database "archeage_world"

[DancerS]

Hello, what if you try to create and fill the archeage_world database? I have a sqlite database, which I rebuilt in sql ... But as I see Gameserver it's not even looking for it.

Archeage_world

[NL0bP]

From which version of the client?

[DancerS]

it's still an old database April 2013. But I think already at least something =)
I can translate data from the database version 3.0, but I do not know how to remove the crypt)

[NL0bP]

This is a problem with the removal of crypt.

[DancerS]

I think for testing you can try to use this database for now. It has a lot of information

[NL0bP]

I have similar database files in Russian-Korean language.

[DancerS]

so why not take data with it? there are all the NPCs, mob's, quests ... I though not a programmer, but I think it's easier than completely all the packages to paint. Yes, and in the database there are data on the menu, skills and more

[DancerS]

I think not in vain all the same in the gameserver there is a database and connect it I think it's just ... P.S And when I dug in the client files (game.pak) for a long time, I found .xml with NPC coordinates. Maybe the information was useful) Thanks for your work)

[NL0bP]

Before using the database is still far away. We still can not create heroes and delete them.

[JeyFrey]

I guess we need a new database, that saves character data like name, classes and stuff. From looking at databases in BDO and Aion, we might be able to try around a bit, maybe we get to the point where we have the right syntax and structure.
But thats just from a layperson.

[Boblarico]

http://ok-torrent.ru/torrent/archeage-3003ut-2013-pc-online-only

[Rain0Ash]

What is it and why is it needed? It would have been better if it has been version 1.x.

[sxeroot]

im kinda confused by that it sais 2013 but client im assuming the 3003 means 3.0.0.3 release atleast on eu/na was at around 2016 so if that client is 3.0 and from 2013 maybe the compact.sqlite is still unencrypted.

anyone with fast download speeds can confirm it by downloading/extracting?

[Boblarico]

likewise ..
I go downloading and test
he lack the «archeageworld » sql

[Rain0Ash]

Now I read rf-cheats, it says that the encryption was introduced in 1.8, and the date of the torrent is 17.12.2016. Therefore, I think it makes no sense. I have db 2.0, it is also encrypted in a new way. On piratebay lie the torrents cbt, obt, and v1.2, but no distributors.

compact.zip

[sxeroot]

all the compact.sqlite3 and i assume, until proven otherwise, the newer encrypted ones also lack some tables that would be needed like spawntables those are prolly never were included in the client database as from what i can tell most of the database is to have less server interaction on things like getting recipes etc and not having to code it each time when you add or change one.

so i think on filling most of the database will still have to e done manually more or less.

[sxeroot]

quick add to my previous statement, did some research so to speak and came up with that the russian clients started or atleast at some point included a compact_server.sqlite3 which would be the database needed for the server.

[Rain0Ash]

Maybe this http://megaoblako.ru/games/456-archeage-l-rus-rus-2013-10-rossiya-klient-ot-150214.html (https://cloud.mail.ru/public/cdaf4fb889b9/Archeage_enotbox.com.rar) old client (v 1.0), but i not sure. I try to download it.

[Rain0Ash]

Update. Looks good

After about 10 hours I'll unpack it.

[Rain0Ash]

I unpack it. It really v1.x version (I saw the verse version 1). But when i try to start it, his open https://games.mail.ru/support/aa/#/questions/1515

[Rain0Ash]

I need to bypass this check, any ideas?

[Rain0Ash]

P.S.

https://drive.google.com/file/d/1stbg2-BUbp936ZdRwnJ0kxGDOT34nxvd/view?usp=sharing
fa 9b 0b 4d 16 c0 02 16 60 01 da 7d 8a b4 0b 45 key

[Rain0Ash]

decrypted.data (key)
https://drive.google.com/open?id=1cEBLl9-IMcNhaTBk9cBP3KULaQUC23_9
decrypted base
https://drive.google.com/open?id=1mIWfpiZxS1aDL1CO1xT5xfusBTjV4P5D

example

[Boblarico]

we must work together and not give up !

[Rain0Ash]

Yes. And I believe that we should not try to copy the current server, and ---train-on-cats--- try something like classic. If we can run the client 😄. But this I just dream.

[Boblarico]

it's possible ! 🙂
But we must continuous the projet..
As ArchRage and better

[12darko]

I'm japan AA Player. I am sorry Russian and English are poor at me. It writes in English using a translation engine. It may be the already known information. I found how to decrypt compact.sqlite3. Step1. Unpack game_pak(compact.sqlite3) ->ArcheAgePackTool Step2. create decrypted.data ->ConsoleApplication1.exe Step3. add compact.sqlite3 head 16byte zero Step4 decrypt compact.sqlite3(with head16bytezero) aes 128 cbc,padding none,key&iv=decrypted.data Step5 remove head16byte from decrypt result ->decrypted.sqlite3 The file of sqlite3 which can be read was able to be acquired in the above-mentioned way. Japanese client PS. ArcheAgePackTool、AA-CDB、archeagedatabase.net is very useful. thank you. //Does anyone know anything about this? 2018-08-16 14:43 GMT+03:00 Projet Dharma <[email protected]>:

…

it's possible ! 🙂 But we must continuous the projet.. As ArchRage and better — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#4 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ANBL5Zy2ltMpmR2tK-Lad8r0AQH5xOfDks5uRVrUgaJpZM4V5qbz> .

[Kalle801]

The v1 client's database is also encrypted.

[Kalle801]

I also found this besides the databse in the cliend:
select SUM(LEN(speech)) from quest_chat_bubbles;
select SUM(LEN(text)) from quest_context_texts;
select SUM(LEN(text)) from quest_component_texts;
select SUM(LEN(name)) from quest_contexts;
select SUM(LEN(name)) from quest_names;
select SUM(LEN(name) + LEN(description)) from items;
select SUM(LEN(name) + LEN(desc) + LEN(web_desc)) from skills;
select SUM(LEN(name)) from npcs;
select SUM(LEN(name)) from npc_nicknames;
select SUM(LEN(name) + LEN(desc)) from buffs;
select SUM(LEN(name)) from doodad_almighties;
select SUM(LEN(title) + LEN(desc)) from crafts;

[DancerS]

I tried everything I already know, but I could not remove this error in the database. Maybe someone knows how to fix it?

[Warning] failed: invalid polymorphic type: FlyingStateChangeEffect - decrypt.sqlite3
where this fix on bd ?((

[12darko]

where do you get this error

[Kalle801]

I found this SHA1 code in Archeage.exe: 4b23a29352c5d6c96d169c15aebb96c29d5e7b4c

From the given client above (URL)

[DancerS]

12darko,
I got this error when I tried to run the original server and the original Archeage files). You need to solve this error and if everything turns out, then I'll throw off the dedicatedserver.exe worker)

[NL0bP]

@DancerS lay out please, I couldn't adjust dedicatedserver.exe

[DancerS]

@NL0bP this file is original sourse server... and files megamax.
I configured some configurations and wrote my own .bat, if I run them, I think it will be much easier. I have already run them for a long time, in the distant 2014 =)

[DancerS]

@NL0bP If you manage to launch the original server, please tell me how you did it ...)) Personally, I have an error with the database ...
https://drive.google.com/file/d/1tusjXwB-sP_AEq4cnfLnbO03eFcmOaop/view?usp=sharing

"README FILES" - the file instructions that I added there

[Boblarico]

I go pay a DEV for coding and Decrypt the database

[JeyFrey]

@D365i Do you have someone who can do that or are you just saying you would in case you find someone?

[Boblarico]

@JeyFrey
I have found someone for the coding

[JeyFrey]

@D365i Sounds good. Any chance that person will join our discord?
And can you tell us the name? Just so if its some known scammer we may keep you safe.

[Boblarico]

👌🏻 Success
For 150$ the coding ..
Joint your Discord ?
But I would share archeage-emulator-server

[JeyFrey]

Wow okay sounds good, where did you get the guy from? Sounds very interesting.

Yea check our discord, link can be found on the discord tab in the wiki section of this project.

[Boblarico]

has already his name of projet-dharma
I am sorry
I have found a coding in a developper website

[JeyFrey]

@D365i
Okay please keep us up to date!

[Boblarico]

Good
I come back
and I you give ArcheAge-emulator full

[DancerS]

@D365i this is excellent) go into the discord, throw the files into the channel files

[Boblarico]

Okay
Send me the Discord please
it’s possible having archeageword sqlite3 decrypts for the Dev
from the version archeage for the server please

[Rain0Ash]

@D365i https://discord.gg/vn8E8E6

[Boblarico]

Thank you