CREATE PROCEDURE dbo.[Forum_User_Update]
    (
      @UserId INT,
      @UserAvatar INT,
      @Avatar NVARCHAR(255),
      @AdditionalAvatars NVARCHAR(255),
      @Signature NVARCHAR(1024),
      @IsTrusted BIT,
      @EnableOnlineStatus BIT,
      @ThreadsPerPage INT,
      @PostsPerPage INT,
      @EnableModNotification BIT,
      @EnablePublicEmail BIT,
      @EmailFormat INT,
      @PortalID INT,
      @LockTrust BIT,
      @EnableProfileWeb BIT,
      @EnableDefaultPostNotify BIT,
      @EnableSelfNotifications BIT,
      @IsBanned BIT,
      @LiftBanDate DATETIME,
      @StartBanDate DATETIME
    )
AS
    UPDATE  dbo.Forum_Users
    SET     [UserAvatar] = @UserAvatar,
            [Avatar] = @Avatar,
            [AdditionalAvatars] = @AdditionalAvatars,
            [Signature] = @Signature,
            [IsTrusted] = @IsTrusted,
            [EnableOnlineStatus] = @EnableOnlineStatus,
            [ThreadsPerPage] = @ThreadsPerPage,
            [PostsPerPage] = @PostsPerPage,
            [EnableModNotification] = @EnableModNotification,
            [EnablePublicEmail] = @EnablePublicEmail,
            [EmailFormat] = @EmailFormat,
            [LockTrust] = @LockTrust,
            [EnableProfileWeb] = @EnableProfileWeb,
            [EnableDefaultPostNotify] = @EnableDefaultPostNotify,
            [EnableSelfNotifications] = @EnableSelfNotifications,
            [IsBanned] = @IsBanned,
            [LiftBanDate] = @LiftBanDate,
            [StartBanDate] = @StartBanDate
    WHERE   [UserID] = @UserID
            AND [PortalID] = @PortalID

GO