Request a Review

[michael_s]

For some reason last_modified value for the purchased items didnt worked for me so i changed a little code to look not in last modified date but in the date item was purchased, everything else works :



i installed this contribution and it didnt worked for me so i modified it a bit:

==========================
in reviews_mail.php FIND:
===========================

$orders_query = tep_db_query ("select o.customers_name,
o.customers_email_address,
o.orders_id,
o.last_modified
from " . TABLE_ORDERS . " o,
" . TABLE_CUSTOMERS . " c
where o.orders_status = '3'
and o.reminder_sent = '0'
and c.customers_id = o.customers_id
" . $newsletter_only . "
");


==================
AND REPLACE WITH:
==================

$orders_query = tep_db_query ("select o.customers_name,
o.customers_email_address,
o.orders_id,
o.date_purchased
from " . TABLE_ORDERS . " o,
" . TABLE_CUSTOMERS . " c
where o.orders_status = '3'
and o.reminder_sent = '0'
and c.customers_id = o.customers_id
" . $newsletter_only . "
");



==================================
As you can notice diference is in last_modified ( this value never modifies on purchase so i changed it to date_purchased
==================================





=====
FIND:
=====

if (strtotime ($orders_array['last_modified']) < $timestamp) { // Delay time has expired


=========
REPLACE:
=========


if (strtotime ($orders_array['date_purchased']) < $timestamp) { // Delay time has expired

More...