IP-CAM

<modification>

    <id>Cache category data to speed up page load for store with many categories and sub categories.</id>
    <version>1.0.1</version>
    <vqmver>2.3.2</vqmver>
    <author>Weismann Web - www.weismannweb.com</author>

    <file name="catalog/controller/extension/module/category.php">
        <operation>
            <search position="after"><![CDATA[

IP-CAM

DELETE t1,t2,t3,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15

FROM `oc_product` t1

LEFT JOIN `oc_product_attribute` t2 ON(t1.product_id=t2.product_id)

LEFT JOIN `oc_product_description` t3 ON(t1.product_id=t3.product_id)

LEFT JOIN `oc_product_discount` t4 ON(t1.product_id=t4.product_id)

IP-CAM

<?xml version="1.0" encoding="utf-8"?>
<modification>
    <name>Product discount options</name>
    <version>1.0.0</version>
    <link>https://e-m.com.ua</link>
    <author>em</author>
    <code>product_discount_options</code>
  	<file path="catalog/model/catalog/product.php">
        <operation error="skip">
            <search><![CDATA[$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "product_discount WHERE product_id = '" . (int)$product_id . "' AND customer_group_id = '" . (int)$this->config->get('config_customer_group_id') . "' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY quantity ASC, priority ASC, price ASC");]]></search>