Moderators Functions - PM Moderation

PM Moderation
Version 1.0

Introduction

PM Moderation does exactly what it says on the tin! It allows you to moderate your members Private Messages before they are sent.

Ever had a new member sign up and do nothing but spam your members with Private Messages inviting them to leave your forum and join theirs? Or perhaps you've got 1 particular user who constantly sends abusive Private Messages to your other members? If so, then PM Moderation is the idea solution!

Features

PM Moderation contains many handy features to make your life as a forum Adminstrator or Moderator easier. These include

• Integrates fully with vBulletin 3.6.0 Beta 2!
• Fully Usergroup Controlled
• Moderate ALL Private Messages for a Particular Usergroup or...
• Moderate Private Messages that have certain Keywords in them!
• Simple Usergorup Permission for deciding who can Moderate Private Messages
• Integrated within the existing Private Messaging Options in the AdminCP
• Moderate Private Messages directly from within the ModCP and AdminCP
• Fully Phrased
• ... and much more!

Installation

Please see the manual.html in the zip for a full Installation and Configuration guide

Credits

PM Moderation was written by Alan @ CIT. The original idea came from Floris with the Keyword idea coming from an anonymous person. Thanks goes to everyone who helped test this modification before it was released, and in particular peterska2 who did a ton of Beta testing, and fixed countless bugs in my dodgy code


Important: Unfortunately, my leased vBulletin licence has now expired, and I won't be renewing it until September which means I will be unable to reply to this thread, or update this mod until then. I'm hopeful that the great vBulletin.org community will step in to answer any questions in my absence though See you all in early September!

PLEASE NOTE: This thread is NOT the place to discuss the rights and wrongs of monitoring users Private Messages. That topic has been discussed to death many times before, but if you really feel the need to discuss it, please do so in The Lounge, not in this thread. Thank you

[pollon]

HI.
I have installed this hack in 3.6.5. everithing looked fine but when i tried to "approve" the message from the admin cp i got this error message:

PHP Code:

Database error in vBulletin 3.6.5:

Invalid SQL:
SELECT id, dateline, pmdetails, fromuserid, fromusername, title, message, recipients, recipients_bcc
            FROM moderation_pm
            WHERE id IN ();

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3
Error Number : 1064
Date         : Wednesday, March 7th 2007 @ 11:41:26 AM
Script       : http://www.my-forum.com/forums/modcp/moderate_pm.php?do=update
Referrer     : http://www.my-forum.com/forums/modcp/moderate_pm.php?do=list
IP Address   : -----------------
Username     :------------------------
Classname    : vb_database 


and when i tried to "reject" the message i got this:

PHP Code:

Database error in vBulletin 3.6.5:

Invalid SQL:
DELETE FROM moderation_pm
            WHERE id IN ();

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2
Error Number : 1064
Date         : Wednesday, March 7th 2007 @ 11:42:10 AM
Script       : http://www.my-forum.com/forums/modcp/moderate_pm.php?do=update
Referrer     : http://www.my-forum.com/forums/modcp/moderate_pm.php?do=list
IP Address   : ----------------
Username     : ---------------
Classname    : vb_database 


anyone can help me please?

[Merjawy]

Originally Posted by BoYagoob

Yes, you can simply:
1. put the PHP file in the admincp folder
2. change the path of that file in XML file(s)


but I have one question: do you have the same problem that I have:
https://vborg.vbsupport.ru/showpost....4&postcount=85
?

Thanks, I'll try that

as for your question, I have not really tested it from a user's point but thats what I read in here

[ORACLE]

i was having a problem backing up my database because of this mod i kept getting errors.
the product would not install, because it said the table was unknown or that the was nor info in the table (empty). so i had to edit the product so it did not remove the table just the product but no i get a server error in phpmyadmin and vb backup so i can only think this is down to this table. can you tell me how i can force the deletion of this table???
thanks
ORACLE

[Chadi]

It seems like I get duplicates of pm's in the moderation queue. Today, there was about 10 of the same pm, and I'm 100% sure the sender did not accidentally press send 10 times. Anyone know of a fix?

[Chadi]

I hope someone else (coder) can take over this hack and implement these features:

- apply moderation to certain usergroups only
- mass approve / disapprove check box
- ajax preview (tooltip / hover over icon??)

[OTTIX]

Hi, why the welcome pn does not arrive to the member, when i aprove the pn from my admin account.

thanks

[Apocalypz]

I installed the code for version 3.6.5 and it does not show up when I click on moderation or vbulletin options...any help?

[OTTIX]

Hi, why the welcome pn does not arrive to the member, when i aprove the pn from my admin account.

thanks

added;
I see that ther is no Reiceipt in the personal message. (The field "Receipt(s)" is empty)

[OTTIX]

Hi, why the welcome pn does not arrive to the member, when i aprove the pn from my admin account.

thanks

added;
I see that ther is no Reiceipt in the personal message. (The field "Receipt(s)" is empty)

please help :-)

[COBRAws]

Originally Posted by chadi

It seems like I get duplicates of pm's in the moderation queue. Today, there was about 10 of the same pm, and I'm 100% sure the sender did not accidentally press send 10 times. Anyone know of a fix?

Thats because no "your PM has been sent to XXX" is shown to the user, and he believes that the PM was not sent, so he writes it again and send it.

The truth is that the pm was sent, but this Filter does not tell the user that it was sent.