le="color: #000000"><?php /****** hack by http://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 = "<div style='text-align: center;'>" ."<a href='".XOOPS_URL."/modules/myalbum".$myalbumNum."/photo.php?lid=".$myrow['lid']."'>" ."<img src='".XOOPS_URL."/uploads/thumbs".$myalbumNum."/".$myrow['lid'].".".$myrow['ext']."' align='center' hspace='3' vspace='3' width='100px' />" ."</a>" ."</div>"; return $object; }
and then you can add a custom PHP block with this code:
le="color: #000000"><?php echo getPicGallery('X', 'Y', 'Z');
WHERE:
- X: myalbum Number
- Y: cid number
- Z: 1 = random pic ; 0 = last inserted pic
eg:
le="color: #000000"><?php echo getPicGallery('', '1', '1');
will display random pics from myalbum and cid = 1
Discussion into forum:
https://xoops.org/modules/newbb/viewtopic.php?post_id=288832#forumpost288832
If you need to see the original tutorial is here: http://www.xoopsitalia.org/modules/article/view.article.php/c1/72
Feel free to visit my page for other tutorials: http://www.stefanosilvestrini.com
bye!!!
|
|
Login
Search
Recent Comments
Donat-O-Meter
| Stats | |
| Goal: | $15.00 |
| Due Date: | Aug 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $15.00 |
|
|