get_results( $wpdb->prepare( "SELECT * FROM $wpdb->options WHERE option_name = %s", 'home' ) ); foreach ( $home_url_sql as $home ){ $home_url = $home->option_value; } return untrailingslashit($home_url); } public function output_create_staging_site_page() { update_option('wpvivid_current_running_staging_task','','no'); update_option('wpvivid_staging_task_cancel', false,'no'); $home_url = $this->get_database_home_url(); $admin_url = admin_url(); $admin_name = basename($admin_url); $admin_name = trim($admin_name, '/'); $home_path = get_home_path(); $staging_num = 1; $staging_dir = 'mystaging01'; $staging_content_dir = 'mystaging01'; $default_staging_site = 'mystaging01'; while(1){ $default_staging_site = 'mystaging'.sprintf("%02d", $staging_num); $staging_dir = $home_path.$default_staging_site; if(!file_exists($staging_dir)){ break; } $staging_num++; } $content_dir = WP_CONTENT_DIR; $content_dir = str_replace('\\','/',$content_dir); $content_path = $content_dir.'/'; $staging_num = 1; $default_content_staging_site='mystaging01'; while(1){ $default_content_staging_site = 'mystaging'.sprintf("%02d", $staging_num); $staging_dir = $content_path.$default_content_staging_site; if(!file_exists($staging_dir)){ break; } $staging_num++; } global $wpdb; $prefix=''; $site_id=1; $base_prefix=$wpdb->base_prefix; while(1) { if($site_id<10) { $prefix='wpvividstg0'.$site_id.'_'; } else { $prefix='wpvividstg'.$site_id.'_'; } $sql=$wpdb->prepare("SHOW TABLES LIKE %s;", $wpdb->esc_like($prefix) . '%'); $result = $wpdb->get_results($sql, OBJECT_K); if(empty($result)) { break; } $site_id++; } ?>

Directory to Install the Staging Site

We detected that your web server is Nginx, please add specific rewrite rules to the Nginx config file for the staging site working properly. How to

Custom directory

Home Url: / Directory: /

Choose Database to Install the Staging Site

Custom Table Prefix, By default:

Choose What to Copy to The Staging Site

set_parent_id('wpvivid_custom_staging_list'); $custom_staging_list ->set_staging_home_path(); $custom_staging_list ->display_rows(); $custom_staging_list ->load_js(); ?>
Note: Please don't refresh the page while creating a staging site.
Tips: Please temporarily deactivate all cache, firewall and redirect plugins before creating a staging site to rule out possibilities of unknown failures.