##########################################################################################
## MOD Title: Send PM On User Registration uninstall 
## MOD Author: Duvelske ( Richard Wagtmans ) http://www.vitrax.opweb.nl
## MOD Version: 1.0.0
## 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:
## This uninstall is only neccesary if you use the send pm on user registration mod by AbelaJohnB
## Otherwise this install neccesary. so if it's not neccesary please close it and forget it :P
##############################################################
#
#-----[ OPEN ]------------------------------------------ 
#
includes/usercp_register.php

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

        // 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

# 
#-----[ REPLACE WITH ]---------------------------------------
# 
// The place of the deleted PM on register mod of AbelaJohnB
#
#-----[ OPEN ]------------------------------------------ 
#
language/lang_english/lang_main.php

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

// 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


#
#-----[ REPLACE WITH ]------------------------------------------ 
#
// The place of the deleted PM on register mod of AbelaJohnB
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ 
#
# EoM