Subversion-Projekte lars-tiefland.em_wm

<?
        require("include/common.php");
        $smarty->assign("title",$common["final_result"]);
        if($config->type=="WC")
        {
                $sql="SELECT * FROM games WHERE g_type IN (5,6)";
        }
        else
        {
                $sql="SELECT * FROM games WHERE g_type IN (4)";
        }
        $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
        {
                if($config->type=="WC")
                {
                        while($row=$res->fetchRow())
                        {
                                $g_id=$row["g_id"];
                                $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;
                                }
                        }
                }
                else
                {
                        $row=$res->fetchRow();
                        $g_id=$row["g_id"];
                        $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;
                        $champion1=($g_g1>$g_g2)?$t_name1:$t_name2;
                        $champion2=($g_g1<$g_g2)?$t_name1:$t_name2;
                        $champion3=$champion4="Gibt es bei einer EM NICHT!";
                }
                $smarty->assign("champion1",$champion1);
                $smarty->assign("champion2",$champion2);
                $smarty->assign("champion3",$champion3);
                $smarty->assign("champion4",$champion4);
                $smarty->display("result.tpl");
        }
?>