Anonymous

<?php/* * Created on 20/11/2007 * * To change the template for this generated file go to * Window - Preferences - PHPeclipse - PHP - Code Templates */mysql_connect("localhost","root","diego");mysql_select_db("mdominio_v2");// mysql_functionsfunction mysql_menuList($id) {	$query = mysql_query("SELECT id,	id_cliente,	id_pai,	ordem,	sec_nome,	sec_url_nome,	sec_tipo	FROM usr__secoes_paginas	WHERE id_cliente = '" . $id . "'	ORDER BY ordem");		if (mysql_num_rows($query) > 0) {		return $query;	}	else {		return 0;	}}function mysql_countParents($id_cliente,$id_pai) {	$query = mysql_query("SELECT id FROM usr__secoes_paginas WHERE id_cliente = '" . $id_cliente . "' and id_pai = '" . $id_pai . "'");	return mysql_affected_rows();}function mysql_getFatherId($id_cliente,$id_menu) {	$query = mysql_query("SELECT	id_pai, sec_nome	FROM usr__secoes_paginas	WHERE id = '" . $id_menu . "' AND" . " id_cliente = '" . $id_cliente . "'");											if (mysql_num_rows($query) <= 0) {		return 0;	}	else { 			return mysql_result($query, 0);		}	 }// tree functionsfunction menuArray($query)    {	  while($row = mysql_fetch_array($query)) 	  {		  if (is_null($row['id_pai']) OR empty($row['id_pai']))		  {			$menu['root'][$row['id']] = $row['sec_nome'];		  } 		  else {		    $menu[$row['id_pai']][$row['id']] = $row['sec_nome'];		  }		}		return $menu;    }function show_tree($id_pai,$menu,$menu_clicked) {	print "<ul>\n";	foreach ($menu[$id_pai] as $id => $nome) {		if (isset($menu[$id])) {	      printf("<li>%s\n", $nome);	      $father_array = mysql_getFatherId(1,$id);	      if ($id_pai != $menu_clicked) { show_tree($id,$menu,$menu_clicked); }	   	} 	    else {	      printf("<li>%s\n", $nome);	    }	}	print "</li></ul>\n";}function tree($menu_clicked) {			$father_parents 	= mysql_countParents(1,$menu_clicked);	$father_id			= mysql_getFatherId(1,$menu_clicked);		if ($father_parents == 0) {		$menu_clicked = $father_id;		if (!is_null($father_id)) { $father_parents = 1; }	}		$menu = menuArray(mysql_menuList(1));	print "<ul id='browser' class='dir'>\n";		foreach ($menu['root'] as $id => $nome) {		printf("<li>%s(ROOT)</a>\n", $nome);				if (isset($menu[$id]) and $father_parents > 0) {			show_tree($id,$menu,$menu_clicked);		}		print "</li>\n";		}			print "</ul>";	echo "\n---------------\n";	print_r($menu);	}	echo "<pre>";tree(4);?>