Subversion-Projekte lars-tiefland.em_wm

Revision

Revision 93 | Revision 107 | Zur aktuellen Revision | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 93 Revision 106
Zeile 1... Zeile 1...
1
<?
1
<?
2
	require("include/common.php");
2
	require ("include/common.php");
3
	$smarty->assign("title",$common["final_result"]);
3
	$smarty->assign("title", $common["final_result"]);
4
	if($config->type=="WC")
4
	$smarty->caching = true;
-
 
5
	$smarty->cache_lifetime = 86400;
-
 
6
	define("CACHE_ID", $u_loc . "|0");
-
 
7
	if (!$smarty->is_cached("group.tpl", CAHCE_ID))
5
	{
8
	{
-
 
9
		if ($config->type == "WC")
-
 
10
		{
6
		$sql="SELECT * FROM games WHERE g_type IN (5,6)";
11
			$sql = "SELECT * FROM games WHERE g_type IN (5,6)";
7
	}
12
		}
8
	else
13
		else
9
	{
14
		{
10
		$sql="SELECT * FROM games WHERE g_type IN (4)";
15
			$sql = "SELECT * FROM games WHERE g_type IN (4)";
11
	}
16
		}
12
	$res=$db->query($sql);
17
		$res = $db->query($sql);
13
	if (DB::isError($res))
18
		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
	{
-
 
22
		if($config->type=="WC")
-
 
23
		{
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
		{
24
			while($row=$res->fetchRow())
27
			if ($config->type == "WC")
25
			{
28
			{
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);
29
				while ($row = $res->fetchRow())
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
				{
30
				{
-
 
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
					{
43
					$champion1=($g_g1>$g_g2)?$t_name1:$t_name2;
48
						$champion1 = ($g_g1 > $g_g2) ? $t_name1 : $t_name2;
44
					$champion2=($g_g1<$g_g2)?$t_name1:$t_name2;
49
						$champion2 = ($g_g1 < $g_g2) ? $t_name1 : $t_name2;
-
 
50
					}
45
				}
51
				}
46
			}
52
			}
-
 
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);
47
		}
74
		}
48
		else
-
 
49
		{
-
 
50
			$row=$res->fetchRow();
-
 
51
			$g_id=$row["g_id"];
-
 
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;
-
 
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!";
-
 
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
	}
75
	}
-
 
76
	$smarty->display("result.tpl");
71
?>
77
?>