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'] = 'Ä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();?>