1 den fazla görev alınmama ve relogda görevin düşmesi

[aliemre123 25]

2. görevi almaya çalıştığımda görevleri bitirip alın uyarısı geliyor ve görevi alıp relog attıgımda aldıgım görev kayboluyor ve yapılmıyor. çözümü nedir şimdiden teşekkürler

[KODevelopers 442]

Quendhandler.cpp bakın ve

UPDATE_USER_DATA

Bakın belki log cıkarıyordur incellemek gerekiyor

[aliemre123 25]

Alıntı

Quendhandler.cpp bakın ve

UPDATE_USER_DATA

Bakın belki log cıkarıyordur incellemek gerekiyor

update_user_datada sorun yok gibi duruyor

/*    ==Scripting Parameters==


    Source Server Version : SQL Server 2016 (13.0.4001)

    Source Database Engine Edition : Microsoft SQL Server Enterprise Edition

    Source Database Engine Type : Standalone SQL Server


    Target Server Version : SQL Server 2017

    Target Database Engine Edition : Microsoft SQL Server Standard Edition

    Target Database Engine Type : Standalone SQL Server

*/


USE [kn_online]

GO

/****** Object:  StoredProcedure [dbo].[UPDATE_USER_DATA]    Script Date: 1.10.2017 23:36:41 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO


ALTER PROCEDURE [dbo].[UPDATE_USER_DATA]

@strCharID char(21),

@bNation tinyint,

@bRace tinyint,

@sClass smallint,

@nHair int,

@bRank tinyint,

@bTitle tinyint,

@bLevel tinyint,

@iExp bigint,

@nLoyalty int,

@bFace tinyint,

@bCity tinyint,

@sClanID smallint,

@bFame tinyint,

@sHp smallint,

@sMp smallint,

@sSp smallint,

@bStr tinyint,

@bSta tinyint,

@bDex tinyint,

@bIntel tinyint,

@bCha tinyint,

@bAuthority tinyint,

@sPoints smallint,		

@nCoins int,

@bZone tinyint,

@sBind smallint,

@iPosX int,

@iPosZ int,

@iPosY int,

@dwTime int,

@sQuestCount smallint,

@strSkill varchar(10),

@strItem binary(584),

@strSerial binary(584),

@strQuest binary(600),

@nMannerPoint int,

@nLoyaltyMonthly int,

@strItemTime binary(584),

@strMemo char(21),

@sGenieTime smallint,

@strGenieOptions char(100)

AS


UPDATE USERDATA 

SET Nation			= @bNation, 

	Race			= @bRace, 

	Class			= @sClass, 

	HairRGB			= @nHair, 

	[Rank]			= @bRank, 

	Title			= @bTitle, 

	[Level]			= @bLevel, 

	[Exp]			= @iExp, 

	Loyalty			= @nLoyalty, 

	Face			= @bFace, 

	City			= @bCity, 

	Knights			= @sClanID, 

	Fame			= @bFame, 

	Hp				= @sHp, 

	Mp				= @sMp, 

	Sp				= @sSp, 

	Strong			= @bStr, 

	Sta				= @bSta, 

	Dex				= @bDex, 

	Intel			= @bIntel, 

	Cha				= @bCha, 

	Authority		= @bAuthority, 

	Points			= @sPoints, 

	Gold			= @nCoins, 

	[Zone]			= @bZone, 

	Bind			= @sBind, 

	PX				= @iPosX, 

	PZ				= @iPosZ, 

	PY				= @iPosY, 

	dwTime			= @dwTime, 

	strSkill		= @strSkill, 

	strItem			= @strItem, 

	strSerial		= @strSerial, 

	sQuestCount		= @sQuestCount, 

	strQuest		= @strQuest, 

	MannerPoint		= @nMannerPoint, 

	LoyaltyMonthly	= @nLoyaltyMonthly, 

	strItemTime		= @strItemTime, 

	strMemo			= @strMemo,

	sGenieTime		= @sGenieTime,

	strGenieOptions = @strGenieOptions,

	dtUpdateTime	= GETDATE() 

WHERE strUserID		= @strCharID

questhandlerda ne yapacağımı bilmiyorum

[YNG 55]

Alıntı

update_user_datada sorun yok gibi duruyor

/*    ==Scripting Parameters==


    Source Server Version : SQL Server 2016 (13.0.4001)

    Source Database Engine Edition : Microsoft SQL Server Enterprise Edition

    Source Database Engine Type : Standalone SQL Server


    Target Server Version : SQL Server 2017

    Target Database Engine Edition : Microsoft SQL Server Standard Edition

    Target Database Engine Type : Standalone SQL Server

*/


USE [kn_online]

GO

/****** Object:  StoredProcedure [dbo].[UPDATE_USER_DATA]    Script Date: 1.10.2017 23:36:41 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO


ALTER PROCEDURE [dbo].[UPDATE_USER_DATA]

@strCharID char(21),

@bNation tinyint,

@bRace tinyint,

@sClass smallint,

@nHair int,

@bRank tinyint,

@bTitle tinyint,

@bLevel tinyint,

@iExp bigint,

@nLoyalty int,

@bFace tinyint,

@bCity tinyint,

@sClanID smallint,

@bFame tinyint,

@sHp smallint,

@sMp smallint,

@sSp smallint,

@bStr tinyint,

@bSta tinyint,

@bDex tinyint,

@bIntel tinyint,

@bCha tinyint,

@bAuthority tinyint,

@sPoints smallint,		

@nCoins int,

@bZone tinyint,

@sBind smallint,

@iPosX int,

@iPosZ int,

@iPosY int,

@dwTime int,

@sQuestCount smallint,

@strSkill varchar(10),

@strItem binary(584),

@strSerial binary(584),

@strQuest binary(600),

@nMannerPoint int,

@nLoyaltyMonthly int,

@strItemTime binary(584),

@strMemo char(21),

@sGenieTime smallint,

@strGenieOptions char(100)

AS


UPDATE USERDATA 

SET Nation			= @bNation, 

	Race			= @bRace, 

	Class			= @sClass, 

	HairRGB			= @nHair, 

	[Rank]			= @bRank, 

	Title			= @bTitle, 

	[Level]			= @bLevel, 

	[Exp]			= @iExp, 

	Loyalty			= @nLoyalty, 

	Face			= @bFace, 

	City			= @bCity, 

	Knights			= @sClanID, 

	Fame			= @bFame, 

	Hp				= @sHp, 

	Mp				= @sMp, 

	Sp				= @sSp, 

	Strong			= @bStr, 

	Sta				= @bSta, 

	Dex				= @bDex, 

	Intel			= @bIntel, 

	Cha				= @bCha, 

	Authority		= @bAuthority, 

	Points			= @sPoints, 

	Gold			= @nCoins, 

	[Zone]			= @bZone, 

	Bind			= @sBind, 

	PX				= @iPosX, 

	PZ				= @iPosZ, 

	PY				= @iPosY, 

	dwTime			= @dwTime, 

	strSkill		= @strSkill, 

	strItem			= @strItem, 

	strSerial		= @strSerial, 

	sQuestCount		= @sQuestCount, 

	strQuest		= @strQuest, 

	MannerPoint		= @nMannerPoint, 

	LoyaltyMonthly	= @nLoyaltyMonthly, 

	strItemTime		= @strItemTime, 

	strMemo			= @strMemo,

	sGenieTime		= @sGenieTime,

	strGenieOptions = @strGenieOptions,

	dtUpdateTime	= GETDATE() 

WHERE strUserID		= @strCharID

questhandlerda ne yapacağımı bilmiyorum

sourceden bak..

[aliemre123 25]

güncel

[CerfiN 68]

Breakpoint koyarak bak nerede sıkıntı çıkarıyor. DB'ye kaydediyor mu görevleri USERDATA'yı güncelliyor mu.

[aliemre123 25]

Alıntı

Breakpoint koyarak bak nerede sıkıntı çıkarıyor. DB'ye kaydediyor mu görevleri USERDATA'yı güncelliyor mu.

breakpoint ile herhangi bir hata çıkmadı.

şuan hiç görev alamıyorum.