Community AlphaAlpha MUADMINS
ENEnglish
Sign in
On MuADMINSConfig ScannerDrop your files zip: rates, drops, spots, limitsOpenOn MuADMINSMeet us on DiscordAsk for help, share what you are building and talk MU with other server owners.Open
← All solutions

A character exists in the Character table but does not appear (AccountCharacter slots)

Written by MuADMINS from the sourceNot verified

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.

  1. 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';
  1. 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 = '');
  1. No AccountCharacter row at all: create it the way WZ_CreateCharacter does:
INSERT INTO AccountCharacter (Id, GameID1) VALUES ('account1', 'CharName');
  1. 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".

Written by MuADMINS
Did this help?

Still stuck? Search MuGPS Ask the MU Assistant

MuADMINS Community Alpha: free and community made, in active development.