[Release] Global Plus Logs ( With item Name )

[Eslam Galull]

so use normal notice writer

[spinal2]

Originally Posted by its.soul

so use normal notice writer

Have some one u know work correct ?

[Baka1338]

when i try execute in _addlogitem got this error any solution


Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 80
Must declare the scalar variable "@strDesc_separado".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 90
Must declare the scalar variable "@strDesc_separado".

[Baka1338]

yea ik it's wrong and try to write it not copy/paste and same

so i need right query to edit it if some1 can
and still gettin th weird problem when i eedit it in addlogitem

Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 80
Must declare the scalar variable "@strDesc_separado".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 90
Must declare the scalar variable "@strDesc_separado".

[XxGhostSpiriTxX]

pliss help

Mens 137, Level 15, State 2, Procedure _AddLogItem, Line 398
You must declare the scalar variable "strDesc_separado".
Mens 137, Level 15, State 2, Procedure _AddLogItem, Line 408
You must declare the scalar variable "strDesc_separado".

[Dev Microsoft]

Usful broh (Y)

[[GM]HeroZ]

Cool

[VORTEX*]

Originally Posted by 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

i Love Ur Work's

[forexjsr]

thanks sir