0) { header("location: /throw_error"); exit(); } // If current password is correct // hash the password $password_hashed = hash("sha256",$u_username.$current_pass); $new_password_hashed = hash("sha256",$new_uname.$current_pass); if($password_hashed == $u_password) { if($u_namechange == 'no') { mysqli_query($conx, "UPDATE accounts SET username='$new_uname' WHERE uid='$u_uid'"); mysqli_query($conx, "UPDATE accounts SET password='$new_password_hashed' WHERE uid='$u_uid'"); mysqli_query($conx, "UPDATE accounts SET uname_change='yes' WHERE uid='$u_uid'"); if($u_csplown == 'yes') { mysqli_query($conx, "UPDATE user_theme_colors SET csplit1_name='$new_uname' WHERE uid='$u_uid' && theme_id='1'"); mysqli_query($conx, "UPDATE user_theme_colors SET csplit2_name='' WHERE uid='$u_uid' && theme_id='1'"); mysqli_query($conx, "UPDATE user_theme_colors SET csplit3_name='' WHERE uid='$u_uid' && theme_id='1'"); mysqli_query($conx, "UPDATE user_theme_colors SET csplit1_name='$new_uname' WHERE uid='$u_uid' && theme_id='2'"); mysqli_query($conx, "UPDATE user_theme_colors SET csplit2_name='' WHERE uid='$u_uid' && theme_id='2'"); mysqli_query($conx, "UPDATE user_theme_colors SET csplit3_name='' WHERE uid='$u_uid' && theme_id='2'"); mysqli_query($conx, "UPDATE user_theme_colors SET csplit1_name='$new_uname' WHERE uid='$u_uid' && theme_id='3'"); mysqli_query($conx, "UPDATE user_theme_colors SET csplit2_name='' WHERE uid='$u_uid' && theme_id='3'"); mysqli_query($conx, "UPDATE user_theme_colors SET csplit3_name='' WHERE uid='$u_uid' && theme_id='3'"); } } else { header("location: /throw_error"); } } else { header("location: /throw_error"); } } else { header("location: /throw_error"); } ?>