problem trying to get two free vqmods to work at the same-time on opencart V1.5.6.4

Code: Select all

<?xml version="1.0" encoding="UTF-8"?>
<modification>
<id><![CDATA[Products by Category - Show option quantity]]></id>
<version><![CDATA[OC v.1.5.6.x]]></version>
<vqmver><![CDATA[2.4.1]]></vqmver>
<author><![CDATA[Shawn Noh - hakim_jz]]></author>

<file name="admin/controller/catalog/product.php">
<operation error="log">
<search position="replace"><![CDATA['quantity'   => $result['quantity'],]]></search>
<add><![CDATA[
		'quantity'   => $result['quantity']. ($result['option_quantity'] ? '<br><b>Summary Option Quantity = '. $result['sum_opt_qty'].'</b><br>' . str_replace(',','<br>',$result['option_quantity']) : ''),
]]></add>
</operation>

<operation error="log">
<search position="before"><![CDATA[$this->template = 'catalog/product_list.tpl';]]></search>
<add><![CDATA[
		$this->load->model('catalog/category');
		$this->data['categories'] = $this->model_catalog_category->getCategories(array());
		$this->data['current_category'] = $filter_category;
]]></add>
</operation>

<operation error="log">
<search position="after"><![CDATA[protected function getList() {]]></search>
<add><![CDATA[
		if (isset($this->request->get['cid'])) {
		$filter_category = intVal($this->request->get['cid']);
		} else {
		$filter_category = 0;
		}
]]></add>
</operation>

<operation error="log">
<search position="after"><![CDATA['filter_status'   => $filter_status,]]></search>
<add><![CDATA[
		'filter_category'   => $filter_category,
]]></add>
</operation>	
</file>

<file name="admin/model/catalog/product.php">
<operation error="log">
<search position="replace"><![CDATA[$sql = "SELECT * FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id)";]]></search>
<add><![CDATA[
		$sql = "SELECT p.product_id, p.image, p.model, p.quantity, p.price, p.status, pd.name, SUM(pov.quantity) as 'sum_opt_qty', GROUP_CONCAT( ovd.name,' : ', pov.quantity ORDER BY ovx.sort_order, ovd.option_id, ovd.name ASC ) AS 'option_quantity'
		FROM " . DB_PREFIX . "product p
		LEFT JOIN " . DB_PREFIX . "product_description pd ON p.product_id = pd.product_id AND pd.language_id = '" . $this->config->get('config_language_id') . "'
		LEFT JOIN " . DB_PREFIX . "product_option_value pov ON p.product_id = pov.product_id
		LEFT JOIN " . DB_PREFIX . "option_value_description ovd ON pov.option_value_id = ovd.option_value_id AND ovd.language_id = '" . $this->config->get('config_language_id') . "'
		LEFT JOIN " . DB_PREFIX . "option_value ovx ON ovd.option_value_id = ovx.option_value_id";
]]></add>
</operation>

<operation error="log">
<search position="before"><![CDATA[if (!empty($data['filter_category_id'])) {]]></search>
<add><![CDATA[
		if (!empty($data['filter_category'])) {
		$sql .= " INNER JOIN " . DB_PREFIX . "product_to_category pc ON (p.product_id=pc.product_id AND pc.category_id=".intVal($data['filter_category']).")";
		}
]]></add>
</operation>
</file>
		
<file name="admin/view/template/catalog/product_list.tpl">
<operation error="log">
<search position="replace"><![CDATA[<h1><img src="view/image/product.png" alt="" /> <?php echo $heading_title; ?>]]></search>
<add><![CDATA[
		<h1><img src="view/image/product.png" alt="" /> <?php echo $heading_title; ?> On
		<select id="select_category">
		<option value="0">All Categories</option>
		<?php
		foreach($categories as $category) {
		$category_id = intVal($category['category_id']);
		$category_name = $category['name'];
		$selected = ($current_category==intVal($category['category_id']))?"selected":"";
		echo "<option value='{$category_id}' {$selected}>{$category_name}</option>";
		}
		?>
		</select>
]]></add>
</operation>

<operation error="log">
<search position="before"><![CDATA[//--></script>]]></search>
<add><![CDATA[
		$("#select_category").change(function() {
		location.href="<?php echo html_entity_decode($this->url->link('catalog/product', 'token=' . $this->session->data['token'] . '', 'SSL'));?>&cid="+$(this).val();
		});
]]></add>
</operation>

<operation error="log">
<search position="after"><![CDATA[url = 'index.php?route=catalog/product&token=<?php echo $token; ?>';]]></search>
<add><![CDATA[
		url += '&cid=<?php echo $current_category;?>';
]]></add>
</operation>
</file>
</modification>