In MuEmu based files the switch is JoinServer\JoinServer.ini, MD5Encryption = 0/1 (next to CaseSensitive = 0). Every pack we read ships 0.
What the databases have:
- X-Team Season 2 and 17 scripts: memb__pwd varchar(10), no MD5 function at all (plain passwords only).
- MuDevs Season 18 / 20 and a MuEmu based Season 16 pack:
UFN_MD5_ENCODEVALUE(@btInStr, @btInStrIndex) RETURNS BINARY(16)andUFN_MD5_CHECKVALUE, which call master..XP_MD5_EncodeKeyVal / XP_MD5_CheckValue (WZ_MD5_MOD.dll, 32 bit SQL Server only). - Louis Season 6 V13 / Update 27 and MSPro V14 backups: no UFN_MD5 function inside.
So these databases are prepared for plain passwords. To switch to MD5, test on a copy first: the stored passwords must be converted to the 16 byte WebZen MD5 value (UFN_MD5_ENCODEVALUE gives BINARY(16); the column then must be binary(16)), the DLL must be registered in master, and the website must write the same form (WebEngine "wzmd5", DmN detects a non varchar memb__pwd as MD5).
Check a function and the column:
SELECT name FROM sys.objects WHERE name LIKE 'UFN_MD5%';
SELECT DATA_TYPE, CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'MEMB_INFO' AND COLUMN_NAME = 'memb__pwd';Source: JoinServer.ini of Louis V13, Louis S6 Update 27, MSPro V14, X-Team S17, MuDevs S18; MuOnline scripts of X-Team S2/S17, MuDevs S18/S20 and the MuEmu based S16 pack; backups of Louis V13, Louis U27, MSPro V14 (read as bytes).