i have bug in grap pet need fix it

IF @[Only registered and activated users can see links. Click Here To Register...] = '114'
BEGIN
DECLARE @[Only registered and activated users can see links. Click Here To Register...] varchar(max) = (SELECT CharName16 from SRO_VT_SHARD.dbo._Char WHERE CharID = @[Only registered and activated users can see links. Click Here To Register...]D),
@[Only registered and activated users can see links. Click Here To Register...]ID INT = (SELECT LatestRegion FROM sro_VT_shard.dbo._Char WHERE CharID = @[Only registered and activated users can see links. Click Here To Register...]D)
DECLARE @[Only registered and activated users can see links. Click Here To Register...]Type1 INT = (SELECT JobType From SRO_VT_SHARD.dbo._CharTrijob Where CharID = @[Only registered and activated users can see links. Click Here To Register...]D )
IF @[Only registered and activated users can see links. Click Here To Register...]ID IN (SELECT wRegionID FROM sro_VT_SHARD.dbo._RefRegion WHERE IsBattleField=0))
IF @[Only registered and activated users can see links. Click Here To Register...]Type1 = 2
BEGIN
DECLARE @[Only registered and activated users can see links. Click Here To Register...]D INT = (SELECT ID FROM sro_VT_shard.dbo._CharCOS WHERE OwnerCharID = @[Only registered and activated users can see links. Click Here To Register...]D )
update SRO_VT_SHARD.._InvCOS SET ItemID = 0 WHERE COSID = @[Only registered and activated users can see links. Click Here To Register...]D
update SRO_VT_SHARD.._CharCos set OwnerCharID = 0 where OwnerCharID = @[Only registered and activated users can see links. Click Here To Register...]D and RefCharID in (select id from SRO_VT_SHARD.._RefObjCommon where CodeName128 like '%COS_t%')
INSERT INTO PlusNotice ([Sent],[Message],[Date]) VALUES ('0','' @[Only registered and activated users can see links. Click Here To Register...]+' : has been spotted trying to break the Trade System!',GetDate())
END
END