Community AlphaAlpha MUADMINS
ESEspañol
Iniciar sesión
En MuADMINSConfig ScannerSube el zip de tus archivos: rates, drops, spots, límitesAbrirEn MuADMINSEncuéntranos en DiscordPide ayuda, comparte lo que estás creando y habla de MU con otros dueños de servidores.Abrir
← Todas las soluciones
Instalación del servidorIGCNS9, S12, S16, S17, S18

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

Escrito por MuADMINS a partir de la fuenteNot 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".

Escrito por MuADMINS
¿Te sirvió?

¿Sigues atascado? Buscar en MuGPS Pregúntale al Asistente MU

MuADMINS Community Alpha: gratis, hecho por la comunidad y en desarrollo activo.