Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $query = array(
- 'SELECT' => 't.forum_id, t.id, t.last_post',
- 'FROM' => 'topics AS t',
- 'JOINS' =>
- array(
- array('INNER JOIN' => 'forums AS f',
- 'ON' => 'f.id=t.forum_id'),
- array('LEFT JOIN' => 'forum_perms AS fp',
- 'ON' => '(fp.forum_id=f.id AND fp.group_id=' . $forum_user['g_id'] . ')')
- ),
- 'WHERE' => '(fp.read_forum IS NULL OR fp.read_forum=1) AND t.last_post>' . $forum_user['last_visit'] .' AND t.moved_to IS NULL');
Add Comment
Please, Sign In to add comment