1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
|
<?php
require_once ('../bootstrap.php');
$title = "Himmel";
$header = "Weckdienst";
include "includes/header.php";
if (isset ($_POST["eintragen"])) {
if ($_POST["eintragen"] == Get_Text("pub_wake_bouton")) {
$SQL = "INSERT INTO `Wecken` (`UID`, `Date`, `Ort`, `Bemerkung`) " .
"VALUES ('" . $_SESSION['UID'] . "', '" . $_POST["Date"] . "', '" . $_POST["Ort"] . "', " .
"'" . $_POST["Bemerkung"] . "')";
$Erg = mysql_query($SQL, $con);
if ($Erg == 1)
Print_Text(4);
}
}
if (isset ($_GET["eintragen"])) {
if ($_GET["eintragen"] == "loeschen") {
$SQL = "DELETE FROM `Wecken` WHERE `UID`='" . $_SESSION['UID'] . "' AND `ID`='" . $_GET["weckID"] . "' LIMIT 1";
$Erg = mysql_query($SQL, $con);
if ($Erg == 1)
Print_Text(4);
}
}
echo "<p>" . Get_Text("Hello") . $_SESSION['Nick'] . ",<br />" . Get_Text("pub_wake_beschreibung") . "</p>\n\n";
echo Get_Text("pub_wake_beschreibung2");
?>
<table border="0" width="100%" class="border" cellpadding="2" cellspacing="1">
<tr class="contenttopic">
<th align="left"><?php echo Get_Text("pub_wake_Datum"); ?></th>
<th align="left"><?php echo Get_Text("pub_wake_Ort"); ?></th>
<th align="left"><?php echo Get_Text("pub_wake_Bemerkung"); ?></th>
<th align="left"><?php echo Get_Text("pub_wake_change"); ?></th>
</tr>
<?php
$sql = "SELECT * FROM `Wecken` WHERE `UID`='" . $_SESSION['UID'] . "' 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"><?php echo mysql_result($Erg, $i, "Date"); ?> </td>
<td align="left"><?php echo mysql_result($Erg, $i, "Ort"); ?> </td>
<td align="left"><?php echo mysql_result($Erg, $i, "Bemerkung"); ?> </td>
<td align="left"><a href="./wecken.php?eintragen=loeschen&weckID=<?php echo mysql_result($Erg, $i, "ID") . "\">" . Get_Text("pub_wake_del"); ?></a></td>
</tr>
<?php
}
?>
</table>
<br /><br />
<?php echo Get_Text("pub_wake_Text2"); ?><br /><br />
<form action="wecken.php" method="post">
<table>
<tr>
<td align="right"><?php echo Get_Text("pub_wake_Datum"); ?>:</td>
<td align="left"><input type="text" name="Date" value="2003-08-05 08:00:00"></td>
</tr>
<tr>
<td align="right"><?php echo Get_Text("pub_wake_Ort"); ?></td>
<td align="left"><input type="text" name="Ort" value="Tent 23"></td>
</tr>
<tr>
<td align="right"><?php echo Get_Text("pub_wake_Bemerkung"); ?></td>
<td align="left"><textarea name="Bemerkung" rows="5" cols="40">knock knock leo, follow the white rabbit to the blue tent</textarea></td>
</tr>
</table>
<input type="submit" name="eintragen" value="<?php echo Get_Text("pub_wake_bouton"); ?>" />
</form>
<?php
include ("includes/footer.php");
?>
|
