function wppa_insert_photo($file = '', $alb = '', $name = '', $desc = '', $porder = '0', $id = '0', $linkurl = '', $linktitle = '')
{
global $wpdb;
global $warning_given_small;
$album = wppa_cache_album($alb);
if (!wppa_allow_uploads($alb)) {
if (is_admin() && !wppa('ajax')) {
wppa_error_message(sprintf(__('Album %s is full', 'wp-photo-album-plus'), wppa_get_album_name($alb)));
} else {
wppa_alert(sprintf(__('Album %s is full', 'wp-photo-album-plus'), wppa_get_album_name($alb)));
}
return false;
}
if ($file != '' && $alb != '') {
// Get the name if not given
if ($name == '') {
$name = basename($file);
}
// Sanitize name
$filename = wppa_sanitize_file_name($name);
$name = wppa_sanitize_photo_name($name);
// If not dups allowed and its already here, quit
if (isset($_POST['wppa-nodups']) || wppa_switch('void_dups')) {
$exists = wppa_file_is_in_album($filename, $alb);
if ($exists) {
if (isset($_POST['del-after-p'])) {
unlink($file);
$msg = __('Photo %s already exists in album number %s. Removed from depot.', 'wp-photo-album-plus');
} else {
$msg = __('Photo %s already exists in album number %s.', 'wp-photo-album-plus');
}
wppa_warning_message(sprintf($msg, $name, $alb));
return false;
}
}
// Verify file exists
if (!wppa('is_remote') && !file_exists($file)) {
if (!is_dir(dirname($file))) {
wppa_error_message('Error: Directory ' . dirname($file) . ' does not exist.');
return false;
}
if (!is_writable(dirname($file))) {
wppa_error_message('Error: Directory ' . dirname($file) . ' is not writable.');
return false;
}
wppa_error_message('Error: File ' . $file . ' does not exist.');
return false;
}
// else {
// wppa_ok_message( 'Good: File '.$file.' exists.' );
// }
// Get and verify the size
$img_size = getimagesize($file);
if ($img_size) {
if (wppa_check_memory_limit('', $img_size['0'], $img_size['1']) === false) {
wppa_error_message(sprintf(__('ERROR: Attempt to upload a photo that is too large to process (%s).', 'wp-photo-album-plus'), $name) . wppa_check_memory_limit());
wppa('ajax_import_files_error', __('Too big', 'wp-photo-album-plus'));
return false;
}
if (!$warning_given_small && ($img_size['0'] < wppa_get_minisize() && $img_size['1'] < wppa_get_minisize())) {
wppa_warning_message(__('WARNING: You are uploading photos that are too small. Photos must be larger than the thumbnail size and larger than the coverphotosize.', 'wp-photo-album-plus'));
wppa('ajax_import_files_error', __('Too small', 'wp-photo-album-plus'));
$warning_given_small = true;
}
} else {
wppa_error_message(__('ERROR: Unable to retrieve image size of', 'wp-photo-album-plus') . ' ' . $name . ' ' . __('Are you sure it is a photo?', 'wp-photo-album-plus'));
wppa('ajax_import_files_error', __('No imagesize', 'wp-photo-album-plus'));
return false;
}
// Get ext based on mimetype, regardless of ext
switch ($img_size[2]) {
// mime type
case 1:
$ext = 'gif';
break;
case 2:
$ext = 'jpg';
break;
case 3:
$ext = 'png';
break;
default:
wppa_error_message(__('Unsupported mime type encountered:', 'wp-photo-album-plus') . ' ' . $img_size[2] . '.');
return false;
}
// Get an id if not yet there
if ($id == '0') {
$id = wppa_nextkey(WPPA_PHOTOS);
}
// Get opt deflt desc if empty
if ($desc == '' && wppa_switch('apply_newphoto_desc')) {
$desc = stripslashes(wppa_opt('newphoto_description'));
}
// Reset rating
$mrat = '0';
// Find ( new ) owner
$owner = wppa_get_user();
// Validate album
if (!is_numeric($alb) || $alb < '1') {
wppa_error_message(__('Album not known while trying to add a photo', 'wp-photo-album-plus'));
return false;
}
if (!wppa_have_access($alb)) {
wppa_error_message(sprintf(__('Album %s does not exist or is not accessable while trying to add a photo', 'wp-photo-album-plus'), $alb));
return false;
}
$status = wppa_switch('upload_moderate') && !current_user_can('wppa_admin') ? 'pending' : 'publish';
// Add photo to db
$id = wppa_create_photo_entry(array('id' => $id, 'album' => $alb, 'ext' => $ext, 'name' => $name, 'p_order' => $porder, 'description' => $desc, 'linkurl' => $linkurl, 'linktitle' => $linktitle, 'owner' => $owner, 'status' => $status, 'filename' => $filename));
if (!$id) {
wppa_error_message(__('Could not insert photo.', 'wp-photo-album-plus'));
} else {
// Save the source
wppa_save_source($file, $filename, $alb);
wppa_flush_treecounts($alb);
wppa_update_album(array('id' => $alb, 'modified' => time()));
wppa_flush_upldr_cache('photoid', $id);
}
// Make the photo files
if (wppa_make_the_photo_files($file, $id, $ext)) {
// Repair photoname if not supplied and not standard
wppa_set_default_name($id, $name);
// Tags
wppa_set_default_tags($id);
// Index
wppa_index_add('photo', $id);
// and add watermark ( optionally ) to fullsize image only
wppa_add_watermark($id);
// also to thumbnail?
if (wppa_switch('watermark_thumbs')) {
wppa_create_thumbnail($id);
}
// Is it a default coverimage?
wppa_check_coverimage($id);
return $id;
}
} else {
wppa_error_message(__('ERROR: Unknown file or album.', 'wp-photo-album-plus'));
return false;
}
}
function wppa_setup($force = false)
{
global $silent;
global $wpdb;
global $wppa_revno;
global $current_user;
global $wppa_error;
$old_rev = get_option('wppa_revision', '100');
if ($old_rev == $wppa_revno && !$force) {
return;
}
// Nothing to do here
wppa_clear_cache(true);
// Clear cache
$wppa_error = false;
// Init no error
$create_albums = "CREATE TABLE " . WPPA_ALBUMS . " (\r\n\t\t\t\t\tid bigint(20) NOT NULL,\r\n\t\t\t\t\tname text NOT NULL,\r\n\t\t\t\t\tdescription text NOT NULL,\r\n\t\t\t\t\ta_order smallint(5) NOT NULL,\r\n\t\t\t\t\tmain_photo bigint(20) NOT NULL,\r\n\t\t\t\t\ta_parent bigint(20) NOT NULL,\r\n\t\t\t\t\tp_order_by smallint(5) NOT NULL,\r\n\t\t\t\t\tcover_linktype tinytext NOT NULL,\r\n\t\t\t\t\tcover_linkpage bigint(20) NOT NULL,\r\n\t\t\t\t\towner text NOT NULL,\r\n\t\t\t\t\ttimestamp tinytext NOT NULL,\r\n\t\t\t\t\tmodified tinytext NOT NULL,\r\n\t\t\t\t\tupload_limit tinytext NOT NULL,\r\n\t\t\t\t\talt_thumbsize tinytext NOT NULL,\r\n\t\t\t\t\tdefault_tags tinytext NOT NULL,\r\n\t\t\t\t\tcover_type tinytext NOT NULL,\r\n\t\t\t\t\tsuba_order_by tinytext NOT NULL,\r\n\t\t\t\t\tviews bigint(20) NOT NULL default '0',\r\n\t\t\t\t\tcats tinytext NOT NULL,\r\n\t\t\t\t\tscheduledtm tinytext NOT NULL,\r\n\t\t\t\t\tPRIMARY KEY (id)\r\n\t\t\t\t\t) DEFAULT CHARACTER SET utf8;";
$create_photos = "CREATE TABLE " . WPPA_PHOTOS . " (\r\n\t\t\t\t\tid bigint(20) NOT NULL,\r\n\t\t\t\t\talbum bigint(20) NOT NULL,\r\n\t\t\t\t\text tinytext NOT NULL,\r\n\t\t\t\t\tname text NOT NULL,\r\n\t\t\t\t\tdescription longtext NOT NULL,\r\n\t\t\t\t\tp_order smallint(5) NOT NULL,\r\n\t\t\t\t\tmean_rating tinytext NOT NULL,\r\n\t\t\t\t\tlinkurl text NOT NULL,\r\n\t\t\t\t\tlinktitle text NOT NULL,\r\n\t\t\t\t\tlinktarget tinytext NOT NULL,\r\n\t\t\t\t\towner text NOT NULL,\r\n\t\t\t\t\ttimestamp tinytext NOT NULL,\r\n\t\t\t\t\tstatus tinytext NOT NULL,\r\n\t\t\t\t\trating_count bigint(20) NOT NULL default '0',\r\n\t\t\t\t\ttags tinytext NOT NULL,\r\n\t\t\t\t\talt tinytext NOT NULL,\r\n\t\t\t\t\tfilename tinytext NOT NULL,\r\n\t\t\t\t\tmodified tinytext NOT NULL,\r\n\t\t\t\t\tlocation tinytext NOT NULL,\r\n\t\t\t\t\tviews bigint(20) NOT NULL default '0',\r\n\t\t\t\t\tpage_id bigint(20) NOT NULL default '0',\r\n\t\t\t\t\texifdtm tinytext NOT NULL,\r\n\t\t\t\t\tvideox smallint(5) NOT NULL default '0',\r\n\t\t\t\t\tvideoy smallint(5) NOT NULL default '0',\r\n\t\t\t\t\tthumbx smallint(5) NOT NULL default '0',\r\n\t\t\t\t\tthumby smallint(5) NOT NULL default '0',\r\n\t\t\t\t\tphotox smallint(5) NOT NULL default '0',\r\n\t\t\t\t\tphotoy smallint(5) NOT NULL default '0',\r\n\t\t\t\t\tscheduledtm tinytext NOT NULL,\r\n\t\t\t\t\tcustom longtext NOT NULL,\r\n\t\t\t\t\tstereo smallint NOT NULL default '0',\r\n\t\t\t\t\tPRIMARY KEY (id),\r\n\t\t\t\t\tKEY albumkey (album)\r\n\t\t\t\t\t) DEFAULT CHARACTER SET utf8;";
$create_rating = "CREATE TABLE " . WPPA_RATING . " (\r\n\t\t\t\t\tid bigint(20) NOT NULL,\r\n\t\t\t\t\ttimestamp tinytext NOT NULL,\r\n\t\t\t\t\tphoto bigint(20) NOT NULL,\r\n\t\t\t\t\tvalue smallint(5) NOT NULL,\r\n\t\t\t\t\tuser text NOT NULL,\r\n\t\t\t\t\tstatus tinytext NOT NULL,\r\n\t\t\t\t\tPRIMARY KEY (id),\r\n\t\t\t\t\tKEY photokey (photo)\r\n\t\t\t\t\t) DEFAULT CHARACTER SET utf8;";
$create_comments = "CREATE TABLE " . WPPA_COMMENTS . " (\r\n\t\t\t\t\tid bigint(20) NOT NULL,\r\n\t\t\t\t\ttimestamp tinytext NOT NULL,\r\n\t\t\t\t\tphoto bigint(20) NOT NULL,\r\n\t\t\t\t\tuser text NOT NULL,\r\n\t\t\t\t\tip tinytext NOT NULL,\r\n\t\t\t\t\temail text NOT NULL,\r\n\t\t\t\t\tcomment text NOT NULL,\r\n\t\t\t\t\tstatus tinytext NOT NULL,\r\n\t\t\t\t\tPRIMARY KEY (id),\r\n\t\t\t\t\tKEY photokey (photo)\r\n\t\t\t\t\t) DEFAULT CHARACTER SET utf8;";
$create_iptc = "CREATE TABLE " . WPPA_IPTC . " (\r\n\t\t\t\t\tid bigint(20) NOT NULL,\r\n\t\t\t\t\tphoto bigint(20) NOT NULL,\r\n\t\t\t\t\ttag tinytext NOT NULL,\r\n\t\t\t\t\tdescription text NOT NULL,\r\n\t\t\t\t\tstatus tinytext NOT NULL,\r\n\t\t\t\t\tPRIMARY KEY (id),\r\n\t\t\t\t\tKEY photokey (photo)\r\n\t\t\t\t\t) DEFAULT CHARACTER SET utf8;";
$create_exif = "CREATE TABLE " . WPPA_EXIF . " (\r\n\t\t\t\t\tid bigint(20) NOT NULL,\r\n\t\t\t\t\tphoto bigint(20) NOT NULL,\r\n\t\t\t\t\ttag tinytext NOT NULL,\r\n\t\t\t\t\tdescription text NOT NULL,\r\n\t\t\t\t\tstatus tinytext NOT NULL,\r\n\t\t\t\t\tPRIMARY KEY (id),\r\n\t\t\t\t\tKEY photokey (photo)\r\n\t\t\t\t\t) DEFAULT CHARACTER SET utf8;";
$create_index = "CREATE TABLE " . WPPA_INDEX . " (\r\n\t\t\t\t\tid bigint(20) NOT NULL,\r\n\t\t\t\t\tslug tinytext NOT NULL,\r\n\t\t\t\t\talbums text NOT NULL,\r\n\t\t\t\t\tphotos text NOT NULL,\r\n\t\t\t\t\tPRIMARY KEY (id),\r\n\t\t\t\t\tKEY slugkey (slug(20))\r\n\t\t\t\t\t) DEFAULT CHARACTER SET utf8;";
$create_session = "CREATE TABLE " . WPPA_SESSION . " (\r\n\t\t\t\t\tid bigint(20) NOT NULL,\r\n\t\t\t\t\tsession tinytext NOT NULL,\r\n\t\t\t\t\ttimestamp tinytext NOT NULL,\r\n\t\t\t\t\tuser tinytext NOT NULL,\r\n\t\t\t\t\tip tinytext NOT NULL,\r\n\t\t\t\t\tstatus tinytext NOT NULL,\r\n\t\t\t\t\tdata text NOT NULL,\r\n\t\t\t\t\tcount bigint(20) NOT NULL default '0',\r\n\t\t\t\t\tPRIMARY KEY (id),\r\n\t\t\t\t\tKEY sessionkey (session(20))\r\n\t\t\t\t\t) DEFAULT CHARACTER SET utf8;";
require_once WPPA_ABSPATH . 'wp-admin/includes/upgrade.php';
// Create or update db tables
$tn = array(WPPA_ALBUMS, WPPA_PHOTOS, WPPA_RATING, WPPA_COMMENTS, WPPA_IPTC, WPPA_EXIF, WPPA_INDEX, WPPA_SESSION);
$tc = array($create_albums, $create_photos, $create_rating, $create_comments, $create_iptc, $create_exif, $create_index, $create_session);
$idx = 0;
while ($idx < 8) {
$a0 = wppa_table_exists($tn[$idx]);
dbDelta($tc[$idx]);
$a1 = wppa_table_exists($tn[$idx]);
if (WPPA_DEBUG) {
if (!$a0) {
if ($a1) {
wppa_ok_message('Database table ' . $tn[$idx] . ' created.');
} else {
wppa_error_message('Could not create database table ' . $tn[$idx]);
}
} else {
wppa_ok_message('Database table ' . $tn[$idx] . ' updated.');
}
}
$idx++;
}
// Although we do not rely om auto increment, it may help avoiding concurrency conflicts
$wpdb->query("ALTER TABLE `" . WPPA_SESSION . "` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT");
// Clear Session
$wpdb->query("TRUNCATE TABLE `" . WPPA_SESSION . "`");
wppa_session_start();
// Convert any changed and remove obsolete setting options
if ($old_rev > '100') {
// On update only
if ($old_rev <= '402') {
wppa_convert_setting('wppa_coverphoto_left', 'no', 'wppa_coverphoto_pos', 'right');
wppa_convert_setting('wppa_coverphoto_left', 'yes', 'wppa_coverphoto_pos', 'left');
}
if ($old_rev <= '440') {
wppa_convert_setting('wppa_fadein_after_fadeout', 'yes', 'wppa_animation_type', 'fadeafter');
wppa_convert_setting('wppa_fadein_after_fadeout', 'no', 'wppa_animation_type', 'fadeover');
}
if ($old_rev <= '450') {
wppa_remove_setting('wppa_fadein_after_fadeout');
wppa_copy_setting('wppa_show_bbb', 'wppa_show_bbb_widget');
wppa_convert_setting('wppa_comment_use_gravatar', 'yes', 'wppa_comment_gravatar', 'mm');
wppa_convert_setting('wppa_comment_use_gravatar', 'no', 'wppa_comment_gravatar', 'none');
wppa_remove_setting('wppa_comment_use_gravatar');
wppa_revalue_setting('wppa_start_slide', 'yes', 'run');
wppa_revalue_setting('wppa_start_slide', 'no', 'still');
wppa_rename_setting('wppa_accesslevel', 'wppa_accesslevel_admin');
wppa_remove_setting('wppa_charset');
wppa_remove_setting('wppa_chmod');
wppa_remove_setting('wppa_coverphoto_left');
wppa_remove_setting('wppa_2col_treshold');
wppa_remove_setting('wppa_album_admin_autosave');
wppa_remove_setting('wppa_doublethevotes');
wppa_remove_setting('wppa_halvethevotes');
wppa_remove_setting('wppa_lightbox_overlaycolor');
wppa_remove_setting('wppa_lightbox_overlayopacity');
wppa_remove_setting('wppa_multisite');
wppa_remove_setting('wppa_set_access_by');
wppa_remove_setting('wppa_accesslevel_admin');
wppa_remove_setting('wppa_accesslevel_upload');
wppa_remove_setting('wppa_accesslevel_sidebar');
}
if ($old_rev <= '452') {
wppa_copy_setting('wppa_fontfamily_numbar', 'wppa_fontfamily_numbar_active');
wppa_copy_setting('wppa_fontsize_numbar', 'wppa_fontsize_numbar_active');
wppa_copy_setting('wppa_fontcolor_numbar', 'wppa_fontcolor_numbar_active');
wppa_copy_setting('wppa_fontweight_numbar', 'wppa_fontweight_numbar_active');
}
if ($old_rev <= '455') {
// rating_count added to WPPA_PHOTOS
$phs = $wpdb->get_results('SELECT `id` FROM `' . WPPA_PHOTOS . '`', ARRAY_A);
if ($phs) {
foreach ($phs as $ph) {
$cnt = $wpdb->get_var($wpdb->prepare('SELECT COUNT(*) FROM `' . WPPA_RATING . '` WHERE `photo` = %s', $ph['id']));
$wpdb->query($wpdb->prepare('UPDATE `' . WPPA_PHOTOS . '` SET `rating_count` = %s WHERE `id` = %s', $cnt, $ph['id']));
}
}
}
if ($old_rev < '470') {
// single photo re-impl. has its own links, clone from slideshow
wppa_copy_setting('wppa_slideshow_linktype', 'wppa_sphoto_linktype');
wppa_copy_setting('wppa_slideshow_blank', 'wppa_sphoto_blank');
wppa_copy_setting('wppa_slideshow_overrule', 'wppa_sphoto_overrule');
}
if ($old_rev <= '474') {
// Convert album and photo descriptions to contain html in stead of htmlspecialchars. Allowing html is assumed, if not permitted, wppa_html will convert to specialcars.
// html
$at = 0;
$ah = 0;
$pt = 0;
$ph = 0;
$albs = $wpdb->get_results('SELECT `id`, `description` FROM ' . WPPA_ALBUMS, ARRAY_A);
if ($albs) {
foreach ($albs as $alb) {
$at++;
if (html_entity_decode($alb['description']) != $alb['description']) {
$wpdb->query($wpdb->prepare('UPDATE `' . WPPA_ALBUMS . '` SET `description` = %s WHERE `id` = %s', html_entity_decode($alb['description']), $alb['id']));
$ah++;
}
}
}
$phots = $wpdb->get_results('SELECT `id`, `description` FROM ' . WPPA_PHOTOS, ARRAY_A);
if ($phots) {
foreach ($phots as $phot) {
$pt++;
if (html_entity_decode($phot['description']) != $phot['description']) {
$wpdb->query($wpdb->prepare('UPDATE `' . WPPA_PHOTOS . '` SET `description` = %s WHERE `id` = %s', html_entity_decode($phot['description']), $phot['id']));
$ph++;
}
}
}
if (WPPA_DEBUG) {
if ($ah || $ph) {
wppa_ok_message($ah . ' out of ' . $at . ' albums and ' . $ph . ' out of ' . $pt . ' photos html converted');
}
}
}
if ($old_rev <= '482') {
// Share box added
$so = get_option('wppa_slide_order', '0,1,2,3,4,5,6,7,8,9');
if (strlen($so) == '19') {
wppa_update_option('wppa_slide_order', $so . ',10');
}
$so = get_option('wppa_slide_order_split', '0,1,2,3,4,5,6,7,8,9,10');
if (strlen($so) == '22') {
wppa_update_option('wppa_slide_order_split', $so . ',11');
}
wppa_remove_setting('wppa_sharetype');
wppa_copy_setting('wppa_bgcolor_namedesc', 'wppa_bgcolor_share');
wppa_copy_setting('wppa_bcolor_namedesc', 'wppa_bcolor_share');
}
if ($old_rev <= '4811') {
wppa_rename_setting('wppa_comment_count', 'wppa_comten_count');
wppa_rename_setting('wppa_comment_size', 'wppa_comten_size');
}
if ($old_rev <= '4910') {
wppa_copy_setting('wppa_show_bread', 'wppa_show_bread_posts');
wppa_copy_setting('wppa_show_bread', 'wppa_show_bread_pages');
wppa_remove_setting('wppa_show_bread');
}
if ($old_rev <= '5000') {
wppa_remove_setting('wppa_autoclean');
}
if ($old_rev <= '5010') {
wppa_copy_setting('wppa_apply_newphoto_desc', 'wppa_apply_newphoto_desc_user');
}
if ($old_rev <= '5107') {
delete_option('wppa_taglist');
// Forces recreation
}
if ($old_rev <= '5205') {
if (get_option('wppa_list_albums_desc', 'nil') == 'yes') {
$value = get_option('wppa_list_albums_by', '0') * '-1';
wppa_update_option('wppa_list_albums_by', $value);
wppa_remove_setting('wppa_list_albums_desc');
}
if (get_option('wppa_list_photos_desc', 'nil') == 'yes') {
$value = get_option('wppa_list_photos_by', '0') * '-1';
wppa_update_option('wppa_list_photos_by', $value);
wppa_remove_setting('wppa_list_photos_desc');
}
}
if ($old_rev <= '5207') {
if (get_option('wppa_strip_file_ext', 'nil') == 'yes') {
wppa_update_option('wppa_newphoto_name_method', 'noext');
delete_option('wppa_strip_file_ext');
}
}
if ($old_rev <= '5307') {
$wpdb->query("TRUNCATE TABLE `" . WPPA_SESSION . "`");
}
if ($old_rev <= '5308') {
wppa_flush_treecounts();
}
if ($old_rev <= '5410') {
wppa_copy_setting('wppa_widget_width', 'wppa_potd_widget_width');
wppa_flush_upldr_cache('all');
// New format
}
if ($old_rev == '5421' || $old_rev == '5420.99') {
// The rev where the bug was
if ($wppa_revno >= '5422') {
// The rev where we fix it
if (get_option('wppa_rating_on', 'no') == 'yes') {
// Only if rating used
if (get_option('wppa_ajax_non_admin', 'yes') == 'no') {
// Only if backend ajax
update_option('wppa_rerate_status', __('Required', 'wp-photo-album-plus'));
// Make sure they see the message
}
}
}
}
if ($old_rev <= '5500') {
wppa_create_pl_htaccess(get_option('wppa_pl_dirname', 'wppa-pl'));
// Remake due to fix in wppa_sanitize_file_name()
}
if ($old_rev <= '6103') {
wppa_copy_setting('wppa_owner_only', 'wppa_upload_owner_only');
}
if ($old_rev <= '6305') {
if (get_option('wppa_comment_captcha') == 'no') {
update_option('wppa_comment_captcha', 'none');
}
if (get_option('wppa_comment_captcha') == 'yes') {
update_option('wppa_comment_captcha', 'all');
}
}
if ($old_rev <= '6310') {
$wpdb->query("UPDATE `" . WPPA_PHOTOS . "` SET `timestamp` = '0' WHERE `timestamp` = ''");
$wpdb->query("UPDATE `" . WPPA_PHOTOS . "` SET `modified` = `timestamp` WHERE `modified` = '' OR `modified` = '0'");
}
if ($old_rev <= '6312') {
$wpdb->query("UPDATE `" . WPPA_ALBUMS . "` SET `timestamp` = '0' WHERE `timestamp` = ''");
$wpdb->query("UPDATE `" . WPPA_ALBUMS . "` SET `modified` = `timestamp` WHERE `modified` = '' OR `modified` = '0'");
wppa_copy_setting('wppa_wppa_set_shortcodes', 'wppa_set_shortcodes');
wppa_remove_setting('wppa_wppa_set_shortcodes');
wppa_copy_setting('wppa_max_album_newtime', 'wppa_max_album_modtime');
wppa_copy_setting('wppa_max_photo_newtime', 'wppa_max_photo_modtime');
}
if ($old_rev <= '6316') {
wppa_remove_setting('wppa_start_symbol_url');
wppa_remove_setting('wppa_pause_symbol_url');
wppa_remove_setting('wppa_stop_symbol_url');
}
}
// Set Defaults
wppa_set_defaults();
// Check required directories
if (!wppa_check_dirs()) {
$wppa_error = true;
}
// Create .htaccess file in .../wp-content/uploads/wppa
wppa_create_wppa_htaccess();
// Copy factory supplied watermarks
$frompath = WPPA_PATH . '/watermarks';
$watermarks = glob($frompath . '/*.png');
if (is_array($watermarks)) {
foreach ($watermarks as $fromfile) {
$tofile = WPPA_UPLOAD_PATH . '/watermarks/' . basename($fromfile);
@copy($fromfile, $tofile);
}
}
// Copy factory supplied watermark fonts
$frompath = WPPA_PATH . '/fonts';
$fonts = glob($frompath . '/*');
if (is_array($fonts)) {
foreach ($fonts as $fromfile) {
if (is_file($fromfile)) {
$tofile = WPPA_UPLOAD_PATH . '/fonts/' . basename($fromfile);
@copy($fromfile, $tofile);
}
}
}
// Copy audiostub.jpg, the default audiostub
$fromfile = WPPA_PATH . '/images/audiostub.jpg';
$tofile = WPPA_UPLOAD_PATH . '/audiostub';
if (!is_file($tofile . '.jpg') && !is_file($tofile . '.gif') && !is_file($tofile . '.png')) {
@copy($fromfile, $tofile . '.jpg');
wppa_update_option('wppa_audiostub', 'audiostub.jpg');
}
// Check if this update comes with a new wppa-theme.php and/or a new wppa-style.css
// If so, produce message
$key = '0';
if ($old_rev < '5400') {
// theme changed since...
$usertheme = get_theme_root() . '/' . get_option('template') . '/wppa-theme.php';
if (is_file($usertheme)) {
$key += '2';
}
}
if ($old_rev < '5211') {
// css changed since...
$userstyle = get_theme_root() . '/' . get_option('stylesheet') . '/wppa-style.css';
if (is_file($userstyle)) {
$key += '1';
} else {
$userstyle = get_theme_root() . '/' . get_option('template') . '/wppa-style.css';
if (is_file($userstyle)) {
$key += '1';
}
}
}
if ($key) {
$msg = '<center>' . __('IMPORTANT UPGRADE NOTICE', 'wp-photo-album-plus') . '</center><br/>';
if ($key == '1' || $key == '3') {
$msg .= '<br/>' . __('Please CHECK your customized WPPA-STYLE.CSS file against the newly supplied one. You may wish to add or modify some attributes. Be aware of the fact that most settings can now be set in the admin settings page.', 'wp-photo-album-plus');
}
if ($key == '2' || $key == '3') {
$msg .= '<br/>' . __('Please REPLACE your customized WPPA-THEME.PHP file by the newly supplied one, or just remove it from your theme directory. You may modify it later if you wish. Your current customized version is NOT compatible with this version of the plugin software.', 'wp-photo-album-plus');
}
wppa_ok_message($msg);
}
// Check if db is ok
if (!wppa_check_database()) {
$wppa_error = true;
}
// Remove dynamic files
$files = glob(WPPA_PATH . '/wppa-init.*.js');
if ($files) {
foreach ($files as $file) {
@unlink($file);
// Will be auto re-created
}
}
@unlink(WPPA_PATH . '/wppa-dynamic.css');
// Will be auto re-created
// Done!
if (!$wppa_error) {
$old_rev = round($old_rev);
// might be 0.01 off
if ($old_rev < $wppa_revno) {
// was a real upgrade,
wppa_update_option('wppa_prevrev', $old_rev);
// Remember prev rev. For support purposes. They say they stay up to rev, but they come from stoneage...
}
wppa_update_option('wppa_revision', $wppa_revno);
if (WPPA_DEBUG) {
if (is_multisite()) {
wppa_ok_message(sprintf(__('WPPA+ successfully updated in multi site mode to db version %s.', 'wp-photo-album-plus'), $wppa_revno));
} else {
wppa_ok_message(sprintf(__('WPPA+ successfully updated in single site mode to db version %s.', 'wp-photo-album-plus'), $wppa_revno));
}
}
} else {
if (WPPA_DEBUG) {
wppa_error_message(__('An error occurred during update', 'wp-photo-album-plus'));
}
}
}
function wppa_delete_photo($photo)
{
global $wppa_supported_audio_extensions;
global $wppa_supported_video_extensions;
global $wpdb;
$photoinfo = $wpdb->get_row($wpdb->prepare('SELECT * FROM `' . WPPA_PHOTOS . '` WHERE `id` = %s', $photo), ARRAY_A);
// Get album
$album = $photoinfo['album'];
// Get filename
$filename = $photoinfo['filename'];
// Delete multimedia files
if (wppa_is_multi($photo)) {
$mmfile = wppa_strip_ext(wppa_get_photo_path($photo));
$allsup = array_merge($wppa_supported_audio_extensions, $wppa_supported_video_extensions);
foreach ($allsup as $mmext) {
if (is_file($mmfile . '.' . $mmext)) {
@unlink($mmfile . '.' . $mmext);
}
}
}
// Delete fullsize image
$file = wppa_get_photo_path($photo);
$file = wppa_fix_poster_ext($file, $photo);
if (is_file($file)) {
unlink($file);
}
// Delete thumbnail image
$file = wppa_get_thumb_path($photo);
$file = wppa_fix_poster_ext($file, $photo);
if (is_file($file)) {
unlink($file);
}
// Delete sourcefile
wppa_delete_source($filename, $album);
// Delete index
wppa_index_remove('photo', $photo);
// Delete db entries
$wpdb->query($wpdb->prepare('DELETE FROM `' . WPPA_PHOTOS . '` WHERE `id` = %s LIMIT 1', $photo));
$wpdb->query($wpdb->prepare('DELETE FROM `' . WPPA_RATING . '` WHERE `photo` = %s', $photo));
$wpdb->query($wpdb->prepare('DELETE FROM `' . WPPA_COMMENTS . '` WHERE `photo` = %s', $photo));
$wpdb->query($wpdb->prepare('DELETE FROM `' . WPPA_IPTC . '` WHERE `photo` = %s', $photo));
$wpdb->query($wpdb->prepare('DELETE FROM `' . WPPA_EXIF . '` WHERE `photo` = %s', $photo));
wppa_flush_treecounts($album);
wppa_flush_upldr_cache('photoid', $photo);
// Delete from cloud
if (wppa_cdn('admin') == 'cloudinary') {
wppa_delete_from_cloudinary($photo);
}
}
function wppa_publish_scheduled()
{
global $wpdb;
$last_check = get_option('wppa_last_schedule_check', '0');
if ($last_check < time() - 300) {
// Longer than 5 mins ago
$to_publish = $wpdb->get_results($wpdb->prepare("SELECT * FROM`" . WPPA_PHOTOS . "` WHERE `status` = 'scheduled' AND `scheduledtm` < %s", wppa_get_default_scheduledtm()), ARRAY_A);
if ($to_publish) {
foreach ($to_publish as $photo) {
wppa_update_photo(array('id' => $photo['id'], 'scheduledtm' => '', 'status' => 'publish', 'timestamp' => time()));
wppa_update_album(array('id' => $photo['album'], 'timestamp' => time()));
// For New indicator on album
wppa_flush_treecounts($photo['album']);
}
}
$to_publish = $wpdb->get_results($wpdb->prepare("SELECT * FROM`" . WPPA_ALBUMS . "` WHERE `scheduledtm` <> '' AND `scheduledtm` < %s", wppa_get_default_scheduledtm()), ARRAY_A);
if ($to_publish) {
foreach ($to_publish as $album) {
wppa_update_album(array('id' => $album['id'], 'scheduledtm' => ''));
wppa_flush_treecounts($album['id']);
}
}
update_option('wppa_last_schedule_check', time());
}
}
function wppa_do_frontend_file_upload($file, $alb)
{
global $wpdb;
// Log upload attempt
wppa_log('Upl', 'FE Upload attempt of file ' . $file['name'] . ', size=' . filesize($file['tmp_name']));
$album = wppa_cache_album($alb);
if (!wppa_allow_uploads($alb) || !wppa_allow_user_uploads()) {
wppa_alert(__('Max uploads reached', 'wp-photo-album-plus'));
return false;
}
if ($file['error'] != '0') {
wppa_alert(__('Error during upload', 'wp-photo-album-plus'));
return false;
}
$imgsize = getimagesize($file['tmp_name']);
if (!is_array($imgsize)) {
wppa_alert(__('Uploaded file is not an image', 'wp-photo-album-plus'));
return false;
}
if ($imgsize[2] < 1 || $imgsize[2] > 3) {
wppa_alert(sprintf(__('Only gif, jpg and png image files are supported. Returned filetype = %d.', 'wp-photo-album-plus'), $imagesize[2]));
return false;
}
$ms = wppa_opt('upload_fronend_maxsize');
if ($ms) {
// Max size configured
if ($imgsize[0] > $ms || $imgsize[0] > $ms) {
wppa_alert(sprintf(__('Uploaded file is larger than the allowed maximum of %d x %d pixels.', 'wp-photo-album-plus'), $ms, $ms));
return false;
}
}
if (wppa_switch('void_dups')) {
// Check for already exists
if (wppa_file_is_in_album(wppa_sanitize_file_name($file['name']), $alb)) {
wppa_alert(sprintf(__('Uploaded file %s already exists in this album.', 'wp-photo-album-plus'), wppa_sanitize_file_name($file['name'])));
return false;
}
}
$mayupload = wppa_check_memory_limit('', $imgsize[0], $imgsize[1]);
if ($mayupload === false) {
$maxsize = wppa_check_memory_limit(false);
if (is_array($maxsize)) {
wppa_alert(sprintf(__('The image is too big. Max photo size: %d x %d (%2.1f MegaPixel)', 'wp-photo-album-plus'), $maxsize['maxx'], $maxsize['maxy'], $maxsize['maxp'] / (1024 * 1024)));
return false;
}
}
switch ($imgsize[2]) {
// mime type
case 1:
$ext = 'gif';
break;
case 2:
$ext = 'jpg';
break;
case 3:
$ext = 'png';
break;
}
if (wppa_get_post('user-name')) {
$name = wppa_get_post('user-name');
} else {
$name = $file['name'];
}
$name = wppa_sanitize_photo_name($name);
$desc = balanceTags(wppa_get_post('user-desc'), true);
$linktarget = '_self';
$status = wppa_switch('upload_moderate') && !current_user_can('wppa_admin') ? 'pending' : 'publish';
$filename = wppa_sanitize_file_name($file['name']);
$id = wppa_create_photo_entry(array('album' => $alb, 'ext' => $ext, 'name' => $name, 'description' => $desc, 'status' => $status, 'filename' => $filename));
if (!$id) {
wppa_alert(__('Could not insert photo into db.', 'wp-photo-album-plus'));
return false;
} else {
wppa_save_source($file['tmp_name'], $filename, $alb);
wppa_update_album(array('id' => $alb, 'modified' => time()));
wppa_flush_treecounts($alb);
wppa_flush_upldr_cache('photoid', $id);
}
if (wppa_make_the_photo_files($file['tmp_name'], $id, $ext)) {
// Repair photoname if not standard
if (!wppa_get_post('user-name')) {
wppa_set_default_name($id, $file['name']);
}
// Custom data
if (wppa_switch('fe_custom_fields')) {
$custom_data = array('', '', '', '', '', '', '', '', '', '');
for ($i = '0'; $i < '10'; $i++) {
if (isset($_POST['wppa-user-custom-' . $i])) {
$custom_data[$i] = strip_tags($_POST['wppa-user-custom-' . $i]);
}
}
wppa_update_photo(array('id' => $id, 'custom' => serialize($custom_data)));
}
// Default tags
wppa_set_default_tags($id);
// Custom tags
$tags = wppa_get_photo_item($id, 'tags');
$oldt = $tags;
for ($i = '1'; $i < '4'; $i++) {
if (isset($_POST['wppa-user-tags-' . $i])) {
// Existing tags
$tags .= ',' . implode(',', $_POST['wppa-user-tags-' . $i]);
}
}
if (isset($_POST['wppa-new-tags'])) {
// New tags
$newt = $_POST['wppa-new-tags'];
$tags .= ',' . $newt;
} else {
$newt = '';
}
$tags = wppa_sanitize_tags(str_replace(array('\'', '"'), ',', wppa_filter_iptc(wppa_filter_exif($tags, $id), $id)));
if ($tags != $oldt) {
// Added tag(s)
wppa_update_photo(array('id' => $id, 'tags' => $tags));
}
// Index
wppa_index_add('photo', $id);
// Tags
if ($tags) {
wppa_clear_taglist();
// Forces recreation
}
// and add watermark ( optionally ) to fullsize image only
wppa_add_watermark($id);
// Also to thumbnail?
if (wppa_switch('watermark_thumbs')) {
wppa_create_thumbnail($id);
// create new thumb
}
// Is it a default coverimage?
wppa_check_coverimage($id);
// Mail
if (wppa_switch('upload_notify')) {
$to = get_bloginfo('admin_email');
$subj = sprintf(__('New photo uploaded: %s', 'wp-photo-album-plus'), $name);
$cont['0'] = sprintf(__('User %1$s uploaded photo %2$s into album %3$s', 'wp-photo-album-plus'), wppa_get_user(), $id, wppa_get_album_name($alb));
if (wppa_switch('upload_moderate') && !current_user_can('wppa_admin')) {
$cont['1'] = __('This upload requires moderation', 'wp-photo-album-plus');
$cont['2'] = '<a href="' . get_admin_url() . 'admin.php?page=wppa_admin_menu&tab=pmod&photo=' . $id . '" >' . __('Moderate manage photo', 'wp-photo-album-plus') . '</a>';
} else {
$cont['1'] = __('Details:', 'wp-photo-album-plus');
$cont['1'] .= ' <a href="' . get_admin_url() . 'admin.php?page=wppa_admin_menu&tab=pmod&photo=' . $id . '" >' . __('Manage photo', 'wp-photo-album-plus') . '</a>';
}
wppa_send_mail($to, $subj, $cont, $id);
}
return true;
} else {
return false;
}
}
function wppa_import_dir_to_album($file, $parent)
{
global $photocount;
global $wpdb;
global $wppa_session;
// Session should survive the default hour
wppa_extend_session();
// see if album exists
if (is_dir($file)) {
// Check parent
if (wppa_switch('import_parent_check')) {
$alb = wppa_get_album_id(basename($file), $parent);
// If parent = 0 ( top-level album ) and album not found,
// try a 'separate' album ( i.e. parent = -1 ) with this name
if (!$alb && $parent == '0') {
$alb = wppa_get_album_id(basename($file), '-1');
}
} else {
$alb = wppa_get_album_id(basename($file), false);
}
if (!$alb) {
// Album must be created
$name = basename($file);
$uplim = wppa_opt('upload_limit_count') . '/' . wppa_opt('upload_limit_time');
$alb = wppa_create_album_entry(array('name' => $name, 'a_parent' => $parent));
if ($alb === false) {
wppa_error_message(__('Could not create album.', 'wp-photo-album-plus') . '<br/>Query = ' . $query);
wp_die('Sorry, cannot continue');
} else {
wppa_set_last_album($alb);
wppa_flush_treecounts($alb);
wppa_index_add('album', $alb);
wppa_create_pl_htaccess();
wppa_ok_message(__('Album #', 'wp-photo-album-plus') . ' ' . $alb . ' ( ' . $name . ' ) ' . __('Added.', 'wp-photo-album-plus'));
if (wppa_switch('newpag_create') && $parent <= '0') {
// Create post object
$my_post = array('post_title' => $name, 'post_content' => str_replace('w#album', $alb, wppa_opt('newpag_content')), 'post_status' => wppa_opt('newpag_status'), 'post_type' => wppa_opt('newpag_type'));
// Insert the post into the database
$pagid = wp_insert_post($my_post);
if ($pagid) {
wppa_ok_message(sprintf(__('Page <a href="%s" target="_blank" >%s</a> created.', 'wp-photo-album-plus'), home_url() . '?page_id=' . $pagid, $name));
$wpdb->query($wpdb->prepare("UPDATE `" . WPPA_ALBUMS . "` SET `cover_linkpage` = %s WHERE `id` = %s", $pagid, $alb));
} else {
wppa_error_message(__('Could not create page.', 'wp-photo-album-plus'));
}
}
}
}
// Now import the files
$photofiles = glob($file . '/*');
if ($photofiles) {
foreach ($photofiles as $photofile) {
if (!is_dir($photofile)) {
if (!isset($wppa_session[$photofile]) || !wppa_switch('keep_import_files')) {
if (wppa_albumphoto_exists($alb, basename($photofile))) {
if (!wppa_switch('keep_import_files')) {
wppa_warning_message('Photo ' . basename($photofile) . ' already exists in album ' . $alb . '. Removed. (2)');
}
} else {
$bret = wppa_insert_photo($photofile, $alb, basename($photofile));
$photocount++;
}
if (!wppa_switch('keep_import_files')) {
@unlink($photofile);
}
$wppa_session[$photofile] = true;
}
if (wppa_is_time_up($photocount)) {
return false;
}
}
}
}
// Now go deeper, process the subdirs
$subdirs = glob($file . '/*');
if ($subdirs) {
foreach ($subdirs as $subdir) {
if (is_dir($subdir)) {
if (basename($subdir) != '.' && basename($subdir) != '..') {
$bret = wppa_import_dir_to_album($subdir, $alb);
if (!$bret) {
return false;
}
// Time out
}
}
}
}
@rmdir($file);
// Try to remove dir, ignore error
} else {
wppa_dbg_msg('Invalid file in wppa_import_dir_to_album(): ' . $file);
return false;
}
return true;
}
function wppa_do_frontend_file_upload($file, $alb)
{
global $wpdb;
global $wppa_supported_video_extensions;
global $wppa_supported_audio_extensions;
// Log upload attempt
wppa_log('Upl', 'FE Upload attempt of file ' . $file['name'] . ', size=' . filesize($file['tmp_name']));
$album = wppa_cache_album($alb);
// Legal here?
if (!wppa_allow_uploads($alb) || !wppa_allow_user_uploads()) {
wppa_alert(__('Max uploads reached', 'wp-photo-album-plus'));
return false;
}
// No error during upload?
if ($file['error'] != '0') {
wppa_alert(__('Error during upload', 'wp-photo-album-plus'));
return false;
}
// Find the filename
$filename = wppa_sanitize_file_name($file['name']);
$filename = wppa_strip_ext($filename);
// See if this filename with any extension already exists in this album
$id = $wpdb->get_var("SELECT `id` FROM `" . WPPA_PHOTOS . "` WHERE `filename` LIKE '" . $filename . ".%' AND `album` = " . $alb);
// Addition to an av item?
if ($id) {
$is_av = wppa_get_photo_item($id, 'ext') == 'xxx';
} else {
$is_av = false;
}
// see if audio / video and process
if (wppa_switch('enable_video') && wppa_switch('user_upload_video_on') && in_array(strtolower(wppa_get_ext($file['name'])), $wppa_supported_video_extensions) || wppa_switch('enable_audio') && wppa_switch('user_upload_audio_on') && in_array(strtolower(wppa_get_ext($file['name'])), $wppa_supported_audio_extensions)) {
$is_av = true;
// Find the name
if (wppa_get_post('user-name')) {
$name = wppa_get_post('user-name');
} else {
$name = $file['name'];
}
$name = wppa_sanitize_photo_name($name);
$filename .= '.xxx';
// update entry
if ($id) {
wppa_update_photo(array('id' => $id, 'ext' => 'xxx', 'filename' => $filename));
}
// Add new entry
if (!$id) {
$id = wppa_create_photo_entry(array('album' => $alb, 'filename' => $filename, 'ext' => 'xxx', 'name' => $name, 'description' => balanceTags(wppa_get_post('user-desc'), true)));
if (!$id) {
wppa_alert(__('Could not insert media into db.', 'wp-photo-album-plus'));
return false;
}
}
// Housekeeping
wppa_update_album(array('id' => $alb, 'modified' => time()));
wppa_flush_treecounts($alb);
wppa_flush_upldr_cache('photoid', $id);
// Add video filetype
$ext = strtolower(wppa_get_ext($file['name']));
$newpath = wppa_strip_ext(wppa_get_photo_path($id)) . '.' . $ext;
copy($file['tmp_name'], $newpath);
// Repair name if not standard
if (!wppa_get_post('user-name')) {
wppa_set_default_name($id, $file['name']);
}
// tags
wppa_fe_add_tags($id);
// custom
wppa_fe_add_custom($id);
// Done!
return $id;
}
// If not already an existing audio / video; Forget the id from a previously found item with the same filename.
if (!$is_av) {
$id = false;
}
// Is it an image?
$imgsize = getimagesize($file['tmp_name']);
if (!is_array($imgsize)) {
wppa_alert(__('Uploaded file is not an image', 'wp-photo-album-plus'));
return false;
}
// Is it a supported image filetype?
if ($imgsize[2] != IMAGETYPE_GIF && $imgsize[2] != IMAGETYPE_JPEG && $imgsize[2] != IMAGETYPE_PNG) {
wppa_alert(sprintf(__('Only gif, jpg and png image files are supported. Returned info = %s.', 'wp-photo-album-plus'), wppa_serialize($imgsize)), false, false);
return false;
}
// Is it not too big?
$ms = wppa_opt('upload_fronend_maxsize');
if ($ms) {
// Max size configured
if ($imgsize[0] > $ms || $imgsize[1] > $ms) {
wppa_alert(sprintf(__('Uploaded file is larger than the allowed maximum of %d x %d pixels.', 'wp-photo-album-plus'), $ms, $ms));
return false;
}
}
// Check for already exists
if (wppa_switch('void_dups')) {
if (wppa_file_is_in_album(wppa_sanitize_file_name($file['name']), $alb)) {
wppa_alert(sprintf(__('Uploaded file %s already exists in this album.', 'wp-photo-album-plus'), wppa_sanitize_file_name($file['name'])));
return false;
}
}
// Check for max memory needed to rocess image?
$mayupload = wppa_check_memory_limit('', $imgsize[0], $imgsize[1]);
if ($mayupload === false) {
$maxsize = wppa_check_memory_limit(false);
if (is_array($maxsize)) {
wppa_alert(sprintf(__('The image is too big. Max photo size: %d x %d (%2.1f MegaPixel)', 'wp-photo-album-plus'), $maxsize['maxx'], $maxsize['maxy'], $maxsize['maxp'] / (1024 * 1024)));
return false;
}
}
// Find extension from mimetype
switch ($imgsize[2]) {
// mime type
case 1:
$ext = 'gif';
break;
case 2:
$ext = 'jpg';
break;
case 3:
$ext = 'png';
break;
}
// Did the user supply a photoname?
if (wppa_get_post('user-name')) {
$name = wppa_get_post('user-name');
} else {
$name = $file['name'];
}
// Sanitize input
$name = wppa_sanitize_photo_name($name);
$desc = balanceTags(wppa_get_post('user-desc'), true);
// If BlogIt! and no descrption given, use name field - this is for the shortcode used: typ"mphoto"
if (!$desc && isset($_POST['wppa-blogit'])) {
$desc = 'w#name';
}
// Find status and other needed data
$linktarget = '_self';
$status = wppa_switch('upload_moderate') && !current_user_can('wppa_admin') ? 'pending' : 'publish';
if (wppa_switch('fe_upload_private')) {
$status = 'private';
}
$filename = wppa_sanitize_file_name($file['name']);
// Create new entry if this is not a posterfile
if (!$is_av) {
$id = wppa_create_photo_entry(array('album' => $alb, 'ext' => $ext, 'name' => $name, 'description' => $desc, 'status' => $status, 'filename' => $filename));
}
if (!$id) {
wppa_alert(__('Could not insert photo into db.', 'wp-photo-album-plus'));
return false;
} else {
wppa_save_source($file['tmp_name'], $filename, $alb);
wppa_make_o1_source($id);
wppa_update_album(array('id' => $alb, 'modified' => time()));
wppa_flush_treecounts($alb);
wppa_flush_upldr_cache('photoid', $id);
}
if (wppa_make_the_photo_files($file['tmp_name'], $id, $ext)) {
// Repair photoname if not standard
if (!wppa_get_post('user-name')) {
wppa_set_default_name($id, $file['name']);
}
// Custom data
wppa_fe_add_custom($id);
// Add tags
wppa_fe_add_tags($id);
// and add watermark ( optionally ) to fullsize image only
wppa_add_watermark($id);
// Also to thumbnail?
if (wppa_switch('watermark_thumbs')) {
wppa_create_thumbnail($id);
// create new thumb
}
// Is it a default coverimage?
wppa_check_coverimage($id);
// Mail
if (wppa_switch('upload_notify')) {
$to = get_bloginfo('admin_email');
$subj = sprintf(__('New photo uploaded: %s', 'wp-photo-album-plus'), $name);
$cont['0'] = sprintf(__('User %1$s uploaded photo %2$s into album %3$s', 'wp-photo-album-plus'), wppa_get_user(), $id, wppa_get_album_name($alb));
if (wppa_switch('upload_moderate') && !current_user_can('wppa_admin')) {
$cont['1'] = __('This upload requires moderation', 'wp-photo-album-plus');
$cont['2'] = '<a href="' . get_admin_url() . 'admin.php?page=wppa_admin_menu&tab=pmod&photo=' . $id . '" >' . __('Moderate manage photo', 'wp-photo-album-plus') . '</a>';
} else {
$cont['1'] = __('Details:', 'wp-photo-album-plus');
$cont['1'] .= ' <a href="' . get_admin_url() . 'admin.php?page=wppa_admin_menu&tab=pmod&photo=' . $id . '" >' . __('Manage photo', 'wp-photo-album-plus') . '</a>';
}
wppa_send_mail($to, $subj, $cont, $id);
}
return $id;
}
return false;
}
function wppa_do_maintenance_proc($slug)
{
global $wpdb;
global $thumb;
global $wppa_opt;
global $wppa_session;
global $wppa_supported_video_extensions;
global $wppa_supported_audio_extensions;
// Check for multiple maintenance procs
if (!wppa_switch('wppa_maint_ignore_concurrency_error')) {
$all_slugs = array('wppa_remake_index_albums', 'wppa_remove_empty_albums', 'wppa_remake_index_photos', 'wppa_apply_new_photodesc_all', 'wppa_append_to_photodesc', 'wppa_remove_from_photodesc', 'wppa_remove_file_extensions', 'wppa_readd_file_extensions', 'wppa_regen_thumbs', 'wppa_rerate', 'wppa_recup', 'wppa_file_system', 'wppa_cleanup', 'wppa_remake', 'wppa_list_index', 'wppa_blacklist_user', 'wppa_un_blacklist_user', 'wppa_rating_clear', 'wppa_viewcount_clear', 'wppa_iptc_clear', 'wppa_exif_clear', 'wppa_watermark_all', 'wppa_create_all_autopages', 'wppa_leading_zeros', 'wppa_add_gpx_tag', 'wppa_optimize_ewww', 'wppa_comp_sizes', 'wppa_edit_tag');
foreach (array_keys($all_slugs) as $key) {
if ($all_slugs[$key] != $slug) {
if (get_option($all_slugs[$key] . '_togo', '0')) {
// Process running
return __('You can run only one maintenance procedure at a time', 'wppa') . '||' . $slug . '||' . __('Error', 'wppa') . '||' . '' . '||' . '';
}
}
}
}
// Lock this proc
update_option($slug . '_user', wppa_get_user());
// Initialize
$endtime = time() + '5';
// Allow for 5 seconds
$chunksize = '1000';
$lastid = strval(intval(get_option($slug . '_last', '0')));
$errtxt = '';
$id = '0';
$topid = '0';
$reload = '';
if (!isset($wppa_session)) {
$wppa_session = array();
}
if (!isset($wppa_session[$slug . '_fixed'])) {
$wppa_session[$slug . '_fixed'] = '0';
}
if (!isset($wppa_session[$slug . '_deleted'])) {
$wppa_session[$slug . '_deleted'] = '0';
}
if (!isset($wppa_session[$slug . '_skipped'])) {
$wppa_session[$slug . '_skipped'] = '0';
}
if ($lastid == '0') {
$wppa_session[$slug . '_fixed'] = '0';
$wppa_session[$slug . '_deleted'] = '0';
$wppa_session[$slug . '_skipped'] = '0';
}
// Pre-processing needed?
if ($lastid == '0') {
switch ($slug) {
case 'wppa_remake_index_albums':
$wpdb->query("UPDATE `" . WPPA_INDEX . "` SET `albums` = ''");
break;
case 'wppa_remake_index_photos':
$wpdb->query("UPDATE `" . WPPA_INDEX . "` SET `photos` = ''");
wppa_index_compute_skips();
break;
case 'wppa_recup':
$wpdb->query("DELETE FROM `" . WPPA_IPTC . "` WHERE `photo` <> '0'");
$wpdb->query("DELETE FROM `" . WPPA_EXIF . "` WHERE `photo` <> '0'");
break;
case 'wppa_file_system':
if (get_option('wppa_file_system') == 'flat') {
update_option('wppa_file_system', 'to-tree');
}
if (get_option('wppa_file_system') == 'tree') {
update_option('wppa_file_system', 'to-flat');
}
break;
case 'wppa_cleanup':
$orphan_album = get_option('wppa_orphan_album', '0');
$album_exists = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM`" . WPPA_ALBUMS . "` WHERE `id` = %s", $orphan_album));
if (!$album_exists) {
$orphan_album = false;
}
if (!$orphan_album) {
$orphan_album = wppa_create_album_entry(array('name' => __('Orphan photos', 'wppa'), 'a_parent' => '-1', 'description' => __('This album contains refound lost photos', 'wppa')));
update_option('wppa_orphan_album', $orphan_album);
}
break;
}
}
// Dispatch on albums / photos / single actions
switch ($slug) {
case 'wppa_remake_index_albums':
case 'wppa_remove_empty_albums':
// Process albums
$table = WPPA_ALBUMS;
$topid = $wpdb->get_var("SELECT `id` FROM `" . WPPA_ALBUMS . "` ORDER BY `id` DESC LIMIT 1");
$albums = $wpdb->get_results("SELECT * FROM `" . WPPA_ALBUMS . "` WHERE `id` > " . $lastid . " ORDER BY `id` LIMIT 100", ARRAY_A);
wppa_cache_album('add', $albums);
if ($albums) {
foreach ($albums as $album) {
$id = $album['id'];
switch ($slug) {
case 'wppa_remake_index_albums':
wppa_index_add('album', $id);
break;
case 'wppa_remove_empty_albums':
$p = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM `" . WPPA_PHOTOS . "` WHERE `album` = %s", $id));
$a = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM `" . WPPA_ALBUMS . "` WHERE `a_parent` = %s", $id));
if (!$a && !$p) {
$wpdb->query($wpdb->prepare("DELETE FROM `" . WPPA_ALBUMS . "` WHERE `id` = %s", $id));
wppa_delete_album_source($id);
wppa_flush_treecounts($id);
wppa_index_remove('album', $id);
}
break;
}
// Test for timeout / ready
$lastid = $id;
update_option($slug . '_last', $lastid);
if (time() > $endtime) {
break;
}
// Time out
}
} else {
// Nothing to do, Done anyway
$lastid = $topid;
}
break;
// End process albums
// End process albums
case 'wppa_remake_index_photos':
$chunksize = '100';
case 'wppa_apply_new_photodesc_all':
case 'wppa_append_to_photodesc':
case 'wppa_remove_from_photodesc':
case 'wppa_remove_file_extensions':
case 'wppa_readd_file_extensions':
case 'wppa_regen_thumbs':
case 'wppa_rerate':
case 'wppa_recup':
case 'wppa_file_system':
case 'wppa_cleanup':
case 'wppa_remake':
case 'wppa_watermark_all':
case 'wppa_create_all_autopages':
case 'wppa_leading_zeros':
case 'wppa_add_gpx_tag':
case 'wppa_optimize_ewww':
case 'wppa_comp_sizes':
case 'wppa_edit_tag':
// Process photos
$table = WPPA_PHOTOS;
if ($slug == 'wppa_cleanup') {
$topid = get_option('wppa_' . WPPA_PHOTOS . '_lastkey', '1') * 10;
$photos = array();
for ($i = $lastid + '1'; $i <= $topid; $i++) {
$photos[]['id'] = $i;
}
} else {
$topid = $wpdb->get_var("SELECT `id` FROM `" . WPPA_PHOTOS . "` ORDER BY `id` DESC LIMIT 1");
$photos = $wpdb->get_results("SELECT * FROM `" . WPPA_PHOTOS . "` WHERE `id` > " . $lastid . " ORDER BY `id` LIMIT " . $chunksize, ARRAY_A);
}
if ($slug == 'wppa_edit_tag') {
$edit_tag = get_option('wppa_tag_to_edit');
$new_tag = get_option('wppa_new_tag_value');
}
if (!$photos && $slug == 'wppa_file_system') {
$fs = get_option('wppa_file_system');
if ($fs == 'to-tree') {
$to = 'tree';
} elseif ($fs == 'to-flat') {
$to = 'flat';
} else {
$to = $fs;
}
}
if ($photos) {
foreach ($photos as $photo) {
$thumb = $photo;
// Make globally known
$id = $photo['id'];
switch ($slug) {
case 'wppa_remake_index_photos':
wppa_index_add('photo', $id);
break;
case 'wppa_apply_new_photodesc_all':
$value = $wppa_opt['wppa_newphoto_description'];
$description = trim($value);
if ($description != $photo['description']) {
// Modified photo description
$wpdb->query($wpdb->prepare("UPDATE `" . WPPA_PHOTOS . "` SET `description` = %s WHERE `id` = %s", $description, $id));
}
break;
case 'wppa_append_to_photodesc':
$value = trim($wppa_opt['wppa_append_text']);
if (!$value) {
return 'Unexpected error: missing text to append||' . $slug . '||Error||0';
}
$description = rtrim($photo['description'] . ' ' . $value);
if ($description != $photo['description']) {
// Modified photo description
$wpdb->query($wpdb->prepare("UPDATE `" . WPPA_PHOTOS . "` SET `description` = %s WHERE `id` = %s", $description, $id));
}
break;
case 'wppa_remove_from_photodesc':
$value = trim($wppa_opt['wppa_remove_text']);
if (!$value) {
return 'Unexpected error: missing text to remove||' . $slug . '||Error||0';
}
$description = rtrim(str_replace($value, '', $photo['description']));
if ($description != $photo['description']) {
// Modified photo description
$wpdb->query($wpdb->prepare("UPDATE `" . WPPA_PHOTOS . "` SET `description` = %s WHERE `id` = %s", $description, $id));
}
break;
case 'wppa_remove_file_extensions':
if (!wppa_is_video($id)) {
$name = str_replace(array('.jpg', '.png', '.gif', '.JPG', '.PNG', '.GIF'), '', $photo['name']);
if ($name != $photo['name']) {
// Modified photo name
$wpdb->query($wpdb->prepare("UPDATE `" . WPPA_PHOTOS . "` SET `name` = %s WHERE `id` = %s", $name, $id));
}
}
break;
case 'wppa_readd_file_extensions':
if (!wppa_is_video($id)) {
$name = str_replace(array('.jpg', '.png', 'gif', '.JPG', '.PNG', '.GIF'), '', $photo['name']);
if ($name == $photo['name']) {
// Name had no fileextension
$wpdb->query($wpdb->prepare("UPDATE `" . WPPA_PHOTOS . "` SET `name` = %s WHERE `id` = %s", $name . '.' . $photo['ext'], $id));
}
}
break;
case 'wppa_regen_thumbs':
if (!wppa_is_video($id) || file_exists(str_replace('xxx', 'jpg', wppa_get_photo_path($id)))) {
wppa_create_thumbnail($id);
}
break;
case 'wppa_rerate':
wppa_rate_photo($id);
break;
case 'wppa_recup':
$a_ret = wppa_recuperate($id);
if ($a_ret['iptcfix']) {
$wppa_session[$slug . '_fixed']++;
}
if ($a_ret['exiffix']) {
$wppa_session[$slug . '_fixed']++;
}
break;
case 'wppa_file_system':
$fs = get_option('wppa_file_system');
if ($fs == 'to-tree' || $fs == 'to-flat') {
if ($fs == 'to-tree') {
$from = 'flat';
$to = 'tree';
} else {
$from = 'tree';
$to = 'flat';
}
// Media files
if (wppa_is_multi($id)) {
// Can NOT use wppa_has_audio() or wppa_is_video(), they use wppa_get_photo_path() without fs switch!!
$exts = array_merge($wppa_supported_video_extensions, $wppa_supported_audio_extensions);
$pathfrom = wppa_get_photo_path($id, $from);
$pathto = wppa_get_photo_path($id, $to);
// wppa_log( 'dbg', 'Trying: '.$pathfrom );
foreach ($exts as $ext) {
if (is_file(str_replace('.xxx', '.' . $ext, $pathfrom))) {
// wppa_log( 'dbg', str_replace( '.xxx', '.'.$ext, $pathfrom ).' -> '.str_replace( '.xxx', '.'.$ext, $pathto ));
@rename(str_replace('.xxx', '.' . $ext, $pathfrom), str_replace('.xxx', '.' . $ext, $pathto));
}
}
}
// Poster / photo
if (file_exists(wppa_fix_poster_ext(wppa_get_photo_path($id, $from), $id))) {
@rename(wppa_fix_poster_ext(wppa_get_photo_path($id, $from), $id), wppa_fix_poster_ext(wppa_get_photo_path($id, $to), $id));
}
// Thumbnail
if (file_exists(wppa_fix_poster_ext(wppa_get_thumb_path($id, $from), $id))) {
@rename(wppa_fix_poster_ext(wppa_get_thumb_path($id, $from), $id), wppa_fix_poster_ext(wppa_get_thumb_path($id, $to), $id));
}
}
break;
case 'wppa_cleanup':
$photo_files = glob(WPPA_UPLOAD_PATH . '/' . $id . '.*');
// Remove dirs
if ($photo_files) {
foreach (array_keys($photo_files) as $key) {
if (is_dir($photo_files[$key])) {
unset($photo_files[$key]);
}
}
}
// files left? process
if ($photo_files) {
foreach ($photo_files as $photo_file) {
$basename = basename($photo_file);
$ext = substr($basename, strpos($basename, '.') + '1');
if (!$wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM `" . WPPA_PHOTOS . "` WHERE `id` = %s", $id))) {
// no db entry for this photo
if (wppa_is_id_free(WPPA_PHOTOS, $id)) {
if (wppa_create_photo_entry(array('id' => $id, 'album' => $orphan_album, 'ext' => $ext, 'filename' => $basename))) {
// Can create entry
$wppa_session[$slug . '_fixed']++;
// Bump counter
wppa_log('Debug', 'Lost photo file ' . $photo_file . ' recovered');
} else {
wppa_log('Debug', 'Unable to recover lost photo file ' . $photo_file . ' Create photo entry failed');
}
} else {
wppa_log('Debug', 'Could not recover lost photo file ' . $photo_file . ' The id is not free');
}
}
}
}
break;
case 'wppa_remake':
if (wppa_remake_files('', $id)) {
$wppa_session[$slug . '_fixed']++;
} else {
$wppa_session[$slug . '_skipped']++;
}
break;
case 'wppa_watermark_all':
if (!wppa_is_video($id)) {
if (wppa_add_watermark($id)) {
wppa_create_thumbnail($id);
// create new thumb
$wppa_session[$slug . '_fixed']++;
} else {
$wppa_session[$slug . '_skipped']++;
}
} else {
$wppa_session[$slug . '_skipped']++;
}
break;
case 'wppa_create_all_autopages':
wppa_get_the_auto_page($id);
break;
case 'wppa_leading_zeros':
$name = $photo['name'];
if (wppa_is_int($name)) {
$target_len = wppa_opt('wppa_zero_numbers');
$name = strval(intval($name));
while (strlen($name) < $target_len) {
$name = '0' . $name;
}
}
if ($name !== $photo['name']) {
$wpdb->query($wpdb->prepare("UPDATE `" . WPPA_PHOTOS . "` SET `name` = %s WHERE `id` = %s", $name, $id));
}
break;
case 'wppa_add_gpx_tag':
$tags = $photo['tags'];
$temp = explode('/', $photo['location']);
if (!isset($temp['2'])) {
$temp['2'] = false;
}
if (!isset($temp['3'])) {
$temp['3'] = false;
}
$lat = $temp['2'];
$lon = $temp['3'];
if ($lat < 0.01 && $lat > -0.01 && $lon < 0.01 && $lon > -0.01) {
$lat = false;
$lon = false;
}
if ($photo['location'] && strpos($tags, 'Gpx') === false && $lat && $lon) {
// Add it
$tags = wppa_sanitize_tags($tags . ',Gpx');
wppa_update_photo(array('id' => $photo['id'], 'tags' => $tags));
wppa_index_update('photo', $photo['id']);
wppa_clear_taglist();
} elseif (strpos($tags, 'Gpx') !== false && !$lat && !$lon) {
// Remove it
$tags = wppa_sanitize_tags(str_replace('Gpx', '', $tags));
wppa_update_photo(array('id' => $photo['id'], 'tags' => $tags));
wppa_index_update('photo', $photo['id']);
wppa_clear_taglist();
}
break;
case 'wppa_optimize_ewww':
$file = wppa_get_photo_path($photo['id']);
if (is_file($file)) {
ewww_image_optimizer($file, 4, false, false, false);
}
$file = wppa_get_thumb_path($photo['id']);
if (is_file($file)) {
ewww_image_optimizer($file, 4, false, false, false);
}
break;
case 'wppa_comp_sizes':
$tx = 0;
$ty = 0;
$px = 0;
$py = 0;
$file = wppa_get_photo_path($photo['id']);
if (is_file($file)) {
$temp = getimagesize($file);
if (is_array($temp)) {
$px = $temp[0];
$py = $temp[1];
}
}
$file = wppa_get_thumb_path($photo['id']);
if (is_file($file)) {
$temp = getimagesize($file);
if (is_array($temp)) {
$tx = $temp[0];
$ty = $temp[1];
}
}
wppa_update_photo(array('id' => $photo['id'], 'thumbx' => $tx, 'thumby' => $ty, 'photox' => $px, 'photoy' => $py));
break;
case 'wppa_edit_tag':
$phototags = explode(',', wppa_get_photo_item($photo['id'], 'tags'));
if (in_array($edit_tag, $phototags)) {
foreach (array_keys($phototags) as $key) {
if ($phototags[$key] == $edit_tag) {
$phototags[$key] = $new_tag;
}
}
$tags = wppa_sanitize_tags(implode(',', $phototags));
wppa_update_photo(array('id' => $photo['id'], 'tags' => $tags));
$wppa_session[$slug . '_fixed']++;
} else {
$wppa_session[$slug . '_skipped']++;
}
break;
}
// Test for timeout / ready
$lastid = $id;
update_option($slug . '_last', $lastid);
if (time() > $endtime) {
break;
}
// Time out
}
} else {
// Nothing to do, Done anyway
$lastid = $topid;
wppa_log('Debug', 'Maintenance proc ' . $slug . ': Done!');
}
break;
// End process photos
// Single action maintenance modules
// case 'wppa_list_index':
// break;
// case 'wppa_blacklist_user':
// break;
// case 'wppa_un_blacklist_user':
// break;
// case 'wppa_rating_clear':
// break;
// case 'wppa_viewcount_clear':
// break;
// case 'wppa_iptc_clear':
// break;
// case 'wppa_exif_clear':
// break;
// End process photos
// Single action maintenance modules
// case 'wppa_list_index':
// break;
// case 'wppa_blacklist_user':
// break;
// case 'wppa_un_blacklist_user':
// break;
// case 'wppa_rating_clear':
// break;
// case 'wppa_viewcount_clear':
// break;
// case 'wppa_iptc_clear':
// break;
// case 'wppa_exif_clear':
// break;
default:
$errtxt = 'Unimplemented maintenance slug: ' . strip_tags($slug);
}
// either $albums / $photos has been exhousted ( for this try ) or time is up
if ($slug == 'wppa_cleanup') {
$togo = $topid - $lastid;
} else {
$togo = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM `" . $table . "` WHERE `id` > %s ", $lastid));
}
$status = $togo ? 'Pending' : 'Ready';
if ($togo) {
update_option($slug . '_togo', $togo);
update_option($slug . '_status', $status);
} else {
// Really done
// Report fixed/skipped/deleted
if ($wppa_session[$slug . '_fixed']) {
$status .= ' fixed:' . $wppa_session[$slug . '_fixed'];
unset($wppa_session[$slug . '_fixed']);
}
if ($wppa_session[$slug . '_skipped']) {
$status .= ' skipped:' . $wppa_session[$slug . '_skipped'];
unset($wppa_session[$slug . '_skipped']);
}
if ($wppa_session[$slug . '_deleted']) {
$status .= ' deleted:' . $wppa_session[$slug . '_deleted'];
unset($wppa_session[$slug . '_deleted']);
}
// Re-Init options
delete_option($slug . '_togo', '');
delete_option($slug . '_status', '');
delete_option($slug . '_last', '0');
delete_option($slug . '_user', '');
// Post-processing needed?
switch ($slug) {
case 'wppa_remake_index_albums':
case 'wppa_remake_index_photos':
$wpdb->query("DELETE FROM `" . WPPA_INDEX . "` WHERE `albums` = '' AND `photos` = ''");
// Remove empty entries
delete_option('wppa_index_need_remake');
break;
case 'wppa_apply_new_photodesc_all':
case 'wppa_append_to_photodesc':
case 'wppa_remove_from_photodesc':
update_option('wppa_remake_index_photos_status', __('Required', 'wppa'));
break;
case 'wppa_regen_thumbs':
wppa_bump_thumb_rev();
break;
case 'wppa_file_system':
wppa_update_option('wppa_file_system', $to);
$reload = 'reload';
break;
case 'wppa_remake':
wppa_bump_photo_rev();
wppa_bump_thumb_rev();
break;
case 'wppa_edit_tag':
wppa_clear_taglist();
$reload = 'reload';
break;
}
}
return $errtxt . '||' . $slug . '||' . $status . '||' . $togo . '||' . $reload;
}
function wppa_grant_albums($xparent = false)
{
global $wpdb;
static $grant_parents;
static $my_albs_parents;
static $owner;
static $user;
// Feature enabled?
if (!wppa_switch('grant_an_album')) {
return false;
}
// Owners only?
if (!wppa_switch('owner_only')) {
return false;
}
// User logged in?
if (!is_user_logged_in()) {
return false;
}
// Can user upload?
if (!current_user_can('wppa_upload') && !wppa_switch('user_upload_on')) {
return false;
}
// Init
$albums_created = array();
// Get required data if not done already
// First get the grant parent album(s)
if (!is_array($grant_parents)) {
switch (wppa_opt('grant_parent_sel_method')) {
case 'selectionbox':
// Album ids are and expanded enumeration sep by , in the setting
$grant_parents = explode(',', wppa_opt('grant_parent'));
if (!is_array($grant_parents)) {
$grant_parents = array('0');
}
break;
case 'category':
// The option hold a category
$grant_parents = $wpdb->get_col("SELECT `id` " . "FROM `" . WPPA_ALBUMS . "` " . "WHERE `cats` LIKE '%," . wppa_opt('grant_parent') . ",%'");
break;
case 'indexsearch':
$temp = $wpdb->get_var("SELECT `albums` " . "FROM `" . WPPA_INDEX . "` " . "WHERE `slug` = '" . wppa_opt('grant_parent') . "'");
$grant_parents = explode('.', wppa_expand_enum($temp));
break;
}
}
if (!$owner) {
$owner = wppa_get_user('login');
// The current users login name
}
if (!is_array($my_albs_parents)) {
$query = $wpdb->prepare("SELECT DISTINCT `a_parent` FROM `" . WPPA_ALBUMS . "` WHERE `owner` = %s", $owner);
$my_albs_parents = $wpdb->get_col($query);
if (!is_array($my_albs_parents)) {
$my_albs_parents = array();
}
}
if (!$user) {
$user = wppa_get_user(wppa_opt('grant_name'));
// The current users name as how the album should be named
}
// If a parent is given and it is not a grant parent, quit
if ($xparent && !in_array($xparent, $grant_parents)) {
return false;
}
// If a parent is given, it will now be a grant parent (see directly above), only create the granted album inside this parent.
if ($xparent) {
$parents = array($xparent);
} else {
$parents = $grant_parents;
}
// Parent independant album data
$name = $user;
$desc = __('Default photo album for', 'wp-photo-album-plus') . ' ' . $user;
// May be multiple granted parents. Check for all parents.
foreach ($parents as $parent) {
// Create only grant album if: parent is either -1 or existing
if ($parent == '-1' || wppa_album_exists($parent)) {
if (!in_array($parent, $my_albs_parents, true)) {
// make an album for this user
$id = wppa_create_album_entry(array('name' => $name, 'description' => $desc, 'a_parent' => $parent));
if ($id) {
wppa_log('Obs', 'Album ' . wppa_get_album_name($parent) . '(' . $parent . ')' . ' -> ' . $id . ' for ' . $user . ' created.');
$albums_created[] = $id;
// Add this parent to the array of my albums parents
$my_albs_parents[] = $parent;
} else {
wppa_log('Err', 'Could not create subalbum of ' . $parent . ' for ' . $user);
}
wppa_flush_treecounts($parent);
wppa_index_add('album', $id);
}
}
}
// Remake permalink redirects
if (!empty($albums_created)) {
wppa_create_pl_htaccess();
}
return $albums_created;
}
function wppa_ajax_callback()
{
global $wpdb;
global $wppa_session;
wppa('ajax', true);
wppa('error', '0');
wppa('out', '');
$wppa_session['page']--;
$wppa_session['ajax']++;
wppa_save_session();
// ALTHOUGH IF WE ARE HERE AS FRONT END VISITOR, is_admin() is true.
// So, $wppa_opt switches are 'yes' or 'no' and not true or false.
// So, always use the function wppa_switch( $slug ) to test on a bool setting
// Globally check query args to prevent php injection
$wppa_args = array('album', 'photo', 'slide', 'cover', 'occur', 'woccur', 'searchstring', 'topten', 'lasten', 'comten', 'featen', 'single', 'photos-only', 'debug', 'relcount', 'upldr', 'owner', 'rootsearch');
foreach ($_REQUEST as $arg) {
if (in_array(str_replace('wppa-', '', $arg), $wppa_args)) {
if (strpos($arg, '<?') !== false) {
die('Security check failure #91');
}
if (strpos($arg, '?>') !== false) {
die('Security check failure #92');
}
}
}
wppa_vfy_arg('wppa-action', true);
wppa_vfy_arg('photo-id');
wppa_vfy_arg('comment-id');
wppa_vfy_arg('moccur');
wppa_vfy_arg('comemail', true);
wppa_vfy_arg('comname', true);
wppa_vfy_arg('tag', true);
$wppa_action = $_REQUEST['wppa-action'];
switch ($wppa_action) {
case 'getssiptclist':
$tag = str_replace('H', '#', $_REQUEST['tag']);
$mocc = $_REQUEST['moccur'];
$oldvalue = '';
if (strpos($wppa_session['supersearch'], ',') !== false) {
$ss_data = explode(',', $wppa_session['supersearch']);
if (count($ss_data) == '4') {
if ($ss_data['0'] == 'p') {
if ($ss_data['1'] == 'i') {
if ($ss_data['2'] == $_REQUEST['tag']) {
$oldvalue = $ss_data['3'];
}
}
}
}
}
$iptcdata = $wpdb->get_results($wpdb->prepare("SELECT * FROM `" . WPPA_IPTC . "` WHERE `photo` > '0' AND `tag` = %s ORDER BY `description`", $tag), ARRAY_A);
$last = '';
$any = false;
if (is_array($iptcdata)) {
foreach ($iptcdata as $item) {
$desc = sanitize_text_field($item['description']);
$desc = str_replace(array(chr(0), chr(1), chr(2), chr(3), chr(4), chr(5), chr(6), chr(7)), '', $desc);
if ($desc != $last) {
$sel = $oldvalue && $oldvalue == $desc ? 'selected="selected"' : '';
if ($sel) {
echo 'selected:' . $oldvalue;
}
$ddesc = strlen($desc) > '32' ? substr($desc, 0, 30) . '...' : $desc;
echo '<option' . ' value="' . esc_attr($desc) . '"' . ' class="wppa-iptclist-' . $mocc . '"' . ' ' . $sel . ' >' . $ddesc . '</option>';
$last = $desc;
$any = true;
}
}
}
if (!$any) {
$query = $wpdb->prepare("DELETE FROM `" . WPPA_IPTC . "` WHERE `photo` = '0' AND `tag` = %s", $tag);
$wpdb->query($query);
// wppa_log( 'dbg', $query );
}
wppa_exit();
break;
case 'getssexiflist':
$tag = str_replace('H', '#', $_REQUEST['tag']);
$mocc = $_REQUEST['moccur'];
$oldvalue = '';
if (strpos($wppa_session['supersearch'], ',') !== false) {
$ss_data = explode(',', $wppa_session['supersearch']);
if (count($ss_data) == '4') {
if ($ss_data['0'] == 'p') {
if ($ss_data['1'] == 'e') {
if ($ss_data['2'] == $_REQUEST['tag']) {
$oldvalue = $ss_data['3'];
}
}
}
}
}
$exifdata = $wpdb->get_results($wpdb->prepare("SELECT * FROM `" . WPPA_EXIF . "` WHERE `photo` > '0' AND `tag` = %s ORDER BY `description`", $tag), ARRAY_A);
$last = '';
$any = false;
if (is_array($exifdata)) {
foreach ($exifdata as $item) {
$desc = sanitize_text_field($item['description']);
$desc = str_replace(array(chr(0), chr(1), chr(2), chr(3), chr(4), chr(5), chr(6), chr(7)), '', $desc);
if ($desc != $last) {
$sel = $oldvalue && $oldvalue == $desc ? 'selected="selected"' : '';
$ddesc = strlen($desc) > '32' ? substr($desc, 0, 30) . '...' : $desc;
echo '<option' . ' value="' . esc_attr($desc) . '"' . ' class="wppa-exiflist-' . $mocc . '"' . ' ' . $sel . ' >' . $ddesc . '</option>';
$last = $desc;
$any = true;
}
}
}
if (!$any) {
$query = $wpdb->prepare("DELETE FROM `" . WPPA_EXIF . "` WHERE `photo` = '0' AND `tag` = %s", $tag);
$wpdb->query($query);
// wppa_log( 'dbg', $query );
}
wppa_exit();
break;
case 'front-edit':
if (!isset($_REQUEST['photo-id'])) {
die('Missing required argument');
}
$photo = $_REQUEST['photo-id'];
$ok = false;
if (current_user_can('wppa_admin')) {
$ok = true;
}
if (wppa_get_user() == wppa_get_photo_owner($photo) && (current_user_can('wppa_upload') || is_user_logged_in() && wppa_switch('upload_edit'))) {
$ok = true;
}
if (!$ok) {
die('You do not have sufficient rights to do this');
}
require_once 'wppa-photo-admin-autosave.php';
wppa('front_edit', true);
echo ' <div style="padding-bottom:4px;height:24px;" >
<span style="color:#777;" >
<i>' . __('All modifications are instantly updated on the server. The <b style="color:#070" >Remark</b> field keeps you informed on the actions taken at the background.', 'wp-photo-album-plus') . '</i>
</span>
<input id="wppa-fe-exit" type="button" style="float:right;color:red;font-weight:bold;" onclick="window.opener.location.reload( true );window.close();" value="' . __('Exit & Refresh', 'wp-photo-album-plus') . '" />
<div id="wppa-fe-count" style="float:right;" ></div>
</div><div style="clear:both;"></div>';
wppa_album_photos('', $photo);
wppa_exit();
break;
case 'do-comment':
// Security check
$mocc = $_REQUEST['moccur'];
$nonce = $_REQUEST['wppa-nonce'];
if (!wp_verify_nonce($nonce, 'wppa-nonce-' . $mocc)) {
_e('Security check failure', 'wp-photo-album-plus');
wppa_exit();
}
// Correct the fact that this is a non-admin operation, if it is only
if (is_admin()) {
require_once 'wppa-non-admin.php';
}
wppa('mocc', $_REQUEST['moccur']);
wppa('comment_photo', isset($_REQUEST['photo-id']) ? $_REQUEST['photo-id'] : '0');
wppa('comment_id', isset($_REQUEST['comment-edit']) ? $_REQUEST['comment-edit'] : '0');
$comment_allowed = !wppa_switch('comment_login') || is_user_logged_in();
if (wppa_switch('show_comments') && $comment_allowed) {
// if ( wppa_switch( 'search_comments' ) ) wppa_index_remove( 'photo', $_REQUEST['photo-id'] );
wppa_do_comment($_REQUEST['photo-id']);
// Process the comment
if (wppa_switch('search_comments')) {
wppa_index_update('photo', $_REQUEST['photo-id']);
}
}
wppa('no_esc', true);
echo wppa_comment_html($_REQUEST['photo-id'], $comment_allowed);
// Retrieve the new commentbox content
wppa_exit();
break;
case 'import':
require_once 'wppa-upload.php';
_wppa_page_import();
wppa_exit();
break;
case 'approve':
$iret = '0';
if (!current_user_can('wppa_moderate') && !current_user_can('wppa_comments')) {
_e('You do not have the rights to moderate photos this way', 'wp-photo-album-plus');
wppa_exit();
}
if (isset($_REQUEST['photo-id']) && current_user_can('wppa_moderate')) {
$iret = $wpdb->query($wpdb->prepare("UPDATE `" . WPPA_PHOTOS . "` SET `status` = 'publish' WHERE `id` = %s", $_REQUEST['photo-id']));
wppa_flush_upldr_cache('photoid', $_REQUEST['photo-id']);
$alb = $wpdb->get_var($wpdb->prepare("SELECT `album` FROM `" . WPPA_PHOTOS . "` WHERE `id` = %s", $_REQUEST['photo-id']));
wppa_clear_taglist();
wppa_flush_treecounts($alb);
}
if (isset($_REQUEST['comment-id'])) {
$iret = $wpdb->query($wpdb->prepare("UPDATE `" . WPPA_COMMENTS . "` SET `status` = 'approved' WHERE `id` = %s", $_REQUEST['comment-id']));
}
if ($iret) {
echo 'OK';
} else {
if (isset($_REQUEST['photo-id'])) {
if (current_user_can('wppa_moderate')) {
echo sprintf(__('Failed to update stutus of photo %s', 'wp-photo-album-plus'), $_REQUEST['photo-id']) . "\n" . __('Please refresh the page', 'wp-photo-album-plus');
} else {
_e('Security check failure', 'wp-photo-album-plus');
}
}
if (isset($_REQUEST['comment-id'])) {
echo sprintf(__('Failed to update stutus of comment %s', 'wp-photo-album-plus'), $_REQUEST['comment-id']) . "\n" . __('Please refresh the page', 'wp-photo-album-plus');
}
}
wppa_exit();
case 'remove':
if (isset($_REQUEST['photo-id'])) {
// Remove photo
if (wppa_user_is('administrator') || current_user_can('wppa_moderate') || wppa_get_user() == wppa_get_photo_owner($_REQUEST['photo-id']) && wppa_switch('upload_edit')) {
// Frontend delete?
wppa_delete_photo($_REQUEST['photo-id']);
echo 'OK||' . __('Photo removed', 'wp-photo-album-plus');
wppa_exit();
}
}
if (!current_user_can('wppa_moderate') && !current_user_can('wppa_comments')) {
_e('You do not have the rights to moderate photos this way', 'wp-photo-album-plus');
wppa_exit();
}
if (isset($_REQUEST['photo-id'])) {
// Remove photo
if (!current_user_can('wppa_moderate')) {
_e('Security check failure', 'wp-photo-album-plus');
wppa_exit();
}
wppa_delete_photo($_REQUEST['photo-id']);
echo 'OK||' . __('Photo removed', 'wp-photo-album-plus');
wppa_exit();
}
if (isset($_REQUEST['comment-id'])) {
// Remove comment
$iret = $wpdb->query($wpdb->prepare("DELETE FROM `" . WPPA_COMMENTS . "` WHERE `id`= %s", $_REQUEST['comment-id']));
if ($iret) {
echo 'OK||' . __('Comment removed', 'wp-photo-album-plus');
} else {
_e('Could not remove comment', 'wp-photo-album-plus');
}
wppa_exit();
}
_e('Unexpected error', 'wp-photo-album-plus');
wppa_exit();
case 'downloadalbum':
// Feature enabled?
if (!wppa_switch('allow_download_album')) {
echo '||ER||' . __('This feature is not enabled on this website', 'wp-photo-album-plus');
wppa_exit();
}
// Validate args
$alb = $_REQUEST['album-id'];
$status = "`status` <> 'pending' AND `status` <> 'scheduled'";
if (!is_user_logged_in()) {
$status .= " AND `status` <> 'private'";
}
$photos = $wpdb->get_results($wpdb->prepare("SELECT * FROM `" . WPPA_PHOTOS . "` WHERE `album` = %s AND ( ( " . $status . " ) OR owner = %s ) " . wppa_get_photo_order($alb), $alb, wppa_get_user()), ARRAY_A);
if (!$photos) {
echo '||ER||' . __('The album is empty', 'wp-photo-album-plus');
wppa_exit();
}
// Remove obsolete files
wppa_delete_obsolete_tempfiles();
// Open zipfile
if (!class_exists('ZipArchive')) {
echo '||ER||' . __('Unable to create zip archive', 'wp-photo-album-plus');
wppa_exit();
}
$zipfilename = wppa_get_album_name($alb);
$zipfilename = wppa_sanitize_file_name($zipfilename . '.zip');
// Remove illegal chars
$zipfilepath = WPPA_UPLOAD_PATH . '/temp/' . $zipfilename;
if (is_file($zipfilepath)) {
// unlink( $zipfilepath ); // Debug
}
$wppa_zip = new ZipArchive();
$iret = $wppa_zip->open($zipfilepath, 1);
if ($iret !== true) {
echo '||ER||' . sprintf(__('Unable to create zip archive. code = %s', 'wp-photo-album-plus'), $iret);
wppa_exit();
}
// Add photos to zip
$stop = false;
foreach ($photos as $p) {
if (wppa_is_time_up()) {
wppa_log('obs', 'Time up during album to zip creation');
$stop = true;
} else {
$id = $p['id'];
if (!wppa_is_multi($id)) {
$source = wppa_switch('download_album_source') && is_file(wppa_get_source_path($id)) ? wppa_get_source_path($id) : wppa_get_photo_path($id);
if (is_file($source)) {
$dest = $p['filename'] ? wppa_sanitize_file_name($p['filename']) : wppa_sanitize_file_name(wppa_strip_ext($p['name']) . '.' . $p['ext']);
$dest = wppa_fix_poster_ext($dest, $id);
$iret = $wppa_zip->addFile($source, $dest);
// To prevent too may files open, and to have at least a file when there are too many photos, close and re-open
$wppa_zip->close();
$wppa_zip->open($zipfilepath);
// wppa_log( 'dbg', 'Added ' . basename($source) . ' to ' . basename($zipfilepath));
}
}
}
if ($stop) {
break;
}
}
// Close zip and return
$zipcount = $wppa_zip->numFiles;
$wppa_zip->close();
// A zip is created
$desturl = WPPA_UPLOAD_URL . '/temp/' . $zipfilename;
echo $desturl . '||OK||';
if ($zipcount != count($photos)) {
echo sprintf(__('Only %s out of %s photos could be added to the zipfile', 'wp-photo-album-plus'), $zipcount, count($photos));
}
wppa_exit();
break;
case 'getalbumzipurl':
$alb = $_REQUEST['album-id'];
$zipfilename = wppa_get_album_name($alb);
$zipfilename = wppa_sanitize_file_name($zipfilename . '.zip');
// Remove illegal chars
$zipfilepath = WPPA_UPLOAD_PATH . '/temp/' . $zipfilename;
$zipfileurl = WPPA_UPLOAD_URL . '/temp/' . $zipfilename;
if (is_file($zipfilepath)) {
echo $zipfileurl;
} else {
echo 'ER';
}
wppa_exit();
break;
case 'makeorigname':
$photo = $_REQUEST['photo-id'];
$from = $_REQUEST['from'];
if ($from == 'fsname') {
$type = wppa_opt('art_monkey_link');
} elseif ($from == 'popup') {
$type = wppa_opt('art_monkey_popup_link');
} else {
echo '||7||' . __('Unknown source of request', 'wp-photo-album-plus');
wppa_exit();
}
$data = $wpdb->get_row($wpdb->prepare("SELECT * FROM `" . WPPA_PHOTOS . "` WHERE `id` = %s", $photo), ARRAY_A);
if ($data) {
// The photo is supposed to exist
// Make the name
if ($data['filename']) {
$name = $data['filename'];
} else {
$name = __($data['name'], 'wp-photo-album-plus');
}
$name = wppa_sanitize_file_name($name);
// Remove illegal chars
$name = preg_replace('/\\.[^.]*$/', '', $name);
// Remove file extension
if (strlen($name) == '0') {
echo '||1||' . __('Empty filename', 'wp-photo-album-plus');
wppa_exit();
}
// Make the file
if (wppa_switch('artmonkey_use_source')) {
if (is_file(wppa_get_source_path($photo))) {
$source = wppa_get_source_path($photo);
} else {
$source = wppa_get_photo_path($photo);
}
} else {
$source = wppa_get_photo_path($photo);
}
$source = wppa_fix_poster_ext($source, $photo);
// Fix the extension for mm items.
if ($data['ext'] == 'xxx') {
$data['ext'] = wppa_get_ext($source);
}
$dest = WPPA_UPLOAD_PATH . '/temp/' . $name . '.' . $data['ext'];
$zipfile = WPPA_UPLOAD_PATH . '/temp/' . $name . '.zip';
$tempdir = WPPA_UPLOAD_PATH . '/temp';
if (!is_dir($tempdir)) {
@mkdir($tempdir);
}
if (!is_dir($tempdir)) {
echo '||2||' . __('Unable to create tempdir', 'wp-photo-album-plus');
wppa_exit();
}
// Remove obsolete files
wppa_delete_obsolete_tempfiles();
// Make the files
if ($type == 'file') {
copy($source, $dest);
$ext = $data['ext'];
} elseif ($type == 'zip') {
if (!class_exists('ZipArchive')) {
echo '||8||' . __('Unable to create zip archive', 'wp-photo-album-plus');
wppa_exit();
}
$ext = 'zip';
$wppa_zip = new ZipArchive();
$wppa_zip->open($zipfile, 1);
$wppa_zip->addFile($source, basename($dest));
$wppa_zip->close();
} else {
echo '||6||' . __('Unknown type', 'wp-photo-album-plus');
wppa_exit();
}
$desturl = WPPA_UPLOAD_URL . '/temp/' . $name . '.' . $ext;
echo '||0||' . $desturl;
// No error: return url
wppa_exit();
} else {
echo '||9||' . __('The photo does no longer exist', 'wp-photo-album-plus');
wppa_exit();
}
wppa_exit();
break;
case 'tinymcedialog':
$result = wppa_make_tinymce_dialog();
echo $result;
wppa_exit();
break;
case 'bumpviewcount':
$nonce = $_REQUEST['wppa-nonce'];
if (wp_verify_nonce($nonce, 'wppa-check')) {
wppa_bump_viewcount('photo', $_REQUEST['wppa-photo']);
} else {
_e('Security check failure', 'wp-photo-album-plus');
}
wppa_exit();
break;
case 'rate':
// Get commandline args
$photo = $_REQUEST['wppa-rating-id'];
$rating = $_REQUEST['wppa-rating'];
$occur = $_REQUEST['wppa-occur'];
$index = $_REQUEST['wppa-index'];
$nonce = $_REQUEST['wppa-nonce'];
// Make errortext
$errtxt = __('An error occurred while processing you rating request.', 'wp-photo-album-plus');
$errtxt .= "\n" . __('Maybe you opened the page too long ago to recognize you.', 'wp-photo-album-plus');
$errtxt .= "\n" . __('You may refresh the page and try again.', 'wp-photo-album-plus');
$wartxt = __('Althoug an error occurred while processing your rating, your vote has been registered.', 'wp-photo-album-plus');
$wartxt .= "\n" . __('However, this may not be reflected in the current pageview', 'wp-photo-album-plus');
// Check on validity
if (!wp_verify_nonce($nonce, 'wppa-check')) {
echo '0||100||' . $errtxt;
wppa_exit();
// Nonce check failed
}
if (wppa_opt('rating_max') == '1' && $rating != '1') {
echo '0||106||' . $errtxt . ':' . $rating;
wppa_exit();
// Value out of range
} elseif (wppa_opt('rating_max') == '5' && !in_array($rating, array('-1', '1', '2', '3', '4', '5'))) {
echo '0||106||' . $errtxt . ':' . $rating;
wppa_exit();
// Value out of range
} elseif (wppa_opt('rating_max') == '10' && !in_array($rating, array('-1', '1', '2', '3', '4', '5', '6', '7', '8', '9', '10'))) {
echo '0||106||' . $errtxt . ':' . $rating;
wppa_exit();
// Value out of range
}
// Get other data
if (!$wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM `" . WPPA_PHOTOS . "` WHERE `id` = %s", $photo))) {
echo '0||999||' . __('Photo has been removed.', 'wp-photo-album-plus');
wppa_exit();
}
$user = wppa_get_user();
$mylast = $wpdb->get_row($wpdb->prepare('SELECT * FROM `' . WPPA_RATING . '` WHERE `photo` = %s AND `user` = %s ORDER BY `id` DESC LIMIT 1', $photo, $user), ARRAY_A);
$myavgrat = '0';
// Init
// Rate own photo?
if (wppa_get_photo_item($photo, 'owner') == $user && !wppa_switch('allow_owner_votes')) {
echo '0||900||' . __('Sorry, you can not rate your own photos', 'wp-photo-album-plus');
wppa_exit();
}
// Already a pending one?
$pending = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM `" . WPPA_RATING . "` WHERE `photo` = %s AND `user` = %s AND `status` = %s", $photo, $user, 'pending'));
// Has user motivated his vote?
$hascommented = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM `" . WPPA_COMMENTS . "` WHERE `photo` = %s AND `user` = %s", $photo, wppa_get_user('display')));
if ($pending) {
if (!$hascommented) {
echo '0||900||' . __('Please enter a comment.', 'wp-photo-album-plus');
wppa_exit();
} else {
$wpdb->query($wpdb->prepare("UPDATE `" . WPPA_RATING . "` SET `status` = 'publish' WHERE `photo` = %s AND `user` = %s", $photo, $user));
}
}
if (wppa_switch('vote_needs_comment')) {
$ratingstatus = $hascommented ? 'publish' : 'pending';
} else {
$ratingstatus = 'publish';
}
// When done, we have to echo $occur.'||'.$photo.'||'.$index.'||'.$myavgrat.'||'.$allavgrat.'||'.$discount.||.$hascommented.||.$message;
// So we have to do: process rating and find new $myavgrat, $allavgrat and $discount ( $occur, $photo and $index are known )
// Case 0: Illegal second vote. Frontend takes care of this, but a hacker could enter an ajaxlink manually
if ($mylast && (!(wppa_switch('rating_change') || wppa_switch('rating_multi')) || $mylast['value'] < '0' || $mylast['value'] > '0' && $rating == '-1')) {
echo '0||109||' . __('Security check failure.', 'wp-photo-album-plus');
wppa_exit();
}
// Case 1: value = -1 this is a legal dislike vote
if ($rating == '-1') {
// Add my dislike
$iret = wppa_create_rating_entry(array('photo' => $photo, 'value' => $rating, 'user' => $user, 'status' => $ratingstatus));
if (!$iret) {
echo '0||101||' . $errtxt;
wppa_exit();
// Fail on storing vote
}
// Add points
wppa_add_credit_points(wppa_opt('cp_points_rating'), __('Photo rated', 'wp-photo-album-plus'), $photo, $rating);
wppa_dislike_check($photo);
// Check for email to be sent every .. dislikes
if (!is_file(wppa_get_thumb_path($photo))) {
// Photo is removed
echo $occur . '||' . $photo . '||' . $index . '||-1||-1|0||' . wppa_opt('dislike_delete');
wppa_exit();
}
} elseif (!$mylast) {
// Add my vote
$iret = wppa_create_rating_entry(array('photo' => $photo, 'value' => $rating, 'user' => $user, 'status' => $ratingstatus));
if (!$iret) {
echo '0||102||' . $errtxt;
wppa_exit();
// Fail on storing vote
}
// Add points
wppa_add_credit_points(wppa_opt('cp_points_rating'), __('Photo rated', 'wp-photo-album-plus'), $photo, $rating);
} elseif (wppa_switch('rating_change')) {
// Votechanging is allowed
$iret = $wpdb->query($wpdb->prepare('UPDATE `' . WPPA_RATING . '` SET `value` = %s WHERE `photo` = %s AND `user` = %s LIMIT 1', $rating, $photo, $user));
if ($iret === false) {
echo '0||103||' . $errtxt;
wppa_exit();
// Fail on update
}
} elseif (wppa_switch('rating_multi')) {
// Rating multi is allowed
$iret = wppa_create_rating_entry(array('photo' => $photo, 'value' => $rating, 'user' => $user, 'status' => $ratingstatus));
if (!$iret) {
echo '0||104||' . $errtxt;
wppa_exit();
// Fail on storing vote
}
} else {
// Should never get here....
echo '0||110||' . __('Unexpected error', 'wp-photo-album-plus');
wppa_exit();
}
// Compute my avg rating
$myrats = $wpdb->get_results($wpdb->prepare('SELECT * FROM `' . WPPA_RATING . '` WHERE `photo` = %s AND `user` = %s AND `status` = %s ', $photo, $user, 'publish'), ARRAY_A);
if ($myrats) {
$sum = 0;
$cnt = 0;
foreach ($myrats as $rat) {
if ($rat['value'] == '-1') {
$sum += wppa_opt('dislike_value');
} else {
$sum += $rat['value'];
}
$cnt++;
}
$myavgrat = $sum / $cnt;
$i = wppa_opt('rating_prec');
$j = $i + '1';
$myavgrat = sprintf('%' . $j . '.' . $i . 'f', $myavgrat);
} else {
$myavgrat = '0';
}
// Compute new allavgrat
$ratings = $wpdb->get_results($wpdb->prepare('SELECT * FROM ' . WPPA_RATING . ' WHERE `photo` = %s AND `status` = %s', $photo, 'publish'), ARRAY_A);
if ($ratings) {
$sum = 0;
$cnt = 0;
foreach ($ratings as $rat) {
if ($rat['value'] == '-1') {
$sum += wppa_opt('dislike_value');
} else {
$sum += $rat['value'];
}
$cnt++;
}
$allavgrat = $sum / $cnt;
if ($allavgrat == '10') {
$allavgrat = '9.99999999';
}
// For sort order reasons text field
} else {
$allavgrat = '0';
}
// Store it in the photo info
$iret = $wpdb->query($wpdb->prepare('UPDATE `' . WPPA_PHOTOS . '` SET `mean_rating` = %s WHERE `id` = %s', $allavgrat, $photo));
if ($iret === false) {
echo '0||106||' . $wartxt;
wppa_exit();
// Fail on save
}
// Compute rating_count and store in the photo info
$ratcount = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM `" . WPPA_RATING . "` WHERE `photo` = %s", $photo));
if ($ratcount !== false) {
$iret = $wpdb->query($wpdb->prepare("UPDATE `" . WPPA_PHOTOS . "` SET `rating_count` = %s WHERE `id` = %s", $ratcount, $photo));
if ($iret === false) {
echo '0||107||' . $wartxt;
wppa_exit();
// Fail on save
}
}
// Format $allavgrat for output
$allavgratcombi = $allavgrat . '|' . $ratcount;
// Compute dsilike count
$discount = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM `" . WPPA_RATING . "` WHERE `photo` = %s AND `value` = -1 AND `status` = %s", $photo, 'publish'));
if ($discount === false) {
echo '0||108||' . $wartxt;
wppa_exit();
// Fail on save
}
// Test for possible medal
wppa_test_for_medal($photo);
// Success!
wppa_clear_cache();
if (wppa_switch('vote_needs_comment') && !$hascommented) {
$message = __("Please explain your vote in a comment.\nYour vote will be discarded if you don't.\n\nAfter completing your comment,\nyou can refresh the page to see\nyour vote became effective.", 'wp-photo-album-plus');
} else {
$message = '';
}
echo $occur . '||' . $photo . '||' . $index . '||' . $myavgrat . '||' . $allavgratcombi . '||' . $discount . '||' . $hascommented . '||' . $message;
break;
case 'render':
$tim_1 = microtime(true);
$nq_1 = get_num_queries();
// Correct the fact that this is a non-admin operation, if it is
if (is_admin()) {
require_once 'wppa-non-admin.php';
}
wppa_load_theme();
// Register geo shortcode if google-maps-gpx-vieuwer is on board. GPX does it in wp_head(), what is not done in an ajax call
// if ( function_exists( 'gmapv3' ) ) add_shortcode( 'map', 'gmapv3' );
// Get the post we are working for
if (isset($_REQUEST['wppa-fromp'])) {
$p = $_REQUEST['wppa-fromp'];
if (wppa_is_int($p)) {
$GLOBALS['post'] = get_post($p);
}
}
// Render
echo wppa_albums();
$tim_2 = microtime(true);
$nq_2 = get_num_queries();
$mem = memory_get_peak_usage(true) / 1024 / 1024;
$msg = sprintf('WPPA Ajax render: db queries: WP:%d, WPPA+: %d in %4.2f seconds, using %4.2f MB memory max', $nq_1, $nq_2 - $nq_1, $tim_2 - $tim_1, $mem);
echo '<script type="text/javascript">wppaConsoleLog( \'' . $msg . '\', \'force\' )</script>';
break;
case 'delete-photo':
$photo = $_REQUEST['photo-id'];
$nonce = $_REQUEST['wppa-nonce'];
// Check validity
if (!wp_verify_nonce($nonce, 'wppa_nonce_' . $photo)) {
echo '||0||' . __('You do not have the rights to delete a photo', 'wp-photo-album-plus');
wppa_exit();
// Nonce check failed
}
if (!is_numeric($photo)) {
echo '||0||' . __('Security check failure', 'wp-photo-album-plus');
wppa_exit();
// Nonce check failed
}
$album = $wpdb->get_var($wpdb->prepare('SELECT `album` FROM `' . WPPA_PHOTOS . '` WHERE `id` = %s', $photo));
wppa_delete_photo($photo);
wppa_clear_cache();
echo '||1||<span style="color:red" >' . sprintf(__('Photo %s has been deleted', 'wp-photo-album-plus'), $photo) . '</span>';
echo '||';
$a = wppa_allow_uploads($album);
if (!$a) {
echo 'full';
} else {
echo 'notfull||' . $a;
}
break;
case 'update-album':
$album = $_REQUEST['album-id'];
$nonce = $_REQUEST['wppa-nonce'];
$item = $_REQUEST['item'];
$value = $_REQUEST['value'];
$value = wppa_decode($value);
// Check validity
if (!wp_verify_nonce($nonce, 'wppa_nonce_' . $album)) {
echo '||0||' . __('You do not have the rights to update album information', 'wp-photo-album-plus') . $nonce;
wppa_exit();
// Nonce check failed
}
switch ($item) {
case 'clear_ratings':
$photos = $wpdb->get_results($wpdb->prepare('SELECT * FROM `' . WPPA_PHOTOS . '` WHERE `album` = %s', $album), ARRAY_A);
if ($photos) {
foreach ($photos as $photo) {
$iret1 = $wpdb->query($wpdb->prepare('DELETE FROM `' . WPPA_RATING . '` WHERE `photo` = %s', $photo['id']));
$iret2 = $wpdb->query($wpdb->prepare('UPDATE `' . WPPA_PHOTOS . '` SET `mean_rating` = %s WHERE `id` = %s', '', $photo['id']));
}
}
if ($photos && $iret1 !== false && $iret2 !== false) {
echo '||97||' . __('<b>Ratings cleared</b>', 'wp-photo-album-plus') . '||' . __('No ratings for this photo.', 'wp-photo-album-plus');
} elseif ($photos) {
echo '||1||' . __('An error occurred while clearing ratings', 'wp-photo-album-plus');
} else {
echo '||97||' . __('<b>No photos in this album</b>', 'wp-photo-album-plus') . '||' . __('No ratings for this photo.', 'wp-photo-album-plus');
}
wppa_exit();
break;
case 'set_deftags':
// to be changed for large albums
$photos = $wpdb->get_results($wpdb->prepare('SELECT * FROM `' . WPPA_PHOTOS . '` WHERE `album` = %s', $album), ARRAY_A);
$deftag = $wpdb->get_var($wpdb->prepare('SELECT `default_tags` FROM `' . WPPA_ALBUMS . '` WHERE `id` = %s', $album));
if (is_array($photos)) {
foreach ($photos as $photo) {
$tags = wppa_sanitize_tags(wppa_filter_iptc(wppa_filter_exif($deftag, $photo['id']), $photo['id']));
$iret = $wpdb->query($wpdb->prepare('UPDATE `' . WPPA_PHOTOS . '` SET `tags` = %s WHERE `id` = %s', $tags, $photo['id']));
wppa_index_update('photo', $photo['id']);
}
}
if ($photos && $iret !== false) {
echo '||97||' . __('<b>Tags set to defaults</b> (reload)', 'wp-photo-album-plus');
} elseif ($photos) {
echo '||1||' . __('An error occurred while setting tags', 'wp-photo-album-plus');
} else {
echo '||97||' . __('<b>No photos in this album</b>', 'wp-photo-album-plus');
}
wppa_clear_taglist();
wppa_exit();
break;
case 'add_deftags':
$photos = $wpdb->get_results($wpdb->prepare('SELECT * FROM `' . WPPA_PHOTOS . '` WHERE `album` = %s', $album), ARRAY_A);
$deftag = $wpdb->get_var($wpdb->prepare('SELECT `default_tags` FROM `' . WPPA_ALBUMS . '` WHERE `id` = %s', $album));
if (is_array($photos)) {
foreach ($photos as $photo) {
$tags = wppa_sanitize_tags(wppa_filter_iptc(wppa_filter_exif($photo['tags'] . ',' . $deftag, $photo['id']), $photo['id']));
$iret = $wpdb->query($wpdb->prepare('UPDATE `' . WPPA_PHOTOS . '` SET `tags` = %s WHERE `id` = %s', $tags, $photo['id']));
wppa_index_update('photo', $photo['id']);
}
}
if ($photos && $iret !== false) {
echo '||97||' . __('<b>Tags added width defaults</b> (reload)', 'wp-photo-album-plus');
} elseif ($photos) {
echo '||1||' . __('An error occurred while adding tags', 'wp-photo-album-plus');
} else {
echo '||97||' . __('<b>No photos in this album</b>', 'wp-photo-album-plus');
}
wppa_clear_taglist();
wppa_exit();
break;
case 'name':
$value = trim(strip_tags($value));
if (!wppa_sanitize_file_name($value)) {
// Empty album name is not allowed
$value = 'Album-#' . $album;
echo '||5||' . sprintf(__('Album name may not be empty.<br />Reset to <b>%s</b>', 'wp-photo-album-plus'), $value);
}
$itemname = __('Name', 'wp-photo-album-plus');
break;
case 'description':
$itemname = __('Description', 'wp-photo-album-plus');
if (wppa_switch('check_balance')) {
$value = str_replace(array('<br/>', '<br>'), '<br />', $value);
if (balanceTags($value, true) != $value) {
echo '||3||' . __('Unbalanced tags in album description!', 'wp-photo-album-plus');
wppa_exit();
}
}
$value = trim($value);
break;
case 'a_order':
$itemname = __('Album order #', 'wp-photo-album-plus');
break;
case 'main_photo':
$itemname = __('Cover photo', 'wp-photo-album-plus');
break;
case 'a_parent':
$itemname = __('Parent album', 'wp-photo-album-plus');
wppa_flush_treecounts($album);
// Myself and my parents
wppa_flush_treecounts($value);
// My new parent
break;
case 'p_order_by':
$itemname = __('Photo order', 'wp-photo-album-plus');
break;
case 'alt_thumbsize':
$itemname = __('Use Alt thumbsize', 'wp-photo-album-plus');
break;
case 'cover_type':
$itemname = __('Cover Type', 'wp-photo-album-plus');
break;
case 'cover_linktype':
$itemname = __('Link type', 'wp-photo-album-plus');
break;
case 'cover_linkpage':
$itemname = __('Link to', 'wp-photo-album-plus');
break;
case 'owner':
$itemname = __('Owner', 'wp-photo-album-plus');
if ($value != '--- public ---' && !get_user_by('login', $value)) {
echo '||4||' . sprintf(__('User %s does not exist', 'wp-photo-album-plus'), $value);
wppa_exit();
}
break;
case 'upload_limit_count':
wppa_ajax_check_range($value, false, '0', false, __('Upload limit count', 'wp-photo-album-plus'));
if (wppa('error')) {
wppa_exit();
}
$oldval = $wpdb->get_var($wpdb->prepare('SELECT `upload_limit` FROM ' . WPPA_ALBUMS . ' WHERE `id` = %s', $album));
$temp = explode('/', $oldval);
$value = $value . '/' . $temp[1];
$item = 'upload_limit';
$itemname = __('Upload limit count', 'wp-photo-album-plus');
break;
case 'upload_limit_time':
$oldval = $wpdb->get_var($wpdb->prepare('SELECT `upload_limit` FROM ' . WPPA_ALBUMS . ' WHERE `id` = %s', $album));
$temp = explode('/', $oldval);
$value = $temp[0] . '/' . $value;
$item = 'upload_limit';
$itemname = __('Upload limit time', 'wp-photo-album-plus');
break;
case 'default_tags':
$value = wppa_sanitize_tags($value, false, true);
$itemname = __('Default tags', 'wp-photo-album-plus');
break;
case 'cats':
$value = wppa_sanitize_cats($value);
wppa_clear_catlist();
$itemname = __('Categories', 'wp-photo-album-plus');
break;
case 'suba_order_by':
$itemname = __('Sub albums sort order', 'wp-photo-album-plus');
break;
case 'year':
case 'month':
case 'day':
case 'hour':
case 'min':
$itemname = __('Schedule date/time', 'wp-photo-album-plus');
$scheduledtm = $wpdb->get_var($wpdb->prepare("SELECT `scheduledtm` FROM`" . WPPA_ALBUMS . "` WHERE `id` = %s", $album));
if (!$scheduledtm) {
$scheduledtm = wppa_get_default_scheduledtm();
}
$temp = explode(',', $scheduledtm);
if ($item == 'year') {
$temp[0] = $value;
}
if ($item == 'month') {
$temp[1] = $value;
}
if ($item == 'day') {
$temp[2] = $value;
}
if ($item == 'hour') {
$temp[3] = $value;
}
if ($item == 'min') {
$temp[4] = $value;
}
$scheduledtm = implode(',', $temp);
wppa_update_album(array('id' => $album, 'scheduledtm' => $scheduledtm));
echo '||0||' . sprintf(__('<b>%s</b> of album %s updated', 'wp-photo-album-plus'), $itemname, $album);
wppa_exit();
break;
case 'setallscheduled':
$scheduledtm = $wpdb->get_var($wpdb->prepare("SELECT `scheduledtm` FROM `" . WPPA_ALBUMS . "` WHERE `id` = %s", $album));
if ($scheduledtm) {
$iret = $wpdb->query($wpdb->prepare("UPDATE `" . WPPA_PHOTOS . "` SET `status` = 'scheduled', `scheduledtm` = %s WHERE `album` = %s", $scheduledtm, $album));
echo '||0||' . __('All photos set to scheduled per date', 'wp-photo-album-plus') . ' ( ' . $iret . ' ) ' . wppa_format_scheduledtm($scheduledtm);
}
wppa_exit();
break;
default:
$itemname = $item;
}
$query = $wpdb->prepare('UPDATE ' . WPPA_ALBUMS . ' SET `' . $item . '` = %s WHERE `id` = %s', $value, $album);
$iret = $wpdb->query($query);
if ($iret !== false) {
if ($item == 'name' || $item == 'description' || $item == 'cats') {
wppa_index_update('album', $album);
}
if ($item == 'name') {
wppa_create_pl_htaccess();
}
echo '||0||' . sprintf(__('<b>%s</b> of album %s updated', 'wp-photo-album-plus'), $itemname, $album);
if ($item == 'upload_limit') {
echo '||';
$a = wppa_allow_uploads($album);
if (!$a) {
echo 'full';
} else {
echo 'notfull||' . $a;
}
}
} else {
echo '||2||' . sprintf(__('An error occurred while trying to update <b>%s</b> of album %s', 'wp-photo-album-plus'), $itemname, $album);
echo '<br>' . __('Press CTRL+F5 and try again.', 'wp-photo-album-plus');
}
wppa_clear_cache();
wppa_exit();
break;
case 'update-comment-status':
$photo = $_REQUEST['wppa-photo-id'];
$nonce = $_REQUEST['wppa-nonce'];
$comid = $_REQUEST['wppa-comment-id'];
$comstat = $_REQUEST['wppa-comment-status'];
// Check validity
if (!wp_verify_nonce($nonce, 'wppa_nonce_' . $photo)) {
echo '||0||' . __('You do not have the rights to update comment status', 'wp-photo-album-plus') . $nonce;
wppa_exit();
// Nonce check failed
}
// if ( wppa_switch( 'search_comments' ) ) wppa_index_remove( 'photo', $photo );
$iret = $wpdb->query($wpdb->prepare('UPDATE `' . WPPA_COMMENTS . '` SET `status` = %s WHERE `id` = %s', $comstat, $comid));
if (wppa_switch('search_comments')) {
wppa_index_update('photo', $photo);
}
if ($iret !== false) {
echo '||0||' . sprintf(__('Status of comment #%s updated', 'wp-photo-album-plus'), $comid);
} else {
echo '||1||' . sprintf(__('Error updating status comment #%s', 'wp-photo-album-plus'), $comid);
}
wppa_exit();
break;
case 'watermark-photo':
$photo = $_REQUEST['photo-id'];
$nonce = $_REQUEST['wppa-nonce'];
// Check validity
if (!wp_verify_nonce($nonce, 'wppa_nonce_' . $photo)) {
echo '||1||' . __('You do not have the rights to change photos', 'wp-photo-album-plus');
wppa_exit();
// Nonce check failed
}
wppa_cache_thumb($photo);
if (wppa_add_watermark($photo)) {
if (wppa_switch('watermark_thumbs')) {
wppa_create_thumbnail($photo);
// create new thumb
}
echo '||0||' . __('Watermark applied', 'wp-photo-album-plus');
wppa_exit();
} else {
echo '||1||' . __('An error occured while trying to apply a watermark', 'wp-photo-album-plus');
wppa_exit();
}
case 'update-photo':
$photo = $_REQUEST['photo-id'];
$nonce = $_REQUEST['wppa-nonce'];
$item = $_REQUEST['item'];
$value = isset($_REQUEST['value']) ? $_REQUEST['value'] : '';
$value = wppa_decode($value);
// Check validity
if (!wp_verify_nonce($nonce, 'wppa_nonce_' . $photo)) {
echo '||0||' . __('You do not have the rights to update photo information', 'wp-photo-album-plus');
wppa_exit();
// Nonce check failed
}
if (substr($item, 0, 20) == 'wppa_watermark_file_' || substr($item, 0, 19) == 'wppa_watermark_pos_') {
wppa_update_option($item, $value);
echo '||0||' . sprintf(__('%s updated to %s.', 'wp-photo-album-plus'), $item, $value);
wppa_exit();
}
switch ($item) {
case 'exifdtm':
$format = '0000:00:00 00:00:00';
$err = '0';
// Length ok?
if (strlen($value) != 19) {
$err = '1';
}
// Check on digits, colons and space
for ($i = 0; $i < 19; $i++) {
$d = substr($value, $i, 1);
$f = substr($format, $i, 1);
switch ($f) {
case '0':
if (!in_array($d, array('0', '1', '2', '3', '4', '5', '6', '7', '8', '9'))) {
$err = '2';
}
break;
case ':':
case ' ':
if ($d != $f) {
$err = '3';
}
break;
}
}
// Check on values if format correct, report first error only
if (!$err) {
$temp = explode(':', str_replace(' ', ':', $value));
if ($temp['0'] < '1970') {
$err = '11';
}
// Before UNIX epoch
if (!$err && $temp['0'] > date('Y')) {
$err = '12';
}
// Future
if (!$err && $temp['1'] < '1') {
$err = '13';
}
// Before january
if (!$err && $temp['1'] > '12') {
$err = '14';
}
// After december
if (!$err && $temp['2'] < '1') {
$err = '15';
}
// Before first of month
if (!$err && $temp['2'] > '31') {
$err = '17';
}
// After 31st ( forget about feb and months with 30 days )
if (!$err && $temp['3'] < '1') {
$err = '18';
}
// Before first hour
if (!$err && $temp['3'] > '24') {
$err = '19';
}
// Hour > 24
if (!$err && $temp['4'] < '1') {
$err = '20';
}
// Min < 1
if (!$err && $temp['4'] > '59') {
$err = '21';
}
// Min > 59
if (!$err && $temp['5'] < '1') {
$err = '22';
}
// Sec < 1
if (!$err && $temp['5'] > '59') {
$err = '23';
}
// Sec > 59
}
if ($err) {
echo '||1||' . sprintf(__('Format error %s. Must be yyyy:mm:dd hh:mm:ss', 'wp-photo-album-plus'), $err);
} else {
wppa_update_photo(array('id' => $photo, 'exifdtm' => $value));
echo '||0||' . __('Exif date/time updated', 'wp-photo-album-plus');
}
wppa_exit();
break;
case 'lat':
if (!is_numeric($value) || $value < '-90.0' || $value > '90.0') {
echo '||1||' . __('Enter a value > -90 and < 90', 'wp-photo-album-plus');
wppa_exit();
}
$photodata = $wpdb->get_row($wpdb->prepare('SELECT * FROM ' . WPPA_PHOTOS . ' WHERE `id` = %s', $photo), ARRAY_A);
$geo = $photodata['location'] ? $photodata['location'] : '///';
$geo = explode('/', $geo);
$geo = wppa_format_geo($value, $geo['3']);
$iret = $wpdb->query($wpdb->prepare('UPDATE `' . WPPA_PHOTOS . '` SET `location` = %s WHERE `id` = %s', $geo, $photo));
if ($iret) {
echo '||0||' . __('Lattitude updated', 'wp-photo-album-plus');
} else {
echo '||1||' . __('Could not update lattitude', 'wp-photo-album-plus');
}
wppa_exit();
break;
case 'lon':
if (!is_numeric($value) || $value < '-180.0' || $value > '180.0') {
echo '||1||' . __('Enter a value > -180 and < 180', 'wp-photo-album-plus');
wppa_exit();
}
$photodata = $wpdb->get_row($wpdb->prepare('SELECT * FROM ' . WPPA_PHOTOS . ' WHERE `id` = %s', $photo), ARRAY_A);
$geo = $photodata['location'] ? $photodata['location'] : '///';
$geo = explode('/', $geo);
$geo = wppa_format_geo($geo['2'], $value);
$iret = $wpdb->query($wpdb->prepare('UPDATE `' . WPPA_PHOTOS . '` SET `location` = %s WHERE `id` = %s', $geo, $photo));
if ($iret) {
echo '||0||' . __('Longitude updated', 'wp-photo-album-plus');
} else {
echo '||1||' . __('Could not update longitude', 'wp-photo-album-plus');
}
wppa_exit();
break;
case 'remake':
if (wppa_remake_files('', $photo)) {
wppa_bump_photo_rev();
wppa_bump_thumb_rev();
echo '||0||' . __('Photo files remade', 'wp-photo-album-plus');
} else {
echo '||2||' . __('Could not remake files', 'wp-photo-album-plus');
}
wppa_exit();
break;
case 'remakethumb':
if (wppa_create_thumbnail($photo)) {
echo '||0||' . __('Thumbnail remade', 'wp-photo-album-plus');
} else {
echo '||0||' . __('Could not remake thumbnail', 'wp-photo-album-plus');
}
wppa_exit();
break;
case 'rotright':
case 'rot180':
case 'rotleft':
switch ($item) {
case 'rotleft':
$angle = '90';
$dir = __('left', 'wp-photo-album-plus');
break;
case 'rot180':
$angle = '180';
$dir = __('180°', 'wp-photo-album-plus');
break;
case 'rotright':
$angle = '270';
$dir = __('right', 'wp-photo-album-plus');
break;
}
wppa('error', wppa_rotate($photo, $angle));
if (!wppa('error')) {
wppa_update_modified($photo);
wppa_bump_photo_rev();
wppa_bump_thumb_rev();
echo '||0||' . sprintf(__('Photo %s rotated %s', 'wp-photo-album-plus'), $photo, $dir);
} else {
echo '||' . wppa('error') . '||' . sprintf(__('An error occurred while trying to rotate photo %s', 'wp-photo-album-plus'), $photo);
}
wppa_exit();
break;
case 'moveto':
$photodata = $wpdb->get_row($wpdb->prepare('SELECT * FROM ' . WPPA_PHOTOS . ' WHERE `id` = %s', $photo), ARRAY_A);
if (wppa_switch('void_dups')) {
// Check for already exists
$exists = wppa_file_is_in_album($photodata['filename'], $value);
if ($exists) {
// Already exists
echo '||3||' . sprintf(__('A photo with filename %s already exists in album %s.', 'wp-photo-album-plus'), $photodata['filename'], $value);
wppa_exit();
break;
}
}
wppa_flush_treecounts($photodata['album']);
// Current album
wppa_flush_treecounts($value);
// New album
$iret = $wpdb->query($wpdb->prepare('UPDATE ' . WPPA_PHOTOS . ' SET `album` = %s WHERE `id` = %s', $value, $photo));
if ($iret !== false) {
wppa_move_source($photodata['filename'], $photodata['album'], $value);
echo '||99||' . sprintf(__('Photo %s has been moved to album %s (%s)', 'wp-photo-album-plus'), $photo, wppa_get_album_name($value), $value);
} else {
echo '||3||' . sprintf(__('An error occurred while trying to move photo %s', 'wp-photo-album-plus'), $photo);
}
wppa_exit();
break;
case 'copyto':
$photodata = $wpdb->get_row($wpdb->prepare('SELECT * FROM ' . WPPA_PHOTOS . ' WHERE `id` = %s', $photo), ARRAY_A);
if (wppa_switch('void_dups')) {
// Check for already exists
$exists = wppa_file_is_in_album($photodata['filename'], $value);
if ($exists) {
// Already exists
echo '||4||' . sprintf(__('A photo with filename %s already exists in album %s.', 'wp-photo-album-plus'), $photodata['filename'], $value);
wppa_exit();
break;
}
}
wppa('error', wppa_copy_photo($photo, $value));
wppa_flush_treecounts($value);
// New album
if (!wppa('error')) {
echo '||0||' . sprintf(__('Photo %s copied to album %s (%s)', 'wp-photo-album-plus'), $photo, wppa_get_album_name($value), $value);
} else {
echo '||4||' . sprintf(__('An error occurred while trying to copy photo %s', 'wp-photo-album-plus'), $photo);
echo '<br>' . __('Press CTRL+F5 and try again.', 'wp-photo-album-plus');
}
wppa_exit();
break;
case 'status':
if (!current_user_can('wppa_moderate') && !current_user_can('wppa_admin')) {
die('Security check failure #78');
}
wppa_flush_treecounts(wppa_get_photo_item($photo, 'album'));
// $wpdb->get_var( $wpdb->prepare( "SELECT `album` FROM `".WPPA_PHOTOS."` WHERE `id` = %s", $photo ) ) );
// $wpdb->get_var( $wpdb->prepare( "SELECT `album` FROM `".WPPA_PHOTOS."` WHERE `id` = %s", $photo ) ) );
case 'owner':
case 'name':
case 'description':
case 'p_order':
case 'linkurl':
case 'linktitle':
case 'linktarget':
case 'tags':
case 'alt':
case 'videox':
case 'videoy':
switch ($item) {
case 'name':
$value = strip_tags($value);
$itemname = __('Name', 'wp-photo-album-plus');
break;
case 'description':
$itemname = __('Description', 'wp-photo-album-plus');
if (wppa_switch('check_balance')) {
$value = str_replace(array('<br/>', '<br>'), '<br />', $value);
if (balanceTags($value, true) != $value) {
echo '||3||' . __('Unbalanced tags in photo description!', 'wp-photo-album-plus');
wppa_exit();
}
}
break;
case 'p_order':
$itemname = __('Photo order #', 'wp-photo-album-plus');
break;
case 'owner':
$usr = get_user_by('login', $value);
if (!$usr) {
echo '||4||' . sprintf(__('User %s does not exists', 'wp-photo-album-plus'), $value);
wppa_exit();
}
$value = $usr->user_login;
// Correct possible case mismatch
wppa_flush_upldr_cache('photoid', $photo);
// Current owner
wppa_flush_upldr_cache('username', $value);
// New owner
$itemname = __('Owner', 'wp-photo-album-plus');
break;
case 'linkurl':
$itemname = __('Link url', 'wp-photo-album-plus');
break;
case 'linktitle':
$itemname = __('Link title', 'wp-photo-album-plus');
break;
case 'linktarget':
$itemname = __('Link target', 'wp-photo-album-plus');
break;
case 'tags':
$value = wppa_sanitize_tags($value, false, true);
$value = wppa_sanitize_tags(wppa_filter_iptc(wppa_filter_exif($value, $photo), $photo));
wppa_clear_taglist();
$itemname = __('Photo Tags', 'wp-photo-album-plus');
break;
case 'status':
wppa_clear_taglist();
wppa_flush_upldr_cache('photoid', $photo);
$itemname = __('Status', 'wp-photo-album-plus');
break;
case 'alt':
$itemname = __('HTML Alt', 'wp-photo-album-plus');
$value = strip_tags(stripslashes($value));
break;
case 'videox':
$itemname = __('Video width', 'wp-photo-album-plus');
if (!wppa_is_int($value) || $value < '0') {
echo '||3||' . __('Please enter an integer value >= 0', 'wp-photo-album-plus');
wppa_exit();
}
break;
case 'videoy':
$itemname = __('Video height', 'wp-photo-album-plus');
if (!wppa_is_int($value) || $value < '0') {
echo '||3||' . __('Please enter an integer value >= 0', 'wp-photo-album-plus');
wppa_exit();
}
break;
default:
$itemname = $item;
}
// if ( $item == 'name' || $item == 'description' || $item == 'tags' ) wppa_index_quick_remove( 'photo', $photo );
$iret = $wpdb->query($wpdb->prepare('UPDATE ' . WPPA_PHOTOS . ' SET `' . $item . '` = %s WHERE `id` = %s', $value, $photo));
if ($item == 'name' || $item == 'description' || $item == 'tags') {
wppa_index_update('photo', $photo);
}
if ($item == 'status' && $value != 'scheduled') {
wppa_update_photo(array('id' => $photo, 'scheduledtm' => ''));
}
if ($item == 'status') {
wppa_flush_treecounts(wppa_get_photo_item($photo, 'album'));
}
if ($iret !== false) {
wppa_update_modified($photo);
if (wppa_is_video($photo)) {
echo '||0||' . sprintf(__('<b>%s</b> of video %s updated', 'wp-photo-album-plus'), $itemname, $photo);
} else {
echo '||0||' . sprintf(__('<b>%s</b> of photo %s updated', 'wp-photo-album-plus'), $itemname, $photo);
}
} else {
echo '||2||' . sprintf(__('An error occurred while trying to update <b>%s</b> of photo %s', 'wp-photo-album-plus'), $itemname, $photo);
echo '<br>' . __('Press CTRL+F5 and try again.', 'wp-photo-album-plus');
wppa_exit();
}
break;
case 'year':
case 'month':
case 'day':
case 'hour':
case 'min':
$itemname = __('Schedule date/time', 'wp-photo-album-plus');
$scheduledtm = $wpdb->get_var($wpdb->prepare("SELECT `scheduledtm` FROM`" . WPPA_PHOTOS . "` WHERE `id` = %s", $photo));
if (!$scheduledtm) {
$scheduledtm = wppa_get_default_scheduledtm();
}
$temp = explode(',', $scheduledtm);
if ($item == 'year') {
$temp[0] = $value;
}
if ($item == 'month') {
$temp[1] = $value;
}
if ($item == 'day') {
$temp[2] = $value;
}
if ($item == 'hour') {
$temp[3] = $value;
}
if ($item == 'min') {
$temp[4] = $value;
}
$scheduledtm = implode(',', $temp);
wppa_update_photo(array('id' => $photo, 'scheduledtm' => $scheduledtm, 'status' => 'scheduled'));
wppa_flush_treecounts($wpdb->get_var($wpdb->prepare("SELECT `album` FROM `" . WPPA_PHOTOS . "` WHERE `id` = %s", $photo)));
wppa_flush_upldr_cache('photoid', $photo);
if (wppa_is_video($photo)) {
echo '||0||' . sprintf(__('<b>%s</b> of video %s updated', 'wp-photo-album-plus'), $itemname, $photo);
} else {
echo '||0||' . sprintf(__('<b>%s</b> of photo %s updated', 'wp-photo-album-plus'), $itemname, $photo);
}
break;
case 'custom_0':
case 'custom_1':
case 'custom_2':
case 'custom_3':
case 'custom_4':
case 'custom_5':
case 'custom_6':
case 'custom_7':
case 'custom_8':
case 'custom_9':
$index = substr($item, -1);
$custom = wppa_get_photo_item($photo, 'custom');
if ($custom) {
$custom_data = unserialize($custom);
} else {
$custom_data = array('', '', '', '', '', '', '', '', '', '');
}
$custom_data[$index] = strip_tags($value);
$custom = serialize($custom_data);
wppa_update_photo(array('id' => $photo, 'custom' => $custom, 'modified' => time()));
wppa_index_update('photo', $photo);
echo '||0||' . sprintf(__('<b>Custom field %s</b> of photo %s updated', 'wp-photo-album-plus'), wppa_opt('custom_caption_' . $index), $photo);
break;
case 'file':
// Check on upload error
if ($_FILES['photo']['error']) {
echo '||' . $_FILES['photo']['error'] . '||' . __('<b>Error during upload.</b>', 'wp-photo-album-plus');
wppa_exit();
}
// Save new source
wppa_save_source($_FILES['photo']['tmp_name'], wppa_get_photo_item($photo, 'filename'), wppa_get_photo_item($photo, 'album'));
// Make the files
$bret = wppa_make_the_photo_files($_FILES['photo']['tmp_name'], $photo, strtolower(wppa_get_ext($_FILES['photo']['name'])));
if ($bret) {
// Update timestamps and sizes
$alb = wppa_get_photo_item($photo, 'album');
wppa_update_album(array('id' => $alb, 'modified' => time()));
wppa_update_photo(array('id' => $photo, 'modified' => time(), 'thumbx' => '0', 'thumby' => '0', 'photox' => '0', 'photoy' => '0'));
// Report success
echo '||0||' . __('Photo files updated.', 'wp-photo-album-plus');
} else {
// Report fail
echo '||1||' . __('Could not update files.', 'wp-photo-album-plus');
}
wppa_exit();
break;
case 'stereo':
$t = microtime(true);
wppa_update_photo(array('id' => $photo, 'stereo' => $value));
wppa_create_stereo_images($photo);
wppa_create_thumbnail($photo);
$t = microtime(true) - $t;
echo '||0||' . sprintf(__('Stereo mode updated in %d milliseconds', 'wp-photo-album-plus'), floor($t * 1000));
wppa_exit();
break;
default:
echo '||98||This update action is not implemented yet( ' . $item . ' )';
wppa_exit();
}
wppa_clear_cache();
break;
// The wppa-settings page calls ajax with $wppa_action == 'update-option';
// The wppa-settings page calls ajax with $wppa_action == 'update-option';
case 'update-option':
// Verify that we are legally here
$nonce = $_REQUEST['wppa-nonce'];
if (!wp_verify_nonce($nonce, 'wppa-nonce')) {
echo '||1||' . __('You do not have the rights to update settings', 'wp-photo-album-plus');
wppa_exit();
// Nonce check failed
}
// Initialize
$old_minisize = wppa_get_minisize();
// Remember for later, maybe we do something that requires regen
$option = $_REQUEST['wppa-option'];
// The option to be processed
$value = isset($_REQUEST['value']) ? wppa_decode($_REQUEST['value']) : '';
// The new value, may also contain & # and +
$value = stripslashes($value);
$value = trim($value);
// Remaove surrounding spaces
$alert = '';
// Init the return string data
wppa('error', '0');
//
$title = '';
//
// If it is a font family, change all double quotes into single quotes as this destroys much more than you would like
if (strpos($option, 'wppa_fontfamily_') !== false) {
$value = str_replace('"', "'", $value);
}
$option = wppa_decode($option);
// Dispatch on option
if (substr($option, 0, 16) == 'wppa_iptc_label_') {
$tag = substr($option, 16);
$q = $wpdb->prepare("UPDATE `" . WPPA_IPTC . "` SET `description`=%s WHERE `tag`=%s AND `photo`='0'", $value, $tag);
$bret = $wpdb->query($q);
// Produce the response text
if ($bret) {
$output = '||0||' . $tag . ' updated to ' . $value . '||';
} else {
$output = '||1||Failed to update ' . $tag . '||';
}
echo $output;
wppa_exit();
} elseif (substr($option, 0, 17) == 'wppa_iptc_status_') {
$tag = substr($option, 17);
$q = $wpdb->prepare("UPDATE `" . WPPA_IPTC . "` SET `status`=%s WHERE `tag`=%s AND `photo`='0'", $value, $tag);
$bret = $wpdb->query($q);
// Produce the response text
if ($bret) {
$output = '||0||' . $tag . ' updated to ' . $value . '||';
} else {
$output = '||1||Failed to update ' . $tag . '||';
}
echo $output;
wppa_exit();
} elseif (substr($option, 0, 16) == 'wppa_exif_label_') {
$tag = substr($option, 16);
$q = $wpdb->prepare("UPDATE `" . WPPA_EXIF . "` SET `description`=%s WHERE `tag`=%s AND `photo`='0'", $value, $tag);
$bret = $wpdb->query($q);
// Produce the response text
if ($bret) {
$output = '||0||' . $tag . ' updated to ' . $value . '||';
} else {
$output = '||1||Failed to update ' . $tag . '||';
}
echo $output;
wppa_exit();
} elseif (substr($option, 0, 17) == 'wppa_exif_status_') {
$tag = substr($option, 17);
$q = $wpdb->prepare("UPDATE `" . WPPA_EXIF . "` SET `status`=%s WHERE `tag`=%s AND `photo`='0'", $value, $tag);
$bret = $wpdb->query($q);
// Produce the response text
if ($bret) {
$output = '||0||' . $tag . ' updated to ' . $value . '||';
} else {
$output = '||1||Failed to update ' . $tag . '||';
}
echo $output;
wppa_exit();
} elseif (substr($option, 0, 5) == 'caps-') {
// Is capability setting
global $wp_roles;
//$R = new WP_Roles;
$setting = explode('-', $option);
if ($value == 'yes') {
$wp_roles->add_cap($setting[2], $setting[1]);
echo '||0||' . __('Capability granted', 'wp-photo-album-plus') . '||';
wppa_exit();
} elseif ($value == 'no') {
$wp_roles->remove_cap($setting[2], $setting[1]);
echo '||0||' . __('Capability withdrawn', 'wp-photo-album-plus') . '||';
wppa_exit();
} else {
echo '||1||Invalid value: ' . $value . '||';
wppa_exit();
}
} else {
switch ($option) {
case 'wppa_colwidth':
// ?? fixed low high title
wppa_ajax_check_range($value, 'auto', '100', false, __('Column width.', 'wp-photo-album-plus'));
break;
case 'wppa_initial_colwidth':
wppa_ajax_check_range($value, false, '100', false, __('Initial width.', 'wp-photo-album-plus'));
break;
case 'wppa_fullsize':
wppa_ajax_check_range($value, false, '100', false, __('Full size.', 'wp-photo-album-plus'));
break;
case 'wppa_maxheight':
wppa_ajax_check_range($value, false, '100', false, __('Max height.', 'wp-photo-album-plus'));
break;
case 'wppa_thumbsize':
wppa_ajax_check_range($value, false, '50', false, __('Thumbnail size.', 'wp-photo-album-plus'));
break;
case 'wppa_tf_width':
wppa_ajax_check_range($value, false, '50', false, __('Thumbnail frame width', 'wp-photo-album-plus'));
break;
case 'wppa_tf_height':
wppa_ajax_check_range($value, false, '50', false, __('Thumbnail frame height', 'wp-photo-album-plus'));
break;
case 'wppa_tn_margin':
wppa_ajax_check_range($value, false, '0', false, __('Thumbnail Spacing', 'wp-photo-album-plus'));
break;
case 'wppa_min_thumbs':
wppa_ajax_check_range($value, false, '0', false, __('Photocount treshold.', 'wp-photo-album-plus'));
break;
case 'wppa_thumb_page_size':
wppa_ajax_check_range($value, false, '0', false, __('Thumb page size.', 'wp-photo-album-plus'));
break;
case 'wppa_smallsize':
wppa_ajax_check_range($value, false, '50', false, __('Cover photo size.', 'wp-photo-album-plus'));
break;
case 'wppa_album_page_size':
wppa_ajax_check_range($value, false, '0', false, __('Album page size.', 'wp-photo-album-plus'));
break;
case 'wppa_topten_count':
wppa_ajax_check_range($value, false, '2', false, __('Number of TopTen photos', 'wp-photo-album-plus'), '40');
break;
case 'wppa_topten_size':
wppa_ajax_check_range($value, false, '32', false, __('Widget image thumbnail size', 'wp-photo-album-plus'), wppa_get_minisize());
break;
case 'wppa_max_cover_width':
wppa_ajax_check_range($value, false, '150', false, __('Max Cover width', 'wp-photo-album-plus'));
break;
case 'wppa_text_frame_height':
wppa_ajax_check_range($value, false, '0', false, __('Minimal description height', 'wp-photo-album-plus'));
break;
case 'wppa_cover_minheight':
wppa_ajax_check_range($value, false, '0', false, __('Minimal cover height', 'wp-photo-album-plus'));
break;
case 'wppa_head_and_text_frame_height':
wppa_ajax_check_range($value, false, '0', false, __('Minimal text frame height', 'wp-photo-album-plus'));
break;
case 'wppa_bwidth':
wppa_ajax_check_range($value, '', '0', false, __('Border width', 'wp-photo-album-plus'));
break;
case 'wppa_bradius':
wppa_ajax_check_range($value, '', '0', false, __('Border radius', 'wp-photo-album-plus'));
break;
case 'wppa_box_spacing':
wppa_ajax_check_range($value, '', '-20', '100', __('Box spacing', 'wp-photo-album-plus'));
break;
case 'wppa_popupsize':
$floor = wppa_opt('thumbsize');
$temp = wppa_opt('smallsize');
if ($temp > $floor) {
$floor = $temp;
}
wppa_ajax_check_range($value, false, $floor, wppa_opt('fullsize'), __('Popup size', 'wp-photo-album-plus'));
break;
case 'wppa_fullimage_border_width':
wppa_ajax_check_range($value, '', '0', false, __('Fullsize border width', 'wp-photo-album-plus'));
break;
case 'wppa_lightbox_bordersize':
wppa_ajax_check_range($value, false, '0', false, __('Lightbox Bordersize', 'wp-photo-album-plus'));
break;
case 'wppa_ovl_border_width':
wppa_ajax_check_range($value, false, '0', '16', __('Lightbox Borderwidth', 'wp-photo-album-plus'));
break;
case 'wppa_ovl_border_radius':
wppa_ajax_check_range($value, false, '0', '16', __('Lightbox Borderradius', 'wp-photo-album-plus'));
break;
case 'wppa_comment_count':
wppa_ajax_check_range($value, false, '2', '40', __('Number of Comment widget entries', 'wp-photo-album-plus'));
break;
case 'wppa_comment_size':
wppa_ajax_check_range($value, false, '32', wppa_get_minisize(), __('Comment Widget image thumbnail size', 'wp-photo-album-plus'), wppa_get_minisize());
break;
case 'wppa_thumb_opacity':
wppa_ajax_check_range($value, false, '0', '100', __('Opacity.', 'wp-photo-album-plus'));
break;
case 'wppa_cover_opacity':
wppa_ajax_check_range($value, false, '0', '100', __('Opacity.', 'wp-photo-album-plus'));
break;
case 'wppa_star_opacity':
wppa_ajax_check_range($value, false, '0', '50', __('Opacity.', 'wp-photo-album-plus'));
break;
// case 'wppa_filter_priority':
// wppa_ajax_check_range( $value, false, wppa_opt( 'shortcode_priority' ), false, __( 'Filter priority' ,'wp-photo-album-plus' ) );
// break;
// case 'wppa_shortcode_priority':
// wppa_ajax_check_range( $value, false, '0', wppa_opt( 'filter_priority' ) - '1', __( 'Shortcode_priority', 'wp-photo-album-plus' ) );
// break;
// case 'wppa_filter_priority':
// wppa_ajax_check_range( $value, false, wppa_opt( 'shortcode_priority' ), false, __( 'Filter priority' ,'wp-photo-album-plus' ) );
// break;
// case 'wppa_shortcode_priority':
// wppa_ajax_check_range( $value, false, '0', wppa_opt( 'filter_priority' ) - '1', __( 'Shortcode_priority', 'wp-photo-album-plus' ) );
// break;
case 'wppa_gravatar_size':
wppa_ajax_check_range($value, false, '10', '256', __('Avatar size', 'wp-photo-album-plus'));
break;
case 'wppa_watermark_opacity':
wppa_ajax_check_range($value, false, '0', '100', __('Watermark opacity', 'wp-photo-album-plus'));
break;
case 'wppa_watermark_opacity_text':
wppa_ajax_check_range($value, false, '0', '100', __('Watermark opacity', 'wp-photo-album-plus'));
break;
case 'wppa_ovl_txt_lines':
wppa_ajax_check_range($value, 'auto', '0', '24', __('Number of text lines', 'wp-photo-album-plus'));
break;
case 'wppa_ovl_opacity':
wppa_ajax_check_range($value, false, '0', '100', __('Overlay opacity', 'wp-photo-album-plus'));
break;
case 'wppa_upload_limit_count':
wppa_ajax_check_range($value, false, '0', false, __('Upload limit', 'wp-photo-album-plus'));
break;
case 'wppa_dislike_mail_every':
wppa_ajax_check_range($value, false, '0', false, __('Notify inappropriate', 'wp-photo-album-plus'));
break;
case 'wppa_dislike_set_pending':
wppa_ajax_check_range($value, false, '0', false, __('Dislike pending', 'wp-photo-album-plus'));
break;
case 'wppa_dislike_delete':
wppa_ajax_check_range($value, false, '0', false, __('Dislike delete', 'wp-photo-album-plus'));
break;
case 'wppa_max_execution_time':
wppa_ajax_check_range($value, false, '0', '900', __('Max execution time', 'wp-photo-album-plus'));
break;
case 'wppa_cp_points_comment':
case 'wppa_cp_points_rating':
case 'wppa_cp_points_upload':
wppa_ajax_check_range($value, false, '0', false, __('Cube Points points', 'wp-photo-album-plus'));
break;
case 'wppa_jpeg_quality':
wppa_ajax_check_range($value, false, '20', '100', __('JPG Image quality', 'wp-photo-album-plus'));
if (wppa_cdn('admin') == 'cloudinary' && !wppa('out')) {
wppa_delete_derived_from_cloudinary();
}
break;
case 'wppa_imgfact_count':
wppa_ajax_check_range($value, false, '1', '24', __('Number of coverphotos', 'wp-photo-album-plus'));
break;
case 'wppa_dislike_value':
wppa_ajax_check_range($value, false, '-10', '0', __('Dislike value', 'wp-photo-album-plus'));
break;
case 'wppa_slideshow_pagesize':
wppa_ajax_check_range($value, false, '0', false, __('Slideshow pagesize', 'wp-photo-album-plus'));
break;
case 'wppa_pagelinks_max':
wppa_ajax_check_range($value, false, '0', false, __('Max Pagelinks', 'wp-photo-album-plus'));
break;
case 'wppa_start_pause_symbol_size':
wppa_ajax_check_range($value, false, '0', false, __('Start/pause symbol size', 'wp-photo-album-plus'));
break;
case 'wppa_start_pause_symbol_bradius':
wppa_ajax_check_range($value, false, '0', false, __('Start/pause symbol border radius', 'wp-photo-album-plus'));
break;
case 'wppa_stop_symbol_size':
wppa_ajax_check_range($value, false, '0', false, __('Stop symbol size', 'wp-photo-album-plus'));
break;
case 'wppa_stop_symbol_bradius':
wppa_ajax_check_range($value, false, '0', false, __('Stop symbol border radius', 'wp-photo-album-plus'));
break;
case 'wppa_rating_clear':
$iret1 = $wpdb->query('TRUNCATE TABLE ' . WPPA_RATING);
$iret2 = $wpdb->query('UPDATE ' . WPPA_PHOTOS . ' SET mean_rating="0", rating_count="0" WHERE id > -1');
if ($iret1 !== false && $iret2 !== false) {
delete_option('wppa_' . WPPA_RATING . '_lastkey');
$title = __('Ratings cleared', 'wp-photo-album-plus');
} else {
$title = __('Could not clear ratings', 'wp-photo-album-plus');
$alert = $title;
wppa('error', '1');
}
break;
case 'wppa_viewcount_clear':
$iret = $wpdb->query("UPDATE `" . WPPA_PHOTOS . "` SET `views` = '0'") && $wpdb->query("UPDATE `" . WPPA_ALBUMS . "` SET `views` = '0'");
if ($iret !== false) {
$title = __('Viewcounts cleared', 'wp-photo-album-plus');
} else {
$title = __('Could not clear viewcounts', 'wp-photo-album-plus');
$alert = $title;
wppa('error', '1');
}
break;
case 'wppa_iptc_clear':
$iret = $wpdb->query('TRUNCATE TABLE ' . WPPA_IPTC);
if ($iret !== false) {
delete_option('wppa_' . WPPA_IPTC . '_lastkey');
$title = __('IPTC data cleared', 'wp-photo-album-plus');
$alert = __('Refresh this page to clear table X', 'wp-photo-album-plus');
update_option('wppa_index_need_remake', 'yes');
} else {
$title = __('Could not clear IPTC data', 'wp-photo-album-plus');
$alert = $title;
wppa('error', '1');
}
break;
case 'wppa_exif_clear':
$iret = $wpdb->query('TRUNCATE TABLE ' . WPPA_EXIF);
if ($iret !== false) {
delete_option('wppa_' . WPPA_EXIF . '_lastkey');
$title = __('EXIF data cleared', 'wp-photo-album-plus');
$alert = __('Refresh this page to clear table XI', 'wp-photo-album-plus');
update_option('wppa_index_need_remake', 'yes');
} else {
$title = __('Could not clear EXIF data', 'wp-photo-album-plus');
$alert = $title;
wppa('error', '1');
}
break;
case 'wppa_recup':
$result = wppa_recuperate_iptc_exif();
echo '||0||' . __('Recuperation performed', 'wp-photo-album-plus') . '||' . $result;
wppa_exit();
break;
case 'wppa_bgcolor_thumbnail':
$value = trim(strtolower($value));
if (strlen($value) != '7' || substr($value, 0, 1) != '#') {
wppa('error', '1');
} else {
for ($i = 1; $i < 7; $i++) {
if (!in_array(substr($value, $i, 1), array('0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'a', 'b', 'c', 'd', 'e', 'f'))) {
wppa('error', '1');
}
}
}
if (!wppa('error')) {
$old_minisize--;
} else {
$alert = __('Illegal format. Please enter a 6 digit hexadecimal color value. Example: #77bbff', 'wp-photo-album-plus');
}
break;
case 'wppa_thumb_aspect':
$old_minisize--;
// Trigger regen message
break;
case 'wppa_rating_max':
if ($value == '5' && wppa_opt('rating_max') == '10') {
$rats = $wpdb->get_results('SELECT `id`, `value` FROM `' . WPPA_RATING . '`', ARRAY_A);
if ($rats) {
foreach ($rats as $rat) {
$wpdb->query($wpdb->prepare('UPDATE `' . WPPA_RATING . '` SET `value` = %s WHERE `id` = %s', $rat['value'] / 2, $rat['id']));
}
}
}
if ($value == '10' && wppa_opt('rating_max') == '5') {
$rats = $wpdb->get_results('SELECT `id`, `value` FROM `' . WPPA_RATING . '`', ARRAY_A);
if ($rats) {
foreach ($rats as $rat) {
$wpdb->query($wpdb->prepare('UPDATE `' . WPPA_RATING . '` SET `value` = %s WHERE `id` = %s', $rat['value'] * 2, $rat['id']));
}
}
}
update_option('wppa_rerate_status', 'Required');
$alert .= __('You just changed a setting that requires the recalculation of ratings.', 'wp-photo-album-plus');
$alert .= ' ' . __('Please run the appropriate action in Table VIII.', 'wp-photo-album-plus');
wppa_update_option($option, $value);
wppa('error', '0');
break;
case 'wppa_newphoto_description':
if (wppa_switch('check_balance') && balanceTags($value, true) != $value) {
$alert = __('Unbalanced tags in photo description!', 'wp-photo-album-plus');
wppa('error', '1');
} else {
wppa_update_option($option, $value);
wppa('error', '0');
$alert = '';
wppa_index_compute_skips();
}
break;
case 'wppa_keep_source':
$dir = wppa_opt('source_dir');
if (!is_dir($dir)) {
@mkdir($dir);
}
if (!is_dir($dir) || !is_writable($dir)) {
wppa('error', '1');
$alert = sprintf(__('Unable to create or write to %s', 'wp-photo-album-plus'), $dir);
}
break;
case 'wppa_source_dir':
$olddir = wppa_opt('source_dir');
$value = rtrim($value, '/');
if (strpos($value . '/', WPPA_UPLOAD_PATH . '/') !== false) {
wppa('error', '1');
$alert = sprintf(__('Source can not be inside the wppa folder.', 'wp-photo-album-plus'));
} else {
$dir = $value;
if (!is_dir($dir)) {
@mkdir($dir);
}
if (!is_dir($dir) || !is_writable($dir)) {
wppa('error', '1');
$alert = sprintf(__('Unable to create or write to %s', 'wp-photo-album-plus'), $dir);
} else {
@rmdir($olddir);
// try to remove when empty
}
}
break;
case 'wppa_newpag_content':
if (strpos($value, 'w#album') === false) {
$alert = __('The content must contain w#album', 'wp-photo-album-plus');
wppa('error', '1');
}
break;
case 'wppa_gpx_shortcode':
if (strpos($value, 'w#lat') === false || strpos($value, 'w#lon') === false) {
$alert = __('The content must contain w#lat and w#lon', 'wp-photo-album-plus');
wppa('error', '1');
}
break;
case 'wppa_i_responsive':
if ($value == 'yes') {
wppa_update_option('wppa_colwidth', 'auto');
}
if ($value == 'no') {
wppa_update_option('wppa_colwidth', '640');
}
break;
case 'wppa_i_downsize':
if ($value == 'yes') {
wppa_update_option('wppa_resize_on_upload', 'yes');
if (wppa_opt('resize_to') == '0') {
wppa_update_option('wppa_resize_to', '1024x768');
}
}
if ($value == 'no') {
wppa_update_option('wppa_resize_on_upload', 'no');
}
break;
case 'wppa_i_source':
if ($value == 'yes') {
wppa_update_option('wppa_keep_source_admin', 'yes');
wppa_update_option('wppa_keep_source_frontend', 'yes');
}
if ($value == 'no') {
wppa_update_option('wppa_keep_source_admin', 'no');
wppa_update_option('wppa_keep_source_frontend', 'no');
}
break;
case 'wppa_i_userupload':
if ($value == 'yes') {
wppa_update_option('wppa_user_upload_on', 'yes');
wppa_update_option('wppa_user_upload_login', 'yes');
wppa_update_option('wppa_owner_only', 'yes');
wppa_update_option('wppa_upload_moderate', 'yes');
wppa_update_option('wppa_upload_edit', 'yes');
wppa_update_option('wppa_upload_notify', 'yes');
wppa_update_option('wppa_grant_an_album', 'yes');
$grantparent = wppa_opt('grant_parent');
if (!wppa_album_exists($grantparent)) {
$id = wppa_create_album_entry(array('name' => __('Members', 'wp-photo-album-plus'), 'description' => __('Parent of the member albums', 'wp-photo-album-plus'), 'a_parent' => '-1', 'upload_limit' => '0/0'));
if ($id) {
wppa_index_add('album', $id);
wppa_update_option('wppa_grant_parent', $id);
}
$my_post = array('post_title' => __('Members', 'wp-photo-album-plus'), 'post_content' => '[wppa type="content" album="' . $id . '"][/wppa]', 'post_status' => 'publish', 'post_type' => 'page');
$pagid = wp_insert_post($my_post);
}
wppa_update_option('wppa_alt_is_restricted', 'yes');
wppa_update_option('wppa_link_is_restricted', 'yes');
wppa_update_option('wppa_covertype_is_restricted', 'yes');
wppa_update_option('wppa_porder_restricted', 'yes');
}
if ($value == 'no') {
wppa_update_option('wppa_user_upload_on', 'no');
}
break;
case 'wppa_i_rating':
if ($value == 'yes') {
wppa_update_option('wppa_rating_on', 'yes');
}
if ($value == 'no') {
wppa_update_option('wppa_rating_on', 'no');
}
break;
case 'wppa_i_comment':
if ($value == 'yes') {
wppa_update_option('wppa_show_comments', 'yes');
wppa_update_option('wppa_comment_moderation', 'all');
wppa_update_option('wppa_comment_notify', 'admin');
}
if ($value == 'no') {
wppa_update_option('wppa_show_comments', 'no');
}
break;
case 'wppa_i_share':
if ($value == 'yes') {
wppa_update_option('wppa_share_on', 'yes');
}
if ($value == 'no') {
wppa_update_option('wppa_share_on', 'no');
}
break;
case 'wppa_i_iptc':
if ($value == 'yes') {
wppa_update_option('wppa_show_iptc', 'yes');
wppa_update_option('wppa_save_iptc', 'yes');
}
if ($value == 'no') {
wppa_update_option('wppa_show_iptc', 'no');
wppa_update_option('wppa_save_iptc', 'no');
}
break;
case 'wppa_i_exif':
if ($value == 'yes') {
wppa_update_option('wppa_show_exif', 'yes');
wppa_update_option('wppa_save_exif', 'yes');
}
if ($value == 'no') {
wppa_update_option('wppa_show_exif', 'no');
wppa_update_option('wppa_save_exif', 'no');
}
break;
case 'wppa_i_gpx':
if ($value == 'yes') {
$custom_content = wppa_opt('custom_content');
if (strpos($custom_content, 'w#location') === false) {
$custom_content = $custom_content . ' w#location';
wppa_update_option('wppa_custom_content', $custom_content);
}
if (!wppa_switch('custom_on')) {
wppa_update_option('wppa_custom_on', 'yes');
}
if (wppa_opt('gpx_implementation') == 'none') {
wppa_update_option('wppa_gpx_implementation', 'wppa-plus-embedded');
}
}
break;
case 'wppa_i_fotomoto':
if ($value == 'yes') {
$custom_content = wppa_opt('custom_content');
if (strpos($custom_content, 'w#fotomoto') === false) {
$custom_content = 'w#fotomoto ' . $custom_content;
wppa_update_option('wppa_custom_content', $custom_content);
}
if (!wppa_switch('custom_on')) {
wppa_update_option('wppa_custom_on', 'yes');
}
wppa_update_option('wppa_fotomoto_on', 'yes');
wppa_update_option('wppa_custom_on', 'yes');
}
break;
case 'wppa_i_video':
if ($value == 'yes') {
wppa_update_option('wppa_enable_video', 'yes');
} else {
wppa_update_option('wppa_enable_video', 'no');
}
break;
case 'wppa_i_audio':
if ($value == 'yes') {
wppa_update_option('wppa_enable_audio', 'yes');
} else {
wppa_update_option('wppa_enable_audio', 'no');
}
break;
case 'wppa_i_done':
$value = 'done';
break;
case 'wppa_search_tags':
case 'wppa_search_cats':
case 'wppa_search_comments':
update_option('wppa_index_need_remake', 'yes');
break;
case 'wppa_blacklist_user':
// Does user exist?
$value = trim($value);
$user = get_user_by('login', $value);
// seems to be case insensitive
if ($user && $user->user_login === $value) {
$wpdb->query($wpdb->prepare("UPDATE `" . WPPA_PHOTOS . "` SET `status` = 'pending' WHERE `owner` = %s", $value));
$black_listed_users = get_option('wppa_black_listed_users', array());
if (!in_array($value, $black_listed_users)) {
$black_listed_users[] = $value;
update_option('wppa_black_listed_users', $black_listed_users);
}
$alert = esc_js(sprintf(__('User %s has been blacklisted.', 'wp-photo-album-plus'), $value));
} else {
$alert = esc_js(sprintf(__('User %s does not exist.', 'wp-photo-album-plus'), $value));
}
$value = '';
break;
case 'wppa_un_blacklist_user':
$wpdb->query($wpdb->prepare("UPDATE `" . WPPA_PHOTOS . "` SET `status` = 'publish' WHERE `owner` = %s", $value));
$black_listed_users = get_option('wppa_black_listed_users', array());
if (in_array($value, $black_listed_users)) {
foreach (array_keys($black_listed_users) as $usr) {
if ($black_listed_users[$usr] == $value) {
unset($black_listed_users[$usr]);
}
}
update_option('wppa_black_listed_users', $black_listed_users);
}
$value = '0';
break;
case 'wppa_fotomoto_on':
if ($value == 'yes') {
$custom_content = wppa_opt('custom_content');
if (strpos($custom_content, 'w#fotomoto') === false) {
$custom_content = 'w#fotomoto ' . $custom_content;
wppa_update_option('wppa_custom_content', $custom_content);
$alert = __('The content of the Custom box has been changed to display the Fotomoto toolbar.', 'wp-photo-album-plus') . ' ';
}
if (!wppa_switch('custom_on')) {
wppa_update_option('wppa_custom_on', 'yes');
$alert .= __('The display of the custom box has been enabled', 'wp-photo-album-plus');
}
}
break;
case 'wppa_gpx_implementation':
if ($value != 'none') {
$custom_content = wppa_opt('custom_content');
if (strpos($custom_content, 'w#location') === false) {
$custom_content = $custom_content . ' w#location';
wppa_update_option('wppa_custom_content', $custom_content);
$alert = __('The content of the Custom box has been changed to display maps.', 'wp-photo-album-plus') . ' ';
}
if (!wppa_switch('custom_on')) {
wppa_update_option('wppa_custom_on', 'yes');
$alert .= __('The display of the custom box has been enabled', 'wp-photo-album-plus');
}
}
break;
case 'wppa_regen_thumbs_skip_one':
$last = get_option('wppa_regen_thumbs_last', '0');
$skip = $last + '1';
update_option('wppa_regen_thumbs_last', $skip);
break;
case 'wppa_remake_skip_one':
$last = get_option('wppa_remake_last', '0');
$skip = $last + '1';
update_option('wppa_remake_last', $skip);
break;
case 'wppa_errorlog_purge':
@unlink(WPPA_CONTENT_PATH . '/wppa-depot/admin/error.log');
break;
case 'wppa_pl_dirname':
$value = wppa_sanitize_file_name($value);
$value = trim($value, ' /');
if (!$value) {
wppa('error', '714');
wppa_out(__('This value can not be empty', 'wp-photo-album-plus'));
} else {
wppa_create_pl_htaccess($value);
}
break;
case 'wppa_new_tag_value':
$value = wppa_sanitize_tags($value, false, true);
break;
case 'wppa_up_tagselbox_content_1':
case 'wppa_up_tagselbox_content_2':
case 'wppa_up_tagselbox_content_3':
$value = wppa_sanitize_tags($value);
break;
case 'wppa_wppa_set_shortcodes':
$value = str_replace(' ', '', $value);
break;
case 'wppa_enable_video':
// if off: set all statusses of videos to pending
break;
default:
wppa('error', '0');
$alert = '';
}
}
if (wppa('error')) {
if (!$title) {
$title = sprintf(__('Failed to set %s to %s', 'wp-photo-album-plus'), $option, $value);
}
if (!$alert) {
$alert .= wppa('out');
}
} else {
wppa_update_option($option, $value);
if (!$title) {
$title = sprintf(__('Setting %s updated to %s', 'wp-photo-album-plus'), $option, $value);
}
}
// Save possible error
$error = wppa('error');
// Something to do after changing the setting?
wppa_initialize_runtime(true);
// force reload new values
// .htaccess
wppa_create_wppa_htaccess();
// Thumbsize
$new_minisize = wppa_get_minisize();
if ($old_minisize != $new_minisize) {
update_option('wppa_regen_thumbs_status', 'Required');
$alert .= __('You just changed a setting that requires the regeneration of thumbnails.', 'wp-photo-album-plus');
$alert .= ' ' . __('Please run the appropriate action in Table VIII.', 'wp-photo-album-plus');
}
// Produce the response text
$output = '||' . $error . '||' . esc_attr($title) . '||' . esc_js($alert);
echo $output;
wppa_clear_cache();
wppa_exit();
break;
// End update-option
// End update-option
case 'maintenance':
$slug = $_POST['slug'];
$nonce = $_REQUEST['wppa-nonce'];
if (!wp_verify_nonce($nonce, 'wppa-nonce')) {
echo 'Security check failure||' . $slug . '||Error||0';
wppa_exit();
}
echo wppa_do_maintenance_proc($slug);
wppa_exit();
break;
case 'maintenancepopup':
$slug = $_POST['slug'];
$nonce = $_REQUEST['wppa-nonce'];
if (!wp_verify_nonce($nonce, 'wppa-nonce')) {
echo 'Security check failure||' . $slug . '||Error||0';
wppa_exit();
}
echo wppa_do_maintenance_popup($slug);
wppa_exit();
break;
case 'do-fe-upload':
if (is_admin()) {
require_once 'wppa-non-admin.php';
}
wppa_user_upload();
echo wppa('out');
wppa_exit();
break;
case 'sanitizetags':
$tags = isset($_GET['tags']) ? $_GET['tags'] : '';
$album = isset($_GET['album']) ? $_GET['album'] : '0';
$deftags = $album ? wppa_get_album_item($album, 'default_tags') : '';
$tags = $deftags ? $tags . ',' . $deftags : $tags;
echo wppa_sanitize_tags($tags, false, true);
wppa_exit();
break;
case 'destroyalbum':
$album = isset($_GET['album']) ? $_GET['album'] : '0';
if (!$album) {
_e('Missing album id', 'wp-photo-album-plus');
wppa_exit();
}
$nonce = isset($_GET['nonce']) ? $_GET['nonce'] : '';
if (!$nonce || !wp_verify_nonce($nonce, 'wppa_nonce_' . $album)) {
echo 'Security check failure #798';
wppa_exit();
}
// May I?
$imay = true;
if (!wppa_switch('user_destroy_on')) {
$may = false;
}
if (wppa_switch('user_create_login')) {
if (!is_user_logged_in()) {
$may = false;
}
// Must login
}
if (!wppa_have_access($album)) {
$may = false;
// No album access
}
if (wppa_is_user_blacklisted()) {
$may = false;
}
if (!$imay) {
_e('You do not have the rights to delete this album', 'wp-photo-album-plus');
wppa_exit();
}
// I may
require_once 'wppa-album-admin-autosave.php';
wppa_del_album($album, '');
wppa_exit();
break;
default:
// Unimplemented $wppa-action
die('-1');
}
wppa_exit();
}
function wppa_album_photos_bulk($album)
{
global $wpdb;
// Check input
wppa_vfy_arg('wppa-page');
// Init
$count = '0';
$abort = false;
if (isset($_POST['wppa-bulk-action'])) {
check_admin_referer('wppa-bulk', 'wppa-bulk');
if (isset($_POST['wppa-bulk-photo'])) {
$ids = $_POST['wppa-bulk-photo'];
$newalb = isset($_POST['wppa-bulk-album']) ? $_POST['wppa-bulk-album'] : '0';
$status = isset($_POST['wppa-bulk-status']) ? $_POST['wppa-bulk-status'] : '';
$owner = isset($_POST['wppa-bulk-owner']) ? $_POST['wppa-bulk-owner'] : '';
$totcount = count($ids);
if (!is_numeric($newalb)) {
wp_die('Security check failure 1');
}
if (is_array($ids)) {
foreach (array_keys($ids) as $id) {
$skip = false;
switch ($_POST['wppa-bulk-action']) {
case 'wppa-bulk-delete':
wppa_delete_photo($id);
break;
case 'wppa-bulk-move-to':
if ($newalb) {
$photo = $wpdb->get_row($wpdb->prepare('SELECT * FROM ' . WPPA_PHOTOS . ' WHERE `id` = %s', $id), ARRAY_A);
if (wppa_switch('void_dups')) {
// Check for already exists
$exists = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM `" . WPPA_PHOTOS . "` WHERE `filename` = %s AND `album` = %s", $photo['filename'], $newalb));
if ($exists) {
// Already exists
wppa_error_message(sprintf(__('A photo with filename %s already exists in album %s.', 'wp-photo-album-plus'), $photo['filename'], $newalb));
$skip = true;
}
}
if ($skip) {
continue;
}
wppa_flush_treecounts($photo['album']);
// Current album
wppa_flush_treecounts($newalb);
// New album
$wpdb->query($wpdb->prepare('UPDATE `' . WPPA_PHOTOS . '` SET `album` = %s WHERE `id` = %s', $newalb, $id));
wppa_move_source($photo['filename'], $photo['album'], $newalb);
} else {
wppa_error_message('Unexpected error #4 in wppa_album_photos_bulk().');
}
break;
case 'wppa-bulk-copy-to':
if ($newalb) {
$photo = $wpdb->get_row($wpdb->prepare('SELECT * FROM ' . WPPA_PHOTOS . ' WHERE `id` = %s', $id), ARRAY_A);
if (wppa_switch('void_dups')) {
// Check for already exists
$exists = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM `" . WPPA_PHOTOS . "` WHERE `filename` = %s AND `album` = %s", $photo['filename'], $newalb));
if ($exists) {
// Already exists
wppa_error_message(sprintf(__($exists . 'A photo with filename %s already exists in album %s.', 'wp-photo-album-plus'), $photo['filename'], $newalb));
$skip = true;
}
}
if ($skip) {
continue;
}
wppa_copy_photo($id, $newalb);
wppa_flush_treecounts($newalb);
} else {
wppa_error_message('Unexpected error #3 in wppa_album_photos_bulk().');
}
break;
case 'wppa-bulk-status':
if (!in_array($status, array('publish', 'pending', 'featured', 'scheduled', 'gold', 'silver', 'bronze', 'private'))) {
wppa_log('error', 'Unknown status ' . strip_tags($status) . ' found in wppa-photo-admin-autosave.php -> wppa_album_photos_bulk()');
$status = 'publish';
}
if (current_user_can('wppa_admin') || current_user_can('wppa_moderate')) {
if ($status == 'publish' || $status == 'pending' || wppa_user_is('administrator') || !wppa_switch('ext_status_restricted')) {
$wpdb->query("UPDATE `" . WPPA_PHOTOS . "` SET `status` = '" . $status . "' WHERE `id` = " . $id);
wppa_flush_treecounts($id, wppa_get_photo_item($id, 'album'));
} else {
wp_die('Security check failure 2');
}
} else {
wp_die('Security check failure 3');
}
break;
case 'wppa-bulk-owner':
if (wppa_user_is('administrator') && wppa_switch('photo_owner_change')) {
if ($owner) {
$owner = sanitize_user($owner);
$exists = $wpdb->get_var("SELECT COUNT(*) FROM `" . $wpdb->users . "` WHERE `user_login` = '" . $owner . "'");
if ($exists) {
$wpdb->query("UPDATE `" . WPPA_PHOTOS . "` SET `owner` = '" . $owner . "' WHERE `id` = " . $id);
} else {
wppa_error_message('A user with login name ' . $owner . ' does not exist.');
$skip = true;
}
} else {
wp_die('Missing required arg in bulk change owner');
}
} else {
wp_die('Security check failure 4');
}
break;
default:
wppa_error_message('Unimplemented bulk action requested in wppa_album_photos_bulk().');
break;
}
if (!$skip) {
$count++;
}
if (wppa_is_time_up()) {
wppa_error_message(sprintf(__('Time is out after processing %d out of %d items.', 'wp-photo-album-plus'), $count, $totcount));
$abort = true;
}
if ($abort) {
break;
}
}
} else {
wppa_error_message('Unexpected error #2 in wppa_album_photos_bulk().');
}
} else {
wppa_error_message('Unexpected error #1 in wppa_album_photos_bulk().');
}
if ($count && !$abort) {
switch ($_POST['wppa-bulk-action']) {
case 'wppa-bulk-delete':
$message = sprintf(__('%d photos deleted.', 'wp-photo-album-plus'), $count);
break;
case 'wppa-bulk-move-to':
$message = sprintf(__('%1$s photos moved to album %2$s.', 'wp-photo-album-plus'), $count, $newalb . ': ' . wppa_get_album_name($newalb));
break;
case 'wppa-bulk-copy-to':
$message = sprintf(__('%1$s photos copied to album %2$s.', 'wp-photo-album-plus'), $count, $newalb . ': ' . wppa_get_album_name($newalb));
break;
case 'wppa-bulk-status':
$message = sprintf(__('Changed status to %1$s on %2$s photos.', 'wp-photo-album-plus'), $status, $count);
break;
case 'wppa-bulk-owner':
$message = sprintf(__('Changed owner to %1$s on %2$s photos.', 'wp-photo-album-plus'), $owner, $count);
break;
default:
$message = sprintf(__('%d photos processed.', 'wp-photo-album-plus'), $count);
break;
}
wppa_ok_message($message);
}
}
$pagesize = wppa_opt('photo_admin_pagesize');
$page = isset($_GET['wppa-page']) ? $_GET['wppa-page'] : '1';
$skip = ($page - '1') * $pagesize;
$limit = $pagesize < '1' ? '' : ' LIMIT ' . $skip . ',' . $pagesize;
if ($album) {
if ($album == 'search') {
$count = wppa_get_edit_search_photos('', 'count_only');
$photos = wppa_get_edit_search_photos($limit);
$link = wppa_dbg_url(get_admin_url() . 'admin.php?page=wppa_admin_menu&tab=edit&edit_id=' . $album . '&wppa-searchstring=' . wppa_sanitize_searchstring($_REQUEST['wppa-searchstring']) . '&bulk');
wppa_show_search_statistics();
} else {
$counts = wppa_treecount_a($album);
$count = $counts['selfphotos'] + $counts['pendphotos'];
//$wpdb->get_var( $wpdb->prepare( 'SELECT COUNT(*) FROM `'.WPPA_PHOTOS.'` WHERE `album` = %s', $album ) );
$photos = $wpdb->get_results($wpdb->prepare('SELECT * FROM `' . WPPA_PHOTOS . '` WHERE `album` = %s ' . wppa_get_photo_order($album, 'norandom') . $limit, $album), ARRAY_A);
$link = wppa_dbg_url(get_admin_url() . 'admin.php?page=wppa_admin_menu&tab=edit&edit_id=' . $album . '&bulk');
}
if ($photos) {
wppa_admin_page_links($page, $pagesize, $count, $link, '#manage-photos');
?>
<script type="text/javascript" >
function wppaBulkActionChange( elm, id ) {
wppa_setCookie( 'wppa_bulk_action',elm.value,365 );
if ( elm.value == 'wppa-bulk-move-to' || elm.value == 'wppa-bulk-copy-to' ) jQuery( '#wppa-bulk-album' ).css( 'display', 'inline' );
else jQuery( '#wppa-bulk-album' ).css( 'display', 'none' );
if ( elm.value == 'wppa-bulk-status' ) jQuery( '#wppa-bulk-status' ).css( 'display', 'inline' );
else jQuery( '#wppa-bulk-status' ).css( 'display', 'none' );
if ( elm.value == 'wppa-bulk-owner' ) jQuery( '#wppa-bulk-owner' ).css( 'display', 'inline' );
else jQuery( '#wppa-bulk-owner' ).css( 'display', 'none' );
}
function wppaBulkDoitOnClick() {
var photos = jQuery( '.wppa-bulk-photo' );
var count=0;
for ( i=0; i< photos.length; i++ ) {
var photo = photos[i];
if ( photo.checked ) count++;
}
if ( count == 0 ) {
alert( 'No photos selected' );
return false;
}
var action = document.getElementById( 'wppa-bulk-action' ).value;
switch ( action ) {
case '':
alert( 'No action selected' );
return false;
break;
case 'wppa-bulk-delete':
break;
case 'wppa-bulk-move-to':
case 'wppa-bulk-copy-to':
var album = document.getElementById( 'wppa-bulk-album' ).value;
if ( album == 0 ) {
alert( 'No album selected' );
return false;
}
break;
case 'wppa-bulk-status':
var status = document.getElementById( 'wppa-bulk-status' ).value;
if ( status == 0 ) {
alert( 'No status selected' );
return false;
}
break;
case 'wppa-bulk-owner':
var owner = documnet.getElementById( 'wppa-bulk-owner' ).value;
if ( owner == 0 ) {
alert( 'No new owner selected' );
return false;
}
break;
default:
alert( 'Unimplemented action requested: '+action );
return false;
break;
}
return true;
}
function wppaSetThumbsize( elm ) {
var thumbsize = elm.value;
wppa_setCookie( 'wppa_bulk_thumbsize',thumbsize,365 );
jQuery( '.wppa-bulk-thumb' ).css( 'max-width', thumbsize+'px' );
jQuery( '.wppa-bulk-thumb' ).css( 'max-height', ( thumbsize/2 )+'px' );
jQuery( '.wppa-bulk-dec' ).css( 'height', ( thumbsize/2 )+'px' );
}
jQuery( document ).ready( function() {
var action = wppa_getCookie( 'wppa_bulk_action' );
document.getElementById( 'wppa-bulk-action' ).value = action;
if ( action == 'wppa-bulk-move-to' || action == 'wppa-bulk-copy-to' ) {
jQuery( '#wppa-bulk-album' ).css( 'display','inline' );
document.getElementById( 'wppa-bulk-album' ).value = wppa_getCookie( 'wppa_bulk_album' );
}
if ( action == 'wppa-bulk-status' ) {
jQuery( '#wppa-bulk-status' ).css( 'display','inline' );
document.getElementById( 'wppa-bulk-status' ).value = wppa_getCookie( 'wppa_bulk_status' );
}
if ( action == 'wppa-bulk-owner' ) {
jQuery( '#wppa-bulk-owner' ).css( 'display','inline' );
document.getElementById( 'wppa-bulk-owner' ).value = wppa_getCookie( 'wppa_bulk_owner' );
}
} );
</script>
<form action="<?php
echo $link . '&wppa-page=' . $page . '#manage-photos';
?>
" method="post" >
<?php
wp_nonce_field('wppa-bulk', 'wppa-bulk');
?>
<h3>
<span style="font-weight:bold;" ><?php
_e('Bulk action:', 'wp-photo-album-plus');
?>
</span>
<select id="wppa-bulk-action" name="wppa-bulk-action" onchange="wppaBulkActionChange( this, 'bulk-album' )" >
<option value="" ></option>
<option value="wppa-bulk-delete" ><?php
_e('Delete', 'wp-photo-album-plus');
?>
</option>
<option value="wppa-bulk-move-to" ><?php
_e('Move to', 'wp-photo-album-plus');
?>
</option>
<option value="wppa-bulk-copy-to" ><?php
_e('Copy to', 'wp-photo-album-plus');
?>
</option>
<?php
if (current_user_can('wppa_admin') || current_user_can('wppa_moderate')) {
?>
<option value="wppa-bulk-status" ><?php
_e('Set status to', 'wp-photo-album-plus');
?>
</option>
<?php
}
?>
<?php
if (wppa_user_is('administrator') && wppa_switch('photo_owner_change')) {
?>
<option value="wppa-bulk-owner" ><?php
_e('Set owner to', 'wp-photo-album-plus');
?>
</option>
<?php
}
?>
</select>
<select name="wppa-bulk-album" id="wppa-bulk-album" style="display:none;" onchange="wppa_setCookie( 'wppa_bulk_album',this.value,365 );" >
<?php
echo wppa_album_select_a(array('checkaccess' => true, 'path' => wppa_switch('hier_albsel'), 'exclude' => $album, 'selected' => '0', 'addpleaseselect' => true));
?>
</select>
<select name="wppa-bulk-status" id="wppa-bulk-status" style="display:none;" onchange="wppa_setCookie( 'wppa_bulk_status',this.value,365 );" >
<option value="" ><?php
_e('- select a status -', 'wp-photo-album-plus');
?>
</option>
<option value="pending" ><?php
_e('Pending', 'wp-photo-album-plus');
?>
</option>
<option value="publish" ><?php
_e('Publish', 'wp-photo-album-plus');
?>
</option>
<?php
if (wppa_switch('ext_status_restricted') && !wppa_user_is('administrator')) {
$dis = ' disabled';
} else {
$dis = '';
}
?>
<option value="featured"<?php
echo $dis;
?>
><?php
_e('Featured', 'wp-photo-album-plus');
?>
</option>
<option value="gold" <?php
echo $dis;
?>
><?php
_e('Gold', 'wp-photo-album-plus');
?>
</option>
<option value="silver" <?php
echo $dis;
?>
><?php
_e('Silver', 'wp-photo-album-plus');
?>
</option>
<option value="bronze" <?php
echo $dis;
?>
><?php
_e('Bronze', 'wp-photo-album-plus');
?>
</option>
<option value="scheduled" <?php
echo $dis;
?>
><?php
_e('Scheduled', 'wp-photo-album-plus');
?>
</option>
<option value="private" <?php
echo $dis;
?>
><?php
_e('Private', 'wp-photo-album-plus');
?>
</option>
</select>
<!-- Owner -->
<?php
$users = wppa_get_users();
if (count($users)) {
?>
<select name="wppa-bulk-owner" id="wppa-bulk-owner" style="display:none;" onchange="wppa_setCookie( 'wppa_bulk_owner',this.value,365 );">
<option value="" ><?php
_e('- select an owner -', 'wp-photo-album-plus');
?>
</option>
<?php
foreach ($users as $user) {
echo '<option value="' . $user['user_login'] . '" >' . $user['display_name'] . ' (' . $user['user_login'] . ')</option>';
}
?>
</select>
<?php
} else {
?>
<input name="wppa-bulk-owner" id="wppa-bulk-owner" style="display:none;" onchange="wppa_setCookie( 'wppa_bulk_owner',this.value,365 );" />
<?php
}
?>
<!-- Submit -->
<input type="submit" onclick="return wppaBulkDoitOnClick()" class="button-primary" value="<?php
_e('Doit!', 'wp-photo-album-plus');
?>
" />
<span style="font-family:sans-serif; font-size:12px; font-style:italic; font-weight:normal;" >
<?php
_e('Pressing this button will reload the page after executing the selected action', 'wp-photo-album-plus');
?>
</span>
</h3>
<table class="widefat" >
<thead style="font-weight:bold;" >
<td><input type="checkbox" class="wppa-bulk-photo" onchange="jQuery( '.wppa-bulk-photo' ).attr( 'checked', this.checked );" /></td>
<td><?php
_e('ID', 'wp-photo-album-plus');
?>
</td>
<td><?php
_e('Preview', 'wp-photo-album-plus');
?>
</td>
<td><?php
_e('Name', 'wp-photo-album-plus');
?>
</td>
<td><?php
_e('Description', 'wp-photo-album-plus');
?>
</td>
<td><?php
_e('Status', 'wp-photo-album-plus');
?>
</td>
<td><?php
_e('Owner', 'wp-photo-album-plus');
?>
</td>
<td><?php
_e('Remark', 'wp-photo-album-plus');
?>
</td>
</thead>
<tbody>
<?php
foreach ($photos as $photo) {
?>
<?php
$id = $photo['id'];
?>
<tr id="photoitem-<?php
echo $photo['id'];
?>
" >
<!-- Checkbox -->
<td>
<input type="hidden" id="photo-nonce-<?php
echo $photo['id'];
?>
" value="<?php
echo wp_create_nonce('wppa_nonce_' . $photo['id']);
?>
" />
<input type="checkbox" name="wppa-bulk-photo[<?php
echo $photo['id'];
?>
]" class="wppa-bulk-photo" />
</td>
<!-- ID and delete link -->
<td><?php
echo $photo['id'];
?>
<br /><a onclick="if ( confirm( '<?php
_e('Are you sure you want to delete this photo?', 'wp-photo-album-plus');
?>
' ) ) wppaAjaxDeletePhoto( <?php
echo $photo['id'];
?>
, '<td colspan=3 >', '</td>' )" style="color:red;font-weight:bold;"><?php
_e('Delete', 'wp-photo-album-plus');
?>
</a>
</td>
<!-- Preview -->
<td style="min-width:240px; text-align:center;" >
<?php
if (wppa_is_video($photo['id'])) {
?>
<a href="<?php
echo str_replace('xxx', 'mp4', wppa_get_photo_url($photo['id']));
?>
" target="_blank" title="Click to see fullsize" >
<?php
// Animating size changes of a video tag is not a good idea. It will rapidly screw up browser cache and cpu
?>
<?php
echo wppa_get_video_html(array('id' => $id, 'height' => '60', 'controls' => false, 'tagid' => 'pa-id-' . $id, 'events' => ' onmouseover="jQuery( this ).css( \'height\', \'160\' )" onmouseout="jQuery( this ).css( \'height\', \'60\' )"', 'preload' => 'metadata', 'use_thumb' => true));
?>
<!-- <video preload="metadata" style="height:60px;" onmouseover="jQuery( this ).css( 'height', '160' )" onmouseout="jQuery( this ).css( 'height', '60' )" >
<?php
// echo wppa_get_video_body( $photo['id'] )
?>
</video> -->
</a>
<?php
} else {
?>
<a href="<?php
echo wppa_fix_poster_ext(wppa_get_photo_url($photo['id']), $photo['id']);
?>
" target="_blank" title="Click to see fullsize" >
<img class="wppa-bulk-thumb" src="<?php
echo wppa_fix_poster_ext(wppa_get_thumb_url($photo['id']), $photo['id']);
?>
" style="height:60px;" onmouseover="jQuery( this ).stop().animate( {height:120}, 100 )" onmouseout="jQuery( this ).stop().animate( {height:60}, 100 )" />
</a>
<?php
}
?>
</td>
<td style="width:25%;" >
<input type="text" style="width:100%;" id="pname-<?php
echo $photo['id'];
?>
" onchange="wppaAjaxUpdatePhoto( <?php
echo $photo['id'];
?>
, 'name', this );" value="<?php
echo esc_attr(stripslashes($photo['name']));
?>
" />
<?php
if (wppa_is_video($photo['id'])) {
echo '<br />' . wppa_get_videox($photo['id']) . ' x ' . wppa_get_videoy($photo['id']) . ' px.';
} else {
$sp = wppa_get_source_path($photo['id']);
if (is_file($sp)) {
$ima = getimagesize($sp);
if (is_array($ima)) {
echo '<br />' . $ima['0'] . ' x ' . $ima['1'] . ' px.';
}
}
}
?>
</td>
<!-- Description -->
<td style="width:25%;" >
<textarea class="wppa-bulk-dec" style="height:50px; width:100%" onchange="wppaAjaxUpdatePhoto( <?php
echo $photo['id'];
?>
, 'description', this )" ><?php
echo stripslashes($photo['description']);
?>
</textarea>
</td>
<!-- Status -->
<td>
<?php
if (current_user_can('wppa_admin') || current_user_can('wppa_moderate')) {
?>
<select id="status-<?php
echo $photo['id'];
?>
" onchange="wppaAjaxUpdatePhoto( <?php
echo $photo['id'];
?>
, 'status', this ); wppaPhotoStatusChange( <?php
echo $photo['id'];
?>
); ">
<option value="pending" <?php
if ($photo['status'] == 'pending') {
echo 'selected="selected"';
}
?>
><?php
_e('Pending', 'wp-photo-album-plus');
?>
</option>
<option value="publish" <?php
if ($photo['status'] == 'publish') {
echo 'selected="selected"';
}
?>
><?php
_e('Publish', 'wp-photo-album-plus');
?>
</option>
<?php
if (wppa_switch('ext_status_restricted') && !wppa_user_is('administrator')) {
$dis = ' disabled';
} else {
$dis = '';
}
?>
<option value="featured" <?php
if ($photo['status'] == 'featured') {
echo 'selected="selected"';
}
echo $dis;
?>
><?php
_e('Featured', 'wp-photo-album-plus');
?>
</option>
<option value="gold" <?php
if ($photo['status'] == 'gold') {
echo 'selected="selected"';
}
echo $dis;
?>
><?php
_e('Gold', 'wp-photo-album-plus');
?>
</option>
<option value="silver" <?php
if ($photo['status'] == 'silver') {
echo 'selected="selected"';
}
echo $dis;
?>
><?php
_e('Silver', 'wp-photo-album-plus');
?>
</option>
<option value="bronze" <?php
if ($photo['status'] == 'bronze') {
echo 'selected="selected"';
}
echo $dis;
?>
><?php
_e('Bronze', 'wp-photo-album-plus');
?>
</option>
<option value="scheduled" <?php
if ($photo['status'] == 'scheduled') {
echo 'selected="selected"';
}
echo $dis;
?>
><?php
_e('Scheduled', 'wp-photo-album-plus');
?>
</option>
<option value="private" <?php
if ($photo['status'] == 'private') {
echo 'selected="selected"';
}
echo $dis;
?>
><?php
_e('Private', 'wp-photo-album-plus');
?>
</option>
</select>
<?php
} else {
if ($photo['status'] == 'pending') {
_e('Pending', 'wp-photo-album-plus');
} elseif ($photo['status'] == 'publish') {
_e('Publish', 'wp-photo-album-plus');
} elseif ($photo['status'] == 'featured') {
e('Featured');
} elseif ($photo['status'] == 'gold') {
_e('Gold', 'wp-photo-album-plus');
} elseif ($photo['status'] == 'silver') {
_e('Silver', 'wp-photo-album-plus');
} elseif ($photo['status'] == 'bronze') {
_e('Bronze', 'wp-photo-album-plus');
} elseif ($photo['status'] == 'scheduled') {
_e('Scheduled', 'wp-photo-album-plus');
} elseif ($photo['status'] == 'private') {
_e('Private', 'wp-photo-album-plus');
}
}
?>
</td>
<!-- Owner -->
<td>
<?php
echo $photo['owner'];
?>
</td>
<!-- Remark -->
<td id="photostatus-<?php
echo $photo['id'];
?>
" style="width:25%;" >
<?php
_e('Not modified', 'wp-photo-album-plus');
?>
<script type="text/javascript">wppaPhotoStatusChange( <?php
echo $photo['id'];
?>
)</script>
</td>
</tr>
<?php
}
?>
</tbody>
<tfoot style="font-weight:bold;" >
<td><input type="checkbox" class="wppa-bulk-photo" onchange="jQuery( '.wppa-bulk-photo' ).attr( 'checked', this.checked );" /></td>
<td><?php
_e('ID', 'wp-photo-album-plus');
?>
</td>
<td><?php
_e('Preview', 'wp-photo-album-plus');
?>
</td>
<td><?php
_e('Name', 'wp-photo-album-plus');
?>
</td>
<td><?php
_e('Description', 'wp-photo-album-plus');
?>
</td>
<td><?php
_e('Status', 'wp-photo-album-plus');
?>
</td>
<td><?php
_e('Owner', 'wp-photo-album-plus');
?>
</td>
<td><?php
_e('Remark', 'wp-photo-album-plus');
?>
</td>
</tfoot>
</table>
</form>
<?php
wppa_admin_page_links($page, $pagesize, $count, $link);
} else {
if ($page == '1') {
if (isset($_REQUEST['wppa-searchstring'])) {
echo '<h3>' . __('No photos matching your search criteria.', 'wp-photo-album-plus') . '</h3>';
} else {
echo '<h3>' . __('No photos yet in this album.', 'wp-photo-album-plus') . '</h3>';
}
} else {
$page_1 = $page - '1';
echo sprintf(__('Page %d is empty, try <a href="%s" >page %d</a>.', 'wp-photo-album-plus'), $page, $link . '&wppa-page=' . $page_1 . '#manage-photos', $page_1);
}
}
} else {
wppa_dbg_msg('Missing required argument in wppa_album_photos() 2', 'red', 'force');
}
}
function wppa_del_album($id, $move = '')
{
global $wpdb;
if ($move && !wppa_have_access($move)) {
wppa_error_message(__('Unable to move photos to album %s. Album not deleted.', 'wp-photo-album-plus'));
return false;
}
// Photos in the album
$photos = $wpdb->get_results($wpdb->prepare('SELECT * FROM `' . WPPA_PHOTOS . '` WHERE `album` = %s', $id), ARRAY_A);
if (empty($move)) {
// will delete all the album's photos
if (is_array($photos)) {
$cnt = '0';
foreach ($photos as $photo) {
$t = -microtime(true);
wppa_delete_photo($photo['id']);
$cnt++;
$t += microtime(true);
// wppa_dbg_msg('Del photo took :'.$t, 'red', 'force');
// Time up?
if (wppa_is_time_up()) {
wppa_flush_treecounts($id);
$msg = sprintf(__('Time is out after %d photo deletes. Please redo this operation', 'wp-photo-album-plus'), $cnt);
if (wppa('ajax')) {
echo $msg;
} else {
wppa_error_message($msg);
}
return;
}
}
}
} else {
// Move
if (is_array($photos)) {
foreach ($photos as $photo) {
$wpdb->query($wpdb->prepare('UPDATE `' . WPPA_PHOTOS . '` SET `album` = %s WHERE `id` = %s', $move, $photo['id']));
wppa_move_source($photo['filename'], $photo['album'], $move);
if (wppa_is_time_up()) {
wppa_error_message('Time is out. Please redo this operation');
return;
}
}
}
wppa_flush_treecounts($move);
}
// First flush treecounts, otherwise we do not know the parent if any
wppa_flush_treecounts($id);
// Now delete the album
$wpdb->query($wpdb->prepare('DELETE FROM `' . WPPA_ALBUMS . '` WHERE `id` = %s LIMIT 1', $id));
wppa_delete_album_source($id);
wppa_index_remove('album', $id);
$msg = __('Album Deleted.', 'wp-photo-album-plus');
if (wppa('ajax')) {
echo $msg;
} else {
wppa_update_message($msg);
}
}
function wppa_do_maintenance_proc($slug)
{
global $wpdb;
global $wppa_session;
global $wppa_supported_video_extensions;
global $wppa_supported_audio_extensions;
// Check for multiple maintenance procs
if (!wppa_switch('maint_ignore_concurrency_error') && !wppa_is_cron()) {
$all_slugs = array('wppa_remake_index_albums', 'wppa_remove_empty_albums', 'wppa_remake_index_photos', 'wppa_apply_new_photodesc_all', 'wppa_append_to_photodesc', 'wppa_remove_from_photodesc', 'wppa_remove_file_extensions', 'wppa_readd_file_extensions', 'wppa_all_ext_to_lower', 'wppa_regen_thumbs', 'wppa_rerate', 'wppa_recup', 'wppa_file_system', 'wppa_cleanup', 'wppa_remake', 'wppa_list_index', 'wppa_blacklist_user', 'wppa_un_blacklist_user', 'wppa_rating_clear', 'wppa_viewcount_clear', 'wppa_iptc_clear', 'wppa_exif_clear', 'wppa_watermark_all', 'wppa_create_all_autopages', 'wppa_delete_all_autopages', 'wppa_leading_zeros', 'wppa_add_gpx_tag', 'wppa_optimize_ewww', 'wppa_comp_sizes', 'wppa_edit_tag', 'wppa_sync_cloud', 'wppa_sanitize_tags', 'wppa_sanitize_cats', 'wppa_test_proc', 'wppa_crypt_photos', 'wppa_crypt_albums', 'wppa_create_o1_files', 'wppa_owner_to_name_proc', 'wppa_move_all_photos');
foreach (array_keys($all_slugs) as $key) {
if ($all_slugs[$key] != $slug) {
if (get_option($all_slugs[$key] . '_togo', '0')) {
// Process running
return __('You can run only one maintenance procedure at a time', 'wp-photo-album-plus') . '||' . $slug . '||' . __('Error', 'wp-photo-album-plus') . '||' . '' . '||' . '';
}
}
}
}
// Lock this proc
if (wppa_is_cron()) {
update_option($slug . '_user', 'cron-job');
update_option($slug . '_lasttimestamp', time());
} else {
update_option($slug . '_user', wppa_get_user());
}
// Extend session
wppa_extend_session();
// Initialize
// Cron job: 30 sec, realtime: 5 sec
$endtime = wppa_is_cron() ? time() + '30' : time() + '5';
$chunksize = '1000';
$lastid = strval(intval(get_option($slug . '_last', '0')));
$errtxt = '';
$id = '0';
$topid = '0';
$reload = '';
$to_delete_from_cloudinary = array();
if (!isset($wppa_session)) {
$wppa_session = array();
}
if (!isset($wppa_session[$slug . '_fixed'])) {
$wppa_session[$slug . '_fixed'] = '0';
}
if (!isset($wppa_session[$slug . '_added'])) {
$wppa_session[$slug . '_added'] = '0';
}
if (!isset($wppa_session[$slug . '_deleted'])) {
$wppa_session[$slug . '_deleted'] = '0';
}
if (!isset($wppa_session[$slug . '_skipped'])) {
$wppa_session[$slug . '_skipped'] = '0';
}
if ($lastid == '0') {
$wppa_session[$slug . '_fixed'] = '0';
$wppa_session[$slug . '_deleted'] = '0';
$wppa_session[$slug . '_skipped'] = '0';
}
wppa_save_session();
// Pre-processing needed?
if ($lastid == '0') {
if (wppa_is_cron()) {
wppa_log('Obs', 'Cron job ' . $slug . ' started.');
} else {
wppa_log('Obs', 'Maintenance proc ' . $slug . ' started.');
}
switch ($slug) {
case 'wppa_remake_index_albums':
// Pre-Clear album index only if not cron
if (!wppa_is_cron()) {
$wpdb->query("UPDATE `" . WPPA_INDEX . "` SET `albums` = ''");
}
break;
case 'wppa_remake_index_photos':
// Pre-Clear photo index only if not cron
if (!wppa_is_cron()) {
$wpdb->query("UPDATE `" . WPPA_INDEX . "` SET `photos` = ''");
}
wppa_index_compute_skips();
break;
case 'wppa_recup':
// Pre-Clear exif and iptc tables only if not cron
if (!wppa_is_cron()) {
$wpdb->query("DELETE FROM `" . WPPA_IPTC . "` WHERE `photo` <> '0'");
$wpdb->query("DELETE FROM `" . WPPA_EXIF . "` WHERE `photo` <> '0'");
}
break;
case 'wppa_file_system':
if (get_option('wppa_file_system') == 'flat') {
update_option('wppa_file_system', 'to-tree');
}
if (get_option('wppa_file_system') == 'tree') {
update_option('wppa_file_system', 'to-flat');
}
break;
case 'wppa_cleanup':
$orphan_album = get_option('wppa_orphan_album', '0');
$album_exists = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM`" . WPPA_ALBUMS . "` WHERE `id` = %s", $orphan_album));
if (!$album_exists) {
$orphan_album = false;
}
if (!$orphan_album) {
$orphan_album = wppa_create_album_entry(array('name' => __('Orphan photos', 'wp-photo-album-plus'), 'a_parent' => '-1', 'description' => __('This album contains refound lost photos', 'wp-photo-album-plus')));
update_option('wppa_orphan_album', $orphan_album);
}
break;
case 'wppa_sync_cloud':
if (!wppa_get_present_at_cloudinary_a()) {
// Still Initializing
$status = 'Initializing';
if (!isset($wppa_session['fun-count'])) {
$wppa_session['fun-count'] = 0;
}
$wppa_session['fun-count'] = ($wppa_session['fun-count'] + 1) % 3;
for ($i = 0; $i < $wppa_session['fun-count']; $i++) {
$status .= '.';
}
$togo = 'all';
$reload = false;
echo '||' . $slug . '||' . $status . '||' . $togo . '||' . $reload;
wppa_exit();
}
break;
case 'wppa_crypt_albums':
update_option('wppa_album_crypt_0', wppa_get_unique_album_crypt());
update_option('wppa_album_crypt_1', wppa_get_unique_album_crypt());
update_option('wppa_album_crypt_2', wppa_get_unique_album_crypt());
update_option('wppa_album_crypt_3', wppa_get_unique_album_crypt());
update_option('wppa_album_crypt_9', wppa_get_unique_album_crypt());
break;
case 'wppa_owner_to_name_proc':
if (!wppa_switch('owner_to_name')) {
echo __('Feature must be enabled in Table IV-A28 first', 'wp-photo-album-plus') . '||' . $slug . '||||||';
wppa_exit();
}
break;
case 'wppa_move_all_photos':
$fromalb = get_option('wppa_move_all_photos_from');
if (!wppa_album_exists($fromalb)) {
echo sprintf(__('From album %d does not exist', 'wp-photo-album-plus'), $fromalb);
wppa_exit();
}
$toalb = get_option('wppa_move_all_photos_to');
if (!wppa_album_exists($toalb)) {
echo sprintf(__('To album %d does not exist', 'wp-photo-album-plus'), $toalb);
wppa_exit();
}
if ($fromalb == $toalb) {
echo __('From and To albums are identical', 'wp-photo-album-plus');
wppa_exit();
}
break;
}
wppa_save_session();
}
// Dispatch on albums / photos / single actions
switch ($slug) {
case 'wppa_remake_index_albums':
case 'wppa_remove_empty_albums':
case 'wppa_sanitize_cats':
case 'wppa_crypt_albums':
// Process albums
$table = WPPA_ALBUMS;
$topid = $wpdb->get_var("SELECT `id` FROM `" . WPPA_ALBUMS . "` ORDER BY `id` DESC LIMIT 1");
$albums = $wpdb->get_results("SELECT * FROM `" . WPPA_ALBUMS . "` WHERE `id` > " . $lastid . " ORDER BY `id` LIMIT 100", ARRAY_A);
wppa_cache_album('add', $albums);
if ($albums) {
foreach ($albums as $album) {
$id = $album['id'];
switch ($slug) {
case 'wppa_remake_index_albums':
// If done as cron job, no initial clear has been done
if (wppa_is_cron()) {
wppa_index_remove('album', $id);
}
wppa_index_add('album', $id);
break;
case 'wppa_remove_empty_albums':
$p = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM `" . WPPA_PHOTOS . "` WHERE `album` = %s", $id));
$a = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM `" . WPPA_ALBUMS . "` WHERE `a_parent` = %s", $id));
if (!$a && !$p) {
$wpdb->query($wpdb->prepare("DELETE FROM `" . WPPA_ALBUMS . "` WHERE `id` = %s", $id));
wppa_delete_album_source($id);
wppa_flush_treecounts($id);
wppa_index_remove('album', $id);
}
break;
case 'wppa_sanitize_cats':
$cats = $album['cats'];
if ($cats) {
wppa_update_album(array('id' => $album['id'], 'cats' => wppa_sanitize_tags($cats)));
}
break;
case 'wppa_crypt_albums':
wppa_update_album(array('id' => $album['id'], 'crypt' => wppa_get_unique_album_crypt()));
break;
}
// Test for timeout / ready
$lastid = $id;
update_option($slug . '_last', $lastid);
if (time() > $endtime) {
break;
}
// Time out
}
} else {
// Nothing to do, Done anyway
$lastid = $topid;
}
break;
// End process albums
// End process albums
case 'wppa_remake_index_photos':
case 'wppa_apply_new_photodesc_all':
case 'wppa_append_to_photodesc':
case 'wppa_remove_from_photodesc':
case 'wppa_remove_file_extensions':
case 'wppa_readd_file_extensions':
case 'wppa_all_ext_to_lower':
case 'wppa_regen_thumbs':
case 'wppa_rerate':
case 'wppa_recup':
case 'wppa_file_system':
case 'wppa_cleanup':
case 'wppa_remake':
case 'wppa_watermark_all':
case 'wppa_create_all_autopages':
case 'wppa_delete_all_autopages':
case 'wppa_leading_zeros':
case 'wppa_add_gpx_tag':
case 'wppa_optimize_ewww':
case 'wppa_comp_sizes':
case 'wppa_edit_tag':
case 'wppa_sync_cloud':
case 'wppa_sanitize_tags':
case 'wppa_crypt_photos':
case 'wppa_test_proc':
case 'wppa_create_o1_files':
case 'wppa_owner_to_name_proc':
case 'wppa_move_all_photos':
// Process photos
$table = WPPA_PHOTOS;
if ($slug == 'wppa_cleanup') {
$topid = get_option('wppa_' . WPPA_PHOTOS . '_lastkey', '1') * 10;
$photos = array();
for ($i = $lastid + '1'; $i <= $topid; $i++) {
$photos[]['id'] = $i;
}
} else {
$topid = $wpdb->get_var("SELECT `id` FROM `" . WPPA_PHOTOS . "` ORDER BY `id` DESC LIMIT 1");
$photos = $wpdb->get_results("SELECT * FROM `" . WPPA_PHOTOS . "` WHERE `id` > " . $lastid . " ORDER BY `id` LIMIT " . $chunksize, ARRAY_A);
}
if ($slug == 'wppa_edit_tag') {
$edit_tag = get_option('wppa_tag_to_edit');
$new_tag = get_option('wppa_new_tag_value');
}
if (!$photos && $slug == 'wppa_file_system') {
$fs = get_option('wppa_file_system');
if ($fs == 'to-tree') {
$to = 'tree';
} elseif ($fs == 'to-flat') {
$to = 'flat';
} else {
$to = $fs;
}
}
if ($photos) {
foreach ($photos as $photo) {
$thumb = $photo;
// Make globally known
$id = $photo['id'];
switch ($slug) {
case 'wppa_remake_index_photos':
// If done as cron job, no initial clear has been done
if (wppa_is_cron()) {
wppa_index_remove('photo', $id);
}
wppa_index_add('photo', $id);
break;
case 'wppa_apply_new_photodesc_all':
$value = wppa_opt('newphoto_description');
$description = trim($value);
if ($description != $photo['description']) {
// Modified photo description
$wpdb->query($wpdb->prepare("UPDATE `" . WPPA_PHOTOS . "` SET `description` = %s WHERE `id` = %s", $description, $id));
}
break;
case 'wppa_append_to_photodesc':
$value = trim(wppa_opt('append_text'));
if (!$value) {
return 'Unexpected error: missing text to append||' . $slug . '||Error||0';
}
$description = rtrim($photo['description'] . ' ' . $value);
if ($description != $photo['description']) {
// Modified photo description
$wpdb->query($wpdb->prepare("UPDATE `" . WPPA_PHOTOS . "` SET `description` = %s WHERE `id` = %s", $description, $id));
}
break;
case 'wppa_remove_from_photodesc':
$value = trim(wppa_opt('remove_text'));
if (!$value) {
return 'Unexpected error: missing text to remove||' . $slug . '||Error||0';
}
$description = rtrim(str_replace($value, '', $photo['description']));
if ($description != $photo['description']) {
// Modified photo description
$wpdb->query($wpdb->prepare("UPDATE `" . WPPA_PHOTOS . "` SET `description` = %s WHERE `id` = %s", $description, $id));
}
break;
case 'wppa_remove_file_extensions':
if (!wppa_is_video($id)) {
$name = str_replace(array('.jpg', '.png', '.gif', '.JPG', '.PNG', '.GIF'), '', $photo['name']);
if ($name != $photo['name']) {
// Modified photo name
$wpdb->query($wpdb->prepare("UPDATE `" . WPPA_PHOTOS . "` SET `name` = %s WHERE `id` = %s", $name, $id));
}
}
break;
case 'wppa_readd_file_extensions':
if (!wppa_is_video($id)) {
$name = str_replace(array('.jpg', '.png', 'gif', '.JPG', '.PNG', '.GIF'), '', $photo['name']);
if ($name == $photo['name']) {
// Name had no fileextension
$wpdb->query($wpdb->prepare("UPDATE `" . WPPA_PHOTOS . "` SET `name` = %s WHERE `id` = %s", $name . '.' . $photo['ext'], $id));
}
}
break;
case 'wppa_all_ext_to_lower':
$EXT = wppa_get_photo_item($id, 'ext');
$ext = strtolower($EXT);
if ($EXT != $ext) {
wppa_update_photo(array('id' => $id, 'ext' => $ext));
$fixed_this = true;
}
$EXT = strtoupper($ext);
$rawpath = wppa_strip_ext(wppa_get_photo_path($id));
$rawthumb = wppa_strip_ext(wppa_get_thumb_path($id));
$fixed_this = false;
if (wppa_is_multi($id)) {
} else {
if (is_file($rawpath . '.' . $EXT)) {
if (is_file($rawpath . '.' . $ext)) {
unlink($rawpath . '.' . $EXT);
} else {
rename($rawpath . '.' . $EXT, $rawpath . '.' . $ext);
}
$fixed_this = true;
}
if (is_file($rawthumb . '.' . $EXT)) {
if (is_file($rawthumb . '.' . $ext)) {
unlink($rawthumb . '.' . $EXT);
} else {
rename($rawthumb . '.' . $EXT, $rawthumb . '.' . $ext);
}
$fixed_this = true;
}
}
if ($fixed_this) {
$wppa_session[$slug . '_fixed']++;
} else {
$wppa_session[$slug . '_skipped']++;
}
break;
case 'wppa_regen_thumbs':
if (!wppa_is_video($id) || file_exists(str_replace('xxx', 'jpg', wppa_get_photo_path($id)))) {
wppa_create_thumbnail($id);
}
break;
case 'wppa_rerate':
wppa_rate_photo($id);
break;
case 'wppa_recup':
$a_ret = wppa_recuperate($id);
if ($a_ret['iptcfix']) {
$wppa_session[$slug . '_fixed']++;
}
if ($a_ret['exiffix']) {
$wppa_session[$slug . '_fixed']++;
}
break;
case 'wppa_file_system':
$fs = get_option('wppa_file_system');
if ($fs == 'to-tree' || $fs == 'to-flat') {
if ($fs == 'to-tree') {
$from = 'flat';
$to = 'tree';
} else {
$from = 'tree';
$to = 'flat';
}
// Media files
if (wppa_is_multi($id)) {
// Can NOT use wppa_has_audio() or wppa_is_video(), they use wppa_get_photo_path() without fs switch!!
$exts = array_merge($wppa_supported_video_extensions, $wppa_supported_audio_extensions);
$pathfrom = wppa_get_photo_path($id, $from);
$pathto = wppa_get_photo_path($id, $to);
// wppa_log( 'dbg', 'Trying: '.$pathfrom );
foreach ($exts as $ext) {
if (is_file(str_replace('.xxx', '.' . $ext, $pathfrom))) {
// wppa_log( 'dbg', str_replace( '.xxx', '.'.$ext, $pathfrom ).' -> '.str_replace( '.xxx', '.'.$ext, $pathto ));
@rename(str_replace('.xxx', '.' . $ext, $pathfrom), str_replace('.xxx', '.' . $ext, $pathto));
}
}
}
// Poster / photo
if (file_exists(wppa_fix_poster_ext(wppa_get_photo_path($id, $from), $id))) {
@rename(wppa_fix_poster_ext(wppa_get_photo_path($id, $from), $id), wppa_fix_poster_ext(wppa_get_photo_path($id, $to), $id));
}
// Thumbnail
if (file_exists(wppa_fix_poster_ext(wppa_get_thumb_path($id, $from), $id))) {
@rename(wppa_fix_poster_ext(wppa_get_thumb_path($id, $from), $id), wppa_fix_poster_ext(wppa_get_thumb_path($id, $to), $id));
}
}
break;
case 'wppa_cleanup':
$photo_files = glob(WPPA_UPLOAD_PATH . '/' . $id . '.*');
// Remove dirs
if ($photo_files) {
foreach (array_keys($photo_files) as $key) {
if (is_dir($photo_files[$key])) {
unset($photo_files[$key]);
}
}
}
// files left? process
if ($photo_files) {
foreach ($photo_files as $photo_file) {
$basename = basename($photo_file);
$ext = substr($basename, strpos($basename, '.') + '1');
if (!$wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM `" . WPPA_PHOTOS . "` WHERE `id` = %s", $id))) {
// no db entry for this photo
if (wppa_is_id_free(WPPA_PHOTOS, $id)) {
if (wppa_create_photo_entry(array('id' => $id, 'album' => $orphan_album, 'ext' => $ext, 'filename' => $basename))) {
// Can create entry
$wppa_session[$slug . '_fixed']++;
// Bump counter
wppa_log('Debug', 'Lost photo file ' . $photo_file . ' recovered');
} else {
wppa_log('Debug', 'Unable to recover lost photo file ' . $photo_file . ' Create photo entry failed');
}
} else {
wppa_log('Debug', 'Could not recover lost photo file ' . $photo_file . ' The id is not free');
}
}
}
}
break;
case 'wppa_remake':
$doit = true;
if (wppa_switch('remake_orientation_only')) {
$ori = wppa_get_exif_orientation(wppa_get_source_path($id));
if ($ori < '2') {
$doit = false;
}
}
if (wppa_switch('remake_missing_only')) {
if (is_file(wppa_get_thumb_path($id)) && is_file(wppa_get_photo_path($id))) {
$doit = false;
}
}
if ($doit && wppa_remake_files('', $id)) {
$wppa_session[$slug . '_fixed']++;
} else {
$wppa_session[$slug . '_skipped']++;
}
break;
case 'wppa_watermark_all':
if (!wppa_is_video($id)) {
if (wppa_add_watermark($id)) {
wppa_create_thumbnail($id);
// create new thumb
$wppa_session[$slug . '_fixed']++;
} else {
$wppa_session[$slug . '_skipped']++;
}
} else {
$wppa_session[$slug . '_skipped']++;
}
break;
case 'wppa_create_all_autopages':
wppa_get_the_auto_page($id);
break;
case 'wppa_delete_all_autopages':
wppa_remove_the_auto_page($id);
break;
case 'wppa_leading_zeros':
$name = $photo['name'];
if (wppa_is_int($name)) {
$target_len = wppa_opt('zero_numbers');
$name = strval(intval($name));
while (strlen($name) < $target_len) {
$name = '0' . $name;
}
}
if ($name !== $photo['name']) {
$wpdb->query($wpdb->prepare("UPDATE `" . WPPA_PHOTOS . "` SET `name` = %s WHERE `id` = %s", $name, $id));
}
break;
case 'wppa_add_gpx_tag':
$tags = $photo['tags'];
$temp = explode('/', $photo['location']);
if (!isset($temp['2'])) {
$temp['2'] = false;
}
if (!isset($temp['3'])) {
$temp['3'] = false;
}
$lat = $temp['2'];
$lon = $temp['3'];
if ($lat < 0.01 && $lat > -0.01 && $lon < 0.01 && $lon > -0.01) {
$lat = false;
$lon = false;
}
if ($photo['location'] && strpos($tags, 'Gpx') === false && $lat && $lon) {
// Add it
$tags = wppa_sanitize_tags($tags . ',Gpx');
wppa_update_photo(array('id' => $photo['id'], 'tags' => $tags));
wppa_index_update('photo', $photo['id']);
wppa_clear_taglist();
} elseif (strpos($tags, 'Gpx') !== false && !$lat && !$lon) {
// Remove it
$tags = wppa_sanitize_tags(str_replace('Gpx', '', $tags));
wppa_update_photo(array('id' => $photo['id'], 'tags' => $tags));
wppa_index_update('photo', $photo['id']);
wppa_clear_taglist();
}
break;
case 'wppa_optimize_ewww':
$file = wppa_get_photo_path($photo['id']);
if (is_file($file)) {
ewww_image_optimizer($file, 4, false, false, false);
}
$file = wppa_get_thumb_path($photo['id']);
if (is_file($file)) {
ewww_image_optimizer($file, 4, false, false, false);
}
break;
case 'wppa_comp_sizes':
$tx = 0;
$ty = 0;
$px = 0;
$py = 0;
$file = wppa_get_photo_path($photo['id']);
if (is_file($file)) {
$temp = getimagesize($file);
if (is_array($temp)) {
$px = $temp[0];
$py = $temp[1];
}
}
$file = wppa_get_thumb_path($photo['id']);
if (is_file($file)) {
$temp = getimagesize($file);
if (is_array($temp)) {
$tx = $temp[0];
$ty = $temp[1];
}
}
wppa_update_photo(array('id' => $photo['id'], 'thumbx' => $tx, 'thumby' => $ty, 'photox' => $px, 'photoy' => $py));
break;
case 'wppa_edit_tag':
$phototags = explode(',', wppa_get_photo_item($photo['id'], 'tags'));
if (in_array($edit_tag, $phototags)) {
foreach (array_keys($phototags) as $key) {
if ($phototags[$key] == $edit_tag) {
$phototags[$key] = $new_tag;
}
}
$tags = wppa_sanitize_tags(implode(',', $phototags));
wppa_update_photo(array('id' => $photo['id'], 'tags' => $tags));
$wppa_session[$slug . '_fixed']++;
} else {
$wppa_session[$slug . '_skipped']++;
}
break;
case 'wppa_sync_cloud':
$is_old = wppa_opt('max_cloud_life') && time() > $photo['timestamp'] + wppa_opt('max_cloud_life');
// $is_in_cloud = @ getimagesize( wppa_get_cloudinary_url( $photo['id'], 'test_only' ) );
$is_in_cloud = isset($wppa_session['cloudinary_ids'][$photo['id']]);
// wppa_log('Obs', 'Id='.$photo['id'].', is old='.$is_old.', in cloud='.$is_in_cloud);
if ($is_old && $is_in_cloud) {
$to_delete_from_cloudinary[] = strval($photo['id']);
if (count($to_delete_from_cloudinary) == 10) {
wppa_delete_from_cloudinary($to_delete_from_cloudinary);
$to_delete_from_cloudinary = array();
}
$wppa_session[$slug . '_deleted']++;
}
if (!$is_old && !$is_in_cloud) {
wppa_upload_to_cloudinary($photo['id']);
$wppa_session[$slug . '_added']++;
}
if ($is_old && !$is_in_cloud) {
$wppa_session[$slug . '_skipped']++;
}
if (!$is_old && $is_in_cloud) {
$wppa_session[$slug . '_skipped']++;
}
break;
case 'wppa_sanitize_tags':
$tags = $photo['tags'];
if ($tags) {
wppa_update_photo(array('id' => $photo['id'], 'tags' => wppa_sanitize_tags($tags)));
}
break;
case 'wppa_crypt_photos':
wppa_update_photo(array('id' => $photo['id'], 'crypt' => wppa_get_unique_photo_crypt()));
break;
case 'wppa_create_o1_files':
wppa_make_o1_source($photo['id']);
break;
case 'wppa_owner_to_name_proc':
$iret = wppa_set_owner_to_name($id);
if ($iret === true) {
$wppa_session[$slug . '_fixed']++;
}
if ($iret === '0') {
$wppa_session[$slug . '_skipped']++;
}
break;
case 'wppa_move_all_photos':
$fromalb = get_option('wppa_move_all_photos_from');
$toalb = get_option('wppa_move_all_photos_to');
$alb = wppa_get_photo_item($id, 'album');
if ($alb == $fromalb) {
wppa_update_photo(array('id' => $id, 'album' => $toalb));
wppa_move_source(wppa_get_photo_item($id, 'filename'), $fromalb, $toalb);
wppa_flush_treecounts($fromalb);
wppa_flush_treecounts($toalb);
$wppa_session[$slug . '_fixed']++;
}
break;
case 'wppa_test_proc':
$tags = '';
$albid = $photo['album'];
$albnam = wppa_get_album_item($albid, 'name');
$tags .= $albnam;
while ($albid > '0') {
$albid = wppa_get_album_item($albid, 'a_parent');
if ($albid > '0') {
$tags .= ',' . wppa_get_album_item($albid, 'name');
}
}
wppa_update_photo(array('id' => $photo['id'], 'tags' => wppa_sanitize_tags($tags)));
break;
}
// Test for timeout / ready
$lastid = $id;
update_option($slug . '_last', $lastid);
if (time() > $endtime) {
break;
}
// Time out
}
} else {
// Nothing to do, Done anyway
$lastid = $topid;
wppa_log('Debug', 'Maintenance proc ' . $slug . ': Done!');
}
break;
// End process photos
// Single action maintenance modules
// case 'wppa_list_index':
// break;
// case 'wppa_blacklist_user':
// break;
// case 'wppa_un_blacklist_user':
// break;
// case 'wppa_rating_clear':
// break;
// case 'wppa_viewcount_clear':
// break;
// case 'wppa_iptc_clear':
// break;
// case 'wppa_exif_clear':
// break;
// End process photos
// Single action maintenance modules
// case 'wppa_list_index':
// break;
// case 'wppa_blacklist_user':
// break;
// case 'wppa_un_blacklist_user':
// break;
// case 'wppa_rating_clear':
// break;
// case 'wppa_viewcount_clear':
// break;
// case 'wppa_iptc_clear':
// break;
// case 'wppa_exif_clear':
// break;
default:
$errtxt = 'Unimplemented maintenance slug: ' . strip_tags($slug);
}
// either $albums / $photos has been exhousted ( for this try ) or time is up
// Post proc this try:
switch ($slug) {
case 'wppa_sync_cloud':
if (count($to_delete_from_cloudinary) > 0) {
wppa_delete_from_cloudinary($to_delete_from_cloudinary);
}
break;
}
// Find togo
if ($slug == 'wppa_cleanup') {
$togo = $topid - $lastid;
} else {
$togo = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM `" . $table . "` WHERE `id` > %s ", $lastid));
}
// Find status
if (!$errtxt) {
$status = $togo ? 'Working' : 'Ready';
} else {
$status = 'Error';
}
// Not done yet?
if ($togo) {
// If a cron job, reschedule next chunk
if (wppa_is_cron()) {
update_option($slug . '_togo', $togo);
update_option($slug . '_status', 'Running cron');
wppa_schedule_maintenance_proc($slug);
} else {
update_option($slug . '_togo', $togo);
update_option($slug . '_status', 'Pending');
}
} else {
// Report fixed/skipped/deleted
if ($wppa_session[$slug . '_fixed']) {
$status .= ' fixed:' . $wppa_session[$slug . '_fixed'];
unset($wppa_session[$slug . '_fixed']);
}
if ($wppa_session[$slug . '_added']) {
$status .= ' added:' . $wppa_session[$slug . '_added'];
unset($wppa_session[$slug . '_added']);
}
if ($wppa_session[$slug . '_deleted']) {
$status .= ' deleted:' . $wppa_session[$slug . '_deleted'];
unset($wppa_session[$slug . '_deleted']);
}
if ($wppa_session[$slug . '_skipped']) {
$status .= ' skipped:' . $wppa_session[$slug . '_skipped'];
unset($wppa_session[$slug . '_skipped']);
}
// Re-Init options
update_option($slug . '_togo', '');
update_option($slug . '_status', '');
update_option($slug . '_last', '0');
update_option($slug . '_user', '');
update_option($slug . '_lasttimestamp', '0');
// Post-processing needed?
switch ($slug) {
case 'wppa_remake_index_albums':
case 'wppa_remake_index_photos':
$wpdb->query("DELETE FROM `" . WPPA_INDEX . "` WHERE `albums` = '' AND `photos` = ''");
// Remove empty entries
delete_option('wppa_index_need_remake');
break;
case 'wppa_apply_new_photodesc_all':
case 'wppa_append_to_photodesc':
case 'wppa_remove_from_photodesc':
update_option('wppa_remake_index_photos_status', __('Required', 'wp-photo-album-plus'));
break;
case 'wppa_regen_thumbs':
wppa_bump_thumb_rev();
break;
case 'wppa_file_system':
wppa_update_option('wppa_file_system', $to);
$reload = 'reload';
break;
case 'wppa_remake':
wppa_bump_photo_rev();
wppa_bump_thumb_rev();
break;
case 'wppa_edit_tag':
wppa_clear_taglist();
if (wppa_switch('search_tags')) {
update_option('wppa_remake_index_photos_status', __('Required', 'wp-photo-album-plus'));
}
$reload = 'reload';
break;
case 'wppa_sanitize_tags':
wppa_clear_taglist();
break;
case 'wppa_sanitize_cats':
wppa_clear_catlist();
break;
case 'wppa_test_proc':
wppa_clear_taglist();
break;
case 'wppa_sync_cloud':
unset($wppa_session['cloudinary_ids']);
break;
}
wppa_log('Obs', 'Maintenance proc ' . $slug . ' completed');
}
wppa_save_session();
if (wppa_is_cron()) {
wppa_log('obs', $errtxt . '||' . $slug . '||' . $status . '||' . $togo . '||' . $reload);
}
return $errtxt . '||' . $slug . '||' . $status . '||' . $togo . '||' . $reload;
}
