Subversion-Projekte lars-tiefland.em_wm

Revision

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

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