daily pastebin goal
53%
SHARE
TWEET

Untitled

a guest Jul 13th, 2018 68 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. $query = array(
  2.     'SELECT' => 't.forum_id, t.id, t.last_post',
  3.     'FROM' => 'topics AS t',
  4.     'JOINS' =>
  5.         array(
  6.             array('INNER JOIN' => 'forums AS f',
  7.                 'ON' => 'f.id=t.forum_id'),
  8.             array('LEFT JOIN' => 'forum_perms AS fp',
  9.                 'ON' => '(fp.forum_id=f.id AND fp.group_id=' . $forum_user['g_id'] . ')')
  10.             ),
  11.     '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');
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top