add total system

git-svn-id: svn://svn.cccv.de/engel-system@1 29ba0400-6e00-0410-a75a-ca02368028f8

1 files changed, 56 insertions, 0 deletions

diff --git a/nonpublic/waeckliste.php b/nonpublic/waeckliste.php
new file mode 100755
index 00000000..80303168
--- /dev/null
+++ b/nonpublic/waeckliste.php
@@ -0,0 +1,56 @@
+<?php
+include ("./inc/funktion_user.php");
+
+$title = "Himmel";
+$header = "Weckdienst - Liste der zu weckenden Engel";
+
+include ("./inc/header.php");
+
+if ($eintragen == "Weck mich!") {
+  $SQL = "INSERT INTO Wecken (`UID`, `Date`, `Ort`, `Bemerkung`) VALUES (".$_SESSION['UID'].", \"$Date\", \"$Ort\", \"$Bemerkung\") ";
+  $Erg = mysql_query($SQL, $con);
+  if ($Erg == 1) { Print_Text(4); }
+}
+
+if ($eintragen == "loeschen") {
+  $SQL = "Delete from Wecken where UID = ".$_SESSION['UID']." and ID = $weckID limit 1";
+  $Erg = mysql_query($SQL, $con);
+  if ($Erg == 1) { 
+  	Print_Text(4); 
+  }
+}
+?>
+
+<? echo Get_Text(1). $_SESSION['Nick'].",<br>\n".
+        Get_Text("pub_waeckliste_Text1")?>
+<br><br>
+<table border="0" width="100%" class="border" cellpadding="2" cellspacing="1">
+        <tr class="contenttopic">
+		<th align="left"><? echo Get_Text("pub_waeckliste_Nick");?></th>
+		<th align="left"><? echo Get_Text("pub_waeckliste_Datum");?></th>
+                <th align="left"><? echo Get_Text("pub_waeckliste_Ort");?></th>
+		<th align="left"><? echo Get_Text("pub_waeckliste_Comment");?></th>
+        </tr>
+						
+<?
+  $sql = "Select * from Wecken order by Date asc";
+  $Erg = mysql_query($sql, $con);
+  $count = mysql_num_rows($Erg);
+
+  for ($i=0; $i < $count; $i++) {
+  $row=mysql_fetch_row($Erg);
+?>
+	<tr class="content">
+		<td align="left"><? echo UID2Nick(mysql_result($Erg, $i, "UID")); ?> </td>
+		<td align="left"><? echo mysql_result($Erg, $i, "Date"); ?> </td>
+		<td align="left"><? echo mysql_result($Erg, $i, "Ort"); ?> </td>
+		<td align="left"><? echo mysql_result($Erg, $i, "Bemerkung"); ?> </td>
+	</tr>
+<?
+
+  }
+?>
+</table>
+<?
+include ("./inc/footer.php");
+?>