0

Hello again =)

Now i have a question about vbulletin and its usergroup manager and some mysql questions that goes with it.

We have a clan site and vbulletin forum.
I have created a specific usergroup for our clan members. Now i want to display those users on a none forum page by grabing the information from the database using dreamveawer.

Whenever i try i cant since i have all members on registered membergroup as main group and the clan member group as secondary and it will not display the secondary groups if i try to grab it from the database.

Is there anyway to get it out of the database ?
I have professional querymanager but i dont know how that works LOL. If it even helps ?

I can display the main group perfectly but not the secondary group. :-|

Not to good of an explonation but i hope you understand anyway =)

3
Contributors
2
Replies
3
Views
12 Years
Discussion Span
Last Post by curiousdan
0

For a primary usergroup:

SELECT userid FROM user WHERE usergroupid = 2

For a secondary usergroup:

SELECT userid FROM user WHERE
	 membergroupids LIKE "%2,%" OR
	 membergroupids LIKE "%,2"
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.