vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)
-   -   Mimic access mask from one forum to another via DB command? (https://vborg.vbsupport.ru/showthread.php?t=45442)

SWFans.net 11-06-2002 03:22 AM

Mimic access mask from one forum to another via DB command?
 
Okay, here is a question for you DB gurus out there.

We are looking to add a new private forum, but after it is added, we don’t want to have to go through and edit the access masks of the over 400 users that already have access to the forum to whom we want it to have the same access list of.

Is it possible to run a MySQL DB query that would be conditional so that the access table entries for all the users in one forum would be set the same for this new forum?

Basically we want to mimic the access list of an already existing forum, and I don’t know enough about query structure and conditionals to be able to pull it off on my own.

Logician 11-06-2002 08:29 AM

<a href="https://vborg.vbsupport.ru/showthread.php?s=&threadid=44818" target="_blank">https://vborg.vbsupport.ru/showt...threadid=44818</a>

SWFans.net 11-06-2002 04:55 PM

It doesn't look like that is what I need. That hack does forum permissions via usergroupID not access masks via userID.

Thanks though.

SWFans.net 11-06-2002 08:51 PM

I'm not sure if this type of syntax would be correct or not. I need to do some trial and error on my test forums.
PHP Code:

UPDATE access WHERE accessmask="1" AND forumid="1" SET accessmask="1" WHERE forumid="2"

That would be where forumID #1 is the existing forum and #2 is the new forum I am trying to get to have the same access list.


All times are GMT. The time now is 07:39 AM.

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.00953 seconds
  • Memory Usage 1,711KB
  • 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
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete