[Release] Global Plus Logs ( With item Name )

[Eslam Galull]

- 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

PHP Code:

   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

PHP Code:

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 


PHP Code:

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


Download in attach

[@$$]

USful thank you

[Eslam Galull]

there is a thanks button in thread

[marko1000]

i need make this plus notice via global start from +14 how?

[Eslam Galull]

Originally Posted by marko1000

i need make this plus notice via global start from +14 how?

update this line

PHP Code:


   ---- Plus Global 
      if(CAST(@strDesc_separado AS NVARCHAR) > 14 ) 
   begin 


[@$$]

will be great if you add save setting button cuz so weried every single close must reset the seting again ^^

[Eslam Galull]

up coming versions will be much pretty than that **** beta test things xD

[TVS]

nice , going to try

[Eslam Galull]

Originally Posted by EnthiseLOL

nice , going to try

enjoy

[ILowe]

hello

programs which source?

[Eslam Galull]

Originally Posted by ILowe

hello

programs which source?

sorry ,what you mean ?

[ILowe]

How can send people to the PM that holding dematerialized log?

PM throw instead of global

[Eslam Galull]

ohh , please re-read the main topic

its simply record the Alchemy Logs . And Global it to ppl like

Global : ILowe Has Plused Sword To +10

[ILowe]

I asked to use it in other works
example : Some information, such as private individuals with PM

[Eslam Galull]

yup you can all you need is just an open source , nd work on it
or the hard way pay me to do it for you