Moderators Functions - Show posts to moderate in the new notification menu

this adds an extra menubit into the menu where you see the posts to moderate

Sorry, in the Screenshot it is german, but in the uploaded version i changed it into english

Changehistory:
1.1

=====
- changed: Menu is just for Mods and Admins vissible
- changed: Now using phrase instead of hardcoded text

1.11

======
- bugfix: in 1.1 i used a false phrasegroup and hook

- Changed: i took can_moderatebecause of the second extraquery out
i have to search for something else

[powerful_rogue]

Originally Posted by TFEX

Been asked a few times already I see. Guess I'll have a look into it myself, I'll let you guys know what I come up with.

Thanks TFEX.

Any update at all?

[djbaxter]

Originally Posted by powerful_rogue

Thanks TFEX.

Any update at all?

See first post:

Changehistory:
1.1

=====
- changed: Menu is just for Mods and Admins vissible
- changed: Now using phrase instead of hardcoded text

[djbaxter]

What exactly is the name of the phrase to edit?

[Alfa1]

Originally Posted by doz

Can you do it for all things waiting aprovel like user thread any profile mesaage

This would be optimal.
Some help with this might be that vbadvanced 3 has a quick moderation module, which shows posts, threads, VM's, attachments, members, to moderate.

[Chriss74]

Originally Posted by reesev

anyway to make it so non staff members do not see these notices? its really causing confusion but other then that it works fine.

The same for me.

I changed the attached xml-File:

 <phpcode><![CDATA[
if (can_moderate()) {
$postcount = $db->query_first("
SELECT COUNT(*) AS count
FROM " . TABLE_PREFIX . "moderation AS moderation
INNER JOIN " . TABLE_PREFIX . "post AS post ON (post.postid = moderation.primaryid)
WHERE moderation.type = 'reply'
");
$vbulletin->userinfo['poststomoderate'] = $postcount['count'];
$notifications['poststomoderate'] = array(
'phrase' => $vbphrase['moderated_posts'],
'link' => 'moderation.html?do=viewposts&type=moderated' . $vbulletin->session->vars['sessionurl_q'],
'order' => 10
);
}
]]></phpcode>

After this changes, only members with moderator-rights see the message.

This addition should be standard in vb.

Greetings,
Chriss

[SVTCobraLTD]

Would be nice if there was something for 3.6 too.

[Magnumutz]

3.6 doesn't have notifications like 3.7 does.
The upgrade is a must.

[veenuisthebest]

well.. It doesn't work for a fresh 3.7.3 PL1

Would appreciate if somebody updates this mod.

Thanks

[DebtFree]

I've got this working, and even better. If you change the 'notifications_list' plugin to the following code, it will display both posts and threads awaiting moderation ...

PHP Code:

if (can_moderate()) {
$postcount = $db->query_first("
    SELECT COUNT(*) AS count
    FROM " . TABLE_PREFIX . "moderation AS moderation
    INNER JOIN " . TABLE_PREFIX . "post AS post ON (post.postid = moderation.primaryid)
    WHERE moderation.type = 'reply'
");
$vbulletin->userinfo['poststomoderate'] = $postcount['count'];
    $notifications['poststomoderate'] = array(
            'phrase' => $vbphrase['posts_awaiting_moderation'],
            'link'   => 'moderation.php?do=viewposts&type=moderated' . $vbulletin->session->vars['sessionurl_q'],
            'order'  => 10
        );
$threadcount = $db->query_first("
    SELECT COUNT(*) AS count
    FROM " . TABLE_PREFIX . "moderation AS moderation
    INNER JOIN " . TABLE_PREFIX . "thread AS thread ON (thread.threadid = moderation.primaryid)
    WHERE moderation.type = 'thread'
");
$vbulletin->userinfo['threadstomoderate'] = $threadcount['count'];
    $notifications['threadstomoderate'] = array(
            'phrase' => $vbphrase['threads_awaiting_moderation'],
            'link'   => 'moderation.php?do=viewthreads&type=moderated' . $vbulletin->session->vars['sessionurl_q'],
            'order'  => 10
        );
} 


NB: You should also change the 'init_startup' plugin to read

PHP Code:

$phrasegroups[] = 'thread'; 


[Fungsten]

Originally Posted by DebtFree

NB: You should also change the 'init_startup' plugin to read

PHP Code:

$phrasegroups[] = 'thread'; 


Which init_startup plugin? Did you mean "global_start"?