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
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 @cnameQ varchar(64)
Declare @RealName 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 @RealName = RealName From SRO_VT_SHARDLOG.dbo._itemsName Where CodeName = @iname
select @cnameQ = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
insert GlobalNotice(Sent, Message)values(0,@cnameQ + ' has increased ' + @RealName + ' 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
Download
- All Copyrights Reserved to Eslam Galull @galullians.com 2015
