Quick Moderation Hack for v3articles / vBa CMPS

Here's a dirty little hack to the "quick moderation" module in vBa CMPS to let you know how many
v3 Articles you have waiting to be moderated.


1. edit moderate.php

Open modules/moderate.php

find this
################################################## ####
$show['posts'] = true;
################################################## ####


after that add
################################################## ####
$articles = $DB_site->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "article WHERE open = '0'");
$articles['count'] = number_format($articles['count']);
$show['articles'] = true;
################################################## ####

Close and save.



2. edit template

Open the "adv_portal_moderation" template

find this
################################################## ####
<div><phrase 1="$posts[count]" 2="$vboptions[bburl]/$modcpdir/moderate.php?do=posts#postlist">$vbphrase[x_posts]</phrase></div>
</if>
################################################## ####


after that add
################################################## ####
<!-- ARTICLE MODERATION -->

<if condition="$show['articles']">
<div><a href=$vboptions[bburl]/$admincpdir/article.php?do=modarticles>Articles</a> ($articles[count])</div>
</if>

<!-- END ARTICLE MODERATION -->
################################################## ####

That's it folks. Now your vBa CMPS admins can see if you have any v3Articles
waiting for moderation, and links directly to them if ya do.

Happy to help answer any questions or assume the position for any critics

Max
Marijuana.Com

[TheComputerGuy]

Very useful! *installed*

[Mike Gaidin]

Nice one.

[TheMusicMan]

Do you know how I set up a vB usergroup to be able to Moderate submitted articles? I have searched in my installation and cannot fins this anywhere. There doesnt seemto be a setting that will allow any group other than Admin to moderate articles. I must be missing something, surely??

[The Realist]

Quick Moderation is saying I have 2 posts waiting, but I know I dont?

How can I delete this?

[bashbang]

I had the same problem with my moderation queue. It said I had 10 posts to be moderated, but there wasn't anything in the que. I ended up cleaing the queue of these ghost posts by:
1) temperarily shutting down the board
2) Clear the queue of any outstanding items
3) going into the mysql DB and deleting all the items in the queue:
mysql> delete from moderation;
4) turn the board back on.

I'm kinda new the whole vBulletin thing, so I'm not sure this is the "proper" way of doing things, but it solved my problem so I was happy.

PS: I don't know for sure, but I think the reason for the ghost moderation items is due to deleting a thread in one window, while the moderation page is open in another. This in itself creates a MySQL error and I suspect is the cause of the orphaned moderation items.