Subversion-Projekte lars-tiefland.em_wm

<?
        require("include/common.php");
        $smarty->assign("title",$common["result"]);
        $sql="SELECT * FROM games WHERE g_type IN (5,6)";
        $res=$db->query($sql);
        if (DB::isError($res))
        {
                $smarty->assign("meld",$common["an_error_occured"]);
                $smarty->assign("db_meld",$res->getUserInfo());
                $smarty->assign("error",true);
                $smarty->display("meld.tpl");
        }
        else
        {
                while($row=$res->fetchRow())
                {
                        $g_type=$row["g_type"];
                        $t_id1=$row["g_m1"];
                        $t_id2=$row["g_m2"];
                        $g_g1=$row["g_g1"];
                        $g_g2=$row["g_g2"];
                        $t1=new Team($t_id1);
                        $t2=new Team($t_id2);
                        $t_name1=$t1->t_name;
                        $t_name2=$t2->t_name;
                        if($g_type==5)
                        {
                                $champion3=($g_g1>$g_g2)?$t_name1:$t_name2;
                                $champion4=($g_g1<$g_g2)?$t_name1:$t_name2;
                        }
                        else
                        {
                                $champion1=($g_g1>$g_g2)?$t_name1:$t_name2;
                                $champion2=($g_g1<$g_g2)?$t_name1:$t_name2;
                        }
                }
                $smarty->assign("champion1",$champion1);
                $smarty->assign("champion2",$champion2);
                $smarty->assign("champion3",$champion3);
                $smarty->assign("champion4",$champion4);
                $smarty->display("result.tpl");
        }
?>