Community AlphaAlpha MUADMINS
FILFilipino
Mag-sign in
Sa MuADMINSConfig ScannerI-upload ang zip ng mga file mo: rate, drop, spot, limitBuksanSa MuADMINSMakipagkita sa amin sa DiscordHumingi ng tulong, ibahagi ang ginagawa mo at makipag-usap tungkol sa MU sa ibang may-ari ng server.Buksan
← Lahat ng solusyon
Server setupIGCNS9, S12, S16, S17, S18

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

Isinulat ng MuADMINS mula sa 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".

Isinulat ng MuADMINS
Nakatulong ba ito?

Naipit pa rin? Maghanap sa MuGPS Magtanong sa MU Assistant

MuADMINS Community Alpha: libre, gawa ng komunidad, at patuloy na dine-develop.