EOT;
}
function form_moderator($text, $name)
{
global $CONFIG, $ALBUM_DATA, $lang_modifyalb_php, $LINEBREAK;
$options = array(
0 => $lang_modifyalb_php['admins_only'],
);
$result = cpg_db_query("SELECT group_id, group_name FROM {$CONFIG['TABLE_USERGROUPS']} WHERE group_id > 1");
while ($group = mysql_fetch_assoc($result)) {
$options[$group['group_id']] = sprintf($lang_modifyalb_php['group_only'], $group['group_name']);
}
mysql_free_result($result);
echo <<< EOT
$text
EOT;
}
function create_form(&$data)
{
foreach ($data as $element) {
if (is_array($element)) {
switch ($element[2]) {
case 0:
form_input($element[0], $element[1]);
break;
case 1:
form_yes_no($element[0], $element[1]);
break;
case 2:
form_category($element[0], $element[1]);
break;
case 3:
form_textarea($element[0], $element[1]);
break;
case 4:
form_alb_thumb($element[0], $element[1]);
break;
case 5:
form_visibility($element[0], $element[1]);
break;
case 6:
form_password($element[0], $element[1]);
break;
case 7:
form_password_hint($element[0], $element[1]);
break;
case 8:
form_moderator($element[0], $element[1]);
break;
case 9:
form_password_protect($element[0], $element[1]);
break;
default:
cpg_die(CRITICAL_ERROR, 'Invalid action for form creation', __FILE__, __LINE__);
}
} else {
form_label($element);
}
}
}
function alb_list_box()
{
global $CONFIG, $CLEAN, $cpg_udb, $CPG_PHP_SELF, $lang_modifyalb_php, $LINEBREAK;
$rowset = array();
if (GALLERY_ADMIN_MODE) {
$result = cpg_db_query("SELECT a.aid, a.title, c.name FROM {$CONFIG['TABLE_ALBUMS']} AS a INNER JOIN {$CONFIG['TABLE_CATEGORIES']} AS c ON a.category = c.cid WHERE a.category < '" . FIRST_USER_CAT . "'");
while ($row = mysql_fetch_assoc($result)) {
// Add to multi-dim array for later sorting
$rowset[] = array(
'cat' => $row['name'],
'aid' => $row['aid'],
'title' => $row['title'],
);
}
mysql_free_result($result);
//now we need to select the albums without a category
$result = cpg_db_query("SELECT aid, title FROM {$CONFIG['TABLE_ALBUMS']} WHERE category = 0");
while ($row = mysql_fetch_assoc($result)) {
// Add to multi-dim array for later sorting
$rowset[] = array(
'cat' => $lang_modifyalb_php['no_cat'],
'aid' => $row['aid'],
'title' => $row['title'],
);
}
mysql_free_result($result);
$sql = $cpg_udb->get_admin_album_list();
$result = cpg_db_query($sql);
while ($row = mysql_fetch_assoc($result)) {
// Add to multi-dim array for later sorting
$rowset[] = array(
'cat' => $lang_modifyalb_php['user_gal'],
'aid' => $row['aid'],
'title' => $row['title'],
);
}
mysql_free_result($result);
} else {
//Only list the albums owned by the user
//get albums in "my albums"
$result = cpg_db_query("SELECT aid, title FROM {$CONFIG['TABLE_ALBUMS']} WHERE category = ".(USER_ID + FIRST_USER_CAT)." AND owner = ".USER_ID);
while ($row = mysql_fetch_assoc($result)) {
// Add to multi-dim array for later sorting
$rowset[] = array(
'cat' => $lang_modifyalb_php['my_gal'],
'aid' => $row['aid'],
'title' => $row['title'],
);
}
mysql_free_result($result);
//get public albums
$result = cpg_db_query("SELECT a.aid, a.title, c.name FROM {$CONFIG['TABLE_ALBUMS']} AS a INNER JOIN {$CONFIG['TABLE_CATEGORIES']} AS c ON a.category = c.cid WHERE a.owner = ".USER_ID);
while ($row = mysql_fetch_assoc($result)) {
// Add to multi-dim array for later sorting
$rowset[] = array(
'cat' => $row['name'],
'aid' => $row['aid'],
'title' => $row['title'],
);
}
mysql_free_result($result);
//now we need to select the albums without a category
$result = cpg_db_query("SELECT aid, title FROM {$CONFIG['TABLE_ALBUMS']} WHERE category = 0 AND owner = ".USER_ID);
while ($row = mysql_fetch_assoc($result)) {
// Add to multi-dim array for later sorting
$rowset[] = array(
'cat' => $lang_modifyalb_php['no_cat'],
'aid' => $row['aid'],
'title' => $row['title'],
);
}
mysql_free_result($result);
}
// Sort by category and album title
$rowset = array_csort($rowset, 'cat', 'title');
if (count($rowset)) {
// Create the nicely sorted and formatted drop down list
$alb_cat = '';
$select = "' . $LINEBREAK;
return $select;
}
}
if (!$CLEAN['album']) {
if (GALLERY_ADMIN_MODE) {
$results = cpg_db_query("SELECT * FROM {$CONFIG['TABLE_ALBUMS']} WHERE 1 LIMIT 1");
} else {
$results = cpg_db_query("SELECT * FROM {$CONFIG['TABLE_ALBUMS']} WHERE category = " . (FIRST_USER_CAT + USER_ID) . " OR owner = '" . USER_ID . "' LIMIT 1");
}
if (mysql_num_rows($results) == 0) {
cpg_die(ERROR, $lang_modifyalb_php['err_no_alb_to_modify'], __FILE__, __LINE__);
}
$ALBUM_DATA = mysql_fetch_assoc($results);
$CLEAN['album'] = $ALBUM_DATA['aid'];
} else {
$results = cpg_db_query("SELECT * FROM {$CONFIG['TABLE_ALBUMS']} WHERE aid='{$CLEAN['album']}'");
if (!mysql_num_rows($results)) {
cpg_die(CRITICAL_ERROR, $lang_errors['non_exist_ap'], __FILE__, __LINE__);
}
$ALBUM_DATA = mysql_fetch_assoc($results);
}
$cat = $ALBUM_DATA['category'];
$actual_cat = $cat;
//////////// main code start ///////////////////
js_include('js/modifyalb.js');
set_js_var('reset_views_confirm', $lang_modifyalb_php['reset_views_confirm']);
set_js_var('cursor_stop', $icon_array['stop']);
pageheader(sprintf($lang_modifyalb_php['upd_alb_n'], $ALBUM_DATA['title']));
$album_lb = alb_list_box();
echo <<< EOT
';
if (GALLERY_ADMIN_MODE) {
// get the album stats
$result = cpg_db_query("SELECT SUM(hits) FROM {$CONFIG['TABLE_PICTURES']} WHERE aid='{$CLEAN['album']}'");
$nbEnr = mysql_fetch_array($result);
$hits = $nbEnr[0];
if (!$hits) {
$hits = 0;
}
mysql_free_result($result);
$result = cpg_db_query("SELECT SUM(votes) FROM {$CONFIG['TABLE_PICTURES']} WHERE aid='{$CLEAN['album']}' AND votes > 0");
$nbEnr = mysql_fetch_array($result);
$votes = $nbEnr[0];
if (!$votes) {
$votes = 0;
}
mysql_free_result($result);
$result = cpg_db_query("SELECT COUNT(*) FROM {$CONFIG['TABLE_PICTURES']} WHERE aid='{$CLEAN['album']}'");
$nbEnr = mysql_fetch_array($result);
$files = $nbEnr[0];
if (!$files) {
$files = 0;
}
mysql_free_result($result);
$result = cpg_db_query("SELECT COUNT(*) FROM {$CONFIG['TABLE_COMMENTS']} AS c INNER JOIN {$CONFIG['TABLE_PICTURES']} AS p ON p.pid = c.pid WHERE aid='{$CLEAN['album']}'");
$nbEnr = mysql_fetch_array($result);
$comments = $nbEnr[0];
if (!$comments) {
$comments = 0;
}
mysql_free_result($result);
echo <<< EOT
EOT;
}
pagefooter();
?>