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
Database Question
Moderator: Team Members
Forum rules
READ THE FORUM STICKY THREADS BEFORE ASKING FOR HELP!
Most information can be found there, and if not, the posts will help you determine the information required to get assistance from the development team.
Incomplete Help Requests will be locked or deleted.
READ THE FORUM STICKY THREADS BEFORE ASKING FOR HELP!
Most information can be found there, and if not, the posts will help you determine the information required to get assistance from the development team.
Incomplete Help Requests will be locked or deleted.
- Scatman
- Retired
- Posts: 1688
- Joined: Wed Apr 16, 2008 5:44 am
- EQ2Emu Server: Scatman's Word
- Characters: Scatman
- Location: New Jersey
Re: Database Question
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.
-
abndrew82
- Posts: 31
- Joined: Tue Apr 13, 2010 3:37 pm
Re: Database Question
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
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
- Zcoretri
- Team Member
- Posts: 1642
- Joined: Fri Jul 27, 2007 12:55 pm
- Location: SoCal
Re: Database Question
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.
So for the example you gave, you will find that creatures/monsters/vox has an appearance_id = 203.
- ZexisStryfe
- Posts: 1026
- Joined: Thu Jul 26, 2007 6:39 am
- EQ2Emu Server: Sytherian Legends
- Location: Connecticut
- Contact:
-
abndrew82
- Posts: 31
- Joined: Tue Apr 13, 2010 3:37 pm
Re: Database Question
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
That was exactly what I needed, I tested the command so I understand that now, and that spreadsheet will be a great help.
Drew
- ZexisStryfe
- Posts: 1026
- Joined: Thu Jul 26, 2007 6:39 am
- EQ2Emu Server: Sytherian Legends
- Location: Connecticut
- Contact:
Re: Database Question
I aim to please 
Who is online
Users browsing this forum: No registered users and 0 guests


