Файл: wenr.online/app/clan/index.php
Строк: 99
<?php
if (!$user->isAuth()) {
redirect('/');
exit;
}
function count_clan($clan){
global $db;
return $db->query('select user_id from users where clan = '.$clan)->rowCount();
}
if($user->get()->clan == 0){
$sort = 'rating';
if($_GET['type'] == 'bonus') $sort = 'attack+def+lucky';
$all = $db->prepare('select * from clan order by '.$sort.' desc');
$all -> execute();
$all = $all->fetchAll();
$peger = new ArrayPaginator('/clan/top', 5);
$items = $peger->getItems($all);
echo $template->render('clan.top', ['items'=>$items, 'peger'=>$peger]);
}
else{
$clan = $db->prepare('select * from clan where id = ?');
$clan -> execute([$user->get()->clan]);
$clan = $clan -> fetch(PDO :: FETCH_OBJ);
if(isset($_GET['out'])){
if($user->get()->clan == $clan->user){
redirect('/clan');
exit;
}
if($user->get()->user_id == $clan -> zam){
$out = $db->prepare('update clan set zam = ? where id = ?');
$out ->execute([0,$clan->id]);
}
$out = $db->prepare('update users set clan = ? where user_id = ?');
$out ->execute([0,$user->get()->user_id]);
Notif :: message('Вы покинули клан «'.$clan->name.'»','/clan');
exit;
}
if(isset($_GET['kick'])){
if($user->get()->user_id != $clan->user){
redirect('/clan');
exit;
}
if($user->get($_GET['kick'])->clan != $clan->id or $user->get($_GET['kick'])->user_id == $user->get()->user_id){
redirect('/clan');
exit;
}
if($user->get($_GET['kick'])->user_id == $clan -> zam){
$out = $db->prepare('update clan set zam = ? where id = ?');
$out ->execute([0,$clan->id]);
}
$out = $db->prepare('update users set clan = ? where user_id = ?');
$out ->execute([0,$user->get($_GET['kick'])->user_id]);
notifSend($_GET['kick'],'Вас выгнали из клана «'.$clan->name.'»');
redirect('/clan');
exit;
}
if(isset($_GET['captain'])){
if($user->get()->user_id != $clan->user){
redirect('/clan');
exit;
}
if($user->get($_GET['captain'])->clan != $clan->id or $user->get($_GET['captain'])->user_id == $user->get()->user_id){
redirect('/clan');
exit;
}
$out = $db->prepare('update clan set zam = ? where id = ?');
$out ->execute([$user->get($_GET['captain'])->user_id,$clan->id]);
notifSend($_GET['captain'],'Вас назначили капитаном в клане «'.$clan->name.'»');
redirect('/clan?wdaw');
exit;
}
$all = $db->prepare('select * from users where clan = ? order by lvl');
$all -> execute([$clan->id]);
$all = $all->fetchAll();
$peger = new ArrayPaginator('/clan', 10);
$items = $peger->getItems($all);
$invite = $db->prepare('select id from clan_invite where clan = ?');
$invite -> execute([$clan->id]);
$clanwar = $db->prepare('select * from clanwar where clan1 = ? and win = ? or clan2 = ? and win = ?');
$clanwar -> execute([$clan->id,0,$clan->id,0]);
$clanwar = $clanwar -> fetch(PDO :: FETCH_OBJ);
echo $template->render('clan.my', ['clan'=>$clan,'items'=>$items, 'peger'=>$peger,'invite'=>$invite->rowCount(),'clanwar'=> $clanwar]);
}