Subversion-Projekte lars-tiefland.laravel_shop

    $rLaender = getRechnungsLaender();

    $laender = $rLaender;

    if ( $_SESSION["SHOP"]["BASKET"] )

    {

        foreach ( $_SESSION["SHOP"]["BASKET"] as $artikel )

        {

            if ( !$artikel["versandgruppen_id"] )

            {

                $artikel["versandgruppen_id"] = 1;

            }

            $vgruppen[] = $artikel["versandgruppen_id"];

        }

        $vgruppen = array_unique( $vgruppen );

        $sql = "SELECT

                        MAX(rang) AS rang

                    FROM

                        versandgruppen

                    WHERE

                        id IN(" . implode( ",", $vgruppen ) . ")

                ";

        $res = $GLOBALS["shopDB"]->query( $sql );

        $row = $res->fetch_assoc();

        $sql = "SELECT

                        id

                    FROM

                        versandgruppen

                    WHERE

                        rang=" . $row["rang"] . "

                ";

        $res = $GLOBALS["shopDB"]->query( $sql );

        $row = $res->fetch_assoc();

        $vgId = $row["id"];

    }

    if ( $vgId )

    {

        $sql = "SELECT DISTINCT

                        country_id

                    FROM

                        versand_to_land vl

                    JOIN

                        versand v

                    ON

                        v.versandgruppen_id=" . $vgId . "

                    AND

                        v.id=vl.versand_id

                ";

    }

    else

    {

        $sql = "SELECT DISTINCT

                        country_id

                    FROM

                        versand_to_land

                ";

    }

    $res = $GLOBALS["shopDB"]->query( $sql );

    while ( $row = $res->fetch_assoc() )

    {

        $sql = "SELECT

                        id,

                        `name-ger`

                    FROM

                        countries

                    WHERE

                        id=" . $row["country_id"] . "

                ";

        $resC = $GLOBALS["db_red"]->query( $sql );

        $rowC = $resC->fetch_assoc();

        $land_name = $rowC["name-ger"];

        if ( !in_array( $land_name, $forbiddenLands ) )

        {

            $vLaender[ $rowC["id"] ] = $land_name;

        }

    }

    foreach ( $rLaender as $landId => $landName )

    {

        if ( !in_array( $landName, $vLaender ) )

        {

            unset( $laender[ $landId ] );

        }

    }