{"slug":"visitors-traffic-real-time-statistics","name":"Visitor Traffic Real Time Statistics","description":"This plugin will help you to track your visitors, browsers, operating systems, visits and much more in one dashboard page.","author":"wp-buy","active_installs":30000,"version":"8.10","wp_org_url":"https://wordpress.org/plugins/visitors-traffic-real-time-statistics/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"ahc_browsers","full_table_name":"wp_ahc_browsers","description":"Stores ahc browsers data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"bsr_id","type":"INT(3) UNSIGNED","nullable":false,"primary_key":false},{"name":"bsr_name","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"bsr_icon","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"bsr_visits","type":"INT(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `ahc_browsers` ( `bsr_id` INT(3) UNSIGNED NOT NULL, PRIMARY KEY(`bsr_id`), `bsr_name` VARCHAR(100) NOT NULL, `bsr_icon` VARCHAR(50), `bsr_visits` INT(11) NOT NULL DEFAULT 0 ) DEFAULT CHARSET"},{"table_name":"ahc_countries","full_table_name":"wp_ahc_countries","description":"Stores ahc countries data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"ctr_id","type":"INT(5) UNSIGNED","nullable":false,"primary_key":true},{"name":"ctr_name","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"ctr_internet_code","type":"VARCHAR(5)","nullable":false,"primary_key":false},{"name":"ctr_latitude","type":"VARCHAR(30)","nullable":true,"primary_key":false},{"name":"ctr_longitude","type":"VARCHAR(30)","nullable":true,"primary_key":false},{"name":"ctr_visitors","type":"INT(11)","nullable":false,"primary_key":false},{"name":"ctr_visits","type":"INT(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `ahc_countries` ( `ctr_id` INT(5) UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY(`ctr_id`), `ctr_name` VARCHAR(100) NOT NULL, `ctr_internet_code` VARCHAR(5) NOT NULL, `ctr_latitude` VARCHAR(30) NULL, `ctr_longitude` VARCHAR(30) NULL, `ctr_visitors` INT(11) NOT NULL DEFAULT 0, `ctr_visits` INT(11) NOT NULL DEFAULT 0 ) DEFAULT CHARSET"},{"table_name":"ahc_daily_visitors_stats","full_table_name":"wp_ahc_daily_visitors_stats","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INT(11) UNSIGNED","nullable":false,"primary_key":true},{"name":"vst_date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"vst_visitors","type":"INT(11) UNSIGNED","nullable":true,"primary_key":false},{"name":"vst_visits","type":"INT(11) UNSIGNED","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `ahc_daily_visitors_stats` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY (`id`), `vst_date` DATETIME NOT NULL, `vst_visitors` INT(11) UNSIGNED NULL DEFAULT 0, `vst_visits` INT(11) UNSIGNED NULL DEFAULT 0 ) DEFAULT CHARSET"},{"table_name":"ahc_hits","full_table_name":"wp_ahc_hits","description":"Stores ahc hits data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"hit_id","type":"INT(11) UNSIGNED","nullable":false,"primary_key":true},{"name":"hit_ip_address","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"hit_user_agent","type":"VARCHAR(200)","nullable":false,"primary_key":false},{"name":"hit_request_uri","type":"VARCHAR(200)","nullable":true,"primary_key":false},{"name":"hit_page_id","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"hit_page_title","type":"VARCHAR(200)","nullable":true,"primary_key":false},{"name":"ctr_id","type":"INT(3) UNSIGNED","nullable":true,"primary_key":false},{"name":"hit_referer","type":"VARCHAR(300)","nullable":true,"primary_key":false},{"name":"hit_referer_site","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"srh_id","type":"INT(3) UNSIGNED","nullable":true,"primary_key":false},{"name":"hit_search_words","type":"VARCHAR(200)","nullable":true,"primary_key":false},{"name":"bsr_id","type":"INT(3) UNSIGNED","nullable":false,"primary_key":false},{"name":"hit_date","type":"DATE","nullable":false,"primary_key":false},{"name":"hit_time","type":"TIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `ahc_hits` ( `hit_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY(`hit_id`), `hit_ip_address` VARCHAR(50) NOT NULL, `hit_user_agent` VARCHAR(200) NOT NULL, `hit_request_uri` VARCHAR(200) NULL, `hit_page_id` VARCHAR(30) NOT NULL, `hit_page_title` VARCHAR(200) NULL, `ctr_id` INT(3) UNSIGNED NULL, `hit_referer` VARCHAR(300) NULL, `hit_referer_site` VARCHAR(100) NULL, `srh_id` INT(3) UNSIGNED NULL, `hit_search_words` VARCHAR(200) NULL, `bsr_id` INT(3) UNSIGNED NOT NULL, `hit_date` DATE NOT NULL, `hit_time` TIME NOT NULL ) DEFAULT CHARSET"},{"table_name":"ahc_ip_geo","full_table_name":"wp_ahc_ip_geo","description":"Stores ahc ip geo data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"ahc_keywords","full_table_name":"wp_ahc_keywords","description":"Stores ahc keywords data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"kwd_id","type":"INT(11) UNSIGNED","nullable":false,"primary_key":true},{"name":"kwd_ip_address","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"kwd_keywords","type":"VARCHAR(200)","nullable":false,"primary_key":false},{"name":"kwd_referer","type":"VARCHAR(300)","nullable":false,"primary_key":false},{"name":"srh_id","type":"INT(3) UNSIGNED","nullable":false,"primary_key":false},{"name":"ctr_id","type":"INT(5) UNSIGNED","nullable":true,"primary_key":false},{"name":"bsr_id","type":"INT(3) UNSIGNED","nullable":false,"primary_key":false},{"name":"kwd_date","type":"DATE","nullable":false,"primary_key":false},{"name":"kwd_time","type":"TIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `ahc_keywords` ( `kwd_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY (`kwd_id`), `kwd_ip_address` VARCHAR(50) NOT NULL, `kwd_keywords` VARCHAR(200) NOT NULL, `kwd_referer` VARCHAR(300) NOT NULL, `srh_id` INT(3) UNSIGNED NOT NULL, `ctr_id` INT(5) UNSIGNED NULL, `bsr_id` INT(3) UNSIGNED NOT NULL, `kwd_date` DATE NOT NULL, `kwd_time` TIME NOT NULL ) DEFAULT CHARSET"},{"table_name":"ahc_online_users","full_table_name":"wp_ahc_online_users","description":"Stores ahc online users data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INT(11) UNSIGNED","nullable":false,"primary_key":true},{"name":"hit_ip_address","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"hit_page_id","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"date","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `ahc_online_users` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY(`id`), `hit_ip_address` VARCHAR(50) NOT NULL, `hit_page_id` VARCHAR(30) NOT NULL, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) DEFAULT CHARSET"},{"table_name":"ahc_recent_visitors","full_table_name":"wp_ahc_recent_visitors","description":"Stores ahc recent visitors data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"vtr_id","type":"INT(11) UNSIGNED","nullable":false,"primary_key":true},{"name":"vtr_ip_address","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"vtr_referer","type":"VARCHAR(300)","nullable":true,"primary_key":false},{"name":"srh_id","type":"INT(3) UNSIGNED","nullable":true,"primary_key":false},{"name":"bsr_id","type":"INT(3) UNSIGNED","nullable":false,"primary_key":false},{"name":"ctr_id","type":"INT(5) UNSIGNED","nullable":true,"primary_key":false},{"name":"vtr_date","type":"DATE","nullable":false,"primary_key":false},{"name":"vtr_time","type":"TIME","nullable":false,"primary_key":false},{"name":"ahc_city","type":"varchar(230)","nullable":true,"primary_key":false},{"name":"ahc_region","type":"varchar(230)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `ahc_recent_visitors` ( `vtr_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY (`vtr_id`), `vtr_ip_address` VARCHAR(50) NOT NULL, `vtr_referer` VARCHAR(300) NULL, `srh_id` INT(3) UNSIGNED NULL, `bsr_id` INT(3) UNSIGNED NOT NULL, `ctr_id` INT(5) UNSIGNED NULL, `vtr_date` DATE NOT NULL, `vtr_time` TIME NOT NULL, `ahc_city` varchar(230) NULL, `ahc_region` varchar(230) NULL ) DEFAULT CHARSET"},{"table_name":"ahc_refering_sites","full_table_name":"wp_ahc_refering_sites","description":"Stores ahc refering sites data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"rfr_id","type":"INT(11) UNSIGNED","nullable":false,"primary_key":true},{"name":"rfr_site_name","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"rfr_visits","type":"INT(11) UNSIGNED","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `ahc_refering_sites` ( `rfr_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY (`rfr_id`), `rfr_site_name` VARCHAR(100) NOT NULL, `rfr_visits` INT(11) UNSIGNED NULL DEFAULT 0 ) DEFAULT CHARSET"},{"table_name":"ahc_search_engine_crawlers","full_table_name":"wp_ahc_search_engine_crawlers","description":"Stores ahc search engine crawlers data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"bot_name","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"srh_id","type":"INT(3) UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `ahc_search_engine_crawlers` ( `bot_name` VARCHAR(50) NOT NULL, `srh_id` INT(3) UNSIGNED NOT NULL ) DEFAULT CHARSET"},{"table_name":"ahc_search_engines","full_table_name":"wp_ahc_search_engines","description":"Stores ahc search engines data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"srh_id","type":"INT(3) UNSIGNED","nullable":false,"primary_key":true},{"name":"srh_name","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"srh_query_parameter","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"srh_icon","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"srh_identifier","type":"VARCHAR(50)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `ahc_search_engines` ( `srh_id` INT(3) UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY(`srh_id`), `srh_name` VARCHAR(100) NOT NULL, `srh_query_parameter` VARCHAR(10) NOT NULL, `srh_icon` VARCHAR(50), `srh_identifier` VARCHAR(50) ) DEFAULT CHARSET"},{"table_name":"ahc_searching_visits","full_table_name":"wp_ahc_searching_visits","description":"Stores ahc searching visits data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"vtsh_id","type":"INT(11) UNSIGNED","nullable":false,"primary_key":true},{"name":"srh_id","type":"INT(3) UNSIGNED","nullable":false,"primary_key":false},{"name":"vtsh_date","type":"DATE","nullable":false,"primary_key":false},{"name":"vtsh_visits","type":"INT(11) UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `ahc_searching_visits` ( `vtsh_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY (`vtsh_id`), `srh_id` INT(3) UNSIGNED NOT NULL, `vtsh_date` DATE NOT NULL, `vtsh_visits` INT(11) UNSIGNED NOT NULL DEFAULT 0 ) DEFAULT CHARSET"},{"table_name":"ahc_settings","full_table_name":"wp_ahc_settings","description":"Stores ahc settings data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"set_id","type":"int(10) unsigned","nullable":false,"primary_key":true},{"name":"set_hits_days","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"set_ajax_check","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"set_ips","type":"text","nullable":true,"primary_key":false},{"name":"set_google_map","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"site_id","type":"INT(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `ahc_settings` ( `set_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `set_hits_days` int(10) unsigned NOT NULL DEFAULT '14', `set_ajax_check` int(10) unsigned NOT NULL DEFAULT '10', `set_ips` text DEFAULT NULL, `set_google_map` varchar(100) NOT NULL DEFAULT 'today_visitors', `site_id` INT(11) NOT NULL DEFAULT '1', PRIMARY KEY (`set_id`) ) DEFAULT CHARSET"},{"table_name":"ahc_title_traffic","full_table_name":"wp_ahc_title_traffic","description":"Stores ahc title traffic data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"til_id","type":"INT(11) UNSIGNED","nullable":false,"primary_key":true},{"name":"til_page_id","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"til_page_title","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"til_hits","type":"INT(11) UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `ahc_title_traffic` ( `til_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY (`til_id`), `til_page_id` VARCHAR(30) NOT NULL, `til_page_title` VARCHAR(100), `til_hits` INT(11) UNSIGNED NOT NULL ) DEFAULT CHARSET"},{"table_name":"ahc_visitors","full_table_name":"wp_ahc_visitors","description":"Stores ahc visitors data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"vst_id","type":"INT(11) UNSIGNED","nullable":false,"primary_key":true},{"name":"vst_date","type":"DATE","nullable":false,"primary_key":false},{"name":"vst_visitors","type":"INT(11) UNSIGNED","nullable":true,"primary_key":false},{"name":"vst_visits","type":"INT(11) UNSIGNED","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `ahc_visitors` ( `vst_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY (`vst_id`), `vst_date` DATE NOT NULL, `vst_visitors` INT(11) UNSIGNED NULL DEFAULT 0, `vst_visits` INT(11) UNSIGNED NULL DEFAULT 0 ) DEFAULT CHARSET"},{"table_name":"ahc_visits_time","full_table_name":"wp_ahc_visits_time","description":"Stores ahc visits time data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"vtm_id","type":"INT(11) UNSIGNED","nullable":false,"primary_key":true},{"name":"vtm_time_from","type":"TIME","nullable":false,"primary_key":false},{"name":"vtm_time_to","type":"TIME","nullable":false,"primary_key":false},{"name":"vtm_visitors","type":"INT(11) UNSIGNED","nullable":false,"primary_key":false},{"name":"vtm_visits","type":"INT(11) UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `ahc_visits_time` ( `vtm_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY (`vtm_id`), `vtm_time_from` TIME NOT NULL, `vtm_time_to` TIME NOT NULL, `vtm_visitors` INT(11) UNSIGNED NOT NULL DEFAULT 0, `vtm_visits` INT(11) UNSIGNED NOT NULL DEFAULT 0 ) DEFAULT CHARSET"}],"table_count":16}