View Single Post
  #8  
Old 2nd March 2008, 13:02
BoLaMN BoLaMN is offline
Senior Member
 
Join Date: Jan 2008
Australia
Posts: 93
Default Re: Yuna Scatari v2.0 PRE7 RC0
********************************
Bug Report by Hatchet todo with users.php

when u click "Next.." you recieve a sql error
***********************

fixed by updating sql query

[code]<?

require "include/bittorrent.php";

dbconn();

loggedinorreturn();

$search = trim($_GET['search']);
$class = $_GET['class'];
if ($class == '-' || !is_valid_user_class($class))
$class = '';

if ($search != '' || $class) {
$query = "username LIKE '%" . sqlwildcardesc("$search") . "%' AND status = 1";
if ($search)
$q = "search=" . htmlspecialchars($search);
} else {
$letter = trim($_GET["letter"]);
if (strlen($letter) > 1)
die;

if ($letter != "" && strpos("abcdefghijklmnopqrstuvwxyz", $letter) === false)
$letter = "a";
if ($letter == "")
$letter = "a";
$query = ( $letter != "" ? "username LIKE '$letter%' AND " : "") . "status = 1";
$q = "letter=$letter";
}

if (is_valid_user_class($class)) {
$query .= " AND class = $class";
$q .= ($q ? "&" : "") . "class=$class";
}

stdhead("Users");

print("<h1>Users</h1>\n");

print("<form method=\"get\" action=\"users.php\">\n");
print("Search: <input type=\"text\" size=\"30\" name=\"search\" value=\"".htmlspecialchars($search)."\">\n");
print("<select name=\"class\">\n");
print("<option value=\"-\">(All Classes)</option>\n");
for ($i = 0;;++$i) {
if ($c = get_user_class_name($i))
print("<option value=\"$i\"" . (is_valid_user_class($class) && $class == $i ? " selected" : "") . ">$c</option>\n");
else
break;
}
print("</select>\n");
print("<input type=\"submit\" value=\"Search\">\n");
print("</form>\n");

print("

\n");

for ($i = 97; $i < 123; ++$i)
{
$l = chr($i);
$L = chr($i - 32);
if ($l == $letter)
print("$L\n");
else
print("<a href=\"users.php?letter=$l\">$L</a>\n");
}

print("</p>\n");

$page = $_GET['page'];
$perpage = 100;

$res = sql_query("SELECT COUNT(*) FROM ".TABLE_USERS." WHERE $query") or sqlerr(__FILE__, __LINE__);
$arr = mysql_fetch_row($res);
$pages = floor($arr[0] / $perpage);
if ($pages * $perpage < $arr[0])
++$pages;

if ($page < 1)
$page = 1;
else
if ($page > $pages)
$page = $pages;

for ($i = 1; $i <= $pages; ++$i)
if ($i == $page)
$pagemenu .= "$i\n";
else
$pagemenu .= "<a href=\"users.php?$q&page=$i\">$i</a>\n";

if ($page == 1)
$browsemenu .= "<< Previous";
else
$browsemenu .= "<a href=\"users.php?$q&page=" . ($page - 1) . "\"><< Previous</a>";

$browsemenu .= "