$result = dbquery(

"SELECT tp.*, ta.* FROM ".$db_prefix."userphotos tp

LEFT JOIN ".$db_prefix."userphoto_albums ta USING (album_id) WHERE ".groupaccess('album_access')." ORDER BY photo_id DESC LIMIT 4"

);

if(dbrows($result)>0){

opentable("Ostatnie Fotki z Usergallery");

echo ">

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

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

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

if(!file_exists($filename)) $filename=$image_url.'/imagenotfound.jpg';

echo "<td align='center'>

<a href='".BASEDIR."userphotogallery.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 /><a href='".BASEDIR."userphotogallery.php?photo_id=".$data['photo_id']."' class='side'>".$data['photo_title']."</a>

<br>

<a href='".BASEDIR."userphotogallery.php?album_id=".$data['album_id']."' class='side'>".$data['album_title']."

</a></td>";

}

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

closetable();

}