If you've used my addendum to this hack earlier (to automatically make new users moderated), you might like a rather more useful-looking moderation queue screen.
This version shows how many posts a user has made, how many replies the existing thread currently has, and has an easy "de-moderate this user" link which takes you to their admin member profile.
Instructions are:
In /mod/moderate.php...
find
maketableheader("Posts awaiting validation");
replace this block (down to
restarttable();) with:
PHP Code:
maketableheader("Posts awaiting validation");
$posts=$DB_site->query("SELECT postid,pagetext,post.dateline,userid,thread.title as title,thread.forumid as forumid,forum.title as forumtitle,thread.replycount as replycount FROM post,thread,forum WHERE thread.threadid=post.threadid AND thread.forumid=forum.forumid AND post.visible=0 AND (1=0 $sql) ORDER BY dateline");
while ($post=$DB_site->fetch_array($posts)) {
$user=$DB_site->query_first("SELECT userid,username,posts FROM user WHERE userid='$post[userid]'");
makelabelcode("<b>Posted by:</b>","<a href=\"user.php?s=$session[sessionhash]&action=viewuser&userid=$user[userid]\">$user[username]</a> ($user[posts] posts) - [<a href=\"http://forums.mediauk.com/admin/user.php?s=$session[sessionhash]&action=edit&userid=$user[userid]\" target=_blank>un-moderate</a>] (in new window)");
makelabelcode("<b>Located in:</b>","<a href=\"/forumdisplay?s=$session[sessionhash]&forumid=$post[forumid]\">$post[forumtitle]</a>");
makeinputcode("Thread: ($post[replycount] replies)","title[$thread[threadid]]",$post[title]);
maketextareacode("Message:","postpagetext[$post[postid]]",$post[pagetext],4,80);
makeyesnocode("Validate:","validatepost[$post[postid]]",1);
makeyesnocode("Delete:","deletepost[$post[postid]]",0);
maketableheader(" ","",0);
$done=1;
}
restarttable();
Tested with 2.2.1 - not 2.2.2.