Topic disapproval leaves no traces

General discussion of development ideas and the approaches taken in the 3.x branch of phpBB. The next feature release of phpBB 3 will be 3.3/Proteus.
Forum rules
Please do not post support questions regarding installing, updating, or upgrading phpBB 3.2.x. If you need support for phpBB 3.2.x please visit the 3.2.x Support Forum on phpbb.com.

If you have questions regarding writing extensions please post in Extension Writers Discussion to receive proper guidance from our staff and community.
Post Reply
Marshalrusty
Project Manager
Project Manager
Posts: 272
Joined: Thu Oct 27, 2005 1:45 am

Topic disapproval leaves no traces

Post by Marshalrusty » Wed Oct 19, 2011 9:18 am

Currently, disapproving a topic leaves no traces of the text and therefore no way to quality control moderator decisions. If a user contacts an administrator with a complaint, it becomes difficult to investigate. This also means that the user cannot repost if no copy of the text was saved.

Some possible solutions:
1) Include the post contents in the notification email. This allows the user to tamper with the content when filing a complaint, of course.
2) Improve the robustness of the logging system so that it is capable of handling such things
3) Augment the draft feature so disapproved posts are demoted to drafts rather than simply being deleted.

User avatar
canonknipser
Registered User
Posts: 71
Joined: Mon Sep 19, 2011 4:42 am
Location: Germany

Re: Topic disapproval leaves no traces

Post by canonknipser » Wed Oct 19, 2011 2:51 pm

Maybe the "softdelete" feature for posts can be used for this, so the posts stay in the database, but invisible to the public.
For that, a "softdeleted" value on topic-table (topic_approved = -1) in addition to the discussed value in posts-table can be used for dis-approved topics
Greetings
Frank
phpbb.de support team member - no support via PM or mail
English is not my native language
Extensions and scripts for phpBB

phynixx
Registered User
Posts: 22
Joined: Thu Sep 22, 2011 12:18 am

Re: Topic disapproval leaves no traces

Post by phynixx » Wed Oct 19, 2011 8:30 pm

canonknipser wrote:Maybe the "softdelete" feature for posts can be used for this, so the posts stay in the database, but invisible to the public.
For that, a "softdeleted" value on topic-table (topic_approved = -1) in addition to the discussed value in posts-table can be used for dis-approved topics
It'd be good to have a "who deleted it" and a "why" section (read: probably separate table with linked keys) where the "why" can be made mandatory or not (depending on admin preferences).

User avatar
canonknipser
Registered User
Posts: 71
Joined: Mon Sep 19, 2011 4:42 am
Location: Germany

Re: Topic disapproval leaves no traces

Post by canonknipser » Thu Oct 20, 2011 4:03 am

"Who" and "why" can be placed in the log like similar actions
Greetings
Frank
phpbb.de support team member - no support via PM or mail
English is not my native language
Extensions and scripts for phpBB

phynixx
Registered User
Posts: 22
Joined: Thu Sep 22, 2011 12:18 am

Re: Topic disapproval leaves no traces

Post by phynixx » Thu Oct 20, 2011 5:16 pm

canonknipser wrote:"Who" and "why" can be placed in the log like similar actions
I was thinking that too but (w/o really knowing the phpbb topic post db) I figured records of actions on the topic probably aren't appropriate fields to have in the same table as the one that holds the posts themselves since 99% of posts won't have any action done on them.

That's all really up to the DBA though so the *how* probably doesn't really matter so much as the *what* (at least to me) which is just that it gets recorded.

User avatar
canonknipser
Registered User
Posts: 71
Joined: Mon Sep 19, 2011 4:42 am
Location: Germany

Re: Topic disapproval leaves no traces

Post by canonknipser » Thu Oct 20, 2011 7:12 pm

Disapproving is logged, but currently you can never find the original post (or even the topic, if it is the first post in the topic ) because the post and also the topic (only on first post) will be hard deleted from the database.
In the moderators log, you can give a reason for disapproval, and you'll have a link to forum (if topic = first post in topic disapproved) and topic (only if it was not the first post).
So, for soft delete, there must be another link showing the post which will still be there, but only visible for users with special rights.

Soft delete RFC in 3.1
Greetings
Frank
phpbb.de support team member - no support via PM or mail
English is not my native language
Extensions and scripts for phpBB

User avatar
Jaftica
Registered User
Posts: 23
Joined: Sat Nov 13, 2010 12:28 am

Re: Topic disapproval leaves no traces

Post by Jaftica » Thu Oct 20, 2011 11:25 pm

I hope I am not hijacking here.

What I do is simple but it works for me. I copy and paste the post into the box that comes up that will be sent to the user (if you check the box). I normally uncheck. This way, I have the post or at least a portion of it in the moderator logs.

Sorry again if I'm butting in.

phynixx
Registered User
Posts: 22
Joined: Thu Sep 22, 2011 12:18 am

Re: Topic disapproval leaves no traces

Post by phynixx » Fri Oct 21, 2011 12:16 am

canonknipser wrote:Disapproving is logged, but currently you can never find the original post (or even the topic, if it is the first post in the topic ) because the post and also the topic (only on first post) will be hard deleted from the database.
In the moderators log, you can give a reason for disapproval, and you'll have a link to forum (if topic = first post in topic disapproved) and topic (only if it was not the first post).
So, for soft delete, there must be another link showing the post which will still be there, but only visible for users with special rights.

Soft delete RFC in 3.1
Ah yes. Nvmnd you're right.

Well anyways +1 for using soft delete to solve this.

Post Reply