<?php
class InstallerWpf {
public static $update_to_version_method = '';
private static $_firstTimeActivated = false;
public static function init( $isUpdate = false ) {
global $wpdb;
$wpPrefix = $wpdb->prefix; /* add to 0.0.3 Versiom */
require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
$current_version = get_option($wpPrefix . WPF_DB_PREF . 'db_version', 0);
if (!$current_version) {
self::$_firstTimeActivated = true;
}
/**
* Table modules
*/
if (!DbWpf::exist('@__modules')) {
dbDelta(DbWpf::prepareQuery("CREATE TABLE IF NOT EXISTS `@__modules` (
`id` smallint(3) NOT NULL AUTO_INCREMENT,
`code` varchar(32) NOT NULL,
`active` tinyint(1) NOT NULL DEFAULT '0',
`type_id` tinyint(1) NOT NULL DEFAULT '0',
`label` varchar(64) DEFAULT NULL,
`ex_plug_dir` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE INDEX `code` (`code`)
) DEFAULT CHARSET=utf8;"));
DbWpf::query("INSERT INTO `@__modules` (id, code, active, type_id, label) VALUES
(NULL, 'adminmenu',1,1,'Admin Menu'),
(NULL, 'options',1,1,'Options'),
(NULL, 'user',1,1,'Users'),
(NULL, 'pages',1,1,'Pages'),
(NULL, 'templates',1,1,'templates'),
(NULL, 'promo',1,1,'promo'),
(NULL, 'admin_nav',1,1,'admin_nav'),
(NULL, 'woofilters',1,1,'woofilters'),
(NULL, 'woofilters_widget',1,1,'woofilters_widget'),
(NULL, 'mail',1,1,'mail'),
(NULL, 'meta',1,1,'meta'),
(NULL, 'overview',1,1,'overview');");
}
/**
* Table modules_type
*/
if (!DbWpf::exist('@__modules_type')) {
dbDelta(DbWpf::prepareQuery('CREATE TABLE IF NOT EXISTS `@__modules_type` (
`id` smallint(3) NOT NULL AUTO_INCREMENT,
`label` varchar(32) NOT NULL,
PRIMARY KEY (`id`)
) AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;'));
DbWpf::query("INSERT INTO `@__modules_type` VALUES
(1,'system'),
(6,'addons');");
}
/**
* Table filters
*/
if (!DbWpf::exist('@__filters')) {
dbDelta(DbWpf::prepareQuery('CREATE TABLE IF NOT EXISTS `@__filters` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`title` VARCHAR(128) NULL DEFAULT NULL,
`setting_data` MEDIUMTEXT NOT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;'));
}
if (version_compare($current_version, '1.3.6') != 1) {
DbWpf::query('ALTER TABLE `@__filters` MODIFY setting_data MEDIUMTEXT;');
}
/**
* Plugin usage statistwpf
*/
if (!DbWpf::exist('@__usage_stat')) {
dbDelta(DbWpf::prepareQuery("CREATE TABLE `@__usage_stat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`code` varchar(64) NOT NULL,
`visits` int(11) NOT NULL DEFAULT '0',
`spent_time` int(11) NOT NULL DEFAULT '0',
`modify_timestamp` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
UNIQUE INDEX `code` (`code`),
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8"));
DbWpf::query("INSERT INTO `@__usage_stat` (code, visits) VALUES ('installed', 1)");
}
/**
* Table meta_keys
*/
if (!DbWpf::exist('@__meta_keys')) {
dbDelta(DbWpf::prepareQuery('CREATE TABLE IF NOT EXISTS `@__meta_keys` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`meta_mode` smallint(3) NOT NULL,
`meta_key` varchar(255) NOT NULL,
`taxonomy` varchar(255) NOT NULL,
`meta_like` smallint(3) NOT NULL,
`parent` INT(11) NOT NULL,
`meta_type` smallint(3) NOT NULL,
`status` smallint(3) NOT NULL,
`added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated` TIMESTAMP,
`locked` TIMESTAMP,
`calculated` TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE INDEX `meta_key` (`meta_key`)
) DEFAULT CHARSET=utf8;'));
DbWpf::query("INSERT INTO `@__meta_keys` VALUES
(NULL,0,'_wpf_product_type','',0,0,0,0,CURRENT_TIMESTAMP,NULL,NULL,NULL),
(NULL,0,'_product_attributes','',0,0,8,0,CURRENT_TIMESTAMP,NULL,NULL,NULL),
(NULL,0,'attribute_%','',1,0,0,0,CURRENT_TIMESTAMP,NULL,NULL,NULL),
(NULL,0,'_wc_average_rating','',0,0,3,0,CURRENT_TIMESTAMP,NULL,NULL,NULL),
(NULL,0,'_stock_status','',0,0,0,0,CURRENT_TIMESTAMP,NULL,NULL,NULL),
(NULL,0,'_price','',0,0,1,0,CURRENT_TIMESTAMP,NULL,NULL,NULL),
(NULL,0,'_sale_price','',0,0,1,0,CURRENT_TIMESTAMP,NULL,NULL,NULL);");
}
/**
* Table meta_data
*/
if (!DbWpf::exist('@__meta_data')) {
dbDelta(DbWpf::prepareQuery('CREATE TABLE IF NOT EXISTS `@__meta_data` (
`id` bigint NOT NULL AUTO_INCREMENT,
`product_id` bigint NOT NULL,
`is_var` smallint(3) NOT NULL DEFAULT 0,
`key_id` INT(11) NOT NULL,
`val_int` bigint,
`val_dec` decimal(19,4),
`val_id` bigint,
`updated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;'));
}
/**
* Table meta_values
*/
if (!DbWpf::exist('@__meta_values')) {
dbDelta(DbWpf::prepareQuery('CREATE TABLE IF NOT EXISTS `@__meta_values` (
`id` bigint NOT NULL AUTO_INCREMENT,
`key_id` INT(11) NOT NULL,
`key2` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`key3` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`key4` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`value` varchar(150) CHARACTER SET utf8 COLLATE utf8_bin,
`product_cnt` INT(11) NOT NULL DEFAULT 0,
`variation_cnt` INT(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;'));
}
/**
* Table meta_values_bk
*/
if (!DbWpf::exist('@__meta_values_bk')) {
dbDelta(DbWpf::prepareQuery('CREATE TABLE IF NOT EXISTS `@__meta_values_bk` (
`id` bigint NOT NULL,
`key_id` INT(11) NOT NULL,
`key2` varchar(32) NOT NULL,
`key3` varchar(32) NOT NULL,
`key4` varchar(32) NOT NULL,
`value` varchar(150),
PRIMARY KEY (`id`),
INDEX `key_id` (`key_id`)
) DEFAULT CHARSET=utf8;'));
}
InstallerDbUpdaterWpf::runUpdate($current_version);
if ($current_version && !self::$_firstTimeActivated) {
self::setUsed();
// For users that just updated our plugin - don't need tp show step-by-step tutorial
update_user_meta(get_current_user_id(), WPF_CODE . '-tour-hst', array('closed' => 1));
}
update_option($wpPrefix . WPF_DB_PREF . 'db_version', WPF_VERSION);
add_option($wpPrefix . WPF_DB_PREF . 'db_installed', 1);
if ( !wp_next_scheduled( 'wpf_calc_meta_indexing' ) ) {
wp_schedule_single_event( time() + 5, 'wpf_calc_meta_indexing' );
}
}
public static function setUsed() {
update_option(WPF_DB_PREF . 'plug_was_used', 1);
}
public static function isUsed() {
return (int) get_option(WPF_DB_PREF . 'plug_was_used');
}
public static function delete() {
self::_checkSendStat('delete');
global $wpdb;
$wpPrefix = $wpdb->prefix;
$wpdb->query('DROP TABLE IF EXISTS `' . $wpdb->prefix . esc_sql(WPF_DB_PREF) . 'modules`');
$wpdb->query('DROP TABLE IF EXISTS `' . $wpdb->prefix . esc_sql(WPF_DB_PREF) . 'modules_type`');
$wpdb->query('DROP TABLE IF EXISTS `' . $wpdb->prefix . esc_sql(WPF_DB_PREF) . 'usage_stat`');
$wpdb->query('DROP TABLE IF EXISTS `' . $wpdb->prefix . esc_sql(WPF_DB_PREF) . 'meta_data`');
delete_option($wpPrefix . WPF_DB_PREF . 'db_version');
delete_option($wpPrefix . WPF_DB_PREF . 'db_installed');
}
public static function deactivate() {
self::_checkSendStat('deactivate');
}
private static function _checkSendStat( $statCode ) {
if (class_exists('FrameWpf') && FrameWpf::_()->getModule('promo') && FrameWpf::_()->getModule('options')) {
FrameWpf::_()->getModule('promo')->getModel()->saveUsageStat( $statCode );
FrameWpf::_()->getModule('promo')->getModel()->checkAndSend( true );
}
}
public static function update() {
global $wpdb;
$wpPrefix = $wpdb->prefix; /* add to 0.0.3 Versiom */
$currentVersion = get_option($wpPrefix . WPF_DB_PREF . 'db_version', 0);
if (!$currentVersion || version_compare(WPF_VERSION, $currentVersion, '>')) {
self::init( true );
update_option($wpPrefix . WPF_DB_PREF . 'db_version', WPF_VERSION);
}
}
}