Файл: group_info.php
Строк: 229
<?php
include ("niz/head.php");
include ("db_bse/bssest.php");
$g=mysql_query("SELECT * FROM `turaga_pers` WHERE `nick`='$nick' AND `pass`='$pass' LIMIT 1");
if(mysql_num_rows($g)==1){
include ("niz/verh.php");
$req = mysql_query("SELECT * FROM `turaga_pers` WHERE `nick` = '$nick'");
////////////////////////////
$avto=mysql_num_rows($req);
if($avto=="0"){
echo'Нет такого персонажа!';
include ("niz/niz.php");
exit;
}
$usdata = mysql_fetch_array($req);
if(empty($_GET[id])){echo"Ошибка!";
include ("niz/niz.php");
exit;}
$req = mysql_query("SELECT * FROM `turaga_clan` where `id`='".mysql_real_escape_string($_GET['id'])."'");
$avto=mysql_num_rows($req);
if($avto==1){
$clan = mysql_fetch_array($req);
$req = mysql_query("SELECT nick FROM `turaga_pers` where `clan`='$clan[lider]'");
////////////////////////////
$kk=mysql_num_rows($req);
}else{
echo"Ошибка";
include ("niz/niz.php");
exit;
}
$nickas = strip_tags($clan[lider]);
$req = mysql_query("SELECT * FROM `turaga_pers` WHERE `nick` = '$nickas'");
$pic = mysql_fetch_array($req);
echo'Группировка:'; echo"<b> <font color="gold">$clan[name]</b></font><br/>";
echo'Основана:'; echo"<b> <font color="IndianRed1">$clan[reg]</b></font><br/>";
echo"В группировке: <font color="SeaGreen1">$kk</font> человек(а)<br/>";
echo"Опыт группировки: ".number_format ($clan[opts])." <img src='/pictures/icons/koza.gif' alt='*'/><br>";
echo"Казна: <img src='/pictures/icons/money.gif' alt='*'/> ".number_format ($clan[serebro])." <img src='/pictures/icons/coin.png' alt='*'/> ".number_format ($clan[gold])."<br>";
$ad=$clan[serebro]/$kk;
echo"Среднее количество <img src='/pictures/icons/money.gif' alt='*'/> серебра на 1 игрока <font color="IndianRed1">".number_format ($ad)."</font>";
echo '<div class="bts"></div>';
$req = mysql_query("SELECT * FROM `turaga_clan` WHERE `lider` = '$clan[lider]'");
////////////////////////////
$cl = mysql_fetch_array($req);
$nickas = strip_tags($clan[lider]);
$req = mysql_query("SELECT * FROM `turaga_pers` WHERE `nick` = '$nickas'");
$pic = mysql_fetch_array($req);
$laikas = 800;
$dabar = time();
$timeout = $dabar - $laikas;
$asd = mysql_num_rows(mysql_query("SELECT laikas, usr FROM turaga_online WHERE laikas > '$timeout' AND usr='$clan[lider]'"));
$req = mysql_query("SELECT `prava`,`status`,`nick`,`lvl`,`lvisit` FROM `turaga_pers` WHERE `nick` = '$clan[lider]' ");
$pic = mysql_fetch_array($req);
if ($pic['status']==0)echo "<img src='/pictures/status/on.gif' alt='' class='icon'/>";
else if ($pic['status']==1)echo "<img src='/pictures/status/gotov_boltat.png' alt='' class='icon'/>";
else if ($pic['status']==2)echo "<img src='/pictures/status/zaniat.png' alt='' class='icon'/>";
else if ($pic['status']==3)echo "<img src='/pictures/status/boleu.png' alt='' class='icon'/>";
else if ($pic['status']==4)echo "<img src='/pictures/status/depressia.png' alt='' class='icon'/>";
else if ($pic['status']==5)echo "<img src='/pictures/status/dumau.png' alt='' class='icon'/>";
else if ($pic['status']==6)echo "<img src='/pictures/status/kuru.png' alt='' class='icon'/>";
else if ($pic['status']==7)echo "<img src='/pictures/status/kushau.png' alt='' class='icon'/>";
else if ($pic['status']==8)echo "<img src='/pictures/status/love.png' alt='' class='icon'/>";
else if ($pic['status']==9)echo "<img src='/pictures/status/tv.png' alt='' class='icon'/>";
else if ($pic['status']==10)echo "<img src='/pictures/status/music.png' alt='' class='icon'/>";
else if ($pic['status']==11)echo "<img src='/pictures/status/vanna.png' alt='' class='icon'/>";
else if ($pic['status']==12)echo "<img src='/pictures/status/tualet.png' alt='' class='icon'/>";
else if ($pic['status']==13)echo "<img src='/pictures/status/sex.png' alt='' class='icon'/>";
else if ($pic['status']==14)echo "<img src='/pictures/status/igrau.png' alt='' class='icon'/>";
else if ($pic['status']==15)echo "<img src='/pictures/status/pivo.png' alt='' class='icon'/>";
else if ($pic['status']==16)echo "<img src='/pictures/status/sonni.png' alt='' class='icon'/>";
////////
else if ($pic['status']==17)echo "<img src='/pictures/status/1.png' alt='' class='icon'/>";
else if ($pic['status']==18)echo "<img src='/pictures/status/12.png' alt='' class='icon'/>";
else if ($pic['status']==19)echo "<img src='/pictures/status/13.png' alt='' class='icon'/>";
else if ($pic['status']==20)echo "<img src='/pictures/status/14.png' alt='' class='icon'/>";
else if ($pic['status']==21)echo "<img src='/pictures/status/18.png' alt='' class='icon'/>";
else if ($pic['status']==22)echo "<img src='/pictures/status/19.png' alt='' class='icon'/>";
else if ($pic['status']==23)echo "<img src='/pictures/status/31.png' alt='' class='icon'/>";
else if ($pic['status']==24)echo "<img src='/pictures/status/7.png' alt='' class='icon'/>";
echo " <a href="nick_info.php?nick=$clan[lider]&go=go">$clan[lider]</a> <img src='/pictures/icons/up.png' alt='*'/> ".number_format ($pic[lvl])." </b>";
if($asd==0){
echo"<font color="red"> Off</font> - <font color="IndianRed1">$pic[lvisit]</font> - <font color="gold">Глава группировки</font><br/>";}else{
echo" <font color="lime"> On</font> - <font color="gold">Глава группировки</font><br>";}
if(empty($startan)) $startan = 0;
$startan=intval($startan);
if($startan<0) $startan=0; $num_msgs_an=5;
$req = mysql_query("SELECT clan,nick,lvl,lvisit FROM `turaga_pers` where `clan`='$clan[lider]' and `nick`!='$clan[lider]' ORDER BY lvl DESC LIMIT $startan,$num_msgs_an");
echo '<div class="bts"></div>';
echo"Cписок группировцев:<br/>";
////////////////////////////
$avto=mysql_num_rows($req);
$i=1;
if($avto>=1){
While($clan = mysql_fetch_array($req))
{
$laikas = 800;
$dabar = time();
$timeout = $dabar - $laikas;
$asd = mysql_num_rows(mysql_query("SELECT laikas, usr FROM turaga_online WHERE laikas > '$timeout' AND usr='$clan[nick]' "));
echo" <a href="nick_info.php?nick=$clan[nick]&go=go">$clan[nick]</a>";
if($asd==0){
echo" <img src='/pictures/icons/up.png' alt='*'/> ".number_format ($clan[lvl])." <font color="red"> Off</font> - <font color="IndianRed1">$clan[lvisit]</font><br/>";}else{
echo" <img src='/pictures/icons/up.png' alt='*'/> ".number_format ($clan[lvl])." <font color="lime"> On</font><br/>";}
}
$q = mysql_query("SELECT COUNT(`clan`) FROM `turaga_pers` where `clan`='$clan[name]'");
$kol = mysql_result($q, 0);
echo "- - -<br/>";
if($startan!= 0) $page2left = ' <a href= group_info.php?id='.$id.'&startan='. ($startan - 5) .'&page='.($page-1).'>'. ($page - 1) .'</a> | ';
if(empty($page)){$page=1;}
if($kol > $startan + 5) $page2right = ' | <a href= group_info.php?id='.$id.'&startan='. ($startan + 5) .'&page='. ($page+1) .'>'. ($page + 1) .'</a>';
echo $page2left.'<b>('.$page.')</b>'.$page1right.$page2right.'<br/>';
if ($startan != 0) {echo '<a href="group_info.php?id='.$id.'&startan='.($startan - 5).'&page='.($page-1).'">Назад</a> ';}
if ($kol > $startan + 5) {echo ' <a href="group_info.php?id='.$id.'&startan='.($startan + 5).'&page='.($page+1).'">Далее</a>';}
}else{
echo '<div class="bts"></div>';
echo"Нет группировцев<br/>";
}
}else{
echo "Пройдите авторизацию!";
echo "<hr><a href="index.php">На главную</a>";
}
include ("niz/niz.php");
?>