Mini Mods - Usergroup Messages

Description
Have you ever wanted to show a usergroup or usergroups a message but don't feel like editing the template to do so?
With this add-on you'll be able to write a message to one, a few, or all usergroups.

To add, edit, or delete a message go to ACP --> Usergroups --> Usergroup Messages Manager

If you have installed this add-on on your board please click Install to the bottom right of this post
You are not permitted to redistribute this add-on on any site.
If you feel this add-on deserves Mod of the Month please click to nominate it

[harmor19]

Thanks everyone.

I don't know why it's not default in vBulletin.

[Aaron RV]

mmm 3.6.2 no work! :cross-eyed:

[eNforce]

Confirmed not working with 3.6.2

It does not install the product, gives a DB error.

Database error in vBulletin 3.6.2:

Invalid SQL:
CREATE TABLE `usergroupmessages` (
  `usergroupmessagesid` mediumint(10) unsigned NOT NULL auto_increment,
  `title` varchar(120) NOT NULL default '',
  `usergroups` varchar(200) NOT NULL default '',
  `message` text NOT NULL,
  `enabled` tinyint(1) unsigned NOT NULL default '',
  PRIMARY KEY  (`usergroupmessagesid`)
);;

MySQL Error  : Invalid default value for 'enabled'
Error Number : 1067
Date         : Monday, October 9th 2006 @ 12:29:36 AM
Script       : http://www.areyouserios.com/admincp/plugin.php?do=productimport
Referrer     : http://www.areyouserios.com/admincp/plugin.php?do=productadd
IP Address   : 
Username     : Windextor
Classname    : vB_Database

[harmor19]

I added "0" as the default for "enabled". Tell me if it works.

[eNforce]

It works great now, thanks /installs

Also, would it be possible to have a drop down menu to select which usergroups will be able to see the message... instead of entering the usergroup ID?

[Aaron RV]

work now, thank's.

[Hornstar]

Originally Posted by eNforce

It works great now, thanks /installs

Also, would it be possible to have a drop down menu to select which usergroups will be able to see the message... instead of entering the usergroup ID?

great idea.

this looks really good. Thanks.

[Snake]

Thanks.

[Nathan2006]

Thanks harmor19

Install

[Shanj]

Sounds a neat tool - but does it send emails? pms? or display posts somewhere? If the last option where?

Tx