header(); $tpl = new tpl('topic_select'); $tpl->out(0); if ( $menu->get(1) == 'del' ) { db_query('DELETE FROM `prefix_topics_select` WHERE tid = "'.$menu->get(2).'" LIMIT 1'); } $abf = db_query("SELECT * FROM prefix_topics_select WHERE uid = ".$_SESSION['authid']); while($row = db_fetch_object($abf)){ $erg = db_query("SELECT erstid FROM prefix_posts WHERE tid = ".$row->tid." ORDER BY id DESC"); echo mysql_error(); while($now = db_fetch_object($erg)){ if ($now->erstid == $_SESSION['authid']) { $stat = 'ja'; } else { $stat = 'nein'; } } $name = db_result(db_query("SELECT name FROM prefix_topics_select LEFT JOIN prefix_topics ON prefix_topics.id WHERE prefix_topics.id = ".$row->tid ) ,0); $tpl->set_ar_out( array( 'TID' => $row->tid, 'STATUS' => $stat, 'NAME' => $name ) , 1 ); } $tpl->out(2); $design->footer(); ?>