<?php

use Cleantalk\ApbctWP\Cron;

function apbct_run_update_actions($current_version, $new_version){
	
	$current_version = apbct_version_standartization($current_version);
	$new_version     = apbct_version_standartization($new_version);
	
	$current_version_str = implode('.', $current_version);
	$new_version_str     = implode('.', $new_version);
	
	for($ver_major = $current_version[0]; $ver_major <= $new_version[0]; $ver_major++){
		for($ver_minor = 0; $ver_minor <= 200; $ver_minor++){
			for($ver_fix = 0; $ver_fix <= 10; $ver_fix++){
				
				if(version_compare("{$ver_major}.{$ver_minor}.{$ver_fix}", $current_version_str, '<='))
					continue;
				
				if(function_exists("apbct_update_to_{$ver_major}_{$ver_minor}_{$ver_fix}")){
					$result = call_user_func("apbct_update_to_{$ver_major}_{$ver_minor}_{$ver_fix}");
					if(!empty($result['error']))
						break;
				}
				
				if(version_compare("{$ver_major}.{$ver_minor}.{$ver_fix}", $new_version_str, '>='))
					break(2);
				
			}
		}
	}
	
	return true;
	
}

function apbct_version_standartization($version){
	
	$version = explode('.', $version);
	$version = !empty($version) ? $version : array();
	
	$version[0] = !empty($version[0]) ? (int)$version[0] : 0;
	$version[1] = !empty($version[1]) ? (int)$version[1] : 0;
	$version[2] = !empty($version[2]) ? (int)$version[2] : 0;
	
	return $version;
}

function apbct_update_to_5_50_0(){
	global $wpdb;
	$wpdb->query('CREATE TABLE IF NOT EXISTS `'. APBCT_TBL_FIREWALL_DATA .'` (
		`network` int(11) unsigned NOT NULL,
		`mask` int(11) unsigned NOT NULL,
		INDEX (  `network` ,  `mask` )
		);');
		
	$wpdb->query('CREATE TABLE IF NOT EXISTS `'. APBCT_TBL_FIREWALL_LOG .'` (
		`ip` VARCHAR(15) NOT NULL , 
		`all` INT NOT NULL , 
		`blocked` INT NOT NULL , 
		`timestamp` INT NOT NULL , 
		PRIMARY KEY (`ip`));');
}

function apbct_update_to_5_56_0(){
	if (!wp_next_scheduled('cleantalk_update_sfw_hook'))
		wp_schedule_event(time()+1800, 'daily', 'cleantalk_update_sfw_hook' );
}
function apbct_update_to_5_70_0(){
	
	global $wpdb;
	
	if(!in_array('all_entries', $wpdb->get_col('DESC '. APBCT_TBL_FIREWALL_LOG, 0))){
		$wpdb->query('ALTER TABLE `'. APBCT_TBL_FIREWALL_LOG .'`
			CHANGE `all` `all_entries` INT(11) NOT NULL,
			CHANGE `blocked` `blocked_entries` INT(11) NOT NULL,
			CHANGE `timestamp` `entries_timestamp` INT(11) NOT NULL;'
		);
	}
	
	// Deleting usless data
	delete_option('cleantalk_sends_reports_till');
	delete_option('cleantalk_activation_timestamp');
	
	// Disabling WP_Cron tasks
	wp_clear_scheduled_hook('cleantalk_send_daily_report_hook');
	wp_clear_scheduled_hook('ct_hourly_event_hook');
	wp_clear_scheduled_hook('ct_send_sfw_log');
	wp_clear_scheduled_hook('cleantalk_update_sfw_hook');
	wp_clear_scheduled_hook('cleantalk_get_brief_data_hook');
	
	// Adding Self cron system tasks
	Cron::addTask('check_account_status', 'ct_account_status_check',  3600, time() + 1800); // New
	Cron::addTask('delete_spam_comments', 'ct_delete_spam_comments',  3600, time() + 3500);
	Cron::addTask('send_feedback',        'ct_send_feedback',         3600, time() + 3500);
	Cron::addTask('sfw_update',           'ct_sfw_update',            86400, time() + 43200);
	Cron::addTask('send_sfw_logs',        'ct_sfw_send_logs',         3600, time() + 1800); // New
	Cron::addTask('get_brief_data',       'cleantalk_get_brief_data', 86400, time() + 3500);
}
function apbct_update_to_5_74_0(){
	Cron::removeTask('send_daily_request');
}

function apbct_update_to_5_97_0(){
	
	global $apbct;
	
	if(count($apbct->data['connection_reports']['negative_report']) >= 20)
		$apbct->data['connection_reports']['negative_report'] = array_slice($apbct->data['connection_reports']['negative_report'], -20, 20);
	
	$apbct->saveData();
}

function apbct_update_to_5_109_0(){
	
	global $apbct, $wpdb;
	
	if(apbct_is_plugin_active_for_network($apbct->base_name) && !defined('CLEANTALK_ACCESS_KEY')){
		
		$sfw_data_query = 'CREATE TABLE IF NOT EXISTS `%s` (
			`network` int(11) unsigned NOT NULL,
			`mask` int(11) unsigned NOT NULL,
			INDEX (  `network` ,  `mask` )
			);';

		$sfw_log_query = 'CREATE TABLE IF NOT EXISTS `%s` (
			`ip` VARCHAR(15) NOT NULL,
			`all_entries` INT NOT NULL,
			`blocked_entries` INT NOT NULL,
			`entries_timestamp` INT NOT NULL,
			PRIMARY KEY (`ip`));';

		$initial_blog  = get_current_blog_id();
		$blogs = array_keys($wpdb->get_results('SELECT blog_id FROM '. $wpdb->blogs, OBJECT_K));
		foreach ($blogs as $blog) {
			switch_to_blog($blog);
			$wpdb->query(sprintf($sfw_data_query, $wpdb->prefix . 'cleantalk_sfw'));       // Table for SpamFireWall data
			$wpdb->query(sprintf($sfw_log_query,  $wpdb->prefix . 'cleantalk_sfw_logs'));  // Table for SpamFireWall logs
			// Cron tasks
			Cron::addTask('check_account_status',  'ct_account_status_check',        3600, time() + 1800); // Checks account status
			Cron::addTask('delete_spam_comments',  'ct_delete_spam_comments',        3600, time() + 3500); // Formerly ct_hourly_event_hook()
			Cron::addTask('send_feedback',         'ct_send_feedback',               3600, time() + 3500); // Formerly ct_hourly_event_hook()
			Cron::addTask('sfw_update',            'ct_sfw_update',                  86400, time() + 300);  // SFW update
			Cron::addTask('send_sfw_logs',         'ct_sfw_send_logs',               3600, time() + 1800); // SFW send logs
			Cron::addTask('get_brief_data',        'cleantalk_get_brief_data',       86400, time() + 3500); // Get data for dashboard widget
			Cron::addTask('send_connection_report','ct_mail_send_connection_report', 86400, time() + 3500); // Send connection report to welcome@cleantalk.org
		}
		switch_to_blog($initial_blog);
	}
}

function apbct_update_to_5_110_0(){
	global $apbct;
	unset($apbct->data['last_remote_call']);
	$apbct->saveData;
	$apbct->save('remote_calls');
}

function apbct_update_to_5_115_1(){
	ct_sfw_update();
}

function apbct_update_to_5_116_0(){
	
	global $apbct, $wpdb;
	
	$apbct->settings['store_urls'] = 0;
	$apbct->settings['store_urls__sessions'] = 0;
	$apbct->saveSettings();
	
	$wpdb->query('CREATE TABLE IF NOT EXISTS `'. APBCT_TBL_SESSIONS .'` (
		`id` VARCHAR(64) NOT NULL,
		`name` TEXT NOT NULL,
		`value` TEXT NULL,
		`last_update` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
		PRIMARY KEY (`id`, `name`(10)));'
	);
}

function apbct_update_to_5_116_1(){
	
	global $wpdb;
	
	$wpdb->query('CREATE TABLE IF NOT EXISTS `'. APBCT_TBL_SESSIONS .'` (
		`id` VARCHAR(64) NOT NULL,
		`name` TEXT NOT NULL,
		`value` TEXT NULL,
		`last_update` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
		PRIMARY KEY (`id`, `name`(10)));'
	);
}

function apbct_update_to_5_116_2(){
	
	global $wpdb;
	
	$wpdb->query('CREATE TABLE IF NOT EXISTS `'. APBCT_TBL_SESSIONS .'` (
		`id` VARCHAR(64) NOT NULL,
		`name` TEXT NOT NULL,
		`value` TEXT NULL DEFAULT NULL,
		`last_update` DATETIME NULL DEFAULT NULL,
		PRIMARY KEY (`id`, `name`(10)));'
	);
}

function apbct_update_to_5_118_0(){
	global $wpdb;
	$wpdb->query(
		'DELETE
			FROM `'. APBCT_TBL_SESSIONS .'`
			WHERE last_update < NOW() - INTERVAL '. APBCT_SEESION__LIVE_TIME .' SECOND;'
	);
	delete_option('cleantalk_server');
}

function apbct_update_to_5_118_2(){
	global $apbct;
	$apbct->data['connection_reports'] = $apbct->def_data['connection_reports'];
	$apbct->data['connection_reports']['since'] = date('d M');
	$apbct->saveData();
}

function apbct_update_to_5_119_0(){
	
	global $wpdb;
	
	$wpdb->query('DROP TABLE IF EXISTS `'. $wpdb->prefix.'cleantalk_sessions`;');  //  Deleting session table
	
	// SFW data
	$sqls[] = 'CREATE TABLE IF NOT EXISTS `%scleantalk_sfw` (
		`network` int(11) unsigned NOT NULL,
		`mask` int(11) unsigned NOT NULL,
		INDEX (  `network` ,  `mask` )
		);';
	
	// SFW log
	$sqls[] = 'CREATE TABLE IF NOT EXISTS `%scleantalk_sfw_logs` (
		`ip` VARCHAR(15) NOT NULL,
		`all_entries` INT NOT NULL,
		`blocked_entries` INT NOT NULL,
		`entries_timestamp` INT NOT NULL,
		PRIMARY KEY (`ip`));';
	
	// Sessions
	$sqls[] = 'CREATE TABLE IF NOT EXISTS `%scleantalk_sessions` (
		`id` VARCHAR(64) NOT NULL,
		`name` VARCHAR(64) NOT NULL,
		`value` TEXT NULL DEFAULT NULL,
		`last_update` DATETIME NULL DEFAULT NULL,
		PRIMARY KEY (`id`(64), `name`(64)));';
	
	apbct_activation__create_tables($sqls);
	
	// WPMS
	if(is_multisite()){
		global $wpdb;
		$initial_blog  = get_current_blog_id();
		$blogs = array_keys($wpdb->get_results('SELECT blog_id FROM '. $wpdb->blogs, OBJECT_K));
		foreach ($blogs as $blog) {
			switch_to_blog($blog);
			$wpdb->query('DROP TABLE IF EXISTS `'. $wpdb->prefix.'cleantalk_sessions`;');  //  Deleting session table
			apbct_activation__create_tables($sqls);
		}
		switch_to_blog($initial_blog);
	}
	
	// Drop work url 
	update_option(
		'cleantalk_server',
		array(
			'ct_work_url'       => null,
			'ct_server_ttl'     => 0,
			'ct_server_changed' => 0,
		)
	);
}

function apbct_update_to_5_124_0(){
	global $apbct;
	// Deleting error in database because format were changed
	$apbct->errors = array();
	$apbct->saveErrors();
}

function apbct_update_to_5_126_0(){
	global $apbct;
	// Enable storing URLs
	$apbct->settings['store_urls'] = 1;
	$apbct->settings['store_urls__sessions'] = 1;
	$apbct->saveSettings();
}

function apbct_update_to_5_127_0(){
	
	global $apbct;
	
	// Move exclusions from variable to settins
	global $cleantalk_url_exclusions, $cleantalk_key_exclusions;
	// URLs
	if(!empty($cleantalk_url_exclusions) && is_array($cleantalk_url_exclusions)){
		$apbct->settings['exclusions__urls'] = implode(',', $cleantalk_url_exclusions);
		if(APBCT_WPMS){
			$initial_blog = get_current_blog_id();
			switch_to_blog( 1 );
		}
		$apbct->saveSettings();
		if(APBCT_WPMS){
			switch_to_blog($initial_blog);
		}
	}
	// Fields
	if(!empty($cleantalk_key_exclusions) && is_array($cleantalk_key_exclusions)){
		$apbct->settings['exclusions__fields'] = implode(',', $cleantalk_key_exclusions);
		if(APBCT_WPMS){
			$initial_blog = get_current_blog_id();
			switch_to_blog( 1 );
		}
		$apbct->saveSettings();
		if(APBCT_WPMS){
			switch_to_blog($initial_blog);
		}
	}
	
	// Deleting legacy
	if(isset($apbct->data['testing_failed'])){
		unset($apbct->data['testing_failed']);
		$apbct->saveData();
	}
	
	if(APBCT_WPMS){
		
		// Whitelabel
		// Reset "api_key_is_recieved" flag
		global $wpdb;
		$initial_blog = get_current_blog_id();
		$blogs        = array_keys( $wpdb->get_results( 'SELECT blog_id FROM ' . $wpdb->blogs, OBJECT_K ) );
		foreach ( $blogs as $blog ){
			switch_to_blog( $blog );
			
			$settings = get_option( 'cleantalk_settings' );
			if( isset( $settings['use_static_js_key'] ) ){
				$settings['use_static_js_key'] = $settings['use_static_js_key'] === 0
					? - 1
					: $settings['use_static_js_key'];
				update_option( 'cleantalk_settings', $settings );
				
				$data = get_option( 'cleantalk_data' );
				if( isset( $data['white_label_data']['is_key_recieved'] ) ){
					unset( $data['white_label_data']['is_key_recieved'] );
					update_option( 'cleantalk_data', $data );
				}
			}
			switch_to_blog( $initial_blog );
			
			if( defined( 'APBCT_WHITELABEL' ) ){
				$apbct->network_settings = array(
					'white_label'              => defined( 'APBCT_WHITELABEL' ) && APBCT_WHITELABEL == true ? 1 : 0,
					'white_label__hoster_key'  => defined( 'APBCT_HOSTER_API_KEY' )  ? APBCT_HOSTER_API_KEY : '',
					'white_label__plugin_name' => defined( 'APBCT_WHITELABEL_NAME' ) ? APBCT_WHITELABEL_NAME : APBCT_NAME,
				);
			}elseif( defined( 'CLEANTALK_ACCESS_KEY' ) ){
				$apbct->network_settings = array(
					'allow_custom_key' => 0,
					'apikey'           => CLEANTALK_ACCESS_KEY,
				);
			}
			$apbct->saveNetworkSettings();
		}
	}else{
		// Switch use_static_js_key to Auto if it was disabled
		$apbct->settings['use_static_js_key'] = $apbct->settings['use_static_js_key'] === 0
			? -1
			: $apbct->settings['use_static_js_key'];
		$apbct->saveSettings();
	}
}

function apbct_update_to_5_127_1(){
	if(APBCT_WPMS && is_main_site()){
		global $apbct;
		$network_settings = get_site_option( 'cleantalk_network_settings' );
		if( $network_settings !== false && empty( $network_settings['allow_custom_key'] ) && empty( $network_settings['white_label'] ) ){
			$network_settings['allow_custom_key'] = 1;
			update_site_option( 'cleantalk_network_settings', $network_settings );
		}
		if( $network_settings !== false && $network_settings['white_label'] == 1 && $apbct->data['moderate'] == 0 ){
			ct_account_status_check( $network_settings['apikey'] ? $network_settings['apikey'] : $apbct->settings['apikey'], false);
		}
	}
}

function apbct_update_to_5_128_0(){
	global $apbct;
	$apbct->remote_calls = array();
	$apbct->save('remote_calls');
}

function apbct_update_to_5_133_0() {

    global $wpdb;

    // Scan comment/user log
    $sqls[] = 'CREATE TABLE IF NOT EXISTS `%scleantalk_spamscan_logs` (
		`id` int(11) NOT NULL AUTO_INCREMENT,
        `scan_type` varchar(11) NOT NULL,
        `start_time` datetime NOT NULL,
        `finish_time` datetime NOT NULL,
        `count_to_scan` int(11) DEFAULT NULL,
        `found_spam` int(11) DEFAULT NULL,
        `found_bad` int(11) DEFAULT NULL,
        PRIMARY KEY (`id`));';

    apbct_activation__create_tables($sqls);

}

function apbct_update_to_5_138_0() {
	
	global $wpdb;
	
	// SQL queries for each blog
	$sqls[] = 'CREATE TABLE IF NOT EXISTS `%scleantalk_spamscan_logs` (
		`id` int(11) NOT NULL AUTO_INCREMENT,
        `scan_type` varchar(11) NOT NULL,
        `start_time` datetime NOT NULL,
        `finish_time` datetime NOT NULL,
        `count_to_scan` int(11) DEFAULT NULL,
        `found_spam` int(11) DEFAULT NULL,
        `found_bad` int(11) DEFAULT NULL,
        PRIMARY KEY (`id`));';
	$sqls[] = 'CREATE TABLE IF NOT EXISTS `%scleantalk_sfw` (
		`network` int(11) unsigned NOT NULL,
		`mask` int(11) unsigned NOT NULL,
		INDEX (  `network` ,  `mask` )
		);';
	$sqls[] = 'ALTER TABLE `%scleantalk_sfw` ADD COLUMN status TINYINT(1) NOT NULL DEFAULT 0 AFTER mask;';
	
	// Actions for WPMS
	if( APBCT_WPMS ){
		
		// Getting all blog ids
		$initial_blog  = get_current_blog_id();
		$blogs = array_keys($wpdb->get_results('SELECT blog_id FROM '. $wpdb->blogs, OBJECT_K));
		
		// Getting main blog setting
		switch_to_blog( 1 );
		$main_blog_settings = get_option( 'cleantalk_settings' );
		switch_to_blog( $initial_blog );
		
		// Getting network settings
		$net_settings = get_site_option('cleantalk_network_settings');
		
		foreach ($blogs as $blog) {
			
			// Update time limit to prevent exec time error
			set_time_limit(20);
			
			switch_to_blog($blog);
			
			// Update SQL structure
			apbct_activation__create_tables($sqls);
			
			// Getting key
			$settings = $net_settings['allow_custom_key']
				? get_option('cleantalk_settings')
				: $main_blog_settings;
			
			// Update plugin status
			if( ! empty( $settings['apikey'] ) ){
				
				$data = get_option( 'cleantalk_data', array() );
				
				$result = \Cleantalk\ApbctWP\API::method__notice_paid_till(
					$settings['api_key'],
					preg_replace('/http[s]?:\/\//', '', get_option('siteurl'), 1),
					! is_main_site() && $net_settings['white_label'] ? 'anti-spam-hosting' : 'antispam'
				);
				
				if( empty( $result['error'] ) || ! empty( $result['valid'] ) ){
					
					// Notices
					$data['notice_show']        = isset($result['show_notice'])             ? (int)$result['show_notice']             : 0;
					$data['notice_renew']       = isset($result['renew'])                   ? (int)$result['renew']                   : 0;
					$data['notice_trial']       = isset($result['trial'])                   ? (int)$result['trial']                   : 0;
					$data['notice_review']      = isset($result['show_review'])             ? (int)$result['show_review']             : 0;
					$data['notice_auto_update'] = isset($result['show_auto_update_notice']) ? (int)$result['show_auto_update_notice'] : 0;
					
					// Other
					$data['service_id']         = isset($result['service_id'])                         ? (int)$result['service_id']         : 0;
					$data['valid']              = isset($result['valid'])                              ? (int)$result['valid']              : 0;
					$data['moderate']           = isset($result['moderate'])                           ? (int)$result['moderate']           : 0;
					$data['ip_license']         = isset($result['ip_license'])                         ? (int)$result['ip_license']         : 0;
					$data['moderate_ip']        = isset($result['moderate_ip'], $result['ip_license']) ? (int)$result['moderate_ip']        : 0;
					$data['spam_count']         = isset($result['spam_count'])                         ? (int)$result['spam_count']         : 0;
					$data['auto_update']        = isset($result['auto_update_app'])                    ? (int)$result['auto_update_app']    : 0;
					$data['user_token']         = isset($result['user_token'])                         ? (string)$result['user_token']      : '';
					$data['license_trial']      = isset($result['license_trial'])                      ? (int)$result['license_trial']      : 0;
					$data['account_name_ob']    = isset($result['account_name_ob'])                    ? (string)$result['account_name_ob'] : '';
					
				}
				
				$data['key_is_ok'] = ! empty( $result['valid'] )
					? true
					: false;
				
				update_option( 'cleantalk_data', $data );
				
			}
			
		}
		
		// Restoring initial blog
		switch_to_blog($initial_blog);
	
	// Actions for stand alone blog
	}else{
		apbct_activation__create_tables($sqls);
	}
	
}

function apbct_update_to_5_142_0() {
	
	$sqls[] = 'CREATE TABLE IF NOT EXISTS `%scleantalk_ac_log` (
		`id` VARCHAR(40) NOT NULL,
		`ip` VARCHAR(40) NOT NULL,
		`entries` INT DEFAULT 0,
		`interval_start` INT NOT NULL,
		PRIMARY KEY (`id`));';
	
	$sqls[] = 'ALTER TABLE `%scleantalk_sfw_logs`
		ADD COLUMN `id` VARCHAR(40) NOT NULL FIRST,
		ADD COLUMN `status` ENUM(\'PASS_SFW\',\'DENY_SFW\',\'PASS_SFW_BY_WHITELIST\',\'PASS_SFW_BY_COOKIE\',\'DENY_ANTIBOT\',\'DENY_ANTICRAWLER\') NOT NULL AFTER `ip`,
		DROP PRIMARY KEY,
		ADD PRIMARY KEY (`id`);';
	
	apbct_activation__create_tables( $sqls );
	
}

function apbct_update_to_5_142_1() {
	
	$sqls[] = 'DELETE FROM `%scleantalk_sfw_logs` WHERE 1=1';
	
	$sqls[] = 'ALTER TABLE `%scleantalk_sfw_logs`
		CHANGE `status` `status` ENUM(\'PASS_SFW\',\'DENY_SFW\',\'PASS_SFW_BY_WHITELIST\',\'PASS_SFW_BY_COOKIE\',\'DENY_ANTICRAWLER\',\'DENY_ANTIFLOOD\') NOT NULL AFTER `ip`;';
	
	apbct_activation__create_tables( $sqls );
	
}

function apbct_update_to_5_142_2() {
	
	$sqls[] = 'DELETE FROM `%scleantalk_sfw_logs` WHERE 1=1';
	
	$sqls[] = 'ALTER TABLE `%scleantalk_sfw_logs`
		CHANGE `status` `status` ENUM(\'PASS_SFW\',\'DENY_SFW\',\'PASS_SFW__BY_WHITELIST\',\'PASS_SFW__BY_COOKIE\',\'DENY_ANTICRAWLER\',\'PASS_ANTICRAWLER\',\'DENY_ANTIFLOOD\',\'PASS_ANTIFLOOD\') NOT NULL AFTER `ip`;';
	
	apbct_activation__create_tables( $sqls );
	
}

function apbct_update_to_5_142_3() {
	
	global $apbct;
	
	$sqls[] = 'CREATE TABLE IF NOT EXISTS `%scleantalk_sfw_logs` (
		`id` VARCHAR(40) NOT NULL,
		`ip` VARCHAR(15) NOT NULL,
		`status` ENUM(\'PASS_SFW\',\'DENY_SFW\',\'PASS_SFW__BY_WHITELIST\',\'PASS_SFW__BY_COOKIE\',\'DENY_ANTICRAWLER\',\'PASS_ANTICRAWLER\',\'DENY_ANTIFLOOD\',\'PASS_ANTIFLOOD\') NULL DEFAULT NULL,
		`all_entries` INT NOT NULL,
		`blocked_entries` INT NOT NULL,
		`entries_timestamp` INT NOT NULL,
		PRIMARY KEY (`id`));';
	
	apbct_activation__create_tables( $sqls, $apbct->db_prefix );
	
}

function apbct_update_to_5_143_2() {
	
	global $apbct;
	
	$sqls[] = 'DROP TABLE IF EXISTS `%scleantalk_sfw_logs`;';
	
	$sqls[] = 'CREATE TABLE IF NOT EXISTS `%scleantalk_sfw_logs` (
		`id` VARCHAR(40) NOT NULL,
		`ip` VARCHAR(15) NOT NULL,
		`status` ENUM(\'PASS_SFW\',\'DENY_SFW\',\'PASS_SFW__BY_WHITELIST\',\'PASS_SFW__BY_COOKIE\',\'DENY_ANTICRAWLER\',\'PASS_ANTICRAWLER\',\'DENY_ANTIFLOOD\',\'PASS_ANTIFLOOD\') NULL DEFAULT NULL,
		`all_entries` INT NOT NULL,
		`blocked_entries` INT NOT NULL,
		`entries_timestamp` INT NOT NULL,
		PRIMARY KEY (`id`));';
	
	apbct_activation__create_tables( $sqls, $apbct->db_prefix );
	
}

function apbct_update_to_5_146_1() {

    global $apbct;

    $sqls[] = 'DROP TABLE IF EXISTS `%scleantalk_ac_log`;';

    $sqls[] = 'CREATE TABLE IF NOT EXISTS `%scleantalk_ac_log` (
		`id` VARCHAR(40) NOT NULL,
		`ip` VARCHAR(40) NOT NULL,
		`ua` VARCHAR(40) NOT NULL,
		`entries` INT DEFAULT 0,
		`interval_start` INT NOT NULL,
		PRIMARY KEY (`id`));';

    apbct_activation__create_tables( $sqls, $apbct->db_prefix );

}

function apbct_update_to_5_146_3() {
	update_option( 'cleantalk_plugin_request_ids', array() );
}

function apbct_update_to_5_146_4() {
	
	global $apbct;
	
	$sqls[] = 'ALTER TABLE `%scleantalk_sfw`
		ADD COLUMN `id` INT(11) NOT NULL AUTO_INCREMENT FIRST,
		ADD PRIMARY KEY (`id`);';
	
	apbct_activation__create_tables( $sqls, $apbct->db_prefix );
	

}
function apbct_update_to_5_148_0() {
    Cron::updateTask('antiflood__clear_table', 'apbct_antiflood__clear_table',  86400);
}