Miscellaneous Hacks - Restrict Style to Usergroup

Restrict Style to Usergroup(s)

Description
This Hack allows you to restrict styles to certain usergroups.

Details
1 Product XML (4 Plugins, 1 Phrase).

Screenshot (from the 3.0 Version; very similar): https://vborg.vbsupport.ru/attachmen...chmentid=26703

History
1.0.0
Initial Version

1.0.1
Slight Bugfix regarding secondary Usergroups not working properly

1.0.2
Converted to a Product; no more file edits necessary

1.0.3
Fixed a Bug that caused this Hack to not work at all

1.0.4
Compatibility Update for vBulletin 4.1.11+

Compatibility
This Add-on is compatible with vBulletin 3.5.X, 3.6.X, 3.7.X, 3.8.X, 4.0.X, 4.1.X and 4.2.0

Attention: This Hack does not work with Show Users using Style in Style Chooser

[Boofo]

Good job! Apparently you found hooks that would work, huh?

[Andreas]

Not really ... there are no Hooks to display the Controls (Usergroups Selector).
But the really important Hooks (Data-Saving) are there, for the GUI Stuff I use a dirty Trick

[Boofo]

Whatever works, right?

[RoryF]

Grand job .

I get an error though when i edit the settings.

PHP Code:

Database error in vBulletin 3.5.0 Release Candidate 3:

Invalid SQL:
SELECT allowedusergroups FROM style WHERE styleid = 2;

MySQL Error  : Unknown column 'allowedusergroups' in 'field list'
Error Number : 1054
Date         : Friday, September 9th 2005 @ 11:10:52 AM
Script       : http://*************/forum/admincp/template.php?s=&group=&do=editstyle&dostyleid=2
Referrer     : http://*************/forum/admincp/template.php?do=modify&group=&expandset=2
IP Address   : ************
Username     : Rory
Classname    : vB_Database 

[Snake]

Screenshots please?

[RoryF]

Screenshot is already in the post . It's just a link.

Screenshot URL is here => https://vborg.vbsupport.ru/attachmen...chmentid=26703

[Andreas]

Originally Posted by RoryF

Grand job .

I get an error though when i edit the settings.

Doh! I forgot the Install Code ^.^

Redownload the ZIP and import the new XML or

[sql]ALTER TABLE style ADD allowedusergroups VARCHAR(250) NOT NULL DEFAULT ''[/sql]

[Snake]

Whoops my bad. Thanks for the hack.

[Oblivion Knight]

So if no usergroups are selected and the style is active; the style can be used by all usergroups. Correct?