Subversion-Projekte lars-tiefland.em_wm

Revision

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

Revision 51 Revision 52
Zeile 2... Zeile 2...
2 
	require("./include/common.php");
 2 
	require("./include/common.php");
3 
	$start=(isset($_POST["start"]))?$_POST["start"]:0;
 3 
	$start=(isset($_POST["start"]))?$_POST["start"]:0;
4 
	$g_l=Gruppe::listeGruppe(0,0);
 4 
	$g_l=Gruppe::listeGruppe(0,0);
5 
	$sql_l="SELECT max(g_date) datum FROM games WHERE g_type=1";
 5 
	$sql_l="SELECT max(g_date) datum FROM games WHERE g_type=1";
6 
	$res_l=$db->query($sql_l);
 6 
	$res_l=$db->query($sql_l);
7 
	$row_l=$res_l->fetchRow(DB_FETCHMODE_ASSOC);
 7 
	$row_l=$res_l->fetchRow();
8 
	$date_l=$row_l["datum"];
 8 
	$date_l=$row_l["datum"];
9 
	$act=date("d.m.Y",$date_l+86400);
 9 
	$act=date("d.m.Y H:i",$date_l+7200);
10 
	$act.=" 0:00:00 Uhr";
 10 
	$act.=" Uhr";
11 
	$smarty->assign("title", "Gruppentabelle - Stand $act");
 11 
	$title="Gruppentabelle - Stand $act";
- 
 
 12 
	if ($date_l > time())
- 
 
 13 
	{
- 
 
 14 
		$title="vorläufige $title";
- 
 
 15 
	}
- 
 
 16 
	else
- 
 
 17 
	{
- 
 
 18 
		$title="endgültige $title";
- 
 
 19 
	}
- 
 
 20 
	$smarty->assign("title", $title);
12 
	if ($error)
 21 
	if ($error)
13 
	{
 22 
	{
14 
		$smarty->assign("error", $error);
 23 
		$smarty->assign("error", $error);
15 
		$smarty->assign("meld", $meld);
 24 
		$smarty->assign("meld", $meld);
16 
		$smarty->assign("db_meld", $db_meld);
 25 
		$smarty->assign("db_meld", $db_meld);
17 
		$smarty->display("meld.tpl");
 26 
		$smarty->display("meld.tpl");
18 
	}
 27 
	}
19 
 		else
 28 
 		else
20 
 		{
 29 
 		{
21 
		$i=0;
 30 
		$i=0;
22 
		while($row_g=$g_l->fetchRow(DB_FETCHMODE_ASSOC))
 31 
		while($row_g=$g_l->fetchRow())
23 
		{
 32 
		{
24 
			$g_id=$row_g["g_id"];
 33 
			$g_id=$row_g["g_id"];
25 
			$g_name=$row_g["g_name"];
 34 
			$g_name=$row_g["g_name"];
26 
			$sql_t="SELECT * FROM teams WHERE t_group=$g_id ORDER BY t_points DESC, t_diff DESC";
 35 
			$sql_t="SELECT * FROM teams WHERE t_group=$g_id ORDER BY t_pos ASC";
27 
			$res_t=$db->query($sql_t);
 36 
			$res_t=$db->query($sql_t);
28 
			if (DB::isError($res_t))
 37 
			if (DB::isError($res_t))
29 
			{
 38 
			{
30 
				$error="true";
 39 
				$error="true";
31 
				$meld="Ein Fehler ist aufgetreten!";
 40 
				$meld="Ein Fehler ist aufgetreten!";
Zeile 35... Zeile 44...
35 
				$smarty->assign("db_meld", $db_meld);
 44 
				$smarty->assign("db_meld", $db_meld);
36 
				$smarty->display("meld.tpl");
 45 
				$smarty->display("meld.tpl");
37 
			}
 46 
			}
38 
			else
 47 
			else
39 
			{
 48 
			{
40 
				while($row_t=$res_t->fetchRow(DB_FETCHMODE_ASSOC))
 49 
				while($row_t=$res_t->fetchRow())
41 
				{
 50 
				{
42 
					$t_name=$row_t["t_name"];
 51 
					$t_name=$row_t["t_name"];
43 
					$t_diff=$row_t["t_diff"];
 52 
					$t_diff=$row_t["t_diff"];
44 
					$t_points=$row_t["t_points"];
 53 
					$t_points=$row_t["t_points"];
45 
					$t_goals=$row_t["t_goals"];
 54 
					$t_goals=$row_t["t_goals"];