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!

[Stoebi]

Hi

It has nothing to do with my fix for 3.6.x.

AdminCP -> Users -> Super PM
Delete your assigned users
Assign a new user
Note! No , at the end after the userid.

Example:
1,2,3,4 is correct

1,2,3,4, is false!


Regards, Stoebi

Originally Posted by craiovaforum

For me it doesn't work

I get this database error:

Database error in vBulletin 3.6.1:

Invalid SQL:
SELECT * FROM vb_usergroup 
						WHERE usergroupid IN (4,6,14,36,8,27,39,38,29,30,34,19,32,35,23,5,18,9,24,22,11,7,25,13,28,17,37,2,31,26,21,15,33,20,16,1,) ORDER BY title;

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 ') ORDER BY title' at line 2
Error Number : 1064
Date         : Thursday, September 21st 2006 @ 08:05:19 PM
Script       : */superpm.php
Referrer     : */private.php?do=newpm
Classname    : vB_Database

[craiovaforum]

I don't know why it adds that , at the end but I removed several usergroups and it works perfectly...

[GoNz00]

woohoo, works for me 2

thanks mate

[GoNz00]

arghh, it sends the PM twice, does anyone have an idea what i need to look at to fix this ?

i double checked i havn't screwed up the original code, or the mod to make it 3.6.x compliant

[KevNJ]

Works with my default style, but will not show on my custom style because the css is using an image for the catagories box. is there a way you can relocate where the "send super pm" text shows up ?

[KevNJ]

wahoooo... like the others have said.. works great.... ill just switch style changes to on... switch to default... send out the email and then switch styles to off... not a big deal.. cause this now works and thats what ive wanted.. WAHOOOOOOOOOOO!!!!!! stoebi for member of the month!!! ( do we have a member of the month.. we should )

[Stoebi]

Originally Posted by KevNJ

wahoooo... like the others have said.. works great.... ill just switch style changes to on... switch to default... send out the email and then switch styles to off... not a big deal.. cause this now works and thats what ive wanted.. WAHOOOOOOOOOOO!!!!!! stoebi for member of the month!!! ( do we have a member of the month.. we should )

Hi

Thx

If you use more than one style with vBulletin, it is necessary to edit these used styles too.

################################################## ###########################
############################## TEMPLATE EDITS ###############################
################################################## ###########################

******************************* IN pm_newpm *******************************

FIND

<td class="tcat">$vbphrase[post_new_private_message]</td>

REPLACE WITH


<!-- [START HACK='Super Private Message' AUTHOR='msgotit and WwW.UAEWEB.COM' VERSION='1.0.0' CHANGEID= 1 ] -->
<td class="tcat"><if condition="$bbuserinfo['spmoption']"><a style="float:$stylevar[right]" href="superpm.php">Send Super Private Message</a></if>$vbphrase[post_new_private_message]</td>
<!-- [END HACK='Super Private Message' AUTHOR='msgotit and WwW.UAEWEB.COM' VERSION='1.0.0' CHANGEID= 1 ] -->



Step 6. Enjoy your new hack. And if you haven't already, click install at vBulletin.org.

################################################## ###########################
################################### THE END #################################
################################################## ###########################

Do this for all your installed styles. Have fun.


Kind Regards, Stoebi

[GoNz00]

Originally Posted by GoNz00

arghh, it sends the PM twice, does anyone have an idea what i need to look at to fix this ?

i double checked i havn't screwed up the original code, or the mod to make it 3.6.x compliant

bump, help. i looked for things entered twice, and see none

[KevNJ]

Okay that worked... But Im having the problem GoNz00 is having double sending. I notice when I sent to myself ( admin ) i get the message twice. Then when I send to myself ( admin ) and mods. I get the message twice again, but the mods gets no message. Then when I send to mods only they get nothing. Each time it says the messages are sent but either I get it twice, or the mods dont get it at all.

Originally Posted by Stoebi

Hi

Thx

If you use more than one style with vBulletin, it is necessary to edit these used styles too.




Do this for all your installed styles. Have fun.


Kind Regards, Stoebi

[GoNz00]

still fubar then

oh well, i wonder if it will play ball when i go from 3.6 to 3.6.1

you still on 3.6 Kev ?