[Tutorial] AKCore setup from start to ingame and online

[SanGawku]

Today's tutorial will focus on setting up a Localhost or Online instance of Dragonball online
using the AKCore server.

Prerequisites

Very few things are needed for compiling the server.

1. Boost 1.55.0
2. x86 MySQL C Connector
3. x86 MySQL C++ Connector
4. A MySQL Database
5. Microsoft Visual Studio 2010 Ultimate
6. DBO Korea 0.50.9 (This is a 70% translated version of it)
7. AKCore Software
8. Microsoft Applocale (This is to see text correctly)

At this point I am going to assume you have already installed your database software, visual studio, and the MySQL connectors, and you have downloaded AKCore and Boost.
Compiling


Extract the AKCore software to someplace easy to navigate to IE:"C:\AKCore"


Copy your everything from INSIDE your boost download to Server/NtlDatabase/mysql/boost When your boost folder looks like this it is correct.



Next in the NtlDatabase folder open mysql_wrapper.h and change the IP_SERVER_ALL to your external IP if you are setting it up for an online instance. otherwise change it to
127.0.0.1



Now select the Debug/win32 configurations and compile.
Congrats you are done with this section



SQL

Create a new database called dbo in your MySQL instance.(Must be named DBO)

import the SQL file from the SQL folder.


Create your first account by manually entering it in your accounts table.


NOTE:Currently you need to have an account called root@localhost for the stored procedures to work. You can change this by changing your definer to anyusername@host combination.

You can do this in navicat like this


Or change your definers to username @ localhost like so
do that for all your functions if you dont want to have an access anywhere account to spoof your functions.




Configuration

Now that you have everything compiled you can setup your server.
Go into the debug folder in the root directory (AKCore) there is only 1 file you need to edit: Server.ini

Set it to your INTERNAL IP IF YOU ARE USING ONLINE SETUPs.
Set it to whatever your ip is on your network 192.168.1.xxx or whatever the case may be.
If you arent using online setup you can leave it as 127.0.0.1

Set your database credentials in this file as well. If your root account has no password use NULL for the password



If you are making an online server. Make sure you have the ports in your config file forwarded in your router Each router is different so it is up to you to determine how to forward the ports. Afterwards Run the file RunServers.Bat and your servers are running congratulations.




Now lets get in game shall we?

Client Configuration

Client configuration is very easy
Set your ConfigOptions.xml

so it looks like this

<?xml version="1.0"?><config_options>
    <op ver="0.1" ip="YOUR_LOCAL_OR_EXTERNAL_IP" port="YOUR AUTHSERVER PORT"/>
    <local ver="0.1" local_dsp="Language\local_data.dat" local_sync_dsp="Language\local_sync_data.dat"/>
    <BUGTRAP ip="YOUR_LOCAL_OR_EXTERNAL_IP" port ="YOUR AUTHSERVER PORT + 1" folder="DBO Client(CJI_Release)" />
</config_options>

Run your client and have fun!

Spoiler:

and have fun.

Credits to Everyone who is helping us make AKCore.
Current list of contributors current and past in no particular order: @ATIDOT3 @Daneos @luiz45 @kalisto2002 @Jupeyy @NicoElPatron @Nicolas321 Madrid252



- - - Updated - - -
@Biesmen Is this a good qualifier for the 1 year sub :)

[MentaL]

[Madrid252]

Good Tutorial bro, it will help alot of people that have some problems compiling and configurating it

[kidunseen]

anyone have any idea how to fix this ?
http://postimg.org/image/d9gxztz33/

[SanGawku]

Are you doing online or localhost?

[kidunseen]

online using hamachi ip i try local host still wont work.I believe it has something to do with my ports ill try changing them.
also forgot to show this
http://postimg.org/image/qypl1f7en/

[SanGawku]

This is not for hamachi. You have to compile IP_SERVER_ALL with either your external ip you can get from whatsmyip.org
Or 127.0.0.1, But what this looks like is a client configuration error.

As you would see in the authserver that you have connected to it.
Please either use Online(without hamachi) or localhost only.

Make sure your configuration in server.ini is correct and your ports are forwarded correctly for online usage/

[apofis]

@kalisto2002 everyrhing workks good but I have problem wit this error after 5 min 'playing' any idea wht is a problem and how to fix it -- http://gyazo.com/0749838949f4aaec139923b823323e78

[SanGawku]

Your error is cause your ip is wrong inside your server.ini. Dont bother changing your ports use your networked ip or 127.0.0.1 for your ports and maybe that will work for you cause i dont know how hamachi works.

- - - Updated - - -

As for you @apofis try doing it with localhost and play for 5 minutes see if you still get the same error.
Remember this source code is in constant development. And we make commits daily. Try just playing around on localhost I am pretty sure this error has something to do with it being online but wasn't present a week or so ago. I will go through the code and see what has changed to cause this.

[apofis]

Ok gonna try now.. You see the problem is whn i die in game whn mobs kill me i press respawn and char respawn and then after 30 sec GameServer crash and show me that error... But whn i don't die same error - GameServer show me that error but after 5 - 10 min playing..

[kidunseen]

nothing seems to work but ill keep trying

- - - Updated - - -

can you tell your ports for server.ini.

[apofis]

mine are this - http://gyazo.com/87cc97d6cf1ca51f60b577768242f5b8
end on configopt are this - http://gyazo.com/c5c316ac6505f763b763dc6679d9133b

[SanGawku]

Dont set your bugtrap to your gameserver port. that is probably what is causing your crashes. Set it to 20201

- - - Updated - - -

Btw the configuration is literally setup for localhost already. Compile, Put in db info, play.
Online doesnt take much. If you are not correctly configuring your server. YOU have done something wrong.
Erase the server folder and start again from boost installation.

[kidunseen]

thanks @apofis seems like only local host ip are working and not hamachii put ill try to work it out but it working now

[apofis]

I change port in 20201 and sam error whn mobs kill me and i respawn after 15 sec that GameServer error shows. :/ maybe its a problem in that visual studio 10.0 hmm ??? idk realy

- - - Updated - - -

[kidunseen]

this made me laugh idk why it seem funny to me but i cant see myself now xD ?
http://postimg.org/image/9521g0t5j/
also this wtf hahahah you deves are too funny
http://postimg.org/image/9d5ubl5mz/