Paid Subscription Expiration Email - 2-Day notice hard-coded?!

[kyrnel]

I am having trouble finding the code that generates the Paid Subscription expiration notice 2 days before it expires. I assume that if I can find the code, I will be able to easily modify the number of days to set the notice email to occur earlier.

Anyone know where this code resides and if the edit will be as simple as I think it will?

Thanks!

[UPDATE]
Actually I found a search tool that will search for all the text in the PHP files and was able to locate the code.

it is in /includes/cron/subscriptions.php

Here is the code that needs to be modified:

PHP Code:

    // time for the reminders
    $subscriptions_reminders = $vbulletin->db->query_read("
        SELECT subscriptionlog.subscriptionid, subscriptionlog.userid, subscriptionlog.expirydate, user.username, user.email, user.languageid
        FROM " . TABLE_PREFIX . "subscriptionlog AS subscriptionlog
        LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = subscriptionlog.userid)
        WHERE subscriptionlog.expirydate >= " . (TIMENOW + (86400 * 2)) . "
            AND subscriptionlog.expirydate <= " . (TIMENOW + (86400 * 3)) . "
            AND status = 1
    "); 


Just replace the "2" and the "3" with the number of days you want the reminder to go out. There is a range instead of a specific number since the cron only runs once per day.
I put 30 and 31 in there.

Enjoy.