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