Plus Notice !!!!!

[Hamza FiGo]

I made the DB side. now the prog side. Someone tell me what should i do with the prog.



Ty

[Crue*]

use your brain and read which info program needs

[Hamza FiGo]

Originally Posted by Crue*

use your brain and read which info program needs

I know what do u mean bro. The thing i don`t know is ( Host/IP )

What exactly i write in here. I already wrote the IP. it gives an error.

[x*Manu*x]

put your sql information in the textboxes:

...\SQLEXPRESS
SRO_VT_LOG
SQLUSERNAME
SQLPASSWORD

and please give a feedback if it worked

[Hamza FiGo]

Originally Posted by x*Manu*x

put your sql information in the textboxes:

...\SQLEXPRESS
SRO_VT_LOG
SQLUSERNAME
SQLPASSWORD

and please give a feedback if it worked

aha Ty i`ll try this.

[Crue*]

Originally Posted by hamzafigo

I know what do u mean bro. The thing i don`t know is ( Host/IP )

What exactly i write in here. I already wrote the IP. it gives an error.

sql username

[Hamza FiGo]

ya ty guys, It works. but the max + is +7

+8+++ nothing appeared

[Crue*]

show me addlogitem proc

[Hamza FiGo]

Now i tried to edit it. But it goes from +1 +2 ++ to 20
i just need from +7 to +20

USE [SRO_VT_SHARDLOG]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogItem]    Script Date: 13/11/2014 03:20:29 ص ******/
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 > 20 and @strDesc_separado < 6) 
        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

if(@strDesc_separado > 20 and @strDesc_separado < 6)

was

if(@strDesc_separado > 7 and @strDesc_separado < 16)

Edit: Ty guys. FIXED.

[badfist]

you know this "plus notice" will make your server to have lag like hell? because he connect to db at every 10 second.

[​Exo]

Originally Posted by badfist

you know this "plus notice" will make your server to have lag like hell? because he connect to db at every 10 second.

Guess it's easily fixed tho, just keep the connection opened.

[Hamza FiGo]

Ty guys for replaying. I just disabled it. and ya it cus a lil laggy