View file xhata.us/adm_panel/lenta.php

<?
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/adm_check.php';
include_once '../sys/inc/user.php';
user_access('adm_mysql',null,'index.php?'.SID);
adm_check();
$set['title']='Очистка Ленты';
include_once '../sys/inc/thead.php';
title();



if (user_access('adm_mysql')){

if (isset($_POST['write']) && isset($_POST['write2']))

{

$timeclear1=0;

if ($_POST['write2']=='sut')$timeclear1=$time-intval($_POST['write'])*60*60*24;

if ($_POST['write2']=='mes')$timeclear1=$time-intval($_POST['write'])*60*60*24*30;

$q = mysql_query("SELECT * FROM `lenta` WHERE `time` < '".mysql_real_escape_string($timeclear1)."'",$db);

$del_th=0;

while ($post = mysql_fetch_assoc($q))

{

mysql_query("DELETE FROM `lenta` WHERE `id` = '".mysql_real_escape_string($post[id])."'",$db);

$del_th++;

}


mysql_query("OPTIMIZE TABLE `lenta`",$db);

msg ("Удалено $del_th уведомлений");

}

}


err();
////aut(); // надо уже знать, что это такое
echo "<div class='rekl_main'>\n";
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `lenta`"),0);
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
echo "<div class='title'><center>Всего уведомлений: $k_post </center></div>\n";
echo "<table class='post'>\n";
if ($k_post==0)
{
echo "   <tr>\n";
echo "  <td class='p_t'>\n";
echo "Нет сообщений\n";
echo "  </td>\n";
echo "   </tr>\n";
}
$q=mysql_query("SELECT * FROM `lenta` ORDER BY id DESC LIMIT $start, $set[p_str]");


while ($post = mysql_fetch_assoc($q))
{
if ($post['id_user']==0)
{
$ank['id']=0;
$ank['pol']='lenta';
$ank['level']=0;
}
else
$ank=get_user($post['id_user']);
$ank2=get_user($post['id_kont']);


echo "  </td>\n";
echo "   </tr>\n";
echo "   <tr>\n";

}

if (user_access('adm_mysql'))

{

if (isset($_GET['act']) && mysql_real_escape_string($_GET['act'])=='create')

{

echo "<form method=\"post\" class='rekl_main' action=\"?\">\n";

echo "Будут удалены уведомления, написанные ... тому назад<br />\n";

echo "<input name=\"write\" value=\"12\" type=\"text\" size='3' />\n";

echo "<select name=\"write2\">\n";

echo "<option value=\"\">       </option>\n";

echo "<option value=\"mes\">Месяцев</option>\n";

echo "<option value=\"sut\">Суток</option>\n";

echo "</select><br />\n";

echo "<input value=\"Очистить\" type=\"submit\" /><br />\n";

echo "<a href=\"?\">Отмена</a><br />\n";

echo "</form>\n";

}

}
echo "<div class=\"gmenu\">\n";

echo "<a href=\"?act=create\">Очистить ленту (по времени)</a><br />\n";

echo "</div>\n";
if (user_access('adm_panel_show')){
echo "<div class='aut'>\n";
echo "&laquo;<a href='/adm_panel/uved_delite.php''>к выбору</a><br />\n";
echo "</div>\n";
}
include_once '../sys/inc/tfoot.php';
?>