Файл: slando.icu/modules/game/reit.php
Строк: 186
<?php
require '../../system/func_for_game2.inc.php';
if (isset($_GET['m'])) {$mod=vvod($_GET['m']);} else {$mod="";}
switch($mod)
{
default:
head2('Рейтинг');
$ctetnomer = mysqli_num_rows(mysqli_query($link,"SELECT id FROM `users` WHERE `opit2` > '".num($user['opit2'])."' or `opit2`= '".num($user['opit2'])."' and `id`<'".num($user['id'])."' "));
if ($ctetnomer=="0"){$ctetnomer =="1";}
$kol_na_str=10;
$total =100;
$count_pages = ceil($total/$kol_na_str);
$page = (isset($_GET['page']) and is_numeric($_GET['page']) and $_GET['page']>1 and $_GET['page']<=$count_pages) ? $_GET['page'] : 1;
$start = $page*$kol_na_str-$kol_na_str;
/** производим запрос к БД **/
$q=mysqli_query($link,"SELECT id,login,adm,sex,opit2,lvl FROM `users` order by `opit2` desc limit ".$start.",".$kol_na_str);
echo '
<div class="block1"><div class="center clrt1">По опыту:</div>
<table>';$n=1+($page*10-10);
while($r = mysqli_fetch_array($q))
{
if($r['opit2']<1000){$opit=$r['opit2'];}elseif($r['opit2']>999 and $r['opit2']<999999){$opit=''.round($r['opit2']/1000,2).' К';}
elseif($r['opit2']>999999){$opit=''.round($r['opit2']/1000000,2).' М';}
$logsend=$r['adm'];$logadm=$r['login'];$id_send=$r['id'];
$name = color_nick($r['login']);
echo'<tr><td style="width:15px;">'.$n.'.</td><td><a href="/anketa?id='.num($r['id']).'">'.sex($r['sex']).''.color_nick($r['id']).'</a></td><td style="width:20px;">'.img(42,'png').'</td><td>'.$opit.'</td></tr>';
$n=$n+1;
}
echo'</table><div class="razriv7"></div>
<div class="center">Вы занимаете '.($ctetnomer+1).' место.</div>';
navi($page, $count_pages, '/reit?page=');
echo'<a class="ssilki3" href="/reit?m=fish">Трофеи</a>';
echo'<a class="ssilki3" href="/reit?m=boarding">Абордаж</a>
';
echo'<a class="ssilki3" href="/reit?m=sea">Потоплено кораблей</a>';
break;
//////
case'boarding':
head2('Рейтинг');
$ctetnomer = mysqli_num_rows(mysqli_query($link,"SELECT id FROM `users` WHERE `reit_abordazh` > '".num($user['reit_abordazh'])."' or `reit_abordazh`= '".num($user['reit_abordazh'])."' and `id`<'".num($user['id'])."' "));
if ($ctetnomer=="0"){$ctetnomer =="1";}
$kol_na_str=10;
$total =100;
$count_pages = ceil($total/$kol_na_str);
$page = (isset($_GET['page']) and is_numeric($_GET['page']) and $_GET['page']>1 and $_GET['page']<=$count_pages) ? $_GET['page'] : 1;
$start = $page*$kol_na_str-$kol_na_str;
/** производим запрос к БД **/
$q=mysqli_query($link,"SELECT id,login,adm,sex,reit_abordazh,lvl FROM `users` order by `reit_abordazh` desc limit ".$start.",".$kol_na_str);
echo '
<div class="block1"><div class="center clrt1">Взято кораблей на абордаж:</div>
<table>';$n=1+($page*10-10);
while($r = mysqli_fetch_array($q))
{
$opit=$r['reit_abordazh'];
$logsend=$r['adm'];$logadm=$r['login'];$id_send=$r['id'];
$name = color_nick($r['login']);
echo'<tr><td style="width:15px;">'.$n.'.</td><td><a href="/anketa?id='.num($r['id']).'">'.sex($r['sex']).''.color_nick($r['id']).'</a></td><td>'.$opit.'</td></tr>';
$n=$n+1;
}
echo'</table><div class="razriv7"></div>
<div class="center">Вы занимаете '.($ctetnomer+1).' место.</div>';
navi($page, $count_pages, '/reit?m=boarding&page=');
echo'<a class="ssilki3" href="/reit">Опыт</a>';
echo'<a class="ssilki3" href="/reit?m=fish">Трофеи</a>
';
echo'<a class="ssilki3" href="/reit?m=sea">Потоплено кораблей</a>';
break;
//////
case'sea':
head2('Рейтинг');
$ctetnomer = mysqli_num_rows(mysqli_query($link,"SELECT id FROM `users` WHERE `arenawin` > '".num($user['arenawin'])."' or `arenawin`= '".num($user['arenawin'])."' and `id`<'".num($user['id'])."' "));
if ($ctetnomer=="0"){$ctetnomer =="1";}
$kol_na_str=10;
$total =100;
$count_pages = ceil($total/$kol_na_str);
$page = (isset($_GET['page']) and is_numeric($_GET['page']) and $_GET['page']>1 and $_GET['page']<=$count_pages) ? $_GET['page'] : 1;
$start = $page*$kol_na_str-$kol_na_str;
/** производим запрос к БД **/
$q=mysqli_query($link,"SELECT id,login,adm,sex,arenawin,lvl FROM `users` order by `arenawin` desc limit ".$start.",".$kol_na_str);
echo '
<div class="block1"><div class="center clrt1">Потоплено кораблей в море:</div>
<table>';$n=1+($page*10-10);
while($r = mysqli_fetch_array($q))
{
$opit=$r['arenawin'];
$logsend=$r['adm'];$logadm=$r['login'];$id_send=$r['id'];
$name = color_nick($r['login']);
echo'<tr><td style="width:15px;">'.$n.'.</td><td><a href="/anketa?id='.num($r['id']).'">'.sex($r['sex']).''.color_nick($r['id']).'</a></td><td>'.$opit.'</td></tr>';
$n=$n+1;
}
echo'</table><div class="razriv7"></div>
<div class="center">Вы занимаете '.($ctetnomer+1).' место.</div>';
navi($page, $count_pages, '/reit?m=sea&page=');
echo'<a class="ssilki3" href="/reit">Опыт</a>';
echo'<a class="ssilki3" href="/reit?m=fish">Трофеи</a>
';
echo'<a class="ssilki3" href="/reit?m=boarding">Абордаж</a>';
break;
//////
case'fish':
head2('Рейтинг');
$ctetnomer = mysqli_num_rows(mysqli_query($link,"SELECT id FROM `users` WHERE `fish_ubil` > '".num($user['fish_ubil'])."' or `fish_ubil`= '".num($user['fish_ubil'])."' and `id`<'".num($user['id'])."' "));
if ($ctetnomer=="0"){$ctetnomer =="1";}
$kol_na_str=10;
$total =100;
$count_pages = ceil($total/$kol_na_str);
$page = (isset($_GET['page']) and is_numeric($_GET['page']) and $_GET['page']>1 and $_GET['page']<=$count_pages) ? $_GET['page'] : 1;
$start = $page*$kol_na_str-$kol_na_str;
/** производим запрос к БД **/
$q=mysqli_query($link,"SELECT id,login,adm,sex,fish_ubil,lvl FROM `users` order by `fish_ubil` desc limit ".$start.",".$kol_na_str);
echo '
<div class="block1"><div class="center clrt1">Выловлено рыбы:</div>
<table>';$n=1+($page*10-10);
while($r = mysqli_fetch_array($q))
{
$opit=$r['fish_ubil'];
$logsend=$r['adm'];$logadm=$r['login'];$id_send=$r['id'];
$name = color_nick($r['login']);
echo'<tr><td style="width:15px;">'.$n.'.</td><td><a href="/anketa?id='.num($r['id']).'">'.sex($r['sex']).''.color_nick($r['id']).'</a></td><td>'.$opit.'</td></tr>';
$n=$n+1;
}
echo'</table><div class="razriv7"></div>
<div class="center">Вы занимаете '.($ctetnomer+1).' место.</div>';
navi($page, $count_pages, '/reit?m=fish&page=');
echo'<a class="ssilki3" href="/reit">Опыт</a>';
echo'<a class="ssilki3" href="/reit?m=boarding">Абордаж</a>
';
echo'<a class="ssilki3" href="/reit?m=sea">Потоплено кораблей</a>';
break;
}
foot();
?>