Subversion-Projekte lars-tiefland.em_wm

Revision

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

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