Created
November 5, 2012 16:59
-
-
Save fritkotparking/4018313 to your computer and use it in GitHub Desktop.
Facebook - FQL: Load friends images
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// Load all friends | |
SELECT uid, name, pic_square FROM user WHERE uid IN (SELECT uid2 FROM friend WHERE uid1 = me()) | |
// Load friend profile pictures | |
SELECT pid, src, src_big FROM photo WHERE aid IN (SELECT aid FROM album WHERE owner=" + uid + " AND type="profile") | |
// Load all photos from a certain person | |
SELECT pid, src, src_big FROM photo WHERE owner=me() | |
SELECT pid, src, src_big FROM photo WHERE owner=" + uid + " | |
// Load photo with specific dimensions | |
SELECT id, width, height, url, is_silhouette, real_width, real_height FROM profile_pic WHERE id=" + uid + " AND width=400 AND height=400 | |
// Extra info on stackoverflow | |
http://facebook.stackoverflow.com/questions/7683230/how-to-retrieve-all-facebook-photos-a-person-is-tagged-in/11188122#11188122 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment