public static function setPageViewed($id_page) { $id_date_range = DateRange::getCurrentRange(); $context = Context::getContext(); // Try to increment the visits counter $sql = 'UPDATE `' . _DB_PREFIX_ . 'page_viewed` SET `counter` = `counter` + 1 WHERE `id_date_range` = ' . (int) $id_date_range . ' AND `id_page` = ' . (int) $id_page . ' AND `id_shop` = ' . (int) $context->shop->id; Db::getInstance()->execute($sql); // If no one has seen the page in this date range, it is added if (Db::getInstance()->Affected_Rows() == 0) { Db::getInstance()->insert('page_viewed', array('id_date_range' => (int) $id_date_range, 'id_page' => (int) $id_page, 'counter' => 1, 'id_shop' => (int) $context->shop->id, 'id_shop_group' => (int) $context->shop->id_shop_group)); } }
public static function setPageViewed($id_page) { $id_date_range = DateRange::getCurrentRange(); // Try to increment the visits counter Db::getInstance()->Execute(' UPDATE `' . _DB_PREFIX_ . 'page_viewed` SET `counter` = `counter` + 1 WHERE `id_date_range` = ' . intval($id_date_range) . ' AND `id_page` = ' . intval($id_page)); // If no one has seen the page in this date range, it is added if (Db::getInstance()->Affected_Rows() == 0) { Db::getInstance()->Execute(' INSERT INTO `' . _DB_PREFIX_ . 'page_viewed` (`id_date_range`,`id_page`,`counter`) VALUES (' . intval($id_date_range) . ',' . intval($id_page) . ',1)'); } }