Database

Question

• 如何允许论坛/博客评论等场所的用户作为垃圾邮件或滥用物标注内容? 我知道,你可以使用诸如基迈特和创建巴斯尼亚垃圾邮件过滤器等服务,但实施一种使用户能够报告内容的制度的最佳方式是什么?

您在称为间谍和(或)旗帜的项目表中增加一个额外领域,以及你如何区别这两个方面? 从根本上说,你将如何建立这样一个系统,数据库结构是什么?

是否有这样的东西在营地?

Answer 1

Database

您希望能详细了解谁在每一个职位上签字,但你也可能希望让许多人也能够宣布一个职位。如果一个人在某一职位上签字,他们的判断可能令人怀疑,但如果20人悬挂该职位,你即立即知道这个问题。

我提出这样一个表格:

flag_seq | post_id | flagger_username |       timestamp     |       user_notes      | active
============================================================================================
       1 |    1431 |          joebob1 | 2010-01-25 13:41:12 | it s spam             | TRUE
       2 |    1431 |      i_hate_spam | 2010-01-25 14:01:23 | You know I hate spam. | TRUE
       3 |    2283 |          joebob1 | 2010-01-24 08:09:57 | vulgar language       | TRUE

保持每个旗帜的轨道将使你能够从行政或温和的水平做一些更先进的事情。

You can keep track of who s flagging stuff (in case someone is abusing that feature i.e. joebob1 doesn t like *i_hate_spam* so they keep flagging their posts as offensive).
You can do a quick count by doing SELECT COUNT(*) FROM flag_table WHERE post_id = 1431 .
You can remove certain flags individually by targeting the flag_seq of the flagged post.
Give the user the ability to include their own comments so you know exactly what and why they re reporting this. You could opt to give them predefined options in a <select> box as well.
Setting an active flag, you never delete your flags even after they ve been dealt with. This is useful for taking stats on flagged posts. You can use this information to justify more moderation staff or justify a time commitment to researching new methods of fighting spam, etc.

Flag this post

一旦建立了你的数据库,你就完全需要把“填补这一员额”连接到每个员额的某个地方。将这一表格与你新创建的数据库联系起来。确保在将数据输入贵国数据库之前,使用<代码>mysql_real_e爱因_string或pg_e爱因_string <>/code>,或使用已准备好的发言稿,妥善地使您的数据制度化。



Moderation

一旦某一职位被撤销,你就可以做一些不同的事。


You could write a cron that will check the amount of flags on each post and take certain actions at certain thresholds.
You could write a moderation page that lists all active flags with different ways to handle them. (e.g. Delete the post, edit the post, ban the poster, all of the above, etc.)

Answer 2

如果你想从头开始就执行这一分析,那么你就应该建立一个有名的报告表。

This table will have these fields:

report_id
post_id
reason
datetime

我认为,情况恰恰相反。

Answer 3

I dont know if there is something built in php. You can surely use an extra field in the table.. Say you have a table post something like

标题内容日期:旗帜

each time some user flags the post as abusive or something, you can simply increment the counter in flags. And if that counter reaches a threshold (keep it low as 3 to 5) depending on how you want to be. If it crosses over the threshold just delete the post or whatever action you want to take!!

Database

Flag this post

Moderation

友情链接