Файл: vitaliy_nosov/public_html/game/clan/invite.php
Строк: 66
<?php
require_once ('../../config/func.php');
$title = 'Заявки в клан';
require_once ('../../config/header.php');
echo auth();
if($user['clan_dol'] != 3){
header('Location: /my_clan/');
exit();
}
$clan = mysql_fetch_assoc(mysql_query("SELECT * FROM `clan`
WHERE `id` = '".$user['clan']."'"));
$has = mysql_result(mysql_query("SELECT COUNT(*) FROM `clan_inv` WHERE `clan` = '".$clan['id']."'"), 0);
$max = 10;
$k_post = mysql_result(mysql_query("SELECT COUNT(id) FROM `clan_inv` WHERE `clan` = '".$user['clan']."'"),0);
$k_page = k_page($k_post,$max);
$page = page($k_page);
$start = $max*$page-$max;
$q = mysql_query("SELECT * FROM `clan_inv` WHERE `clan` = '".$user['clan']."' ORDER BY `id` DESC LIMIT $start, $max");
if($k_post < 1){
echo ' <div class="block center"> Новых заявок нет</div>';
}
while($inv = mysql_fetch_assoc($q)) {
$us = mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = '".$inv['user_id']."'"));
if($us['online'] > time() - 60) $online = 'user.png';
if($us['online'] < time() - 60) $online = 'user_off.png';
if (isset($user) && isset($_GET['no'])){
$id_no = htmlspecialchars($_GET['id']);
mysql_query("DELETE FROM `clan_inv` where `id` = '".$id_no."'");
$_SESSION['notif'] = 'Заявка отклонена';
header('Location: ?');
exit();
}
if (isset($user) && isset($_GET['yes'])){
$text = ' <a href="/pers/'.$us['id'].'/"><img src="/style/'.$online.'"> <font color="'.$us['color'].'"> '.$us['login'].'</font> </a> вступил в клан';
$id = htmlspecialchars($_GET['id']);
mysql_query("UPDATE `user` SET `clan` = '".$user['clan']."' WHERE `id` = '".$us['id']."'");
mysql_query("INSERT INTO `clan_log` SET `clan_id` = '".$user['clan']."', `text` = '".$text."', `time` = '".time()."'");
mysql_query("DELETE FROM `clan_inv` where `id` = '".$id."'");
$_SESSION['notif'] = 'Заявка одобрена';
header('Location: ?');
exit();
}
echo ' <div class="block"><a href="/pers/'.$us['id'].'/"> <img src="/style/'.$online.'"> '.$us['login'].'</a> хочет вступить в клан </br>
<a href="?yes&id='.$inv['id'].'"> Принять | <a href="?no&id='.$inv['id'].'"> Отклонить</a></div>';
}
require_once ('../../config/footer.php');
?>