[x3n0]

Thats the SQL query to pull the usernames from the chat data tables. Then I used the following code in my sidebar template to create the collapsable stat:

<!-- WHOS IN CHAT -->
<tbody>
<tr>
<td class="thead" colspan="2">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('who_chat')"><img id="collapseimg_who_chat" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_stats].gif" alt="" border="0" /></a>
Who's in Chat?
</td>
</tr>
</tbody>

<tbody id="collapseobj_who_chat">
<tr>
<td class="alt1" width="100%"><div class="smallfont">$chat_users</a></td>
</tr>
</tbody>

<!-- /WHOS IN CHAT -->