Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

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

Newbie Spellweaver
Joined
Feb 6, 2007
Messages
7
Reaction score
0
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!!!
 
Experienced Elementalist
Joined
Aug 7, 2006
Messages
271
Reaction score
0
check out MDH ->

or logging to ur mySQL server using sqlyog...
there are a number of tables to backup..
and MDH will do it for you...
 
Newbie Spellweaver
Joined
Feb 6, 2007
Messages
7
Reaction score
0
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.
 
Newbie Spellweaver
Joined
Jan 27, 2007
Messages
84
Reaction score
0
ye just downloaded the database handler ( newest version )

and i'm getting serious errors to.
 
Newbie Spellweaver
Joined
Feb 6, 2007
Messages
7
Reaction score
0
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.:lol:

best wishes to all!!!!
 
Newbie Spellweaver
Joined
Sep 12, 2006
Messages
20
Reaction score
0
Well if you wanna extract the quests and NPC-s from the game files yourself you better see the silverDB development forums:

Or the EP forums on
They have a section about analyzing DBC files from the game.
Maybe this will help.
 
Banned
Banned
Joined
Oct 20, 2006
Messages
3,245
Reaction score
1,652
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...
 
Newbie Spellweaver
Joined
Feb 6, 2007
Messages
7
Reaction score
0
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!
 
Banned
Banned
Joined
Oct 20, 2006
Messages
3,245
Reaction score
1,652
Well, the best place to get quest information form is
 
Newbie Spellweaver
Joined
Feb 6, 2007
Messages
7
Reaction score
0
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!
 
Back
Top