Quote:
|
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.
Code:
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 ;