if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SP_GET_MEMB_LIMITTIME]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SP_GET_MEMB_LIMITTIME]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SP_SET_MEMB_LIMITTIME_PLAYTIME]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SP_SET_MEMB_LIMITTIME_PLAYTIME]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SP_SET_MEMB_LIMITTIME_RESTTIME]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SP_SET_MEMB_LIMITTIME_RESTTIME]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MEMB_LIMITTIME]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MEMB_LIMITTIME]
GO

CREATE TABLE [dbo].[MEMB_LIMITTIME] (
[AccountID] [varchar] (50) NOT NULL ,
[AddPlayTime] [int] NOT NULL ,
[AddRestTime] [int] NOT NULL ,
[LastLogoutDate] [datetime] NOT NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[MEMB_LIMITTIME] WITH NOCHECK ADD
CONSTRAINT [PK_MEMB_LIMITTIME] PRIMARY KEY CLUSTERED
(
[AccountID]
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[MEMB_LIMITTIME] ADD
CONSTRAINT [DF_MEMB_LIMITTIME_AddPlayTime] DEFAULT (0) FOR [AddPlayTime],
CONSTRAINT [DF_MEMB_LIMITTIME_AddRestTime] DEFAULT (0) FOR [AddRestTime],
CONSTRAINT [DF_MEMB_LIMITTIME_LastLogoutDate] DEFAULT (getdate()) FOR [LastLogoutDate]
GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO

CREATE PROCEDURE SP_GET_MEMB_LIMITTIME
@szAccountID varchar(10)
As
Begin
BEGIN TRANSACTION

SET NOCOUNT ON

IF NOT EXISTS ( SELECT AccountID FROM MEMB_LIMITTIME WITH (READUNCOMMITTED) WHERE AccountID = @szAccountID)
BEGIN
INSERT MEMB_LIMITTIME (AccountID) VALUES(@szAccountID)
END

SELECT AddPlayTime, AddRestTime, DATEPART(YY, LastLogoutDate) As LastYear, DATEPART(MM, LastLogoutDate) As LastMonth, DATEPART(DD, LastLogoutDate) As LastDay, DATEPART(HH, LastLogoutDate) As LastHour, DATEPART(MI, LastLogoutDate) As LastMinute, DATEPART(SS, LastLogoutDate) As LastSecond FROM MEMB_LIMITTIME WITH (READUNCOMMITTED) WHERE AccountID = @szAccountID

IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION

SET NOCOUNT OFF
End

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO

CREATE PROCEDURE SP_SET_MEMB_LIMITTIME_PLAYTIME
@szAccountID varchar(10),
@iAddPlayTime int
As
Begin
BEGIN TRANSACTION

SET NOCOUNT ON

IF NOT EXISTS ( SELECT AccountID FROM MEMB_LIMITTIME WITH (READUNCOMMITTED) WHERE AccountID = @szAccountID)
BEGIN
INSERT MEMB_LIMITTIME VALUES(@szAccountID, @iAddPlayTime, 0, GetDate())
END
ELSE
BEGIN
UPDATE MEMB_LIMITTIME SET AddPlayTime = @iAddPlayTime, LastLogoutDate = GetDate() WHERE AccountID = @szAccountID
END

IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION

SET NOCOUNT OFF
End

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO

CREATE PROCEDURE SP_SET_MEMB_LIMITTIME_RESTTIME
@szAccountID varchar(10),
@iAddRestTime int
As
Begin
BEGIN TRANSACTION

SET NOCOUNT ON

IF NOT EXISTS ( SELECT AccountID FROM MEMB_LIMITTIME WITH (READUNCOMMITTED) WHERE AccountID = @szAccountID)
BEGIN
INSERT MEMB_LIMITTIME VALUES(@szAccountID, 0, @iAddRestTime, GetDate())
END
ELSE
BEGIN
UPDATE MEMB_LIMITTIME SET AddRestTime = @iAddRestTime, LastLogoutDate = GetDate() WHERE AccountID = @szAccountID
END

IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION

SET NOCOUNT OFF
End

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

→转载请注明:唯一奇迹私服网　HTTP://WWW.Onlymu.Com