<?
include_once '../sys/inc/start.php';
include_once '../sys/inc/compress.php';
include_once '../sys/inc/sess.php';
include_once '../sys/inc/home.php';
include_once '../sys/inc/settings.php';
include_once '../sys/inc/db_connect.php';
include_once '../sys/inc/ipua.php';
include_once '../sys/inc/fnc.php';
include_once '../sys/inc/user.php';
user_access('user_delete', null, '/');
if($user['level'] <= 4){
header("Location: /");
exit;
}
if (isset($_GET['id'])){
$ank['id'] = intval($_GET['id']);
}
else {
$set['title'] = "Удаление юзера";
include_once '../sys/inc/thead.php';
shapka_VK(true, '/adm/', 'Удаление юзера');
if (isset($_POST['cfms'])){
$id = intval($_POST['id']);
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `id` = '$id' LIMIT 1"),0) == 0)
$err[] = 'Юзер с таким ID не обнаружен!';
if(!preg_match("#^([0-9\ ])+$#ui", $_POST['id']))
$err[] = 'Разрешено вводить только цифры!';
if (!$err){
header("Location: del_us.php?id=".$id."");
exit;
}
}
?>
<div class="basisDefault">
<div class="basisDefault__row">
<div class="Pad">
<?
uvedom();
if (isset($err)){
?>
<div class="Row Row_style_tinyPaddingBottom"><div class="Pad__alert Alert Alert_theme_warning">
<?
err();
?>
</div></div>
<?
}
?>
<div class="Pad__header Row"><h3 class="Pad__title">Введите ID юзера, которого будем удалять:</h3></div>
<div class="Pad__content">
<form action="del_us.php" method="POST">
<div class="Row">
<label class="Input Input_prefixed">
<div class="Input__prefix Input__prefix_gray">http://xmyx.ru/id</div>
<div class="Input__nativeWrap"><input class="Input__native" name="id" value="" autocapitalize="off"></div>
</label>
</div>
<div class="Row Row_style_tinyPaddingTop"><button class="Btn Btn_theme_regular" name="cfms" type="submit">Продолжить</button></div>
</form>
</div></div></div>
</div>
<?
include_once H.'sys/inc/tfoot.php';
exit;
}
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `id` = '$ank[id]' LIMIT 1"),0) == 0){
header("Location: /");
exit;
}
$ank = get_user($ank['id']);
$ank['nick'] = u_nick($ank['id']);
if ($user['level'] <= $ank['level'] || $user['id'] == $ank['id']){
header("Location: /");
exit;
}
$set['title'] = 'Удаление юзера '.$ank['nick'].'';
include_once '../sys/inc/thead.php';
shapka_VK(true, '/adm/del_us.php', 'Удаление '.$ank['nick'].'');
if (isset($_POST['dell'])){
if (function_exists('set_time_limit'))@set_time_limit(600);
$mass[0] = $ank['id'];
$collisions = user_collision($mass,1);
mysql_query("DELETE FROM `user` WHERE `id` = '$ank[id]' LIMIT 1");
mysql_query("DELETE FROM `user_gifts` WHERE `id_user` = '$ank[id]' OR `id_ank` = '$ank[id]'");
// Удаление бананов
mysql_query("DELETE FROM `ban` WHERE `id_user` = '$ank[id]' OR `id_ban` = '$ank[id]'");
mysql_query("DELETE FROM `user_set` WHERE `id_user` = '$ank[id]'");
// Фото
$gallery_q = mysql_query("SELECT * FROM `photos` WHERE `id_user` = '$ank[id]'");
while ($gallery = mysql_fetch_assoc($gallery_q))
{
$q = mysql_query("SELECT * FROM `photos_user` WHERE `id_album` = '$gallery[id]'");
while ($post = mysql_fetch_assoc($q))
{
@unlink(H."files/photos/size50/".$post['id'] . $post['hash'].".jpg");
@unlink(H."files/photos/size100/".$post['id'] . $post['hash'].".jpg");
@unlink(H."files/photos/size200/".$post['id'] . $post['hash'].".jpg");
@unlink(H."files/photos/original/".$post['id'] . $post['hash'].".jpg");
mysql_query("DELETE FROM `photos_user` WHERE `id` = '$post[id]' LIMIT 1");
mysql_query("DELETE FROM `photos_user_like` WHERE `id_photo` = '$post[id]'");
mysql_query("DELETE FROM `photos_count` WHERE `id_photo` = '$post[id]'");
mysql_query("DELETE FROM `photos_comm` WHERE `id_photo` = '$post[id]'");
}
}
mysql_query("DELETE FROM `photos` WHERE `id_user` = '$ank[id]'");
mysql_query("DELETE FROM `photos_comm` WHERE `id_user` = '$ank[id]'");
mysql_query("DELETE FROM `photos_user_like` WHERE `id_user` = '$ank[id]'");
mysql_query("DELETE FROM `photos_count` WHERE `id_user` = '$ank[id]'");
// Стена юзера
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `user_wall` WHERE `id_ank` = '".$ank['id']."' OR `id_user` = '".$ank['id']."'"), 0) > 0)
{
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `user_wall_komm` WHERE `id_ank` = '".$ank['id']."' OR `id_user` = '".$ank['id']."'"), 0) > 0)
{
mysql_query("DELETE FROM `user_wall_komm` WHERE `id_ank` = '".$ank['id']."' OR `id_user` = '".$ank['id']."'");
}
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `user_wall_files` WHERE `id_ank` = '".$ank['id']."' OR `id_user` = '".$ank['id']."'"), 0) > 0)
{
$q_f = mysql_query("SELECT * FROM `user_wall_files` WHERE `id_ank` = '".$ank['id']."' OR `id_user` = '".$ank['id']."'");
while ($post_f = mysql_fetch_array($q_f))
{
if (is_file(H.'files/wall/files/others/'.$post_f['id'].'.'.$post_f['ras'].''))
{
unlink(H.'files/wall/files/others/'.$post_f['id'].'.'.$post_f['ras'].'');
}
mysql_query("DELETE FROM `user_wall_files` WHERE `id` = '".$post_f['id']."' LIMIT 1");
}
}
mysql_query("DELETE FROM `user_wall` WHERE `id_ank` = '".$ank['id']."' OR `id_user` = '".$ank['id']."' LIMIT 1");
}
$user_wal = mysql_query("SELECT * FROM `user_wall` WHERE `id_user` = '$ank[id]'");
while ($user_wale = mysql_fetch_assoc($user_wal))
{
mysql_query("DELETE FROM `fave` WHERE `id_object` = '$user_wale[id]'");
}
mysql_query("DELETE FROM `user_wall_count` WHERE `id_ank` = '".$ank['id']."' OR `id_user` = '$ank[id]'");
mysql_query("DELETE FROM `user_wall_like` WHERE `id_user` = '$ank[id]'");
mysql_query("DELETE FROM `user_wall_komm` WHERE `id_user` = '$ank[id]'");
mysql_query("DELETE FROM `user_wall_komm_like` WHERE `id_user` = '$ank[id]'");
mysql_query("DELETE FROM `user_wall_repost` WHERE `id_user` = '$ank[id]' OR `id_ank` = '$ank[id]'");
mysql_query("DELETE FROM `fave` WHERE `id_object` = '$ank[id]'");
// Удаляет данные с групп, которые писал юзер
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `groups_wall` WHERE `id_user` = '".$ank['id']."'"), 0) > 0)
{
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `groups_wall_komm` WHERE `id_user` = '".$ank['id']."'"), 0) > 0)
{
mysql_query("DELETE FROM `groups_wall_komm` WHERE `id_user` = '".$ank['id']."'");
}
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `groups_files` WHERE `id_user` = '".$ank['id']."'"), 0) > 0)
{
$q_f = mysql_query("SELECT * FROM `groups_files` WHERE `id_user` = '".$ank['id']."' ORDER BY `time` DESC");
while ($post_f = mysql_fetch_array($q_f))
{
if (is_file(H.'files/groups/files/others/'.$post_f['id'].'.'.$post_f['ras'].''))
{
unlink(H.'files/groups/files/others/'.$post_f['id'].'.'.$post_f['ras'].'');
}
mysql_query("DELETE FROM `groups_files` WHERE `id` = '".$post_f['id']."' LIMIT 1");
}
}
mysql_query("DELETE FROM `groups_wall` WHERE `id_user` = '".$ank['id']."' LIMIT 1");
}
$groups_w = mysql_query("SELECT * FROM `groups_wall` WHERE `id_user` = '$ank[id]'");
while ($groups_e = mysql_fetch_assoc($groups_w))
{
mysql_query("DELETE FROM `fave` WHERE `id_object` = '$groups_e[id]'");
}
mysql_query("DELETE FROM `groups_wall_count` WHERE `id_user` = '$ank[id]'");
mysql_query("DELETE FROM `groups_wall_like` WHERE `id_user` = '$ank[id]'");
mysql_query("DELETE FROM `groups_users` WHERE `id_user` = '$ank[id]'");
mysql_query("DELETE FROM `groups_komm_like` WHERE `id_user` = '$ank[id]'");
mysql_query("DELETE FROM `groups_invite` WHERE `id_user` = '$ank[id]' OR `id_ank` = '$ank[id]'");
mysql_query("DELETE FROM `groups_board_komm` WHERE `id_user` = '$ank[id]'");
mysql_query("DELETE FROM `groups_board` WHERE `id_user` = '$ank[id]'");
mysql_query("DELETE FROM `group_wall_repost` WHERE `id_user` = '$ank[id]' OR `id_ank` = '$ank[id]'");
// Удаляет и группу, если юзера
mysql_query("DELETE FROM `groups` WHERE `id_user` = '$ank[id]'");
// Закладки, новости, уведомл
mysql_query("DELETE FROM `fave` WHERE `id_user` = '$ank[id]'");
mysql_query("DELETE FROM `tape_set` WHERE `id_user` = '$ank[id]'");
mysql_query("DELETE FROM `tape` WHERE `id_user` = '$ank[id]'");
mysql_query("DELETE FROM `tape` WHERE `avtor` = '$ank[id]'");
mysql_query("DELETE FROM `tape` WHERE `id_file` = '$ank[id]' AND `type` = 'frend'");
mysql_query("DELETE FROM `notifi` WHERE `id_user` = '$ank[id]'");
mysql_query("DELETE FROM `notifi` WHERE `avtor` = '$ank[id]'");
// Удаление друзей, заявок, подписок, общих
mysql_query("DELETE FROM `frends` WHERE `user` = '$ank[id]' OR `frend` = '$ank[id]'");
mysql_query("DELETE FROM `frends_new` WHERE `user` = '$ank[id]' OR `to` = '$ank[id]'");
// Почта
mysql_query("DELETE FROM `mail` WHERE `id_user` = '$ank[id]' OR `id_kont` = '$ank[id]'");
mysql_query("DELETE FROM `mail_important` WHERE `id_user` = '".$ank['id']."'");
$q = mysql_query("SELECT folder, tmp_name FROM mail_files_vk WHERE `id_user` = '".$ank['id']."'");
while($unlink = mysql_fetch_assoc($q))
unlink(H . 'mail/files/' . $unlink['folder'] . '/' . $unlink['tmp_name']);
mysql_query("DELETE FROM `mail_files_vk` WHERE `id_user` = '".$ank['id']."'");
mysql_query("DELETE FROM `users_konts` WHERE `id_user` = '$ank[id]' OR `id_kont` = '$ank[id]'");
mysql_query("DELETE FROM `user_voice` WHERE `id_user` = '$ank[id]' OR `id_kont` = '$ank[id]'");
mysql_query("DELETE FROM `user_collision` WHERE `id_user` = '$ank[id]' OR `id_user2` = '$ank[id]'");
mysql_query("DELETE FROM `votes_user` WHERE `u_id` = '$ank[id]'");
// Оптимизация удаленных таблиц
$tab = mysql_list_tables($set['mysql_db_name']);
for($i = 0; $i < mysql_num_rows($tab); $i++){
mysql_query("OPTIMIZE TABLE `".mysql_tablename($tab,$i)."`");
}
$_SESSION['message'] = 'Все данные о юзере '.$ank['nick'].' удалены.';
header("Location: /adm/");
exit;
}
$mass[0]=$ank['id'];
$collisions=user_collision($mass,1);
$files_mess = mysql_result(mysql_query("SELECT COUNT(*) FROM mail_files_vk WHERE `id_user` = '$ank[id]'"), 0);
$zakl_us = mysql_result(mysql_query("SELECT COUNT(*) FROM fave WHERE `id_user` = '$ank[id]'"), 0);
$fav_mess = mysql_result(mysql_query("SELECT COUNT(id) FROM mail_important WHERE `id_user` = '$ank[id]'"), 0);
$wall_mess = mysql_result(mysql_query("SELECT COUNT(*) FROM `user_wall` WHERE `id_ank` = '".$ank['id']."' OR `id_user` = '".$ank['id']."'"), 0);
$wall_gr_mess = mysql_result(mysql_query("SELECT COUNT(*) FROM `groups_wall` WHERE `id_user` = '".$ank['id']."'"), 0);
$mail = mysql_result(mysql_query("SELECT COUNT(*) FROM `mail` WHERE `id_user` = '$ank[id]' OR `id_kont` = '$ank[id]'"),0);
$k_groups = mysql_result(mysql_query("SELECT COUNT(*) FROM `groups_users` WHERE `id_user` = '".$ank['id']."'"), 0);
$album_q = mysql_query("SELECT * FROM `photos` WHERE `id_user` = '$ank[id]'");
$photo = 0;
while ($album = mysql_fetch_assoc($album_q))
{
$photo+=mysql_result(mysql_query("SELECT COUNT(*) FROM `photos_user` WHERE `id_album` = '$album[id]'"),0);
}
$wall_q = mysql_query("SELECT * FROM `user_wall` WHERE `id_ank` = '".$ank['id']."' OR `id_user` = '$ank[id]'");
$fil_wall = 0;
while ($walle = mysql_fetch_assoc($wall_q))
{
$fil_wall+=mysql_result(mysql_query("SELECT COUNT(*) FROM `user_wall_files` WHERE `id_user` = '$ank[id]' OR `id_ank` = '$ank[id]'"),0);
}
$wall_qgr = mysql_query("SELECT * FROM `groups_wall` WHERE `id_user` = '$ank[id]'");
$fil_wallgr = 0;
while ($wallegr = mysql_fetch_assoc($wall_qgr))
{
$fil_wallgr+=mysql_result(mysql_query("SELECT COUNT(*) FROM `groups_files` WHERE `id_user` = '$ank[id]'"),0);
}
?>
<div class="basisDefault">
<div class="basisDefault__row">
<div class="Pad">
<div class="Anchor Pad__anchor" id="change_dell"></div>
<div class="Pad__header Row"><h3 class="Pad__title">Удаляем юзера <?= $ank['nick']?></h3></div>
<div class="Pad__content">
<div class="Row" style="padding: 7px 16px;">
<div class="Row__label Row__label_mini">SMSок в почте:</div><div class="Row__labeledContent"><?= $mail?></div>
</div>
<div class="Row" style="padding: 7px 16px;">
<div class="Row__label Row__label_mini">Файлов в почте:</div><div class="Row__labeledContent"><?= $files_mess?></div>
</div>
<div class="Row" style="padding: 7px 16px;">
<div class="Row__label Row__label_mini">Фотографий:</div><div class="Row__labeledContent"><?= $photo?></div>
</div>
<div class="Row" style="padding: 7px 16px;">
<div class="Row__label Row__label_mini">Закладок:</div><div class="Row__labeledContent"><?= $zakl_us?></div>
</div>
<div class="Row" style="padding: 7px 16px;">
<div class="Row__label Row__label_mini">Записей на стенах:</div><div class="Row__labeledContent"><?= $wall_mess?></div>
</div>
<div class="Row" style="padding: 7px 16px;">
<div class="Row__label Row__label_mini">Файлов на стенах:</div><div class="Row__labeledContent"><?= $fil_wall?></div>
</div>
<div class="Row" style="padding: 7px 16px;">
<div class="Row__label Row__label_mini">Групп у юзера:</div><div class="Row__labeledContent"><?= $k_groups?></div>
</div>
<div class="Row" style="padding: 7px 16px;">
<div class="Row__label Row__label_mini">Записей в группах:</div><div class="Row__labeledContent"><?= $wall_gr_mess?></div>
</div>
<div class="Row" style="padding: 7px 16px;">
<div class="Row__label Row__label_mini">Файлов в группах:</div><div class="Row__labeledContent"><?= $fil_wallgr?></div>
</div>
<form action="?id=<?= $ank['id']?>" method="POST">
<div class="Row Row_style_tinyPaddingTop">
<button class="Btn Btn_theme_regular" name="dell" type="submit">Удалить страницу</button>
<a class="BtnStack__btn al_back Btn Btn_theme_link" href="del_us.php" role="button">Назад</a>
</div>
<div class="option_tip" style="margin: 0 15px 15px 15px;">* Удаленные данные невозможно будет восстановить!</div>
</form>
</div>
</div></div>
</div>
<?
include_once '../sys/inc/tfoot.php';
?>