$wynik = dbquery("SELECT tp.*, ta.*, u.user_id, u.user_name, COUNT(tr.rating_item_id) AS count_votes 

FROM ".DB_PHOTOS." tp 

LEFT JOIN ".DB_PHOTO_ALBUMS." ta USING(album_id)

LEFT JOIN ".DB_USERS." u ON (tp.photo_user=u.user_id)

LEFT JOIN ".DB_RATINGS." tr ON tr.rating_item_id = tp.photo_id AND tr.rating_type='P'

WHERE ".groupaccess('album_access')." AND

DATE(FROM_UNIXTIME(photo_datestamp)) = CURDATE() 

GROUP BY photo_id

ORDER BY photo_datestamp DESC");  



include LOCALE.LOCALESET."photogallery.php";

if(dbrows($wynik) > 0) {

openside("Dzi¶ dodane zdjêcia");  

echo "<table cellpadding='0' cellspacing='0' width='100%'>\n<tr>"; 



$counter = 0; 

$columns = 2;

      

while($data = dbarray($wynik)) {

if ($counter != 0 && ($counter % $columns == 0)) { echo "</tr>\n<tr>\n"; }    

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

echo "<td class='tbl' 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>



<br /><br /><span class='small photogallery_album_photo_info'> <!--photogallery_album_photo_info-->\n";

echo $locale['433'].showdate("shortdate", $data['photo_datestamp'])."<br />\n";

echo $locale['434']."<a href='".BASEDIR."profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a><br />\n";

$photo_comments = dbcount("(comment_id)", DB_COMMENTS, "comment_type='P' AND comment_item_id='".$data['photo_id']."'");

echo ($photo_comments == 1 ? $locale['436b'] : $locale['436']).$photo_comments."<br />\n";

echo $locale['437'].($data['count_votes'] > 0 ? str_repeat("<img src='".IMAGES."star.gif' alt='*' style='vertical-align:middle' />", ceil($data['sum_rating'] / $data['count_votes'])) : $locale['438'])."<br />\n";

echo $locale['435'].$data['photo_views']."</span><br />

</td>\n";

$counter++;

}

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

closeside();

}