IF @Operation = 16 AND @ItemRefID = 36790 BEGIN DECLARE @JID INT, @Silk INT = 1000;
SET @JID = UserJID FROM SRO_VT_ACCOUNT.._User WHERE CharID = @CharID
IF EXISTS (SELECT JID FROM SRO_VT_ACCOUNT..SK_Silk WHERE JID = @JID) BEGIN UPDATE SRO_VT_ACCOUNT..SK_Silk SET silk_own += @Silk WHERE JID = @JID END ELSE BEGIN INSERT INTO SRO_VT_ACCOUNT..SK_Silk SELECT @JID, @Silk, 0, 0 END END