[James Cridland]

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("&nbsp;","",0);

    $done=1;
  }
  restarttable(); 


Tested with 2.2.1 - not 2.2.2.