public function init() { if ($cms_rewrite = Tools::getValue('cms_rewrite')) { $sql = 'SELECT l.`id_cms` FROM `' . _DB_PREFIX_ . 'cms_lang` l LEFT JOIN `' . _DB_PREFIX_ . 'cms_shop` s ON (l.`id_cms` = s.`id_cms`) WHERE l.`link_rewrite` = \'' . pSQL(str_replace('.html', '', $cms_rewrite)) . '\''; if (Shop::isFeatureActive() && Shop::getContext() == Shop::CONTEXT_SHOP) { $sql .= ' AND s.`id_shop` = ' . (int) Shop::getContextShopID(); } $id_cms = (int) Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($sql); if ($id_cms > 0) { $_GET['id_cms'] = $id_cms; } } elseif ($cms_category_rewrite = Tools::getValue('cms_category_rewrite')) { $sql = 'SELECT `id_cms_category` FROM `' . _DB_PREFIX_ . 'cms_category_lang` WHERE `link_rewrite` = \'' . pSQL($cms_category_rewrite) . '\''; if (Shop::isFeatureActive() && Shop::getContext() == Shop::CONTEXT_SHOP) { $sql .= ' AND s.`id_shop` = ' . (int) Shop::getContextShopID(); } $id_cms_category = (int) Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($sql); if ($id_cms_category > 0) { $_GET['id_cms_category'] = $id_cms_category; } } parent::init(); }
public function init() { if (Tools::getValue('cms_rewrite')) { $rewrite_url = Tools::getValue('cms_rewrite'); $id_cms = Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue(' SELECT `id_cms` FROM `' . _DB_PREFIX_ . 'cms_lang` WHERE `link_rewrite` = \'' . $rewrite_url . '\''); if ($id_cms > 0) { $_GET['id_cms'] = $id_cms; //$_GET['noredirect'] = 1; } else { Tools::display404Error(); die; } } else { if (Tools::getValue('cms_category_rewrite')) { $rewrite_url = Tools::getValue('cms_category_rewrite'); $id_cms_category = Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue(' SELECT `id_cms_category` FROM `' . _DB_PREFIX_ . 'cms_category_lang` WHERE `link_rewrite` = \'' . $rewrite_url . '\''); if ($id_cms_category > 0) { $_GET['id_cms_category'] = $id_cms_category; //$_GET['noredirect'] = 1; } else { Tools::display404Error(); die; } } } parent::init(); }
/** * Method init() : Initialize cms controller with cms_rewrite params * * @module now_seo_links * * @see CmsControllerCore::init() */ public function init() { // Get rewrite $sRewrite = Tools::getValue('cms_rewrite', false); if ($sRewrite) { $iIdCms = (int) Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue(' SELECT `id_cms` FROM `' . _DB_PREFIX_ . 'cms_lang` WHERE `link_rewrite` = \'' . $sRewrite . '\' AND `id_lang` = ' . Context::getContext()->language->id); if ($iIdCms) { $_GET['id_cms'] = $iIdCms; } } // Get rewrite $sRewriteCategory = Tools::getValue('cms_category_rewrite', false); if ($sRewriteCategory) { $iIdCmsCategory = (int) Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue(' SELECT `id_cms_category` FROM `' . _DB_PREFIX_ . 'cms_category_lang` WHERE `link_rewrite` = \'' . $sRewriteCategory . '\' AND `id_lang` = ' . Context::getContext()->language->id); if ($iIdCmsCategory) { $_GET['id_cms_category'] = $iIdCmsCategory; } } parent::init(); }
public function init() { if (Tools::getValue('cms_rewrite')) { $rewrite_url = Tools::getValue('cms_rewrite'); $id_cms = Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue(' SELECT `id_cms` FROM `' . _DB_PREFIX_ . 'cms_lang` WHERE `link_rewrite` = \'' . $rewrite_url . '\''); if ($id_cms > 0) { $_GET['id_cms'] = $id_cms; $_GET['noredirect'] = 1; } else { Tools::display404Error(); die; } } if ($id_cms = (int) Tools::getValue('id_cms')) { $this->cms = new CMS($id_cms, $this->context->language->id); } else { if ($id_cms_category = (int) Tools::getValue('id_cms_category')) { $this->cms_category = new CMSCategory($id_cms_category, $this->context->language->id); } } if (Configuration::get('PS_SSL_ENABLED') && Tools::getValue('content_only') && Tools::getValue('id_cms') == (int) Configuration::get('PS_CONDITIONS_CMS_ID') && Validate::isLoadedObject($this->cms)) { $this->ssl = true; } parent::init(); $this->canonicalRedirection(); // assignCase (1 = CMS page, 2 = CMS category) if (Validate::isLoadedObject($this->cms)) { $adtoken = Tools::getAdminToken('AdminCmsContent' . (int) Tab::getIdFromClassName('AdminCmsContent') . (int) Tools::getValue('id_employee')); if (!$this->cms->isAssociatedToShop() || !$this->cms->active && Tools::getValue('adtoken') != $adtoken) { header('HTTP/1.1 404 Not Found'); header('Status: 404 Not Found'); } else { $this->assignCase = 1; } } else { if (Validate::isLoadedObject($this->cms_category)) { $this->assignCase = 2; } else { header('HTTP/1.1 404 Not Found'); header('Status: 404 Not Found'); } } }
public function init() { if (Tools::getValue('cms_rewrite')) { $rewrite_url = Tools::getValue('cms_rewrite'); $sql = 'SELECT l.`id_cms` FROM `' . _DB_PREFIX_ . 'cms_lang` l LEFT JOIN `' . _DB_PREFIX_ . 'cms_shop` s ON (l.`id_cms` = s.`id_cms`) WHERE l.`link_rewrite` = \'' . $rewrite_url . '\''; if (Shop::isFeatureActive() && Shop::getContext() == Shop::CONTEXT_SHOP) { $sql .= ' AND s.`id_shop` = ' . (int) Shop::getContextShopID(); } $id_cms = (int) Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($sql); if ($id_cms > 0) { $_GET['id_cms'] = $id_cms; } else { //TODO: Do we need to send 404? header('HTTP/1.1 404 Not Found'); header('Status: 404 Not Found'); } } else { if (Tools::getValue('cms_category_rewrite')) { $rewrite_url = Tools::getValue('cms_category_rewrite'); $sql = 'SELECT `id_cms_category` FROM `' . _DB_PREFIX_ . 'cms_category_lang` WHERE `link_rewrite` = \'' . $rewrite_url . '\''; if (Shop::isFeatureActive() && Shop::getContext() == Shop::CONTEXT_SHOP) { $sql .= ' AND s.`id_shop` = ' . (int) Shop::getContextShopID(); } $id_cms_category = (int) Db::getInstance(_PS_USE_SQL_SLAVE_)->getValue($sql); if ($id_cms_category > 0) { $_GET['id_cms_category'] = $id_cms_category; } else { //TODO: Do we need to send 404? header('HTTP/1.1 404 Not Found'); header('Status: 404 Not Found'); } } } parent::init(); }