Bildiginiz Gibi 1310 Gittikçe Gelişiyor..
Login Prosedüründe Md5 Şifreleme Oldugu İcin Herkez Sorun Çekiyor.. Bnde Bunu Paylaşıyorum..
Account_Login
Kod:
CREATE PROCEDURE [dbo].[ACCOUNT_LOGIN]
@AccountID varchar(21),
@Password varchar(32),
@nRet smallint OUTPUT
AS
DECLARE @pwd varchar(32), @Authority int, @count int, @Nation int, @CharNum int
BEGIN
-- <RETRIEVE ACCOUNT DATA>
SELECT @pwd = strPasswd, @Authority = strAuthority FROM TB_USER WHERE strAccountID = @AccountID
-- </RETRIEVE ACCOUNT DATA>
-- <ACCOUNT DOES NOT EXIST>
IF @@ROWCOUNT = 0
BEGIN
SET @nRet = 0
RETURN
END
-- </ACCOUNT DOES NOT EXIST>
-- <BANNED>
IF @Authority = 255
BEGIN
SET @nRet = 0
RETURN
END
-- </BANNED>
-- <EMPTY PASSWORD>
ELSE IF @pwd IS NULL
BEGIN
SET @nRet = 0
RETURN
END
-- </EMPTY PASSWORD>
-- <INVALID PASSWORD>
ELSE IF master.dbo.fn_md5(@Password) <> @pwd
BEGIN
SET @nRet = 0
RETURN
END
-- </INVALID PASSWORD>
-- <RETRIEVE NATION AND CHARACTER COUNT>
SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
-- </RETRIEVE NATION AND CHARACTER COUNT>
-- <NO NATION SELECTED>
IF @@ROWCOUNT = 0 OR @CharNum = 0
BEGIN
SET @nRet = 1
END
-- </NO NATION SELECTED>
ELSE
-- <NATION ALREADY SELECTED>
BEGIN
SET @nRet = @Nation + 1
END
-- </NATION ALREADY SELECTED>
END
GO
ACCOUNT_LOGOUT
Kod:
CREATE PROCEDURE [dbo].[ACCOUNT_LOGOUT]
@AccountID varchar(21),
@id int,
@nRet smallint OUTPUT,
@a smallint OUTPUT
AS
EXEC RANK_KNIGHTS
EXEC USER_KNIGHTS_RATING_UPDATE
EXEC KNIGHTS_RATING_UPDATE
EXEC UPDATE_MANNERPOINT_RANK
EXEC UPDATE_PERSONAL_RANK
BEGIN TRAN
DELETE FROM CURRENTUSER WHERE strAccountID = @AccountID
COMMIT TRAN
SET @nRet = 1
SET @a = 1
GO |
