Subversion-Projekte lars-tiefland.em_wm

Revision

Revision 40 | Revision 52 | Zur aktuellen Revision | Details | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
16 lars 1 
<?
24 lars 2 
	define("IN_ADMIN",true);
16 lars 3 
	require("include/common.php");
44 lars 4 
	if(User_login(true)->getAuth())
16 lars 5 
	{
44 lars 6 
		$smarty->assign("title", "Gruppentabelle berechnen");
7 
		$t_l=Team::listeTeam(0,0);
8 
		$i=0;
9 
		while($row_t=$t_l->fetchRow(DB_FETCHMODE_ASSOC))
16 lars 10 
		{
44 lars 11 
			$diff=0;
12 
			$g1=0;
13 
			$g2=0;
14 
			$p1=0;
15 
			$t_id=$row_t["t_id"];
16 
			$t=new Team($t_id);
17 
			$today=mktime(date("H"),date("i"),date("s"),date("m"),date("d"),date("Y"));
18 
			$sql_g="SELECT * FROM games WHERE (g_m1=$t_id OR g_m2=$t_id) AND g_type=1 AND g_date<=$today";
19 
			$res_g=$db->query($sql_g);
20 
			while($row_g=$res_g->fetchRow(DB_FETCHMODE_ASSOC))
16 lars 21 
			{
44 lars 22 
				if (($row_g["g_g1"]>$row_g["g_g2"] AND $row_g["g_m1"]==$t_id) OR ($row_g["g_g2"]>$row_g["g_g1"] AND $row_g["g_m2"]==$t_id))
16 lars 23 
				{
44 lars 24 
						$p1+=3;
25 
				}
26 
				else
16 lars 27 
				{
44 lars 28 
					if ($row_g["g_g1"]==$row_g["g_g2"])
29 
					{
30 
						$p1+=1;
31 
					}
32 
					else
33 
					{
34 
						$p1+=0;
35 
					}
36 
				}
37 
				if ($row_g["g_m1"]==$t_id)
38 
				{
39 
					$g1+=$row_g["g_g1"];
40 
					$g2+=$row_g["g_g2"];
41 
				}
42 
				else
43 
				{
44 
					$g2+=$row_g["g_g1"];
45 
					$g1+=$row_g["g_g2"];
46 
				}
47 
				}
48 
			$diff=$g1 - $g2;
49 
			$erg[$i]["tore"]="$g1 : $g2";
50 
			$i++;
51 
			$sql_u="UPDATE teams SET t_diff=$diff, t_points=$p1, t_goals='$g1 : $g2' WHERE t_id=$t_id";
52 
			$res_u=$db->query($sql_u);
53 
			if (true == DB::isError($res_u))
54 
			{
55 
				$error="true";
56 
				$meld="Ein Fehler ist aufgetreten!";
57 
				$db_meld=$res_u->getUserInfo();
58 
				break;
16 lars 59 
			}
44 lars 60 
			else
16 lars 61 
			{
44 lars 62 
				$meld="Gruppentabelle erfolgreich erstellt!";
63 
				$error=false;
16 lars 64 
			}
65 
		}
44 lars 66 
		$smarty->assign("error", $error);
67 
		$smarty->assign("meld", $meld);
68 
		$smarty->assign("db_meld", $db_meld);
69 
		$smarty->display("meld.tpl");
16 lars 70 
	}
71 
?>