Dark Elf Cleric Newbie Armor Quests

gatorman · #2 02-02-2008, 07:16 AM

Now for the SQL tradeskill_recipe inserts:

Code:

INSERT INTO `tradeskill_recipe` (VALUES 9751,"Holy Metal Bracer Material",63,0,0,1,0,"Blaz");
INSERT INTO `tradeskill_recipe` (VALUES 9752,"Initiate Darkpriest Bracer",63,0,0,1,0,"Blaz");
INSERT INTO `tradeskill_recipe` (VALUES 9753,"Holy Metal Breastplate Material",63,0,0,1,0,"Blaz");
INSERT INTO `tradeskill_recipe` (VALUES 9754,"Initiate Darkpriest Breastplate",63,0,0,1,0,"Blaz");
INSERT INTO `tradeskill_recipe` (VALUES 9755,"Holy Metal Armguard Material",63,0,0,1,0,"Blaz");
INSERT INTO `tradeskill_recipe` (VALUES 9756,"Initiate Darkpriest Armguards",63,0,0,1,0,"Blaz");
INSERT INTO `tradeskill_recipe` (VALUES 9757,"Holy Metal Boot Material",63,0,0,1,0,"Blaz");
INSERT INTO `tradeskill_recipe` (VALUES 9758,"Initiate Darkpriest Boots",63,0,0,1,0,"Blaz");
INSERT INTO `tradeskill_recipe` (VALUES 9759,"Holy Metal Gauntlet Material",63,0,0,1,0,"Blaz");
INSERT INTO `tradeskill_recipe` (VALUES 9760,"Initiate Darkpriest Gauntlets",63,0,0,1,0,"Blaz");
INSERT INTO `tradeskill_recipe` (VALUES 9761,"Holy Metal Helm Material",63,0,0,1,0,"Blaz");
INSERT INTO `tradeskill_recipe` (VALUES 9762,"Initiate Darkpriest Helm",63,0,0,1,0,"Blaz");
INSERT INTO `tradeskill_recipe` (VALUES 9763,"Holy Metal Greaves Material",63,0,0,1,0,"Blaz");
INSERT INTO `tradeskill_recipe` (VALUES (9764,"Initiate Darkpriest Greaves",63,0,0,1,0,"Blaz");

And the tradeskill_recipe_entries inserts:

Code:

INSERT INTO `tradeskill_recipe_entries` VALUES (124314,9752,22648,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124315,9752,22604,1,0,0,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124316,9752,22611,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124317,9752,17,0,0,0,1);
INSERT INTO `tradeskill_recipe_entries` VALUES (124322,9751,13030,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124323,9751,13088,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124324,9751,13791,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124325,9751,22601,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124326,9751,22648,1,0,0,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124327,9751,17245,0,0,0,1);
INSERT INTO `tradeskill_recipe_entries` VALUES (124328,9753,22601,0,0,5,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124329,9753,16173,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124330,9753,16990,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124331,9753,22572,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124332,9753,14550,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124333,9753,22653,1,0,0,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124334,9753,17245,0,0,0,1);
INSERT INTO `tradeskill_recipe_entries` VALUES (124351,9754,22616,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124352,9754,22653,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124353,9754,22609,1,0,0,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124354,9754,17,0,0,0,1);
INSERT INTO `tradeskill_recipe_entries` VALUES (124355,9755,22601,0,0,3,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124356,9755,16168,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124357,9755,19575,0,0,2,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124358,9755,16592,0,0,2,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124359,9755,22650,1,0,0,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124360,9755,17245,0,0,0,1);
INSERT INTO `tradeskill_recipe_entries` VALUES (124361,9756,22613,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124362,9756,22650,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124363,9756,22606,1,0,0,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124364,9756,17,0,0,0,1);
INSERT INTO `tradeskill_recipe_entries` VALUES (124367,9757,22601,0,0,2,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124368,9757,13250,0,0,2,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124369,9757,13006,0,0,2,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124370,9757,22649,1,0,0,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124371,9757,17245,0,0,0,1);
INSERT INTO `tradeskill_recipe_entries` VALUES (124380,9759,22601,0,0,3,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124381,9759,22645,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124382,9759,22652,1,0,0,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124383,9759,13113,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124384,9759,16903,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124385,9759,13070,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124386,9759,17245,0,0,0,1);
INSERT INTO `tradeskill_recipe_entries` VALUES (124389,9760,22608,1,0,0,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124390,9760,22615,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124391,9760,22652,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124392,9760,17,0,0,0,1);
INSERT INTO `tradeskill_recipe_entries` VALUES (124395,9761,22602,1,0,0,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124396,9761,22601,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124397,9761,13753,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124398,9761,16166,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124399,9761,13018,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124400,9761,17245,0,0,0,1);
INSERT INTO `tradeskill_recipe_entries` VALUES (124403,9762,22602,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124404,9762,22610,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124405,9762,22603,1,0,0,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124406,9762,17,0,0,0,1);
INSERT INTO `tradeskill_recipe_entries` VALUES (124409,9763,22601,0,0,4,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124410,9763,13253,0,0,2,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124411,9763,16172,0,0,2,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124412,9763,13016,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124413,9763,22651,1,0,0,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124414,9763,17245,0,0,0,1);
INSERT INTO `tradeskill_recipe_entries` VALUES (124417,9764,22651,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124418,9764,22607,1,0,0,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124419,9764,22614,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124420,9764,17,0,0,0,1);
INSERT INTO `tradeskill_recipe_entries` VALUES (124421,9758,22649,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124422,9758,22612,0,0,1,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124423,9758,22605,1,0,0,0);
INSERT INTO `tradeskill_recipe_entries` VALUES (124424,9758,17,0,0,0,1);

Hopefully that is all that is needed!

-Blaz