shop->id; $id_hook_reassurance = (int)Hook::getIdByName('displayReassurance'); $id_hook_contact = (int)$this->getIdByName('displayMapcontact'); $queries = [ 'INSERT INTO `'._DB_PREFIX_.'pos_staticblock` (`id_pos_staticblock`, `id_hook`, `position`, `name`,`active`) VALUES (1, '.$id_hook_contact.', 1, "Map Block", 1), (2, '.$id_hook_reassurance.', 2, "payment block", 1)' ]; foreach (Language::getLanguages(true, Context::getContext()->shop->id) as $lang) { $queries[] = 'INSERT INTO `'._DB_PREFIX_.'pos_staticblock_lang` (`id_pos_staticblock`, `id_lang`, `content`) VALUES (1, '.(int)$lang['id_lang'].', \'
Contact us via the contact form below, or come visit us on our office in Melbourne and we will discuss your new project
\'), (2, '.(int)$lang['id_lang'].', \'

Guarantee safe & secure checkout

\')' ; } $queries[] = 'INSERT INTO `'._DB_PREFIX_.'pos_staticblock_shop` (`id_pos_staticblock`, `id_shop`) VALUES (1, 1), (2, 1)'; foreach ($queries as $query) { $return &= Db::getInstance()->execute($query); } return $return; } public function getIdByName($hook_name){ $sql = 'SELECT h.`id_hook` FROM `'._DB_PREFIX_.'hook` h WHERE h.`name` = \''.$hook_name.'\''; $result = Db::getInstance()->executeS($sql); return $result[0]['id_hook']; } } ?>