Unix bot v1 | Most Advanced Automatic Events

[goda2020]

ممكن لو سمحت البرو سيدور

[Dev.LumiusCux]

المشاركة الأصلية كتبت بواسطة goda2020 عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

ممكن لو سمحت البرو سيدور

 --Start
   declare @strDesc_separado varchar(128) 
         declare  @len_desc1 int 

		  if (@Operation = 35)   
	   begin   
		insert _LogCashItem (RefItemID, CharID, Cnt, EventTime, Serial64)   
		values(@ItemRefID, @CharID, @dwData, GetDate(), @ItemSerial)   
	   end 
	   if (@Operation = 90 OR @Operation = 160)   
	   begin   
	   set @len_desc1 = CHARINDEX (']',@strDesc)  
	  if(@len_desc1 = 9)   
		 begin 
		 set @strDesc = SUBSTRING(@strDesc,0,9) 
		 set @strDesc_separado = SUBSTRING(@strDesc, 8, 1) 
		end 
	   else if(@len_desc1 = 10) 
			begin 
			set @strDesc = SUBSTRING(@strDesc,0,10) 
			set @strDesc_separado = SUBSTRING(@strDesc, 8, 2) 
			end 

	if (@Operation = 90  and @strDesc_separado = 1 and @ItemRefID = 245)

	   begin
	   declare @char1name varchar(64)
	   select @char1name = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID 
	   Declare @Charname varchar(65) = (Select Top 1 CharName from UnixEvents..AlchemyEvent)
	   begin
	   if(@Charname is null or @Charname = '')
	   insert into UnixEvents..AlchemyEvent (CharName,Plus,Itemid,Date) values (@char1name,@strDesc_separado,@ItemRefID,GETDATE())
	   end  
	   end
	   end

 --End

اتقضل حط ده في SHARLOG

و اعمل داتا و سميها UnixEvents و اعمل Execute لدي ده

USE [UnixEvents]
GO

/****** Object:  Table [dbo].[AlchemyEvent]    Script Date: 7/2/2018 9:51:00 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[AlchemyEvent](
	[CharName] [varchar](max) NULL,
	[Plus] [int] NULL,
	[Itemid] [int] NULL,
	[Date] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO