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]

Wouldn't mind at all; to that same extent: when I release the automatic installer could I include those updates?

[Boofo]

Originally Posted by rob_daemon

Wouldn't mind at all; to that same extent: when I release the automatic installer could I include those updates?

Rob, you might want to do a TXT file, too, for those of us who like to know what code we're adding and don't like auto-installers.

[AN-net]

um, im getting errors when i register on my site now after a registration is done. it says there seems to be a problem with our database. and the option to edit the setting for new user pm does not show up in my user registration setting page.

[rob_daemon]

Originally Posted by AN-net

um, im getting errors when i register on my site now after a registration is done. it says there seems to be a problem with our database. and the option to edit the setting for new user pm does not show up in my user registration setting page.

Try these instructions: https://vborg.vbsupport.ru/showpost....2&postcount=72

[joeychgo]

Probably a stupid question ---

in the instructions it says to open phpMyAdmin and run queries.....

Is that the same as running queries from EXECUTE SQL QUERY in my admin cp?

[rob_daemon]

Originally Posted by joeychgo

Probably a stupid question ---

in the instructions it says to open phpMyAdmin and run queries.....

Is that the same as running queries from EXECUTE SQL QUERY in my admin cp?

If you want to do the queries via the Admin CP, you need to run them individually as it can't split MySQL queries. And, there is a security limitation in the mysql_query() function that prevents more than one query from being executed at a time.

So, either do each query individually or do them all at once in phpMyAdmin.

[AN-net]

Originally Posted by rob_daemon

Try these instructions: https://vborg.vbsupport.ru/showpost....2&postcount=72

i have alrdy run the queries in the instructs. what should i do then?

[SaN-DeeP]

nice mod.

please update UR INSTRUCTIONS in file.

or someone else DO IT. for THE author.

Instructions in THE file do not WORK on Gold VErsion.
and lead users to SQL ERRORS.

although reading the post no. 72 helped.. and works now after 6 hours
[high]* SaN-DeeP clicks INSTALL. ;0
[/high]

Sandy...

[rob_daemon]

i have alrdy run the queries in the instructs. what should i do then?

If those instructions do not work, then I'm not sure what the cause of them not showing up would be.

Go to here: yourdomain.com/admincp/options.php?do=editsetting&varname=regpmfrom and tell me what you see.

Instructions in THE file do not WORK on Gold VErsion.

Yes, actually they do (but they do not appear to work on all installations)... I'll be updating the file tonight or tomorrow afternoon.

[achtungbaby]

Originally Posted by rob_daemon

If those instructions do not work, then I'm not sure what the cause of them not showing up would be.

Go to here: yourdomain.com/admincp/options.php?do=editsetting&varname=regpmfrom and tell me what you see.



Yes, actually they do (but they do not appear to work on all installations)... I'll be updating the file tonight or tomorrow afternoon.

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