Subversion-Projekte lars-tiefland.em_wm

<?
        require("./include/common.php");
        $start=(isset($_POST["start"]))?$_POST["start"]:0;
        $smarty->assign("title", "Gruppentabelle");
        $g_l=Gruppe::listeGruppe(0,0);
        if ($error)
        {
                $smarty->assign("error", $error);
                $smarty->assign("meld", $meld);
                $smarty->assign("db_meld", $db_meld);
                $smarty->display("meld.tpl");
        }
                else
                {
                $i=0;
                while($row_g=$g_l->fetchRow(DB_FETCHMODE_ASSOC))
                {
                        $g_id=$row_g["g_id"];
                        $g_name=$row_g["g_name"];
                        $sql_t="SELECT * FROM teams WHERE t_group=$g_id ORDER BY t_points DESC, t_diff DESC";
                        $res_t=$db->query($sql_t);
                        if (DB::isError($res_t))
                        {
                                $error="true";
                                $meld="Ein Fehler ist aufgetreten!";
                                $db_meld=$res_t->getUserInfo();
                                $smarty->assign("error", $error);
                                $smarty->assign("meld", $meld);
                                $smarty->assign("db_meld", $db_meld);
                                $smarty->display("meld.tpl");
                        }
                        else
                        {
                                while($row_t=$res_t->fetchRow(DB_FETCHMODE_ASSOC))
                                {
                                        $t_name=$row_t["t_name"];
                                        $t_diff=$row_t["t_diff"];
                                        $t_points=$row_t["t_points"];
                                        $t_goals=$row_t["t_goals"];
                                        $t_flag=$row_t["t_flag"];
                                        $pos=(($i % 4)+1);
                                        $erg[$i]["g_name"]=$g_name;
                                        $erg[$i]["pos"]=$pos;
                                        $erg[$i]["team"]=$t_name;
                                        $erg[$i]["diff"]=$t_diff;
                                        $erg[$i]["points"]=$t_points;
                                        $erg[$i]["tore"]=$t_goals;
                                        $erg[$i]["flag"]="images/flags/$t_flag";
                                        $i++;
                                }
                        }
                }
                $smarty->assign("erg", $erg);
                $smarty->display("group.tpl");
        }
?>