122 lines
4.6 KiB
PHP
122 lines
4.6 KiB
PHP
<?php
|
|
/**
|
|
* NOTICE OF LICENSE
|
|
*
|
|
* This product is licensed for one customer to use on one installation (test stores and multishop included).
|
|
* Site developer has the right to modify this module to suit their needs, but can not redistribute the module in
|
|
* whole or in part. Any other use of this module constitutes a violation of the user agreement.
|
|
*
|
|
* DISCLAIMER
|
|
*
|
|
* NO WARRANTIES OF DATA SAFETY OR MODULE SECURITY
|
|
* ARE EXPRESSED OR IMPLIED. USE THIS MODULE IN ACCORDANCE
|
|
* WITH YOUR MERCHANT AGREEMENT, KNOWING THAT VIOLATIONS OF
|
|
* PCI COMPLIANCY OR A DATA BREACH CAN COST THOUSANDS OF DOLLARS
|
|
* IN FINES AND DAMAGE A STORES REPUTATION. USE AT YOUR OWN RISK.
|
|
*
|
|
* @author idnovate.com <info@idnovate.com>
|
|
* @copyright 2022 idnovate.com
|
|
* @license See above
|
|
*/
|
|
|
|
$query = array();
|
|
|
|
$query[] = "
|
|
CREATE TABLE IF NOT EXISTS `"._DB_PREFIX_."advancedpopup` (
|
|
`id_advancedpopup` int unsigned NOT NULL auto_increment,
|
|
`id_shop` int unsigned NOT NULL DEFAULT '0',
|
|
`name` VARCHAR(150) NOT NULL,
|
|
`date_init` DATETIME NULL DEFAULT NULL,
|
|
`date_end` DATETIME NULL DEFAULT NULL,
|
|
`schedule` TEXT NULL,
|
|
`secs_to_display` TEXT NULL,
|
|
`secs_to_display_cart` TEXT NULL,
|
|
`secs_to_close` TEXT NULL,
|
|
`dont_display_again` tinyint(1) NOT NULL,
|
|
`image_link_target` VARCHAR(32) NOT NULL,
|
|
`priority` int NULL DEFAULT '0',
|
|
`locked` tinyint(1) NOT NULL,
|
|
`show_customer_newsletter` tinyint(1) NULL DEFAULT '0',
|
|
`show_customer_not_newsletter` tinyint(1) NULL DEFAULT '0',
|
|
`show_on_view_page_nbr` int NULL DEFAULT '0',
|
|
`show_every_nbr_hours` TEXT NULL,
|
|
`maximum_per_user` int NULL DEFAULT '0',
|
|
`session` tinyint(1) NULL DEFAULT '0',
|
|
`nb_products` TEXT NULL,
|
|
`nb_products_comparator` tinyint(1) NULL DEFAULT '0',
|
|
`back_opacity_value` decimal(10,2) NULL DEFAULT '0.00',
|
|
`controller_exceptions` TEXT NULL,
|
|
`groups` TEXT NULL,
|
|
`genders` TEXT NULL,
|
|
`customers` TEXT NULL,
|
|
`products` TEXT NULL,
|
|
`countries` TEXT NULL,
|
|
`zones` TEXT NULL,
|
|
`categories` TEXT NULL,
|
|
`categories_selected` TEXT NULL,
|
|
`manufacturers` TEXT NULL,
|
|
`suppliers` TEXT NULL,
|
|
`cms` TEXT NULL,
|
|
`languages` TEXT NULL,
|
|
`attributes` TEXT NULL,
|
|
`features` TEXT NULL,
|
|
`active` tinyint(1) NULL DEFAULT '0',
|
|
`display_on_load` tinyint(1) NOT NULL,
|
|
`display_after_cart` tinyint(1) NOT NULL,
|
|
`display_on_exit` tinyint(1) NOT NULL,
|
|
`display_on_click` tinyint(1) NOT NULL,
|
|
`display_on_click_selector` VARCHAR(150) NULL,
|
|
`close_on_background` tinyint(1) NOT NULL,
|
|
`blur_background` tinyint(1) NOT NULL,
|
|
`color_background` varchar(32) NULL,
|
|
`open_effect` VARCHAR(32) NOT NULL,
|
|
`position` INT(11) NOT NULL,
|
|
`cart_amount` tinyint(1) NOT NULL,
|
|
`cart_amount_from` decimal(20,2),
|
|
`cart_amount_to` decimal(20,2),
|
|
`display_mobile` tinyint(1) NOT NULL,
|
|
`display_tablet` tinyint(1) NOT NULL,
|
|
`display_desktop` tinyint(1) NOT NULL,
|
|
`display_ip_string` TEXT NULL,
|
|
`product_stock` tinyint(1) NOT NULL,
|
|
`product_stock_from` INT(10) NULL,
|
|
`product_stock_to` INT(10) NULL,
|
|
`product_price` tinyint(1) NOT NULL,
|
|
`product_price_from` decimal(17,2) NOT NULL DEFAULT '0.00',
|
|
`product_price_to` decimal(17,2) NOT NULL DEFAULT '0.00',
|
|
`date_add` DATETIME NOT NULL,
|
|
`date_upd` DATETIME NULL DEFAULT NULL,
|
|
PRIMARY KEY (`id_advancedpopup`),
|
|
KEY `id_advancedpopup` (`id_advancedpopup`)
|
|
) ENGINE="._MYSQL_ENGINE_." DEFAULT CHARSET=utf8;
|
|
";
|
|
|
|
$query[] = "
|
|
CREATE TABLE IF NOT EXISTS `"._DB_PREFIX_."advancedpopup_lang` (
|
|
`id_advancedpopup` int unsigned NOT NULL,
|
|
`id_lang` int unsigned NOT NULL,
|
|
`css_class` VARCHAR(150) NULL,
|
|
`css` TEXT NULL DEFAULT NULL,
|
|
`js` TEXT NULL DEFAULT NULL,
|
|
`content` TEXT NULL DEFAULT NULL,
|
|
`image_background` VARCHAR(150) NULL,
|
|
`image` VARCHAR(150) NULL DEFAULT NULL,
|
|
`image_link` VARCHAR(250) NULL,
|
|
`popup_height` TEXT NULL,
|
|
`popup_width` TEXT NULL,
|
|
`popup_padding` int NULL,
|
|
`responsive_min` int NULL,
|
|
`responsive_max` int NULL,
|
|
`display_url_string` VARCHAR(150) NULL,
|
|
`display_referrer_string` VARCHAR(150) NULL,
|
|
PRIMARY KEY (`id_advancedpopup`, `id_lang`),
|
|
KEY `id_advancedpopup` (`id_advancedpopup`)
|
|
) ENGINE="._MYSQL_ENGINE_." DEFAULT CHARSET=utf8;
|
|
";
|
|
|
|
foreach ($query as $query) {
|
|
Db::getInstance()->execute($query);
|
|
}
|
|
|
|
return true;
|