Файл: coliseum_rating.php
Строк: 52
<?
require_once ('system/func.php');
auth(); // Только для аторизованных
$title = 'Рейтинг колизея';
require_once ('system/header.php');
$set['p_str'] = 10;
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `coliseum_rating` > '0'"),0);
$k_page = k_page($k_post,$set['p_str']);
$page = page($k_page);
$start = $set['p_str']*$page-$set['p_str'];
if($page == 1){
$n_1 = mysql_query("SELECT * FROM `users` ORDER BY `coliseum_rating` DESC, `online` DESC LIMIT 1");
$n_1 = mysql_fetch_assoc($n_1);
echo "<div class='block center'>".ico('icons','dost.png')." <font color='yellow'><b>Самый активный воин</b></font><div class='mb10'></div>";
echo "".icons_user($n_1['id'])." <a>$n_1[login]</a> ".ico('icons','level.png')." $n_1[level] уровень<div class='mb10'></div>";
echo "<img src='/manekenImage_".$n_1['id'].".png'
width='160px'>";
echo "<div class='mb10'></div></div>";
}
$q = mysql_query("SELECT * FROM `users` WHERE `coliseum_rating` > '0' ORDER BY `coliseum_rating` DESC, `online` DESC LIMIT $start, $set[p_str]");
echo "<div class='block'>";
echo "<table width='100%'>";
while($post = mysql_fetch_assoc($q)) {
echo '<tr>';
echo "<td class='center' width='15%'>";
$i++;
echo ($i+$start);
echo '</td>';
echo "<td class='center' width='70%'>";
if($myID == $post[id])echo "<div style='background-color: darkred;'>";
else echo "<div>";
echo icons_user($post[id])." <a href='/profile/$post[id]'>$post[login]</a>, ".ico('icons','level.png')." $post[level] ур.";
echo '</div>';
echo '</td>';
echo "<td class='center' width='15%'>";
echo ico('icons','sum_stat.png')." ".($post['coliseum_rating']);
echo '</td>';
echo '</tr>';
}
echo '</table>';
echo "</div>";
echo "<div class='block center'>";
str('?',$k_page,$page); // Вывод страниц
echo '</div>';
$q = mysql_query("SELECT * FROM `users` WHERE `coliseum_rating` > '0' ORDER BY `coliseum_rating` DESC, `online` DESC");
while($post = mysql_fetch_assoc($q)){
$a++;
if($post[id] == $myID){
echo "<div class='block center'><span class='info small'>Вы находитесь на <b>$a</b> месте в рейтинге!</span></div>";
}
}
require_once ('system/footer.php');