[Dev.Ri3o]

ال AddlogItem اهو

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogItem]    Script Date: 11/28/2016 10:09:23 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO


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)
		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
				insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, strDesc, Serial64)
				values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @strDesc, @ItemSerial)
			end
			else if (@len_pos > 0 and @len_desc = 0)
			begin
				insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, Serial64)
				values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @ItemSerial)
			end
			else if (@len_pos = 0 and @len_desc > 0)
			begin
				insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, strDesc, Serial64)
				values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @strDesc, @ItemSerial)
			end
			else if (@len_pos = 0 and @len_desc = 0)
			begin
				insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, Serial64)
				values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @ItemSerial)
			end
			-- ىœ*료 ى•„ى‌´ي…œ 구ى‍…ى‌´ë©´!
			-- #define LOG_ITEMEVENT_BUY_CASHITEM		(BYTE)35
			if (@Operation = 35)
			begin
				insert _LogCashItem (RefItemID, CharID, Cnt, EventTime, Serial64)
				values(@ItemRefID, @CharID, @dwData, GetDate(), @ItemSerial)
			end

لو مشتغلش يبقى لازم تعمل Restore لل Database
يعنى ايه مش بيعمل 2 data ؟