Warning: mysqli::set_charset

Code: Select all

// SEO
// cache seo keywords in constant by one query in startup
define('USE_SEO_CACHE', true);
// additionally, store the seo keywords cache in file (might actually slow things down, reading cache file vs query)
define('USE_SEO_CACHE_FILE', false);

Code: Select all

		// OpenBay Pro
		$this->registry->set('openbay', new Openbay($this->registry));

Code: Select all

		// SEO CACHE if seo urls enabled and seo cache enabled
		if ($this->config->get('config_seo_url') && USE_SEO_CACHE) {
			$pairs = false;
			// define cache storage by store and language
			$seo_pair_cache_file = 'seo.'.$this->config->get('config_store_id').'.'.$this->config->get('config_language_id');
			// read cache storage if enabled
			if (USE_SEO_CACHE_FILE) $pairs = $this->cache->get($seo_pair_cache_file);
			// if no storage or no storage enabled fetch all seo query/keyword pairs for store and language
			if (!$pairs) {
				$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "seo_url WHERE store_id = '" . (int)$this->config->get('config_store_id') . "' AND language_id = '" . (int)$this->config->get('config_language_id') . "' order by keyword ASC ");
				$pairs = array();
				// build query/keyword pairs
				foreach ($query->rows as $row) $pairs[$row['query']] = $row['keyword'];
				// store the pairs in file if enabled
				if (USE_SEO_CACHE_FILE) $this->cache->set($seo_pair_cache_file, $pairs);
				// free memory
				unset ($query);
			}
			// define the pair constant
			global $seo_pairs;
			$seo_pairs = $pairs;
			// free memory
			unset($pairs);
		}

Code: Select all

	public function rewrite($link) {

Code: Select all

global $seo_pairs;

Code: Select all

		foreach ($data as $key => $value) {
			if (isset($data['route'])) {
				if (($data['route'] == 'product/product' && $key == 'product_id') || (($data['route'] == 'product/manufacturer/info' || $data['route'] == 'product/product') && $key == 'manufacturer_id') || ($data['route'] == 'information/information' && $key == 'information_id')) {
					$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "seo_url WHERE `query` = '" . $this->db->escape($key . '=' . (int)$value) . "' AND store_id = '" . (int)$this->config->get('config_store_id') . "' AND language_id = '" . (int)$this->config->get('config_language_id') . "'");

					if ($query->num_rows && $query->row['keyword']) {
						$url .= '/' . $query->row['keyword'];

						unset($data[$key]);
					}
				} elseif ($key == 'path') {
					$categories = explode('_', $value);

					foreach ($categories as $category) {
						$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "seo_url WHERE `query` = 'category_id=" . (int)$category . "' AND store_id = '" . (int)$this->config->get('config_store_id') . "' AND language_id = '" . (int)$this->config->get('config_language_id') . "'");

						if ($query->num_rows && $query->row['keyword']) {
							$url .= '/' . $query->row['keyword'];
						} else {
							$url = '';

							break;
						}
					}

					unset($data[$key]);
				}
			}
		}

Code: Select all

		foreach ($data as $key => $value) {
			if (isset($data['route'])) {
				if (($data['route'] == 'product/product' && $key == 'product_id') || (($data['route'] == 'product/manufacturer/info' || $data['route'] == 'product/product') && $key == 'manufacturer_id') || ($data['route'] == 'information/information' && $key == 'information_id')) {
					if (USE_SEO_CACHE && $seo_pairs) {
						if (isset($seo_pairs[$key . '=' . $value])) {
							$url .= '/' . $seo_pairs[$key . '=' . $value];
							unset($data[$key]);
						}
					} else {
						$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "seo_url WHERE `query` = '" . $this->db->escape($key . '=' . (int)$value) . "' AND store_id = '" . (int)$this->config->get('config_store_id') . "' AND language_id = '" . (int)$this->config->get('config_language_id') . "'");
						if ($query->num_rows && $query->row['keyword']) {
							$url .= '/' . $query->row['keyword'];
							unset($data[$key]);
						}
					}
				} elseif ($key == 'path') {
					$categories = explode('_', $value);
					foreach ($categories as $category) {
						if (USE_SEO_CACHE && $seo_pairs) {
							if (isset($seo_pairs['category_id=' . $category])) {
								$url .= '/' . $seo_pairs['category_id=' . $category];
								unset($data[$key]);
							} else {
								$url = '';
								break;
							}
						} else {
							$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "seo_url WHERE `query` = 'category_id=" . (int)$category . "' AND store_id = '" . (int)$this->config->get('config_store_id') . "' AND language_id = '" . (int)$this->config->get('config_language_id') . "'");
							if ($query->num_rows && $query->row['keyword']) {
								$url .= '/' . $query->row['keyword'];
							} else {
								$url = '';
								break;
							}
						}
					}
					unset($data[$key]);
				}
			}
		}

Code: Select all

define('USE_SEO_CACHE_FILE', true);

Code: Select all

$this->cache->delete('product');

Code: Select all

$this->cache->delete('seo');