BLESSING

[Zeljian]

Hi Epvpvers regarding to blessing of fashion,. do i need to remove some code in sql to avoid database error to make run normally the fashion with blessing can be tradable??

i got this error

 Spoiler

2017/12/19 20:25:12
query:uspLoggingTrade @pFlag=2, @deID=1513686305, @ndex='01', @pidPlayer='0000004', @mIndex='24558', @mSerialNum=1372506561, @mCnt=1, @pAbilityOpt=0, @mResist=0, @stAbilityOpt=0 @mOpt=1387606559738305536
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2017/12/19 20:25:12
query:uspLoggingTrade @pFlag=2, @deID=1513686305, @ndex='01', @pidPlayer='0000004', @mIndex='24558', @mSerialNum=1372506561, @mCnt=1, @pAbilityOpt=0, @mResist=0, @stAbilityOpt=0 @mOpt=1387606559738305536
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2017/12/19 20:25:12
query:LOG_ITEM_STR @im_szName='mehoh',@iserverindex='01',@im_GetszNam e='Zeljian',@idwWorldID=1,@im_dwGold=645005,@im_nR emainGold=645005,@iItem_UniqueNo=-651572838,@iItem_Name='24555',@iItem_durability=90 00000,@im_nAbilityOption=0,@Im_GetdwGold=4404379,@ iItem_count=1,@iState='T',@im_nSlot0=100,@im_nSlot 1=100,@im_bItemResist=0,@im_nResistAbilityOption=0 ,@im_bCharged=1,@im_dwKeepTime=0,@im_nRandomOptIte mId=1387606559738305536,@inPiercedSize=0,@iadwItem Id0=0,@iadwItemId1=0,@iadwItemId2=0,@iadwItemId3=0 ,@iadwItemId4=0,@iMaxDurability=0,@inPetKind=0,@in PetLevel=0,@idwPetExp=0,@iwPetEnergy=0,@iwPetLife= 0,@inPetAL_D=0,@inPetAL_C=0,@inPetAL_B=0,@inPetAL_ A=0,@inPetAL_S=0,@iadwItemId5=0,@iadwItemId6=0,@ia dwItemId7=0,@iadwItemId8=0,@iadwItemId9=0,@inUMPie rcedSize=0,@iadwUMItemId0=0,@iadwUMItemId1=0,@iadw UMItemId2=0,@iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
2017/12/19 20:25:12
query:uspLoggingTrade @pFlag=2, @deID=1513686305, @ndex='01', @pidPlayer='0000004', @mIndex='24555', @mSerialNum=-651572838, @mCnt=1, @pAbilityOpt=0, @mResist=0, @stAbilityOpt=0 @mOpt=1387606559738305536
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2017/12/19 20:25:12
query:uspLoggingTrade @pFlag=2, @deID=1513686305, @ndex='01', @pidPlayer='0000004', @mIndex='24555', @mSerialNum=-651572838, @mCnt=1, @pAbilityOpt=0, @mResist=0, @stAbilityOpt=0 @mOpt=1387606559738305536
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2017/12/19 20:25:12
query:LOG_ITEM_STR @im_szName='mehoh',@iserverindex='01',@im_GetszNam e='Zeljian',@idwWorldID=1,@im_dwGold=645005,@im_nR emainGold=645005,@iItem_UniqueNo=961802955,@iItem_ Name='24556',@iItem_durability=3600000,@im_nAbilit yOption=0,@Im_GetdwGold=4404379,@iItem_count=1,@iS tate='T',@im_nSlot0=100,@im_nSlot1=100,@im_bItemRe sist=0,@im_nResistAbilityOption=0,@im_bCharged=1,@ im_dwKeepTime=0,@im_nRandomOptItemId=1387606559738 305536,@inPiercedSize=0,@iadwItemId0=0,@iadwItemId 1=0,@iadwItemId2=0,@iadwItemId3=0,@iadwItemId4=0,@ iMaxDurability=0,@inPetKind=0,@inPetLevel=0,@idwPe tExp=0,@iwPetEnergy=0,@iwPetLife=0,@inPetAL_D=0,@i nPetAL_C=0,@inPetAL_B=0,@inPetAL_A=0,@inPetAL_S=0, @iadwItemId5=0,@iadwItemId6=0,@iadwItemId7=0,@iadw ItemId8=0,@iadwItemId9=0,@inUMPiercedSize=0,@iadwU MItemId0=0,@iadwUMItemId1=0,@iadwUMItemId2=0,@iadw UMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
2017/12/19 20:25:12
query:uspLoggingTrade @pFlag=2, @deID=1513686305, @ndex='01', @pidPlayer='0000004', @mIndex='24556', @mSerialNum=961802955, @mCnt=1, @pAbilityOpt=0, @mResist=0, @stAbilityOpt=0 @mOpt=1387606559738305536
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2017/12/19 20:25:12
query:uspLoggingTrade @pFlag=2, @deID=1513686305, @ndex='01', @pidPlayer='0000004', @mIndex='24556', @mSerialNum=961802955, @mCnt=1, @pAbilityOpt=0, @mResist=0, @stAbilityOpt=0 @mOpt=1387606559738305536
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2017/12/19 20:25:12
query:LOG_ITEM_STR @im_szName='mehoh',@iserverindex='01',@im_GetszNam e='Zeljian',@idwWorldID=1,@im_dwGold=645005,@im_nR emainGold=645005,@iItem_UniqueNo=1252827974,@iItem _Name='39454',@iItem_durability=-1,@im_nAbilityOption=0,@Im_GetdwGold=4404379,@iIte m_count=1,@iState='T',@im_nSlot0=100,@im_nSlot1=10 0,@im_bItemResist=0,@im_nResistAbilityOption=0,@im _bCharged=0,@im_dwKeepTime=0,@im_nRandomOptItemId= 18542234823826944,@inPiercedSize=2,@iadwItemId0=0, @iadwItemId1=0,@iadwItemId2=0,@iadwItemId3=0,@iadw ItemId4=0,@iMaxDurability=0,@inPetKind=0,@inPetLev el=0,@idwPetExp=0,@iwPetEnergy=0,@iwPetLife=0,@inP etAL_D=0,@inPetAL_C=0,@inPetAL_B=0,@inPetAL_A=0,@i nPetAL_S=0,@iadwItemId5=0,@iadwItemId6=0,@iadwItem Id7=0,@iadwItemId8=0,@iadwItemId9=0,@inUMPiercedSi ze=0,@iadwUMItemId0=0,@iadwUMItemId1=0,@iadwUMItem Id2=0,@iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
2017/12/19 20:25:12
query:uspLoggingTrade @pFlag=2, @deID=1513686305, @ndex='01', @pidPlayer='0000004', @mIndex='39454', @mSerialNum=1252827974, @mCnt=1, @pAbilityOpt=0, @mResist=0, @stAbilityOpt=0 @mOpt=18542234823826944
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2017/12/19 20:25:12
query:uspLoggingTrade @pFlag=2, @deID=1513686305, @ndex='01', @pidPlayer='0000004', @mIndex='39454', @mSerialNum=1252827974, @mCnt=1, @pAbilityOpt=0, @mResist=0, @stAbilityOpt=0 @mOpt=18542234823826944
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2017/12/19 20:25:12
query:LOG_ITEM_STR @im_szName='mehoh',@iserverindex='01',@im_GetszNam e='Zeljian',@idwWorldID=1,@im_dwGold=645005,@im_nR emainGold=645005,@iItem_UniqueNo=1354394280,@iItem _Name='24557',@iItem_durability=5850000,@im_nAbili tyOption=0,@Im_GetdwGold=4404379,@iItem_count=1,@i State='T',@im_nSlot0=100,@im_nSlot1=100,@im_bItemR esist=0,@im_nResistAbilityOption=0,@im_bCharged=1, @im_dwKeepTime=0,@im_nRandomOptItemId=138760655973 8305536,@inPiercedSize=0,@iadwItemId0=0,@iadwItemI d1=0,@iadwItemId2=0,@iadwItemId3=0,@iadwItemId4=0, @iMaxDurability=0,@inPetKind=0,@inPetLevel=0,@idwP etExp=0,@iwPetEnergy=0,@iwPetLife=0,@inPetAL_D=0,@ inPetAL_C=0,@inPetAL_B=0,@inPetAL_A=0,@inPetAL_S=0 ,@iadwItemId5=0,@iadwItemId6=0,@iadwItemId7=0,@iad wItemId8=0,@iadwItemId9=0,@inUMPiercedSize=0,@iadw UMItemId0=0,@iadwUMItemId1=0,@iadwUMItemId2=0,@iad wUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
2017/12/19 20:25:12
query:uspLoggingTrade @pFlag=2, @deID=1513686305, @ndex='01', @pidPlayer='0000004', @mIndex='24557', @mSerialNum=1354394280, @mCnt=1, @pAbilityOpt=0, @mResist=0, @stAbilityOpt=0 @mOpt=1387606559738305536
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2017/12/19 20:25:12
query:uspLoggingTrade @pFlag=2, @deID=1513686305, @ndex='01', @pidPlayer='0000004', @mIndex='24557', @mSerialNum=1354394280, @mCnt=1, @pAbilityOpt=0, @mResist=0, @stAbilityOpt=0 @mOpt=1387606559738305536
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2017/12/19 20:25:12
query:LOG_ITEM_STR @im_szName='mehoh',@iserverindex='01',@im_GetszNam e='Zeljian',@idwWorldID=1,@im_dwGold=645005,@im_nR emainGold=645005,@iItem_UniqueNo=2074865050,@iItem _Name='38666',@iItem_durability=50000,@im_nAbility Option=0,@Im_GetdwGold=4404379,@iItem_count=1,@iSt ate='T',@im_nSlot0=100,@im_nSlot1=100,@im_bItemRes ist=0,@im_nResistAbilityOption=0,@im_bCharged=0,@i m_dwKeepTime=0,@im_nRandomOptItemId=13876065597383 05536,@inPiercedSize=0,@iadwItemId0=0,@iadwItemId1 =0,@iadwItemId2=0,@iadwItemId3=0,@iadwItemId4=0,@i MaxDurability=0,@inPetKind=0,@inPetLevel=0,@idwPet Exp=0,@iwPetEnergy=0,@iwPetLife=0,@inPetAL_D=0,@in PetAL_C=0,@inPetAL_B=0,@inPetAL_A=0,@inPetAL_S=0,@ iadwItemId5=0,@iadwItemId6=0,@iadwItemId7=0,@iadwI temId8=0,@iadwItemId9=0,@inUMPiercedSize=0,@iadwUM ItemId0=0,@iadwUMItemId1=0,@iadwUMItemId2=0,@iadwU MItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
2017/12/19 20:25:12
query:uspLoggingTrade @pFlag=2, @deID=1513686305, @ndex='01', @pidPlayer='0000004', @mIndex='38666', @mSerialNum=2074865050, @mCnt=1, @pAbilityOpt=0, @mResist=0, @stAbilityOpt=0 @mOpt=1387606559738305536
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2017/12/19 20:25:12
query:uspLoggingTrade @pFlag=2, @deID=1513686305, @ndex='01', @pidPlayer='0000004', @mIndex='38666', @mSerialNum=2074865050, @mCnt=1, @pAbilityOpt=0, @mResist=0, @stAbilityOpt=0 @mOpt=1387606559738305536
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2017/12/19 20:25:12
query:LOG_ITEM_STR @im_szName='mehoh',@iserverindex='01',@im_GetszNam e='Zeljian',@idwWorldID=1,@im_dwGold=645005,@im_nR emainGold=645005,@iItem_UniqueNo=-1343379043,@iItem_Name='60670',@iItem_durability=5 0000,@im_nAbilityOption=0,@Im_GetdwGold=4404379,@i Item_count=1,@iState='T',@im_nSlot0=100,@im_nSlot1 =100,@im_bItemResist=0,@im_nResistAbilityOption=0, @im_bCharged=0,@im_dwKeepTime=0,@im_nRandomOptItem Id=198335062052964864,@inPiercedSize=0,@iadwItemId 0=0,@iadwItemId1=0,@iadwItemId2=0,@iadwItemId3=0,@ iadwItemId4=0,@iMaxDurability=0,@inPetKind=0,@inPe tLevel=0,@idwPetExp=0,@iwPetEnergy=0,@iwPetLife=0, @inPetAL_D=0,@inPetAL_C=0,@inPetAL_B=0,@inPetAL_A= 0,@inPetAL_S=0,@iadwItemId5=0,@iadwItemId6=0,@iadw ItemId7=0,@iadwItemId8=0,@iadwItemId9=0,@inUMPierc edSize=0,@iadwUMItemId0=0,@iadwUMItemId1=0,@iadwUM ItemId2=0,@iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
2017/12/19 20:25:12
query:uspLoggingTrade @pFlag=2, @deID=1513686305, @ndex='01', @pidPlayer='0000004', @mIndex='60670', @mSerialNum=-1343379043, @mCnt=1, @pAbilityOpt=0, @mResist=0, @stAbilityOpt=0 @mOpt=198335062052964864
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2017/12/19 20:25:12
query:uspLoggingTrade @pFlag=2, @deID=1513686305, @ndex='01', @pidPlayer='0000004', @mIndex='60670', @mSerialNum=-1343379043, @mCnt=1, @pAbilityOpt=0, @mResist=0, @stAbilityOpt=0 @mOpt=198335062052964864
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2017/12/19 20:25:33
query:LOG_USER_CNT_STR '01', 0, 2
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state

thanks

[flyffdev]

I really dont get it.

What i Understand, if you want to become tradable the fashion with blessing and this is the fix:

Item.cpp

#if __VER >= 11 // __SYS_IDENTIFY
	if( g_xRandomOptionProperty->GetRandomOptionSize( GetRandomOptItemId() ) > 0
		&& ( 
		/* g_xRandomOptionProperty->GetRandomOptionKind( this ) == CRandomOptionProperty::eBlessing || */ 
		g_xRandomOptionProperty->GetRandomOptionKind( this ) == CRandomOptionProperty::eEatPet ) )
		return TRUE;
	if( GetLevelDown() < 0 )
		return TRUE;
#endif	// __SYS_IDENTIFY

Then remove the tooltip that says: you cannot trade, mail or vend with blessed fashions

here's the fix

WndManager.cpp

/*
	if( bBlessing )
	{
		str.Format( "\n%s", prj.GetText( TID_GAME_BLESSING_WARNING ) );
		pEdit->AddString( str, dwItemColor[g_Option.m_nToolTipText].dwBlessingWarning );
	}
*/

[Nortix]

SQL has nothing to do with tradeable items

[Zeljian]

Originally Posted by flyffdev

I really dont get it.

What i Understand, if you want to become tradable the fashion with blessing and this is the fix:

Item.cpp

#if __VER >= 11 // __SYS_IDENTIFY
	if( g_xRandomOptionProperty->GetRandomOptionSize( GetRandomOptItemId() ) > 0
		&& ( 
		/* g_xRandomOptionProperty->GetRandomOptionKind( this ) == CRandomOptionProperty::eBlessing || */ 
		g_xRandomOptionProperty->GetRandomOptionKind( this ) == CRandomOptionProperty::eEatPet ) )
		return TRUE;
	if( GetLevelDown() < 0 )
		return TRUE;
#endif	// __SYS_IDENTIFY

Then remove the tooltip that says: you cannot trade, mail or vend with blessed fashions

here's the fix

WndManager.cpp

/*
	if( bBlessing )
	{
		str.Format( "\n%s", prj.GetText( TID_GAME_BLESSING_WARNING ) );
		pEdit->AddString( str, dwItemColor[g_Option.m_nToolTipText].dwBlessingWarning );
	}
*/

before you comment this i already know were is the code can be tradable,
but my main problem is this,

after i trade the fashion with blessing awake i get sql error

 Spoiler

2017/12/21 21:58:19
query:uspLoggingTrade @pFlag=2, @deID=1513864673, @ndex='01', @pidPlayer='0000004', @mIndex='24557', @mSerialNum=1354394280, @mCnt=1, @pAbilityOpt=0, @mResist=0, @stAbilityOpt=0 @mOpt=1387606559738305536
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2017/12/21 21:58:19
query:uspLoggingTrade @pFlag=2, @deID=1513864673, @ndex='01', @pidPlayer='0000004', @mIndex='24557', @mSerialNum=1354394280, @mCnt=1, @pAbilityOpt=0, @mResist=0, @stAbilityOpt=0 @mOpt=1387606559738305536
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2017/12/21 21:58:20
query:LOG_ITEM_STR @im_szName='Zeljian',@iserverindex='01',@im_GetszN ame='Zeljian123',@idwWorldID=1,@im_dwGold=645005,@ im_nRemainGold=645005,@iItem_UniqueNo=1372506561,@ iItem_Name='24558',@iItem_durability=4500000,@im_n AbilityOption=0,@Im_GetdwGold=4404379,@iItem_count =1,@iState='T',@im_nSlot0=100,@im_nSlot1=100,@im_b ItemResist=0,@im_nResistAbilityOption=0,@im_bCharg ed=1,@im_dwKeepTime=0,@im_nRandomOptItemId=1387606 559738305536,@inPiercedSize=0,@iadwItemId0=0,@iadw ItemId1=0,@iadwItemId2=0,@iadwItemId3=0,@iadwItemI d4=0,@iMaxDurability=0,@inPetKind=0,@inPetLevel=0, @idwPetExp=0,@iwPetEnergy=0,@iwPetLife=0,@inPetAL_ D=0,@inPetAL_C=0,@inPetAL_B=0,@inPetAL_A=0,@inPetA L_S=0,@iadwItemId5=0,@iadwItemId6=0,@iadwItemId7=0 ,@iadwItemId8=0,@iadwItemId9=0,@inUMPiercedSize=0, @iadwUMItemId0=0,@iadwUMItemId1=0,@iadwUMItemId2=0 ,@iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
2017/12/21 21:58:20
query:uspLoggingTrade @pFlag=2, @deID=1513864673, @ndex='01', @pidPlayer='0000004', @mIndex='24558', @mSerialNum=1372506561, @mCnt=1, @pAbilityOpt=0, @mResist=0, @stAbilityOpt=0 @mOpt=1387606559738305536
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2017/12/21 21:58:20
query:uspLoggingTrade @pFlag=2, @deID=1513864673, @ndex='01', @pidPlayer='0000004', @mIndex='24558', @mSerialNum=1372506561, @mCnt=1, @pAbilityOpt=0, @mResist=0, @stAbilityOpt=0 @mOpt=1387606559738305536
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2017/12/21 21:58:20
query:LOG_ITEM_STR @im_szName='Zeljian',@iserverindex='01',@im_GetszN ame='Zeljian123',@idwWorldID=1,@im_dwGold=645005,@ im_nRemainGold=645005,@iItem_UniqueNo=961802955,@i Item_Name='24556',@iItem_durability=3600000,@im_nA bilityOption=0,@Im_GetdwGold=4404379,@iItem_count= 1,@iState='T',@im_nSlot0=100,@im_nSlot1=100,@im_bI temResist=0,@im_nResistAbilityOption=0,@im_bCharge d=1,@im_dwKeepTime=0,@im_nRandomOptItemId=13876065 59738305536,@inPiercedSize=0,@iadwItemId0=0,@iadwI temId1=0,@iadwItemId2=0,@iadwItemId3=0,@iadwItemId 4=0,@iMaxDurability=0,@inPetKind=0,@inPetLevel=0,@ idwPetExp=0,@iwPetEnergy=0,@iwPetLife=0,@inPetAL_D =0,@inPetAL_C=0,@inPetAL_B=0,@inPetAL_A=0,@inPetAL _S=0,@iadwItemId5=0,@iadwItemId6=0,@iadwItemId7=0, @iadwItemId8=0,@iadwItemId9=0,@inUMPiercedSize=0,@ iadwUMItemId0=0,@iadwUMItemId1=0,@iadwUMItemId2=0, @iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
2017/12/21 21:58:20
query:uspLoggingTrade @pFlag=2, @deID=1513864673, @ndex='01', @pidPlayer='0000004', @mIndex='24556', @mSerialNum=961802955, @mCnt=1, @pAbilityOpt=0, @mResist=0, @stAbilityOpt=0 @mOpt=1387606559738305536
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2017/12/21 21:58:20
query:uspLoggingTrade @pFlag=2, @deID=1513864673, @ndex='01', @pidPlayer='0000004', @mIndex='24556', @mSerialNum=961802955, @mCnt=1, @pAbilityOpt=0, @mResist=0, @stAbilityOpt=0 @mOpt=1387606559738305536
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2017/12/21 21:58:20
query:LOG_ITEM_STR @im_szName='Zeljian',@iserverindex='01',@im_GetszN ame='Zeljian123',@idwWorldID=1,@im_dwGold=645005,@ im_nRemainGold=645005,@iItem_UniqueNo=2074865050,@ iItem_Name='38666',@iItem_durability=50000,@im_nAb ilityOption=0,@Im_GetdwGold=4404379,@iItem_count=1 ,@iState='T',@im_nSlot0=100,@im_nSlot1=100,@im_bIt emResist=0,@im_nResistAbilityOption=0,@im_bCharged =0,@im_dwKeepTime=0,@im_nRandomOptItemId=138760655 9738305536,@inPiercedSize=0,@iadwItemId0=0,@iadwIt emId1=0,@iadwItemId2=0,@iadwItemId3=0,@iadwItemId4 =0,@iMaxDurability=0,@inPetKind=0,@inPetLevel=0,@i dwPetExp=0,@iwPetEnergy=0,@iwPetLife=0,@inPetAL_D= 0,@inPetAL_C=0,@inPetAL_B=0,@inPetAL_A=0,@inPetAL_ S=0,@iadwItemId5=0,@iadwItemId6=0,@iadwItemId7=0,@ iadwItemId8=0,@iadwItemId9=0,@inUMPiercedSize=0,@i adwUMItemId0=0,@iadwUMItemId1=0,@iadwUMItemId2=0,@ iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
2017/12/21 21:58:21
query:uspLoggingTrade @pFlag=2, @deID=1513864673, @ndex='01', @pidPlayer='0000004', @mIndex='38666', @mSerialNum=2074865050, @mCnt=1, @pAbilityOpt=0, @mResist=0, @stAbilityOpt=0 @mOpt=1387606559738305536
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2017/12/21 21:58:21
query:uspLoggingTrade @pFlag=2, @deID=1513864673, @ndex='01', @pidPlayer='0000004', @mIndex='38666', @mSerialNum=2074865050, @mCnt=1, @pAbilityOpt=0, @mResist=0, @stAbilityOpt=0 @mOpt=1387606559738305536
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2017/12/21 21:58:21
query:LOG_ITEM_STR @im_szName='Zeljian',@iserverindex='01',@im_GetszN ame='Zeljian123',@idwWorldID=1,@im_dwGold=645005,@ im_nRemainGold=645005,@iItem_UniqueNo=-651572838,@iItem_Name='24555',@iItem_durability=90 00000,@im_nAbilityOption=0,@Im_GetdwGold=4404379,@ iItem_count=1,@iState='T',@im_nSlot0=100,@im_nSlot 1=100,@im_bItemResist=0,@im_nResistAbilityOption=0 ,@im_bCharged=1,@im_dwKeepTime=0,@im_nRandomOptIte mId=1387606559738305536,@inPiercedSize=0,@iadwItem Id0=0,@iadwItemId1=0,@iadwItemId2=0,@iadwItemId3=0 ,@iadwItemId4=0,@iMaxDurability=0,@inPetKind=0,@in PetLevel=0,@idwPetExp=0,@iwPetEnergy=0,@iwPetLife= 0,@inPetAL_D=0,@inPetAL_C=0,@inPetAL_B=0,@inPetAL_ A=0,@inPetAL_S=0,@iadwItemId5=0,@iadwItemId6=0,@ia dwItemId7=0,@iadwItemId8=0,@iadwItemId9=0,@inUMPie rcedSize=0,@iadwUMItemId0=0,@iadwUMItemId1=0,@iadw UMItemId2=0,@iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
2017/12/21 21:58:21
query:uspLoggingTrade @pFlag=2, @deID=1513864673, @ndex='01', @pidPlayer='0000004', @mIndex='24555', @mSerialNum=-651572838, @mCnt=1, @pAbilityOpt=0, @mResist=0, @stAbilityOpt=0 @mOpt=1387606559738305536
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2017/12/21 21:58:21
query:uspLoggingTrade @pFlag=2, @deID=1513864673, @ndex='01', @pidPlayer='0000004', @mIndex='24555', @mSerialNum=-651572838, @mCnt=1, @pAbilityOpt=0, @mResist=0, @stAbilityOpt=0 @mOpt=1387606559738305536
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.

[Zeljian]

bump

[raventh1984]

An arithmetic overflow is caused by a calculated column value that exceeds the column's specified size. When this error occurs, the calculation stops and the remainder of the results pane is not filled.

So it means that the data you are trying to insert is larger then the field.

either change the field to bigint or change the code so that it will not exceed the int value of -2147483647 to 2147483647 since your awakening id is (1387606559738305536)

[Zeljian]

Originally Posted by raventh1984

An arithmetic overflow is caused by a calculated column value that exceeds the column's specified size. When this error occurs, the calculation stops and the remainder of the results pane is not filled.

So it means that the data you are trying to insert is larger then the field.

either change the field to bigint or change the code so that it will not exceed the int value of -2147483647 to 2147483647 since your awakening id is (1387606559738305536)

where i can change it?