Файл: spam.php
Строк: 70
<?php
include ("niz/head.php");
include ("db_bse/bssest.php");
$g=mysql_query("SELECT * FROM `turaga_pers` WHERE `nick`='$nick' AND `pass`='$pass' LIMIT 1");
if(mysql_num_rows($g)==1){
include ("niz/verh.php");
switch($_GET[mod]){
default:
if($prava<'3'){
echo"<img src='/pictures/icons/no.png' alt='*'/> <font color=red><small>Ошибка!</small></font>";
include ("niz/niz.php");
exit;}
$koli4estvo = mysql_query("SELECT COUNT(`msg`) FROM `turaga_spams`;");
$online = mysql_result($koli4estvo, 0);
echo"Всего сообщений спама: <b>$online</b>";
if(empty($startan)) $startan = 0; $startan=intval($startan); if($startan<0) $startan=0; $num_msgs_an=5;
$data = mysql_query("SELECT * FROM turaga_spams ORDER by `id` DESC LIMIT $startan,$num_msgs_an");
while($dat = mysql_fetch_array( $data ))
{
$req = mysql_query("SELECT `prava`,`status` FROM `turaga_pers` WHERE `nick` = '$dat[nick]'");
$pic = mysql_fetch_array($req);
echo "<div class='bts'></div>Персонаж: <a href="nick_info.php?nick=$dat[nick]&go=go">$dat[nick]</a> ";
$req = mysql_query("SELECT `prava`,`status` FROM `turaga_pers` WHERE `nick` = '$dat[name]'");
$pic = mysql_fetch_array($req);
echo"<br/>Пожаловался на персонажа: <a href="nick_info.php?nick=$dat[name]&go=go">$dat[name]</a> ";
echo"<br/>За сообщение: $dat[msg]";
if($prava>=3){
echo" <a href="spam.php?mod=del_post&rs=$dat[id]"><img src="pictures/icons/zon.png"></a><br/>";
}
}
$q = mysql_query("SELECT COUNT(`id`) FROM `turaga_spams` ");
$kol = mysql_result($q, 0);
echo "<div class='bts'></div>";
if($startan!= 0) $page2left = ' <a href= spam.php?startan='. ($startan - 5) .'&page='.($page-1).'>'. ($page - 1) .'</a> | ';
if(empty($page)){$page=1;}
if($kol > $startan + 5) $page2right = ' | <a href= spam.php?startan='. ($startan + 5) .'&page='. ($page+1) .'>'. ($page + 1) .'</a>';
echo $page2left.'<b>('.$page.')</b>'.$page1right.$page2right.'<br/>';
if ($startan != 0) {echo '<a href="spam.php?startan='.($startan - 5).'&page='.($page-1).'">Назад</a> ';}
if ($kol > $startan + 5) {echo ' <a href="spam.php?startan='.($startan + 5).'&page='.($page+1).'">Далее</a>';}
break;
case 'del_post':
if($prava>=3)
{
if(empty($_GET[rs])){
echo"Невыбран пост!<br/>";
}else{
$asd = mysql_query("SELECT * FROM turaga_spams WHERE id='".mysql_real_escape_string($_GET['rs'])."' LIMIT 1");
$avto=mysql_num_rows($asd);
if($avto==0){
echo'Нет такого поста!<br/>';
}else{
mysql_query("DELETE FROM `turaga_spams` WHERE id='".mysql_real_escape_string($_GET['rs'])."' LIMIT 1");
header ("Location: spam.php");
}
}
}else{
echo "Ошибка!Доступ закрыт!";
}
}
}else{
echo "Пройдите авторизацию!";
echo "<hr><a href="index.php">На главную</a>";
}
include ("niz/niz.php");
?>