pablobm left a comment (openstreetmap/openstreetmap-website#6513)
Right, then perhaps this won't be that useful. Having said that, I wonder if
this could be useful against less sophisticated actors. I don't have access to
the DB so I can't answer this question: do we see any correlation between
accounts flagged for abuse, and the "repetiveness" of their
`users.creation_addr`?
As for the implementation detail, what I was thinking was running something
like the following on user creation:
```sql
UPDATE users SET count_users_in_ipaddr = count_users_in_ipaddr + 1 WHERE
creation_addr = ?
```
--
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/issues/6513#issuecomment-3516308760
You are receiving this because you are subscribed to this thread.
Message ID:
<openstreetmap/openstreetmap-website/issues/6513/[email protected]>
_______________________________________________
rails-dev mailing list
[email protected]
https://lists.openstreetmap.org/listinfo/rails-dev
