Файл: users/forum/del_them_ok.php
Строк: 22
<?
$_SESSION['mother_them_del']=$forum['mother'];
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `name` = 'Песочница, Архив' AND `type` = 'forum' LIMIT 1"),0)==0)
{
mysql_query("INSERT INTO `forum` (`id_comm`, `mother`, `type`, `name`, `time`, `text`, `count`) values ('0', '0', 'forum', 'Песочница, Архив', '$time', '', '0')");
$id_forum=mysql_insert_id();
$id_forum=mysql_fetch_array(mysql_query("SELECT * FROM `forum` WHERE `id` = '$id_forum' AND `type` = 'forum' LIMIT 1"));
}
else $id_forum=mysql_fetch_array(mysql_query("SELECT * FROM `forum` WHERE `name` = 'Песочница, Архив' AND `type` = 'forum' LIMIT 1"));
if(mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `name` = 'Архив тем' AND `type` = 'razdel' AND `mother` = '$id_forum[id]' LIMIT 1"),0)==0)
{
mysql_query("INSERT INTO `forum` (`id_comm`, `type`, `name`, `time`, `text`, `count`, `mother`) values ('0', 'razdel', 'Архив тем', '$time', '', '$id_forum[count]/$id_forum[id]', '$id_forum[id]')");
$id_razdel=mysql_insert_id();
$id_razdel=mysql_fetch_array(mysql_query("SELECT * FROM `forum` WHERE `id` = '$id_razdel' AND `type` = 'razdel' AND `mother` = '$id_forum[id]' LIMIT 1"));
}
else $id_razdel=mysql_fetch_array(mysql_query("SELECT * FROM `forum` WHERE `name` = 'Архив тем' AND `type` = 'razdel' AND `mother` = '$id_forum[id]' LIMIT 1"));
$q = mysql_query("SELECT * FROM `forum_them_komm` WHERE `id_them` = '$forum[id]' AND `sled` = '1'");
while ($f = mysql_fetch_array($q))
{
$a=mysql_fetch_array(mysql_query("SELECT * FROM `user` WHERE `id` = '$f[id_user]' LIMIT 1"));
if($a['id']!=$user['id'] && $a['id']!=$forum['id_user'])
{
mysql_query("INSERT INTO `jurnal` (`id_user`, `id_kont`, `msg`, `time`) values('0', '$f[id_user]', 'Система оставила комментарий в теме [url=/users/forum/?id=$forum[id]]$forum[name][/url]', '$time')");
}
}
if($user['id']!=$forum['id_user'])
{
mysql_query("INSERT INTO `jurnal` (`id_user`, `id_kont`, `msg`, `time`) values('0', '$forum[id_user]', 'Система оставила комментарий к вашей теме [url=/users/forum/?id=$forum[id]]$forum[name][/url]', '$time')");
}
mysql_query("INSERT INTO `forum_komm` (`id_them`, `id_user`, `time`, `msg`, `sistem`, `razdel_to`, `razdel_at`, `who_moved`) values('$forum[id]', '0', '$time', 'Темa успешно перемещена!', '1', '$id_razdel[id]', '$forum[mother]', '$user[id]')");
mysql_query("INSERT INTO `forum_history` (`id_them`, `id_user`, `time`, `type`) values('$forum[id]', '$user[id]', '$time', 'del')");
mysql_query("UPDATE `forum` SET `mother` = '$id_razdel[id]', `up` = '0', `count` = '$id_razdel[count]/$id_razdel[id]', `close_id_user` = '$user[id]', `close` = '1', `time_obnov` = '$time' WHERE `id` = '$forum[id]' LIMIT 1");
$back=$_SESSION['mother_them_del'];
header("location: /users/forum/?id=$back");
?>