[RELEASE] Dragonball Online Release Source

[ATIDOT3]

i changed everything, i'm not stupid to copy past thanks.

My procedure work, if i use

DECLARE @OUT_Result INT;

EXECUTE [dbo].[AccountCreate] @m_szUserID = 'UserName'
,@m_szUserPW = '123456'
,@m_nResultCode = @OUT_Result OUTPUT

It's just not finding the procedure with

BEGIN_DECLARE_SQLUNIT( SP_AccountCreate, "{ ? = call AccountCreate(?, ?) }" )

[Daneos]

because
? = call AccountCreate(?, ?)
^ need a return

try
call AccountCreate(?, ?)

[Killerwoody]

I have faith in you guys and read your post everyday. Keep up this awesome job!

[ATIDOT3]

it's really strating to piss me off.

Impossible to user the fucking procedure ? = or not with int result declare(3) or not nothing work

[Daneos]

Anyone know how I can get the results in my .cpp file?

pSqlUnit2->m_nResultCode <-- this give a 100

how can I get the value inside a .cpp file?

example:
adsfdf.h

pSqlUnit2->Exec();
printf("ExecuteQuery Done: result: %i ACC ID: %i \n", pSqlUnit2->m_nResultCode, pSqlUnit2->m_dwAccountID );

now I want to get the sqlunit2 results inside sdgdfg.cpp

Inside
sdgdfg.cpp

I run

databaseManager.Query( hDB, new CQuery_UpdateAccountID(TEXT("DaneosIsSexy"), "1234") );

then on adsfdf.h

int ExecuteQuery(CNtlDatabaseConnection * pConnection)
	{
		////---------------------------------------------------------------
		FIND_SQLUNIT( SP_AccountSelect, pConnection, pSqlUnit2 );
		if( NULL == pSqlUnit2 )
		{
			return NTL_FAIL;
		}

		strncpy_s( pSqlUnit2->m_szUserID, m_szUserID, MAX_SIZE_USER_ID );
		strncpy_s( pSqlUnit2->m_szUserPW, m_szUserPW, MAX_SIZE_USER_ID );


		pSqlUnit2->Exec();
		printf("ExecuteQuery Done: result: %i ACC ID: %i \n", pSqlUnit2->m_nResultCode, pSqlUnit2->m_dwAccountID );


		return NTL_SUCCESS;
	}

[Tatuds]

Any can create a public server ? Or send ip to me :c

[Daneos]

Any can create a public server ? Or send ip to me :c

yes here 127.0.0.1

[ATIDOT3]

CQuery_AccountCreate *account = new CQuery_AccountCreate("tester2", "1234");
databaseManager.Query( hDB, account );
printf("account->m_szUserID = %S", account->m_szUserID);

try it but not sure

[Daneos]

I think I wont create a query server...

client -> auth/char/game is enough I think..

[ATIDOT3]

I think I wont create a query server...

client -> auth/char/game is enough I think..

Ot, you create a library :).

where you could call your query everywhere, and execute request everywhere.

[Daneos]

Yeah.. I wont create a query server.. its waste of time I think. Query server would only be useful if there are looots of players.

[ATIDOT3]

Convert query server to library will take long time as make the query server XD.

[Daneos]

Convert query server to library will take long time as make the query server XD.

I wont make query library because its useless.. Auth, char and chat server only need few queries. The only server which really need many queries is the gameserver. And I already finished moving everything into the auth and char server

[ATIDOT3]

I wont make query library because its useless.. Auth, char and chat server only need few queries. The only server which really need many queries is the gameserver. And I already finished moving everything into the auth and char server

not very good, if you add a connection msql foreach server.

[Daneos]

if you add a connection msql foreach server. ????

Any idea how I could get data out of this
databaseManager.Query( hDB, new CQuery_AuthServer(TEXT("DaneosIsSexy"),"1234") );

Im getting pissed why c++ cant be easy like php with arrays etc -.-