Subversion-Projekte lars-tiefland.em_wm

<?
        define("IN_ADMIN",true);
        require("include/common.php");
        $smarty->assign("title", "Gruppentabelle");
        $t_l=Team::listeTeam(0,0);
        $i=0;
        while($row_t=$t_l->fetchRow(DB_FETCHMODE_ASSOC))
        {
                $diff=0;
                $g1=0;
                $g2=0;
                $p1=0;
                $t_id=$row_t["t_id"];
                $t=new Team($t_id);
                $today=mktime(date("H"),date("i"),date("s"),date("m"),date("d"),date("Y"));
                $sql_g="SELECT * FROM games WHERE (g_m1=$t_id OR g_m2=$t_id) AND g_type=1 AND g_date<=$today";
                $res_g=$db->query($sql_g);
                while($row_g=$res_g->fetchRow(DB_FETCHMODE_ASSOC))
                {
                        if (($row_g["g_g1"]>$row_g["g_g2"] AND $row_g["g_m1"]==$t_id) OR ($row_g["g_g2"]>$row_g["g_g1"] AND $row_g["g_m2"]==$t_id))
                        {
                                $p1+=3;
                        }
                        else
                        {
                                if ($row_g["g_g1"]==$row_g["g_g2"])
                                {
                                        $p1+=1;
                                }
                                else
                                {
                                        $p1+=0;
                                }
                        }
                        if ($row_g["g_m1"]==$t_id)
                        {
                                $g1+=$row_g["g_g1"];
                                $g2+=$row_g["g_g2"];
                        }
                        else
                        {
                                $g2+=$row_g["g_g1"];
                                $g1+=$row_g["g_g2"];
                        }
                }
                $diff=$g1 - $g2;
                $erg[$i]["tore"]="$g1 : $g2";
                $i++;
                $sql_u="UPDATE teams SET t_diff=$diff, t_points=$p1, t_goals='$g1 : $g2' WHERE t_id=$t_id";
                $res_u=$db->query($sql_u);
                if (true == DB::isError($res_u))
                {
                        $error="true";
                        $meld="Ein Fehler ist aufgetreten!";
                        $db_meld=$res_u->getUserInfo();
                        break;
                }
                else
                {
                        $meld="Gruppentabelle erfolgreich erstellt!";
                        $error=false;
                }
        }
        $smarty->assign("error", $error);
        $smarty->assign("meld", $meld);
        $smarty->assign("db_meld", $db_meld);
        $smarty->display("meld.tpl");
?>