########################################################################################## 


## MOD Title: Send PM On User Registration 


## MOD Author: AbelaJohnB < abela@phpbb.com > (John B. Abela) http://www.JohnAbela.Com/ 


## MOD Author, Secondary: typicalgeek  < me@typicalgeek.com > (N/A)  http://www.typicalgeek.com 


## MOD Author, Secondary: netclectic < adrian@netclectic.com > (Adrian *beep*) http://www.netclectic.com 


## MOD Description: This MOD will send a PM to all new users when they register. 


## MOD Version: 1.0.2 


## 


## Installation Level: Easy 


## Installation Time: ~3 Minutes 


## Files To Edit: includes/usercp_register.php, language/lang_english/lang_main.php 


## Included Files: n/a 


########################################################################################## 


## For Security Purposes, Please Check: http://www.phpbb.com/mods/downloads/ for the 


## latest version of this MOD. Downloading this MOD from other sites could cause malicious code 


## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered 


## in our MOD-Database, located at: http://www.phpbb.com/mods/downloads/ 


########################################################################################## 


##Author Notes: 


## 


##  Copyright  © John B. Abela. 2002 - http://www.JohnAbela.Com/ 


## 


## ** No Placement Of This MOD At Sites Other Than www.phpBB.Com Or www.JohnAbela.Com Without My Permission. 


## 


## If you download this MOD from anywhere other than my own site or phpBB, please do not 


## use it. I do not allow this MOD (or any of mine) to be posted at non-official phpBB Sites, 


## and as such I will not be able to keep this MOD up-to-date at any of these non-official sites 


## which do not respect my request to not place it within their site. If you do find it at a site 


## other than phpBB.com please let me know!  <abela@phpbb.com> 


## 


## If you are an owner of a non-official site and would like to place it within your site, please 


## email me for permission, so I can keep track of who has it and where it's at, to help keep 


## keep your site up-to-date with this MOD. 


## 


## For anybody that likes this MOD, you can always say 'thanks' by signing my guestbook at 


## my web site!   http://www.JohnAbela.Com/  :) 


## 


## This MOD does not take into consideration any user registration methods. 


##  ie: confirm via email, auto register, etc) Any new person that registers will get a PM, 


##  even if they have not confirmed their account. I do not plan on changing this, as I do 


## not really see the point in doing such. 


## 


########################################################################################## 


## History: 


## 


## 1.0.2 - 1/10/2003 - Updated To Work With phpBB2.0.4. Included fix by 'netclectic' to account for instant pop-up of new message. (thanks!) 


## 1.0.1 - 9/19/2002 - Updated Language Section To Include 'typicalgeek's method of site name. 


## 


########################################################################################## 


## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 


########################################################################################## 





# 


#-----[ OPEN ]------------------------------------------ 


# 


includes/usercp_register.php 





# 


#-----[ FIND ]------------------------------------------ 


# 





$sql = "INSERT INTO " . GROUPS_TABLE . " (group_name, group_description, group_single_user, group_moderator) 





# 


#-----[ BEFORE, ADD ]------------------------------------------ 


# 





        // START - SEND PM ON REGISTER MOD - AbelaJohnB 


   // 


   // According to 'netclectic' we need to set the datastamp to '9999999999' in order to 


   // insure the pop-up notification about a new message existing. I concur with 'netclectic' 


   // and have thus made the change to his suggestion. Thanks netclectic! 


        // 


   $sql = "UPDATE " . USERS_TABLE . " 


      SET user_new_privmsg = '1', user_last_privmsg = '9999999999' 


            WHERE user_id = $user_id"; 


      if ( !($result = $db->sql_query($sql)) ) 


        { 


          message_die(GENERAL_ERROR, 'Could not update users table', '', __LINE__, __FILE__, $sql); 


        } 





        $register_pm_subject = $lang['register_pm_subject']; 


        $register_pm = $lang['register_pm']; 


        $privmsgs_date = date("U"); 


        $sql = "INSERT INTO " . PRIVMSGS_TABLE . " (privmsgs_type, privmsgs_subject, privmsgs_from_userid, privmsgs_to_userid, privmsgs_date, privmsgs_enable_html, privmsgs_enable_bbcode, privmsgs_enable_smilies, privmsgs_attach_sig) VALUES ('0', '" . str_replace("\'", "''", addslashes(sprintf($register_pm_subject,$board_config['sitename']))) . "', '2', " . $user_id . ", " . $privmsgs_date . ", '0', '1', '1', '0')"; 


        if ( !$db->sql_query($sql) ) 


      { 


         message_die(GENERAL_ERROR, 'Could not insert private message sent info', '', __LINE__, __FILE__, $sql); 


      } 





      $privmsg_sent_id = $db->sql_nextid(); 


      $privmsgs_text = $lang['register_pm_subject']; 


        // 


        $sql = "INSERT INTO " . PRIVMSGS_TEXT_TABLE . " (privmsgs_text_id, privmsgs_text) VALUES ($privmsg_sent_id, '" . str_replace("\'", "''", addslashes(sprintf($register_pm,$board_config['sitename'],$board_config['sitename']))) . "')"; 


        if ( !$db->sql_query($sql) ) 


      { 


         message_die(GENERAL_ERROR, 'Could not insert private message sent text', '', __LINE__, __FILE__, $sql); 


      } 


        // END - SEND PM ON REGISTER MOD - AbelaJohnB 





# 


#-----[ OPEN ]------------------------------------------ 


# 


language/lang_english/lang_main.php 





# 


#-----[ FIND ]------------------------------------------ 


# 





$lang['Click_view_privmsg'] = 'Click %sHere%s to visit your Inbox'; 





# 


#-----[ AFTER, ADD ]------------------------------------------ 


# 





// START - SEND PM ON REGISTER MOD - AbelaJohnB 


$lang['register_pm_subject'] = 'Welcome to %s'; 


$lang['register_pm'] = 'Hello!<br /><br />Welcome to %s. <br /><br />We hope you enjoy your time at this site! <br /><br />Feel free to join in and share with others or start your own discussion! <br /><br />~Enjoy!<br />%s Staff '; 


// END - SEND PM ON REGISTER MOD - AbelaJohnB 





# 


#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ 


# 


# EoM