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

How do I reset a character with SQL on IGCN files (RESETS, GrandResets) with the server closed?

Написано MuADMINS по источникуNot verified

Columns in IGCN Character: RESETS (int, all seasons), GrandResets (tinyint, Season 16, 17, 18), GRANDRESET (Season 12), plus cLevel, Experience, LevelUpPoint and the stats.

  1. Close the GameServers (a change made while the character is online is overwritten when the server saves it). Back up first.
  2. Look first:
SELECT Name, AccountID, cLevel, RESETS, GrandResets, LevelUpPoint FROM Character WHERE Name = 'CharName';
  1. Reset one character, only if it reached the level you require:
UPDATE Character SET cLevel = 1, Experience = 0, RESETS = RESETS + 1
WHERE Name = 'CharName' AND cLevel >= 400;
  1. Points or stat changes depend on your own reset rules: add them to LevelUpPoint or the stat columns in the same UPDATE if your server gives them.

Never run an UPDATE on Character without WHERE: it changes every character of the server.

Source: IGCN S9, S12.2, S16, S17, S18 MuOnline scripts (Character table); IGCN maintenance scripts start with "Take server offline before proceeding with the script".

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

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

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