UBB.Developers Forums UBB.threads 7 Development Modification Ideas FlashChat with UBB.Threads 7.0.2

/* PHP CODE HERE, IF NECESSARY */

	header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
	header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
	header("Cache-Control: no-store, no-cache, must-revalidate");
	header("Cache-Control: post-check=0, pre-check=0", false);
	header("Pragma: no-cache");


/**
If this file is not in the FlashChat root folder, then change this
path to the location of the inc/common.php file.
*/
include_once('inc/common.php');

ChatServer::purgeExpired();  // ERROR HERE: Undefined class name 'chatserver'

/**
Retrieves the number of users who are chatting in any room.
Leave the $room parameter empty to return the number of users in all room.
*/
function numusers( $room = "" )
{
	if($room) {
		$stmt = new Statement("SELECT COUNT(*) AS numb FROM {$GLOBALS['fc_config']['db']['pref']}connections WHERE userid IS NOT NULL AND roomid=?");
		$rs = $stmt->process($room);
	} else {
		$stmt = new Statement("SELECT COUNT(*) AS numb FROM {$GLOBALS['fc_config']['db']['pref']}connections,{$GLOBALS['fc_config']['db']['pref']}rooms
							  WHERE userid IS NOT NULL AND ispublic IS NOT NULL
							  AND {$GLOBALS['fc_config']['db']['pref']}connections.roomid = {$GLOBALS['fc_config']['db']['pref']}rooms.id");
		$rs = $stmt->process();
	}
	
	$rec = $rs->next();

	return $rec?$rec['numb']:0;
}

/**
Retrieves a list of the users (by login ID) who are in $room.
Leave the $room parameter empty to return a list of all users in all rooms.
*/
function usersinroom( $room = "" )
{
	$cms = $GLOBALS['fc_config']['cms'];
	$list = array();

	if($room) {
		$stmt = new Statement("SELECT userid, state, color, lang, roomid FROM {$GLOBALS['fc_config']['db']['pref']}connections WHERE userid IS NOT NULL AND roomid=?");
		$rs = $stmt->process($room);
	} else {
		$stmt = new Statement("SELECT userid, state, color, lang, roomid FROM {$GLOBALS['fc_config']['db']['pref']}connections WHERE userid IS NOT NULL");
		$rs = $stmt->process();
	}

	while($rec = $rs->next()) $list[] = array_merge($cms->getUser($rec['userid']), $rec);

	return $list;
}

/**
Retrieves a list of all available rooms, as an array.
*/
function roomlist()
{
	$list = array();

	// populate $list with the names of all available rooms
	$stmt = new Statement("SELECT * FROM {$GLOBALS['fc_config']['db']['pref']}rooms WHERE ispublic IS NOT NULL order by ispermanent");
	$rs = $stmt->process();  // ERROR: Cannot instantiate non-existent class: statement

	while($rec = $rs->next()) $list[] = $rec;

	//result will be an array of arrays like ('id' => <room id>, 'updated' = <timestamp>, 'created' => <timestamp>, 'name' => <room name>, 'ispublic' => <public flag>, 'ispermanent' => <autoclose flag>)
	return $list;
}


$rooms = roomlist();
$roomnumb = sizeof($rooms);
$usernumb = numusers();



/* DO NOT CHANGE THE LINE BELOW */
$body = <<<EOF

<BR>&#62;<a href="/threads/chat/flashchat.php" target="_blank">Chatroom</a> (<?= $usernumb ?> user<? if ($usernumb != 1) echo "s" ?> in <?=$roomnumb ?> room<? if ($roomnumb != 1) echo "s"; ?>)
<ul id="roomList">
<?php if($roomnumb) { ?>
		<?php foreach($rooms as $room) { ?>
<li><strong><a href="#" onclick="javascript:toggleUserList('room_<?=$room[id]?>')"><?=$room[name]?> (<?= numusers($room[id]) ?>)</a></strong>
				<?php
					$users = usersinroom($room[id]);
										if ($users) { 
										  echo "<ul class="userList" id="room_".$room[id]."">";
										  foreach( $users as $user ) {
						echo "<li>".$user[login] . "</li>";
					  }
										  echo "</ul>";
										}

				?> </li>
		<?php } ?>
<?php } ?>
</ul>



EOF;
/* DO NOT CHANGE THE LINE ABOVE */