nvm, figured it out. If anyone else has a table prefix for their vbulletin you'll need to open modcp/postreport.php and change....
Code:
$searchquery = "
SELECT
" . TABLE_PREFIX . "postreport.*,
" . TABLE_PREFIX . "user.username modname,
" . TABLE_PREFIX . "user2.username reporter,
" . TABLE_PREFIX . "post.username postername,
" . TABLE_PREFIX . "post.userid posterid,
" . TABLE_PREFIX . "thread.title,
" . TABLE_PREFIX . "thread.threadid,
" . TABLE_PREFIX . "forum.title forumtitle,
" . TABLE_PREFIX . "forum.forumid
FROM " . TABLE_PREFIX . "postreport AS postreport
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (postreport.modid = user.userid)
LEFT JOIN " . TABLE_PREFIX . "user AS user2 ON (postreport.userid = user2.userid)
LEFT JOIN " . TABLE_PREFIX . "post AS post ON (postreport.postid = post.postid)
LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (post.threadid = thread.threadid)
LEFT JOIN " . TABLE_PREFIX . "forum AS forum ON (thread.forumid = forum.forumid)
WHERE postreport.status < 2
ORDER BY dateline DESC
LIMIT $page_start, $reports_per_page
";
TO
Code:
$searchquery = "
SELECT
postreport.*,
user.username modname,
user2.username reporter,
post.username postername,
post.userid posterid,
thread.title,
thread.threadid,
forum.title forumtitle,
forum.forumid
FROM " . TABLE_PREFIX . "postreport AS postreport
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (postreport.modid = user.userid)
LEFT JOIN " . TABLE_PREFIX . "user AS user2 ON (postreport.userid = user2.userid)
LEFT JOIN " . TABLE_PREFIX . "post AS post ON (postreport.postid = post.postid)
LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (post.threadid = thread.threadid)
LEFT JOIN " . TABLE_PREFIX . "forum AS forum ON (thread.forumid = forum.forumid)
WHERE postreport.status < 2
ORDER BY dateline DESC
LIMIT $page_start, $reports_per_page
";
That seemed to do the trick for me.