Newer
Older
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
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
<?php
// neuen Rank eintragen, ändern oder löschen
if ($_POST['eintragen'] == 'Neue Position') {
db_query("INSERT INTO " . $db_prefix . "_rallyorte (id, name, welche_rallys) VALUES (NULL, '" . $_POST['name'] . "','" . implode(',', array_keys($_POST['rally'])) . "');");
Echo '<b><font size="+2" color="#087102">Eintragung erfolgreich!</font></b>';
} ;
if ($_POST['eintragen'] == 'Loeschen') {
db_query("DELETE FROM " . $db_prefix . "_rallyorte WHERE id = '" . $_POST['id'] . "';");
Echo '<b><font size="+2" color="#087102">Eintrag erfolgreich gelöscht!</font></b>';
} ;
if ($_POST['eintragen'] == 'Aendern') {
db_query("UPDATE " . $db_prefix . "_rallyorte SET welche_rallys='" . implode(',', array_keys($_POST['rally'])) . "' WHERE id='" . $_POST['id'] . "';");
Echo '<b><font size="+2" color="#087102">Änderung erfolgreich!</font></b>';
} ;
if ($_POST['rally'] == 'Eintragen') {
db_query("INSERT INTO `vms_rallydaten`
(`id`, `name`, `beschrieb`, `status`, `start`, `ende_art`, `ende_zeit`, `ende_punkte`, `ende_punkte_aktuell`, `ende_punkte_anzahl`, `ende_formulierung`, `ende_vortschritt`, `gewinn_art`, `gewinn_dyn_steigerung`, `gewinn_topf`, `gewinner_anzahl`, `mindestpunktzhl`, `sperruser`, `tagpotstart`, `einheit`)
VALUES (NULL, '" . $_POST['rallyname'] . "', ' ', 'deaktiviert', '0', 'zeit', '0', '0', '0.00', '0', ' ', 'datum', 'statisch', '0.00', '0.00', '0', '0', ' ', '0', ' ' )");
Echo '<b><font size="+2" color="#087102">Eintragung erfolgreich!</font></b>';
} ;
if ($_POST['rally'] == 'Loeschen') {
db_query("DELETE FROM " . $db_prefix . "_rallydaten WHERE id = '" . $_POST['id'] . "';");
Echo '<b><font size="+2" color="#087102">Eintrag erfolgreich gelöscht!</font></b>';
} ;
head("<b><center>Rallys im System </center></b>");
?>
<table align="center" border="0" cellpadding="3" cellspacing="1" width="100%" bgcolor="#000000">
<tr bgcolor="#c0c0c0">
<td align="center"><strong>Name</strong></td>
<td align="center"><strong>Bearbeiten der einzelnen Rallys</strong></td>
</tr>
<?php $rally = db_query("SELECT * FROM " . $db_prefix . "_rallydaten");
while ($rall = mysqli_fetch_array($rally)) {?>
<form action="" method="post">
<tr bgcolor="#d0d0d0" >
<td align="center"><strong><?php echo $rall['name'];?></strong></td>
<td align="center" valign="top">
<input type="hidden" name="id" value="<?php echo $rall['id']?>">
<input type="submit" name="rally" value="Loeschen" style="width:100px;">
</td>
</tr>
</form>
<?php } ?>
</table>
<?php foot();?>
<?php head("<b><center>Neue Rally eintragen. </center></b>");?>
<table align="center" border="0" cellpadding="3" cellspacing="1" width="100%" bgcolor="#000000">
<tr bgcolor="#c0c0c0">
<td align="center"><strong>Name</strong></td>
<td align="center"><strong>Bearbeiten der einzelnen Rallys</strong></td>
</tr>
<form action="" method="post">
<tr bgcolor="#d0d0d0" >
<td align="center"><input type="text" name="rallyname"></td>
<td align="center" valign="top"><input type="submit" name="rally" value="Eintragen" style="width:100px;"></td>
</tr>
</form>
</table>
<?php foot();?>
<?php head("<b><center>Was in welcher Rally teil nehmen soll. </center></b>");?>
<table align="center" border="0" cellpadding="3" cellspacing="1" width="100%" bgcolor="#000000">
<tr bgcolor="#c0c0c0">
<td align="center"><strong>Diese ID<br>müssen Sie<br>in der <br>Funktion<br>eingeben</strong></td>
<td align="center"><strong>Beschrieb</strong></td>
<td align="center"><strong>Welche rallys</strong></td>
<td align="center"><strong>Bearbeiten<br>der <br>einzelnen <br>Positionen</strong></td>
</tr>
<?php $ap_anzeige = db_query("SELECT * FROM " . $db_prefix . "_rallyorte ORDER BY id ASC");
while ($ap = mysqli_fetch_array($ap_anzeige)) {
$rallynamen = db_query("SELECT id, name FROM " . $db_prefix . "_rallydaten");
$rallys = '';
while ($rallyname = mysqli_fetch_array($rallynamen)) {
$checked = '';
$arrays = explode (',', $ap['welche_rallys']);
if (in_array($rallyname['id'], $arrays)) $checked = 'checked="checked"';
$rallys .= '<input type="checkbox" ' . $checked . ' value="1" name="rally[' . $rallyname['id'] . ']"> ' . $rallyname['name'] . '<br>';
}
?>
<tr bgcolor="#d0d0d0" >
<form action="" method="post">
<td align="center" valign="top"><input type="hidden" name="id" value="<?php echo $ap['id']?>"><?php echo $ap['id'];?></td>
<td align="center" valign="top"><strong><?php echo $ap['name'];?></strong></td>
<td align="left" valign="top"><?php echo $rallys;?></td>
<td align="center" valign="top"><input type="submit" name="eintragen" value="Aendern" style="width:100px;"><br><input type="submit" name="eintragen" value="Loeschen" style="width:100px;"></td>
</form>
</tr>
<?php } ;?>
</table>
<?php foot();?>
<?php head("<b><center> Neue Position eintragen</center></b>");
$rallynamenneu = db_query("SELECT id, name FROM " . $db_prefix . "_rallydaten");
$rallysneu = '';
while ($rallynameneu = mysqli_fetch_array($rallynamenneu)) {
$rallysneu .= '<input type="checkbox" value="1" name="rally[' . $rallynameneu['id'] . ']"> ' . $rallynameneu['name'] . '<br>';
}
?>
<form action="" method="post">
<table align="center" border="0" cellpadding="3" cellspacing="1" width="100%" bgcolor="#000000">
<tr bgcolor="#c0c0c0">
<td align="center"><b>Name</b></td>
<td align="center"><b>Rallys</b></td>
<td align="center"><b>Speichern</b></td>
</tr>
<tr bgcolor="#d0d0d0">
<td align="center">
Dieser Name ist nur für Sie gedacht.<br>
Er hat keinerlei Funktion.<br>
<input type="text" name="name" value="" style="width:200px;">
</td>
<td align="left"><?php echo $rallysneu;?></td>
<td align="center"><input type="submit" name="eintragen" value="Neue Position" style="width:100px;"></td>
</tr>
</table>
</form>
<?php foot(); ?>