From 866c47ec603595e8fe67da5f0e5d162a70b1f7b4 Mon Sep 17 00:00:00 2001
From: cookie <cookie@29ba0400-6e00-0410-a75a-ca02368028f8>
Date: Sun, 6 Nov 2005 17:14:25 +0000
Subject: move files

git-svn-id: svn://svn.cccv.de/engel-system@20 29ba0400-6e00-0410-a75a-ca02368028f8
---
 www-ssl/admin/news.php | 109 +++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 109 insertions(+)
 create mode 100755 www-ssl/admin/news.php

(limited to 'www-ssl/admin/news.php')

diff --git a/www-ssl/admin/news.php b/www-ssl/admin/news.php
new file mode 100755
index 00000000..7c501751
--- /dev/null
+++ b/www-ssl/admin/news.php
@@ -0,0 +1,109 @@
+<?PHP
+
+$title = "Newsverwaltung";
+$header = "Verwaltung der News";
+include ("./inc/header.php");
+include ("./inc/funktion_db_list.php");
+include ("./inc/funktion_user.php");
+
+
+if (!IsSet($_GET["action"])) {
+
+$SQL = "SELECT * from News order by Datum DESC";
+$Erg = mysql_query($SQL, $con);
+
+$rowcount = mysql_num_rows($Erg);
+?>
+Hallo <? echo $_SESSION['Nick'] ?>, <br>
+hier kannst du die News s&auml;bern... falls jemand auf die Idee kommt, 
+hier herumzuspamen oder aus Versehen falsche Informationen zu hinterlegen :)<br><br>
+
+<table width="100%" class="border" cellpadding="2" cellspacing="1">
+        <tr class="contenttopic">
+         <td>Datum</td>
+         <td>Betreff</td>
+         <td>Text</td>
+         <td>Erfasser</td>
+         <td>Engeltreff</td>
+	 <td>&Auml;nd.</td>
+	</tr>
+<?				  
+
+for ($i=0; $i < $rowcount; $i++) {
+	echo "\t<tr class=\"content\">\n";
+	echo "\t <td>".mysql_result($Erg, $i, "Datum")."</td>";
+	echo "\t <td>".mysql_result($Erg, $i, "Betreff")."</td>";
+	echo "\t <td>".mysql_result($Erg, $i, "Text")."</td>";
+	echo "\t <td>".UID2Nick(mysql_result($Erg, $i, "UID"))."</td>";
+	echo "\t <td>".mysql_result($Erg, $i, "Treffen")."</td>";
+	echo "\t <td><a href=\"./news.php?action=change&date=".mysql_result($Erg, $i, "Datum")."\">XXX</a></td>";
+	echo "\t</tr>\n";
+}
+echo "</table>";
+
+
+} else {
+
+switch ($_GET["action"]) 
+{
+
+case 'change':
+	$SQL = "SELECT * from News where (Datum='". $_GET["date"]. "')";
+	$Erg = mysql_query($SQL, $con);
+
+	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 "</table>";
+
+        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=\"". $_GET["date"]. "\">\n";
+	echo "<input type=\"submit\" value=\"l&ouml;schen...\">\n";
+	echo "</form>";
+
+	break;
+
+case 'change_save':
+	$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 = '". $_POST["date"]. "' limit 1";
+	break;
+}
+
+if (IsSet($chsql)) {
+// SQL-Statement ausführen...
+	$Erg = mysql_query($chsql, $con);
+	If ($Erg == 1)
+	{
+		echo "&Auml;nderung erfolgreich gesichert...";
+	} 
+	else 
+	{
+		echo "Ein Fehler ist aufgetreten... probiere es am besten nocheinmal... :)<br><br>\n";
+		echo mysql_error($con);
+		echo "<br><br>\n[$chsql]";
+	}
+}
+
+}
+include ("./inc/footer.php");
+?>
+
-- 
cgit v1.2.3-70-g09d2