function get_tree_album_data($category, $dtree_parent)
{
global $catStr, $ALBUM_SET, $dtree_counter, $LINEBREAK;
global $CONFIG, $HIDE_USER_CAT, $FORBIDDEN_SET, $cpg_show_private_album;
$album_filter = '';
$pic_filter = '';
if (!empty($FORBIDDEN_SET) && !$cpg_show_private_album) {
$album_filter = ' ' . str_replace('p.', 'a.', $FORBIDDEN_SET);
$pic_filter = ' ' . str_replace('p.', $CONFIG['TABLE_PICTURES'] . '.', $FORBIDDEN_SET);
}
if ($category == USER_GAL_CAT) {
$sql = "SELECT DISTINCT user_id, user_name FROM {$CONFIG['TABLE_USERS']}, {$CONFIG['TABLE_ALBUMS']} WHERE 10000 + {$CONFIG['TABLE_USERS']}.user_id = {$CONFIG['TABLE_ALBUMS']}.category ORDER BY user_name ASC";
$result = cpg_db_query($sql);
if (($cat_count = mysql_num_rows($result)) > 0) {
$rowset = cpg_db_fetch_rowset($result);
$catStr .= '<ul>' . $LINEBREAK;
foreach ($rowset as $subcat) {
$dtree_counter++;
// User gallery
$catStr .= '<li><a href="index.php?cat=' . (FIRST_USER_CAT + (int) $subcat['user_id']) . '">' . $subcat['user_name'] . '</a>' . $LINEBREAK;
get_tree_album_data(FIRST_USER_CAT + (int) $subcat['user_id'], $dtree_counter);
$catStr .= '</li>' . $LINEBREAK;
}
$catStr .= '</ul>' . $LINEBREAK;
}
} else {
if ($category == USER_GAL_CAT) {
$sql = "SELECT aid,title FROM {$CONFIG['TABLE_ALBUMS']} WHERE category = {$category} " . $ALBUM_SET . $album_filter . " ORDER BY pos";
} else {
$unaliased_album_filter = str_replace('a.', '', $album_filter);
$sql = "SELECT aid,title FROM {$CONFIG['TABLE_ALBUMS']} WHERE category = {$category} " . $ALBUM_SET . $unaliased_album_filter . " ORDER BY pos";
}
$result = cpg_db_query($sql);
if (($cat_count = mysql_num_rows($result)) > 0) {
$rowset = cpg_db_fetch_rowset($result);
$catStr .= '<ul>' . $LINEBREAK;
foreach ($rowset as $subcat) {
$dtree_counter++;
// Album
$catStr .= '<li><a href="thumbnails.php?album=' . $subcat['aid'] . '">' . $subcat['title'] . '</a></li>' . $LINEBREAK;
}
$catStr .= '</ul>' . $LINEBREAK;
}
}
}
function get_tree_album_data($category, $dtree_parent)
{
global $catStr, $ALBUM_SET, $dtree_counter;
global $CONFIG, $HIDE_USER_CAT, $FORBIDDEN_SET, $cpg_show_private_album;
$album_filter = '';
$pic_filter = '';
if (!empty($FORBIDDEN_SET) && !$cpg_show_private_album) {
$album_filter = ' and ' . str_replace('p.', 'a.', $FORBIDDEN_SET);
$pic_filter = ' and ' . str_replace('p.', $CONFIG['TABLE_PICTURES'] . '.', $FORBIDDEN_SET);
}
if ($category == USER_GAL_CAT) {
$sql = "SELECT DISTINCT user_id, user_name FROM {$CONFIG['TABLE_USERS']}, {$CONFIG['TABLE_ALBUMS']} WHERE 10000 + {$CONFIG['TABLE_USERS']}.user_id = {$CONFIG['TABLE_ALBUMS']}.category ORDER BY user_name ASC";
$result = cpg_db_query($sql);
if (($cat_count = mysql_num_rows($result)) > 0) {
$rowset = cpg_db_fetch_rowset($result);
foreach ($rowset as $subcat) {
$dtree_counter++;
$catStr .= "d.add(" . $dtree_counter . "," . $dtree_parent . ",'" . addslashes($subcat['user_name']) . "','index.php?cat=" . (FIRST_USER_CAT + (int) $subcat['user_id']) . "');\n";
get_tree_album_data(FIRST_USER_CAT + (int) $subcat['user_id'], $dtree_counter);
}
}
} else {
if ($category == USER_GAL_CAT) {
$sql = "SELECT aid,title FROM {$CONFIG['TABLE_ALBUMS']} WHERE category = {$category} " . $ALBUM_SET . $album_filter . " ORDER BY pos";
} else {
$unaliased_album_filter = str_replace('a.', '', $album_filter);
$sql = "SELECT aid,title FROM {$CONFIG['TABLE_ALBUMS']} WHERE category = {$category} " . $ALBUM_SET . $unaliased_album_filter . " ORDER BY pos";
}
$result = cpg_db_query($sql);
if (($cat_count = mysql_num_rows($result)) > 0) {
$rowset = cpg_db_fetch_rowset($result);
foreach ($rowset as $subcat) {
$dtree_counter++;
$catStr .= "d.add(" . $dtree_counter . "," . $dtree_parent . ",'" . addslashes($subcat['title']) . "','thumbnails.php?album=" . $subcat['aid'] . "','');\n";
}
}
}
}
