Subversion-Projekte lars-tiefland.em_wm

<?

	define("IN_ADMIN", true);

	require("include/common.php");

	$mode=isset($_POST["mode"])?$_POST["mode"]:"";

	$id=intval(isset($_POST["id"])?$_POST["id"]:0);

	if ($mode=="edit" OR $mode=="new")

	{

		$t_namen[]="Bitte wählen!";

		$t_ids[]=-1;

		$l_namen[]="Bitte wählen!";

		$l_ids[]=-1;

		$g_l=Gruppe::listeGruppe(0,0);

		while($row_g=$g_l->fetchRow(DB_FETCHMODE_ASSOC))

		{

			$g_id=$row_g["g_id"];

			$g_name=$row_g["g_name"];

			$t_namen[]="---------- Gruppe $g_name ----------";

			$t_ids[]=-1;

			$sql_t="SELECT * FROM teams WHERE t_group=$g_id";

			$t_l=$db->query($sql_t);

			while ($row_t=$t_l->fetchRow(DB_FETCHMODE_ASSOC))

			{

				$t_name=$row_t["t_name"];

				$t_id=$row_t["t_id"];

				$t_namen[]=$t_name;

				$t_ids[]=$t_id;

  			}

		}

		$sql_l="SELECT * FROM locations";

		$l_l=$db->query($sql_l);

		while ($row_l=$l_l->fetchRow(DB_FETCHMODE_ASSOC))

		{

			$l_name=$row_l["l_name"];

			$l_id=$row_l["l_id"];

			$l_namen[]=$l_name;

			$l_ids[]=$l_id;

  		}

  		$game=new Spiele($id);

  		$smarty->assign("s_name", $game->g_name);

  		$smarty->assign("akt_m1_id", $game->g_m1);

  		$smarty->assign("akt_m2_id", $game->g_m2);

  		$smarty->assign("akt_l_id", $game->g_location);

  		$smarty->assign("s_g1", $game->g_g1);

  		$smarty->assign("s_g2", $game->g_g2);

  		$smarty->assign("t_namen", $t_namen);

  		$smarty->assign("t_ids", $t_ids);

  		$smarty->assign("l_ids", $l_ids);

  		$smarty->assign("l_namen", $l_namen);

		$smarty->display("edit_games.tpl");

	}

?>