diff options
Diffstat (limited to 'www-ssl')
-rw-r--r-- | www-ssl/admin/faq.1.php | 6 | ||||
-rw-r--r-- | www-ssl/admin/faq.php | 271 | ||||
-rw-r--r-- | www-ssl/css/base.css | 5 | ||||
-rw-r--r-- | www-ssl/index.php | 4 | ||||
-rw-r--r-- | www-ssl/nonpublic/faq.php | 73 |
5 files changed, 9 insertions, 350 deletions
diff --git a/www-ssl/admin/faq.1.php b/www-ssl/admin/faq.1.php deleted file mode 100644 index 04dda6aa..00000000 --- a/www-ssl/admin/faq.1.php +++ /dev/null @@ -1,6 +0,0 @@ -<h4 class="menu"> Anfragen und FAQ </h4> - -<li><a href="faq.php?quest=all">Alle Anfragen</a></li> -<li><a href="faq.php?quest=open">Offene Anfragen (<?php echo noAnswer(); ?>)</a></li> -<li><a href="faq.php?quest=faq">FAQ-Liste editiern</a></li> - diff --git a/www-ssl/admin/faq.php b/www-ssl/admin/faq.php deleted file mode 100644 index 779d8822..00000000 --- a/www-ssl/admin/faq.php +++ /dev/null @@ -1,271 +0,0 @@ -<?php -require_once ('../bootstrap.php'); - -$title = "Himmel"; -$header = "FAQ / Fragen an die Erzengel"; -$submenus = 1; -include ("includes/header.php"); -include ("includes/funktion_db.php"); - -//var init -$quest_bearb = 0; - -if (IsSet ($_GET["quest"])) { - - switch ($_GET["quest"]) { - - // *--------------------------------------------------------------------------- - // * Anfragen - Bearbeitung - // *--------------------------------------------------------------------------- - // * je nach �bergabeoption ($quest) koennen Anfragen beantwortet werden oder - // * als FAQ uebergeben werden - // *--------------------------------------------------------------------------- - - case "all" : - $SQL = "SELECT * FROM `Questions` ORDER BY QID DESC"; -?> - Alle Anfragen:<br /> - <table width="100%" class="border" cellpadding="2" cellspacing="1"> - <tr class="contenttopic"> - <th>Frage</th> - <th>Anfragender</th> - <th>Beantwortet?</th> - <th>Antwort</th> - <th>Antwort von</th> - <th>change</th> - </tr> - -<?php - - - $Erg = mysql_query($SQL, $con); - // anzahl zeilen - $Zeilen = mysql_num_rows($Erg); - for ($n = 0; $n < $Zeilen; $n++) { - echo "<tr class=\"content\">\n"; - echo "<td>" . mysql_result($Erg, $n, "Question") . "</td>\n"; - echo "<td>" . UID2Nick(mysql_result($Erg, $n, "UID")) . "</td>\n"; - echo "<td>"; - if (mysql_result($Erg, $n, "AID") > 0) { - echo "Ja</td>\n"; - echo "<td>" . mysql_result($Erg, $n, "Answer") . "</td>\n"; - echo "<td>" . UID2Nick(mysql_result($Erg, $n, "AID")) . "</td>\n"; - } else { - echo "Nein</td>\n"; - echo "<td> </td>\n"; - echo "<td> </td>\n"; - } - echo "<td><a href=\"faq.php?quest=edit&QID=" . mysql_result($Erg, $n, "QID") . "\">xxx</a></td>"; - echo "</tr>\n"; - } - echo "</table>\n"; - break; - - case "open" : - $SQL = "SELECT * FROM `Questions` WHERE `AID`='0' ORDER BY `QID` DESC"; - $quest_bearb = 1; // Fragenliste anzeigen - echo "\t\tOffene Anfragen:<br />\n"; - break; - - case "edit" : - if (!IsSet ($_GET["QID"])) - echo "\t\tFehlerhafter Aufruf...<br />Bitte die Bearbeitung nochmals beginnen :)\n"; - else { - $SQL = "SELECT * FROM `Questions` WHERE `QID`='" . $_GET["QID"] . "'"; - $Erg = mysql_query($SQL, $con); - echo "\t\t<form action=\"./faq.php\" method=\"GET\">\n"; - echo "\t\tAnfrage von <b>" . UID2NICK(mysql_result($Erg, 0, "UID")) . "</b>:<br />\n"; - echo "\t\t<textarea name=\"Question\" rows=\"3\" cols=\"80\">" . - mysql_result($Erg, 0, "Question") . "</textarea>\n"; - echo "<br /><br />Antwort der Erzengel:<br />\n"; - if (mysql_result($Erg, 0, "Answer") == "") - echo "\t\t<textarea name=\"Answer\" rows=\"5\" cols=\"80\">" . - "Bitte hier die Antwort eintragen...</textarea><br />\n"; - else - echo "\t\t<textarea name=\"Answer\" rows=\"5\" cols=\"80\">" . - mysql_result($Erg, 0, "Answer") . "</textarea>\n<br />\n"; - echo "\t\t<input type=\"hidden\" name=\"QID\" value=\"" . $_GET["QID"] . "\">\n"; - echo "\t\t<input type=\"hidden\" name=\"quest\" value=\"save\">\n"; - echo "\t\t<input type=\"submit\" value=\"Sichern...\">\n"; - echo "\t</form>\n"; - if (mysql_result($Erg, 0, "AID") <> "0") { - echo "\tDu kannst diese Anfrage so wie sie ist, als Engel-FAQ eintrag übernehmen.<br />\n"; - echo "<a href=\"./faq.php?quest=transfer&QID=" . $_GET["QID"] . "\">Als FAQ-Eintrag sichern...</a>\n"; - } - } // Abfrage der QID - break; - - case "save" : - if (!IsSet ($_GET["QID"])) - echo "\tFehlerhafter Aufruf... Bitte die Bearbeitung nochmal starten..."; - else { - $SQL = "UPDATE `Questions` SET `Question`='" . $_GET["Question"] . - "', `AID`='" . $_SESSION['UID'] . "' , `Answer`='" . $_GET["Answer"] . "' " . - "WHERE `QID`='" . $_GET["QID"] . "' LIMIT 1"; - $Erg = db_query($SQL, "save Question"); - if ($Erg == 1) { - echo "\tDer Eintrag wurde geändert<br />\n"; - SetHeaderGo2Back(); - } else - echo "\tEin Fehler ist aufgetreten. Sorry, du kannst es aber ja nochmal probieren :)\n"; - } - break; - - case "transfer" : - if (!IsSet ($_GET["QID"])) - echo "\tFehlerhafter Aufruf... Bitte die Bearbeitung nochmal starten...\n"; - else { - $SQL1 = "SELECT * FROM `Questions` WHERE `QID`='" . $_GET["QID"] . "'"; - $Erg = mysql_query($SQL1, $con); - $SQL2 = "INSERT INTO `FAQ` Values ('', '" . - mysql_result($Erg, 0, "Question") . "', '" . mysql_result($Erg, 0, "Answer") . "')"; - $Erg = db_query($SQL2, "trasfert to request to the FAQ"); - if ($Erg == 1) - echo "\tDer Eintrag wurde übertragen.<br />\n"; - else - echo "\tEin Fehler ist aufgetreten. Sorry, du kannst es aber ja nochmal probieren :)\n"; - } - - break; - - // *--------------------------------------------------------------------------- - // * FAQ - Bearbeitung - // *--------------------------------------------------------------------------- - // * je nach �bergabeoption ($quest) koennen FAQ's erfasst werden, - // * geaendert oder geloscht werden... - // *--------------------------------------------------------------------------- - case "faq" : - $quest_bearb = 0; // keine Fragenliste anzeigen, FAQ editieren... - echo "\tFAQ-Liste:<br />"; - echo "<a href=\"./faq.php?quest=faqnew\">Neuen Eintrag</a>"; - - $SQL = "SELECT * FROM `FAQ`"; - $Erg = mysql_query($SQL, $con); - - // anzahl zeilen - $Zeilen = mysql_num_rows($Erg); - - for ($n = 0; $n < $Zeilen; $n++) - if (mysql_result($Erg, $n, "Antwort") != "") { - echo "\t<p class=\"question\">" . mysql_result($Erg, $n, "Frage") . "</p>\n"; - echo "\t<p class=\"answetion\">" . mysql_result($Erg, $n, "Antwort") . "</p>\n"; - echo "\t<a href=\"./faq.php?quest=faqedit&FAQID=" . mysql_result($Erg, $n, "FID") . - "\">Bearbeiten</a>\n<br />---<br />\n"; - } - break; - - case "faqedit" : - if (!IsSet ($_GET["FAQID"])) - echo "\tFehlerhafter Aufruf...<br />Bitte die Bearbeitung nochmals beginnen :)\n"; - else { - $SQL = "SELECT * FROM `FAQ` WHERE `FID`='" . $_GET["FAQID"] . "'"; - $Erg = mysql_query($SQL, $con); - - // anzahl zeilen - $Zeilen = mysql_num_rows($Erg); -?> - <form action="./faq.php" method="GET"> - Frage:<br /> - <textarea name="Frage" rows="3" cols="80"><?php echo mysql_result($Erg, 0, "Frage"); ?></textarea> - <br /><br /> - Antwort:<br /> - <textarea name="Antwort" rows="5" cols="80"><?php echo mysql_result($Erg, 0, "Antwort"); ?></textarea><br /> - <input type="hidden" name="FAQID" value="<?php echo $_GET["FAQID"]; ?>"> - <input type="hidden" name="quest" value="faqsave"> - <input type="submit" value="Sichern..."> - </form> - <form action="./faq.php"> - <input type="hidden" name="FAQID" value="<?php echo $_GET["FAQID"]; ?>"> - <input type="hidden" name="quest" value="faqdelete"> - <input type="submit" value="Löschen..."> - </form> -<?php - - - } - break; - - case "faqdelete"; - if (!IsSet ($_GET["FAQID"])) - echo "\tFehlerhafter Aufruf... Bitte die Bearbeitung nochmal starten...\n"; - else { - $SQL = "DELETE FROM `FAQ` WHERE `FID`='" . $_GET["FAQID"] . "' LIMIT 1"; - $Erg = db_query($SQL, "delate faq item"); - if ($Erg == 1) - echo "\tDer Eintrag wurde gelöscht<br />\n"; - else - echo "\tEin Fehler ist aufgetreten. Ist der Eintag bereits gelöscht gewesen?\n"; - } - break; - - case "faqsave"; - if (!IsSet ($_GET["FAQID"])) - echo "\tFehlerhafter Aufruf... Bitte die Bearbeitung nochmal starten...\n"; - else { - $SQL = "UPDATE `FAQ` SET `Frage`='" . $_GET["Frage"] . "', `Antwort`='" . $_GET["Antwort"] . - "' WHERE `FID`='" . $_GET["FAQID"] . "' LIMIT 1"; - $Erg = db_query($SQL, $con); - if ($Erg == 1) - echo "\tDer Eintrag wurde geändert<br />\n"; - else - echo "\tEin Fehler ist aufgetreten. Sorry, du kannst es aber ja nochmal probieren :)\n"; - } - break; - - case "faqnew" : -?> - <form action="./faq.php" method="GET"> - Frage:<br /> - <textarea name="Frage" rows="3" cols="80">Frage...</textarea><br /><br /> - Antwort:<br /> - <textarea name="Antwort" rows="5" cols="80">Antwort</textarea><br /> - <input type="hidden" name="quest" value="faqnewsave"> - <input type="submit" value="Sichern..."> - </form> -<?php - - - break; - - case "faqnewsave"; - $SQL = "INSERT INTO `FAQ` VALUES ('', '" . $_GET["Frage"] . "', '" . $_GET["Antwort"] . "')"; - $Erg = db_query($SQL, "Save new FAQ entry"); - if ($Erg == 1) - echo "\tDer Eintrag wurde erfasst.<br />\n"; - else - echo "\tEin Fehler ist aufgetreten. Sorry, du kannst es aber ja nochmal probieren :)\n"; - break; - - } //switch ($_GET["quest"]) - - // Hilfsroutine f�r die Anfragen: - // Fragenliste anzeigen??? - if ($quest_bearb == 1) { - $Erg = mysql_query($SQL, $con); - // anzahl zeilen - $Zeilen = mysql_num_rows($Erg); - - if ($Zeilen == 0) - echo "\tkeine vorhanden...\n"; - else - for ($n = 0; $n < $Zeilen; $n++) { - echo "\t<p>" . nl2br(mysql_result($Erg, $n, "Question")) . "\n</p><br />\n"; - echo "\t<a href=\"./faq.php?quest=edit&QID=" . mysql_result($Erg, $n, "QID") . "\">Bearbeiten</a>\n"; - echo "<br />---<br />\n"; - } - - } - -} //if (IsSet($_GET["quest"])) -else { - echo "Bitte wähle aus, ob du:\n"; - echo "<ul>\n"; - echo "\t<li><a href=\"./faq.php?quest=all\">Alle Anfragen anzeigen/bearbeiten möchtest</a></li>\n"; - echo "\t<li><a href=\"./faq.php?quest=open\">Alle offenen Anfragen anzeigen/bearbeiten möchtest (" . - noAnswer() . ")</a></li>\n"; - echo "\t<li><a href=\"./faq.php?quest=faq\">Die FAQ's anzeigen/bearbeiten</a></li>\n"; - echo "</ul>\n"; -} - -include ("includes/footer.php"); -?> diff --git a/www-ssl/css/base.css b/www-ssl/css/base.css index bfe050a5..44e1959c 100644 --- a/www-ssl/css/base.css +++ b/www-ssl/css/base.css @@ -109,6 +109,11 @@ td, th { border: 1px solid #888; } +textarea { + height: 200px; + width: 300px; +} + .background { background: #f0f0f0; } diff --git a/www-ssl/index.php b/www-ssl/index.php index d722de32..8ad025aa 100644 --- a/www-ssl/index.php +++ b/www-ssl/index.php @@ -73,6 +73,10 @@ if (in_array($p, $privileges)) { elseif ($p == "admin_groups") { require_once ('includes/pages/admin_groups.php'); $content = admin_groups(); + } + elseif ($p == "admin_faq") { + require_once ('includes/pages/admin_faq.php'); + $content = admin_faq(); } else { require_once ('includes/pages/guest_start.php'); $content = guest_start(); diff --git a/www-ssl/nonpublic/faq.php b/www-ssl/nonpublic/faq.php deleted file mode 100644 index fcc17158..00000000 --- a/www-ssl/nonpublic/faq.php +++ /dev/null @@ -1,73 +0,0 @@ -<?php -require_once ('../bootstrap.php'); - -$title = "Himmel"; -$header = "FAQ / Fragen an die Erzengel"; -include "includes/header.php"; - -// Erstaufruf, oder Frage bereits abgeschickt? -if (!isset ($_POST["eUID"])) { - Print_Text(35); -?> -<br /><br /> -<form action="./faq.php" method="POST"> - <input type="hidden" name="eUID" value="<?php echo $_SESSION['UID']; ?>"> - <textarea name="frage" cols="40" rows="10"><?php Print_Text(36); ?></textarea><br /><br /> - <input type="submit" value="<?php Print_Text("save"); ?>"> -</form> -<?php - - -} else { - // Auswertung d. Formular-Daten: - - echo "<b>" . Get_Text(37) . "</b><br /><br />\n" . nl2br($_POST["frage"]) . "<br /><br />\n" . Get_Text(38) . "<br />\n"; - - $SQL = "INSERT INTO `Questions` VALUES ('', '" . $_SESSION['UID'] . "', '" . $_POST["frage"] . "', '', '')"; - $Erg = mysql_query($SQL, $con); - -} -// Bisherige Anfragen: -echo "<br />\n<b>" . Get_Text(39) . "</b><br />\n"; -echo "<hr width=\"99%\">\n"; -echo "<br /><b>" . Get_Text(40) . "</b><br />\n"; - -$SQL = "SELECT * FROM `Questions` WHERE `UID` = " . $_SESSION['UID'] . " AND `AID`='0' ORDER BY 'QID' DESC"; -$Erg = mysql_query($SQL, $con); - -// anzahl zeilen -$Zeilen = mysql_num_rows($Erg); - -if ($Zeilen == 0) { - Print_Text(41); - -} else { - for ($n = 0; $n < $Zeilen; $n++) { - echo "<p class='question'>" . nl2br(mysql_result($Erg, $n, "Question")) . "<br />\n"; - // Es gibt ja noch keine Antwort: - // echo "<p class='answer'>".nl2br(mysql_result($Erg, $n, "Answer"))."</p>\n"; - echo "\n<br />---<br />"; - } -} - -echo "<hr width=\"99%\">\n"; -echo "<br /><b>" . Get_Text(42) . "</b><br />\n"; -$SQL = "SELECT * FROM `Questions` WHERE `UID`='" . $_SESSION['UID'] . "' and `AID`<>'0' ORDER BY 'QID' DESC"; -$Erg = mysql_query($SQL, $con); - -// anzahl zeilen -$Zeilen = mysql_num_rows($Erg); - -if ($Zeilen == 0) { - Print_Text(41); -} else { - for ($n = 0; $n < $Zeilen; $n++) { - echo "<p class='question'>" . nl2br(mysql_result($Erg, $n, "Question")) . "<br />\n"; - echo "<p class='answer'>" . nl2br(mysql_result($Erg, $n, "Answer")) . - "@" . UID2Nick(mysql_result($Erg, $n, "AID")) . "\n"; - echo "\n<br />---<br />"; - } -} - -include ("includes/footer.php"); -?> |