Файл: public_html/rating.php
Строк: 21
<?php
include ('./dev/db.php');
include ('./dev/functions.php');
include ('./dev/user.php');
$title = 'Рейтинг';
include ('./dev/head.php');
if(!$user) {
header('location: /index.php');
exit;
}
$max = 10;
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `users`"),0);
$k_page = k_page($k_post,$max);
$page = page($k_page);
$start = $max*$page-$max;
$sql = mysql_query("SELECT * FROM `users` ORDER BY `strength` + `armor` + `max_health` DESC LIMIT $start, $max");
while($r = mysql_fetch_assoc($sql))
{
$rating = $r['strength'] + $r['armor'] + $r['health'];
echo '<a href="/user.php?id='.$r['id'].'" class="link"><img src="/img/race/sex/'.$r['race'].'.jpg"> '.$r['login'].' <span style="float: right"><small>'.$rating.'</small> <img src="/img/rating.png"></span></a>';
}
if($k_post<1) {
echo '<div class="block center">Игроков нет!</div>';
}
if($k_page>1) echo str('?',$k_page,$page);
require_once './dev/foot.php';
?>