Subversion-Projekte lars-tiefland.php_share

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
3 lars 1 
<?
2 
	function getNavTree($root = "root", $rootInfo = false)
3 
	{
4 
		static $getNavTreeBuffer = array();
5 
 
6 
		if ($getNavTreeBuffer != array())
7 
		{
8 
			$buffer = $getNavTreeBuffer;
9 
		}
10 
		else
11 
		{
12 
			$query="
13 
				select
14 
					directory.*,
15 
					if (directory.Father = -1, 'root', directory.Father) as Father,
16 
					Herstellerkatalog.Logo1 as Logo
17 
				from
18 
					directory
19 
				left join
20 
					Herstellerkatalog
21 
				on
22 
					Herstellerkatalog.Bezeichnung = directory.Name
23 
				where
24 
					directory.status=0
25 
				and
26 
					directory.Artikelstamm=0
27 
				and
28 
					directory.Language= '".$_SESSION['INI']['language']."'
29 
				order by
30 
					directory.Kennung
31 
			";
32 
 
33 
			$buffer=array();
34 
			$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>$query<hr>");
35 
			while($zeile=mysql_fetch_assoc($result))
36 
			{
37 
				$buffer[$zeile['ID']]=$zeile;
38 
			}
39 
 
40 
			foreach(array_keys($buffer) as $id)
41 
			{
42 
				if (!$buffer[$id]['childNodes']) { $buffer[$id]['childNodes'] = array(); }
43 
				$buffer[$buffer[$id]['Father']]['childNodes'][] = &$buffer[$id];
44 
			}
45 
		}
46 
		$getNavTreeBuffer = $buffer;
47 
		if ($rootInfo == true)
48 
		{
49 
			return $buffer[$root];
50 
		}
51 
		else
52 
		{
53 
			return $buffer[$root]['childNodes'];
54 
		}
55 
	}
56 
?>