'0' AND forum_id = forumid AND groupid = '$ug' ORDER BY topic_post_time DESC"; if($site == 1){$start = 0;}else{$start = $site * $eintraege_pro_seite - $eintraege_pro_seite;} $go = " LIMIT 0, 7"; $sql = @mysql_query("SELECT *".$from.$where.$go); while ($data = @mysql_fetch_array($sql)){ $topic_id = $data["topic_id"]; $topic_userid = $data["topic_userid"]; $topic_time = $data["topic_time"]; $topic_title = $data["topic_title"]; $forum_id = $data["forum_id"]; $topic_count = $data["topic_count"]; $topic_status = $data["topic_status"]; // Autor ermitteln $user_sql = @mysql_query("SELECT * FROM users WHERE user_id = '$topic_userid'"); $user_data = @mysql_fetch_array($user_sql); $uname = $user_data["user_name"]; if($uname){$uname = $uname;}else{$uname = "Gast";} // Letzter Beitrag $user_sql = @mysql_query("SELECT * FROM forum_posts WHERE post_topic = '$topic_id' ORDER BY post_time DESC"); $user_data = @mysql_fetch_array($user_sql); $post_uid = $user_data["post_userid"]; $post_time = date('d.m.y | H:i', $user_data["post_time"]); // Autor des letzten Beitrages ermitteln $user_sql = mysql_query("SELECT * FROM users WHERE user_id = '$post_uid'"); $user_data = mysql_fetch_array($user_sql); $last_user = $user_data["user_name"]; if($last_user){$last_user = $last_user;}else{$last_user = "Gast";} $daten = "Von: $last_user
"; $daten .= "Am: $post_time Uhr
"; $info = "onmouseover=\"Tip('$daten')\" onmouseout=\"UnTip()\""; // Berechnen auf welcher Seite der letzte Beitrag steht $resultID = @mysql_query("SELECT COUNT(*) FROM forum_posts WHERE post_topic = '$topic_id'"); $post_site = ceil(@mysql_result($resultID, 0)/$eintraege_pro_seite); // Post ID des letzten Posts ermitteln $resultID = @mysql_query("SELECT post_id FROM forum_posts WHERE post_topic = '$topic_id' ORDER BY post_time DESC"); $post_id = @mysql_result($resultID, 0); // Liste anzeigen echo(" "); } echo "

	$topic_title
	Die Letzten 100 Topics

"; ?>