Hello,

I'm using a FireBoard forum with Joomla:

www.blockout.net/index.php?option=com_fireboard&Itemid=27

The userList is not working properly:
I had to make the following path in order to make it work properly.

File: template/default/plugin/userlist/userlist.php

Line 54:
[code:1]

Replaced:

$query
= "SELECT u.id, u.name, u.username , u.usertype , u.email , u.registerDate, u.lastvisitDate ,fu.showOnline, fu.group_id, fu.posts ,fu.karma , fu.uhits , g.title "
. "nFROM #__users AS u " . "nINNER JOIN #__fb_users AS fu ON fu.userid = u.id" . "nINNER JOIN #__fb_groups AS g ON g.id = fu.group_id ";

By:

$query = "SELECT * FROM (";
$query .= " SELECT u.id, u.name, u.username , u.usertype , u.email , u.registerDate, u.lastvisitDate , fu.group_id,";
$query .= " fu.posts ,fu.karma , fu.uhits , g.title";
$query .= " FROM #__users AS u";
$query .= " INNER JOIN #__fb_users AS fu ON u.id=fu.userid";
$query .= " INNER JOIN #__fb_groups AS g ON g.id = fu.group_id";
$query .= " UNION (";
$query .= " select id,name,username,usertype,email,registerDate,lastvisitDate,1 AS group_id,0 as posts,0 as karma,";
$query .= " 0 as uhits,'Registered User' as title";
$query .= " FROM #__users WHERE #__users.id not in (select userid from #__fb_users)";
$query .= " )";
$query .= "«») AS allTable";

[/code:1]

Note: I adapted the default values for users which are not in the yet __fb_users table to
my purpose.

I would be great if this can be integrated in the new release.
Thank you very much for your work :)

Put it in the bugtracker.

Sorry for my ignorance but where is the bugtracker ?

Thanks
Done.
joomlacode.org/gf/project/fireboard/trac...tracker_item_id=9557

Will this fix work when the userlist is coming from Community Builder?

I am using Joomla 1.0.15 and Fireboard 1.0.4 Stable. My userlist was being appropriately counted, but none of the users were displaying.

I tried the code above and still had no display. I ran the query directly in phpMyAdmin and got a MySQL error. This particular query is beyond my SQL skills, but I did find that by eliminating the open parentheses after "UNION" and eliminating one of the closing parentheses at the end I could get the query to run. The query I ended up using is as follows:
[code:1]$query = "SELECT * FROM (";
$query .= " SELECT u.id, u.name, u.username , u.usertype , u.email , u.registerDate, u.lastvisitDate , fu.group_id,";
$query .= " fu.posts ,fu.karma , fu.uhits , g.title";
$query .= " FROM #__users AS u";
$query .= " INNER JOIN #__fb_users AS fu ON u.id=fu.userid";
$query .= " INNER JOIN #__fb_groups AS g ON g.id = fu.group_id";
$query .= " UNION ";
$query .= " select id,name,username,usertype,email,registerDate,lastvisitDate,1 AS group_id,0 as posts,0 as karma,";
$query .= " 0 as uhits,'Registered User' as title";
$query .= " FROM #__users WHERE #__users.id not in (select userid from #__fb_users)";
$query .= " )";
$query .= " AS allTable";[/code:1]

It seems like it works for the search, too, though it doesn't display all users, presumably because of the factors related in [url=http://www.bestofjoomla.com/component/option,com_fireboard/Itemid,38/func,view/id,43090/catid,73/limit,10/limitstart,0/]this post[/url].

Hope this helps someone else with a blank user list!