[HELP] EP10 username and password is not match when login

[lamgood921]

I have set up the server and client is connected to the server successfully.

I have also enter UserName UserID UserPass UserPass2 UserType at the database RanUser

But the game keep saying username and password is not matched at login....

could not think of why??

[MentaL]

[cus]

Use MD5.
Example: 123456789 --> 25F9E794323B453885F

[baby011528]

I have set up the server and client is connected to the server successfully.

I have also enter UserName UserID UserPass UserPass2 UserType at the database RanUser

But the game keep saying username and password is not matched at login....

could not think of why??

u need a tools that convert password to MD5.
or u can proceed with this SQL query

use ranuser
declare @tmpusername varchar(50),@tmppassword varchar(50),@tmppassword2 varchar(50),@tmpusertype int
set @tmpusername= 'userid1'
set @tmppassword= 'userpassword'
set @tmppassword2= 'userpassword2'
set @tmpusertype= '30'

declare @nUserPass varchar(19),@nUserPass2 varchar(19)
set @nUserPass=(Select left(CONVERT(Varchar(32),HashBytes('MD5',@tmppassword),2),19))
set @nUserPass2=(Select left(CONVERT(Varchar(32),HashBytes('MD5',@tmppassword2),2),19))
insert into UserInfo (UserName,UserID,UserPass,UserPass2,UserType) Values (@tmpusername,@tmpusername,@nUserPass,@nUserPass2,@tmpusertype)

[lamgood921]

thanks dude fixed
so silly of me
was wondering what that MD5 button next to password in ranmanager for -.- lol