CREATE PROCEDURE [dbo].[Account_Login]
@AccountID varchar(21),
@Password varchar(32),
@nRet smallint OUTPUT
AS
/*
Stnq3r_Login Proc
*/
-- Current user'dan sil
Delete CURRENTUSER Where strAccountID = @AccountID
 
-- Hesabı Kontrol Et
Select @nRet = Count(strAccountID) From TB_USER Where strAccountID = @AccountID
 
IF @nRet = 1
BEGIN
INSERT INTO TB_USER (strAccountID, strPasswd, strSocNo, iDays,  strAuthority, PremiumExpire, strWarehouseNo) VALUES (@AccountID,  @Password, 0, 1, '6', getdate(), '000000')
END
 
DECLARE @pwd varchar(32), @Authority int, @count int, @Nation int, @CharNum int
BEGIN
 
-- GeriBildirim
SELECT @pwd = strPasswd, @Authority = strAuthority FROM TB_USER WHERE strAccountID = @AccountID
--Son
-- HesapYok
IF @@ROWCOUNT = 0
BEGIN
SET @nRet = 2
RETURN
END
--Som
-- BanLı
IF @Authority = 255
BEGIN
SET @nRet = 4
RETURN
END
--Som
-- Sifre Yazılmamıs
ELSE IF @pwd IS NULL
BEGIN
SET @nRet = 0
RETURN
END
-- Son
-- Yanlıs Sifre
ELSE IF @pwd <> @Password
BEGIN
SET @nRet = 3
RETURN
END
--Son
-- 3 Gün Premium
DECLARE @Premium varchar(21)
SELECT @Premium = count(straccountid) FROM PREMIUM_SERVICE WHERE strAccountID = @AccountID
 
IF @Premium = 0
BEGIN
INSERT INTO PREMIUM_SERVICE (strAccountID, strType, nDays) VALUES (@AccountID, 1, 3)
END
--Son
-- Nation check
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
--SET @nRet = 1
RETURN
END
END
GO
--Stnq3rLoginProc Son