<?

/*

// +--------------------------------------------------------------------------+

// | Project: TBDevYSE - TBDev Yuna Scatari Edition |

// +--------------------------------------------------------------------------+

// | This file is part of TBDevYSE. TBDevYSE is based on TBDev, |

// | originally by RedBeard of TorrentBits, extensively modified by |

// | Gartenzwerg. |

// | |

// | TBDevYSE is free software; you can redistribute it and/or modify |

// | it under the terms of the GNU General Public License as published by |

// | the Free Software Foundation; either version 2 of the License, or |

// | (at your option) any later version. |

// | |

// | TBDevYSE is distributed in the hope that it will be useful, |

// | but WITHOUT ANY WARRANTY; without even the implied warranty of |

// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |

// | GNU General Public License for more details. |

// | |

// | You should have received a copy of the GNU General Public License |

// | along with TBDevYSE; if not, write to the Free Software Foundation, |

// | Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA |

// +--------------------------------------------------------------------------+

// | Do not remove above lines! |

// +--------------------------------------------------------------------------+

*/

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='confirmed'";

if ($search)

$q = "search=" . htmlspecialchars_uni($search);

} else {

$letter = trim($_GET["letter"]);

if (strlen($letter) > 1)

die;

/* if ($letter != "" && strpos("abcdefghijklmnopqrstuvwxyz", $letter) === false)

$letter = "a";

$query = ( $letter != "" ? "username LIKE '$letter%' AND " : "") . "status='confirmed'";

if ($letter == "")

$letter = "a";

$q = "letter=$letter";*/

if ($letter != "" && strpos("abcdefghijklmnopqrstuvwxyz" . "àáâãäå¸æçèéêëìíîïðñòóôõö÷øùúûüýþÿ", $letter) === false)

$letter = "";

$query = ( $letter != "" ? "username LIKE '$letter%' AND " : "") . "status='confirmed'";

if ($letter != "")

$q = "letter=$letter";

}

if (is_valid_user_class($class)) {

$query .= " AND class = $class";

$q .= ($q ? "&amp;" : "") . "class=$class";

}

stdhead("Ïîëüçîâàòåëè");

print("<h1>Ïîëüçîâàòåëè</h1>\n");

print("<form method=\"get\" action=\"users.php\">\n");

print("Ïîèñê: <input type=\"text\" size=\"30\" name=\"search\" value=\"".htmlspecialchars_uni($search)."\">\n");

print("<select name=\"class\">\n");

print("<option value=\"-\">(Âñå óðîâíè)</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=\"Âïåðåä\">\n");

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

print("<p>\n");

for ($i = 97; $i < 123; ++$i)

{

$l = chr($i);

$L = chr($i - 32);

if ($l == $letter)

print("<b>$L</b>\n");

else

print("<a href=\"users.php?letter=$l\"><b>$L</b></a>\n");

}

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

print("<p>\n");

$russian_letters = "àáâãäå¸æçèéêëìíîïðñòóôõö÷øùúûüýþÿ"; // Äà, ß äîãàäûâàþñü ÷òî ñëîâà íå ìîãóò íà÷èíàòñÿ ñ üúû, íî Þçåðíåéìû ìîãóò!

$russian_upperscase_letters = "ÀÁÂÃÄŨÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞß";

foreach (str_split($russian_letters) as $key => $l)

{

$L = $russian_upperscase_letters[$key];

if ($l == $letter)

print("<b>$L</b>\n");

else

print("<a href=\"users.php?letter=$l\"><b>$L</b></a>\n");

}

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

$q .= ($q ? "&amp;" : "");

$page = $_GET['page'];

$perpage = 100;

$res = sql_query("SELECT COUNT(*) FROM 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 .= "<b>$i</b>\n";

else

$pagemenu .= "<a href=\"users.php?{$q}page=$i\"><b>$i</b></a>\n";

if ($page == 1)

$browsemenu .= "<b>&lt;&lt; Ïðåä</b>";

else

$browsemenu .= "<a href=\"users.php?{$q}page=" . ($page - 1) . "\"><b>&lt;&lt; Ïðåä</b></a>";

$browsemenu .= "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";

if ($page == $pages || (($page * $perpage) > $arr[0]))

$browsemenu .= "<b>Ñëåä &gt;&gt;</b>";

else

$browsemenu .= "<a href=\"users.php?{$q}page=" . ($page + 1) . "\"><b>Ñëåä &gt;&gt;</b></a>";

print("<p>$browsemenu<br />$pagemenu</p>");

$offset = ($page * $perpage) - $perpage;

$res = sql_query("SELECT u.*, c.name, c.flagpic FROM users AS u LEFT JOIN countries AS c ON c.id = u.country WHERE $query ORDER BY username LIMIT $offset,$perpage") or sqlerr(__FILE__, __LINE__);

$num = mysql_num_rows($res);

print("<table border=\"1\" cellspacing=\"0\" cellpadding=\"5\">\n");

print("<tr><td class=\"colhead\" align=\"left\">Èìÿ</td><td class=\"colhead\">Çàðåãåñòðèðîâàí</td><td class=\"colhead\">Ïîñëåäíèé âõîä</td><td class=\"colhead\">Ðåéòèíã</td><td class=\"colhead\">Ïîë</td><td class=\"colhead\" align=\"left\">Óðîâåíü</td><td class=\"colhead\">Ñòðàíà</td></tr>\n");

for ($i = 0; $i < $num; ++$i)

{

$arr = mysql_fetch_assoc($res);

if ($arr['country'] > 0) {

$country = "<td style=\"padding: 0px\" align=\"center\"><img src=\"pic/flag/$arr[flagpic]\" alt=\"$arr[name]\" title=\"$arr[name]\"></td>";

}

else

$country = "<td align=\"center\">---</td>";

if ($arr['added'] == '0000-00-00 00:00:00')

$arr['added'] = '-';

if ($arr['last_access'] == '0000-00-00 00:00:00')

$arr['last_access'] = '-';

if ($arr["downloaded"] > 0) {

$ratio = number_format($arr["uploaded"] / $arr["downloaded"], 2);

if (($arr["uploaded"] / $arr["downloaded"]) > 100)

$ratio = "100+";

$ratio = "<font color=\"" . get_ratio_color($ratio) . "\">$ratio</font>";

}

else

if ($arr["uploaded"] > 0)

$ratio = "Inf.";

else

$ratio = "------";

if ($arr["gender"] == "1") $gender = "<img src=\"".$pic_base_url."/male.gif\" alt=\"Ïàðåíü\" style=\"margin-left: 4pt\">";

elseif ($arr["gender"] == "2") $gender = "<img src=\"".$pic_base_url."/female.gif\" alt=\"Äåâóøêà\" style=\"margin-left: 4pt\">";

print("<tr><td align=\"left\"><a href=\"userdetails.php?id=$arr[id]\"><b>".get_user_class_color($arr["class"], $arr["username"])."</b></a>" .($arr["donated"] > 0 ? "<img src=\"pic/star.gif\" border=\"0\" alt=\"Donor\">" : "")."</td>" .

"<td>$arr[added]</td><td>$arr[last_access]</td><td>$ratio</td><td>$gender</td>".

"<td align=\"left\">" . get_user_class_name($arr["class"]) . "</td>$country</tr>\n");

}

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

print("<p>$pagemenu<br />$browsemenu</p>");

stdfoot();

die;

?>