<?php
/**
 * Database upgrade funcs
 *
 * NOTE: whenever called this file, always call Data::get_upgrade_lock and Data::_set_upgrade_lock first.
 *
 * @since  3.0
 */
defined('WPINC') || exit();

use LiteSpeed\Debug2;
use LiteSpeed\Conf;
use LiteSpeed\Admin_Display;
use LiteSpeed\File;

/**
 * Append webp/mobile to url_file
 * @since 5.3
 */
function litespeed_update_5_3()
{
	global $wpdb;
	Debug2::debug('[Data] Upgrade url_file table');
	$tb_exists = $wpdb->get_var('SHOW TABLES LIKE "' . $wpdb->prefix . 'litespeed_url_file"');
	if ($tb_exists) {
		$q =
			'ALTER TABLE `' .
			$wpdb->prefix .
			'litespeed_url_file`
				ADD COLUMN `mobile` tinyint(4) NOT NULL COMMENT "mobile=1",
				ADD COLUMN `webp` tinyint(4) NOT NULL COMMENT "webp=1"
			';
		$wpdb->query($q);
	}
}

/**
 * Add expired to url_file table
 * @since 4.4.4
 */
function litespeed_update_4_4_4()
{
	global $wpdb;
	Debug2::debug('[Data] Upgrade url_file table');
	$tb_exists = $wpdb->get_var('SHOW TABLES LIKE "' . $wpdb->prefix . 'litespeed_url_file"');
	if ($tb_exists) {
		$q =
			'ALTER TABLE `' .
			$wpdb->prefix .
			'litespeed_url_file`
				ADD COLUMN `expired` int(11) NOT NULL DEFAULT 0,
				ADD KEY `filename_2` (`filename`,`expired`),
				ADD KEY `url_id` (`url_id`,`expired`)
			';
		$wpdb->query($q);
	}
}

/**
 * Drop cssjs table and rm cssjs folder
 * @since 4.3
 */
function litespeed_update_4_3()
{
	if (file_exists(LITESPEED_STATIC_DIR . '/ccsjs')) {
		File::rrmdir(LITESPEED_STATIC_DIR . '/ccsjs');
	}
}

/**
 * Drop object cache data file
 * @since 4.1
 */
function litespeed_update_4_1()
{
	if (file_exists(WP_CONTENT_DIR . '/.object-cache.ini')) {
		unlink(WP_CONTENT_DIR . '/.object-cache.ini');
	}
}

/**
 * Drop cssjs table and rm cssjs folder
 * @since 4.0
 */
function litespeed_update_4()
{
	global $wpdb;
	$tb = $wpdb->prefix . 'litespeed_cssjs';
	$existed = $wpdb->get_var("SHOW TABLES LIKE '$tb'");
	if (!$existed) {
		return;
	}

	$q = 'DROP TABLE IF EXISTS ' . $tb;
	$wpdb->query($q);

	if (file_exists(LITESPEED_STATIC_DIR . '/ccsjs')) {
		File::rrmdir(LITESPEED_STATIC_DIR . '/ccsjs');
	}
}

/**
 * Append jQuery to JS optm exclude list for max compatibility
 * Turn off JS Combine and Defer
 *
 * @since  3.5.1
 */
function litespeed_update_3_5()
{
	$__conf = Conf::cls();
	// Excludes jQuery
	foreach (array('optm-js_exc', 'optm-js_defer_exc') as $v) {
		$curr_setting = $__conf->conf($v);
		$curr_setting[] = 'jquery.js';
		$curr_setting[] = 'jquery.min.js';
		$__conf->update($v, $curr_setting);
	}
	// Turn off JS Combine and defer
	$show_msg = false;
	foreach (array('optm-js_comb', 'optm-js_defer', 'optm-js_inline_defer') as $v) {
		$curr_setting = $__conf->conf($v);
		if (!$curr_setting) {
			continue;
		}
		$show_msg = true;
		$__conf->update($v, false);
	}

	if ($show_msg) {
		$msg = sprintf(
			__(
				'LiteSpeed Cache upgraded successfully. NOTE: Due to changes in this version, the settings %1$s and %2$s have been turned OFF. Please turn them back on manually and verify that your site layout is correct, and you have no JS errors.',
				'litespeed-cache'
			),
			'<code>' . __('JS Combine', 'litespeed-cache') . '</code>',
			'<code>' . __('JS Defer', 'litespeed-cache') . '</code>'
		);
		$msg .= sprintf(' <a href="admin.php?page=litespeed-page_optm#settings_js">%s</a>.', __('Click here to settings', 'litespeed-cache'));
		Admin_Display::info($msg, false, true);
	}
}

/**
 * For version under v2.0 to v2.0+
 *
 * @since  3.0
 */
function litespeed_update_2_0($ver)
{
	global $wpdb;

	// Table version only exists after all old data migrated
	// Last modified is v2.4.2
	if (version_compare($ver, '2.4.2', '<')) {
		/**
		 * Convert old data from postmeta to img_optm table
		 * @since  2.0
		 */

		// Migrate data from `wp_postmeta` to `wp_litespeed_img_optm`
		$mids_to_del = array();
		$q = "SELECT * FROM $wpdb->postmeta WHERE meta_key = %s ORDER BY meta_id";
		$meta_value_list = $wpdb->get_results($wpdb->prepare($q, 'litespeed-optimize-data'));
		if ($meta_value_list) {
			$max_k = count($meta_value_list) - 1;
			foreach ($meta_value_list as $k => $v) {
				$md52src_list = maybe_unserialize($v->meta_value);
				foreach ($md52src_list as $md5 => $v2) {
					$f = array(
						'post_id' => $v->post_id,
						'optm_status' => $v2[1],
						'src' => $v2[0],
						'srcpath_md5' => md5($v2[0]),
						'src_md5' => $md5,
						'server' => $v2[2],
					);
					$wpdb->replace($wpdb->prefix . 'litespeed_img_optm', $f);
				}
				$mids_to_del[] = $v->meta_id;

				// Delete from postmeta
				if (count($mids_to_del) > 100 || $k == $max_k) {
					$q = "DELETE FROM $wpdb->postmeta WHERE meta_id IN ( " . implode(',', array_fill(0, count($mids_to_del), '%s')) . ' ) ';
					$wpdb->query($wpdb->prepare($q, $mids_to_del));

					$mids_to_del = array();
				}
			}

			Debug2::debug('[Data] img_optm inserted records: ' . $k);
		}

		$q = "DELETE FROM $wpdb->postmeta WHERE meta_key = %s";
		$rows = $wpdb->query($wpdb->prepare($q, 'litespeed-optimize-status'));
		Debug2::debug('[Data] img_optm delete optm_status records: ' . $rows);
	}

	/**
	 * Add target_md5 field to table
	 * @since  2.4.2
	 */
	if (version_compare($ver, '2.4.2', '<') && version_compare($ver, '2.0', '>=')) {
		// NOTE: For new users, need to bypass this section
		$sql = sprintf('ALTER TABLE `%1$s` ADD `server_info` text NOT NULL, DROP COLUMN `server`', $wpdb->prefix . 'litespeed_img_optm');

		$res = $wpdb->query($sql);
		if ($res !== true) {
			Debug2::debug('[Data] Warning: Alter table img_optm failed!', $sql);
		} else {
			Debug2::debug('[Data] Successfully upgraded table img_optm.');
		}
	}

	// Delete img optm tb version
	delete_option($wpdb->prefix . 'litespeed_img_optm');

	// Delete possible HTML optm data from wp_options
	delete_option('litespeed-cache-optimized');

	// Delete HTML optm tb version
	delete_option($wpdb->prefix . 'litespeed_optimizer');
}

/**
 * Move all options in litespeed-cache-conf from v3.0- to separate records
 *
 * @since  3.0
 */
function litespeed_update_3_0($ver)
{
	global $wpdb;
	// Upgrade v2.0- to v2.0 first
	if (version_compare($ver, '2.0', '<')) {
		litespeed_update_2_0($ver);
	}

	set_time_limit(86400);

	// conv items to litespeed.conf.*
	Debug2::debug('[Data] Conv items to litespeed.conf.*');
	$data = array(
		'litespeed-cache-exclude-cache-roles' => 'cache-exc_roles',
		'litespeed-cache-drop_qs' => 'cache-drop_qs',
		'litespeed-forced_cache_uri' => 'cache-force_uri',
		'litespeed-cache_uri_priv' => 'cache-priv_uri',
		'litespeed-excludes_uri' => 'cache-exc',
		'litespeed-cache-vary-group' => 'cache-vary_group',
		'litespeed-adv-purge_all_hooks' => 'purge-hook_all',
		'litespeed-object_global_groups' => 'object-global_groups',
		'litespeed-object_non_persistent_groups' => 'object-non_persistent_groups',
		'litespeed-media-lazy-img-excludes' => 'media-lazy_exc',
		'litespeed-media-lazy-img-cls-excludes' => 'media-lazy_cls_exc',
		'litespeed-media-webp_attribute' => 'img_optm-webp_attr',
		'litespeed-optm-css' => 'optm-ccss_con',
		'litespeed-optm_excludes' => 'optm-exc',
		'litespeed-optm-ccss-separate_posttype' => 'optm-ccss_sep_posttype',
		'litespeed-optm-css-separate_uri' => 'optm-ccss_sep_uri',
		'litespeed-optm-js-defer-excludes' => 'optm-js_defer_exc',
		'litespeed-cache-dns_prefetch' => 'optm-dns_prefetch',
		'litespeed-cache-exclude-optimization-roles' => 'optm-exc_roles',
		'litespeed-log_ignore_filters' => 'debug-log_no_filters', // depreciated
		'litespeed-log_ignore_part_filters' => 'debug-log_no_part_filters', // depreciated
		'litespeed-cdn-ori_dir' => 'cdn-ori_dir',
		'litespeed-cache-cdn_mapping' => 'cdn-mapping',
		'litespeed-crawler-as-uids' => 'crawler-roles',
		'litespeed-crawler-cookies' => 'crawler-cookies',
	);
	foreach ($data as $k => $v) {
		$old_data = get_option($k);
		if ($old_data) {
			Debug2::debug("[Data] Convert $k");
			// They must be an array
			if (!is_array($old_data) && $v != 'optm-ccss_con') {
				$old_data = explode("\n", $old_data);
			}

			if ($v == 'crawler-cookies') {
				$tmp = array();
				$i = 0;
				foreach ($old_data as $k2 => $v2) {
					$tmp[$i]['name'] = $k2;
					$tmp[$i]['vals'] = explode("\n", $v2);
					$i++;
				}
				$old_data = $tmp;
			}

			add_option('litespeed.conf.' . $v, $old_data);
		}
		Debug2::debug("[Data] Delete $k");
		delete_option($k);
	}

	// conv other items
	$data = array(
		'litespeed-setting-mode' => 'litespeed.setting.mode',
		'litespeed-media-need-pull' => 'litespeed.img_optm.need_pull',
		'litespeed-env-ref' => 'litespeed.env.ref',
		'litespeed-cache-cloudflare_status' => 'litespeed.cdn.cloudflare.status',
	);
	foreach ($data as $k => $v) {
		$old_data = get_option($k);
		if ($old_data) {
			add_option($v, $old_data);
		}
		delete_option($k);
	}

	// Conv conf from litespeed-cache-conf child to litespeed.conf.*
	Debug2::debug('[Data] Conv conf from litespeed-cache-conf child to litespeed.conf.*');
	$previous_options = get_option('litespeed-cache-conf');

	$data = array(
		'radio_select' => 'cache',
		'hash' => 'hash',
		'auto_upgrade' => 'auto_upgrade',
		'news' => 'news',
		'crawler_domain_ip' => 'server_ip',

		'esi_enabled' => 'esi',
		'esi_cached_admbar' => 'esi-cache_admbar',
		'esi_cached_commform' => 'esi-cache_commform',

		'heartbeat' => 'misc-heartbeat_front',

		'cache_browser' => 'cache-browser',
		'cache_browser_ttl' => 'cache-ttl_browser',
		'instant_click' => 'util-instant_click',
		'use_http_for_https_vary' => 'util-no_https_vary',

		'purge_upgrade' => 'purge-upgrade',
		'timed_urls' => 'purge-timed_urls',
		'timed_urls_time' => 'purge-timed_urls_time',

		'cache_priv' => 'cache-priv',
		'cache_commenter' => 'cache-commenter',
		'cache_rest' => 'cache-rest',
		'cache_page_login' => 'cache-page_login',
		'cache_favicon' => 'cache-favicon',
		'cache_resources' => 'cache-resources',
		'mobileview_enabled' => 'cache-mobile',
		'mobileview_rules' => 'cache-mobile_rules',
		'nocache_useragents' => 'cache-exc_useragents',
		'nocache_cookies' => 'cache-exc_cookies',
		'excludes_qs' => 'cache-exc_qs',
		'excludes_cat' => 'cache-exc_cat',
		'excludes_tag' => 'cache-exc_tag',
		'public_ttl' => 'cache-ttl_pub',
		'private_ttl' => 'cache-ttl_priv',
		'front_page_ttl' => 'cache-ttl_frontpage',
		'feed_ttl' => 'cache-ttl_feed',
		'login_cookie' => 'cache-login_cookie',

		'debug_disable_all' => 'debug-disable_all',
		'debug' => 'debug',
		'admin_ips' => 'debug-ips',
		'debug_level' => 'debug-level',
		'log_file_size' => 'debug-filesize',
		'debug_cookie' => 'debug-cookie',
		'collapse_qs' => 'debug-collapse_qs',
		// 'log_filters' 				=> 'debug-log_filters',

		'crawler_cron_active' => 'crawler',
		// 'crawler_include_posts' 	=> 'crawler-inc_posts',
		// 'crawler_include_pages' 	=> 'crawler-inc_pages',
		// 'crawler_include_cats' 		=> 'crawler-inc_cats',
		// 'crawler_include_tags' 		=> 'crawler-inc_tags',
		// 'crawler_excludes_cpt' 		=> 'crawler-exc_cpt',
		// 'crawler_order_links' 		=> 'crawler-order_links',
		'crawler_usleep' => 'crawler-usleep',
		'crawler_run_duration' => 'crawler-run_duration',
		'crawler_run_interval' => 'crawler-run_interval',
		'crawler_crawl_interval' => 'crawler-crawl_interval',
		'crawler_threads' => 'crawler-threads',
		'crawler_load_limit' => 'crawler-load_limit',
		'crawler_custom_sitemap' => 'crawler-sitemap',

		'cache_object' => 'object',
		'cache_object_kind' => 'object-kind',
		'cache_object_host' => 'object-host',
		'cache_object_port' => 'object-port',
		'cache_object_life' => 'object-life',
		'cache_object_persistent' => 'object-persistent',
		'cache_object_admin' => 'object-admin',
		'cache_object_transients' => 'object-transients',
		'cache_object_db_id' => 'object-db_id',
		'cache_object_user' => 'object-user',
		'cache_object_pswd' => 'object-psw',

		'cdn' => 'cdn',
		'cdn_ori' => 'cdn-ori',
		'cdn_exclude' => 'cdn-exc',
		// 'cdn_remote_jquery'			=> 'cdn-remote_jq',
		'cdn_quic' => 'cdn-quic',
		'cdn_cloudflare' => 'cdn-cloudflare',
		'cdn_cloudflare_email' => 'cdn-cloudflare_email',
		'cdn_cloudflare_key' => 'cdn-cloudflare_key',
		'cdn_cloudflare_name' => 'cdn-cloudflare_name',
		'cdn_cloudflare_zone' => 'cdn-cloudflare_zone',

		'media_img_lazy' => 'media-lazy',
		'media_img_lazy_placeholder' => 'media-lazy_placeholder',
		'media_placeholder_resp' => 'media-placeholder_resp',
		'media_placeholder_resp_color' => 'media-placeholder_resp_color',
		'media_placeholder_resp_async' => 'media-placeholder_resp_async',
		'media_iframe_lazy' => 'media-iframe_lazy',
		// 'media_img_lazyjs_inline'		=> 'media-lazyjs_inline',

		'media_optm_auto' => 'img_optm-auto',
		'media_optm_cron' => 'img_optm-cron',
		'media_optm_ori' => 'img_optm-ori',
		'media_rm_ori_bkup' => 'img_optm-rm_bkup',
		// 'media_optm_webp'			=> 'img_optm-webp',
		'media_webp_replace' => 'img_optm-webp',
		'media_optm_lossless' => 'img_optm-lossless',
		'media_optm_exif' => 'img_optm-exif',
		'media_webp_replace_srcset' => 'img_optm-webp_replace_srcset',

		'css_minify' => 'optm-css_min',
		// 'css_inline_minify'		=> 'optm-css_inline_min',
		'css_combine' => 'optm-css_comb',
		// 'css_combined_priority'	=> 'optm-css_comb_priority',
		// 'css_http2'				=> 'optm-css_http2',
		'css_exclude' => 'optm-css_exc',
		'js_minify' => 'optm-js_min',
		// 'js_inline_minify'		=> 'optm-js_inline_min',
		'js_combine' => 'optm-js_comb',
		// 'js_combined_priority'	=> 'optm-js_comb_priority',
		// 'js_http2'				=> 'optm-js_http2',
		'js_exclude' => 'optm-js_exc',
		// 'optimize_ttl'			=> 'optm-ttl',
		'html_minify' => 'optm-html_min',
		'optm_qs_rm' => 'optm-qs_rm',
		'optm_ggfonts_rm' => 'optm-ggfonts_rm',
		'optm_css_async' => 'optm-css_async',
		// 'optm_ccss_gen'			=> 'optm-ccss_gen',
		// 'optm_ccss_async'		=> 'optm-ccss_async',
		'optm_css_async_inline' => 'optm-css_async_inline',
		'optm_js_defer' => 'optm-js_defer',
		'optm_emoji_rm' => 'optm-emoji_rm',
		// 'optm_exclude_jquery'	=> 'optm-exc_jq',
		'optm_ggfonts_async' => 'optm-ggfonts_async',
		// 'optm_max_size'			=> 'optm-max_size',
		// 'optm_rm_comment'		=> 'optm-rm_comment',
	);
	foreach ($data as $k => $v) {
		if (!isset($previous_options[$k])) {
			continue;
		}
		// The following values must be array
		if (!is_array($previous_options[$k])) {
			if (in_array($v, array('cdn-ori', 'cache-exc_cat', 'cache-exc_tag'))) {
				$previous_options[$k] = explode(',', $previous_options[$k]);
				$previous_options[$k] = array_filter($previous_options[$k]);
			} elseif (in_array($v, array('cache-mobile_rules', 'cache-exc_useragents', 'cache-exc_cookies'))) {
				$previous_options[$k] = explode('|', str_replace('\\ ', ' ', $previous_options[$k]));
				$previous_options[$k] = array_filter($previous_options[$k]);
			} elseif (
				in_array($v, array(
					'purge-timed_urls',
					'cache-exc_qs',
					'debug-ips',
					// 'crawler-exc_cpt',
					'cdn-exc',
					'optm-css_exc',
					'optm-js_exc',
				))
			) {
				$previous_options[$k] = explode("\n", $previous_options[$k]);
				$previous_options[$k] = array_filter($previous_options[$k]);
			}
		}

		// Special handler for heartbeat
		if ($v == 'misc-heartbeat_front') {
			if (!$previous_options[$k]) {
				add_option('litespeed.conf.misc-heartbeat_front', true);
				add_option('litespeed.conf.misc-heartbeat_back', true);
				add_option('litespeed.conf.misc-heartbeat_editor', true);
				add_option('litespeed.conf.misc-heartbeat_front_ttl', 0);
				add_option('litespeed.conf.misc-heartbeat_back_ttl', 0);
				add_option('litespeed.conf.misc-heartbeat_editor_ttl', 0);
			}
			continue;
		}

		add_option('litespeed.conf.' . $v, $previous_options[$k]);
	}
	// Conv purge_by_post
	$data = array(
		'-' => 'purge-post_all',
		'F' => 'purge-post_f',
		'H' => 'purge-post_h',
		'PGS' => 'purge-post_p',
		'PGSRP' => 'purge-post_pwrp',
		'A' => 'purge-post_a',
		'Y' => 'purge-post_y',
		'M' => 'purge-post_m',
		'D' => 'purge-post_d',
		'T' => 'purge-post_t',
		'PT' => 'purge-post_pt',
	);
	if (isset($previous_options['purge_by_post'])) {
		$purge_by_post = explode('.', $previous_options['purge_by_post']);
		foreach ($data as $k => $v) {
			add_option('litespeed.conf.' . $v, in_array($k, $purge_by_post));
		}
	}
	// Conv 404/403/500 TTL
	$ttl_status = array();
	if (isset($previous_options['403_ttl'])) {
		$ttl_status[] = '403 ' . $previous_options['403_ttl'];
	}
	if (isset($previous_options['404_ttl'])) {
		$ttl_status[] = '404 ' . $previous_options['404_ttl'];
	}
	if (isset($previous_options['500_ttl'])) {
		$ttl_status[] = '500 ' . $previous_options['500_ttl'];
	}
	add_option('litespeed.conf.cache-ttl_status', $ttl_status);

	/**
	 * Resave cdn cfg from lscfg to separate cfg when upgrade to v1.7
	 *
	 * NOTE: this can be left here as `add_option` bcos it is after the item `litespeed-cache-cdn_mapping` is converted
	 *
	 * @since 1.7
	 */
	if (isset($previous_options['cdn_url'])) {
		$cdn_mapping = array(
			'url' => $previous_options['cdn_url'],
			'inc_img' => $previous_options['cdn_inc_img'],
			'inc_css' => $previous_options['cdn_inc_css'],
			'inc_js' => $previous_options['cdn_inc_js'],
			'filetype' => $previous_options['cdn_filetype'],
		);
		add_option('litespeed.conf.cdn-mapping', array($cdn_mapping));
		Debug2::debug('[Data] plugin_upgrade option adding CDN map');
	}

	/**
	 * Move Exclude settings to separate item
	 *
	 * NOTE: this can be left here as `add_option` bcos it is after the relevant items are converted
	 *
	 * @since  2.3
	 */
	if (isset($previous_options['forced_cache_uri'])) {
		add_option('litespeed.conf.cache-force_uri', $previous_options['forced_cache_uri']);
	}
	if (isset($previous_options['cache_uri_priv'])) {
		add_option('litespeed.conf.cache-priv_uri', $previous_options['cache_uri_priv']);
	}
	if (isset($previous_options['optm_excludes'])) {
		add_option('litespeed.conf.optm-exc', $previous_options['optm_excludes']);
	}
	if (isset($previous_options['excludes_uri'])) {
		add_option('litespeed.conf.cache-exc', $previous_options['excludes_uri']);
	}

	// Backup stale conf
	Debug2::debug('[Data] Backup stale conf');
	delete_option('litespeed-cache-conf');
	add_option('litespeed-cache-conf.bk', $previous_options);

	// Upgrade site_options if is network
	if (is_multisite()) {
		$ver = get_site_option('litespeed.conf._version');
		if (!$ver) {
			Debug2::debug('[Data] Conv multisite');
			$previous_site_options = get_site_option('litespeed-cache-conf');

			$data = array(
				'network_enabled' => 'cache',
				'use_primary_settings' => 'use_primary_settings',
				'auto_upgrade' => 'auto_upgrade',
				'purge_upgrade' => 'purge-upgrade',

				'cache_favicon' => 'cache-favicon',
				'cache_resources' => 'cache-resources',
				'mobileview_enabled' => 'cache-mobile',
				'mobileview_rules' => 'cache-mobile_rules',
				'login_cookie' => 'cache-login_cookie',
				'nocache_cookies' => 'cache-exc_cookies',
				'nocache_useragents' => 'cache-exc_useragents',

				'cache_object' => 'object',
				'cache_object_kind' => 'object-kind',
				'cache_object_host' => 'object-host',
				'cache_object_port' => 'object-port',
				'cache_object_life' => 'object-life',
				'cache_object_persistent' => 'object-persistent',
				'cache_object_admin' => 'object-admin',
				'cache_object_transients' => 'object-transients',
				'cache_object_db_id' => 'object-db_id',
				'cache_object_user' => 'object-user',
				'cache_object_pswd' => 'object-psw',

				'cache_browser' => 'cache-browser',
				'cache_browser_ttl' => 'cache-ttl_browser',

				'media_webp_replace' => 'img_optm-webp',
			);
			foreach ($data as $k => $v) {
				if (!isset($previous_site_options[$k])) {
					continue;
				}
				// The following values must be array
				if (!is_array($previous_site_options[$k])) {
					if (in_array($v, array('cache-mobile_rules', 'cache-exc_useragents', 'cache-exc_cookies'))) {
						$previous_site_options[$k] = explode('|', str_replace('\\ ', ' ', $previous_site_options[$k]));
						$previous_site_options[$k] = array_filter($previous_site_options[$k]);
					}
				}

				add_site_option('litespeed.conf.' . $v, $previous_site_options[$k]);
			}

			// These are already converted to single record in single site
			$data = array('object-global_groups', 'object-non_persistent_groups');
			foreach ($data as $v) {
				$old_data = get_option($v);
				if ($old_data) {
					add_site_option('litespeed.conf.' . $v, $old_data);
				}
			}

			delete_site_option('litespeed-cache-conf');

			add_site_option('litespeed.conf._version', '3.0');
		}
	}

	// delete tables
	Debug2::debug('[Data] Drop litespeed_optimizer');
	$q = 'DROP TABLE IF EXISTS ' . $wpdb->prefix . 'litespeed_optimizer';
	$wpdb->query($q);

	// Update image optm table
	Debug2::debug('[Data] Upgrade img_optm table');
	$tb_exists = $wpdb->get_var('SHOW TABLES LIKE "' . $wpdb->prefix . 'litespeed_img_optm"');
	if ($tb_exists) {
		$status_mapping = array(
			'requested' => 3,
			'notified' => 6,
			'pulled' => 9,
			'failed' => -1,
			'miss' => -3,
			'err' => -9,
			'err_fetch' => -5,
			'err_optm' => -7,
			'xmeta' => -8,
		);
		foreach ($status_mapping as $k => $v) {
			$q = 'UPDATE `' . $wpdb->prefix . "litespeed_img_optm` SET optm_status='$v' WHERE optm_status='$k'";
			$wpdb->query($q);
		}

		$q =
			'ALTER TABLE `' .
			$wpdb->prefix .
			'litespeed_img_optm`
				DROP INDEX `post_id_2`,
				DROP INDEX `root_id`,
				DROP INDEX `src_md5`,
				DROP INDEX `srcpath_md5`,
				DROP COLUMN `srcpath_md5`,
				DROP COLUMN `src_md5`,
				DROP COLUMN `root_id`,
				DROP COLUMN `target_saved`,
				DROP COLUMN `webp_saved`,
				DROP COLUMN `server_info`,
				MODIFY COLUMN `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
				MODIFY COLUMN `optm_status` tinyint(4) NOT NULL DEFAULT 0,
				MODIFY COLUMN `src` text COLLATE utf8mb4_unicode_ci NOT NULL
			';
		$wpdb->query($q);
	}

	delete_option('litespeed-recommended');

	Debug2::debug('[Data] litespeed_update_3_0 done!');

	add_option('litespeed.conf._version', '3.0');
}