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
  #142  
Old 05-21-2004, 12:29 AM
Rick Sample Rick Sample is offline
 
Join Date: Apr 2004
Location: Ohio
Posts: 407
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

quick question,
1. lets say after I open admin cp and run each query individually, how can I test to see if it worked? I mean will I see side effects if it doesn't?

2. I forget should I run it manually or automatic in the admin cp

3. I created the board, but it says I don't have permissions to exicute an SQL query. I know when I transfered my PHP board, it transfered my admin account, then created another admin account. I deleted that without thinking. So how do I make myself a super admin again???


Thanks for all of your help
Reply With Quote
  #143  
Old 05-21-2004, 12:59 AM
rob_daemon's Avatar
rob_daemon rob_daemon is offline
 
Join Date: Sep 2003
Posts: 197
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
To test it to make sure users can still register, should I try to register after I do this hack, just to see if its all working?
Yup... and then delete the user in the Admin CP when you are done.

Quote:
lets say after I open admin cp and run each query individually, how can I test to see if it worked? I mean will I see side effects if it doesn't?
To see if it worked, go into the Admin CP --> vBulletion Options --> User Registration Options

And there should be three new options: Registration PM From, Text, and Title.

Quote:
I forget should I run it manually or automatic in the admin cp
You do them manually by pasting them into the query box.

Quote:
I created the board, but it says I don't have permissions to exicute an SQL query. I know when I transfered my PHP board, it transfered my admin account, then created another admin account. I deleted that without thinking. So how do I make myself a super admin again???
http://www.vbulletin.com/docs/html/m...ntenance_query
Reply With Quote
  #144  
Old 05-21-2004, 07:03 AM
josh929's Avatar
josh929 josh929 is offline
 
Join Date: Mar 2002
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i would like to install this hack. however, i know absolutely NOTHING about mysql.

i would be able to run the queries just fine, but i need to know now to uninstall the hack for future upgrades and whatnot. if anyone could provide an exact undo of every change to the database (putting it back just like it was before the hack was installed), that would be fantabulous. i could then install the hack without worrying about foreign things in my vbulletin database that i have no idea how to get rid of.

if this is alot of work, then nevermind.
Reply With Quote
  #145  
Old 05-22-2004, 02:04 AM
rob_daemon's Avatar
rob_daemon rob_daemon is offline
 
Join Date: Sep 2003
Posts: 197
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The following two queries will undo any database changes:

Code:
DELETE FROM `setting` WHERE `varname` IN ('regpmfrom', 'regpmtext',  'regpmtitle');

DELETE FROM `phrase` WHERE `varname` IN ('setting_regpmfrom_title', 'setting_regpmfrom_desc', 'setting_regpmtext_title', 'setting_regpmtext_desc', 'setting_regpmtitle_title', 'setting_regpmtitle_desc');
Reply With Quote
  #146  
Old 05-22-2004, 11:28 PM
josh929's Avatar
josh929 josh929 is offline
 
Join Date: Mar 2002
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

thanks
Reply With Quote
  #147  
Old 06-03-2004, 07:14 AM
MediaHound MediaHound is offline
 
Join Date: May 2004
Location: Florida
Posts: 165
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks a lot for this hack!
Reply With Quote
  #148  
Old 06-03-2004, 09:30 AM
Onkel_Tom's Avatar
Onkel_Tom Onkel_Tom is offline
 
Join Date: Mar 2002
Location: Stuttgart- Germany
Posts: 208
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks for this hack !
click install
Reply With Quote
  #149  
Old 06-03-2004, 01:24 PM
contramontanum contramontanum is offline
 
Join Date: Feb 2004
Posts: 28
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ran all queries, clicked "save" in ACP User registration options and did the file edit. When I registered a test user I got an error message that there was a problem with the database. This is the error msg that was emailed to me.
Quote:
Database error in vBulletin 3.0.0:

Invalid SQL: INSERT INTO pmtext
(
fromuserid,
fromusername,
title,
message,
touserarray,
iconid,
dateline,
showsignature,
allowsmilie
)
VALUES
(
,
'',
'Welcome to Loudmouth Discussion Forums!',
'Hi testuser and welcome to Loudmouth Discussion Forums!

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 Loudmouth Discussion Forums staff',
'a:1:{i:89;s:8:\"testuser\";}',
0,
1086272221,
1,
1
)
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '
'',
'Welcome to Loudmouth Disc

mysql error number: 1064
Reply With Quote
  #150  
Old 06-03-2004, 03:26 PM
Bryan Ex's Avatar
Bryan Ex Bryan Ex is offline
 
Join Date: Feb 2004
Location: Canada
Posts: 233
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Looks like exactly what I was after. Just so I'm clear on this... do PM's need to be enabled for users awaiting email confirmation or will the welcome PM just wait until the account is activated?
Reply With Quote
  #151  
Old 06-03-2004, 05:08 PM
rob_daemon's Avatar
rob_daemon rob_daemon is offline
 
Join Date: Sep 2003
Posts: 197
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Ran all queries, clicked "save" in ACP User registration options and did the file edit. When I registered a test user I got an error message that there was a problem with the database. This is the error msg that was emailed to me.
It appears that you don't have a user set for the registration PM to be from. Go into the Admin CP and make sure that 'User Who Sends Automatic PM Upon Registration' has the proper value.

Quote:
Looks like exactly what I was after. Just so I'm clear on this... do PM's need to be enabled for users awaiting email confirmation or will the welcome PM just wait until the account is activated?
The PM will be sent upon the user hitting the final button in the registration system... since there is no "PM Que" in vB, the user will get the welcome PM notice right after they register (even if they haven't activated yet). And the hack simply puts the PM in the user's inbox without any regards for permissions.
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 06:01 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.04866 seconds
  • Memory Usage 2,328KB
  • Queries Executed 27 (?)
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
  • (3)bbcode_code
  • (1)bbcode_php
  • (7)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_postinfo_query
  • fetch_postinfo
  • 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