Файл: vkolhoze.com/inc/rating.php
Строк: 57
<?
$set['p_str']=20;
echo "<div class='event'><h1>Фермеры</h1></div>";
echo "<div class='content'>";
echo "<div class='block'>";
if(isset($_GET['teh']))
{
$sort='tehnika';
$sort2='/teh';
}
elseif(isset($_GET['dost']))
{
$sort='dostig';
$sort2='/dost';
}
///////////////рейтинг популярности//////////////////
///////////////////////////////////////////////////////////
elseif(isset($_GET['arena_rate']))
{
$sort='arena_rating';
$sort2='/arena_rate';
}
else
{
$sort='level';
$sort2=NULL;
}
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_user`"),0);
if ($k_post==0)
{
echo "Список пуст...";
}
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
$num=($page-1)*$set['p_str'];
$q=mysql_query("SELECT * FROM `kolhoz_user` ORDER BY $sort DESC, rating DESC LIMIT $start, $set[p_str]");
if($sort=='level'){
$m=(mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_user` WHERE `rating` > '".$ku['rating']."' "),0))+1;
}else{
$m=(mysql_result(mysql_query("SELECT COUNT(*) FROM `kolhoz_user` WHERE `rating` > '".$ku[$sort]."' "),0))+1;
}
echo "<ul><span class='title'>Вы находитесь на ".$m." месте</span><li class='ptm'></li>";
while($post=mysql_fetch_array($q))
{
$num++;
echo "<li><span class='minor'><span>$num.</span></span> <span>";
echo "".on_k($post['id'])."";
echo " <a class='' href='/user/$post[id]'>".nc($post['id'])."</a></span><span class='title'> $post[$sort]</span></li>";
}
echo "</ul><li class='pt'></li>";
if ($k_page>1)new_str("rating$sort2/",$k_page,$page); // Вывод страниц
echo "<h3>Рейтинг по:</h3>";
echo "<ul>";
echo "<li><img width='16' height='16' src='images/icons/rating.png' alt='o'> ".(isset($_GET['dost']) || isset($_GET['arena_rate']) || isset($_GET['teh'])?"<a href='/rating'>Опыту</a>":"Опыту")."</li>";
echo "<li><img width='16' height='16' src='images/icons/rating.png' alt='o'> ".(!isset($_GET['dost'])?"<a href='/rating/dost'>Достижениям</a>":"Достижениям")."</li>";
echo "<li><img width='16' height='16' src='images/icons/rating.png' alt='o'> ".(!isset($_GET['arena_rate'])?"<a href='/rating/arena_rate'>Арене</a>":"Арене")."</li>";
echo "<li><img width='16' height='16' src='images/icons/rating.png' alt='o'> ".(!isset($_GET['teh'])?"<a href='/rating/teh'>Механизации</a>":"Механизации")."</li>";
echo "<li><img width='16' height='16' src='images/icons/rating.png' alt='o'> ".(!isset($_GET['popul'])?"<a href='/rating/popul'>Популярности</a>":"Популярности")."</li>";
echo "</ul>";
echo "</div>";
include_once 'inc/foot.php';
?>