"), array("forum.php4?id=$id") ); eval ("echo \"$tmpl_header\";"); eval ("echo \"$tmpl_boardheader\";"); $bdata = mysql_query("SELECT id,name,mods,threads,posts,lastmodified,description,password FROM ebb_boards WHERE forum='$id' ORDER BY displayorder asc"); while(list($bid,$boardname,$moderator,$topics,$posts,$modified,$desc,$board_password) = mysql_fetch_row($bdata)) { if (!$moderator) { $moderator = " "; } else list($moderator_id) = mysql_fetch_row(mysql_query("SELECT id FROM ebb_user WHERE name='$moderator'")); if($board_password) $boardname_info = "(Geschützt)"; else $boardname_info = ""; if($modified > $ebb_lastvisited) $new_or_not = "
"; else $new_or_not = "
"; $modified_string = HackDate($modified); list($ltid) = mysql_fetch_row(mysql_query("SELECT id FROM ebb_threads WHERE boardid='$bid' order by lastreply desc")); list($bla_id,$last_post_userid) = mysql_fetch_row(mysql_query("SELECT id,author FROM ebb_posts WHERE threadid='$ltid' order by posttime desc")); list($a_name,$a_sign) = mysql_fetch_row(mysql_query("SELECT name,sign FROM ebb_user WHERE id='$last_post_userid'")); /* list($a_name,$a_sign) = mysql_fetch_row(mysql_query(" SELECT name,sign FROM ebb_user WHERE id IN ( SELECT author FROM ebb_posts WHERE threadid IN ( SELECT id FROM ebb_threads WHERE boardid='$bid' order by id desc ) order by id desc) ")); */ $last_post_by = "$a_sign $a_name"; eval ("echo \"$tmpl_boardrow\";"); } eval ("echo \"$tmpl_boardfooter\";"); eval ("echo \"$tmpl_footer\";"); ?>