Super PM (Mass PM)

-------------------------------------
Super Private Message
-------------------------------------
Hack Version: 1.0.4
vB-version: 3.5.x
Developer: msgotit
Install-difficulty: Easy

Description:
Allows specified users to send a Private Message to certain groups of people.

This is basically the same as the hack created by UAE and in talking with him I have posted this here.

Super Private Message will give you the convenience and ability to provide many different options for sending mass private messages to users by any one you choose to assign this task to based on Conditionals (if):

User's Usergroup is Y.
User's has posts greater than x posts.
User's has posts less than x posts.
User's Join Date is After (yyyy-mm-dd).
User's Join Date is Befor (yyyy-mm-dd).
User's Last Activiy is After (yyyy-mm-dd).
User's Last Activiy is Befor (yyyy-mm-dd).
User's Last Post is After (yyyy-mm-dd).
User's Last Post is Befor (yyyy-mm-dd).

Settings in the Admin CP:

Specify who gets to use the Super Private Message System by Assigning their User Names or User IDs.
Specify the Secondary and Primary usergroup they can send a mass pm to.
Select what usergroup to be visible for selection(s).
Select to have the assignee change his identity when sending.
Control what fields to be visible for each assignee.
List All assignee, delete/edit them.

Hack Installation Details:

New files for this Hack: 2
/admincp/adminsuperpm.php
/superpm.php

New templates for this Hack: 1
pm_newsuperpm

Template-edits: 1
pm_newpm

DB Tables modified for this Hack: 1
user

History:

1.0.1 BETA
Fixed bug in xml
No longer show to whom the message will be sent (if you like that don't upload the superpm.php file. If your copy is working there is really no need to upgrade, there are no major changes yet - hopefully soon there will be!

1.0.2 BETA
Changed wording in Template - Makes more sense
Changed location of SuperPM link in admincp - Contained in the "User" group
Changed insert to fix/help fix the problem with overloading the server
Added option for admin to show to whom message will be sent

1.0.3
Fixed bug causing a php error * Thanks for the report Fofer
Fixed bug saving message to sent items even if you don't send it.

1.0.4
Added Email on pm - WARNING this will most likely not work if sending to over 500 people (probably ok up to 1000) although may be server intensive. Also, to do that you will likely have to change the max number or pms in superpm.php file from 500 to 1000.
Misc. changes as requested.

To upgrade, upload files and import the new product, click on overwrite and you will be set.
-------------------------------------

PLEASE REMEMBER TO BACKUP BEFORE YOU BEGIN!

If you like this hack, please be kind and click "INSTALL" Link.

This has been tested and seems to be working fine. If you find any errors please let me know!

[cdembek]

I now get this message..

Database error in vBulletin 3.5.4:

Invalid SQL:
INSERT INTO pm (pmtextid, userid, folderid, messageread) VALUES (1295, 6, 0, 0), (1295, 7, 0, 0), (1295, 9, 0, 0), (1295, 10, 0, 0), (1295, 11, 0, 0), (1295, 12, 0, 0), (1295, 13, 0, 0), (1295, 14, 0, 0), (1295, 15, 0, 0), (1295, 16, 0, 0), (1295, 18, 0, 0), (1295, 19, 0, 0), (1295, 20, 0, 0), (1295, 21, 0, 0), (1295, 22, 0, 0), (1295, 23, 0, 0), (1295, 24, 0, 0), (1295, 25, 0, 0), (1295, 26, 0, 0), (1295, 27, 0, 0), (1295, 28, 0, 0), (1295, 29, 0, 0), (1295, 30, 0, 0), (1295, 31, 0, 0), (1295, 32, 0, 0), (1295, 33, 0, 0), (1295, 34, 0, 0), (1295, 35, 0, 0), (1295, 36, 0, 0), (1295, 37, 0, 0), (1295, 38, 0, 0), (1295, 39, 0, 0), (1295, 40, 0, 0), (1295, 41, 0, 0), (1295, 42, 0, 0), (1295, 43, 0, 0), (1295, 44, 0, 0), (1295, 45, 0, 0), (1295, 46, 0, 0), (1295, , 0, 0), (1295, 49, 0, 0), (1295, 50, 0, 0), (1295, 51, 0, 0), (1295, 52, 0, 0), (1295, 53, 0, 0), (1295, 54, 0, 0), (1295, 55, 0, 0), (1295, 56, 0, 0), (1295, 57, 0, 0), (1295, 58, 0, 0), (1295, 59, 0, 0), (1295, 60, 0, 0), (1295, 61, 0, 0), (1295, 62, 0, 0), (1295, 63, 0, 0), (1295, 64, 0, 0), (1295, 65, 0, 0), (1295, 66, 0, 0), (1295, 67, 0, 0), (1295, 68, 0, 0), (1295, 69, 0, 0), (1295, 70, 0, 0), (1295, 71, 0, 0), (1295, 72, 0, 0), (1295, 73, 0, 0), (1295, 74, 0, 0), (1295, 75, 0, 0), (1295, 76, 0, 0), (1295, 77, 0, 0), (1295, 78, 0, 0), (1295, 79, 0, 0), (1295, 80, 0, 0), (1295, 81, 0, 0), (1295, 82, 0, 0), (1295, 83, 0, 0), (1295, 84, 0, 0), (1295, 85, 0, 0), (1295, 86, 0, 0), (1295, 87, 0, 0), (1295, 88, 0, 0), (1295, 89, 0, 0), (1295, 91, 0, 0), (1295, 92, 0, 0), (1295, 93, 0, 0), (1295, 94, 0, 0), (1295, 95, 0, 0), (1295, 96, 0, 0), (1295, 97, 0, 0), (1295, 98, 0, 0), (1295, 99, 0, 0), (1295, 100, 0, 0), (1295, 102, 0, 0), (1295, 103, 0, 0), (1295, 104, 0, 0), (1295, 105, 0, 0), (1295, 106, 0, 0), (1295, 107, 0, 0), (1295, 109, 0, 0), (1295, 110, 0, 0), (1295, 111, 0, 0);

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 ' 0, 0), (1295, 49, 0, 0), (1295, 50, 0, 0), (1295, 51, 0, 0), (
Error Number : 1064

[DjTaz]

Originally Posted by cdembek

I now get this message..

Database error in vBulletin 3.5.4:

Invalid SQL:
INSERT INTO pm (pmtextid, userid, folderid, messageread) VALUES (1295, 6, 0, 0), (1295, 7, 0, 0), (1295, 9, 0, 0), (1295, 10, 0, 0), (1295, 11, 0, 0), (1295, 12, 0, 0), (1295, 13, 0, 0), (1295, 14, 0, 0), (1295, 15, 0, 0), (1295, 16, 0, 0), (1295, 18, 0, 0), (1295, 19, 0, 0), (1295, 20, 0, 0), (1295, 21, 0, 0), (1295, 22, 0, 0), (1295, 23, 0, 0), (1295, 24, 0, 0), (1295, 25, 0, 0), (1295, 26, 0, 0), (1295, 27, 0, 0), (1295, 28, 0, 0), (1295, 29, 0, 0), (1295, 30, 0, 0), (1295, 31, 0, 0), (1295, 32, 0, 0), (1295, 33, 0, 0), (1295, 34, 0, 0), (1295, 35, 0, 0), (1295, 36, 0, 0), (1295, 37, 0, 0), (1295, 38, 0, 0), (1295, 39, 0, 0), (1295, 40, 0, 0), (1295, 41, 0, 0), (1295, 42, 0, 0), (1295, 43, 0, 0), (1295, 44, 0, 0), (1295, 45, 0, 0), (1295, 46, 0, 0), (1295, , 0, 0), (1295, 49, 0, 0), (1295, 50, 0, 0), (1295, 51, 0, 0), (1295, 52, 0, 0), (1295, 53, 0, 0), (1295, 54, 0, 0), (1295, 55, 0, 0), (1295, 56, 0, 0), (1295, 57, 0, 0), (1295, 58, 0, 0), (1295, 59, 0, 0), (1295, 60, 0, 0), (1295, 61, 0, 0), (1295, 62, 0, 0), (1295, 63, 0, 0), (1295, 64, 0, 0), (1295, 65, 0, 0), (1295, 66, 0, 0), (1295, 67, 0, 0), (1295, 68, 0, 0), (1295, 69, 0, 0), (1295, 70, 0, 0), (1295, 71, 0, 0), (1295, 72, 0, 0), (1295, 73, 0, 0), (1295, 74, 0, 0), (1295, 75, 0, 0), (1295, 76, 0, 0), (1295, 77, 0, 0), (1295, 78, 0, 0), (1295, 79, 0, 0), (1295, 80, 0, 0), (1295, 81, 0, 0), (1295, 82, 0, 0), (1295, 83, 0, 0), (1295, 84, 0, 0), (1295, 85, 0, 0), (1295, 86, 0, 0), (1295, 87, 0, 0), (1295, 88, 0, 0), (1295, 89, 0, 0), (1295, 91, 0, 0), (1295, 92, 0, 0), (1295, 93, 0, 0), (1295, 94, 0, 0), (1295, 95, 0, 0), (1295, 96, 0, 0), (1295, 97, 0, 0), (1295, 98, 0, 0), (1295, 99, 0, 0), (1295, 100, 0, 0), (1295, 102, 0, 0), (1295, 103, 0, 0), (1295, 104, 0, 0), (1295, 105, 0, 0), (1295, 106, 0, 0), (1295, 107, 0, 0), (1295, 109, 0, 0), (1295, 110, 0, 0), (1295, 111, 0, 0);

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 ' 0, 0), (1295, 49, 0, 0), (1295, 50, 0, 0), (1295, 51, 0, 0), (
Error Number : 1064

You have a problem with either your SQL database or the script trying to generate the INSERT. You have a number missing somewhere - possibly a usernumber

[sabret00the]

If i get permission off of the author i'll port it to 3.6.x

[CP,]

Hi there i am sending bulk emails and i have sent a few now via my forum.

I then came to send more bulk pm's to another group which are around 900 members. It shows me this error message:

Fatal error: Unable to proceed with save while $errors array is not empty in class vb_datamanager_pm in /includes/class_dm.php on line 758

does anybody know whats wrong...?

Cheers!

[erdiyilmaz]

is this works under v3.6.7-PL ?

[USAMustangs.com]

Originally Posted by FunaGuy

There is any coder thats make this hack for vb 3.6.5

that would be nice

[Tralala]

"Super PM" doesn't show up for me under AdminCP -> Users.

I've tried clearing cache and also tried a 2nd browser.

But the page *does* come up when I manually go to http://www.myforum.com/admincp/adminsuperpm.php

otherwise seems to be running okay in vBull 3.6.5.

How can I get the settings to show up in AdminCP?

[sabret00the]

hey folks. i did get permission to port this but i haven't had a chance to do so yet. sorry for the delay.

[USAMustangs.com]

Originally Posted by sabret00the

hey folks. i did get permission to port this but i haven't had a chance to do so yet. sorry for the delay.

awesome!

keep us posted.

[Tralala]

Awesome sabret00the... and thanks for keeping us updated!