1310 İnventory item silinmesi fixlendi.

[orhankral]

1. Adım Q Anlys

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

2. Q Anlys

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

3. Adım Q Anlys

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

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

4. Adım Q Anlys

USE [KN_ONLINE]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
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 @countnull int
        select @countnull = COUNT(*) from WAREHOUSE where strAccountID = @strAccountID and strwarehousepw is null
        if @countnull > 0 
                set @strWarehousePw = (select strWarehouseNo from KNIGHT_ACCOUNT.dbo.TB_USER where strAccountID = @strAccountID)
                
        UPDATE WAREHOUSE SET strWarehousePw = @strWarehousePw, dwTime = @dwTime, nMoney = @Money, WareHouseData = @strWarehouseData, strSerial = @strSerial WHERE strAccountID = @strAccountID
        
END

Kolay gelsin arkadaşlar.

 

[valtinho]

Cevap: 1310 İnventory item silinmesi fixlendi.

Thanks for release (y)