Exodar Database Project

This post is dedicated to spawning the new areas of the game. We are currently working on Azuremyst, Exodar, and Bloodmyst. Once these are done, we will move on to other areas.

All updates will be released in this first post.


March 2nd, 2007:
Full Tables (SQLyog): HERE
Full Tables (batch dump): HERE
Includes:
creatureinvolvedrelation
creaturequestrelation
creatures_loot
creatures_templ
graveyards
items
quests
sell_templ


world_spawns.txt: HERE
This includes:
Azuremyst Isle: 99% complete: spawned/vendors/quests
Bloodmyst Isle: 99% complete: spawned/vendors
Exodar: 90% complete: spawned/vendors/trainers

Eversong Woods: 85% complete: spawned/vendors/quests
Ghostlands: 90% complete: spawned/vendors
Silvermoon City: 85% complete: spawned/vendors/trainers

Karazhan: 100% complete: Spawned



These probably work best using SQLyog (that is what I use).

If you would like to join my test server and check out the updates before they are released, the server page is at Azazwow BC

ONe of my GM's has been working on this as well all week using online maps and his official accounts. I will extract tonight and post so we can compair/combine and be twice as done lol...

Rook -

excellent !!

Just so we don't duplicate ourselves and we can all save time, here is what we have been working on:

Levels 1 - 30 NPCs in Azuremyst Isle. This includes Exodar.

We are also working on the sell tables for all of the vendors. I will post the Inserts when we are done =)

Ok just like I promised, here is what we have done so far. This is all (or most) of the NPC's that are in Azuremyst including Exodar. This is the creatures themselves, their sell templates if they have one, and their spawnpoints. Hope you enjoy them! (These do not include ones that were already spawned in AceIndy's and Iceman's V3.1).

Sell Templates HERE

Creatures_templ Inserts HERE

Spawn Inserts HERE

EXCELENT
let me chek a little then add to svn ! nice guys lets keep it up!

i think is better to you post your full tables , cuz there is many duplicate entrys..

Ok I am exporting the entire tables for you all. I will have them uploaded in a bit.

Full Sell Table: HERE

Full Creatures_templ Table: HERE

Full spawn table: HERE

Slick wrote:

Ok I am exporting the entire tables for you all. I will have them uploaded in a bit.

Full Sell Table: HERE

Full Creatures_templ Table: HERE

Full spawn table: HERE

your queries are so slow...why to you create the table with double... =\ ?
its better to create before as we do usually :

Code:

CREATE TABLE `sell_templ` (
  `sell_tmpl_id` int(11) NOT NULL auto_increment,
  `creature_id` int(11) unsigned NOT NULL default '0',
  `item_id` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`sell_tmpl_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

and then to import the information...
anyway...great work i was working on it too but i dont have acceses to my account in bli$$ anymore =\

EDIT: somthing is wrong with those table but i dont have time to check more...

It must have been the way I exported them from SQLyog. I just clicked on the table and then Export with structure and data.

Is there another way I should do it?



EDIT: Has anyone tested these files out enough to provide any feedback? I know everything isn't completed yet with the NPC's that are spawned, but a little feedback would be nice =)

well starting zone is ok, but i had to fix factions on every and each npc.. i did that on Silvermoon City when it got released.. but now everything is ok, keep the good work

I also wanted to add that we will be working on Bloodmyst Isle through Monday. I will post results on those in a new thread when they are ready.

espadas wrote:

well starting zone is ok, but i had to fix factions on every and each npc.. i did that on Silvermoon City when it got released.. but now everything is ok, keep the good work

what is correct faction id for draenei npc?
927 is not obviously
so wich one is it?

1638 is for Exodar.

1602 is for Silvermoon.

Tranquillian is 1623

You have to look in the FactionTemplate.dbc to get the correct ones that Kobold uses.

i set mine to 1604...

Edit : This is previous project silvermoon conversion (not recent) and also has the Draenei starting area spawned and veil moths and those mutation things spawned.

Here are all of my 530 spawns, the Eversong/Silvermoon ones are converted...all the draenei ones were hand spawned from maps and official accounts.

hxxp://rapidshare.com/files/17260455/530spawns.sql.html

Rook -

Does this include anything that I have spawned? Can you be more specific as to what you have spawned in here? I have almost all of Exodar spawned, most of Azuremyst NPC's and am working on Bloodmyst as we speak.

im gonna check yours
i was working on gameobjects but ice told me that they almost done converting it...am i getting old ? im only 17 years old =\
anyway , they are doing a great job

(thx for your help ice )

can u give more info ppl?
would like to combine what we have so far but need more info

Ok, on my server here is what we have spawned:

Azuremyst - 90% of all NPC's spawned with sell tables
50% of mobs

Exodar - 85% of all NPC's spawned with sell tables

Bloodmyst - 80% of all NPC's spawned w/o sell tables
60% of all mobs

Quests - About 40% so far for Draenei

We are steady working on the rest and will begin to spawn Hellfire and Ghostlands after these are completed.

I will upload what we have done so far tonight. If someone can instruct me how to extract my full tables in SQLyog so everyone can use them without errors I would appreciate it.

Iceman wrote:

what is correct faction id for draenei npc?
927 is not obviously
so wich one is it?

Draenei npc's faction should be 35.

Gospel wrote:

Iceman wrote:

what is correct faction id for draenei npc?
927 is not obviously
so wich one is it?

Draenei npc's faction should be 35.

lets discus their faction in here
https://legacydevteam.forumotion.com/Legacy-Development-Community-Forums-c1/DB-dev-section-f2/New-Races-npc-factions-p2406.htm#2406

:)

OK..very nice Slick ...but can you only post updates only, not whole tables??
I can't use this table as for LDT purposes, as I do not know it's differences....besides, in order to update correct, people will need world_spawns.txt.

Find your extracted data here: http://rapidshare.com/files/17571526/Azure.rar

This is what I found as addition data to LDT:

• 58 creature templates
  
• 135 sell templates
  
• 127 spawnpoints
  

Hmmm..... well how would I get the latest info from the database? If I have to know each creature id # that I put in, that would take forever! =)

Is there an easy way to get just the most recent updated rows out of a table?

You could try sorting by the faction column...I keep two db's, one live and one for transfering. Sort by faction, highlight all and copy and paste into the blank creatures table and export from there...

Rook -