Moderators Functions - vbAccessDenied

Keywords: admincp, access denied, forum access, access, user, admin, usergroup


This modification contains a MySQL injection vulnerability, and you are hereby advised to unintall this modification until such time that the author provides a fix.
-- vBorg Staff


Description:
A powerful tool for customizing the generic vBulletin access denied message.

Translations
German (Thanks to alluidh)

Features:

• Fully Phrased.
• Turn on or off in admin cp.
• Created a custom message for any vBulletin generic access denied message.
• Personalize messages with any user, forum or usergroup information.
• Automatically send a PM to one or more users the first time a member receives a specific access denied message.
• Personalize the PM with any user, forum or usergroup information.
• Add an approval link to the automatic PM that will give the user a new primary or secondary usergroup of your choice when clicked.
• Send a PM to everyone who received the original access request, and the requesting user, when they are approved.
• Several layers of security.

Use Case
On my board we only allow access to a few forums until a user has been approved by an admin. The sample screen shots show this process in action.

Install

1. Download the vbAccessDenied_1.0.zip file.
2. Unzip and upload the files in the upload directory to your forum root.
3. Import the product file in your admincp.
4. Create custom messages as desired.

1.1 Changes

1. Supports bbcodes in messages (see updated screen shot).
2. Fixed sql bug that prevented many messages from showing properly.
3. Removed 255 character limit on messages.

Upgrade from 1.0 to 1.1
You will need to reupload all files, and uninstall and reinstall the product to upgrade from 1.0 to 1.1. Please copy your messages to a text editor first if you want to save them.

[pugmy]

installed

[Tyegurl]

okay so how do i choose more than one forum to deeny for one group?

[hambil]

Originally Posted by Tyegurl

okay so how do i choose more than one forum to deeny for one group?

You can duplicate the message, or use the * option for the forum - or set it up for a top level forum and it will also affect all the subforums because of how vBulletin works.

If people find they need a more powerful "multi-list box" kind of selection for forums and/or usergoups then I may consider adding that.

[Tyegurl]

okay so there's no way to just hold ctrl and click.....that would be nice....have a mass denial for certain forums....can you do that?

[hambil]

Originally Posted by Tyegurl

okay so there's no way to just hold ctrl and click.....that would be nice....have a mass denial for certain forums....can you do that?

Well, I'm not sure it's needed. Consider this: It only customizes the already existing "access denied" message. So - if you have 10 forums, and you have a usergroup that only has access to three of those forums, and you create a vbAccessDenied message with that usergroup name, and * for the forum, it will display whenever they try to access any of the seven forums they don't have access too.

vBulletin's usergroup, forum and promotion system is already very powerful - this hack builds on that, rather than replaces it.

[Tyegurl]

okay so i get it lol * goes in the forum....duh see i am a little thick....wasn't quite understanding....

so you can make one denial for a group for all the forums vb has denied them.

or a denial for a forum for all groups?

[Tyegurl]

well now i get a db error when i am unregisterd trying to access a page i shouldn't. i don't get a message about denial.

what have i done wrong?

SELECT * FROM accessdenied_message
WHERE usergroupid = 1
AND forumid =
AND (script = 'arcade(*)' OR script = '*');

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 'AND (script = 'arcade(*)' OR script = '*')' at line 4
Error Number : 1064
Date : Thursday, March 30th 2006 @ 12:32:57 AM
Script : http://www.teamrespawn.com/vBulletin/arcade.php
Referrer : http://www.teamrespawn.com/vBulletin/forum.php

[hambil]

Originally Posted by Tyegurl

so you can make one denial for a group for all the forums vb has denied them.

Yup!

Originally Posted by Tyegurl

or a denial for a forum for all groups?

For all groups who vb has denied that forum, anyway.

Also, the messages are handled from specific to generic. So, if you have a group with a * for forum, and then you have the same group with a specific forum and a different message, they'll get the specific message for that forum, but the general one for all others.

The order is:
Specific message
General Usergroup Message
General Forum Message

[hambil]

Originally Posted by Tyegurl

well now i get a db error when i am unregisterd trying to access a page i shouldn't. i don't get a message about denial.

what have i done wrong?

SELECT * FROM accessdenied_message
WHERE usergroupid = 1
AND forumid =
AND (script = 'arcade(*)' OR script = '*');

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 'AND (script = 'arcade(*)' OR script = '*')' at line 4
Error Number : 1064
Date : Thursday, March 30th 2006 @ 12:32:57 AM
Script : http://www.teamrespawn.com/vBulletin/arcade.php
Referrer : http://www.teamrespawn.com/vBulletin/forum.php

This should be fixed if you download the latest zip file.

[Tyegurl]

if its the one i downloaded tonight from the top of the page then yes.

nm i uploaded the wrong one dammit....i will fix thanks!