[DVDGuy]

I managed to get this working with a bit of SQL hacking. The reason this stopped working in 3.7.x is because the "moderation" table has changed (from having separate threadid and postid columns, to now a single primaryid column).

I fixed it by editing "product-moderation_forumhome.xml"

Find:

PHP Code:

// ##### Posts to Moderate
if (can_moderate(0, 'canmoderateposts'))
{
$postcount = $db->query_first("
    SELECT COUNT(*) AS count
    FROM " . TABLE_PREFIX . "moderation AS moderation
    INNER JOIN " . TABLE_PREFIX . "post AS post USING (postid)
    WHERE moderation.type='reply'
"); 


Change:
INNER JOIN " . TABLE_PREFIX . "post AS post USING (postid)

To:
INNER JOIN " . TABLE_PREFIX . "post AS post ON post.postid=moderation.primaryid

Similarly, find:

PHP Code:

// ##### Threads to Moderate
$threadcount = $db->query_first("
    SELECT COUNT(*) AS count
    FROM " . TABLE_PREFIX . "moderation AS moderation
    INNER JOIN " . TABLE_PREFIX . "thread AS thread USING (threadid)
    WHERE moderation.type='thread'
"); 


Change:
INNER JOIN " . TABLE_PREFIX . "thread AS thread USING (threadid)

To:
INNER JOIN " . TABLE_PREFIX . "thread AS thread ON thread.threadid=moderation.primaryid

This makes the plugin work for me in 3.7.3.