[Spinball]

I want to thank Kirk for scripting this mod for our board.
We used to have an unapproved checkpoint thread in each forum which indicated which threads had been checked. The moderators read those threads newer than the checkpoint thread and then replied to to it to bump it to the top.
But this was crude and didn't prevent moderators from reading the same posts in a thread.
So a while back I kicked around the checkpoint system idea here which helped me focus some ideas.
With help from the moderators on our forum (I have about 60 of them), we nailed the functionality down and Kirk agreed to put it into action.
I feel it's important that the community benefits from ideas like this so I asked Kirk to release it here.
My moderators love this functionality as it saves loads of their precious time and helps them efficiently work their way through posts and threads checking the content for rule breaking, infractions and libellous material.
(Incidentally here in the UK at least, the OWNER of a forum can get sued for libellous contents of their board irrespective of whom wrote it).
I think we're going to become very reliant on this modification very quickly.

I found a couple of SQL statements very useful.
Firstly to assign post check and uncheck permissions to all the moderators in all the forums they moderate (after you have installed the plugin, of course!):

UPDATE moderator SET cancheck=1,canuncheck=1

(remember to put any table prefixes in).
And because we wanted to start with a clean slate and mark all the old threads as having been checked, I ran this:

UPDATE post SET `ischecked`=1, `checkedby`=nnnnn, `checkedbyu`= 'Username', `checkedtime`=xxxxxxxxxx WHERE `ischecked`=0 AND `dateline`<xxxxxxxxxx

Where nnnnn is the id of your chosen moderator, 'Username' is the name of your chosen moderator and xxxxxxxxxx is the unix time before which you want to mark your posts as having been checked.
On our board, we have a system user which I used, and I marked all the posts prior to 01/01/2008 to having been checked on 01/01/2008:

update post set `ischecked`=1, `checkedby`=160503, `checkedbyu`= 'AVForums system', `checkedtime`=1199145600 WHERE `ischecked`=0 AND `dateline`<1199145600

(remember to put any table prefixes in).
This processed 4.7 million posts in a few minutes - which is a lot faster than manually checking all the threads! And afterwards don't forget to run the checked post counter (in admincp->update counters) to correctly set the checked post count in your threads.