Simple moderation queue

[dietrichm]

Simple moderation queue, mainly for anti-spam reasons, setting new messages from potential spammers as unpublished until an admin/mod publishes them.

Unpublished messages are not displayed to guests or members.

[dietrichm]

publishedcolumn added to posts. Should also:

• Add config setting for potential spammers to keep posts unpublished.
• Denote this on posting form.
• Ensure these posts are kept unpublished, and the last post references are not updated.
• Add conditions to query that hide unpublished posts for non-staff.
  • Applies to topics, topic reviews, search, etc.
• Some way of marking unpublished posts for staff.
• Publishing single post / all posts for a user.
  • Update last post references.

[dietrichm]

Up to some point (checking whether can view data, extra table columns, config settings, ...) changes have been made to the branch for this issue. However I have decided to currently not continue the work for this issue, and release 1.0.15.

Likely this will even never get finished, because it seems a lot is going to be changed in the database, column values getting different meanings, etc that could break mods and custom scripts. I don't think this is worth it. Also, without automated tests it is hard to test whether something broke along the way.

I refer to v2 for a more flexible and supported mod queue.