Subversion-Projekte lars-tiefland.em_wm

Revision

Revision 107 | Revision 114 | Zur aktuellen Revision | Details | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

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