$result = dbquery(

"SELECT tp.photo_id, tp.photo_title, tp.photo_thumb1, ta.album_id, ta.album_title FROM ".DB_USERPHOTOS." tp

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

WHERE ".groupaccess('album_access')." ORDER BY RAND() LIMIT 5"

);

if(dbrows($result)>0){

   opentable("Losowe fotki z galerii użytkowników");

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

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

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

   echo "<td align='center'>\n";

   echo "<a href='".BASEDIR."userphotogallery.php?photo_id=".$data['photo_id']."' class='photogallery_album_photo_link'>\n";

   if ($data['photo_thumb1']) {

      echo "<img src='".$randphotodir.$data['photo_thumb1']."' alt='".$data['photo_title']."' style='border:0px' class='photogallery_album_photo' />\n";

   } else {

      echo "<img src='".IMAGES."imagenotfound.jpg' alt='".$data['photo_title']."' style='border:0px' class='photogallery_album_photo' />\n";   

   }

   echo "</a>\n";

   echo "<br />\n";

   echo "<a href='".BASEDIR."userphotogallery.php?photo_id=".$data['photo_id']."' class='side'><strong>".$data['photo_title']."</strong></a>\n";

   echo "<br />\n";

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

   echo "</td>\n";

}

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

   closetable();

}