The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
![]()
Hi all,
I want to improve the default template for paid subscription reminders as it is a bit abrupt and need to know how far in advance the reminder is sent of their impending expiry. I look in subscriptions.php in includes/cron and find 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 "); So the reminder is sent out with less than 3 days to expiry? If I wanted to change that to be a week's notice (7 days) would that just be Code:
WHERE subscriptionlog.expirydate >= " . (TIMENOW + (86400 * 6)) . " AND subscriptionlog.expirydate <= " . (TIMENOW + (86400 * 7)) . " Best regards, Will |
![]() |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|