Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.0 > vBulletin 3.0 Full Releases
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
New User Welcome PM [v2] Details »»
New User Welcome PM [v2]
Version: 2.1.0, by rob_daemon rob_daemon is offline
Developer Last Online: Sep 2019 Show Printable Version Email this Page

Version: 3.0.0 Rating:
Released: 03-31-2004 Last Update: 12-05-2004 Installs: 200
DB Changes
 
No support by the author.

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):

Code:
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:

Code:
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.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #182  
Old 06-30-2004, 05:59 AM
rob_daemon's Avatar
rob_daemon rob_daemon is offline
 
Join Date: Sep 2003
Posts: 197
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hmm... I'm not sure why that would be happening. I'll see if I can recreate this tomorrow and if I am able to, I'll see if I can't come up with a fix.
Reply With Quote
  #183  
Old 06-30-2004, 08:24 AM
SnowBot's Avatar
SnowBot SnowBot is offline
 
Join Date: Jul 2003
Location: Manchester UK
Posts: 631
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Cool that will be great Thanks for the fast responce
Reply With Quote
  #184  
Old 07-05-2004, 05:56 AM
Osterling Osterling is offline
 
Join Date: Jan 2004
Posts: 381
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

the attachement seems to be messed up.. can some one send me the instructions?
Reply With Quote
  #185  
Old 07-06-2004, 09:11 PM
Onkel_Tom's Avatar
Onkel_Tom Onkel_Tom is offline
 
Join Date: Mar 2002
Location: Stuttgart- Germany
Posts: 208
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Small update to find the correct place to put the code in register.php for vB3.0.2 or 3.0.3:

find:
PHP Code:
$username $_POST['username'];
            
$email $_POST['email'];
            eval(
fetch_email_phrases('newuser'0));

            
$newemails explode(' '$vboptions['newuseremail']);
            foreach (
$newemails AS $toemail)
            {
                if (
trim($toemail))
                {
                    
vbmail($toemail$subject$message);
                }
            }
        } 
after add:
PHP Code:
// ##############################################################################################

        // ###################################################################
        // # WELCOME PM HACK BY rob_daemon
        // ###################################################################
        
        
$username $_POST['username'];
        
        
// Process each one of the replacement vars
        
$vars = array(
            
'$bbtitle' => $vboptions['bbtitle'], 
            
'$username' => $username
            
'$email' => $email
            
'$userid' => $userid
        
);
        
        
$pmoptions['regpmtext'] = $vboptions['regpmtext'];
        
$pmoptions['regpmtitle'] = $vboptions['regpmtitle'];
        
$pmoptions['regpmfrom'] = $vboptions['regpmfrom'];
        
        
// Now that we have the options, we need to process eaach of the 
        // vars we can use
        
foreach($vars AS $_key => $_value)
        {
            
$pmoptions['regpmtext'] = str_replace($_key$_value$pmoptions['regpmtext']);
            
$pmoptions['regpmtitle'] = str_replace($_key$_value$pmoptions['regpmtitle']);
        }

        
$get_pm_from $DB_site->query_first("SELECT username,userid FROM " TABLE_PREFIX "user WHERE userid=$pmoptions[regpmfrom]");
        
        
// 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
            )"
        
);
        
        
$pmtextid $DB_site->insert_id();
        
        
$DB_site->query("UPDATE " TABLE_PREFIX "user SET pmtotal=pmtotal+1, pmunread=pmunread+1, pmpopup=2 WHERE userid=$userid");
        
$DB_site->query(
        
"INSERT INTO " TABLE_PREFIX "pm 
            (
                pmtextid, 
                userid, 
                folderid, 
                messageread
            ) 
            VALUES 
            (
                '
$pmtextid', 
                '
$userid', 
                '0', 
                '0'
            )"
        
);
        
// ###################################################################
        // # END WELCOME PM HACK
        // ###################################################################
// ############################################################################################## 
@ rob_daemon
Please update the installation instruction
Reply With Quote
  #186  
Old 07-07-2004, 12:03 AM
Kwak Kwak is offline
 
Join Date: Sep 2003
Posts: 154
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

[QUOTE=Onkel_Tom]Small update to find the correct place to put the code in register.php for vB3.0.2 or 3.0.3:

find:
PHP Code:
$username $_POST['username'];
            
$email $_POST['email'];
            eval(
fetch_email_phrases('newuser'0));

            
$newemails explode(' '$vboptions['newuseremail']);
            foreach (
$newemails AS $toemail)
            {
                if (
trim($toemail))
                {
                    
vbmail($toemail$subject$message);
                }
            }
        } 


On the register.php file for 3.0.3, I can't find $username = $_POST['username'];

This is the part I think you are talking about:
Code:
$email = $_POST['email'];
			eval(fetch_email_phrases('newuser', 0));

			$newemails = explode(' ', $vboptions['newuseremail']);
			foreach ($newemails AS $toemail)
			{
				if (trim($toemail))
				{
					vbmail($toemail, $subject, $message);
				}
			}
		}

On top of that code is:
Code:
		if ($vboptions['newuseremail'] != '')
		{
			if ($havefields)
			{
				 $DB_site->data_seek(0, $profilefields);
				 while ($profilefield = $DB_site->fetch_array($profilefields))
				 {
					$varname = "field$profilefield[profilefieldid]";
					$cfield = $$varname;
					$customfields .= "$profilefield[title] : $cfield\n";
				 }
			}

Any idea?
Reply With Quote
  #187  
Old 07-07-2004, 12:55 AM
Onkel_Tom's Avatar
Onkel_Tom Onkel_Tom is offline
 
Join Date: Mar 2002
Location: Stuttgart- Germany
Posts: 208
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

In the original file register.php it's line 743 with
$username = $_POST['username'];
Reply With Quote
  #188  
Old 07-08-2004, 06:30 PM
rob_daemon's Avatar
rob_daemon rob_daemon is offline
 
Join Date: Sep 2003
Posts: 197
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by exasko
the attachement seems to be messed up.. can some one send me the instructions?
What are you using to view the file? See here.

The file has been updated with the new instructions.
Reply With Quote
  #189  
Old 07-08-2004, 07:40 PM
Kwak Kwak is offline
 
Join Date: Sep 2003
Posts: 154
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Code:
Error

SQL-query : 

INSERT INTO `setting` ( `varname` , `grouptitle` , `value` , `defaultvalue` , `optioncode` , `displayorder` , `advanced` , `volatile` )
VALUES (
'regpmfrom', 'register', '1', '1', '', 140, 0, 0
)

MySQL said:
#1062 - Duplicate entry 'regpmfrom' for key 1

[Documentation] ? [Back]
Getting that error message when I query the provided codes on phpmyadmin.
vB 3.0.3.
Reply With Quote
  #190  
Old 07-08-2004, 10:02 PM
rob_daemon's Avatar
rob_daemon rob_daemon is offline
 
Join Date: Sep 2003
Posts: 197
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You don't need to redo the queries if you have already installed the mod.

Quote:
Originally Posted by Upgrade Instructions in the First Post
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.
Reply With Quote
  #191  
Old 07-08-2004, 10:07 PM
Onkel_Tom's Avatar
Onkel_Tom Onkel_Tom is offline
 
Join Date: Mar 2002
Location: Stuttgart- Germany
Posts: 208
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by iKwak
Code:
Error

SQL-query : 

INSERT INTO `setting` ( `varname` , `grouptitle` , `value` , `defaultvalue` , `optioncode` , `displayorder` , `advanced` , `volatile` )
VALUES (
'regpmfrom', 'register', '1', '1', '', 140, 0, 0
)

MySQL said:
#1062 - Duplicate entry 'regpmfrom' for key 1

[Documentation] ? [Back]
Getting that error message when I query the provided codes on phpmyadmin.
vB 3.0.3.
that means that you have already the needed setting for regpmfrom in your database !
You can't add a setting twice with the same name.
If you have installed the hack before all is fine and you can proceed with the other instructions. If not you have to check which hack also uses a varname called regpmfrom in the settings table.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 03:16 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04733 seconds
  • Memory Usage 2,371KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (6)bbcode_code
  • (4)bbcode_php
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete