USE [KN_online]
GO
/****** Object:  StoredProcedure [dbo].[ACCOUNT_LOGIN]    Script Date: 07/16/2008 01:01:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create PROCEDURE [dbo].[ACCOUNT_LOGIN]
@AccountID    varchar(21),
@Password    varchar(13),
@nRet        smallint    OUTPUT

AS

DECLARE @Nation tinyint, @CharNum smallint
SET @Nation = 0
SET @CharNum = 0
DECLARE @pwd varchar(13)
SET @pwd = null
SELECT @pwd = strPasswd FROM [dbo].[TB_USER] WHERE strAccountID = @AccountID  and  idays>0
IF @pwd IS null
BEGIN
    --SET @nRet = 0
             SET @nRet = 4
    RETURN
END
ELSE IF @pwd <> @Password
BEGIN
    --SET @nRet = 0
             SET @nRet = 3
    RETURN
END

exec rundupecheck @accountid
exec rundupecheckinn @accountid

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 = 1
    RETURN
END

USE [KN_online]
GO
/****** Object:  Table [dbo].[PREMIUM_SERVICE]    Script Date: 07/16/2008 01:02:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PREMIUM_SERVICE](
    [strAccountID] [varchar](27) NOT NULL,
    [strType] [smallint] NOT NULL,
    [nDays] [smallint] NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

begin
check table PREMIUM_SERVICE where StrAccountID = @AccountID and nDays='0' 

if nDays='0'

delete from table PREMIUM_SERVICE where StrAccountID = @AccountID
end

Begin
select * 
from 
    PREMIUM_SERVICE 
where 
    StrAccountID= @Accountid and nDays='0'
if nDays='0'
Delete From PREMIUM_SERVICE where StrAccountID= @Accountid
End

select @Accountid from PREMIUM_SERVICE where strAccountID = @Accountid 
select nDays from PREMIUM_SERVICE where nDays = '0' 
Delete From PREMIUM_SERVICE where StrAccountID = @Accountid

UPDATE PREMIUM_SERVICE SET nDays='365';

SELECT @DaysLeft=nDays FROM PREMIUM_SERVICE WHERE strAccountID=@AccountID;
if @DaysLeft = 0 /* Although, you may want to set it to 1 to avoid program crashes at all costs */
BEGIN
DELETE FROM PREMIUM_SERVICE WHERE strAccountID=@AccountID;
END