File: /home/healthbenefitapproval/public_html/wp-content/plugins/visitors-online/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.3
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__ ) . '/import-country.php';
if ( file_exists( $vstrsnln_fpath ) ) {
include $vstrsnln_fpath;
}
/* Function for adding menu and submenu */
if ( ! function_exists( 'vstrsnln_admin_menu' ) ) {
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' ) ) {
function vstrsnln_plugins_loaded() {
/* Internationalization, first(!) */
load_plugin_textdomain( 'visitors-online', false, dirname( plugin_basename( __FILE__ ) ) . '/languages/' );
}
}
if ( ! function_exists( 'vstrsnln_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();
}
}
/* Function to add plugin version. */
if ( ! function_exists ( 'vstrsnln_plugin_admin_init' ) ) {
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' );
}
}
/* Set default settings */
if ( ! function_exists ( 'vstrsnln_default_options' ) ) {
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'];
}
}
/* (array) array with default options */
if ( ! function_exists( 'vstrsnln_get_options_default' ) ) {
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;
}
}
/* Function to add script and styles to the admin panel. */
if ( ! function_exists ( 'vstrsnln_admin_head' ) ) {
function vstrsnln_admin_head() {
wp_enqueue_style( 'vstrsnln_icon', plugins_url( 'css/icon.css', __FILE__ ) );
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__ ) );
wp_enqueue_script( 'vstrsnln_script', plugins_url( 'js/script.js', __FILE__ ), array( 'jquery' ) );
wp_enqueue_script( 'vstrsnln_country_script', plugins_url( 'js/import-country.js', __FILE__ ), array( 'jquery' ) );
$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();
}
}
}
}
/* Function sets crons events */
if ( ! function_exists( 'vstrsnln_install' ) ) {
function vstrsnln_install() {
vstrsnln_install_base();
/* 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 */
if ( is_multisite() ) {
switch_to_blog( 1 );
register_uninstall_hook( __FILE__, 'vstrsnln_uninstall' );
restore_current_blog();
} else {
register_uninstall_hook( __FILE__, 'vstrsnln_uninstall' );
}
}
}
/* Function to create a new tables in database, sets crons events, settings defaults */
if ( ! function_exists( 'vstrsnln_install_base' ) ) {
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 IF NOT EXISTS `" . $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 IF NOT EXISTS `" . $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( "SELECT `id` FROM {$wpdb->base_prefix}bws_list_countries WHERE `country_name` = '" . $value['country'] . "' LIMIT 1;" );
$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 IF NOT EXISTS `{$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 IF NOT EXISTS `{$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 );
}
}
}
/* Add or changes the data a user in the table "Detailing" */
if ( ! function_exists( 'vstrsnln_write_user_base' ) ) {
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 = $_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",
$_COOKIE['vstrsnln']
) );
}
$vstrsnln_guest_admin = ( is_admin() ) ? false : true;
if ( isset( $_COOKIE['vstrsnln'] ) && $vstrsnln_record_table > 0 ) {
$vstrsnln_user = $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' => $_COOKIE['vstrsnln'] )
);
} else {
/* Сreate a new record of the database table */
$vstrsnln_bot = $vstrsnln_user = $vstrsnln_guest = false;
if ( isset( $_SERVER['HTTP_USER_AGENT'] ) && ! empty( $_SERVER['HTTP_USER_AGENT'] ) ) {
$vstrsnln_user_agent = $_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( 'HTTP_X_REAL_IP', 'HTTP_CLIENT_IP', 'HTTP_X_FORWARDED_FOR', 'REMOTE_ADDR' );
foreach ( $sever_vars as $var ) {
if ( isset( $_SERVER[ $var ] ) && ! empty( $_SERVER[ $var ] ) ) {
if ( filter_var( $_SERVER[ $var ], FILTER_VALIDATE_IP ) ) {
$ip = $_SERVER[ $var ];
break;
} else { /* if proxy */
$ip_array = explode( ',', $_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( "SELECT `country_id` FROM {$wpdb->base_prefix}bws_list_ip
WHERE `ip_from_int` <= '" . sprintf( '%u', ip2long( $ip ) ) . "'
AND `ip_to_int` >= '" . sprintf( '%u', ip2long( $ip ) ) . "' LIMIT 1;" );
} 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
)
);
}
}
}
}
/* We do not check the elapsed time during which the user is considered online */
if ( ! function_exists( 'vstrsnln_check_user' ) ) {
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( "
SELECT `id`
FROM `" . $wpdb->base_prefix . "vstrsnln_detailing`
WHERE `time_off` IS NULL
AND `time_on` <= " . $time . "
AND `blog_id` = '" . $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 )
);
}
}
}
}
/* Work on the settings page */
if ( ! function_exists( 'vstrsnln_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 _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 $message; ?></strong></p></div>
<div class="error below-h2" <?php if ( '' == $error ) echo 'style="display:none"'; ?>><p><strong><?php echo $error; ?></strong></p>
</div>
<noscript>
<div class="error below-h2">
<p><strong><?php _e( "Please, enable JavaScript in your browser.", 'visitors-online' ); ?></strong></p>
</div>
</noscript>
<?php $page->display_content();
}
}
/* Checking whether the maximum number of users yesterday */
if ( ! function_exists( 'vstrsnln_write_max_visits' ) ) {
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( "
SELECT `date_connection`
FROM `" . $wpdb->base_prefix . "vstrsnln_general`
WHERE `blog_id` = '" . $blog_id . "'
ORDER BY `date_connection` DESC
LIMIT 1"
);
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( "
SELECT count( * )
FROM `" . $wpdb->base_prefix . "vstrsnln_detailing`
WHERE `date_connection` = '" . $date_yesterday . "'
AND `blog_id` = '" . $blog_id . "'
LIMIT 1"
);
if ( 0 != $number_visits_detailing ) {
$type_user = $wpdb->get_row( "
SELECT COUNT( * ) AS 'guest',
( SELECT COUNT( * ) FROM `" . $wpdb->base_prefix . "vstrsnln_detailing`
WHERE `date_connection` = '" . $date_yesterday . "'
AND `user_type` = 'bot'
AND `blog_id` = '" . $blog_id . "'
) AS 'bot',
( SELECT COUNT( * ) FROM `" . $wpdb->base_prefix . "vstrsnln_detailing`
WHERE `date_connection` = '" . $date_yesterday . "'
AND `user_type` = 'user'
AND `blog_id` = '" . $blog_id . "'
) AS 'user'
FROM `" . $wpdb->base_prefix . "vstrsnln_detailing`
WHERE `date_connection` = '" . $date_yesterday . "'
AND `user_type` = 'guest'
AND `blog_id` = '" . $blog_id . "'
LIMIT 1"
);
/* We determine which country had the maximum number of connections */
$country_max_connections = $wpdb->get_var( "
SELECT `country_id`
FROM `" . $wpdb->base_prefix . "vstrsnln_detailing`
WHERE `date_connection` = '" . $date_yesterday . "'
AND `country_id` != '0'
GROUP BY country_id
ORDER BY count( * )
DESC LIMIT 1;"
);
/* We determine which browser had the maximum number of connections */
$browser_max_connections = $wpdb->get_var( "
SELECT `browser`
FROM `" . $wpdb->base_prefix . "vstrsnln_detailing`
WHERE `date_connection` = '" . $date_yesterday . "'
AND `browser` != ''
GROUP BY browser
ORDER BY count( * )
DESC LIMIT 1;"
);
/* 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( "DELETE
FROM `" . $wpdb->base_prefix . "vstrsnln_detailing`
WHERE `date_connection` <= '" . $date_delete . "'
AND `blog_id` = '" . $blog_id . "'"
);
}
}
/* Create an interval for checking user online */
if ( ! function_exists( 'vstrsnln_add_user_interval' ) ) {
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;
}
}
/* List of bots */
if ( ! function_exists( 'vstrsnln_list_bots' ) ) {
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;
}
}
/* Display information about users online */
if ( ! function_exists( 'vstrsnln_info_display' ) ) {
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( "
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` = '" . $vstrsnln_date_today . "'
AND `user_type` = 'bot'
AND `time_off` IS NULL
AND `blog_id` = '" . $vstrsnln_blog_id . "'
) 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` = '" . $vstrsnln_date_today . "'
AND `user_type` = 'user'
AND `time_off` IS NULL
AND `blog_id` = '" . $vstrsnln_blog_id . "'
) 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` = '" . $vstrsnln_date_today . "'
AND `user_type` = 'guest'
AND `time_off` IS NULL
AND `blog_id` = '" . $vstrsnln_blog_id . "'
LIMIT 1"
);
$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;
}
/* 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 $vstrsnln_content;
} else {
return $vstrsnln_content;
}
}
}
/* get general table */
if ( ! function_exists( 'vstrsnln_get_table_general' ) ) {
function vstrsnln_get_table_general( $blog_id ) {
global $wpdb;
return $wpdb->get_row( "
SELECT *
FROM `" . $wpdb->base_prefix . "vstrsnln_general`
WHERE `blog_id` = '" . $blog_id . "'
ORDER BY `number_visits` DESC"
);
}
}
/* add shortcode content */
if ( ! function_exists( 'vstrsnln_shortcode_button_content' ) ) {
function vstrsnln_shortcode_button_content( $content ) { ?>
<div id="vstrsnln" style="display:none;">
<fieldset>
<?php _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 }
}
/* Display information about users online to dashboard */
if ( ! function_exists( 'vstrsnln_dashboard_widget' ) ) {
function vstrsnln_dashboard_widget() {
add_meta_box( 'vstrsnln_dashboard', 'Visitors Online', 'vstrsnln_info_display', 'dashboard', 'side', 'default' );
}
}
/* Creation Widget */
if ( ! class_exists( 'Vstrsnln_Widget' ) ) {
class Vstrsnln_Widget extends WP_Widget {
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' )
) );
}
function widget( $args, $instance ) {
echo $args['before_widget'];
if ( ! empty( $instance['vstrsnln_widget_title'] ) ) {
echo $args['before_title'] . apply_filters( 'widget_title', $instance['vstrsnln_widget_title'], $instance, $this->id_base ) . $args['after_title'];
}
vstrsnln_info_display( true );
echo $args['after_widget'];
}
/* Save widget options */
function update( $new_instance, $old_instance ) {
$instance = $old_instance;
$instance['vstrsnln_widget_title'] = $new_instance['vstrsnln_widget_title'];
return $instance;
}
/* Output admin widget options form */
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 _e( 'Title', 'visitors-online' ); ?></label><br />
<input type="text" <?php echo $this->get_field_id( 'vstrsnln_widget_title' ); ?> name="<?php echo $this->get_field_name( 'vstrsnln_widget_title' ); ?>" value="<?php echo $instance['vstrsnln_widget_title']; ?>" class='widefat' />
</p>
</div>
<?php }
}
}
/* Add widget */
if ( ! function_exists( 'vstrsnln_register_widget' ) ) {
function vstrsnln_register_widget() {
register_widget( 'Vstrsnln_Widget' );
}
}
/* Uninstall plugin, drop tables, delete options. */
if ( ! function_exists( 'vstrsnln_uninstall' ) ) {
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__ ) );
}
}
/* Add "Settings", "FAQ", "Support" Links On The Plugin Page */
if ( ! function_exists( 'vstrsnln_register_plugin_links' ) ) {
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;
}
}
/* Add "Settings" Link On The Plugin Action Page */
if ( ! function_exists( 'vstrsnln_plugin_action_links' ) ) {
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;
}
}
/* add help tab */
if ( ! function_exists( 'vstrsnln_add_tabs' ) ) {
function vstrsnln_add_tabs() {
$screen = get_current_screen();
$args = array(
'id' => 'vstrsnln',
'section' => '201089295'
);
bws_help_tab( $screen, $args );
}
}
/* Сheck whether there are users with an undefined country, if there is something we define */
if ( ! function_exists( 'vstrsnln_check_country' ) ) {
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' ) ) {
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' );