[stardotstar]

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

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

does this say that subscription reminders are sent out by the cron job if there are any expiring more than 48 hours and less than 72 hours from TIMENOW?
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

WHERE subscriptionlog.expirydate >= " . (TIMENOW + (86400 * 6)) . "
			AND subscriptionlog.expirydate <= " . (TIMENOW + (86400 * 7)) . "

And finally, is there any variable I can call upon in the template that will tell the user what day their subscription will expire on? At the moment I will tell them it will expire in (3 or 7) days...

Best regards,
Will