header(); if($_GET['delete']) { $faqID = $_GET['faqID']; safe_query(" DELETE FROM ic1_faq WHERE faqID='$faqID' "); } elseif($_GET['delcat']) { $faqcatID = $_GET['faqcatID']; safe_query("DELETE FROM ic1_faq WHERE faqcatID='$faqcatID'"); safe_query("DELETE FROM ic1_faq_categories WHERE faqcatID='$faqcatID'"); header("Location: admin.php?faq"); } elseif($_POST['sortieren']) { $sortfaqcat = $_POST['sortfaqcat']; $sortfaq = $_POST['sortfaq']; if(is_array($sortfaqcat)) { foreach($sortfaqcat as $sortstring) { $sorter=explode("-", $sortstring); safe_query("UPDATE ic1_faq_categories SET sort='$sorter[1]' WHERE faqcatID='$sorter[0]' "); } } if(is_array($sortfaq)) { foreach($sortfaq as $sortstring) { $sorter=explode("-", $sortstring); safe_query("UPDATE ic1_faq SET sort='$sorter[1]' WHERE faqID='$sorter[0]' "); } } header("Location: admin.php?faq"); } elseif($_POST['save']) { $faqcat = $_POST['faqcat']; $question = $_POST['question']; $answer = $_POST['answer']; if($faqcat=="") $faqcat=0; safe_query("INSERT INTO ic1_faq ( faqcatID, question, answer, sort ) values( '$faqcat', '$question', '$answer', '1' )"); header("Location: admin.php?faq"); } elseif($_POST['savecat']) { $faqcatname = $_POST['faqcatname']; $description = $_POST['description']; safe_query("INSERT INTO ic1_faq_categories ( faqcatname, description, sort ) values( '$faqcatname', '$description', '1' )"); header("Location: admin.php?faq"); } elseif($_POST['saveedit']) { $faqcat = $_POST['faqcat']; $question = $_POST['question']; $answer = $_POST['answer']; $faqID = $_POST['faqID']; safe_query("UPDATE ic1_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']; safe_query("UPDATE ic1_faq_categories SET faqcatname='$faqcatname', description='$description' WHERE faqcatID='$faqcatID' "); header("Location: admin.php?faq"); } echo'

FAQ

'; if($_GET['action']=="add") { // neue FAQ ertstellen $ergebnis=safe_query("SELECT * FROM ic1_faq_categories ORDER BY sort"); $faqcats=''; echo'
Category: '.$faqcats.'
FAQ:
Answer:
 
'; } elseif($_GET['action']=="edit") { // FAQ bearbeiten $faqID = $_GET['faqID']; $ergebnis=safe_query("SELECT * FROM ic1_faq WHERE faqID='$faqID'"); $ds=mysql_fetch_array($ergebnis); $faqcategory=safe_query("SELECT * FROM ic1_faq_categories ORDER BY sort"); $faqcats=''; echo'
Category: '.$faqcats.'
FAQ:
Answer:
'; } elseif($_GET['action']=="addcat") { // Kategorie erstellen echo'
Category Name:
Description:
 
'; } elseif($_GET['action']=="editcat") { // Kategorie bearbeiten $faqcatID = $_GET['faqcatID']; $ergebnis=safe_query("SELECT * FROM ic1_faq_categories WHERE faqcatID='$faqcatID'"); $ds=mysql_fetch_array($ergebnis); echo'
Category Name:
Description:
'; } else { echo' '; echo'
'; $ergebnis=db_query("SELECT * FROM ic1_faq_categories ORDER BY sort"); $anz=db_query("SELECT count(faqcatID) FROM ic1_faq_categories"); $anz=mysql_result($anz, 0); while($ds=mysql_fetch_array($ergebnis)) { echo''; $faq=safe_query("SELECT * FROM ic1_faq WHERE faqcatID='$ds[faqcatID]' ORDER BY sort"); $anzfaq=safe_query("SELECT count(faqID) FROM ic1_faq WHERE faqcatID='$ds[faqcatID]'"); $anzfaq=mysql_result($anzfaq, 0); while($db=mysql_fetch_array($faq)) { echo''; } } $faq=db_query("SELECT * FROM ic1_faq WHERE faqcatID='0' ORDER BY sort"); $anzfaq=db_query("SELECT count(faqID) FROM ic1_faq WHERE faqcatID='0'"); $anzfaq=mysql_result($anzfaq, 0); while($db=mysql_fetch_array($faq)) { echo''; } echo'
FAQ: Actions: Sort:
• '.$ds[faqcatname].'
'.$ds[description].'
- '.$db[question].'
'.$db[answer].'
'.$db[question].'
 
'; } ?>