name = 'customblocks'; $this->tab = 'front_office_features'; $this->version = '2.5.4'; $this->author = 'PRESTACREA'; $this->bootstrap = true; $this->need_instance = 0; parent::__construct(); $this->displayName = ('PRESTACREA - Custom Blocks'); $this->description = $this->l('Adds editable blocks on your shop'); $this->confirmUninstall = $this->l('Uninstalling the module will delete all its data. Do you want to continue uninstalling the module ?'); if (version_compare(_PS_VERSION_, '1.5.0.0', '<')) require(_PS_MODULE_DIR_.$this->name.'/backward_compatibility/backward.php'); } public function install() { if (file_exists(dirname(__FILE__).'/install/customblocks-install.php')) require_once(dirname(__FILE__).'/install/customblocks-install.php'); if (file_exists(dirname(__FILE__).'/views/css/front/less/default.less.cache')) unlink(dirname(__FILE__).'/views/css/front/less/default.less.cache'); if (file_exists(dirname(__FILE__).'/views/css/front/less/responsive.less.cache')) unlink(dirname(__FILE__).'/views/css/front/less/responsive.less.cache'); if (file_exists(dirname(__FILE__).'/install/customblocks-update.php') && $this->version >= '2.2') unlink(dirname(__FILE__).'/install/customblocks-update.php'); if (!parent::install() || !$this->registerHook('header') || !$this->registerHook('top') || !$this->registerHook('leftColumn') || !$this->registerHook('rightColumn') || !$this->registerHook('footer') || !$this->registerHook('home') || !$this->registerHook('extraLeft') || !$this->registerHook('extraRight') || !$this->registerHook('productActions') || !$this->registerHook('productOutOfStock') || !$this->registerHook('productfooter') || !$this->registerHook('shoppingCart') || !$this->registerHook('shoppingCartExtra') || !$this->registerHook('createAccountForm') || !$this->registerHook('customerAccount') || !$this->registerHook('extraCarrier')) return false; return true; } public function uninstall() { if (file_exists(dirname(__FILE__).'/install/customblocks-uninstall.php')) require_once(dirname(__FILE__).'/install/customblocks-uninstall.php'); if (file_exists(dirname(__FILE__).'/views/css/front/less/default.less.cache')) unlink(dirname(__FILE__).'/views/css/front/less/default.less.cache'); if (file_exists(dirname(__FILE__).'/views/css/front/less/responsive.less.cache')) unlink(dirname(__FILE__).'/views/css/front/less/responsive.less.cache'); if (!parent::uninstall()) return false; return true; } public function addBlock() { $languages = Language::getLanguages(); $default_language = (int)Configuration::get('PS_LANG_DEFAULT'); if (version_compare(_PS_VERSION_, '1.5.0.0', '>=')) { $id_shop = $this->context->shop->id; if (!Db::getInstance()->Execute('INSERT INTO '._DB_PREFIX_.'customblocks VALUES ()') || !$last_id = Db::getInstance()->Insert_ID()) return false; foreach ($languages as $language) { $content = Tools::getValue('editor_'.$language['id_lang']) ? Tools::getValue('editor_'.$language['id_lang']) : Tools::getValue('editor_'.$default_language); $link = Tools::getValue('link_'.$language['id_lang']) ? Tools::getValue('link_'.$language['id_lang']) : Tools::getValue('link_'.$default_language); $inhook = Tools::getValue('inhook_'.$default_language); $position = Tools::getValue('position_'.$default_language); $active = Tools::getValue('active_'.$default_language); if (!Db::getInstance()->Execute('INSERT INTO '._DB_PREFIX_.'customblocks_lang VALUES ('.$last_id.', \''.(int)$id_shop.'\', '.$language['id_lang'].', \''.addslashes($content).'\', \''.addslashes($link).'\', \''.addslashes($inhook).'\', \''.addslashes($position).'\', \''.addslashes($active).'\')')) return false; } return true; } else { if (!Db::getInstance()->Execute('INSERT INTO '._DB_PREFIX_.'customblocks VALUES ()') || !$last_id = mysql_insert_id()) return false; foreach ($languages as $language) { $content = Tools::getValue('editor_'.$language['id_lang']) ? Tools::getValue('editor_'.$language['id_lang']) : Tools::getValue('editor_'.$default_language); $link = Tools::getValue('link_'.$language['id_lang']) ? Tools::getValue('link_'.$language['id_lang']) : Tools::getValue('link_'.$default_language); $inhook = Tools::getValue('inhook_'.$default_language); $position = Tools::getValue('position_'.$default_language); $active = Tools::getValue('active_'.$default_language); if (!Db::getInstance()->Execute('INSERT INTO '._DB_PREFIX_.'customblocks_lang VALUES ('.$last_id.', "1", '.$language['id_lang'].', \''.addslashes($content).'\', \''.addslashes($link).'\', \''.addslashes($inhook).'\', \''.addslashes($position).'\', \''.addslashes($active).'\')')) return false; } return true; } } public function editBlock() { $languages = Language::getLanguages(); $default_language = (int)Configuration::get('PS_LANG_DEFAULT'); if (version_compare(_PS_VERSION_, '1.5.0.0', '>=')) { $id_shop = $this->context->shop->id; foreach ($languages as $language) { $content = Tools::getValue('editor_'.$language['id_lang']) ? Tools::getValue('editor_'.$language['id_lang']) : Tools::getValue('editor_'.$default_language); $link = Tools::getValue('link_'.$language['id_lang']) ? Tools::getValue('link_'.$language['id_lang']) : Tools::getValue('link_'.$default_language); $inhook = Tools::getValue('inhook_'.$default_language); $position = Tools::getValue('position_'.$default_language); $active = Tools::getValue('active_'.$default_language); $id_block = (int)Tools::getValue('id'); if (!Db::getInstance()->Execute('REPLACE '._DB_PREFIX_.'customblocks_lang VALUES (\''.($id_block).'\', \''.(int)$id_shop.'\', \''.$language['id_lang'].'\', \''.addslashes($content).'\', \''.addslashes($link).'\', \''.addslashes($inhook).'\', \''.addslashes($position).'\', \''.addslashes($active).'\')')) return false; } return true; } else { foreach ($languages as $language) { $content = Tools::getValue('editor_'.$language['id_lang']) ? Tools::getValue('editor_'.$language['id_lang']) : Tools::getValue('editor_'.$default_language); $link = Tools::getValue('link_'.$language['id_lang']) ? Tools::getValue('link_'.$language['id_lang']) : Tools::getValue('link_'.$default_language); $inhook = Tools::getValue('inhook_'.$default_language); $position = Tools::getValue('position_'.$default_language); $active = Tools::getValue('active_'.$default_language); $id_block = (int)Tools::getValue('id'); if (!Db::getInstance()->Execute('REPLACE '._DB_PREFIX_.'customblocks_lang VALUES (\''.($id_block).'\', "1", \''.$language['id_lang'].'\', \''.addslashes($content).'\', \''.addslashes($link).'\', \''.addslashes($inhook).'\', \''.addslashes($position).'\', \''.addslashes($active).'\')')) return false; } return true; } } public function deleteBlock() { $id_block = (int)Tools::getValue('id'); if (Db::getInstance()->Execute('DELETE FROM '._DB_PREFIX_.'customblocks WHERE `id_block`='.$id_block)) return Db::getInstance()->Execute('DELETE FROM '._DB_PREFIX_.'customblocks_lang WHERE `id_block`='.$id_block); return false; } public function getContent() { $this->_html = '

'.$this->displayName.' - v.'.$this->version.'

'.$this->l('PDF documentation').'
'; if (file_exists(dirname(__FILE__).'/install/customblocks-update.php') && $this->version >= '2.2' && !Tools::isSubmit('submitUpdate')) $this->_html .= ''; $this->_html .= '
'; $default_language = Configuration::get('PS_LANG_DEFAULT'); $position = Tools::getValue('position_'.$default_language); if (Tools::isSubmit('submitGeneral')) { Configuration::updateValue('CB_RESPONSIVE', pSQL(Tools::getValue('cb_responsive'))); $this->_html .= $this->displayConfirmation($this->l('Configuration updated')); } elseif (Tools::isSubmit('submitAddBlock')) { if (!$position || $position <= 0 || !Validate::isInt($position)) $this->_html .= $this->displayError($this->l('Invalid position number')); else { if ($this->addBlock()) $this->_html .= $this->displayConfirmation($this->l('The block has been added successfully')); else $this->_html .= $this->displayError($this->l('An error occured during block adding')); } } elseif (Tools::isSubmit('submitEditBlock')) { if (!$position || $position <= 0 || !Validate::isInt($position)) $this->_html .= $this->displayError($this->l('Invalid position number')); else { if (!Tools::getValue('id') || !is_numeric(Tools::getValue('id')) || !$this->editBlock()) $this->_html .= $this->displayError($this->l('An error occured during block editing')); else $this->_html .= $this->displayConfirmation($this->l('The block has been edited successfully')); } } elseif (Tools::getValue('id')) { if (!is_numeric(Tools::getValue('id')) || !$this->deleteBlock()) $this->_html .= $this->displayError($this->l('An error occurred during block deletion')); else $this->_html .= $this->displayConfirmation($this->l('The block has been deleted successfully')); } if (Tools::isSubmit('submitCSS')) { if ($this->putFileContents()) $this->_html .= $this->displayConfirmation($this->l('CSS file updated')); else $this->_html .= $this->displayError($this->l('No CSS file selected')); } if (Tools::isSubmit('submitCache')) { if (file_exists(dirname(__FILE__).'/views/css/front/less/default.less.cache')) unlink(dirname(__FILE__).'/views/css/front/less/default.less.cache'); if (file_exists(dirname(__FILE__).'/views/css/front/less/responsive.less.cache')) unlink(dirname(__FILE__).'/views/css/front/less/responsive.less.cache'); $this->_html .= $this->displayConfirmation($this->l('Module cache cleared')); } if (Tools::isSubmit('submitUpdate')) { if (file_exists(dirname(__FILE__).'/install/customblocks-update.php')) require_once(dirname(__FILE__).'/install/customblocks-update.php'); unlink(dirname(__FILE__).'/install/customblocks-update.php'); $this->_html .= $this->displayConfirmation($this->l('Module updated')); } $this->displayForm(); return $this->_html; } public function displayForm() { $iso = Language::getIsoById((int)$this->context->cookie->id_lang); $this->_html .= '
'; $this->configBlocks(); $this->_html .= '
'; $iso_tiny_mce = (file_exists(_PS_ROOT_DIR_.'/js/tiny_mce/langs/'.$iso.'.js') ? $iso : 'en'); $ad = dirname(Tools::safeOutput($_SERVER['PHP_SELF'])); $this->_html .= ' '; if (version_compare(_PS_VERSION_, '1.6.0.12', '>=')) $this->_html .= ''; if (version_compare(_PS_VERSION_, '1.5.0.0', '>=')) { $this->_html .= ''; } } public function configBlocks() { $languages = Language::getLanguages(); $default_language = (int)Configuration::get('PS_LANG_DEFAULT'); if (version_compare(_PS_VERSION_, '1.5.0.0', '>=')) $id_shop = $this->context->shop->id; $div_lang_name = 'editor¤link'; $this->_html .= '

'.$this->l('Blocks configuration').'

'.$this->l('Location').' :
'; foreach ($languages as $language) { $this->_html .= '
'.$this->l('Hook').' '.$this->l('Position Nº').'
'; } $this->_html .= '

'.$this->l('Set the hook of the block and its position inside the hook').'

'.$this->l('Content').' :
'; foreach ($languages as $language) $this->_html .= '
'; $this->_html .= $this->displayFlags($languages, $default_language, $div_lang_name, 'editor', true); $this->_html .= '

'.$this->l('Set the content of the block').'

'.$this->l('Link').' :
'; foreach ($languages as $language) $this->_html .= ''; $this->_html .= $this->displayFlags($languages, $default_language, $div_lang_name, 'link', true); $this->_html .= '

'.$this->l('Display a button with link in the block').'

'.$this->l('Status').' :
'; foreach ($languages as $language) $this->_html .= '
'; $this->_html .= '

'.$this->l('Set whether the block is enabled or not').'

'; if (version_compare(_PS_VERSION_, '1.5.0.0', '>=')) $this->_html .= ''; else $this->_html .= ''; $this->_html .= '
'; $this->listBlocks(); $this->_html .= '
'; } public function configGeneral() { $this->_html .= '

'.$this->l('General configuration options').'

'.$this->l('Yes').' '.$this->l('No').'

'.$this->l('Set whether the responsive mode is activated or not (the template used must be compatible, disable this option if the template is not responsive)').'

'; } public function configCSS() { $dir = dirname(__FILE__).'/views/css/front/less/'; $files = scandir($dir); $cnt = count($files); $this->_html .= '

'.$this->l('Warning').'

'.$this->l('Editing CSS file is only for experienced users. Edit these files only if you know what you are doing.').'

'.$this->l('List of CSS files (LESS files)').'

'; for ($i = 0; $i < $cnt; $i++) if (preg_match('/.less$/', $files[$i])) { $link = ''; $link .= ''; $this->_html .= ''; } $this->_html .= '
'.$this->l('Filename').' '.$this->l('Edit').'
'.$files[$i].' '.$link.'
'; $this->_html .= '
'; } public function putFileContents() { $filename = Tools::getValue('fileName'); $file = dirname(__FILE__).'/views/css/front/less/'.$filename; $balises = array('content:"e', 'content:"f'); $replace = array('content:"\\e', 'content:"\\f'); $data = str_replace($balises, $replace, Tools::getValue('contentCSS')); $contents = $data; if ($filename) { file_put_contents($file, $contents); return true; } else return false; } public function getBlocks($id_lang = null) { $result = array(); if (version_compare(_PS_VERSION_, '1.5.0.0', '>=')) { $id_shop = $this->context->shop->id; if (!$blocks = Db::getInstance()->ExecuteS('SELECT c.`id_block`, cl.`inhook`, cl.`position` FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND `id_shop`='.(int)$id_shop.' AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') ORDER BY `inhook`, `position`')) return false; } else { if (!$blocks = Db::getInstance()->ExecuteS('SELECT c.`id_block`, cl.`inhook`, cl.`position` FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') ORDER BY `inhook`, `position`')) return false; } $i = 0; foreach ($blocks as $block) { $result[$i]['id'] = $block['id_block']; if (version_compare(_PS_VERSION_, '1.5.0.0', '>=')) $sql = 'SELECT `id_lang`, `content`, `link`, `inhook`, `position`, `active` FROM '._DB_PREFIX_.'customblocks_lang WHERE `id_block`='.(int)$block['id_block'].' AND `id_shop`='.(int)$id_shop; else $sql = 'SELECT `id_lang`, `content`, `link`, `inhook`, `position`, `active` FROM '._DB_PREFIX_.'customblocks_lang WHERE `id_block`='.(int)$block['id_block']; if (isset($id_lang) && is_numeric($id_lang) && (int)$id_lang > 0) $sql .= ' AND `id_lang` = '.(int)$id_lang; if (!$texts = Db::getInstance()->ExecuteS($sql)) return false; foreach ($texts as $text) { $result[$i]['content_'.$text['id_lang']] = $text['content']; $result[$i]['link_'.$text['id_lang']] = $text['link']; $result[$i]['inhook_'.$text['id_lang']] = $text['inhook']; $result[$i]['position_'.$text['id_lang']] = $text['position']; $result[$i]['active_'.$text['id_lang']] = $text['active']; } $i++; } return $result; } public function listBlocks() { $blocks = $this->getBlocks(); $default_language = (int)Configuration::get('PS_LANG_DEFAULT'); $languages = Language::getLanguages(); if (version_compare(_PS_VERSION_, '1.5.0.0', '>=')) $token = Tools::safeOutput(Tools::getValue('token')); if ($blocks) { $this->_html .= ''; $this->_html .= $var; } if (!$blocks) $this->_html .= '

'.$this->l('No blocks').'

'; else { $this->_html .= ''; $i = 0; foreach ($blocks as $block) { $content = isset($block['content_'.$this->context->cookie->id_lang]) ? $block['content_'.$this->context->cookie->id_lang] : $block['content_'.$default_language]; $link = isset($block['link_'.$this->context->cookie->id_lang]) ? $block['link_'.$this->context->cookie->id_lang] : $block['link_'.$default_language]; $inhook = isset($block['inhook_'.$this->context->cookie->id_lang]) ? $block['inhook_'.$this->context->cookie->id_lang] : $block['inhook_'.$default_language]; $position = isset($block['position_'.$this->context->cookie->id_lang]) ? $block['position_'.$this->context->cookie->id_lang] : $block['position_'.$default_language]; $active = isset($block['active_'.$this->context->cookie->id_lang]) ? $block['active_'.$this->context->cookie->id_lang] : $block['active_'.$default_language]; $this->_html .= ' '; $i++; } $this->_html .= '
'.$this->l('ID').' '.$this->l('Hook').' '.$this->l('Position').' '.$this->l('Content').' '.$this->l('Link').' '.$this->l('Status').' '.$this->l('Actions').'
'.(int)$block['id'].' '.($inhook == 'top' ? ''.$this->l('Top').'' : '').' '.($inhook == 'leftColumn' ? ''.$this->l('Left column').'' : '').' '.($inhook == 'rightColumn' ? ''.$this->l('Right column').'' : '').' '.($inhook == 'footer' ? ''.$this->l('Footer').'' : '').' '.($inhook == 'home' ? ''.$this->l('Homepage').'' : '').' '.($inhook == 'extraLeft' ? ''.$this->l('Product page left column').'' : '').' '.($inhook == 'extraRight' ? ''.$this->l('Product page right column').'' : '').' '.($inhook == 'productActions' ? ''.$this->l('Product page actions').'' : '').' '.($inhook == 'productOutOfStock' ? ''.$this->l('Product page out of stock').'' : '').' '.($inhook == 'productfooter' ? ''.$this->l('Product page footer').'' : '').' '.($inhook == 'shoppingCart' ? ''.$this->l('Shopping cart page footer').'' : '').' '.($inhook == 'shoppingCartExtra' ? ''.$this->l('Shopping cart page extra footer').'' : '').' '.($inhook == 'createAccountForm' ? ''.$this->l('Account creation page footer').'' : '').' '.($inhook == 'customerAccount' ? ''.$this->l('Customer account page').'' : '').' '.($inhook == 'extraCarrier' ? ''.$this->l('Carrier page').'' : '').' '.($inhook == 'topColumn' ? ''.$this->l('Top column').'' : '').' '.(int)$position.' '.$content.' '.Tools::safeOutput($link).' '.($active == 1 ? ''.$this->l('Enabled').'' : ''.$this->l('Disabled').'').'
'; } } public function cacheCompileLess($input_file, $output_file) { if (!class_exists('lessc')) require_once dirname(__FILE__).'/lessc.inc.php'; $cache_file = $input_file.'.cache'; if (file_exists($cache_file)) $cache = unserialize(Tools::file_get_contents($cache_file)); else $cache = $input_file; $less = new lessc; $less->setFormatter('classic'); $new_cache = $less->cachedCompile($cache); if (!is_array($cache) || $new_cache['updated'] > $cache['updated']) { file_put_contents($cache_file, serialize($new_cache)); file_put_contents($output_file, $new_cache['compiled']); } } public function hookHeader() { $this->cacheCompileLess(dirname(__FILE__).'/views/css/front/less/default.less', dirname(__FILE__).'/views/css/front/customblocks.css'); $this->cacheCompileLess(dirname(__FILE__).'/views/css/front/less/responsive.less', dirname(__FILE__).'/views/css/front/customblocks-responsive.css'); if (version_compare(_PS_VERSION_, '1.5.0.0', '>=')) { $this->context->controller->addCSS(($this->_path).'views/css/front/customblocks.css', 'all'); if (Configuration::get('CB_RESPONSIVE') == 1) $this->context->controller->addCSS(($this->_path).'views/css/front/customblocks-responsive.css', 'all'); } else { Tools::addCSS($this->_path.'views/css/front/customblocks.css', 'all'); if (Configuration::get('CB_RESPONSIVE') == 1) Tools::addCSS($this->_path.'views/css/front/customblocks-responsive.css', 'all'); } } public function hookTop() { if (version_compare(_PS_VERSION_, '1.5.0.0', '>=')) { $id_shop = $this->context->shop->id; $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND `id_shop`='.(int)$id_shop.' AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "top" AND `active` = 1 ORDER BY `position`'; $this->context->smarty->assign('id_shop', $id_shop); } else { $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "top" AND `active` = 1 ORDER BY `position`'; } $blocks = Db::getInstance()->ExecuteS($sql); $this->context->smarty->assign(array( 'ps_version' => _PS_VERSION_, 'blocks' => $blocks, 'inhook' => 'top' )); return $this->display(__FILE__, 'views/templates/front/customblocks.tpl'); } public function hookLeftColumn() { if (version_compare(_PS_VERSION_, '1.5.0.0', '>=')) { $id_shop = $this->context->shop->id; $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND `id_shop`='.(int)$id_shop.' AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "leftColumn" AND `active` = 1 ORDER BY `position`'; $this->context->smarty->assign('id_shop', $id_shop); } else { $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "leftColumn" AND `active` = 1 ORDER BY `position`'; } $blocks = Db::getInstance()->ExecuteS($sql); $this->context->smarty->assign(array( 'ps_version' => _PS_VERSION_, 'blocks' => $blocks, 'inhook' => 'leftColumn' )); return $this->display(__FILE__, 'views/templates/front/customblocks.tpl'); } public function hookRightColumn() { if (version_compare(_PS_VERSION_, '1.5.0.0', '>=')) { $id_shop = $this->context->shop->id; $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND `id_shop`='.(int)$id_shop.' AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "rightColumn" AND `active` = 1 ORDER BY `position`'; $this->context->smarty->assign('id_shop', $id_shop); } else { $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "rightColumn" AND `active` = 1 ORDER BY `position`'; } $blocks = Db::getInstance()->ExecuteS($sql); $this->context->smarty->assign(array( 'ps_version' => _PS_VERSION_, 'blocks' => $blocks, 'inhook' => 'rightColumn' )); return $this->display(__FILE__, 'views/templates/front/customblocks.tpl'); } public function hookFooter() { if (version_compare(_PS_VERSION_, '1.5.0.0', '>=')) { $id_shop = $this->context->shop->id; $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND `id_shop`='.(int)$id_shop.' AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "footer" AND `active` = 1 ORDER BY `position`'; $this->context->smarty->assign('id_shop', $id_shop); } else { $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "footer" AND `active` = 1 ORDER BY `position`'; } $blocks = Db::getInstance()->ExecuteS($sql); $this->context->smarty->assign(array( 'ps_version' => _PS_VERSION_, 'blocks' => $blocks, 'inhook' => 'footer' )); return $this->display(__FILE__, 'views/templates/front/customblocks.tpl'); } public function hookHome() { if (version_compare(_PS_VERSION_, '1.5.0.0', '>=')) { $id_shop = $this->context->shop->id; $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND `id_shop`='.(int)$id_shop.' AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "home" AND `active` = 1 ORDER BY `position`'; $this->context->smarty->assign('id_shop', $id_shop); } else { $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "home" AND `active` = 1 ORDER BY `position`'; } $blocks = Db::getInstance()->ExecuteS($sql); $this->context->smarty->assign(array( 'ps_version' => _PS_VERSION_, 'blocks' => $blocks, 'inhook' => 'home' )); return $this->display(__FILE__, 'views/templates/front/customblocks.tpl'); } public function hookExtraLeft() { if (version_compare(_PS_VERSION_, '1.5.0.0', '>=')) { $id_shop = $this->context->shop->id; $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND `id_shop`='.(int)$id_shop.' AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "extraLeft" AND `active` = 1 ORDER BY `position`'; $this->context->smarty->assign('id_shop', $id_shop); } else { $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "extraLeft" AND `active` = 1 ORDER BY `position`'; } $blocks = Db::getInstance()->ExecuteS($sql); $this->context->smarty->assign(array( 'ps_version' => _PS_VERSION_, 'blocks' => $blocks, 'inhook' => 'extraLeft' )); return $this->display(__FILE__, 'views/templates/front/customblocks.tpl'); } public function hookExtraRight() { if (version_compare(_PS_VERSION_, '1.5.0.0', '>=')) { $id_shop = $this->context->shop->id; $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND `id_shop`='.(int)$id_shop.' AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "extraRight" AND `active` = 1 ORDER BY `position`'; $this->context->smarty->assign('id_shop', $id_shop); } else { $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "extraRight" AND `active` = 1 ORDER BY `position`'; } $blocks = Db::getInstance()->ExecuteS($sql); $this->context->smarty->assign(array( 'ps_version' => _PS_VERSION_, 'blocks' => $blocks, 'inhook' => 'extraRight' )); return $this->display(__FILE__, 'views/templates/front/customblocks.tpl'); } public function hookProductActions() { if (version_compare(_PS_VERSION_, '1.5.0.0', '>=')) { $id_shop = $this->context->shop->id; $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND `id_shop`='.(int)$id_shop.' AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "productActions" AND `active` = 1 ORDER BY `position`'; $this->context->smarty->assign('id_shop', $id_shop); } else { $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "productActions" AND `active` = 1 ORDER BY `position`'; } $blocks = Db::getInstance()->ExecuteS($sql); $this->context->smarty->assign(array( 'ps_version' => _PS_VERSION_, 'blocks' => $blocks, 'inhook' => 'productActions' )); return $this->display(__FILE__, 'views/templates/front/customblocks.tpl'); } public function hookProductOutOfStock() { if (version_compare(_PS_VERSION_, '1.5.0.0', '>=')) { $id_shop = $this->context->shop->id; $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND `id_shop`='.(int)$id_shop.' AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "productOutOfStock" AND `active` = 1 ORDER BY `position`'; $this->context->smarty->assign('id_shop', $id_shop); } else { $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "productOutOfStock" AND `active` = 1 ORDER BY `position`'; } $blocks = Db::getInstance()->ExecuteS($sql); $this->context->smarty->assign(array( 'ps_version' => _PS_VERSION_, 'blocks' => $blocks, 'inhook' => 'productOutOfStock' )); return $this->display(__FILE__, 'views/templates/front/customblocks.tpl'); } public function hookProductFooter() { if (version_compare(_PS_VERSION_, '1.5.0.0', '>=')) { $id_shop = $this->context->shop->id; $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND `id_shop`='.(int)$id_shop.' AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "productfooter" AND `active` = 1 ORDER BY `position`'; $this->context->smarty->assign('id_shop', $id_shop); } else { $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "productfooter" AND `active` = 1 ORDER BY `position`'; } $blocks = Db::getInstance()->ExecuteS($sql); $this->context->smarty->assign(array( 'ps_version' => _PS_VERSION_, 'blocks' => $blocks, 'inhook' => 'productfooter' )); return $this->display(__FILE__, 'views/templates/front/customblocks.tpl'); } public function hookShoppingCart() { if (version_compare(_PS_VERSION_, '1.5.0.0', '>=')) { $id_shop = $this->context->shop->id; $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND `id_shop`='.(int)$id_shop.' AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "shoppingCart" AND `active` = 1 ORDER BY `position`'; $this->context->smarty->assign('id_shop', $id_shop); } else { $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "shoppingCart" AND `active` = 1 ORDER BY `position`'; } $blocks = Db::getInstance()->ExecuteS($sql); $this->context->smarty->assign(array( 'ps_version' => _PS_VERSION_, 'blocks' => $blocks, 'inhook' => 'shoppingCart' )); return $this->display(__FILE__, 'views/templates/front/customblocks.tpl'); } public function hookShoppingCartExtra() { if (version_compare(_PS_VERSION_, '1.5.0.0', '>=')) { $id_shop = $this->context->shop->id; $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND `id_shop`='.(int)$id_shop.' AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "shoppingCartExtra" AND `active` = 1 ORDER BY `position`'; $this->context->smarty->assign('id_shop', $id_shop); } else { $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "shoppingCartExtra" AND `active` = 1 ORDER BY `position`'; } $blocks = Db::getInstance()->ExecuteS($sql); $this->context->smarty->assign(array( 'ps_version' => _PS_VERSION_, 'blocks' => $blocks, 'inhook' => 'shoppingCartExtra' )); return $this->display(__FILE__, 'views/templates/front/customblocks.tpl'); } public function hookCreateAccountForm() { if (version_compare(_PS_VERSION_, '1.5.0.0', '>=')) { $id_shop = $this->context->shop->id; $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND `id_shop`='.(int)$id_shop.' AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "createAccountForm" AND `active` = 1 ORDER BY `position`'; $this->context->smarty->assign('id_shop', $id_shop); } else { $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "createAccountForm" AND `active` = 1 ORDER BY `position`'; } $blocks = Db::getInstance()->ExecuteS($sql); $this->context->smarty->assign(array( 'ps_version' => _PS_VERSION_, 'blocks' => $blocks, 'inhook' => 'createAccountForm' )); return $this->display(__FILE__, 'views/templates/front/customblocks.tpl'); } public function hookCustomerAccount() { if (version_compare(_PS_VERSION_, '1.5.0.0', '>=')) { $id_shop = $this->context->shop->id; $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND `id_shop`='.(int)$id_shop.' AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "customerAccount" AND `active` = 1 ORDER BY `position`'; $this->context->smarty->assign('id_shop', $id_shop); } else { $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "customerAccount" AND `active` = 1 ORDER BY `position`'; } $blocks = Db::getInstance()->ExecuteS($sql); $this->context->smarty->assign(array( 'ps_version' => _PS_VERSION_, 'blocks' => $blocks, 'inhook' => 'customerAccount' )); return $this->display(__FILE__, 'views/templates/front/customblocks.tpl'); } public function hookExtraCarrier() { if (version_compare(_PS_VERSION_, '1.5.0.0', '>=')) { $id_shop = $this->context->shop->id; $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND `id_shop`='.(int)$id_shop.' AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "extraCarrier" AND `active` = 1 ORDER BY `position`'; $this->context->smarty->assign('id_shop', $id_shop); } else { $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "extraCarrier" AND `active` = 1 ORDER BY `position`'; } $blocks = Db::getInstance()->ExecuteS($sql); $this->context->smarty->assign(array( 'ps_version' => _PS_VERSION_, 'blocks' => $blocks, 'inhook' => 'extraCarrier' )); return $this->display(__FILE__, 'views/templates/front/customblocks.tpl'); } public function hookTopColumn() { if (version_compare(_PS_VERSION_, '1.5.0.0', '>=')) { $id_shop = $this->context->shop->id; $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND `id_shop`='.(int)$id_shop.' AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "topColumn" AND `active` = 1 ORDER BY `position`'; $this->context->smarty->assign('id_shop', $id_shop); } else { $sql = 'SELECT c.`id_block` AS id, cl.`content` AS content, cl.`link` AS link FROM `'._DB_PREFIX_.'customblocks` c JOIN `'._DB_PREFIX_.'customblocks_lang` cl ON (c.`id_block` = cl.`id_block` AND cl.`id_lang` = '.(int)$this->context->cookie->id_lang.') WHERE `inhook` = "topColumn" AND `active` = 1 ORDER BY `position`'; } $blocks = Db::getInstance()->ExecuteS($sql); $this->context->smarty->assign(array( 'ps_version' => _PS_VERSION_, 'blocks' => $blocks, 'inhook' => 'topColumn' )); return $this->display(__FILE__, 'views/templates/front/customblocks.tpl'); } }