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.

[hambil]

Originally Posted by Delphiprogrammi

verry strange here is no error message ......

PHP Code:

$msgs = $db->query_read("
        SELECT accessdenied_message.*, usergroup.title AS usergroup, forum.title AS forum
        FROM " . TABLE_PREFIX . "accessdenied_message
        LEFT JOIN " . TABLE_PREFIX . "usergroup ON usergroup.usergroupid = accessdenied_message.usergroupid
        LEFT JOIN " . TABLE_PREFIX . "forum ON forum.forumid = accessdenied_message.forumid
    "); 


that is causing the error i have no field called "accessdenied_message" within the table vb3_accessdenied_message that field is for some reason missing

Okay, download the zip and try again.

[Delphiprogrammi]

Originally Posted by hambil

Okay, download the zip and try again.

yeah working now thanks for fixing that do you mind telling me what the problem whas ?

[GamerzWorld]

Originally Posted by hambil

Thanks to Gamerz I've realized that vbAccessDenied needs integration with vBulletin's group functions. I'll add this. I also plan on adding a new {matchlist} subsitution variable, that will list all users with matching ips to the one requesting access. Should be done by the weekend

Looking forward to this. My main concern was that I had no control over who could and who couldnt see the private forum, and therefore couldnt remove them. By intergrating the systems it

(a) Improved the current system massivley, as users are having problems finding where to apply
(b) Improves the use of your hack to automatically request

All it would need then is a link to registration as discussed :knockedout:

[hambil]

Originally Posted by Delphiprogrammi

yeah working now thanks for fixing that do you mind telling me what the problem whas ?

The query was broken if you had a table prefix. You must have been the first to install it who has a table prefix

[scottct1]

Ok here is what I am trying to do.

I have a special forum on my site for supporters who donate.

At the moment if your not a donating member you can see the forum and if you click on the forum you are taken to it but are told that no posts have been made over the past 30 days.

What I would like it to do is when someone clicks on that forum they see a custom error message which asks them to consinder donating to get access to that forum.

Can that be done?

Thanks!

[hambil]

Well, you can only customize existing vbulletin access denied messages. The closest you can get is to make the forum so they can view it, but view nothing else (can't view thread contents or create new threads, etc.). Then use this tool to create a custom message for that forum and usergroup(s).

This to me actually seems like a better solution anyway, because the non-donating members are teased with the thread titles, and more encouraged to donate when they try to read and thread and get the message.

[scottct1]

Excellent, I think that will work.

Thank you!

[scottct1]

I would love to see this support formatted messages and possible vbcode.

I just typed up a nice message and its all squished together in one paragraph.

The origional looked like this...

You have tried to access the Private Supporting Members Pub and Grill Forum.

This is a special private forum made only available to those who financially support SatelliteGuys.US. (i.e. help us pay our bills)

Access to this special private forum can be yours for only $19.99 a year and besides giving you access to our very active Pub Member Forums you also get...

* Elimination of over 90% of the ads! (You will only see the top banner ad and the Gold Sponsors)
* A larger Private Message box, store 1000 Private Messages instead of only 25!
* The ability to store 300 pages (Using the SatelliteGuys Pager)instead of only 10!
* The ability to have your own ANIMATED Avatar!
* Ability for you to post FOR SALE items in our Classifieds Section!
* Access to our Private Back Room Forum - An optional forum where adults can hang out and discuss adult topics.
* A special icon next to your username in all your posts which tells everyone your a supporter!
* The good feeling that you help one of America's Most Popular Satellite sites stay online!

AND MORE!

And if you hurry now you will pay only $19.99 for a 1 years membership as the price will be going up to $24.95 on May 15th 2006!

To become a SatelliteGuys Supporter TODAY please visit http://www.satelliteguys.us/payments.php

If you pay by Credit Card you get all the benefits of your pub membership INSTANTLY!

Thank you for your support and for helping us keep the lights on!

However when it prints out it looks like this...

You have tried to access the Private Supporting Members Pub and Grill Forum. This is a special private forum made only available to those who financially support SatelliteGuys.US. (i.e. help us pay our bills) Access to this special private forum can be yours for only $19.99 a year and besides giving you access to our very active Pub Member Forums you also get... * Elimination of over 90% of the ads! (You will only see the top banner ad and the Gold Sponsors) * A larger Private Message box, store 1000 Private Messages instead of only 25! * The ability to store 300 pages (Using the SatelliteGuys Pager)instead of only 10! * The ability to have your own ANIMATED Avatar! * Ability for you to post FOR SALE items in our Classifieds Section! * Access to our Private Back Room Forum - An optional forum where adults can hang out and discuss adult topics. * A special icon next to your username in all your posts which tells everyone your a supporter! * The good feeling that you help one of America's Most Popular Satellite sites stay online! AND MORE! And if you hurry now you will pay only $19.99 for a 1 years membership as the price will be going up to $24.95 on May 15th 2006! To become a SatelliteGuys Supporter TODAY please visit http://www.satelliteguys.us/payments.php If you pay by Credit Card you get all the benefits of your pub membership INSTANTLY! Thank you for your support and for helping us keep the lights on!

Other then that working good!

Thanks!

[hambil]

It supports bbcode. See the attachment above: https://vborg.vbsupport.ru/attachmen...4&d=1143606717

I plan to use the WYSIWYG editor in the next version, but as you can see I've created a formated message. Can you give me some before and after screen shots?

[hambil]

Try creating the message using the WYSIWYG editor, when switching to the standard editor (button in the top right of the editor will do that). Then copy and pasting the message into vbAccessDenied. That should work.

This is why I will be directly supporting the WYSIWYG editor in the next version