function build_child($oldID)
{
// Refer to the global array defined at the top of this script
global $exclude, $depth, $db, $tprefix, $editid, $tld;
$tempTree = '';
$child_sql = "SELECT * FROM `{$tprefix}" . "_category` WHERE parent_id=" . $oldID;
//echo $child_sql ;
$child_query = $db->query($child_sql);
while ($child = $child_query->fetch_array()) {
if ($child['cat_id'] != $child['parent_id']) {
for ($c = 0; $c < $depth; $c++) {
$tempTree .= " ";
}
$tempTree .= "- " . '<input type="checkbox" name="category[]" value="' . $child['cat_id'] . '" ' . check_category($editid, $child['cat_id']) . ' />' . $child['cat_label'] . '<a href="' . $tld . '/manage/settings/category-form.php?parent_id=' . $child['cat_id'] . '&parent_name=' . $child['cat_label'] . '">[+]</a><br>';
$depth++;
// Incriment depth b/c we're building this child's child tree (complicated yet???)
$tempTree .= build_child($child['cat_id']);
// Add to the temporary local tree
$depth--;
// Decrement depth b/c we're done building the child's child tree.
ARRAY_PUSH($exclude, $child['cat_id']);
// Add the item to the exclusion list
}
}
return $tempTree;
// Return the entire child tree
}
function build_child($oldID)
{
// Refer to the global array defined at the top of this script
global $exclude, $depth, $db, $tprefix, $editid;
$tempR = array();
$child_sql = "SELECT * FROM `mu" . "_category` WHERE parent_id=" . $oldID;
//echo $child_sql ;
$child_query = $db->query($child_sql);
$k = 0;
while ($child = $child_query->fetch_array()) {
if ($child['cat_id'] != $child['parent_id']) {
for ($c = 0; $c < $depth; $c++) {
}
$tempR[$k]['cat_id'] = $child['cat_id'];
$tempR[$k]['label'] = $child['cat_label'];
$depth++;
// Increment depth b/c we're building this child's child tree (complicated yet???)
if (build_child($child['cat_id']) != FALSE) {
$tempR[$k]['child'] = build_child($child['cat_id']);
}
$depth--;
// Decrement depth b/c we're done building the child's child tree.
ARRAY_PUSH($exclude, $child['cat_id']);
// Add the item to the exclusion list
$k++;
}
}
if (!empty($tempR)) {
return $tempR;
} else {
return FALSE;
}
// Return the entire child tree
}
function build_child($oldID)
{
$indent = "";
$tempTree = "";
global $exclude, $depth;
$child_query = mysql_query("SELECT * FROM category WHERE par_id=" . $oldID . " ORDER BY name");
while ($child = mysql_fetch_array($child_query)) {
if ($child['id'] != $child['par_id']) {
for ($c = 0; $c < $depth; $c++) {
$tempTree .= "";
$indent .= " ";
}
$tempTree .= "<tr><td> " . $indent . $child['name'] . "</td><td><a href='edit_category.php?cid=" . $child['id'] . "'>edit</a></td><td><a href='categories.php?cid=" . $child['id'] . "&act=del'>delete</a></td></tr>";
$indent = "";
$depth++;
$tempTree .= build_child($child['id']);
$depth--;
@array_push($exclude, $child['id']);
}
}
return $tempTree;
}
