Add Links Awaiting Moderation to Your vBa CMPS Quick Moderation Module

[geoff]

ok...ty for that tip.

btw, changing links to gallery did not work for the gallery quick moderation deal...heh..just FYI

[absolutepunknet]

adv_gallery_images

is what you need to change it too..

[guttormson]

I use vb 3.6.7 and vb cmps 3 and I get an database error when attempting this hack.

Can this hack be done in my setup?

[guttormson]

The instant I add the above code it breaks my entire site so I have to remove it ASAP. Maybe this solution has changed since vb 3.6?

Anyone know?

[Ramses]

Fyi this is still working on 3.7rc1 / cmps 3 / vba links 2.
Add into the moderation.php file:

PHP Code:

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


And as Gary Bolton already mentioned above add into the vba_portal_moderation template:

PHP Code:

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


[natas]

This is not working for VBA Links 3. The template edit is wrong. 3.0 no longer uses vba_links.php

[Brian]

If you're running v3.0.0 then you should be able to use this for your link:

"$vboptions[vba_links_homeurl]/moderate.php$session[sessionurl_q]"

[adwade]

Didn't work for me, because the previous 'quoted' CODE above was for such OLD versions of both vB's CMPS & vBLinks Add-On. However, I kept reading the thread and trying different things until I stumbled across the right stuff... So thought I'd post it here for anyone else interested in doing such. I'm still surprised this isn't a built into the Quick Moderation Module of vBa's CMPS by now.

The Thread's original post, revised for versions: vBulletin (v3.8.6PL1), CMPS (3.2.2) & vBLinks (3.3.0) should read:

First, open your /forum/modules/moderate.php FILE and look for:

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

Right Above that line, ADD:

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

Next, in AdminCP open your 'adv_portal_moderate' Template and find:

<div<if condition="$users[count]"> style="font-weight: bold"</if>><a href="$admincpdir/user.php?$session[sessionurl]do=moderate" target="_blank">$vbphrase[members]</a> ($users[count])</div>

Then, just below it add the following code segment:

<div><a href="$vboptions[vba_links_homeurl]/moderate.php$session[sessionurl_q]" target="_blank">Links</a> ($links[count])</div>
</td>
<td class="thead" align="center">$links[count]</td></tr>
<tr><td class="alt1" width="100%">

Thanxx to EVERYone who chimed-in and added snippets of revised CODE along the way. Through studying those examples, I figured out what I needed to make it work for our versions of software.

MODERATOR: Feel free to MOVE this post to a different forum if you feel it fits better there, I couldn't turn up this information in the v2 or v3 sections for vBa Links or CMPS.