Subversion-Projekte lars-tiefland.php_share

<?
        // mediaran.de
        function getVersandItems()
        {
                if ($_SESSION['SHOP']['Lieferadresse'] == "true")
                {
                        $Land=$_SESSION['SHOP']['buy']['Persdata']['liefer_Land'];
                }
                else
                {
                        $Land=$_SESSION['SHOP']['buy']['Persdata']['Land'];
                }
                
                if (!$Land)
                {
                        $_SESSION['SHOP']['buy']['Persdata']['Land']=1;
                        $Land=$_SESSION['SHOP']['buy']['Persdata']['Land'];
                }

                $query="
                SELECT
                        ID,
                        kurzbezeichnung as kurz,
                        langbezeichnung as lang,
                        beschreibung as beschr,
                        preis1 as preis,
                        1 as Versand
                FROM
                        artikel
                WHERE
                        Father = -3
                AND 
                        Language = 'DE'
                AND
                        Lieferstatus & ".$Land." = ".$Land."
                AND
                        status = ".$_SESSION['INI']['shops_ID']."
                AND
                        ".getBasketGewicht()." between preis_neu1 and preis_neu2
                AND
                        (
                                (".getBasketSumme(true)." between preis_neu3 and preis_neu4)
                                or
                                (preis_neu3 = preis_neu4)
                        ) 
                order by Rang asc
                ";
                
                $result = mysql_query ($query) or die (mysql_errno().": ".mysql_error().pre($query,true));
                $buffer=array();
                while($zeile=mysql_fetch_assoc($result))
                {
                        $buffer[]=$zeile;
                }
                return $buffer;
        }
?>