Subversion-Projekte lars-tiefland.em_wm

Revision

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

Revision 44 Revision 52
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 
	if(User_login(true)->getAuth())
 4 
	$u=User_login(true);
- 
 
 5 
	if($u->getAuth())
5 
	{
 6 
	{
6 
		$smarty->assign("title", "Gruppentabelle berechnen");
 7 
		$smarty->assign("title", "Gruppentabelle berechnen");
7 
		$t_l=Team::listeTeam(0,0);
 8 
		$t_l=Team::listeTeam(0,0);
8 
		$i=0;
 9 
		$i=0;
9 
		while($row_t=$t_l->fetchRow(DB_FETCHMODE_ASSOC))
 10 
		while($row_t=$t_l->fetchRow())
10 
		{
 11 
		{
11 
			$diff=0;
 12 
			$diff=0;
12 
			$g1=0;
 13 
			$g1=0;
13 
			$g2=0;
 14 
			$g2=0;
14 
			$p1=0;
 15 
			$p1=0;
15 
			$t_id=$row_t["t_id"];
 16 
			$t_id=$row_t["t_id"];
16 
			$t=new Team($t_id);
 17 
			$t=new Team($t_id);
17 
			$today=mktime(date("H"),date("i"),date("s"),date("m"),date("d"),date("Y"));
 18 
			$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 
			$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 
			$res_g=$db->query($sql_g);
20 
			while($row_g=$res_g->fetchRow(DB_FETCHMODE_ASSOC))
 21 
			while($row_g=$res_g->fetchRow())
21 
			{
 22 
			{
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 
				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 
				{
 24 
				{
24 
						$p1+=3;
 25 
						$p1+=3;
25 
				}
 26 
				}
Zeile 42... Zeile 43...
42 
				else
 43 
				else
43 
				{
 44 
				{
44 
					$g2+=$row_g["g_g1"];
 45 
					$g2+=$row_g["g_g1"];
45 
					$g1+=$row_g["g_g2"];
 46 
					$g1+=$row_g["g_g2"];
46 
				}
 47 
				}
47 
				}
 48 
			}
48 
			$diff=$g1 - $g2;
 49 
			$diff=$g1 - $g2;
49 
			$erg[$i]["tore"]="$g1 : $g2";
 50 
			$erg[$i]["tore"]="$g1 : $g2";
50 
			$i++;
 51 
			$i++;
51 
			$sql_u="UPDATE teams SET t_diff=$diff, t_points=$p1, t_goals='$g1 : $g2' WHERE t_id=$t_id";
 52 
			$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 
			$res_u=$db->query($sql_u);
Zeile 61... Zeile 62...
61 
			{
 62 
			{
62 
				$meld="Gruppentabelle erfolgreich erstellt!";
 63 
				$meld="Gruppentabelle erfolgreich erstellt!";
63 
				$error=false;
 64 
				$error=false;
64 
			}
 65 
			}
65 
		}
 66 
		}
- 
 
 67 
		$g_l=Gruppe::listeGruppe(0,0);
- 
 
 68 
		while ($row=$g_l->fetchRow())
- 
 
 69 
		{
- 
 
 70 
			$t_pos=1;
- 
 
 71 
			$g_id=$row["g_id"];
- 
 
 72 
			$sql="SELECT * FROM teams WHERE t_group=$g_id ORDER BY t_points DESC, t_diff DESC";
- 
 
 73 
			$res=$db->query($sql);
- 
 
 74 
			while ($row_t=$res->fetchRow())
- 
 
 75 
			{
- 
 
 76 
				$t_id=$row_t["t_id"];
- 
 
 77 
				$t_aus=($t_pos > 2)?1:-1;
- 
 
 78 
				$sql_u="UPDATE teams SET t_pos=$t_pos, t_aus='$t_aus' WHERE t_id=$t_id";
- 
 
 79 
				$res_u=$db->query($sql_u);
- 
 
 80 
				if (true == DB::isError($res_u))
- 
 
 81 
				{
- 
 
 82 
					$error="true";
- 
 
 83 
					$meld="Ein Fehler ist aufgetreten!";
- 
 
 84 
					$db_meld=$res_u->getUserInfo();
- 
 
 85 
					break;
- 
 
 86 
				}
- 
 
 87 
				else
- 
 
 88 
				{
- 
 
 89 
					$meld="Gruppentabelle erfolgreich erstellt!";
- 
 
 90 
					$error=false;
- 
 
 91 
				}
- 
 
 92 
				$t_pos++;
- 
 
 93 
			}
- 
 
 94 
		}
66 
		$smarty->assign("error", $error);
 95 
		$smarty->assign("error", $error);
67 
		$smarty->assign("meld", $meld);
 96 
		$smarty->assign("meld", $meld);
68 
		$smarty->assign("db_meld", $db_meld);
 97 
		$smarty->assign("db_meld", $db_meld);
69 
		$smarty->display("meld.tpl");
 98 
		$smarty->display("meld.tpl");
70 
	}
 99 
	}