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 $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_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;
}