Spawning a Forge

[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?

Originally Posted by Kayot

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

You can add it, anyone can add it.

[sdabbs65]

Originally Posted by mattmeck

You can add it, anyone can add it.

Need a dummies guide on how to add to the wiki.
I looked/searched and I can't find it either.. LOL.
so far I figgured out how to register on the wiki.
but after that who knows as far as createing new pages.
editing existing pages is fairly simple tho.




P.S Mondays are stupid.

[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?

you have 26 colums check your database mine expet's to see 11 colums.
these are the discriptions it expects if you have more you need more 0's.
if not.. then why add 0's as it will give you errors.
id, zoneid, xpos, ypos, zpos, heading, itemid, charges, objectname, type, icon

[Angelox]

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?

If you do a #goto to the x,y,z coords mentioned above, it puts you in a wall in Nexus (at least with me it does).
Take a new #loc of where you want it, or use these coords -27.9 -32.8 -30.9 and replace (puts it close to the center).
Works pretty good, just need to find the proper "forge" graphic for Augs.

[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?