Creating Account

[Supacek]

INSERT INTO Player (PlayerID,Password,Access) VALUE ('username',PASSWORD('password'), 'ALLOW')

1406 - Data too long for column 'Password' at row 1
Time: 0.054s
ok so we have problem or i have problem
the new hash code is to logn so we need to change table PLAYER

and set Lenght from 15 to like 50 cuz the new hash is 41 lenght long

then try again create account with query

succes

but the problem is after trying log in into game Error

the problem must be in the new hash
any help ? how i can figure it out ???
when i try to use
query with INSERT` INTO Player (PlayerID,Password,Access) VALUE ('username',OLD_PASSWORD('password'), 'ALLOW')
function dont exist

any idea? how to fix ?

[Supacek]

INTO Player (PlayerID,Password,Access) VALUE ('username',PASSWORD('password'), 'ALLOW')

possible fix use only
INTO Player (PlayerID,Password,Access) VALUE ('username', 'password', 'ALLOW') = no hash password

[tiancaiamao]

Yes, I changed code ... to use the raw passward.
You can INTO Player (PlayerID,Password,Access) VALUE ('username','your password'), 'ALLOW')

@Supacek

[tiancaiamao]

No PASSWORD or OLD_PASSWORD function

[Supacek]

Fixed ye