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 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 LEFT JOIN phpgw_fud_users u ON m.poster_id=u.id LEFT JOIN phpgw_fud_level l ON u.level_id=l.id LEFT JOIN phpgw_fud_poll p ON m.poll_id=p.id LEFT JOIN phpgw_fud_poll_opt_track pot ON pot.poll_id=p.id AND pot.user_id=' . _uid . ' WHERE m.id=' . $mid . ' AND m.apr=1'); if (!isset($_GET['prevloaded'])) { th_inc_view_count($th); if (_uid) { if ($frm->last_view < $msg_obj->post_stamp) { user_register_thread_view($th, $msg_obj->post_stamp, $mid); } if ($frm->last_forum_view < $msg_obj->post_stamp) { user_register_forum_view($frm->forum_id); } } $subscribe_status = $frm->subscribed ? '| <a class="GenLink" href="/egroupware/fudforum/3814588639/index.php?t=tree&th=' . $th . '&notify=' . $usr->id . '&' . _rsid . '&opt=off&mid=' . $mid . '" title="Stop receiving notifications about new posts in this topic">Unsubscribe from topic</a> ' : '| <a class="GenLink" href="/egroupware/fudforum/3814588639/index.php?t=tree&th=' . $th . '&notify=' . $usr->id . '&' . _rsid . '&opt=on&mid=' . $mid . '" title="Receive notification about new posts inside this topic">Subscribe to topic</a> '; } else { $subscribe_status = ''; } ses_update_status($usr->sid, 'Browsing topic (tree view) <a class="GenLink" href="/egroupware/fudforum/3814588639/index.php?t=tree&th=' . $frm->id . '&' . _rsid . '">' . $frm->subject . '</a>', $frm->id); function tmpl_create_forum_select($frm_id, $mod) {
LEFT JOIN phpgw_fud_poll p ON m.poll_id=p.id LEFT JOIN phpgw_fud_poll_opt_track pot ON pot.poll_id=p.id AND pot.user_id=' . _uid . ' WHERE m.thread_id=' . $_GET['th'] . ' AND m.apr=1 ORDER BY m.id ASC LIMIT ' . qry_limit($count, $_GET['start'])); $obj2 = $message_data = ''; $usr->md = $frm->md; $m_num = 0; while ($obj = db_rowobj($result)) { $message_data .= tmpl_drawmsg($obj, $usr, $perms, false, $m_num, array($_GET['start'], $count)); $obj2 = $obj; } unset($result); un_register_fps(); if (!isset($_GET['prevloaded'])) { th_inc_view_count($frm->id); if (_uid && $obj2) { if ($frm->last_forum_view < $obj2->post_stamp) { user_register_forum_view($frm->forum_id); } if ($frm->last_view < $obj2->post_stamp) { user_register_thread_view($frm->id, $obj2->post_stamp, $obj2->id); } } } $page_pager = tmpl_create_pager($_GET['start'], $count, $total, '/egroupware/fudforum/3814588639/index.php?t=msg&th=' . $_GET['th'] . '&prevloaded=1&' . _rsid . reveal_lnk . unignore_tmp); get_prev_next_th_id($frm, $prev_thread_link, $next_thread_link); $pdf_link = $FUD_OPT_2 & 2097152 ? '[ <a href="' . $GLOBALS['WWW_ROOT'] . 'pdf.php?th=' . $_GET['th'] . '">Generate printable PDF</a> ]' : ''; $xml_link = $FUD_OPT_2 & 1048576 ? '[ <a href="/egroupware/fudforum/3814588639/index.php?t=help_index&section=boardusage#syndicate">Syndicate this forum (XML)</a> ]' : ''; if ($FUD_OPT_2 & 2) { $page_gen_end = gettimeofday();