summaryrefslogtreecommitdiff
path: root/admin
diff options
context:
space:
mode:
authorcookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8>2005-11-06 16:51:32 +0000
committercookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8>2005-11-06 16:51:32 +0000
commitc3f45775b0306943ab98f17391c31dbeb1f36257 (patch)
tree20af2318090034e46c29740fb83f863bc686fdd6 /admin
parentb2ed0cd03d61675aefbd42d101c2698009840f45 (diff)
jetzt war news-verwaltung dran
git-svn-id: svn://svn.cccv.de/engel-system@18 29ba0400-6e00-0410-a75a-ca02368028f8
Diffstat (limited to 'admin')
-rwxr-xr-xadmin/news.php45
1 files changed, 28 insertions, 17 deletions
diff --git a/admin/news.php b/admin/news.php
index 12d5e140..7c501751 100755
--- a/admin/news.php
+++ b/admin/news.php
@@ -7,7 +7,7 @@ include ("./inc/funktion_db_list.php");
include ("./inc/funktion_user.php");
-if (!IsSet($action)) {
+if (!IsSet($_GET["action"])) {
$SQL = "SELECT * from News order by Datum DESC";
$Erg = mysql_query($SQL, $con);
@@ -44,51 +44,62 @@ echo "</table>";
} else {
-switch ($action) {
+switch ($_GET["action"])
+{
case 'change':
- $SQL = "SELECT * from News where (Datum='$date')";
+ $SQL = "SELECT * from News where (Datum='". $_GET["date"]. "')";
$Erg = mysql_query($SQL, $con);
- echo "<form action=\"./news.php\" method=\"post\">\n";
+ echo "<form action=\"./news.php\" method=\"GET\">\n";
echo "<table>\n";
- echo " <tr><td>Datum</td><td><input type=\"text\" size=\"40\" name=\"date\" value=\"".mysql_result($Erg, 0, "Datum")."\" disabled></td></tr>\n";
- echo " <tr><td>Betreff</td><td><input type=\"text\" size=\"40\" name=\"eBetreff\" value=\"".mysql_result($Erg, 0, "Betreff")."\"></td></tr>\n";
- echo " <tr><td>Text</td><td><textarea rows=\"10\" cols=\"80\" name=\"eText\">".mysql_result($Erg, 0, "Text")."</textarea></td></tr>\n";
- echo " <tr><td>Engel</td><td><input type=\"text\" size=\"40\" name=\"eUser\" value=\"".UID2Nick(mysql_result($Erg, 0, "UID"))."\" disabled></td></tr>\n";
- echo " <tr><td>Treffen</td><td><input type=\"text\" size=\"40\" name=\"eTreffen\" value=\"".mysql_result($Erg, 0, "Treffen")."\"></td></tr>\n";
+ echo " <tr><td>Datum</td><td><input type=\"text\" size=\"40\" name=\"date\" value=\"".
+ mysql_result($Erg, 0, "Datum")."\" disabled></td></tr>\n";
+ echo " <tr><td>Betreff</td><td><input type=\"text\" size=\"40\" name=\"eBetreff\" value=\"".
+ mysql_result($Erg, 0, "Betreff")."\"></td></tr>\n";
+ echo " <tr><td>Text</td><td><textarea rows=\"10\" cols=\"80\" name=\"eText\">".
+ mysql_result($Erg, 0, "Text")."</textarea></td></tr>\n";
+ echo " <tr><td>Engel</td><td><input type=\"text\" size=\"40\" name=\"eUser\" value=\"".
+ UID2Nick(mysql_result($Erg, 0, "UID"))."\" disabled></td></tr>\n";
+ echo " <tr><td>Treffen</td><td><input type=\"text\" size=\"40\" name=\"eTreffen\" value=\"".
+ mysql_result($Erg, 0, "Treffen")."\"></td></tr>\n";
echo "</table>";
- echo "<input type=\"hidden\" name=\"date\" value=\"$date\">\n";
+ echo "<input type=\"hidden\" name=\"date\" value=\"". $_GET["date"]. "\">\n";
echo "<input type=\"hidden\" name=\"action\" value=\"change_save\">\n";
echo "<input type=\"submit\" value=\"Abschicken...\">\n";
echo "</form>";
echo "<form action=\"./news.php?action=delete\" method=\"POST\">\n";
- echo "<input type=\"hidden\" name=\"date\" value=\"$date\">\n";
+ echo "<input type=\"hidden\" name=\"date\" value=\"". $_GET["date"]. "\">\n";
echo "<input type=\"submit\" value=\"l&ouml;schen...\">\n";
echo "</form>";
-
break;
case 'change_save':
- $chsql="update News set Betreff = '$eBetreff', Text = '$eText', Treffen = '$eTreffen' where (Datum = '$date') limit 1";
+ $chsql="UPDATE News set Betreff = \"". $_GET["eBetreff"]. "\", Text = \"". $_GET["eText"].
+ "\", Treffen=". $_GET["eTreffen"]. " where (Datum = '". $_GET["date"]. "') limit 1";
break;
case 'delete':
- $chsql="delete from News where Datum = '$date' limit 1";
+ $chsql="DELETE from News where Datum = '". $_POST["date"]. "' limit 1";
break;
}
if (IsSet($chsql)) {
// SQL-Statement ausführen...
$Erg = mysql_query($chsql, $con);
- If ($Erg == 1){
+ If ($Erg == 1)
+ {
echo "&Auml;nderung erfolgreich gesichert...";
- } else {
- echo "Ein Fehler ist aufgetreten... probiere es am besten nocheinmal... :)";
+ }
+ else
+ {
+ echo "Ein Fehler ist aufgetreten... probiere es am besten nocheinmal... :)<br><br>\n";
+ echo mysql_error($con);
+ echo "<br><br>\n[$chsql]";
}
}