\n"; $forum_list = ""; $current_cat = ""; $result = dbquery( "SELECT f.*, COUNT(t.thread_id) AS thread_count, MAX(t.thread_lastpost) AS last_post, f2.forum_name AS forum_cat_name, u.user_id, u.user_name FROM ".$db_prefix."forums f LEFT JOIN ".$db_prefix."threads t USING(forum_id) LEFT JOIN ".$db_prefix."forums f2 ON f.forum_cat = f2.forum_id LEFT JOIN ".$db_prefix."users u ON f.forum_lastuser = u.user_id WHERE ".groupaccess('f.forum_access')." AND f.forum_cat!='0' AND f.forum_sub='$forum_id' GROUP BY forum_id ORDER BY f2.forum_order ASC, f.forum_order ASC" ); while ($data = dbarray($result)) { $moderators = ""; if ($data['forum_moderators']) { $res = "user_id='".str_replace(".", "' OR user_id='", $data['forum_moderators'])."'"; $result2 = dbquery("SELECT user_id,user_name FROM ".$db_prefix."users WHERE (".$res.")"); while ($data2 = dbarray($result2)) { if ($moderators) $moderators .= ", "; $moderators .= "".$data2['user_name'].""; } } if ($data['last_post'] > $lastvisited) { $fim = "

"; } else { $fim = "

"; } echo "\n" : "\n")." \n\n"; } else { echo showdate("forumdate", $data['forum_lastpost'])."
".$locale['406']."".$data['user_name']."\n"; } } echo "

".$locale['401']."			".$locale['402']."	".$locale['403']."	".$locale['404']."
".($data['forum_icon'] == "" ? "" : "")."	$fim	".$data['forum_name']." ".$data['forum_description'].($moderators ? " \n".$locale['411'].$moderators."	".$data['thread_count']."	".dbcount("(post_id)", "posts", "forum_id='".$data['forum_id']."'")."	"; if ($data['forum_lastpost'] == 0) { echo $locale['405']."

"; closetable(); tablebreak(); } opentable($locale['450']); echo "\n"; if (iMEMBER && $can_post) { echo "\n"; } echo "

".$settings['sitename']." | $caption

\n"; $rows = dbrows(dbquery("SELECT * FROM ".$db_prefix."threads WHERE forum_id='$forum_id' AND thread_sticky='0'")); if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0; if ($rows > $threads_per_page) { echo "

".makePageNav($rowstart,20,$rows,3,FUSION_SELF."?forum_id=$forum_id&")."

\n"; } echo "

"; if ($data['info'] != "") { echo ""; } echo " \n"; if ($rowstart == 0) { $result = dbquery( "SELECT t.*, COUNT(p.post_id) AS thread_replies, tu1.user_name AS user_author, tu2.user_name AS user_lastuser FROM ".$db_prefix."threads t LEFT JOIN ".$db_prefix."posts p USING(thread_id) LEFT JOIN ".$db_prefix."users tu1 ON t.thread_author = tu1.user_id LEFT JOIN ".$db_prefix."users tu2 ON t.thread_lastuser = tu2.user_id WHERE t.forum_id='$forum_id' AND thread_sticky='1' GROUP BY thread_id ORDER BY thread_lastpost DESC" ); if (dbrows($result) != 0) { while ($data = dbarray($result)) { if ($data['thread_locked']) { echo "\n"; } else { if ($data['thread_lastpost'] > $lastvisited) { $folder = " ".$locale[

"; } else { $folder = " ".$locale[

"; } echo "\n"; } $reps = ceil($data['thread_replies'] / $threads_per_page); $threadsubject = "".$data['thread_subject'].""; if ($reps > 1) { $ctr = 0; $ctr2 = 1; $pages = ""; while ($ctr2 <= $reps) { $pnum = "$ctr2 "; $pages = $pages.$pnum; $ctr = $ctr + $threads_per_page; $ctr2++; } $threadsubject .= " - (".$locale['412'].trim($pages).")"; } echo "\n"; } $threadcount = dbrows($result); } else { $threadcount = 0; } } if ($rows != 0) { $result = dbquery( "SELECT t.*, COUNT(p.post_id) AS thread_replies, tu1.user_name AS user_author, tu2.user_name AS user_lastuser FROM ".$db_prefix."threads t LEFT JOIN ".$db_prefix."posts p USING(thread_id) LEFT JOIN ".$db_prefix."users tu1 ON t.thread_author = tu1.user_id LEFT JOIN ".$db_prefix."users tu2 ON t.thread_lastuser = tu2.user_id WHERE t.forum_id='$forum_id' AND thread_sticky='0' GROUP BY thread_id ORDER BY thread_lastpost DESC LIMIT $rowstart,20" ); $numrows = dbrows($result); while ($data = dbarray($result)) { if ($data['thread_locked']) { echo "\n"; } else { if ($data['thread_lastpost'] > $lastvisited) { $folder = " ".$locale[

"; } else { $folder = "

Info	".$data['info']."
	".$locale['451']."	".$locale['452']."	".$locale['453']."	".$locale['454']."	".$locale['404']."

$folder	$threadsubject	".$data['user_author']."	".$data['thread_views']."	".($data['thread_replies']-1)."	".showdate("forumdate", $data['thread_lastpost'])." ".$locale['406']."".$data['user_lastuser']."

$folder	$threadsubject	".$data['user_author']."	".$data['thread_views']."	".($data['thread_replies']-1)."	".showdate("forumdate", $data['thread_lastpost'])." ".$locale['406']."".$data['user_lastuser']."
".$locale['455']."

\n"; if ($rows > $threads_per_page) { echo "

".makePageNav($rowstart,20,$rows,3,FUSION_SELF."?forum_id=$forum_id&")."

\n"; } $forum_list = ""; $current_cat = ""; $result = dbquery( "SELECT f.forum_id, f.forum_name, f2.forum_name AS forum_cat_name FROM ".$db_prefix."forums f INNER JOIN ".$db_prefix."forums f2 ON f.forum_cat=f2.forum_id WHERE ".groupaccess('f.forum_access')." AND f.forum_cat!='0' ORDER BY f2.forum_order ASC, f.forum_order ASC" ); while ($data2 = dbarray($result)) { if ($data2['forum_cat_name'] != $current_cat) { if ($current_cat != "") $forum_list .= "\n"; $current_cat = $data2['forum_cat_name']; $forum_list .= "\n"; } $sel = ($data2['forum_id'] == $data['forum_id'] ? " selected" : ""); $forum_list .= "\n"; } $forum_list .= "\n"; echo "\n"; if (iMEMBER && $can_post) { echo "\n"; } echo "

".$locale['540']."

\n"; echo "

- ".$locale['456']."(

- ".$locale['457']." )

- ".$locale['458']."

- ".$locale['459']."

- ".$locale['460']."

\n"; closetable(); echo "\n"; require_once BASEDIR."side_right.php"; require_once BASEDIR."footer.php"; ?>