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
  #62  
Old 04-02-2004, 09:55 PM
blubber12 blubber12 is offline
 
Join Date: Nov 2003
Posts: 78
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well i've done everything over..as you recommended to nemesis, and still have the same problems, also running gold and clean reg.php
Reply With Quote
  #63  
Old 04-02-2004, 10:06 PM
rob_daemon's Avatar
rob_daemon rob_daemon is offline
 
Join Date: Sep 2003
Posts: 197
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm running it on Gold (I wrote it on my test board which is running Gold).

I'm not sure why those settings won't show up in the Admin CP... can you run this query in the Admin CP and tell me what you see as the results?

Code:
SELECT * FROM setting WHERE varname LIKE 'regpm%';
Reply With Quote
  #64  
Old 04-03-2004, 04:19 AM
nemesis01's Avatar
nemesis01 nemesis01 is offline
 
Join Date: Dec 2001
Posts: 62
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

regpmfrom register 1 1 140 0 0
regpmtext register Hi $username and welcome to $bbtitle! We appreciate you taking the time to register on our site and we hope you enjoy your stay. If you have any questions, you can ask an administrator for assistance. We hope to see you around. Sincerely, The $bbtitle staff 0 textarea 150 0 1
regpmtitle register Welcome to $bbtitle! 0 160 0 0

After running the above query.....
Reply With Quote
  #65  
Old 04-03-2004, 07:02 AM
rob_daemon's Avatar
rob_daemon rob_daemon is offline
 
Join Date: Sep 2003
Posts: 197
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hmm... how very odd... that should mean that the settings come up in the Admin CP... are you sure that you don't have the settings at the bottom of the User Registration Options page in the vB Options part of the Admin CP?

Even if the phrases didn't work out, you should at least have blank options at the bottom of that page.
Reply With Quote
  #66  
Old 04-03-2004, 07:24 AM
nemesis01's Avatar
nemesis01 nemesis01 is offline
 
Join Date: Dec 2001
Posts: 62
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm quite sure yes, covered all the bases, cleared temp inet files, cookies, heck I even tried using a different browser but they are simply not there.
Reply With Quote
  #67  
Old 04-03-2004, 11:11 AM
Cloudrunner's Avatar
Cloudrunner Cloudrunner is offline
 
Join Date: May 2003
Location: Butte, MT
Posts: 635
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Just a quick note...

For those of you who are using a table prefix for your VB installation, you'll need to adjust the code provided for your register.php.

instead of:
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 user WHERE userid=$pmoptions[regpmfrom]");
		
		// Send the new owner a PM
		$DB_site->query(
			"INSERT INTO pmtext
			(
				fromuserid,
				fromusername,
				title,
				message,
				touserarray,
				iconid,
				dateline,
				showsignature,
				allowsmilie
			)
			VALUES
			(
				$get_pm_from[userid],
				'$get_pm_from[username]',
				'$pmoptions[regpmtitle]',
				'" . addslashes($pmoptions['regpmtext']) . "',
				'" . serialize(array($userid => $username)) . "',
				0,
				" . TIMENOW . ",
				0,
				0
			)"
		);
		
		$pmtextid = $DB_site->insert_id();
		
		$DB_site->query("UPDATE user SET pmtotal=pmtotal+1, pmunread=pmunread+1, pmpopup=2 WHERE userid=$userid");
		$DB_site->query(
		"INSERT INTO pm 
			(
				pmtextid, 
				userid, 
				folderid, 
				messageread
			) 
			VALUES 
			(
				'$pmtextid', 
				'$userid', 
				'0', 
				'0'
			)"
		);
		// ###################################################################
use this:
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],
				'$get_pm_from[username]',
				'$pmoptions[regpmtitle]',
				'" . addslashes($pmoptions['regpmtext']) . "',
				'" . serialize(array($userid => $username)) . "',
				0,
				" . TIMENOW . ",
				0,
				0
			)"
		);
		
		$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
		// ###################################################################
Other than that, Great hack!

[high]* Cloudrunner clicks install
[/high]

Thank you!

)O( Cloudrunner )O(
Reply With Quote
  #68  
Old 04-03-2004, 01:05 PM
poetic poetic is offline
 
Join Date: Apr 2003
Posts: 125
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I too have had problems that nemesis has. He's explained them exactly as I've recieved them.
Reply With Quote
  #69  
Old 04-03-2004, 04:14 PM
rob_daemon's Avatar
rob_daemon rob_daemon is offline
 
Join Date: Sep 2003
Posts: 197
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Unfortunately I can't recreate these problems... I've tried doing various things to try and break it but I just can't do it... if they're there in the database they should be showing up in the Admin CP.

Try going to this link for me: yourdomain.com/admincp/options.php?do=editsetting&varname=regpmfrom

That should edit one of the settings.... if it exists, it will be there.
Reply With Quote
  #70  
Old 04-03-2004, 10:40 PM
nemesis01's Avatar
nemesis01 nemesis01 is offline
 
Join Date: Dec 2001
Posts: 62
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by rob_daemon
Unfortunately I can't recreate these problems... I've tried doing various things to try and break it but I just can't do it... if they're there in the database they should be showing up in the Admin CP.

Try going to this link for me: yourdomain.com/admincp/options.php?do=editsetting&varname=regpmfrom

That should edit one of the settings.... if it exists, it will be there.
Did that, the result was interesting.
Reply With Quote
  #71  
Old 04-03-2004, 11:49 PM
rob_daemon's Avatar
rob_daemon rob_daemon is offline
 
Join Date: Sep 2003
Posts: 197
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

There's your problem... they're stuck in the Version Info and Other Untouchables (for a reason which I can not comprehend).

Pull down the "Setting Group" option and put it in User Registration Options.

Try doing the same for:
yourdomain.com/admincp/options.php?do=editsetting&varname=regpmtext
yourdomain.com/admincp/options.php?do=editsetting&varname=regpmtitle
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 12:52 AM.


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.04906 seconds
  • Memory Usage 2,320KB
  • 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
  • (5)bbcode_code
  • (1)bbcode_php
  • (1)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
  • (1)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