Automatic PM on New Thread
 

What this hack does?

This hack will allow the admin to setup a certain usergroup to receive an instant PM notification informing that usergroup that a new thread in the specified forum has been created.

How to install?

1. Import the Product
2. Template Edit: newthread
   • Find the following:
     HTML Code:

     ---

     <tr>
            <if condition="$prefix_options">

     ---

   • Replace with:
     HTML Code:

     ---

     $sendpm
       
        <tr>
            <if condition="$prefix_options">

     ---

You will need to go into your vBulletin Admin Control Center and do the following.

1. On the left frame find: User Profile Fields
2. Then click on: Add New User Profile Field. Set with these properties
   • Single Selection Menu
   • Title and description you can set to how you want it
   • Options: Yes and No (Make sure you separate by a line break)
   • Set Default: Yes, But No First Blank Option
   • Field Required: No, but display at registration
   • Field Editable by User: Yes
   • Display Page: Other:Options
   • Note: You can change the other settings that I did not list to how you want it
   • Important: After it saves you will be taken back to the User Profile Field Manager, here you will see what field# you have, such as field5, remember that number for later use.

Settings?

1. vBulletin Options:
   • Userid - Enter the userid that the PM will be sent from
   • Username - Enter the username that the PM will be sent from
   • Usergroupid's - Enter the usergroupid's (separated by a coma) to send the PM to.
   • Custom Profile Field - Enter the custom profile field number that you set up above.
2. Forum Manager
   • Enable/Disable

Customize it for yourself?

You can go ahead and edit the six phrases to suite your needs with it. The variables are prefixed with autopm_.

Please click install if you use!

Suggestions are always welcomed!

Reserved for future use

great mod mike

Can you explain in detail as to what the custom profile field does and why it is needed. Do you have to do the custom profile field in order for this hack to work?

Thanks,
Itworx4me

It gives the person in the usergroup (set by admin) a chance to opt on on being auto pmed.

ideas ?

Great mod, would be usefull to send PM to users subscribed to certain vb social group.
for example BMX lovers about posts in Bikes forum... ect..

thanks great mod I might install it later

how would this work for large databases ?

if a usergroup has more than 30 000 people..Will it crash my server ? or does it send a certain amount of mail at a time ? etc ?

yes i get the same db error :

Database error in vBulletin 3.7.1:

Invalid SQL:

ALTER TABLE thread
ADD sendpm varchar(100) UNSIGNED NOT NULL;

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 'UNSIGNED NOT NULL' at line 2
Error Number : 1064
Request Date : Wednesday, July 2nd 2008 @ 05:31:41 AM
Error Date : Wednesday, July 2nd 2008 @ 05:31:42 AM
Script : http://www.maroceve.com/forums/admin...=productimport
Referrer : http://www.maroceve.com/forums/admin...?do=productadd
IP Address : 41.251.65.88
Username : Ez
Classname : vB_Database
MySQL Version : 4.1.22-standard

Updated. Should have the fix now.