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!

[msgotit]

Originally Posted by biggjoe

...If/when they click on 'All Usergroups', is that for literally all of the user groups in the forums, or all of ther usergroups that are listed for them only? Which in this case would mean only the one 'Registered Users' usergroup?

Thanks Joe,

The 'All Usergroups' is used to select all of the groups that are listed, I didn't think about it, but I may change that in the next version so that it says 'Select All', because that is really what it does. By selecting it, it just selects all of the groups that are available. Glad you like that hack, and if there is anything that would make it more useful let me know!

Mark

[jellybaby]

I get an error message with this:-

Too many recipients - you are attempting to send to 2790 users but you are only allowed to send to 1000 users.

How can I send to all?

[msgotit]

Originally Posted by jellybaby

I get an error message with this:-

Too many recipients - you are attempting to send to 2790 users but you are only allowed to send to 1000 users.

How can I send to all?

Find this bit of code in superpm.php:

PHP Code:

if ($vbulletin->userinfo['spmoption'])
{
    $permissions['pmsendmax'] = 1000;
    $spmugroupid = $vbulletin->userinfo['spmugroup'];
    $spmoption = convert_bits_to_array($vbulletin->userinfo['spmoption'], $_SPMOPTION);
} 


Change 1000 to 10000 or whatever you want, I meant to change that and will in the next version possibly giving the option to limit it if desired. Sorry about that.

[Watson]

Originally Posted by msgotit

When you send a private message normally you should see just what you see when in the first screen shot. That is, in the right top corner of the box you should see a link to "Send Super Private Message", and that should take you to the superpm.php page. If that isn't there, maybe post the part of the pm_newpm template, a little before and a little after where you edited it and I will see if I can help.

The page shouldn't time out, so I would like to know what it happening, when you say the page times out, is this once you have submited the message or before that? I know that with that many members that there could be a problem, and I am working on a way to fix that, hopefully in the next week I will have that done, but I would like to know what I need to do to make it work better, especially for those with large boards. Thanks for your help

With the timing out, its when I try to send to all members, but its only on the Count bit, it doesnt go to the send and confirm screen. thats when I get a page not found error.

And I found the error with the superPM template bit, I hadn't put it in the right place overwriting the old code

Cheers mate

[hilfe-forum]

first sorry für my bad english

i have this error:

Datenbankfehler in vBulletin 3.5.1:

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

MySQL-Fehler : Table 'abcd.user' doesn't exist
Fehler-Nr. : 1146

but "abcd" is the name of the DB not the table Prefix

can anybody help?
THX!

[msgotit]

Originally Posted by hilfe-forum

first sorry f?r my bad english

i have this error:

Datenbankfehler in vBulletin 3.5.1:

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


MySQL-Fehler : Table 'abcd.user' doesn't exist
Fehler-Nr. : 1146

but "abcd" is the name of the DB not the table Prefix

can anybody help?
THX!

That is likely my bad, I didn't include the table prefix when I created the product, and I now realize I should of, I will get that taken care of and post it.

Mark

EDIT: I uploaded a new xml file. If you still have problems let me know!

[hilfe-forum]

Originally Posted by msgotit

That is likely my bad, I didn't include the table prefix when I created the product, and I now realize I should of, I will get that taken care of and post it.

Mark

EDIT: I uploaded a new xml file. If you still have problems let me know!

THX for help!!!

I have now a other prob.

Fatal error: Call to undefined function: array_chunk() in /var/www/www1/rechner2/wwwneu/vbulletin/superpm.php on line 375

[msgotit]

Originally Posted by hilfe-forum

THX for help!!!

I have now a other prob.

Fatal error: Call to undefined function: array_chunk() in /var/www/www1/rechner2/wwwneu/vbulletin/superpm.php on line 375

Sorry, I have been playing around with it and accidently uploaded the other copy, I think I got the right one now, go ahead and try it and let me know!

[jellybaby]

This caused an overload on my server when I did it as I sent PMs to over 2,500 people how do I stop that happening as it took my site down for 10 mins!:disappointed:

[msgotit]

Originally Posted by jellybaby

This caused an overload on my server when I did it as I sent PMs to over 2,500 people how do I stop that happening as it took my site down for 10 mins!:disappointed:

Give me a couple of days and I believe that I will have a fix, I have been working on making this process less server intensive. I apologize for taking your site down, really didn't mean to do that, but I am close on having a process that won't do that. Again, sorry!!