Page 1 of 1
Database Question
Posted: Sun Apr 18, 2010 4:08 pm
by abndrew82
Hello
I am looking at creating some customized zones for me and my brother to mess around with.
I have been reading through the guides but have a question about the Database Layout
What Table are the actual Mobs in, I see NPC Spawns and spawns but nothing for Creatures or NPCs as I had expected.
So curious what table I need to look into to find NPCS to be able to spawn, and appearance IDs if I want to create my own Creatures.
Thanks Much
Drew
Re: Database Question
Posted: Sun Apr 18, 2010 4:15 pm
by Scatman
Check out the spawn_location_* tables. They dictate where spawns spawn, chances, etc. The easiest way to setup a spawn is probably to use /spawn create to initially create it, then use /spawn set to set features about it in game.
Re: Database Question
Posted: Sun Apr 18, 2010 4:22 pm
by abndrew82
K I understand that but I guess my main questions is where are the creatures at in the DB or are they not and need to be created for everything
Meaning say I want to spawn a Gnoll or Orc in Lavastorm
I can use the /spawn create command to create the spawn
But that command needs the following info I think
npc 203 1 50 'Lady Vox' 1 32
Where do I find all the information
Such as what Lady Vox's ID is or what the ID is for a basic Orc / Gnoll, is there a table in the DB that I can look at that lists all Mobs that can be spawned in the game.
Thanks
Drew
Re: Database Question
Posted: Sun Apr 18, 2010 5:11 pm
by Zcoretri
Look at the appearances tables for a list of ID's for creature you can spawn.
So for the example you gave, you will find that creatures/monsters/vox has an appearance_id = 203.
Re: Database Question
Posted: Sun Apr 18, 2010 5:23 pm
by ZexisStryfe
Re: Database Question
Posted: Sun Apr 18, 2010 5:25 pm
by abndrew82
Thank you very much
That was exactly what I needed, I tested the command so I understand that now, and that spreadsheet will be a great help.
Drew
Re: Database Question
Posted: Sun Apr 18, 2010 7:53 pm
by ZexisStryfe
I aim to please
