[Release] Aura Kingdom Server Files

[NanayaQ]

Nice, AK files still it feels like something is missing. Also does it only use pgSQL? or can it be mysql etc... because I was looking at the gatewayserver logs after I executed the qd file just to see what its missing (I know the db is missing or whatnot after reading this post).

2,2015/08/22 17:35:04,[EVENT] Use PgSQL.

Edit: there also something about .../config00-07.ini, GMCmd.ini and GMCmdOnce.ini don't know if those are important or not. Also in the Data folder I assume db folder is database and those ini file are the db file?

Edit2: Idk if anyone got the serverstatus.sql or world.sql to work but this is what I see on my error log on world, zone, and mission server logs with similar errors.

     1,2015/08/22 18:58:04,DBAEvent Save Period 1200   163,2015/08/22 18:58:04,Connected to database [akdb].
   164,2015/08/22 18:58:04,Connected to database [akdb].
   165,2015/08/22 18:58:04,Connected to database [akdb].
   166,2015/08/22 18:58:04,ExecTuplesOk Failed:ERROR:  relation "serverstatus" does not exist
LINE 1: SELECT int_port from serverstatus where id = -2
                             ^
   167,2015/08/22 18:58:04,[FAIL]  "SELECT int_port from serverstatus where id = -2" failed due to [ERROR:  relation "serverstatus" does not exist
LINE 1: SELECT int_port from serverstatus where id = -2
                             ^
].

Still doing some testing and stuff.

 

[PalmR84]

Nice, AK files still it feels like something is missing. Also does it only use pgSQL? or can it be mysql etc... because I was looking at the gatewayserver logs after I executed the qp file just to see what its missing (I know the db is missing or whatnot after reading this post).

2,2015/08/22 17:35:04,[EVENT] Use PgSQL.

Database script files missing.
I find out on chinese board (soke163, iopq, jiutu9).
Be same all still no db script.

P.S. Little hope that will be shared from Towan

 

[Evencelance]

It would be good if more and put a guide for launching

 

[morbitangel]

Yes. I was able to completely run the server.

running the server and showing a screen of the channel/server selection is something completely different from being able to log in game.
how did you manage to get ingame did you actually reconstruct the databases already? a little more info than a 'yes' would be nice....

 

[DarkSkeleton]

Currently Towan writing tools Aura Kingdom...

(I'm sorry for my bad English)

 

[Eperty123]

Currently Towan writing tools Aura Kingdom...

(I'm sorry for my bad English)

I assume that means he's working on a tutorial?

 

[DarkSkeleton]

I assume that means he's working on a tutorial?

No, we reverse server and client side, we have an almost complete database.

 

[Eperty123]

No, we REVERSE server and client side, we have an almost complete database.

Sounds great! I hope you guys will manage to complete it!
- Also will a tutorial be available once you finish it?

 

[Dzver]

@ everyone else: I will check chinese forums for more info or any other releases and will report/share it here whenever i find anything.

unpacker (untested since i dont have any client atm):

    #quickbms sript
    #幻想神域 Online
    #http://ff.x-legend.com.tw/#
    open FDSE pkg.idx
    get files asize
    math files - 0x124
    math files / 0x250
    goto 0x124
    for i = 0 < files
    get FILENUM long
    get OFFSET long
    get unk02 long
    get ZSIZE long
    get unk04 long
    get unk05 long
    get unk06 long
    get unk07 long
    get unk08 long
    get unk09 long
    get unk10 long
    get unk11 long
    get unk12 long
    get unk13 long
    get SIZE long
    getdstring file 0x104
    getdstring NAME 0x108
    string NAME + file
    get packfile long
    get unk15 long
    if packfile < 10
    set pname 0x3030
    string pname = pname
    string pname + packfile
    set var string "pkg"
    string var + pname
    string var + ".pkg"
    open FDSE var 1
    elif packfile < 100
    set pname 0x30
    string pname = pname
    string pname + packfile
    set var string "pkg"
    string var + pname
    string var + ".pkg"
    open FDSE var 1
    elif packfile < 1000
    set pname ""
    string pname + packfile
    set var string "pkg"
    string var + pname
    string var + ".pkg"
    open FDSE var 1
    endif
    if ZSIZE != SIZE
    clog NAME OFFSET ZSIZE SIZE 1
    else
    log NAME OFFSET ZSIZE 1
    endif
    next i

Credit to chrrox @ NifTools

 

[Eperty123]

Selfish people like you makes me think twice to release anything here or keep it. So i am not going to share anything because people like you know only how to leech and keep it for themself and at the other side people with less knowledge still trying to figure out things weeks after and at the end give up.. The same people that gave you that incomplete or not working at that time source. If you know how or have something usefull why you have to keep it just for you? Why if they didnt share it with you? What would you do without their source? Why if this guy didnt released this files? Think. Dont be selfish.

@ everyone else: I will check chinese forums for more info or any other releases and will report/share it here whenever i find anything.

I'm with you on finding any useable informations.

 

[Towan]

 

[Eperty123]

Great, now we just need a proper tutorial on how to set up a server and get the databases working.

 

[Evencelance]

It is very very logical, because if no one share, then none of this would have been, is not it dear, who is here now is selfish?

 

[Dzver]

Unpacker: (removed, dont ask why)

Official thread:

You must be registered to see links

 

[idontknowlol]

Can you do this for Eden Eternal's server files as well?

(Ik this has nothing to do with AK)

 

[Eperty123]

I can confirm that the files work. The tables are the only thing that's missing for the servers to work properly.


Edit: i will make a tutorial on setting up the server environment once we get our hands on the databases.

 

[masterpop2014]

I share my unpacker This put it within the pkg folder, then run it and the program does the rest. It works with any version.


Appreciation ProGramerCity

Link......>

You must be registered to see links

ATT: Masterpop

 

[jojomihijo]

quickbms for unpacking is good, but quickbms is not for repacking , because quickbms only reimport
so if you want repack files bigger than original, quickbms can not do it

@ everyone else: I will check chinese forums for more info or any other releases and will report/share it here whenever i find anything.

unpacker (untested since i dont have any client atm):

    #quickbms sript
    #幻想神域 Online
    #http://ff.x-legend.com.tw/#
    open FDSE pkg.idx
    get files asize
    math files - 0x124
    math files / 0x250
    goto 0x124
    for i = 0 < files
    get FILENUM long
    get OFFSET long
    get unk02 long
    get ZSIZE long
    get unk04 long
    get unk05 long
    get unk06 long
    get unk07 long
    get unk08 long
    get unk09 long
    get unk10 long
    get unk11 long
    get unk12 long
    get unk13 long
    get SIZE long
    getdstring file 0x104
    getdstring NAME 0x108
    string NAME + file
    get packfile long
    get unk15 long
    if packfile < 10
    set pname 0x3030
    string pname = pname
    string pname + packfile
    set var string "pkg"
    string var + pname
    string var + ".pkg"
    open FDSE var 1
    elif packfile < 100
    set pname 0x30
    string pname = pname
    string pname + packfile
    set var string "pkg"
    string var + pname
    string var + ".pkg"
    open FDSE var 1
    elif packfile < 1000
    set pname ""
    string pname + packfile
    set var string "pkg"
    string var + pname
    string var + ".pkg"
    open FDSE var 1
    endif
    if ZSIZE != SIZE
    clog NAME OFFSET ZSIZE SIZE 1
    else
    log NAME OFFSET ZSIZE 1
    endif
    next i

Credit to chrrox @ NifTools

 

[Towan]

Hello everyone else. Who else was able to recover the database? I got about 80-90 tables.
--
I also wrote a packer/rebuilder. Packaging resources and edit them I succeed.
--
Also, the server runs completely without error.
But a problem in the client. I already tested 10 clients, and each crash at different places, the packets do not match, then somebody else.


We need now to find exactly the right client version.


(As for the guide/tutorial, I began to prepare it, but time is not enough. There are other things for which I have no time on the server.
As for the database, there is still a lot of that rule, since the first Recover it, I mixed up some types of columns currently fixes this)


If someone could also run completely restore the server and database, please write to this topic.

 

[Eperty123]

Hello everyone else. Who else was able to recover the database? I got about 80-90 tables.
--
I also wrote a packer/rebuilder. Packaging resources and edit them I succeed.
--
Also, the server runs completely without error.
But a problem in the client. I already tested 10 clients, and each crash at different places, the packets do not match, then somebody else.


We need now to find exactly the right client version.


(As for the guide/tutorial, I began to prepare it, but time is not enough. There are other things for which I have no time on the server.
As for the database, there is still a lot of that rule, since the first Recover it, I mixed up some types of columns currently fixes this)


If someone could also run completely restore the server and database, please write to this topic.

If you can provide the SQL's I can help with making a tutorial as well as helping out with the columns and additional bug fixes.