1310+ Warehouse/Inventory kayıt problemi çözümü

[Nero 846]

Spoiler

 

-- Use CREATE PROCEDURE instead of ALTER PROCEDURE if you don't already have this procedure

ALTER PROCEDURE [dbo].[UPDATE_WAREHOUSE_PW]

        @strAccountID varchar(21),

        @strWarehousePw varchar(20),

        @Money int,

        @dwTime int,

        @strWarehouseData varchar(1600),

        @strSerial varchar(1600)

AS

BEGIN

        DECLARE @FirstRun int

        SELECT @FirstRun = COUNT(*) FROM WAREHOUSE WHERE strAccountID = @strAccountID AND strWarehousePw IS NULL



        IF @FirstRun = 0

        BEGIN

                SELECT @strWarehousePw = strWarehouseNo FROM TB_USER WHERE strAccountID = @strAccountID

  END         



  UPDATE WAREHOUSE SET strWarehousePw = @strWarehousePw, dwTime = @dwTime, nMoney = @Money, WareHouseData = @strWarehouseData, strSerial = @strSerial WHERE strAccountID = @strAccountID

END



ALTER  PROCEDURE [dbo].[UPDATE_WAREHOUSE]

        @accountid              varchar(21),

        @Money          int,

        @dwTime        int,

        @strItem                varchar(1600),

        @strSerial              varchar(1600)

AS

UPDATE  WAREHOUSE

Set

        nMoney          = @Money,

        dwTime          = @dwTime,

        WarehouseData  = @strItem,

        strSerial              = @strSerial

WHERE  strAccountID    = @accountid



ALTER  PROCEDURE [dbo].[UPDATE_USER_DATA]

        @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        smallint,       -- @Points (and Points in USERDATA) need to be smallint

        @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



DECLARE @KnightsIndex smallint



IF @Zone > 2            -- battle zone user

BEGIN

        SELECT @KnightsIndex=Knights FROM USERDATA WHERE strUserId=@id

        IF @KnightsIndex = -1  -- expel user

        BEGIN

                SET @Knights = 0

                SET @Fame = 0

        END

END



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.22

        UpdateTime        = getdate()

WHERE  strUserId      = @id