V13 DB Reconstruction

[byakuyabr]

You have to configure ur windows odbc.

You can find it at: Start->Control Panel->Administrative Tools->ODBC

I guess you have to create "account" and "login" (without double quotes) on system data source.

To learn how to create it you will must have to search on Google.

[FilixXx]

The default username is "sa" and the password is setted through MSSQL installation. The host (Localhost) is think case should be SQLEXPRESS/*computer name here*.

Anyways, trying to do a grandchase server is a great practice. You can always message me if you need help.

[YannicK2007]

omg Yannick is the leecher here never saw him before though i see him at iflyff :/

The Database and the Serverfiles is from me...

A fucking german peoples have release the files >.<

[Blackbox]

A fucking german peoples have release the files >.<

Technically Aeon "released" the files They had to of known someone would of been smart enough to figure it out.

Their mistake, everyone else's gain.

Anyways, good luck to whoever takes on the task of this. Sounds like you'll have your hands busy for a while. o.o

[MisterKid]

Technically Aeon "released" the files They had to of known someone would of been smart enough to figure it out.

Their mistake, everyone else's gain.

Anyways, good luck to whoever takes on the task of this. Sounds like you'll have your hands busy for a while. o.o

nha i don't think he is :P ^^

[Kasoki]

For those who can't find anything, here is a list of procedures and Tables with columns that i've found :

(I got this list by TwiLight !)

[code]
====================================================
= Tables mit TBL Suffix ============================
====================================================

ACCOUNT_TBL

BANK_TBL
- m_apIndex_Bank
- m_BankPiercing
- m_Bank
- m_dwObjIndex_Bank
- m_extBank

BANK_EXT_TBL
- m_BankPiercing
- m_extBank
- szBankPet

CHARACTER_TBL
- m_aCompleteQuest
- m_dwGold
- m_lpQuestCntArray

INVENTORY_TBL
- m_apIndex
- m_dwObjIndex
- m_extInventory
- m_Inventory
- m_InventoryPiercing

INVENTORY_EXT_TBL
- m_extInventory
- m_InventoryPiercing
- szInventoryPet

ITEM_SEND_TBL

GUILD_BANK_TBL
- m_GuildBank

GUILD_BANK_EXT_TBL
- m_extGuildBank
- m_GuildBankPiercing
- szGuildBankPet

GUILD_TBL
- m_nGuildGold


====================================================
= Sonstige Tables ? ================================
====================================================

curr_time
sysobjects

====================================================
= Pr

[Dekokjeroen]

Thx Kasoki :)

[Turion123456]

Kasoki , in the most auf tables is "serverindex" ;)

[Dekokjeroen]

Any Updates DD or others ?

[AccountDeleted]

I'm working on building a scan routine which scans each exe and actually parses the sql execute functions out to re-create each statement... close to getting it fully working but minor bugs then I gotta make it reverse the statements so it re-creates the shit.

[MisterKid]

I'm working on building a scan routine which scans each exe and actually parses the sql execute functions out to re-create each statement... close to getting it fully working but minor bugs then I gotta make it reverse the statements so it re-creates the shit.

0.0 nice hope it works still i have no idea how you do those things :/ im just an beginner :S
well ^^ if you could can you explain that abit :O too lazy too google altough im googleing my ass off to learn some things Eheh well Good Luck

[Dekokjeroen]

So are u gonna release the Db u recreated ? for research etc

[Kasoki]

No, possibly he will release his rebuiling-tool :P

[FilixXx]

From what he said, he's probably going end doing the tool by getting it fully working with bugs fixed and then, release the tool so we can use to scan each exe, allowing us to reconstruct the database.

Good luck DeadlyData.

[Deltaanime]

From what he said, he's probably going end doing the tool by getting it fully working with bugs fixed and then, release the tool so we can use to scan each exe, allowing us to reconstruct the database.

Good luck DeadlyData.

"we"?

I'm pretty sure what'll happen is Deadly will end up doing all the work and, as usual, everyone will go on about how "they" got the DB together

~Fran