Файл: pages/reitinggarem.php
Строк: 203
<?
include_once '../sys/inc/start.php';
include_once '../sys/inc/compress.php';
include_once '../sys/inc/sess.php';
include_once '../sys/inc/home.php';
include_once '../sys/inc/settings.php';
include_once '../sys/inc/db_connect.php';
include_once '../sys/inc/ipua.php';
include_once '../sys/inc/fnc.php';
include_once '../sys/inc/user.php';
$set['title']='Рейтинг гаремов'; // заголовок страницы
include_once '../sys/inc/thead.php';
title();
################################################################################
$vse=mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `steal_garem` > '0'"),0);
$m=mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `pol` = '1' AND `steal_garem` > '0'"),0);
$j=mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `pol` = '0' AND `steal_garem` > '0'"),0);
echo "<div class='foot'>
Сортировать по: <br />
<form> <select name='menu' onchange='top.location.href = this.options[this.selectedIndex].value;'>
<option selected>-Выбрать-
<option value='?'>Все ($vse)</option>
<option value='?a=m'>Парни ($m)</option>
<option value='?a=j'>Девушки ($j)</option>
</select></option></form>
</div>";
################################################################################
if (isset($_GET['a'])) {$a = esc($_GET['a']);} else {$a='i';}
switch ($a):
case "i":
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `steal_garem` > '0'"),0);
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
echo "<table class='post'>n";
if ($k_post==0)
{
echo " <tr>n";
echo " <td class='p_t'>n";
echo "Нет результатовn";
echo " </td>n";
echo " </tr>n";
}
$q=mysql_query("SELECT `id` FROM `user` WHERE `steal_garem` > '0' ORDER BY `steal_garem` DESC LIMIT $start, $set[p_str]");
while ($ank = mysql_fetch_assoc($q))
{
$ank=get_user($ank['id']);
echo " <tr>n";
if ($set['set_show_icon']==2){
echo " <td class='icon48' rowspan='2'>n";
avatar2($ank['id']);
echo " </td>n";
}
elseif ($set['set_show_icon']==1)
{
echo " <td class='icon14'>n";
echo "".status($ank['id'])."";
echo " </td>n";
}
echo " <td class='p_t'>n";
echo "<a href='/id$ank[id]'><span style='color:$ank[ncolor]'>$ank[nick]</span></a>n";
echo "".medal($ank['id'])." ".online($ank['id'])."";
echo " ".city($ank['id'])."<br />n";
echo " </td>n";
echo " </tr>n";
echo " <tr>n";
if ($set['set_show_icon']==1)echo " <td class='p_m' colspan='2'>n"; else echo " <td class='p_m'>n";
$pol = ($ank['pol']==1) ? '' : 'а';
echo 'Украден'.$pol.': '.$ank['steal_garem'].' раз.<br />';
echo " </td>n";
echo " </tr>n";
}
echo "</table>n";
if ($k_page>1)str("?",$k_page,$page); // Вывод страниц
break;
################################################################################
case "m":
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `pol` = '1' AND `steal_garem` > '0'"),0);
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
echo "<table class='post'>n";
if ($k_post==0)
{
echo " <tr>n";
echo " <td class='p_t'>n";
echo "Нет результатовn";
echo " </td>n";
echo " </tr>n";
}
$q=mysql_query("SELECT `id` FROM `user` WHERE `pol` = '1' AND `steal_garem` > '0' ORDER BY `steal_garem` DESC LIMIT $start, $set[p_str]");
while ($ank=mysql_fetch_assoc($q))
{
$ank=get_user($ank['id']);
echo " <tr>n";
if ($set['set_show_icon']==2){
echo " <td class='icon48' rowspan='2'>n";
avatar2($ank['id']);
echo " </td>n";
}
elseif ($set['set_show_icon']==1)
{
echo " <td class='icon14'>n";
echo "".status($ank['id'])."";
echo " </td>n";
}
echo " <td class='p_t'>n";
echo "<a href='/id$ank[id]'><span style='color:$ank[ncolor]'>$ank[nick]</span></a>n";
echo "".medal($ank['id'])."n".online($ank['id'])."n";
echo "".city($ank['id'])."<br />n";
echo " </td>n";
echo " </tr>n";
echo " <tr>n";
if ($set['set_show_icon']==1)echo " <td class='p_m' colspan='2'>n"; else echo " <td class='p_m'>n";
$pol = ($ank['pol']==1) ? '' : 'а';
echo 'Украден'.$pol.': '.$ank['steal_garem'].' раз.<br />';
echo " </td>n";
echo " </tr>n";
}
echo "</table>n";
if ($k_page>1)str("?a=m&",$k_page,$page); // Вывод страниц
break;
################################################################################
case "j":
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `pol` = '0' AND `steal_garem` > '0'"),0);
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
echo "<table class='post'>n";
if ($k_post==0)
{
echo " <tr>n";
echo " <td class='p_t'>n";
echo "Нет результатовn";
echo " </td>n";
echo " </tr>n";
}
$q=mysql_query("SELECT `id` FROM `user` WHERE `pol` = '0' AND `steal_garem` > '0' ORDER BY `steal_garem` DESC LIMIT $start, $set[p_str]");
while ($ank=mysql_fetch_assoc($q))
{
$ank=get_user($ank['id']);
echo " <tr>n";
if ($set['set_show_icon']==2){
echo " <td class='icon48' rowspan='2'>n";
avatar2($ank['id']);
echo " </td>n";
}
elseif ($set['set_show_icon']==1)
{
echo " <td class='icon14'>n";
echo "".status($ank['id'])."";
echo " </td>n";
}
echo " <td class='p_t'>n";
echo "<a href='/id$ank[id]'><span style='color:$ank[ncolor]'>$ank[nick]</span></a>n";
echo "".medal($ank['id'])."n".online($ank['id'])."n";
echo "".city($ank['id'])."<br />n";
echo " </td>n";
echo " </tr>n";
echo " <tr>n";
if ($set['set_show_icon']==1)echo " <td class='p_m' colspan='2'>n"; else echo " <td class='p_m'>n";
$pol = ($ank['pol']==1) ? '' : 'а';
echo 'Украден'.$pol.': '.$ank['steal_garem'].' раз.<br />';
echo " </td>n";
echo " </tr>n";
}
echo "</table>n";
if ($k_page>1)str("?a=j&",$k_page,$page); // Вывод страниц
break;
default:
header("location: ?a=i");
endswitch;
include_once '../sys/inc/tfoot.php';
?>