[RELEASE] Dragonball Online Release Source

Quote:

---

Originally Posted by maximojoni

@Daneos I have read and I already removed
I do not know where I am going wrong now I'll see if I left any backward
need to fix it to work with you in the database

---

Check again all files..

- - - Updated - - -

Quote:

---

Originally Posted by SSGokug

Can someone give a guide on how to play online i have the Auth Char and gamer servers all that is needed to play just how to i do it?

---

no. Read all pages

- - - Updated - - -

Quote:

---

Originally Posted by ATIDOT3

Just take your source, i'm adding my change on it.

So lets do some msql but i could not help you a lot with this...

---

I for myself also prefer mysql because Im very used to mysql (Im php developer)
but I read google and in most game developement forum I read that mssql is better.

With mssql I got little experience.. All I need to know is how to run the queries and print the results.. After I know that I can easily write the whole query server.

Quote:

---

Originally Posted by Daneos

Check again all files..

- - - Updated - - -



no. Read all pages

- - - Updated - - -



I for myself also prefer mysql because Im very used to mysql (Im php developer)
but I read google and in most game developement forum I read that mssql is better

---

Of course msql is better for online game, but lets make the fucking request for get the database value..... i'll kill my and yourself XD.:P:


EDIT:

i got the best idea in the world, like we use msql...

let's make IIS API with it for connect to the database etc ! <--------------------------- never do it.... :adore:

Dont know how .. xd
Maybe an experienced user could look into it and tell us how to create queries and print the results.

Code:

---

#include <iostream>
#include <windows.h>
#include <sqltypes.h>
#include <sql.h>
#include <sqlext.h>

using namespace std;

void show_error(unsigned int handletype, const SQLHANDLE& handle){
    SQLCHAR sqlstate[1024];
    SQLCHAR message[1024];
    if(SQL_SUCCESS == SQLGetDiagRec(handletype, handle, 1, sqlstate, NULL, message, 1024, NULL))
        cout<<"Message: "<<message<<"nSQLSTATE: "<<sqlstate<<endl;
}

int main(){

    SQLHANDLE sqlenvhandle;   
    SQLHANDLE sqlconnectionhandle;
    SQLHANDLE sqlstatementhandle;
    SQLRETURN retcode;

    if(SQL_SUCCESS!=SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &sqlenvhandle))
        goto FINISHED;

    if(SQL_SUCCESS!=SQLSetEnvAttr(sqlenvhandle,SQL_ATTR_ODBC_VERSION, (SQLPOINTER)SQL_OV_ODBC3, 0))
        goto FINISHED;
   
    if(SQL_SUCCESS!=SQLAllocHandle(SQL_HANDLE_DBC, sqlenvhandle, &sqlconnectionhandle))
        goto FINISHED;

    SQLCHAR retconstring[1024];
    switch(SQLDriverConnect (sqlconnectionhandle,
                NULL,
                (SQLCHAR*)"DRIVER={SQL Server};SERVER=localhost, 1433;DATABASE=MyDatabase;UID=sa;PWD=Admin-123;",
                SQL_NTS,
                retconstring,
                1024,
                NULL,
                SQL_DRIVER_NOPROMPT)){
        case SQL_SUCCESS_WITH_INFO:
            show_error(SQL_HANDLE_DBC, sqlconnectionhandle);
            break;
        case SQL_INVALID_HANDLE:
        case SQL_ERROR:
            show_error(SQL_HANDLE_DBC, sqlconnectionhandle);
            goto FINISHED;
        default:
            break;
    }
   
    if(SQL_SUCCESS!=SQLAllocHandle(SQL_HANDLE_STMT, sqlconnectionhandle, &sqlstatementhandle))
        goto FINISHED;

    if(SQL_SUCCESS!=SQLExecDirect(sqlstatementhandle, (SQLCHAR*)"select * from testtable", SQL_NTS)){
        show_error(SQL_HANDLE_STMT, sqlstatementhandle);
        goto FINISHED;
    }
    else{
        char name[64];
        char address[64];
        int id;
        while(SQLFetch(sqlstatementhandle)==SQL_SUCCESS){
            SQLGetData(sqlstatementhandle, 1, SQL_C_ULONG, &id, 0, NULL);
            SQLGetData(sqlstatementhandle, 2, SQL_C_CHAR, name, 64, NULL);
            SQLGetData(sqlstatementhandle, 3, SQL_C_CHAR, address, 64, NULL);
            cout<<id<<" "<<name<<" "<<address<<endl;
        }
    }

FINISHED:
    SQLFreeHandle(SQL_HANDLE_STMT, sqlstatementhandle );
    SQLDisconnect(sqlconnectionhandle);
    SQLFreeHandle(SQL_HANDLE_DBC, sqlconnectionhandle);
    SQLFreeHandle(SQL_HANDLE_ENV, sqlenvhandle);
   
}

---

Found on google

[Client Accept]
Address=192.168.0.2
Port=30001
[Server Accept]
Address=192.168.0.2
Port=30002
[Server Connect]
Address=192.168.0.2
Port=10001
[ChatServer Connect]
Address=192.168.0.2
Port=40001 What do i change here?

Quote:

---

Originally Posted by ATIDOT3

Code:

---

#include <iostream>
#include <windows.h>
#include <sqltypes.h>
#include <sql.h>
#include <sqlext.h>

using namespace std;

void show_error(unsigned int handletype, const SQLHANDLE& handle){
    SQLCHAR sqlstate[1024];
    SQLCHAR message[1024];
    if(SQL_SUCCESS == SQLGetDiagRec(handletype, handle, 1, sqlstate, NULL, message, 1024, NULL))
        cout<<"Message: "<<message<<"nSQLSTATE: "<<sqlstate<<endl;
}

int main(){

    SQLHANDLE sqlenvhandle;   
    SQLHANDLE sqlconnectionhandle;
    SQLHANDLE sqlstatementhandle;
    SQLRETURN retcode;

    if(SQL_SUCCESS!=SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &sqlenvhandle))
        goto FINISHED;

    if(SQL_SUCCESS!=SQLSetEnvAttr(sqlenvhandle,SQL_ATTR_ODBC_VERSION, (SQLPOINTER)SQL_OV_ODBC3, 0))
        goto FINISHED;
   
    if(SQL_SUCCESS!=SQLAllocHandle(SQL_HANDLE_DBC, sqlenvhandle, &sqlconnectionhandle))
        goto FINISHED;

    SQLCHAR retconstring[1024];
    switch(SQLDriverConnect (sqlconnectionhandle,
                NULL,
                (SQLCHAR*)"DRIVER={SQL Server};SERVER=localhost, 1433;DATABASE=MyDatabase;UID=sa;PWD=Admin-123;",
                SQL_NTS,
                retconstring,
                1024,
                NULL,
                SQL_DRIVER_NOPROMPT)){
        case SQL_SUCCESS_WITH_INFO:
            show_error(SQL_HANDLE_DBC, sqlconnectionhandle);
            break;
        case SQL_INVALID_HANDLE:
        case SQL_ERROR:
            show_error(SQL_HANDLE_DBC, sqlconnectionhandle);
            goto FINISHED;
        default:
            break;
    }
   
    if(SQL_SUCCESS!=SQLAllocHandle(SQL_HANDLE_STMT, sqlconnectionhandle, &sqlstatementhandle))
        goto FINISHED;

    if(SQL_SUCCESS!=SQLExecDirect(sqlstatementhandle, (SQLCHAR*)"select * from testtable", SQL_NTS)){
        show_error(SQL_HANDLE_STMT, sqlstatementhandle);
        goto FINISHED;
    }
    else{
        char name[64];
        char address[64];
        int id;
        while(SQLFetch(sqlstatementhandle)==SQL_SUCCESS){
            SQLGetData(sqlstatementhandle, 1, SQL_C_ULONG, &id, 0, NULL);
            SQLGetData(sqlstatementhandle, 2, SQL_C_CHAR, name, 64, NULL);
            SQLGetData(sqlstatementhandle, 3, SQL_C_CHAR, address, 64, NULL);
            cout<<id<<" "<<name<<" "<<address<<endl;
        }
    }

FINISHED:
    SQLFreeHandle(SQL_HANDLE_STMT, sqlstatementhandle );
    SQLDisconnect(sqlconnectionhandle);
    SQLFreeHandle(SQL_HANDLE_DBC, sqlconnectionhandle);
    SQLFreeHandle(SQL_HANDLE_ENV, sqlenvhandle);
   
}

---

Found on google

---

Dont need it. We already have everything we need inside "NtlDatabase"

Code:

---

// Connect MSSQL

        int rc = NTL_SUCCESS;
        HDATABASE hDB = INVALID_HDATABASE;
        CSampleSqlUnitHelper sqlUnitHelper(MAX_SQL_ID);
        CNtlDatabaseManager databaseManager;
        rc = databaseManager.Create(&sqlUnitHelper, 10);
        if( NTL_SUCCESS != rc )
        {
                printf("failed to create database manager");
                return -1;
        }
        rc = databaseManager.Open("dbo2", "sa", "password", &hDB, 10);
        if( NTL_SUCCESS != rc )
        {
                printf("failed to connect to database");
                return -1;
        }
        databaseManager.Start();

---

and to do a query

Quote:

---

databaseManager.Query( hDB, new CQuery_Account(TEXT("tester2"), "1234") );

---

here is a query

Code:

---

BEGIN_DECLARE_SQLUNIT2( SP_AccountSelect )

        //DEFINE_QUERY( "Select UserID, UserPW from Account where AccountID = ?" )
        DEFINE_QUERY( "Select AccountID, UserPW from Account where Username = ?" )

        BEGIN_VARIABLE()
                DWORD        m_dwAccountID;
                char        m_szUserID[MAX_SIZE_USER_ID + 1];
                char        m_szUserPW[MAX_SIZE_USER_PW + 1];
        END_VARIABLE()

        // ¼ø¼­¿¡ ÁÖÀÇ
        BEGIN_COLUMN(2)
                COLUMN_ENTRY(m_dwAccountID)
                COLUMN_ENTRY_STR(m_szUserPW)
        END_PARAM()

        // ¼ø¼­¿¡ ÁÖÀÇ
        BEGIN_PARAM(1)
                PARAM_ENTRY_STR(SQL_PARAM_INPUT, m_szUserID)
        END_PARAM()

END_DECLARE_SQLUNIT()

---

but I dont really understand

DEFINE_QUERY( "Select AccountID, UserPW from Account where Username = ?" )

i think you get the username with packet,

char* myquery = strcat("Select AccountID, UserPW from Account where Username = ", username);

but the DEFINE_QUERY is :thumbdown:, i think we should make #define getuserDB "Select AccountID, UserPW from Account where Username = "

What is you mssql version 2012 ?

express entreprise etc... ?

express

- - - Updated - - -

Quote:

---

Originally Posted by ATIDOT3

DEFINE_QUERY( "Select AccountID, UserPW from Account where Username = ?" )

i think you get the username with packet,
[/FONT]

---

what? That query get the account id and password from the database where the username -> packet

would look like this
databaseManager.Query( hDB, new CQuery_Account(TEXT(req->accountId)) );

req->accountId = Username which client sent to auth server

Huuuum yes i think it's like this.

@Daneos
good I had to reread to "calm" every page now worked
but because it came from "nothing" as I do not use more "virtualSv" where I'll edit?
[IMG]http://i.imgur.com/uDlUNCF.jpg[/IMG]

http://s7.directupload.net/images/140613/98glxqp5.jpg
... Now I have to understand on how to echo the result.

- - - Updated - - -

Quote:

---

Originally Posted by maximojoni

@Daneos
good I had to reread to "calm" every page now worked
but because it came from "nothing" as I do not use more "virtualSv" where I'll edit?
[IMG]http://i.imgur.com/uDlUNCF.jpg[/IMG]

---

What is wrong?

@Daneos Now to activate things is based on correct data?
MSSQL 2012 which do you use? ultimate?
I'll start thinking about it

How do you call the database manager ?

Quote:

---

// Connect MSSQL

int rc = NTL_SUCCESS;
HDATABASE hDB = INVALID_HDATABASE;
CSampleSqlUnitHelper sqlUnitHelper(MAX_SQL_ID);
CNtlDatabaseManager databaseManager;
rc = databaseManager.Create(&sqlUnitHelper, 10);
if( NTL_SUCCESS != rc )
{
printf("failed to create database manager");
return -1;
}
rc = databaseManager.Open("dbo2", "sa", "password", &hDB, 10);
if( NTL_SUCCESS != rc )
{
printf("failed to connect to database");
return -1;
}
databaseManager.Start();

databaseManager.Query( hDB, new CQuery_Account(TEXT("Daneos")) );

---

added that to the main file from query server. So when I start the query server he will connect to database and run query

Ok ty, now let's find how to print the table value correcly ;).