Файл: l2ps_v5/ratings.php
Строк: 521
<?php
include_once("files/zag.php");
include_once("files/ini.php");
$polz=mysql_query("SELECT * FROM `users` WHERE `udata0`='$log' AND `udata1`='$pas' LIMIT 1");
if(mysql_num_rows($polz)==0){
header ("Location: index.php?error");
echo'<div class="p">Ошибка! Пользователь с таким логином и паролем не зарегистрирован, или пароль/логин неверен! <a href="index.php">На главную</a><br>';exit;
}else{
switch($r) {
default:
echo"<img src="l2pic/m.gif"> <a href="ratings?&r=activ">Самые активные</a><br/>";
echo"<img src="l2pic/m.gif"> <a href="ratings?&r=post">Рейтинг постеров</a><br/>";
echo"<img src="l2pic/m.gif"> <a href="ratings?&r=exp">Самые опытные</a><br/>";
echo"<img src="l2pic/m.gif"> <a href="ratings?&r=pvp">Рейтинг PVP</a><br/>";
echo"<img src="l2pic/m.gif"> <a href="ratings?&r=pk">Рейтинг PK </a>(по количеству) <br/>";
echo"<img src="l2pic/m.gif"> <a href="ratings?&r=pk_k">Рейтинг PK </a>(по карме) <br/>";
echo"<img src="l2pic/m.gif"> <a href="ratings?&r=c_rep">Рейтинг кланов </a> (по клановым очкам)<br/>";
echo"<img src="l2pic/m.gif"> <a href="ratings?&r=c_exp">Рейтинг кланов </a> (по опыту)<br/>";
echo"<img src="l2pic/m.gif"> <a href="ratings?&r=rek">Популярные игроки</a><br/>";
echo"<img src="l2pic/m.gif"> <a href="ratings?&r=questions">Самые умные игроки</a><br/>";
echo"<img src="l2pic/m.gif"> <a href="ratings?&r=battle">Рейтинг Боев</a><br/>";
if ($udata67 == "200" or $udata67 == "777")
{
echo"<img src="l2pic/m.gif"> <a href="ratings?&r=lovkost">Самые крепкие</a><br/>";
echo"<img src="l2pic/m.gif"> <a href="ratings?&r=ataka">Самые сильные</a><br/>";
echo"<img src="l2pic/m.gif"> <a href="ratings?&r=coin">Рейтинг по Coin of Luck</a><br/>";
echo"<img src="l2pic/m.gif"> <a href="ratings?&r=c_mon">Рейтинг кланов </a> (по капиталу клана)<br/>";
}
break;
case 'lovkost':
echo '<b>Самые крепкие:</b><br/>';
$pr_q=mysql_query("SELECT * FROM `users` WHERE `udata67`!='200' and `udata67`!='777' order by `udata3` desc limit 10;");
$i=1;
while($pr_ar=mysql_fetch_array($pr_q))
{
$udatap3=$pr_ar['udata3'];
echo "<br><b>".$i.".</b><a href="search.php?&nick=".$pr_ar['udata0']."&go=go">".$pr_ar['udata0']." </a><br>Защита: "; echo number_format( $udatap3 );
$i=$i+1;
}
break;
case 'post':
echo '<b>Рейтинг постов:</b><br/>';
$pr_q=mysql_query("SELECT * FROM `users` WHERE `udata67`!='200' and `udata67`!='777' order by `udata89` desc limit 10;");
while($arr=mysql_fetch_array($pr_q))
{
$aglava=mysql_query("SELECT * FROM `clan` WHERE `clan0`='$arr[udata23]' ");
$arrs= mysql_fetch_array($aglava);
$ggg=$arrs['clan2'];
echo "<br>";
if(!empty($ggg)){
echo"<img src="pic/clan/$ggg" alt="clan"/>";}
if($arr['udata86'] >= "1"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=red>".$arr['udata0']."</font></a>";}else
if($arr['udata67'] == "200"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=lime>".$arr['udata0']."</font></a>";}else
if($arr['udata67'] == "100"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=blue>".$arr['udata0']."</font></a>";}else
if($arr['udata75']=="vip"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=gold>".$arr['udata0']."</font></a>";}else
if($arr['udata25']!==""){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="".$arr['udata25'].""><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="80"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#008B8B"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="81"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00CDCD"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="82"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00EEEE"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="83"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00CDCD"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="84"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00FFFF"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="85"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#FF4500"><up><b>".$arr['udata0']."</b></up></font></a>";}else{
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go">".$arr['udata0']."</a>";}
echo' (Уровень '.$arr['udata9'].', Постов: '.number_format($arr['udata89']).') ';
}
$pr_q=mysql_query("SELECT * FROM `users` WHERE `udata67`!='200' and `udata67`!='777' order by `udata89` desc;");
$i=1;
while($pr_ar=mysql_fetch_array($pr_q))
{
if($pr_ar[udata0]==$log){
echo "<br><br>Вы находитесь на <b>".$i."</b> месте.";
}
$i=$i+1;
}
break;
case 'ataka':
echo '<b>Самые сильные:</b><br/>';
$pr_q=mysql_query("SELECT * FROM `users` WHERE `udata67`!='200' and `udata67`!='777' order by `udata4` desc limit 10;");
$i=1;
while($pr_ar=mysql_fetch_array($pr_q))
{
$udatap4=$pr_ar['udata4'];
echo "<br><b>".$i.".</b><a href="search.php?&nick=".$pr_ar['udata0']."&go=go">".$pr_ar['udata0']." </a><br>Атака: "; echo number_format( $udatap4 );
$i=$i+1;
}
break;
case 'questions':
echo '<b>Самые умные игроки:</b><br/>';
$pr_q=mysql_query("SELECT * FROM `v_answer` order by `answer` desc limit 10;");
$i=1;
while($pr_ar=mysql_fetch_array($pr_q))
{
$add=mysql_query("SELECT * FROM `users` WHERE `udata0`='$pr_ar[usr]'");
$arr=mysql_fetch_array($add);
$udatap86=$pr_ar['answer'];
$aglava=mysql_query("SELECT * FROM `clan` WHERE `clan0`='$arr[udata23]' ");
$arrs= mysql_fetch_array($aglava);
$ggg=$arrs['clan2'];
echo "<br>".$i.".";
if(!empty($ggg)){
echo"<img src="pic/clan/$ggg" alt="clan"/> ";}
if($arr['udata86'] >= "1"){
echo "<a href="search.php?&nick=".$pr_ar['usr']."&go=go"><font color=red>".$pr_ar['usr']."</font></a> <br> Правильных ответов:";}else
if($arr['udata67'] == "200"){
echo "<a href="search.php?&nick=".$pr_ar['usr']."&go=go"><font color=lime>".$pr_ar['usr']."</font></a> <br> Правильных ответов:";}else
if($arr['udata67'] == "100"){
echo "<a href="search.php?&nick=".$pr_ar['usr']."&go=go"><font color=blue>".$pr_ar['usr']."</font></a> <br> Правильных ответов:";}else
if($arr['udata75']=="vip"){
echo "<a href="search.php?&nick=".$pr_ar['usr']."&go=go"><font color=gold>".$pr_ar['usr']."</font></a> <br> Правильных ответов:";}else
if($arr['udata25']!==""){
echo"<a href="search.php?&nick=".$pr_ar['usr']."&go=go"><font color="".$arr['udata25'].""><up>".$pr_ar['usr']."</up></font></a> <br> Правильных ответов:";}else
if($arr['udata9']=="80"){
echo"<a href="search.php?&nick=".$pr_ar['usr']."&go=go"><font color="#008B8B"><up>".$pr_ar['usr']."</up></font></a> <br> Правильных ответов:";}else
if($arr['udata9']=="81"){
echo"<a href="search.php?&nick=".$pr_ar['usr']."&go=go"><font color="#00CDCD"><up>".$pr_ar['usr']."</up></font></a> <br> Правильных ответов:";}else
if($arr['udata9']=="82"){
echo"<a href="search.php?&nick=".$pr_ar['usr']."&go=go"><font color="#00EEEE"><up>".$pr_ar['usr']."</up></font></a> <br> Правильных ответов:";}else
if($arr['udata9']=="83"){
echo"<a href="search.php?&nick=".$pr_ar['usr']."&go=go"><font color="#00CDCD"><up>".$pr_ar['usr']."</up></font></a> <br> Правильных ответов:";}else
if($arr['udata9']=="84"){
echo"<a href="search.php?&nick=".$pr_ar['usr']."&go=go"><font color="#00FFFF"><up>".$pr_ar['usr']."</up></font></a> <br> Правильных ответов:";}else
if($arr['udata9']=="85"){
echo"<a href="search.php?&nick=".$pr_ar['usr']."&go=go"><font color="#FF4500"><up><b>".$pr_ar['usr']."</b></up></font></a> <br>";}else{
echo "<a href="search.php?&nick=".$pr_ar['usr']."&go=go">".$pr_ar['usr']."</a> <br> Правильных ответов:";}
echo number_format( $udatap86 );
$i=$i+1;
}
$pr_q=mysql_query("SELECT * FROM `v_answer` order by `answer` desc ");
$i=1;
while($pr_ar=mysql_fetch_array($pr_q))
{
if($pr_ar[usr]==$log){
echo "<br><br>Вы находитесь на <b>".$i."</b> месте.";
}
$i=$i+1;
}
break;
case 'rek':
echo '<b>Популярные игроки:</b><br/>';
$pr_q=mysql_query("SELECT * FROM `recommendations` order by `kol` desc limit 10;");
$i=1;
while($pr_ar=mysql_fetch_array($pr_q))
{
$add=mysql_query("SELECT * FROM `users` WHERE `udata67`!='200' and `udata67`!='777' and `udata0`='$pr_ar[usr]'");
$arr=mysql_fetch_array($add);
$udatap86=$pr_ar['kol'];
$aglava=mysql_query("SELECT * FROM `clan` WHERE `clan0`='$arr[udata23]' ");
$arrs= mysql_fetch_array($aglava);
$ggg=$arrs['clan2'];
echo "<br>".$i.".";
if(!empty($ggg)){
echo"<img src="pic/clan/$ggg" alt="clan"/> ";}
if($arr['udata86'] >= "1"){
echo "<a href="search.php?&nick=".$pr_ar['usr']."&go=go"><font color=red>".$pr_ar['usr']."</font></a> (".$arr['udata9']." уровень)<br> Рекомендован:";}else
if($arr['udata67'] == "200"){
echo "<a href="search.php?&nick=".$pr_ar['usr']."&go=go"><font color=lime>".$pr_ar['usr']."</font></a> (".$arr['udata9']." уровень)<br> Рекомендован:";}else
if($arr['udata67'] == "100"){
echo "<a href="search.php?&nick=".$pr_ar['usr']."&go=go"><font color=blue>".$pr_ar['usr']."</font></a> (".$arr['udata9']." уровень)<br> Рекомендован:";}else
if($arr['udata75']=="vip"){
echo "<a href="search.php?&nick=".$pr_ar['usr']."&go=go"><font color=gold>".$pr_ar['usr']."</font></a> (".$arr['udata9']." уровень)<br> Рекомендован:";}else
if($arr['udata25']!==""){
echo"<a href="search.php?&nick=".$pr_ar['usr']."&go=go"><font color="".$arr['udata25'].""><up>".$pr_ar['usr']."</up></font></a> (".$arr['udata9']." уровень)<br> Рекомендован:";}else
if($arr['udata9']=="80"){
echo"<a href="search.php?&nick=".$pr_ar['usr']."&go=go"><font color="#008B8B"><up>".$pr_ar['usr']."</up></font></a> (".$arr['udata9']." уровень)<br> Рекомендован:";}else
if($arr['udata9']=="81"){
echo"<a href="search.php?&nick=".$pr_ar['usr']."&go=go"><font color="#00CDCD"><up>".$pr_ar['usr']."</up></font></a> (".$arr['udata9']." уровень)<br> Рекомендован:";}else
if($arr['udata9']=="82"){
echo"<a href="search.php?&nick=".$pr_ar['usr']."&go=go"><font color="#00EEEE"><up>".$pr_ar['usr']."</up></font></a> (".$arr['udata9']." уровень)<br> Рекомендован:";}else
if($arr['udata9']=="83"){
echo"<a href="search.php?&nick=".$pr_ar['usr']."&go=go"><font color="#00CDCD"><up>".$pr_ar['usr']."</up></font></a> (".$arr['udata9']." уровень)<br> Рекомендован:";}else
if($arr['udata9']=="84"){
echo"<a href="search.php?&nick=".$pr_ar['usr']."&go=go"><font color="#00FFFF"><up>".$pr_ar['usr']."</up></font></a> (".$arr['udata9']." уровень)<br> Рекомендован:";}else
if($arr['udata9']=="85"){
echo"<a href="search.php?&nick=".$pr_ar['usr']."&go=go"><font color="#FF4500"><up><b>".$pr_ar['usr']."</b></up></font></a> (".$arr['udata9']." уровень)<br>";}else{
echo "<a href="search.php?&nick=".$pr_ar['usr']."&go=go">".$pr_ar['usr']."</a> (".$arr['udata9']." уровень)<br> Рекомендован:";}
echo number_format( $udatap86 );
$i=$i+1;
}
$pr_q=mysql_query("SELECT * FROM `recommendations` order by `kol` desc limit 10;");
$i=1;
while($pr_ar=mysql_fetch_array($pr_q))
{
if($pr_ar[usr]==$log){
echo "<br><br>Вы находитесь на <b>".$i."</b> месте.";
}
$i=$i+1;
}
break;
case 'activ':
echo '<b>Самые активные:</b><br/>';
$pr_q=mysql_query("SELECT * FROM `users` WHERE `udata67`!='200' and `udata67`!='777' order by `udata60` desc limit 10;");
while($arr=mysql_fetch_array($pr_q))
{
$udatap60=$arr['udata60'];
$aglava=mysql_query("SELECT * FROM `clan` WHERE `clan0`='$arr[udata23]' ");
$arrs= mysql_fetch_array($aglava);
$ggg=$arrs['clan2'];
echo "<br>";
if(!empty($ggg)){
echo"<img src="pic/clan/$ggg" alt="clan"/>";}
if($arr['udata86'] >= "1"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=red>".$arr['udata0']."</font></a>";}else
if($arr['udata67'] == "200"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=lime>".$arr['udata0']."</font></a>";}else
if($arr['udata67'] == "100"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=blue>".$arr['udata0']."</font></a>";}else
if($arr['udata75']=="vip"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=gold>".$arr['udata0']."</font></a>";}else
if($arr['udata25']!==""){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="".$arr['udata25'].""><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="80"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#008B8B"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="81"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00CDCD"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="82"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00EEEE"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="83"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00CDCD"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="84"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00FFFF"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="85"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#FF4500"><up><b>".$arr['udata0']."</b></up></font></a>";}else{
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go">".$arr['udata0']."</a>";}
echo' (Уровень: '.$arr['udata9'].' | В игре: '.sec2day($udatap60).') ';
}
$pr_q=mysql_query("SELECT * FROM `users` WHERE `udata67`!='200' and `udata67`!='777' order by `udata60` desc;");
$i=1;
while($pr_ar=mysql_fetch_array($pr_q))
{
if($pr_ar[udata0]==$log){
$udataf19=$pr_ar['udata19'];
echo "<br><br>Вы находитесь на <b>".$i."</b> месте.";
}
$i=$i+1;
}
break;
case 'exp':
echo '<b>Самые опытные:</b><br/>';
$pr_q=mysql_query("SELECT * FROM `users` WHERE `udata67`!='200' and `udata67`!='777' order by `udata19` desc limit 10;");
while($arr=mysql_fetch_array($pr_q))
{
$udatap60=$arr['udata60'];
$aglava=mysql_query("SELECT * FROM `clan` WHERE `clan0`='$arr[udata23]' ");
$arrs= mysql_fetch_array($aglava);
$ggg=$arrs['clan2'];
echo "<br>";
if(!empty($ggg)){
echo"<img src="pic/clan/$ggg" alt="clan"/>";}
if($arr['udata86'] >= "1"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=red>".$arr['udata0']."</font></a>";}else
if($arr['udata67'] == "200"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=lime>".$arr['udata0']."</font></a>";}else
if($arr['udata67'] == "100"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=blue>".$arr['udata0']."</font></a>";}else
if($arr['udata75']=="vip"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=gold>".$arr['udata0']."</font></a>";}else
if($arr['udata25']!==""){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="".$arr['udata25'].""><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="80"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#008B8B"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="81"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00CDCD"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="82"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00EEEE"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="83"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00CDCD"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="84"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00FFFF"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="85"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#FF4500"><up><b>".$arr['udata0']."</b></up></font></a>";}else{
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go">".$arr['udata0']."</a>";}
echo' (Уровень '.$arr['udata9'].', Опыт: '.number_format($arr['udata19']).') ';
}
$pr_q=mysql_query("SELECT * FROM `users` WHERE `udata67`!='200' and `udata67`!='777' order by `udata19` desc;");
$i=1;
while($pr_ar=mysql_fetch_array($pr_q))
{
if($pr_ar[udata0]==$log){
echo "<br><br>Вы находитесь на <b>".$i."</b> месте.";
}
$i=$i+1;
}
break;
case 'pvp':
echo '<b>PvP:</b><br/>';
$pr_q=mysql_query("SELECT * FROM `users` WHERE `udata67`!='200' and `udata67`!='777' order by `udata85` desc limit 10;");
while($arr=mysql_fetch_array($pr_q))
{
$aglava=mysql_query("SELECT * FROM `clan` WHERE `clan0`='$arr[udata23]' ");
$arrs= mysql_fetch_array($aglava);
$ggg=$arrs['clan2'];
echo "<br>";
if(!empty($ggg)){
echo"<img src="pic/clan/$ggg" alt="clan"/>";}
if($arr['udata86'] >= "1"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=red>".$arr['udata0']."</font></a>";}else
if($arr['udata67'] == "200"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=lime>".$arr['udata0']."</font></a>";}else
if($arr['udata67'] == "100"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=blue>".$arr['udata0']."</font></a>";}else
if($arr['udata75']=="vip"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=gold>".$arr['udata0']."</font></a>";}else
if($arr['udata25']!==""){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="".$arr['udata25'].""><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="80"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#008B8B"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="81"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00CDCD"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="82"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00EEEE"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="83"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00CDCD"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="84"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00FFFF"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="85"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#FF4500"><up><b>".$arr['udata0']."</b></up></font></a>";}else{
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go">".$arr['udata0']."</a>";}
echo' (Уровень '.$arr['udata9'].' | PvP: '.number_format($arr['udata85']).' )';
}
$pr_q=mysql_query("SELECT * FROM `users` WHERE `udata67`!='200' and `udata67`!='777' order by `udata85` desc;");
$i=1;
while($pr_ar=mysql_fetch_array($pr_q))
{
if($pr_ar[udata0]==$log){
echo "<br><br>Вы находитесь на <b>".$i."</b> месте.";
}
$i=$i+1;
}
break;
case 'pk':
echo '<b>PK:</b><br/>';
$pr_q=mysql_query("SELECT * FROM `users` WHERE `udata67`!='200' and `udata67`!='777' order by `udata61` desc limit 10;");
while($arr=mysql_fetch_array($pr_q))
{
$aglava=mysql_query("SELECT * FROM `clan` WHERE `clan0`='$arr[udata23]' ");
$arrs= mysql_fetch_array($aglava);
$ggg=$arrs['clan2'];
echo "<br>";
if(!empty($ggg)){
echo"<img src="pic/clan/$ggg" alt="clan"/>";}
if($arr['udata86'] >= "1"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=red>".$arr['udata0']."</font></a>";}else
if($arr['udata67'] == "200"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=lime>".$arr['udata0']."</font></a>";}else
if($arr['udata67'] == "100"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=blue>".$arr['udata0']."</font></a>";}else
if($arr['udata75']=="vip"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=gold>".$arr['udata0']."</font></a>";}else
if($arr['udata25']!==""){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="".$arr['udata25'].""><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="80"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#008B8B"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="81"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00CDCD"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="82"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00EEEE"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="83"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00CDCD"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="84"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00FFFF"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="85"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#FF4500"><up><b>".$arr['udata0']."</b></up></font></a>";}else{
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go">".$arr['udata0']."</a>";}
echo' (Уровень '.$arr['udata9'].', PK: '.number_format($arr['udata61']).') ';
}
$pr_q=mysql_query("SELECT * FROM `users` WHERE `udata67`!='200' and `udata67`!='777' order by `udata61` desc;");
$i=1;
while($pr_ar=mysql_fetch_array($pr_q))
{
if($pr_ar[udata0]==$log){
echo "<br><br>Вы находитесь на <b>".$i."</b> месте.";
}
$i=$i+1;
}
break;
case 'pk_k':
echo '<b>PvP:</b><br/>';
$pr_q=mysql_query("SELECT * FROM `users` WHERE `udata67`!='200' and `udata67`!='777' order by `udata86` desc limit 10;");
while($arr=mysql_fetch_array($pr_q))
{
$aglava=mysql_query("SELECT * FROM `clan` WHERE `clan0`='$arr[udata23]' ");
$arrs= mysql_fetch_array($aglava);
$ggg=$arrs['clan2'];
echo "<br>";
if(!empty($ggg)){
echo"<img src="pic/clan/$ggg" alt="clan"/>";}
if($arr['udata86'] >= "1"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=red>".$arr['udata0']."</font></a>";}else
if($arr['udata67'] == "200"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=lime>".$arr['udata0']."</font></a>";}else
if($arr['udata67'] == "100"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=blue>".$arr['udata0']."</font></a>";}else
if($arr['udata75']=="vip"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=gold>".$arr['udata0']."</font></a>";}else
if($arr['udata25']!==""){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="".$arr['udata25'].""><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="80"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#008B8B"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="81"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00CDCD"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="82"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00EEEE"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="83"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00CDCD"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="84"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00FFFF"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="85"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#FF4500"><up><b>".$arr['udata0']."</b></up></font></a>";}else{
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go">".$arr['udata0']."</a>";}
echo' (Уровень '.$arr['udata9'].', Карма: '.number_format($arr['udata86']).') ';
}
$pr_q=mysql_query("SELECT * FROM `users` WHERE `udata67`!='200' and `udata67`!='777' order by `udata86` desc;");
$i=1;
while($pr_ar=mysql_fetch_array($pr_q))
{
if($pr_ar[udata0]==$log){
echo "<br><br>Вы находитесь на <b>".$i."</b> месте.";
}
$i=$i+1;
}
break;
case 'coin':
echo '<b>Монеты удачи:</b><br/>';
$pr_q=mysql_query("SELECT * FROM `users` WHERE `udata67`!='200' and `udata67`!='777' order by `udata38` desc limit 10;");
while($arr=mysql_fetch_array($pr_q))
{
$aglava=mysql_query("SELECT * FROM `clan` WHERE `clan0`='$arr[udata23]' ");
$arrs= mysql_fetch_array($aglava);
$ggg=$arrs['clan2'];
echo "<br>";
if(!empty($ggg)){
echo"<img src="pic/clan/$ggg" alt="clan"/>";}
if($arr['udata86'] >= "1"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=red>".$arr['udata0']."</font></a>";}else
if($arr['udata67'] == "200"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=lime>".$arr['udata0']."</font></a>";}else
if($arr['udata67'] == "100"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=blue>".$arr['udata0']."</font></a>";}else
if($arr['udata75']=="vip"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=gold>".$arr['udata0']."</font></a>";}else
if($arr['udata25']!==""){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="".$arr['udata25'].""><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="80"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#008B8B"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="81"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00CDCD"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="82"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00EEEE"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="83"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00CDCD"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="84"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00FFFF"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="85"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#FF4500"><up><b>".$arr['udata0']."</b></up></font></a>";}else{
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go">".$arr['udata0']."</a>";}
echo' (Уровень '.$arr['udata9'].', Монет Удачи: '.number_format($arr['udata38']).') ';
}
$pr_q=mysql_query("SELECT * FROM `users` WHERE `udata67`!='200' and `udata67`!='777' order by `udata38` desc;");
$i=1;
while($pr_ar=mysql_fetch_array($pr_q))
{
if($pr_ar[udata0]==$log){
echo "<br><br>Вы находитесь на <b>".$i."</b> месте.";
}
$i=$i+1;
}
break;
case 'battle':
echo '<b>Бои:</b><br/>';
$pr_q=mysql_query("SELECT * FROM `users` WHERE `udata67`!='200' and `udata67`!='777' order by `udata6` desc limit 10;");
while($arr=mysql_fetch_array($pr_q))
{
$aglava=mysql_query("SELECT * FROM `clan` WHERE `clan0`='$arr[udata23]' ");
$arrs= mysql_fetch_array($aglava);
$ggg=$arrs['clan2'];
echo "<br>";
if(!empty($ggg)){
echo"<img src="pic/clan/$ggg" alt="clan"/>";}
if($arr['udata86'] >= "1"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=red>".$arr['udata0']."</font></a>";}else
if($arr['udata67'] == "200"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=lime>".$arr['udata0']."</font></a>";}else
if($arr['udata67'] == "100"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=blue>".$arr['udata0']."</font></a>";}else
if($arr['udata75']=="vip"){
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color=gold>".$arr['udata0']."</font></a>";}else
if($arr['udata25']!==""){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="".$arr['udata25'].""><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="80"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#008B8B"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="81"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00CDCD"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="82"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00EEEE"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="83"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00CDCD"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="84"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#00FFFF"><up>".$arr['udata0']."</up></font></a>";}else
if($arr['udata9']=="85"){
echo"<a href="search.php?&nick=".$arr['udata0']."&go=go"><font color="#FF4500"><up><b>".$arr['udata0']."</b></up></font></a>";}else{
echo "<a href="search.php?&nick=".$arr['udata0']."&go=go">".$arr['udata0']."</a>";}
echo' (Уровень '.$arr['udata9'].', Выиграно боев : '.number_format($arr['udata6']).') ';
}
$pr_q=mysql_query("SELECT * FROM `users` WHERE `udata67`!='200' and `udata67`!='777' order by `udata6` desc;");
$i=1;
while($pr_ar=mysql_fetch_array($pr_q))
{
if($pr_ar[udata0]==$log){
echo "<br><br>Вы находитесь на <b>".$i."</b> месте.";
}
$i=$i+1;
}
break;
case 'c_rep':
echo 'Рейтинга кланов (по клановым очкам)<br/>';
$pr_q=mysql_query("SELECT * FROM `clan` order by `clan11` desc limit 10;");
$i=1;
while($pr_ar=mysql_fetch_array($pr_q))
{
$ggg=$pr_ar['clan2'];
$pt = mysql_query("SELECT * FROM `clan_people` where `clan_people1`='$pr_ar[clan1]' ;");
$pts = mysql_num_rows($pt);
$clan9=$pr_ar['clan11'];
echo "<br><b>$i.</b><a href="search.php?&nick=".$pr_ar['clan0']."&go=clan"><b>".$pr_ar['clan1']."</b></a>";$sss=$arr['udata23'];
if(!empty($ggg)){
echo" <img src="pic/clan/$ggg" alt="clan"/>";} echo"<br> Глава: <a href="search.php?&nick=".$pr_ar['clan0']."&go=go">".$pr_ar['clan0']." </a><br> Репутация: "; echo number_format( $clan9 ); echo"<br>Человек в клане: $pts";
$i=$i+1;
}
break;
case 'c_exp':
echo 'Рейтинга кланов (по клановому опыту)<br/>';
$pr_q=mysql_query("SELECT * FROM `clan` order by `clan8` desc limit 10;");
$i=1;
while($pr_ar=mysql_fetch_array($pr_q))
{
$ggg=$pr_ar['clan2'];
$pt = mysql_query("SELECT * FROM `clan_people` where `clan_people1`='$pr_ar[clan1]' ;");
$pts = mysql_num_rows($pt);
$clan9=$pr_ar['clan11'];
echo "<br><b>$i.</b>";if(!empty($ggg)){
echo" <img src="pic/clan/$ggg" alt="clan"/> ";}echo"<a href="search.php?&nick=".$pr_ar['clan0']."&go=clan"><b>".$pr_ar['clan1']."</b></a>";$sss=$arr['udata23'];
echo" (Глава: <a href="search.php?&nick=".$pr_ar['clan0']."&go=go">".$pr_ar['clan0']." </a> | Опыт: ".number_format( $pr_ar['clan8'] ).")";
$i=$i+1;
}
break;
case 'c_mon':
echo 'Рейтинга кланов (по клановому капиталу)<br/>';
$pr_q=mysql_query("SELECT * FROM `clan` order by `clan4` desc limit 10;");
$i=1;
while($pr_ar=mysql_fetch_array($pr_q))
{
$ggg=$pr_ar['clan2'];
echo "<br><b>$i.</b>";if(!empty($ggg)){
echo" <img src="pic/clan/$ggg" alt="clan"/> ";}echo"<a href="search.php?&nick=".$pr_ar['clan0']."&go=clan"><b>".$pr_ar['clan1']."</b></a>";$sss=$arr['udata23'];
echo" (Глава: <a href="search.php?&nick=".$pr_ar['clan0']."&go=go">".$pr_ar['clan0']." </a> | Капитал: ".number_format( $pr_ar['clan4'] ).")";
$i=$i+1;
}
break;
}
}
include_once"files/down.php";
?>