[Problem] Create Char Job

[kinerzou]

Hello,

I have try to test this system

it's work fine, but when i click "Ok", my character is not create (not in char selection), however the character is in the DB.

Sorry for my english !

[kinerzou]

Anyone ?

[Lumi]

Did you excute the query?

[kinerzou]

This?

FROM BASE_VALUE_TBL
WHERE g_nSex = @im_dwSex AND
m_nJob

I have modify the stored procedure and execute.

My DBManager.cpp

#ifdef __JOB_CREATE_CHAR
DBQryCharacter( szQuery, "I1", 0, g_appInfo.dwSys, lpDbOverlappedPlus->AccountInfo.szAccount, lpDbOverlappedPlus->AccountInfo.szPlayer, nSlot, dwWorldID,
dwIndex, vPos.x, vPos.y, vPos.z, '\0', nSkinSet, nHairMesh, dwHairColor, nHeadMesh, nSex, 0.0f, 0, 0.0f, 0, 0, 0, 0, 0, nJob );
#else //__JOB_CREATE_CHAR
DBQryCharacter( szQuery, "I1", 0, g_appInfo.dwSys, lpDbOverlappedPlus->AccountInfo.szAccount, lpDbOverlappedPlus->AccountInfo.szPlayer, nSlot, dwWorldID,
dwIndex, vPos.x, vPos.y, vPos.z, '\0', nSkinSet, nHairMesh, dwHairColor, nHeadMesh, nSex );
#endif //__JOB_CREATE_CHAR


if( FALSE == qry->Exec( szQuery ) )
{
WriteLog( "%s, %d\r\n\t%s", __FILE__, __LINE__, szQuery );
FreeRequest( lpDbOverlappedPlus );
return;
}

#ifdef __Chogiha
// ÃʱâÈ* ÀÛ¾÷ÇÒ¶§ ¾²ÀδÙ~~~~ Æò»ó½Ã ¾È¾¸
WriteToFile(nSkinSet, nHairMesh, nSex, nJob, nHeadMesh, dwHairColor, lpDbOverlappedPlus->AccountInfo.szPlayer );
#endif

if( qry->Fetch() )
{
int nError;
u_long nidPlayer;
nError = qry->GetInt( "fError" );
if( nError == 1 )
{
nidPlayer = qry->GetInt( "m_idPlayer" );
#if __VER >= 11 // __SYS_PLAYER_DATA
PlayerData pd;
#ifdef __JOB_CREATE_CHAR
pd.data.nJob = nJob;
#else //__JOB_CREATE_CHAR
pd.nJob = 0;
#endif // __JOB_CREATE_CHAR

[Lumi]

You need the base_value query too.

[kinerzou]

what is the base_value query?

Oh, ok i've find it ! Thanks.
But when i execute the query, they have an error. they have a primary key on g_nSex, i can't add.

[marvincod1]

Hey, do you have the v19 resdata for me? because here my client crash because of resdata.inc

[Avalion]

Originally Posted by kinerzou

what is the base_value query?

Oh, ok i've find it ! Thanks.
But when i execute the query, they have an error. they have a primary key on g_nSex, i can't add.

It's because the only thing the table is based of *** which causes the errors. You need to add m_nJob to the indexing as well as keeping *** involved.