Spawning a Forge

[sdabbs65]

Originally Posted by Kayot

Thank you for the list ^-^ it really should be in the wiki.

-----------

I tryed adding a forge but I think my santax is messed up. It wont show up.

INSERT INTO object (id, zoneid, xpos, ypos, zpos, heading, itemid, charges, objectname, type, icon) VALUES (100000, 183, 96, 150, 4.75, 140, 17909, 0, 'IT17_ACTORDEF', 53, 1115, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

any ideas?

Looks like the new table requires 24 inserts.

CREATE TABLE `object` (
`id` int(11) NOT NULL auto_increment,
`zoneid` int(11) unsigned NOT NULL default '0',
`xpos` float NOT NULL default '0',
`ypos` float NOT NULL default '0',
`zpos` float NOT NULL default '0',
`heading` float NOT NULL default '0',
`itemid` int(11) NOT NULL default '0',
`charges` tinyint(3) unsigned NOT NULL default '0',
`objectname` varchar(16) NOT NULL default '',
`type` int(11) NOT NULL default '0',
`icon` int(11) NOT NULL default '0',
`linked_list_addr_01` int(11) NOT NULL default '0',
`linked_list_addr_02` int(11) NOT NULL default '0',
`unknown08` mediumint(5) NOT NULL default '0',
`unknown10` mediumint(5) NOT NULL default '0',
`unknown20` int(11) NOT NULL default '0',
`unknown24` int(11) NOT NULL default '0',
`unknown60` int(11) NOT NULL default '0',
`unknown64` int(11) NOT NULL default '0',
`unknown68` int(11) NOT NULL default '0',
`unknown72` int(11) NOT NULL default '0',
`unknown76` int(11) NOT NULL default '0',
`unknown84` int(11) NOT NULL default '0',
`unknown88` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=52842 ;

[Kayot]

I'm not putting it into Nexus. I'm putting it into tutorial ^-^.

[Angelox]

Originally Posted by Kayot

I'm not putting it into Nexus. I'm putting it into tutorial ^-^.

Did you set up you're own coords for it? also do you remember if there was a forge in tutorial?