USP_FAFSOCIALNETWORKMESSAGE_EDIT

CREATE procedure dbo.USP_FAFSOCIALNETWORKMESSAGE_EDIT
(
  @ID uniqueidentifier,
  @PUBLISHCALLTEXT nvarchar(500), 
  @PUBLISHMESSAGETEXT nvarchar(500), 
  @MISSIONCALLTEXT nvarchar(500), 
  @MISSIONTEXT nvarchar(500), 
  @PUBLISHLOGO int, 
  @CHANGEAGENTID uniqueidentifier = null
)
as

    set nocount on;

  declare @EVENTID uniqueidentifier

    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

    begin try

        -- handle updating the data

        update dbo.FAFEVENTSOCIALNETWORKPROPERTY 
    set
        PUBLISHCALLTEXT = @PUBLISHCALLTEXT,
    PUBLISHMESSAGETEXT = @PUBLISHMESSAGETEXT,
    MISSIONCALLTEXT = @MISSIONCALLTEXT,
    MISSIONTEXT = @MISSIONTEXT,
    PUBLISHLOGO = @PUBLISHLOGO,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = getdate(),
    ISEMPTY = 0

        from dbo.FAFEVENTSOCIALNETWORKPROPERTY (NOLOCK)
        where ID = @ID

    set @EVENTID = (select EventID from dbo.FAFEVENTSOCIALNETWORKPROPERTY where ID = @ID)

    update EVENTEXTENSION set ISNEWSOCIALNETWORK = 1 where EVENTID = @EVENTID

    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;