![]() |
Hi!
How can I show the usergroup after the username in the memberlist?? I menaged to show the groupid but i want the name! help plz StarBuG |
No one can help ????
StarBuG |
Err I'm in a bit of a hurry, but try replacing this in memberlist.php:
Code:
$users=$DB_site->query("SELECT * Code:
$users=$DB_site->query("SELECT * Hope this works. :) |
nope there where no output in the memberlist.
|
I get this error:
Invalid SQL: SELECT * FROM user,userfield LEFT JOIN usergroup ON usergroup.usergroupid=user.usergroupid WHERE 1=1 AND user.userid = userfield.userid AND usergroupid NOT IN (1,3,4) ORDER BY username ASC LIMIT 0,30 mysql error: Column: 'usergroupid' in where clause is ambiguous mysql error number: 1052 Any suggestions? |
Replace this:
Code:
".iif($memberAllGood, " AND usergroupid NOT IN (1,3,4) ", "")." Code:
".iif($memberAllGood, " AND user.usergroupid NOT IN (1,3,4) ", "")." |
Firefly, in memberlistbit Template don't add $user[title], add this $unserinfo[title] and it will work.
THX for your help |
Quote:
THX to both of u for your help!!! Greetings StarBuG |
sorry litte false, but i think everyone can understand this :) now
THX for the corretion |
is there away of displaying the usergroup text in the postbit template, if so what will i need to do!!!!!
|
All times are GMT. The time now is 12:35 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 | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|