Miscellany

<?php
#   Copyright by: Manuel Staechele
#   Support: www.ilch.de


defined ('main') or die ( 'no direct access' );
defined ('admin') or die ( 'only admin access' );


$design = new design ( 'Admins Area', 'Admins Area', 2 );
$design->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'<h2>FAQ</h2>';
if($_GET['action']=="add") {   // neue FAQ ertstellen
    $ergebnis=db_query("SELECT * FROM prefix_faq_categories ORDER BY sort");
    $faqcats='<select name="faqcat">';
	while($ds=mysql_fetch_array($ergebnis)) {
	    $faqcats.='<option value="'.$ds[faqcatID].'">'.$ds[faqcatname].'</option>';
	}
	$faqcats.='</select>';
		
	echo'<form method="post" action="admin.php?faq">
	     <table cellpadding="4" cellspacing="0">
		 <tr>
		   <td>Kategorie:</td>
		   <td>'.$faqcats.'</td>
		 </tr>
		 <tr>
		   <td>FAQ:</td>
		   <td><input type="text" name="question" size="91" class="form_off" onFocus="this.className=\'form_on\'" onBlur="this.className=\'form_off\'"></td>
		 </tr>
		 <tr>
		   <td>Antwort:</td>
		   <td><textarea cols="90" rows="10" name="answer" class="form_off" onFocus="this.className=\'form_on\'" onBlur="this.className=\'form_off\'"></textarea></td>
		 </tr>
		 <tr>
		   <td>&nbsp;</td>
		   <td><input type="submit" name="save" value="Senden"></td>
		 </tr>
		 </table>
		 </form>';
}

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='<select name="faqcat">';
	while($dc=mysql_fetch_array($faqcategory)) {
	    $faqcats.='<option value="'.$dc[faqcatID].'">'.$dc[faqcatname].'</option>';
	}
	$faqcats.='</select>';
		
	echo'<form method="post" action="admin.php?faq">
	     <table cellpadding="4" cellspacing="0">
		 <tr>
		   <td>Kategorie:</td>
		   <td>'.$faqcats.'</td>
		 </tr>
		 <tr>
		   <td>FAQ:</td>
		   <td><input type="text" name="question" value="'.$ds[question].'" size="91" class="form_off" onFocus="this.className=\'form_on\'" onBlur="this.className=\'form_off\'"></td>
		 </tr>
		 <tr>
		   <td>Antwort:</td>
		   <td><textarea cols="90" rows="10" name="answer" class="form_off" onFocus="this.className=\'form_on\'" onBlur="this.className=\'form_off\'">'.$ds[answer].'</textarea></td>
		 </tr>
		 <tr>
		   <td><input type="hidden" name="faqID" value="'.$faqID.'"></td>
		   <td><input type="submit" name="saveedit" value="Update"></td>
		 </tr>
		 </table>
		 </form>';
}

elseif($_GET['action']=="addcat") { // Kategorie erstellen
    echo'<form method="post" action="admin.php?faq" enctype="multipart/form-data">
	     <table cellpadding="4" cellspacing="0">
		 <tr>
		   <td>Kategorie Name:</td>
		   <td><input type="text" name="faqcatname" size="61" class="form_off" onFocus="this.className=\'form_on\'" onBlur="this.className=\'form_off\'"></td>
		 </tr>
		 <tr>
		   <td>Beschreibung:</td>
		   <td><textarea cols="60" rows="6" name="description" class="form_off" onFocus="this.className=\'form_on\'" onBlur="this.className=\'form_off\'"></textarea></td>
		 </tr>
		 <tr>
		   <td>&nbsp;</td>
		   <td><input type="submit" name="savecat" value="Senden"></td>
		 </tr>
		 </table>
		 </form>';
}

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'<form method="post" action="admin.php?faq">
	     <table cellpadding="4" cellspacing="0">
		 <tr>
		   <td>Kategorie Name:</td>
		   <td><input type="text" name="faqcatname" value="'.$ds[faqcatname].'" size="61" class="form_off" onFocus="this.className=\'form_on\'" onBlur="this.className=\'form_off\'"></td>
		 </tr>
		 <tr>
		   <td>Beschreibung:</td>
		   <td><textarea cols="60" rows="6" name="description" class="form_off" onFocus="this.className=\'form_on\'" onBlur="this.className=\'form_off\'">'.$ds[description].'</textarea></td>
		 </tr>
		 <tr>
		   <td><input type="hidden" name="faqcatID" value="'.$faqcatID.'"></td>
		   <td><input type="submit" name="saveeditcat" value="update"></td>
		 </tr>
		 </table>
		 </form>';
}
else {
	echo'<a href="admin.php?faq&action=add">Neuen FAQ Eintrag</a>&nbsp;
	     <a href="admin.php?faq&action=addcat">Neue Kategorie</a><br>';	

	echo'<form method="post" action="admin.php?faq">
		     <table width="100%" cellpadding="4" cellspacing="1" bgcolor="#999999">
		     <tr bgcolor="#CCCCCC">
			   <td class="Chead"><b><font color="#FFFFFF">FAQ:</font></b></td>
			   <td class="Chead"><b><font color="#FFFFFF">Aktion:</font></b></td>
			   <td class="Chead"><b><font color="#FFFFFF">Sortieren:</font></b></td>
			 </tr>';
			 
	$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'<tr><td colspan="3" class="Cdark"></td></tr>
		     <tr class="Cnorm">
		      <td width="470"><b>&#8226; '.$ds[faqcatname].'</b><br>'.$ds[description].'</td>
			    <td><a href="admin.php?faq&action=editcat&faqcatID='.$ds[faqcatID].'"><img src="include/images/icons/edit.gif"></a>&nbsp;<a href="admin.php?faq&delcat=true&faqcatID='.$ds[faqcatID].'"><img src="include/images/icons/del.gif"></a></td>
			   <td>
			     <select name="sortfaqcat[]">';
		for($n=1; $n<=$anz; $n++) {
		    if($ds[sort] == $n) echo'<option value="'.$ds[faqcatID].'-'.$n.'" selected>'.$n.'</option>';
			else echo'<option value="'.$ds[faqcatID].'-'.$n.'">'.$n.'</option>';
	       }		
	    echo'</select></td>
		     </tr>
			 <tr><td colspan="3" class="Cdark"></td></tr>';		 
		
	    $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'<tr>
		          <td class="Cmite" width="470"><b>- '.$db[question].'</b><br>'.$db[answer].'</td>
		          <td class="Cmite">
				  <a href="admin.php?faq&action=edit&faqID='.$ds[faqcatID].'"><img src="include/images/icons/edit.gif"></a> &nbsp;
				  <a href="admin.php?faq&del=true&faqID='.$ds[faqcatID].'"><img src="include/images/icons/del.gif"></a>
				  </td>
		          <td class="Cmite">
		            <select name="sortfaq[]">';
	        for($j=1; $j<=$anzfaq; $j++) {
	            if($db[sort] == $j) echo'<option value="'.$db[faqID].'-'.$j.'" selected>'.$j.'</option>';
		        else echo'<option value="'.$db[faqID].'-'.$j.'">'.$j.'</option>';
	           }		
	           echo'   </select>
	             </td>
	           </tr>';
		}
	}	 
	
	$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'<tr bgcolor="dcdcdc">
	          <td bgcolor="#FFFFFF"><b>'.$db[question].'</b></td>
	          <td bgcolor="#FFFFFF">
				  <a href="admin.php?faq&action=editcat&faqcatID='.$ds[faqcatID].'"><img src="include/images/icons/edit.gif"></a> &nbsp;
				  <a href="admin.php?faq&delcat=true&faqcatID='.$ds[faqcatID].'"><img src="include/images/icons/del.gif"></a>
				  </td>
	          <td bgcolor="#FFFFFF">
	            <select name="sort[]">';
		for($n=1; $n<=$anzfaq; $n++) {
	    	if($ds[sort] == $n) echo'<option value="'.$db[faqID].'-'.$n.'" selected>'.$n.'</option>';
	        else echo'<option value="'.$db[faqID].'-'.$n.'">'.$n.'</option>';
		}
		echo'</select></td></tr>';
	}
	
	echo'<tr class="Cnorm">
		       <td>&nbsp;</td>
			   <td colspan="3" align="right"><input type="submit" name="sortieren" value="Sortieren"></td>
			 </tr>
			 </table></form>';
}
$design->footer();
?>