Subversion-Projekte lars-tiefland.php_share

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
3 lars 1 
<?
2 
	function getItem($Id)
3 
	{
4 
		$buffer=false;
5 
		if (ereg("_", $Id )) {
6 
			$options = explode("_", $Id);
7 
			$query="
8 
				SELECT
9 
					*
10 
				FROM
11 
					artikel
12 
				WHERE
13 
					Language= '".$_SESSION['INI']['language']."'
14 
				AND
15 
					ID = ".$options[0]."
16 
				AND
17 
				(
18 
					(status = 0)
19 
					OR
20 
					(
21 
						Father = -3
22 
						AND
23 
						status = ".$_SESSION['INI']['shops_ID']."
24 
					)
25 
				)
26 
				";
27 
		} else {
28 
			$query="
29 
				SELECT
30 
					*
31 
				FROM
32 
					artikel
33 
				WHERE
34 
					Language= '".$_SESSION['INI']['language']."'
35 
				AND
36 
					ID = $Id
37 
				AND
38 
				(
39 
					(status = 0)
40 
					OR
41 
					(
42 
						Father = -3
43 
						AND
44 
						status = ".$_SESSION['INI']['shops_ID']."
45 
					)
46 
				)
47 
				";
48 
		}
49 
 
50 
		$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query);
51 
		if ($zeile=mysql_fetch_assoc($result))
52 
		{
53 
			$buffer=itemKorrektur($zeile);
54 
		}
55 
		return $buffer;
56 
	}
57 
?>