vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Moderators Functions - vbAccessDenied (https://vborg.vbsupport.ru/showthread.php?t=111601)

pugmy 03-29-2006 08:58 PM

installed :)

Tyegurl 03-30-2006 04:16 AM

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

hambil 03-30-2006 04:43 AM

Quote:

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 03-30-2006 04:48 AM

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 03-30-2006 04:52 AM

Quote:

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 03-30-2006 05:28 AM

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 03-30-2006 05:34 AM

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 03-30-2006 05:36 AM

Quote:

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

Yup! :)

Quote:

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 03-30-2006 05:37 AM

Quote:

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 03-30-2006 05:39 AM

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!

hambil 03-30-2006 05:50 AM

LOL - I do that all the time. It's hard to keep track sometimes :)

Tyegurl 03-30-2006 05:51 AM

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.

hambil 03-30-2006 05:54 AM

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.

Delphiprogrammi 03-30-2006 11:03 AM

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

hambil 03-30-2006 11:07 AM

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?

Delphiprogrammi 03-30-2006 11:12 AM

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

hambil 03-30-2006 11:15 AM

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?

Delphiprogrammi 03-30-2006 11:24 AM

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

hambil 03-30-2006 11:28 AM

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.

hambil 03-30-2006 11:29 AM

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.

hambil 03-30-2006 11:45 AM

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

Okay, download the zip and try again.

Delphiprogrammi 03-30-2006 12:24 PM

Quote:

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 03-30-2006 12:55 PM

Quote:

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 03-30-2006 01:52 PM

Quote:

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 04-06-2006 04:36 PM

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 04-06-2006 05:45 PM

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 04-06-2006 06:03 PM

Excellent, I think that will work. :D

Thank you!

scottct1 04-06-2006 06:27 PM

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 04-06-2006 06:30 PM

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 04-06-2006 06:34 PM

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 :)

scottct1 04-06-2006 06:37 PM

Here is what I am seeing...

The before is in the admin panel using the big editor.

The after is the message folks are actually seeing...

Thanks for your help!

scottct1 04-06-2006 06:47 PM

Quote:

Originally Posted by 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.

Tried that, no go, the BB Code displays correctly in the admin control panel (see picture 1)

However when the message is displayed to the user its all garbled up as seen in the second picture.

Thanks again!

scottct1 04-06-2006 07:02 PM

Ok I got it...

I had to use HTML instead of BBcodes and it all worked fine. The error messages now properly display. :)

Thanks again!

hambil 04-06-2006 07:26 PM

Quote:

Originally Posted by scottct1
Ok I got it...

I had to use HTML instead of BBcodes and it all worked fine. The error messages now properly display. :)

Thanks again!

The bbcode parser somehow didn't make it into the product file. Ack! I've updated the product file, and doing an install with allow overwrite should enable bbcode with no harm done. Though you may need to change the html back to bbcode afterwards, I'm not sure.

Xplorer4x4 04-07-2006 09:09 AM

PHP Code:

Database error in vBulletin 3.5.4:

Invalid SQL:

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

MySQL Error  You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near 'AND (script = 'private(*)' OR script = '*')' at line 4
Error Number 
1064
Date         
FridayApril 7th 2006 10:05:28 AM
Script       
http://www.domsforums.net/private.php
Referrer     :
IP Address   :
Username     Unregistered
Classname    
vb_database 

I got this trying to send a PM as a user waiting email conformation. It says unregistered but I was infact registered.

hambil 04-07-2006 09:20 AM

Quote:

Originally Posted by Xplorer4x4
PHP Code:

Database error in vBulletin 3.5.4:

Invalid SQL:

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

MySQL Error  You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near 'AND (script = 'private(*)' OR script = '*')' at line 4
Error Number 
1064
Date         
FridayApril 7th 2006 10:05:28 AM
Script       
http://www.domsforums.net/private.php
Referrer     :
IP Address   :
Username     Unregistered
Classname    
vb_database 

I got this trying to send a PM as a user waiting email conformation. It says unregistered but I was infact registered.

Make sure you'd downloaded and installed the lastest zip. This problem was fixed a while back.

hambil 04-09-2006 11:49 PM

I'm taking this off Beta. It hasn't had any complaints or bugs in a while ;)

computer1 04-18-2006 05:10 PM

I have install this nowe and markt the forum movies to the moderator group
but when I login to the forum whit normal user I can se and write to that section movies howe can I fix this??.

Can I use admin group I cant finde that groupe ???
here is the link to that section
http://forum.wrestlingsidan.se/showt...?p=644#post644

I dont nowe where is the wrong whit this

hambil 04-18-2006 05:14 PM

Quote:

Originally Posted by computer1
I have install this nowe and markt the forum movies to the moderator group
but when I login to the forum whit normal user I can se and write to that section movies

You mark it to the group you want to get the message. So, if you want normal users to get the message then deny them posting access to the forum (in forum settings) and then mark the access denied message as "movies" forum and "normal" usersgroup (whatever your normal usergroup and movies forum is called).

MissKalunji 05-11-2006 09:18 PM

is it possible to use that to block access to example download section? its not in a forum but its apart of vb?


All times are GMT. The time now is 06:22 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01533 seconds
  • Memory Usage 1,877KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (5)bbcode_php_printable
  • (19)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete