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

if (!defined("DB_PHOTOS")) {

define("DB_PHOTOS", DB_PREFIX."photos ");

}

if (!defined("DB_PHOTO_ALBUMS")) {

define("DB_PHOTO_ALBUMS", DB_PREFIX."photo_albums");

}

if (!defined("DB_RATINGS")) {

define("DB_RATINGS", DB_PREFIX."ratings");

}

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

$wynik1 = dbquery("SELECT tp.*, ta.*, (SELECT COUNT(rating_id) FROM "

.DB_RATINGS." c

WHERE c.rating_type='P' AND (c.rating_item_id = tp.photo_id)) AS ile,

(SELECT ROUND(AVG(rating_vote), 2) FROM "

.DB_RATINGS." c

WHERE c.rating_type='P' AND (c.rating_item_id = tp.photo_id)) AS srednia

FROM "

.DB_PHOTOS." tp LEFT JOIN "

.DB_PHOTO_ALBUMS." ta USING(album_id)

WHERE ".groupaccess('album_access')." ORDER BY srednia DESC, ile DESC LIMIT 10");

 

if(dbrows($wynik1) > 0) {

while($data1 = dbarray($wynik1)) {

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

echo "<td align='center'>Ilość ocen: ".number_format($data1['ile'])."<br />

Średnia: ".$data1['srednia']."<br /><a href='"

.BASEDIR."photogallery.php?photo_id=".$data1['photo_id']."' class='gallery'>

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

</td>";

}

} else { echo "<tr><td align='center'>Brak fotek.</td></tr>"; }

echo "</tr></table>";

closetable();