/**
* oledrion
*
* @copyright The XOOPS Project http://sourceforge.net/projects/xoops/
* @license http://www.fsf.org/copyleft/gpl.html GNU public license
* @author Hervé Thouzard (http://www.herve-thouzard.com/)
* @author Hossein Azizabadi (azizabadi@faragostaresh.com)
* @version $Id: functions_update.php 12290 2014-02-07 11:05:17Z beckmi $
*/
function xoops_module_update_oledrion($module, $version)
{
global $xoopsDB;
// Présence des nouvelles tables et nouvelles zones dans la base de données
// Nouvelle table oledrion_gateways_options
$tableName = $xoopsDB->prefix('oledrion_gateways_options');
if (!oledrion_utils::tableExists($tableName)) {
$sql = "CREATE TABLE " . $tableName . " (\n `option_id` int(10) unsigned NOT NULL auto_increment,\n `option_gateway` varchar(50) NOT NULL COMMENT 'nom de la passerelle de paiement',\n `option_name` varchar(50) NOT NULL,\n `option_value` text NOT NULL,\n PRIMARY KEY (`option_id`),\n KEY `option_gateway` (`option_gateway`),\n KEY `option_name` (`option_name`),\n KEY `option_gateway_name` (`option_gateway`,`option_name`)\n ) ENGINE=InnoDB";
$xoopsDB->queryF($sql);
}
// Nouveau champ cmd_comment dans oledrion_commands
$tableName = $xoopsDB->prefix('oledrion_commands');
if (!oledrion_utils::fieldExists('cmd_comment', $tableName)) {
oledrion_utils::addField('`cmd_comment` TEXT NOT NULL', $tableName);
}
if (!oledrion_utils::fieldExists('cmd_vat_number', $tableName)) {
oledrion_utils::addField('`cmd_vat_number` VARCHAR( 255 ) NOT NULL', $tableName);
}
/**
* Nouvelle table oledrion_lists
* @since 2.2.2009.01.29
*/
$tableName = $xoopsDB->prefix('oledrion_lists');
if (!oledrion_utils::tableExists($tableName)) {
$sql = "CREATE TABLE " . $tableName . " (\n `list_id` int(10) unsigned NOT NULL auto_increment,\n `list_uid` mediumint(8) unsigned NOT NULL,\n `list_title` varchar(255) NOT NULL,\n `list_date` int(10) unsigned NOT NULL,\n `list_productscount` mediumint(8) unsigned NOT NULL,\n `list_views` mediumint(8) unsigned NOT NULL,\n `list_password` varchar(50) NOT NULL,\n `list_type` tinyint(3) unsigned NOT NULL,\n `list_description` text NOT NULL,\n PRIMARY KEY (`list_id`),\n KEY `list_uid` (`list_uid`)\n ) ENGINE=InnoDB";
$xoopsDB->queryF($sql);
}
/**
* Nouvelle table oledrion_lists
* @since 2.2.2009.01.29
*/
$tableName = $xoopsDB->prefix('oledrion_products_list');
if (!oledrion_utils::tableExists($tableName)) {
$sql = "CREATE TABLE " . $tableName . " (\n `productlist_id` int(10) unsigned NOT NULL auto_increment,\n `productlist_list_id` int(10) unsigned NOT NULL,\n `productlist_product_id` int(10) unsigned NOT NULL,\n PRIMARY KEY (`productlist_id`),\n KEY `productlist_list_id` (`productlist_list_id`),\n KEY `productlist_product_id` (`productlist_product_id`)\n ) ENGINE=InnoDB";
$xoopsDB->queryF($sql);
}
if (!oledrion_utils::fieldExists('productlist_date', $tableName)) {
oledrion_utils::addField('productlist_date DATE NOT NULL', $tableName);
}
/**
* Nouvelle table oledrion_attributes
* @since 2.3.2009.03.09
*/
$tableName = $xoopsDB->prefix('oledrion_attributes');
if (!oledrion_utils::tableExists($tableName)) {
$sql = "CREATE TABLE `{$tableName}` (\n `attribute_id` int(10) unsigned NOT NULL auto_increment,\n `attribute_weight` mediumint(7) unsigned default NULL,\n `attribute_title` varchar(255) default NULL,\n `attribute_name` varchar(255) NOT NULL,\n `attribute_type` tinyint(3) unsigned default NULL,\n `attribute_mandatory` tinyint(1) unsigned default NULL,\n `attribute_values` text,\n `attribute_names` text,\n `attribute_prices` text,\n `attribute_stocks` text,\n `attribute_product_id` int(11) unsigned default NULL,\n `attribute_default_value` varchar(255) default NULL,\n `attribute_option1` mediumint(7) unsigned default NULL,\n `attribute_option2` mediumint(7) unsigned default NULL,\n PRIMARY KEY (`attribute_id`),\n KEY `attribute_product_id` (`attribute_product_id`),\n KEY `attribute_weight` (`attribute_weight`)\n ) ENGINE=InnoDB;";
$xoopsDB->queryF($sql);
}
/**
* Nouvelle table oledrion_caddy_attributes
* @since 2.3.2009.03.10
*/
$tableName = $xoopsDB->prefix('oledrion_caddy_attributes');
if (!oledrion_utils::tableExists($tableName)) {
$sql = "CREATE TABLE `{$tableName}` (\n `ca_id` int(10) unsigned NOT NULL auto_increment,\n `ca_cmd_id` int(10) unsigned NOT NULL,\n `ca_caddy_id` int(10) unsigned NOT NULL,\n `ca_attribute_id` int(10) unsigned NOT NULL,\n `ca_attribute_values` text NOT NULL,\n `ca_attribute_names` text NOT NULL,\n `ca_attribute_prices` text NOT NULL,\n PRIMARY KEY (`ca_id`),\n KEY `ca_cmd_id` (`ca_cmd_id`),\n KEY `ca_caddy_id` (`ca_caddy_id`),\n KEY `ca_attribute_id` (`ca_attribute_id`)\n ) ENGINE=InnoDB;";
$xoopsDB->queryF($sql);
}
/**
* Augmentation des types numéraires pour accepter le million
* @since 2.3.2009.04.20
*/
$definition = oledrion_utils::getFieldDefinition('product_price', $xoopsDB->prefix('oledrion_products'));
if ($definition != '') {
if (xoops_trim($definition['Type']) == 'decimal(7,2)') {
$tablesToUpdates = array('oledrion_products' => array('product_price', 'product_shipping_price', 'product_discount_price', 'product_ecotaxe'), 'oledrion_caddy' => array('caddy_price'), 'oledrion_commands' => array('cmd_shipping'), 'oledrion_discounts' => array('disc_price_degress_l1total', 'disc_price_degress_l2total', 'disc_price_degress_l3total', 'disc_price_degress_l4total', 'disc_price_degress_l5total'));
foreach ($tablesToUpdates as $tableName => $fields) {
foreach ($fields as $field) {
$sql = 'ALTER TABLE ' . $xoopsDB->prefix($tableName) . ' CHANGE `' . $field . '` `' . $field . '` DECIMAL( 16, 2 ) NOT NULL';
$xoopsDB->queryF($sql);
}
}
}
}
/**
* Add product_property
* @since 2.3.2012.08.03
*/
$tableName = $xoopsDB->prefix('oledrion_products');
if (!oledrion_utils::fieldExists('product_property1', $tableName)) {
oledrion_utils::addField('`product_property1` varchar(255) NOT NULL', $tableName);
}
if (!oledrion_utils::fieldExists('product_property2', $tableName)) {
oledrion_utils::addField('`product_property2` varchar(255) NOT NULL', $tableName);
}
if (!oledrion_utils::fieldExists('product_property3', $tableName)) {
oledrion_utils::addField('`product_property3` varchar(255) NOT NULL', $tableName);
}
if (!oledrion_utils::fieldExists('product_property4', $tableName)) {
oledrion_utils::addField('`product_property4` varchar(255) NOT NULL', $tableName);
}
if (!oledrion_utils::fieldExists('product_property5', $tableName)) {
oledrion_utils::addField('`product_property5` varchar(255) NOT NULL', $tableName);
}
if (!oledrion_utils::fieldExists('product_property6', $tableName)) {
oledrion_utils::addField('`product_property6` varchar(255) NOT NULL', $tableName);
}
if (!oledrion_utils::fieldExists('product_property7', $tableName)) {
oledrion_utils::addField('`product_property7` varchar(255) NOT NULL', $tableName);
}
if (!oledrion_utils::fieldExists('product_property8', $tableName)) {
oledrion_utils::addField('`product_property8` varchar(255) NOT NULL', $tableName);
}
if (!oledrion_utils::fieldExists('product_property9', $tableName)) {
oledrion_utils::addField('`product_property9` varchar(255) NOT NULL', $tableName);
}
if (!oledrion_utils::fieldExists('product_property10', $tableName)) {
oledrion_utils::addField('`product_property10` varchar(255) NOT NULL', $tableName);
}
/**
* Nouvelle table oledrion_packing
* @since 2.3.4 2013.03.5
*/
$tableName = $xoopsDB->prefix('oledrion_packing');
if (!oledrion_utils::tableExists($tableName)) {
$sql = "CREATE TABLE `{$tableName}` (\n `packing_id` int(5) unsigned NOT NULL auto_increment,\n `packing_title` varchar(255) NOT NULL default '',\n `packing_width` varchar(50) NOT NULL,\n `packing_length` varchar(50) NOT NULL,\n `packing_weight` varchar(50) NOT NULL,\n `packing_image` varchar(255) NOT NULL,\n `packing_description` text,\n `packing_price` decimal(16,2) NOT NULL,\n `packing_online` tinyint(1) NOT NULL default '1',\n PRIMARY KEY (`packing_id`),\n KEY `packing_title` (`packing_title`),\n KEY `packing_online` (`packing_online`),\n KEY `packing_price` (`packing_price`)\n ) ENGINE=InnoDB;";
$xoopsDB->queryF($sql);
}
/**
* Nouvelle table oledrion_location
* @since 2.3.4 2013.03.5
*/
$tableName = $xoopsDB->prefix('oledrion_location');
if (!oledrion_utils::tableExists($tableName)) {
$sql = "CREATE TABLE `{$tableName}` (\n `location_id` int(5) unsigned NOT NULL auto_increment,\n `location_pid` int(5) unsigned NOT NULL default '0',\n `location_title` varchar(255) NOT NULL default '',\n `location_online` tinyint(1) NOT NULL default '1',\n `location_type` enum('location','parent') NOT NULL,\n PRIMARY KEY (`location_id`),\n KEY `location_title` (`location_title`),\n KEY `location_pid` (`location_pid`),\n KEY `location_online` (`location_online`)\n ) ENGINE=InnoDB;";
$xoopsDB->queryF($sql);
}
/**
* Nouvelle table oledrion_delivery
* @since 2.3.4 2013.03.5
*/
$tableName = $xoopsDB->prefix('oledrion_delivery');
if (!oledrion_utils::tableExists($tableName)) {
$sql = "CREATE TABLE `{$tableName}` (\n `delivery_id` int(10) unsigned NOT NULL auto_increment,\n `delivery_title` varchar(255) NOT NULL default '',\n `delivery_description` text,\n `delivery_online` tinyint(1) NOT NULL default '1',\n `delivery_image` varchar(255) NOT NULL,\n PRIMARY KEY (`delivery_id`),\n KEY `delivery_title` (`delivery_title`),\n KEY `delivery_online` (`delivery_online`)\n ) ENGINE=InnoDB;";
$xoopsDB->queryF($sql);
}
/**
* Nouvelle table oledrion_payment
* @since 2.3.4 2013.03.5
*/
$tableName = $xoopsDB->prefix('oledrion_payment');
if (!oledrion_utils::tableExists($tableName)) {
$sql = "CREATE TABLE `{$tableName}` (\n `payment_id` int(10) unsigned NOT NULL auto_increment,\n `payment_title` varchar(255) NOT NULL default '',\n `payment_description` text,\n `payment_online` tinyint(1) NOT NULL default '1',\n `payment_type` enum('online','offline') NOT NULL,\n `payment_gateway` varchar(64) NOT NULL default '',\n `payment_image` varchar(255) NOT NULL,\n PRIMARY KEY (`payment_id`),\n KEY `payment_title` (`payment_title`),\n KEY `payment_online` (`payment_online`),\n KEY `payment_type` (`payment_type`),\n KEY `payment_gateway` (`payment_gateway`)\n ) ENGINE=InnoDB;";
$xoopsDB->queryF($sql);
}
/**
* Nouvelle table oledrion_location_delivery
* @since 2.3.4 2013.03.5
*/
$tableName = $xoopsDB->prefix('oledrion_location_delivery');
if (!oledrion_utils::tableExists($tableName)) {
$sql = "CREATE TABLE `{$tableName}` (\n `ld_id` int(5) unsigned NOT NULL auto_increment,\n `ld_location` int(5) unsigned NOT NULL,\n `ld_delivery` int(5) unsigned NOT NULL,\n `ld_price` decimal(16,2) NOT NULL,\n `ld_delivery_time` mediumint(8) unsigned NOT NULL,\n PRIMARY KEY (`ld_id`),\n KEY `ld_location` (`ld_location`),\n KEY `ld_delivery` (`ld_delivery`)\n ) ENGINE=InnoDB;";
$xoopsDB->queryF($sql);
}
/**
* Nouvelle table oledrion_delivery_payment
* @since 2.3.4 2013.03.5
*/
$tableName = $xoopsDB->prefix('oledrion_delivery_payment');
if (!oledrion_utils::tableExists($tableName)) {
$sql = "CREATE TABLE `{$tableName}` (\n `dp_id` int(5) unsigned NOT NULL auto_increment,\n `dp_delivery` int(5) unsigned NOT NULL,\n `dp_payment` int(5) unsigned NOT NULL,\n PRIMARY KEY (`dp_id`),\n KEY `dp_delivery` (`dp_delivery`),\n KEY `dp_payment` (`dp_payment`)\n ) ENGINE=InnoDB;";
$xoopsDB->queryF($sql);
}
/**
* Nouvelle table oledrion_delivery_payment
* @since 2.3.4 2013.03.15
*/
$tableName = $xoopsDB->prefix('oledrion_payment_log');
if (!oledrion_utils::tableExists($tableName)) {
$sql = "CREATE TABLE `{$tableName}` (\n `log_id` int(10) unsigned NOT NULL auto_increment,\n `log_create` int(10) unsigned NOT NULL,\n `log_status` tinyint(1) unsigned NOT NULL,\n `log_ip` varchar(32) NOT NULL,\n `log_type` enum('online','offline') NOT NULL,\n `log_payment` int(10) unsigned NOT NULL,\n `log_gateway` varchar(64) NOT NULL default '',\n `log_uid` int(10) unsigned NOT NULL,\n `log_command` int(10) unsigned NOT NULL,\n `log_amount` double(16,2) NOT NULL,\n `log_authority` varchar(255) NOT NULL,\n PRIMARY KEY (`log_id`),\n KEY `log_uid` (`log_uid`),\n KEY `log_command` (`log_command`),\n KEY `log_status` (`log_status`)\n ) ENGINE=InnoDB;";
$xoopsDB->queryF($sql);
}
/**
* Add New fields to oledrion_commands
* @since 2.3.2013.03.15
*/
$tableName = $xoopsDB->prefix('oledrion_commands');
if (!oledrion_utils::fieldExists('cmd_create', $tableName)) {
oledrion_utils::addField('`cmd_create` int(10) unsigned NOT NULL', $tableName);
}
if (!oledrion_utils::fieldExists('cmd_packing', $tableName)) {
oledrion_utils::addField('`cmd_packing` varchar(255) NOT NULL', $tableName);
}
if (!oledrion_utils::fieldExists('cmd_packing_id', $tableName)) {
oledrion_utils::addField('`cmd_packing_id` int(5) unsigned NOT NULL', $tableName);
}
if (!oledrion_utils::fieldExists('cmd_location', $tableName)) {
oledrion_utils::addField('`cmd_location` varchar(255) NOT NULL', $tableName);
}
if (!oledrion_utils::fieldExists('cmd_location_id', $tableName)) {
oledrion_utils::addField('`cmd_location_id` int(5) unsigned NOT NULL', $tableName);
}
if (!oledrion_utils::fieldExists('cmd_delivery', $tableName)) {
oledrion_utils::addField('`cmd_delivery` varchar(255) NOT NULL', $tableName);
}
if (!oledrion_utils::fieldExists('cmd_delivery_id', $tableName)) {
oledrion_utils::addField('`cmd_delivery_id` int(5) unsigned NOT NULL', $tableName);
}
if (!oledrion_utils::fieldExists('cmd_payment', $tableName)) {
oledrion_utils::addField('`cmd_payment` varchar(255) NOT NULL', $tableName);
}
if (!oledrion_utils::fieldExists('cmd_payment_id', $tableName)) {
oledrion_utils::addField('`cmd_payment_id` int(5) unsigned NOT NULL', $tableName);
}
if (!oledrion_utils::fieldExists('cmd_status', $tableName)) {
oledrion_utils::addField('`cmd_status` tinyint(1) unsigned NOT NULL default "1"', $tableName);
}
if (!oledrion_utils::fieldExists('cmd_mobile', $tableName)) {
oledrion_utils::addField('`cmd_mobile` varchar(30) NOT NULL', $tableName);
}
if (!oledrion_utils::fieldExists('cmd_packing_price', $tableName)) {
oledrion_utils::addField('`cmd_packing_price` decimal(16,2) NOT NULL', $tableName);
}
/**
* Add/update product urls
* @since 2.3.2013.08.03
*/
$tableName = $xoopsDB->prefix('oledrion_products');
if (!oledrion_utils::fieldExists('product_url2', $tableName)) {
oledrion_utils::addField('`product_url2` VARCHAR( 255 ) NOT NULL AFTER `product_url`', $tableName);
}
if (!oledrion_utils::fieldExists('product_url3', $tableName)) {
oledrion_utils::addField('`product_url3` VARCHAR( 255 ) NOT NULL AFTER `product_url`', $tableName);
}
/**
* Add cmd_track
* @since 2014.01.03
*/
$tableName = $xoopsDB->prefix('oledrion_commands');
if (!oledrion_utils::fieldExists('cmd_track', $tableName)) {
oledrion_utils::addField('`cmd_track` VARCHAR( 255 ) NOT NULL', $tableName);
}
/**
* Add cmd_track
* @since 2014.01.10
*/
$tableName = $xoopsDB->prefix('oledrion_related');
if (!oledrion_utils::fieldExists('related_product_percent', $tableName)) {
oledrion_utils::addField('`related_product_percent` INT( 4 ) NOT NULL', $tableName);
}
}