Subversion-Projekte lars-tiefland.em_wm

Revision

Revision 16 | Revision 19 | 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);
18 lars 6 
	$g_m1=intval(isset($_POST["g_m1"])?$_POST["g_m1"]:-1);
7 
	$g_m2=intval(isset($_POST["g_m2"])?$_POST["g_m2"]:-1);
8 
	$g_g1=intval(isset($_POST["g_g1"])?$_POST["g_g1"]:-1);
9 
	$g_g2=intval(isset($_POST["g_g2"])?$_POST["g_g2"]:-1);
10 
	$g_namme=addslashes(isset($_POST["g_name"])?$_POST["name"]:"");
11 
	switch ($mode)
12 
	{
13 
		case "edit":
14 
			$title="Spiel $id ändern";
15 
			$new_mode="update";
16 
			break;
17 
		case "new":
18 
			$title="neues Spiel eingeben";
19 
			$new_mode="save";
20 
			break;
21 
		case "del":
22 
		case "ask":
23 
			$title="Spiel $id löschen";
24 
			$new_mode="update";
25 
			break;
26 
		case "save":
27 
			$title="neues Spiel speichern";
28 
			$new_mode="update";
29 
			break;
30 
		case "update":
31 
			$title="Spiel $id speichern";
32 
			$new_mode="update";
33 
			break;
34 
	}
16 lars 35 
	if ($mode=="edit" OR $mode=="new")
36 
	{
37 
		$t_namen[]="Bitte wählen!";
38 
		$t_ids[]=-1;
18 lars 39 
		$typ_namen[]="Bitte wählen!";
40 
		$typ_ids[]=-1;
16 lars 41 
		$l_namen[]="Bitte wählen!";
42 
		$l_ids[]=-1;
43 
		$g_l=Gruppe::listeGruppe(0,0);
44 
		while($row_g=$g_l->fetchRow(DB_FETCHMODE_ASSOC))
45 
		{
46 
			$g_id=$row_g["g_id"];
47 
			$g_name=$row_g["g_name"];
48 
			$t_namen[]="---------- Gruppe $g_name ----------";
49 
			$t_ids[]=-1;
50 
			$sql_t="SELECT * FROM teams WHERE t_group=$g_id";
51 
			$t_l=$db->query($sql_t);
52 
			while ($row_t=$t_l->fetchRow(DB_FETCHMODE_ASSOC))
53 
			{
54 
				$t_name=$row_t["t_name"];
55 
				$t_id=$row_t["t_id"];
56 
				$t_namen[]=$t_name;
57 
				$t_ids[]=$t_id;
58 
  			}
59 
		}
18 lars 60 
		$l_l=Ort::listeOrt(0,0);
16 lars 61 
		while ($row_l=$l_l->fetchRow(DB_FETCHMODE_ASSOC))
62 
		{
63 
			$l_name=$row_l["l_name"];
64 
			$l_id=$row_l["l_id"];
65 
			$l_namen[]=$l_name;
66 
			$l_ids[]=$l_id;
67 
  		}
18 lars 68 
		$typ_l=Typ::listeTyp(0,0);
69 
		while ($row_typ=$typ_l->fetchRow(DB_FETCHMODE_ASSOC))
70 
		{
71 
			$typ_name=$row_typ["t_name"];
72 
			$typ_id=$row_typ["t_id"];
73 
			$typ_namen[]=$typ_name;
74 
			$typ_ids[]=$typ_id;
75 
		}
76 
		$game=new Spiele($id);
77 
		$smarty->assign("s_name", $game->g_name);
78 
		$smarty->assign("akt_typ_id", $game->g_type);
79 
		$smarty->assign("akt_m1_id", $game->g_m1);
80 
		$smarty->assign("akt_m2_id", $game->g_m2);
81 
		$smarty->assign("akt_l_id", $game->g_location);
82 
		$smarty->assign("s_g1", $game->g_g1);
83 
		$smarty->assign("s_g2", $game->g_g2);
84 
		$smarty->assign("t_namen", $t_namen);
85 
		$smarty->assign("t_ids", $t_ids);
86 
		$smarty->assign("typ_namen", $typ_namen);
87 
		$smarty->assign("typ_ids", $typ_ids);
88 
		$smarty->assign("l_ids", $l_ids);
89 
		$smarty->assign("l_namen", $l_namen);
90 
		$smarty->assign("mode", $new_mode);
91 
		$smarty->assign("title", $title);
16 lars 92 
		$smarty->display("edit_games.tpl");
93 
	}
18 lars 94 
	else
95 
	{
96 
		switch ($mode)
97 
		{
98 
			case "save":
99 
				$sql="INSERT INTO games (g_name, g_m1, g_m2, g_g1, g_g2, g_location, g_date, g_time, g_type)
100 
					VALUES ('$g_name', $g_m1, $g_m2, $g_g1, $g_g2, $g_location, $g_date, $g_time, $g_type)";
101 
				break;
102 
 
103 
		}
104 
	}
16 lars 105 
?>