Community AlphaAlpha MUADMINS
FILFilipino
Mag-sign in
Sa MuADMINSMag-ambagTumulong at makakuha ng Community PointsBuksanSa MuADMINSIskedyul ng mga eventBlood Castle, Devil Square, mga invasion sa isang lingguhang gridBuksan
← Lahat ng solusyon

I changed a character, coins or a vault with SQL and the change disappeared (UPDATE while the server is on)

Isinulat ng MuADMINS mula sa sourceNot verified

The running server keeps its own copy of every online character and account and writes it back to the database, so an UPDATE made while that player is online can be overwritten a moment later. That is why:

  • the IGCN maintenance scripts start with "Take server offline before proceeding with the script";
  • WebEngine refuses to add or take credits while the account is online (WEBENGINE_CREDITS_CONFIG.config_checkonline, error_14).

Safe order for any manual change:

  1. Close the GameServers (for account data: the whole server), or at least make sure the player is offline: SELECT ConnectStat FROM MEMB_STAT WHERE memb___id = 'account1' (0 = offline, but see the stuck ConnectStat solution).
  2. Back up:
BACKUP DATABASE [MuOnline] TO DISK = N'C:\MUBackup\MuOnline_before_fix.bak' WITH INIT;
  1. SELECT the rows first, then UPDATE with the same WHERE.
  2. Start the server and check in game.

Source: IGCN S17 2. Update Scripts/Maintenance Scripts (Check & Fix negative Coins.sql); WebEngine 1.2.7 install/sql/WEBENGINE_CREDITS_CONFIG.txt and includes/classes/class.credits.php.

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.