Subversion-Projekte lars-tiefland.em_wm

<?
        require ("./include/common.php");
        $start = intval(isset($_POST["start"]) ? $_POST["start"] : 0);
        $smarty->caching = true;
        $smarty->cache_lifetime = 86400;
        define("CACHE_ID", $u_loc . "|" . $start);
        if (!$smarty->is_cached("group.tpl", CAHCE_ID))
        {
                $g_l = Gruppe::listeGruppe(0, 0);
                $sql_l = "SELECT max(g_date) datum FROM games WHERE g_type=1";
                $res_l = $db->query($sql_l);
                $row_l = $res_l->fetchRow();
                $date_l = $row_l["datum"] + 7200;
                if ($date_l > time())
                {
                        $h1 = $common["provisional"] . " ";
                        $act = $loc->formatDateTime(time());
                }
                else
                {
                        $h1 = $common["final"] . " ";
                        $act = $loc->formatDateTime($date_l);
                }
                $act .= " " . $common["o_clock"];
                $h1 .= $common["prel_table"];
                $title = "$h1 - " . $common["state"] . ": $act";
                $smarty->assign("title", $title);
                $smarty->assign("h1", $h1);
                if ($error)
                {
                        $smarty->assign("error", $error);
                        $smarty->assign("meld", $meld);
                        $smarty->assign("db_meld", $db_meld);
                        $smarty->display("meld.tpl");
                }
                else
                {
                        $i = 0;
                        while ($row_g = $g_l->fetchRow())
                        {
                                $g_id = $row_g["g_id"];
                                $g_name = $row_g["g_name"];
                                $sql_t = "SELECT * FROM teams WHERE t_group=$g_id ORDER BY t_pos ASC";
                                $res_t = $db->query($sql_t);
                                if (DB::isError($res_t))
                                {
                                        $error = "true";
                                        $meld = "Ein Fehler ist aufgetreten!";
                                        $db_meld = $res_t->getUserInfo();
                                        $smarty->assign("error", $error);
                                        $smarty->assign("meld", $meld);
                                        $smarty->assign("db_meld", $db_meld);
                                        $smarty->display("meld.tpl");
                                }
                                else
                                {
                                        while ($row_t = $res_t->fetchRow())
                                        {
                                                $t_name = $row_t["t_name"];
                                                $t_diff = $row_t["t_diff"];
                                                $t_points = $row_t["t_points"];
                                                $t_goals = $row_t["t_goals"];
                                                $t_flag = $row_t["t_flag"];
                                                $pos = (($i % 4) + 1);
                                                if ($pos == 1 || $pos == 2)
                                                {
                                                        $erg[$i]["style_b"] = "<b>";
                                                        $erg[$i]["style_e"] = "</b>";
                                                }
                                                else
                                                {
                                                        $erg[$i]["style_b"] = "";
                                                        $erg[$i]["style_e"] = "";
                                                }
                                                $erg[$i]["g_name"] = $g_name;
                                                $erg[$i]["pos"] = $pos;
                                                $erg[$i]["team"] = $t_name;
                                                $erg[$i]["diff"] = $t_diff;
                                                $erg[$i]["points"] = $t_points;
                                                $erg[$i]["tore"] = $t_goals;
                                                $erg[$i]["flag"] = "images/flags/$t_flag";
                                                $i++;
                                        }
                                }
                        }
                        $smarty->assign("erg", $erg);
                }
                $smarty->display("group.tpl", CACHE_ID);
        }
?>