<?
/*---------------DCMS.SU---------------//
*	 Версия: 5.5
* 	Используя данный скрипт, Вы, согласны с Лицензионным соглашением.
* 	Официальный сайт: http://master.dcms.su/
* 	Поддержка: http://master.dcms.su/forum/
* 	ICQ: 69-77-02
/*---------------DCMS.SU---------------*/
define("BASEDIR","../");
include_once '../system/set.php';      // загрузка настроек системы
include_once '../system/system.php';   // Получение общих данных
include_once '../system/errors.php';   // Ошибки

only_level(1);

$set['title']='Оптимизация форума'; // заголовок страницы
$set['mesto']='Оптимизация форума'; // заголовок страницы (Для "кто-где")

theme_head(); // Верх страницы
title('Оптимизация форума','no');



if (isset($_GET['del']))
{
$q = mysql_query("SELECT id_f FROM `forum_r`",$db);
while ($forum_r = mysql_fetch_array($q))
{
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_f` WHERE `id` = '$forum_r[id_f]' LIMIT 1"),0)==0)
mysql_query("DELETE FROM `forum_r` WHERE `id` = '$forum_r[id]' LIMIT 1");
}
$q = mysql_query("SELECT id,id_f,id_r,id_user,id_user_last FROM `forum_t`",$db);
while ($forum_t = mysql_fetch_array($q))
{
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_r` WHERE `id` = '$forum_t[id_r]' LIMIT 1"),0)==0
|| mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_f` WHERE `id` = '$forum_t[id_f]' LIMIT 1"),0)==0)
mysql_query("DELETE FROM `forum_t` WHERE `id` = '$forum_t[id]' LIMIT 1");
}
$q = mysql_query("SELECT id,id_f,id_r,id_t,id_user,m_id_user FROM `forum_p`",$db);
while ($forum_p = mysql_fetch_array($q))
{
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_t` WHERE `id` = '$forum_p[id_t]' LIMIT 1"),0)==0
|| mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_r` WHERE `id` = '$forum_p[id_r]' LIMIT 1"),0)==0
|| mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_f` WHERE `id` = '$forum_p[id_f]' LIMIT 1"),0)==0
|| $forum_p['m_id_user']!=0 && mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `id` = '$forum_p[m_id_user]' LIMIT 1"),0)==0)
mysql_query("DELETE FROM `forum_p` WHERE `id` = '$forum_p[id]' LIMIT 1");
}
mysql_query("OPTIMIZE TABLE `forum_p` , `forum_t`, `forum_r`",$db);
mess ("Оптимизация успешно произведена");
}
aut(); // форма авторизации


$p_b_t=0;
$p_b_r=0;
$p_b_f=0;
$p_b_u=0;
$q = mysql_query("SELECT id_f,id_r,id_t,id_user,m_id_user FROM `forum_p`",$db);
while ($forum_p = mysql_fetch_array($q))
{
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_t` WHERE `id` = '$forum_p[id_t]' LIMIT 1"),0)==0)$p_b_t++;
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_r` WHERE `id` = '$forum_p[id_r]' LIMIT 1"),0)==0)$p_b_r++;
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_f` WHERE `id` = '$forum_p[id_f]' LIMIT 1"),0)==0)$p_b_f++;
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `id` = '$forum_p[id_user]' LIMIT 1"),0)==0)$p_b_u++;
if ($forum_p['m_id_user']!=0 && mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `id` = '$forum_p[m_id_user]' LIMIT 1"),0)==0)$p_b_u++;
}
$t_b_r=0;
$t_b_f=0;
$t_b_u=0;
$q = mysql_query("SELECT id_f,id_r,id_user,id_user_last FROM `forum_t`",$db);
while ($forum_t = mysql_fetch_array($q))
{
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_r` WHERE `id` = '$forum_t[id_r]' LIMIT 1"),0)==0)$t_b_r++;
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_f` WHERE `id` = '$forum_t[id_f]' LIMIT 1"),0)==0)$t_b_f++;
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `id` = '$forum_t[id_user]' LIMIT 1"),0)==0)$t_b_u++;
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `users` WHERE `id` = '$forum_t[id_user_last]' LIMIT 1"),0)==0)$t_b_u++;
}
$r_b_f=0;
$q = mysql_query("SELECT id_f FROM `forum_r`",$db);
while ($forum_r = mysql_fetch_array($q))
{
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_f` WHERE `id` = '$forum_r[id_f]' LIMIT 1"),0)==0)$r_b_f++;
}
echo "Постов без тем: $p_b_t<br />\n";
echo "Постов без разделов: $p_b_r<br />\n";
echo "Постов без форумов: $p_b_f<br />\n";
//echo "Постов без юзеров: $p_b_u<br />\n";
echo "Тем без разделов: $t_b_r<br />\n";
echo "Тем без форумов: $t_b_f<br />\n";
//echo "Тем без юзеров: $t_b_u<br />\n";
echo "Разделов без форумов: $r_b_f<br />\n";
if ($p_b_t!=0 || $p_b_r!=0 || $p_b_f!=0 || $t_b_r!=0 || $t_b_f!=0 || $r_b_f!=0)
echo "Необходимо <a href=\"optim_f.php?del\">удалить</a> ненужные данные<br />\n";
else echo "Оптимизация не требуется<br />\n";


navigation();   // навигация
theme_foot();   // Низ страницы
?>