Stop emails regarding paid sub's.

[josh_B]

Can this be done so it does not send out reminders?

Thanks

[Marco van Herwaarden]

You would need to edit the includes/cron/subscriptions.php file and comment out:
// 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
");

vbmail_start();
while ($subscriptions_reminder = $vbulletin->db->fetch_array($subscriptions_reminders))
{
require_once(DIR . '/includes/functions_misc.php');
$subscription_title = fetch_phrase('sub' . $subscriptions_reminder['subscriptionid'] . '_title', 'subscription', '', true, true, $subscriptions_reminder['languageid']);

$username = unhtmlspecialchars($subscriptions_reminder['username']);
eval(fetch_email_phrases('paidsubscription_reminde r', $subscriptions_reminder['languageid']));
vbmail($subscriptions_reminder['email'], $subject, $message);
}
vbmail_end();

[josh_B]

Thanks