[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';