dataserver e eventserver fixed jpn season4/5
sao reups a pedido de um amigo:
segue as procedures
Código:
USE [MU2003_EVENT_DATA]
GO
/****** Object: StoredProcedure [dbo].[SP_REQ_PCBANG_POINT_INFO2] Script Date: 04/07/2010 19:38:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[SP_REQ_PCBANG_POINT_INFO2]
@unk int,
@AccountID varchar(10)
As
Begin
BEGIN TRANSACTION
SET NOCOUNT ON
DECLARE @PCBANGPOINT INT
DECLARE @YEAR INT
DECLARE @MONTH INT
DECLARE @DAY INT
DECLARE @HOUR INT
IF EXISTS (SELECT * FROM T_PCBANG_POINT_INFO WHERE memb___id = @AccountID)
BEGIN
SELECT @PCBANGPOINT = PCBangPoint, @YEAR = Year, @MONTH = MONTH, @DAY = DAY, @HOUR = Hour FROM T_PCBANG_POINT_INFO WHERE
memb___id = @AccountID
SELECT @PCBANGPOINT As Result, @YEAR As ResetYear, @MONTH As ResetMonth, @DAY As ResetDay, @HOUR As ResetHour
END
ELSE
BEGIN
INSERT INTO T_PCBANG_POINT_INFO (memb___id, PCBangPoint, Year, Month, Day, Hour) VALUES (@AccountID, 0, 2011, 12, 31, 23)
SELECT @PCBANGPOINT = PCBangPoint, @YEAR = YEAR, @MONTH = MONTH, @DAY = DAY, @HOUR = Hour FROM T_PCBANG_POINT_INFO WHERE
memb___id = @AccountID
SELECT @PCBANGPOINT As Result, @YEAR As ResetYear, @MONTH As ResetMonth, @DAY As ResetDay, @HOUR As ResetHour
END
IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION
SET NOCOUNT OFF
End
///////////////
USE [MU2003_EVENT_DATA]
GO
/****** Object: StoredProcedure [dbo].[SP_REQ_PCBANG_POINT_UPDATE2] Script Date: 04/07/2010 19:38:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[SP_REQ_PCBANG_POINT_UPDATE2]
@unk int, /* I dont know what is it, it always 0... */
@AccountID varchar(10),
@PCPoint int,
@ResetYear datetime
As
Begin
BEGIN TRANSACTION
SET NOCOUNT ON
UPDATE T_PCBANG_POINT_INFO SET PCBangPoint=@PCPoint WHERE memb___id = @AccountID
SELECT 1 As Result
IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION
SET NOCOUNT OFF
End
USE [MU2003_EVENT_DATA]
GO
/****** Object: Table [dbo].[T_PCBANG_POINT_INFO] Script Date: 04/07/2010 19:41:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
//////////////
CREATE TABLE [dbo].[T_PCBANG_POINT_INFO](
[memb___id] [varchar](10) NOT NULL,
[PCBangPoint] [int] NOT NULL,
[Hour] [smallint] NULL,
[Year] [smallint] NULL,
[Month] [smallint] NULL,
[Day] [smallint] NULL,
CONSTRAINT [PK_T_PCBANG_POINT_INFO] PRIMARY KEY CLUSTERED
(
[memb___id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[T_PCBANG_POINT_INFO] ADD CONSTRAINT [DF_T_PCBANG_POINT_INFO_PCBangPoint] DEFAULT ((0)) FOR [PCBangPoint]
GO
/////////////////
CREATE PROCEDURE SP_REG_ILLUSION_TEMPLE_RANKPOINT
@AccountID varchar(10),
@Name varchar(10),
@Server_code smallint,
@IT_Number tinyint,
@Class smallint,
@Level int,
@Win tinyint,
@iPCRoom int,
@ExpGained int
AS
BEGIN
BEGIN TRANSACTION
SET NOCOUNT ON
DECLARE @Wins INT
DECLARE @Exp INT
IF EXISTS (SELECT * FROM T_Illusion_Temple_Rank WHERE AccountID = @AccountID AND Name = @Name)
BEGIN
SELECT @Wins = Wins, @Exp = Exp FROM T_Illusion_Temple_Rank WHERE AccountID = @AccountID AND Name = @Name
UPDATE T_Illusion_Temple_Rank SET Level = @Level, Class = @Class, IT_Number = @IT_Number, Wins = @Wins + @Win, Exp = @Exp + @ExpGained WHERE AccountID = @AccountID AND Name = @Name
END
ELSE
BEGIN
INSERT INTO T_Illusion_Temple_Rank VALUES (@AccountID, @Name, @Class, @Level, @IT_Number, @Wins, @Exp)
END
IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION
SET NOCOUNT OFF
END
GO
/////////////////
CREATE TABLE [dbo].[T_Illusion_Temple_Rank] (
[AccountID] [varchar] (10) COLLATE Finnish_Swedish_CI_AS NULL ,
[Name] [varchar] (10) COLLATE Finnish_Swedish_CI_AS NULL ,
[Class] [smallint] NULL ,
[Level] [smallint] NULL ,
[IT_Number] [smallint] NULL ,
[Wins] [int] NULL ,
[Exp] [int] NULL
) ON [PRIMARY]
GO
//////////////
[Only registered and activated users can see links. Click Here To Register...]
