10 2013 档案

Discuz 取各排行榜数据
摘要：取论坛指定版块帖子或回复(first=1 就是帖子的1楼, 如果=0 就是调用回复,fid=62 是论坛版块号): SELECT * FROM discuzx.pre_forum_post where first=1 and fid=62 order by tid desc取论坛最新帖子并显示版块名称:SELECT a.*,b.* FROM discuzx.pre_forum_thread as a left join discuzx.pre_forum_forum as b on a.fid=b.fid order by tid desc按积分排行调用论坛用户头像和名称，也可以将 credi 阅读全文
posted @ 2013-10-08 21:56 Zhou Hr 阅读(1272) 评论(0) 推荐(0) 编辑