[SNS] 페이스북 몇가지 기능의 FQL

1. 페이지의 최신 게시물(stream) 가져오기
select post_id from stream where source_id=page_id and created_time>=1379003538

2. 페이지의 최신 댓글 가져오기
select id from comment where post_id IN (select post_id from stream where source_id=page_id limit 999999) and time>=1379003538

3. stream like 검색
SELECT message FROM stream WHERE source_id=page_id
AND strpos(lower(message),lower('검색어')) >=0

Posted by incree

2013/09/14 02:26 2013/09/14 02:26
, , , , , ,
Response
0 Trackbacks , 0 Comments
RSS :
http://www.incree.com/tc/incree/rss/response/267

Trackback URL : 이 글에는 트랙백을 보낼 수 없습니다


Notices

Archives

Authors

  1. incree

Recent Trackbacks

Calendar

«   2017/06   »
        1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30  

Site Stats

Total hits:
409984
Today:
12
Yesterday:
155