Use the form that matches PasswordEncryptType in IGCDS.ini and the memb__pwd column type. Keep the account offline and always use WHERE.
- Type 0 (varchar(20)):
UPDATE MEMB_INFO SET memb__pwd = 'NewPass1' WHERE memb___id = 'account1';- Type 1 (binary(16), WZ_MD5): IGCN's own function, password first, account second:
UPDATE MEMB_INFO SET memb__pwd = dbo.fn_md5('NewPass1', 'account1') WHERE memb___id = 'account1';- Type 2 (varchar(32), md5 like PHP md5(), lower case hex):
UPDATE MEMB_INFO SET memb__pwd = LOWER(CONVERT(varchar(32), HASHBYTES('MD5', 'NewPass1'), 2))
WHERE memb___id = 'account1';- Type 3 (SHA256 with salt): let the website set it (WebEngine computes it with the same salt) instead of writing it by hand.
If you use Me_MuOnline (IGCDS.ini MeMuOnlineDB = Me_MuOnline), change the row in Me_MuOnline.dbo.MEMB_INFO: that database has its own MEMB_INFO and its own fn_md5.
Source: IGCN Season 17 and 18 MuOnline_MD5.sql / Me_MuOnline_MD5.sql (fn_md5), IGCDS.ini [JoinServer] (types 0 to 3).