vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Miscellaneous Hacks - Subscription Notifications -- Drive paid subscriptions & renewals (https://vborg.vbsupport.ru/showthread.php?t=179864)

Ted S 02-16-2011 04:59 PM

Quote:

Originally Posted by vitrag24 (Post 2162704)
update for vbulletin 4 plz?

It's been out for over almost a year... https://vborg.vbsupport.ru/showthread.php?t=241224

Drareg 05-11-2013 05:56 PM

A question, users are notified when a subscription will expire, but what about notifying an Admin when a users subscription will expire?

I could not find anything about this, just a simple email to the admin to notify him or is this just a silly question?

Does this mod also work on 3.8.4?

Ted S 05-11-2013 07:33 PM

Quote:

Originally Posted by Drareg (Post 2421360)
A question, users are notified when a subscription will expire, but what about notifying an Admin when a users subscription will expire?

I could not find anything about this, just a simple email to the admin to notify him or is this just a silly question?

Does this mod also work on 3.8.4?

This mod does not notify admins.

Drareg 05-12-2013 10:03 AM

I thought so. We do not use PayPal or anything else, just members pay per bank. But when the member gets an expire email, it would just be nice that the Admin also gets a notification of this. I could not find anything so far about this, suggestions?

Maybe it's simpel by coding the subscriptions.php in includes/cron and add the Admins email address, but I'm not a coder unfortunatly.

PHP Code:

    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'''truetrue$subscriptions_reminder['languageid']);

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

Something else, below in subscriptions.php is this line:
PHP 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
    "
); 

Can I change TIMENOW + (86400 * 2) and TIMENOW + (86400 * 3) to longer periods without problems? For example TIMENOW + (86400 * 7) and TIMENOW + (86400 * 14)

Thanks.

Ted S 05-12-2013 04:39 PM

Quote:

Originally Posted by Drareg (Post 2421500)
I thought so. We do not use PayPal or anything else, just members pay per bank. But when the member gets an expire email, it would just be nice that the Admin also gets a notification of this. I could not find anything so far about this, suggestions?

Maybe it's simpel by coding the subscriptions.php in includes/cron and add the Admins email address, but I'm not a coder unfortunatly.

PHP Code:

    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'''truetrue$subscriptions_reminder['languageid']);

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

Something else, below in subscriptions.php is this line:
PHP 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
    "
); 

Can I change TIMENOW + (86400 * 2) and TIMENOW + (86400 * 3) to longer periods without problems? For example TIMENOW + (86400 * 7) and TIMENOW + (86400 * 14)

Thanks.

You'll need to write a script to query the susbcriptions, generate an email and save it as a cron. Questions on coding like that are far better directed to the coding forum here where you get access to all sorts of individuals rather than a support thread like this one which is visited by very few developers.

Drareg 05-12-2013 04:57 PM

Thanks Ted for the effort, I will do so.

jnmann 02-16-2014 04:08 PM

Can this work on 4.2.1?

Ted S 02-17-2014 02:18 AM

Quote:

Originally Posted by jnmann (Post 2481547)
Can this work on 4.2.1?

3.x mods do not work on 4.x

Of course the 4.x version will work fine...


All times are GMT. The time now is 04:46 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.01175 seconds
  • Memory Usage 1,765KB
  • 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
  • (4)bbcode_php_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (8)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete