i need file Dye effect scroll work

01/26/2022 12:50 M@hmoud#1
i need file Dye effect scroll work
03/02/2022 07:36 A N X I#2
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