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]

Originally Posted by fiber1

Rob,

The text file you have is stretches horizontal in a few lines and very hard to follow.
Would it be to much to ask to align it left with the proper page breaks so it is easier to folllow?

Fiber

Take a look at this post and see if it helps.

[fiber1]

Thanks, that issue happens from time to time.

Fiber

[fiber1]

Very nice hack!

Thank you,

Fiber

[nelto]

Hi
Great hack you have seted up here.
But Im having a little prb.
I installed it, everythitng was smoth as silk but.....
I tested it by registering myself with a different username, and I didnt got any pm on my pm box.
Any ideas?

[rob_daemon]

Hmm... have you double checked that you specified all of the right variables in the Admin CP? After you check to make sure they're there, hit the save button, just to make sure the cache is rebuilt.

[KW802]

[high]* KW802 clicks "install" so he remembers to install this over the weekend. [/high]

[shadesvn]

I'm so tired to read all of your msgs for every cases ... could you guys please give a fresh instruction for VB 3.03 .. !

Thanks so much !

[KW802]

Originally Posted by shadesvn

I'm so tired to read all of your msgs for every cases ... could you guys please give a fresh instruction for VB 3.03 .. !

Thanks so much !

I'm running 3.0.3 and used the instructions in the first post; took about 5 minutes.

[ManagerJosh]

Originally Posted by KW802

I'm running 3.0.3 and used the instructions in the first post; took about 5 minutes.

Rob, you might need to revise the hack a bit:

Invalid SQL: INSERT INTO pmtext
(
fromuserid,
fromusername,
title,
message,
touserarray,
iconid,
dateline,
showsignature,
allowsmilie
)
VALUES
(
1,
'ManagerJosh',
'Welcome to WorldSims Forums!',
'',
'a:1:{i:8387;s:13:"Sims2Kid'sMom";}',
0,
1095699710,
0,
0
)
mysql error: You have an error in your SQL syntax near 'sMom";}',
0,
1095699710,
0,
0
)' at line 19

mysql error number: 1064

[shadesvn]

Originally Posted by ManagerJosh

Rob, you might need to revise the hack a bit:

Just like KW802 said above ... and I got no problems 222 .. thanks for your confirmation mate .. !

Actually, don't change the original queries, MJosh .. you can change the PM's content in ACP later.