<?php
if (in_array($_SERVER['SCRIPT_NAME'], array("/home.php","/photogallery.php"))){
//echo $_SERVER['SCRIPT_NAME'];
openside("Наши лучшие фото");
// номер альбома в котором проводится конкурс
if (!isset($album_id) || !isNum($album_id)) {
$n_photo_album = " (album_id = 1 OR album_id = 4 OR album_id = 5 OR album_id = 10) "; } else {
$n_photo_album = " album_id = ". $album_id;
}
// Количество претендентов
$n_count = 12;
$n_row = 3;
$result = dbquery("SELECT rating_item_id, SUM(rating_vote) as rating_rating , photo_id, photo_thumb1, album_id, photo_title, COUNT(rating_item_id) as all_vote FROM ".$db_prefix."ratings, ".$db_prefix."photos WHERE rating_type = 'p' AND ".$n_photo_album.
" AND rating_item_id = photo_id GROUP BY rating_item_id ORDER BY all_vote DESC, rating_rating DESC LIMIT ".$n_count );
if (dbrows($result) !=0) {
echo "<table border=0 cellpadding='0' cellspacing='0' width='100%' >\n";
$td = 0;
while($data = dbarray($result)){
$rating_item_id = $data['rating_item_id'];
$the_rating = $data['rating_rating'];
$photo_title = $data['photo_title'];
$photo_thumb1 = $data['photo_thumb1'];
if(!file_exists($photo_thumb1)) $filename=$image_url.'/imagenotfound.jpg';
$album_id_c = $data['album_id'];
$all_vote = $data['all_vote'];
if ($td == 0 ){ $tr1="<tr>"; $tr2="<tr>"; }
$tr1 .= "<td width=".(round((100/$n_row),0))."%><center><a href='".BASEDIR."photogallery.php?photo_id=".$rating_item_id."' title='".$photo_title."' ><img src='".PHOTOS."album_".$album_id_c."/".$photo_thumb1."' title='".$photo_title."' alt='".$photo_title."' style='align:center' border=0></a></center></td>";
$tr2 .="<td><center><span align=left><i>рейтинг : ".$the_rating." голосов : ".$all_vote."</i></span></center><br></td>\n";
$td++;
if ($td == $n_row){echo $tr1."</tr>".$tr2."</tr>"; $td=0;}
}
if ($td != 0){ echo $tr1."</tr>".$tr2."</tr>";}
echo "</table>";
}
else {
// Display message if no news items are visible/rated
echo "<center>Нет Фото для ретинга</center>\n";
}
closeside();openside("Новые фотографии");
//количество новых фотографий
$n_count = $n_row;
$result = dbquery("SELECT * FROM ".$db_prefix."photos WHERE ".$n_photo_album.
" ORDER BY photo_datestamp DESC LIMIT 0,".$n_count );
if (dbrows($result) !=0) {
echo "<table border=0 cellpadding='0' cellspacing='0' width='100%' >\n";
$td = 0;
while($data = dbarray($result)){
$photo_item_id = $data['photo_id'];
$photo_item_title = $data['photo_title'];
$photo_item_thumb1 = $data['photo_thumb1'];
$photo_item_data = date("d/m/y",$data['photo_datestamp']);
if(!file_exists($photo_item_thumb1)) $filename=$image_url.'/imagenotfound.jpg';
$album_id_c = $data['album_id'];
if ($td == 0 ){ $tr1="<tr>"; $tr2="<tr>"; }
$tr1 .= "<td width=".round((100/$n_row),0)."%><center><a href='".BASEDIR."photogallery.php?photo_id=".$photo_item_id."' title='".$photo_item_title."'><img src='".PHOTOS."album_".$album_id_c."/".$photo_item_thumb1."' title='".$photo_item_title."' alt='".$photo_item_title."' style='align:center' border=0></a></center></td>";
$tr2 .="<td><center>дата : ".$photo_item_data."</i></span></center><br></td>\n";
$td++;
if ($td == $n_row){echo $tr1."</tr>".$tr2."</tr>"; $td=0;}
}
if ($td != 0){ echo $tr1."</tr>".$tr2."</tr>";}
echo "</table>";
}
else {
// Display message if no news items are visible/rated
echo "<center>Фотографий еще не поступало</center>\n";
}
closeside();}
?>
Регистрация 
