Subversion-Projekte lars-tiefland.php_share

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
3 lars 1 
<?
2 
	// mediaran.de
3 
	function getVersandItems()
4 
	{
5 
		if ($_SESSION['SHOP']['Lieferadresse'] == "true")
6 
		{
7 
			$Land=$_SESSION['SHOP']['buy']['Persdata']['liefer_Land'];
8 
		}
9 
		else
10 
		{
11 
			$Land=$_SESSION['SHOP']['buy']['Persdata']['Land'];
12 
		}
13 
 
14 
		if (!$Land)
15 
		{
16 
			$_SESSION['SHOP']['buy']['Persdata']['Land']=1;
17 
			$Land=$_SESSION['SHOP']['buy']['Persdata']['Land'];
18 
		}
19 
 
20 
		$query="
21 
		SELECT
22 
			ID,
23 
			kurzbezeichnung as kurz,
24 
			langbezeichnung	as lang,
25 
			beschreibung as beschr,
26 
			preis1 as preis,
27 
			1 as Versand
28 
		FROM
29 
			artikel
30 
		WHERE
31 
			Father = -3
32 
		AND
33 
			Language = 'DE'
34 
		AND
35 
			Lieferstatus & ".$Land." = ".$Land."
36 
		AND
37 
			status = ".$_SESSION['INI']['shops_ID']."
38 
		AND
39 
			".getBasketGewicht()." between preis_neu1 and preis_neu2
40 
		AND
41 
			(
42 
				(".getBasketSumme(true)." between preis_neu3 and preis_neu4)
43 
				or
44 
				(preis_neu3 = preis_neu4)
45 
			)
46 
		order by Rang asc
47 
		";
48 
 
49 
		$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error().pre($query,true));
50 
		$buffer=array();
51 
		while($zeile=mysql_fetch_assoc($result))
52 
		{
53 
			$buffer[]=$zeile;
54 
		}
55 
		return $buffer;
56 
	}
57 
?>