summaryrefslogtreecommitdiff
path: root/nonpublic/waeckliste.php
diff options
context:
space:
mode:
Diffstat (limited to 'nonpublic/waeckliste.php')
-rwxr-xr-xnonpublic/waeckliste.php56
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");
+?>