| Hell_Boy |
09-12-2017 06:14 PM |
رد: ممكن مساعده
_AddLogItem
كود PHP:
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 09/12/2017 05:12:47 م ******/
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
IF (@Operation = 41) and (@ItemRefID = 404915)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 110 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404916)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 111 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404917)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 112 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404918)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 113 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404919)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 114 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404920)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 115 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404921)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 116 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404922)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 117 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404923)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 118 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404924)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 119 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404925)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 120 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404926)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 121 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404927)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 122 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404928)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 123 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404929)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 124 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404930)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 125 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404931)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 126 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404932)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 127 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404933)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 128 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404934)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 129 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404935)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 130 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404936)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 131 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404937)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 132 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404938)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 133 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404939)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 134 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404940)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 135 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404941)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 136 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404942)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 137 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404943)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 138 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404944)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 139 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404945)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 140 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404946)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 141 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404947)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 142 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404948)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 143 Where [CharID] = @CharID
End
IF (@Operation = 41) and (@ItemRefID = 404949)
Begin
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET [HwanLevel] = 144 Where [CharID] = @CharID
End
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
داه اخر رقم وانا محطش في Addtimejob
كود PHP:
6 1397769301 200 1145127506 35 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_6 UIO_SECOND_HWAN_EU_NAME_LEVEL_6
كود PHP:
6 UIO_SECOND_HWAN_CH_NAME_LEVEL_6 UIO_SECOND_HWAN_EU_NAME_LEVEL_6
|
