|
|
 |

Gallery
require_once(getenv('DOCUMENT_ROOT')."/eng/connect.php");
require_once(getenv('DOCUMENT_ROOT')."/eng/config.inc.php");
require_once(getenv('DOCUMENT_ROOT')."/eng/_classes/template.cls.php");
$q="SELECT ".TABLE_GALLERIES.".gallery_id, ".TABLE_GALLERIES.".gallery_name,".TABLE_GALLERIES.".description, count(".TABLE_PHOTOS.".photo_id) as count FROM ".TABLE_GALLERIES." LEFT JOIN ".TABLE_PHOTOS." ON ".TABLE_GALLERIES.".gallery_id=".TABLE_PHOTOS.".gallery_id GROUP BY ".TABLE_GALLERIES.".gallery_id ORDER BY ".TABLE_GALLERIES.".gallery_id DESC";
$r=mysql_query($q);
if(mysql_num_rows($r)>0) {
$t=new Template(getenv('DOCUMENT_ROOT').PATH_TEMPLATES."gallery/galleries.tmpl");
$begin=$t->GetTag('начало');
$end=$t->GetTag('конец');
$del=$t->GetTag('разделитель');
$galleries=array();
while($row=mysql_fetch_assoc($r)) {
$row['description']=str_replace("\r",'',$row['description']);
$row['description']=str_replace("\n",' ',$row['description']);
$row['кнопка_посмотреть']='';
if($row['count']>0) {
$row['кнопка_посмотреть']=$t->GetTag('кнопка_посмотреть',$row);
$row['заголовок']=$t->GetTag('заголовок_если_есть_фотографии',$row);
}
else {
$row['заголовок']=$t->GetTag('заголовок_если_нет_фотографий',$row);
}
$galleries[]=$t->GetTag('галерея',$row);
}
print $begin.join($del,$galleries).$end;
}
?>
|
 |
|
 |
 |
 |
News:
include($DOCUMENT_ROOT."/eng/config.inc.php");
include($DOCUMENT_ROOT."/eng/connect.php");
include($DOCUMENT_ROOT."/eng/_classes/include.inc.php");
$res=mysql_query("SELECT link,news_id,announce,body,title,photo1,photo2,photo3,news_date,DATE_FORMAT(news_date,'%e.%m.%Y') as p_date FROM eng_news WHERE mainpage>0 ORDER BY news_date DESC,news_id DESC LIMIT 5");
if(mysql_num_rows($res)==0) $res=mysql_query("SELECT link,news_id,announce,body,title,photo1,photo2,photo3,news_date,DATE_FORMAT(news_date,'%e.%m.%Y') as p_date FROM eng_news ORDER BY news_date DESC,news_id DESC LIMIT 5");
if(mysql_num_rows($res)>0)
{
while($row=mysql_fetch_array($res))
{
#if(!$row['photo']) $row['photo']="/img/spacer.gif";
#else $row['photo']=$IMAGE_NEWS_PATH.$row['photo'];
if($row['photo1']) $photos['[IMAGE1]']=" ";
else $row['[IMAGE1]']='';
if($row['photo2']) $photos['[IMAGE2]']=" ";
else $row['[IMAGE2]']='';
if($row['photo3']) $photos['[IMAGE3]']=" ";
else $row['[IMAGE3]']='';
if($row['body']) $row['more_url']="".$NEWS_MORE_TEXT." ";
elseif($row['link']) $row['more_url']="".$NEWS_MORE_TEXT." ";
else $row['more_url']='';
$data=ParseTemplate($row,"shortnews");
foreach($photos as $key=>$val) {
$data=str_replace($key,$val,$data);
}
print $data;
}
}
?>
|
 |
|
|