Файл: group_admins.php
Строк: 335
<?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");
switch($_GET[go]){
default:
$req = mysql_query("SELECT * FROM `turaga_clan` WHERE `lider` = '$nick'");
////////////////////////////
$lider=mysql_num_rows($req);
if($lider==0){
echo'Ошибка!<br/>';
include ("niz/niz.php");
exit;
}
$req = mysql_query("SELECT * FROM `turaga_clan` WHERE `lider` = '$nick'");
////////////////////////////
$lider=mysql_num_rows($req);
if($lider==1){
echo"» <a href="group_admins.php?go=prs">Пригласить в группировку</a><br/>";
echo"» <a href="group_admins.php?go=dels&ask">Удалить группировку</a><br/>";
echo"» <a href="group_admins.php?go=rassulka">Раcсылка группировке</a><br/>";
echo"» <a href="group_admins.php?go=clans">Cписок группировцев</a><br/>";
}
break;
case 'dels':
$req = mysql_query("SELECT * FROM `turaga_clan` WHERE `lider` = '$nick'");
////////////////////////////
$lider=mysql_num_rows($req);
if($lider==0){
echo'Ошибка!<br/>';
include ("niz/niz.php");
exit;
}
$req = mysql_query("SELECT * FROM `turaga_clan` WHERE `lider` = '$nick'");
////////////////////////////
$lider=mysql_num_rows($req);
if($lider==1){
if(isset($_GET['ask'])){
echo'Вы действительно хотите удалить группировку?<br/>';
echo"<a href="group_admins.php?go=dels"><b>ДА!</b></a><br/>";
echo"<a href="group_admins.php?">Нет, назад</a><br/>";
}else{
$req = mysql_query("SELECT `nick` FROM `turaga_pers` WHERE `clan` = '$nick' LIMIT 1");
// //////////////////////////
$avto = mysql_num_rows($req);
if ($avto == 1) {
while($claner = mysql_fetch_array($req)){
mysql_query("UPDATE `turaga_pers` SET `clan` = '' WHERE `clan` = '$clan'");
mysql_query("UPDATE `turaga_pers` SET `clan` = '' WHERE `nick` = '$claner[nick]'");
}
}
mysql_query("DELETE FROM `turaga_clanchat` WHERE `clan` = '$nick'");
mysql_query("DELETE FROM `turaga_clanlog` WHERE `clan` = '$nick'");
mysql_query("DELETE FROM `turaga_clan` WHERE `lider` = '$nick'");
mysql_query("DELETE FROM `turaga_invite` WHERE `clan` = '$nick'");
mysql_query("DELETE FROM `turaga_sklad_klana` WHERE `clan` = '$nick'");
echo'Группировка успешно удалена!<br/>';
}
}else{
echo'Доступ закрыт!';
}
break;
case 'rassulka':
$req = mysql_query("SELECT * FROM `turaga_clan` WHERE `lider` = '$nick'");
////////////////////////////
$lider=mysql_num_rows($req);
if($lider==0){
echo'Ошибка!<br/>';
include ("niz/niz.php");
exit;
}
if(empty($_POST['text'])){
echo "<form method="post" action="group_admins.php?go=rassulka">";
echo "Введите текст рассылки:<br/>";
echo "<textarea name="text" rows=5 cols=15 wrap="off"></textarea><br/><br/>";
echo "<input type="submit" value="Отправить" class="ibutton"></form>";
}else{
$text=htmlspecialchars($_POST[text]);
$req = mysql_query("SELECT `nick` FROM `turaga_pers` where `clan`='$clan'");
////////////////////////////
$avto=mysql_num_rows($req);
if($avto>=1){
$time = date("H:i d.m.y");
While($clan = mysql_fetch_array($req))
{
mysql_query("INSERT INTO `turaga_r` SET `user_from` = 'System', `user_to` = '$clan[nick]', `time` = '$time', `read` = 1, `mail_msg` = '$text'");
}
echo'Рассылка успешно отправлена!<br/><br/>';
echo"» <a href="group_mains.php?">Продолжить</a>";
}else{
echo'Нет игроков в вашей группировки!<br/>';
}
}
break;
case 'clans':
$req = mysql_query("SELECT * FROM `turaga_clan` WHERE `lider` = '$nick'");
////////////////////////////
$lider=mysql_num_rows($req);
if($lider==0){
echo'Ошибка!<br/>';
include ("niz/niz.php");
exit;
}
$req = mysql_query("SELECT * FROM `turaga_clan` WHERE `lider` = '$clan' ");
////////////////////////////
$cl = 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='$cl[lider]'"));
$req = mysql_query("SELECT `prava`,`status`,`nick`,`lvl` FROM `turaga_pers` WHERE `nick` = '$cl[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=$cl[lider]&go=go">$cl[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="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' and `nick`!='$clan' 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> [<a href="group_admins.php?go=delpers&usr=$clan[nick]">Выгнать</a>]<br/>";}else{
echo" <img src='/pictures/icons/up.png' alt='*'/> ".number_format ($clan[lvl])." <font color="lime"> On</font> [<a href="group_admins.php?go=delpers&usr=$clan[nick]">Выгнать</a>]<br/>";}
}
$q = mysql_query("SELECT COUNT(`clan`) FROM `turaga_pers` where `clan`='$nick'");
$kol = mysql_result($q, 0);
echo "- - -<br/>";
if($startan!= 0) $page2left = ' <a href= group_admins.php?go=clans&startan='. ($startan - 5) .'&page='.($page-1).'>'. ($page - 1) .'</a> | ';
if(empty($page)){$page=1;}
if($kol > $startan + 5) $page2right = ' | <a href= group_admins.php?go=clans&startan='. ($startan + 5) .'&page='. ($page+1) .'>'. ($page + 1) .'</a>';
echo $page2left.'<b>('.$page.')</b>'.$page1right.$page2right.'<br/>';
if ($startan != 0) {echo '<a href="group_admins.php?go=clans&startan='.($startan - 5).'&page='.($page-1).'">Назад</a> ';}
if ($kol > $startan + 5) {echo ' <a href="group_admins.php?go=clans&startan='.($startan + 5).'&page='.($page+1).'">Далее</a>';}
}else{
echo '<div class="bts"></div>';
echo"Нет группировцев<br/>";
}
break;
case 'delpers':
$req = mysql_query("SELECT * FROM `turaga_clan` WHERE `lider` = '$nick'");
////////////////////////////
$lider=mysql_num_rows($req);
if($lider==0){
echo'Ошибка!<br/>';
include ("niz/niz.php");
exit;
}
if(empty($_GET[usr])){
echo'Не выбран игрок!<br/>';
include ("niz/niz.php");
exit;
}
$req = mysql_query("SELECT * FROM `turaga_pers` WHERE `nick` = '".mysql_real_escape_string($_GET['usr'])."' LIMIT 1");
// //////////////////////////
$avto = mysql_num_rows($req);
if ($avto == 1) {
$claner = mysql_fetch_array($req);
mysql_query("UPDATE `turaga_pers` SET `clan` = '' WHERE `nick` = '".mysql_real_escape_string($_GET['usr'])."'");
$time = date("H:i d.m.y");
$text = "$nick исключил вас из группировки!";
mysql_query("INSERT INTO `turaga_r` SET `user_from` = 'System', `user_to` = '".mysql_real_escape_string($_GET['usr'])."', `time` = '$time', `read` = 1, `mail_msg` = '$text'");
}else{
echo'Нет такого игрока в вашей группировки!';
include ("niz/niz.php");
exit;
}
$time = date("H:i d.m.y"); mysql_query("INSERT INTO `turaga_clanchat` SET `clan` = '$clan', `usr` = 'System', `msg` = '$nick выгнал ".mysql_real_escape_string($_GET['usr'])." из группировки!', `time` = '$time'");
header ("Location: group_admins.php?go=clans");
include ("niz/niz.php");
exit;
break;
case 'prs':
$req = mysql_query("SELECT * FROM `turaga_clan` WHERE `lider` = '$nick'");
////////////////////////////
$lider=mysql_num_rows($req);
if($lider==0){
echo'Ошибка!<br/>';
include ("niz/niz.php");
exit;
}
if(empty($_POST[name]) or empty($_POST[text])){
echo "<form action="group_admins.php?go=prs" method="post">";
echo"Введите ник:<br/>";
echo"<input class='input' type="text" size="10" name="name" maxlength="10"/><br/>";
echo"Текст к приглашению:<br/>";
echo"<input class='input' type="text" size="15" name="text" maxlength="100"/><br/>";
echo '<input class="button" type="submit" value="Отослать" /></form>';
}else{
$name=htmlspecialchars($_POST[name]);
$text=htmlspecialchars($_POST[text]);
$req = mysql_query("SELECT `clan` FROM `turaga_pers` WHERE `nick` = '$name'");
////////////////////////////
$avto=mysql_num_rows($req);
$inv = mysql_fetch_array($req);
if($avto=="0"){
echo'Нет такого игрока!<br/>';
include ("niz/niz.php");
exit;
}
$req = mysql_query("SELECT * FROM `turaga_invite` WHERE `usr` = '$name' LIMIT 1");
////////////////////////////
$avto=mysql_num_rows($req);
if($avto==1){
echo'У персонажа уже есть приглашение в группировку!';
include ("niz/niz.php");
exit;
}
$log=$nick;
if($name==$log){
echo'Себе отправлять нельзя!<br/>';
include ("niz/niz.php");
exit;
}
if($inv[clan]==$log){
echo'Этот игрок и так в вашей группировке!<br/>';
include ("niz/niz.php");
exit;
}
if(!empty($inv[clan])){
echo'Этот игрок в другой группировке!<br/>';
include ("niz/niz.php");
exit;
}
mysql_query("INSERT INTO `turaga_invite` SET `clan` = '$nick',`usr` = '$name',`text` = '$text'");
echo"Приглашение для игрока <b>$name</b> отослано!";
}
}
}else{
echo "Пройдите авторизацию!";
echo "<hr><a href="index.php">На главную</a>";
}
include ("niz/niz.php");
?>