';
		foreach ($database->_log as $k => $sql)
			echo $k + 1, "\n", $sql, '
';
	}

	doGzip();

	die;
}

function integrate_reset_pass($old_username, $username, $password)
{
	global $mosConfig_db, $mosConfig_dbprefix, $db_name;

	$newpass = md5($password);
	mysql_select_db($mosConfig_db);

	$request = mysql_query("
		UPDATE {$mosConfig_dbprefix}users
		SET 
			password = '$newpass',
			username = '$username'
		WHERE username = '" . addslashes($old_username) . "'
		LIMIT 1");
	mysql_select_db($db_name);

	return true;
}

function integrate_change_email($username, $email)
{
	global $mosConfig_db, $mosConfig_dbprefix, $db_name;

	mysql_select_db($mosConfig_db);
	$request = mysql_query("
		UPDATE {$mosConfig_dbprefix}users
		SET emailAddress = '$email'
		WHERE username = '" . addslashes($username) . "'
		LIMIT 1");
	mysql_select_db($db_name);

	return true;
}

function integrate_outgoing_email($subject, &$message, $headers)
{
	global $boardurl, $mosConfig_live_site, $Itemid, $scripturl, $mosConfig_sef;
		
	if (strpos($message, $scripturl) != 0)
	{
		$message = str_replace ($scripturl, '="' . $scripturl, $message);
		$message = un_htmlspecialchars(ob_mambofix($message));
		$message = str_replace ('="', '', $message);
		if ($mosConfig_sef == '1'){		
			$message = str_replace ($mosConfig_live_site . '/index.php', 'index.php', $message);
			preg_match ('~index\.php.+~', $message, $url);
			if (isset($url[0])){
				$new_url = sefReltoAbs($url[0]);
				$new_url = str_replace(';', '/', $new_url);			
				$message = str_replace($url[0], $new_url, $message);
			}
		}
	}
}


function integrate_login($username, $passwd, $cookielength)
{
	global $mosConfig_db, $mosConfig_dbprefix, $user_settings, $db_name;
	global $scripturl, $cb_reg, $mosConfig_absolute_path, $mosConfig_live_site;

	require($mosConfig_absolute_path . '/administrator/components/com_smf_registration/config.smf_registration.php');

	if (!isset($passwd) || $passwd == '' || $passwd == null)
		$passwd = 'migrated';
	
	mysql_select_db($mosConfig_db);

	// Let's see if the user already exists in Mambo
	$mos_sql = "
		SELECT username, block, password 
		FROM {$mosConfig_dbprefix}users 
		WHERE username = '$username';";
	$mos_result = mysql_query($mos_sql);
	$mos_array = mysql_fetch_array($mos_result);
	$mos_user = $mos_array[0];

	//if the user doesn't exist in Mambo, they've already been verified by SMF, so register them into Mambo as well
	if (!isset($mos_user))
	{
		$mos_write = mysql_query("
			INSERT INTO {$mosConfig_dbprefix}users 
				(name,username,email,password,gid) 
			VALUES ('$username', '$username', '$user_settings[emailAddress]', '$passwd', '18')");

		$mos_find_id = mysql_query("
			SELECT id
			FROM {$mosConfig_dbprefix}users
			WHERE name = '$username'
			LIMIT 1");
		$mos_id_array = mysql_fetch_array($mos_find_id);
		$mos_id = $mos_id_array[0];

		$mos_write = mysql_query("
			INSERT INTO {$mosConfig_dbprefix}core_acl_aro 
				(section_value, value, order_value, name, hidden) 
			VALUES ('users', '$mos_id', '0', '$username', '0');");
		
		$mos_map_sql = mysql_query("
			SELECT aro_id
			FROM {$mosConfig_dbprefix}core_acl_aro
			WHERE name = '$username'
			LIMIT 1");
		$mos_map_array = mysql_fetch_array($mos_map_sql);
		$aro_id = $mos_map_array[0];
		$mos_write = mysql_query ("
			INSERT INTO {$mosConfig_dbprefix}core_acl_groups_aro_map 
				(group_id, section_value, aro_id) 
			VALUES ('18', '', '$aro_id');");

		//Do you have Community Builder?  Might has well get them in there too...
		if ($cb_reg=="on")
			$sql = mysql_query("
				INSERT INTO {$mosConfig_dbprefix}comprofiler 
					(id, user_id) 
				VALUES ('$mos_id', '$mos_id')");

		//maybe this user exists, but has not yet activated their account?

	} 
	elseif ($mos_array[1] == 1)
	{
		echo '
			', "\n";
		exit();
	}
		
	$mos_pwd_qry = mysql_query("
		SELECT password 
		FROM {$mosConfig_dbprefix}users
		WHERE username = '$username'
		LIMIT 1");
	list($passwd) = mysql_fetch_row($mos_pwd_qry);
		
	$currentDate = date("Y-m-d\TH:i:s");
	mysql_query("
		UPDATE {$mosConfig_dbprefix}users
		SET lastvisitDate = '$currentDate'
		WHERE username = '$username'");

	// Get rid of the online entry for that old guest....
	
	// Log into Mambo now.....
	$request = mysql_query("
		SELECT id, gid, block, usertype
		FROM {$mosConfig_dbprefix}users
		WHERE username = '$username'
			AND password = '$passwd'");
	$row = mysql_fetch_array($request);
	
	// Fudge the group stuff.
	$session =& $this['_session'];
	$session['guest'] = 0;
	$session['username'] = $username;
	$session['userid'] = intval($row['id']);
	$session['usertype'] = $row['usertype'];
	$session['gid'] = intval($row['gid']);

	$currentDate = date("Y-m-d\TH:i:s");
	mysql_query("
		UPDATE {$mosConfig_dbprefix}users 
		SET lastvisitDate = '$currentDate' 
		WHERE id = '$session[userid]'");

	$lifetime = time() + (60 * $cookielength);
	setcookie('usercookie[username]', $username, $lifetime, '/');
	setcookie('usercookie[password]', $passwd, $lifetime, '/');
	setcookie('sessioncookie', '', -3600, '/');
	
	//Let's make sure this works in both Mambo and Joomla
	$sessionCookieName = md5('site' . $mosConfig_live_site);
	setcookie($sessionCookieName, '', -3600, '/');
	
	//Let's try to minimize the effects of those nasty extra sessions
	$sql = mysql_query("
		DELETE FROM {$mosConfig_dbprefix}session
		WHERE username = '$username'");
		
	//Try to set the redirect by the login module params...

	$sql = mysql_query ("
		SELECT params
		FROM {$mosConfig_dbprefix}modules
		WHERE module='mod_smf_login'");
	$result = mysql_fetch_array($sql);
	$paramlist = $result[0];
	$paramslogin = mosParseParams($paramlist);
	$returncheck = $paramslogin->login;

	// Default, in case we couldn't find anything, or the admin forgot to configure the login module
	// direct to SMF => 1
	// direct to frontpage => 0
	// option 2 cannot be used for default
	if (empty($_SESSION['return']) && ($returncheck == '' || $returncheck == '2'))
		$returncheck = '1';

	//Set the redirection URL
	switch ($returncheck)
	{
		//Redirect to Mambo
		case '0';
		$_SESSION['login_url'] = $GLOBALS['mosConfig_live_site'];
		break;

		//Redirect to SMF
		case '1';
		$_SESSION['login_url'] = $scripturl;
		break;

		//Redirect back to login page
		case '2';
		$_SESSION['login_url'] = sefReltoAbs($_SESSION['return']);
		break;

		//There still might be nothing....
		case '';
		$_SESSION['login_url'] = $GLOBALS['mosConfig_live_site'];
		break;
	}

	mysql_select_db($db_name);
	
	return true;
}

function integrate_redirect (&$setLocation, $refresh)
{
	global $boardurl, $mosConfig_live_site, $mosConfig_sef;

	$myurl = sefReltoAbs(basename($_SERVER['PHP_SELF']) . '?option=com_smf&Itemid=' . $_REQUEST['Itemid'] . '&' );

	if ($setLocation == '')
		$setLocation = $myurl;
		
    // Certain URLs need to be done this way
	if (substr($setLocation, 0, 4) == 'http' && $_REQUEST['action'] != 'logout' && (!isset($_REQUEST['sa']) || $_REQUEST['sa'] != 'check'))
	{
		$setLocation = mambo_smf_url($setLocation);
		$setLocation = un_htmlspecialchars(ob_mambofix($setLocation));
		$setLocation = substr($setLocation, strlen($mosConfig_live_site) + 1, strlen($setLocation) - 1);
		if ($mosConfig_sef == 1){
			$setLocation = sefReltoAbs($setLocation);
		} else {
			$setLocation = $mosConfig_live_site . '/' . $setLocation;
		}
	}
	// and others like this
	else
	{
		if ($mosConfig_sef == 1){
			$setLocation = sefReltoAbs($setLocation);
		} else {
		    if (substr($setLocation, 0, 4) != 'http'){
				$setLocation = $mosConfig_live_site . '/' . $setLocation;
			}
		}
		$setLocation = un_htmlspecialchars(ob_mambofix($setLocation));
	}
	
	if(substr($setLocation, strlen($setLocation) - 1, strlen($setLocation)) == '/')
	{
		$setLocation = substr($setLocation, 0, strlen($setLocation) - 1);
		$setLocation = str_replace(';', '/', $setLocation);
	}
}


function integrate_logout ($username)
{
	global $mosConfig_db, $mosConfig_dbprefix, $db_name, $mosConfig_live_site, $scripturl;

	setcookie('usercookie[username]', $username, time() - 3600, '/');
	setcookie('usercookie[password]', '', time() - 3600, '/');
	setcookie('sessioncookie' , '' , time() - 3600 , '/');

	//Let's make sure this works in both Mambo and Joomla
	$sessionCookieName = md5('site' . $mosConfig_live_site);
	setcookie($sessionCookieName, '', time() - 3600, '/');

	mysql_select_db($mosConfig_db);

	// Let's try to minimize the effects of those nasty extra sessions.
	$sql = mysql_query("
		DELETE FROM {$mosConfig_dbprefix}session
		WHERE username = '$username'");
	
	//Try to set up the logout redirection
	if (!isset($_REQUEST['returnurl']))
	{
		$sql = mysql_query("
			SELECT params 
			FROM {$mosConfig_dbprefix}modules 
			WHERE module='mod_smf_login'");
		$result = mysql_fetch_array($sql);
		$paramlist = $result[0];
		$paramslogin = mosParseParams($paramlist);
		$returncheck = $paramslogin->logout;
	}
	else
		$returncheck = $_REQUEST['returnurl'];
	
	// Default, in case we couldn't find anything, or the admin forgot to configure the login module
	// direct to SMF => 1
	// direct to frontpage => 0
	// option 2 cannot be used for default	
	if (empty($_SESSION['return']) && ($returncheck == '' || $returncheck == '2'))
		$returncheck = "1";

	//Set the redirection URL
	switch ($returncheck)
	{
		//Redirect to Mambo frontpage
		case "0";
		$_SESSION['logout_url'] = $GLOBALS['mosConfig_live_site'];
		break;

		//Redirect to SMF
		case "1";
		$_SESSION['logout_url'] = sefReltoAbs($scripturl);
		break;

		//Redirect back to logout page
		case "2";
		$_SESSION['logout_url'] = sefReltoAbs($_SESSION['return']);
		break;
	}
	
	mysql_select_db($db_name);
}

function integrate_delete_member($user)
{
	global $db_name, $db_prefix, $mosConfig_db, $mosConfig_dbprefix;

	$query = mysql_query ("
		SELECT memberName
		FROM {$db_prefix}members
		WHERE ID_MEMBER = '$user'");
	list($username) = mysql_fetch_row($query);

	mysql_select_db($mosConfig_db);
	$query = mysql_query ("
		DELETE FROM {$mosConfig_dbprefix}users
		WHERE username = '$username'");

	mysql_select_db($db_name);
}

function integrate_validate_login($username, $password, $cookietime)
{
	global $db_name, $db_prefix, $mosConfig_db, $mosConfig_dbprefix;

	// Check if the user already exists in SMF.
	mysql_select_db($db_name);
	$request = mysql_query("
		SELECT ID_MEMBER
		FROM {$db_prefix}members
		WHERE memberName = '$username'");
	if ($request !== false && mysql_num_rows($request) === 1)
	{
		mysql_free_result($request);
		return false;
	}

	//OK, so no user in SMF.  Does this user exist in Mambo?
	else
	{
		mysql_select_db($mosConfig_db);

		//!!! How about sendEmail and activation?
		$request = mysql_query("
			SELECT name, password, email, UNIX_TIMESTAMP(registerDate) AS dateRegistered, activation
			FROM {$mosConfig_dbprefix}users
			WHERE username = '$username'");

		//No user in Mambo, either.  This guy is just guessing....
		if (mysql_num_rows($request) === 0){
			mysql_select_db($db_name);
			return false;
		}

		$mos_user = mysql_fetch_assoc($request);
		mysql_free_result($request);
		
			//If there's no user in SMF, and the Mambo/Joomla user isn't activated, we don't want them logging in
			if ($mos_user['activation']!='')
				fatal_lang_error('still_awaiting_approval');

		mysql_select_db($db_name);

		//There must be a result, so let's write this one into SMF....
		mysql_query("
			INSERT INTO {$db_prefix}members 
				(memberName, realName, passwd, emailAddress, dateRegistered, lngfile, buddy_list, pm_ignore_list, messageLabels, personalText, websiteTitle, websiteUrl, location, ICQ, MSN, signature, avatar, usertitle, memberIP, secretQuestion, additionalGroups)
			VALUES ('$username', '$mos_user[name]', '$mos_user[password]', '$mos_user[email]', $mos_user[dateRegistered], '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '')");
		return 'retry';
	}
}

function integrate_register($regOptions, $theme_vars)
{
	global $db_name, $db_prefix, $mosConfig_db, $mosConfig_dbprefix;
	global $regOptions, $cb_reg;
	
	mysql_select_db($mosConfig_db);

	mysql_query("
		INSERT INTO {$mosConfig_dbprefix}users 
			(name, username, email, password, gid) 
		VALUES ('" . $regOptions['register_vars']['realName'] . "', '" . $regOptions['register_vars']['memberName'] . "', '" . $regOptions['register_vars']['emailAddress'] . "', '" . md5($regOptions['password']) . "', '18')");

	$mos_find_userid = mysql_query("
		SELECT `id`
		FROM {$mosConfig_dbprefix}users
		WHERE username = '".$regOptions['register_vars']['memberName']."'
		LIMIT 1");
	list($mos_id) = mysql_fetch_row($mos_find_userid); 

	mysql_query( "
		INSERT INTO {$mosConfig_dbprefix}core_acl_aro 
			(aro_id, section_value, value, order_value, name, hidden)
		VALUES ('', 'users', '$mos_id', '0', '" . $regOptions['register_vars']['realName'] . "', '0');");

	$mos_map_sql = mysql_query("
		SELECT aro_id
		FROM {$mosConfig_dbprefix}core_acl_aro
		WHERE name = '".$regOptions['register_vars']['realName']."'
		LIMIT 1");
	list($aro_id) = mysql_fetch_row($mos_map_sql);

	mysql_query ("
		INSERT INTO {$mosConfig_dbprefix}core_acl_groups_aro_map 
			(group_id, section_value, aro_id) 
		VALUES ('18', '', '" . $aro_id . "');");

	//Do you have Community Builder?  Might has well get them in there too...
	if ($cb_reg == 'on')
		mysql_query("
			INSERT INTO {$mosConfig_dbprefix}comprofiler
				(id, user_id)
			VALUES ('$mos_id', '$mos_id')");

	mysql_select_db($db_name);
}

?>