Giảm lag cho game để test :D

[TS2GVN]

Các bạn có thể chén các này vào theo thứ tự của Stored Procedure của Sro_Vt_Log sẽ giảm lag cho server nhưng ngược lại các thông tin giao dịch và các thứ các bạn sẽ không thấy trong SMC

[/CENTER]

_AddLogChar

USE [SRO_VT_LOG]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogChar]    Script Date: 12/02/2011 11:35:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER   procedure [dbo].[_AddLogChar] 
@CharID        int,
@EventID        tinyint,
@Data1        int,
@Data2        int,
@strPos        varchar(64),
@Desc        varchar(128)
as
    declare @len_pos     int
    declare @len_desc    int
    set @len_pos = len(@strPos)
    set @len_desc = len(@Desc)
    if (@len_pos > 0 and @len_desc > 0)
    begin    
        return -1
    end
    else if (@len_pos > 0 and @len_desc = 0)
    begin    
        return -2
    end
    else if (@len_pos = 0 and @len_desc > 0)
    begin    
        return -3
    end
    else
    begin    
        return -4
    end 

_AddLogItems

USE [SRO_VT_LOG]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogItem]    Script Date: 12/02/2011 11:37:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-------------------------------------------------------------------------------------------------------------------
-- Step 2
-- ±âÁ¸ ¾ÆÀÌÅÛ ·Î±× ÀÔ·Â Stored procedure ¼öÁ¤
-- DataBase            : Shard Log  
ALTER  procedure [dbo].[_AddLogItem]  
  @CharID  int,  
  @ItemRefID int,  
  @ItemSerial bigint,  
  @dwData int,  
  @TargetStorage tinyint,  
  @Operation tinyint,  
  @Slot_From tinyint,  
  @Slot_To tinyint,  
  @EventPos varchar(64),  
  @strDesc varchar(128),
  @Gold        bigint            -- #ifdef EXTEND_GOLD_TYPE »ðÀÔ   
  as  
   declare @len_pos int  
   declare @len_desc int  
   set @len_pos = len(@EventPos)  
   set @len_desc = len(@strDesc)  
   if (@len_pos > 0 and @len_desc > 0)  
   begin  
        return -1
     end  
   else if (@len_pos > 0 and @len_desc = 0)  
   begin  
        return -1
     end  
    else if (@len_pos = 0 and @len_desc > 0)  
   begin  
        return -1
     end  
   else if (@len_pos = 0 and @len_desc = 0)  
   begin  
        return -1
     end  
    -- À¯·á ¾ÆÀÌÅÛ ±¸ÀÔÀ̸é!  
   -- #define LOG_ITEMEVENT_BUY_CASHITEM  (BYTE)35  
   if (@Operation = 35)  
  begin  
        return -1
     end 

_AddLogSchedule

USE [SRO_VT_LOG]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogSchedule]    Script Date: 12/02/2011 11:38:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ·Î±× »ðÀÔ ÇÁ·Î½ÃÀú 
ALTER PROCEDURE [dbo].[_AddLogSchedule] 
    @ServerType VARCHAR(124),
    @ServerBodyID INT,            
    @ScheduleDefine VARCHAR(124),
    @ScheduleIdx INT,
    @nType      VARCHAR(10), 
    @OccureTime DATETIME    -- °¢°¢ÀÇ ¸Ó½ÅÀÇ ½Ã°£À» Àû¾îÁØ´Ù.
AS
   return -1 

_AddLogServerEvent

USE [SRO_VT_LOG]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogServerEvent]    Script Date: 12/02/2011 11:39:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER    procedure [dbo].[_AddLogServerEvent] 
@ServerEventID        int,
@LogType        tinyint,
@Desc            varchar(128)
as
    declare @len_desc    int
    set @len_desc = len(@Desc)
    if ( @len_desc > 0)
    begin  
        return -1
     end  
   else
    begin  
        return -1
     end 

_AddLogSiegeFortress

USE [SRO_VT_LOG]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogSiegeFortress]    Script Date: 12/02/2011 11:40:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER    procedure [dbo].[_AddLogSiegeFortress] 
@FortressID        int,
@EventID        tinyint,
@CharID            int,
@Data1            int,
@Data2            int,
@Desc            varchar(128)
as
    declare @len_desc    int
    set @len_desc = len(@Desc)
    if ( @len_desc > 0)
    begin  
        return -1
     end  
   else
    begin  
        return -1
     end