Columns in IGCN Character: RESETS (int, all seasons), GrandResets (tinyint, Season 16, 17, 18), GRANDRESET (Season 12), plus cLevel, Experience, LevelUpPoint and the stats.
- Close the GameServers (a change made while the character is online is overwritten when the server saves it). Back up first.
- Look first:
SELECT Name, AccountID, cLevel, RESETS, GrandResets, LevelUpPoint FROM Character WHERE Name = 'CharName';- 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;- 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".