Hi chaps
I’m a little confused about /admin/reports/user_flagging_ratio, either I’m doing something wrong or I think it’s bugged. I’ve tested it with someone who flagged 5 posts, agreed and took no action, this didn’t update so I thought maybe “agreed” needs to be “agreed and took action”, ran the test again silencing, suspending and hiding posts and no update.
The other flagging areas seem to be working fine.
So this specific report is broken?
It appears to be yes, this section believes our site has had about 25 flags since the new year, anything else that refers to flags on the dash appears ok.
The game plan as we grow is to pay the top 10 “most helpful” flaggers in the community to incentivise and outsource moderating by tweaking flags… That’s how I ended up on that report which I suppose is rarely looked at otherwise.
We’re on Beta9+399
我认为这应该能解决问题：
我们之前遇到的问题是为了避免某些错误，使用了 HAVING #{disagreed} > #{agreed} 子句，这实际上导致大量结果无法显示。
如果你有 5 个“不同意”标记和 20 个“同意”标记，结果中将不会显示。此修复还调整了那些“不同意”标记为 0 的用户，他们的得分将变为 agreed^2。