Файл: public_html/clan/rating.php
Строк: 32
<?
include '../system/common.php';
include '../system/functions.php';
include '../system/user.php';
$title = 'Рейтинг золота';
include '../system/h.php';
?><hr><center>
<font color='orange'>Рейтинг золота</font></center><hr>
<div class="razdel">
<?
$q = mysql_query("SELECT * FROM `clan_memb` WHERE `clan` = '".$clan[id]."' ORDER BY `g` DESC LIMIT 50");
while($row= mysql_fetch_assoc($q)){
$usere = mysql_query("SELECT * FROM `users` WHERE `id` = '".$row[user]."' ORDER BY `g` DESC LIMIT 50");
while($us= mysql_fetch_assoc($usere)){
echo "<a href='/user/$us[id]'><img src='/images/icon/race/$user[r].png'> $us[login]</a> <font color='lime'>$row[g] золота</font><hr>";
}
}
echo "</div>";
?>
<?
echo "<center>Рейтинг серебра</center>";
$q = mysql_query("SELECT * FROM `clan_memb` WHERE `clan` = '".$clan[id]."' ORDER BY `s` DESC LIMIT 50");
while($row= mysql_fetch_assoc($q)){
$usere = mysql_query("SELECT * FROM `users` WHERE `id` = '".$row[user]."' ORDER BY `s` DESC LIMIT 50");
while($us= mysql_fetch_assoc($usere)){
echo "<a href='/user/$us[id]'><img src='/images/icon/race/$user[r].png'> $us[login]</a> <font color='lime'>$row[s] серебра</font><hr>";
}
}
echo "</div>";
include '../system/f.php';
?>