Файл: slando.icu/modules/flot/zayavki.php
Строк: 199
<?php
$mem_start = memory_get_usage();
require '../../system/func_for_game2.inc.php';
$clan=mysqli_fetch_array(mysqli_query($link,"SELECT * FROM `clans` WHERE `id`='".num($user['clan'])."'"));
if($clan['id']>0 and $user['clan_zvanie']>3){
head2('Заявки');
if (isset($_GET['act'])) {$mod=vvod($_GET['act']);} else {$mod="";}
switch($mod)
{
default:
echo'<div class="block1"><table class="center">
<tr><td><span class="tabact" >Входящие</span></td><td><a class="tab" href="/flot/zayavki?act=ish">Исходящие</a></td></tr></table>';
$kol_na_str=10;
$total = mysqli_num_rows(mysqli_query($link,"select * from `clans_prigl` where `id_clan`='".num($clan['id'])."' and `tip`='1' "));
$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;
$query = mysqli_query($link,"select * from `clans_prigl` where `id_clan`='".num($clan['id'])."' and `tip`='1' order by `id` desc limit ".$start.",".$kol_na_str);$n=0;
while($r = mysqli_fetch_array($query))
{
if($user['clan_zvanie']>1){$pov='<a class="chatsend" href="/flot/zayavki?act=del&id='.num($r['id']).'">'.img(100,'png').' </a> <a class="chatsend" href="/flot/zayavki?act=add&id='.num($r['id']).'">'.img(52,'png').'</a>';}else{$pov='';}
$suser=mysqli_fetch_array(mysqli_query($link,"SELECT id ,adm,sex,login,authtime FROM `users` WHERE `id`='".num($r['id_prigl'])."' "));$name = color_nick($suser['id']);
$logsend=$suser['adm'];$logadm=$suser['login'];$id_send=$suser['id'];
$name = color_nick($suser['login']);
echo'<div><a href="/anketa?id='.num($r['id_prigl']).'">'.sex($suser['sex']).''.$name.' </a> '.$pov.'</div>';
$n=$n+1;
}
if($n==0){echo'<div class="clrt2 center">Входящих заявок нет.</div>';}
navi($page, $count_pages, '/flot/build?page=');
echo'<a class="ssilki3" href="/flot/view">Назад</a>';
break;
case 'add':
if(isset($_GET['id'])){$id=num($_GET['id']);}else{$id=0;}
$zayavka=mysqli_fetch_array(mysqli_query($link,"SELECT * FROM `clans_prigl` WHERE `id`='$id' and `tip`='1' and `id_clan`='".num($clan['id'])."' "));
$user_msg=mysqli_fetch_array(mysqli_query($link,"SELECT id,login,clan FROM `users` WHERE `id`='".num($zayavka['id_prigl'])."'"));
if($zayavka['id']>0 and $user_msg['clan']==0 and $user['clan_zvanie']>1){
$maxuser=$clan['lvl']+2;
$user_in_clan=mysqli_num_rows(mysqli_query($link,"SELECT id FROM `users` WHERE `clan`='".num($clan['id'])."'"));
if ($user_in_clan+1 <= $maxuser)
{
if(!isset($_GET['ok'])){
echo'<div class="block1 clrt2 center">Принять в клан <span class="clrt0">'.$user_msg['login'].'</span> ?
<table class="center">
<tr><td width="50%"><a class="ssilki9" href="/flot/zayavki?act=add&id='.$id.'&ok">Да</a></td><td><a class="ssilki8" href="/flot/zayavki">Нет</a></td></tr>
</table> ';
}else{$timecl=time();
mysqli_query($link,"UPDATE `users` SET `clan`='".num($clan['id'])."',`clan_zvanie`='1',`clan_time`='$timecl',`opitvclan`='0',`resvclan`='0' WHERE id='".num($user_msg['id'])."'");
logi_clan(1,num($clan['id']),'[cvgame=/anketa?id='.$user['id'].']'.vivod($user['login']).'[/cvgame] принял в клан [cvgame=/anketa?id='.$user_msg['id'].']'.vivod($user_msg['login']).'[/cvgame]');
mysqli_query($link,"DELETE FROM `clans_prigl` WHERE `id_prigl` = '".num($user_msg['id'])."'");
go("/flot/zayavki");
}
}else{echo'<div class="block1">В клане нет свободного места.';}
}else{go("/flot/zayavki");}
break;
//////
case 'del':
if(isset($_GET['id'])){$id=num($_GET['id']);}else{$id=0;}
$zayavka=mysqli_fetch_array(mysqli_query($link,"SELECT * FROM `clans_prigl` WHERE `id`='$id' and `id_clan`='".num($clan['id'])."' "));
$user_msg=mysqli_fetch_array(mysqli_query($link,"SELECT id,login,clan FROM `users` WHERE `id`='".num($zayavka['id_prigl'])."'"));
if($zayavka['id']>0 and $user['clan_zvanie']>1){
if(!isset($_GET['ok'])){
echo'<div class="block1 clrt2 center">Удалить заявку о вступлении игрока <span class="clrt0">'.$user_msg['login'].'</span> ?
<table class="center">
<tr><td width="50%"><a class="ssilki9" href="/flot/zayavki?act=del&id='.$id.'&ok">Да</a></td><td><a class="ssilki8" href="/flot/zayavki">Нет</a></td></tr>
</table> ';
}else{
mysqli_query($link,"DELETE FROM `clans_prigl` WHERE `id_clan`='".num($clan['id'])."' and `id_prigl`= '".num($user_msg['id'])."'");
go("/flot/zayavki");
}
}else{go("/flot/zayavki");}
break;
//////
case 'ish':
echo'<div class="block1 left"><table class="center">
<tr><td><a class="tab" href="/flot/zayavki">Входящие</a></td><td><span class="tabact" >Исходящие</span></td></tr></table>';
$kol_na_str=10;
$total = mysqli_num_rows(mysqli_query($link,"select * from `clans_prigl` where `id_clan`='".num($clan['id'])."' and `tip`='0' "));
$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;
$query = mysqli_query($link,"select * from `clans_prigl` where `id_clan`='".num($clan['id'])."' and `tip`='0' order by `id` desc limit ".$start.",".$kol_na_str);$n=0;
while($r = mysqli_fetch_array($query))
{
if($user['clan_zvanie']>1){$pov='<a class="chatsend" href="/flot/zayavki?act=del&id='.num($r['id']).'">'.img(100,'png').' </a>';}else{$pov='';}
$suser=mysqli_fetch_array(mysqli_query($link,"SELECT id ,sex,login,authtime,adm FROM `users` WHERE `id`='".num($r['id_prigl'])."' "));$name = color_nick($suser['id']);
$logsend=$suser['adm'];$logadm=$suser['login'];$id_send=$suser['id'];
$name = color_nick($suser['login']);
echo'<div ><a href="/anketa?id='.num($r['id_prigl']).'">'.sex($suser['sex']).''.$name.' </a> '.$pov.'</div>';
$n=$n+1;
}
if($n==0){echo'<div class="clrt2 center">Исходящих заявок нет.</div>';}
navi($page, $count_pages, '/flot/build?act=ish&page=');
echo'<a class="ssilki3" href="/flot/view">Назад</a>';
break;
}
}else{
go("/flot");}
foot();
?>