usergroup in memberlist

[StarBuG]

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

[StarBuG]

No one can help ????

StarBuG

[Admin]

Err I'm in a bit of a hurry, but try replacing this in memberlist.php:

  $users=$DB_site->query("SELECT *
                          FROM user,userfield
                          WHERE $condition AND

with this:

  $users=$DB_site->query("SELECT *
                          FROM user,userfield
                          LEFT JOIN usergroup ON usergroup.usergroupid=user.usergroupid
                          WHERE $condition AND

then try using $user[title] in the memberlistbit template.

Hope this works.

[Tarion]

nope there where no output in the memberlist.

[StarBuG]

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?

[Admin]

Replace this:

                                ".iif($memberAllGood, " AND usergroupid NOT IN (1,3,4) ", "")."
                          ORDER BY $orderby $direction

with:

                                ".iif($memberAllGood, " AND user.usergroupid NOT IN (1,3,4) ", "")."
                          ORDER BY $orderby $direction

[Tarion]

Firefly, in memberlistbit Template don't add $user[title], add this $unserinfo[title] and it will work.

THX for your help

[StarBuG]

Originally posted by Tarion
Firefly, in memberlistbit Template don't add $user[title], add this $unserinfo[title] and it will work.

THX for your help

You made a Typo $userinfo[title] not unserinfo[titel] but that was the solution!!

THX to both of u for your help!!!

Greetings

StarBuG

[Tarion]

sorry litte false, but i think everyone can understand this now

THX for the corretion

[5861king]

is there away of displaying the usergroup text in the postbit template, if so what will i need to do!!!!!