This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
ini_set ("display_errors", 1); | |
$start_time = microtime(true); | |
// Configuration | |
if (file_exists('config.php')) { | |
require_once('config.php'); | |
} else { | |
die("Config file is not exists"); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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> |
OlderNewer