帝国调用dz 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]
|
顶部 
加入收藏夹
2009-05-31 15:12:01 
已设置保密
回复
引用
报告
编辑
删除
好贴
