Miscellaneous Hacks - Instant New Thread Notification

= New Thread Notification =

Description

Very simple, it adds instant email notification for forums. If you are subscribed to a forum using instant email notification, whenever a new thread is posted you will be sent an email containing the details and the thread text.


Options: (AdminCP > vBulletin Options > New Thread Notification)

Enable new thread notifications?
Choose Yes to enable instant email notification for new threads.

Allow new thread notification for Usergroups:
Enter the IDs of the usergroups you want to allow to subscribe to instant new thread email notifications, separated by commas. (i.e. 1,2,3)

If you only want to exclude usergroups instead of including them, leave this blank to allow everyone to subscribe to instant new thread notifications except those listed below.

Do NOT allow new thread notification for Usergroups:
Enter the IDs of the usergroups you want to exclude from subscribing to instant new thread email notifications, separated by commas. (i.e. 1,2,3) Leave blank to not exclude usergroups.

Allow new thread notification for Forums:
Enter the IDs of the forums you want to allow subscribing to instant new thread email notifications, separated by commas. (i.e. 1,2,3)

If you only want to exclude forums instead of including them, leave this blank to allow instant new thread notifications in every forum except those listed below.

Do NOT allow new thread notification for Forums:
Enter the IDs of the forums you want to exclude from subscribing to instant new thread email notifications, separated by commas. (i.e. 1,2,3) Leave blank to not exclude forums.

Use mailqueue?
Choose Yes for new thread notifications to use mailqueueing as per your settings (Recommended for all except very low traffic forums). Choosing No will bypass mailqueueing and send all emails instantly.


Installation Instructions:
1. Go to AdminCP > Plugins & Products > Manage Products > Add/Import Product.
2. Upload the new_thread_subscription_xxx.xml file.
Done!

To subscribe to new thread notifications just subscribe to a forum as normal. The new option has been added to the list.


Donations

If you have a pressing wish to donate money to me (and of course, you do) to say thank you and to possibly encourage more future work then you can do via the link below. Also, you will go to heaven.

http://redtyger.co.uk/donations.php

Don't panic! The donations link is only hosted on my website so it can be encrypted and not open my email address to spammers.


Changelog
v1.00 Initial release
v1.01 Fixed bug where Instant Email Subscription would appear twice.
v1.02 Fixed bug where a database error would occur when nobody is subscribed to the forum the thread is being posted in.

[WebmasterSimds]

There is a problem with this and the Vboard Newer version. I get a BD error when someone wants to post, and here it is
================================================== ============
Database error in vBulletin 3.6.5:

Invalid SQL:

SELECT email, username
FROM user
WHERE userid IN ();

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3
Error Number : 1064
Date : Wednesday, March 14th 2007 @ 03:20:43 AM
Script : http://www.xxxxxxx.com/Ss/newthread....stthread&f=324
Referrer : http://www.xxxxxxx.com/Ss/newthread....ewthread&f=324
IP Address : xx.xx.xx.82
Username : Someone
Classname : vb_database

================================================== ========

I edited options right after I installed it, and set the member groups that i wanteed to get instant notifications about any topic posted, but when its enabled this happens, when not enabled, its ok to post.

Any Ideas?

[WebmasterSimds]

So far your upgrade seemed to be working thanks.

I will Keep an eye on it to see how it goes, and if there are any more issues. I will let you know. I have a massive board. So this helps

[RedTyger]

It should be fine, but if you have a really huge board doesn't it take forever to actually post the thread? Even with a small mailing list it stalls quite a bit, you might want to look at a different solution.

[WebmasterSimds]

actually no, not at all. I have my own server, and enough power to handle situations like this. and it helps me to test its limits LOL

[Tralala]

I like that this has Admin options; thanks for sharing! Does it allow you to change the email subject and body via phrases too, like this older similar hack did?

[RedTyger]

Yes, it does. It's very much like that other modification with some additional optimisation and options.

[Tralala]

Originally Posted by RedTyger

Yes, it does. It's very much like that other modification with some additional optimisation and options.

Thanks for the reply RedTyger. I did indeed find the newthreadsub phrase, and used the variables to make the email subject more verbose, namely:

PHP Code:

$vboptions[bbtitle] Subscription: $threadinfo[postusername] posted "$threadinfo[title]" in $foruminfo[title_clean] 


I noticed this doesn't sends out the subscription email to the actual creator of the thread (even if they are subscribed to the forum...) which is smart and very cool.

I like this a lot, thanks for the excellent mod.

One thing about forum subscriptions though, it's not intuitive how to UNSUBSCRIBE. You can only do it from the UserCP. Wouldn't it make sense that for subscribed forums, this menu changed to say "Unsubscribe from this Forum" -- just like it works for Threads?


Is that something this hack could incorporate? I hope you like my suggestion.

[HollyRidge]

The version check hack is reporting the wrong version (https://vborg.vbsupport.ru/showthread.php?t=133366). It reports 1.01 when we downloaded and installed the 1.02 hack from here last night on a fresh vb install.

[rjmjr69]

-Reserved- great idea

[RedTyger]

Originally Posted by HollyRidge

The version check hack is reporting the wrong version (https://vborg.vbsupport.ru/showthread.php?t=133366). It reports 1.01 when we downloaded and installed the 1.02 hack from here last night on a fresh vb install.

Thanks, fixed it. It makes no difference but you can use the new zip if you want.

Originally Posted by rjmjr69

-Reserved- great idea

What are you reserving? And why?