WrEmu, Odbc with C#

[~Beefy~ 6]

Hello Everybody,

a few weeks ago i downloaded wremu. its a warrock privat server.

i mean there is source withit.

i got a biig problem, the other ones i solved already but i dont know how to fix that shit.

 

 

 

USE [WARROCK_DBF]
GO
/****** Objekt:  StoredProcedure [dbo].[LOGIN_STR]	Skriptdatum: 08/15/2010 19:37:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[LOGIN_STR]
@uUsername VARCHAR(32), 
@uPassword VARCHAR(32)
AS
BEGIN
SET NOCOUNT ON;

IF EXISTS(SELECT a.username FROM ACCOUNT_TBL a, ACCOUNT_TBL_DETAIL b 
			  WHERE a.userID = b.userID AND a.username = @uUsername)
	BEGIN
		IF EXISTS(SELECT username FROM ACCOUNT_TBL  
				WHERE username = @uUsername AND password = @uPassword)
			BEGIN
				SELECT	fError =	CASE 	WHEN a.status = 1
												THEN '3/0'
											WHEN b.banTime = -1
												THEN '4/0'
											WHEN b.banTime > 0
												THEN ('5/' + CONVERT(VARCHAR, a.userID, 0) + '/' + CONVERT(VARCHAR, b.banDate, 0) + '/' + CONVERT(VARCHAR, b.banTime, 0))
											ELSE ('0/' + CONVERT(VARCHAR, a.userID, 0) + '/' + CONVERT(VARCHAR, a.nickname, 0))
									END
				FROM ACCOUNT_TBL a, ACCOUNT_DETAIL_TBL b 
					WHERE a.userID = b.userID AND a.username = @uUsername AND a.password = @uPassword
			END
		ELSE
			BEGIN
				SELECT fError = '2/0'
			END
	END
ELSE
	BEGIN
		SELECT fError = '1/0'
	END

SET NOCOUNT OFF;
END
RETURN
-- fError 0/USERID/NICKNAME: Login succeed
-- fError 1/0: Account not exists
-- fError 2/0: Wrong Password
-- fError 3/0: Already Online
-- fError 4/0: Account Banned
-- fError 5/USERID/DATE/TIME: Account Banned with Time

 

 

 

Except, my problem is here:

IF EXISTS(SELECT username FROM ACCOUNT_TBL  
				WHERE username = @uUsername AND >>>password = @uPassword<<<)
			BEGIN
				SELECT	fError =	CASE 	WHEN a.status = 1
												THEN '3/0'
											WHEN b.banTime = -1
												THEN '4/0'
											WHEN b.banTime > 0
												THEN ('5/' + CONVERT(VARCHAR, a.userID, 0) + '/' + CONVERT(VARCHAR, b.banDate, 0) + '/' + CONVERT(VARCHAR, b.banTime, 0))
											ELSE ('0/' + CONVERT(VARCHAR, a.userID, 0) + '/' + CONVERT(VARCHAR, a.nickname, 0))
									END
				FROM ACCOUNT_TBL a, ACCOUNT_DETAIL_TBL b 
					WHERE a.userID = b.userID AND a.username = @uUsername AND a.password = @uPassword
			END
		ELSE
			BEGIN
				SELECT fError = '2/0'
			END
	END

 

The Password i entered is right, md5 crypted with the salt "wremu".

my pass is now: wremupassword

 

how do i fix this shit?

[paTTax 5]

We need more than these snippets to help you. Also, why do u edit the source for the Loginservers? The original Source is working perfectly!