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;
}{

<{if $block.users}>



<{/if}>

<{$block.count}> user(s) are in chat

<{foreach from=$block.users item=user}> <{$user.name}>, <{/foreach}>

Join Chat Room Now!

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';

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';