Community AlphaAlpha MUADMINS
ITItaliano
Accedi
Su MuADMINSContribuisciDai una mano e guadagna Community PointsApriSu MuADMINSOrari degli eventiBlood Castle, Devil Square, invasioni in una griglia settimanaleApri
← Tutte le soluzioni

WebEngine: accounts made on the website cannot log in (password encryption must match memb__pwd)

Scritto da MuADMINS a partire dalla fonteNot verified

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].

Scritto da MuADMINS
Ti è stato utile?

Non hai ancora risolto? Cerca su MuGPS Chiedi all'Assistente MU

MuADMINS Community Alpha: gratuito, fatto dalla community, in sviluppo attivo.