Change a character's name through the database


I’m trying to change the name of a character through the database while the player is online(I know that there’s the command .character rename, but I want to give the character a specific name through the db). The problem is that the database will change back the name of the character once the user logs out. Is there a way to change the name while the user is online?

You can use character rename to a forced name.

[COLOR=rgb(51,51,51)]([COLOR=rgb(24,54,145)]‘character rename[COLOR=rgb(24,54,145)]’[COLOR=rgb(51,51,51)], [COLOR=rgb(0,134,179)]2[COLOR=rgb(51,51,51)], [COLOR=rgb(24,54,145)]‘Syntax: .character rename [$name] [$newName] \n\nMark selected in game or by $name in command character for rename at next login.\n\nIf $newName then the player will be forced rename.[COLOR=rgb(24,54,145)]’[COLOR=rgb(51,51,51)]);

But how can I do that using a mySQL query?

Check how command works.

— Canned message start —
This thread is not related to the official Trinity codebase and was moved to the Custom Code section.
Please read the stickies next time.
— Canned message end —