Password and email change in the profile
Open includes/ucp/ucp_profile.php
Search for this part:
if (sizeof($sql_ary))
{
$sql = 'UPDATE ' . USERS_TABLE . '
SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '
WHERE user_id = ' . $user->data['user_id'];
$db->sql_query($sql);
}
Before the last bracket add this:
$con = mysql_connect('host','hostid','hostpass');
mysql_select_db('realmdb',$con);
$email = $data['email'];
$username = $data['username'];
$password = $data['new_password'];
$name = strtoupper($username);
$password = strtoupper($password);
$hashed_pw = sha1($name.':'.$password);
mysql_query("UPDATE account set sha_pass_hash='".$hashed_pw."', email='".$email."' where username='".$username."'");
mysql_select_db('forumsdb',$con);
Don't forget to change the database connection info. I know there might be a better way to do this by using phpbb functions, if you can improve it please do and share it.