now this is a total waste of space LOL (maybe)

Development forum for the EQ2Emulator Database project.

Moderator: Team Members

Post Reply
User avatar
Ememjr
Team Member
Posts: 975
Joined: Wed Mar 15, 2017 9:41 am
EQ2Emu Server: Perseverance

now this is a total waste of space LOL (maybe)

Post by Ememjr » Mon Mar 18, 2019 3:20 pm

i was looking for spawn_objest and here is what i found, I was expecting objects that are spawn around zone
spawn_objects.JPG
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
You do not have the required permissions to view the files attached to this post.

Jabantiz
Lead Developer
Posts: 2912
Joined: Wed Jul 25, 2007 2:52 pm
Location: California

Re: now this is a total waste of space LOL (maybe)

Post by Jabantiz » Mon Mar 18, 2019 4:43 pm

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.

User avatar
Gangrenous
Posts: 812
Joined: Sun Apr 24, 2016 6:54 am
Characters: Dinsmoor

Re: now this is a total waste of space LOL (maybe)

Post by Gangrenous » Wed Mar 20, 2019 5:41 am

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?
Resident Dirty Hippy

User avatar
Ememjr
Team Member
Posts: 975
Joined: Wed Mar 15, 2017 9:41 am
EQ2Emu Server: Perseverance

Re: now this is a total waste of space LOL (maybe)

Post by Ememjr » Wed Mar 20, 2019 7:22 am

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

Jabantiz
Lead Developer
Posts: 2912
Joined: Wed Jul 25, 2007 2:52 pm
Location: California

Re: now this is a total waste of space LOL (maybe)

Post by Jabantiz » Wed Mar 20, 2019 4:36 pm

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.

Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests