Community AlphaAlpha MUADMINS
FRFrançais
Connexion
Sur MuADMINSConfig ScannerDéposez le zip de vos fichiers : rates, drops, spots, limitesOuvrirSur MuADMINSRetrouvez-nous sur DiscordDemandez de l'aide, partagez ce que vous créez et parlez de MU avec d'autres propriétaires de serveurs.Ouvrir
← Toutes les solutions
Installation du serveurS2, S6, S16, S17, S18, S20

How do I reset a character with SQL on MuEmu, Louis, MSPro, X-Team or MuDevs files (ResetCount) with the server closed?

Rédigé par MuADMINS à partir de la sourceNot verified

Columns: Character.ResetCount and MasterResetCount (X-Team also ResetDay, ResetWek, ResetMon and MasterResetDay / Wek / Mon for the daily, weekly and monthly limits). The server reads and writes them with WZ_GetResetInfo / WZ_SetResetInfo @Account, @Name, @Reset, @ResetDay, @ResetWek, @ResetMon.

  1. Close the GameServers (an online character is saved back from memory and your change is lost). Back up.
  2. Look first:
SELECT Name, AccountID, cLevel, ResetCount, MasterResetCount, LevelUpPoint FROM Character WHERE Name = 'CharName';
  1. Reset one character that reached the level:
UPDATE Character SET cLevel = 1, Experience = 0, ResetCount = ResetCount + 1
WHERE Name = 'CharName' AND AccountID = 'account1' AND cLevel >= 400;
  1. Add points (LevelUpPoint) only if your reset rules give them.

Rankings: WebEngine (xteam.tables.php) shows ResetCount as resets and MasterResetCount as grand resets.

Source: X-Team S17 DB/MuOnline.sql (Character, WZ_GetResetInfo, WZ_SetResetInfo), MuDevs S18 MuOnline DB Create Script.sql, MuEmu based S16 MuOnline.sql; WebEngine 1.2.7 includes/config/xteam.tables.php.

Rédigé par MuADMINS
Cela vous a-t-il aidé ?

Toujours bloqué ? Rechercher sur MuGPS Demander à l'Assistant MU

MuADMINS Community Alpha : gratuit, fait par la communauté, en développement actif.