Subversion-Projekte lars-tiefland.em_wm

Revision

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

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