openside("Najwyżej oceniane zdjęcia");

$rok = date('Y');

$miech = date('n');

$dzien = date('j');

$time = gmmktime(0, 0, 0, $miech, 1, $rok);



$miesiace = array(1 => "Styczeń", 2 => "Luty", 3=> "Marzec", 4 => "Kwiecień", 5 => "Maj", 6 => "Czerwiec", 7 => "Lipiec", 8 => "Sierpień", 9 => "Wrzesień", 10 => "Październik", 11 => "Listopad", 12 => "Grudzien" ); 

echo "<table align='center' cellpadding='0' cellspacing='4'>";

$wynik = dbquery("

SELECT photo_id, photo_title, photo_thumb1, album_id,

COUNT(photo_id) AS num_vote,

ROUND( AVG(rating_vote),2) AS avg_photo

 FROM ".DB_PHOTOS." 

 LEFT JOIN ".DB_RATINGS." ON (rating_item_id = photo_id) AND rating_type='P' AND rating_datestamp  >='".$time."'

 LEFT JOIN ".DB_PHOTO_ALBUMS." USING ( album_id )

WHERE ".groupaccess('album_access')."

GROUP BY photo_id

ORDER BY avg_photo DESC , num_vote DESC

LIMIT 1 

");

if(dbrows($wynik) > 0) {      

$data = dbarray($wynik);    

$randphotodir = PHOTOS.(!@ini_get("safe_mode") ? "album_".$data['album_id']."/" : "");

echo 

"<tr>

<td align='center'>Zdjęcie miesciąca ".$miesiace[$miech]."</td></tr>

<tr>

<tr>

<td align='center'><a href='".BASEDIR."photogallery.php?photo_id=".$data['photo_id']."' class='gallery'>

<img src='".$randphotodir.$data['photo_thumb1']."' title='".$data['photo_title']."' alt='".$data['photo_title']."' border='0' /></a></td></tr>

<tr>

<td align='center'>Liczba ocen: ".number_format($data['num_vote'])."</td>

</tr>

<tr>

<td align='center'>Średnia: ".$data['avg_photo']."</td>

</tr>";

} else {

echo "<tr>

<td align='center'>Brak głósów w tym miesiącu</td>

</tr>";  

}

echo '</table>';

closeside();