".getNewsDate($obj->newsdate)."
"; $HTMLresult .= "$obj->announce"; if(!is_null($obj->newstext) && $obj->newstext!='') { $HTMLresult .= " id\">..."; } $HTMLresult .= "
"; } return $HTMLresult; } function getAnnouncesNewspage($siteid) { $newsPerPage = 10; if(array_key_exists('skip', $_GET)) { $offsetNews = preg_replace('/\D/','',$_GET['skip']); } else { $offsetNews = 0; } $HTMLresult=""; $newsQuery = "SELECT * FROM news WHERE siteid=$siteid ORDER BY newsdate DESC LIMIT ".$offsetNews.', '.$newsPerPage; $newsResult = mysql_query($newsQuery) or die ('Could not execute required query: '.$newsQuery.'$fdate
"; } else { $HTMLresult.="$ctext
\r\n"; if(!(is_null($arr['newstext']) || trim($arr['newstext'])=="")) { $HTMLresult.="Подробнее...\r\n";
}
}
$pager = getNewsPager($siteid, $lastDateFlag, $firstDateFlag);
return $pager.$HTMLresult.$pager;
}
function getNewsById($newsId, $siteId) {
$HTMLresult="";
$newsQuery = "SELECT * FROM news WHERE id=$newsId and siteid=$siteId";
$newsResult = mysql_query($newsQuery) or die ('Could not execute required query: '.$newsQuery.'
'.mysql_error());
if(mysql_num_rows($newsResult)!=0) {
$news = mysql_fetch_object($newsResult);
if($news->subject!='') {
$HTMLresult .= "
".getNewsDate($news->newsdate).""; $HTMLresult .= "
".$news->newstext."
"; } else { $HTMLresult = "К сожалению, такой новости не существует
"; } return $HTMLresult; } function getNewsPager($siteid, $lastDateFlag, $firstDateFlag) { $$newsPerPage = 5; $HTMLnewsNav = '';
$prevQuery = "SELECT count(id) as prevcount FROM news WHERE siteid=$siteid and newsdate<'".$lastDateFlag."'";
$prevQueryRes = mysql_query($prevQuery) or die ('Could not execute required query: '.$prevQueryRes.'
'.mysql_error());
$prevRow = mysql_fetch_assoc($prevQueryRes);
$nextQuery = "SELECT count(id) as nextcount FROM news WHERE siteid=$siteid and newsdate>'".$firstDateFlag."'";
$nextQueryRes = mysql_query($nextQuery) or die ('Could not execute required query: '.$nextQueryRes.'
'.mysql_error());
$nextRow = mysql_fetch_assoc($nextQueryRes);
if($prevRow['prevcount']!=0) {
$skipParameter = $offsetNews + $newsPerPage;
$HTMLnewsNav.= ''.'Предыдущие'.'';
}
$HTMLnewsNav.=' ';
if($nextRow['nextcount']!=0) {
$skipParameter = $offsetNews - $newsPerPage;
if($skipParameter==0) {
$HTMLnewsNav.= ''.'Следующие'.'';
} else {
$HTMLnewsNav.= ''.'Следующие'.'';
}
}
$HTMLnewsNav.= "