The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Question about usergroup filtering
Ok, I have this plugin that shows when a user post a reply or post a new thread on my forums. The problem is I can't enable the admin forums to be shown as members would be able to see it. I then thought about it and looked through the database and seen that theirs a table called "forumpermission". I noticed that for whatever forumid it was it had usergroupid and then permission for that forumid. After looking through and confirming my results, anything that has "forumpermissions" set to '0', means they can't read or see the forum. So obviously I need a sql query to display the information something like:
Code:
SELECT u.usergroupid, p.usergroupid, p.forumpermissions, p.forumid FROM from " . TABLE_PREFIX . "forumpermission p LEFT JOIN " . TABLE_PREFIX . "user u on (u.usergroupid = p.usergroupid) WHERE p.forumpermissions > 0 Thanks |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|