vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   Confirmation about reminder timeframe in subscriptions (https://vborg.vbsupport.ru/showthread.php?t=298085)

stardotstar 05-13-2013 01:27 AM

Confirmation about reminder timeframe in subscriptions
 
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
        ");

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

Code:

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


All times are GMT. The time now is 08:59 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03055 seconds
  • Memory Usage 1,708KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (1)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete