QUICKMODERATION: Moderation queue info on Forums

What does it do? Well, at the top of all forums will be a bar that tells your mods and admins how many:

• Posts to moderate
• Threads to moderate
• Attachments to moderate
• Events to moderate
• Users to moderate
• Reports that have not been fulfilled (only works for my report system mod)

The features include:

• Links to each type of moderation CP or page
• Can be placed anywhere in the forum, and modded easily (different per skin if you'd like)
• Which usergroup can see quick mod panel can be changed easily
• Option to have the bar turn red if there is something to attend to (a post to moderate, user to moderate, etc.)

Hope this is to your liking, and if anyone has any I am open to suggestions.

The installation requires 2 new plugins, 1 template change, 1 new template and a bit of configuration to choose which options you want.

[high]Plugins[/high]

Open your admincp -> Click Plugin System on the left nav panel -> Click 'Download/upload Plugins' -> Browse to QUICKMOD plugin.xml included in this package.

This adds 2 plugins. One is the quick mod php code + queries. The second is the caching of the quick mod template (not required but recommended).


[high]Templates[/high]

Add new template called navbar_moderation to all styles with this code:

<if condition="$bbuserinfo[usergroupid]=='6' or $bbuserinfo[usergroupid]=='5'">
<!-- Quick Moderation -->
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
	<tr>
		<td class="<if condition="$alertmods==true">alertmod<else />alt1</if>" width="100%">
			<div class="smallfont">
				<b>Quick Moderation:</b> 
				<if condition="$show['threads']">
					<a href="modcp/moderate.php?do=posts">Threads</a>: <b>$threads[count]</b> 
				</if>
				<if condition="$show['posts']">
					<a href="modcp/moderate.php?do=posts#posts">Posts</a>: <b>$posts[count]</b> 
				</if>
				<if condition="$show['attachments']">
					<a href="modcp/moderate.php?do=attachments">Attachments</a>: <b>$attachments[count]</b> 
				</if>
				<if condition="$show['events']">
					<a href="modcp/moderate.php?do=events">Events</a>: <b>$events[count]</b> 
				</if>	
				<if condition="$show['users']">
					Users: <b>$users[count]</b> 
				</if>			
				<if condition="$show['reports']">
					<a href="private.php">Reports Unfulfilled</a>: <b>$reports[count]</b>
				</if>
			</div>
		</td>
	</tr>
</table>
<!-- / Quick Moderation -->
<br />
</if>

Open template called navbar
At absolute bottom of template insert this code:

$moderate

and/or insert it anywhere in any other template if you'd like


[high]Configuration[/high]

To change what user groups can view the quick-mod bar replace

<if condition="$bbuserinfo[usergroupid]=='6' or $bbuserinfo[usergroupid]=='5'">

in the navbar_moderation template with whatever user group IDs you would like. You can find the usergroup IDs in the admincp by clicking 'usergroups' -> 'usergroup manager' then looking at what it says in the dropdown on the right of each user group [example: Edit Usergroup (ID:2)].

You may choose which options are shown on the quick moderation bar through the 'QUICKMOD::code' template

By default all but "reports unfulfilled" are shown on the quick mod bar, you can see that it is commented out using /* and */ (text between those is commented out, meaning it is not included in the code).

The Users, Posts, Threads, Attachments and Events can also be turned off this same way.

To have the quick mod bar show in a red color (or any other color of your choice) if there is something your mods must attend to, replace the following code in the QUICKMOD::code plugin:

//See if any of them are greater than 1
/*
if ($threads['count']>0 or $posts['count']>0 or $reports['count']>0 or $events['count']>0 or $attachments['count']>0 or $users['count']>0)
{
	$alertmods = true;
}

*/

with:

//See if any of them are greater than 1

if ($threads['count']>0 or $posts['count']>0 or $reports['count']>0 or $events['count']>0 or $attachments['count']>0 or $users['count']>0)
{
	$alertmods = true;
}

(it's been uncommented) and then add this css to all of your skins/styles:

.alertmod {
  background-color: #F2D0D0;
  color: #183562;
}

If you want the links to open in a new window, add target="_BLANK" to all links. See here for a better explanation.

That's about it, fairly simple but VERY useful mod. Enjoy
If anyone has any questions or suggestions post, pm or email me.

[joeychgo]

installed on 3.64 with no problems.

[King Justice]

Great plugin! Thank you! Two thumbs up on this one!

[JPnyc]

Excellent plugin. Should be standard, I agree

[Devilbrad]

Installed and working on 3.6.7 Thanks!!!

[halcyoncmdr]

Wonderful mod. Makes it much easier to moderate things. :-)

[tmod]

Ok something weird here.

I have this hack installed on 3.6.7 and it is working but the posts number never returns to 0 even though according to the ACP there is no posts to moderate.

Anyone have any idea why this would happen?

Threads reads 0
Posts reads 1

Thanks!

Tmod

[rossco_2005]

@tmod,

This is a vbulletin bug I encountered ONCE on my own forums.
It left behind the entry in the 'moderation' table even though the post was set to visible (approved).

Here is how I fixed it. You need phpmyadmin access for this method, or if you're familiar with mysql you can come up with a query of your own but I won't spend time on that.

1. Make sure there are no posts, threads, etc. in the moderation queue first!
2. Go into phpmyadmin and browse to the table 'moderation'
3. Click on browse and there should be only ONE entry here. Delete this entry. Backup/export first if you want for safety but there shouldn't be any problem.

[tmod]

rossco_2005,

Thanks for the reply, I am attaching a image of the moderation table and if you could point out what needs to be deleted I would appreciate it.

Thanks!

Tmod

[rossco_2005]

Looks like there's nothing there, I must be wrong.
Sorry let me try and think of something else that might be the problem.

[tmod]

rossco_2005,

Hey you were right on the money as the cause of the problem.

I had a different database selected as I have one test database for my test setup of vBulletin.

Thanks for the info!!

Sorry for the mistake!

Tmod