vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Mini Mods - [OzzModz] Email Admin For Expiring Subscriptions (https://vborg.vbsupport.ru/showthread.php?t=316513)

TheLastSuperman 01-09-2015 11:26 AM

Quote:

Originally Posted by ozzy47 (Post 2531451)
I just made a subscription expire, and it seems to just update the DB and set status to 0

So could someone that actually runs paid subscriptions check their DB and see if it holds all the expired ones?

One would assume but you know what they say about that, issue for me yesterday was localhost w/o any subscriptions and I don't just login to clients sites to test things blindly out of curiosity so with that being said I'll setup a paid subscription on localhost later and fiddle with it if I have time just depends on how much coffee's left in my bucket and whether or not I must go pickup coffeemate creamer or not - rough morning's w/o my coffee now deary lol.

Edit: If it deletes their actual sub though... then would not all members (even if they had subbed or not) who did not have an active sub show as expired? If we think of it that way then yes so then w/o something added to track it you might be sending an email or contacting a member who never had a sub to begin with, only because their "status" is set to 0.

dknelson 01-09-2015 11:33 AM

FANTASTIC. Thank you so very much. Installed. I use paid subscriptions and have for several years. I will do some checking on the database for you but the way mine work is that the user is put in a different user group automatically when their subscription expires so they are not completely removed from the site. They just lose privileges. All their profile information and etc. is still there. If they renew later, everything is restored.

CharlieDelta 01-09-2015 02:13 PM

I have lots of paid subs and will have a peek in the db to see what is there.
I have my subs set up as "Recurring" so not sure if this will make a difference as well.
Will post what I find.

CharlieDelta 01-09-2015 02:41 PM

Looking at my DB and it has stored all expired subs.

ozzy47 01-09-2015 10:15 PM

Cool, I can then try and work out the query for subs that have expired. Would seven days be a good point?

dknelson 01-09-2015 11:53 PM

7 days works for me.

Charis 01-13-2015 04:07 PM

What to say? Thanks, again.
Haven't been bored from so many "thank you"?

CharlieDelta 01-13-2015 04:50 PM

Quote:

Originally Posted by Charis (Post 2532319)
What to say? Thanks, again.
Haven't been bored from so many "thank you"?

Uhhh, what?

ozzy47 01-13-2015 10:41 PM

Quote:

Originally Posted by Charis (Post 2532319)
What to say? Thanks, again.
Haven't been bored from so many "thank you"?

Glad you like it, and thanks for marking as installed. :)


All times are GMT. The time now is 08:20 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.01241 seconds
  • Memory Usage 1,728KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (9)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