discuz x3.x 我收藏的版块和帖子查询

因为有些常用的帖子和版块每次都要点来点去的去找，所以干脆把收藏功能拿出来用，做个菜单，随时查看和删除。

查询代码：

1.我收藏的版块

$forum_favorites = DB::fetch_all("SELECT a.*,b.name,b.todayposts,c.icon,c.description as forum_description FROM ".DB::table('home_favorite')." a LEFT JOIN ".DB::table('forum_forum')." b on b.fid=a.id LEFT JOIN ".DB::table('forum_forumfield')." c on c.fid=b.fid WHERE a.`idtype`= 'fid' AND a.`uid`='$_G[uid]' ORDER BY a.`dateline` DESC LIMIT 0,10");//版块

2.我收藏的帖子

$thread_favorites = DB::fetch_all("SELECT a.*,b.authorid,b.author,b.views,b.replies,b.tid,c.attachment,c.remote FROM ".DB::table('home_favorite')." a LEFT JOIN ".DB::table('forum_thread')." b on b.tid=a.id LEFT JOIN ".DB::table('forum_threadimage')." c on c.tid=b.tid WHERE a.`idtype`= 'tid' AND a.`uid`='$_G[uid]' ORDER BY a.`dateline` DESC LIMIT 0,10");//帖子

调用方法：

版块

{loop $forum_favorites $value}

$value['字段']

{/loop}

{loop $thread_favorites $value}

$value['字段']

{/loop}

帖子