Auto add rewards not working when paying by PayPal

Code: Select all

<?xml version="1.0" encoding="utf-8"?>

<modification>



	<id>Automatically Add Reward points when purchased</id>

	<version>200.1</version>

	<vqmver>2.5.1</vqmver>

	<author>Qphoria@gmail.com</author>

	

	<file name="catalog/controller/checkout/success.php">



		<operation info="auto add reward points">

            <search position="after"><![CDATA[

			$this->cart->clear();

            ]]></search>

            <add><![CDATA[

		$order_id = $this->session->data['order_id'];

		$description = 'Order ID: #' . $order_id;

		$customer_id = $this->customer->getId();

		$order_query = $this->db->query("SELECT SUM(reward) as reward FROM `" . DB_PREFIX . "order_product` WHERE order_id = '" . (int)$order_id . "'");

		$order_info = $order_query->row;

		$query = $this->db->query("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "customer_reward WHERE order_id = '" . (int)$order_id . "'");

		$reward_total = $query->row['total'];

		if (!$reward_total && (int)$order_info['reward'] > 0) {

			$this->db->query("INSERT INTO " . DB_PREFIX . "customer_reward SET customer_id = '" . (int)$customer_id . "', order_id = '" . (int)$order_id . "', points = '" . (int)$order_info['reward'] . "', description = '" . $this->db->escape($description) . "', date_added = NOW()");

		}

			]]></add>

        </operation>

	</file>

</modification>





	

Code: Select all

<?xml version="1.0" encoding="utf-8"?>
<modification>
<id>Automatically Add Reward points when purchased</id>
<version>200.1</version>
<vqmver>2.5.1</vqmver>
<author>Qphoria@gmail.com</author>

<file name="catalog/controller/checkout/success.php">
<operation error="log">
<search position="after"><![CDATA[$this->cart->clear();]]></search>
<add><![CDATA[
	$order_id = $this->session->data['order_id'];
	$description = 'Order ID: #' . $order_id;
	$customer_id = $this->customer->getId();
	$order_query = $this->db->query("SELECT SUM(reward) as reward FROM `" . DB_PREFIX . "order_product` WHERE order_id = '" . (int)$order_id . "'");
	$order_info = $order_query->row;
	$query = $this->db->query("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "customer_reward WHERE order_id = '" . (int)$order_id . "'");
	$reward_total = $query->row['total'];
	if (!$reward_total && (int)$order_info['reward'] > 0) {
	$this->db->query("INSERT INTO " . DB_PREFIX . "customer_reward SET customer_id = '" . (int)$customer_id . "', order_id = '" . (int)$order_id . "', points = '" . (int)$order_info['reward'] . "', description = '" . $this->db->escape($description) . "', date_added = NOW()");
	}
]]></add>
</operation>
</file>
</modification>