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!

[sagiklein]

Error:

Database error in vBulletin 3.5.1:

Invalid SQL:
INSERT INTO pm (pmtextid, userid, folderid, messageread) VALUES (60483, 6417, 0, 0), (60483, 7758, 0, 0), (60483, 8166, 0, 0), (60483, 9872, 0, 0), (60483, 11129, 0, 0), (60483, 12516, 0, 0), (60483, 14312, 0, 0), (60483, 14879, 0, 0), (60483, 15109, 0, 0), (60483, 15732, 0, 0), (60483, 17072, 0, 0), (60483, 17221, 0, 0), (60483, 17662, 0, 0), (60483, 19080, 0, 0), (60483, 20308, 0, 0), (60483, 20483, 0, 0), (60483, 21270, 0, 0);

MySQL Error  : Table 'pocket4.pm' doesn't exist
Error Number : 1146
Date         : Friday, December 16th 2005 @ 11:27:39 PM

[LBSources]

seems to work for me.. thanks.. problem is it seems to have nuked my pm_popup hack.. cant seem to fix it..

any ideas?

Lenny

[msgotit]

sagiklein

Find this:

PHP Code:

$db->query("INSERT INTO pm (pmtextid, userid, folderid, messageread) VALUES " . implode(", ", $toInsert)); 


Replace with this:

PHP Code:

$db->query("INSERT INTO " . TABLE_PREFIX . "pm (pmtextid, userid, folderid, messageread) VALUES " . implode(", ", $toInsert)); 


I believe that will fix it. Let me know.

[msgotit]

Originally Posted by LBSources

seems to work for me.. thanks.. problem is it seems to have nuked my pm_popup hack.. cant seem to fix it..

any ideas?

Lenny

LBSources,

What is happening, it just doesn't pop-up, or what, I don't know for sure off hand, but if you have some more details, maybe I can figure it out. Mainly what is going on, and what the hack did in the first place? Sorry about that.

Mark

[LBSources]

Originally Posted by msgotit

LBSources,

What is happening, it just doesn't pop-up, or what, I don't know for sure off hand, but if you have some more details, maybe I can figure it out. Mainly what is going on, and what the hack did in the first place? Sorry about that.

Mark

DISREGARD!

silly me and sorry for wasting your time.. i dont know what the heck happened..

it works now

Lenny

Ok.. users do NOT receive an email that they received a new PM when i send a user the SuperPM .. they also dont get the unread message notification that says they have a new message

i cant explain it.. maybe now the blinking pm hack is now in conflict .. i dont mind that the new pm message doesnt show up; but i like to get atleast an email sent.. any idea?

[ronoxQ]

The PM options aren't appearing! What did I do wrong?

[LBSources]

Originally Posted by ronoxQ

The PM options aren't appearing! What did I do wrong?

happened to me; if its now happened to you.. the settings are in the Users section of the AdminCP .. SuperPM

HTH

Lenny

[msgotit]

LBSources,

I know that it isn't sending the email, and what not, part of the problem, is that if your board is very big (a lot of users), running this and having all of that happen will be very server intensive, for those that have a lot of users it often would bring their board down, if you don't have that many users, I could probably find an older copy that would do all of that. I will look into just the email part, you might be ok if you just did that, although I don't know for sure. Let me know what you would like and I will see what I can do!

Mark

[msgotit]

Originally Posted by ronoxQ

The PM options aren't appearing! What did I do wrong?

Did you find it, if not let me know! If you uploaded the xml file then it should be under the users section.

[LBSources]

Originally Posted by msgotit

LBSources,

I know that it isn't sending the email, and what not, part of the problem, is that if your board is very big (a lot of users), running this and having all of that happen will be very server intensive, for those that have a lot of users it often would bring their board down, if you don't have that many users, I could probably find an older copy that would do all of that. I will look into just the email part, you might be ok if you just did that, although I don't know for sure. Let me know what you would like and I will see what I can do!

Mark

Mark, its ok .. i dont plan to use this hack for the whole board. I use it really for staff and when i need them to know something and i want their attention.

For the rest of the board i use the mass email sending ..

so if you could find that ability to send the email notifications; i would like to try it..

Thanks..

Lenny