vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Paid subscription renewel email, how to change the time. (https://vborg.vbsupport.ru/showthread.php?t=255037)

huskermax 12-11-2010 01:26 AM
Paid subscription renewel email, how to change the time.
 
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.

Quote:
Originally Posted by Trevor Hannant (Post 2085617)
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.
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
    ");
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?

calorie 12-11-2010 01:56 AM
TIMENOW is the time when the script runs, and there are 86400 seconds in a 24 hour period, so this:
Code:
subscriptionlog.expirydate >= " . (TIMENOW + (86400 * 2)) . "
Means the expiry date is more than two days in the future from TIMENOW and this:
Code:
subscriptionlog.expirydate <= " . (TIMENOW + (86400 * 3)) . "
Means that the expiry date is less than three days in the future from TIMENOW.

So when the subscriptions cron runs it looks for subscription data from those active subscriptions set to expire between two and three days into the future.

Not sure what you mean by "change this to 2 weeks and then 3 days" but maybe you can now edit that query using the above information.

huskermax 12-12-2010 05:17 PM
Quote:
Originally Posted by calorie (Post 2132199)
TIMENOW is the time when the script runs, and there are 86400 seconds in a 24 hour period, so this:
Code:
subscriptionlog.expirydate >= " . (TIMENOW + (86400 * 2)) . "
Means the expiry date is more than two days in the future from TIMENOW and this:
Code:
subscriptionlog.expirydate <= " . (TIMENOW + (86400 * 3)) . "
Means that the expiry date is less than three days in the future from TIMENOW.

So when the subscriptions cron runs it looks for subscription data from those active subscriptions set to expire between two and three days into the future.

Not sure what you mean by "change this to 2 weeks and then 3 days" but maybe you can now edit that query using the above information.
That makes sense! Thanks for explaining that I can do what I need to do.


All times are GMT. The time now is 04:59 PM.

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.02382 seconds
  • Memory Usage 1,723KB
  • 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
  • (5)bbcode_code_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)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