header(); if($_GET['delete']) { $faqID = $_GET['faqID']; db_query(" DELETE FROM prefix_faq WHERE faqID='$faqID' "); } elseif($_GET['delcat']) { $faqcatID = $_GET['faqcatID']; db_query("DELETE FROM prefix_faq WHERE faqcatID='$faqcatID'"); db_query("DELETE FROM prefix_faq_categories WHERE faqcatID='$faqcatID'"); $design->header(); } elseif($_POST['sortieren']) { $sortfaqcat = $_POST['sortfaqcat']; $sortfaq = $_POST['sortfaq']; if(is_array($sortfaqcat)) { foreach($sortfaqcat as $sortstring) { $sorter=explode("-", $sortstring); db_query("UPDATE prefix_faq_categories SET sort='$sorter[1]' WHERE faqcatID='$sorter[0]' "); } } if(is_array($sortfaq)) { foreach($sortfaq as $sortstring) { $sorter=explode("-", $sortstring); db_query("UPDATE prefix_faq SET sort='$sorter[1]' WHERE faqID='$sorter[0]' "); } } $design->header(); } elseif($_POST['save']) { $faqcat = $_POST['faqcat']; $question = $_POST['question']; $answer = $_POST['answer']; if($faqcat=="") $faqcat=0; db_query("INSERT INTO prefix_faq ( faqcatID, question, answer, sort ) values( '$faqcat', '$question', '$answer', '1' )"); $design->header(); } elseif($_POST['savecat']) { $faqcatname = $_POST['faqcatname']; $description = $_POST['description']; db_query("INSERT INTO prefix_faq_categories ( faqcatname, description, sort ) values( '$faqcatname', '$description', '1' )"); $design->header(); } elseif($_POST['saveedit']) { $faqcat = $_POST['faqcat']; $question = $_POST['question']; $answer = $_POST['answer']; $faqID = $_POST['faqID']; db_query("UPDATE prefix_faq SET faqcatID='$faqcat', question='$question', answer='$answer' WHERE faqID='$faqID' "); header("Location: admin.php?faq"); } elseif($_POST['saveeditcat']) { $faqcatname = $_POST['faqcatname']; $description = $_POST['description']; $faqcatID = $_POST['faqcatID']; db_query("UPDATE prefix_faq_categories SET faqcatname='$faqcatname', description='$description' WHERE faqcatID='$faqcatID' "); $design->header(); } echo'

FAQ

'; if($_GET['action']=="add") { // neue FAQ ertstellen $ergebnis=db_query("SELECT * FROM prefix_faq_categories ORDER BY sort"); $faqcats=''; echo'
Kategorie: '.$faqcats.'
FAQ:
Antwort:
 
'; } elseif($_GET['action']=="edit") { // FAQ bearbeiten $faqID = $_GET['faqID']; $ergebnis=db_query("SELECT * FROM prefix_faq WHERE faqID='$faqID'"); $ds=mysql_fetch_array($ergebnis); $faqcategory=db_query("SELECT * FROM prefix_faq_categories ORDER BY sort"); $faqcats=''; echo'
Kategorie: '.$faqcats.'
FAQ:
Antwort:
'; } elseif($_GET['action']=="addcat") { // Kategorie erstellen echo'
Kategorie Name:
Beschreibung:
 
'; } elseif($_GET['action']=="editcat") { // Kategorie bearbeiten $faqcatID = $_GET['faqcatID']; $ergebnis=db_query("SELECT * FROM prefix_faq_categories WHERE faqcatID='$faqcatID'"); $ds=mysql_fetch_array($ergebnis); echo'
Kategorie Name:
Beschreibung:
'; } else { echo'Neuen FAQ Eintrag  Neue Kategorie
'; echo'
'; $ergebnis=db_query("SELECT * FROM prefix_faq_categories ORDER BY sort"); $anz=db_query("SELECT count(faqcatID) FROM prefix_faq_categories"); $anz=mysql_result($anz, 0); while($ds=mysql_fetch_array($ergebnis)) { echo''; $faq=db_query("SELECT * FROM prefix_faq WHERE faqcatID='$ds[faqcatID]' ORDER BY sort"); $anzfaq=db_query("SELECT count(faqID) FROM prefix_faq WHERE faqcatID='$ds[faqcatID]'"); $anzfaq=mysql_result($anzfaq, 0); while($db=mysql_fetch_array($faq)) { echo''; } } $faq=db_query("SELECT * FROM prefix_faq WHERE faqcatID='0' ORDER BY sort"); $anzfaq=db_query("SELECT count(faqID) FROM prefix_faq WHERE faqcatID='0'"); $anzfaq=mysql_result($anzfaq, 0); while($db=mysql_fetch_array($faq)) { echo''; } echo'
FAQ: Aktion: Sortieren:
• '.$ds[faqcatname].'
'.$ds[description].'		  
- '.$db[question].'
'.$db[answer].'		  
'.$db[question].'  
 
'; } $design->footer(); ?>