[Release] Global Plus Logs ( With item Name )

[EslamGalal]

- same thread title says

this tool record plus logs ( alchemy ) and Global it via a global chat ( same as plus notice but to prevent spam & with item name )


here we go


Execute ! all coming querys & tables in Shard Log

Add this Code into Your _Addlogitem

if(@Operation = 90 ) begin 


---- Plus Global 
if(CAST(@strDesc_separado AS NVARCHAR) > 7 ) 
begin 
declare @iname varchar(129) 
declare @iid int 
declare  [USER=2000184804]CnaM[/USER]eQ varchar(64) 
Declare  [USER=401224]Real[/USER]Name Varchar(Max) 
select @iid = RefItemID from SRO_VT_SHARD.dbo._Items where Serial64 = @ItemSerial 
select @iname = CodeName128 from SRO_VT_SHARD.dbo._RefObjCommon where id = @iid 
Select  [USER=401224]Real[/USER]Name = RealName From SRO_VT_SHARDLOG.dbo._itemsName Where CodeName = @iname 
select  [USER=2000184804]CnaM[/USER]eQ = CharName16 from SRO_VT_SHARD.dbo._Char where CharID =  [USER=551894]Char[/USER]ID 
insert GlobalNotice(Sent, Message)values(0  [USER=2000184804]CnaM[/USER]eQ + ' has increased ' +  [USER=401224]Real[/USER]Name + ' plus To + ' + CAST(@strDesc_separado AS NVARCHAR) ) 
end 
end

​

and add those two tables

USE [SRO_VT_SHARDLOG] GO 

/****** Object: Table [dbo].[GlobalNotice] Script Date: 5/27/2015 10:00:24 PM 

By Eslam Galull 
Skype : eslam.galull 

******/ 
SET ANSI_NULLS ON 
GO 

SET QUOTED_IDENTIFIER ON 
GO 

SET ANSI_PADDING ON 
GO 

CREATE TABLE [dbo].[GlobalNotice]( 
[Sent] [int] NOT NULL, 
[Message] [varchar](300) NOT NULL, 
[Date] [datetime] NOT NULL 
) ON [PRIMARY] 

GO 

SET ANSI_PADDING OFF 
GO 

ALTER TABLE [dbo].[GlobalNotice] ADD CONSTRAINT [DF_GlobalNotice_Sent] DEFAULT ((0)) FOR [Sent] 
GO 

ALTER TABLE [dbo].[GlobalNotice] ADD CONSTRAINT [DF_GlobalNotice_Date] DEFAULT (getdate()) FOR [Date] 
GO

​

USE [SRO_VT_SHARDLOG] GO 

/****** Object: Table [dbo].[_itemsName] 

By Eslam Galull 
Skype : eslam.galull 
Script Date: 5/27/2015 10:01:46 PM ******/ 
SET ANSI_NULLS ON 
GO 

SET QUOTED_IDENTIFIER ON 
GO 

SET ANSI_PADDING ON 
GO 

CREATE TABLE [dbo].[_itemsName]( 
[CodeName] [varchar](max) NULL, 
[2] [varchar](max) NULL, 
[RealName] [varchar](max) NULL, 
[4] [varchar](max) NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] 

GO 

SET ANSI_PADDING OFF 
GO

​

- Well Done Now we need to insert items data insert the following into _itemsName table

btw its till D11 items since the project was build for Galullians Online

the table data in attach just copy & past it

Scan Link​

You must be registered to see links

Download in attach​

 

[denise456]

Query Not Work

 

[EslamGalal]

which one ?

 

[RenePunik]

Query Not Work

You can use SrZor to save Global Chats, and also about Plus Logs you can take it from Devias Log DB. Nothing is new in this thread.