Moderators Functions - Moderator Checkpoint System

Moderator Checkpoint System

For boards with a large moderating staff, it can be difficult to know who has checked what post and which threads are completely checked. The goal of the Moderator Checkpoint System is to ensure that moderators don't read over the same post(s) twice, leaving them to spend this time checking other posts/threads.

The core functionality of the Moderator Checkpoint System (MCS) is the ability (for those with appropriate permission) to mark threads/posts as having been "Checked" - indicating that no further action is required and the thread(s)/post(s) has/have been given the OK by a Staff Member. When a post is marked as checked, the checking user's User ID, Username, and a timestamp is stored in the database. This information then appears on the checked post(s), and the post will change markup (depending on your customizations through the included options) indicating the post has been checked. This process is, of course, completely invisible to the community at-large, and only those Users with adequate permission will be allowed to Check/Uncheck and view Checked posts/threads.

Because some Moderators may like to browse forums normally, a feature has been integrated that will allow each user to Enable/Disable viewing the forum in "Moderation Mode" at their leisure. Disabling Moderation Mode will return the display of posts/threads to their normal state.

Features

• Forumdisplay
  • Threads can be (Admin Optional) colored according to whether they are completely checked -OR- contain unchecked posts.
  • A new column next to "Views" will display the number of Unchecked Posts in each thread.
  • Clicking the "Unchecked" column's header will allow the user to sort threads by the least/most number of unchecked posts, allowing them to see which threads need the most attention.
  • Threads can be (Admin Optional) marked as "Checked", thereby checking ALL the posts in a thread. This is useful for large, old threads which you know contain no problem posts.
• Showthread
  • Posts can be (Admin Optional) colored according to whether they have been checked -OR- remain to be checked.
  • Checked posts will display the Date/Time they were Checked and the Moderator Username/User ID who checked it. (Unchecked posts will have text indicating as much)
  • Posts can be marked as Checked/Unchecked via Inline Moderation.
  • "Active Checking" is utilized.
    • Active Checking is a feature which each User can Enable/Disable at their leisure. When Active Checking is Enabled, each time the User visits a thread, the posts displayed on that page will be marked as "Checked". The idea is that when in Active Checking mode, the User is actively reviewing the posts that they are reading, thus each can be marked as Checked.
  • Newly Checked Posts can be (Admin Optional) colored to indicate their recent activity. This coloring is visible only to the Checking User and is intended to serve as a guide for them to see which posts they, in their current session, have checked.
• Update Counters
  • If you ever feel your counters (Unchecked Count per Thread) are off, there is an Update Counters feature included in the modification. To access this feature, go to your AdminCP -> Maintenance (Very bottom) -> Update Counters -> Update Checkcount Counters (Very bottom).
    

Installation

1. Import the Product XML file.
   1. (a) IMPORTANT: THIS PRODUCT ADDS COLUMNS TO YOUR DATABASE'S POST TABLE. IF YOU HAVE A LARGE NUMBER OF POSTS, THE IMPORT PROCESS WILL TAKE SOME TIME (AND MAY APPEAR TO HANG); IT IS *IMPORTANT* THAT YOU DO NOT EXIT YOUR BROWSER DURING THE INSTALLATION PROCESS
2. Follow the instructions included in the ZIP archive to edit your templates.
3. Configuration Options are accessible through AdminCP -> vBulletin Options -> Moderator Checkpoint Configuration. Permissions are accessible through the Moderator Permissions panel (AdminCP -> Forums & Moderators -> Show All Moderators -> Edit Permissions.

Upgrade

• Upgrading from 1.0.9 to 1.1.1: https://vborg.vbsupport.ru/showpost....9&postcount=44
• Upgrading from 1.1.1 to 1.1.5: https://vborg.vbsupport.ru/showpost....5&postcount=76
• Upgrading from 1.1.5 to 1.1.6: https://vborg.vbsupport.ru/showpost....6&postcount=88
  

If you like this modification, feel free to Nominate it for Modification of the Month. Please click Install if you're actively using it, so you can receive updates about new releases.

This modification was written by request for Spinball, whose MCS Concept was utilized throughout development.
------------------------------------------------------------

Version History:
1.1.7 - Fixes Checkcount Display Bug in Forumdisplay
1.1.6 - Fixes Announcement Bug in Forumdisplay
1.1.5 - Prevents Checks/Unchecks from being written to the Moderator Log
1.1.4 - Added option for Default Moderation Mode
1.1.3 - Bug fixes
1.1.2 - Bug fixes
1.1.1 - Bug fix for soft-deleted post redirection issue
1.1.0 - Core code consolidated - numerous bug fixes
1.0.9 - Minor SQL Query fix
1.0.8 - Bug fix to correct issue with Forumdisplay sorting of Unchecked Threads
1.0.7 - Bug fix to correct counters not carrying over when merging threads
1.0.6 - Initial Release to Community

[PyroMarkus]

That would be even better, Kirk! No to search for "new" threads/posts as normal in vB, but search for unchecked threads/posts - this would be great, yes!

If this is too time consuming/difficult, then it would be fine, if the normal vB search result from any search would mark threads containing unchecked messages.

I have some searches "preperated" for my users/mods, which say
- new messages since last visited
- new messages since the last X days (where X is to specify 1, 2 ... more days).

With these two searches my moderators look for new threads/messages - noone of them is crawling the single forums. Marking unchecked threads in their search results would be great.

But both versions are very fine and would be highly appreciated!
Thank you for your quick answer and the great mod!

[Kirk Y]

Ah, OK, I see what you mean now. I'll see what I can do for the next release.

[Cristi_XP]

ok,i get myslq gone away when I try to install this .
What queries should i use to remove from DB the changes that where made,because i cannot install this,so I can run uninstall.

[Kirk Y]

It would help if you *explained* whatever problem you're having.

[Cristi_XP]

whenever i try to upload the product I get DB error,Mysql server has gone away.Probablly it hangs to much ,and the mysql kills the connection,and i thought that though the instalation wasn`t complete,there are still changes made to the DB ...so I want to undo the changes.

[Kirk Y]

How many posts does your board have?

The following queries are executed on the removal of this modification:

// Drop Post Columns
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "post DROP ischecked");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "post DROP checkedby");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "post DROP checkedbyu");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "post DROP checkedtime");

// Drop Moderator Columns
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "moderator DROP cancheck");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "moderator DROP cancheck_whole");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "moderator DROP canuncheck");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "moderator DROP canuncheck_others");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "moderator DROP canuncheck_whole");

// Drop Thread Columns
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "thread DROP checkcount");

[Deviant K1]

Thanks.. great mod! **INSTALLED**

[Kirk Y]

v1.1.6 released--

Announcement bug in Forumdisplay fixed. (Thanks Wuelfi)

Upgrading
To upgrade simply upload (allow overwrite) the new product XML.

[wuelfi71]

Originally Posted by Kirk Y

Cont'd-- Wuelfi, I've setup some test threads on my development board and am unable to replicate this bug (negative counters on 1000k+ post threads). Could you describe the bug further? When was the last time you updated your post/thread checkcount counters?

Oh, i update them regulary, that has nothing to do with the bug. I made a hardcopy and attached it.

Originally Posted by Kirk Y

v1.1.6 released--

Announcement bug in Forumdisplay fixed. (Thanks Wuelfi)

That's wonderful, thank you for your work^^

Another slight problem: When i keep logged in und return to the forum, moderation mode is always "off". When i log out and log in again it's "on" like it should be in version 1.1.6. But when i return without logging out, it's "off" again.

[Kirk Y]

The Moderator cookie is set to expire at the end of your session (when you close your browser). I'll increase the expiry date in the next release.

Regarding the check count bug: can you reset your thread/post check count counters and then see if it still shows the negative value?