View Single Post
  #11  
Old 01-16-2007, 05:36 AM
Kayot
Discordant
 
Join Date: Sep 2006
Location: Subsection 185.D354 C.12
Posts: 346
Default

This is the SQL for tradeskills:

Code:
DROP TABLE IF EXISTS `peq`.`tradeskill_recipe`;
CREATE TABLE  `peq`.`tradeskill_recipe` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(64) NOT NULL default '',
  `tradeskill` smallint(6) NOT NULL default '0',
  `skillneeded` smallint(6) NOT NULL default '0',
  `trivial` smallint(6) NOT NULL default '0',
  `nofail` tinyint(1) NOT NULL default '0',
  `replace_container` tinyint(1) NOT NULL default '0',
  `notes` tinytext,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8852 DEFAULT CHARSET=utf8;
All I had to do to change is so toolbox combines could be done was modify tradeskill to the number of the tradeskill for the Tackle Box. The recipes in tradeskill_recipe_entries still had the container set to toolbox/deluxe tool box/ collapsible tool box. But I was making mana batteries and cloaking devices in my tackle box and my fishing skill was going up. So I'm not sure just how required the extra entries are.

P.S. I haven't removed the lines, I just never changed them. Let sleeping dragons lie?

Last edited by Kayot; 01-16-2007 at 01:38 PM..