Archive for August 8th, 2008
Cele mai vizualizate poze - PHP-Fusion
Puneti acest cod intr-un panou. Salvati-l si activati-l.
if (!defined(”IN_FUSION”)) { header(”Location:../../index.php”); exit; }
define(”SAFEMODE”, @ini_get(”safe_mode”) ? true : false);openside(”Cele mai vizualizate poze”);
$result = dbquery(
“SELECT tp.*, ta.*, tu.user_id,user_name FROM “.$db_prefix.”photos tp
LEFT JOIN “.$db_prefix.”photo_albums ta USING (album_id)
LEFT JOIN “.$db_prefix.”users tu ON tp.photo_user=tu.user_id
WHERE “.groupaccess(’ta.album_access’).” ORDER BY tp.photo_views DESC LIMIT 0,7″
);
if (dbrows($result) != 0) {
while($data = dbarray($result)) {
$itemsubject = trimlink($data['photo_id'], 23);
$itemdescription = trimlink($data['photo_title'], 23);
$photodir = (!SAFEMODE ? “album_”.$data['album_id'].”/” : “”);
echo “<br>\n”;
echo “<center><a href=’”.BASEDIR.”photogallery.php?photo_id=”.$data['photo_id'].”‘ title=’”.$data['photo_title'].”‘ class=’side’>
<img src=’”.PHOTOS.$photodir.$data['photo_thumb1'].”‘ title=’”.$data['photo_title'].”‘ alt=’”.$data['photo_title'].”‘ border=’0′><br />”.$data['photo_title'].” (”.$data['photo_views'].”)\n”;
echo “<br>\n”;
}
} else {
echo $locale['004'];
}
closeside();