Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server
You last visited: Today at 08:46

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



Scroll Dye Glows wrong Damage

Discussion on Scroll Dye Glows wrong Damage within the SRO Private Server forum part of the Silkroad Online category.

Closed Thread
 
Old   #1
 
elite*gold: 0
Join Date: Mar 2012
Posts: 78
Received Thanks: 15
Scroll Dye Glows wrong Damage

Hello everyone ... I'm trying to put the Glows scroll for the weapons and I have the following problem ...
Normal Weapon



After



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
pablitto18 is offline  
Closed Thread


Similar Threads Similar Threads
Vsro silk scroll and gift scroll doesn't work
10/17/2015 - SRO Private Server - 1 Replies
solved topic can delete
Damage Damage Damage
02/28/2012 - Mabinogi Hacks, Bots, Cheats & Exploits - 3 Replies
Because of poor English grammar may be a bit strange May I ask what damage accumulated or MOD
(ALB) WTS Effect Scroll - Megadolon Drop Scroll
01/09/2012 - Trading - 1 Replies
Im looking for plats just serious offers please
WTT 3X Scroll for Shuta( Come with ur Scroll)(Evengarda)
06/16/2010 - Archlord Trading - 1 Replies
İ want to change 4x Scroll for shuta ... u need to come with ur scroll



All times are GMT +1. The time now is 08:47.


Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.