[PAYLASIM] v1311 Banka itemleri relogda silinmesi (FİX)

[HIDE-REPLY]

1311 Dosyalarının Hepsinde Bu bug vardır. Bankaya Bazı koyduğunuz itemler v1311'de silinmekte Biraz araştırma yaparak ve Birazda Çalışarak sizlere Sunayım dedim ;



Kod:

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

Kod 2



Kod:

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

Kod 3



Kod:

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,[/HIDE-REPLY]​