Go Back   EQEmulator Home > EQEmulator Forums > Quests > Quests::need work
Reload this Page Usable Crescent Reach Freebie Tradeskills

Quests::need work This is where quests that are outdated or still need work

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-03-2018, 04:21 AM
Tegila
Hill Giant
  
Join Date: Mar 2018
Location: NY
Posts: 125
Default Usable Crescent Reach Freebie Tradeskills
These are usable as is except for alchemy and research, but they do still need to be made into the quests they should be. Right now you can hail and get the ingredients to skill up to 54 in everything except those 2 that come from the same questgiver, researcher akila. I haven't gotten to writing their's yet because it requires to skip alchemy unless a shaman, and make shaman do alchemy before research in order to make usable without creating the full quests.

The dialog from the NPCs is not the official dialog, it's just there to say hey it's working along with the supplies appearing on cursor.

In order to make these work of course, all the recipes also had to be created. The only recipes in default db do not give supplies and are from different zones. Some of these recipes are alternatives to Abysmal Sea/Wayfarer's recipes of the same names.

WARNING: These will only work if you have nothing in the recipeid's from 25500 and up, or the recipe_entry id's from 252538 and up.

Code:
Brewing Recipes:

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25500, 'Spicy Sunrise', 65, 0, 31, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252538, 25500, 58144, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252539, 25500, 98259, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252540, 25500, 98289, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252541, 25500, 19, 0, 0, 0, 0, 1);


INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25501, 'Vanilla Coffee', 65, 0, 38, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252551, 25501, 58165, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252552, 25501, 58164, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252553, 25501, 58033, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252554, 25501, 98256, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252556, 25501, 19, 0, 0, 0, 0, 1);

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25502, 'Peppy Juice', 65, 0, 46, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252557, 25502, 98257, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252558, 25502, 98259, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252559, 25502, 58033, 1, 1, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252560, 25502, 58070, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252561, 25502, 19, 0, 0, 0, 0, 1);

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25509, 'Simple Spiced Win', 65, 0, 54, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252562, 25503, 98290, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252563, 25503, 58133, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252564, 25503, 98289, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252565, 25503, 19, 0, 0, 0, 0, 1);




Brewer_Mesi.pl


sub EVENT_SAY
{
	if($text=~/hail/i)
	{
		if($client->GetSkill(65) < 31)
		{
			quest::say("A fledgling brewer!  I've got a recipe for you to start out with.  Take these ingredients and make yourself some Spicy Sunrise."); 
			quest::summonitem(98259,20);
			quest::summonitem(98289,20);
		}
		elsif($client->GetSkill(65) < 38)
		{
			quest::say("Wonderful!  Now, to further that skill, you should try your hand at some Vanilla Coffee.  It's the perfect weather, don't you think?");
			quest::summonitem(58164,20);
			quest::summonitem(58033,20);
			quest::summonitem(98256,20);
		}
		elsif($client->GetSkill(65) < 46)
		{
			quest::say("If you'd like a little more spring in your step, my secret recipe Peppy Juice is just the thing.  I'll share the secret with you though, because you've been such a great student.");
			quest::summonitem(98259,20);
			quest::summonitem(58033,20);
			quest::summonitem(58070,20);
		}
		elsif($client->GetSkill(65) < 54)
		{
			quest::say("Ahh, that hits the spot.  Now, it's getting a little late in the day for me.  I've got a tasty evening drink recipe, if you'd like to try your hand at it.  This Simple Spiced Wine is perfect after a long day, I'm sure you'll agree.");
			quest::summonitem(58133,20);
			quest::summonitem(98289,20);
		}
		if($client->GetSkill(65) >=54)
		{
			quest::say("I'm sorry, your skill is too great for my help now.  Perhaps it is time to learn another craft.")
		}
	}
}
Code:
Baking Recipes:

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25506, 'Simple Oatmeal', 60, 0, 31, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252566, 25506, 98260, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252567, 25506, 98258, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252568, 25506, 58045, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252569, 25506, 14, 0, 0, 0, 0, 1);


INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25507, 'Simple Muffins', 60, 0, 38, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252570, 25507, 98277, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252571, 25507, 58046, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252572, 25507, 98291, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252573, 25507, 15, 0, 0, 0, 0, 1);

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25508, 'Simple Pie', 60, 0, 46, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252574, 25508, 98281, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252575, 25508, 98291, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252576, 25508, 98282, 1, 1, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252577, 25508, 58046, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252578, 25508, 15, 0, 0, 0, 0, 1);

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25509, 'Simple Pastry', 60, 0, 54, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252579, 25509, 98280, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252580, 25509, 58046, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252581, 25509, 98254, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252582, 25509, 15, 0, 0, 0, 0, 1);


Baker_Sanura.pl

sub EVENT_SAY
{
	if($text=~/hail/i)
	{
		if($client->GetSkill(60) < 31)
		{
			quest::say("A fledgling baker!  I've got a recipe for you to start out with.  Take these ingredients and make yourself some Simple Oatmeal."); 
			quest::summonitem(98258,20);
			quest::summonitem(58045,20);
		}
		elsif($client->GetSkill(60) < 38)
		{
			quest::say("Wonderful!  Now, to further that skill, you should try your hand at some Simple Muffins.  It's the perfect weather, don't you think?");
			quest::summonitem(98291,20);
			quest::summonitem(58046,20);
		}
		elsif($client->GetSkill(60) < 46)
		{
			quest::say("If you'd like a little sweetness, my secret recipe Simple Pie is just the thing.  I'll share the secret with you though, because you've been such a great student.");
			quest::summonitem(98291,20);
			quest::summonitem(98282,20);
			quest::summonitem(58046,20);
		}
		elsif($client->GetSkill(60) < 54)
		{
			quest::say("Ahh, that hits the spot.  Now, it's getting a little late in the day for me.  I've got a tasty evening treat recipe, if you'd like to try your hand at it.  This Simple Pastry is perfect after a long day, I'm sure you'll agree.");
			quest::summonitem(58046,20);
			quest::summonitem(98254,20);
		}
		if($client->GetSkill(60) >=54)
		{
			quest::say("I'm sorry, your skill is too great for my help now.  Perhaps it is time to learn another craft.")
		}
	}
}
Code:
Fletching Recipes

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25510, 'Simple Arrow', 64, 0, 31, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252583, 25510, 98264, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252584, 25510, 98267, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252585, 25510, 98288, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252586, 25510, 98274, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252587, 25510, 18, 0, 0, 0, 0, 1);


INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25511, 'Simple Bow', 64, 0, 38, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252588, 25511, 98270, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252589, 25511, 98272, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252590, 25511, 98271, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252591, 25511, 18, 0, 0, 0, 0, 1);

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25512, 'Simple Bow Staff', 64, 0, 46, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252592, 25512, 98271, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252593, 25512, 58077, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252594, 25512, 98276, 1, 1, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252595, 25512, 18, 0, 0, 0, 0, 1);

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25513, 'Simple Arrowhead', 64, 0, 54, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252596, 25513, 98267, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252597, 25513, 58072, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252598, 25513, 98276, 1, 1, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252599, 25513, 18, 0, 0, 0, 0, 1);


Fletcher_Fenuku.pl

sub EVENT_SAY
{
	if($text=~/hail/i)
	{
		if($client->GetSkill(64) < 31)
		{
			quest::say("A fledgling fletcher!  I've got a little project for you to start out with.  Take these components and make yourself some Simple Arrows."); 
			quest::summonitem(98267,20);
			quest::summonitem(98274,20);
			quest::summonitem(98288,20);
		}
		elsif($client->GetSkill(64) < 38)
		{
			quest::say("Wonderful!  Now, to further that skill, you should try your hand at some Simple Bows.  It's the perfect season, don't you think?");
			quest::summonitem(98271,20);
			quest::summonitem(98272,20);
		}
		elsif($client->GetSkill(64) < 46)
		{
			quest::say("If you'd like a little difficulty, my secret method for Simple Bow Staffs will do the trick.  I'll share the secret with you though, because you've been such a great student.");
			quest::summonitem(98276,1);
			quest::summonitem(58077,20);
		}
		elsif($client->GetSkill(64) < 54)
		{
			quest::say("Ahh, that was a great job.  Now, it's getting a little late in the day for me.  I've got one last little project, if you'd like to try your hand at it.  These Simple Arrowheads bring us back to where we started but I'm going to show you how to make them using recycling. The woodelves would be pleased, I'm sure you'll agree.");
			quest::summonitem(58072,20);
			quest::summonitem(98276,1);
		}
		if($client->GetSkill(64) >=54)
		{
			quest::say("I'm sorry, your skill is too great for my help now.  Perhaps it is time to learn another craft.")
		}
	}
}
Code:
Alchemy Recipes Only:

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25514, 'Simple Black Dye', 59, 0, 31, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252600, 25514, 98268, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252601, 25514, 98287, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252602, 25514, 58145, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252603, 25514, 9, 0, 0, 0, 0, 1);


INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25515, 'Simple Green Dye', 59, 0, 38, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252604, 25515, 98275, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252605, 25515, 98287, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252606, 25515, 98271, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252607, 25515, 9, 0, 0, 0, 0, 1);

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25516, 'Simple Blue Dye', 59, 0, 46, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252608, 25516, 98269, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252609, 25516, 58088, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252610, 25516, 98287, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252611, 25516, 9, 0, 0, 0, 0, 1);

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25517, 'Simple Red Dye', 59, 0, 54, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252612, 25517, 98286, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252613, 25517, 58066, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252614, 25517, 98287, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252615, 25517, 9, 0, 0, 0, 0, 1);
Code:
Jewelcraft Recipes:

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25518, 'Simple Clasp', 68, 0, 31, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252616, 25518, 58092, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252617, 25518, 58158, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252618, 25518, 20, 0, 0, 0, 0, 1);


INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25519, 'Simple Copper Ring', 68, 0, 38, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252619, 25519, 58094, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252620, 25519, 58023, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252621, 25519, 58141, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252622, 25519, 20, 0, 0, 0, 0, 1);

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25520, 'Simple Brass Armband', 68, 0, 46, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252623, 25520, 98269, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252624, 25520, 58023, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252625, 25520, 58140, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252626, 25520, 20, 0, 0, 0, 0, 1);

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25521, 'Simple Silver Chain', 68, 0, 54, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252627, 25521, 98286, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252628, 25521, 58023, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252629, 25521, 58157, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252630, 25521, 20, 0, 0, 0, 0, 1);


Jeweler_Chuma.pl

sub EVENT_SAY
{
	if($text=~/hail/i)
	{
		if($client->GetSkill(68) < 31)
		{
			quest::say("A fledgling jewelcrafter!  I've got a little project for you to start out with.  Start out by making some Simple Clasps."); 
			quest::summonitem(58158,20);
		}
		elsif($client->GetSkill(68) < 38)
		{
			quest::say("Wonderful!  Now, to further that skill, you should try your hand at some Simple Rings.  Love is in the air, don't you think?");
			quest::summonitem(58023,20);
			quest::summonitem(58141,20);
		}
		elsif($client->GetSkill(68) < 46)
		{
			quest::say("If you'd like to try something a little larger, my secret method for Simple Brass Armbands will do the trick.  I'll share the secret with you though, because you've been such a great student.");
			quest::summonitem(58140,20);
			quest::summonitem(58023,20);
		}
		elsif($client->GetSkill(68) < 54)
		{
			quest::say("Ahh, that was a great job.  Now, it's getting a little late in the day for me.  I've got one last little project, if you'd like to try your hand at it.  These Simple Simple Silver Chains bring us back to where it started, but I'm going to show you a better way than our ancestors used. They would be pleased, I'm sure you'll agree.");
			quest::summonitem(58023,20);
			quest::summonitem(58157,20);
		}
		if($client->GetSkill(68) >=54)
		{
			quest::say("I'm sorry, your skill is too great for my help now.  Perhaps it is time to learn another craft.")
		}
	}
}
Code:
Poisonmaking Recipes:

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25522, 'Simple Universal Suspension', 56, 0, 31, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252631, 25522, 58130, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252632, 25522, 58128, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252633, 25522, 98265, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252634, 25522, 12, 0, 0, 0, 0, 1);


INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25523, 'Simple Solvent', 56, 0, 38, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252635, 25523, 58122, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252636, 25523, 58060, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252637, 25523, 98265, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252638, 25523, 12, 0, 0, 0, 0, 1);

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25524, 'Simple Contact Poison', 56, 0, 46, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252639, 25524, 58093, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252640, 25524, 58063, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252641, 25524, 58169, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252642, 25524, 12, 0, 0, 0, 0, 1);

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25525, 'Simple Injected Poison', 56, 0, 54, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252643, 25525, 58097, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252644, 25525, 58062, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252645, 25525, 58168, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252646, 25525, 12, 0, 0, 0, 0, 1);


Poisoner_Kamuzu.pl

sub EVENT_SAY
{
	if($text=~/hail/i)
	{
		if($client->GetSkill(56) < 31)
		{
			quest::say("A fledgling poisonmaker!  I've got a little recipe for you to start out with.  Start out by making some Simple Universal Suspension."); 
			quest::summonitem(98265,20);
			quest::summonitem(58128,20);
		}
		elsif($client->GetSkill(56) < 38)
		{
			quest::say("Wonderful!  Now, to further that skill, you should try your hand at some Simple Solvent.  It will come in quite handy, don't you think?");
			quest::summonitem(98265,20);
			quest::summonitem(58060,20);
		}
		elsif($client->GetSkill(56) < 46)
		{
			quest::say("If you'd like to try some real poisonmaking now, my secret method for Simple Contact Poison will do the trick.  I'll share the secret with you though, because you've been such a great student.");
			quest::summonitem(58169,20);
			quest::summonitem(58063,20);
		}
		elsif($client->GetSkill(56) < 54)
		{
			quest::say("Ahh, that was a great job.  Now, it's getting a little late in the day for me.  I've got one last little project, if you'd like to try your hand at it.  This Simple Injectable Poison brings us to why you're here to begin with, but I'm going to show you a better way than our ancestors used. They would be pleased, I'm sure you'll agree.");
			quest::summonitem(58062,20);
			quest::summonitem(58168,20);
		}
		if($client->GetSkill(56) >=54)
		{
			quest::say("I'm sorry, your skill is too great for my help now.  Perhaps it is time to learn another craft.")
		}
	}
}
Code:
Pottery Recipes:

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25526, 'Simple Repaired Plate', 69, 0, 31, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252647, 25526, 98283, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252648, 25526, 58024, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252649, 25526, 98253, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252650, 25526, 22, 0, 0, 0, 0, 1);

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25527, 'Simple Pot', 69, 0, 38, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252651, 25527, 98284, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252652, 25527, 58135, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252653, 25527, 98285, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252654, 25527, 22, 0, 0, 0, 0, 1);

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25528, 'Unfired Simple Mug', 69, 0, 46, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252655, 25528, 98262, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252656, 25528, 98265, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252657, 25528, 58135, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252658, 25528, 21, 0, 0, 0, 0, 1);

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25529, 'Unfired Simple Arrowshaft', 69, 0, 54, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252659, 25529, 98261, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252660, 25529, 58265, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252661, 25529, 58135, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252662, 25529, 98273, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252663, 25530, 21, 0, 0, 0, 0, 1);


Potter_Safiya.pl

sub EVENT_SAY
{
	if($text=~/hail/i)
	{
		if($client->GetSkill(69) < 31)
		{
			quest::say("A fledgling potter!  I've got a little project for you to start out with.  Start out by doing some Simple Repaired Plates."); 
			quest::summonitem(98253,20);
			quest::summonitem(58024,20);
		}
		elsif($client->GetSkill(69) < 38)
		{
			quest::say("Wonderful!  Now, to further that skill, you should try your hand at making some Simple Pots.  They will come in quite handy, don't you think?");
			quest::summonitem(98285,20);
			quest::summonitem(58135,20);
		}
		elsif($client->GetSkill(69) < 46)
		{
			quest::say("If you'd like to try some real pottery on the wheel now, my secret method for Unfired Simple Mugs will do the trick.  I'll share the secret with you though, because you've been such a great student.");
			quest::summonitem(98265,20);
			quest::summonitem(58135,20);
		}
		elsif($client->GetSkill(69) < 54)
		{
			quest::say("Ahh, that was a great job.  Now, it's getting a little late in the day for me.  I've got one last little project, if you'd like to try your hand at it.  These Unfired Simple Arrow Shafts are in big demand by the Rangers. They would be pleased, I'm sure you'll agree.");
			quest::summonitem(98265,20);
			quest::summonitem(58135,20);
			quest::summonitem(98273,20);
		}
		if($client->GetSkill(69) >=54)
		{
			quest::say("I'm sorry, your skill is too great for my help now.  Perhaps it is time to learn another craft.")
		}
	}
}
Code:
Blacksmithing Recipes:

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25531, 'Simple Stud', 63, 0, 31, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252664, 25531, 58124, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252665, 25531, 58055, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252666, 25531, 98265, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252667, 25531, 58103, 1, 1, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252668, 25531, 17, 0, 0, 0, 0, 1);

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25532, 'Simple Ring', 63, 0, 38, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252669, 25532, 58122, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252670, 25532, 58103, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252671, 25532, 58055, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252672, 25532, 58113, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252673, 25532, 17, 0, 0, 0, 0, 1);

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25533, 'Simple Chisel', 63, 0, 46, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252674, 25533, 58090, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252675, 25533, 58091, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252676, 25533, 58055, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252677, 25533, 17, 0, 0, 0, 0, 1);

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25534, 'Simple File', 63, 0, 54, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252678, 25534, 58095, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252679, 25534, 58265, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252680, 25534, 58055, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252681, 25534, 58096, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252682, 25534, 17, 0, 0, 0, 0, 1);


Smith_Wamukota.pl

sub EVENT_SAY
{
	if($text=~/hail/i)
	{
		if($client->GetSkill(63) < 31)
		{
			quest::say("A fledgling blacksmith!  I've got a little project for you to start out with.  Start out by doing some Simple Studs."); 
			quest::summonitem(98265,20);
			quest::summonitem(58055,20);
			quest::summonitem(58103,1);	
		}
		elsif($client->GetSkill(63) < 38)
		{
			quest::say("Wonderful!  Now, to further that skill, you should try your hand at making some Simple Rings.  They will come in quite handy, don't you think?");
			quest::summonitem(58113,20);
			quest::summonitem(58055,20);
			quest::summonitem(58103,1);	
		}
		elsif($client->GetSkill(63) < 46)
		{
			quest::say("If you'd like to try some real blacksmithing, my secret method for Simple Chisels will do the trick.  I'll share the secret with you though, because you've been such a great student.");
			quest::summonitem(58091,20);
			quest::summonitem(58055,20);
		}
		elsif($client->GetSkill(63) < 54)
		{
			quest::say("Ahh, that was a great job.  Now, it's getting a little late in the day for me.  I've got one last little project, if you'd like to try your hand at it.  These Simple Files are in big demand by many craftsmen. They would be pleased, I'm sure you'll agree.");
			quest::summonitem(98265,20);
			quest::summonitem(58055,20);
			quest::summonitem(58096,20);
		}
		if($client->GetSkill(63) >=54)
		{
			quest::say("I'm sorry, your skill is too great for my help now.  Perhaps it is time to learn another craft.")
		}
	}
}
Code:
Tailoring Recipes:

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25539, 'Simple Quill', 61, 0, 31, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252702, 25539, 58086, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252703, 25539, 58221, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252705, 25539, 58087, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252706, 25539, 16, 0, 0, 0, 0, 1);

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25540, 'Simple Ink', 61, 0, 38, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252707, 25540, 58121, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252708, 25540, 58221, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252709, 25540, 58120, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252710, 25540, 16, 0, 0, 0, 0, 1);

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25541, 'Simple Book Binding', 61, 0, 46, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252711, 25541, 58109, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252712, 25541, 58221, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252713, 25541, 58110, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252714, 25541, 16, 0, 0, 0, 0, 1);

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25542, 'Simple Black Book', 61, 0, 54, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252715, 25542, 58114, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252716, 25542, 58221, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252717, 25542, 58115, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252718, 25542, 16, 0, 0, 0, 0, 1);


Tailor_Nabirye.pl

sub EVENT_SAY
{
	if($text=~/hail/i)
	{
		if($client->GetSkill(61) < 31)
		{
			quest::say("A fledgling tailor!  I've got a little project for you to start out with.  Start out by doing some Simple Belts."); 
			quest::summonitem(58087,20);
			quest::summonitem(58221,20);
		}
		elsif($client->GetSkill(61) < 38)
		{
			quest::say("Wonderful!  Now, to further that skill, you should try your hand at making some Simple Socks.  They will come in quite handy, don't you think?");
			quest::summonitem(58120,20);
			quest::summonitem(58221,20);
		}
		elsif($client->GetSkill(61) < 46)
		{
			quest::say("If you'd like to try some real tailoring, my secret method for Simple Pants will do the trick.  I'll share the secret with you though, because you've been such a great student.");
			quest::summonitem(58110,20);
			quest::summonitem(58221,20);
		}
		elsif($client->GetSkill(61) < 54)
		{
			quest::say("Ahh, that was a great job.  Now, it's getting a little late in the day for me.  I've got one last little project, if you'd like to try your hand at it.  These Simple Shirt are just the thing to go with the pants, I'm sure you'll agree.");
			quest::summonitem(58115,20);
			quest::summonitem(58221,20);
		}
		if($client->GetSkill(61) >=54)
		{
			quest::say("I'm sorry, your skill is too great for my help now.  Perhaps it is time to learn another craft.")
		}
	}
}
Code:
Research Recipes Only:

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25535, 'Simple Quill', 58, 0, 31, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252683, 25535, 98292, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252684, 25535, 98297, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252685, 25535, 98296, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252686, 25535, 11, 0, 0, 0, 0, 1);

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25536, 'Simple Ink', 58, 0, 38, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252687, 25536, 98293, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252688, 25536, 58145, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252689, 25536, 98256, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252690, 25536, 98298, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252691, 25536, 11, 0, 0, 0, 0, 1);

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25537, 'Simple Book Binding', 58, 0, 46, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252692, 25537, 98294, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252693, 25537, 98299, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252694, 25537, 98300, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252695, 25537, 98301, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252696, 25537, 11, 0, 0, 0, 0, 1);

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25538, 'Simple Black Book', 58, 0, 54, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252697, 25538, 98295, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252698, 25538, 98302, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252699, 25538, 98303, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252700, 25538, 98294, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252701, 25538, 11, 0, 0, 0, 0, 1);
Code:
Tinkering Recipes:

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25543, 'Simple Spring', 57, 0, 31, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252719, 25543, 58245, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252720, 25543, 58148, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252721, 25543, 10, 0, 0, 0, 0, 1);

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25544, 'Simple Pulley', 57, 0, 38, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252722, 25544, 58246, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252723, 25544, 58226, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252724, 25544, 58227, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252725, 25544, 58228, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252726, 25544, 10, 0, 0, 0, 0, 1);

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25545, 'Simple Animated Lure', 57, 0, 46, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252727, 25545, 58247, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252728, 25545, 58231, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252729, 25545, 58230, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252730, 25545, 58229, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252731, 25545, 10, 0, 0, 0, 0, 1);

INSERT INTO peq.tradeskill_recipe (id, name, tradeskill, skillneeded, trivial, nofail, replace_container) VALUES ( 25546, 'Simple Bow Cam', 57, 0, 54, 0, 0);

INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252732, 25546, 58248, 1, 0, 0, 0, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252733, 25546, 58232, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252734, 25546, 58234, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252735, 25546, 58233, 0, 0, 1, 1, 0);
INSERT INTO peq.tradeskill_recipe_entries (id, `recipe_id`, `item_id`, `successcount`, `failcount`, `componentcount`, `salvagecount`, `iscontainer`) VALUES ( 252736, 25546, 10, 0, 0, 0, 0, 1);


Matrum_Geerlok.pl

sub EVENT_SAY
{
	if($text=~/hail/i)
	{
		if($client->GetSkill(57) < 31)
		{
			quest::say("A fledgling tinkerer!  I've got a little project for you to start out with.  Start out by doing some Simple Springs."); 
			quest::summonitem(58158,20);
		}
		elsif($client->GetSkill(57) < 38)
		{
			quest::say("Wonderful!  Now, to further that skill, you should try your hand at making some Simple Pulleyss.  They will come in quite handy, don't you think?");
			quest::summonitem(58226,20);
			quest::summonitem(58227,20);
			quest::summonitem(58228,20);
		}
		elsif($client->GetSkill(57) < 46)
		{
			quest::say("If you'd like to try some real tinkering, my secret method for Simple Animated Lures will do the trick.  I'll share the secret with you though, because you've been such a great student.");
			quest::summonitem(58231,20);
			quest::summonitem(58230,20);
			quest::summonitem(58229,20);
		}
		elsif($client->GetSkill(57) < 54)
		{
			quest::say("Ahh, that was a great job.  Now, it's getting a little late in the day for me.  I've got one last little project, if you'd like to try your hand at it.  These Simple Bow Cams are in big demand by many Rangers. They would be pleased, I'm sure you'll agree.");
			quest::summonitem(58232,20);
			quest::summonitem(58233,20);
			quest::summonitem(58234,20);
		}
		if($client->GetSkill(57) >=54)
		{
			quest::say("I'm sorry, your skill is too great for my help now.  Perhaps it is time to learn another craft.")
		}
	}
}
edit: fixed 1 item in research that was incorrect. 98303 should replace 98304 in the last recipe.
Reply With Quote
 

« Previous Thread | Next Thread »

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 02:35 PM.

EQEmulator - Archive - Top

 

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 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3