The character list of an account is kept in AccountCharacter (Id = account, GameID1 to GameID5, or to GameID10 on newer files, plus GameIDC). The packs' WZ_CreateCharacter writes the new name into the first empty GameID slot. A character that exists in Character but is in no slot of its account (manual INSERT, rename done only in Character, restore of one table, a 5 slot procedure on 10 slot files) is the first thing to check.
- Server closed or account offline. Look at both tables:
SELECT * FROM AccountCharacter WHERE Id = 'account1';
SELECT Name, AccountID, cLevel, Class, CtlCode FROM Character WHERE AccountID = 'account1';- Put the name back into a free slot (example slot 2, only if it is empty):
UPDATE AccountCharacter SET GameID2 = 'CharName' WHERE Id = 'account1' AND (GameID2 IS NULL OR GameID2 = '');- No AccountCharacter row at all: create it the way WZ_CreateCharacter does:
INSERT INTO AccountCharacter (Id, GameID1) VALUES ('account1', 'CharName');- Also check Character.AccountID is exactly the account name, and CtlCode (1 = blocked character in the Louis ban scripts).
Slots: GameID6 to GameID10 came with Louis Season 6 Update 26 and MSPro V6; IGCN Season 17 and X-Team Season 17 have 10 slots.
Source: AccountCharacter and WZ_CreateCharacter in the IGCN S17, X-Team S17, MuDevs S18 scripts and Louis S6 Update 26 "Update Procedure WZ_CreateCharacter.sql".