The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Listing a usergroup on non vb php page...
Ok, I have a usergroup composed of paying advertisers. I want to create an ad index that lists their username, location, and web address (just like the 'show forum leaders' does). Is this possible to do on a non vb .php page?
TIA... |
#2
|
||||
|
||||
Basically it's
[sql]SELECT userid, username, field2 FROM user LEFT JOIN userfield ON (userfield.userid=user.userid) WHERE usergroupid=X OR FIND_IN_SET('X', membergroupids)[/sql] Where X is the ID of this usergroup. |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|