john,

How do i add spawns to my db, tried the commands but nothing happened but it did add it to the db under spawns

Doc

Sorry for the delay, been extremely busy. The EQ2Emu team does not have time to teach everyone how to do everything with the emulator. The code is there, and examples are in the client such as /spawn create. Unfortunately, you'll have to figure out most things on your own for now.

Until this community bands together and helps us fill the Wiki with more documentation, this is how it is, sorry to say.

I've started a Server Admin FAQ in the Wiki. Hopefully more will see fit to add to it in the months to come.

John,
Thanks for the wiki link, helped alot. But im still not sure how to differ from NPC's to Merchants. I understand the spawning process but if I want to add merchants to the DB is it still considered an NPC or not?

Dr.Z

I have also signed up on the Wiki and plan to help you as much as possible, I use to play eq2 all the time till i got tired of paying for it, then i went to WoW private servers and learned programming and their db stuff, very good at their coding and this seems not to far off from what they are using as far as the db is concerned.

Merchants are normal NPCs like everyone else (a spawn). Spawn them how you would an NPC. Then, you have to look inside the `entity_commands` table for the command_list_id for the entry `buy from merchant`. That is the spawn's command_primary value to make the right-click/default-click engage the Merchant dialog.

To get the merchant dialog to appear, you have to build a merchant list. To do this, insert a record into merchants. Take the merchant_id you got there and place it in the spawn.merchant_id field. Now, your merchant NPC opens a window.

Fill the merchant_inventory table for merchant_id 'x' with item_id's from your items table (which you probably don't have, just insert something from our examples on the forum til we release Items).


Btw, literally everything for manually building a DB is very intensive, and can be very complex. This is why our Content Team does NOT build the DB manually, but uses collected data from the SOE Live servers, parsed and inserted into our DB. Doing this manually though should show you just how configurable and robust our Emulator is.