[Dev] Archlord Emulator [Help needed]

[archknup]

Originally Posted by botas12

you still don't know what it does?

CREATE TABLE [dbo].[AMT_COUPON_USER

Every line lik this creates a Table in a Database

What i dont know its if has to be at same DB or not

[botas12]

Originally Posted by archknup

CREATE TABLE [dbo].[AMT_COUPON_USER

Every line lik this creates a Table in a Database

What i dont know its if has to be at same DB or not

[dbo] <- DB name without "[" and "]"
[AMT_COUPON_USER] <- table name without "[" and "]"


so yes, all tables will be created on the same DB...

p.s. leave DB for now, we need think how to reverse this one or create from 0...

[archknup]

Originally Posted by botas12

[dbo] <- DB name without "[" and "]"
[AMT_COUPON_USER] <- table name without "[" and "]"

so yes, all tables will be created on the same DB...

p.s. leave DB for now, we need think how to reverse this one or create from 0...

Yep you are right ^^

I also edited the first post with new directions we have to think about

Thanks again ^^

[EpvpFTW]

Originally Posted by archknup

Yep you are right ^^

I also edited the first post with new directions we have to think about

Thanks again ^^

Step by step going to the right direction...

[archknup]

Originally Posted by jin76

hey arch can u tell us how far u got so far and what u need help with so we can try to help u out m8

good luck

Well i try to explain the situation:


This is a Server Emulator for Archlord Episode III "China"

The emulator have a LoginServer a Gameserver and a Database

You can find the database at /ini/ directory, all of the XLS files are the tables of the database, you can import all of this by MS SQL server.

Ok so Lets start with Loginserver:

Each time you run it, it starts to read and load the ini files, but when the serevr try to read the file DBSERVERINFO it crashes, because this file is who point to database and we must translate and edit it.

If we are able to make the loginserver load correct, then we have to start with gameserver.


Lets think about that we have made all Server files to run correctly, and not crash...

Then we still having need to edit the chinese client files to point at the IP of the server we put online

Ok so if im not wrong, Botas12 are saying that we also can make our own emulator, not the chinese one, but with a lot more of work

Anyway im decided to try both thing if neccesary, i really like to do that ^^


Ok so now the Pros and Contras i see:


Using Chinese emulator

Pros: We already have all decrypted files and DB

Contras: Chinese things, really hard to set up, client not stable, and were not able to update in future in any way


Making our own emulator:

Pros: It can be Open Source, English, able to update and improve the server, and a satsifaction of gods when its finished xDD

Contras: Start it from 0



Ok so please if im wrong at anything please correct me ^^

[Havocker]

Originally Posted by archknup

Well i try to explain the situation:


This is a Server Emulator for Archlord Episode III "China"

The emulator have a LoginServer a Gameserver and a Database

You can find the database at /ini/ directory, all of the XLS files are the tables of the database, you can import all of this by MS SQL server.

Ok so Lets start with Loginserver:

Each time you run it, it starts to read and load the ini files, but when the serevr try to read the file DBSERVERINFO it crashes, because this file is who point to database and we must translate and edit it.

If we are able to make the loginserver load correct, then we have to start with gameserver.


Lets think about that we have made all Server files to run correctly, and not crash...

Then we still having need to edit the chinese client files to point at the IP of the server we put online

Ok so if im not wrong, Botas12 are saying that we also can make our own emulator, not the chinese one, but with a lot more of work

Anyway im decided to try both thing if neccesary, i really like to do that ^^


Ok so now the Pros and Contras i see:


Using Chinese emulator

Pros: We already have all decrypted files and DB

Contras: Chinese things, really hard to set up, client not stable, and were not able to update in future in any way


Making our own emulator:

Pros: It can be Open Source, English, able to update and improve the server, and a satsifaction of gods when its finished xDD

Contras: Start it from 0



Ok so please if im wrong at anything please correct me ^^

I dont know if it will help you, but i can encrypt the ini files of the Webzen Client, so i have my own mysql database with all Items,Monster etc.

I know something about the ini files, which ini needs another ini file to get the stats of an item maybe. what i dont know is to get the textures, but i know the ID´s and the Texture ID´s of all Items. So its possible to edit the Ini Files. Maybe the Spider Potion can be an Archlord Potion and so on. Spawn Points of Monster or the Gifts of Quest´s can be Changed.

DropRate & DropRank of Item´s and Chance by the Monster can be changed.

And its possible to unlock the "new" Items that not available now in Webzen Archlord =D

so far (sry for my english, i am german =D)

PS: all i can do is to create an Game Database for MySql or MS Sql for VB, XML, MS ACCESS and u can update it

[archknup]

Originally Posted by Havocker

I dont know if it will help you, but i can encrypt the ini files of the Webzen Client, so i have my own mysql database with all Items,Monster etc.

I know something about the ini files, which ini needs another ini file to get the stats of an item maybe. what i dont know is to get the textures, but i know the ID´s and the Texture ID´s of all Items. So its possible to edit the Ini Files. Maybe the Spider Potion can be an Archlord Potion and so on. Spawn Points of Monster or the Gifts of Quest´s can be Changed.

DropRate & DropRank of Item´s and Chance by the Monster can be changed.

so far (sry for my english, i am german =D)

So if we open the XLS from this china emu maybe we can find all the data, because all the variables are at english, but the names ando so are at traditional chinese and we can translate it

[Havocker]

Originally Posted by archknup

So if we open the XLS from this china emu maybe we can find all the data, because all the variables are at english, but the names ando so are at traditional chinese and we can translate it

yes i saw it too, but if u are create ur own Emu, i can help u to create the Game Database for U

[archknup]

Examples:

[archknup]

Originally Posted by Havocker

yes i saw it too, but if u are create ur own Emu, i can help u to create the Game Database for U

Your help will be so great my friend

But first we all have to decide what to do, if we work with thsi china emu or make new one ^^

[Havocker]

Originally Posted by archknup

Examples:

=D, i know this problem, if u put this Data into a MySQL Database u can translate this with the Pacific Version of ini Files. Each Row has a Name that use an ID these ID is the Lead for the translate, with the ini Files of Webzen.

So i created my own english Client for the korean Version. It works not correctly for the korean Version cuz they are higher in Episodes but what Webzen has included in the Client i can use in korean.

So it can work for the Chinese Version, or u make ur own Emu

[archknup]

But that will crash the server if we dont modify all the client, right?

[Havocker]

Originally Posted by archknup

But that will crash the server if we dont modify all the client, right?

not really, the ini files in the Client have only the function to show all texts or items etc. the game and server DB must only working to take and send the files for game clients and their stuff. like the AION Emu from Nova... but i dont know how u can create an working P-server, i can only show u to create an english Game Database like this:

[archknup]

Edited:

The english database was the first thing i was making before, i was importing it to mysql from the china files, but then we saw that the database are from MS SQL Server

The import can be done easy

If we be able to conigure & run the china emu the last thing to do will be translate ini files for client, and the game will be english

[Havocker]

Originally Posted by archknup

But if i have webzen client with new npc quest etc whien it calls the db about a quest or db its not listed the DB will not respond.. it will crash?

i cant say anything about programming for server emu or something else, only what i know is that ican create for u a game database.

what ive done with the korean version is only a translation