OK Krathis I'm starting to feel bad for you so I'll explain how it goes. Sorry for the delay, I read this post before but was inclined to giving out information when I, myself got shit on by so many others when asking for a piece of information even by an "Op" of this whole project who will remain nameless.
One more piece of information. You are correct the table in the database is only 10 characters long for the name of the door, however in code it is expanded up to 16 characters.
i.e.:
************************************************** **
[ In File eq_packet_structs.h ]
struct Door_Struct
{
/*0000*/ char name[16]; // Filename of Door // Was 10char long before... added the 6 in the next unknown to it: Daeken M. BlackBlade
// uint8 unknown0008[6]; // This is "supposed" to be with name hehe
************************************************** **
To fix this problem you can either
A) Source out the door table, then drop the doors table and paste the following into a txt file and then source it back into the database
************************************************** ***
CREATE TABLE `doors` (
`id` int(11) NOT NULL auto_increment,
`doorid` smallint(4) NOT NULL default '0',
`zone` varchar(16) NOT NULL default '',
`name` varchar(16) NOT NULL default '',
`pos_y` float NOT NULL default '0',
`pos_x` float NOT NULL default '0',
`pos_z` float NOT NULL default '0',
`heading` int(11) NOT NULL default '0',
`opentype` smallint(4) NOT NULL default '0',
`guild` smallint(4) NOT NULL default '0',
`lockpick` smallint(4) NOT NULL default '0',
`keyitem` int(11) NOT NULL default '0',
`triggerdoor` smallint(4) NOT NULL default '0',
`triggertype` smallint(4) NOT NULL default '0',
`doorisopen` smallint(4) NOT NULL default '0',
`liftheight` int(4) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM
************************************************** **
and then source back in your door data that you sourced out.
Be sure to open the sourced out door data and remove the CREATE table at the top so it doesn't interfer with the new table you just sourced in.
or
B) Update the table directly which I think is possible but I don't have the command near me so don't quote me on this one.
------------------------------------------------------------------------------------
Now onto your main problem ...
(Will explain the minor details in case others read this)
First as you are doing, use the EQModel viewer and load up the zone you wish to peek into for the objects/doors you wish to spawn.
[Load up the Zone_Name.obj file]
Now look for the object you want.
For example say you want FSMFORGE301_DMSPRITEDEF
What you would put for the name value in the doors table in the database is "FSMFORGE301" Put everything up until the first underscore.
Then do what you just explained, get the coords, etc insert values for the other data values in the table and then reload your world.exe and your new object should show.
Any questions feel free to pop on the server [LEGIT]Memories of Vex.
-David
ServerOp of Memories of Vex