function upgrade_module_2_0_1($object)
{
upgrade_addquickaccess();
Db::getInstance()->execute('ALTER TABLE `' . _DB_PREFIX_ . 'smart_blog_post` ADD is_featured int(11) DEFAULT NULL');
$smartblog = new smartblog();
$smartblog->registerHook('displayBackOfficeHeader');
$smartblog->SmartHookInsert();
Configuration::updateGlobalValue('smartshowviewed', '1');
Configuration::updateGlobalValue('smartcaptchaoption', '1');
Configuration::updateGlobalValue('smartdisablecatimg', '1');
return true;
}
function upgrade_module_2_1_0($object)
{
Configuration::updateGlobalValue('smartdataformat', 'm/d/Y H:i:s');
upgrade_addquickaccess();
$smartblog = new smartblog();
$smartblog->registerHook('actionsbdeletecat');
$smartblog->registerHook('actionsbnewcat');
$smartblog->registerHook('actionsbupdatecat');
$smartblog->registerHook('actionsbtogglecat');
$smartblog->registerHook('actionsbdeletepost');
$smartblog->registerHook('actionsbnewpost');
$smartblog->registerHook('actionsbupdatepost');
$smartblog->registerHook('actionsbtogglepost');
$smartblog->registerHook('actionHtaccessCreate');
$smartblog->registerHook('displaySmartBlogLeft');
$smartblog->registerHook('displaySmartBlogRight');
$smartblog->registerHook('displaySmartBeforePost');
$smartblog->registerHook('displaySmartAfterPost');
Configuration::updateGlobalValue('smartshowviewed', '1');
Configuration::updateGlobalValue('smartcaptchaoption', '1');
Configuration::updateGlobalValue('smartdisablecatimg', '1');
//----------------------------------------------------------------------------------
Db::getInstance()->execute('DROP TABLE `' . _DB_PREFIX_ . 'smart_blog_product_related`');
//----------------------------------------------------------------------------------
Db::getInstance()->execute('ALTER TABLE `' . _DB_PREFIX_ . 'smart_blog_post_category` CHANGE `id_smart_blog_post_category` `id_smart_blog_post` INT(11) NOT NULL');
Db::getInstance()->execute('ALTER TABLE `' . _DB_PREFIX_ . 'smart_blog_post_category` ADD PRIMARY KEY( `id_smart_blog_post`, `id_smart_blog_category`)');
$results = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('
SELECT id_smart_blog_post , id_category FROM ' . _DB_PREFIX_ . 'smart_blog_post ');
$res = null;
foreach ($results as $result) {
$sql = 'INSERT INTO `' . _DB_PREFIX_ . 'smart_blog_post_category` (`id_smart_blog_post`, `id_smart_blog_category`) VALUES (' + $result['id_smart_blog_post'] + ', ' + $result['id_category'] + ')';
// $res .= Db::getInstance()->execute($sql);
}
//-------------------------------------------------------------------------------------
$results = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS('
SELECT id_smart_blog_post , id_category FROM ' . _DB_PREFIX_ . 'smart_blog_post ');
foreach ($results as $result) {
Db::getInstance()->insert('smart_blog_post_category', array('id_smart_blog_post' => (int) $result['id_smart_blog_post'], 'id_smart_blog_category' => (int) $result['id_category']));
}
//--------------------------------------------------------------------------------------
$id_tab = (int) Tab::getIdFromClassName('AdminSmartBlogAjax');
if (!$id_tab) {
$tab = new Tab();
$tab->active = 1;
$tab->class_name = 'AdminSmartBlogAjax';
$tab->name = array();
foreach (Language::getLanguages(true) as $lang) {
$tab->name[$lang['id_lang']] = 'SmartBlogAjax';
}
$tab->id_parent = -1;
$tab->module = $object->name;
$tab->add();
}
//--------------------------------------------------------------------------------------
$sql = 'CREATE TABLE IF NOT EXISTS `' . _DB_PREFIX_ . 'smart_blog_gallary_images` (
`id_smart_blog_gallary_images` INT(11) NOT NULL AUTO_INCREMENT,
`id_smart_blog_post` int(11) NOT NULL,
`position` int(11) NOT NULL,
PRIMARY KEY (`id_smart_blog_gallary_images`,`id_smart_blog_post`)
) ENGINE=' . _MYSQL_ENGINE_ . ' DEFAULT CHARSET=utf8';
Db::getInstance()->execute($sql);
$sql1 = 'CREATE TABLE IF NOT EXISTS `' . _DB_PREFIX_ . 'smart_blog_gallary_images_lang` (
`id_smart_blog_gallary_images` INT(11) NOT NULL,
`id_lang` int(11) NOT NULL,
`legend` varchar(256) NOT NULL,
PRIMARY KEY (`id_smart_blog_gallary_images`,`id_lang`)
) ENGINE=' . _MYSQL_ENGINE_ . ' DEFAULT CHARSET=utf8';
Db::getInstance()->execute($sql1);
// Changes for shop table
$tables = array(_DB_PREFIX_ . 'smart_blog_category_shop' => 'id_smart_blog_category_shop', _DB_PREFIX_ . 'smart_blog_comment_shop' => 'id_smart_blog_comment_shop', _DB_PREFIX_ . 'smart_blog_post_shop' => 'id_smart_blog_post_shop');
$sqltorun = '';
foreach ($tables as $table => $col) {
$test = Db::getInstance()->executeS("SHOW COLUMNS from `{$table}` WHERE FIELD LIKE '{$col}'", true, false);
if (count($test)) {
$sqltorun .= "ALTER TABLE `{$table}` DROP COLUMN `{$col}`;\n";
}
}
if (!empty($sqltorun)) {
Db::getInstance()->execute($sqltorun);
}
//--------------------------------------------------------------------------------------
$test = Db::getInstance()->executeS("SHOW COLUMNS from `" . _DB_PREFIX_ . "smart_blog_post` WHERE FIELD LIKE 'associations'", true, false);
if (!count($test)) {
Db::getInstance()->execute('ALTER TABLE `' . _DB_PREFIX_ . 'smart_blog_post` ADD `associations` TEXT NOT NULL AFTER `comment_status`');
}
//--------------------------------------------------------------------------------------
Configuration::updateGlobalValue('smartenableguestcomment', '1');
//--------------------------------------------------------------------------------------
Db::getInstance()->execute('CREATE TABLE IF NOT EXISTS `' . _DB_PREFIX_ . 'smart_blog_post_meta` (
`id_smart_blog_post_meta` int(11) NOT NULL auto_increment,
`id_smart_blog_post` int(11) NOT NULL,
`meta_key` VARCHAR(50) NOT NULL,
`meta_value` LONGTEXT,
PRIMARY KEY (`id_smart_blog_post_meta`, `id_smart_blog_post`),
KEY `id_smart_blog_post` (`id_smart_blog_post`)
) ENGINE=' . _MYSQL_ENGINE_ . ' DEFAULT CHARSET=utf8');
//--------------------------------------------------------------------------------------
Configuration::updateGlobalValue('smartblogurlpattern', '2');
Configuration::updateGlobalValue('smartshowhomepost', 4);
Configuration::updateGlobalValue('smartshowrelatedproduct', 5);
Configuration::updateGlobalValue('smartshowrelatedproductpost', 5);
Configuration::updateGlobalValue('smart_update_period', 'hourly');
Configuration::updateGlobalValue('smart_update_frequency', '1');
Configuration::updateGlobalValue('smartshowrelatedpost', 3);
Configuration::updateGlobalValue('sort_category_by', 'id_desc');
Configuration::updateGlobalValue('latestnews_sort_by', 'id_desc');
//--------------------------------------------------------------------------------------
return true;
}