![[PAYLAŞIM] v1311 Banka itemleri relogda silinmesi (FİX) 11799266115352909643](https://2img.net/h/hizliupload.com/img/11799266115352909643.png)
Anasayfa
Latest images
![[ - KoPvP-City / Site Sahibi - ]](https://2img.net/h/www.hizliupload.com/img/73208841549281992712.png "[ - KoPvP-City / Site Sahibi - ]")
![[PAYLAŞIM] v1311 Banka itemleri relogda silinmesi (FİX) 41886997910176512190](https://2img.net/h/www.hizliupload.com/img/41886997910176512190.png)
![[PAYLAŞIM] v1311 Banka itemleri relogda silinmesi (FİX) 39916603645653072848](https://2img.net/h/www.hizliupload.com/img/39916603645653072848.png)
tarafından 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 ;
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
Kod 2
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
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
Bankaya Bazı koyduğunuz itemler v1311'de silinmekte Biraz araştırma
yaparak ve Birazda Çalışarak sizlere Sunayım dedim ;
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
Kod 2
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
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
