Social Group and Album Enhancements - Automatically subscribe a new social group member to daily email updates

My first contribution to vBulletin.org is a simple plugin that automatically subscribes a new social group member to daily email updates.

Why?
When new social group users click "Join", they probably think they are automatically subscribing to the group and will get updates, but they aren't. The default subscription is 'none' so new social group members aren't notified about updates unless they hunt out the "Group Tools" menu and click "Subscribe".

How to install
Download the attached xml file, then go to Admin CP -> Plugins & Products -> Download/Upload Plugins, then scroll to the bottom of that page and "upload the XML file from your computer".

[smnet]

Great idea!

Is there an option to sign up all existing group members to this automatically too? Is this possible, or perhaps an sql query would do this.

Thanks for the mod!

[jilly]

some questions:

if there is no update to the group that day, does it still send an email?

will there be a way for a new group member to opt out of this, if they decide they do not want the daily update anymore?

[nick_ramsay]

Originally Posted by smnet

Is there an option to sign up all existing group members to this automatically too? Is this possible, or perhaps an sql query would do this.

No such option, and since members are added to a separate subscriptions table in the database when they subscribe, it would take more than a simple SQL query.

Originally Posted by jilly

if there is no update to the group that day, does it still send an email?

Emails are only sent when there are updates.

Originally Posted by jilly

will there be a way for a new group member to opt out of this, if they decide they do not want the daily update anymore?

Members can unsubscribe from the Group Tools menu in the social group.

[HermetiC]

Very very nice plugin!
Thanks!

[mialutz]

I would love a way to subscribe existing members too.

[ryancooper]

When I uninstall and try to join a group i get

Database error in vBulletin 3.8.1:

Invalid SQL:

REPLACE INTO subscribegroup (userid, groupid, emailupdate)
				VALUES (1, 20, 'daily');

MySQL Error   : Unknown column 'emailupdate' in 'field list'
Error Number  : 1054
Request Date  : Sunday, June 14th 2009 @ 07:09:20 AM
Error Date    : Sunday, June 14th 2009 @ 07:09:21 AM
Script        : http://www.xxxxx.com/group.php?do=dojoin
Referrer      : http://www.xxxxx.com/group.php?do=join&groupid=20
IP Address    : xxxxx
Username      : Ryan C.
Classname     : vB_Database
MySQL Version : 5.0.75-community-log

even when I reinstall the plugin i get this error. Any help?

[john102774]

*reserved

[wmlvb]

Originally Posted by mialutz

I would love a way to subscribe existing members too.

yea any way we can get all the existing members auto subscribed? thanks

[Canadians360]

I use a mod that makes a members social groups look like forums, so I don't really want to bug them with daily emails, is there an easy way to make them automaticaly have a no email notification subscription?