Subversion-Projekte lars-tiefland.em_wm

Revision

Revision 52 | Revision 55 | 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");
54 lars 3 
	$start=intval(($_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 
	{
54 lars 11 
		$title="vorläufige ";
12 
		$act=date("d.m.Y H:i",time());
52 lars 13 
	}
14 
	else
15 
	{
54 lars 16 
		$title="endgültige ";
17 
		$act=date("d.m.Y H:i",$date_l);
52 lars 18 
	}
54 lars 19 
	$act.=" Uhr";
20 
	$title.="Gruppentabelle - Stand $act";
52 lars 21 
	$smarty->assign("title", $title);
13 lars 22 
	if ($error)
23 
	{
24 
		$smarty->assign("error", $error);
25 
		$smarty->assign("meld", $meld);
26 
		$smarty->assign("db_meld", $db_meld);
27 
		$smarty->display("meld.tpl");
28 
	}
29 
 		else
30 
 		{
31 
		$i=0;
52 lars 32 
		while($row_g=$g_l->fetchRow())
13 lars 33 
		{
34 
			$g_id=$row_g["g_id"];
35 
			$g_name=$row_g["g_name"];
52 lars 36 
			$sql_t="SELECT * FROM teams WHERE t_group=$g_id ORDER BY t_pos ASC";
13 lars 37 
			$res_t=$db->query($sql_t);
38 
			if (DB::isError($res_t))
39 
			{
40 
				$error="true";
41 
				$meld="Ein Fehler ist aufgetreten!";
42 
				$db_meld=$res_t->getUserInfo();
43 
				$smarty->assign("error", $error);
44 
				$smarty->assign("meld", $meld);
45 
				$smarty->assign("db_meld", $db_meld);
46 
				$smarty->display("meld.tpl");
47 
			}
48 
			else
49 
			{
52 lars 50 
				while($row_t=$res_t->fetchRow())
13 lars 51 
				{
52 
					$t_name=$row_t["t_name"];
53 
					$t_diff=$row_t["t_diff"];
54 
					$t_points=$row_t["t_points"];
14 lars 55 
					$t_goals=$row_t["t_goals"];
26 lars 56 
					$t_flag=$row_t["t_flag"];
54 lars 57 
					$t_aus=$row_t["t_aus"];
58 
					if ($t_aus!=-1)
59 
					{
60 
						$erg[$i]["pre"]="<strike>";
61 
						$erg[$i]["post"]="</strike>";
62 
						$sql_aus="SELECT * FROM types WHERE t_id=$t_aus";
63 
						$res_aus=$db->query($sql_aus);
64 
						$row_aus=$res_aus->fetchRow();
65 
						$t_aus_typ=$row_aus["t_name"];
66 
					}
67 
					else
68 
					{
69 
						$t_aus_typ="<strong>Noch dabei!</strong>";
70 
						$erg[$i]["pre"]="<strong>";
71 
						$erg[$i]["post"]="</strong>";
72 
					}
13 lars 73 
					$pos=(($i % 4)+1);
74 
					$erg[$i]["g_name"]=$g_name;
75 
					$erg[$i]["pos"]=$pos;
76 
					$erg[$i]["team"]=$t_name;
77 
					$erg[$i]["diff"]=$t_diff;
78 
					$erg[$i]["points"]=$t_points;
14 lars 79 
					$erg[$i]["tore"]=$t_goals;
26 lars 80 
					$erg[$i]["flag"]="images/flags/$t_flag";
54 lars 81 
					$erg[$i]["aus"]=$t_aus_typ;
13 lars 82 
					$i++;
83 
				}
51 lars 84 
				}
13 lars 85 
		}
86 
		$smarty->assign("erg", $erg);
87 
		$smarty->display("group.tpl");
88 
	}
89 
?>