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

How do I fix a vault (warehouse): forgotten vault password, or a broken vault that must be emptied safely?

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

Every MSSQL family we read has warehouse (AccountID, Items varbinary, Money, EndUseDate, pw ...); the Items size differs (IGCN S17 7680 bytes, MuDevs 6000, X-Team S17 4800, WebZen S2 1920). In the WebZen Season 2 procedure WHS_UPD_MnyPwDbv pw is the vault password (0 = none).

Server closed (or player offline), and keep a copy of the row first:

SELECT * INTO warehouse_copy_20261031 FROM warehouse WHERE AccountID = 'account1';

Forgotten vault password:

UPDATE warehouse SET pw = 0 WHERE AccountID = 'account1';

Broken vault (server errors when it opens): take the bytes of a vault you know is empty in the SAME database (for example a test account that opened its empty vault once):

SELECT AccountID, DATALENGTH(Items) AS bytes FROM warehouse WHERE AccountID IN ('account1', 'emptyacc');
UPDATE warehouse SET Items = (SELECT Items FROM warehouse WHERE AccountID = 'emptyacc') WHERE AccountID = 'account1';

On WebZen Season 2 files the shipped WHS_SELECT creates an empty vault as cast(REPLICATE(char(0xff),1920) as varbinary(1920)). The items are gone after this; the copy table keeps them for an editor (MuMaker, the files' editor) to recover what is good.

Source: warehouse in the IGCN S17, X-Team S17, MuDevs S18 scripts; WHS_SELECT and WHS_UPD_MnyPwDbv in the WebZen Season 2 namech backup (module text).

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.