"); if (!isset($usr_grps) || !isNum($usr_grps)) $usr_grps=""; $result = dbquery( "SELECT tf.*, tt.*, tu.user_id,user_name,user_color,user_prefix FROM ".$db_prefix."forums tf INNER JOIN ".$db_prefix."threads tt USING(forum_id) INNER JOIN ".$db_prefix."users tu ON tt.thread_lastuser=tu.user_id ".$usr_grps." ORDER BY thread_lastpost DESC LIMIT 0,12"); if (dbrows($result) != 0) { $i=0; if ($theme_width == "100%") echo "\n"; while ($data = dbarray($result)) { if ($i % 2 == 0) { $row_color = "tbl1"; } else { $row_color = "tbl1"; } $new_posts = dbcount("(thread_id)", "posts", "thread_id='".$data['thread_id']."' and post_datestamp>'".(isset($lastvisited) ? $lastvisited : 0)."'"); //$thread_replies = dbcount("(thread_id)", "posts", "thread_id='".$data['thread_id']."'") - 1; $thread_replies = $data['thread_replies']; $forum_id = $data['forum_id']; if ($new_posts > 0) { $folder123 = "

"; } else if ($new_posts > 19) { $folder123 = "

"; } else { if ($data['thread_locked'] == 1) { $folder123 = "

"; } else if ($data['thread_locked'] == 0) { $folder123 = "

"; } } //$reply_count = dbcount("(thread_id)", "posts", "thread_id='".$data['thread_id']."'"); $reply_count = $data['thread_replies']+1; $data2 = dbarray(dbquery("SELECT post_id FROM ".$db_prefix."posts WHERE thread_id='".$data['thread_id']."' ORDER BY post_id DESC LIMIT 1")); $threads_message = $data['thread_subject']; $threads_message = str_replace("'", "", $threads_message); $rstart = ($reply_count > 20 ? "rowstart=".((ceil($reply_count / 20)-1)*20)."&" : ""); echo "\n"; echo ""; } else { echo "$folder123 ".trimlink($data['thread_subject'], 16)."
\n"; echo ""; } echo "

"; if ($theme_width == "100%") { echo "$folder123 ".trimlink($data['thread_subject'], 16)."

[ ".($reply_count - 1)." / ".$data['thread_views']." ]