Najwyżej oceniane: "; echo ""; $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 4"); $licznik =0; if(dbrows($wynik1) > 0) { while($data1 = dbarray($wynik1)) { if (++$licznik==1) echo ""; $randphotodir = PHOTOS.(!@ini_get("safe_mode") ? "album_".$data1['album_id']."/" : ""); echo " "; if ($licznik==$kolumn) { echo ""; $licznik=0; } } }else {echo ""; } $koniec=$kolumn-count($lista)%$kolumn; if ($koniec<>$kolumn) { for ($i=0;$i<$koniec;$i++) { $licznik++; echo ""; } if ($licznik==$kolumn) echo ""; } echo "

Liczba ocen: ".number_format($data1['ile'])." Średnia: ".$data1['srednia']."

Brak fotek.

"; echo "

Najczesciej komentowane:

"; echo ""; $wynik2 = dbquery("SELECT tp.*, ta.*, (SELECT COUNT(comment_id) FROM ".DB_COMMENTS." c WHERE c.comment_type='P' AND (c.comment_item_id = tp.photo_id)) AS ile FROM ".DB_PHOTOS." tp LEFT JOIN ".DB_PHOTO_ALBUMS." ta USING(album_id) WHERE ".groupaccess('album_access')." ORDER BY ile DESC LIMIT 4"); $test = 0; if(dbrows($wynik2) > 0) { while($r1 = dbarray($wynik2)) { if (++$test==1) echo ""; echo " "; if ($test==$kolumn) { echo ""; $test=0; } } } else {echo ""; } $koniec=$kolumn-count($lista)%$kolumn; if ($koniec<>$kolumn) { for ($i=0;$i<$koniec;$i++) { $test++; echo ""; } if ($test==$kolumn) echo ""; } echo "

Liczba komentarzy: ".number_format($r1['ile'])."

Brak fotek.

"; echo "

Ostatnio dodane:

"; echo ""; $wynik3 = dbquery("SELECT * FROM ".DB_PHOTOS." tp LEFT JOIN ".DB_PHOTO_ALBUMS." ta USING(album_id) WHERE ".groupaccess('album_access')." ORDER BY photo_datestamp DESC LIMIT 4"); $test1 = 0; if(dbrows($wynik3) > 0) { while($r11 = dbarray($wynik3)) { if (++$test1==1) echo ""; echo " "; if ($test1==$kolumn) { echo ""; $test1=0; } } } else {echo ""; } $koniec=$kolumn-count($lista)%$kolumn; if ($koniec<>$kolumn) { for ($i=0;$i<$koniec;$i++) { $test1++; echo ""; } if ($test1==$kolumn) echo ""; } echo "

Brak fotek.

"; closetable(); require_once THEMES."templates/footer.php"; ?>