diff options
Diffstat (limited to 'nonpublic/waeckliste.php')
| -rwxr-xr-x | nonpublic/waeckliste.php | 56 |
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"); +?> |