if (_uid) { $un_opt = isset($_GET['unread']) ? str_replace('&unread=' . $_GET['unread'], '', $_SERVER['QUERY_STRING']) : $_SERVER['QUERY_STRING'] . '&unread=1'; $frm_opt = isset($_GET['sub_forum_limit']) ? str_replace('&sub_forum_limit=' . $_GET['sub_forum_limit'], '', $_SERVER['QUERY_STRING']) : $_SERVER['QUERY_STRING'] . '&sub_forum_limit=1'; $th_opt = isset($_GET['sub_th_limit']) ? str_replace('&sub_th_limit=' . $_GET['sub_th_limit'], '', $_SERVER['QUERY_STRING']) : $_SERVER['QUERY_STRING'] . '&sub_th_limit=1'; $s_unread = valstat(isset($_GET['unread'])); $s_subf = valstat(isset($_GET['sub_forum_limit'])); $s_subt = valstat(isset($_GET['sub_th_limit'])); $subscribed_thr = ' | <a class="GenLink" href="/egroupware/fudforum/3814588639/index.php?' . $th_opt . '" title="Toggle the subscribed topics filter (will only show posts from the topics you are subscribed to)">Subscribed Topics ' . $s_subt . '</a>'; $subscribed_frm = ' | <a class="GenLink" href="/egroupware/fudforum/3814588639/index.php?' . $frm_opt . '" title="Toggle the subscribed forums filter (will only show posts from the forums you are subscribed to)">Subscribed Forums ' . $s_subf . '</a>'; $unread_messages = ' | <a class="GenLink" href="/egroupware/fudforum/3814588639/index.php?' . $un_opt . '" title="Toggle unread message filter (will only show unread messages)">Unread Messages ' . $s_unread . '</a>'; } else { $subscribed_thr = $subscribed_frm = $unread_messages = ''; } $todays_posts = '<a class="GenLink" href="/egroupware/fudforum/3814588639/index.php?' . $dt_opt . '" title="Toggle today's posts filter (will only show posts made today)">Today's Posts ' . $s_today . '</a>'; $unanswered = ' | <a class="GenLink" href="/egroupware/fudforum/3814588639/index.php?' . $rp_opt . '" title="Toggle the un-answered posts filter (will show only posts that have no replies)">Unanswered Posts ' . $s_unu . '</a>'; make_perms_query($fields, $join); if (!$unread_limit) { $total = (int) q_singleval('SELECT count(*) FROM phpgw_fud_msg m INNER JOIN phpgw_fud_thread t ON m.thread_id=t.id INNER JOIN phpgw_fud_forum f ON t.forum_id=f.id INNER JOIN phpgw_fud_cat c ON f.cat_id=c.id ' . (isset($_GET['sub_forum_limit']) ? 'INNER JOIN phpgw_fud_forum_notify fn ON fn.forum_id=f.id AND fn.user_id=' . _uid : '') . ' ' . (isset($_GET['sub_th_limit']) ? 'INNER JOIN phpgw_fud_thread_notify tn ON tn.thread_id=t.id AND tn.user_id=' . _uid : '') . ' ' . $join . ' LEFT JOIN phpgw_fud_mod mm ON mm.forum_id=f.id AND mm.user_id=' . _uid . ' WHERE m.apr=1 ' . $date_limit . ' ' . ($frm_id ? ' AND f.id=' . $frm_id : '') . ' ' . ($th ? ' AND t.id=' . $th : '') . ' ' . (isset($_GET['reply_count']) ? ' AND t.replies=' . (int) $_GET['reply_count'] : '') . ' ' . $perm_limit); } if ($unread_limit || $total) { /* figure out the query */ $c = $query_type('SELECT m.*, t.thread_opt, t.root_msg_id, t.last_post_id, t.forum_id, f.message_threshold, f.name, u.id AS user_id, u.alias AS login, u.avatar_loc, u.email, u.posted_msg_count, u.join_date, u.location, u.sig, u.custom_status, u.icq, u.jabber, u.affero, u.aim, u.msnm, u.yahoo, u.last_visit AS time_sec, u.users_opt, l.name AS level_name, l.level_opt, l.img AS level_img, p.max_votes, p.expiry_date, p.creation_date, p.name AS poll_name, p.total_votes, pot.id AS cant_vote, r.last_view,
function forum_notify_del($user_id, $forum_id) { q('DELETE FROM phpgw_fud_forum_notify WHERE forum_id=' . $forum_id . ' AND user_id=' . $user_id); } /* make sure that we have what appears to be a valid forum id */ if (!isset($_GET['frm_id']) || !($frm_id = (int) $_GET['frm_id'])) { invl_inp_err(); } if (!isset($_GET['start']) || !($start = (int) $_GET['start'])) { $start = 0; } /* This query creates frm object that contains info about the current * forum, category & user's subscription status & permissions to the * forum. */ make_perms_query($fields, $join, $frm_id); $frm = db_sab('SELECT f.id, f.name, f.thread_count, c.name AS cat_name, fn.forum_id AS subscribed, m.forum_id AS md, a.ann_id AS is_ann, ' . $fields . ' FROM phpgw_fud_forum f INNER JOIN phpgw_fud_cat c ON c.id=f.cat_id LEFT JOIN phpgw_fud_forum_notify fn ON fn.user_id=' . _uid . ' AND fn.forum_id=' . $frm_id . ' LEFT JOIN phpgw_fud_mod m ON m.user_id=' . _uid . ' AND m.forum_id=' . $frm_id . ' ' . $join . ' LEFT JOIN phpgw_fud_ann_forums a ON a.forum_id=' . $frm_id . ' WHERE f.id=' . $frm_id . ' LIMIT 1'); if (!$frm) {