openside("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'>";

$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)) {

echo

 "<tr>

<td align='center'>Liczba ocen: "

.number_format($data1['ile'

])."</td>

</tr>

<tr>

<td align='center'>Średnia: "

.$data1['srednia'

]."</td>

</tr>"

;

 

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

echo

 "<tr>

<td align='center'><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>

</tr>"

;

}

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

echo "</table>";

closeside();