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 8)