View Single Post
  #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
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01045 seconds
  • Memory Usage 1,795KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete