hey guys I just got cometchat 2.04 and I'm trying to get it to work with php-fusion with no luck can someone help me out please?
here the integration.php code
[syntaxhighlighter brush=php,first-line=1,highlight=0,collapse=false,html-script=false]<?php
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/* ADVANCED */
define('SET_SESSION_NAME','slb'
; // Session name
define('DO_NOT_START_SESSION','1'
; // Set to 1 if you have already started the session
define('DO_NOT_DESTROY_SESSION','1'
; // Set to 1 if you do not want to destroy session on logout
define('SWITCH_ENABLED','1'
;
define('INCLUDE_JQUERY','1'
;
define('FORCE_MAGIC_QUOTES','1'
;
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
include_once dirname(dirname(__FILE__))."/config.php";
/* DATABASE */
define('DB_SERVER', $db_host );
define('DB_PORT', '3306' );
define('DB_USERNAME', $db_user );
define('DB_PASSWORD', $db_pass );
define('DB_NAME', $db_name );
define('TABLE_PREFIX', $db_prefix );
define('DB_USERTABLE', 'users' );
define('DB_USERTABLE_NAME', 'user_name' );
define('DB_USERTABLE_USERID', 'user_id' );
define('DB_USERTABLE_LASTACTIVITY', 'user_lastvisit' );
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/* FUNCTIONS */
function getUserID() {
$userid = 0;
if (!empty($_SESSION['userid'])) {
$userid = $_SESSION['userid'];
}
return $userid;
}
function getFriendsList($userid,$time) {
$sql = ("select DISTINCT ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." userid, ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_NAME." username, ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_LASTACTIVITY." lastactivity, ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." avatar, ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." link, cometchat_status.message, cometchat_status.status from ".TABLE_PREFIX."friends join ".TABLE_PREFIX.DB_USERTABLE." on ".TABLE_PREFIX."friends.toid = ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." left join cometchat_status on ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." = cometchat_status.userid where ".TABLE_PREFIX."friends.fromid = '".mysql_real_escape_string($userid)."' order by username asc"
;
return $sql;
}
function getUserDetails($userid) {
$sql = ("select ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." userid, ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_NAME." username, ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_LASTACTIVITY." lastactivity, ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." link, ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." avatar, cometchat_status.message, cometchat_status.status from ".TABLE_PREFIX.DB_USERTABLE." left join cometchat_status on ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." = cometchat_status.userid where ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." = '".mysql_real_escape_string($userid)."'"
;
return $sql;
}
function updateLastActivity($userid) {
$sql = ("update
".TABLE_PREFIX.DB_USERTABLE."
set ".DB_USERTABLE_LASTACTIVITY." = '".getTimeStamp()."' where ".DB_USERTABLE_USERID." = '".mysql_real_escape_string($userid)."'"
;
return $sql;
}
function getUserStatus($userid) {
$sql = ("select cometchat_status.message, cometchat_status.status from cometchat_status where userid = '".mysql_real_escape_string($userid)."'"
;
return $sql;
}
function getLink($link) {
return 'profile.php?lookup='.$link;
}
function getAvatar($image) {
if (is_file(dirname(dirname(__FILE__)).'/images/'.$image.'.gif'
) {
return 'images/'.$image.'.gif';
} else {
return 'images/noavatar.gif';
}
}
function getTimeStamp() {
return time();
}
function processTime($time) {
return $time;
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/* HOOKS */
function hooks_statusupdate($userid,$statusmessage) {
}
function hooks_forcefriends() {
}
function hooks_activityupdate($userid,$status) {
}
function hooks_message($userid,$unsanitizedmessage) {
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
[/syntaxhighlighter]