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.

[Kwak]

I just love this hack. Props to the hacker.

[Wifey]

[high]* Wifey clicks install
[/high]

GREAT hack! It works out really well with another hack I have installed in order to let people know how to check what usergroup they were sorted into. It also keeps another group of special members that I have who welcome new members to their clique with work

Thank you so much!

[NightWalk8r]

I got this error when i try 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. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
INSERT INTO vb3_phrase (phraseid, languageid, varname, `text

Please help

[rob_daemon]

Originally Posted by NightWalk8r

I got this error when i try 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. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
INSERT INTO vb3_phrase (phraseid, languageid, varname, `text

Please help

Can you please paste the whole query here so I can try to trouble shoot it?

[NightWalk8r]

I used this because my DB uses the vb3_ prefix.

INSERT INTO `vb3_setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('regpmfrom', 'register', '1', '1', '', 140, 0, 0);
INSERT INTO vb3_phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALUES (NULL, '0', 'setting_regpmfrom_title', 'User Who Sends Automatic PM Upon Registration', '5000');
INSERT INTO vb3_phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALUES (NULL, '0', 'setting_regpmfrom_desc', 'Enter the user ID of the person whose account you\'d like to be used when sending new users a welcome PM upon registering.', '5000');


INSERT INTO `vb3_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);
INSERT INTO vb3_phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALUES (NULL, '0', 'setting_regpmtext_title', 'Welcome PM Text', '5000');
INSERT INTO vb3_phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALUES (NULL, '0', 'setting_regpmtext_desc', 'Set the text of the PM sent to all new users.<br />\r<br />\rNote: You can use the following variables to specify the <b>user\'s</b> information: $username, $userid, $email. And you can use the $bbtitle to specify the board\'s name.', '5000');


INSERT INTO `vb3_setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('regpmtitle', 'register', 'Welcome to $bbtitle!', 'Welcome to $bbtitle!', '', 160, 0, 0);
INSERT INTO vb3_phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALUES (NULL, '0', 'setting_regpmtitle_title', 'Title Of the PM That is Automatically Sent to New Users', '5000');
INSERT INTO vb3_phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALUES (NULL, '0', 'setting_regpmtitle_desc', 'Set the title of the PM that is sent to all new users automatically. You can use the same variables as the ones that you can use for the PM text (see above).', '5000')

This is the error i keep getting =/

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. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
INSERT INTO vb3_phrase (phraseid, languageid, varname, `text

[rob_daemon]

I just ran all of those queries without problem. Try running each one individually to see where the problem occurs.

[NightWalk8r]

wow!!! it works!!!! hmm.........i wonder why? -_-
Thank you soooo much =)

[rob_daemon]

Very odd. Where were you running the queries? Command line, phpMyAdmin, vB Admin CP?

[mtha]

Originally Posted by mtha

Seem like the function wasnt implemented, so I gave it a shot.
If you already install the hack, do the followings

run this querry to add another option (turn on/off) to your "vB Registration Options

INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('regpmactive', 'register', '1', '1', '', 139, 0, 0);
 INSERT INTO phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALUES (NULL, '0', 'setting_regpmactive_title', 'Send default PM to new users?', '5000');
 INSERT INTO phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALUES (NULL, '0', 'setting_regpmactive_desc', '', '5000');

In registration.php

Look for

	   $pmoptions['regpmtext'] = $vboptions['regpmtext'];

add above:

 		$pmoptions['regpmactive'] = $vboptions['regpmactive'];

Look for:

		// Send the new owner a PM
 		$DB_site->query(

Add above:

if ($pmoptions['regpmactive']) {

LOOK FOR

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

ADD ABOVE:

}

Rob, do you want to add this option to turn ON/OFF the welcome PM into your hack?

I think I'd be very handy for users

[rob_daemon]

Originally Posted by mtha

Rob, do you want to add this option to turn ON/OFF the welcome PM into your hack?

I think I'd be very handy for users

It's in the version in CVS, I've just been busy writing my term papers and other things to clean it up and update all the instructions. I'm hoping to get new versions of my three hacks out next weekend.