Go Back   vb.org Archive > vBulletin Modifications > Archive > Modification Graveyard
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
vbAccessDenied Details »»
vbAccessDenied
Version: 1.1, by hambil hambil is offline
Developer Last Online: Apr 2013 Show Printable Version Email this Page

Category: Moderators Functions - Version: 3.5.4 Rating:
Released: 03-27-2006 Last Update: 04-05-2006 Installs: 40
Uses Plugins
Additional Files  
No support by the author.

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.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #52  
Old 03-30-2006, 05:50 AM
hambil's Avatar
hambil hambil is offline
 
Join Date: Jun 2004
Location: Seattle
Posts: 1,719
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

LOL - I do that all the time. It's hard to keep track sometimes
Reply With Quote
  #53  
Old 03-30-2006, 05:51 AM
Tyegurl's Avatar
Tyegurl Tyegurl is offline
 
Join Date: Mar 2006
Location: NY
Posts: 480
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

one last thing.... how do i get it to automatically add the forum title and user's name? i am not too quick on this stuff

and yes with the correct version i got the message. sorry about that.
Reply With Quote
  #54  
Old 03-30-2006, 05:54 AM
hambil's Avatar
hambil hambil is offline
 
Join Date: Jun 2004
Location: Seattle
Posts: 1,719
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Tyegurl
one last thing.... how do i get it to automatically add the forum title and user's name? i am not too quick on this stuff

and yes with the correct version i got the message. sorry about that.
One of the screen shots has some nice examples. Basically, any forum or user or usergroup data can be used. You put them in {} in the message.

Username would be {user.username}
and the forum would be {forum.title}

I'll put up a complete list of the standard vb ones tomorrow - but if you have installed hacks that add to the forum or user or usergroup table, you can also use those values too.
Reply With Quote
  #55  
Old 03-30-2006, 11:03 AM
Delphiprogrammi Delphiprogrammi is offline
 
Join Date: Feb 2004
Location: Landen(Belgium)
Posts: 1,335
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

hi,

this doesn't work and throws an error every time you hit "messages" in the admincp navigation

Quote:

Invalid SQL:

SELECT accessdenied_message.*, usergroup.title AS usergroup, forum.title AS forum
FROM vb3_accessdenied_message
LEFT JOIN vb3_usergroup ON usergroup.usergroupid = accessdenied_message.usergroupid
LEFT JOIN vb3_forum ON forum.forumid = accessdenied_message.forumid;

MySQL Error : Unknown table 'accessdenied_message'
Error Number : 1051
Date : Thursday, March 30th 2006 @ 07:00:54 AM
Script : http://*******/testvb/admincp/access....php?do=modify
Referrer : http://*******/testvb/admincp/index.php?do=nav
IP Address : ******
Username : ******
Classname : vb_database
Reply With Quote
  #56  
Old 03-30-2006, 11:07 AM
hambil's Avatar
hambil hambil is offline
 
Join Date: Jun 2004
Location: Seattle
Posts: 1,719
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Delphiprogrammi
hi,

this doesn't work and throws an error every time you hit "messages" in the admincp navigation
Unknown table means it didn't install properly for some reason. I have no idea why. What version is your MySQL?
Reply With Quote
  #57  
Old 03-30-2006, 11:12 AM
Delphiprogrammi Delphiprogrammi is offline
 
Join Date: Feb 2004
Location: Landen(Belgium)
Posts: 1,335
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by hambil
Unknown table means it didn't install properly for some reason. I have no idea why. What version is your MySQL?
MySQL 4.1.14-standard
Reply With Quote
  #58  
Old 03-30-2006, 11:15 AM
hambil's Avatar
hambil hambil is offline
 
Join Date: Jun 2004
Location: Seattle
Posts: 1,719
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Can you remove the line $db->hide_errors() from the product xml and try importing it again? Tell me what, if any error you see?
Reply With Quote
  #59  
Old 03-30-2006, 11:24 AM
Delphiprogrammi Delphiprogrammi is offline
 
Join Date: Feb 2004
Location: Landen(Belgium)
Posts: 1,335
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by hambil
Can you remove the line $db->hide_errors() from the product xml and try importing it again? Tell me what, if any error you see?
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
Reply With Quote
  #60  
Old 03-30-2006, 11:28 AM
hambil's Avatar
hambil hambil is offline
 
Join Date: Jun 2004
Location: Seattle
Posts: 1,719
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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
There is no field call accessdenied_message - it's the table name.
Reply With Quote
  #61  
Old 03-30-2006, 11:29 AM
hambil's Avatar
hambil hambil is offline
 
Join Date: Jun 2004
Location: Seattle
Posts: 1,719
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ah...
I may see the problem - though why it hasn't caused anyone else trouble I don't know. Let me try a quick fix.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 04:22 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04882 seconds
  • Memory Usage 2,322KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (2)bbcode_php
  • (6)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete