<?php

/* ADVANCED */

define('SET_SESSION_NAME','');         // Session name

define('DO_NOT_START_SESSION','0');      // Set to 1 if you have already started the session

define('DO_NOT_DESTROY_SESSION','0');   // 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','0');

/* DATABASE */

define('DB_SERVER',   "localhost"   );

define('DB_PORT',"3306");

define('DB_USERNAME',"fusion-user-name"   );

define('DB_PASSWORD',"fusion-db-passwort");

define('DB_NAME',"fusion-db-name");

define('TABLE_PREFIX',"fusioneW6E2_");

define('DB_USERTABLE',"users"   );

define('DB_USERTABLE_USERID',"user_id");

define('DB_USERTABLE_NAME',"user_name");

define('DB_AVATARTABLE'," ");

define('DB_AVATARFIELD',   ".TABLE_PREFIX.DB_USERTABLE.".".DB_USERTABLE_USERID." ");

define('DB_USERTABLE_LASTACTIVITY',   "user_lastvisit"                     );

/* FUNCTIONS */

function getUserID() {

$userid = 0;

if (!empty($_SESSION['basedata']) && $_SESSION['basedata'] != 'null') {

$_REQUEST['basedata'] = $_SESSION['basedata'];

}

if (!empty($_REQUEST['basedata'])) {

$userid = $_REQUEST['basedata'];

}

if (!empty($_SESSION['userid'])) {

$userid = $_SESSION['userid'];

}

return $userid;

}

function chatLogin($userName,$userPass){

$userid = 0;

if (filter_var($userName, FILTER_VALIDATE_EMAIL)) {

$sql ="SELECT * FROM `".TABLE_PREFIX.DB_USERTABLE."` WHERE email ='".$userName."'";

} else {

$sql ="SELECT * FROM `".TABLE_PREFIX.DB_USERTABLE."` WHERE username ='".$userName."'"; 

}

$result=mysql_query($sql);

$row = mysql_fetch_array($result);

$salted_password = md5($row1['value'].$userPass.$row['salt']);

if($row['password'] == $salted_password){

$userid = $row['user_id'];

}

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, ".DB_AVATARFIELD." 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 ".DB_AVATARTABLE." 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, ".DB_AVATARFIELD." 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 ".DB_AVATARTABLE." 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 'users.php?id='.$link;

}

function getAvatar($image) {

if (is_file(dirname(dirname(__FILE__)).DIRECTORY_SEPARATOR.'images'.DIRECTORY_SEPARATOR.$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) {

}

define('DB_USERNAME',            "fusion-user-name"                           );

define('DB_PASSWORD',            "fusion-db-passwort"                        );

define('DB_NAME',               "fusion-db-name"                     );

define('TABLE_PREFIX',            "fusioneW6E2_"                              );