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.

[dsboyce8624]

Originally Posted by SRuvbnhad

For some reason NotePad will not display the file correctly. Right click on it and open with WordPad. Works fine.

Also getting an error when trying to run the queries:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax near ';
INSERT INTO phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALU' at line 1

Try pasting one query at a time, usually the CR/LF at the end will mess them up if you do 'em all at once.

[gonecountry]

I just installed and it worked great, but I have one small question and I may have missed the answer in this thread, where do I change the user id of who is sending the pm. ie defaults to user id #1 want to be user id # 5.

[rob_daemon]

Originally Posted by gonecountry

I just installed and it worked great, but I have one small question and I may have missed the answer in this thread, where do I change the user id of who is sending the pm. ie defaults to user id #1 want to be user id # 5.

Go to:

Admin CP --> Options --> vBulletin Options --> User Registration Options

And you'll find the setting for this there.

[gonecountry]

Thank you

[cmiller1014]

Will it work on 3.0.7?

[Mijae]

Originally Posted by cmiller1014

Will it work on 3.0.7?

It does.

[mcyates]

I've got a problem, the new pms are getting sent out 8 times instead of just 1. Is there anything i can do about this?

[rob_daemon]

Originally Posted by mcyates

I've got a problem, the new pms are getting sent out 8 times instead of just 1. Is there anything i can do about this?

I have no idea why this would be happening. Does the happen every time? Try uploading the original register.php and then rehacking it.

[Megareus Rex]

Whenever I try to open the .txt instructions, it erases all of the line breaks, so its all one big jumble of unintellgible text. I managed to seperate the queries out of it, but I can't do the php like that.

Is there something wrong with the instruction file?

EDIT: Nevermind, my comp was just being stupid.

[ManagerJosh]

Sigh

Rob, here got that error for you

Invalid SQL: INSERT INTO pmtext ( fromuserid, fromusername, title, message, touserarray, iconid, dateline, showsignature, allowsmilie ) VALUES ( 1, 'ManagerJosh', 'Welcome to WorldSims Forums!', 'Hello it\'s_like_that, and Welcome to WorldSims Forums!We appreciate you taking the time to register on our site. We hope you will enjoy your stay here and become an active part of this outgrowing community.If you have any questions please feel free to contact any person of our http://forums.worldsims.org/showgroups.php]team[/URL].We hope to see you around.Have Fun!The WorldSims.org Team', 'a:1:{i:15876;s:14:"it's_like_that";}', 0, 1119734548, 0, 0 )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 's_like_that";}', 0, 1119734548, 0, 0 )' at lmysql error number: 1064