Fire Drake v1.453 LogInServer

[admin]

v1.089 sourcesinden toparlanmıştır, düzgün çalısmakta ve bir problemi yoktur.



Türkçe karakter koruması var.

CREATE PROCEDURE ACCOUNT_LOGIN

@AccountID    varchar(21),

@Password    varchar(50) OUTPUT,

@nRet        smallint OUTPUT,

@PremiumDays    smallint OUTPUT

AS



DECLARE @pwd varchar(50), @Nation tinyint, @CharNum smallint

SET @nRet = 0

SET @pwd = null

SET @Nation = 0

SET @CharNum = 0

SET @PremiumDays = 30



SELECT @nRet = COUNT(strAccountID) FROM TB_USER Where strAccountID = @AccountID

IF @nRet = 0

BEGIN

    INSERT INTO TB_USER (strAccountID, strPasswd, strSocNo, iDays) VALUES (@AccountID, @Password, 1, '6')

END



SELECT @pwd = strPasswd FROM TB_USER WHERE strAccountID = @AccountID and idays=6

IF @pwd IS null or @pwd != @Password

BEGIN

    SET @nRet = 3

    RETURN

END

/*

SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID

IF @@ROWCOUNT = 0

BEGIN

    SET @nRet = 1

    RETURN

END

IF @CharNum = 0

BEGIN

    SET @nRet = 1

    RETURN

END

ELSE 

BEGIN

    SET @nRet = @Nation+1

    RETURN

END

*/

DELETE FROM CURRENTUSER Where strAccountID = @AccountID

SET @nRet = 1

RETURN

GO

Resim anderson tarafından cekilmistir