Code:
CREATE PROCEDURE [dbo].[_DyeSwitching] [MENTION=395373]Chari[/MENTION]D INT, [MENTION=1134588]item[/MENTION]RefID INT
AS
DECLARE [MENTION=361045]color[/MENTION] VARCHAR(50) = CASE
WHEN [MENTION=1134588]item[/MENTION]RefID = 55519 THEN 'RED'
WHEN [MENTION=1134588]item[/MENTION]RefID = 55520 THEN 'BLUE'
WHEN [MENTION=1134588]item[/MENTION]RefID = 55521 THEN 'GOLDEN'
WHEN [MENTION=1134588]item[/MENTION]RefID = 55522 THEN 'GREEN'
END
BEGIN TRY
DECLARE [MENTION=3898309]charname[/MENTION] varchar(64)
UPDATE I Set RefItemID=M2.RefItemID
FROM SRO_VT_SHARD.._Inventory Inv
JOIN SRO_VT_SHARD.._Items I ON Inv.ItemID=I.ID64
JOIN _Models M1 ON I.RefItemID=M1.RefItemID
JOIN _Models M2 ON M2.ItemType=M1.ItemType AND M2.ItemGrade=M1.ItemGrade AND M2.GLOW [MENTION=361045]color[/MENTION] AND M2.Model = M1.Model AND M2.ItemType NOT LIKE '%10_CA_%' AND M2.ItemGrade IN('C_RARE','D_RARE')
WHERE Inv.CharID [MENTION=395373]Chari[/MENTION]D AND Inv.Slot=13 AND Inv.ItemID!=0 AND M2.RefItemID IN(SELECT ID FROM SRO_VT_SHARD.._RefObjCommon WHERE CodeName128 LIKE 'ITEM_%')
IF @@ROWCOUNT = 0
BEGIN
SELECT [MENTION=3898309]charname[/MENTION]=CharName16 FROM SRO_VT_SHARD.._Char WITH(NOLOCK) WHERE CharID [MENTION=395373]Chari[/MENTION]D
DECLARE [MENTION=606027]codename[/MENTION] VARCHAR(max),@AccountName VARCHAR(MAX)
SELECT TOP 1 [MENTION=606027]codename[/MENTION] = Codename128 FROM SRO_VT_SHARD.._RefObjCommon WHERE ID = [MENTION=1134588]item[/MENTION]RefID
SET @AccountName= (SELECT TOP 1 [StrUserID] FROM SRO_VT_SHARD.._User U INNER JOIN SRO_VT_ACCOUNT..TB_User TU ON U.UserJID=TU.JID WHERE [CharID] [MENTION=395373]Chari[/MENTION]D)
declare [MENTION=1134588]item[/MENTION]Codename varchar(100)= (SELECT TOP 1 Codename128 from SRO_VT_SHARD.._RefObjCommon where iD = [MENTION=1134588]item[/MENTION]RefID)
--INSERT SR_Guard.._ScheduledInstantItems SELECT [MENTION=3898309]charname[/MENTION] [MENTION=1134588]item[/MENTION]Codename,1
INSERT SR_Guard.._ChestItems SELECT [MENTION=3898309]charname[/MENTION] [MENTION=1134588]item[/MENTION]Codename,1,GETDATE(),'Dye Switcher',1
INSERT SR_Guard.._AutoPMQueue SELECT [MENTION=3898309]charname[/MENTION],3,'Please put a valid [Seal of Eagle/Sun] item into the first slot of your inventory. The Dye Scroll has been added to your chest',1
END
END TRY
BEGIN CATCH
INSERT _ErrorLog select 1,ERROR_MESSAGE() + ' | '+ ERROR_PROCEDURE(),GetDate()
END CATCH
