$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&#91;'album_id'&#93;."/" : "");
if(!file_exists($filename)) $filename=$image_url.'/imagenotfound.jpg';
echo "<td align='center'>
<a href='".BASEDIR."userphotogallery.php?photo_id=".$data&#91;'photo_id'&#93;."' class='gallery'>
<img src='".$randphotodir.$data&#91;'photo_thumb1'&#93;."' title='".$data&#91;'photo_title'&#93;."' alt='".$data&#91;'photo_title'&#93;."' border='0'>
</a><br /><a href='".BASEDIR."userphotogallery.php?photo_id=".$data&#91;'photo_id'&#93;."' class='side'>".$data&#91;'photo_title'&#93;."</a>
<br>
<a href='".BASEDIR."userphotogallery.php?album_id=".$data&#91;'album_id'&#93;."' class='side'>".$data&#91;'album_title'&#93;."
</a></td>";
}
echo "</tr></table></marquee>";
closetable();
}
Zinterpretowano w sekund: 0.033, wykorzystano GeSHi 1.0.8.10