edit file integration.php
[code]
/* DATABASE */
define('DB_SERVER', 'localhost' );// can be different
define('DB_PORT', '3306' );
define('DB_USERNAME', '******' );// change this
define('DB_PASSWORD', '******' );// change this
define('DB_NAME', '******' );// change this
define('TABLE_PREFIX', 'jcow_' );
define('DB_USERTABLE', 'accounts' );
define('DB_USERTABLE_NAME', 'fullname' );// or username
define('DB_USERTABLE_USERID', 'id' );
define('DB_USERTABLE_LASTACTIVITY', 'lastlogin' );
[/code]
[code]
function getUserID() {
$userid = 0;
if (!empty($_SESSION['uid'])) {
$userid = $_SESSION['uid'];
}
return $userid;
}
[/code]
[code]
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.".avatar avatar, ".TABLE_PREFIX.DB_USERTABLE.".username link, cometchat_status.message, cometchat_status.status from ".TABLE_PREFIX."friends join ".TABLE_PREFIX.DB_USERTABLE." on ".TABLE_PREFIX."friends.fid = ".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.uid = '".mysql_real_escape_string($userid)."' order by username asc");
return $sql;
}
[/code]
[code]
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.".username link, ".TABLE_PREFIX.DB_USERTABLE.".avatar 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;
}
[/code]
[code]
function getLink($link) {
return 'u/'.$link;
}
[/code]
[code]
function getAvatar($image) {
if (is_file($_SERVER['DOCUMENT_ROOT'].'/uploads/avatars/'.$image)) {
return '/uploads/avatars/'.$image;
} else {
return '/uploads/avatars/undefined.jpg';
}
}
[/code]
trus ketik
http://domainagan.com/direktori_agan/install.php
trus copy code nyang agan dapet di bagian theme agan