Subversion-Projekte lars-tiefland.content-management

<?
    function getVersandItems( $shopID, $Language, $Land )
    {
        $laender = array( "", "Deutschland", "Niederlande", "Österreich",
            "Belgien", "Luxemburg", "Dänemark", "Schweiz", "Frankreich",
            "Großbritannien", "Italien", "Spanien", "Portugal", "Schweden",
            "Finnland", "Norwegen", "Irland", "Griechenland", "Estland",
            "Lettland", "Malta", "Litauen", "Polen", "Slowenien",
            "Tschechien/Slowakei", "Türkei", "Ungarn", "Zypern" );

        if ( !is_numeric( $Land ) )
        {
            $Land = array_search( $Land, $laender );
        }

        $query = "
                SELECT
                        ID,
                        kurzbezeichnung as kurz,
                        langbezeichnung as lang,
                        beschreibung as beschr,
                        preis1 as preis,
                        1 as Versand,
                        short_line_1
                FROM
                        " . artikelDatabase( $shopID ) . "
                WHERE
                        Father = -3
                AND 
                        Language = '" . $Language . "'
                AND
                        Lieferstatus & '" . $Land . "' = '" . $Land . "'
                AND
                        status = '" . $shopID . "'
                ";

        $result = mysql_query_logged( $query . " order by Rang asc" ) or die( mysql_errno
            () . ": " . mysql_error() . pre( $query, true ) );
        $buffer = array();
        while ( $zeile = mysql_fetch_assoc( $result ) )
        {
            $buffer[] = $zeile;
        }
        return $buffer;
    }
?>