Add Links Awaiting Moderation to Your vBa CMPS Quick Moderation Module

[Brian]

This is a fairly easy hack, but I'm sure will be very useful for those who also have the CMPS installed. As the title states, it will add the number of links awaiting moderation to your 'Quick Moderation' module in the CMPS.

First, open your /forum/modules/moderat.php file and look for:

PHP Code:

eval('$home[$mods[\'modid\']][\'content\'] .= "' . fetch_template('adv_portal_moderation') . '";'); 


Right Above that, Add:

PHP Code:

$links = $DB_site->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "links WHERE valid = 0"); 


Then open your 'adv_portal_moderate' template and add the following code where you wish:

<div><a href="$vboptions[bburl]/$modcpdir/links.php?do=validate" target="_blank">Links</a> ($links[count])</div>

That's it.

[Shon]

Worked perfectly, thank you

[Brian]

I like what you did with that module.

[Shon]

Originally Posted by Brian

I like what you did with that module.

Why thank you

[bezzell]

Hmmm... I tried this and received the following error:

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "links WHERE valid = 0 mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '" . TABLE_PREFIX . "links WHERE valid = 0' at line 1

mysql error number: 1064

[Shon]

Originally Posted by bezzell

Hmmm... I tried this and received the following error:

Use this instead:

PHP Code:

$links = $DB_site->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "links WHERE valid = 0"); 


[Brian]

Oops, didn't realize that I had single 's in the query. Just updated the post.

[bezzell]

Thanks Shon & Brian - that works!

[pdatotaal]

Works great..! Mhh Shon like to share your nice table?

[Shon]

Originally Posted by pdatotaal

Works great..! Mhh Shon like to share your nice table?

Well, since then I've added Link Posts and Join Requests... I took the join requests part of it out and left the link posts HTML, if you want to you can take it out or I may post the code for it later if nobody releases it or has released it yet....

Template: adv_portal_moderation

<!-- Quick Moderation Block -->

<table align="center" border="0" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" class="tborder" width="187">
<thead>
	<tr>
		<td class="thead">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('moderate')"><img id="collapseimg_moderate" src="$stylevar[imgdir_button]/collapse_tcat$collapseimg_moderate.gif" alt="" border="0" /></a>
<span class="smallfont"><strong>$vba_options[portal_blockbullet] $vbphrase[quick_moderation]</strong></span></td>
	</tr>
<thead>
<tbody id="collapseobj_moderate" style="$collapseobj_moderate">
	<tr>
		<td class="$getbgrow">
<table border="0" cellpadding="3" cellspacing="1" class="tborder" width="100%">
	
			<if condition="$show['threads']">
<tr><td class="alt1" width="80%">
				<div><a href="$vboptions[bburl]/$modcpdir/moderate.php?do=posts">Threads</div>
</td>
<td class="thead" align="center">$threads[count]</td></tr>
			</if>
			<if condition="$show['posts']">
<tr><td class="alt2" width="80%">
				<div><a href="$vboptions[bburl]/$modcpdir/moderate.php?do=posts#postlist">Posts</div>
</td>
<td class="thead" align="center">$posts[count]</td></tr>
			</if>
			<if condition="$show['events']">
<tr><td class="alt1" width="80%">
				<div><a href="$vboptions[bburl]/$modcpdir/moderate.php?do=events">Events</div>
</td>
<td class="thead" align="center">$events[count]</td></tr>
			</if>
			<if condition="$show['attachments']">
<tr><td class="alt2" width="80%">
				<div><a href="$vboptions[bburl]/$modcpdir/moderate.php?do=attachments">Attachments</div>
</td>
<td class="thead" align="center">$attachments[count]</td></tr>
			</if>
<tr><td class="alt1" width="80%">
				<div><a href="$vboptions[bburl]/$admincpdir/user.php?do=moderate">Users</a></div>
</td>
<td class="thead" align="center">$users[count]</td></tr>
<tr><td class="alt2" width="80%">
				<div><a href="$vboptions[bburl]/$modcpdir/links.php?do=validate" target="_blank">Links</a></div>
</td>
<td class="thead" align="center">$links[count]</td></tr>
<tr><td class="alt1" width="80%">
				<div><a href="$vboptions[bburl]/$modcpdir/links.php?do=validateposts" target="_blank">Link Posts</a></div>
</td>
<td class="thead" align="center">$linkposts[count]</td></tr>
</table>
		
		</td>
	</tr>
</tbody>
</table>
<br />

<!-- End Quick Moderation Block -->

[pdatotaal]

Thanks, installed! looks very nice... so far not Link Posts and Join Requests used.. So later will be maybe nice..

Thanks again for sharing!

[KW802]

Shon, very nice! The only change I did was to change the hard-coded width of "187" to be "100%" instead so that it behaves like the rest of my modules.

Thanks.

[Polo]

nice thanks Brian

[cmiller1014]

My quick moderation always shows 1 post needs to be moderated, but there are none. Any ideas?

[cmiller1014]

Shon,

I used your template and its great! What should I add to moderate.php so that it pulls the number of link posts too? Right now it shows no number there, not even 0.

Thanks!

Originally Posted by Shon

Well, since then I've added Link Posts and Join Requests... I took the join requests part of it out and left the link posts HTML, if you want to you can take it out or I may post the code for it later if nobody releases it or has released it yet....

Template: adv_portal_moderation

<!-- Quick Moderation Block -->

<table align="center" border="0" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" class="tborder" width="187">
<thead>
	<tr>
		<td class="thead">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('moderate')"><img id="collapseimg_moderate" src="$stylevar[imgdir_button]/collapse_tcat$collapseimg_moderate.gif" alt="" border="0" /></a>
<span class="smallfont"><strong>$vba_options[portal_blockbullet] $vbphrase[quick_moderation]</strong></span></td>
	</tr>
<thead>
<tbody id="collapseobj_moderate" style="$collapseobj_moderate">
	<tr>
		<td class="$getbgrow">
<table border="0" cellpadding="3" cellspacing="1" class="tborder" width="100%">
	
			<if condition="$show['threads']">
<tr><td class="alt1" width="80%">
				<div><a href="$vboptions[bburl]/$modcpdir/moderate.php?do=posts">Threads</div>
</td>
<td class="thead" align="center">$threads[count]</td></tr>
			</if>
			<if condition="$show['posts']">
<tr><td class="alt2" width="80%">
				<div><a href="$vboptions[bburl]/$modcpdir/moderate.php?do=posts#postlist">Posts</div>
</td>
<td class="thead" align="center">$posts[count]</td></tr>
			</if>
			<if condition="$show['events']">
<tr><td class="alt1" width="80%">
				<div><a href="$vboptions[bburl]/$modcpdir/moderate.php?do=events">Events</div>
</td>
<td class="thead" align="center">$events[count]</td></tr>
			</if>
			<if condition="$show['attachments']">
<tr><td class="alt2" width="80%">
				<div><a href="$vboptions[bburl]/$modcpdir/moderate.php?do=attachments">Attachments</div>
</td>
<td class="thead" align="center">$attachments[count]</td></tr>
			</if>
<tr><td class="alt1" width="80%">
				<div><a href="$vboptions[bburl]/$admincpdir/user.php?do=moderate">Users</a></div>
</td>
<td class="thead" align="center">$users[count]</td></tr>
<tr><td class="alt2" width="80%">
				<div><a href="$vboptions[bburl]/$modcpdir/links.php?do=validate" target="_blank">Links</a></div>
</td>
<td class="thead" align="center">$links[count]</td></tr>
<tr><td class="alt1" width="80%">
				<div><a href="$vboptions[bburl]/$modcpdir/links.php?do=validateposts" target="_blank">Link Posts</a></div>
</td>
<td class="thead" align="center">$linkposts[count]</td></tr>
</table>
		
		</td>
	</tr>
</tbody>
</table>
<br />

<!-- End Quick Moderation Block -->

[Gary Bolton]

For cmps 2 this needs to be changed in Brians first post

Change:

<div><a href="$vboptions[bburl]/$modcpdir/links.php?do=validate" target="_blank">Links</a> ($links[count])</div>

To:

<div><a href="$vboptions[bburl]/$modcpdir/vba_links.php?do=validate" target="_blank">Links</a> ($links[count])</div>

---------------------------

PS: Brian, using the same method, what database entry would I have to add to also display Gallery images that need moderating as well? All I need to know is the database code to add to modules/moderate.php

[geoff]

I know Im bringing up an old post but it fit...

I tried to add the line to my moderate.php within the modules fodler and got an error

is the new line still that since links has changed?

[WarriorFX]

Originally Posted by geoff

I know Im bringing up an old post but it fit...

I tried to add the line to my moderate.php within the modules fodler and got an error

is the new line still that since links has changed?

Try this instead (vb3.5.x w/vBadv CMPS 2.1)...

	$links = $db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "links WHERE valid = 0");

[geoff]

hell ya!!

that worked out

got one for Gallery by chance?

[WarriorFX]

Originally Posted by geoff

hell ya!!

that worked out

got one for Gallery by chance?

I don't know of the Gallery module but make sure your references to "$DB_site->" are "$db->" for vB3.5.x