How to get list of online friends using FQL with facebook API ?

Question

I have got my friends list after getting logging in on facebook using Facebook connect Java script client API. I want list of my friends that are online at given time.

Answer 1

Please see this:

http://wiki.developers.facebook.com/index.php/Sample%5FFQL%5FQueries

Answer 2

You can use the online_presence column of the user table, which gives the user's current Facebook Chat status. This isn't a foolproof "is this user online right now" but it does serve the general purpose as such. This column is a string which has one of four possible values: active, idle, offline, or error. Querying the friend table in conjunction with this can yield the result you requested (in this case I consider "online" to mean active or idle):

SELECT uid FROM user WHERE
  online_presence IN ('active', 'idle')
  AND uid IN (
    SELECT uid2 FROM friend WHERE uid1 = $user_id
  )