| 16 |
lars |
1 |
<?
|
| 114 |
lars |
2 |
define( "IN_ADMIN", true );
|
|
|
3 |
require ( "include/common.php" );
|
|
|
4 |
$mode = ( $_POST["mode"] ) ? $_POST["mode"] : "new";
|
|
|
5 |
$id = intval( isset($_POST["id"]) ? $_POST["id"] : 0 );
|
|
|
6 |
$g_m1 = intval( isset($_POST["g_m1"]) ? $_POST["g_m1"] : 0 );
|
|
|
7 |
$g_m2 = intval( isset($_POST["g_m2"]) ? $_POST["g_m2"] : 0 );
|
|
|
8 |
$g_g1 = intval( isset($_POST["g_g1"]) ? $_POST["g_g1"] : 0 );
|
|
|
9 |
$g_g2 = intval( isset($_POST["g_g2"]) ? $_POST["g_g2"] : 0 );
|
|
|
10 |
$g_location = intval( isset($_POST["g_location"]) ? $_POST["g_location"] :
|
|
|
11 |
|
|
|
12 |
$g_type = intval( isset($_POST["g_typ"]) ? $_POST["g_typ"] : -1 );
|
|
|
13 |
$g_name = addslashes( isset($_POST["g_name"]) ? $_POST["g_name"] : "" );
|
|
|
14 |
$month = intval( isset($_POST["Month"]) ? $_POST["Month"] : -1 );
|
|
|
15 |
$day = intval( isset($_POST["Day"]) ? $_POST["Day"] : -1 );
|
|
|
16 |
$hour = intval( isset($_POST["Hour"]) ? $_POST["Hour"] : -1 );
|
|
|
17 |
$min = intval( isset($_POST["Minute"]) ? $_POST["Minute"] : -1 );
|
|
|
18 |
$g = Spiele::listSpiele( 0, 0 );
|
|
|
19 |
$g_anz = $g->numRows();
|
|
|
20 |
$g_max = 2 * $config->groups * $config->teams_per_group;
|
|
|
21 |
if ( $hour >= 0 and $day > 0 and $month > 0 && $min > -1 )
|
|
|
22 |
{
|
|
|
23 |
$g_date = mktime( $hour, $min, 0, $month, $day, $config->year );
|
|
|
24 |
}
|
|
|
25 |
if ( $g_anz >= $g_max && $mode == "new" )
|
|
|
26 |
{
|
|
|
27 |
$smarty->assign( "meld", "Ein Fehler ist aufgetreten!" );
|
|
|
28 |
$smarty->assign( "db_meld", "In dieser $config->type sind nur $g_max Spiele zulässig!" );
|
|
|
29 |
$smarty->assign( "error", true );
|
|
|
30 |
$smarty->display( "meld.tpl" );
|
|
|
31 |
exit;
|
|
|
32 |
}
|
|
|
33 |
$smarty->assign( "mode", $mode );
|
|
|
34 |
$smarty->assign( "id", $id );
|
|
|
35 |
if ( $a->getAuth() )
|
|
|
36 |
{
|
|
|
37 |
if ( $u->u_type != 1 && $mode != "edit" )
|
|
|
38 |
{
|
|
|
39 |
$meld = "Ein Fehler ist aufgetreten!";
|
|
|
40 |
$db_meld =
|
|
|
41 |
"Nur Administratoren haben Zugriff auf diese Funktion!";
|
|
|
42 |
$smarty->assign( "meld", $meld );
|
|
|
43 |
$smarty->assign( "db_meld", $db_meld );
|
|
|
44 |
$smarty->assign( "error", true );
|
|
|
45 |
$smarty->display( "meld.tpl" );
|
|
|
46 |
exit;
|
|
|
47 |
}
|
|
|
48 |
$game = new Spiele( $id );
|
|
|
49 |
$t = new Typ( $g_type );
|
|
|
50 |
$sql_t = "SELECT count(*) AS anzahl FROM games WHERE g_type=$g_type";
|
|
|
51 |
$res_t = $db->query( $sql_t );
|
|
|
52 |
$row_t = $res_t->fetchRow();
|
|
|
53 |
$anz = $row_t["anzahl"];
|
|
|
54 |
if ( $mode == "save" || $mode == "update" )
|
|
|
55 |
{
|
|
|
56 |
$game->update( $g_name, $g_m1, $g_m2, $g_g1, $g_g2, $g_location,
|
|
|
57 |
$g_date, $g_type );
|
|
|
58 |
}
|
| 65 |
lars |
59 |
|
| 114 |
lars |
60 |
function fill_form()
|
|
|
61 |
{
|
|
|
62 |
global $db, $smarty, $id, $new_mode, $g_date, $title, $game;
|
|
|
63 |
$teams[-1] = "Bitte wählen!";
|
|
|
64 |
$typ_namen[] = "Bitte wählen!";
|
|
|
65 |
$typ_ids[] = -1;
|
|
|
66 |
$l_namen[] = "Bitte wählen!";
|
|
|
67 |
$l_ids[] = -1;
|
|
|
68 |
$g_l = Gruppe::listeGruppe( 0, 0 );
|
|
|
69 |
while ( $row_g = $g_l->fetchRow() )
|
|
|
70 |
{
|
|
|
71 |
$g_id = $row_g["g_id"];
|
|
|
72 |
$g_name = $row_g["g_name"];
|
|
|
73 |
// $t_namen[]="---------- Gruppe $g_name ----------";
|
|
|
74 |
// $t_ids[]=-1;
|
|
|
75 |
$sql_t = "SELECT * FROM teams WHERE t_group=$g_id";
|
|
|
76 |
$t_l = $db->query( $sql_t );
|
|
|
77 |
while ( $row_t = $t_l->fetchRow() )
|
|
|
78 |
{
|
|
|
79 |
$t_name = $row_t["t_name"];
|
|
|
80 |
$t_aus = $row_t["t_aus"];
|
|
|
81 |
$t_id = $row_t["t_id"];
|
|
|
82 |
// $t_namen[]=$t_name;
|
|
|
83 |
// $t_ids[]=$t_id;
|
|
|
84 |
$teams["Gruppe $g_name"][$t_id] = $t_name;
|
|
|
85 |
}
|
|
|
86 |
}
|
|
|
87 |
$l_l = Ort::listeOrt( 0, 0 );
|
|
|
88 |
while ( $row_l = $l_l->fetchRow() )
|
|
|
89 |
{
|
|
|
90 |
$l_name = $row_l["l_name"];
|
|
|
91 |
$l_name2 = $row_l["l_name2"];
|
|
|
92 |
$l_id = $row_l["l_id"];
|
|
|
93 |
$l_namen[] = "$l_name - $l_name2";
|
|
|
94 |
$l_ids[] = $l_id;
|
|
|
95 |
}
|
|
|
96 |
$typ_l = Typ::listeTyp( 0, 0 );
|
|
|
97 |
while ( $row_typ = $typ_l->fetchRow() )
|
|
|
98 |
{
|
|
|
99 |
$typ_name = $row_typ["t_name"];
|
|
|
100 |
$typ_id = $row_typ["t_id"];
|
|
|
101 |
$typ_namen[] = $typ_name;
|
|
|
102 |
$typ_ids[] = $typ_id;
|
|
|
103 |
}
|
|
|
104 |
$smarty->assign( "id", $id );
|
|
|
105 |
$smarty->assign( "g_date", (!($g_date)) ? $game->g_date : $g_date );
|
|
|
106 |
$smarty->assign( "g_name", ($game->g_name) );
|
|
|
107 |
$smarty->assign( "akt_typ_id", $game->g_type );
|
|
|
108 |
$smarty->assign( "akt_m1_id", $game->g_m1 );
|
|
|
109 |
$smarty->assign( "akt_m2_id", $game->g_m2 );
|
|
|
110 |
$smarty->assign( "akt_l_id", $game->g_location );
|
|
|
111 |
$smarty->assign( "g_g1", $game->g_g1 );
|
|
|
112 |
$smarty->assign( "g_g2", $game->g_g2 );
|
|
|
113 |
// $smarty->assign("t_namen", $t_namen);
|
|
|
114 |
$smarty->assign( "teams", $teams );
|
|
|
115 |
// $smarty->assign("t_ids", $t_ids);
|
|
|
116 |
$smarty->assign( "typ_namen", $typ_namen );
|
|
|
117 |
$smarty->assign( "typ_ids", $typ_ids );
|
|
|
118 |
$smarty->assign( "l_ids", $l_ids );
|
|
|
119 |
$smarty->assign( "l_namen", $l_namen );
|
|
|
120 |
$smarty->assign( "mode", $new_mode );
|
|
|
121 |
$smarty->assign( "title", $title );
|
|
|
122 |
$smarty->assign( "extra", ($new_mode == "save") ? "disabled=\"disabled\"" :
|
|
|
123 |
"" );
|
|
|
124 |
$smarty->display( "edit_games.tpl" );
|
|
|
125 |
}
|
|
|
126 |
|
|
|
127 |
switch ( $mode )
|
|
|
128 |
{
|
|
|
129 |
case "edit":
|
|
|
130 |
$title = "Spiel $id ändern";
|
|
|
131 |
$new_mode = "update";
|
|
|
132 |
break;
|
|
|
133 |
case "new":
|
|
|
134 |
$title = "neues Spiel eingeben";
|
|
|
135 |
$new_mode = "save";
|
|
|
136 |
break;
|
|
|
137 |
case "delete":
|
|
|
138 |
case "ask":
|
|
|
139 |
$title = "Spiel $id löschen";
|
|
|
140 |
$new_mode = "delete";
|
|
|
141 |
break;
|
|
|
142 |
case "save":
|
|
|
143 |
$title = "neues Spiel speichern";
|
|
|
144 |
$new_mode = "save";
|
|
|
145 |
$smarty->assign( "save", true );
|
|
|
146 |
$smarty->assign( "weiter", "ein weiteres Spiel eingeben" );
|
|
|
147 |
break;
|
|
|
148 |
case "update":
|
|
|
149 |
$title = "Spiel $id speichern";
|
|
|
150 |
$new_mode = "update";
|
|
|
151 |
break;
|
|
|
152 |
}
|
|
|
153 |
if ( $mode == "edit" or $mode == "new" )
|
|
|
154 |
{
|
|
|
155 |
fill_form();
|
|
|
156 |
}
|
|
|
157 |
else
|
|
|
158 |
{
|
|
|
159 |
switch ( $mode )
|
|
|
160 |
{
|
|
|
161 |
case "save":
|
|
|
162 |
case "delete":
|
|
|
163 |
case "update":
|
|
|
164 |
if ( !checkdate($month, $day, $config->year) )
|
|
|
165 |
{
|
|
|
166 |
$meld = "Ein Fehler ist aufgetreten!";
|
|
|
167 |
$db_meld = "$day.$month.$config->year ist kein gültiges Datum!";
|
|
|
168 |
$error = true;
|
|
|
169 |
$smarty->assign( "db_meld", $db_meld );
|
|
|
170 |
$smarty->assign( "error", $error );
|
|
|
171 |
$smarty->assign( "meld", $meld );
|
|
|
172 |
fill_form();
|
|
|
173 |
}
|
|
|
174 |
else
|
|
|
175 |
{
|
|
|
176 |
if ( ($mode == "save" && $anz >= $t->t_max) || ($mode ==
|
|
|
177 |
"update" && $anz > $t->t_max) )
|
|
|
178 |
{
|
|
|
179 |
$meld = "Ein Fehler ist aufgetreten!";
|
|
|
180 |
$db_meld = "Es kann nur $t->t_max Spiele vom Typ \"$t->t_name\" geben! Bitte den Typ oder ein vorhandenes Spiel ändern!";
|
|
|
181 |
$error = true;
|
|
|
182 |
$smarty->assign( "db_meld", $db_meld );
|
|
|
183 |
$smarty->assign( "error", $error );
|
|
|
184 |
$smarty->assign( "meld", $meld );
|
|
|
185 |
fill_form();
|
|
|
186 |
}
|
|
|
187 |
else
|
|
|
188 |
{
|
|
|
189 |
$res = $game->save( $mode );
|
|
|
190 |
if ( true == DB::isError($res) )
|
|
|
191 |
{
|
|
|
192 |
$smarty->assign( "meld",
|
|
|
193 |
"Ein Fehler ist aufgetreten!" );
|
|
|
194 |
$smarty->assign( "db_meld", $res->
|
|
|
195 |
getUserInfo() );
|
|
|
196 |
$smarty->assign( "error", true );
|
|
|
197 |
}
|
|
|
198 |
else
|
|
|
199 |
{
|
|
|
200 |
if ( $mode == "save" )
|
|
|
201 |
{
|
|
|
202 |
$akt = "hinzugefügt";
|
|
|
203 |
} elseif ( $mode == "update" )
|
|
|
204 |
{
|
|
|
205 |
$akt = "geändert";
|
|
|
206 |
}
|
|
|
207 |
else
|
|
|
208 |
{
|
|
|
209 |
$akt = "gelöscht";
|
|
|
210 |
}
|
|
|
211 |
$smarty->assign( "title", $title );
|
|
|
212 |
$smarty->assign( "meld",
|
|
|
213 |
"Datensatz erfolgreich $akt!" );
|
|
|
214 |
$smarty->assign( "db_meld", "" );
|
|
|
215 |
$logger->info( "Spiel $game->g_name erfolgreich $akt!" );
|
|
|
216 |
$smarty->assign( "error", false );
|
|
|
217 |
if ( $mode == "update" )
|
|
|
218 |
{
|
|
|
219 |
if ( $game->g_type != 4 )
|
|
|
220 |
{
|
|
|
221 |
if ( $game->g_type < 4 )
|
|
|
222 |
{
|
|
|
223 |
if ( $game->g_g1 < $game->g_g2 )
|
|
|
224 |
{
|
|
|
225 |
$m_id = $game->g_m1;
|
|
|
226 |
}
|
|
|
227 |
else
|
|
|
228 |
{
|
|
|
229 |
$m_id = $game->g_m2;
|
|
|
230 |
}
|
|
|
231 |
|
|
|
232 |
}
|
|
|
233 |
else
|
|
|
234 |
{
|
|
|
235 |
$m_id = "$game->g_m1 OR t_id=$game->g_m2";
|
|
|
236 |
}
|
|
|
237 |
$sql = "UPDATE teams SET t_aus='$game->g_type' WHERE t_id=$m_id";
|
|
|
238 |
$res = $db->query( $sql );
|
|
|
239 |
if ( DB::isError($res) )
|
|
|
240 |
{
|
|
|
241 |
$smarty->assign( "meld",
|
|
|
242 |
"Ein Fehler ist aufgetreten!" );
|
|
|
243 |
$smarty->assign( "db_meld", $db->
|
|
|
244 |
getUserInfo );
|
|
|
245 |
$smarty->assign( "error", true );
|
|
|
246 |
}
|
|
|
247 |
}
|
|
|
248 |
}
|
|
|
249 |
}
|
|
|
250 |
$smarty->display( "meld.tpl" );
|
|
|
251 |
}
|
|
|
252 |
}
|
|
|
253 |
break;
|
|
|
254 |
case "ask":
|
|
|
255 |
$smarty->assign( "title", $title );
|
|
|
256 |
$smarty->assign( "art", "Spiel" );
|
|
|
257 |
$smarty->assign( "id", $id );
|
|
|
258 |
$smarty->assign( "name", $game->g_name );
|
|
|
259 |
$smarty->display( "del.tpl" );
|
|
|
260 |
break;
|
|
|
261 |
default:
|
|
|
262 |
$smarty->assign( "title", $title );
|
|
|
263 |
$smarty->assign( "meld", "Ein Fehler ist aufgetreten!" );
|
|
|
264 |
$smarty->assign( "db_meld", "Ungültiger Modsu!" );
|
|
|
265 |
$smarty->assign( "error", true );
|
|
|
266 |
$smarty->display( "meld.tpl" );
|
|
|
267 |
}
|
|
|
268 |
}
|
|
|
269 |
}
|
| 16 |
lars |
270 |
?>
|