Subversion-Projekte lars-tiefland.em_wm

<?
        require("./include/common.php");
        $start=intval(isset($_POST["start"])?$_POST["start"]:0);
        $g_l=Gruppe::listeGruppe(0,0);
        $sql_l="SELECT max(g_date) datum FROM games WHERE g_type=1";
        $res_l=$db->query($sql_l);
        $row_l=$res_l->fetchRow();
        $date_l=$row_l["datum"]+7200;
        if ($date_l > time())
        {
                $h1=$common["provisional"]." ";
                $act=$loc->formatDateTime(time());
        }
        else
        {
                $h1=$common["final"]." ";
                $act=$loc->formatDateTime($date_l);
        }
        $act.=" ".$common["o_clock"];
        $h1.=$common["prel_table"];
        $title="$h1 - ".$common["state"].": $act";
        $smarty->assign("title", $title);
        $smarty->assign("h1", $h1);
        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())
                {
                        $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_pos ASC";
                        $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())
                                {
                                        $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");
        }
?>