How to Import Quests and Instances from Original Gamefiles'n/Folders to the Databes?

[troniac]

Hello Everybody,

May someone explain me how the Quests will imported into the Database?

I've Mysql skills and can write an automated import proceedure. But I don't know where to find the Quest and Instance information from the MPQ Files!

Please someone could explain me where the Quest Informations is stored in the Gamefiles? :rudolph:

Or may someone tell me who I could ask for this problem?

Wish you all a great time playing BC 2.0.6!

It's a great work!!!

 

[DJRavine]

check out MDH ->

To view the content, you need to sign in or register

or logging to ur mySQL server using sqlyog...
there are a number of tables to backup..
and MDH will do it for you...

 

[troniac]

Thank you for your answer!

I'd installed the newst MDH rev. 247 to my computer where the SQL Server is running. Fild out the fields which are needed to communicate with the SQL Server but I got a serious warning and nothing work!

"Your configuration file is wrong, modufy your options...
You have specified an invalid column ordinal."


May you have a solution for this error?

I tried this five times.

 

[Zika123]

ye just downloaded the database handler ( newest version )

and i'm getting serious errors to.

 

[troniac]

Converting Quests to SQL Format

I don't fixed the MDH Problem I tried many things but if it says Write into Mysql DB... the error occures!!! :slap:

My first question is just where to find the Quests in the Original Game. I noticed too that many instances are not implemented into the database, they are empty no enemy and no logout, spell and any intersection with NPC's is working!!!

How can I fix it?

I just want to know where I can find the Quest Informations in the original WOW GAME FILES. The Batch file to convert the Datastructure into SQL is an smaller problem I think. The Converter I can write but without data I can't write any converter.

I write the Converter in C# Programm, it will be an executable file for Windows and Linux.

So as faster I get the Quest information as faster I can write the converter.

best wishes to all!!!!

 

[waxman]

Well if you wanna extract the quests and NPC-s from the game files yourself you better see the silverDB development forums:

To view the content, you need to sign in or register

Or the EP forums on

To view the content, you need to sign in or register

They have a section about analyzing DBC files from the game.
Maybe this will help.

 

[Yamachi]

Lol! I laughed my arse off when I read this... ^_^ Not being mean or nothing because you're obviuosly new and have no idea how WOW PSs work, but you CANNOT extract "quests" form the MPQ files... XD Quests are SERVER-SIDE, along with many other things. Otherwise, you'd have to have an update EVERY single time bl!zz@rd decide to add/mod a quest...

 

[troniac]

Lol! I laughed my arse off when I read this... ^_^ Not being mean or nothing because you're obviuosly new and have no idea how WOW PSs work, but you CANNOT extract "quests" form the MPQ files... XD Quests are SERVER-SIDE, along with many other things. Otherwise, you'd have to have an update EVERY single time bl!zz@rd decide to add/mod a quest...

Yes, thought this way. That the quests are server sided, but how may the Emupedia or Silver Crew get the quests. I will ask there, if I can help I will do! I've many experience in Networking programs. But this skill may be not needed because World of Warcraft could log any quest or NPC Information via the Addons who have write access to the Harddisk. But I don't want to say something wrong I just ask there!

Thank you for your comment and you given me a better view of this all!

All the best to anybody!

 

[Yamachi]

Well, the best place to get quest information form is

To view the content, you need to sign in or register

 

[troniac]

Yes I know this site thank you! I will capture some quests from there and get some from buffed.de it's the best I think.

I know many Quest Databases on the Internet, like

buffed.de - Nearly all German Quests
wow.allakhazam.com - Nearly all US Quests

For Spanish or French I don't know where I could find some, I don't speak this languages scus' me!