Moderation Queue on FORUMHOME

[Kirk Y]

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 ModerationFeatures
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.

[MentaL]

cool

[SMO]

if one has no moderation awaiting..is it blank?

also, is it possible to add gallery pics/posts and links/posts awaiting as well?

[Kirk Y]

If there aren't any events needing moderation, a message basically stating that will show. Which gallery hack? I suppose I could take a look at it.

[SMO]

If there aren't any events needing moderation, a message basically stating that will show. Which gallery hack? I suppose I could take a look at it.


i use vbgallery (vbagallery) and vba links.

[Kirk Y]

That's a paid modification. I don't have a version to test on, sorry.

[jluerken]

I want to see this for the upcoming vB 3.6.x

[R1D1]

It's possible to run that on 3.5.3?

I get this error:


SELECT COUNT(*) AS count
FROM event AS event
INNER JOIN calendar AS calendar USING (calendarid)
WHERE event.visible = 0;

MySQL-Error: Table 'XXXXXXXXXXXX.event' doesn't exist

[Snake]

Awesome, I'll install this when I get back to home. :)

[Diana Notacat]

Fantastique! I've been waiting for something like this to come along!

[Kirk Y]

It's possible to run that on 3.5.3?

Yes -- that's my fault, I forgot to take into account boards with table prefixes. I'll fix that right now.

I want to see this for the upcoming vB 3.6.x

I don't have a version of that to test on either, lol. But I'll probably be renewing my license sometime next week.

Edit: Product Updated - Fixed Table Prefix bug. Be sure you download the latest version.

[R1D1]

thx for the bugfix! ;)

seems to work now. :)

[UZFRED]

Are super administrators allowed to see the moderation queue, if so, then this modification is not working for me :/.

[coffee_bean]

Does it show the table only to those users with moderation/admin priviledges?

[Kirk Y]

@UZFRED: I set it for only Administrators but I'll add Super Administrators.

@Coffee_bean: At the moment, only Administrators can see it and as I said above -- I'll be adding Super Administrators shortly.

If you'd like to add more Usergroups:

Look for: (In template forumhome_moderationqueue)
<if condition="is_member_of($vbulletin->userinfo,6)">

Replace with:
<if condition="is_member_of($vbulletin->userinfo,6,XX)">

Replace the XX with the Usergroupid of whatever Usergroup you'd like to view the Queue.

[Jafo232]

BTW, this works perfect in conjuction with the Akismet Anti-Spam hack that places suspected SPAM posts/threads into moderation:

https://vborg.vbsupport.ru/showthread.php?t=118421

[sam anders]

installed this hack and works great thanks, but it killed my second navbar please can you help, it looks like when the product is added it over writes my calling to a second navbar: $navbar2

any suggestions?

[Kirk Y]

Mind posting the address to your site? I'll take a look.

One fix I can think off the top of my head is that you'd need to change the forumhome_complete plugin I use that says where to put the Queue. The plugin is called Moderation Queue HTML -- click Edit on that and change '$navbar' to '$navbar2'. That should fix it, but if not, I'll take another look.

[UZFRED]

This isn't working at all for me :s can anybody help me?

I just imported it and nothing happened... I got 5 templates (Default, Air, AirX, Fusion, FusionX) on none of the templates it appeared.

I would really like to have this hack since it tells staff they have things to do.

[Kirk Y]

The two templates included with the product are placed inside the forumhome template category. Have you made any modifications to your forumhome template and do you have the standard navbar on your vBulletin?

Also, what is the Usergroup ID for Administrators on your forum?

[sam anders]

Mind posting the address to your site? I'll take a look.

One fix I can think off the top of my head is that you'd need to change the forumhome_complete plugin I use that says where to put the Queue. The plugin is called Moderation Queue HTML -- click Edit on that and change '$navbar' to '$navbar2'. That should fix it, but if not, I'll take another look.

tried what you mentioned but they removed your mod all together, so reverted back to normal and all ok,still missing my second navbar will have a look this morning and get back to you

[Kirk Y]

If the template was reverted, most likely your $navbar2 variable was removed. If you're willing to try again, I'm certain that applying the change I mentioned would work for you. But that's up to you.

[UZFRED]

The two templates included with the product are placed inside the forumhome template category. Have you made any modifications to your forumhome template and do you have the standard navbar on your vBulletin?

Also, what is the Usergroup ID for Administrators on your forum?

Yes there are probably allot of modifications to my forumhome (ShoutBox, top10 stats,...).

The usergroup of Administrators are the default ones (I never changed), but once I can show it on my homepage I will edit to show to moderators and stuff.

Was hoping maybe you could make a version that allows you to place it yourself on forumhome? Since I think many people will have trouble with it like me.

And if I add buttons for example to my forum template. On the vBulletin Default Style I have to edit navbar to add buttons. For my ExtremePixels styles Air & Fusion I have to edit header for it.

[Kirk Y]

All my plugin does is look for the string: $navbar in your forumhome template. It's a unique string that should be in everyone's template, except for occassional change, as in Sam Anders' case in which there are $navbar and $navbar2.

If you'd like to position the Queue yourself, just go into the Plugin system and disable the 'Moderation Queue HTML' Plugin in the forumhome_complete category. Then take the contents of the template forumhome_moderationqueue and position them as you please. But you should note that the Queue will only work on the forumhome, if you want to put it on other pages, you'll have to make a modification.

If you'd like me to do it for you, I can -- no charge or anything like that.

Also I should note that in the next version, the Queue permissions will be set via Usergroup Permissions, rather than having to edit the template.

[UZFRED]

:0 it's working now. Now I was able to select usergroups it's working. So guess there is nothing wrong after all, just a usergroup issue, nice modification :).

[Kirk Y]

That's good to hear UZ. Hope everything works fine.

[sam anders]

installed this hack and works great thanks, but it killed my second navbar please can you help, it looks like when the product is added it over writes my calling to a second navbar: $navbar2

any suggestions?

this has now been fix, removed the navbar mod and reinstalled this hack then installed a different navbar hack and all ok :banana:

great hack works very well now :)

[bashy]

I did take a look at this but i have 40 querires already on my forumhone adding another 6 will not do any favours, big shame though as i was looking for something like this!!

Thanks anyway!!

[Kirk Y]

As far as I know, this is the most efficient way of doing this, so the six queries can't be helped. For most people it shouldn't be a problem, but like you said -- you've got 40 queries. I believe my board only has 25-27 and that's with this hack installed.

[neofootball]

Very nice, works great is there any way to change the colors?

[Kirk Y]

Very nice, works great is there any way to change the colors?
Edit templates forumhome_moderationqueue and forumhome_moderationqueue_bit.

[Julie]

The capability for Moderators to only be shown their specific Moderation Events will be coming in the next version.

I'll definitly install this when that version comes :)

*subscribed, and waiting patiently!*

[bashy]

Hi m8

What if i wanted to put this elsewhere, what would i changed please...

usually theres a little bit of code (if on forumhome) like, $menualert or $vbshout
there just examples but i cannot find out like that in the forumhome template for your hack....hence the question?

[Kirk Y]

It's complicated to explain, it'd be easier if you told me where you wanted it and I could provide you with the exact coding needed to place it there.

[bashy]

to be honest i aint really sure...its just that it uses a good handfull of queries and i already got 41 on the index and didnt reallt want to increase this too much...

I am maybe thinking about adding a new page using Logicans Web Templates
How about adding the code to this?

[rushabh]

Thank you. works like a charm and much appreciated.

[taydu]

anything change it get port to 3.6 this is a great hack

[taydu]

how do I add a single user to view the moderation queue ??

[Kirk Y]

how do I add a single user to view the moderation queue ??

Untested, but should work. ;)

Find in forumhome_moderationqueue:
<if condition="$permissions[modqueueperms] & $vbulletin->bf_ugp[modqueueperms][view_queue]">

Replace with:
<if condition="$permissions[modqueueperms] & $vbulletin->bf_ugp[modqueueperms][view_queue] OR $bbuserinfo['userid'] == 'xx'">

Replace xx with the UserID of the User you'd like to view the queue.

[Necrosaro420]

This does not work with 3.6.4 =( Are there any other alternatives? This is a great idea!

[Nudda]

^^i second that

[taydu]

Thanks Acidburn, is there a way to not display moderation in certain forums in the moderation queue

Untested, but should work. ;)

Find in forumhome_moderationqueue:
<if condition="$permissions[modqueueperms] & $vbulletin->bf_ugp[modqueueperms][view_queue]">

Replace with:
<if condition="$permissions[modqueueperms] & $vbulletin->bf_ugp[modqueueperms][view_queue] OR $bbuserinfo['userid'] == 'xx'">

Replace xx with the UserID of the User you'd like to view the queue.

[t325]

It's working great in 3.6.5 for me. Thanks for the addon!

[Muellmann]

Thanks that's awesome and very useful.

[snags204]

Is there a way to add pm moderation from the pm mod. By https://vborg.vbsupport.ru/showthread.php?t=118983&highlight=pm+moderation

[jgommel]

Seems to have installed okay other than I'm getting the following message at the top... "There are currently Array event(s) requiring your attention." Any ideas how to fix this?

[Jafo232]

This product is not working for 3.7, it throws the following error:

Database error in vBulletin 3.7.0:

Invalid SQL:

SELECT COUNT(*) AS count
FROM moderation AS moderation
INNER JOIN post AS post USING (postid)
WHERE moderation.type='reply';

MySQL Error : Unknown column 'postid' in 'from clause'
Error Number : 1054

[gopherhockey]

This product is not working for 3.7, it throws the following error:

I'd love to see an update...

[Jafo232]

ditto...

[badboy_29]

Is there any way to make this work with 3.7.1 Or does it and my site is just messed up.

[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:

// ##### 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:

// ##### 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]

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]

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!

[cmd19872002]

Tyvm DVDGuy

[washingtonboise]

Thread subscribed, standing by for version, compatibility, and development updates.