Plus Auto Notice(Sample + Source)

[Caosfox]

yup, love your work!
even if for you took only 1 hour... for me is almost impossible ( but google is my best friend ^^)
works perfect to save globals and notices to db ( with some modifications, ofc), but logdb is going to scream for mercy if do that
maybe can make another db so save it... but lazy

 

[Comandante]

yup, love your work!
even if for you took only 1 hour... for me is almost impossible ( but google is my best friend ^^)
works perfect to save globals and notices to db ( with some modifications, ofc), but logdb is going to scream for mercy if do that
maybe can make another db so save it... but lazy

My SQL server using a lot of RAM. So i must use another version of this for a stable server with good performance. I'm decreasing logging level to minimum. Only some kind of items and GM commands. Logging them to txt from DB and then deleting the original one from DB. Otherwise SQL usage will be so high.

 

[Caosfox]

true that.

indeed is better for the db to write to text file and the program works faster ( dont even need to write from db to txt, simply to program to txt)

 

[BlackRoseGaming]

niceeee

 

[matrixasd2]

Can You Help Me ..
There A problem , Table _itemPluslog is Loading Fine .

The Table of PlusNotice is Empty Nothing Load

How Can Fix This Table To Make Him Loading

 

[Showtek]

Something wrong, If PlusNotice table clean - spamming clean notices every 10 sec, If I pluss item, notices gone, whats wrong?
AddLogItem:

USE [SRO_VT_LOG]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogItem]    Script Date: 6/14/2013 8:45:54 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO



------------------------------------------------------------------------------------------------------------------- 
-- Step 2 
-- ±âÁ¸ ¾ÆÀÌÅÛ ·Î±× ÀÔ·Â Stored procedure ¼öÁ¤ 
-- DataBase            : Shard Log   
ALTER  procedure [dbo].[_AddLogItem]  
  @CharID  int,   
  @ItemRefID int,   
  @ItemSerial bigint,   
  @dwData int,   
  @TargetStorage tinyint,   
  @Operation tinyint,   
  @Slot_From tinyint,   
  @Slot_To tinyint,   
  @EventPos varchar(64),   
  @strDesc varchar(128), 
  @Gold         bigint          -- #ifdef EXTEND_GOLD_TYPE »ðÀÔ 
  as   
   declare @len_pos int   
   declare @len_desc int  
   declare @strDesc_separado varchar(128)  
   declare  @len_desc1 int 
   set @len_pos = len(@EventPos)   
   set @len_desc = len(@strDesc)   
   if (@len_pos > 0 and @len_desc > 0)   
   begin   
                        insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, strDesc, Serial64, Gold)    -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼ 
                        values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @strDesc, @ItemSerial, @Gold)              -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼ 
   end   
   else if (@len_pos > 0 and @len_desc = 0)   
   begin   
                        insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, Serial64, Gold)                     -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼ 
                        values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @ItemSerial, @Gold)                                -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼  
   end   
   else if (@len_pos = 0 and @len_desc > 0)   
   begin   
                        insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, strDesc, Serial64, Gold)                      -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼ 
                        values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @strDesc, @ItemSerial, @Gold)                                 -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼  
   end   
   else if (@len_pos = 0 and @len_desc = 0)   
   begin   
                        insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, Serial64, Gold)                                               -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼ 
                        values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @ItemSerial, @Gold)                                                   -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼ 
   end   
   -- À¯·á ¾ÆÀÌÅÛ ±¸ÀÔÀ̸é!   
   -- #define LOG_ITEMEVENT_BUY_CASHITEM  (BYTE)35   
   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(@strDesc_separado >= 8) 
                begin 
                --set @strDesc_separado = @len_desc1 
          insert _LogItemPlus(CharID, Serial64, Plus, Data, Lido) values(@CharID, @ItemSerial, @strDesc_separado, GetDate(), '0')   
        end  
   end 
   if(@Operation = 90)
   begin
        declare @iname varchar(129)
        declare @iid int
        declare @cname varchar(64)
        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 @cname = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
        insert PlusNotice(Sent, Message)values(0,@cname + ' has increased ' + @iname + ' to [lvl ' + CAST(@strDesc_separado AS NVARCHAR) + ']') 
  end

PlusNotice:

USE [SRO_VT_LOG]
GO

/****** Object:  Table [dbo].[PlusNotice]    Script Date: 6/14/2013 8:46:55 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[PlusNotice](
	[Sent] [int] NOT NULL,
	[message] [varchar](max) NOT NULL,
	[Date] [datetime] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[PlusNotice] ADD  CONSTRAINT [DF_PlusNotice_Sent]  DEFAULT ((0)) FOR [Sent]
GO

ALTER TABLE [dbo].[PlusNotice] ADD  CONSTRAINT [DF_PlusNotice_Date]  DEFAULT (getdate()) FOR [Date]
GO

1	Hardy has increased ITEM_CH_NECKLACE_09_A_RARE to [lvl 8]	2013-06-14 08:43:01.393

 

[matrixasd2]

EveryThing Now Work Fine .. Left Something , Auto Notice Don't write notice in Game ..



Please Tell Me How Can Fix The Auto Notice To Write in Server

 

[Showtek]

Same for me ^^

 

[matrixasd2]

everything Fine Like You , DB Work Fine Now ,, Last Thing To Be Everything Done Auto Notice Write

 

[elitebi]

if you are using a gateway port other than 15779, it will not work.

 

[Showtek]

if you are using a gateway port other than 15779, it will not work.

Nope, it is 15779.

 

[egsro]

there is no problem with the sql scripts !!
The problem based on the exe file
create your own or fix his source code

 

[Showtek]

there is no problem with the sql scripts !!
The problem based on the exe file
create your own or fix his source code

Stop writing like this please!

 

[Comandante]

Can someone explain me the issue. i still don't get it so i'll release a fix


Edit: Try now released a new one

 

[Kira]

Link Not work !

 

[Comandante]

Link Not work !

It does.

 

[matrixasd2]

It does.

i will Try The New Release ..

 

[Comandante]

i will Try The New Release ..

Let me know the result

 

[matrixasd2]

This Version Doesn't Load AnyThing .. The Auto Notice Empty . DB loading Fine .. Check

 

[Comandante]

This Version Doesn't Load AnyThing .. The Auto Notice Empty . DB loading Fine .. Check

View attachment 132510View attachment 132511

I've just checked the application and it's working fine. Be sure that it's connecting to DB succesfuly + It won't send notice while Sent column is 1