Файл: sys/delete_user_inc/files/default.php
Строк: 61
<?php
$res = $db->query('SELECT gl.id, gf.id AS id_file, ras FROM `gallery` gl
LEFT JOIN `gallery_foto` gf ON gf.`id_gallery` = gl.`id`
WHERE gl.`id_user`=?i', [$ank['id']])->row();
foreach ($res as $post) {
if (is_file(H . 'files/foto/' . $post['id'] . '.png')) {
unlink(H . 'files/foto/' . $post['id'] . '.png');
}
}
$db->query('DELETE FROM `forum_posts` WHERE `id_theme` IN (
SELECT `id` FROM `forum_themes` WHERE `id_user`=?i)', [$ank['id']]);
$res = $db->query('SELECT `id` FROM `obmennik_files` WHERE `id_user` =?i', [$ank['id']])->row();var_dump($res);
if (count($res)) {
foreach ($res as $row) {
if (is_file(H . 'sys/obmen/files/' . $row['id'] . '.dat')) {
unlink(H . 'sys/obmen/files/' . $row['id'] . '.dat');
}
}
}
if (is_file(H . 'files/avatars/' . $ank['id'] . '.png')) {
unlink(H . 'files/avatars/' . $ank['id'] . '.png');
}
// TODO: переделать движки таблиц на innodb
$db->query('DELETE forum_themes, forum_posts, f_journal
FROM forum_themes
JOIN forum_posts ON forum_themes.id_user=forum_posts.id_user
JOIN f_journal ON forum_themes.id_user=f_journal.id_user
WHERE forum_themes.id_user=?i', [$ank['id']]);
$db->query('DELETE guest, obmennik_files
FROM guest
JOIN obmennik_files ON guest.id_user=obmennik_files.id_user
WHERE guest.id_user=?i', [$ank['id']]);
$db->query('DELETE FROM `users_konts` WHERE `id_user`=?i OR `id_kont`=?i', [$ank['id'], $ank['id']]);
$db->query('DELETE FROM `mail` WHERE `id_user`=?i OR `id_kont`=?i', [$ank['id'], $ank['id']]);
$db->query('DELETE FROM `user_collision` WHERE `id_user`=?i OR `id_user2`=?i', [$ank['id'], $ank['id']]);
$db->query('DELETE `gallery_foto`, gallery_komm, gallery_rating, gallery
FROM gallery_foto
LEFT JOIN gallery_komm ON gallery_foto.id = gallery_komm.id_foto
LEFT JOIN gallery_rating ON gallery_foto.id_user = gallery_rating.id_foto
LEFT JOIN gallery ON gallery_foto.id_gallery = gallery.id
WHERE gallery_foto.id_user =?i', [$ank['id']]);
$db->query('DELETE FROM `ban` WHERE `id_user`=?i OR `id_ban`=?i', [$ank['id'], $ank['id']]);
$db->query('DELETE FROM `user` WHERE `id`=?i LIMIT ?i', [$ank['id'], 1]);
if (isset($_GET['all']) && count($collisions)>1) {
for ($i=1;$i<count($collisions);$i++) {
$db->query('DELETE FROM `ban` WHERE `id_user`=?i OR `id_ban`=?i', [$collisions[$i], $collisions[$i]]);
}
}