Subversion-Projekte lars-tiefland.em_wm

Revision

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

Revision 114 Revision 123
Zeile 15... Zeile 15...
15
            $smarty->assign( "error", true );
15
            $smarty->assign( "error", true );
16
            $smarty->display( "meld.tpl" );
16
            $smarty->display( "meld.tpl" );
17
            exit;
17
            exit;
18
        }
18
        }
19
        $t_l = Team::listeTeam( 0, 0 );
19
        $t_l = Team::listeTeam( 0, 0 );
20
        $i = 0;
20
        $today = mktime( date("H"), date("i"), date("s"), date("m"), date("d"), date("Y") );
21
        while ( $row_t = $t_l->fetchRow() )
21
        while ( $row_t = $t_l->fetchRow() )
22
        {
22
        {
23
            $diff = 0;
23
            $diff = 0;
24
            $g1 = 0;
24
            $g1 = 0;
25
            $g2 = 0;
25
            $g2 = 0;
26
            $p1 = 0;
26
            $p1 = 0;
27
            $t_id = $row_t["t_id"];
27
            $t_id = $row_t["t_id"];
28
            $t = new Team( $t_id );
-
 
29
            $today = mktime( date("H"), date("i"), date("s"), date("m"),
-
 
30
                date("d"), date("Y") );
-
 
31
            $sql_g = "SELECT * FROM games WHERE (g_m1=$t_id OR g_m2=$t_id) AND g_type=1 AND g_date<=$today";
28
            $sql_g = "SELECT * FROM games WHERE (g_m1=$t_id OR g_m2=$t_id) AND g_type=1 AND g_date<=$today";
32
            $res_g = $db->query( $sql_g );
29
            $res_g = $db->query( $sql_g );
33
            while ( $row_g = $res_g->fetchRow() )
30
            while ( $row_g = $res_g->fetchRow() )
34
            {
31
            {
35
                if ( ($row_g["g_g1"] > $row_g["g_g2"] and $row_g["g_m1"] ==
32
                if ( ($row_g["g_g1"] > $row_g["g_g2"] and $row_g["g_m1"] ==
Zeile 59... Zeile 56...
59
                    $g2 += $row_g["g_g1"];
56
                    $g2 += $row_g["g_g1"];
60
                    $g1 += $row_g["g_g2"];
57
                    $g1 += $row_g["g_g2"];
61
                }
58
                }
62
            }
59
            }
63
            $diff = $g1 - $g2;
60
            $diff = $g1 - $g2;
64
            $erg[$i]["tore"] = "$g1 : $g2";
61
            $tore = "$g1 : $g2";
65
            $i++;
-
 
66
            $sql_u = "UPDATE teams SET t_diff=$diff, t_points=$p1, t_goals='$g1 : $g2' WHERE t_id=$t_id";
62
            $sql_u = "UPDATE teams SET t_diff=$diff, t_points=$p1, t_goals='$tore' WHERE t_id=$t_id";
67
            $res_u = $db->query( $sql_u );
63
            $res_u = $db->query( $sql_u );
68
            if ( true == DB::isError($res_u) )
64
            if ( true == DB::isError($res_u) )
69
            {
65
            {
70
                $error = "true";
66
                $error = "true";
71
                $meld = "Ein Fehler ist aufgetreten!";
67
                $meld = "Ein Fehler ist aufgetreten!";
72
                $db_meld = $res_u->getUserInfo();
68
                $db_meld = $res_u->getUserInfo();
73
                break;
69
                break;
74
            }
70
            }
75
            else
-
 
76
            {
-
 
77
                $meld = "Gruppentabelle erfolgreich erstellt!";
-
 
78
                $error = false;
-
 
79
            }
-
 
80
        }
71
        }
81
        $g_l = Gruppe::listeGruppe( 0, 0 );
72
        $g_l = Gruppe::listeGruppe( 0, 0 );
82
        while ( $row = $g_l->fetchRow() )
73
        while ( $row = $g_l->fetchRow() )
83
        {
74
        {
84
            $t_pos = 1;
75
            $t_pos = 1;
Zeile 108... Zeile 99...
108
            }
99
            }
109
        }
100
        }
110
        $smarty->assign( "error", $error );
101
        $smarty->assign( "error", $error );
111
        $smarty->assign( "meld", $meld );
102
        $smarty->assign( "meld", $meld );
112
        $smarty->assign( "db_meld", $db_meld );
103
        $smarty->assign( "db_meld", $db_meld );
-
 
104
	$smarty->clear_all_cache();
113
        $smarty->display( "meld.tpl" );
105
        $smarty->display( "meld.tpl" );
114
    }
106
    }
115
?>
107
?>