IF @UniqueCodename LIKE '%MOB%'
BEGIN
DECLARE @HonorPoints INT;
DECLARE @Message VARCHAR(255);
DECLARE @PartyID INT = ISNULL((SELECT PartyID FROM MaxiGuard_User.dbo._PartyData WITH (NOLOCK) WHERE CharID=@KillerCharID), 0);
DECLARE @RegionID INT = (SELECT LatestRegion FROM...