duartegabriel

9 hours ago, PARADISE said:

I had the same issue with frameworks and query builders and so on. This is how I managed to insert the encrypted password. The encrypted password from L2Crypt.js should look like this: 0x256891DE63C270EDD8416767AA301616 . Then you insert this using CONVERT inside user_auth

 

CONVERT(BINARY(16), '$pass', 1)

And for the answers of the security questions (answer1 & answer2 inside user_auth)

 

CONVERT(BINARY(32), '$answer1', 1)

 

something like:

knex('user_auth')
   .insert({
      CONVERT(BINARY(16), 'pass', 1), 
      quiz1,
      quiz2, 
      CONVERT(BINARY(16), 'answer1', 1),
      CONVERT(BINARY(16), 'answer2', 1),
   });

How to crypt password using L2Crypt.js?

I have the error:

"message": "Implicit conversion from data type nvarchar to binary is not allowed. Use the CONVERT function to run this query.",

how to solve? I use KNEX

It worked.

I was using an old function that was not encrypting correctly ...

Thank you very much...

Hello everyone;

I'm starting in the world of Lineage 2 OFF (interlude) and would like to know some things ... (if you can).

I am developing a panel and I want to create the account for it, but I can not create the user password in the binary value that is needed.

How do I create the user password in the format required to be able to enter the game?

I am using PHP on my panel.

Thanks...