\n");
?>
 |
');
print(ru_month(substr($dateo,0,2),'I')/*.' '.substr($dateo,3,5)*/);
print(' ');
$prev_year = $new_year;
// print('');
// print(ru_month(substr($dateo,0,2),'I').substr($dateo,2,5));
//
?>
0) print(' | ');
?>
|
0) {
$r=mysql_fetch_array($q);
$id_comntype=$r['id_ntype'];
}
$dt_ownb=substr($newsdate,0,14);
$dt_owne=substr($newsdate,14,14);
$order='news.dt_own';
$sortcol=$order;
if($sortorder==0) {$order.=' desc';} else {$order.=' asc';}
if($showpage==0) {
if(isset($id_author)) {
$query="select distinct news.id_news from news where id_author=$id_author and $sortcol between '$dt_ownb' and '$dt_owne' and approved=$approved order by $order";
}
else {
if(!$showsite) {
if(!$showussr) {
$query="select distinct news.id_news from news,new_cit,sit_cit_typ,new_typ where ((id_ntype>=2 and news.id_news=new_cit.id_news and new_cit.id_city=sit_cit_typ.id_city) and sit_cit_typ.id_site=$id_site and news.id_news=new_typ.id_news and new_typ.id_type=sit_cit_typ.id_type) and $sortcol between '$dt_ownb' and '$dt_owne' and approved=$approved order by $order";
} else {
$query="select distinct news.id_news from news,new_cit,sit_cit_typ,new_typ where ((id_ntype=$id_comntype or (id_ntype>=2 and news.id_news=new_cit.id_news and new_cit.id_city=sit_cit_typ.id_city)) and sit_cit_typ.id_site=$id_site and news.id_news=new_typ.id_news and new_typ.id_type=sit_cit_typ.id_type) and $sortcol between '$dt_ownb' and '$dt_owne' and approved=$approved order by $order";
}
}
else {
if(!$showussr) {
$query="select distinct news.id_news from news,new_cit,sit_cit_typ,new_typ,new_sit where ((id_ntype>=2 and news.id_news=new_cit.id_news and new_cit.id_city=sit_cit_typ.id_city and sit_cit_typ.id_site=$id_site and news.id_news=new_typ.id_news and new_typ.id_type=sit_cit_typ.id_type) or (id_ntype=1 and news.id_news=new_sit.id_news and new_sit.id_site=$id_site)) and $sortcol between '$dt_ownb' and '$dt_owne' and approved=$approved order by $order";
} else {
$query="select distinct news.id_news from news,new_cit,sit_cit_typ,new_typ,new_sit where (((id_ntype=$id_comntype or (id_ntype>=2 and news.id_news=new_cit.id_news and new_cit.id_city=sit_cit_typ.id_city)) and sit_cit_typ.id_site=$id_site and news.id_news=new_typ.id_news and new_typ.id_type=sit_cit_typ.id_type) or (id_ntype=1 and news.id_news=new_sit.id_news and new_sit.id_site=$id_site)) and $sortcol between '$dt_ownb' and '$dt_owne' and approved=$approved order by $order";
}
}
}
/*
// version with ussr news on every page and without site news
$query="select distinct news.id_news from news,new_cit,sit_cit_typ,new_typ where ((id_ntype=$id_comntype or (id_ntype>=2 and news.id_news=new_cit.id_news and new_cit.id_city=sit_cit_typ.id_city)) and sit_cit_typ.id_site=$id_site and news.id_news=new_typ.id_news and new_typ.id_type=sit_cit_typ.id_type) and $sortcol between '$dt_ownb' and '$dt_owne' order by $order";
*/
$q=mysql_query($query,$cid);
$found=mysql_numrows($q);
$showpage=1;
$showtotal=ceil((double)$found/$showby);
if(isset($id_news_list)) {
unset($id_news_list);
}
for($i=0; $i<$found; $i++) {
$r=mysql_fetch_array($q);
$id_news_list[$i]=$r['id_news'];
}
// print("Найдено: ".$found." \n");
}
if($showtotal>0) {
if(isset($news)) {
$id_news_list=unserialize(StripSlashes(urldecode($news)));
}
elseif(!isset($id_news_list)) {
tail();
}
$id_news_this='('.implode(',',array_slice($id_news_list,$showby*($showpage-1),$showby)).')';
$query="select distinct approved, news.id_news idnews,title,body,news.id_ntype idntype,DATE_FORMAT(news.dt_own,'%d %m %Y') d_own,DATE_FORMAT(news.dt_post,'%d.%m.%Y %k:%i') d_post,persons.nickname auth_name, news.id_author id_auth, news.id_editor id_edit, source from news,persons where news.id_news in $id_news_this and persons.id_person=news.id_author and approved=$approved order by $order";
$q=mysql_query($query,$cid);
$dateo=date("m Y",mktime(0,0,0,substr($newsdate,4,2),1,substr($newsdate,0,4)));
hd1(ru_month(substr($dateo,0,2),'I').substr($dateo,2,5));
for($i=0; $i
|
| \n");
/* print("| Информация: ".$r['auth_name']." | ");
*/
if(empty($r['source'])) {
?>
| |
| (Прислал: ) |
|
|
=3) {
?>
'.preg_replace("/(_pic\((\d{1,20})\))/e", "pic2html(\\2,$maxW,$maxH)", str_replace("\r\n\r\n","\n ",$r['body']))." \n");
/*
if($access_rate>=3) {
print(' | | ');
print('Редактировать');
print(" | \n");
print('Удалить');
print(" | \n");
}
*/
?>
| |
\n");
print("Страница: \n");
$news=urlencode(serialize($id_news_list));
for($i=1; $i<=$showtotal; $i++)
if($i!=$showpage)
{ print(''.$i."\n"); }
else { print($i." "); }
print(" ");
}
else {
// print(" |