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.

[lanc3lot]

Thanks Rob, going to uninstall and install now...

[Onkel_Tom]

Just updated to the newest version on 3 Boards and still work fine
thanks Rob

[lanc3lot]

Yep it is working....thanks a lot rob

[Wilt]

Originally Posted by rob_daemon

Did you upgrade? What version of the hack are you using?

Doesn't matter, it appears there was an extra } in register.php what didn't throw up an error.

[Challenge]

Can you remove your signature from the message?

[rob_daemon]

Originally Posted by Challenge

Can you remove your signature from the message?

Yes. Open register.php and find:

PHP Code:

        // Send the new owner a PM
        $DB_site->query(
            "INSERT INTO " . TABLE_PREFIX . "pmtext
            (
                fromuserid,
                fromusername,
                title,
                message,
                touserarray,
                iconid,
                dateline,
                showsignature,
                allowsmilie
            )
            VALUES
            (
                $get_pm_from[userid],
                '" . addslashes($get_pm_from['username']) . "',
                '" . addslashes($pmoptions['regpmtitle']) . "',
                '" . addslashes($pmoptions['regpmtext']) . "',
                '" . addslashes(serialize(array($userid => $username))) . "',
                0,
                " . TIMENOW . ",
                1,
                1
            )"
        ); 


Replace with:

PHP Code:

        // Send the new owner a PM
        $DB_site->query(
            "INSERT INTO " . TABLE_PREFIX . "pmtext
            (
                fromuserid,
                fromusername,
                title,
                message,
                touserarray,
                iconid,
                dateline,
                showsignature,
                allowsmilie
            )
            VALUES
            (
                $get_pm_from[userid],
                '" . addslashes($get_pm_from['username']) . "',
                '" . addslashes($pmoptions['regpmtitle']) . "',
                '" . addslashes($pmoptions['regpmtext']) . "',
                '" . addslashes(serialize(array($userid => $username))) . "',
                0,
                " . TIMENOW . ",
                0,
                1
            )"
        ); 


[Challenge]

Thanks a lot :squareeyed:
Smarties

[pingme]

Does it work with VB 3.0.6 ? I would love ti install if it works w/o issues

[rob_daemon]

It works on 3.0.x without any issues .

[OrangeFlea]

Question:

I'm somewhat unfamiliar with installing hacks/mods that involve inputing queries. The instructions you've provided have me at a loss, because I don't know if I'm supposed to collectively paste all those words into the query dialogue box or enter them in individually. Basically -- and I've consulted with the vBulletin manual -- I don't know how to enter queries. It's a dilemma that I've been ignoring 'till I saw this hack, which would help any board tremendously.

Can you or anyone help?