Forum features
Steve Pampling (1551) 8155 posts |
Red
Intermediate I hadn’t considered.
> 9 and you’re talking to yourself. Although past experience suggests that would just allow a big, choking build up of dross for some poor soul to remove, so unless the moderator intervenes let the automated element stop additional posts after an additional < arbitrary number > From past experience (the mega spam incidents) I suspect that the facility to block like that doesn’t exist, or it’s a bit more than a trivial exercise to implement, otherwise it would already be there. |
Grahame Parish (436) 480 posts |
You would need to be careful that only users with a certain number of posts could downvote another user to prevent malicious new users from exploiting the system for harm. |
Clive Semmens (2335) 3276 posts |
That doesn’t solve the problem of us malicious old users though. |
Rick Murray (539) 13806 posts |
The Beast website no longer exists (abandoned project), but at one time it proudly presented itself as a functional forum in the least lines of code possible.
There isn’t really a solution. Regard (political) voting, same problem… |
Clive Semmens (2335) 3276 posts |
And there you have it. To so many things. |
Stuart Painting (5389) 712 posts |
That is in fact very easy to do: just delete the user. Admittedly it gets done in a rather messy way: threads started by the now-deleted user disappear in their entirety, and if anyone tries to access one of the deleted threads they get the error message “Application error: Rails” instead of a 404. |
Dave Higton (1515) 3497 posts |
Deleting a user does not delete their posts or topics started by them. |
Stuart Painting (5389) 712 posts |
In that case, the forum code has been updated since November of last year. While I welcome this news, it is a little odd that no mention was made of the update (Changeset 481 – the most recent change – doesn’t seem to cover it at all, and Changeset 480 dates from 2020). |
Rick Murray (539) 13806 posts |
What makes you think it wasn’t done manually? |
Stuart Painting (5389) 712 posts |
Two reasons:
If we posit an administrator manually deleting 2600 individual messages (and assuming 5 seconds per message deletion) that comes in at 3.6 hours elapsed. Achievable, but decidedly tedious. |
Rick Murray (539) 13806 posts |
There’s your problem right there. Remember I said this:
So… something like? SELECT ALL TOPICS WHERE TOPIC_CREATOR = "Troll" SELECT ALL MESSAGES WHERE MESSAGE_TOPIC = SELECTED DELETE -withoutprejudice SELECT ALL MESSAGES WHERE TOPIC AUTHOR = "Troll" DELETE -withoutprejudice DROP "Troll" HARD ON HIS BONCE TWICE I’ll let somebody else bash that into something that resembles coherent SQL. |
Steve Pampling (1551) 8155 posts |
Simpify. Presume that messages with no valid author are marked as invalid and are hidden and marked for purge at next database clean/re-index. So: Delete account – trigger feature of display system for message database and hide all orphaned messages (of the thread originator) |
Stuart Painting (5389) 712 posts |
What you are suggesting is pretty much exactly what happened on 07 November 2021, either automatically (when the user account was deleted) or by the admins running a database script. So it looks like the admins already have this one covered, one way or the other. |
Sprow (202) 1155 posts |
Most likely is that the person in question invoked their right to be forgotten under the website privacy policy which says account deletion doesn’t by default delete history. Some database foo was clearly done behind the scenes to satisfy the request. That left the question of what to do about threads the user had contributed to. It’d be a bit odd to come back to a linked thread and only find one half the conversation there (or people appearing to talk to themselves), so I guess the least bad option was to drop threads started by the user entirely, but not those where they’d merely commented part way through. |