Go Back   EQEmulator Home > EQEmulator Forums > Quests > Quests::Completed

Quests::Completed This is where Completed quests are.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 04:45 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3