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 ;