Subversion-Projekte lars-tiefland.em_wm

Revision

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

Revision 108 Revision 114
Zeile 1... Zeile 1...
1
<?
1
<?
2
	require ("include/common.php");
2
    require ( "include/common.php" );
3
	$smarty->assign("title", $common["final_result"]);
3
    $smarty->assign( "title", $common["final_result"] );
4
	$smarty->caching = true;
4
    $smarty->caching = true;
5
	$smarty->cache_lifetime = 86400;
5
    $smarty->cache_lifetime = 86400;
6
	define("CACHE_ID", $u_loc . "|0");
6
    define( "CACHE_ID", $u_loc . "|0" );
7
	if (!$smarty->is_cached("result.tpl", CAHCE_ID))
7
    if ( !$smarty->is_cached("result.tpl", CAHCE_ID) )
8
	{
8
    {
9
		if ($config->type == "WC")
9
        if ( $config->type == "WC" )
10
		{
10
        {
11
			$sql = "SELECT * FROM games WHERE g_type IN (5,6)";
11
            $sql = "SELECT * FROM games WHERE g_type IN (5,6)";
12
		}
12
        }
13
		else
13
        else
14
		{
14
        {
15
			$sql = "SELECT * FROM games WHERE g_type IN (4)";
15
            $sql = "SELECT * FROM games WHERE g_type IN (4)";
16
		}
16
        }
17
		$res = $db->query($sql);
17
        $res = $db->query( $sql );
18
		if (DB::isError($res))
18
        if ( DB::isError($res) )
19
		{
19
        {
20
			$smarty->assign("meld", $common["an_error_occured"]);
20
            $smarty->assign( "meld", $common["an_error_occured"] );
21
			$smarty->assign("db_meld", $res->getUserInfo());
21
            $smarty->assign( "db_meld", $res->getUserInfo() );
22
			$smarty->assign("error", true);
22
            $smarty->assign( "error", true );
23
			$smarty->display("meld.tpl");
23
            $smarty->display( "meld.tpl" );
24
		}
24
        }
25
		else
25
        else
26
		{
26
        {
27
			if ($config->type == "WC")
27
            if ( $config->type == "WC" )
28
			{
28
            {
29
				while ($row = $res->fetchRow())
29
                while ( $row = $res->fetchRow() )
30
				{
30
                {
31
					$g_id = $row["g_id"];
31
                    $g_id = $row["g_id"];
32
					$g_type = $row["g_type"];
32
                    $g_type = $row["g_type"];
33
					$t_id1 = $row["g_m1"];
33
                    $t_id1 = $row["g_m1"];
34
					$t_id2 = $row["g_m2"];
34
                    $t_id2 = $row["g_m2"];
35
					$g_g1 = $row["g_g1"];
35
                    $g_g1 = $row["g_g1"];
36
					$g_g2 = $row["g_g2"];
36
                    $g_g2 = $row["g_g2"];
37
					$t1 = new Team($t_id1);
37
                    $t1 = new Team( $t_id1 );
38
					$t2 = new Team($t_id2);
38
                    $t2 = new Team( $t_id2 );
39
					$t_name1 = $t1->t_name;
39
                    $t_name1 = $t1->t_name;
40
					$t_name2 = $t2->t_name;
40
                    $t_name2 = $t2->t_name;
41
					if ($g_type == 5)
41
                    if ( $g_type == 5 )
42
					{
42
                    {
43
						$champion3 = ($g_g1 > $g_g2) ? $t_name1 : $t_name2;
43
                        $champion3 = ( $g_g1 > $g_g2 ) ? $t_name1 : $t_name2;
44
						$champion4 = ($g_g1 < $g_g2) ? $t_name1 : $t_name2;
44
                        $champion4 = ( $g_g1 < $g_g2 ) ? $t_name1 : $t_name2;
45
					}
45
                    }
46
					else
46
                    else
47
					{
47
                    {
48
						$champion1 = ($g_g1 > $g_g2) ? $t_name1 : $t_name2;
48
                        $champion1 = ( $g_g1 > $g_g2 ) ? $t_name1 : $t_name2;
49
						$champion2 = ($g_g1 < $g_g2) ? $t_name1 : $t_name2;
49
                        $champion2 = ( $g_g1 < $g_g2 ) ? $t_name1 : $t_name2;
50
					}
50
                    }
51
				}
51
                }
52
			}
52
            }
53
			else
53
            else
54
			{
54
            {
55
				$row = $res->fetchRow();
55
                $row = $res->fetchRow();
56
				$g_id = $row["g_id"];
56
                $g_id = $row["g_id"];
57
				$g_type = $row["g_type"];
57
                $g_type = $row["g_type"];
58
				$t_id1 = $row["g_m1"];
58
                $t_id1 = $row["g_m1"];
59
				$t_id2 = $row["g_m2"];
59
                $t_id2 = $row["g_m2"];
60
				$g_g1 = $row["g_g1"];
60
                $g_g1 = $row["g_g1"];
61
				$g_g2 = $row["g_g2"];
61
                $g_g2 = $row["g_g2"];
62
				$t1 = new Team($t_id1);
62
                $t1 = new Team( $t_id1 );
63
				$t2 = new Team($t_id2);
63
                $t2 = new Team( $t_id2 );
64
				$t_name1 = $t1->t_name;
64
                $t_name1 = $t1->t_name;
65
				$t_name2 = $t2->t_name;
65
                $t_name2 = $t2->t_name;
66
				$champion1 = ($g_g1 > $g_g2) ? $t_name1 : $t_name2;
66
                $champion1 = ( $g_g1 > $g_g2 ) ? $t_name1 : $t_name2;
67
				$champion2 = ($g_g1 < $g_g2) ? $t_name1 : $t_name2;
67
                $champion2 = ( $g_g1 < $g_g2 ) ? $t_name1 : $t_name2;
68
				$champion3 = $champion4 = "Gibt es bei einer EM NICHT!";
68
                $champion3 = $champion4 = "Gibt es bei einer EM NICHT!";
69
			}
69
            }
70
			$smarty->assign("champion1", $champion1);
70
            $smarty->assign( "champion1", $champion1 );
71
			$smarty->assign("champion2", $champion2);
71
            $smarty->assign( "champion2", $champion2 );
72
			$smarty->assign("champion3", $champion3);
72
            $smarty->assign( "champion3", $champion3 );
73
			$smarty->assign("champion4", $champion4);
73
            $smarty->assign( "champion4", $champion4 );
74
		}
74
        }
75
	}
75
    }
76
	$smarty->display("result.tpl", CACHE_ID);
76
    $smarty->display( "result.tpl", CACHE_ID );
77
?>
77
?>