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();
}
