Database Question

General support forum. If you require assistance and your problem doesnt fall in any of the other categories, this is the forum for you!

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.
Post Reply
abndrew82
Posts: 31
Joined: Tue Apr 13, 2010 3:37 pm

Database Question

Post by abndrew82 » Sun Apr 18, 2010 4:08 pm

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

User avatar
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

Post by Scatman » Sun Apr 18, 2010 4:15 pm

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

Post by abndrew82 » Sun Apr 18, 2010 4:22 pm

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

User avatar
Zcoretri
Team Member
Posts: 1642
Joined: Fri Jul 27, 2007 12:55 pm
Location: SoCal

Re: Database Question

Post by Zcoretri » Sun Apr 18, 2010 5:11 pm

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.

User avatar
ZexisStryfe
Posts: 1026
Joined: Thu Jul 26, 2007 6:39 am
EQ2Emu Server: Sytherian Legends
Location: Connecticut
Contact:

Re: Database Question

Post by ZexisStryfe » Sun Apr 18, 2010 5:23 pm

~ EQ2 Emulator Project Manager

Image
Image
Image
"Zexis, from this day forth, you shall be known as... '3 of 6'" - John Adams

abndrew82
Posts: 31
Joined: Tue Apr 13, 2010 3:37 pm

Re: Database Question

Post by abndrew82 » Sun Apr 18, 2010 5:25 pm

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

User avatar
ZexisStryfe
Posts: 1026
Joined: Thu Jul 26, 2007 6:39 am
EQ2Emu Server: Sytherian Legends
Location: Connecticut
Contact:

Re: Database Question

Post by ZexisStryfe » Sun Apr 18, 2010 7:53 pm

I aim to please 8)
~ EQ2 Emulator Project Manager

Image
Image
Image
"Zexis, from this day forth, you shall be known as... '3 of 6'" - John Adams

Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests