Subversion-Projekte lars-tiefland.em_wm

Revision

Revision 114 | Revision 127 | Zur aktuellen Revision | Details | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
16 lars 1 
<?
114 lars 2 
    define( "IN_ADMIN", true );
3 
    require ( "include/common.php" );
4 
    $smarty->assign( "title", "Gruppentabelle berechnen" );
5 
    $a = User_login( true );
6 
    if ( $a->getAuth() )
7 
    {
8 
        if ( $u->u_type != 1 && $mode != "edit" )
9 
        {
10 
            $meld = "Ein Fehler ist aufgetreten!";
11 
            $db_meld =
12 
                "Nur Administratoren haben Zugriff auf diese Funktion!";
13 
            $smarty->assign( "meld", $meld );
14 
            $smarty->assign( "db_meld", $db_meld );
15 
            $smarty->assign( "error", true );
16 
            $smarty->display( "meld.tpl" );
17 
            exit;
18 
        }
19 
        $t_l = Team::listeTeam( 0, 0 );
123 lars 20 
        $today = mktime( date("H"), date("i"), date("s"), date("m"), date("d"), date("Y") );
114 lars 21 
        while ( $row_t = $t_l->fetchRow() )
22 
        {
23 
            $diff = 0;
24 
            $g1 = 0;
25 
            $g2 = 0;
26 
            $p1 = 0;
27 
            $t_id = $row_t["t_id"];
28 
            $sql_g = "SELECT * FROM games WHERE (g_m1=$t_id OR g_m2=$t_id) AND g_type=1 AND g_date<=$today";
29 
            $res_g = $db->query( $sql_g );
30 
            while ( $row_g = $res_g->fetchRow() )
31 
            {
32 
                if ( ($row_g["g_g1"] > $row_g["g_g2"] and $row_g["g_m1"] ==
33 
                    $t_id) or ($row_g["g_g2"] > $row_g["g_g1"] and $row_g["g_m2"] ==
34 
                    $t_id) )
35 
                {
36 
                    $p1 += 3;
37 
                }
38 
                else
39 
                {
40 
                    if ( $row_g["g_g1"] == $row_g["g_g2"] )
41 
                    {
42 
                        $p1 += 1;
43 
                    }
44 
                    else
45 
                    {
46 
                        $p1 += 0;
47 
                    }
48 
                }
49 
                if ( $row_g["g_m1"] == $t_id )
50 
                {
51 
                    $g1 += $row_g["g_g1"];
52 
                    $g2 += $row_g["g_g2"];
53 
                }
54 
                else
55 
                {
56 
                    $g2 += $row_g["g_g1"];
57 
                    $g1 += $row_g["g_g2"];
58 
                }
59 
            }
60 
            $diff = $g1 - $g2;
123 lars 61 
            $tore = "$g1 : $g2";
62 
            $sql_u = "UPDATE teams SET t_diff=$diff, t_points=$p1, t_goals='$tore' WHERE t_id=$t_id";
114 lars 63 
            $res_u = $db->query( $sql_u );
64 
            if ( true == DB::isError($res_u) )
65 
            {
66 
                $error = "true";
67 
                $meld = "Ein Fehler ist aufgetreten!";
68 
                $db_meld = $res_u->getUserInfo();
69 
                break;
70 
            }
71 
        }
72 
        $g_l = Gruppe::listeGruppe( 0, 0 );
73 
        while ( $row = $g_l->fetchRow() )
74 
        {
75 
            $t_pos = 1;
76 
            $g_id = $row["g_id"];
77 
            $sql = "SELECT * FROM teams WHERE t_group=$g_id ORDER BY t_points DESC, t_diff DESC";
78 
            $res = $db->query( $sql );
79 
            while ( $row_t = $res->fetchRow() )
80 
            {
81 
                $t_id = $row_t["t_id"];
82 
                $t_aus = ( $t_pos > 2 ) ? 1 : -1;
83 
                $sql_u = "UPDATE teams SET t_pos=$t_pos, t_aus='$t_aus' WHERE t_id=$t_id";
84 
                $res_u = $db->query( $sql_u );
85 
                if ( true == DB::isError($res_u) )
86 
                {
87 
                    $error = "true";
88 
                    $meld = "Ein Fehler ist aufgetreten!";
89 
                    $db_meld = $res_u->getUserInfo();
90 
                    break;
91 
                }
92 
                else
93 
                {
94 
                    $meld = "Gruppentabelle erfolgreich erstellt!";
95 
                    $logger->info( $meld );
96 
                    $error = false;
97 
                }
98 
                $t_pos++;
99 
            }
100 
        }
101 
        $smarty->assign( "error", $error );
102 
        $smarty->assign( "meld", $meld );
103 
        $smarty->assign( "db_meld", $db_meld );
123 lars 104 
	$smarty->clear_all_cache();
114 lars 105 
        $smarty->display( "meld.tpl" );
106 
    }
16 lars 107 
?>