how to populate a database with items, quest zones etc

[Zedd_RD]

hello everyone i am new to world building. so can so one please explain to me how db work in eq. Can some of the World builder give a rough guide on how to start building zones like they have!! please! since i install eqemu 5 , i can;t figure out the database structures, since i really how they function i can build complres databse in access.
can someone please help out?
thank you :wink:

[a_Guest03]

Zedd, I don't build worlds myself, but I'll try to give you some information you should find helpful.

Worldbuilding relies on a database. We use a database program called mysql (www.mysql.com). If you don't know anything about it, go to the website. Database manipulation takes time to learn, and everquestserver.com is not the place to learn all of it. If you are familiar with hosting a database, this shouldn't be TOO hard for you.

Worldbuilding/ EQlive emulation

A program called packetcollector exists. It searches the live everquest for items, and populates their data into a database that is made available to everyone. The developers make it available to us. You can look at the items in the same fashion as "lucy", the item and spell information site. These items (http://www.everquestserver.com/items.php) are available to view (http://www.everquestserver.com/search.php) or to download (http://prdownloads.sourceforge.net/eqemu/dumpeditems.sql.gz?download).

Editing a database

tcsmyworld is producing the best emulated database (http://npcmovdb.eqemulator.net/MWnpcmovDB_050_alpha0_3_3.zip) so far. It has movement, and is like everquest live.

If you search the 3rd party tools (http://www.everquestserver.com/forums/viewforum.php?f=10) forum, you'll find much information about programs that exist to help build worlds.

This is as much information as you will learn without venturing out into database editing for yourself.

EDIT: For structures that you don't understand, I suggest you read the guide that Magick produced (see signature for link) to see if it's covered. I also suggest that you use the SEARCH (http://www.everquestserver.com/forums/search.php) function. Much of this has been covered, but perhaps not all of it. If you need help with exact structures, try posting which parts you don't understand.

[capusr5]

I download an ODBC driver from www.mysql.com and used MS Access to connect to the DB from my 2nd PC. Working very well and allowing me to twink some things very easily.

If you know something about that, it will help you a lot. Most things about what each table does I discovered them myself via that way and trial+error

[Kgaul]

One step further is to dl the MySQL CC (command center) from

www.mysql.com

from there you can rock your db. gives you information from the privileges tables and Grant to the DB's on your server. it also gives you a very easy to understand GUI with all the info present...


Kgaul

Please pm me if you need help with MySQL

[Zedd_RD]

thanks for the help people , for those of u that are world builder why didn't u check this sit out www.planeshift.it it's a website of a free mmorpg game called planeshift. this game aims to be as successful as EQ!!
and they need lots of people to help them particular developers.

[a_Guest03]

I think I was the victim of a bait and switch... Did you want to advertise or did you want help?

[hellsbell]

Regardless of undesired advertising, :x

a_Guest03,

you were able to give me alot of good links/information on this thread.

Thankyou! :D