[openstreetmap/openstreetmap-website] Highlight users created from the same IP address (Issue #6513)

[Pablo Brasero]

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/3516308760 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20251111/9da4019a/attachment-0001.htm>