3 Admin Tools: Remove Redirect, Edit Posts, & Moderate User

Three additional tools for administrators/moderators - one written by wluke (I hope he does not mind me bundling it with the other two I wrote).

Download the zip file attached. Each hack has its own txt file with exact instructions on how to install it.

Hacks description:

1. Redirect Removal: Allows you to delete the "Moved" redirect to a thread.
   
2. Multi Posts Editing: Allows you to conveniently edit several posts in one thread at once, in one page and with one submit button (good for occassions where a thread gets out of hand and people are overboard).
   
3. Place User's Posting under Moderation: Allows you to place a user under moderation, whereby his posts and threads will be queued until an admin/moderator validates them. (written by Wluke).

Cheers,

Bira

UPDATE MAY 3rd:

* Added to the zip-file a fourth tool for mass-prune redirects ("moved:" links) older than x days (with ability to select which to delete and which to leave).

* fixed a bug in the user-under-moderation hack, which allowed threads with a poll to go unmoderated.


Download here

[Jawelin]

Excuse.
Is it possible to create a Warning group and, instead of actually moderating user posts, simply to be notified via email of their new posts ?
(just like an automatic subscription to their threads)

??

Thanks

[ladyfyre]

does it work with 2.2.2???

[James Cridland]

Originally posted by Joshua Clinard
This looks like a cool hack. I'm not installing it until 2.2.2 is out. Can someone tell me if mods can add a user to the moderation que? Also, do you have to create a moderation usergroup for this to work?

Adding a user to moderation is easy - just change their user type to "Moderated User" or whatever you've set as your category. But yes, you do have to create a usergroup for it.

[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.

[Jawelin]

Originally posted by bira
Eva it's from the mass-prune-redirects hack:

That's cos there are two "control panels" -- one in admin and one in mod

Excuse: should be necessary to modify the index.php to link the thread.php?action=prunered or that function is included elsewhere in the existing code ?
I didn't found.

Thanks.


P.S.: I'll push up even my question on Post #51 about a slight modification to 'moderate user'. Simply, instead of setting his posts 'visible=0', I would that post be reported to the webmaster with an email...
I tried following a path similar to 'email this page' (i.e. sendtofriend.php) but didn't managed to make the process hidden.
Simply I would create a new template with the thread link and the userid moderated posting here and send everything via mail() to the webmaster.
Someone could give me any hint about ?

Thanks for both answers.
Bye

[James Cridland]

Incidentally, I've furthered this hack to also add "moderators can see unmoderated messages", and an enhanced control panel moderation section.

I've not documented this, but if anyone wants me to have a go, I'll certainly add it to The Big List.

[heidit]

Can someone confirm that it works on 2.2.2?

[ZiRu$]

very, very nice......

will add......

[Harvey]

Hi,

great hack. But I only installed massprune redirects for admins.

There is one problem: If there are to much redirects to delete I get a time out and the script terminates.

My suggestion: Because I can't find any table that points to a redirect-thread and imho it's not nessesary to update counters delete all threads at once.

I have not tested, but the following should work:
in admin-thread-php-addition replace

PHP Code:

  while ($thread=$DB_site->fetch_array($threads)) {
    deletethread($thread[threadid],0);
  } 


by

PHP Code:

  $threadlist = "";
  while ($thread=$DB_site->fetch_array($threads)) {
    if ($threadlist == "") {
      $threadlist = $thread[threadid];
    } else {
      $threadlist .= "," . $thread[threadid];
    }
  }
  if ($threadlist != "") {
    $DB_site->query("DELETE FROM thread WHERE threadid in (".$threadlist.")");
  } 


and

PHP Code:

  while (list($key,$val)=each($delete)) {
    if ($val==1) {
      deletethread($key,0);
    }
  } 


by

PHP Code:

  $threadlist = "";
  while (list($key,$val)=each($delete)) {
    if ($val==1) {
      if ($threadlist == "") {
        $threadlist = $key;
      } else {
        $threadlist .= "," . $key;
      }
    }
  }
  if ($threadlist != "") {
    $DB_site->query("DELETE FROM thread WHERE threadid in (".$threadlist.")");
  } 


[admiralapril]

Originally posted by babak
i just installed the
install-mderate-user-posts.txt
hack alone and put a user into
the moderated group. but when
this user logs in and press the "new thread"
button, he gets the message-page:

"You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:
1
2
3
..."

what is the reason?

I am getting the same error after installing the user moderated hack. I'm using 2.2.3. Any ideas??