echo ""; echo" "; if (!isset($usr_grps)) $usr_grps=""; $result = dbquery( "SELECT tf.*, tt.*, tu.user_id,user_name FROM fusion_forums tf INNER JOIN fusion_threads tt USING(forum_id) INNER JOIN fusion_users tu ON tt.thread_lastuser=tu.user_id ".$usr_grps." ORDER BY thread_lastpost DESC LIMIT 0,8"); 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>'$lastvisited'"); $thread_replies = dbcount("(thread_id)", "posts", "thread_id='".$data['thread_id']."'") - 1; $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']."'"); $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 = strtr($threads_message, "'", ""); $rstart = ($reply_count > 20 ? "rowstart=".((ceil($reply_count / 20)-1)*20)."&" : ""); echo "\n"; echo ""; } else { echo "$folder123 Najnowsze posty w serwisie:

".$locale['XXX_019']."Temat: ".$threads_message."

".$locale['XXX_020']."Odp/Wy¶w: ".($reply_count - 1)."/".$data['thread_views']."
".$locale['XXX_021']."Ostatni wpis: ".$data['user_name']."
".$locale['XXX_022']."Data: ".showdate("forumdate", $data['thread_lastpost']).";')\"'>".trimlink($data['thread_subject'], 20)."
\n"; echo ""; } echo "

"; if ($theme_width == "100%") { echo "$folder123 ° ".$locale['XXX_017']." °

".$locale['XXX_019'].": ".$threads_message."

".$locale['XXX_020'].": ".($reply_count - 1)."/".$data['thread_views']."
".$locale['XXX_021'].": ".$data['user_prefix'].$data['user_name']."
".$locale['XXX_022'].": ".showdate("forumdate", $data['thread_lastpost'])."$end')\"' onMouseout=\"hideddrivetip()\" >".trimlink($data['thread_subject'], 16)."

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

"; $i++; } } else { echo "".$locale['004']."\n"; }