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 functions
function 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 "\n";
foreach ($menu[$id_pai] as $id => $nome) {
if (isset($menu[$id])) {
printf("- %s\n", $nome);
$father_array = mysql_getFatherId(1,$id);
if ($id_pai != $menu_clicked) { show_tree($id,$menu,$menu_clicked); }
}
else {
printf("
- %s\n", $nome);
}
}
print "
\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 "\n";
foreach ($menu['root'] as $id => $nome) {
printf("- %s(ROOT)\n", $nome);
if (isset($menu[$id]) and $father_parents > 0) {
show_tree($id,$menu,$menu_clicked);
}
print "
\n";
}
print "
";
echo "\n---------------\n";
print_r($menu);
}
echo "";
tree(4);
?>