Subversion-Projekte lars-tiefland.em_wm

Revision

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

Revision Autor Zeilennr. Zeile
13 lars 1
<?
106 lars 2
	require ("./include/common.php");
3
	$start = intval(isset($_POST["start"]) ? $_POST["start"] : 0);
4
	$smarty->caching = true;
5
	$smarty->cache_lifetime = 86400;
6
	define("CACHE_ID", $u_loc . "|" . $start);
7
	if (!$smarty->is_cached("group.tpl", CAHCE_ID))
52 lars 8
	{
106 lars 9
		$g_l = Gruppe::listeGruppe(0, 0);
10
		$sql_l = "SELECT max(g_date) datum FROM games WHERE g_type=1";
11
		$res_l = $db->query($sql_l);
12
		$row_l = $res_l->fetchRow();
13
		$date_l = $row_l["datum"] + 7200;
14
		if ($date_l > time())
13 lars 15
		{
106 lars 16
			$h1 = $common["provisional"] . " ";
17
			$act = $loc->formatDateTime(time());
18
		}
19
		else
20
		{
21
			$h1 = $common["final"] . " ";
22
			$act = $loc->formatDateTime($date_l);
23
		}
24
		$act .= " " . $common["o_clock"];
25
		$h1 .= $common["prel_table"];
26
		$title = "$h1 - " . $common["state"] . ": $act";
27
		$smarty->assign("title", $title);
28
		$smarty->assign("h1", $h1);
29
		if ($error)
30
		{
31
			$smarty->assign("error", $error);
32
			$smarty->assign("meld", $meld);
33
			$smarty->assign("db_meld", $db_meld);
34
			$smarty->display("meld.tpl");
35
		}
36
		else
37
		{
38
			$i = 0;
39
			while ($row_g = $g_l->fetchRow())
13 lars 40
			{
106 lars 41
				$g_id = $row_g["g_id"];
42
				$g_name = $row_g["g_name"];
43
				$sql_t = "SELECT * FROM teams WHERE t_group=$g_id ORDER BY t_pos ASC";
44
				$res_t = $db->query($sql_t);
45
				if (DB::isError($res_t))
13 lars 46
				{
106 lars 47
					$error = "true";
48
					$meld = "Ein Fehler ist aufgetreten!";
49
					$db_meld = $res_t->getUserInfo();
50
					$smarty->assign("error", $error);
51
					$smarty->assign("meld", $meld);
52
					$smarty->assign("db_meld", $db_meld);
53
					$smarty->display("meld.tpl");
54
				}
55
				else
56
				{
57
					while ($row_t = $res_t->fetchRow())
83 lars 58
					{
106 lars 59
						$t_name = $row_t["t_name"];
60
						$t_diff = $row_t["t_diff"];
61
						$t_points = $row_t["t_points"];
62
						$t_goals = $row_t["t_goals"];
63
						$t_flag = $row_t["t_flag"];
64
						$pos = (($i % 4) + 1);
65
						if ($pos == 1 || $pos == 2)
66
						{
67
							$erg[$i]["style_b"] = "<b>";
68
							$erg[$i]["style_e"] = "</b>";
69
						}
70
						else
71
						{
72
							$erg[$i]["style_b"] = "";
73
							$erg[$i]["style_e"] = "";
74
						}
75
						$erg[$i]["g_name"] = $g_name;
76
						$erg[$i]["pos"] = $pos;
77
						$erg[$i]["team"] = $t_name;
78
						$erg[$i]["diff"] = $t_diff;
79
						$erg[$i]["points"] = $t_points;
80
						$erg[$i]["tore"] = $t_goals;
81
						$erg[$i]["flag"] = "images/flags/$t_flag";
82
						$i++;
83 lars 83
					}
13 lars 84
				}
106 lars 85
			}
86
			$smarty->assign("erg", $erg);
13 lars 87
		}
106 lars 88
		$smarty->display("group.tpl", CACHE_ID);
13 lars 89
	}
90
?>