帝国调用discuz uc 帖子 图片
调用uc博客最新主题
[ecmsinfo]‘select subject as title,uid as userid,blogid as id from uchome_blog order by blogid desc limit 17′,0,40,0,24,28,0[/ecmsinfo]
## 调用uc博客最新图片
[ecmsinfo]‘select albumname as title,uid as userid,albumid as id,pic as titlepic from uchome_album order by albumid desc limit 2′,0,22,0,24,31,0[/ecmsinfo]
## 调用uc博客最新回复
[ecmsinfo]‘select subject as title,uid as userid,blogid as id from uchome_blog order by tracenum desc limit 3′,0,30,0,24,29,0[/ecmsinfo]
## 调用uc博客群组
[ecmsinfo]‘select subject as title,tid as userid,tagid as id from uchome_thread order by replynum desc limit 1′,0,18,0,24,30,0[/ecmsinfo]
## 调用dz论坛最新主题
[ecmsinfo]‘select subject as title,tid as id from cdb_threads order by lastpost desc limit 4′,0,40,0,24,25,0[/ecmsinfo]
## 调用dz论坛最新图片
[ecmsinfo]‘select u.attachment as titlepic,ui.subject as title,u.tid as id from cdb_attachments u LEFT JOIN cdb_threads ui ON u.tid=ui.tid where u.isimage=1 order by ui.tid DESC limit 2′,0,30,0,24,36,0[/ecmsinfo]
## 调用dz论坛随即帖子
[ecmsinfo]‘select subject as title,tid as id from cdb_threads order by highlight desc limit 3′,0,30,0,24,27,0[/ecmsinfo]
## 调用dz论坛精华帖子
[ecmsinfo]‘select subject as title,tid as id from cdb_threads order by digest desc limit 1′,0,18,0,24,26,0[/ecmsinfo]
## 调用dz论坛指定版块的帖子
[ecmsinfo]‘select subject as title,tid as id from cdb_threads where fid=10 order by tid desc limit 14′,0,30,0,24,38,0[/ecmsinfo]
## 例子
[ecmsinfo]‘select subject as title(调用后变量),tid as id from cdb_threads(数据表) where fid=10(版块id) order by tid desc limit 14(调用条数)’,0,30,0,24,38,0[/ecmsinfo]