Renewal question

[hel68c +]

How does this script manage sending out the Email X number of days before the ad expires?

how the system know when to send the signal to execute this script?

[Eric Barnes +]

It uses the file includes/cron.php which determines when emails should be sent and when listings should be deleted.

It knows by using the current date and subtracting x number of days to get ones that need to be emailed.

[hel68c +]

As I understand in the script cron.php, it compares the expiration date of the ads less the number of days to expire with today date and sends an e-mail

It executes this script once a day.

So the customer receives a single email once for renewal.

Is this the way it works?

I ask this information because I work with two languages on my site and I wonder how I have to tell him to send an email in a specific language.

[Eric Barnes +]

Yes. It runs once a day and if it emails them then it updates the listing table and marks that listing that it has been sent.

I am not sure how you could determine which language it was written in. Maybe use the category.

[hel68c +]

I noticed that the renewal notification is not reset.

The field notified remain to Y.

Do you have any advise?

[hel68c +]

I'm looking at the code and I noticed that the function that puts notified to 'N' is the function updateNotification.

PHP Code:

    function updateNotification($orderid)
    {
        global $db;
        $sSQL="UPDATE ".PREFIX."listings SET notified='N' WHERE orderID=".$orderid;
        $db->query($sSQL);
echo "update notification & orderid= ".$orderid; 


I placed an echo to look at the $orderid variable and it return 773.

This is the last order number that I did. This number does not appear in the listings of the ad. The number that appear in the field orderID in listing Table is 237 (the first order number)

So the function can't update the listings.

[Eric Barnes +]

In your signature it shows as v4.0.8 so I would recommend downloading v4.0.9 and then replacing these template files:
user/userbrowselistings.tpl
renew/ - every file in this folder.

[hel68c +]

I replace the new 4.09 step1.tpl step2.tpl and userbrowselisting.tpl with the old version 4.08 and samething, the notified field can't be reset to 'N'

[juven14 +]

Did you upgrade to 4.0.9 or just copy over those template files?

[hel68c +]

I just copy the files.

I made too many changes to the files to copy all 4.09.