New User Welcome PM [v2]

This hack will send any new users a welcome PM. This will work in vB3 Gold and probably RC versions as well. I will give support for this hack (if it's needed) in this thread.

If you upgraded your vB version and you are using a hack version prior to July 8, 2004:
If you have upgraded vB and your hack version is not July 8, 2004 or newer, run this query (there was a problem with the prior instructions):

INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('regpmtext', 'register', 'Hi $username and welcome to $bbtitle!\r\n\r\nWe appreciate you taking the time to register on our site and we hope you enjoy your stay.\r\n\r\nIf you have any questions, you can ask an administrator for assistance.\r\n\r\nWe hope to see you around.\r\n\r\nSincerely,\r\nThe $bbtitle staff', 'Hi $username and welcome to $bbtitle!\r\n\r\nWe appreciate you taking the time to register on our site and we hope you enjoy your stay.\r\n\r\nIf you have any questions, you can ask an administrator for assistance.\r\n\r\nWe hope to see you around.\r\n\r\nSincerely,\r\nThe $bbtitle staff', 'textarea', 150, 0, 0);

This hack was last updated: Sun December 5, 2004 at 23:00 PDT
This update has a new on/off switch.

Update includes: vB 3.0.2/3.0.3 instructions

To install follow the instructions in the attached file.

Installation Information
Files to Edit: 1
Queries to Run: 11

Upgrade Instructions:

Open ./register.php and remove the hack (to find the old hack see below). And re-add the updated hack found in the Installation Instructions file.

To upgrade to the December 5th release, you'll need to run these three queries:

INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('regpmon', 'register', '1', '1', 'yesno', 135, 0, 0);
INSERT INTO phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALUES (NULL, '0', 'setting_regpmon_title', 'Automatically Send Welcome PM to New Users?', '5000');
INSERT INTO phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALUES (NULL, '0',  'setting_regpmon_desc', 'Do you want to automatically send a welcome PM to new users?', '5000');

Uninstall Instructions:

Run the queries in this post, and then remove the hack in register.php (see below).

Look for:

PHP Code:

        // ###################################################################
        // # WELCOME PM HACK BY rob_daemon
        // ###################################################################

 // [. . .] There is code here, but I didn't want to take  up more room

        // ###################################################################
        // # END WELCOME PM HACK
        // ################################################################### 


To configure it after installation, go to: Admin CP --> Options --> vBulletin Options --> User Registration Options

Attached is a screen grab of the PM by default and text instructions. If the file appears corrupt, please see this post.

[rob_daemon]

Okay. New version is done. It now has an on/off switch. Sorry for such a delay! I was trying to replicate Manager Josh's problem (page 15) but I was not able to with any form of magic quotes or any quote character as it is all escaped. Manager Josh: if you still have this problem please let me know .

[ManagerJosh]

still having it...I think :-/

Haven't officially rechecked recently. I'll do a test in a couple of hrs...meanwhile will upgrade to the latest changes to see if that bug still exists.

[trackpads]

Great work and thanks for the update!!

[Viks]

the hack text file is all so .. mish..mashed!!
cud you kindly upload a formated text file, it just easy to follow......especially for forum admins who are not techies.



thanks

[rob_daemon]

Originally Posted by Viks

the hack text file is all so .. mish..mashed!!
cud you kindly upload a formated text file, it just easy to follow......especially for forum admins who are not techies.



thanks

This could be caused by your editor, did you read this post?

[Viks]

thanks!!!!!!!!!

[Delphiprogrammi]

i get SQL errors

MySQL retourneerde: 


#1062 - Duplicate entry 'regpmon' for key 1

while running this query

INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('regpmon', 'register', '1', '1', 'yesno', 135, 0, 0);

the uninstallation instructions do not help ....

now how can i get rid of it :nervous:

[Delphiprogrammi]

hi,

never mind that SQL error all installed and working fine thanks for another great one *clicking install*

[4number8]

Thanks alot, works like a charm....clicks Install

[tormodg]

This worked fine for me! Thanks. Installed!