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!

[KevNJ]

Originally Posted by msgotit

There are two fields you can add people in, one is a UserID and the other is a username, make sure you are using the correct one. That would be my guess. Let me know if that isn't the problem!!

I got it using the userid, was User error. Works perfectly now! :banana:

::clicks install::

[plateau]

Installed! Clicked!!!!!!!

Thank you very much msgotit!

===

and, have u worked out the solution for those forums that have so many users? i mean the function that sends batch PMs, such as 500/time.

===

anyway, thanks a lot and all the best!!!

[Aaron RV]

work on 3.5.4?

[plateau]

Tested Around, Everything runs well on VB3.5.4.

Thanks.

[msgotit]

plateau,

It doesn't send 500 at a time, but the way it inserts it goes relatively fast, I don't know how hard it is on the server, but one person did post that they sent it to about 21000 (I believe, check earlier post) and said that it was ok. It does not email anyone at this point, I am working on that, but have been pretty busy, although if I do get that done I don't think it is something for bigger boards. Hope that helps!

Mark

[plateau]

Originally Posted by msgotit

plateau,

It doesn't send 500 at a time, but the way it inserts it goes relatively fast, I don't know how hard it is on the server, but one person did post that they sent it to about 21000 (I believe, check earlier post) and said that it was ok. It does not email anyone at this point, I am working on that, but have been pretty busy, although if I do get that done I don't think it is something for bigger boards. Hope that helps!

Mark

Mark, thank you very much for your reply. OK I think that wont be a problem for my site to use the Super PM.

It is a good hack and all my SMods are happy with that. All the best for you, cheers!

[BoYagoob]

Originally Posted by jellybaby

For some reason when I use this its not automatically sending emails to those members wanting to know if they have received a pm. Anyone else have this problem?

Thanks

It will be perfect, if this feature is made ..

[3mr3]

very nice thanks

[drumsy]

I've received the following error after attempting to send to about 21,000 members:

Database error in vBulletin 3.5.4:

Invalid SQL:
INSERT INTO pm (pmtextid, userid, folderid, messageread) VALUES (121879, 50870, 0, 0), (121879, 50872, 0, 0), (121879, 50877, 0, 0), (121879, 50879, 0, 0), (121879, 50891, 0, 0), (121879, 50904, 0, 0), (121879, 50905, 0, 0), (121879, 50906, 0, 0), (121879, 50907, 0, 0), (121879, 50917, 0, 0), (121879, 50918, 0, 0), (121879, 50920, 0, 0), (121879, 50929, 0, 0), (121879, 50938, 0, 0), (121879, 50940, 0, 0), (121879, 50943, 0, 0), (121879, 50950, 0, 0), (121879, 50952, 0, 0), (121879, 50953, 0, 0), (121879, 50956, 0, 0), (121879, 50959, 0, 0), (121879, 50960, 0, 0), (121879, 50961, 0, 0), (121879, 50969, 0, 0), (121879, 50970, 0, 0), (121879, 50974, 0, 0), (121879, 50975, 0, 0), (121879, , 0, 0), (121879, 50978, 0, 0), (121879, 50981, 0, 0), (121879, 50982, 0, 0), (121879, 50985, 0, 0), (121879, 50988, 0, 0), (121879, 50991, 0, 0), (121879, 50992, 0, 0), (121879, 50993, 0, 0), (121879, 50994, 0, 0), (121879, 50998, 0, 0), (121879, 51002, 0, 0), (121879, 51004, 0, 0), (121879, 51005, 0, 0), (121879, 51007, 0, 0), (121879, 51012, 0, 0), (121879, 51017, 0, 0), (121879, 51018, 0, 0), (121879, 51019, 0, 0), (121879, 51024, 0, 0), (121879, 51026, 0, 0), (121879, 51027, 0, 0), (121879, 51029, 0, 0), (121879, 51035, 0, 0), (121879, 51038, 0, 0), (121879, 51040, 0, 0), (121879, 51042, 0, 0), (121879, 51048, 0, 0), (121879, 51050, 0, 0), (121879, 51055, 0, 0), (121879, 51060, 0, 0), (121879, 51062, 0, 0), (121879, 51063, 0, 0), (121879, 51064, 0, 0), (121879, 51066, 0, 0), (121879, 51068, 0, 0), (121879, 51074, 0, 0), (121879, 51077, 0, 0), (121879, 51078, 0, 0), (121879, 51079, 0, 0), (121879, 51081, 0, 0), (121879, 51083, 0, 0), (121879, 51085, 0, 0), (121879, 51087, 0, 0), (121879, 51088, 0, 0), (121879, 51091, 0, 0), (121879, 51094, 0, 0), (121879, 51095, 0, 0), (121879, 51103, 0, 0), (121879, 51104, 0, 0), (121879, 51105, 0, 0), (121879, 51109, 0, 0), (121879, 51113, 0, 0), (121879, 51116, 0, 0), (121879, 51117, 0, 0), (121879, 51118, 0, 0), (121879, 51119, 0, 0), (121879, 51126, 0, 0), (121879, 51128, 0, 0), (121879, 51139, 0, 0), (121879, 51143, 0, 0), (121879, 51148, 0, 0), (121879, 51150, 0, 0), (121879, 51152, 0, 0), (121879, 51155, 0, 0), (121879, 51156, 0, 0), (121879, 51157, 0, 0), (121879, 51160, 0, 0), (121879, 51168, 0, 0), (121879, 51180, 0, 0), (121879, 51181, 0, 0), (121879, 51184, 0, 0), (121879, 51185, 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), (121879, 50978, 0, 0), (121879, 50981, 0, 0), (121879, 
Error Number : 1064
Date         : Monday, May 1st 2006 @ 09:47:40 PM
Script       : http://www.honda-acura.net/forums/superpm.php
Referrer     : http://www.honda-acura.net/forums/superpm.php
IP Address   : 166.82.44.125
Username     : Daniel
Classname    : vb_database

[haytham]

Works perfectly. Thanks a lot. Clicked install.