(picture category = {$pic['category']}/ $pid)", __FILE__, __LINE__);
if (!isset($user_album_set[$aid])) cpg_die(ERROR, $lang_errors['perm_denied']."
(target album = $aid)", __FILE__, __LINE__);
}
$update = "aid = '".$aid."'";
if (is_movie($pic['filename'])) {
$update .= ", pwidth = ".$pwidth;
$update .= ", pheight = ".$pheight;
}
$update .= ", title = '".addslashes($title)."'";
$update .= ", caption = '".addslashes($caption)."'";
$update .= ", keywords = '".addslashes($keywords)."'";
$update .= ", user1 = '".addslashes($user1)."'";
$update .= ", user2 = '".addslashes($user2)."'";
$update .= ", user3 = '".addslashes($user3)."'";
$update .= ", user4 = '".addslashes($user4)."'";
if ($reset_vcount) $update .= ", hits = '0'";
if ($reset_votes) $update .= ", pic_rating = '0', votes = '0'";
if ($del_comments) {
$query = "DELETE FROM {$CONFIG['TABLE_COMMENTS']} WHERE pid='$pid'";
$result =db_query($query);
} else {
$query = "UPDATE {$CONFIG['TABLE_PICTURES']} SET $update WHERE pid='$pid' LIMIT 1";
$result = db_query($query);
}
}
function get_user_albums($user_id)
{
global $CONFIG, $USER_ALBUMS_ARRAY, $user_albums_list;
if (!isset($USER_ALBUMS_ARRAY[$user_id])) {
$user_albums = db_query("SELECT aid, title FROM {$CONFIG['TABLE_ALBUMS']} WHERE category='".(FIRST_USER_CAT + $user_id)."' ORDER BY title");
if (mysql_num_rows($user_albums)) {
$user_albums_list=db_fetch_rowset($user_albums);
} else {
$user_albums_list = array();
}
mysql_free_result($user_albums);
$USER_ALBUMS_ARRAY[$user_id] = $user_albums_list;
} else {
$user_albums_list = &$USER_ALBUMS_ARRAY[$user_id];
}
}
function form_alb_list_box()
{
global $CONFIG, $CURRENT_PIC;
global $user_albums_list, $public_albums_list, $lang_editpics_php;
$sel_album = $CURRENT_PIC['aid'];
echo <<
{$lang_editpics_php['album']}
|
|
EOT;
}
if (isset($HTTP_POST_VARS['submitDescription'])) process_post_data();
$result = db_query("SELECT * FROM {$CONFIG['TABLE_PICTURES']} WHERE pid = '$pid'");
$CURRENT_PIC = mysql_fetch_array($result);
mysql_free_result($result);
if (!(GALLERY_ADMIN_MODE || $CURRENT_PIC['owner_id'] == USER_ID)) cpg_die(ERROR, $lang_errors['access_denied'], __FILE__, __LINE__);
$thumb_url = get_pic_url($CURRENT_PIC, 'thumb');
$thumb_link = 'displayimage.php?pos='.(-$CURRENT_PIC['pid']);
$filename = htmlspecialchars($CURRENT_PIC['filename']);
$THUMB_ROWSPAN=5;
if ($CONFIG['user_field1_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field2_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field3_name'] != '') $THUMB_ROWSPAN++;
if ($CONFIG['user_field4_name'] != '') $THUMB_ROWSPAN++;
if (GALLERY_ADMIN_MODE) {
$public_albums = db_query("SELECT DISTINCT aid, title, IF(category = 0, CONCAT('> ', title), CONCAT(name,' < ',title)) AS cat_title FROM {$CONFIG['TABLE_ALBUMS']}, {$CONFIG['TABLE_CATEGORIES']} WHERE category < '" . FIRST_USER_CAT . "' AND (category = 0 OR category = cid) ORDER BY cat_title");
if (mysql_num_rows($public_albums)) {
$public_albums_list=db_fetch_rowset($public_albums);
} else {
$public_albums_list = array();
}
mysql_free_result($public_albums);
} else {
$public_albums_list = array();
}
get_user_albums($CURRENT_PIC['owner_id']);
echo <<
function textCounter(field, maxlimit) {
if (field.value.length > maxlimit) // if too long...trim it!
field.value = field.value.substring(0, maxlimit);
}
';
pagefooter();
ob_end_flush();
?>