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...





LinkBack URL
About LinkBacks









Bookmarks