Subversion-Projekte lars-tiefland.em_wm

Revision

Revision 39 | Revision 44 | Zur aktuellen Revision | Details | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
16 lars 1 
<?
2 
	define("IN_ADMIN", true);
3 
	require("include/common.php");
4 
	$mode=isset($_POST["mode"])?$_POST["mode"]:"";
5 
	$id=intval(isset($_POST["id"])?$_POST["id"]:0);
37 lars 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"]:0);
32 lars 11 
	$g_type=intval(isset($_POST["g_typ"])?$_POST["g_typ"]:-1);
12 
	$g_name=addslashes(isset($_POST["g_name"])?$_POST["g_name"]:"");
13 
	$month=intval(isset($_POST["Month"])?$_POST["Month"]:-1);
14 
	$day=intval(isset($_POST["Day"])?$_POST["Day"]:-1);
15 
	$hour=intval(isset($_POST["Hour"])?$_POST["Hour"]:-1);
33 lars 16 
	$game=new Spiele($id);
35 lars 17 
	$t=new Typ($g_type);
18 
	$sql_t="SELECT count(*) AS anzahl FROM games WHERE g_type=$g_type";
19 
	$res_t=$db->query($sql_t);
20 
	$row_t=$res_t->fetchRow(DB_FETCHMODE_ASSOC);
21 
	$anz=$row_t["anzahl"];
32 lars 22 
	if ($hour >=0 AND $day > 0 AND $month > 0)
23 
	{
24 
		$g_date=mktime($hour, 0, 0, $month, $day, 2006);
25 
	}
37 lars 26 
	if ($mode=="save" || $mode=="update")
27 
	{
28 
		$game->update($g_name, $g_m1, $g_m2, $g_g1, $g_g2, $g_location, $g_date, $g_type);
29 
	}
30 
 
31 lars 31 
	function fill_form()
18 lars 32 
	{
33 lars 33 
		global $db, $smarty, $id, $new_mode, $g_date, $title, $game;
16 lars 34 
		$t_namen[]="Bitte wählen!";
35 
		$t_ids[]=-1;
18 lars 36 
		$typ_namen[]="Bitte wählen!";
37 
		$typ_ids[]=-1;
16 lars 38 
		$l_namen[]="Bitte wählen!";
39 
		$l_ids[]=-1;
40 
		$g_l=Gruppe::listeGruppe(0,0);
41 
		while($row_g=$g_l->fetchRow(DB_FETCHMODE_ASSOC))
42 
		{
43 
			$g_id=$row_g["g_id"];
44 
			$g_name=$row_g["g_name"];
45 
			$t_namen[]="---------- Gruppe $g_name ----------";
46 
			$t_ids[]=-1;
47 
			$sql_t="SELECT * FROM teams WHERE t_group=$g_id";
48 
			$t_l=$db->query($sql_t);
49 
			while ($row_t=$t_l->fetchRow(DB_FETCHMODE_ASSOC))
50 
			{
51 
				$t_name=$row_t["t_name"];
52 
				$t_id=$row_t["t_id"];
53 
				$t_namen[]=$t_name;
54 
				$t_ids[]=$t_id;
19 lars 55 
			}
16 lars 56 
		}
18 lars 57 
		$l_l=Ort::listeOrt(0,0);
16 lars 58 
		while ($row_l=$l_l->fetchRow(DB_FETCHMODE_ASSOC))
59 
		{
60 
			$l_name=$row_l["l_name"];
61 
			$l_id=$row_l["l_id"];
62 
			$l_namen[]=$l_name;
63 
			$l_ids[]=$l_id;
19 lars 64 
		}
18 lars 65 
		$typ_l=Typ::listeTyp(0,0);
66 
		while ($row_typ=$typ_l->fetchRow(DB_FETCHMODE_ASSOC))
67 
		{
68 
			$typ_name=$row_typ["t_name"];
69 
			$typ_id=$row_typ["t_id"];
70 
			$typ_namen[]=$typ_name;
71 
			$typ_ids[]=$typ_id;
72 
		}
28 lars 73 
		$smarty->assign("id", $id);
33 lars 74 
		$smarty->assign("g_date", (!isset($g_date))?$game->g_date:$g_date);
75 
		$smarty->assign("g_name", ($game->g_name));
18 lars 76 
		$smarty->assign("akt_typ_id", $game->g_type);
77 
		$smarty->assign("akt_m1_id", $game->g_m1);
78 
		$smarty->assign("akt_m2_id", $game->g_m2);
79 
		$smarty->assign("akt_l_id", $game->g_location);
19 lars 80 
		$smarty->assign("g_g1", $game->g_g1);
81 
		$smarty->assign("g_g2", $game->g_g2);
18 lars 82 
		$smarty->assign("t_namen", $t_namen);
83 
		$smarty->assign("t_ids", $t_ids);
84 
		$smarty->assign("typ_namen", $typ_namen);
85 
		$smarty->assign("typ_ids", $typ_ids);
86 
		$smarty->assign("l_ids", $l_ids);
87 
		$smarty->assign("l_namen", $l_namen);
88 
		$smarty->assign("mode", $new_mode);
89 
		$smarty->assign("title", $title);
40 lars 90 
		$smarty->assign("extra", ($new_mode=="save")?"disabled=\"disabled\"":"");
16 lars 91 
		$smarty->display("edit_games.tpl");
92 
	}
31 lars 93 
 
94 
	switch ($mode)
95 
	{
96 
		case "edit":
97 
			$title="Spiel $id ändern";
98 
			$new_mode="update";
99 
			break;
100 
		case "new":
101 
			$title="neues Spiel eingeben";
102 
			$new_mode="save";
103 
			break;
37 lars 104 
		case "delete":
31 lars 105 
		case "ask":
106 
			$title="Spiel $id löschen";
37 lars 107 
			$new_mode="delete";
31 lars 108 
			break;
109 
		case "save":
110 
			$title="neues Spiel speichern";
37 lars 111 
			$new_mode="save";
31 lars 112 
			break;
113 
		case "update":
114 
			$title="Spiel $id speichern";
115 
			$new_mode="update";
116 
			break;
117 
	}
118 
	if ($mode=="edit" OR $mode=="new")
119 
	{
120 
		fill_form();
121 
	}
18 lars 122 
	else
123 
	{
124 
		switch ($mode)
125 
		{
126 
			case "save":
37 lars 127 
			case "delete":
19 lars 128 
			case "update":
31 lars 129 
				if (!checkdate($month, $day, $config->year))
28 lars 130 
				{
31 lars 131 
					$meld="Ein Fehler ist aufgetreten!";
132 
					$db_meld="$day.$month.$config->year ist kein gültiges Datum!";
35 lars 133 
					$error=true;
31 lars 134 
					$smarty->assign("db_meld", $db_meld);
135 
					$smarty->assign("error", $error);
136 
					$smarty->assign("meld", $meld);
137 
					fill_form();
28 lars 138 
				}
30 lars 139 
				else
140 
				{
38 lars 141 
					if (($mode=="save" && $anz >=$t->t_max) || ($mode=="update" && $anz>$t->t_max))
30 lars 142 
					{
35 lars 143 
						$meld="Ein Fehler ist aufgetreten!";
144 
						$db_meld="Es kann nur $t->t_max Spiele vom Typ \"$t->t_name\" geben! Bitte den Typ oder ein vorhandenes Spiel ändern!";
145 
						$error=true;
146 
						$smarty->assign("db_meld", $db_meld);
147 
						$smarty->assign("error", $error);
148 
						$smarty->assign("meld", $meld);
149 
						fill_form();
30 lars 150 
					}
151 
					else
152 
					{
39 lars 153 
						$res=$game->save($mode);
35 lars 154 
						if (true == DB::isError($res))
31 lars 155 
						{
35 lars 156 
							$smarty->assign("meld", "Ein Fehler ist aufgetreten!");
157 
							$smarty->assign("db_meld", $res->getUserInfo());
158 
							$smarty->assign("error", true);
31 lars 159 
						}
160 
						else
161 
						{
35 lars 162 
							if ($mode=="save")
163 
							{
164 
								$akt="hinzugefügt";
165 
							}
166 
							elseif ($mode=="update")
167 
							{
168 
								$akt="geändert";
169 
							}
170 
							else
171 
							{
172 
								$akt="gelöscht";
173 
							}
40 lars 174 
							$smarty->assign("title", $title);
35 lars 175 
							$smarty->assign("meld", "Datensatz erfolgreich $akt!");
176 
							$smarty->assign("db_meld", "");
177 
							$smarty->assign("error", false);
31 lars 178 
						}
35 lars 179 
						$smarty->display("meld.tpl");
30 lars 180 
					}
181 
				}
19 lars 182 
				break;
30 lars 183 
			case "ask":
33 lars 184 
				$smarty->assign("title", $title);
185 
				$smarty->assign("art", "Spiel");
186 
				$smarty->assign("id", $id);
187 
				$smarty->assign("name",$game->g_name);
188 
				$smarty->display("del.tpl");
30 lars 189 
				break;
190 
			default:
40 lars 191 
				$smarty->assign("title", $title);
30 lars 192 
				$smarty->assign("meld","Ein Fehler ist aufgetreten!");
193 
				$smarty->assign("db_meld", "Ungültiger Modsu!");
194 
				$smarty->assign("error", true);
31 lars 195 
				$smarty->display("meld.tpl");
18 lars 196 
		}
197 
	}
16 lars 198 
?>