Renewal Link works but it doesn't renew for 30 days(NOT A BUG)

[prodigy]

I posted a test ad which last for 3 days. One day later, the script email me that my ad is gonna expire in 2 days.

After I click the link to extend the ad for another "30 days", the next day I get another email stating that my ad is gonna expire in 3 days time.

What is wrong ?? Renewal Link works but it doesn't renew for 30 days .... Even after I click on the renewal link several times every day, I still receive an email the very next day stating that the ad will expire in 3 days .........

Please help!!!

[prodigy]

No reply?

Since this is not working for me, can I disable the sendnotice cron job altogether? Will the ad still expire?

What I want is to silently expire the ads without sending emails since the email link does not renew for 30 days.

[Chuck S]

Hello

What is the link in the email for you? It definately works for me and your issue could be a bug posted on this forum and it has been fixed.

I would suggest you download the classifieds script and upload the templates and php files just to grab any bug fixes we have fixed

If you dont use sendnotice.php as a cron nope no ads are expired ever

The link in the email is like this

http://www.domain.com/classifieds/ed....php?resell=45

You will notice in editproduct.php for resell is this

list($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime();
$mon = $mon + 1;
$mday = $mday + $duration;
$enddate = mktime($hour,$min,$sec,$mon,$mday,$year);

$query = "UPDATE {$Globals['pp_db_prefix']}products SET status=0,approved='$moderate',enddate='$enddate' WHERE id='$resell'";
$resultc = ppmysql_query($query,$link);

So the ad definately gets renewed for the same duration it was set for.

[prodigy]

I know what is wrong now......

I have posted an ad, duration is 3 days. But I receive an email stating:
"If you have not sold your product and wish to renew your ad for an additional 30 days,"

The correct email I should receive is:
"If you have not sold your product and wish to renew your ad for an additional 3 days,"

Is it possible to change the line in sendnotice.php to the one below?:
$letter .= "If you have not sold your product and wish to renew your ad for an additional $duration days,";

[Chuck S]

Yes you may do so by editing the query that grabs the info about the product in sendnotice.php to add and define the duration field

[prodigy]

Can teach me how to do that? Cos the default email that states "30 days" is wrong and misleading.

[Chuck S]

Well I would be easier to rename the language string but try this and then replace 30 days with $duration

$query = "SELECT id,user,userid,title,enddate,duration FROM {$Globals['pp_db_prefix']}products WHERE enddate < $expire AND status=0 AND isauction=0";
$result = ppmysql_query($query,$link);

while ( list( $id, $user, $userid, $title, $enddate,$duration )= mysql_fetch_array($result) ) {

[prodigy]

Is this correct?:

$letter .= "If you have not sold your product and wish to renew your ad for an additional $duration days,";

[prodigy]

The email:

If you have not sold your product and wish to renew your ad for an AADITIONAL days, please click on the link below:

So can't just insert $duration in there ..... help ???

[Chuck S]

Look at the query again above. Just further down in the last query