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

### Problem

I order to build better spam detection mechanisms, we want the ability to 
easily reference past spam content.

However currently we can only do this approximately as, currently, when a user 
is suspended we do not store the reason for this in DB. When later we want to 
get metrics on how many accounts were suspended for spam, we have to resort to 
heuristics.

Similarly it's not possible to know if a user was self-deleted or was deleted 
for a different reason.

### Description

Proposal: store the cause of suspension/deletion in DB.

Details:
- On the DB table `users` add new columns `suspension_reason character varying` 
and `deletion_reason character varying`.
- When an admin clicks "Hide this User", show an interface asking for the 
reason.
        - Free text, not required.
        - Include some sort of shortcut for the values `spam` and `abuse`.
- Similar for "Delete this User".
        - QUESTION: what should be the shortcut values?
- When a user self-deletes, automatically fill out `deletion_reason` with the 
value `self-deleted`.

### Screenshots

_No response_

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

Message ID: <openstreetmap/openstreetmap-website/issues/[email protected]>
_______________________________________________
rails-dev mailing list
[email protected]
https://lists.openstreetmap.org/listinfo/rails-dev

Reply via email to