[HELP] 4Story TLogin function

[Hamachi4s]

Hello!

Password not working. Syntax error... password1=password2
(MD5 Hashed?)
My TLogin script:

 Spoiler

IF (@@ERROR <> 0 OR @nWebReturn <> 0)
-- BEGIN
/* Not found user */
-- RETURN @nWebReturn
-- END

-- INSERT INTO TLogTest (dwId, szLog) VALUES (10, @szPasswd)

SELECT TOP 1 @dwUserID = dwUserID, @bCheck=bCheck FROM TACCOUNT WHERE szUserID = @szUserID
IF @@ROWCOUNT = 0
BEGIN
/* Not found user */
RETURN 1
END

SELECT TOP 1 @dwUserID = dwUserID, @bCheck=bCheck FROM TACCOUNT WHERE szUserID = @szUserID
IF @@ROWCOUNT = 0
BEGIN
/* Invalid Password */
RETURN 2
END

[[DEV] Tiger]

This is no MD5 hash

 Spoiler

SELECT TOP 1 @dwUserID = dwUserID, @bCheck=bCheck FROM TACCOUNT WHERE szUserID = @szUserID AND @szPasswd =szPasswd

[Hamachi4s]

Yes yes
Edited The script.

[[DEV] Tiger]

SELECT TOP 1 @dwUserID = dwUserID, @bCheck=bCheck FROM TACCOUNT WHERE szUserID = @szUserID AND @szPasswd = CONVERT(VARCHAR(100), HashBytes('MD5', szPasswd) , 2)
IF @@ROWCOUNT = 0
BEGIN
/* Invalid Password */
RETURN 2
END

With MD5 hash