Moderators Functions - Moderation Auto-PM v2.0.1

Moderation Auto-PM
Version 2.0.1

What is it?
Moderation Auto-PM will automaticly send a Private Message to the user whenever their thread, post or attachment is moderated using the Thread Tools or Inline Moderation Tools.

It has support for the following types of moderation:

• Thread: Move
• Thread: Delete
• Thread: Undelete
• Thread: Stick
• Thread: Unstick
• Thread: Open
• Thread: Close
• Thread: Approve
• Thread: Unapprove
• Thread: Title Edit
• Post: Edit
• Post: Move
• Post: Delete
• Post: Undelete
• Post: Approve
• Post: Unapprove
• Attachment: Approve
• Attachment: Unapprove

All options can be turned on/off in the AdminCP. Moderation Auto-PM will not show the user where their thread is being moved to/from if they do not have permission to view the forum. You can also set a "master" exclude list of forum IDs that will never be touched by Moderation Auto-PM.

What's new in Version 2.0.1?

• Added support for opening and closing threads by double-clicking on the thread icon
• Fixed a bug caused by a missing phrase

Credit for this release goes to ConqSoft, as he notice the missing phrase bug, and suggested the new Ajax open/close feature

What's new in Version 2.0?

• Fully compatible with both vB 3.5.4 and vBulletin 3.6 Beta 2 or above! :banana:
• Support for editing posts / titles using the ajax quick edit bits
• Support for deleting posts via quick edit
• Don't send a PM if you are moderating your own thread
• Send a Delete PM instead of a Move PM if moved to a particular forum (ie, a recycle bin type forum)
• Age Cutoff Point - if the item is over a certain age, a PM won't be sent
• A couple of tiny bugfixes that no-one noticed

How do I install / configure it?
Please see the install.txt file contained within the zip.


How do I upgrade?
If you are upgrading from a previous version of this mod (any version), just upload the 3 PHP files, making sure to overwrite the old ones and re-import the Product XML, making sure you set "Allow Overwrite" to Yes.

If you are upgrading from PM on Thread Move, please uninstall that hack first, then install this one following the instructions in install.txt


Thanks go to redlabour for kindly providing a German translation for the phrases and to everyone who nominated this mod or voted for this mod in HotM June

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!

Note The screenshots below are only an example of the messages. The message text is fully editable

[skooby]

Loving this mod, thanks

[tommyxv]

Alan,

I uninstalled the Moderation Auto-PM 1.0 version product, and I received a bunch of database error emails.

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_search AS phrasegroup_search,
language.phrasegroup_inlinemod AS phrasegroup_inlinemod,
language.phrasegroup_autopm_title AS phrasegroup_autopm_title,
language.phrasegroup_autopm_text AS phrasegroup_autopm_text,
language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep

FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) INNER JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 2, user.languageid))

WHERE user.userid = 2772;

MySQL Error : Unknown column 'language.phrasegroup_autopm_title' in 'field list'
Error Number : 1054

I re-installed the updated 1.02 version, but my question is, are we stuck having this installed because of all the automated PM's sitting in users PM boxes???

[Alan @ CIT]

Did all of the plugins get uninstalled as well? Sounds like the uninstall code was run as the language column was deleted, but the plugins didn't get uninstalled.

Give it another try and check that the plugins are removed correctly.

Sorry to hear you are uninstalling it btw, is there anything I can do to improve the product so that you would consider installing it again?

Thanks,
Alan.

[tommyxv]

I have every intent to keep using it. It is a great mod. I wasn't sure how to go from 1.0 to 1.02. The install instructions in the zip made no mention on how to upgrade. I figured the best way would be to just un-install the product from the admincp. Maybe the un-install code from v1.0 didn't work. I did have the 3 include files still on the server after i removed it.

I overwrote the old files with the news ones and then uploaded the 2.0 version. All seems normal now.

Thanks,

[Alan @ CIT]

Good stuff, glad to hear it's all working again

Apologies for not updating the install file, I'll remember to do that for the next version

Thanks,
Alan.

[redlabour]

Update to 1.0.2 and AdminCP Translations. :banana:

[IrPr]

Originally Posted by IrPr

one suggestion:

when someone is moderating his/her own thead/post no report needed.

bump

[redlabour]

Originally Posted by IrPr

bump

Agree !

[bada_bing]

Can you post how to upgrade from 1.0.1 to 1.0.2 please

[redlabour]

Originally Posted by bada_bing

Can you post how to upgrade from 1.0.1 to 1.0.2 please

???? Just look above at the Download. There is your answer.