| Server IP : 35.201.19.92 / Your IP : 216.73.216.191 Web Server : nginx System : Linux pod-200961 6.8.0-1055-gke #61-Ubuntu SMP Tue May 26 22:57:42 UTC 2026 x86_64 User : fpm200098 ( 200098) PHP Version : 8.2.34 Disable Function : apache_child_terminate,apache_get_modules,apache_get_version,apache_getenv,apache_note,apache_setenv,disk_free_space,disk_total_space,diskfreespace,dl,exec,fastcgi_finish_request,link,opcache_compile_file,opcache_get_configuration,opcache_invalidate,opcache_is_script_cached,opcache_reset,passthru,pclose,pcntl_exec,popen,posix_getpid,posix_getppid,posix_getpwuid,posix_kill,posix_mkfifo,posix_setegid,posix_seteuid,posix_setgid,posix_setpgid,posix_setsid,posix_setuid,posix_uname,proc_close,proc_get_status,proc_nice,proc_open,proc_terminate,realpath_cache_get,shell_exec,show_source,symlink,system MySQL : OFF | cURL : ON | WGET : OFF | Perl : ON | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /nas/content/live/questfamilyday/wp-content/plugins/wp-seopress-pro/inc/admin/export/ |
Upload File : |
<?php
defined('ABSPATH') or exit('Please don’t call the plugin directly. Thanks :)');
///////////////////////////////////////////////////////////////////////////////////////////////////
//Export SEOPress metadata to CSV
///////////////////////////////////////////////////////////////////////////////////////////////////
//WPML compatibility
add_filter('seopress_metadata_query_args', function ($args, $seopress_get_post_types, $increment, $offset) {
if (defined('ICL_SITEPRESS_VERSION')) {
global $sitepress, $sitepress_settings;
$sitepress_settings['auto_adjust_ids'] = 0;
remove_filter('terms_clauses', [$sitepress, 'terms_clauses']);
remove_filter('category_link', [$sitepress, 'category_link_adjust_id'], 1);
}
return $args;
}, 10, 4);
if (version_compare(SEOPRESS_VERSION, '7.9', '>=')) {
function seopress_metadata_export() {
check_ajax_referer('seopress_export_csv_metadata_nonce', '_ajax_nonce', true);
if ( ! is_admin()) {
wp_send_json_error();
return;
}
if ( ! current_user_can(seopress_capability('manage_options', 'migration'))) {
wp_send_json_error();
return;
}
if (isset($_POST['offset'])) {
$offset = absint($_POST['offset']);
}
$post_export = '';
if (isset($_POST['post_export'])) {
$post_export = esc_attr($_POST['post_export']);
}
$term_export = '';
if (isset($_POST['term_export'])) {
$term_export = esc_attr($_POST['term_export']);
}
$cpt_export = [];
if (isset($_POST['cptData'])) {
foreach ($_POST['cptData'] as $formData) {
if ($formData['name'] === 'post_types[]') {
$cpt_export[] = esc_attr($formData['value']);
}
}
}
$tax_export = [];
if (isset($_POST['taxData'])) {
foreach ($_POST['taxData'] as $formData) {
if ($formData['name'] === 'taxonomies[]') {
$tax_export[] = esc_attr($formData['value']);
}
}
}
//Get post types
$seopress_get_post_types = isset($cpt_export) ? $cpt_export : [];
//Get taxonomies
$seopress_get_taxonomies = isset($tax_export) ? $tax_export : [];
if (empty($seopress_get_post_types) && empty($seopress_get_taxonomies)) {
wp_send_json_error();
return;
}
global $wpdb;
global $post;
//Count posts
$count_items = 0;
$i = 1;
if (empty($seopress_get_post_types)) {
$sql = '((post_type = "post"))';
} else {
$sql = '(';
$count = count($seopress_get_post_types);
foreach ($seopress_get_post_types as $cpt) {
$sql .= '(post_type = "' . $cpt . '")';
if ($i < $count) {
$sql .= ' OR ';
}
++$i;
}
$sql .= ')';
}
$total_count_posts = (int) $wpdb->get_var("SELECT count(*)
FROM {$wpdb->posts}
WHERE $sql
AND (post_status = 'publish' OR post_status = 'pending' OR post_status = 'draft' OR post_status = 'auto-draft' OR post_status = 'future' OR post_status = 'private' OR post_status = 'inherit' OR post_status = 'trash') ");
//Count terms
$total_count_terms = (int) $wpdb->get_var("SELECT count(*) FROM {$wpdb->terms}");
$increment = 200;
$csv = '';
$csv = get_option('seopress_metadata_csv');
$download_url = '';
$settings['id'] = [];
$settings['post_title'] = [];
$settings['url'] = [];
$settings['slug'] = [];
$settings['taxonomy'] = [];
$settings['post_type'] = [];
$settings['meta_title'] = [];
$settings['meta_desc'] = [];
$settings['fb_title'] = [];
$settings['fb_desc'] = [];
$settings['fb_img'] = [];
$settings['tw_title'] = [];
$settings['tw_desc'] = [];
$settings['tw_img'] = [];
$settings['noindex'] = [];
$settings['nofollow'] = [];
$settings['noimageindex'] = [];
$settings['nosnippet'] = [];
$settings['canonical_url'] = [];
$settings['primary_cat'] = [];
$settings['redirect_active'] = [];
$settings['redirect_status'] = [];
$settings['redirect_type'] = [];
$settings['redirect_url'] = [];
$settings['target_kw'] = [];
$metas_key = [
'meta_title' => '_seopress_titles_title',
'meta_desc' => '_seopress_titles_desc',
'fb_title' => '_seopress_social_fb_title',
'fb_desc' => '_seopress_social_fb_desc',
'fb_img' => '_seopress_social_fb_img',
'tw_title' => '_seopress_social_twitter_title',
'tw_desc' => '_seopress_social_twitter_desc',
'tw_img' => '_seopress_social_twitter_img',
'noindex' => '_seopress_robots_index',
'nofollow' => '_seopress_robots_follow',
'noimageindex' => '_seopress_robots_imageindex',
'nosnippet' => '_seopress_robots_snippet',
'canonical_url' => '_seopress_robots_canonical',
'primary_cat' => '_seopress_robots_primary_cat',
'redirect_active' => '_seopress_redirections_enabled',
'redirect_status' => '_seopress_redirections_logged_status',
'redirect_type' => '_seopress_redirections_type',
'redirect_url' => '_seopress_redirections_value',
'target_kw' => '_seopress_analysis_target_kw',
];
//Posts
if ('done' != $post_export) {
if ($offset > $total_count_posts || empty($seopress_get_post_types)) {
wp_reset_postdata();
$count_items = $total_count_posts;
//Reset offset once Posts export is done
$offset = 0;
update_option('seopress_metadata_csv', $csv, false);
$post_export = 'done';
} else {
$args = [
'post_type' => $seopress_get_post_types,
'posts_per_page' => $increment,
'offset' => $offset,
'post_status' => 'any',
'order' => 'DESC',
'orderby' => 'date',
];
$args = apply_filters('seopress_metadata_query_args', $args, $seopress_get_post_types, $increment, $offset);
$meta_query = get_posts($args);
if ($meta_query) {
// The Loop
foreach ($meta_query as $post) {
array_push($settings['id'], $post->ID);
array_push($settings['post_title'], $post->post_title);
array_push($settings['url'], get_permalink($post));
array_push($settings['slug'], $post->post_name);
array_push($settings['taxonomy'], '');
array_push($settings['post_type'], $post->post_type);
foreach($metas_key as $key => $meta_key) {
$meta = get_post_meta($post->ID, $meta_key, true);
if (isset($meta) && false !== $meta) {
array_push($settings[$key], get_post_meta($post->ID, $meta_key, true));
} else {
array_push($settings[$key], '');
}
}
$csv[] = array_merge(
$settings['id'],
$settings['post_title'],
$settings['url'],
$settings['slug'],
$settings['taxonomy'],
$settings['post_type'],
$settings['meta_title'],
$settings['meta_desc'],
$settings['fb_title'],
$settings['fb_desc'],
$settings['fb_img'],
$settings['tw_title'],
$settings['tw_desc'],
$settings['tw_img'],
$settings['noindex'],
$settings['nofollow'],
$settings['noimageindex'],
$settings['nosnippet'],
$settings['canonical_url'],
$settings['primary_cat'],
$settings['redirect_active'],
$settings['redirect_status'],
$settings['redirect_type'],
$settings['redirect_url'],
$settings['target_kw']
);
//Clean arrays
$settings['id'] = [];
$settings['post_title'] = [];
$settings['url'] = [];
$settings['slug'] = [];
$settings['taxonomy'] = [];
$settings['post_type'] = [];
$settings['meta_title'] = [];
$settings['meta_desc'] = [];
$settings['fb_title'] = [];
$settings['fb_desc'] = [];
$settings['fb_img'] = [];
$settings['tw_title'] = [];
$settings['tw_desc'] = [];
$settings['tw_img'] = [];
$settings['noindex'] = [];
$settings['nofollow'] = [];
$settings['noimageindex'] = [];
$settings['nosnippet'] = [];
$settings['canonical_url'] = [];
$settings['primary_cat'] = [];
$settings['redirect_active'] = [];
$settings['redirect_status'] = [];
$settings['redirect_type'] = [];
$settings['redirect_url'] = [];
$settings['target_kw'] = [];
}
}
$offset += $increment;
if ($offset >= $total_count_posts) {
$count_items = $total_count_posts;
} else {
$count_items = $offset;
}
update_option('seopress_metadata_csv', $csv, false);
}
} elseif ('done' != $term_export) {
//Terms
if ($offset > $total_count_terms || empty($seopress_get_taxonomies)) {
$count_items = $total_count_terms + $total_count_posts;
update_option('seopress_metadata_csv', $csv, false);
$post_export = 'done';
$term_export = 'done';
} else {
$args = [
'taxonomy' => $seopress_get_taxonomies,
'number' => $increment,
'offset' => $offset,
'order' => 'DESC',
'orderby' => 'date',
'hide_empty' => false,
];
$args = apply_filters('seopress_metadata_query_terms_args', $args, $seopress_get_taxonomies, $increment, $offset);
$meta_query = get_terms($args);
if ($meta_query) {
// The Loop
foreach ($meta_query as $term) {
if ( is_wp_error($term)) {
continue;
}
if ( !is_object($term)) {
continue;
}
array_push($settings['id'], $term->term_id);
array_push($settings['post_title'], $term->name);
array_push($settings['url'], get_term_link($term));
array_push($settings['slug'], $term->slug);
array_push($settings['taxonomy'], $term->taxonomy);
array_push($settings['post_type'], '');
foreach($metas_key as $key => $meta_key) {
if (get_term_meta($term->term_id, $meta_key, true)) {
array_push($settings[$key], get_term_meta($term->term_id, $meta_key, true));
} else {
array_push($settings[$key], '');
}
}
$csv[] = array_merge(
$settings['id'],
$settings['post_title'],
$settings['url'],
$settings['slug'],
$settings['taxonomy'],
$settings['post_type'],
$settings['meta_title'],
$settings['meta_desc'],
$settings['fb_title'],
$settings['fb_desc'],
$settings['fb_img'],
$settings['tw_title'],
$settings['tw_desc'],
$settings['tw_img'],
$settings['noindex'],
$settings['nofollow'],
$settings['noimageindex'],
$settings['nosnippet'],
$settings['canonical_url'],
$settings['primary_cat'],
$settings['redirect_active'],
$settings['redirect_status'],
$settings['redirect_type'],
$settings['redirect_url'],
$settings['target_kw']
);
//Clean arrays
$settings['id'] = [];
$settings['post_title'] = [];
$settings['url'] = [];
$settings['slug'] = [];
$settings['taxonomy'] = [];
$settings['post_type'] = [];
$settings['meta_title'] = [];
$settings['meta_desc'] = [];
$settings['fb_title'] = [];
$settings['fb_desc'] = [];
$settings['fb_img'] = [];
$settings['tw_title'] = [];
$settings['tw_desc'] = [];
$settings['tw_img'] = [];
$settings['noindex'] = [];
$settings['nofollow'] = [];
$settings['noimageindex'] = [];
$settings['nosnippet'] = [];
$settings['canonical_url'] = [];
$settings['primary_cat'] = [];
$settings['redirect_active'] = [];
$settings['redirect_status'] = [];
$settings['redirect_type'] = [];
$settings['redirect_url'] = [];
$settings['target_kw'] = [];
}
}
$offset += $increment;
if ($offset >= $total_count_terms) {
$count_items = $total_count_terms + $total_count_posts;
} elseif ($offset === 200) {
$count_items = $total_count_posts + 200;
} else {
$count_items += $offset;
}
$post_export = 'done';
update_option('seopress_metadata_csv', $csv, false);
}
} else {
$post_export = 'done';
$term_export = 'done';
}
//Create download URL
if ('done' == $post_export && 'done' == $term_export) {
$args = array_merge($_POST, [
'nonce' => wp_create_nonce('seopress_csv_batch_export_nonce'),
'page' => 'seopress-import-export',
'seopress_action' => 'seopress_download_batch_export',
]);
$download_url = add_query_arg($args, admin_url('admin.php'));
$offset = 'done';
}
//Return data to JSON
$data = [];
$data['count'] = $count_items;
$data['total'] = $total_count_posts + $total_count_terms;
$data['offset'] = $offset;
$data['url'] = $download_url;
$data['post_export'] = $post_export;
$data['term_export'] = $term_export;
wp_send_json_success($data);
}
add_action('wp_ajax_seopress_metadata_export', 'seopress_metadata_export');
}