= 2) { if ($disable_buddy_list == 1 OR check_if_guest($userid) OR NO_FREIND_SYSTEM == 1 OR ($is_admin == 1 AND $admin_chat_all == 1) OR ($is_mod == 1 AND $admin_chat_all == 1)) { // Get search results for all users both online and offline $result = $db->execute(" SELECT DISTINCT " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_NAME . " name, " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " userid, arrowchat_status.status status, arrowchat_status.session_time session_time, arrowchat_status.is_admin is_admin FROM " . TABLE_PREFIX . DB_USERTABLE . " INNER JOIN arrowchat_status ON " . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_USERID . " = arrowchat_status.userid WHERE LOWER(" . DB_USERTABLE_NAME . ") LIKE '%" . $db->escape_string(strtolower($search_name)) . "%' ORDER BY CASE WHEN LOWER(name) LIKE '" . $db->escape_string(strtolower($search_name)) . "%' THEN 1 WHEN LOWER(name) LIKE '%" . $db->escape_string(strtolower($search_name)) . "' THEN 2 ELSE 3 END, session_time DESC LIMIT 25 "); if ($result AND $db->count_select() > 0) { while ($rows1[] = $db->fetch_array($result)){} $search_results = true; } $result = $db->execute(" SELECT userid, guest_name name, session_time, status FROM arrowchat_status WHERE LOWER(guest_name) LIKE '%" . $db->escape_string(strtolower($search_name)) . "%' ORDER BY CASE WHEN LOWER(name) LIKE '" . $db->escape_string(strtolower($search_name)) . "%' THEN 1 WHEN LOWER(name) LIKE '%" . $db->escape_string(strtolower($search_name)) . "' THEN 2 ELSE 3 END, session_time DESC LIMIT 25 "); if ($result AND $db->count_select() > 0) { while ($rows2[] = $db->fetch_array($result)){} $search_results = true; } $merged_results = array_merge($rows1, $rows2); } else { // Get search results for users that are on the friend's list only $friends_list_enabled = true; $online_timeout = time(); $sql = get_friend_list($userid, 0); $sql = str_replace("WHERE ", "WHERE LOWER(" . TABLE_PREFIX . DB_USERTABLE . "." . DB_USERTABLE_NAME . ") LIKE '%" . $db->escape_string(strtolower($search_name)) . "%' AND ", $sql); $sql = str_replace("ORDER BY ", "ORDER BY CASE WHEN LOWER(username) LIKE '" . $db->escape_string(strtolower($search_name)) . "%' THEN 1 WHEN LOWER(username) LIKE '%" . $db->escape_string(strtolower($search_name)) . "' THEN 2 ELSE 3 END, ", $sql); $sql = $sql . " LIMIT 25"; $result = $db->execute($sql); if ($result AND $db->count_select() > 0) { while ($rows1[] = $db->fetch_array($result)){} $search_results = true; } $merged_results = array_merge($rows1, $rows2); } if ($search_results) { // Process SQL search results $online_timeout = $old_online_timeout; if (!empty($block_chats)) { $block_chats_unserialized = unserialize($block_chats); if (!is_array($block_chats_unserialized)) { $block_chats_unserialized = array(); } } else { $block_chats_unserialized = array(); } foreach ($merged_results as $row) { if (!empty($row)) { if (!empty($row['lastactivity'])) { $row['session_time'] = $row['lastactivity']; } if (!empty($row['username'])) { $row['name'] = $row['username']; } if ($row['userid'] != $userid) { if ((($time-$row['session_time']) < $online_timeout) AND $row['status'] != 'invisible' AND $row['status'] != 'offline') { if ($row['status'] != 'busy' AND $row['status'] != 'away') { $row['status'] = 'available'; } } else { if ($row['status'] == 'invisible') { $row['status'] = 'offline'; } else { $row['status'] = 'offline'; } } if (empty($row['is_admin'])) { $row['is_admin'] = 0; } $show_user = false; if ($friends_list_enabled) { $show_user = true; } else if (check_if_guest($userid)) { if ($guests_chat_with == 1) { if (check_if_guest($row['userid'])) $show_user = true; } else if ($guests_chat_with == 2) { $show_user = true; } else if ($guests_chat_with == 3) { if (!check_if_guest($row['userid'])) $show_user = true; } else if ($guests_chat_with == 4) { if ($row['is_admin'] == 1) $show_user = true; } else { $show_user = true; } } else { if ($users_chat_with == 1) { if (check_if_guest($row['userid'])) $show_user = true; } else if ($users_chat_with == 2) { $show_user = true; } else if ($users_chat_with == 3) { if (!check_if_guest($row['userid'])) $show_user = true; } else if ($guests_chat_with == 4) { if ($row['is_admin'] == 1) $show_user = true; } else { $show_user = true; } } if ($hide_admins_buddylist == 1 AND $row['is_admin'] == 1) { $show_user = false; } if (($is_admin == 1 AND $admin_chat_all == 1) OR ($is_mod == 1 AND $admin_chat_all == 1)) { $show_user = true; } $avatar = $base_url . AC_FOLDER_ADMIN . "/images/img-no-avatar.png"; if (!in_array($row['userid'], $block_chats_unserialized)) { if (!empty($row['name']) AND $show_user) { $searched_users[] = array('id' => $row['userid'], 'name' => $row['name'], 'avatar' => $avatar, 'status' => $row['status']); } } } } } if (!empty($searched_users)) { $response['search'] = $searched_users; } } } header('Content-type: application/json; charset=utf-8'); echo json_encode($response); close_session(); exit; ?>