<div style="display: flex; flex-wrap: wrap; white-space: pre-wrap; align-items: center; "><img height="20" width="20" style="border-radius:50%; margin-right: 4px;" decoding="async" src="https://avatars.githubusercontent.com/u/36066?s=20&v=4" /><strong>pablobm</strong> created an issue <a href="https://github.com/openstreetmap/openstreetmap-website/issues/6544">(openstreetmap/openstreetmap-website#6544)</a></div>
<h3 dir="auto">Problem</h3>
<p dir="auto">I order to build better spam detection mechanisms, we want the ability to easily reference past spam content.</p>
<p dir="auto">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.</p>
<p dir="auto">Similarly it's not possible to know if a user was self-deleted or was deleted for a different reason.</p>
<h3 dir="auto">Description</h3>
<p dir="auto">Proposal: store the cause of suspension/deletion in DB.</p>
<p dir="auto">Details:</p>
<ul dir="auto">
<li>On the DB table <code class="notranslate">users</code> add new columns <code class="notranslate">suspension_reason character varying</code> and <code class="notranslate">deletion_reason character varying</code>.</li>
<li>When an admin clicks "Hide this User", show an interface asking for the reason.
<ul dir="auto">
<li>Free text, not required.</li>
<li>Include some sort of shortcut for the values <code class="notranslate">spam</code> and <code class="notranslate">abuse</code>.</li>
</ul>
</li>
<li>Similar for "Delete this User".
<ul dir="auto">
<li>QUESTION: what should be the shortcut values?</li>
</ul>
</li>
<li>When a user self-deletes, automatically fill out <code class="notranslate">deletion_reason</code> with the value <code class="notranslate">self-deleted</code>.</li>
</ul>
<h3 dir="auto">Screenshots</h3>
<p dir="auto"><em>No response</em></p>
<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />Reply to this email directly, <a href="https://github.com/openstreetmap/openstreetmap-website/issues/6544">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AAK2OLJBEJD447EFJDPHCHL35SHNNAVCNFSM6AAAAACMS4SG7SVHI2DSMVQWIX3LMV43ASLTON2WKOZTGY2DGMZYGYYTEMY">unsubscribe</a>.<br />You are receiving this because you are subscribed to this thread.<img src="https://github.com/notifications/beacon/AAK2OLPCGUZ7PQIB6KIOSZD35SHNNA5CNFSM6AAAAACMS4SG7SWGG33NNVSW45C7OR4XAZNFJFZXG5LFVJRW63LNMVXHIX3JMTHNSKNJBM.gif" height="1" width="1" alt="" /><span style="color: transparent; font-size: 0; display: none; visibility: hidden; overflow: hidden; opacity: 0; width: 0; height: 0; max-width: 0; max-height: 0; mso-hide: all">Message ID: <span><openstreetmap/openstreetmap-website/issues/6544</span><span>@</span><span>github</span><span>.</span><span>com></span></span></p>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/openstreetmap/openstreetmap-website/issues/6544",
"url": "https://github.com/openstreetmap/openstreetmap-website/issues/6544",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>