function get_tree_subcat_data($parent, $dtree_parent = 0)
{
global $CONFIG, $HIDE_USER_CAT, $catStr, $dtree_counter, $LINEBREAK;
if ($CONFIG['categories_alpha_sort'] == 1) {
$cat_sort_order = 'name';
} else {
$cat_sort_order = 'pos';
}
$sql = "SELECT cid, name " . "FROM {$CONFIG['TABLE_CATEGORIES']} " . "WHERE parent = '{$parent}' " . "ORDER BY " . $cat_sort_order;
$result = cpg_db_query($sql);
if (($cat_count = mysql_num_rows($result)) > 0) {
$rowset = cpg_db_fetch_rowset($result);
$pos = 0;
$catStr .= '<ul>' . $LINEBREAK;
foreach ($rowset as $subcat) {
if ($subcat['cid'] == USER_GAL_CAT && $HIDE_USER_CAT == 1) {
} else {
$dtree_counter++;
// Category
$catStr .= '<li><a href="index.php?cat=' . $subcat['cid'] . '">' . $subcat['name'] . '</a>' . $LINEBREAK;
$dtree_temp = $dtree_counter;
get_tree_subcat_data($subcat['cid'], $dtree_temp);
get_tree_album_data($subcat['cid'], $dtree_temp);
$catStr .= '</li>' . $LINEBREAK;
}
}
$catStr .= '</ul>' . $LINEBREAK;
if ($parent == 0) {
get_tree_album_data($parent, 0);
}
}
}
function get_tree_subcat_data($parent, $dtree_parent = 0)
{
global $CONFIG, $HIDE_USER_CAT, $catStr, $dtree_counter;
if ($CONFIG['categories_alpha_sort'] == 1) {
$cat_sort_order = 'name';
} else {
$cat_sort_order = 'pos';
}
$sql = "SELECT cid, name " . "FROM {$CONFIG['TABLE_CATEGORIES']} " . "WHERE parent = '{$parent}' " . "ORDER BY " . $cat_sort_order;
$result = cpg_db_query($sql);
if (($cat_count = mysql_num_rows($result)) > 0) {
$rowset = cpg_db_fetch_rowset($result);
$pos = 0;
foreach ($rowset as $subcat) {
if ($subcat['cid'] == USER_GAL_CAT && $HIDE_USER_CAT == 1) {
} else {
$dtree_counter++;
$catStr .= "d.add(" . $dtree_counter . "," . $dtree_parent . ",'" . addslashes($subcat['name']) . "','index.php?cat=" . $subcat['cid'] . "','');\n";
$dtree_temp = $dtree_counter;
get_tree_subcat_data($subcat['cid'], $dtree_temp);
get_tree_album_data($subcat['cid'], $dtree_temp);
}
}
if ($parent == 0) {
get_tree_album_data($parent, 0);
}
}
}
