vb.org Archive - Mini Mods - [OzzModz] Email Admin For Expiring Subscriptions

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)

[OzzModz] Email Admin For Expiring Subscriptions

Another mod brought to you by,
https://vborg.vbsupport.ru/external/2015/01/1.png

This mod will allow admins to get emails for their users paid subscriptions that are about to expire. This is a cron job, and it will sent the specified email addresses the email between 2 - 3 days before the subscription expires. This should allow you to perhaps entice the member somehow to renew their subscription. Because they may have not got the mail notifying them that it is about to expire.

The email title, as well as the message that is sent is phrased, so you can translate it to your language.

It is a simple installation upload the contents of the UPLOAD folder, then import the product XML, ozzmodz_sub_expiry

You can edit the options under the settings, [OzzModz] Email Admin For Expiring Subscriptions Settings

Complete Feature List

Option to disable the mod completely.
Option to set which emails to send the email to when a users paid subscription is about to expire.

Frequently Asked Questions.

Q. Why do I need such a thing, you ask?

A. Some admins might like to know before hand that a users paid subscription is going to expire.

Q. Can I send it to multiple email addresses??

A. Yes you can.

-------------------------------------------------------------------------------------------

If you like this mod please hit the https://vborg.vbsupport.ru/external/2015/08/1.png button to the right ---->

Please remember to click the, https://vborg.vbsupport.ru/external/2015/08/2.png button to the right if you installed the mod ---->

What does 'Marking As Installed' do ?

* It helps you to stay on top of updates - members who have installed modifications will be notified whenever new updates are available.

* For security issues - vbulletin.org will contact all members who have installed a modification whenever a security issue is brought to their attention.

* Marking a modification as installed also helps me know how many people are using my work, giving me extra incentive to provide more features and new modifications.

I appreciate the support!
-------------------------------------------------------------------------------------------

* History (Changelog) *
-------------------------
v1.0.0 (January 8, 2015)
- Initial public release.

Excellent mod, installed. Great idea.

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

This will be a handy mod. I am always looking at my subs to see if some have expired and most of the time I am too late and they have.

Will install this shortly.

Excellent, don't forget to mark as installed when you do.

*Idea

If possible, have option to allow admin to specify receiving email of subscriptions not renewed after X days of expiring - this way they know who has not renewed by said set # of days since subscription is marked as expired. Edit: This will allow the admin to reach out to them and see why they didn't renew and possibly work something out or give them a discount to regain their subscription.

Yeah that is something I can look into at some point. :)

Quote:

Originally Posted by ozzy47 (Post 2531370)

Excellent, don't forget to mark as installed when you do.

Never missed one yet. :)
Done.

Good deal, hope ya like it, and thanks for marking as installed. :)

Quote:

Originally Posted by TheLastSuperman (Post 2531373)

Actually now that I think about it, is the subscription information retained in the subscriptionlog table after it expires? I don't use them, so I do not know for sure.

Isn't that what status in that table is used for?

Edit: Why does that seem like grammar in a half shell ^ :p

PHP Code:


		
			
AND status = 1

This is the lines of code that runs on the cron.

Code:

if (is_array($subobj->subscriptioncache))

{

    foreach ($subobj->subscriptioncache as $key => $subscription)

    {

        // disable people :)

        $subscribers = $vbulletin->db->query_read("

            SELECT userid

            FROM " . TABLE_PREFIX . "subscriptionlog

            WHERE subscriptionid = $subscription[subscriptionid]

                AND expirydate <= " . TIMENOW . "

                AND status = 1

        ");



        while ($subscriber = $vbulletin->db->fetch_array($subscribers))

        {

            $subobj->delete_user_subscription($subscription['subscriptionid'], $subscriber['userid'], -1, true);

        }

    }

So if I read that right, it deletes the subscription.

I read the same... so then perhaps add a field to your mod, when it emails them it adds their userid and subscription type then query said table every 10 days or so via cron, if their userid is present it emails admin or something like that still just spitting out ideas. One way to work around the deletion of subs and also retain prior sub info in a sense but like I said twas just an idea up to you IF you want to go through the trouble.

Perhaps, if their is enough interest. but it seems like a lot of trouble to go through. IMO the records should not be deleted anyway, they should stay in the DB untill I of course want to thin out the table, then I should be able to run a cron, to delete subscriptions older than X.

To bad they did not think of it when they built the system.

I like the idea proposed by Superman. :up:

Cool, that's two. :)

Damn, can you read my mind? :D I've been waiting for months for this, thank you very much ozzy :)

I know something like this has been asked for quite a few times over the years, so I figured why not. :p

Thanks for marking as installed. :)

Quote:

Originally Posted by TheLastSuperman (Post 2531399)

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?

Quote:

Originally Posted by ozzy47 (Post 2531451)

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.

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.

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.

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

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

7 days works for me.

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

Quote:

Originally Posted by Charis (Post 2532319)

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

Uhhh, what?

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. :)

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01373 seconds Memory Usage 1,801KB 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 (1)bbcode_code_printable (1)bbcode_php_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (29)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
Messages: