1
Hi all
i have written a function to build random pictures blocks (from myalbum-p).
You need to include this into your: root/include/functions.php:
/****** hack by www.stefanosilvestrini.com *****/
function getPicGallery($myalbumNum, $cid, $random) {
global $xoopsConfig;
$db =& Database::getInstance();
$myalbumNum = trim($myalbumNum);
if($random != 1) $sql = "SELECT s.lid AS lid, s.ext AS ext FROM ".$db->prefix('myalbum'.$myalbumNum.'_photos')." s, ".$db->prefix('myalbum'.$myalbumNum.'_cat')." t WHERE s.cid = t.cid AND s.cid = ".$cid." ORDER BY s.lid DESC LIMIT 1";
else $sql = "SELECT s.lid AS lid, s.ext AS ext FROM ".$db->prefix('myalbum'.$myalbumNum.'_photos')." s, ".$db->prefix('myalbum'.$myalbumNum.'_cat')." t WHERE s.cid = t.cid AND s.cid = ".$cid." ORDER BY RAND() LIMIT 1";
$result = $db->query($sql);
$myrow = $db->fetchArray($result);
$object = "";
return $object;
}
and then you can add a custom PHP block with this code:
echo getPicGallery('X', 'Y', 'Z');
WHERE:
- X: myalbum Number
- Y: cid number
- Z: 1 = random pic ; 0 = last inserted pic
eg:
echo getPicGallery('', '1', '1');
will display random pics from myalbum and cid = 1
If you need to see the original tutorial is here:
http://www.xoopsitalia.org/modules/article/view.article.php/c1/72Feel free to visit my page for other tutorials:
http://www.stefanosilvestrini.combye!!!