Super Private Message

-------------------------------------
Super Private Message
-------------------------------------
Hack Version: 1.0.1
vB-version: 3.0.7
Developer: WwW.UAEWEB.CoM
Install-difficulty: Easy


What is it:
Ever wanted to send a mass private message to a group of members?
well, yeah, but what if you want to specify who gets to send this private message and to whome it should be sent.

Private Messages being an effective tool at times Administrators or Moderators are forced to send mass number of private messages. Currently the limitation of sending private messages for various reasons (such as announcement for certain groups, with certain criteria ?etc) is frustrating and that is why the idea of current hack came along.

Super Private Message will give you the convinous and enable you 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):

1. User's Usergroup is Y.
2. User's has posts greater than x posts.
3. User's has posts less than x posts.
4. User's Join Date is After (yyyy-mm-dd).
5. User's Join Date is Befor (yyyy-mm-dd).
6. User's Last Activiy is After (yyyy-mm-dd).
7. User's Last Activiy is Befor (yyyy-mm-dd).
8. User's Last Post is After (yyyy-mm-dd).
9. 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 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.

Super Private Message 1.0.1 Updates:
- New Addition: Can send messages to individuals who are in the usergroup as a Secondary Usergroup instead of just the Primary. ( Credit goes to msgotit )

Installation Update For Super Private Message 1.0.1
You may install v1.0.1 fresh
You may upgrade from v1.0.0 -> 1.0.1 (Read UPGRADE.txt)


Screenshots:

See attachments.

Hack Installation Details:

New files for this Hack: 2
/admincp/adminsuperpm.php
/superpm.php

New templates for this Hack: 1
pm_newsuperpm

File-edits: 1
/admincp/index.php

Template-edits: 1
pm_newpm

DB Tables modified for this Hack: 1
user
-------------------------------------

PLEASE REMEMBER TO BACKUP BEFORE YOU BEGIN!


If you like this hack, please be kind and click on "" Link.

[uae]

Super Private Message v1.0.1 has been released and with the new update, you will be able to send messages to individuals who are in the secodary usergroup instead of just the primary usergoup.

Thanks goes to msgotit for this addition.

You may upgrade by replacing the existing superpm.php with the new one included in the zip file.

[SilverBoy]

I get a dangerous problem

when I send a one message to all my members (more than 36,000) the server is hang up, because it sending an email notification to all members without breaking time between emails.

any idea?

[EricaJoy]

Brilliant!

Now if there was a way to automate the PM sending when a person is added to a group, that would be fantastic!

[EricaJoy]

/me clicks install

[EricaJoy]

Database error in vBulletin 3.0.*:

Invalid SQL: INSERT INTO pmtext (fromuserid, fromusername, title, message, iconid,
dateline, showsignature, allowsmilie) VALUES (, '', 'Welcome to the Premiere Users
Group', 'Welcome to the Premiere Users group. Enjoy your stay!', 0, 1119469648, 1, 1)

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 ' '',
'Welcome to the Premiere Users Group', 'Welcome to the Pre

mysql error number: 1064

I get thise when I attempt to send a Mass PM to a specific Usergroup. I hate error 1064 mainly because I don't know what it means. Any help please?

[EricaJoy]

I think I fixed it...

In superpm.php on Line 404
Found:

				$DB_site->query("INSERT INTO " . TABLE_PREFIX . "pmtext (fromuserid, fromusername, title, message, iconid, dateline, showsignature, allowsmilie) VALUES ($pm[userid], '" . addslashes($pm['username']) .  "', '$title', '$message', $iconid, " . TIMENOW . ", $signature, $disablesmilies)");

Replaced with:

				$DB_site->query("INSERT INTO " . TABLE_PREFIX . "pmtext (fromuserid, fromusername, title, message, iconid, dateline, showsignature, allowsmilie) VALUES ($bbuserinfo[userid], '" . addslashes($bbuserinfo['username']) .  "', '$title', '$message', $iconid, " . TIMENOW . ", $signature, $disablesmilies)");

[mprjr41510]

I'm interested in using this hack but have a concern...

Let's say you send 5000 private messages.. Is there a way to "mass delete" them all after a certain amount of days? Otherwise won't this take up a whole lot of extra memory if you do mass messaging often?

Great idea by the way

[mprjr41510]

SilverBoy,

Are you still having trouble using this hack with your large forum? I have about as many members as you and want to avoid any problems.

[SilverBoy]

yes mprjr41510 the trouble still exist.

my server dieng when I send a private message, I think the hack must be modified to send a specific amount of private message evrytime maybe 500 pm at once, to avoid server hang.

[mprjr41510]

SilverBoy,

Yes, that is a good idea... Similar to the way you can email users through vBulletin. It let's you choose a certain number of messages to send so you can do it in batches.

Hey uae, is this something you can add to the hack?