function find_users($token = null, $search) { global $error_message; $db = new Database(df_db()); $user = get_user(); if (!$user) { $error_message = "You are not logged in"; return false; } $out = $db->getObjects("select p.username, p.avatar, p.screen_name, if(f.user1 IS NULL, 0, 1) as is_friend,\n if(pending_invites.sender IS NULL, 0, 1) as has_pending_invite\n from profiles p \n left join friends f on ((p.username=f.user1 and f.user2=:user) or (p.username=f.user2 and f.user1=:user)) \n left join friend_requests pending_invites on (pending_invites.receiver=p.username and pending_invites.sender=:user)\n where (p.username like :query or p.screen_name like :query) and p.username != :user limit 100", array('query' => '%' . $search . '%', 'user' => $user)); foreach ($out as $o) { $o->avatar = get_avatar_url($o); } return $out; }