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 として計算されるようになります。