$result=dbquery(

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

LEFT JOIN ".$db_prefix."photo_albums ta USING(album_id)

WHERE ".groupaccess('album_access')." ORDER BY photo_datestamp DESC LIMIT 8"

);

if(dbrows($result)>0){

openside("Ostatnie Fotki");

echo "<center><marquee behavior='scroll' align='center' valign='bottom' direction='up' width='120' height='120' scrollamount='1' scrolldelay='1' onmouseover='this.stop()' onmouseout='this.start()'>

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

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

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

echo "<tr>

<td 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></td>

</tr>";

}

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

closeside();

}