Community AlphaAlpha MUADMINS
ESEspañol
Iniciar sesión
En MuADMINSConfig ScannerSube el zip de tus archivos: rates, drops, spots, límitesAbrirEn MuADMINSEncuéntranos en DiscordPide ayuda, comparte lo que estás creando y habla de MU con otros dueños de servidores.Abrir
← Todas las soluciones

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

Escrito por MuADMINS a partir de la fuenteNot 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".

Escrito por MuADMINS
¿Te sirvió?

¿Sigues atascado? Buscar en MuGPS Pregúntale al Asistente MU

MuADMINS Community Alpha: gratis, hecho por la comunidad y en desarrollo activo.