CREATE PROCEDURE [dbo].[UMG_UPDATE_USER_DATA2]
    @id         VARCHAR(21),
    @Nation tinyint,
    @Race       tinyint,
    @Class      SMALLINT,
    @HairColor  tinyint,
    @Rank       tinyint,
    @Title      tinyint,
    @Level      tinyint,
    @EXP        INT,
    @Loyalty    INT,
    @Face       tinyint,
    @City       tinyint,
    @Knights    SMALLINT,
    @Fame       tinyint,
    @Hp     SMALLINT,
    @Mp     SMALLINT,
    @Sp     SMALLINT,
    @Str        tinyint,
    @Sta        tinyint,
    @Dex        tinyint,
    @Intel      tinyint,
    @Cha        tinyint,
    @Authority  tinyint,
    @Points     tinyint,
    @Gold       INT,
    @Zone       tinyint,
    @Bind       SMALLINT,
    @PX     INT,
    @PZ     INT,
    @PY     INT,
    @dwTime INT,
    @QuestTotal     SMALLINT,
    @strSkill   VARCHAR(20),
    @strItem    VARCHAR(400),
    @strSerial  VARCHAR(400),
    @strQuest   VARCHAR(400),
    @MannerPoint   INT,
    @LoyaltyMonthly INT
AS

UPDATE  USERDATA
SET
    Nation      = @Nation,
    Race        = @Race,
    Class       = @Class,
    HairColor   = @HairColor,
    Rank        = @Rank,
    Title       = @Title,
    [Level]     = @Level,
    [EXP]       = @EXP,
    Loyalty     = @Loyalty,
    Face        = @Face,
    City        = @City,
    Knights     = @Knights,
    Fame        = @Fame,
    Hp      = @Hp,
    Mp      = @Mp,
    Sp      = @Sp,
    Strong      = @Str,
    Sta     = @Sta,
    Dex     = @Dex,
    Intel       = @Intel,
    Cha     = @Cha,
    Authority   = @Authority,
    Points      = @Points,
    Gold        = @Gold,
    [Zone]      = @Zone,
    Bind        = @Bind,
    PX      = @PX,
    PZ      = @PZ,
    PY      = @PY,
    dwTime      = @dwTime,
    strSkill        = @strSkill,
    strItem     = @strItem,
    strSerial       = @strSerial,   -- 2002 11. 12
    sQuestCount = @QuestTotal,  -- 2003.04.09
    strQuest        = @strQuest,    -- 2003.04.09
    MannerPoint     = @MannerPoint, -- 2004.01.30
    LoyaltyMonthly  = @LoyaltyMonthly   -- 2004.04.29
WHERE   strUserId   = @id