Hacks
/****** 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 = ""
.".XOOPS_URL."/modules/myalbum".$myalbumNum."/photo.php?lid=".$myrow['lid']."'>"
.".XOOPS_URL."/uploads/thumbs".$myalbumNum."/".$myrow['lid'].".".$myrow['ext']."' align='center' hspace='3' vspace='3' width='100px' />"
.""
." ";
return $object;
}然后您可以使用以下代码添加自定义PHP块
echo getPicGallery('X', 'Y', 'Z'); WHERE
- X: myalbum 编号
- Y: cid编号
- Z: 1 = 随机图片 ; 0 = 最后插入的图片
例如
echo getPicGallery('', '1', '1'); 将从我的专辑和cid = 1 展示随机图片
论坛讨论
https://xoops.org.cn/modules/newbb/viewtopic.php?post_id=288832#forumpost288832
教程的原始页面在这里： http://www.xoopsitalia.org/modules/article/view.article.php/c1/72
欢迎访问我的页面以查看更多教程： http://www.stefanosilvestrini.com
再见!!!
|
|
Login
Search
Recent Comments
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $100.00 |
| Due Date: | Aug 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $100.00 |
 |
|