BLESSING

12/19/2017 13:42 Zeljian#1

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

thanks

12/19/2017 19:09 flyffdev#2

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

Code:

#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

Code:

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

12/20/2017 14:41 Nortix#3

SQL has nothing to do with tradeable items

12/21/2017 15:03 Zeljian#4

Quote:
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
Code:
#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
Code:
/*
	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

12/22/2017 18:13 Zeljian#5

bump

12/29/2017 20:11 raventh1984#6

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)

01/23/2018 05:41 Zeljian#7

Quote:

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?