Koguard 10060

[B]CREATE PROCEDURE [dbo].[MAIN_LOGIN] @AccountID    varchar(21), @Password    varchar(32), @nRet2    smallint OUTPUT, @nRet        smallint    OUTPUT AS  -- # Login Disabled  for Banned Accounts Start # -- DECLARE @AccID int, @BanCount int, @isExist int SELECT @AccID = ID FROM TB_USER WHERE strAccountID = @AccountID IF @AccID is not null BEGIN     SELECT @BanCount = Count(ID) FROM USERDATA WHERE Authority = 255 AND AccountID = @AccID     IF @BanCount <> 0     BEGIN         -- Blocked Account         SET @nRet = 4         RETURN     END END -- # Login Disabled  for Banned Accounts End # --  -- # Auto Account Start # IF @AccID is null BEGIN     INSERT INTO TB_USER (strAccountID,strPasswd) VALUES (@AccountID,@Password)     IF @@error <> 0     BEGIN         -- No Registred Such ID         SET @nRet = 2         RETURN     END     SELECT @AccID = ID FROM TB_USER WHERE strAccountID = @AccountID     IF @AccID is null     BEGIN         -- No Registred Such ID         SET @nRet = 2         RETURN     END END -- # Auto Account End #  -- # Check Current User Start # SELECT @nRet = Count(iAccountID) FROM CURRENTUSER WHERE iAccountID = @AccID IF @nRet <> 0 BEGIN     DELETE FROM CURRENTUSER WHERE iAccountID = @AccID END -- # Check Current User End #  SELECT @isExist = Count(ID) FROM TB_USER WHERE ID = @AccID and strPasswd = @Password IF (@isExist <> 1) BEGIN     -- Invalid Password     SET @nRet = 3     RETURN END ELSE BEGIN     -- Success     SET @nRet = 1     RETURN END[/B]