I have the fix for the db error email that you get when you post a hidden post. Find this code (in the newpost_complete plugin):
PHP Code:
// remove entry of moderation queue
$vbulletin->db->query_write("
DELETE FROM " . TABLE_PREFIX . "moderation
WHERE postid = $post[postid]
");
And replace it with:
PHP Code:
// remove entry of moderation queue
$vbulletin->db->query_write("
DELETE FROM " . TABLE_PREFIX . "moderation
WHERE primaryid = " . $post[postid] . "
AND type = 'reply'
");
The code has been verified and it works. It now removes the hidden post from the moderation queue and does not send any db error emails. It wasn't working right on 3.7.0 beta 6. Thanks to Marco for the type code.