View file new.php

File size: 3.35Kb
<? $page_name="Новости"; include("include/1.php"); require "include/avto.php";

if(!isset($_GET['id'])){
//////////////////////////////////////////
$num = $pstr['new'];
@$page = $_GET['page'];
$result00 = mysql_query("SELECT COUNT(*) FROM `shurik_news`");
$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;
///////////////////////////////////////////


$all_news_1=mysql_query("select * from `shurik_news` order by `date` desc limit $start, $num");
$all_news_2=mysql_fetch_array($all_news_1);

do{$comments=mysql_num_rows(mysql_query("select * from `shurik_com` where new=$all_news_2[id]"));
echo "<a href=new.php?id=$all_news_2[id]>$all_news_2[name]</a><br><small>$all_news_2[text]</small><br/><a href=comment.php?new=$all_news_2[id]>Коментарии ($comments)</a><hr style=color:white>";}
while($all_news_2=mysql_fetch_array($all_news_1));

//////////////////////////
$url_for_pstr="new.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;
}
////////////////////////////



}



if(isset($_GET['id']) and $_GET['id']!=0){
$id=$_GET['id'];
$new_1=mysql_query("select * from `shurik_news` where id=$id limit 1");
if(mysql_num_rows($new_1)>0){
$new_2=mysql_fetch_array($new_1);

$login_avtor=$new_2['avtor'];$user_avtor=mysql_fetch_array(mysql_query("select id, login, echologin from `shurik_users` where login='$login_avtor'"));
echo "Разместил: <a href=user/$user_avtor[id]>$user_avtor[echologin]</a><br>";
echo "Дата: <b>$new_2[date]</b><br><br>";
echo "<i>$new_2[text]</i><br/><br/>";
echo "<a href=comment.php?new=$id>Коментарии</a> (".mysql_num_rows(mysql_query("select * from `shurik_com` where new=$id")).")";}

else echo error('Новость не надена!', '');
}
include("include/2.php"); ?>