Просмотр файла admin/com.php

<? $page_name="Админ-меню";  $dir='../'; include("../include/1.php"); require "../include/avto.php";

if(!isset($_SESSION['user_id']) or $me['admin']!=2)exit("Нету доступа!");

if(isset($_GET['id']))
{$id=$_GET['id'];$post_1=mysql_fetch_array(mysql_query("select * from `shurik_com` where id=$id"));
if(!isset($_POST['text'])){
echo '
<form action="com.php?id='.$id.'" method="post">
Текст<br/><textarea name="text" cols="25" rows="5">'.$post_1['text'].'</textarea><br/>
<input name="" type="submit" value="Редактировать"></form>';
}


if(isset($_POST['text']))
{$text=$_POST['text'];
$upd_com=mysql_query("update `shurik_com` set text='$text' where id=$id");
if($upd_com)echo "Коментарий отредактирован";
else echo "Ошибка".mysql_error();
echo "<br/><a href=com.php>назад</a>";
}

}


if(isset($_GET['del']))
{$id=$_GET['del'];$del_com=mysql_query("delete from `shurik_com` where id=$id limit 1");
if($del_com)echo "Коментарий удален";
else echo error("Коментарий не удален", '../');}

######

if(!isset($_GET['id']))
{

//////////////////////////////////////////
$num = 5;
@$page = $_GET['page'];
$result00 = mysql_query("SELECT COUNT(*) FROM `shurik_com`");
$temp = mysql_fetch_array($result00);
if($temp[0] == 0)echo error('Коментариев нет', '');
$posts = $temp[0];
$total = (($posts - 1) / $num) + 1;
$total =  intval($total);
$page = intval($page);
if(empty($page) or $page < 0) $page = 1;
if($page > $total) $page = $total;
$start = $page * $num - $num;
///////////////////////////////////////////
$comm_1=mysql_query("select * from `shurik_com` order by date desc limit $start,$num");
$comm_3=mysql_query("select * from `shurik_com`");

$comm_2=@mysql_fetch_array($comm_1);


if(mysql_num_rows($comm_3) > 0){

do{$user_avtor=mysql_fetch_array(mysql_query("select * from `shurik_users` where login='$comm_2[avtor]'"));
$date=date("ndHis");
$time=$user_avtor['online'];
if ($time+45 > $date) $user_on = "<span style='color:green'>[ON]</span>";
else $user_on = "<span style='color:red'>[OFF]</span>";
$text=str_replace('<img src=', '<img src=../', $comm_2['text']);
echo "<div class=aa><a href=com.php?id=$comm_2[id]>[ред]</a> <a href=com.php?del=$comm_2[id]>[удал]</a> <a href=../user/$user_avtor[id]>$user_avtor[echologin]</a> $user_on<br/><small>$comm_2[date]</small><br/>$text</div><hr color=white>";}
while ($comm_2=mysql_fetch_array($comm_1));


//////////////////////////
$url_for_pstr="com.php?page=";
if($page - 5 > 0) $page5left = ' <a href='.$url_for_pstr.($page - 5) .'>'. ($page - 5) .'</a> | ';
if($page - 4 > 0) $page4left = ' <a href='.$url_for_pstr.($page - 4) .'>'. ($page - 4) .'</a> | ';
if($page - 3 > 0) $page3left = ' <a href='.$url_for_pstr.($page - 3) .'>'. ($page - 3) .'</a> | ';
if($page - 2 > 0) $page2left = ' <a href='.$url_for_pstr.($page - 2) .'>'. ($page - 2) .'</a> | ';
if($page - 1 > 0) $page1left = ' <a href='.$url_for_pstr.($page - 1) .'>'. ($page - 1) .'</a> | ';

if($page + 5 <= $total) $page5right = ' | <a href='.$url_for_pstr.($page + 5) .'>'. ($page + 5) .'</a>';
if($page + 4 <= $total) $page4right = ' | <a href='.$url_for_pstr.($page + 4) .'>'. ($page + 4) .'</a>';
if($page + 3 <= $total) $page3right = ' | <a href='.$url_for_pstr.($page + 3) .'>'. ($page + 3) .'</a>';
if($page + 2 <= $total) $page2right = ' | <a href='.$url_for_pstr.($page + 2) .'>'. ($page + 2) .'</a>';
if($page + 1 <= $total) $page1right = ' | <a href='.$url_for_pstr.($page + 1) .'>'. ($page + 1) .'</a>';

if($page - 1 > 0) $nazad = '<a href='.$url_for_pstr.($page - 1) .'>Назад</a>';
if($page + 1 <= $total) $vpered = '<a href='.$url_for_pstr.($page + 1) .'>Далее</a>';

// Вывод меню если страниц больше одной

if ($total > 1)
{
Error_Reporting(E_ALL & ~E_NOTICE);
echo $pervpage.$page5left.$page4left.$page3left.$page2left.$page1left.'<b>'.$page.'</b>'.$page1right.$page2right.$page3right.$page4right.$page5right.$nextpage.'<br>'.$nazad.' | '.$vpered;
}
////////////////////////////
}
}


//}

echo "<br/><br><a href=index.php>Админ-меню</a>";
include("../include/2.php"); ?>