setaside wrote:
Would you be willing to release that "Who's in Chat" block that you made for it?

function b_inchat_show() {
global $xoopsDB,$xoopsUser;

$block = array();

$result = $xoopsDB->query("SELECT c.name AS name, d.uid AS uid FROM chat_users c, ".$xoopsDB->prefix("users")." d WHERE NOW( ) - datetime < 12 AND d.uname LIKE c.name");


while ( $myrow = $xoopsDB->fetchArray($result) ) {
$block['users'][] = $myrow;
}
$block["count"] = count($block['users']);
return $block;
}{

<table width="99%" class="whitebg" border="0" cellspacing="1" cellpadding="3">
<tr>
<td class="odd"><b><{$block.count}></b> user(s) are in chat</td>
</tr>
<{if $block.users}>
<tr>
<td class="even">
<{foreach from=$block.users item=user}>
<a href="<{$XOOPS_URL}>userinfo.php?uid=<{$user.uid}>"><{$user.name}></a>,
<{/foreach}>
</td>
</tr>
<{/if}>
<tr>
<td class="odd">
<a href="<{$XOOPS_URL}>/modules/flashchat/">Join Chat Room Now!</a>
</td>
</tr>
</table>

DobePhat wrote:
Wow thanks for that! Do you place in a custom block then modify a template or creat a new template file for it with the theme?

// blocks
$modversion['blocks'][1]['file'] = "inchat.php";
$modversion['blocks'][1]['name'] = "Who's in chat";
$modversion['blocks'][1]['description'] = "Shows Article menu";
$modversion['blocks'][1]['show_func'] = "b_inchat_show";
$modversion['blocks'][1]['template'] = 'inchat.html';

<?php
function b_inchat_show() {
global $xoopsDB,$xoopsUser;

$block = array();

$result = $xoopsDB->query("SELECT c.name AS name, d.uid AS uid FROM chat_users c, ".$xoopsDB->prefix("users")." d WHERE NOW( ) - datetime < 12 AND d.uname LIKE c.name");


while ( $myrow = $xoopsDB->fetchArray($result) ) {
$block['users'][] = $myrow;
}
$block["count"] = count($block['users']);
return $block;
}

?>

$modversion['blocks'][1]['template'] = 'inchat.html';