Community AlphaAlpha MUADMINS
RUРусский
Войти
На MuADMINSConfig ScannerЗагрузите zip своих файлов: рейты, дропы, споты, лимитыОткрытьНа MuADMINSПрисоединяйтесь к нам в DiscordПросите помощи, показывайте свои проекты и общайтесь о MU с другими владельцами серверов.Открыть
← Все решения

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

Написано MuADMINS по источникуNot 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".

Написано MuADMINS
Это помогло?

Всё ещё не получается? Поиск в MuGPS Спросить Помощника MU

MuADMINS Community Alpha: бесплатно, создаётся сообществом, в активной разработке.