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.

[SaN-DeeP]

Originally Posted by achtungbaby

I wasn't able to install this hack either...although it is a good idea

Hack is PERFECT.
Follow the POST NO. 72 of rob.

Delete all the queries, upload ur ORIGINAl register.php file and then FOLLOW the Queires in post no. 72, then run all phrase manage queries.

after then goto ADMINCP.... and click save.

then edit ur register.php file again.

It is GONNA WORK FOR 100% SURE.

I had probs, too BUT its INSTALLED PERFECT now.

thnx rob.
nice mod.

although, i am still tricket, i have set that new users, should get an email message once when they receive private messages.

This is the PROCEDURE. on my site.
User register -> auth code is send to his mail
User clicks on the link in mail, and comes to board.
Welcome email is send to user.

Even the WELCOME PM appears in USERS, mail box.
But the email is not send about this NEW PM.. in there mail..

Not really wanted, but IT should WORK. technically.

Sandy..

[AN-net]

when i go to: admincp/options.php?do=editsetting&varname=regpmfrom

it takes me to what it is susposed to be i think. um but for some reason it doesnt show up on the drop down list for settings. im using vb3 gold

[rob_daemon]

Originally Posted by AN-net

when i go to: admincp/options.php?do=editsetting&varname=regpmfrom

it takes me to what it is susposed to be i think. um but for some reason it doesnt show up on the drop down list for settings. im using vb3 gold

Does it look like this? https://vborg.vbsupport.ru/attachmen...chmentid=17874

If so, what does the 'Setting Group' dropdown menu say for yours?

Updated file to include instructions from post number 27. Also, added Boofo's addslashes() fix and Cloudrunner's table prefix to the code. Upgrade is not mandatory, but recommended to protect against users with a ' or a " in their name.

[LilPimp]

I dont get tha directions

[rob_daemon]

Originally Posted by LilPimp

I dont get tha directions

What specifically don't you get?

You run the nine queries in phpMyAdmin, go into your Admin CP and save one setting, and then apply the file edit.

[Boofo]

Rob, in your updated instructions, you have it to show the signature and smilies are set to off. You need to switch the numbers (0 and 1) around.

[joeychgo]

Question. I installed the other version of this hack, LAST UPDATED: Tue Apr 13 2004 19:34 PST ........

So I need to do another update now? If so, what are the update instructions?

Looks like a great hack...... Very nice job. I can only hope my fist hack will be this good.

[rob_daemon]

Originally Posted by joeychgo

Question. I installed the other version of this hack, LAST UPDATED: Tue Apr 13 2004 19:34 PST ........


So I need to do another update now? If so, what are the update instructions?

Looks like a great hack...... Very nice job. I can only hope my fist hack will be this good.

For upgrading, find the old version of the hack, by searching for:

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

And then look for the end of it:

		$DB_site->query(
		"INSERT INTO " . TABLE_PREFIX . "pm 
			(
				pmtextid, 
				userid, 
				folderid, 
				messageread
			) 
			VALUES 
			(
				'$pmtextid', 
				'$userid', 
				'0', 
				'0'
			)"
		);
		// ###################################################################

And replace that and everything in-between with the updated code in the file. There are no new queries to run.

Originally Posted by Boofo

Rob, in your updated instructions, you have it to show the signature and smilies are set to off. You need to switch the numbers (0 and 1) around.

And I even double-checked this, too I'll just turn 'em both on.

[Boofo]

I don't think I'd turn sigs on, but it is your hack. Just make the last 0 in that column a 1 and the smilies will work. That's how I have mine and the smilies show and the sig does not.

[Kwak]

What are queries and how do you run them?