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
Server setupIGCNS9, S12, S16, S17, S18

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

Written by MuADMINS from the sourceNot 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".

Written by MuADMINS
Did this help?

Still stuck? Search MuGPS Ask the MU Assistant

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