按应用程序 ID 使用 FQL 检索所有评论

发布于 2024-12-01 11:44:25 字数 574 浏览 2 评论 0原文

我们使用 Facebook 评论插件在我们的网站上发表评论。

为了调节这些内容,我们使用此工具:https://developers.facebook.com/tools/comments

然而,我们希望构建自己的工具来审核这些评论,并将其集成到我们现有的软件中。

我找不到正确的方法来做到这一点。经过几个小时的研究,我现在发现的唯一方法是这个 FQL 查询:

select post_fbid, fromid, object_id, text, time from comment where object_id in (select comments_fbid from link_stat where url ='URL_HERE')

这不起作用,因为我们有数千个不同的 URL,我无法每次都查询它们以查看是否有任何新评论。

我需要一种方法,只需输入我们的 app_id、域名或类似内容即可获取所有(新)评论,

我该怎么做?

We use the facebook comment plugin to have comments on our site.

To moderate those, we use this tool: https://developers.facebook.com/tools/comments

However, we want to build our own tool to moderate those comments, and integrate it to our existing software.

I can't find a proper way of doing this. the only way I found out now after hours of research is this FQL query:

select post_fbid, fromid, object_id, text, time from comment where object_id in (select comments_fbid from link_stat where url ='URL_HERE')

That doesn't work because we have thousands of different URL's and I cant query each of them every time to see if there are any new comments.

I need a way to get all (new) comments by just enter our app_id, domain or something like that

How can I do this?

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(2

策马西风 2024-12-08 11:44:25

我正在考虑做同样的事情 - 获取我的应用程序的所有用户帖子。我假设这是一个类似的任务。

对于给定的用户,我将滚动浏览提要和主页以查找应用程序帖子。对于您来说,您可以:

`home?fields=comments`
`feed?fields=comments`

并检查“type”和“id”是否与您的应用程序匹配。

I'm considering doing the same thing- grabbing all user posts for my application. I'm assuming it's a similar task.

For given user, I will scroll through feed and home looking for app posts. For you, you'd go:

`home?fields=comments`
`feed?fields=comments`

And check for "type" and "id" to match your application.

猫卆 2024-12-08 11:44:25

此代码查询您的应用程序使用的所有注释 xids:

https://graph.facebook.com/fql?q=SELECT fromid, text, id, time, username, xid, object_id FROM comment WHERE xid IN (SELECT xid FROM comments_info WHERE app_id = {0}) ORDER BY time desc&access_token={1}&format=json

This code queries for all comments xids used by your application:

https://graph.facebook.com/fql?q=SELECT fromid, text, id, time, username, xid, object_id FROM comment WHERE xid IN (SELECT xid FROM comments_info WHERE app_id = {0}) ORDER BY time desc&access_token={1}&format=json
~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文