Файл: vxas.ru/adm_panel/lenta.php
Строк: 106
<?
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 "«<a href='/adm_panel/uved_delite.php''>к выбору</a><br />n";
echo "</div>n";
}
include_once '../sys/inc/tfoot.php';
?>