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

	 $this->loginStmt = new Statement("SELECT USER_DISPLAY_NAME, USER_MEMBERSHIP_LEVEL, USER_PASSWORD,USER_IS_APPROVED,USER_IS_BANNED,USER_ID FROM   {$GLOBALS['config']['TABLE_PREFIX']}USERS WHERE  USER_DISPLAY_NAME = ? LIMIT 1");
		//$this->updateSessionStmt = new Statement("UPDATE {$GLOBALS['config']['TABLE_PREFIX']}USERS SET	U_Laston   = ?, U_SessionId = ? WHERE  USER_DISPLAY_NAME = ?");
		$this->getUserStmt = new Statement("SELECT USER_DISPLAY_NAME as login, USER_MEMBERSHIP_LEVEL as status FROM {$GLOBALS['config']['TABLE_PREFIX']}USERS WHERE  USER_ID = ? LIMIT 1");
		$this->getUsersStmt = new Statement("SELECT USER_DISPLAY_NAME as login, USER_ID as id FROM {$GLOBALS['config']['TABLE_PREFIX']}USERS"); 

	 $this->loginStmt = new Statement("SELECT USER_DISPLAY_NAME, USER_MEMBERSHIP_LEVEL, USER_PASSWORD,USER_IS_APPROVED,USER_IS_BANNED,USER_ID FROM   {$GLOBALS['config']['TABLE_PREFIX']}USERS WHERE  USER_DISPLAY_NAME = ? LIMIT 1");
		//$this->updateSessionStmt = new Statement("UPDATE {$GLOBALS['config']['TABLE_PREFIX']}USERS SET	U_Laston   = ?, U_SessionId = ? WHERE  USER_DISPLAY_NAME = ?");
		$this->getUserStmt = new Statement("SELECT USER_DISPLAY_NAME as login, USER_MEMBERSHIP_LEVEL as status FROM {$GLOBALS['config']['TABLE_PREFIX']}USERS WHERE  USER_ID = ? LIMIT 1");
		$this->getUsersStmt = new Statement("SELECT USER_DISPLAY_NAME as login, USER_ID as id FROM {$GLOBALS['config']['TABLE_PREFIX']}USERS"); 

<?php

	if ( !defined( 'INC_DIR' ) ) {
		die( 'hacking attempt' );
	}

/************************************************************************/
//!!! IMPORTANT NOTE
//!!! FlashChat 4.4.0 and higher support a new user role: ROLE_MODERATOR
//!!! Please edit the getUser and getRoles function if you need use of
//!!! the new moderator role. This change has not yet been applied.
/************************************************************************/

// integration class for UBB.Threads (www.ubbcentral.com/ubbthreads/)


$ubb_root_path = realpath(dirname(__FILE__) . '/../../../') . '/';

require_once($ubb_root_path . 'includes/config.inc.php');

class UBBCMS {
var $loginStmt;
var $updateSessionStmt;
var $getUserStmt;
var $getUsersStmt;
var $userid;
	function UBBCMS() {

	$this->loginStmt = new Statement("SELECT USER_DISPLAY_NAME, USER_MEMBERSHIP_LEVEL, USER_PASSWORD,USER_IS_APPROVED,USER_IS_BANNED,USER_ID FROM   {$GLOBALS['config']['TABLE_PREFIX']}USERS WHERE  USER_DISPLAY_NAME = ? LIMIT 1");
		//$this->updateSessionStmt = new Statement("UPDATE {$GLOBALS['config']['TABLE_PREFIX']}USERS SET	U_Laston   = ?, U_SessionId = ? WHERE  USER_DISPLAY_NAME = ?");
		$this->getUserStmt = new Statement("SELECT USER_DISPLAY_NAME as login, USER_MEMBERSHIP_LEVEL as status FROM {$GLOBALS['config']['TABLE_PREFIX']}USERS WHERE  USER_ID = ? LIMIT 1");
		$this->getUsersStmt = new Statement("SELECT USER_DISPLAY_NAME as login, USER_ID as id FROM {$GLOBALS['config']['TABLE_PREFIX']}USERS");  

		// $this->loginStmt = new Statement("SELECT USER_DISPLAY_NAME, USER_MEMBERSHIP_LEVEL, USER_PASSWORD,USER_IS_APPROVED,USER_IS_BANNED,USER_ID FROM   {$GLOBALS['config']['TABLE_PREFIX']}USERS WHERE  USER_LOGIN_NAME = ? LIMIT 1");
		// $this->updateSessionStmt = new Statement("UPDATE {$GLOBALS['config']['TABLE_PREFIX']}users SET	U_Laston   = ?, U_SessionId = ? WHERE  USER_DISPLAY_NAME = ?");
		// $this->getUserStmt = new Statement("SELECT USER_LOGIN_NAME as login, USER_MEMBERSHIP_LEVEL as status FROM {$GLOBALS['config']['TABLE_PREFIX']}USERS WHERE  USER_ID = ? LIMIT 1");
		// $this->getUsersStmt = new Statement("SELECT USER_LOGIN_NAME as login, USER_ID as id FROM {$GLOBALS['config']['TABLE_PREFIX']}USERS");
		
		$this->userid = isset($_COOKIE[$GLOBALS["config"]["COOKIE_PREFIX"] ."ubbt_myid"]) ? $_COOKIE[$GLOBALS["config"]["COOKIE_PREFIX"] ."ubbt_myid"] : NULL;
	}

	function isLoggedIn() {
		return $this->userid;
	}


//	DOESN'T WORK:
//
//	function getRoles($status) {
//		$rv = NULL;
//
//		if ($status == "Administrator")
//			$rv = ROLE_ADMIN;
//		elseif ($status == "Moderator")
//			$rv = ROLE_MODERATOR;
//		elseif ($status == "User")
//			$rv = ROLE_USER;
//		else
//			$rv = ROLE_SPY;
//
//		return $rv;
//	}


//  SO ADMINS AND MODS WILL GET ADMIN STATUS IN FLASHCHAT:


	function getRoles($status) {
		$rv = NULL;

		if ($status == "Administrator" || $status == "Moderator")
			$rv = ROLE_ADMIN;
		elseif ($status == "User")
			$rv = ROLE_USER;
		else
			$rv = ROLE_SPY;

		return $rv;
	}

	function getUserProfile($userid) {
		if ($userid == SPY_USERID) $rv = NULL;

		elseif ($user = $this->getUser($userid))
		{
			//toLog("this",$this->isLoggedIn());
			$id = $this->isLoggedIn();
			
			if( $id && ($id == $userid) )
			{
				toLog("true",true);
				$rv = $GLOBALS["config"]["FULL_URL"] . "/ubbthreads.php?ubb=showprofile&User={$userid}";
			}
			else
			{
				toLog("false",false);
				$rv = $GLOBALS["config"]["FULL_URL"] . "/ubbthreads.php?ubb=login";
			}
			
		}
toLog("rv_prof",$rv);
		return $rv;
	}


	function getUser($userid) {

		$rs = $this->getUserStmt->process($userid);
		$rv = $rs->next();

		if($rv) {
			$rv["roles"] = $this->getRoles($rv["status"]);
		}
		return $rv;
	}

	// taken from ubbt.inc.php



	function login($login, $password) {

		$goodPassword = false;

		$rs = $this->loginStmt->process(addslashes($login));
		$rec = $rs->next();

		if ($rec) {
			// check if user is banned
			if ($rec["USER_IS_BANNED"]) return NULL;

			// allow login only with permanent password. Ignore the temporary password
			if (md5($password) != $rec["USER_PASSWORD"]) return NULL;

			// $this->ubbt_setcookie("{$GLOBALS['config']['cookieprefix']}w3t_myid",$rec['U_Number'],time()+$GLOBALS['config']['cookieexp']);

		   // $this->updateSessionStmt->process(time() + $GLOBALS["config"]["adjustime"] * 3600, md5(rand(0,32767)), addslashes($login));


			return $rec['USER_ID'];

		}

	}

	function userInRole($userid, $role) {
		if($user = $this->getUser($userid)) {
			return ($user['roles'] == $role);
		}
		return false;
	}

	function logout() {

	}

	function getUsers() {
		return $this->getUsersStmt->process();
	}

	function getGender($userid) {
		// 'M' for Male, 'F' for Female, NULL for undefined
		return NULL;
	}
}

$GLOBALS['fc_config']['db'] = array(
				'host' => $GLOBALS["config"]["DATABASE_SERVER"],
				'user' => $GLOBALS["config"]["DATABASE_USER"],
				'pass' => $GLOBALS["config"]["DATABASE_PASSWORD"],
				'base' => $GLOBALS["config"]["DATABASE_NAME"],
				'pref' => $GLOBALS["config"]["TABLE_PREFIX"] . 'fc_',
				);

$GLOBALS['fc_config']['cms'] = new UBBCMS();


foreach($GLOBALS['fc_config']['languages'] as $k => $v) {
	$GLOBALS['fc_config']['languages'][$k]['dialog']['login']['moderator'] = '';
}

?>

/* 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 */
 

Fatal error: Call to a member function next() on a non-object in /home/boneyard/public_html/forum3/chat/inc/cmses/ubb71CMS.php on line 82 

$rv = $rs->next();