All pastes #736561 Raw Edit

Unbenannt

public php v1 · immutable
·published 2007-10-14 17:30 UTC
rendered paste body
<?php#   Copyright by Moniwoll#   Support per Ilch Communitydefined ('main') or die ( 'no direct access' );defined ('admin') or die ( 'only admin access' );$design = new design ( 'Admins Area', 'Admins Area', 2 );$design->header();function getcat ( $akt , $addcat='') {  $catAR = array();	$cat = '';	if (empty($addcat)) {	    $erg = db_query("SELECT DISTINCT cat FROM `prefix_tutorials`");    } else {        $erg = db_query("SELECT DISTINCT a.cat FROM ((SELECT DISTINCT cat FROM `prefix_tutorials`) UNION (SELECT '$addcat' AS cat)) AS a");        echo mysql_error();    }	while ($row = db_fetch_object($erg)) {		$catAr[] = $row->cat;	}  $catAr[] = 'HTML';	$catAr = array_unique($catAr);	foreach($catAr as $a) {	  if (trim($a) == trim($akt)) {		  $sel = ' selected';		} else {		  $sel = '';		}	  $cat .= '<option'.$sel.'>'.$a.'</option>';	}  return ($cat);}	$id = $menu->getA(1) == 'c' ? $menu->getE(1) : 0;	$sid = escape($_POST['sid'], 'integer');  $name = escape($_POST['name'], 'string');  $author = escape($_POST['author'], 'string');  $datum = escape($_POST['datum'], 'string'); 	   $txt = escape($_POST['txt'], 'string'); 	  $cat = $_POST['cat'] == 'neu' ? escape($_POST['newcat'],'string') : escape($_POST['cat'],'string');  		  if (isset($_POST['insert'])) {    $abf = "INSERT INTO `prefix_tutorials` ( `name` , `author` , `datum` , `txt` `cat` )            VALUES ( '$name', '$author', '$datum', '$txt', '$cat')";    db_query($abf);  } elseif (isset($_POST['change'])) {    db_query('UPDATE `prefix_tutorials` SET  `name`  = "'.$name.'",                                              `author` = "'.$author.'",                                              `datum` = "'.$datum.'",                                              `txt` = "'.$txt.'",                                              `cat` = "'.$cat.'"                                          WHERE id = "'.$sid.'"');  }  if ($menu->getA(1) == 'd' ) {    $delete = $menu->getE(1);    db_query('DELETE FROM `prefix_tutorials` WHERE id = "'.$delete.'" LIMIT 1');  }  if ( $id > 0 ) {    $abf = 'SELECT * FROM `prefix_tutorials` WHERE id = "'.$id.'"';    $erg = db_query($abf);    $row = db_fetch_assoc($erg);    $row['sub_val'] = '&Auml;ndern';    $row['sub'] = 'change';    $row['cat'] = getcat($row['cat']);  } else {    $row = array();    $row['sub_val'] = 'Eintragen';    $row['sub'] = 'insert';    $row['name'] = '';    $row['author'] = '';    $row['datum'] = '';    $row['txt'] = '';    $row['cat'] = getcat('neu');  }  $clas = '';  $tpl = new tpl ( 'tutorials', 0);  $tpl->set_ar_out($row,1);  $erg = db_query('SELECT * FROM `prefix_tutorials` ORDER BY id');  while ($row = db_fetch_assoc($erg) ) {     $clas = ($clas == 'Cmite' ? 'Cnorm' : 'Cmite' );          $row['class'] = $clas;          $tpl->set_ar_out($row,2);  }  $tpl->out(3);$design->footer();?>