Subversion-Projekte lars-tiefland.em_wm

Revision

Revision 52 | Revision 58 | Zur aktuellen Revision | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 52 Revision 54
Zeile 1... Zeile 1...
1 
<?
 1 
<?
2 
	define("IN_ADMIN", true);
 2 
	define("IN_ADMIN", true);
3 
	require("include/common.php");
 3 
	require("include/common.php");
- 
 
 4 
	$mode=($_POST["mode"])?$_POST["mode"]:"new";
- 
 
 5 
	$id=intval(($_POST["id"])?$_POST["id"]:0);
- 
 
 6 
	$g_m1=intval(($_POST["g_m1"])?$_POST["g_m1"]:0);
- 
 
 7 
	$g_m2=intval(($_POST["g_m2"])?$_POST["g_m2"]:0);
- 
 
 8 
	$g_g1=intval(($_POST["g_g1"])?$_POST["g_g1"]:0);
- 
 
 9 
	$g_g2=intval(($_POST["g_g2"])?$_POST["g_g2"]:0);
- 
 
 10 
	$g_location=intval(($_POST["g_location"])?$_POST["g_location"]:0);
- 
 
 11 
	$g_type=intval(($_POST["g_typ"])?$_POST["g_typ"]:-1);
- 
 
 12 
	$g_name=addslashes(($_POST["g_name"])?$_POST["g_name"]:"");
- 
 
 13 
	$month=intval(($_POST["Month"])?$_POST["Month"]:-1);
- 
 
 14 
	$day=intval(($_POST["Day"])?$_POST["Day"]:-1);
- 
 
 15 
	$hour=intval(($_POST["Hour"])?$_POST["Hour"]:-1);
4 
	$g=Spiele::listSpiele(0,0);
 16 
	$g=Spiele::listSpiele(0,0);
5 
	$g_anz=$g->numRows();
 17 
	$g_anz=$g->numRows();
6 
	$g_max=2*$config->groups*$config->teams_per_group;
 18 
	$g_max=2*$config->groups*$config->teams_per_group;
- 
 
 19 
	if ($hour >=0 AND $day > 0 AND $month > 0)
- 
 
 20 
	{
- 
 
 21 
		$g_date=mktime($hour, 0, 0, $month, $day, 2006);
- 
 
 22 
	}
7 
	if ($g_anz>=$g_max && $mode=="new")
 23 
	if ($g_anz>=$g_max && $mode=="new")
8 
	{
 24 
	{
9 
		$smarty->assign("meld","Ein Fehler ist aufgetreten!");
 25 
		$smarty->assign("meld","Ein Fehler ist aufgetreten!");
10 
		$smarty->assign("db_meld","In dieser $config->type sind nur $g_max Spiele zulässig!");
 26 
		$smarty->assign("db_meld","In dieser $config->type sind nur $g_max Spiele zulässig!");
11 
		$smarty->assign("error",true);
 27 
		$smarty->assign("error",true);
12 
		$smarty->display("meld.tpl");
 28 
		$smarty->display("meld.tpl");
13 
		exit;
 29 
		exit;
14 
	}
 30 
	}
15 
	$mode=isset($_POST["mode"])?$_POST["mode"]:"";
 - 
 
16 
	$id=intval(isset($_POST["id"])?$_POST["id"]:0);
 - 
 
17 
	$smarty->assign("mode", $mode);
 31 
	$smarty->assign("mode", $mode);
18 
	$smarty->assign("id", $id);
 32 
	$smarty->assign("id", $id);
19 
	$a=User_login(true);
 33 
	$a=User_login(true);
20 
	if ($a->getAuth())
 34 
	if ($a->getAuth())
21 
	{
 35 
	{
22 
		$g_m1=intval(isset($_POST["g_m1"])?$_POST["g_m1"]:0);
 36 
		if($u->u_type!=1 && $mode!="edit")
- 
 
 37 
		{
23 
		$g_m2=intval(isset($_POST["g_m2"])?$_POST["g_m2"]:0);
 38 
			$meld="Ein Fehler ist aufgetreten!";
24 
		$g_g1=intval(isset($_POST["g_g1"])?$_POST["g_g1"]:0);
 39 
			$db_meld="Nur Administratoren haben Zugriff auf diese Funktion!";
25 
		$g_g2=intval(isset($_POST["g_g2"])?$_POST["g_g2"]:0);
 40 
			$smarty->assign("meld", $meld);
26 
		$g_location=intval(isset($_POST["g_location"])?$_POST["g_location"]:0);
 - 
 
27 
		$g_type=intval(isset($_POST["g_typ"])?$_POST["g_typ"]:-1);
 - 
 
28 
		$g_name=addslashes(isset($_POST["g_name"])?$_POST["g_name"]:"");
 41 
			$smarty->assign("db_meld", $db_meld);
29 
		$month=intval(isset($_POST["Month"])?$_POST["Month"]:-1);
 42 
			$smarty->assign("error", true);
30 
		$day=intval(isset($_POST["Day"])?$_POST["Day"]:-1);
 43 
			$smarty->display("meld.tpl");
31 
		$hour=intval(isset($_POST["Hour"])?$_POST["Hour"]:-1);
 44 
			exit;
- 
 
 45 
		}
32 
		$game=new Spiele($id);
 46 
		$game=new Spiele($id);
33 
		$t=new Typ($g_type);
 47 
		$t=new Typ($g_type);
34 
		$sql_t="SELECT count(*) AS anzahl FROM games WHERE g_type=$g_type";
 48 
		$sql_t="SELECT count(*) AS anzahl FROM games WHERE g_type=$g_type";
35 
		$res_t=$db->query($sql_t);
 49 
		$res_t=$db->query($sql_t);
36 
		$row_t=$res_t->fetchRow();
 50 
		$row_t=$res_t->fetchRow();
37 
		$anz=$row_t["anzahl"];
 51 
		$anz=$row_t["anzahl"];
38 
		if ($hour >=0 AND $day > 0 AND $month > 0)
 - 
 
39 
		{
 - 
 
40 
			$g_date=mktime($hour, 0, 0, $month, $day, 2006);
 - 
 
41 
		}
 - 
 
42 
		if ($mode=="save" || $mode=="update")
 52 
		if ($mode=="save" || $mode=="update")
43 
		{
 53 
		{
44 
			$game->update($g_name, $g_m1, $g_m2, $g_g1, $g_g2, $g_location, $g_date, $g_type);
 54 
			$game->update($g_name, $g_m1, $g_m2, $g_g1, $g_g2, $g_location, $g_date, $g_type);
45 
		}
 55 
		}
Zeile 63... Zeile 73...
63 
				$sql_t="SELECT * FROM teams WHERE t_group=$g_id";
 73 
				$sql_t="SELECT * FROM teams WHERE t_group=$g_id";
64 
				$t_l=$db->query($sql_t);
 74 
				$t_l=$db->query($sql_t);
65 
				while ($row_t=$t_l->fetchRow())
 75 
				while ($row_t=$t_l->fetchRow())
66 
				{
 76 
				{
67 
					$t_name=$row_t["t_name"];
 77 
					$t_name=$row_t["t_name"];
- 
 
 78 
					$t_aus=$row_t["t_aus"];
68 
					$t_id=$row_t["t_id"];
 79 
					$t_id=$row_t["t_id"];
69 
					$t_namen[]=$t_name;
 80 
					$t_namen[]=$t_name;
70 
					$t_ids[]=$t_id;
 81 
					$t_ids[]=$t_id;
71 
				}
 82 
				}
72 
			}
 83 
			}
Zeile 85... Zeile 96...
85 
				$typ_id=$row_typ["t_id"];
 96 
				$typ_id=$row_typ["t_id"];
86 
				$typ_namen[]=$typ_name;
 97 
				$typ_namen[]=$typ_name;
87 
				$typ_ids[]=$typ_id;
 98 
				$typ_ids[]=$typ_id;
88 
			}
 99 
			}
89 
			$smarty->assign("id", $id);
 100 
			$smarty->assign("id", $id);
90 
			$smarty->assign("g_date", (!isset($g_date))?$game->g_date:$g_date);
 101 
			$smarty->assign("g_date", (!($g_date))?$game->g_date:$g_date);
91 
			$smarty->assign("g_name", ($game->g_name));
 102 
			$smarty->assign("g_name", ($game->g_name));
92 
			$smarty->assign("akt_typ_id", $game->g_type);
 103 
			$smarty->assign("akt_typ_id", $game->g_type);
93 
			$smarty->assign("akt_m1_id", $game->g_m1);
 104 
			$smarty->assign("akt_m1_id", $game->g_m1);
94 
			$smarty->assign("akt_m2_id", $game->g_m2);
 105 
			$smarty->assign("akt_m2_id", $game->g_m2);
95 
			$smarty->assign("akt_l_id", $game->g_location);
 106 
			$smarty->assign("akt_l_id", $game->g_location);
Zeile 189... Zeile 200...
189 
								}
 200 
								}
190 
								$smarty->assign("title", $title);
 201 
								$smarty->assign("title", $title);
191 
								$smarty->assign("meld", "Datensatz erfolgreich $akt!");
 202 
								$smarty->assign("meld", "Datensatz erfolgreich $akt!");
192 
								$smarty->assign("db_meld", "");
 203 
								$smarty->assign("db_meld", "");
193 
								$smarty->assign("error", false);
 204 
								$smarty->assign("error", false);
- 
 
 205 
								if ($mode=="update")
- 
 
 206 
								{
- 
 
 207 
									if($game->g_g1 < $game->g_g2)
- 
 
 208 
									{
- 
 
 209 
										$m_id=$game->g_m1;
- 
 
 210 
									}
- 
 
 211 
									else
- 
 
 212 
									{
- 
 
 213 
										$m_id=$game->g_m2;
- 
 
 214 
									}
- 
 
 215 
									$sql="UPDATE teams SET t_aus='$game->g_type' WHERE t_id=$m_id";
- 
 
 216 
									$res=$db->query($sql);
- 
 
 217 
									if(DB::isError($res))
- 
 
 218 
									{
- 
 
 219 
										$smarty->assign("meld", "Ein Fehler ist aufgetreten!");
- 
 
 220 
										$smarty->assign("db_meld", $db->getUserInfo);
- 
 
 221 
										$smarty->assign("error", true);
- 
 
 222 
									}
- 
 
 223 
								}
194 
							}
 224 
							}
195 
							$smarty->display("meld.tpl");
 225 
							$smarty->display("meld.tpl");
196 
						}
 226 
						}
197 
					}
 227 
					}
198 
					break;
 228 
					break;