Subversion-Projekte lars-tiefland.em_wm

Revision

Revision 19 | Zur aktuellen Revision | Blame | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

<?
        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");
        }
?>