aibishal

✏️ Editing: visitors-online.php

<?php
/**
Plugin Name: Visitors Online by BestWebSoft
Plugin URI: https://bestwebsoft.com/products/wordpress/plugins/visitors-online/
Description: Display live count of online visitors who are currently browsing your WordPress website.
Author: BestWebSoft
Text Domain: visitors-online
Domain Path: /languages
Version: 1.1.6
Author URI: https://bestwebsoft.com/
License: GPLv3 or later
 */

/*
© Copyright 2020 BestWebSoft ( https://support.bestwebsoft.com )

This program is free software; you can redistribute it and/or modify
	it under the terms of the GNU General Public License, version 2, as
	published by the Free Software Foundation.

This program is distributed in the hope that it will be useful,
	but WITHOUT ANY WARRANTY; without even the implied warranty of
	MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
	GNU General Public License for more details.

You should have received a copy of the GNU General Public License
	along with this program; if not, write to the Free Software
	Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
*/

/* Include files on import of table and declare the prefix */
$vstrsnln_fpath = dirname( __FILE__ ) . '/includes/import-country.php';
if ( file_exists( $vstrsnln_fpath ) ) {
	include $vstrsnln_fpath;
}

if ( ! function_exists( 'vstrsnln_admin_menu' ) ) {
	/**
	 * Function for adding menu and submenu
	 */
	function vstrsnln_admin_menu() {
		global $submenu, $wp_version, $vstrsnln_plugin_info;

if ( ! is_plugin_active( 'visitors-online-pro/visitors-online-pro.php' ) ) {
			$settings = add_menu_page(
				__( 'Visitors Online Settings', 'visitors-online' ),
				'Visitors Online',
				'manage_options',
				'visitors-online.php',
				'vstrsnln_settings_page'
			);

add_submenu_page(
				'visitors-online.php',
				__( 'Visitors Online Settings', 'visitors-online' ),
				__( 'Settings', 'visitors-online' ),
				'manage_options',
				'visitors-online.php',
				'vstrsnln_settings_page'
			);

add_submenu_page(
				'visitors-online.php',
				'BWS Panel',
				'BWS Panel',
				'manage_options',
				'vstrsnln-bws-panel',
				'bws_add_menu_render'
			);

if ( isset( $submenu['visitors-online.php'] ) ) {
				$submenu['visitors-online.php'][] = array(
					'<span style="color:#d86463"> ' . __( 'Upgrade to Pro', 'visitors-online' ) . '</span>',
					'manage_options',
					'https://bestwebsoft.com/products/wordpress/plugins/visitors-online/?k=1b01d30e84bb97b2afecb5f34c43931d&pn=213&v=' . $vstrsnln_plugin_info['Version'] . '&wp_v=' . $wp_version,
				);
			}

add_action( 'load-' . $settings, 'vstrsnln_add_tabs' );
		}
	}
}

if ( ! function_exists( 'vstrsnln_plugins_loaded' ) ) {
	/**
	 * Internatiolazation
	 */
	function vstrsnln_plugins_loaded() {
		load_plugin_textdomain( 'visitors-online', false, dirname( plugin_basename( __FILE__ ) ) . '/languages/' );
	}
}

if ( ! function_exists( 'vstrsnln_plugin_init' ) ) {
	/**
	 * Plugin init
	 */
	function vstrsnln_plugin_init() {
		global $vstrsnln_plugin_info;

require_once dirname( __FILE__ ) . '/bws_menu/bws_include.php';
		bws_include_init( plugin_basename( __FILE__ ) );

if ( empty( $vstrsnln_plugin_info ) ) {
			if ( ! function_exists( 'get_plugin_data' ) ) {
				require_once ABSPATH . 'wp-admin/includes/plugin.php';
			}
			$vstrsnln_plugin_info = get_plugin_data( __FILE__ );
		}
		/* Function check if plugin is compatible with current WP version */
		bws_wp_min_version_check( plugin_basename( __FILE__ ), $vstrsnln_plugin_info, '4.5' );

/* Get/Register and check settings for plugin */
		vstrsnln_default_options();

vstrsnln_write_user_base();
	}
}

if ( ! function_exists( 'vstrsnln_plugin_admin_init' ) ) {
	/**
	 * Function to add plugin version
	 */
	function vstrsnln_plugin_admin_init() {
		global $bws_plugin_info, $vstrsnln_plugin_info, $vstrsnln_options, $hook_suffix, $bws_shortcode_list;
		if ( ! isset( $bws_plugin_info ) || empty( $bws_plugin_info ) ) {
			$bws_plugin_info = array(
				'id'      => '213',
				'version' => $vstrsnln_plugin_info['Version'],
			);
		}

if ( 'plugins.php' === $hook_suffix ) {
			if ( function_exists( 'bws_plugin_banner_go_pro' ) ) {
				vstrsnln_default_options();
				bws_plugin_banner_go_pro( $vstrsnln_options, $vstrsnln_plugin_info, 'vstrsnln', 'visitors-online', 'ac4699da21e7e6d6238f373bc0065912', '213', 'visitors-online' );
			}
		}
		/* add Visitors Online to global $bws_shortcode_list */
		$bws_shortcode_list['vstrsnln'] = array( 'name' => 'Visitors Online' );
	}
}

if ( ! function_exists( 'vstrsnln_default_options' ) ) {
	/**
	 * Set default settings
	 */
	function vstrsnln_default_options() {
		global $vstrsnln_plugin_info, $vstrsnln_user_interval, $vstrsnln_options;
		/* Add options to database */
		$db_version = '1.0';

if ( ! isset( $vstrsnln_plugin_info ) ) {
			if ( ! function_exists( 'get_plugin_data' ) ) {
				require_once ABSPATH . 'wp-admin/includes/plugin.php';
			}
			$vstrsnln_plugin_info = get_plugin_data( __FILE__ );
		}

$vstrsnln_options = get_option( 'vstrsnln_options' );

if ( ! $vstrsnln_options ) {
			$vstrsnln_options = vstrsnln_get_options_default();
			add_option( 'vstrsnln_options', $vstrsnln_options );
		}

/* Array merge incase this version has added new options */
		if ( ! isset( $vstrsnln_options['plugin_option_version'] ) || $vstrsnln_options['plugin_option_version'] !== $vstrsnln_plugin_info['Version'] ) {
			/* register uninstall hook */
			if ( is_multisite() ) {
				switch_to_blog( 1 );
				register_uninstall_hook( __FILE__, 'vstrsnln_uninstall' );
				restore_current_blog();
			} else {
				register_uninstall_hook( __FILE__, 'vstrsnln_uninstall' );
			}

$vstrsnln_option_defaults = vstrsnln_get_options_default();

$vstrsnln_options                          = array_merge( $vstrsnln_option_defaults, $vstrsnln_options );
			$vstrsnln_options['plugin_option_version'] = $vstrsnln_plugin_info['Version'];
			/* show pro features */
			$vstrsnln_options['hide_premium_options'] = array();
			$update_option                            = true;
		}
		/* Update plugin database */
		if ( ! isset( $vstrsnln_options['plugin_db_version'] ) || $vstrsnln_options['plugin_db_version'] !== $db_version ) {
			vstrsnln_install_base();
			$vstrsnln_options['plugin_db_version'] = $db_version;
			$update_option                         = true;
		}
		if ( isset( $update_option ) ) {
			update_option( 'vstrsnln_options', $vstrsnln_options );
		}

$vstrsnln_user_interval = $vstrsnln_options['check_user_interval'];
	}
}

if ( ! function_exists( 'vstrsnln_get_options_default' ) ) {
	/**
	 * Array with default options
	 */
	function vstrsnln_get_options_default() {
		global $vstrsnln_plugin_info;

$default_options = array(
			'plugin_option_version'   => $vstrsnln_plugin_info['Version'],
			'display_settings_notice' => 1,
			'suggest_feature_banner'  => 1,
			'check_user_interval'     => 15,
			'structure_pattern'       => __( 'Visitors online', 'visitors-online' ) . " – {TOTAL}\n" .
				__( 'users', 'visitors-online' ) . " – {USERS}\n" .
				__( 'guests', 'visitors-online' ) . " – {GUESTS}\n" .
				__( 'bots', 'visitors-online' ) . " – {BOTS}\n" .
				__( 'The maximum number of visits was', 'visitors-online' ) . " – {MAX-DATE}\n" .
				__( 'all visitors', 'visitors-online' ) . " – {MAX-TOTAL}\n" .
				__( 'users', 'visitors-online' ) . " – {MAX-USERS}\n" .
				__( 'guests', 'visitors-online' ) . " – {MAX-GUESTS}\n" .
				__( 'bots', 'visitors-online' ) . ' – {MAX-BOTS}',
		);

$blog_id       = get_current_blog_id();
		$table_general = vstrsnln_get_table_general( $blog_id );

if ( ! empty( $table_general->country ) ) {
			$default_options['structure_pattern'] .= "\n" . __( 'country', 'visitors-online' ) . ' – {COUNTRY}';
		}

if ( ! empty( $table_general->browser ) ) {
			$default_options['structure_pattern'] .= "\n" . __( 'browser', 'visitors-online' ) . ' – {BROWSER}';
		}

return $default_options;
	}
}

if ( ! function_exists( 'vstrsnln_admin_head' ) ) {
	/**
	 * Function to add script and styles to the admin panel
	 */
	function vstrsnln_admin_head() {
		global $vstrsnln_plugin_info;
		if ( ! isset( $vstrsnln_plugin_info ) ) {
			if ( ! function_exists( 'get_plugin_data' ) ) {
				require_once ABSPATH . 'wp-admin/includes/plugin.php';
			}
			$vstrsnln_plugin_info = get_plugin_data( __FILE__ );
		}
		wp_enqueue_style( 'vstrsnln_icon', plugins_url( 'css/icon.css', __FILE__ ), false, $vstrsnln_plugin_info['Version'] );
		if ( isset( $_REQUEST['page'] ) && 'visitors-online.php' === $_REQUEST['page'] ) {
			bws_enqueue_settings_scripts();
			bws_plugins_include_codemirror();
			wp_enqueue_style( 'vstrsnln_stylesheet', plugins_url( 'css/style.css', __FILE__ ), false, $vstrsnln_plugin_info['Version'] );
			wp_enqueue_script( 'vstrsnln_script', plugins_url( 'js/script.js', __FILE__ ), array( 'jquery' ), $vstrsnln_plugin_info['Version'], false );
			wp_enqueue_script( 'vstrsnln_country_script', plugins_url( 'js/import-country.js', __FILE__ ), array(), $vstrsnln_plugin_info['Version'], false );
			$vstrsnln_var = array(
				'notice_finish'  => __( 'Import was finished', 'visitors-online' ),
				'notice_false'   => __( 'Not enough rights to import from the GeoIPCountryWhois.csv file, import is impossible', 'visitors-online' ),
				'vstrsnln_nonce' => wp_create_nonce( 'bws_plugin', 'vstrsnln_ajax_nonce_field' ),
			);
			wp_localize_script( 'vstrsnln_country_script', 'vstrsnln_var', $vstrsnln_var );
			wp_localize_script( 'vstrsnln_script', 'vstrsnln_ajax', array( 'vstrsnln_nonce' => wp_create_nonce( 'bws_plugin', 'vstrsnln_ajax_nonce_field' ) ) );

if ( isset( $_GET['action'] ) && 'custom_code' === $_GET['action'] ) {
				bws_plugins_include_codemirror();
			}
		}
	}
}

if ( ! function_exists( 'vstrsnln_install' ) ) {
	/**
	 * Function sets crons events
	 */
	function vstrsnln_install() {
		vstrsnln_install_base();

if ( is_multisite() ) {
			$all_blogs = wp_get_sites();

foreach ( $all_blogs as $key => $val ) {
				switch_to_blog( $val['blog_id'] );
				/* Add the planned hook - check users online */
				if ( ! wp_next_scheduled( 'vstrsnln_check_users' ) ) {
					$vstrsnln_time = time() + 60;
					wp_schedule_event( $vstrsnln_time, 'vstrsnln_interval', 'vstrsnln_check_users' );
				}
				/* Add the planned hook - record of the day with the maximum number of visits */
				if ( ! wp_next_scheduled( 'vstrsnln_count_visits_day' ) ) {
					$vstrsnln_time_daily = strtotime( date( 'Y-m-d', strtotime( ' +1 day' ) ) . ' 00:00:59' );
					wp_schedule_event( $vstrsnln_time_daily, 'daily', 'vstrsnln_count_visits_day' );
				}
			}
			/* register uninstall hook */
			switch_to_blog( 1 );
			register_uninstall_hook( __FILE__, 'vstrsnln_uninstall' );
			restore_current_blog();
		} else {
			/* Add the planned hook - check users online */
			if ( ! wp_next_scheduled( 'vstrsnln_check_users' ) ) {
				$vstrsnln_time = time() + 60;
				wp_schedule_event( $vstrsnln_time, 'vstrsnln_interval', 'vstrsnln_check_users' );
			}
			/* Add the planned hook - record of the day with the maximum number of visits */
			if ( ! wp_next_scheduled( 'vstrsnln_count_visits_day' ) ) {
				$vstrsnln_time_daily = strtotime( date( 'Y-m-d', strtotime( ' +1 day' ) ) . ' 00:00:59' );
				wp_schedule_event( $vstrsnln_time_daily, 'daily', 'vstrsnln_count_visits_day' );
			}
			/* register uninstall hook */
			register_uninstall_hook( __FILE__, 'vstrsnln_uninstall' );
		}
	}
}

if ( ! function_exists( 'vstrsnln_install_base' ) ) {
	/**
	 * Function to create a new tables in database, sets crons events, settings defaults
	 */
	function vstrsnln_install_base() {
		global $wpdb;
		require_once ABSPATH . 'wp-admin/includes/upgrade.php';

/* Data users connect : connection time, country, browser, etc. */
		if ( ! $wpdb->query( "SHOW TABLES LIKE '{$wpdb->base_prefix}vstrsnln_detailing'" ) ) {
			$sql = 'CREATE TABLE `' . $wpdb->base_prefix . 'vstrsnln_detailing` (
				`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
				`date_connection` DATE NOT NULL,
				`time_on` INT( 10 ),
				`time_off` INT( 10 ),
				`user_type` CHAR( 5 ),
				`user_name` VARCHAR( 255 ),
				`browser` CHAR( 100 ),
				`country_id` INT( 10 ),
				`ip_user` CHAR( 16 ),
				`user_cookie` CHAR( 32 ),
				`blog_id` CHAR( 5 ),
				PRIMARY KEY ( `id` )
				) ENGINE = InnoDB DEFAULT CHARSET = utf8;';
			dbDelta( $sql );
		}

/* Data about day with a number of connections */
		if ( ! $wpdb->query( "SHOW TABLES LIKE '{$wpdb->base_prefix}vstrsnln_general'" ) ) {
			$sql = 'CREATE TABLE `' . $wpdb->base_prefix . 'vstrsnln_general` (
				`id` INT( 3 ) UNSIGNED NOT NULL AUTO_INCREMENT,
				`date_connection` DATE NOT NULL,
				`number_users` INT,
				`number_bots` INT,
				`number_guests` INT,
				`number_visits` INT,
				`blog_id` CHAR( 5 ),
				`country_id` INT,
				`browser` CHAR( 70 ),
				PRIMARY KEY ( `id` )
				) ENGINE = InnoDB DEFAULT CHARSET = utf8;';
			dbDelta( $sql );
		}

$wpdb->query( 'ALTER TABLE `' . $wpdb->base_prefix . 'vstrsnln_general` ADD UNIQUE ( `date_connection` ,`blog_id`)' );

/* v0.2 -> 0.3 */
		$wpdb->query( 'DROP TABLE IF EXISTS `' . $wpdb->base_prefix . 'bws_country`;' );
		$column_exists = $wpdb->query( 'SHOW COLUMNS FROM `' . $wpdb->base_prefix . "vstrsnln_general` LIKE 'country_id'" );
		if ( empty( $column_exists ) ) {
			$wpdb->query( 'ALTER TABLE `' . $wpdb->base_prefix . 'vstrsnln_general` ADD `country_id` INT AFTER `blog_id`;' );

$all_countries = $wpdb->get_results( 'SELECT DISTINCT `country` FROM `' . $wpdb->base_prefix . 'vstrsnln_general`', ARRAY_A );
			if ( ! empty( $all_countries ) ) {
				$number_general = $wpdb->query( "SHOW TABLES LIKE '{$wpdb->base_prefix}bws_list_countries'" );
				if ( $number_general > 0 && $wpdb->get_var( "SELECT count( * ) FROM {$wpdb->base_prefix}bws_list_countries LIMIT 1;" ) > 0 ) {
					foreach ( $all_countries as $value ) {
						$country_id = $wpdb->get_var(
							$wpdb->prepare(
								'SELECT `id`
								FROM ' . $wpdb->base_prefix . 'bws_list_countries
								WHERE `country_name` = %s LIMIT 1;',
								$value['country']
							)
						);

$wpdb->update(
							$wpdb->base_prefix . 'vstrsnln_general',
							array( 'country_id' => $country_id ),
							array( 'country' => $value['country'] )
						);
					}
				} else {
					/* defer until creating country tables */
					$vstrsnln_options['defer_update_country'] = true;
				}
			}
			if ( ! isset( $vstrsnln_options['defer_update_country'] ) ) {
				$wpdb->query( 'ALTER TABLE `' . $wpdb->base_prefix . 'vstrsnln_general` DROP COLUMN `country`;' );
			}

$wpdb->query( 'UPDATE `' . $wpdb->base_prefix . 'vstrsnln_detailing` SET `country_id`= 0' );

if ( ! isset( $vstrsnln_options['defer_update_country'] ) ) {
				vstrsnln_check_country();
			}
		}
		/* Identification of the country by IP */
		if ( ! $wpdb->query( "SHOW TABLES LIKE '{$wpdb->base_prefix}bws_list_ip'" ) ) {
			$sql = "CREATE TABLE `{$wpdb->base_prefix}bws_list_ip` (
                `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
                `ip_from` CHAR( 15 ),
                `ip_to` CHAR( 15 ),
                `ip_from_int` BIGINT( 12 ) UNIQUE,
                `ip_to_int` BIGINT( 12 ) UNIQUE,
                `country_id` INT,
                PRIMARY KEY ( `id` )
                ) ENGINE = InnoDB DEFAULT CHARSET = utf8;";
			dbDelta( $sql );
		}
		if ( ! $wpdb->query( "SHOW TABLES LIKE '{$wpdb->base_prefix}bws_list_countries'" ) ) {
			$sql = "CREATE TABLE `{$wpdb->base_prefix}bws_list_countries` (
                `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
                `country_code` CHAR( 2 ) UNIQUE,
                `country_name` CHAR( 30 ),
                PRIMARY KEY ( `id` )
                ) ENGINE = InnoDB DEFAULT CHARSET = utf8;";
			dbDelta( $sql );
		}
	}
}

if ( ! function_exists( 'vstrsnln_write_user_base' ) ) {
	/**
	 * Add or changes the data a user in the table "Detailing"
	 */
	function vstrsnln_write_user_base() {
		global $wpdb, $vstrsnln_user_interval;
		/* Return in doing cron */
		if ( defined( 'DOING_CRON' ) && DOING_CRON ) {
			return;
		}

if ( isset( $_SERVER['HTTP_USER_AGENT'] ) && ! empty( $_SERVER['HTTP_USER_AGENT'] ) ) {
			$vstrsnln_user_agent = sanitize_text_field( wp_unslash( $_SERVER['HTTP_USER_AGENT'] ) );
		}

$vstrsnln_blog_id      = get_current_blog_id();
		$vstrsnln_record_table = 0;

if ( isset( $_COOKIE['vstrsnln'] ) ) {
			$vstrsnln_record_table = (int) $wpdb->get_var(
				$wpdb->prepare(
					'SELECT count( * )
					FROM `' . $wpdb->base_prefix . 'vstrsnln_detailing`
					WHERE `time_off` IS NULL
						AND `user_cookie` = %s
					LIMIT 1',
					sanitize_text_field( wp_unslash( $_COOKIE['vstrsnln'] ) )
				)
			);
		}
		$vstrsnln_guest_admin = ( is_admin() ) ? false : true;

if ( isset( $_COOKIE['vstrsnln'] ) && $vstrsnln_record_table > 0 ) {
			$vstrsnln_user  = false;
			$vstrsnln_guest = false;
			/* Сheck bot */
			if ( true === vstrsnln_list_bots( $vstrsnln_user_agent ) ) {
				$vstrsnln_user_type = 'bot';
			} else {
				$vstrsnln_current_user = wp_get_current_user();
				/* If not bot, check guest */
				$vstrsnln_current_id = $vstrsnln_current_user->ID;
				if ( false === $vstrsnln_guest_admin ) {
					$vstrsnln_user      = true;
					$vstrsnln_user_type = 'user';
				} else {
					if ( empty( $vstrsnln_current_id ) ) {
						$vstrsnln_guest     = true;
						$vstrsnln_user_type = 'guest';
					} else {
						/* Check user */
						$vstrsnln_user      = true;
						$vstrsnln_user_type = 'user';
					}
				}
			}
			/* Update record database table */
			setcookie( 'vstrsnln', $_COOKIE['vstrsnln'], time() + $vstrsnln_user_interval * 60, '/' );
			$wpdb->update(
				$wpdb->base_prefix . 'vstrsnln_detailing',
				array(
					'time_on'         => time(),
					'date_connection' => date( 'Y.m.d' ),
					'user_type'       => $vstrsnln_user_type,
					'blog_id'         => $vstrsnln_blog_id,
				),
				array( 'user_cookie' => sanitize_text_field( wp_unslash( $_COOKIE['vstrsnln'] ) ) )
			);
		} else {
			/* Сreate a new record of the database table */
			$vstrsnln_bot   = false;
			$vstrsnln_user  = false;
			$vstrsnln_guest = false;

if ( isset( $_SERVER['HTTP_USER_AGENT'] ) && ! empty( $_SERVER['HTTP_USER_AGENT'] ) ) {
				$vstrsnln_user_agent = sanitize_text_field( wp_unslash( $_SERVER['HTTP_USER_AGENT'] ) );
				/* Detects the browser and its version */
				preg_match( '/(Firefox|Opera|Chrome|MSIE|OPR|Trident|Avant|Acoo|Iron|Orca|Lynx|Version|Opera Mini|Netscape|Konqueror|SeaMonkey|Camino|Minefield|Iceweasel|K-Meleon|Maxthon)(?:\/| )([0-9.]+)/', $vstrsnln_user_agent, $vstrsnln_browser_info );
				list( , $browser, $version ) = $vstrsnln_browser_info;
				$vstrsnln_browser            = $browser . ' ' . $version;
				if ( preg_match( '/Opera ( [0-9.]+ ) /i', $vstrsnln_user_agent, $opera ) ) {
					$vstrsnln_browser = ( $opera[1] ) ? 'Opera ' . $opera[1] : 'Opera ';
				}
				if ( 'MSIE' === $browser ) {
					preg_match( '/( Maxthon|Avant Browser|MyIE2 )/i', $vstrsnln_user_agent, $ie );
					$vstrsnln_browser = ( $ie && $ie[1] ) ? $ie[1] . ' based on IE ' . $version : 'IE ' . $version;
				}
				if ( 'Firefox' === $browser ) {
					preg_match( '/( Flock|Navigator|Epiphany)\/([0-9.]+ ) /', $vstrsnln_user_agent, $ff );
					if ( $ff ) {
						$vstrsnln_browser = ( $ff[1] && $ff[2] ) ? $ff[1] . ' ' . $ff[2] : '';
					}
				}
				if ( 'Opera' === $browser && '9.80' === $version ) {
					$vstrsnln_browser = 'Opera ' . substr( $vstrsnln_user_agent, -5 );
				}
				if ( 'Version' === $browser ) {
					$vstrsnln_browser = 'Safari ' . $version;
				}
				if ( ! $browser && strpos( $vstrsnln_user_agent, 'Gecko' ) ) {
					$vstrsnln_browser = 'Browser based on Gecko';
				}
				/* Сheck bot */
				if ( true === vstrsnln_list_bots( $vstrsnln_user_agent ) ) {
					$vstrsnln_user_type = 'bot';
					$vstrsnln_bot       = true;
				}
			} else {
				$vstrsnln_browser = '';
			}
			if ( true !== $vstrsnln_bot ) {
				$vstrsnln_current_user = wp_get_current_user();
				/* If not bot, check guest */
				$vstrsnln_current_id = $vstrsnln_current_user->ID;
				if ( false === $vstrsnln_guest_admin ) {
					$vstrsnln_user      = true;
					$vstrsnln_user_type = 'user';
				} else {
					if ( empty( $vstrsnln_current_id ) ) {
						$vstrsnln_guest     = true;
						$vstrsnln_user_type = 'guest';
					} else {
						/* Check user */
						$vstrsnln_user      = true;
						$vstrsnln_user_type = 'user';
					}
				}
			}
			/* Set a cookie */
			$vstrsnln_cookie_value = md5( 'vstrsnln' . date( 'H:i:s' ) );
			setcookie( 'vstrsnln', $vstrsnln_cookie_value, time() + $vstrsnln_user_interval * 60, '/' );
			/* Detects the IP */
			$ip = '';
			if ( isset( $_SERVER ) ) {
				$sever_vars = array( 'REMOTE_ADDR', 'HTTP_X_REAL_IP', 'HTTP_CLIENT_IP', 'HTTP_X_FORWARDED_FOR' );
				foreach ( $sever_vars as $var ) {
					if ( isset( $_SERVER[ $var ] ) && ! empty( $_SERVER[ $var ] ) ) {
						if ( filter_var( $_SERVER[ $var ], FILTER_VALIDATE_IP ) ) {
							$ip = sanitize_text_field( wp_unslash( $_SERVER[ $var ] ) );
							break;
						} else { /* if proxy */
							$ip_array = explode( ',', sanitize_text_field( wp_unslash( $_SERVER[ $var ] ) ) );
							if ( is_array( $ip_array ) && ! empty( $ip_array ) && filter_var( $ip_array[0], FILTER_VALIDATE_IP ) ) {
								$ip = $ip_array[0];
								break;
							}
						}
					}
				}
			}
			if ( ! empty( $ip ) ) {
				/* Detects the country */
				$number_general = $wpdb->query( "SHOW TABLES LIKE '{$wpdb->base_prefix}bws_list_ip'" );
				if ( $number_general > 0 ) {
					$vstrsnln_country = $wpdb->get_var(
						$wpdb->prepare(
							'SELECT `country_id` FROM `' . $wpdb->base_prefix . 'bws_list_ip`
							WHERE `ip_from_int` <= %s 
							AND `ip_to_int` >=  %s LIMIT 1;',
							sprintf( '%u', ip2long( $ip ) ),
							sprintf( '%u', ip2long( $ip ) )
						)
					);
				} else {
					$vstrsnln_country = 0;
				}
				$wpdb->insert(
					$wpdb->base_prefix . 'vstrsnln_detailing',
					array(
						'date_connection' => date( 'Y.m.d' ),
						'time_on'         => time(),
						'user_type'       => $vstrsnln_user_type,
						'browser'         => $vstrsnln_browser,
						'country_id'      => $vstrsnln_country,
						'ip_user'         => $ip,
						'user_cookie'     => $vstrsnln_cookie_value,
						'blog_id'         => $vstrsnln_blog_id,
					)
				);
			}
		}
	}
}

if ( ! function_exists( 'vstrsnln_check_user' ) ) {
	/**
	 * We do not check the elapsed time during which the user is considered online
	 */
	function vstrsnln_check_user() {
		global $wpdb, $vstrsnln_user_interval;
		$vstrsnln_blog_id   = get_current_blog_id();
		$time               = time() - $vstrsnln_user_interval * 60;
		$vstrsnln_all_users = $wpdb->get_results(
			$wpdb->prepare(
				'SELECT `id`
				FROM `' . $wpdb->base_prefix . 'vstrsnln_detailing`
				WHERE `time_off` IS NULL
					AND `time_on` <= %d
					AND `blog_id` = %d',
				$time,
				$vstrsnln_blog_id
			)
		);
		if ( is_array( $vstrsnln_all_users ) ) {
			foreach ( $vstrsnln_all_users as $vstrsnln_user ) {
				$wpdb->update(
					$wpdb->base_prefix . 'vstrsnln_detailing',
					array(
						'time_off' => time(),
					),
					array(
						'id'      => $vstrsnln_user->id,
						'blog_id' => $vstrsnln_blog_id,
					)
				);
			}
		}
	}
}

if ( ! function_exists( 'vstrsnln_settings_page' ) ) {
	/**
	 * Work on the settings page
	 */
	function vstrsnln_settings_page() {
		global $vstrsnln_options;
		$message = '';
		$error   = '';

if ( isset( $_REQUEST['vstrsnln_submit'] ) && check_admin_referer( plugin_basename( __FILE__ ), 'vstrsnln_nonce_name' ) ) {
			if ( isset( $_POST['bws_hide_premium_options'] ) ) {
				$hide_result      = bws_hide_premium_options( $vstrsnln_options );
				$vstrsnln_options = $hide_result['options'];
			}
		}
		/* Pressing the 'Import Country' */
		$vstrsnln_result_downloaded = vstrsnln_press_buttom_import();
		$result                     = $vstrsnln_result_downloaded['result'];
		if ( 0 !== $result ) {
			$message = $vstrsnln_result_downloaded['message'];
			$error   = $vstrsnln_result_downloaded['error'];
		}
		if ( true === $result ) {
			vstrsnln_check_country( true );
		}
		if ( ! class_exists( 'Bws_Settings_Tabs' ) ) {
			require_once dirname( __FILE__ ) . '/bws_menu/class-bws-settings.php';
		}
		require_once dirname( __FILE__ ) . '/includes/class-vstrsnln-settings.php';
		$page = new Vstrsnln_Settings_Tabs( plugin_basename( __FILE__ ) ); ?>
		<div class="wrap">
			<h1><?php esc_html_e( 'Visitors Online Settings', 'visitors-online' ); ?></h1>
			<div class="updated fade below-h2" 
			<?php
			if ( '' === $message || '' !== $error ) {
				echo 'style="display:none"';}
			?>
			><p><strong><?php echo esc_html( $message ); ?></strong></p></div>
			<div class="error below-h2" 
			<?php
			if ( '' === $error ) {
				echo 'style="display:none"';}
			?>
			><p><strong><?php echo esc_html( $error ); ?></strong></p>
		</div>
		<noscript>
			<div class="error below-h2">
				<p><strong><?php esc_html_e( 'Please, enable JavaScript in your browser.', 'visitors-online' ); ?></strong></p>
			</div>
		</noscript>
		<?php
		$page->display_content();
	}
}

if ( ! function_exists( 'vstrsnln_write_max_visits' ) ) {
	/**
	 * Checking whether the maximum number of users yesterday
	 */
	function vstrsnln_write_max_visits() {
		global $wpdb;

$blog_id = get_current_blog_id();
		/* Date two days ago, to clean the table detailing */
		$date_delete = date( 'Y-m-d', time() - 172800 );
		/* Determine the last day for which the processed statistics */
		$general_last_day = $wpdb->get_var(
			$wpdb->prepare(
				'SELECT `date_connection`
				FROM `' . $wpdb->base_prefix . '"vstrsnln_general`
				WHERE `blog_id` = %d
				ORDER BY `date_connection` DESC
				LIMIT 1',
				$blog_id
			)
		);
		if ( empty( $general_last_day ) ) {
			$begin = new DateTime( 'yesterday' );
		} else {
			$begin = new DateTime( $general_last_day );
			$begin = $begin->modify( '+1 day' );
		}
		$end       = new DateTime( '-1 day' );
		$interval  = new DateInterval( 'P1D' );
		$daterange = new DatePeriod( $begin, $interval, $end );
		foreach ( $daterange as $key => $date ) {
			if ( is_object( $date ) ) {
				$date_yesterday = $date->format( 'Y-m-d' );
			} else {
				$date_yesterday = date( 'Y-m-d', strtotime( $date ) );
			}
			$number_visits_detailing = $wpdb->get_var(
				$wpdb->prepare(
					'SELECT count( * )
					FROM `' . $wpdb->base_prefix . 'vstrsnln_detailing`
					WHERE `date_connection` = %s
						AND `blog_id` = %d
					LIMIT 1',
					$date_yesterday,
					$blog_id
				)
			);

if ( 0 !== absint( $number_visits_detailing ) ) {
				$type_user = $wpdb->get_row(
					$wpdb->prepare(
						'SELECT COUNT( * ) AS "guest",
							( SELECT COUNT( * ) FROM `' . $wpdb->base_prefix . 'vstrsnln_detailing`
								WHERE `date_connection` = %s
									AND `user_type` = "bot"
									AND `blog_id` = %d
							) AS "bot",
							( SELECT COUNT( * ) FROM `' . $wpdb->base_prefix . 'vstrsnln_detailing`
								WHERE `date_connection` = %s
									AND `user_type` = "user"
									AND `blog_id` = %d
							) AS "user"
						FROM `' . $wpdb->base_prefix . 'vstrsnln_detailing`
						WHERE `date_connection` = %s
						AND `user_type` = "guest"
						AND `blog_id` = %d
						LIMIT 1',
						$date_yesterday,
						$blog_id,
						$date_yesterday,
						$blog_id,
						$date_yesterday,
						$blog_id
					)
				);

/* We determine which country had the maximum number of connections */
				$country_max_connections = $wpdb->get_var(
					$wpdb->prepare(
						'SELECT `country_id`
						FROM `' . $wpdb->base_prefix . 'vstrsnln_detailing`
						WHERE `date_connection` = %s
							AND `country_id` != "0"
							AND `blog_id` = %d
						GROUP BY country_id
						ORDER BY count( * )
						DESC LIMIT 1;',
						$date_yesterday,
						$blog_id
					)
				);

/* We determine which browser had the maximum number of connections */
				$browser_max_connections = $wpdb->get_var(
					$wpdb->prepare(
						'SELECT `browser`
						FROM `' . $wpdb->base_prefix . 'vstrsnln_detailing`
						WHERE `date_connection` = %s
							AND `browser` != ""
							AND `blog_id` = %d
						GROUP BY browser
						ORDER BY count( * )
						DESC LIMIT 1;',
						$date_yesterday,
						$blog_id
					)
				);

/* No records in the table */
				$wpdb->insert(
					$wpdb->base_prefix . 'vstrsnln_general',
					array(
						'date_connection' => $date_yesterday,
						'number_users'    => $type_user->user,
						'number_bots'     => $type_user->bot,
						'number_guests'   => $type_user->guest,
						'number_visits'   => $number_visits_detailing,
						'blog_id'         => $blog_id,
						'country_id'      => $country_max_connections,
						'browser'         => $browser_max_connections,
					)
				);
			}
			if ( ! is_object( $date ) ) {
				break;
			}
		}
		/* Keep records for two days, delete the remaining */
		$wpdb->query(
			$wpdb->prepare(
				'DELETE
				FROM `' . $wpdb->base_prefix . 'vstrsnln_detailing`
				WHERE `date_connection` <= %s
					AND `blog_id` = %d',
				$date_delete,
				$blog_id
			)
		);
	}
}

if ( ! function_exists( 'vstrsnln_add_user_interval' ) ) {
	/**
	 * Create an interval for checking user online
	 *
	 * @param array $schedules Array with interval.
	 * @return array $schedules
	 */
	function vstrsnln_add_user_interval( $schedules ) {
		global $vstrsnln_options;

if ( ! $vstrsnln_options ) {
			vstrsnln_default_options();
		}

$vstrsnln_user_interval         = $vstrsnln_options['check_user_interval'];
		$vstrsnln_display               = $vstrsnln_user_interval . __( 'min', 'visitors-online' );
		$schedules['vstrsnln_interval'] = array(
			'interval' => 60 * $vstrsnln_user_interval,
			'display'  => $vstrsnln_display,
		);
		return $schedules;
	}
}

if ( ! function_exists( 'vstrsnln_list_bots' ) ) {
	/**
	 * List of bots
	 *
	 * @param string $vstrsnln_user_agent User agent.
	 */
	function vstrsnln_list_bots( $vstrsnln_user_agent ) {
		$vstrsnln_array_bots       = array(
			'AbachoBOT',
			'accoona',
			'AdsBot-Google',
			'agama',
			'alexa.com',
			'AltaVista',
			'aport/',
			'ask.com',
			'ASPSeek',
			'bing.com',
			'Baiduspider/',
			'Copyscape.com',
			'crawler@fast',
			'CrocCrawler',
			'Dumbot',
			'FAST-WebCrawler',
			'GeonaBot',
			'gigabot',
			'Gigabot',
			'googlebot/',
			'Googlebot/',
			'ia_archiver',
			'igde.ru',
			'liveinternet.ru',
			'Lycos/',
			'mail.ru',
			'MantraAgent',
			'metadatalabs.com',
			'msnbot/',
			'MSRBOT',
			'Nigma.ru',
			'qwartabot',
			'Robozilla',
			'sape.bot',
			'sape_context',
			'scooter/',
			'Scrubby',
			'snapbot',
			'Slurp',
			'Teoma_agent',
			'WebAlta',
			'WebCrawler',
			'YandexBot',
			'yaDirectBot',
			'yahoo/',
			'yandexSomething',
			'yanga.co.uk',
			'ZyBorg',
		);
		$vstrsnln_current_user_bot = false;
		foreach ( $vstrsnln_array_bots as $vstrsnln_bot_name ) {
			if ( false !== stripos( $vstrsnln_user_agent, $vstrsnln_bot_name ) ) {
				$vstrsnln_current_user_bot = true;
				break;
			}
		}
		return $vstrsnln_current_user_bot;
	}
}

if ( ! function_exists( 'vstrsnln_info_display' ) ) {
	/**
	 * Display information about users onlin
	 *
	 * @param bool $is_widget Flag for widget.
	 */
	function vstrsnln_info_display( $is_widget = false ) {
		global $wpdb, $vstrsnln_options;
		$vstrsnln_blog_id    = get_current_blog_id();
		$vstrsnln_content    = $vstrsnln_options['structure_pattern'];
		$vstrsnln_date_today = date( 'Y-m-d', time() );

/* get realtime info */
		$vstrsnln_type_user = $wpdb->get_row(
			$wpdb->prepare(
				'
				SELECT COUNT( * ) AS "guest",
					( SELECT COUNT( * ) FROM `' . $wpdb->base_prefix . 'vstrsnln_detailing`
					LEFT JOIN `' . $wpdb->base_prefix . 'bws_list_countries` ON `' . $wpdb->base_prefix . 'bws_list_countries` . `id`=`' . $wpdb->base_prefix . 'vstrsnln_detailing` . `country_id`
						WHERE `date_connection` = %s
							AND `user_type` = %s
							AND `time_off` IS NULL
							AND `blog_id` = %d
					) AS "bot",
					( SELECT COUNT( * ) FROM `' . $wpdb->base_prefix . 'vstrsnln_detailing`
					LEFT JOIN `' . $wpdb->base_prefix . 'bws_list_countries` ON `' . $wpdb->base_prefix . 'bws_list_countries` . `id`=`' . $wpdb->base_prefix . 'vstrsnln_detailing` . `country_id`
						WHERE `date_connection` = %s
							AND `user_type` = %s
							AND `time_off` IS NULL
							AND `blog_id` = %d
					) AS "user"
				FROM `' . $wpdb->base_prefix . 'vstrsnln_detailing`
				LEFT JOIN `' . $wpdb->base_prefix . 'bws_list_countries` ON `' . $wpdb->base_prefix . 'bws_list_countries` . `id`=`' . $wpdb->base_prefix . 'vstrsnln_detailing` . `country_id`
				WHERE `date_connection` = %s
				AND `user_type` = %s
				AND `time_off` IS NULL
				AND `blog_id` = %d
				LIMIT 1',
				$vstrsnln_date_today,
				'bot',
				$vstrsnln_blog_id,
				$vstrsnln_date_today,
				'user',
				$vstrsnln_blog_id,
				$vstrsnln_date_today,
				'guest',
				$vstrsnln_blog_id
			)
		);

$table_general = vstrsnln_get_table_general( $vstrsnln_blog_id );

/* preparing data for placeholder replacing */
		$replacements = array(
			'total'  => 0, /* total count will be calculated later */
			'users'  => $vstrsnln_type_user->user,
			'guests' => $vstrsnln_type_user->guest,
			'bots'   => $vstrsnln_type_user->bot,
		);

/* get total "realtime visitors" count */
		if ( strpos( $vstrsnln_content, '{USERS}' ) ) {
			$replacements['total'] += $vstrsnln_type_user->user;
		}

if ( strpos( $vstrsnln_content, '{GUESTS}' ) ) {
			$replacements['total'] += $vstrsnln_type_user->guest;
		}

if ( strpos( $vstrsnln_content, '{BOTS}' ) ) {
			$replacements['total'] += $vstrsnln_type_user->bot;
		}

if ( ! strpos( $vstrsnln_content, '{USERS}' ) && ! strpos( $vstrsnln_content, '{GUESTS}' ) && ! strpos( $vstrsnln_content, '{BOTS}' ) ) {
			$replacements['total'] = $vstrsnln_type_user->bot + $vstrsnln_type_user->guest + $vstrsnln_type_user->user;
		}

/* add new replacements */
		if ( ! empty( $table_general ) ) {
			$max_replacements = array(
				'max-date'   => $table_general->date_connection,
				'max-total'  => $table_general->number_visits,
				'max-users'  => $table_general->number_users,
				'max-guests' => $table_general->number_guests,
				'max-bots'   => $table_general->number_bots,
			);

/* get total "max visitors" count */
			if ( ! strpos( $vstrsnln_content, '{MAX-USERS}' ) ) {
				$max_replacements['max-total'] -= $table_general->number_users;
			}

if ( ! strpos( $vstrsnln_content, '{MAX-GUESTS}' ) ) {
				$max_replacements['max-total'] -= $table_general->number_guests;
			}

if ( ! strpos( $vstrsnln_content, '{MAX-BOTS}' ) ) {
				$max_replacements['max-total'] -= $table_general->number_bots;
			}

/* add geo replacements */
			$geo_replacements = array();

if ( ! empty( $table_general->country_id ) ) {
				$geo_replacements['country'] = $wpdb->get_var(
					$wpdb->prepare(
						'
						SELECT `country_name`
						FROM `' . $wpdb->base_prefix . 'bws_list_countries`
						WHERE `id` = %d',
						$table_general->country_id
					)
				);
			} else {
				$geo_replacements['country'] = __( 'No data', 'visitors-online' );
			}

$geo_replacements['browser'] =
				! empty( $table_general->browser ) ?
				$table_general->browser :
				__( 'No data', 'visitors-online' );

$replacements = array_merge( $replacements, $geo_replacements );
		} else {
			/* max replacements = realtime replacements if $table_general is empty (at first day, you install the plugin) */
			$max_replacements = array(
				'max-date'   => date( 'Y-m-d' ),
				'max-total'  => $replacements['total'],
				'max-users'  => $replacements['users'],
				'max-guests' => $replacements['guests'],
				'max-bots'   => $replacements['bots'],
				'country'    => __( 'No data', 'visitors-online' ),
				'browser'    => __( 'No data', 'visitors-online' ),
			);
		}

$replacements = array_merge( $replacements, $max_replacements );

/*
		* process patterns with foreach
		* it helps us to change brackets (when it is needed) and add PRRE modifiers
		*/
		$patterns = array();
		foreach ( $replacements as $key => $value ) {
			$patterns[] = '~{' . $key . '}~i'; /* "i" should be used to make the expression case-insensitive */
		}
		$vstrsnln_content = preg_replace( $patterns, array_values( $replacements ), $vstrsnln_content );

$vstrsnln_content = '<div class="vstrsnln-block">' . wpautop( $vstrsnln_content ) . '</div>';
		$vstrsnln_content = apply_filters( 'vstrsnln_content', $vstrsnln_content );

if ( is_admin() || true === $is_widget ) {
			echo wp_kses_post( $vstrsnln_content );
		} else {
			return wp_kses_post( $vstrsnln_content );
		}
	}
}

if ( ! function_exists( 'vstrsnln_get_table_general' ) ) {
	/**
	 * Get general table
	 *
	 * @param int $blog_id Blog ID.
	 */
	function vstrsnln_get_table_general( $blog_id ) {
		global $wpdb;

return $wpdb->get_row(
			$wpdb->prepare(
				'
				SELECT *
				FROM `' . $wpdb->base_prefix . 'vstrsnln_general`
				WHERE `blog_id` = %d
				ORDER BY `number_visits` DESC',
				$blog_id
			)
		);
	}
}

if ( ! function_exists( 'vstrsnln_shortcode_button_content' ) ) {
	/**
	 * Add shortcode content
	 *
	 * @param string $content Content.
	 */
	function vstrsnln_shortcode_button_content( $content ) {
		?>
		<div id="vstrsnln" style="display:none;">
			<fieldset>
				<?php esc_html_e( 'Add the Visitors Online counter to your website', 'visitors-online' ); ?>
			</fieldset>
			<input class="bws_default_shortcode" type="hidden" name="default" value="[vstrsnln_info]" />
			<div class="clear"></div>
		</div>
		<?php
	}
}

if ( ! function_exists( 'vstrsnln_dashboard_widget' ) ) {
	/**
	 * Display information about users online to dashboard
	 */
	function vstrsnln_dashboard_widget() {
		add_meta_box( 'vstrsnln_dashboard', 'Visitors Online', 'vstrsnln_info_display', 'dashboard', 'side', 'default' );
	}
}

if ( ! class_exists( 'Vstrsnln_Widget' ) ) {
	/**
	 * Widet for display info
	 */
	class Vstrsnln_Widget extends WP_Widget {

/**
		 * Construct
		 */
		public function __construct() {
			parent::__construct(
				false,
				'Visitors Online',
				array(
					'classname'   => 'visitors-online',
					'description' => __( 'This Widget shows the number of active visitors on the site, including users, guests and bots.', 'visitors-online' ),
				)
			);
		}

/**
		 * Widget
		 *
		 * @param array $args     Array with widget args.
		 * @param array $instance Widget instance.
		 */
		public function widget( $args, $instance ) {
			echo wp_kses_post( $args['before_widget'] );
			if ( ! empty( $instance['vstrsnln_widget_title'] ) ) {
				echo wp_kses_post( $args['before_title'] . apply_filters( 'widget_title', $instance['vstrsnln_widget_title'], $instance, $this->id_base ) . $args['after_title'] );
			}
			vstrsnln_info_display( true );
			echo wp_kses_post( $args['after_widget'] );
		}

/**
		 * Update widhet
		 *
		 * @param array $new_instance Widget instance.
		 * @param array $old_instance Widget instance.
		 */
		public function update( $new_instance, $old_instance ) {
			$instance                          = $old_instance;
			$instance['vstrsnln_widget_title'] = $new_instance['vstrsnln_widget_title'];
			return $instance;
		}

/**
		 * Widget options form
		 *
		 * @param array $instance Widget instance.
		 */
		public function form( $instance ) {
			$default_widget_args = array(
				'vstrsnln_widget_title' => '',
			);
			$instance            = wp_parse_args( (array) $instance, $default_widget_args );
			?>
			<div class='vstrsnln_widget_settings'>
				<p>
					<label><?php esc_html_e( 'Title', 'visitors-online' ); ?></label><br />
					<input type="text" <?php echo wp_kses_post( $this->get_field_id( 'vstrsnln_widget_title' ) ); ?> name="<?php echo esc_attr( $this->get_field_name( 'vstrsnln_widget_title' ) ); ?>" value="<?php echo esc_html( $instance['vstrsnln_widget_title'] ); ?>" class='widefat' />
				</p>
			</div>
			<?php
		}
	}
}

if ( ! function_exists( 'vstrsnln_register_widget' ) ) {
	/**
	 * Add widget
	 */
	function vstrsnln_register_widget() {
		register_widget( 'Vstrsnln_Widget' );
	}
}

if ( ! function_exists( 'vstrsnln_uninstall' ) ) {
	/**
	 * Uninstall plugin, drop tables, delete options
	 */
	function vstrsnln_uninstall() {
		global $wpdb;

if ( ! function_exists( 'get_plugins' ) ) {
			require_once ABSPATH . 'wp-admin/includes/plugin.php';
		}
		$all_plugins = get_plugins();

if ( ! array_key_exists( 'visitors-online-pro/visitors-online-pro.php', $all_plugins ) ) {
			$wpdb->query( 'DROP TABLE `' . $wpdb->base_prefix . 'vstrsnln_general`, `' . $wpdb->base_prefix . 'vstrsnln_detailing`;' );

if ( function_exists( 'is_multisite' ) && is_multisite() ) {
				$old_blog = $wpdb->blogid;
				/* Get all blog ids */
				$blogids = $wpdb->get_col( "SELECT `blog_id` FROM $wpdb->blogs" );
				foreach ( $blogids as $blog_id ) {
					switch_to_blog( $blog_id );
					delete_option( 'vstrsnln_options' );
					delete_option( 'widget_vstrsnln_widget' );
					wp_clear_scheduled_hook( 'vstrsnln_check_users' );
					wp_clear_scheduled_hook( 'vstrsnln_count_visits_day' );
				}
				switch_to_blog( $old_blog );
			} else {
				delete_option( 'vstrsnln_options' );
				delete_option( 'widget_vstrsnln_widget' );
				wp_clear_scheduled_hook( 'vstrsnln_check_users' );
				wp_clear_scheduled_hook( 'vstrsnln_count_visits_day' );
			}
		}

$wpdb->query( 'DROP TABLE `' . $wpdb->base_prefix . 'bws_country`;' );
		$wpdb->query( 'DROP TABLE `' . $wpdb->base_prefix . 'bws_list_ip`;' );
		$wpdb->query( 'DROP TABLE `' . $wpdb->base_prefix . 'bwws_list_countries`;' );

require_once dirname( __FILE__ ) . '/bws_menu/bws_include.php';
		bws_include_init( plugin_basename( __FILE__ ) );
		bws_delete_plugin( plugin_basename( __FILE__ ) );
	}
}

if ( ! function_exists( 'vstrsnln_register_plugin_links' ) ) {
	/**
	 * Add "Settings", "FAQ", "Support" Links On The Plugin Page
	 *
	 * @param array  $links Array with links.
	 * @param string $file  File name.
	 */
	function vstrsnln_register_plugin_links( $links, $file ) {
		$base = plugin_basename( __FILE__ );
		if ( $file === $base ) {
			if ( ! is_network_admin() ) {
				$links[] = '<a href="admin.php?page=visitors-online.php">' . __( 'Settings', 'visitors-online' ) . '</a>';
			}
			$links[] = '<a href="https://support.bestwebsoft.com/hc/en-us/sections/201089295" target="_blank">' . __( 'FAQ', 'visitors-online' ) . '</a>';
			$links[] = '<a href="https://support.bestwebsoft.com">' . __( 'Support', 'visitors-online' ) . '</a>';
		}
		return $links;
	}
}

if ( ! function_exists( 'vstrsnln_plugin_action_links' ) ) {
	/**
	 * Add "Settings" Link On The Plugin Action Page
	 *
	 * @param array  $links Array with links.
	 * @param string $file  File name.
	 */
	function vstrsnln_plugin_action_links( $links, $file ) {
		if ( ! is_network_admin() ) {
			/* Static so we don't call plugin_basename on every plugin row. */
			static $this_plugin;
			if ( ! $this_plugin ) {
				$this_plugin = plugin_basename( __FILE__ );
			}
			if ( $file === $this_plugin ) {
				$settings_link = '<a href="admin.php?page=visitors-online.php">' . __( 'Settings', 'visitors-online' ) . '</a>';
				array_unshift( $links, $settings_link );
			}
		}
		return $links;
	}
}

if ( ! function_exists( 'vstrsnln_add_tabs' ) ) {
	/**
	 * Add "Help" tab
	 */
	function vstrsnln_add_tabs() {
		$screen = get_current_screen();
		$args   = array(
			'id'      => 'vstrsnln',
			'section' => '201089295',
		);
		bws_help_tab( $screen, $args );
	}
}

if ( ! function_exists( 'vstrsnln_check_country' ) ) {
	/**
	 * Сheck whether there are users with an undefined country, if there is something we define
	 *
	 * @param bool $noscript Fkag for noscript.
	 */
	function vstrsnln_check_country( $noscript = false ) {
		global $wpdb;
		if ( false === $noscript ) {
			check_ajax_referer( 'bws_plugin', 'vstrsnln_ajax_nonce_field' );
		}

$vstrsnln_country_undefined = $wpdb->get_results(
			'
			SELECT `ip_user`, `id`
			FROM `' . $wpdb->base_prefix . 'vstrsnln_detailing`
			WHERE `country_id` = 0'
		);

if ( $vstrsnln_country_undefined ) {
			foreach ( $vstrsnln_country_undefined as $vstrsnln_visitors ) {
				$ip = $vstrsnln_visitors->ip_user;
				/* Detects the country */
				$ip_int      = sprintf( '%u', ip2long( $ip ) );
				$query_where = ( empty( $ip_int ) ) ? ' `ip_to` LIKE "' . $ip . '" OR `ip_from` LIKE "' . $ip . '"' : '`ip_from_int` <= ' . $ip_int . ' AND `ip_to_int` >= ' . $ip_int;
				$country_id  = $wpdb->get_var(
					'SELECT `country_id` 
					FROM ' . $wpdb->base_prefix . 'bws_list_ip
					WHERE ' . $query_where . ' LIMIT 1;'
				);

if ( ! empty( $country_id ) ) {
					$wpdb->update(
						$wpdb->base_prefix . 'vstrsnln_detailing',
						array( 'country_id' => $country_id ),
						array( 'id' => $vstrsnln_visitors->id )
					);
				}
			}
		}
	}
}

if ( ! function_exists( 'vstrsnln_plugin_banner' ) ) {
	/**
	 * Plugin banner
	 */
	function vstrsnln_plugin_banner() {
		global $hook_suffix, $vstrsnln_plugin_info, $vstrsnln_options;
		if ( 'plugins.php' === $hook_suffix ) {
			if ( ! is_network_admin() ) {
				bws_plugin_banner_to_settings( $vstrsnln_plugin_info, 'vstrsnln_options', 'visitors-online', 'admin.php?page=visitors-online.php' );
			}
		}

if ( isset( $_REQUEST['page'] ) && 'visitors-online.php' === $_REQUEST['page'] ) {
			bws_plugin_suggest_feature_banner( $vstrsnln_plugin_info, 'vstrsnln_options', 'visitors-online' );
		}
	}
}

register_activation_hook( __FILE__, 'vstrsnln_install' );

add_action( 'admin_menu', 'vstrsnln_admin_menu' );
add_action( 'init', 'vstrsnln_plugin_init' );
add_action( 'admin_init', 'vstrsnln_plugin_admin_init' );
add_action( 'plugins_loaded', 'vstrsnln_plugins_loaded' );

add_action( 'admin_enqueue_scripts', 'vstrsnln_admin_head' );
/* Add the function to the specified hook */
add_action( 'vstrsnln_check_users', 'vstrsnln_check_user' );
/* Add the function to the specified hook - record of the day with the maximum number of visits*/
add_action( 'vstrsnln_count_visits_day', 'vstrsnln_write_max_visits' );
/* Register a user interval */
add_filter( 'cron_schedules', 'vstrsnln_add_user_interval' );
add_shortcode( 'vstrsnln_info', 'vstrsnln_info_display' );
/* custom filter for bws button in tinyMCE */
add_filter( 'bws_shortcode_button_content', 'vstrsnln_shortcode_button_content' );

add_action( 'wp_dashboard_setup', 'vstrsnln_dashboard_widget' );
add_action( 'widgets_init', 'vstrsnln_register_widget' );

/* Additional links on the plugin page */
add_filter( 'plugin_action_links', 'vstrsnln_plugin_action_links', 10, 2 );
add_filter( 'plugin_row_meta', 'vstrsnln_register_plugin_links', 10, 2 );
/* Hooks for ajax */
add_action( 'wp_ajax_vstrsnln_count_rows', 'vstrsnln_count_rows' );
add_action( 'wp_ajax_vstrsnln_insert_rows', 'vstrsnln_insert_rows' );
add_action( 'wp_ajax_vstrsnln_check_country', 'vstrsnln_check_country' );

add_action( 'admin_notices', 'vstrsnln_plugin_banner' );

Gifari Industries - BD Cyber Security Team