Thread: Ebon Strongbear
View Single Post
  #5  
Old 07-02-2007, 02:43 PM
CrabClaw's Avatar
CrabClaw
Hill Giant
 
Join Date: Jun 2006
Location: Plane of Knowledge
Posts: 191
Default

Patience Perseveres!

Here is the 100% game tested SQL for the recipe data for the quest armor combines. Just source this as a SQL file into your database and you're done.

Remember to always back your work/tables up before proceeding! Use the admin tool to make a 'tradeskill_recipe_entries' and 'tradeskill_recipe' backup.

(Note, for my purposes am using UID: 120000 thru 129999 as my personal 'tradeskill_recipe_entries' range for my future work and UID: 9000 thru 9999 as my 'tradeskill_recipe' range. If it conflicts with anything you have feel free to shift the ID's to fit your project. It does work with the two current biggies 'ax_classic' and 'PEQ_Luclin' though.)

(Now my friend is bugging me to do the Ranger armors quest next....blarg! No prob though. )

Code:
INSERT INTO tradeskill_recipe_entries VALUES (120000, 9000, 17268, 0, 0, 0, 1);
INSERT INTO tradeskill_recipe_entries VALUES (120001, 9000, 19630, 0, 0, 2, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120002, 9000, 27396, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120003, 9000, 13070, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120004, 9000, 13034, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120005, 9000, 27460, 1, 0, 0, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120006, 9001, 17, 0, 0, 0, 1);
INSERT INTO tradeskill_recipe_entries VALUES (120007, 9001, 38834, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120008, 9001, 27460, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120009, 9001, 27358, 1, 0, 0, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120010, 9002, 17268, 0, 0, 0, 1);
INSERT INTO tradeskill_recipe_entries VALUES (120011, 9002, 19630, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120012, 9002, 27397, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120013, 9002, 27400, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120014, 9002, 27408, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120015, 9002, 27461, 1, 0, 0, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120016, 9003, 17, 0, 0, 0, 1);
INSERT INTO tradeskill_recipe_entries VALUES (120017, 9003, 38830, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120018, 9003, 27461, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120019, 9003, 27359, 1, 0, 0, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120020, 9004, 17268, 0, 0, 0, 1);
INSERT INTO tradeskill_recipe_entries VALUES (120021, 9004, 19630, 0, 0, 2, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120022, 9004, 27404, 0, 0, 2, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120023, 9004, 13062, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120024, 9004, 13082, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120025, 9004, 27462, 1, 0, 0, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120026, 9005, 17, 0, 0, 0, 1);
INSERT INTO tradeskill_recipe_entries VALUES (120027, 9005, 38831, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120028, 9005, 27462, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120029, 9005, 27360, 1, 0, 0, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120030, 9006, 17268, 0, 0, 0, 1);
INSERT INTO tradeskill_recipe_entries VALUES (120031, 9006, 19630, 0, 0, 3, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120032, 9006, 27405, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120033, 9006, 13026, 0, 0, 2, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120034, 9006, 27463, 1, 0, 0, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120035, 9007, 17, 0, 0, 0, 1);
INSERT INTO tradeskill_recipe_entries VALUES (120036, 9007, 38833, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120037, 9007, 27463, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120038, 9007, 27361, 1, 0, 0, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120039, 9008, 17268, 0, 0, 0, 1);
INSERT INTO tradeskill_recipe_entries VALUES (120040, 9008, 19630, 0, 0, 4, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120041, 9008, 9910, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120042, 9008, 9895, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120043, 9008, 16598, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120044, 9008, 9905, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120045, 9008, 27464, 1, 0, 0, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120046, 9009, 17, 0, 0, 0, 1);
INSERT INTO tradeskill_recipe_entries VALUES (120047, 9009, 38836, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120048, 9009, 27464, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120049, 9009, 27362, 1, 0, 0, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120050, 9010, 17268, 0, 0, 0, 1);
INSERT INTO tradeskill_recipe_entries VALUES (120051, 9010, 19630, 0, 0, 3, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120052, 9010, 13417, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120053, 9010, 27497, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120054, 9010, 13780, 0, 0, 2, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120055, 9010, 27465, 1, 0, 0, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120056, 9011, 17, 0, 0, 0, 1);
INSERT INTO tradeskill_recipe_entries VALUES (120057, 9011, 38832, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120058, 9011, 27465, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120059, 9011, 27363, 1, 0, 0, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120060, 9012, 17268, 0, 0, 0, 1);
INSERT INTO tradeskill_recipe_entries VALUES (120061, 9012, 19630, 0, 0, 5, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120062, 9012, 13756, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120063, 9012, 9914, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120064, 9012, 10299, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120065, 9012, 9913, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120066, 9012, 27410, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120067, 9012, 27466, 1, 0, 0, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120068, 9013, 17, 0, 0, 0, 1);
INSERT INTO tradeskill_recipe_entries VALUES (120069, 9013, 38835, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120070, 9013, 27466, 0, 0, 1, 0);
INSERT INTO tradeskill_recipe_entries VALUES (120071, 9013, 27364, 1, 0, 0, 0);
INSERT INTO tradeskill_recipe VALUES (9000, 'battlemasters helm material', 63, 0, 0, 1, 0, 'Created by CrabClaw');
INSERT INTO tradeskill_recipe VALUES (9001, 'helm of the battlemaster', 63, 0, 0, 1, 0, 'Created by CrabClaw');
INSERT INTO tradeskill_recipe VALUES (9002, 'battlemasters bracer material', 63, 0, 0, 1, 0, 'Created by CrabClaw');
INSERT INTO tradeskill_recipe VALUES (9003, 'bracer of the battlemaster', 63, 0, 0, 1, 0, 'Created by CrabClaw');
INSERT INTO tradeskill_recipe VALUES (9004, 'battlemasters armguards material', 63, 0, 0, 1, 0, 'Created by CrabClaw');
INSERT INTO tradeskill_recipe VALUES (9005, 'armguards of the battlemaster', 63, 0, 0, 1, 0, 'Created by CrabClaw');
INSERT INTO tradeskill_recipe VALUES (9006, 'battlemasters boot material', 63, 0, 0, 1, 0, 'Created by CrabClaw');
INSERT INTO tradeskill_recipe VALUES (9007, 'boots of the battlemaster', 63, 0, 0, 1, 0, 'Created by CrabClaw');
INSERT INTO tradeskill_recipe VALUES (9008, 'battlemasters greaves material', 63, 0, 0, 1, 0, 'Created by CrabClaw');
INSERT INTO tradeskill_recipe VALUES (9009, 'greaves of the battlemaster', 63, 0, 0, 1, 0, 'Created by CrabClaw');
INSERT INTO tradeskill_recipe VALUES (9010, 'battlemasters gauntlets material', 63, 0, 0, 1, 0, 'Created by CrabClaw');
INSERT INTO tradeskill_recipe VALUES (9011, 'gauntlets of the battlemaster', 63, 0, 0, 1, 0, 'Created by CrabClaw');
INSERT INTO tradeskill_recipe VALUES (9012, 'battlemasters breastplate material', 63, 0, 0, 1, 0, 'Created by CrabClaw');
INSERT INTO tradeskill_recipe VALUES (9013, 'breastplate of the battlemaster', 63, 0, 0, 1, 0, 'Created by CrabClaw');
Reply With Quote