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

[bira]

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:



Redirect Removal: Allows you to delete the "Moved" redirect to a thread.

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

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.


http://www.atlasf1.com/bb/images/lastpost.gif Download here (http://www.atlasf1.com/personal/bira/admin-tools.zip)

[bira]

Some screenshots, for what they're worth:

The link to delete a "Moved" redirect to a thread would look like this:

http://www.atlasf1.com/personal/bira/sample3.gif


The link to edit multiple posts in one thread would look like this:

http://www.atlasf1.com/personal/bira/sample1.gif

And here's a bit of what the multi-edit form page looks like:

http://www.atlasf1.com/personal/bira/sample2.gif

[tubedogg]

Kick-A@@! You rock, bira!

BTW, I hope you don't mind, I borrowed your speech for my sig. :D (But I credited you, so...)

[bira]

Thanks tubedogg :)

[bokhalifa]

good hack:p

[eva2000]

can the remove redirect link be made available in the /mod control panel as well ?

[CJ]

Does the last feature (the place users post under moderation) still have the bug that the user who is actually moderated can view the private forums? (ie forums only for moderators and/or administrators)

Looks like a nice hack :)

[bira]

CJ - it never had that bug. The hack has 0 effect or relevance to permissions.

Eva2000 -- to add it to the mod's control panel you would need to make another hack, which I can look into but I have a feeling I can save that time with an easier solution:

Am I right in assuming that you want it, because you don't allow your mods to delete threads, which means they have no permission going to the "Delete" page? If I am right, tell me this: are they allowed to go to the "Edit" page?

The reason I ask is this: "Edit" and "Delete" - those are just different actions from the same script. It makes the hack allthemore easy to implement on any web page that is essentially outputted from this script. The Mod's control panel is a whole different set of scripts though.

[eva2000]

well my problem is one forum i have get's alot of threads posted in that always get moved out by moderators (who can not delete posts)

this leaves the forum full of redirect links of which my mods want to be able to delete after a certain time i.e. 1, 3, 5 or 7 days

[bira]

ok Eva, I understand what you mean now. I'll write a separate hack for that

[CJ]

Bira, it might not be a bug in teh hack than, but to put users on moderated you need a seperate usergroup, right? Well you need to be careful there. Be sure you disable private forums for that usergroup.

[bira]

CJ - you can't possibly say that if an admin doesn't grant appropriate usergroup permissions per forum, that's a bug?!? :confused:

Private Forums permissions have NOTHING to do with placing a user under moderation of his posts.

I have a user who HAS access to a private forum but his posts are under moderation because he has a tendency to use foul launguage.

Forum permissions are about access and other rights you give or take from users and usergroups.

ALL this hack does is put a user's new post or new thread in the moderation queue, rather than automatically make it public.

[bira]

Fourth Admin Tool added at Eva2000's request :D

Prune Redirects in Moderators CP (http://www.vbulletin.com/forum/showthread.php?s=&threadid=15409)

[CJ]

Yeah sorry, I wasn't sure at first how this hack worked and if it would be part of the hack.

Sorry, and good hacks anyway

Originally posted by bira
CJ - you can't possibly say that if an admin doesn't grant appropriate usergroup permissions per forum, that's a bug?!? :confused:

Private Forums permissions have NOTHING to do with placing a user under moderation of his posts.

I have a user who HAS access to a private forum but his posts are under moderation because he has a tendency to use foul launguage.

Forum permissions are about access and other rights you give or take from users and usergroups.

ALL this hack does is put a user's new post or new thread in the moderation queue, rather than automatically make it public.

[RobAC]

Bira,

Awesome job! I'm looking forward to insalling this one. I'm holding off with installing anymore hacks until the final production version of 2.0 is out. This hack along with a couple of tubedogg's hacks are on the top of my list! :D

[bira]

thanks :) :) :)

[julius]

Place User's Posting under Moderation (I like it! :) )

A little bug:
If there is a poll in the post, the hack doesn't work.

[bira]

Hi Julius,

Thanks for picking up on that.

For those interested, here's the fix:


Open poll.php

find:

if (ismoderator($foruminfo[forumid])) {
$visible=1;
}

AFTER it put:

if ($bbuserinfo[usergroupid]==XX) {
$visible=0;
}

(Where XX equals the usergroup id of your new group.)


I also updated the download file in the first post. Cheers!

[eva2000]

hey bira are these vB 2.0.0 final compliant? :)

[RobAC]

Good question eva2000. I'd like to install this hack but only if it's 2.0 Gold compliant. "Is bira in the house???" :D

[Dontom]

Edit Posts works perfectly for me on 2.0.0
:D

[eva2000]

Originally posted by Dontom
Edit Posts works perfectly for me on 2.0.0
:D thanks :D

[bira]

Eva I tested all my hacks, and it seems nothing changed as far as my hacks go from rc3, so yes, it will work fine :D

[eva2000]

btw, what's the 2 txt files for admin-thread-php-addition and thread-php-addition ?

[bira]

Eva it's from the mass-prune-redirects hack:


4. Open mod/thread.php.

Find:

if ($parentid and !$forumid) {
$forumid = $parentid;
}

Below it PASTE THE ENTIRE CONTENT of thread-php-addition.txt

.
.
.
.

6. Open admin/thread.php.

Find:

adminlog(iif($forumid!=0,"forum id = $forumid",""));

cpheader();

Below it PASTE THE ENTIRE CONTENT of admin-thread-php-addition.txt


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

[eva2000]

thanks did get that far in reading the instructions fully yet :D

[eva2000]

confusion :)

in the instructions for moderate user posts it says


4) Open poll.php

find:

if (ismoderator($foruminfo[forumid])) {
$visible=1;
}

AFTER it put:

if ($bbuserinfo[usergroupid]==XX) {
$visible=0;
}


problem is there are 2 instances of the find code in poll.php


if (ismoderator($foruminfo[forumid])) {
$visible=1;
}

so do i add it to both or the first or 2nd instance ?

[bira]

Eva you can add it after the 2nd instace as well.

[eva2000]

thanks bira :D

[jucs]

This can be a very good feature so banning is not necessary in all cases. I think it needs to be included in a future version as a feature.

[eva2000]

Originally posted by jucs
This can be a very good feature so banning is not necessary in all cases. I think it needs to be included in a future version as a feature. probably will be :)

[ThomasP]

fantastic bira!
Especially the redirect removal was what I needed badly :)
-Tom

[mr.scotty]

thanks a lot

that's what I was looking for !
great hack !

mr.scotty

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

[Christine]

Thanks, Bira - working like a champ!!!

:D

[Cloughie]

does this work with 2.0.3?

I REALLY need the moderate users hack :)

[jucs]

Does this work with 2.2?

[Tommy Boy]

Or 2.2.1?

[julius]

To prevent a user register himself only to spam throw emails and messages to other users, it would be useful to put one more option in the usergroup:

Email Permissions:

Can Use Send Email to Other Members? yes ---- no

When you're shure that the new member has written on the forum, you can switch him to the group with all permissions enabled.

[Psychdrone]

THis is sweet!

dose it work for 2.2.1??

[trainer]

Originally posted by julius
To prevent a user register himself only to spam throw emails and messages to other users, it would be useful to put one more option in the usergroup:

Email Permissions:

Can Use Send Email to Other Members? yes ---- no

When you're shure that the new member has written on the forum, you can switch him to the group with all permissions enabled.


yes that option to allow members to email using the bb system would be great

also does this work with 2.2.1 ??? anyone tried it

[Tommy Boy]

Yeah, I installed it on 2.2.1. The instructions do not always match, but if you know PHP, you should be fine. It is working smoothly for me.

[James Cridland]

Me too, I think "moderate users" is great.

And now, an extra bit of code.

To make posts from all new users to be "under moderation", you can do the following...

---
Open register.php
Search for the following
// activate account
$DB_site->query("UPDATE user SET usergroupid=2 WHERE userid='$u'");

Replace the usergroupid (2) with the new, Under Moderation, user group you've just made.

You might also wish to replace your redirect_postthanks template to let users know that "your post may not appear immediately".
---

You're free to add this to the documentation of the main hack.

[James Cridland]

Note that the above hack places current users onto moderation if they change their e-mail address. I don't think there's a way round it, to be honest, and I'll not spend much time trying.

[FWC]

Originally posted by James Cridland
Note that the above hack places current users onto moderation if they change their e-mail address. I don't think there's a way round it, to be honest, and I'll not spend much time trying. Intersting, that hasn't happened to me.

[James Cridland]

Ah, of course. Let me re-write that...

Note that the above hack places current users onto moderation if they change their e-mail address and you have e-mail verification on. I don't think there's a way round it, to be honest, and I'll not spend much time trying.

Well spotted! :)

[Martz]

Sorry to bump this, but does the "Moderated User" part of this hack work with 2.2.0 or 2.2.1 - does anyone know? :)

Thanks

[FWC]

Originally posted by Martz
Sorry to bump this, but does the "Moderated User" part of this hack work with 2.2.0 or 2.2.1 - does anyone know? :)

Thanks Yes, it does. I'm using it on 2.2.1.

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

[Joshua Clinard]

*Bump*

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

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 (https://vborg.vbsupport.ru/showthread.php?postid=220467#post220467) 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

while ($thread=$DB_site->fetch_array($threads)) {
deletethread($thread[threadid],0);
}
by
$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
while (list($key,$val)=each($delete)) {
if ($val==1) {
deletethread($key,0);
}
}
by
$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?? :(

[dnd]

Originally posted by 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?? :(

any update ??????

[LouChipher]

Originally posted by bira
Fourth Admin Tool added at Eva2000's request :D

Prune Redirects in Moderators CP (http://www.vbulletin.com/forum/showthread.php?s=&threadid=15409)

i'm looking for this hack.. where can i find it, somebody an idea?

[dkilburn]

I just installed the moderate users part of this hack on version 2.2.1 . I then created a new user and put him in the moderated group. When I tried to post a message to the board as this user, I got the usual "if admin has chosen to moderate..." message. So far so good.

Now where do I go as admin to see the posts that need approval? In the control panel home page it shows how many new members are awaiting moderation, but I don't see anywhere to find messages that need moderation.

Thanks!!

[FWC]

Originally posted by dkilburn
Now where do I go as admin to see the posts that need approval? In the control panel home page it shows how many new members are awaiting moderation, but I don't see anywhere to find messages that need moderation.
In the left column of the Admin CP there is a header for Moderation and New Posts is under it. You can also moderate new messages from the Moderators CP.

[dkilburn]

I'm using version 2.0.3 and I don't see that option. I'm waiting to upgrade until my classes are over in 3 weeks. Is there something I can hack into the code for the control panel to moderate the messages?

[FWC]

Originally posted by dkilburn
I'm using version 2.0.3 and I don't see that option. I'm waiting to upgrade until my classes are over in 3 weeks. Is there something I can hack into the code for the control panel to moderate the messages? I think you can add this in admin/index.php:<tr><td>
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<?php maketableheader("Moderate New Posts"); ?>
</table>
<a href="../mod/moderate.php?s=<?php echo $session[sessionhash]; ?>&action=posts"> Moderate New Posts </a><br>
<a href="../mod/moderate.php?s=<?php echo $session[sessionhash]; ?>&action=attachments"> Moderate New Attachments </a>
</td></tr>
Or, you can always use the Mod CP.

[dkilburn]

Perfect! Thank you :cool:

[FWC]

You're welcome. :)

[dkilburn]

Uh oh, I just went to moderate several messages and got the following error:

Fatal error: Call to undefined function: sendnotification() in /home/kilburn/public_html/forums/mod/moderate.php on line 128

I don't have a forum/mod/moderate.php file in this version. It appears that the one message I approved went through, and the ones I didn't approve did not, so things seem to be working. Is the mod directory in the newer version of vBulletin or is it referring to a different hack that I don't have installed?

[FWC]

Originally posted by dkilburn
I don't have a forum/mod/moderate.php file in this version. It appears that the one message I approved went through, and the ones I didn't approve did not, so things seem to be working. Is the mod directory in the newer version of vBulletin or is it referring to a different hack that I don't have installed? :confused: You should have a forum/mod/moderate.php file. Its part of the standard vB 2.0.3 release.

[dkilburn]

:knockedout: I was looking at my local copy and not the server copy. Apparently I didn't have all the files locally. Anyway, I DO have the mod folder, and here is what is shown around line 128:


// send notification
if (!$notified["$thread[threadid]"]) {
$message = $postpagetext[$key];
sendnotification($thread['threadid'], $thread['userid'], $key);
$notified["$thread[threadid]"] = 1;
}

[FWC]

That's weird. sendnotification is defined in admin/functions.php. I've never gotten that error.

[Dark Shogun]

I have 2.2.6. and am trying to remove the redirects. This is the file I am working with now: install-massprune-redirects

In that file there is some code that I can't find.
3. Open mod/index.php.

Find:

<a href="thread.php?s=<?php echo $session[sessionhash]; ?>&action=prune"> Mass Prune </a>

Is mod/index.php even the right file to find that code?

Dark Shogun

[NTLDR]

Originally posted by Dark Shogun
Is mod/index.php even the right file to find that code?

Yes! The CPs have changed alot since then, the code you need to find is:

makenavoption("Mass Prune","thread.php?action=prune");

And you need to add the code in the same format, so:

makenavoption("Mass Prune Redirects","thread.php?action=prunered");

[Dark Shogun]

Last question is about:

This code is what I am supposed to find in admin/index.php but as above things have change but I don't know how to convert it.

<a href="thread.php?s=<?php echo $session[sessionhash]; ?>&action=move"> Move </a>

Dark Shogun

[NTLDR]

Find, and add the same as above for /mod/index.php

[Dark Shogun]

I put it where it was supposed to go but I don't see the link in the admin center.

Dark Shogun

[neocorteqz]

I Installed the delete redirects one.. I will give the other ones a go later.. Nice work.

Thanks.

[mtha]

I just install the Mass Redirects Deletion Hack in vB2.7.7 (same in 2.7.8)

some changes need to be made in this hack:

3. Open mod/index.php.
Find:
<a href="thread.php?s=<?php echo $session[sessionhash]; ?>&action=prune"> Mass Prune </a>
Below it add:
<br> <a href="thread.php?s=<?php echo $session[sessionhash]; ?>&action=prunered"> Mass Prune Redirects</a>


change to
3. Open mod/index.php.

Find:

makenavoption("Mass Prune","thread.php?action=prune");

Below it add:

makenavoption("Mass Prune Redirects","thread.php?action=prunered");

Change

5. Open admin/index.php.
Find:
<a href="thread.php?s=<?php echo $session[sessionhash]; ?>&action=move"> Move </a>
Below it add:
<br> <a href="thread.php?s=<?php echo $session[sessionhash]; ?>&action=prunered"> Mass Prune Redirects</a>

to

5. Open admin/index.php.

Find:

makenavoption("Mass Move","thread.php?action=move","<br />");


Below it add:

makenavoption("Mass Prune Redirects","thread.php?action=prunered","<br />");


in thread-php-addition.txt, change

// ###################### Start Prune Redirects #######################
if ($action=="prunered") {

$perms=getpermissions();
if (!$perms[ismoderator] and !$ismod=$DB_site->query_first("SELECT * FROM moderator WHERE userid=$bbuserinfo[userid] AND canmassprunered=1")) {
echo "<p>You do not have permission to do this!</p>";
exit;
}

doformheader("thread","prunereddate");
maketableheader("Prune redirects by date");
makeinputcode("Delete redirects older than x days:","daysdelete","");
makemodchoosercode(-1,-1,'','All forums','In forum',0);

doformfooter();

}

to

// ###################### Start Prune Redirects #######################
if ($action=="prunered") {

$perms=getpermissions();
if (!$perms[ismoderator] and !$ismod=$DB_site->query_first("SELECT * FROM moderator WHERE userid=$bbuserinfo[userid] AND canmassprunered=1")) {
echo "<p>You do not have permission to do this!</p>";
exit;
}

doformheader("thread","prunereddate");
maketableheader("Prune redirects by date");
makeinputcode("Delete redirects older than x days:","daysdelete","");
makeforumchooser("forumid",-1,-1,"","----- all -----","Forum:");
makeyesnocode("Include sub forums","subforums");

doformfooter();

}

[julius]

It works with 2.3.0?
Thansk

[Weasel]

This works with 2.3.0 (You need to have a little intelligence because the format has changed slightly over the versions) as far as I can tell but I have one gripe with it. In the mass edit post hack if you completely take out the text of the post you just get a blank postbit, the behavior I would expect would be to delete the post entirly, how would I change this?

[Austin Dea]

Delete the post instead of editing it ;)

[tmapm]

When I run the mass redirect deletion, the polls of the original thread are deleted. The $pollid variable isn't recieving any information.

[MaDCaT75]

Why hasnt the issue of "you do not have permission to access this page" been addressed yet?

[weewilly]

Grrrr...

The "Moderated User" is not working for me.

I set a user as moderated in the admin panel, but he is still able to post and nothing shows up as far as posts needing moderation.

I have checked and double checked, but everything looks correct. I am using this on version 2.3.2

[weewilly]

Well, it gets WAY worse than my last post.

I asked a trusted member to test this out, and she emailed me that as soon as I made her moderated she was able to see our private admin/mod forum and was able to read everything on it!

This is a disaster! We had 5 really troublesome members on that moderated list and I will assume they were able to read there too. Not good at all considering our game plan for dealing with them is all spelled out there, as well as lots of other stuff they should not see.

This board has several hacks installed, so I don't know if this is just version incompatible or it doesn't jive with another hack.

Just wanted to give a heads up about this!

[chrisvonc]

The Redirect removal was just what I needed. Worked like a charm on 2.3.2.

Thank you! :)

Chris

[JustAskJulie]

Do these work on 2.3.4?

[G-man]

Can we get this to work on the current 3.0gold release?

[Spacefreak]

Is there any swimilar mod for 3.0.7? I've been hunting to with no success.

[Andreas]

Remove Redirects is standard functionality of vBulletin 3.