UBB.threads PHP Forum Software Community Forums UBB.threads Bug Reports Fixed Bugs [FIXED in b4[ B3: Changing email-address in profile give an error

 update ubbt_USERS set where USER_ID = 3

 update ubbt_USERS set SOMETHING where USER_ID = 3

 $query_string = preg_replace("/,$/","",$query_string);
		array_push($query_vars,$user['USER_ID']);
		$query = "
			update	{$config['TABLE_PREFIX']}USERS
			set			$query_string
			where		USER_ID = ?
		";

	if ($changedisplay || $changeemail || $changepassword) {
		$query_vars = array();
		$query_string = "";
		if ($changedisplay) {
			$query_string = "USER_DISPLAY_NAME = ? ,";
			array_push($query_vars,$displayname);
		} // end if
		if ($changepassword) {
			$query_string .= "USER_PASSWORD = ? ,";
			array_push($query_vars,$ChosenPassword);
		}
		$query_string = preg_replace("/,$/","",$query_string);

	if ($changedisplay || $changeemail || $changepassword) {
		$query_vars = array();
		$query_string = "";
		if ($changedisplay) {
			$query_string = "USER_DISPLAY_NAME = ? ,";
			array_push($query_vars,$displayname);
		} // end if
		if ($changeemail)
		{
			$query_string .= "USER_REAL_EMAIL = ? ,";
			array_push($query_vars,$Email);		
		}
		if ($changepassword) {
			$query_string .= "USER_PASSWORD = ? ,";
			array_push($query_vars,$ChosenPassword);
		}
		$query_string = preg_replace("/,$/","",$query_string);