View Single Post
  #4  
Old 02-17-2008, 07:07 AM
AndMetal
Developer
 
Join Date: Mar 2007
Location: Ohio
Posts: 648
Default

I have a little more time than I originally thought, so I had a chance to look a little more.

There's quite a few recipes that use the container (76 according to the tradeskill_recipe_entries table):

SELECT DISTINCT(tradeskill_recipe_entries.recipe_id), tradeskill_recipe.name FROM tradeskill_recipe_entries LEFT JOIN tradeskill_recipe ON tradeskill_recipe_entries.recipe_id = tradeskill_recipe.id WHERE item_id = '17124' ORDER BY recipe_id ASC
Code:
recipe_id	name 
8389		ashen bone mail bracer 
8390		ashen bone mail coif 
8391		ashen bone mail leggings 
8392		ashen bone mail sleeves 
8393		ashen bone mail gloves 
8394		ashen bone mail tunic 
8564		moss toe boots 
8565		moss toe bracer 
8566		moss toe cap 
8567		moss toe gloves 
8568		moss toe leggings 
8569		moss toe sleeves 
8570		moss toe tunic 
8621		armguards of the pestilence priest 
8622		boots of the pestilence priest 
8623		bracer of the pestilence priest 
8624		gauntlets of the pestilence priest 
8625		greaves of the pestilence priest 
8626		helm of the pestilence priest 
8627		pestilence priest breastplate 
8923		Sylvan Initiate Boots 
8925		Sylvan Initiate Bracer 
8927		Sylvan Initiate Breastplate 
8929		Sylvan Initiate Gauntlets 
8931		Sylvan Initiate Greaves 
8933		Sylvan Initiate Helm 
8935		Sylvan Initiate Vambraces 
9145		Orc Slayer Boots 
9146		Orc Slayer Bracer 
9147		Orc Slayer Breastplate 
9148		Orc Slayer Gauntlets 
9149		Orc Slayer Greaves 
9150		Orc Slayer Vambraces 
9151		Orc Slayer Helm 
9265		Emerald Novice Helm 
9267		Emerald Novice Boots 
9268		Emerald Novice Bracers 
9269		Emerald Novice Breastplate 
9270		Emerald Novice Gauntlets 
9271		Emerald Novice Greaves 
9272		Emerald Novice Vambraces 
9535		Thorn Mail Cap 
9536		Thorn Mail Bracer 
9537		Thorn Mail Gloves 
9538		Thorn Mail Boots 
9539		Thorn Mail Sleeves 
9540		Thorn Mail Leggings 
9541		Thorn Mail Tunic 
9715		Templar of Fright Boots 
9716		Templar of Fright Bracer 
9717		Templar of Fright Breastplate 
9718		Templar of Fright Gauntlets 
9719		Templar of Fright Greaves 
9720		Templar of Fright Helm 
9722		Templar of Fright Armguards 
9725		Felwithe Defenders Gauntlets 
9726		Felwithe Defenders Boots 
9727		Felwithe Defenders Bracer 
9728		Felwithe Defenders Helm 
9729		Felwithe Defenders Greaves 
9730		Felwithe Defenders Armguards 
9731		Felwithe Defenders Breastplate 
9734		Plague Knight Boots 
9735		Plague Knight Bracer 
9736		Plague Knight Breastplate 
9737		Plague Knight Gauntlets 
9738		Plague Knight Greaves 
9739		Plague Knight Helm 
9740		Plague Knight Vambraces 
9749		Bone Mail Boots 
9750		Bone Mail Bracer 
9751		Bone Mail Helm 
9752		Bone Mail Gauntlets 
9753		Bone Mail Greaves 
9754		Bone Mail Vambraces 
9755		Bone Mail Breastplate
So, it looks like recipe IDs 9145 through 9151 are the orc slayers. So I guess that answers my original question, and the combines look to be in the DB.

Looking at the Orc Slayer Greaves recipe (recipe ID 9149), it looks like the pattern is "Tattered Pant Pattern", which is item # 19560 in the PEQ DB:
Code:
id	recipe_id	item_id	successcount	failcount	componentcount	 iscontainer

114129	9149	17124	0	0	0	1 
114130	9149	16486	0	0	3	0 
114131	9149	16176	0	0	1	0 
114132	9149	16186	0	0	2	0 
114133	9149	16191	0	0	1	0 
114134	9149	19560	0	0	1	0 
114135	9149	19590	1	0	0	0
__________________
GM-Impossible of 'A work in progress'
A non-legit PEQ DB server
How to create your own non-legit server

My Contributions to the Wiki
Reply With Quote