Subversion-Projekte lars-tiefland.em_wm

<?
        define("IN_ADMIN",true);
        require("include/common.php");
        if(User_login(true)->getAuth())
        {
                $smarty->assign("title", "Gruppentabelle berechnen");
                $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");
        }
?>