Group :: Rede/Outros
RPM: ackerTodo
Main Changelog Spec Patches Sources Download Gear Bugs e FR Repocop
Patch: ackerTodo.patch
Download
Download
--- src/html/admin_list_users.html.orig 2005-03-20 19:03:55 +0300
+++ src/html/admin_list_users.html 2006-09-14 17:05:57 +0400
@@ -46,7 +46,7 @@
<?php
$result = get_users();
-while($myrow = mysql_fetch_array($result)) {
+while($myrow = @mysql_fetch_array($result)) {
$user = $myrow['login'];
$user_name = $myrow['first'] . ' ' . $myrow['last'];
?>
--- src/html/header.html.orig 2005-12-30 19:59:27 +0300
+++ src/html/header.html 2006-09-15 15:56:09 +0400
@@ -43,7 +43,7 @@
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" >
<head>
<title><?php echo $version; ?></title>
- <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
+ <meta http-equiv="Content-Type" content="text/html" />
<link rel="stylesheet" href="themes/<?php echo "$theme/$theme.css" ?>" type="text/css" />
<link rel="icon" href="images/favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="images/favicon.ico" type="image/x-icon" />
--- src/html/list_comments.html.orig 2006-09-01 19:49:47 +0400
+++ src/html/list_comments.html 2006-09-14 17:05:57 +0400
@@ -72,7 +72,7 @@
?>
</tr>
<?php
-while ($myrow = mysql_fetch_array($result)) {
+while ($myrow = @mysql_fetch_array($result)) {
?>
<tr class="<?php echo ((++$i % 2 == 0)?'even':'odd') ?>">
<?php
--- src/html/list_tasks.html.orig 2006-09-01 19:49:47 +0400
+++ src/html/list_tasks.html 2006-09-15 17:10:05 +0400
@@ -254,7 +254,7 @@
}
?>
<?php
-while($myrow = mysql_fetch_array($pub_users)) {
+while($myrow = @mysql_fetch_array($pub_users)) {
if($output['login'] != $myrow['login']) {
?>
<option value="<?php echo $myrow['login'] ?>"<?php echo ($output['task_who'] == $myrow['login'])?' selected="selected"':'' ?>><?php echo ucfirst($myrow['login'])._SEARCH_USERS ?></option>
@@ -283,7 +283,7 @@
}
global $table_prefix;
-while($myrow = mysql_fetch_array($output['result'])) {
+while($myrow = @mysql_fetch_array($output['result'])) {
$deadline = 1;
$deny_group = 0;
$deny_user = 0;
@@ -296,7 +296,7 @@
$i = 0;
$comments = array();
- while($com = mysql_fetch_array($result)) {
+ while($com = @mysql_fetch_array($result)) {
$comments[$i]['date'] = $com['date'];
$comments[$i]['comment'] = $com['comment'];
$comments[$i]['login'] = $com['login'];
--- src/html/reports_groups.html.orig 2006-09-01 19:49:47 +0400
+++ src/html/reports_groups.html 2006-09-14 17:05:57 +0400
@@ -25,7 +25,7 @@
$i = 0;
$result = db_query("SELECT * FROM ".$table_prefix."groups");
-while($myrow = mysql_fetch_array($result)) {
+while($myrow = @mysql_fetch_array($result)) {
$group_id = "group_" . $myrow['id'];
create_report($group_id, $myrow['name']);
$i++;
@@ -43,35 +43,35 @@
$result = db_query("SELECT COUNT(*) FROM ".$table_prefix."tasks "
."WHERE login='$login'");
- $total = mysql_fetch_array($result);
+ $total = @mysql_fetch_array($result);
$result = db_query("SELECT COUNT(*) FROM ".$table_prefix."tasks "
."WHERE login='$login' AND completed='1'");
- $completed = mysql_fetch_array($result);
+ $completed = @mysql_fetch_array($result);
$result = db_query("SELECT COUNT(*) FROM ".$table_prefix."tasks "
."WHERE login='$login' AND completed='0'");
- $open = mysql_fetch_array($result);
+ $open = @mysql_fetch_array($result);
$result = db_query("SELECT COUNT(*) FROM ".$table_prefix."tasks "
."WHERE login='$login' AND priority='3' AND completed='1'");
- $high = mysql_fetch_array($result);
+ $high = @mysql_fetch_array($result);
$result = db_query("SELECT COUNT(*) FROM ".$table_prefix."tasks "
."WHERE login='$login' AND priority='2' AND completed='1'");
- $medium = mysql_fetch_array($result);
+ $medium = @mysql_fetch_array($result);
$result = db_query("SELECT COUNT(*) FROM ".$table_prefix."tasks "
."WHERE login='$login' AND priority='1' AND completed='1'");
- $low = mysql_fetch_array($result);
+ $low = @mysql_fetch_array($result);
$result = db_query("SELECT COUNT(*) FROM ".$table_prefix."tasks "
."WHERE login='$login' AND priority='0' AND completed='1'");
- $undefined = mysql_fetch_array($result);
+ $undefined = @mysql_fetch_array($result);
$result = db_query("SELECT COUNT(*) FROM ".$table_prefix."comments "
."WHERE login='$login'");
- $comments = mysql_fetch_array($result);
+ $comments = @mysql_fetch_array($result);
if($total[0] == 0) return -1;
--- src/includes/users.inc.orig 2006-09-01 19:49:48 +0400
+++ src/includes/users.inc 2006-09-15 17:14:33 +0400
@@ -212,7 +212,7 @@
global $table_prefix;
$result = db_query("SELECT language FROM ".$table_prefix."users WHERE login='$login'");
- $myrow = mysql_fetch_array($result);
+ $myrow = @mysql_fetch_array($result);
$language = $myrow['language'];
echo '<select name="newlanguage" size="1" class="btn">';
@@ -294,7 +294,7 @@
$result = db_query("SELECT login FROM ".$table_prefix."users ORDER by login");
$users_array = array();
- while ($myrow = mysql_fetch_array($result)) {
+ while ($myrow = @mysql_fetch_array($result)) {
$users_array[] = $myrow['login'];
}
@@ -307,7 +307,7 @@
$result = db_query("SELECT login, allow_others FROM ".$table_prefix."users ORDER BY login");
$users_array = array();
- while ($myrow = mysql_fetch_array($result)) {
+ while ($myrow = @mysql_fetch_array($result)) {
$users_array[] = $myrow;
}
@@ -323,10 +323,10 @@
function get_user_array($users) {
global $table_prefix;
- $result = db_query("SELECT * FROM ".$table_prefix."users WHERE login='$users'");
+ $result = db_query("SELECT * FROM ".$table_prefix."`users` WHERE `login`='$users'");
if (mysql_num_rows($result) == 1) {
- return mysql_fetch_array($result);
+ return @mysql_fetch_array($result);
} else {
return;
}
@@ -339,7 +339,7 @@
$result = db_query("SELECT group_id FROM ".$table_prefix."group_membership WHERE login='$login'");
- while ($myrow = mysql_fetch_array($result)) {
+ while ($myrow = @mysql_fetch_array($result)) {
$groups_in_array[] = $myrow['group_id'];
}
@@ -357,7 +357,7 @@
$result = db_query("SELECT extra FROM ".$table_prefix."users WHERE login='$my_login'");
- $myrow = mysql_fetch_array($result);
+ $myrow = @mysql_fetch_array($result);
$extra = $myrow['extra'];
--- src/includes/ajax.php.orig 2006-09-01 19:49:48 +0400
+++ src/includes/ajax.php 2006-09-14 17:05:57 +0400
@@ -152,7 +152,7 @@
$theme = $_SESSION['theme'];
$result = db_query("SELECT * FROM ".$table_prefix."tasks WHERE id='$id'");
- $myrow = mysql_fetch_array($result);
+ $myrow = @mysql_fetch_array($result);
$myrow['date'] = $new_date;
list($status, $image) = get_status($myrow, $date_format);
--- src/includes/categories.inc.orig 2006-09-01 20:15:45 +0400
+++ src/includes/categories.inc 2006-09-15 17:15:18 +0400
@@ -60,14 +60,14 @@
."ORDER BY name");
}
- while ($myrow = mysql_fetch_array($result)) {
+ while ($myrow = @mysql_fetch_array($result)) {
$categories_id_name_aarray[$myrow['id']] = $myrow['name'];
}
if ($include_supercats) {
$result = db_query("SELECT * FROM ".$table_prefix."supercats WHERE login='$login' ORDER BY name");
- while ($myrow = mysql_fetch_array($result)) {
+ while ($myrow = @mysql_fetch_array($result)) {
$categories_id_name_aarray['s_' . $myrow['id']] = $myrow['name'] . ' (' . _SUPERCAT .')';
}
}
@@ -81,7 +81,7 @@
$global_categories = array();
- while ($myrow = mysql_fetch_array($result)) {
+ while ($myrow = @mysql_fetch_array($result)) {
$global_categories[$myrow['id']] = $myrow['name'];
}
@@ -95,7 +95,7 @@
$result = db_query("SELECT id FROM ".$table_prefix."category WHERE login='$login' ORDER by id");
$categories_id_array = array();
- while ($myrow = mysql_fetch_array($result)) {
+ while ($myrow = @mysql_fetch_array($result)) {
$categories_id_array[] = $myrow['id'];
}
@@ -108,7 +108,7 @@
$result = db_query("SELECT category_id FROM ".$table_prefix."supercat_membership WHERE supercat_id = '$supercat_id'");
$categories = array();
- while ($myrow = mysql_fetch_array($result)) {
+ while ($myrow = @mysql_fetch_array($result)) {
$categories[] = $myrow['category_id'];
}
@@ -131,7 +131,7 @@
. " WHERE ".$table_prefix."supercats.id = ".$table_prefix."supercat_membership.supercat_id AND login='$login'"
. " ORDER BY name");
- while ($myrow = mysql_fetch_array($result)) {
+ while ($myrow = @mysql_fetch_array($result)) {
$gid = $myrow['supercat_id'];
$category_id = $myrow['category_id'];
$category_name = $categories[$category_id];
@@ -166,7 +166,7 @@
$result = db_query("SELECT ".$table_prefix."supercats.id as supercat_id, ".$table_prefix."supercats.name as name FROM ".$table_prefix."supercats"
. " WHERE login='$login' ORDER BY name");
- while ($myrow = mysql_fetch_array($result)) {
+ while ($myrow = @mysql_fetch_array($result)) {
$gid = $myrow['supercat_id'];
if (!isset($supercats_and_categories_array[$gid])) {
--- src/includes/cli.inc.orig 2006-09-01 19:49:48 +0400
+++ src/includes/cli.inc 2006-09-15 17:15:52 +0400
@@ -28,7 +28,7 @@
echo "All Users\n";
echo "=========\n\n";
- while($myrow = mysql_fetch_array($result)) {
+ while($myrow = @mysql_fetch_array($result)) {
if($myrow['admin'] == 1) {
$admin = "(Admin)";
} else {
@@ -77,7 +77,7 @@
echo "Currently Open Tasks\n";
echo "====================\n\n";
- while($myrow = mysql_fetch_array($result)) {
+ while($myrow = @mysql_fetch_array($result)) {
$date = format_date_simple($myrow['date']);
echo $i . ".) Title: " . $myrow['title'] . "\n";
echo " Date: " . $date . "\n";
@@ -156,7 +156,7 @@
echo "All Tasks\n";
echo "=========\n\n";
- while($myrow = mysql_fetch_array($result)) {
+ while($myrow = @mysql_fetch_array($result)) {
echo $myrow['id'] . ".) Title: " . $myrow['title'] . "\n";
}
@@ -259,7 +259,7 @@
echo "All Your Categories\n";
echo "===================\n\n";
- while($myrow = mysql_fetch_array($result)) {
+ while($myrow = @mysql_fetch_array($result)) {
echo $i . ".) " . $myrow['name'] . "\n";
$i++;
}
@@ -373,7 +373,7 @@
."WHERE login='$login' "
."AND password='$enc_pass'");
- $myrow = mysql_fetch_array($result);
+ $myrow = @mysql_fetch_array($result);
$isadmin = $myrow['admin'];
if(!$result || mysql_num_rows($result) != 1) {
--- src/includes/db.inc.orig 2006-01-28 17:48:27 +0300
+++ src/includes/db.inc 2006-09-15 17:16:06 +0400
@@ -52,7 +52,7 @@
$result1 = mysql_query($query, $db);
$results = '';
- while ($myrow = mysql_fetch_array($result1, MYSQL_ASSOC)) {
+ while ($myrow = @mysql_fetch_array($result1, MYSQL_ASSOC)) {
$results .= '<br />' . print_r($myrow, true);
}
--- src/includes/funcs.inc.orig 2006-09-01 19:49:48 +0400
+++ src/includes/funcs.inc 2006-09-15 17:16:25 +0400
@@ -554,7 +554,7 @@
$result = db_query("SELECT * FROM ".$table_prefix."modules");
- while($myrow = mysql_fetch_array($result)) {
+ while($myrow = @mysql_fetch_array($result)) {
$modules[$i] = $myrow['name'];
$i++;
}
@@ -570,7 +570,7 @@
$result = db_query("SELECT * FROM ".$table_prefix."modules "
."WHERE enabled='1'");
- while($myrow = mysql_fetch_array($result)) {
+ while($myrow = @mysql_fetch_array($result)) {
$modules[$i] = $myrow['name'];
$i++;
}
@@ -584,7 +584,7 @@
$result = db_query("SELECT * FROM ".$table_prefix."modules "
."WHERE name='$module'");
- $myrow = mysql_fetch_array($result);
+ $myrow = @mysql_fetch_array($result);
return $myrow;
}
@@ -635,7 +635,7 @@
echo '<?xml version="1.0" encoding="utf-8" ?>
<todo>';
- while($myrow = mysql_fetch_array($result)) {
+ while($myrow = @mysql_fetch_array($result)) {
$category = $myrow['category_name'];
$title = $myrow['title'];
$task = $myrow['task'];
--- src/includes/groups.inc.orig 2006-09-01 20:15:45 +0400
+++ src/includes/groups.inc 2006-09-15 17:16:59 +0400
@@ -41,7 +41,7 @@
$result = db_query("SELECT id, name FROM ".$table_prefix."groups ORDER BY name");
}
- while($myrow = mysql_fetch_array($result)) {
+ while($myrow = @mysql_fetch_array($result)) {
if($first == 1) {
$first_id = $myrow['id'];
$first = 0;
@@ -99,7 +99,7 @@
. " WHERE ".$table_prefix."groups.id = ".$table_prefix."group_membership.group_id"
. " ORDER BY name");
- while ($myrow = mysql_fetch_array($result)) {
+ while ($myrow = @mysql_fetch_array($result)) {
$gid = $myrow['group_id'];
$login = $myrow['login'];
@@ -131,7 +131,7 @@
$result = db_query("SELECT ".$table_prefix."groups.id as group_id, ".$table_prefix."groups.name as name FROM ".$table_prefix."groups"
. ' ORDER BY name');
- while ($myrow = mysql_fetch_array($result)) {
+ while ($myrow = @mysql_fetch_array($result)) {
$gid = $myrow['group_id'];
if (!isset($groups_and_users_array[$gid])) {
@@ -163,7 +163,7 @@
$result = db_query("SELECT login FROM ".$table_prefix."group_membership WHERE group_id='$group_id'");
- while ($myrow = mysql_fetch_array($result)) {
+ while ($myrow = @mysql_fetch_array($result)) {
$group_members_array[] = $myrow['login'];
}
@@ -177,7 +177,7 @@
$result = db_query("SELECT name FROM ".$table_prefix."groups WHERE id='$group_id'");
if (mysql_num_rows($result) == 1) {
- $myrow = mysql_fetch_array($result);
+ $myrow = @mysql_fetch_array($result);
return $myrow['name'];
} else {
return;
--- src/includes/session.inc.orig 2006-09-01 19:49:48 +0400
+++ src/includes/session.inc 2006-09-15 17:17:13 +0400
@@ -54,7 +54,7 @@
session_start();
- $myrow = mysql_fetch_array($result);
+ $myrow = @mysql_fetch_array($result);
$_SESSION['login'] = $myrow['login'];
$_SESSION['isadmin'] = $myrow['admin'];
--- src/includes/tasks.inc.orig 2006-09-01 20:15:45 +0400
+++ src/includes/tasks.inc 2006-09-15 17:17:37 +0400
@@ -28,7 +28,7 @@
function send_email($login, $task_array) {
global $_PRIORITY, $version, $table_prefix;
- while($myrow = mysql_fetch_array($login)) {
+ while($myrow = @mysql_fetch_array($login)) {
if($myrow['email_notification'] == 1) {
$email = $myrow['email'];
$date_format = $myrow['date_format'];
@@ -61,7 +61,7 @@
} else {
$result = db_query("SELECT * FROM ".$table_prefix."category "
."WHERE id='" . $category . "'");
- while($catrow = mysql_fetch_array($result)) {
+ while($catrow = @mysql_fetch_array($result)) {
$category = $catrow['name'];
}
}
@@ -119,7 +119,7 @@
."AND date <= '$enddate' AND login IN ($login_and_groups)");
$date_array = array();
- while($myrow = mysql_fetch_array($result)) {
+ while($myrow = @mysql_fetch_array($result)) {
$temp_date = substr($myrow['date'], 0, 8);
$date_array[] = $temp_date;
}
@@ -195,7 +195,7 @@
if (empty($cache_comments)) {
$result = db_query("SELECT task_id, COUNT(*) as num FROM ".$table_prefix."comments, ".$table_prefix."tasks, ".$table_prefix."category WHERE ${output['where']} AND task_id = tasks.id GROUP BY task_id");
- while($myrow = mysql_fetch_array($result)) {
+ while($myrow = @mysql_fetch_array($result)) {
$cache_comments[$myrow['task_id']] = $myrow['num'];
}
}
@@ -488,7 +488,7 @@
// That'll stop some sql injections
// This breaks ths task list for some reason...
- // Warning: mysql_fetch_array(): supplied argument is not a valid
+ // Warning: @mysql_fetch_array(): supplied argument is not a valid
// MySQL result resource in /var/www/todo/html/list_tasks.html on
// line 257
// $query with this line...
--- src/modules/aim/im.php.orig 2005-05-08 18:59:20 +0400
+++ src/modules/aim/im.php 2006-09-14 17:05:57 +0400
@@ -55,7 +55,7 @@
."OR (recurrence='1' AND completed='0') "
."ORDER BY login");
- while($tasks_myrow = mysql_fetch_array($tasks_result)) {
+ while($tasks_myrow = @mysql_fetch_array($tasks_result)) {
$task = $tasks_myrow["task"];
$title = $tasks_myrow["title"];
$login = $tasks_myrow["login"];
@@ -66,7 +66,7 @@
$im_result = db_query("SELECT * FROM users "
."WHERE login='$login'");
- $im_myrow = mysql_fetch_array($im_result);
+ $im_myrow = @mysql_fetch_array($im_result);
$im = $im_myrow["im_notification"];
$screenname = $im_myrow["screenname"];
--- src/modules/email/email.php.orig 2005-09-06 05:38:52 +0400
+++ src/modules/email/email.php 2006-09-14 17:05:57 +0400
@@ -39,12 +39,12 @@
."WHERE date='$date' "
."AND tasks.category = category.id");
- while($user_myrow = mysql_fetch_array($user_result)) {
+ while($user_myrow = @mysql_fetch_array($user_result)) {
if($user_myrow['completed'] == 0) {
$login = $user_myrow['login'];
$email_result = mysql_query("SELECT * FROM users "
."WHERE login='$login'");
- $email_myrow = mysql_fetch_array($email_result);
+ $email_myrow = @mysql_fetch_array($email_result);
$email = $email_myrow['email'];
$date_format = $email_myrow['date_format'];
--- src/index.php.orig 2006-09-01 19:49:47 +0400
+++ src/index.php 2006-09-15 17:18:15 +0400
@@ -136,7 +136,7 @@
."AND compdate < CURDATE()");
$ids = array();
- while($myrow = mysql_fetch_array($result)) {
+ while($myrow = @mysql_fetch_array($result)) {
$ids[] = $myrow['id'];
}
@@ -156,7 +156,7 @@
."AND compdate != CURDATE()");
$ids = array();
- while($myrow = mysql_fetch_array($result)) {
+ while($myrow = @mysql_fetch_array($result)) {
if($cur_dow != substr($myrow['date'], 6, 2)) {
$ids[] = $myrow['id'];
}
@@ -176,7 +176,7 @@
."AND completed='1'");
$ids = array();
- while($myrow = mysql_fetch_array($result)) {
+ while($myrow = @mysql_fetch_array($result)) {
$temp_day = substr($myrow['date'], 6, 2);
if($temp_day == $this_day) {
@@ -199,7 +199,7 @@
."AND completed='1'");
$ids = array();
- while($myrow = mysql_fetch_array($result)) {
+ while($myrow = @mysql_fetch_array($result)) {
$temp_day = substr($myrow['date'], 6, 2);
if($temp_day == $this_day) {
@@ -283,7 +283,6 @@
show_default_view();
}
-
} elseif($cmd == 'do_add_task') {
if($_REQUEST['recurrence'] == 2) {
@@ -496,7 +495,7 @@
} else {
$result = db_query("SELECT * FROM ".$table_prefix."groups WHERE name='$add_user'");
- if(($myrow = mysql_fetch_array($result)) == 0) {
+ if(($myrow = @mysql_fetch_array($result)) == 0) {
$add_user = strip_tags($_REQUEST['add_user']);
$result = db_query("INSERT INTO ".$table_prefix."users (login) "
."VALUES ('$add_user')");
@@ -526,7 +525,7 @@
$result = db_query("SELECT * FROM ".$table_prefix."users WHERE login='$add_group'");
- if(($myrow = mysql_fetch_array($result)) == 0) {
+ if(($myrow = @mysql_fetch_array($result)) == 0) {
$result = db_query("INSERT INTO ".$table_prefix."groups (name) "
."VALUES ('$add_group')");
$output['message'] = _GROUP_ADDED;
@@ -613,7 +612,7 @@
$result = db_query("SELECT * FROM ".$table_prefix."supercats WHERE name='$add_supercat' AND login='$login'");
- if(($myrow = mysql_fetch_array($result)) == 0) {
+ if(($myrow = @mysql_fetch_array($result)) == 0) {
$result = db_query("INSERT INTO ".$table_prefix."supercats (name, login) "
."VALUES ('$add_supercat', '$login')");
$output['message'] = _GROUP_SUPERCAT;