/**
* get_subcat_data()
*
* function get the list of all the subcategories for the given category
*/
function get_subcat_data($parent, $ident = '')
{
global $CONFIG, $catStr, $parentAlubm;
if ($parentAlubm != 1) {
$parentAlubm = 1;
if ($parent == 0) {
$catStr .= "\n{$ident}<cat>\n {$ident}<id>{$parent}</id>\n {$ident}<name>Parent</name>";
} else {
$sql = "SELECT cid, name, description " . "FROM {$CONFIG['TABLE_CATEGORIES']} " . "WHERE cid = '{$parent}' " . "ORDER BY pos";
$result = cpg_db_query($sql);
$row = cpg_db_fetch_row($result);
mysql_free_result($results);
$catStr .= "\n{$ident}<cat>\n {$ident}<id>{$row['cid']}</id>\n {$ident}<name>{$row['name']}</name>";
}
get_album_data($parent, " ");
}
if ($parent == 1) {
/**
* This is a user category and the categories inside this are not listed in categories table
* So, we need to loop in the users table and create category id's and get the albums in it
*/
if (USER_IS_ADMIN) {
//Get all user albums
$sql = "SELECT user_name, user_id FROM {$CONFIG['TABLE_USERS']}";
$result = cpg_db_query($sql);
if (($cat_count = mysql_num_rows($result)) > 0) {
$rowset = cpg_db_fetch_rowset($result);
foreach ($rowset as $cat) {
$catStr .= "\n {$ident}<cat>\n {$ident}<id>" . (FIRST_USER_CAT + $cat['user_id']) . "</id>\n {$ident}<name>{$cat['user_name']}</name>";
get_album_data(FIRST_USER_CAT + $cat['user_id'], $ident . " ");
$catStr .= "\n {$ident}</cat>";
}
}
} elseif (USER_ID) {
//Get only current users albums
$catStr .= "\n {$ident}<cat>\n {$ident}<id>" . (FIRST_USER_CAT + USER_ID) . "</id>\n {$ident}<name>" . USER_NAME . "</name>";
get_album_data(FIRST_USER_CAT + USER_ID, $ident . " ");
$catStr .= "\n {$ident}</cat>";
}
} else {
$sql = "SELECT cid, name, description " . "FROM {$CONFIG['TABLE_CATEGORIES']} " . "WHERE parent = '{$parent}' " . "ORDER BY pos";
$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) {
$catStr .= "\n {$ident}<cat>\n {$ident}<id>{$subcat['cid']}</id>\n {$ident}<name>{$subcat['name']}</name>";
get_album_data($subcat['cid'], $ident . " ");
get_subcat_data($subcat['cid'], $ident . " ");
$catStr .= "\n {$ident}</cat>";
}
}
}
}
?>
<form name="picture_menu" id="cpgform" method="post" action="delete.php?what=picmgr" onSubmit="return CheckPictureForm(this);">
<input type="hidden" name="delete_picture" value="" />
<input type="hidden" name="sort_order" value="<?php
echo $sort_order;
?>
" />
<td class="tableb" valign="top" align="center">
<br />
<table width="300" border="0" cellspacing="0" cellpadding="0">
<?php
//Joe Ernst - Added USER_ADMIN_MODE
if (GALLERY_ADMIN_MODE || USER_ADMIN_MODE) {
$ALBUM_LIST = array();
$ALBUM_LIST[] = array(0, $lang_picmgr_php['no_album']);
get_album_data(FIRST_USER_CAT + USER_ID, '');
echo <<<EOT
<tr>
<td>
<b>{$lang_picmgr_php['select_album']}</b>
EOT;
print albumselect('aid');
echo <<<EOT
</td>
</tr>
EOT;
}
?>
<tr>
<td>
