[Core / reserved_name/character rename command] Can't be reverted

[TheSCREWEDSoftware]

Current Behaviour

If you currently rename someone with parametre 1 (.character rename ExampleChar 1) will place it on acore_characters.reserved_name

Running the following query (with the user logged or not, doesnt make a difference)

DELETE FROM `reserved_name` WHERE `name` = "Examplechar";

UPDATE `characters` SET `name` = "Examplechar" WHERE `guid` = 109;

If you login into that character, you will load screen then be kicked out, and then you will be again flagged for a rename.

Even if you do remove the at_login flag if it has IT WILL ALWAYS DO THE ABOVE

UPDATE `characters` SET `at_login` = `at_login` &~ 1 WHERE `guid` = 109;

It will always apply a rename flag on login when it kicks the player.

SELECT guid, NAME, at_login FROM characters WHERE GUID = 109

Note: That if the name has been removed from reserved names, (after the character has been rename) if you set at_login to 1 or make a new character with that name it will work fine, it's only giving issue when you do it via db

Expected Behaviour

Being able to remove the name from the reserved list and the flag without being in a infinite loop of not being able to free up the name.

Source

N/A

Steps to reproduce the problem

Just do as above.

Extra Notes

No response

AC rev. hash/commit

fdaaaae

Operating system

W11

Custom changes or Modules

N/A

[Nyeriah]

Reserved names are loaded in memory therefore removing them from the database requires a server restart in order to take effect