Siga-nos em...
Follow us on Twitter Follow us on Facebook Watch us on YouTube
Registro

Alpha Servers
Resultados 1 a 2 de 2
  1. #1

    Avatar de levelx
    Data de Ingresso
    Nov 2010
    Localização
    fail Cave
    Idade
    41
    Posts
    559
    Agradecido
    28
    Agradeceu
    23
    Peso da Avaliação
    23

    Padrão 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
    
    
    //////////////
    [Somente usuários registrados podem vem os links. ]
    Última edição por Segredo; 24-01-2011 às 11:20 AM.
    Hidden Content
    Tip
    "E sem saber que era impossível, ele foi lá e fez"(Jean Cocteau)
    LUCENA ME DEIXOU DE MEMBRO ETERNO E ME DEIXOU UMA SAUDADE ETERNA TBM................
    Hidden Content

  2. #2

    Avatar de hamiltontsz
    Data de Ingresso
    Jan 2010
    Localização
    Goiânia
    Posts
    307
    Agradecido
    5
    Agradeceu
    3
    Peso da Avaliação
    19

    Padrão



    DATA SERVER E JOINSERVER MIRROR MULTIUPLOAD

 

 

Informações de Tópico

Usuários Navegando neste Tópico

Há 1 usuários navegando neste tópico. (0 registrados e 1 visitantes)

Tópicos Similares

  1. |Download| Aion Flash Statistics 1.1 Fixed
    Por OmegaPT no fórum AI | Downloads
    Respostas: 1
    Último Post: 10-04-2012, 05:34 AM
  2. |Download| Comprar Sem Bau DT- Fixed.
    Por gneccao no fórum WebShops
    Respostas: 0
    Último Post: 14-08-2011, 08:15 PM
  3. |Source| 65k Fixed - 97D
    Por Chris7yan no fórum Sources
    Respostas: 8
    Último Post: 09-08-2010, 01:33 PM

Marcadores

Permissões de Postagem

  • Você não pode iniciar novos tópicos
  • Você não pode enviar respostas
  • Você não pode enviar anexos
  • Você não pode editar suas mensagens
  •