Файл: wenr.online/app/clan/clan.php
Строк: 49
<?php
if (!$user->isAuth()) {
redirect('/');
exit;
}
$id = Clean :: int($_GET['id']);
$clan = $db->prepare('select * from clan where id = ?');
$clan -> execute([$id]);
$clan = $clan -> fetch(PDO :: FETCH_OBJ);
if(!isset($clan->id) or $clan->id == $user->get()->clan){
redirect('/clan');
exit;
}
$all = $db->prepare('select nick,user_id,lvl from users where clan = ? order by lvl');
$all -> execute([$clan->id]);
$all = $all->fetchAll();
if(isset($_GET['inv'])){
if($user->get()->clan != 0){
Notif :: error('Вы уже состоите в клане','/clan');
exit;
}
if(count($all) == 50){
Notif :: error('В клане нет места','/clan/view?id='.$clan->id);
exit;
}
$del = $db->prepare('delete from clan_invite where user = ?');
$del -> execute([$user->get()->user_id]);
$sql = $db->prepare('insert into clan_invite (user,clan,time) values (?,?,?)');
$sql -> execute([$user->get()->user_id,$clan->id,time()]);
Notif :: message('Заявка на вступление в клан успешно отправлена','/clan/view?id='.$clan->id);
exit;
}
$peger = new ArrayPaginator('/clan/view?id='.$clan->id, 10);
$items = $peger->getItems($all);
$invite = $db->prepare('select id from clan_invite where clan = ?');
$invite -> execute([$clan->id]);
echo $template->render('clan.clan', ['clan'=>$clan,'items'=>$items, 'peger'=>$peger,'invite'=>$invite->rowCount()]);