Paid subscription renewel email, how to change the time.

[huskermax]

This is from vbulletin.com so I wanted to post this here to see if any one can help me out here as I describe below. Here is the original thread on the .com board.

Originally Posted by Trevor Hannant

The timing is hard-coded into the includes/cron/subscriptions.php file around line 48 (for 4.1). You can change this value here.

Note that we cannot officially support code modifications or forums running modified code. If you require support from us, we may ask you to re-upload all original files thus overwriting any changes you make.

Regarding mass moving users, you can use AdminCP > Users > Prune/Move Users to do this. There is no way to mass-subscribe people at this time however.

    // 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
    ");

Is it the "(TIMENOW + (86400 * 2)) . " and "(TIMENOW + (86400 * 3)) ."?

I got basic html knowledge and that is about it. Would like to change this to 2 weeks and then 3 days. Is this the right section?