PDA

View Full Version : Mimic access mask from one forum to another via DB command?

SWFans.net
11-06-2002, 03:22 AM
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.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.