帝国调用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]
|
[该贴被修改 1 次,最后修改时间 2009-05-31 23:23:00 ]
|