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 = '
' . wpautop( $vstrsnln_content ) . '
';
$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 ) {
?>
'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 );
?>
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[] = '
' . __( 'Settings', 'visitors-online' ) . '';
}
$links[] = '
' . __( 'FAQ', 'visitors-online' ) . '';
$links[] = '
' . __( 'Support', 'visitors-online' ) . '';
}
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 = '
' . __( 'Settings', 'visitors-online' ) . '';
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' );