Subversion-Projekte lars-tiefland.em_wm

Revision

Revision 77 | Revision 106 | Zur aktuellen Revision | Details | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
66 lars 1 
<?
2 
	require("include/common.php");
77 lars 3 
	$smarty->assign("title",$common["final_result"]);
93 lars 4 
	if($config->type=="WC")
5 
	{
6 
		$sql="SELECT * FROM games WHERE g_type IN (5,6)";
7 
	}
8 
	else
9 
	{
10 
		$sql="SELECT * FROM games WHERE g_type IN (4)";
11 
	}
66 lars 12 
	$res=$db->query($sql);
13 
	if (DB::isError($res))
14 
	{
15 
		$smarty->assign("meld",$common["an_error_occured"]);
16 
		$smarty->assign("db_meld",$res->getUserInfo());
17 
		$smarty->assign("error",true);
18 
		$smarty->display("meld.tpl");
19 
	}
20 
	else
21 
	{
93 lars 22 
		if($config->type=="WC")
66 lars 23 
		{
93 lars 24 
			while($row=$res->fetchRow())
25 
			{
26 
				$g_id=$row["g_id"];
27 
				$g_type=$row["g_type"];
28 
				$t_id1=$row["g_m1"];
29 
				$t_id2=$row["g_m2"];
30 
				$g_g1=$row["g_g1"];
31 
				$g_g2=$row["g_g2"];
32 
				$t1=new Team($t_id1);
33 
				$t2=new Team($t_id2);
34 
				$t_name1=$t1->t_name;
35 
				$t_name2=$t2->t_name;
36 
				if($g_type==5)
37 
				{
38 
					$champion3=($g_g1>$g_g2)?$t_name1:$t_name2;
39 
					$champion4=($g_g1<$g_g2)?$t_name1:$t_name2;
40 
				}
41 
				else
42 
				{
43 
					$champion1=($g_g1>$g_g2)?$t_name1:$t_name2;
44 
					$champion2=($g_g1<$g_g2)?$t_name1:$t_name2;
45 
				}
46 
			}
47 
		}
48 
		else
49 
		{
50 
			$row=$res->fetchRow();
51 
			$g_id=$row["g_id"];
66 lars 52 
			$g_type=$row["g_type"];
53 
			$t_id1=$row["g_m1"];
54 
			$t_id2=$row["g_m2"];
55 
			$g_g1=$row["g_g1"];
56 
			$g_g2=$row["g_g2"];
57 
			$t1=new Team($t_id1);
58 
			$t2=new Team($t_id2);
59 
			$t_name1=$t1->t_name;
60 
			$t_name2=$t2->t_name;
93 lars 61 
			$champion1=($g_g1>$g_g2)?$t_name1:$t_name2;
62 
			$champion2=($g_g1<$g_g2)?$t_name1:$t_name2;
63 
			$champion3=$champion4="Gibt es bei einer EM NICHT!";
66 lars 64 
		}
65 
		$smarty->assign("champion1",$champion1);
66 
		$smarty->assign("champion2",$champion2);
67 
		$smarty->assign("champion3",$champion3);
68 
		$smarty->assign("champion4",$champion4);
69 
		$smarty->display("result.tpl");
70 
	}
71 
?>