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;

    }

?>