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!

[IamPud]

Getting "Invalid recipient username" don't think i missed anything but any hints?

[msgotit]

Originally Posted by IamPud

Getting "Invalid recipient username" don't think i missed anything but any hints?

I would assume this is the message you get back when you click "Count and Confirm" (if not let me know). It doesn't make sense that you are getting this, when I get home and can look at this more closely I will let you know, I am actually post an update tonight so that might solve your problem. If you have any other info that will help let me know, but like I said I will look at it tonight, sorry about the delay!

[IamPud]

Actually i click that count and confirm and it returns the number that i want with the submit message button. When i click that is when i get the error.

[Telegon80]

ill install this tomorrow cool hack!

[msgotit]

Originally Posted by IamPud

Actually i click that count and confirm and it returns the number that i want with the submit message button. When i click that is when i get the error.

I have updated the files, it isn't for your specific error, but I think that it should work. If you want to try and reupload the files and see what that does, let me know if it isn't fixed!

[IamPud]

I did an uninstall first then imported the new xml file and got this

Database error in vBulletin 3.5.0:

Invalid SQL:
ALTER TABLE `user` ADD `spmoption` INT( 10 ) DEFAULT '0' NOT NULL;

If i go into the CP and Select SuperPM i get

Invalid SQL:
SELECT count(*) as users from vb3_user
WHERE spmugroup > 0;

[utw-Mephisto]

I don't find the settings ?!?

[utw-Mephisto]

never mind, found it

[Digma]

Msgotit, this is exactly what I was looking for and am tempted to try once we upgrade to 3.5.x.

However, with around 5,000 users I am affraid to do so until some load management has been built in. Sending the PM to 250 users max at a time and a quick pause before continuing with the next 250, until you have PM-ed everyone.

You mentioned you would look into it, any luck so far?

Keep up to good work :up:

[msgotit]

Originally Posted by IamPud

I did an uninstall first then imported the new xml file and got this

Database error in vBulletin 3.5.0:

Invalid SQL:
ALTER TABLE `user` ADD `spmoption` INT( 10 ) DEFAULT '0' NOT NULL;


If i go into the CP and Select SuperPM i get

Invalid SQL:
SELECT count(*) as users from vb3_user
WHERE spmugroup > 0;

IamPud,

I have reuploaded the file, I thought I had taken care of that problem, I didn't have the table prefix on the front of the tables when adding the fields, it should be there now so we should be good to go, let me know.