Public feed #723314

Zeug

public text v1 · immutable
Raw Edit
·published 2007-10-02 18:24 UTC
rendered paste body
<?php 
#   Copyright by: Manuel Staechele
#   Support: www.ilch.de


defined ('main') or die ( 'no direct access' );
$title = $allgAr['title'].' :: Beobachtete Themen'; 
$hmenu = 'Beobachtete Themen '; 
$design = new design ( $title , $hmenu ); 

$design->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(); 
?>