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
  #222  
Old 09-25-2004, 04:51 PM
tbroush tbroush is offline
 
Join Date: Aug 2003
Posts: 39
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Awesome hack and very easy to install.

Carlos
Reply With Quote
  #223  
Old 10-03-2004, 12:00 AM
joergh's Avatar
joergh joergh is offline
 
Join Date: Oct 2001
Posts: 37
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Very nice hack :nervous: :ninja:

joergh
Reply With Quote
  #224  
Old 10-14-2004, 05:18 AM
mtha's Avatar
mtha mtha is offline
 
Join Date: Jul 2002
Location: US
Posts: 775
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by msimplay
what about turning it on and off ?
Seem like the function wasnt implemented, so I gave it a shot.
If you already install the hack, do the followings

run this querry to add another option (turn on/off) to your "vB Registration Options

Code:
INSERT INTO `setting` (`varname`, `grouptitle`, `value`, `defaultvalue`, `optioncode`, `displayorder`, `advanced`, `volatile`) VALUES ('regpmactive', 'register', '1', '1', '', 139, 0, 0);
INSERT INTO phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALUES (NULL, '0', 'setting_regpmactive_title', 'Send default PM to new users?', '5000');
INSERT INTO phrase (phraseid, languageid, varname, `text`, phrasetypeid) VALUES (NULL, '0',  'setting_regpmactive_desc', '', '5000');
In registration.php

Look for

Code:
	   $pmoptions['regpmtext'] = $vboptions['regpmtext'];
add above:

Code:
 		$pmoptions['regpmactive'] = $vboptions['regpmactive'];
Look for:

Code:
		// Send the new owner a PM
		$DB_site->query(
Add above:

Code:
if ($pmoptions['regpmactive']) {

LOOK FOR

Code:
		// ###################################################################
		// # END WELCOME PM HACK
		// ###################################################################
ADD ABOVE:

Code:
}
Reply With Quote
  #225  
Old 10-14-2004, 10:02 AM
taffy056 taffy056 is offline
 
Join Date: Sep 2004
Location: In a house in Wales ;)
Posts: 254
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi,

I would like to add this on, but I am having a problem with phpMyAdmin, the problem is I have no real idea how to work it, can someone tell me in English how to to do these queries etc for this hack, I simply have no idea.

Thanks

taffy
Reply With Quote
  #226  
Old 10-14-2004, 01:41 PM
rob_daemon's Avatar
rob_daemon rob_daemon is offline
 
Join Date: Sep 2003
Posts: 197
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The easiest way to run queries is through the Admin CP. You can find the documentation about it here
Reply With Quote
  #227  
Old 10-14-2004, 04:17 PM
zendiver zendiver is offline
 
Join Date: Sep 2004
Location: Houston, TX
Posts: 118
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

One small thing to add for the more inexperienced members trying to install this hack. If you are following the updated version of the hack "Weclome PM Hack [Oct 14 2004]" and you open up phpMyAdmin to run the queries and you get the following error:
PHP Code:
Error

SQL
-query :  

INSERT INTO `setting` ( `varname` , `grouptitle` , `value` , `defaultvalue` , `optioncode` , `displayorder` , `advanced` , `volatile` ) 
VALUES (

'regpmactive''register''1''1'''13900


MySQL said


Table 'database_name.setting' doesn't exist 
it is because you have a prefix on your tables in your database.

To fix this problem, go back into the instructions and everwhere it says:
INSERT INTO `setting`
and
INSERT INTO phrase

make sure you add the prefix for your tables:

Example: My tables have vb3_ as the prefix so I added it to look like the following:
INSERT INTO `vb3_setting`
and
INSERT INTO vb3_phrase


Hope this helps
-Robert
Reply With Quote
  #228  
Old 10-14-2004, 05:51 PM
mtha's Avatar
mtha mtha is offline
 
Join Date: Jul 2002
Location: US
Posts: 775
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by zendiver
One small thing to add for the more inexperienced members trying to install this hack. If you are following the updated version of the hack "Weclome PM Hack [Oct 14 2004]" and you open up phpMyAdmin to run the queries and you get the following error:
PHP Code:
Error
 
 SQL
-query :  
 
 
INSERT INTO `setting` ( `varname` , `grouptitle` , `value` , `defaultvalue` , `optioncode` , `displayorder` , `advanced` , `volatile` ) 
 
VALUES (
 
 
'regpmactive''register''1''1'''13900
 

 
 
MySQL said
 
 
 
Table 'database_name.setting' doesn't exist 
it is because you have a prefix on your tables in your database.

To fix this problem, go back into the instructions and everwhere it says:
INSERT INTO `setting`
and
INSERT INTO phrase

make sure you add the prefix for your tables:

Example: My tables have vb3_ as the prefix so I added it to look like the following:
INSERT INTO `vb3_setting`
and
INSERT INTO vb3_phrase


Hope this helps
-Robert
yeah, I just copy the original one over.

anyway, there's a fun way to do this:turn on debug mod, and add directly from ACP/vB Options but ... you have to know what you are doing, or you will distroy your board.
Reply With Quote
  #229  
Old 10-17-2004, 07:18 AM
ManagerJosh's Avatar
ManagerJosh ManagerJosh is offline
 
Join Date: Feb 2002
Posts: 348
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by shadesvn
Just like KW802 said above ... and I got no problems 222 .. thanks for your confirmation mate .. !

Actually, don't change the original queries, MJosh .. you can change the PM's content in ACP later.
Shades, if you read the SQL error in more detail, the error was about the hacking being unable to support apostrophes within the usernames, causing the insert in the PM text to break down.

Yes I know i can edit it manually, however it is just frustrating sometimes and well, annoying.
Reply With Quote
  #230  
Old 10-19-2004, 12:23 AM
alwafi's Avatar
alwafi alwafi is offline
 
Join Date: May 2003
Location: Saudia Arabia
Posts: 24
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

nice thanks
Reply With Quote
  #231  
Old 10-21-2004, 01:33 PM
FleaBag's Avatar
FleaBag FleaBag is offline
 
Join Date: Dec 2001
Posts: 1,674
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I finally got around to installing this - used to use it on vB2. Thanks a lot.
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 01:45 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.09785 seconds
  • Memory Usage 2,339KB
  • 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
  • (9)bbcode_code
  • (3)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