Файл: rating.php
Строк: 153
<?
include './system/common.php';
include './system/functions.php';
include './system/user.php';
if(!$user) {
header('location: /');
exit;
}
$title = 'Рейтинг игроков';
include './system/h.php';
?>
<div class='title'><div class="ribbon mb2"><div class="rl"><div class="rr"><?=$title?></div></div></div>
</div>
<div class='line'></div>
<div class='menu'>
<?
$sort = _string($_GET['sort']);
$max = 10;
$count = mysql_result(mysql_query('SELECT COUNT(*) FROM `users`'),0);
$pages = ceil($count/$max);
$page = _string(_num($_GET['page']));
if($page > $pages) {
$page = $pages;
}
if($page < 1) {
$page = 1;
}
$start = $page * $max - $max;
if($page == 1) {
$i = $page - 1;
}
elseif($page == 2) {
$i = ($page + 9);
}
else
{
$i = ($page * 10) - 9;
}
switch($sort) {
default:
$q = mysql_query('SELECT * FROM `users` ORDER BY `str`+`vit`+`agi`+`def` DESC LIMIT '.$start.', '.$max.'');
break;
case 'duel':
$q = mysql_query('SELECT * FROM `users` ORDER BY `duel_rating` DESC LIMIT '.$start.', '.$max.'');
break;
case 'coliseum':
$q = mysql_query('SELECT * FROM `users` ORDER BY `coliseum_rating` DESC LIMIT '.$start.', '.$max.'');
break;
}
while($row = mysql_fetch_array($q)) {
$i++;
if($i == 1) {
$w_1 = mysql_query('SELECT * FROM `inv` WHERE `user` = "'.$row['id'].'" AND `id` = "'.$row['w_1'].'"');
$w_1 = mysql_fetch_array($w_1);
if(!$w_1) {
$w_1['item'] = 0;
}
$w_2 = mysql_query('SELECT * FROM `inv` WHERE `user` = "'.$row['id'].'" AND `id` = "'.$row['w_2'].'"');
$w_2 = mysql_fetch_array($w_2);
if(!$w_2) {
$w_2['item'] = 0;
}
$w_3 = mysql_query('SELECT * FROM `inv` WHERE `user` = "'.$row['id'].'" AND `id` = "'.$row['w_3'].'"');
$w_3 = mysql_fetch_array($w_3);
if(!$w_3) {
$w_3['item'] = 0;
}
$w_4 = mysql_query('SELECT * FROM `inv` WHERE `user` = "'.$row['id'].'" AND `id` = "'.$row['w_4'].'"');
$w_4 = mysql_fetch_array($w_4);
if(!$w_4) {
$w_4['item'] = 0;
}
$w_5 = mysql_query('SELECT * FROM `inv` WHERE `user` = "'.$row['id'].'" AND `id` = "'.$row['w_5'].'"');
$w_5 = mysql_fetch_array($w_5);
if(!$w_5) {
$w_5['item'] = 0;
}
$w_6 = mysql_query('SELECT * FROM `inv` WHERE `user` = "'.$row['id'].'" AND `id` = "'.$row['w_6'].'"');
$w_6 = mysql_fetch_array($w_6);
if(!$w_6) {
$w_6['item'] = 0;
}
$w_7 = mysql_query('SELECT * FROM `inv` WHERE `user` = "'.$row['id'].'" AND `id` = "'.$row['w_7'].'"');
$w_7 = mysql_fetch_array($w_7);
if(!$w_7) {
$w_7['item'] = 0;
}
$w_8 = mysql_query('SELECT * FROM `inv` WHERE `user` = "'.$row['id'].'" AND `id` = "'.$row['w_8'].'"');
$w_8 = mysql_fetch_array($w_8);
if(!$w_8) {
$w_8['item'] = 0;
}
switch($sort) {
default:
?>
<div class="bdr bg_main mb2"><div class="light"><div class="wr1"><div class="wr2"><div class="wr3"><div class="wr4"><div class="wr5"><div class="wr6"><div class="wr7"><div class="wr8">
<div class="cntr mt10">
<table>
<tr>
<td><a class="nd" href="/view_profile?player_id=811208"><img src="http://144.76.125.123/maneken/h_66_123_76_165_126_79_129_80_3491466481_avatar0.png?1.3.52" /></a></td>
<td><a class="nd" href="/view_profile?player_id=193615"><img src="http://144.76.125.123/maneken/h_66_67_68_69_70_71_73_72_3402821628_avatar0.png?1.3.52" /></a></td>
<td><a class="nd" href="/view_profile?player_id=15588"><img src="http://144.76.125.123/maneken/h_66_163_124_173_70_127_177_168_2056356429_avatar0.png?1.3.52" /></a></td>
<td><a class="nd" href="/view_profile?player_id=663794"><img src="http://144.76.125.123/maneken/h_170_75_76_165_174_79_169_128_2659389161_avatar0.png?1.3.52" /></a></td>
</tr>
</table>
</div>
</div>
<div class="hr_arr mlr10 mb-3"><div class="alf"><div class="art"><div class="acn"></div></div></div></div>
<div class="pt3 cntr">
<div class="fl w33 inbl spr2bg r">
<span class="slct"><span class="send"><span class="sttl">
<a href='/rating/'>Игроки</a> </span></span></span>
</div>
<div class="fl w34 inbl spr2bg r">
<a href="/best?pvp=1" class="pt3 inbl">
<a href='/rating/coliseum/'>Колизей</a> </a>
</div>
<div class="fr w33 inbl">
<a href='/clans/' class="pt3 inbl">
Кланы </a>
</div>
<div class="clb"></div>
</div>
<div class="hr_arr mlr10"><div class="alf"><div class="art"><div class="acn"></div></div></div></div>
<table class="cntr wa mlra">
<tr>
<td class="p5">Имя</td>
<td class="p5">Рейтинг</td>
</tr>
<?
break;
case 'duel':
?>
<div class="bdr bg_main mb2"><div class="light"><div class="wr1"><div class="wr2"><div class="wr3"><div class="wr4"><div class="wr5"><div class="wr6"><div class="wr7"><div class="wr8">
<div class="cntr mt10">
<table>
<tr>
<td><a class="nd" href="/view_profile?player_id=811208"><img src="http://144.76.125.123/maneken/h_66_123_76_165_126_79_129_80_3491466481_avatar0.png?1.3.52" /></a></td>
<td><a class="nd" href="/view_profile?player_id=193615"><img src="http://144.76.125.123/maneken/h_66_67_68_69_70_71_73_72_3402821628_avatar0.png?1.3.52" /></a></td>
<td><a class="nd" href="/view_profile?player_id=15588"><img src="http://144.76.125.123/maneken/h_66_163_124_173_70_127_177_168_2056356429_avatar0.png?1.3.52" /></a></td>
<td><a class="nd" href="/view_profile?player_id=663794"><img src="http://144.76.125.123/maneken/h_170_75_76_165_174_79_169_128_2659389161_avatar0.png?1.3.52" /></a></td>
</tr>
</table>
</div>
</div>
<div class="hr_arr mlr10 mb-3"><div class="alf"><div class="art"><div class="acn"></div></div></div></div>
<div class="pt3 cntr">
<div class="fl w33 inbl spr2bg r">
<span class="slct"><span class="send"><span class="sttl">
<a href='/rating/'>Игроки</a> </span></span></span>
</div>
<div class="fl w34 inbl spr2bg r">
<a href="/best?pvp=1" class="pt3 inbl">
<a href='/rating/coliseum/'>Колизей</a> </a>
</div>
<div class="fr w33 inbl">
<a href='/clans/' class="pt3 inbl">
Кланы </a>
</div>
<div class="clb"></div>
</div>
<div class="hr_arr mlr10"><div class="alf"><div class="art"><div class="acn"></div></div></div></div>
<table class="cntr wa mlra">
<tr>
<td class="p5">Имя</td>
<td class="p5">Рейтинг</td>
</tr>
<?
break;
case 'coliseum':
?>
<div class="bdr bg_main mb2"><div class="light"><div class="wr1"><div class="wr2"><div class="wr3"><div class="wr4"><div class="wr5"><div class="wr6"><div class="wr7"><div class="wr8">
<div class="cntr mt10">
<table>
<tr>
<td><a class="nd" href="/view_profile?player_id=811208"><img src="http://144.76.125.123/maneken/h_66_123_76_165_126_79_129_80_3491466481_avatar0.png?1.3.52" /></a></td>
<td><a class="nd" href="/view_profile?player_id=193615"><img src="http://144.76.125.123/maneken/h_66_67_68_69_70_71_73_72_3402821628_avatar0.png?1.3.52" /></a></td>
<td><a class="nd" href="/view_profile?player_id=15588"><img src="http://144.76.125.123/maneken/h_66_163_124_173_70_127_177_168_2056356429_avatar0.png?1.3.52" /></a></td>
<td><a class="nd" href="/view_profile?player_id=663794"><img src="http://144.76.125.123/maneken/h_170_75_76_165_174_79_169_128_2659389161_avatar0.png?1.3.52" /></a></td>
</tr>
</table>
</div>
</div>
<div class="hr_arr mlr10 mb-3"><div class="alf"><div class="art"><div class="acn"></div></div></div></div>
<div class="pt3 cntr">
<div class="fl w33 inbl spr2bg r">
<span class="slct"><span class="send"><span class="sttl">
<a href='/rating/'>Игроки</a> </span></span></span>
</div>
<div class="fl w34 inbl spr2bg r">
<a href="/best?pvp=1" class="pt3 inbl">
<a href='/rating/coliseum/'>Колизей</a> </a>
</div>
<div class="fr w33 inbl">
<a href='/clans/' class="pt3 inbl">
Кланы </a>
</div>
<div class="clb"></div>
</div>
<div class="hr_arr mlr10"><div class="alf"><div class="art"><div class="acn"></div></div></div></div>
<?
break;
}
?>
<?
}
else
{
?>
<tr>
<td class="">
<center><a class="lwhite" href='/user/<?=$row['id']?>/'>
<img src='/images/icon/race/<?=$row['r'].($row['online'] > time() - 300 ? '':'-off')?>.png' alt='*'> <a href='/user/<?=$row['id']?>/'><?=$row['login']?></center></a>
<?
switch($sort) {
default:
?>
<?=($row['str']+$row['vit']+$row['agi']+$row['def'])?>
<?
break;
case 'duel':
?>
<td class="yell"><?=$row['duel_rating']?></td>
<?
break;
case 'coliseum':
?>
<center></center> <td class="yell"><center><?=$row['coliseum_rating']?></center></td>
<?
break;
}
?>
<br/>
<?
}
}
?>
</table>
<div class="hr_arr mt5 mlr10"><div class="alf"><div class="art"><div class="acn"></div></div></div></div>
</div>
</div></div></div></div></div></div></div></div></div></div>
<?=pages('/rating/'.$sort.'/?');?>
<?
include './system/f.php';
?>