{"slug":"adrotate","name":"AdRotate Banner Manager","description":"Easily manage, and schedule ads on your WordPress site with AdRotate. Support for Google AdSense, Amazon, and custom banners. Start monetizing today!","author":"Arnan","active_installs":20000,"version":"5.17.5","wp_org_url":"https://wordpress.org/plugins/adrotate/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"adrotate","full_table_name":"wp_adrotate","description":"Stores adrotate data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"mediumint(8) unsigned","nullable":false,"primary_key":true},{"name":"title","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"bannercode","type":"longtext","nullable":false,"primary_key":false},{"name":"thetime","type":"int(15)","nullable":false,"primary_key":false},{"name":"updated","type":"int(15)","nullable":false,"primary_key":false},{"name":"author","type":"varchar(60)","nullable":false,"primary_key":false},{"name":"imagetype","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"image","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"tracker","type":"char(1)","nullable":false,"primary_key":false},{"name":"show_everyone","type":"char(1)","nullable":false,"primary_key":false},{"name":"desktop","type":"char(1)","nullable":false,"primary_key":false},{"name":"mobile","type":"char(1)","nullable":false,"primary_key":false},{"name":"tablet","type":"char(1)","nullable":false,"primary_key":false},{"name":"os_ios","type":"char(1)","nullable":false,"primary_key":false},{"name":"os_android","type":"char(1)","nullable":false,"primary_key":false},{"name":"type","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"weight","type":"int(3)","nullable":false,"primary_key":false},{"name":"autodelete","type":"char(1)","nullable":false,"primary_key":false},{"name":"autodisable","type":"char(1)","nullable":false,"primary_key":false},{"name":"budget","type":"double","nullable":false,"primary_key":false},{"name":"crate","type":"double","nullable":false,"primary_key":false},{"name":"irate","type":"double","nullable":false,"primary_key":false},{"name":"state_req","type":"char(1)","nullable":false,"primary_key":false},{"name":"cities","type":"text","nullable":false,"primary_key":false},{"name":"states","type":"text","nullable":false,"primary_key":false},{"name":"countries","type":"text","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_adrotate` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `title` varchar(255) NOT NULL DEFAULT '', `bannercode` longtext NOT NULL, `thetime` int(15) NOT NULL default '0', `updated` int(15) NOT NULL, `author` varchar(60) NOT NULL default '', `imagetype` varchar(10) NOT NULL, `image` varchar(255) NOT NULL, `tracker` char(1) NOT NULL default 'N', `show_everyone` char(1) NOT NULL default 'Y', `desktop` char(1) NOT NULL default 'Y', `mobile` char(1) NOT NULL default 'Y', `tablet` char(1) NOT NULL default 'Y', `os_ios` char(1) NOT NULL default 'Y', `os_android` char(1) NOT NULL default 'Y', `type` varchar(10) NOT NULL default '0', `weight` int(3) NOT NULL default '6', `autodelete` char(1) NOT NULL default 'N', `autodisable` char(1) NOT NULL default 'N', `budget` double NOT NULL default '0', `crate` double NOT NULL default '0', `irate` double NOT NULL default '0', `state_req` char(1) NOT NULL default 'N', `cities` text NOT NULL, `states` text NOT NULL, `countries` text NOT NULL, PRIMARY KEY (`id`) ) \".$charset_collate.$engine.\";\");"},{"table_name":"adrotate_groups","full_table_name":"wp_adrotate_groups","description":"Stores adrotate groups data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"mediumint(8) unsigned","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"modus","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"fallback","type":"varchar(5)","nullable":false,"primary_key":false},{"name":"cat","type":"longtext","nullable":false,"primary_key":false},{"name":"cat_loc","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"cat_par","type":"tinyint(2)","nullable":false,"primary_key":false},{"name":"page","type":"longtext","nullable":false,"primary_key":false},{"name":"page_loc","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"page_par","type":"tinyint(2)","nullable":false,"primary_key":false},{"name":"woo_cat","type":"longtext","nullable":false,"primary_key":false},{"name":"woo_loc","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"bbpress","type":"longtext","nullable":false,"primary_key":false},{"name":"bbpress_loc","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"mobile","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"geo","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"wrapper_before","type":"longtext","nullable":false,"primary_key":false},{"name":"wrapper_after","type":"longtext","nullable":false,"primary_key":false},{"name":"align","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"gridrows","type":"int(3)","nullable":false,"primary_key":false},{"name":"gridcolumns","type":"int(3)","nullable":false,"primary_key":false},{"name":"admargin","type":"int(2)","nullable":false,"primary_key":false},{"name":"admargin_bottom","type":"int(2)","nullable":false,"primary_key":false},{"name":"admargin_left","type":"int(2)","nullable":false,"primary_key":false},{"name":"admargin_right","type":"int(2)","nullable":false,"primary_key":false},{"name":"adwidth","type":"varchar(6)","nullable":false,"primary_key":false},{"name":"adheight","type":"varchar(6)","nullable":false,"primary_key":false},{"name":"adspeed","type":"int(5)","nullable":false,"primary_key":false},{"name":"repeat_impressions","type":"char(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_adrotate_groups` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `modus` tinyint(1) NOT NULL default '0', `fallback` varchar(5) NOT NULL default '0', `cat` longtext NOT NULL, `cat_loc` tinyint(1) NOT NULL default '0', `cat_par` tinyint(2) NOT NULL default '0', `page` longtext NOT NULL, `page_loc` tinyint(1) NOT NULL default '0', `page_par` tinyint(2) NOT NULL default '0', `woo_cat` longtext NOT NULL, `woo_loc` tinyint(1) NOT NULL default '0', `bbpress` longtext NOT NULL, `bbpress_loc` tinyint(1) NOT NULL default '0', `mobile` tinyint(1) NOT NULL default '0', `geo` tinyint(1) NOT NULL default '0', `wrapper_before` longtext NOT NULL, `wrapper_after` longtext NOT NULL, `align` tinyint(1) NOT NULL default '0', `gridrows` int(3) NOT NULL DEFAULT '2', `gridcolumns` int(3) NOT NULL DEFAULT '2', `admargin` int(2) NOT NULL DEFAULT '0', `admargin_bottom` int(2) NOT NULL DEFAULT '0', `admargin_left` int(2) NOT NULL DEFAULT '0', `admargin_right` int(2) NOT NULL DEFAULT '0', `adwidth` varchar(6) NOT NULL DEFAULT '125', `adheight` varchar(6) NOT NULL DEFAULT '125', `adspeed` int(5) NOT NULL DEFAULT '6000', `repeat_impressions` char(1) NOT NULL DEFAULT 'Y', PRIMARY KEY (`id`) ) \".$charset_collate.$engine.\";\");"},{"table_name":"adrotate_linkmeta","full_table_name":"wp_adrotate_linkmeta","description":"Stores adrotate linkmeta data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"mediumint(8) unsigned","nullable":false,"primary_key":true},{"name":"ad","type":"int(5) unsigned","nullable":false,"primary_key":false},{"name":"group","type":"int(5) unsigned","nullable":false,"primary_key":false},{"name":"user","type":"int(5) unsigned","nullable":false,"primary_key":false},{"name":"schedule","type":"int(5) unsigned","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_adrotate_linkmeta` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `ad` int(5) unsigned NOT NULL default '0', `group` int(5) unsigned NOT NULL default '0', `user` int(5) unsigned NOT NULL default '0', `schedule` int(5) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) \".$charset_collate.$engine.\";\");"},{"table_name":"adrotate_schedule","full_table_name":"wp_adrotate_schedule","description":"Stores adrotate schedule data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(8) unsigned","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"starttime","type":"int(15) unsigned","nullable":false,"primary_key":false},{"name":"stoptime","type":"int(15) unsigned","nullable":false,"primary_key":false},{"name":"maxclicks","type":"int(15) unsigned","nullable":false,"primary_key":false},{"name":"maximpressions","type":"int(15) unsigned","nullable":false,"primary_key":false},{"name":"spread","type":"char(1)","nullable":false,"primary_key":false},{"name":"spread_all","type":"char(1)","nullable":false,"primary_key":false},{"name":"daystarttime","type":"char(4)","nullable":false,"primary_key":false},{"name":"daystoptime","type":"char(4)","nullable":false,"primary_key":false},{"name":"day_mon","type":"char(1)","nullable":false,"primary_key":false},{"name":"day_tue","type":"char(1)","nullable":false,"primary_key":false},{"name":"day_wed","type":"char(1)","nullable":false,"primary_key":false},{"name":"day_thu","type":"char(1)","nullable":false,"primary_key":false},{"name":"day_fri","type":"char(1)","nullable":false,"primary_key":false},{"name":"day_sat","type":"char(1)","nullable":false,"primary_key":false},{"name":"day_sun","type":"char(1)","nullable":false,"primary_key":false},{"name":"autodelete","type":"char(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_adrotate_schedule` ( `id` int(8) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `starttime` int(15) unsigned NOT NULL default '0', `stoptime` int(15) unsigned NOT NULL default '0', `maxclicks` int(15) unsigned NOT NULL default '0', `maximpressions` int(15) unsigned NOT NULL default '0', `spread` char(1) NOT NULL default 'N', `spread_all` char(1) NOT NULL default 'N', `daystarttime` char(4) NOT NULL default '0000', `daystoptime` char(4) NOT NULL default '0000', `day_mon` char(1) NOT NULL default 'Y', `day_tue` char(1) NOT NULL default 'Y', `day_wed` char(1) NOT NULL default 'Y', `day_thu` char(1) NOT NULL default 'Y', `day_fri` char(1) NOT NULL default 'Y', `day_sat` char(1) NOT NULL default 'Y', `day_sun` char(1) NOT NULL default 'Y', `autodelete` char(1) NOT NULL default 'N', PRIMARY KEY (`id`), KEY `starttime` (`starttime`) ) \".$charset_collate.$engine.\";\");"},{"table_name":"adrotate_stats","full_table_name":"wp_adrotate_stats","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(9) unsigned","nullable":false,"primary_key":true},{"name":"ad","type":"int(5) unsigned","nullable":false,"primary_key":false},{"name":"group","type":"int(5) unsigned","nullable":false,"primary_key":false},{"name":"thetime","type":"int(15) unsigned","nullable":false,"primary_key":false},{"name":"clicks","type":"int(15) unsigned","nullable":false,"primary_key":false},{"name":"impressions","type":"int(15) unsigned","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_adrotate_stats` ( `id` bigint(9) unsigned NOT NULL auto_increment, `ad` int(5) unsigned NOT NULL default '0', `group` int(5) unsigned NOT NULL default '0', `thetime` int(15) unsigned NOT NULL default '0', `clicks` int(15) unsigned NOT NULL default '0', `impressions` int(15) unsigned NOT NULL default '0', PRIMARY KEY (`id`), INDEX `ad_thetime` (`ad`, `thetime`), INDEX `thetime` (`thetime`) ) \".$charset_collate.$engine.\";\");"},{"table_name":"adrotate_stats_archive","full_table_name":"wp_adrotate_stats_archive","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(9) unsigned","nullable":false,"primary_key":true},{"name":"ad","type":"int(5) unsigned","nullable":false,"primary_key":false},{"name":"group","type":"int(5) unsigned","nullable":false,"primary_key":false},{"name":"thetime","type":"int(15) unsigned","nullable":false,"primary_key":false},{"name":"clicks","type":"int(15) unsigned","nullable":false,"primary_key":false},{"name":"impressions","type":"int(15) unsigned","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_adrotate_stats_archive` ( `id` bigint(9) unsigned NOT NULL auto_increment, `ad` int(5) unsigned NOT NULL default '0', `group` int(5) unsigned NOT NULL default '0', `thetime` int(15) unsigned NOT NULL default '0', `clicks` int(15) unsigned NOT NULL default '0', `impressions` int(15) unsigned NOT NULL default '0', PRIMARY KEY (`id`), INDEX `ad_thetime` (`ad`, `thetime`), INDEX `thetime` (`thetime`) ) \".$charset_collate.$engine.\";\");"},{"table_name":"adrotate_tracker","full_table_name":"wp_adrotate_tracker","description":"Stores adrotate tracker data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(9) unsigned","nullable":false,"primary_key":true},{"name":"ipaddress","type":"varchar(15)","nullable":false,"primary_key":false},{"name":"timer","type":"int(15) unsigned","nullable":false,"primary_key":false},{"name":"bannerid","type":"int(15) unsigned","nullable":false,"primary_key":false},{"name":"stat","type":"char(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_adrotate_tracker` ( `id` bigint(9) unsigned NOT NULL auto_increment, `ipaddress` varchar(15) NOT NULL default '0', `timer` int(15) unsigned NOT NULL default '0', `bannerid` int(15) unsigned NOT NULL default '0', `stat` char(1) NOT NULL default 'c', PRIMARY KEY (`id`), KEY `ipaddress` (`ipaddress`), KEY `timer` (`timer`) ) \".$charset_collate.$engine.\";\");"}],"table_count":7}