[RELEASE] Dragonball Online Release Source

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

My procedure work, if i use

Quote:

---

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

Quote:

---

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

---

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

try
call AccountCreate(?, ?)

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

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

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

Code:

---

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

Quote:

---

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

---

then on adsfdf.h

Code:

---

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;
        }

---

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

Quote:

---

Originally Posted by Tatuds

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

---

yes here 127.0.0.1

Quote:

---

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

I think I wont create a query server...

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

Quote:

---

Originally Posted by Daneos

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.

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.

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

Quote:

---

Originally Posted by ATIDOT3

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

Quote:

---

Originally Posted by Daneos

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.

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 -.-