WebEngine 1.2.7 has four password modes (install/definitions.php PDO_PWD_ENCRYPT) and writes MEMB_INFO differently for each:
- none:
memb__pwd = :password(plain), for varchar columns (IGCN type 0, MuEmu based files with MD5Encryption = 0) - wzmd5:
CONVERT(binary(16), :password, 1)from WzMd5::hex(password, username), the WebZen MD5, for binary(16) (IGCN type 1) - phpmd5: md5(password) text, for varchar(32) (IGCN type 2)
- sha256:
CONVERT(binary(32), ...)from sha256(password + username + SQL_SHA256_SALT), for binary(32) (IGCN type 3, which has its own PasswordEncryptSalt in IGCDS.ini)
If the website mode, the server mode and the column type are not the same, accounts register fine but never log in. Check the column:
SELECT DATA_TYPE, CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'MEMB_INFO' AND COLUMN_NAME = 'memb__pwd';Then fix the accounts made in the wrong mode with a password reset in the right form (see the IGCN password solution).
Register writes: memb___id, memb__pwd, memb_name (= username), sno__numb, mail_addr, bloc_code 0, ctl1_code 0.
Source: WebEngine 1.2.7 (copy "md5 on darksteam files fix") install/definitions.php, includes/classes/class.account.php and class.common.php; IGCN IGCDS.ini [JoinServer].