Opret kampe - hjemme- og udebane.

Tabellen for kampe ser sådan ud:

game_id -> Indeholder kampens unikke ID
leag_id -> Indeholder ID for den liga kampen hører til
game_home -> Indeholder hjemmeholdets ID
game_away -> Indeholder udeholdets ID

Jeg fandt selv en løsning - Måske ikke den bedste, men det virker efter hensigten...

    open_db();

    $array = sql_request_and_response("SELECT * FROM team WHERE team_id = '$_REQUEST[tid]'");

    for($i = 0;$i < sizeof($array);$i++)
    {
        extract($array[$i]);

        $leag_id = $team_league;
    }

    $array = sql_request_and_response("SELECT * FROM league WHERE leag_id = '$leag_id'");

    for($i = 0;$i < sizeof($array);$i++)
    {
        extract($array[$i]);

        $leag_teams = $leag_teams;
    }

    if($leag_teams == 1)
    {
        $array = sql_request_and_response("SELECT * FROM game WHERE leag_id = '$leag_id'");

        for($i = 0;$i < sizeof($array);$i++)
        {
            extract($array[$i]);

            $home[] = $game_id;
        }

        shuffle($home);

        for($i = 0;$i < 4;$i++)
        {
            $no = $i + 1;

            sql_query("UPDATE game SET game_home = '$_REQUEST[tid]', game_away = '$no' WHERE game_id = '$home[$i]'");
        }

        $array = sql_request_and_response("SELECT * FROM game WHERE leag_id = '$leag_id' AND game_home <> '$_REQUEST[tid]'");

        for($i = 0;$i < sizeof($array);$i++)
        {
            extract($array[$i]);

            $away[] = $game_id;
        }

        shuffle($away);

        for($i = 0;$i < 4;$i++)
        {
            $no = $i + 1;

            sql_query("UPDATE game SET game_away = '$_REQUEST[tid]', game_home = '$no' WHERE game_id = '$away[$i]'");
        }
    }

    if($leag_teams == 2)
    {
        sql_query("UPDATE game SET game_home = '$_REQUEST[tid]' WHERE leag_id = '$leag_id' AND game_home = '1'");

        $array = sql_request_and_response("SELECT * FROM game WHERE leag_id = '$leag_id' AND game_home = ''");

        for($i = 0;$i < sizeof($array);$i++)
        {
            extract($array[$i]);

            $home[] = $game_id;
        }

        shuffle($home);

        for($i = 0;$i < 3;$i++)
        {
            $no = $i + 2;

            sql_query("UPDATE game SET game_home = '$_REQUEST[tid]', game_away = '$no' WHERE game_id = '$home[$i]'");
        }

        sql_query("UPDATE game SET game_away = '$_REQUEST[tid]' WHERE leag_id = '$leag_id' AND game_away = '1'");

        $array = sql_request_and_response("SELECT * FROM game WHERE leag_id = '$leag_id' AND game_away = ''");

        for($i = 0;$i < sizeof($array);$i++)
        {
            extract($array[$i]);

            $away[] = $game_id;
        }

        shuffle($away);

        for($i = 0;$i < 3;$i++)
        {
            $no = $i + 2;

            sql_query("UPDATE game SET game_away = '$_REQUEST[tid]', game_home = '$no' WHERE game_id = '$away[$i]'");
        }
    }

    if($leag_teams == 3)
    {
        sql_query("UPDATE game SET game_home = '$_REQUEST[tid]' WHERE leag_id = '$leag_id' AND game_home = '2'");

        $array = sql_request_and_response("SELECT * FROM game WHERE leag_id = '$leag_id' AND game_home = ''");

        for($i = 0;$i < sizeof($array);$i++)
        {
            extract($array[$i]);

            $home[] = $game_id;
        }

        shuffle($home);

        for($i = 0;$i < 2;$i++)
        {
            $no = $i + 3;

            sql_query("UPDATE game SET game_home = '$_REQUEST[tid]', game_away = '$no' WHERE game_id = '$home[$i]'");
        }

        sql_query("UPDATE game SET game_away = '$_REQUEST[tid]' WHERE leag_id = '$leag_id' AND game_away = '2'");

        $array = sql_request_and_response("SELECT * FROM game WHERE leag_id = '$leag_id' AND game_away = ''");

        for($i = 0;$i < sizeof($array);$i++)
        {
            extract($array[$i]);

            $away[] = $game_id;
        }

        shuffle($away);

        for($i = 0;$i < 2;$i++)
        {
            $no = $i + 3;

            sql_query("UPDATE game SET game_away = '$_REQUEST[tid]', game_home = '$no' WHERE game_id = '$away[$i]'");
        }
    }

    if($leag_teams == 4)
    {
        sql_query("UPDATE game SET game_home = '$_REQUEST[tid]' WHERE leag_id = '$leag_id' AND game_home = '3'");

        $array = sql_request_and_response("SELECT * FROM game WHERE leag_id = '$leag_id' AND game_home = ''");

        for($i = 0;$i < sizeof($array);$i++)
        {
            extract($array[$i]);

            $home[] = $game_id;
        }

        shuffle($home);

        for($i = 0;$i < 1;$i++)
        {
            $no = $i + 4;

            sql_query("UPDATE game SET game_home = '$_REQUEST[tid]', game_away = '$no' WHERE game_id = '$home[$i]'");
        }

        sql_query("UPDATE game SET game_away = '$_REQUEST[tid]' WHERE leag_id = '$leag_id' AND game_away = '3'");

        $array = sql_request_and_response("SELECT * FROM game WHERE leag_id = '$leag_id' AND game_away = ''");

        for($i = 0;$i < sizeof($array);$i++)
        {
            extract($array[$i]);

            $away[] = $game_id;
        }

        shuffle($away);

        for($i = 0;$i < 1;$i++)
        {
            $no = $i + 4;

            sql_query("UPDATE game SET game_away = '$_REQUEST[tid]', game_home = '$no' WHERE game_id = '$away[$i]'");
        }
    }

    if($leag_teams == 5)
    {
        sql_query("UPDATE game SET game_home = '$_REQUEST[tid]' WHERE leag_id = '$leag_id' AND game_home = '4'");

        sql_query("UPDATE game SET game_away = '$_REQUEST[tid]' WHERE leag_id = '$leag_id' AND game_away = '4'");
    }

    close_db();