Файл: war/war/rating.php
Строк: 295
<?
define('PROTECTOR', 1);
$headmod = 'rating';//фикс. места
$textl='Зал Славы';
include('files/path.php');
include('files/gzips.php');
include($path.'files/db.php');
include($path.'files/auth.php');
include($path.'files/func.php');
include($path.'files/core.php');
include($path.'files/head.php');
include($path.'files/zag.php');
switch($_GET[mod]){
default:
echo"<center><b>Зал славы</b></center>";
echo'<div class="bt"></div>';
echo"» <a href="rating.php?mod=lvl">Рейтинг самых больших уровней</a><br/>";
echo"» <a href="rating.php?mod=opit">Рейтинг самых опытных</a><br/>";
echo"» <a href="rating.php?mod=sila">Рейтинг самых сильных</a><br/>";
echo"» <a href="rating.php?mod=lovk">Рейтинг самых ловких</a><br/>";
echo"» <a href="rating.php?mod=prot">Рейтинг физической защиты</a><br/>";
echo"» <a href="rating.php?mod=krit">Рейтинг Критического удара</a><br/>";
echo"» <a href="rating.php?mod=ukrit">Рейтинг Критического урона</a><br/>---<br/>";
echo"» <a href="rating.php?mod=igrok">Рейтинг победителей арены</a><br/>";
echo"» <a href="rating.php?mod=igrok_porajeniya">Рейтинг боёв на арене</a><br/>";
echo"» <a href="rating.php?mod=loc">Рейтинг побед в окрестностях</a><br/>";
echo"» <a href="rating.php?mod=loc_proigral">Рейтинг поражений в окрестностях</a><br/>";
echo"<br/>---<br/>";
echo"» <a href="rating.php?mod=pop">Популярные игроки</a><br/>";
break;
case 'pop':
$b = mysql_query("SELECT usr,rek FROM users WHERE rek >'0' AND prava <'5' ORDER BY loses DESC LIMIT 0, 10");
////////////////////////////
$avto=mysql_num_rows($b);
if($avto>=1){
$i=1;
While($best = mysql_fetch_array($b))
{
$nickas = strip_tags($best[usr]);
$req = mysql_query("SELECT `storona` FROM `users` WHERE `usr` = '$nickas'");
$asd = mysql_num_rows(mysql_query("SELECT laikas, usr FROM online WHERE laikas > '$timeout' AND usr='$nickas'"));
$pic = mysql_fetch_array($req);
echo"$i.";
echo' <img src="pic/main/'.$pic['storona'].'.png" alt="#"/>';
$i++;
echo" <a href="search.php?nick=$best[usr]&go=go">$best[usr]</a>
Популярность: ".number_format ($best[rek])."";
if($asd==0){
echo" - <font color="red"> offline</font><br/>";}else{
echo" - <font color="lime"> Online</font><br/>";}
}
echo "<br/>» <a href="rating.php?"> Вернуться</a><br>";
}else{
echo"<b>Нет популярных</b><br/>";
}
break;
case 'loc_proigral':
$b = mysql_query("SELECT usr,loses FROM users WHERE loses >'0' AND prava <'5' ORDER BY loses DESC LIMIT 0, 10");
////////////////////////////
$avto=mysql_num_rows($b);
if($avto>=1){
$i=1;
While($best = mysql_fetch_array($b))
{
$nickas = strip_tags($best[usr]);
$req = mysql_query("SELECT `storona` FROM `users` WHERE `usr` = '$nickas'");
$asd = mysql_num_rows(mysql_query("SELECT laikas, usr FROM online WHERE laikas > '$timeout' AND usr='$nickas'"));
$pic = mysql_fetch_array($req);
echo"$i.";
echo' <img src="pic/main/'.$pic['storona'].'.png" alt="#"/>';
$i++;
echo" <a href="search.php?nick=$best[usr]&go=go">$best[usr]</a>
Поражений: ".number_format ($best[loses])."";
if($asd==0){
echo" - <font color="red"> offline</font><br/>";}else{
echo" - <font color="lime"> Online</font><br/>";}
}
echo "<br/>» <a href="rating.php?"> Вернуться</a><br>";
}else{
echo"<b>Нет поражений</b><br/>";
}
break;
case 'loc':
$b = mysql_query("SELECT usr,wins FROM users WHERE wins >'0' AND prava <'5' ORDER BY wins DESC LIMIT 0, 10");
////////////////////////////
$avto=mysql_num_rows($b);
if($avto>=1){
$i=1;
While($best = mysql_fetch_array($b))
{
$nickas = strip_tags($best[usr]);
$req = mysql_query("SELECT `storona` FROM `users` WHERE `usr` = '$nickas'");
$asd = mysql_num_rows(mysql_query("SELECT laikas, usr FROM online WHERE laikas > '$timeout' AND usr='$nickas'"));
$pic = mysql_fetch_array($req);
echo"$i.";
echo' <img src="pic/main/'.$pic['storona'].'.png" alt="#"/>';
$i++;
echo" <a href="search.php?nick=$best[usr]&go=go">$best[usr]</a>
Побед ".number_format ($best[wins])."";
if($asd==0){
echo" - <font color="red"> offline</font><br/>";}else{
echo" - <font color="lime"> Online</font><br/>";}
}
echo "<br/>» <a href="rating.php?"> Вернуться</a><br>";
}else{
echo"<b>Нет победителей</b><br/>";
}
break;
case 'igrok_porajeniya':
$b = mysql_query("SELECT usr,boi FROM users WHERE boi >'0' AND prava <'5' ORDER BY boi DESC LIMIT 0, 10");
////////////////////////////
$avto=mysql_num_rows($b);
if($avto>=1){
$i=1;
While($best = mysql_fetch_array($b))
{
$nickas = strip_tags($best[usr]);
$req = mysql_query("SELECT `storona` FROM `users` WHERE `usr` = '$nickas'");
$asd = mysql_num_rows(mysql_query("SELECT laikas, usr FROM online WHERE laikas > '$timeout' AND usr='$nickas'"));
$pic = mysql_fetch_array($req);
echo"$i.";
echo' <img src="pic/main/'.$pic['storona'].'.png" alt="#"/>';
$i++;
echo" <a href="search.php?nick=$best[usr]&go=go">$best[usr]</a>
Боёв на арене: ".number_format ($best[boi])."";
if($asd==0){
echo" - <font color="red"> offline</font><br/>";}else{
echo" - <font color="lime"> Online</font><br/>";}
}
echo "<br/>» <a href="rating.php?"> Вернуться</a><br>";
}else{
echo"<b>Небыло боёв</b><br/>";
}
break;
case 'igrok':
$b = mysql_query("SELECT usr,pobeda FROM users WHERE pobeda >'0' AND prava <'5' ORDER BY pobeda DESC LIMIT 0, 10");
////////////////////////////
$avto=mysql_num_rows($b);
if($avto>=1){
$i=1;
While($best = mysql_fetch_array($b))
{
$nickas = strip_tags($best[usr]);
$req = mysql_query("SELECT `storona` FROM `users` WHERE `usr` = '$nickas'");
$asd = mysql_num_rows(mysql_query("SELECT laikas, usr FROM online WHERE laikas > '$timeout' AND usr='$nickas'"));
$pic = mysql_fetch_array($req);
echo"$i.";
echo' <img src="pic/main/'.$pic['storona'].'.png" alt="#"/>';
$i++;
echo" <a href="search.php?nick=$best[usr]&go=go">$best[usr]</a>
Побед: ".number_format ($best[pobeda])."";
if($asd==0){
echo" - <font color="red"> offline</font><br/>";}else{
echo" - <font color="lime"> Online</font><br/>";}
}
echo "<br/>» <a href="rating.php?"> Вернуться</a><br>";
}else{
echo"<b>Нет победителей</b><br/>";
}
break;
case 'opit':
$b = mysql_query("SELECT usr,exp FROM users WHERE exp >'0' AND prava <'5' ORDER BY exp DESC LIMIT 0, 10");
////////////////////////////
$avto=mysql_num_rows($b);
if($avto>=1){
$i=1;
While($best = mysql_fetch_array($b))
{
$nickas = strip_tags($best[usr]);
$req = mysql_query("SELECT `storona` FROM `users` WHERE `usr` = '$nickas'");
$asd = mysql_num_rows(mysql_query("SELECT laikas, usr FROM online WHERE laikas > '$timeout' AND usr='$nickas' "));
$pic = mysql_fetch_array($req);
echo"$i.";
echo' <img src="pic/main/'.$pic['storona'].'.png" alt="#"/>';
$i++;
echo" <a href="search.php?nick=$best[usr]&go=go">$best[usr]</a>
Опыта: ".number_format ($best[exp])."";
if($asd==0){
echo" - <font color="red"> offline</font><br/>";}else{
echo" - <font color="lime"> Online</font><br/>";}
}
echo "<br/>» <a href="rating.php?"> Вернуться</a><br>";
}else{
echo"<b>Нет опытных</b><br/>";
}
break;
case 'lvl':
$b = mysql_query("SELECT usr,lvl FROM users WHERE lvl >'0' AND prava <'5' ORDER BY lvl DESC LIMIT 0, 10");
////////////////////////////
$avto=mysql_num_rows($b);
if($avto>=1){
$i=1;
While($best = mysql_fetch_array($b))
{
$nickas = strip_tags($best[usr]);
$req = mysql_query("SELECT `storona` FROM `users` WHERE `usr` = '$nickas'");
$asd = mysql_num_rows(mysql_query("SELECT laikas, usr FROM online WHERE laikas > '$timeout' AND usr='$nickas'"));
$pic = mysql_fetch_array($req);
echo"$i.";
echo' <img src="pic/main/'.$pic['storona'].'.png" alt="#"/>';
$i++;
echo" <a href="search.php?nick=$best[usr]&go=go">$best[usr]</a> <img src='pic/up.png'/> $best[lvl] ";
if($asd==0){
echo" - <font color="red"> offline</font><br/>";}else{
echo" - <font color="lime"> Online</font><br/>";}
}
echo "<br/>» <a href="rating.php?"> Вернуться</a><br>";
}else{
echo"<b>Нет опытных игроков</b><br/>";
}
break;
///////////
///////////
case 'sila':
$b = mysql_query("SELECT usr,sila FROM users WHERE sila >'0' AND prava <'5' ORDER BY sila DESC LIMIT 0, 10");
////////////////////////////
$avto=mysql_num_rows($b);
if($avto>=1){
$i=1;
While($best = mysql_fetch_array($b))
{
$nickas = strip_tags($best[usr]);
$req = mysql_query("SELECT `storona` FROM `users` WHERE `usr` = '$nickas'");
$asd = mysql_num_rows(mysql_query("SELECT laikas, usr FROM online WHERE laikas > '$timeout' AND usr='$nickas'"));
$pic = mysql_fetch_array($req);
echo"$i.";
echo' <img src="pic/main/'.$pic['storona'].'.png" alt="#"/>';
$i++;
echo" <a href="search.php?nick=$best[usr]&go=go">$best[usr]</a>
Сила: $best[sila]";
if($asd==0){
echo" - <font color="red"> offline</font><br/>";}else{
echo" - <font color="lime"> Online</font><br/>";}
}
echo "<br/>» <a href="rating.php?"> Вернуться</a><br>";
}else{
echo"<b>Нет сильных игроков</b><br/>";
}
break;
////////////////////////////
case 'lovk':
$b = mysql_query("SELECT usr,lovk FROM users WHERE lovk >'0' AND prava <'5' ORDER BY lovk DESC LIMIT 0, 10");
////////////////////////////
$avto=mysql_num_rows($b);
if($avto>=1){
$i=1;
While($best = mysql_fetch_array($b))
{
$nickas = strip_tags($best[usr]);
$req = mysql_query("SELECT `storona` FROM `users` WHERE `usr` = '$nickas'");
$asd = mysql_num_rows(mysql_query("SELECT laikas, usr FROM online WHERE laikas > '$timeout' AND usr='$nickas'"));
$pic = mysql_fetch_array($req);
echo"$i.";
echo' <img src="pic/main/'.$pic['storona'].'.png" alt="#"/>';
$i++;
echo" <a href="search.php?nick=$best[usr]&go=go">$best[usr]</a>
Ловкость: $best[lovk]";
if($asd==0){
echo" - <font color="red"> offline</font><br/>";}else{
echo" - <font color="lime"> Online</font><br/>";}
}
echo "<br/>» <a href="rating.php?"> Вернуться</a><br>";
}else{
echo"<b>Нет Ловких игроков</b><br/>";
}
break;
///////////
case 'prot':
$b = mysql_query("SELECT usr,prot FROM users WHERE prot >'0' AND prava <'5' ORDER BY prot DESC LIMIT 0, 10");
////////////////////////////
$avto=mysql_num_rows($b);
if($avto>=1){
$i=1;
While($best = mysql_fetch_array($b))
{
$nickas = strip_tags($best[usr]);
$req = mysql_query("SELECT `storona` FROM `users` WHERE `usr` = '$nickas'");
$asd = mysql_num_rows(mysql_query("SELECT laikas, usr FROM online WHERE laikas > '$timeout' AND usr='$nickas'"));
$pic = mysql_fetch_array($req);
echo"$i.";
echo' <img src="pic/main/'.$pic['storona'].'.png" alt="#"/>';
$i++;
echo" <a href="search.php?nick=$best[usr]&go=go">$best[usr]</a>
Защита: ".number_format ($best[prot])."";
if($asd==0){
echo" - <font color="red"> offline</font><br/>";}else{
echo" - <font color="lime"> Online</font><br/>";}
}
echo "<br/>» <a href="rating.php?"> Вернуться</a><br>";
}else{
echo"<b>Нет физ. защищёных игроков</b><br/>";
}
break;
///////////
case 'krit':
$b = mysql_query("SELECT usr,krit FROM users WHERE krit >'0' AND prava <'5' ORDER BY krit DESC LIMIT 0, 10");
////////////////////////////
$avto=mysql_num_rows($b);
if($avto>=1){
$i=1;
While($best = mysql_fetch_array($b))
{
$nickas = strip_tags($best[usr]);
$req = mysql_query("SELECT `storona` FROM `users` WHERE `usr` = '$nickas'");
$asd = mysql_num_rows(mysql_query("SELECT laikas, usr FROM online WHERE laikas > '$timeout' AND usr='$nickas'"));
$pic = mysql_fetch_array($req);
echo"$i.";
echo' <img src="pic/main/'.$pic['storona'].'.png" alt="#"/>';
$i++;
echo" <a href="search.php?nick=$best[usr]&go=go">$best[usr]</a>
Критический удар: $best[krit] %";
if($asd==0){
echo" - <font color="red"> offline</font><br/>";}else{
echo" - <font color="lime"> Online</font><br/>";}
}
echo "<br/>» <a href="rating.php?"> Вернуться</a><br>";
}else{
echo"<b>Нет критовиков</b><br/>";
}
break;
///////////
case 'ukrit':
$b = mysql_query("SELECT usr,ukrit FROM users WHERE ukrit >'0' AND prava <'5' ORDER BY ukrit DESC LIMIT 0, 10");
////////////////////////////
$avto=mysql_num_rows($b);
if($avto>=1){
$i=1;
While($best = mysql_fetch_array($b))
{
$nickas = strip_tags($best[usr]);
$req = mysql_query("SELECT `storona` FROM `users` WHERE `usr` = '$nickas'");
$asd = mysql_num_rows(mysql_query("SELECT laikas, usr FROM online WHERE laikas > '$timeout' AND usr='$nickas'"));
$pic = mysql_fetch_array($req);
echo"$i.";
echo' <img src="pic/main/'.$pic['storona'].'.png" alt="#"/>';
$i++;
echo" <a href="search.php?nick=$best[usr]&go=go">$best[usr]</a>
Крит-урон: $best[ukrit] %";
if($asd==0){
echo" - <font color="red"> offline</font><br/>";}else{
echo" - <font color="lime"> Online</font><br/>";}
}
echo "<br/>» <a href="rating.php?"> Вернуться</a><br>";
}else{
echo"<b>Нет критовиков с сильным ударом</b><br/>";
}
break;
///////////
case 'money':
$b = mysql_query("SELECT usr,money FROM users WHERE money >0 AND prava <'5' ORDER BY money DESC LIMIT 0, 10");
////////////////////////////
$avto=mysql_num_rows($b);
if($avto>=1){
$i=1;
While($best = mysql_fetch_array($b))
{
echo"$i. <a href="search.php?nick=$best[usr]&go=go">$best[usr]</a>
[Монеты <b>$best[money]</b>]<br/>";
$i++;
}
}else{
echo"<b>Нет богачей</b><br/>";
}
echo "<br/>» <a href="rating.php?"> Вернуться</a><br>";
break;
///////////
case 'gald':
$b = mysql_query("SELECT usr,gold FROM users WHERE gold >0 AND prava <'5' ORDER BY gold DESC LIMIT 0, 10");
////////////////////////////
$avto=mysql_num_rows($b);
if($avto>=1){
$i=1;
While($best = mysql_fetch_array($b))
{
echo"$i. <a href="search.php?nick=$best[usr]&go=go">$best[usr]</a>
[Монеты <b>$best[gold]</b>]<br/>";
$i++;
}
}else{
echo"<b>Нет богачей</b><br/>";
}
echo"<a href="rating.php?">Назад</a>";
break;
///////////
}
include($path.'files/down.php');
include($path.'files/meny.php');
?>