public function init() { global $smarty; parent::init(); if (Module::isInstalled('agilesellerratings')) { include_once _PS_ROOT_DIR_ . "/modules/agilesellerratings/agilesellerratings.php"; $smarty->assign(array('cate_seller_ratting' => AgileSellerRatings::getAverageRating4Category($this->category->id))); } }
public function init() { if ($category_rewrite = Tools::getValue('category_rewrite')) { $sql = 'SELECT `id_category` FROM `' . _DB_PREFIX_ . 'category_lang` WHERE `link_rewrite` = \'' . pSQL(str_replace('.html', '', $category_rewrite)) . '\' AND `id_lang` = ' . Context::getContext()->language->id; if (Shop::isFeatureActive() && Shop::getContext() == Shop::CONTEXT_SHOP) { $sql .= ' AND `id_shop` = ' . (int) Shop::getContextShopID(); } $id_category = (int) Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($sql); if ($id_category > 0) { $_GET['id_category'] = $id_category; } } parent::init(); }
public function init() { if (Tools::getValue('category_rewrite')) { // SQL safe? $category_rewrite = Tools::getValue('category_rewrite'); $sql = 'SELECT `id_category` FROM `' . _DB_PREFIX_ . 'category_lang` WHERE `link_rewrite` = \'' . $category_rewrite . '\' AND `id_lang` = ' . Context::getContext()->language->id; if (Shop::isFeatureActive() && Shop::getContext() == Shop::CONTEXT_SHOP) { $sql .= ' AND `id_shop` = ' . (int) Shop::getContextShopID(); } $categorys_list = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($sql); $categorys_count = count($categorys_list); if ($categorys_count == 1) { // Found ONLY one so dont need to look for parent $id_category = (int) $categorys_list[0]['id_category']; $_GET['noredirect'] = TRUE; } else { if ($categorys_count > 1) { // Found more than one so look for parent // SQL safe? $parent_rewrite = Tools::getValue('categories_rewrite'); $shop_id = (int) Shop::getContextShopID(); $sql = 'SELECT c.`id_category` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = ' . $shop_id . ' ) INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = ' . $shop_id . ') LEFT JOIN `ps_category_lang` clp ON (c.`id_parent` = clp.`id_category`) WHERE cl.`link_rewrite` = \'' . $category_rewrite . '\' AND clp.`link_rewrite` = \'' . $parent_rewrite . '\' AND cl.`id_lang` = ' . Context::getContext()->language->id; $id_category = (int) Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($sql); $_GET['noredirect'] = TRUE; } else { // none found $id_category = 0; } } if ($id_category > 0) { $_GET['id_category'] = $id_category; } else { //TODO: Do we need to send 404? header('HTTP/1.1 404 Not Found'); header('Status: 404 Not Found'); } } parent::init(); }
public function init() { if (Tools::getValue('category_rewrite')) { $category_rewrite = Tools::getValue('category_rewrite'); $id_category = Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue(' SELECT `id_category` FROM `' . _DB_PREFIX_ . 'category_lang` WHERE `link_rewrite` = \'' . $category_rewrite . '\''); if ($id_category > 0) { $_GET['id_category'] = $id_category; //$_GET['noredirect'] = 1; } else { Tools::display404Error(); die; } } parent::init(); }
/** * Method init() : Initialize category controller with category_rewrite params * * @module now_seo_links * * @see CategoryControllerCore::init() */ public function init() { // Get rewrite $sRewrite = Tools::getValue('category_rewrite', false); if ($sRewrite) { $iIdCategory = (int) Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue(' SELECT `id_category` FROM `' . _DB_PREFIX_ . 'category_lang` WHERE `link_rewrite` = \'' . $sRewrite . '\' AND `id_lang` = ' . Context::getContext()->language->id); if ($iIdCategory) { $_GET['id_category'] = $iIdCategory; } } parent::init(); // On vérifie si l'URL actuelle est correcte ou pas $goodUrl = Context::getContext()->link->getCategoryLink($this->category); if (!preg_match('#' . $_SERVER['REDIRECT_URL'] . '#', $goodUrl)) { header('Status: 301 Moved Permanently', false, 301); header('Location: ' . $goodUrl); exit; } }