Scroll Dye Glows wrong Damage

06/25/2018 14:40 pablitto18#1
Hello everyone ... I'm trying to put the Glows scroll for the weapons and I have the following problem ...
Normal Weapon

[Only registered and activated users can see links. Click Here To Register...]

After

[Only registered and activated users can see links. Click Here To Register...]

Code:
USE [_ELYSON_EXT]
GO
/****** Object:  StoredProcedure [dbo].[_DyeSysWepSP]    Script Date: 25/6/2018 09:35:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


-------------------------------------------------------------------------------------------------------------------
-- Step 2
-- ±âÁ¸ ¾ÆÀÌÅÛ ·Î±× ÀÔ·Â Stored procedure ¼öÁ¤
-- DataBase			: Shard Log  
ALTER  procedure [dbo].[_DyeSysWepSP]  
    [MENTION=395373]Chari[/MENTION]D  int,  
    [MENTION=1134588]item[/MENTION]RefID int

  as  

             
             DECLARE   [MENTION=1134588]item[/MENTION]ID	int
                       [MENTION=6278456]refit[/MENTION]emID int
                       [MENTION=361045]color[/MENTION] varchar(16)
                       [MENTION=2013988]Raret[/MENTION] varchar(16)
                       [MENTION=1706850]nitem[/MENTION] int
                    ,@DG INT
                    
                    ,@T1 tinyint 
                    ,@T2 tinyint 
                    ,@T3 tinyint
                    ,@T4 tinyint
       SELECT   [MENTION=361045]color[/MENTION] = CASE WHEN   [MENTION=1134588]item[/MENTION]RefID = '42316' THEN 'BLUE'
                            WHEN   [MENTION=1134588]item[/MENTION]RefID = '42317' THEN 'BODH'
                            WHEN   [MENTION=1134588]item[/MENTION]RefID = '42318' THEN 'BODZ'
                            WHEN   [MENTION=1134588]item[/MENTION]RefID = '42319' THEN 'FIRE'
                            WHEN   [MENTION=1134588]item[/MENTION]RefID = '42320' THEN 'FIRE_1'
                            WHEN   [MENTION=1134588]item[/MENTION]RefID = '42321' THEN 'GREEN'
                            WHEN   [MENTION=1134588]item[/MENTION]RefID = '42322' THEN 'RED'
                            WHEN   [MENTION=1134588]item[/MENTION]RefID = '42323' THEN 'YELLOW'
                            WHEN   [MENTION=1134588]item[/MENTION]RefID = '42324' THEN 'RAINBOW'
                            WHEN   [MENTION=1134588]item[/MENTION]RefID = '42325' THEN 'PURB'
                            WHEN   [MENTION=1134588]item[/MENTION]RefID = '42326' THEN 'ORANGE'
                            WHEN   [MENTION=1134588]item[/MENTION]RefID = '42327' THEN 'NORMAL'
                            ELSE NULL END         
                    
                    
            SELECT   [MENTION=1134588]item[/MENTION]ID=I.ID64 ,   [MENTION=6278456]refit[/MENTION]emID = I.RefItemID 
            FROM SRO_VT_SHARD.dbo._Items I INNER JOIN SRO_Vt_SHARD.dbo._Inventory Iv
            ON I.ID64 = Iv.ItemID
            WHERE Iv.Slot = '6' AND Iv.CharID =   [MENTION=395373]Chari[/MENTION]D
           
            -- First item 
            SELECT @T1 = TypeID1 , @T2 = TypeID2 , @T3 = TypeID3 , @T4 = TypeID4  , @DG = DG
            FROM _ELYSON_EXT.dbo._DyeSysWep WHERE ID =   [MENTION=6278456]refit[/MENTION]emID
            
            
            -- Secound item
            SELECT   [MENTION=1706850]nitem[/MENTION] = ID FROM _ELYSON_EXT.dbo._DyeSysWep 
            
            WHERE TypeID1 = @T1 
              AND TypeID2 = @T2 
              AND TypeID3 = @T3
              AND TypeID4 = @T4
              AND Color =   [MENTION=361045]color[/MENTION]
              AND DG = @DG
          -- Upcating
          UPDATE SRO_VT_SHARD.dbo._Items SET RefItemID =   [MENTION=1706850]nitem[/MENTION] WHERE ID64 =   [MENTION=1134588]item[/MENTION]ID
Code:
USE [SRO_VT_LOG]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogItem]    Script Date: 25/6/2018 07:57:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


-------------------------------------------------------------------------------------------------------------------
-- Step 2
-- ±âÁ¸ ¾ÆÀÌÅÛ ·Î±× ÀÔ·Â Stored procedure ¼öÁ¤
-- DataBase			: Shard Log  
ALTER  procedure [dbo].[_AddLogItem]  
    [MENTION=395373]Chari[/MENTION]D  int,  
    [MENTION=1134588]item[/MENTION]RefID int,  
    [MENTION=756518]items[/MENTION]erial bigint,  
    [MENTION=2636410]dwda[/MENTION]ta int,  
    [MENTION=5292286]Targets[/MENTION]torage tinyint,  
    [MENTION=1059401]operation[/MENTION] tinyint,  
    [MENTION=5337177]slot_[/MENTION]From tinyint,  
    [MENTION=5337177]slot_[/MENTION]To tinyint,  
    [MENTION=555807]event[/MENTION]Pos varchar(64),  
    [MENTION=812922]sTrd[/MENTION]esc varchar(128),
    [MENTION=442951]gold[/MENTION]		bigint			-- #ifdef EXTEND_GOLD_TYPE »ðÀÔ   
  as

   -- Dye Sys 
  -- Weapon
  
  IF  (    [MENTION=1059401]operation[/MENTION] =   '41') AND    [MENTION=1134588]item[/MENTION]RefID BETWEEN '42316' AND '42327') 
             BEGIN
             EXEC _ELYSON_EXT.dbo._DyeSysWepSP   [MENTION=395373]Chari[/MENTION]D   [MENTION=1134588]item[/MENTION]RefID  
             
             END 
 -- Shield
 IF  (    [MENTION=1059401]operation[/MENTION] =   '41') AND    [MENTION=1134588]item[/MENTION]RefID BETWEEN '42328' AND '42339') 
             BEGIN
             EXEC _ELYSON_EXT.dbo._DyeSysSHSP   [MENTION=395373]Chari[/MENTION]D   [MENTION=1134588]item[/MENTION]RefID  
             
             END
  
   declare   [MENTION=319410]Len[/MENTION]_pos int  
   declare   [MENTION=319410]Len[/MENTION]_desc int  
   set   [MENTION=319410]Len[/MENTION]_pos = len   [MENTION=555807]event[/MENTION]Pos)  
   set   [MENTION=319410]Len[/MENTION]_desc = len   [MENTION=812922]sTrd[/MENTION]esc)  
   if    [MENTION=319410]Len[/MENTION]_pos > 0 and   [MENTION=319410]Len[/MENTION]_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(),   [MENTION=395373]Chari[/MENTION]D,   [MENTION=1134588]item[/MENTION]RefID,   [MENTION=2636410]dwda[/MENTION]ta,   [MENTION=5292286]Targets[/MENTION]torage,   [MENTION=1059401]operation[/MENTION],   [MENTION=5337177]slot_[/MENTION]From,   [MENTION=5337177]slot_[/MENTION]To,   [MENTION=555807]event[/MENTION]Pos,   [MENTION=812922]sTrd[/MENTION]esc,   [MENTION=756518]items[/MENTION]erial,   [MENTION=442951]gold[/MENTION])		-- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
   end  
   else if    [MENTION=319410]Len[/MENTION]_pos > 0 and   [MENTION=319410]Len[/MENTION]_desc = 0)  
   begin  
			insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, Serial64, Gold)			-- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
			values(GetDate(),   [MENTION=395373]Chari[/MENTION]D,   [MENTION=1134588]item[/MENTION]RefID,   [MENTION=2636410]dwda[/MENTION]ta,   [MENTION=5292286]Targets[/MENTION]torage,   [MENTION=1059401]operation[/MENTION],   [MENTION=5337177]slot_[/MENTION]From,   [MENTION=5337177]slot_[/MENTION]To,   [MENTION=555807]event[/MENTION]Pos,   [MENTION=756518]items[/MENTION]erial,   [MENTION=442951]gold[/MENTION])				-- #ifdef EXTEND_GOLD_TYPE ±³Ã¼ 
   end  
   else if    [MENTION=319410]Len[/MENTION]_pos = 0 and   [MENTION=319410]Len[/MENTION]_desc > 0)  
   begin  
			insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, strDesc, Serial64, Gold)			-- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
			values(GetDate(),   [MENTION=395373]Chari[/MENTION]D,   [MENTION=1134588]item[/MENTION]RefID,   [MENTION=2636410]dwda[/MENTION]ta,   [MENTION=5292286]Targets[/MENTION]torage,   [MENTION=1059401]operation[/MENTION],   [MENTION=5337177]slot_[/MENTION]From,   [MENTION=5337177]slot_[/MENTION]To,   [MENTION=812922]sTrd[/MENTION]esc,   [MENTION=756518]items[/MENTION]erial,   [MENTION=442951]gold[/MENTION])					-- #ifdef EXTEND_GOLD_TYPE ±³Ã¼ 
   end  
   else if    [MENTION=319410]Len[/MENTION]_pos = 0 and   [MENTION=319410]Len[/MENTION]_desc = 0)  
   begin  
			insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, Serial64, Gold)						-- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
			values(GetDate(),   [MENTION=395373]Chari[/MENTION]D,   [MENTION=1134588]item[/MENTION]RefID,   [MENTION=2636410]dwda[/MENTION]ta,   [MENTION=5292286]Targets[/MENTION]torage,   [MENTION=1059401]operation[/MENTION],   [MENTION=5337177]slot_[/MENTION]From,   [MENTION=5337177]slot_[/MENTION]To,   [MENTION=756518]items[/MENTION]erial,   [MENTION=442951]gold[/MENTION])							-- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
   end  
   -- À¯·á ¾ÆÀÌÅÛ ±¸ÀÔÀ̸é!  
   -- #define LOG_ITEMEVENT_BUY_CASHITEM  (BYTE)35  
   if    [MENTION=1059401]operation[/MENTION] = 35)  
   begin  
    insert _LogCashItem (RefItemID, CharID, Cnt, EventTime, Serial64)  
    values   [MENTION=1134588]item[/MENTION]RefID,   [MENTION=395373]Chari[/MENTION]D,   [MENTION=2636410]dwda[/MENTION]ta, GetDate(),   [MENTION=756518]items[/MENTION]erial)  
   end
_DyeSysWepSP

RefObjCommon

RefObjItem

UPDATE

Solved Item Wrong Damage

BUT now when the weapon is moon or sun and i use the scroll that change the weapon to Star i don't know why

Solved all - sorry for bothering xd

y db is wrong Type1,2,3,4 just con edit Type4 and change 3 2 1 this is how producer select Type weapon