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"; } } } }