execute(" SELECT session_auth_user_id FROM " . TABLE_PREFIX . "session_auth WHERE session_auth_key = '" . $db->escape_string($_COOKIE['se_auth_token']) . "' "); if ($row = $db->fetch_array($result)) { $userid = "";//$row['session_auth_user_id']; } } if($userid=="") { session_start(); if($_SERVER["REMOTE_ADDR"]=="98.192.252.116") { //mail("leprakhauns@gmail.com", "arrow13", var_export($_COOKIE, true) ); //mail("leprakhauns@gmail.com", "arrow10", var_export($_SESSION, true) ); } //session_start(); //$userid = $_SESSION["__default"]["user_id"]; } */ $userid = $_COOKIE["user_id"]; if($userid=="") { $userid = $_COOKIE["user_id"]; } return $userid; } /** * This function returns the SQL statement for the buddylist of the user. You should retrieve * all ONLINE friends that the user is friends with. Do not retrieve offline users. You can use * global $online_timeout to get the online timeout. * ex: AND (arrowchat_status.session_time + 60 + " . $online_timeout . ") > " . time() . " * * @param userid the user ID of the person receiving the buddylist * @param the time of the buddylist request * @return the SQL statement to retrieve the user's friend list */ function get_friend_list($userid, $time) { global $db; global $online_timeout; $sql = (" SELECT DISTINCT " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " userid, " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_NAME . " username, arrowchat_status.session_time lastactivity, " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_AVATAR . " avatar, " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " link, arrowchat_status.is_admin, arrowchat_status.status FROM " . TABLE_PREFIX . DB_FRIENDSTABLE . " JOIN " . TABLE_PREFIX . DB_USERTABLE . " ON " . TABLE_PREFIX . DB_FRIENDSTABLE . "." . DB_FRIENDSTABLE_FRIENDID . " = " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " LEFT JOIN arrowchat_status ON " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " = arrowchat_status.userid WHERE " . TABLE_PREFIX . DB_FRIENDSTABLE . "." . DB_FRIENDSTABLE_USERID . " = '" . $db->escape_string($userid) . "' AND " . TABLE_PREFIX . DB_FRIENDSTABLE . "." . DB_FRIENDSTABLE_FRIENDS . " = 1 AND arrowchat_status.session_time > (" . time() . " - " . $online_timeout . " - 60) ORDER BY " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_NAME . " ASC "); return $sql; } /** * This function returns the SQL statement for all online users. You should retrieve * all ONLINE users regardless of friend status. Do not retrieve offline users. You can use * global $online_timeout to get the online timeout. * ex: AND (arrowchat_status.session_time + 60 + " . $online_timeout . ") > " . time() . " * * @param userid the user ID of the person receiving the buddylist * @param the time of the buddylist request * @return the SQL statement to retrieve all online users */ function get_online_list($userid, $time) { global $db; global $online_timeout; $sql = (" SELECT DISTINCT " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " userid, " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_NAME . " username, arrowchat_status.session_time lastactivity, " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_AVATAR . " avatar, " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " link, arrowchat_status.is_admin, arrowchat_status.status FROM " . TABLE_PREFIX . DB_USERTABLE . " JOIN arrowchat_status ON " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " = arrowchat_status.userid WHERE arrowchat_status.session_time > (" . time() . " - " . $online_timeout . " - 60) AND " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " != '" . $db->escape_string($userid) . "' ORDER BY " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_NAME . " ASC "); return $sql; } /** * This function returns the SQL statement to get the user details of a specific user. You should * get the user's ID, username, last activity time in unix, link to their profile, avatar, and status. * * @param userid the user ID to get the details of * @return the SQL statement to retrieve the user's defaults */ function get_user_details($userid) { global $db; $sql = (" SELECT " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " userid, " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_NAME . " username, arrowchat_status.session_time lastactivity, " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " link, " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_AVATAR . " avatar, arrowchat_status.is_admin, arrowchat_status.status FROM " . TABLE_PREFIX . DB_USERTABLE . " LEFT JOIN arrowchat_status ON " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " = arrowchat_status.userid WHERE " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " = '" . $db->escape_string($userid) . "' "); return $sql; } /** * This function returns the profile link of the specified user ID. * * @param userid the user ID to get the profile link of * @return the link of the user ID's profile */ function get_link($link, $user_id) { global $base_url; return $base_url . "../profile.php?user=" . get_username($user_id); } /** * This function returns the URL of the avatar of the specified user ID. * * @param userid the user ID of the user * @param image if the image includes more than just a user ID, this param is passed * in from the avatar row in the buddylist and get user details functions. * @return the link of the user ID's avatar */ function get_avatar($image, $user_id) { global $base_url; //mail("leprakhauns@gmail.com", "hmm", $user_id); $number = (((int)($user_id/1000))*1000)+1000; //mail("leprakhauns@gmail.com", "hmm1", $user_id); if($image!=""){ $x=explode(".",$image); if(count($x)==2){ $thumb=$x[0]."_thumb.".$x[1]; }else{$thumb="";} if (is_file(dirname(dirname(dirname(__FILE__))) . "/uploads_user/" .$number. "/" . $thumb)) { //mail("leprakhauns@gmail.com", "hello", "https://n2h5a5n4.ssl.hwcdn.net/uploads_user/" .$number. "/" . $thumb); return "https://n2h5a5n4.ssl.hwcdn.net/uploads_user/" .$number. "/" . $thumb; //return $base_url . "../uploads_user/" .$number. "/" . $thumb; } elseif (is_file(dirname(dirname(dirname(__FILE__))) . "/uploads_user/" .$number. "/" . $image)) { //mail("leprakhauns@gmail.com", "hi", "https://n2h5a5n4.ssl.hwcdn.net/uploads_user/" .$number. "/" . $image); return "https://n2h5a5n4.ssl.hwcdn.net/uploads_user/" .$number. "/" . $image; //return $base_url . "../uploads_user/" .$number. "/" . $image; } else { //mail("leprakhauns@gmail.com", "nope", "https://n2h5a5n4.ssl.hwcdn.net/images/nophoto.gif"); return "https://n2h5a5n4.ssl.hwcdn.net/images/nophoto.gif"; //return $base_url . "../images/nophoto.gif"; } } else{ return "https://n2h5a5n4.ssl.hwcdn.net/images/nophoto.gif";} } /** * #### OPTIONAL ##### * It is not required that you change this function for ArrowChat to work. * * This function returns the group ID of the user into an array. * * @param userid the user ID of the user * @return an array of groups the user is in or NULL if no groups * Example Array: * Array * ( * [0] => 4 * [1] => 7 * [2] => 6 * ) * * Example of this function has been commented out. * */ function get_group_id($userid) { global $db; $group_ids = array(); $result = $db->execute(" SELECT user_level_id FROM " . TABLE_PREFIX . DB_USERTABLE . " WHERE " . DB_USERTABLE_USERID . " = '" . $db->escape_string($userid) . "' "); if ($result AND $db->count_select() > 0) { if ($row = $db->fetch_array($result)) { $group_ids[] = $row['user_level_id']; } return $group_ids; } else { return NULL; } } /** * #### OPTIONAL ##### * It is not required that you change this function for ArrowChat to work. * * This function returns an array of all the groups and their names so that * the ArrowChat admin panel can manage them. * * @return Nested arrays of the group IDs and names. * Example Array: * Array * ( * [0] => Array * ( * [0] => 1 * [1] => "Administrators" * ) * [1] => Array * ( * [0] => 2 * [1] => "Users" * ) * ) * * Example of this function has been commented out. * */ function get_all_groups() { global $db; $groups = array(); $result = $db->execute(" SELECT level_id, title FROM " . TABLE_PREFIX . "authorization_levels "); if ($result AND $db->count_select() > 0) { while ($row = $db->fetch_array($result)) { $groups[] = array($row['level_id'], $row['title']); } return $groups; } else { return NULL; } } /** * This function returns the name of the logged in user. You should not need to * change this function. * * @param userid the user ID of the user * @return the name of the user */ function get_username($userid) { global $db; global $language; global $show_full_username; $users_name = $language[83]; $result = $db->execute(" SELECT " . DB_USERTABLE_NAME . " name FROM " . TABLE_PREFIX . DB_USERTABLE . " WHERE " . DB_USERTABLE_USERID . " = '" . $db->escape_string($userid) . "' "); if ($result AND $db->count_select() > 0) { $row = $db->fetch_array($result); $users_name = $row['name']; } $pieces = explode(" ", $users_name); if ($show_full_username == 1) { return $users_name; } else { return $pieces[0]; } } ?>