i was looking for spawn_objest and here is what i found, I was expecting objects that are spawn around zone 11808 entries of which 7 are actual useful data

i believe there is room for improvement here, by only adding entries to this table if there is a device ID assigned

now to find the spawn objects i was looking for

A random crate in the zone and a forge are both considered objects. Well at least that is how live sends them. Device id is for the tradeskill tables and is only used on the server side.

I too have always wondered what the table is used for, meaning a more detailed explanation. So if there is a spawn and it does have a location but also has an entry in the object table, what does the entry actually do for the spawn?

this one identifies which crafting table type it is( if the object is a crafitng table)

IMHO it should only be adding to that table if the deviceid is 1-7 otherwise dont use it and defualt to 0

In the world we can only spawn a widget, sign, object, ground, or entity(npc,player,bots,pet). Packets vary based on the type of spawn we are spawning. There is no "Spawn" type, that is just a base class with info that all the others share.

Object is the closest to the base class as you can get so spawns in the world that pretty much don't do anything will be an object, lot of crates, barrels, tables and other decoration type stuff. The device_id came much later for tradeskills. All this really does is assign the spawn to the type if the spawn doesn't have a type it can not be spawned into the world.