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

[Pablo Brasero]

pablobm created an issue (openstreetmap/openstreetmap-website#6513)

### Problem

DWG often has to deal with users creating multiple accounts (sock puppets) in order to abuse features of OSM.

### Description

Detecting sock puppet accounts is tricky. A first approach could be using the `creation_address` and check how many other users were created from the same one, as follows:

1. Add a column `users.count_users_in_ipaddr`.
2. On user creation.
  - Find any other users with the same `creation_address`.
  - For all of them increase their `count_users_in_ipaddr` in one.
3. Show this number... where exactly? TBD

### Open questions

- [ ] If this was implemented, where would this information be useful and to whom? Ideas below, to be accessible/visible by moderators:
  - A page listing users with high values of `count_users_in_ipaddr`?
  - A number next to the user name, wherever relevant? Eg: changesets.
  - In the `/issues` list?

To discuss with DWG and maintainers.

### Screenshots

_No response_

-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/issues/6513
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/openstreetmap-website/issues/6513 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20251110/2ae4a1d3/attachment.htm>