Subversion-Projekte lars-tiefland.em_wm

<?

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

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

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

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

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

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

	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(DB_FETCHMODE_ASSOC))

		{

			$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_points DESC, t_diff DESC";

			$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(DB_FETCHMODE_ASSOC))

				{

					$t_name=$row_t["t_name"];

					$t_diff=$row_t["t_diff"];

					$t_points=$row_t["t_points"];

					$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;

					$i++;

				}

	  		}

		}

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

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

	}

?>