Moderation Queue on FORUMHOME

Moderation Queue on FORUMHOME

What does this do?
Adds a Moderation Queue displaying:

• Users needing Moderation
• Threads needing Moderation
• Posts needing Moderation
• Attachments needing Moderation
• Events needing Moderation

Features
Queue stored in collapsable container.
Easily customizable and best of all -- NO Template Edits!
Linked directly to AdminCP/ModCP Moderation Pages.

Installation
1. Download and Unzip the attached ZIP file.
2. Upload includes/xml/bitfield_modqueue.xml to your includes/xml directory.
3. Import the Product XML File.
(Cont'd) 3. If you're Upgrading -- Set Overwrite to YES when importing the XML File.
4. Go to your AdminCP - Usergroups -> Usergroup Manager -> Pick A Usergroup -> Set 'Can View Moderation Queue' to Yes - To allow Usergroups to view the Queue. (See Note Below!)

Version History
1.00 - Initial Release
1.01 - Bug fix: Event SQL had missing tableprefix - Download latest version!
1.02 - Now uses Usergroup Permissions - Download latest version!

Notes
With version 1.02 comes the ability to allow multiple Usergroups the permission to view the Moderation Queue. It should be noted however, that this hack currently pulls ALL Events Needing Moderation. This means that if you're planning on using this with Moderators who can, for example, only Moderate Forum A, then this hack will show ALL of the events needing moderation, not just those in Forum A. The capability for Moderators to only be shown their specific Moderation Events will be coming in the next version.

[Bacon Butty]

Would be great if this could be available for 3.7.

[Gondola]

Also very interested in an update for this.

[lostgirl815]

Me too! It's really really handy. But in 3.7 it causes the forum home page to display a database error message. If you need more specific information I can enable it again and copy the source code. Anyway, posting so I'll know if it's available again.

[Konstantinos]

this is cool but u really need to add an option which stuff to be dispayed. for example there is no need for moderators to see how many users need moderation since they cant use user moderation

[gopherhockey]

Bump... anyone have this for 3.7? I can't believe it hasn't been updated or something similar hasn't been created.

[DVDGuy]

I managed to get this working with a bit of SQL hacking. The reason this stopped working in 3.7.x is because the "moderation" table has changed (from having separate threadid and postid columns, to now a single primaryid column).

I fixed it by editing "product-moderation_forumhome.xml"

Find:

PHP Code:

// ##### Posts to Moderate
if (can_moderate(0, 'canmoderateposts'))
{
$postcount = $db->query_first("
    SELECT COUNT(*) AS count
    FROM " . TABLE_PREFIX . "moderation AS moderation
    INNER JOIN " . TABLE_PREFIX . "post AS post USING (postid)
    WHERE moderation.type='reply'
"); 


Change:
INNER JOIN " . TABLE_PREFIX . "post AS post USING (postid)

To:
INNER JOIN " . TABLE_PREFIX . "post AS post ON post.postid=moderation.primaryid

Similarly, find:

PHP Code:

// ##### Threads to Moderate
$threadcount = $db->query_first("
    SELECT COUNT(*) AS count
    FROM " . TABLE_PREFIX . "moderation AS moderation
    INNER JOIN " . TABLE_PREFIX . "thread AS thread USING (threadid)
    WHERE moderation.type='thread'
"); 


Change:
INNER JOIN " . TABLE_PREFIX . "thread AS thread USING (threadid)

To:
INNER JOIN " . TABLE_PREFIX . "thread AS thread ON thread.threadid=moderation.primaryid

This makes the plugin work for me in 3.7.3.

[epolitica]

Originally Posted by DVDGuy

I managed to get this working with a bit of SQL hacking. The reason this stopped working in 3.7.x is because the "moderation" table has changed (from having separate threadid and postid columns, to now a single primaryid column).

I fixed it by editing "product-moderation_forumhome.xml"

[...]

DVDGuy, you're the man!

Thanks very much, I confirm it works under 3.7.3 :up:

[badboy_29]

I made the edits and they do work. Thank you for posting the changes.

[Meestor_X]

Is there a way to make this mod send a PM or e-mail when there are new items that need moderating? Saves having to continually log into the forum to check.

[DrSnoCaps]

Originally Posted by Meestor_X

Is there a way to make this mod send a PM or e-mail when there are new items that need moderating? Saves having to continually log into the forum to check.

I'll second that!