Canonical link with categories

Code: Select all

<modification>
	<id>Canonical Product URL with Category Path</id>
	<version>1.0</version>
	<vqmver>2.1.5</vqmver>
	<author>https://www.kdnovelties.com</author>
	<file name="catalog/controller/product/product.php">
		<operation>
			<search position="replace"><![CDATA[$this->document->addLink($this->url->link('product/product', 'product_id=' . $this->request->get['product_id']), 'canonical');]]></search>
			<add><![CDATA[if($this->model_catalog_product->getCategoryPath($this->request->get['product_id'])!='0'){
    $this->document->addLink($this->url->link('product/product', 'path=' . $this->model_catalog_product->getCategoryPath($this->request->get['product_id']) . '&product_id=' . $this->request->get['product_id']), 'canonical');
}else{
    $this->document->addLink($this->url->link('product/product', 'product_id=' . $this->request->get['product_id']), 'canonical');
}]]></add>
		</operation>
		<operation>
	<!-- CORRECTS PRODUCT PATH FOR ADDTHIS LINK -->
			<search position="replace"><![CDATA[
				$data['share'] = $this->url->link('product/product', 'product_id=' . (int)$this->request->get['product_id']);
			]]></search>
			<add><![CDATA[
				$data['share'] = $this->url->link('product/product', 'path=' . $this->model_catalog_product->getCategoryPath($this->request->get['product_id']) . '&product_id=' . (int)$this->request->get['product_id']);
			]]></add>
		</operation>
	</file>

	<file name="catalog/model/catalog/product.php">
		<operation>
			<search position="before" offset="1"><![CDATA[	public function getProduct($product_id) {]]></search>
			<add><![CDATA[
   public function getCategoryPath($product_id) {

	$query = $this->db->query("SELECT category_id AS catid FROM " . DB_PREFIX . "category WHERE category_id IN (SELECT category_id FROM " . DB_PREFIX . "product_to_category WHERE product_id = '" . (int)$product_id . "' ) ORDER BY sort_order asc LIMIT 1");

	$babybooks = array(390, 33, 24, 55, 56, 249, 57);
	if($query->row['catid'] != 8 || in_array($product_id, $babybooks)){
		// Do another query to get/set minimum child category
		$query = $this->db->query("SELECT category_id AS catid FROM " . DB_PREFIX . "category WHERE category_id IN (SELECT MIN(category_id) FROM " . DB_PREFIX . "product_to_category WHERE product_id = '" . (int)$product_id . "' ) ORDER BY sort_order asc LIMIT 1");

		$cat = $this->db->query("SELECT model FROM " . DB_PREFIX . "product WHERE product_id = '" . (int)$product_id . "' LIMIT 1");
		if(strstr($cat->row['model'], 'GS0')) {
			$query->row['catid'] = 16;
		    } elseif(strstr($cat->row['model'], 'GB0')) {
			$query->row['catid'] = 29;
		}
	} 

     
      if(array_key_exists('catid', $query->row)) {
         $path = array();
         $path[0] = $query->row['catid'];
         
         $query = $this->db->query("SELECT parent_id AS pid FROM " . DB_PREFIX . "category WHERE category_id = '" . (int)$path[0] . "'");

         $parent = $query->row['pid'];
         
         $p = 1;
         while($parent>0){
            $path[$p] = $parent;
            
            $query = $this->db->query("SELECT parent_id AS pid FROM " . DB_PREFIX . "category WHERE category_id = '" . (int)$parent . "'");
            $parent = $query->row['pid'];
            $p++;
         }
      
         $path = array_reverse($path);
         
         $fullpath = '';
         
         foreach($path as $val){
            $fullpath .= '_'.$val;
         }
      
         return ltrim($fullpath, '_');
      }else{
         return '0';
      }
   }]]></add>
		</operation>
	</file>

	<file name="catalog/controller/product/category.php">
		<operation>
			<search position="replace" offset="11"><![CDATA[// http://googlewebmastercentral.blogspot.com/2011/09/pagination-with-relnext-and-relprev.html]]></search>
			<add><![CDATA[if ($page == 1) {
			    $this->document->addLink($this->url->link('product/category', 'path=' . $this->request->get['path'], true), 'canonical');
			} elseif ($page == 2) {
			    $this->document->addLink($this->url->link('product/category', 'path=' . $this->request->get['path'], true), 'prev');
			} else {
			    $this->document->addLink($this->url->link('product/category', 'path=' . $this->request->get['path'] . '&page='. ($page - 1), true), 'prev');
			}

			if ($limit && ceil($product_total / $limit) > $page) {
			    $this->document->addLink($this->url->link('product/category', 'path=' . $this->request->get['path'] . '&page='. ($page + 1), true), 'next');
			}]]></add>
		</operation>
	</file>

</modification>

Code: Select all

<search position="replace" offset="11"><![CDATA[// http://googlewebmastercentral.blogspot.com/2011/09/pagination-with-relnext-and-relprev.html]]></search>