Subversion-Projekte lars-tiefland.em_wm

<?

	require("./include/common.php");

	$start=intval(($_POST["start"])?$_POST["start"]:0);

	$g_l=Gruppe::listeGruppe(0,0);

	$sql_l="SELECT max(g_date) datum FROM games WHERE g_type=1";

	$res_l=$db->query($sql_l);

	$row_l=$res_l->fetchRow();

	$date_l=$row_l["datum"]+7200;

	if ($date_l > time())

	{

		$title="vorläufige ";

		$act=date("d.m.Y H:i",time());

	}

	else

	{

		$title="endgültige ";

		$act=date("d.m.Y H:i",$date_l);

	}

	$act.=" Uhr";

	$title.="Gruppentabelle - Stand $act";

	$smarty->assign("title", $title);

	if ($error)

	{

		$smarty->assign("error", $error);

		$smarty->assign("meld", $meld);

		$smarty->assign("db_meld", $db_meld);

		$smarty->display("meld.tpl");

	}

	else

 	{

		$i=0;

		while($row_g=$g_l->fetchRow())

		{

			$g_id=$row_g["g_id"];

			$g_name=$row_g["g_name"];

			$sql_t="SELECT * FROM teams WHERE t_group=$g_id ORDER BY t_pos ASC";

			$res_t=$db->query($sql_t);

			if (DB::isError($res_t))

			{

				$error="true";

				$meld="Ein Fehler ist aufgetreten!";

				$db_meld=$res_t->getUserInfo();

				$smarty->assign("error", $error);

				$smarty->assign("meld", $meld);

				$smarty->assign("db_meld", $db_meld);

				$smarty->display("meld.tpl");

			}

			else

			{

				while($row_t=$res_t->fetchRow())

				{

					$t_name=$row_t["t_name"];

					$t_diff=$row_t["t_diff"];

					$t_points=$row_t["t_points"];

					$t_goals=$row_t["t_goals"];

					$t_flag=$row_t["t_flag"];

					$pos=(($i % 4)+1);

					$erg[$i]["g_name"]=$g_name;

					$erg[$i]["pos"]=$pos;

					$erg[$i]["team"]=$t_name;

					$erg[$i]["diff"]=$t_diff;

					$erg[$i]["points"]=$t_points;

					$erg[$i]["tore"]=$t_goals;

					$erg[$i]["flag"]="images/flags/$t_flag";

					$i++;

				}

				}

		}

		$smarty->assign("erg", $erg);

		$smarty->display("group.tpl");

	}

?>