ShardManager process reduce + reduce log + delete logs

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

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

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

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

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