Subversion-Projekte lars-tiefland.em_wm

Revision

Revision 24 | Zur aktuellen Revision | Details | Letzte Änderung | Log anzeigen | RSS feed

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