Community AlphaAlpha MUADMINS
ENEnglish
Sign in
On MuADMINSConfig ScannerDrop your files zip: rates, drops, spots, limitsOpenOn MuADMINSMeet us on DiscordAsk for help, share what you are building and talk MU with other server owners.Open
← All solutions

How do I set a new password for one account on a WebZen Season 2 / 3 MD5 database (SP_MD5_ENCODE_VALUE)?

Written by MuADMINS from the sourceNot verified

The Season 3 mumatrix and Season 2 namech databases ship SP_MD5_ENCODE_VALUE @btInStr VARCHAR(10), @btInStrIndex VARCHAR(10) ("Created By WebZen, Adapted By [CzF]Deathway" in the Season 3 copy). In the Season 3 copy it runs EXEC master..XP_MD5_EncodeKeyVal @btInStr, @btInStrIndex, @btOutVal OUT and then UPDATE MEMB_INFO SET memb__pwd = @btOutVal WHERE memb___id = @btInStrIndex. So: new password first, account second:

EXEC SP_MD5_ENCODE_VALUE 'NewPass1', 'account1';

It needs XP_MD5_EncodeKeyVal registered in master (WZ_MD5_MOD.dll, 32 bit SQL Server):

SELECT name, dll_name FROM master.sys.extended_procedures WHERE name LIKE 'XP_MD5%';

Only for databases that store MD5 passwords: on a plain password database this writes a 16 byte value the server cannot read.

Source: Season 3 mumatrix configs mu/Database/MuOnline.bak and Season 2 namech Database Files/MuOnline (SP_MD5_ENCODE_VALUE module text read from the backups).

Written by MuADMINS
Did this help?

Still stuck? Search MuGPS Ask the MU Assistant

MuADMINS Community Alpha: free and community made, in active development.