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

Quests::Completed This is where Completed quests are.

Reply
 
Thread Tools Display Modes
  #1  
Old 11-05-2007, 02:33 PM
Theeper
Discordant
 
Join Date: May 2004
Posts: 290
Default Prashnak.pl (Spiritcharmers Armor)

Using PEQ Yak DB, Prashnak spawns in Neriak, but on Live, he's back in Grobb. Use this query to put him in the correct place in Grobb.
Code:
UPDATE spawn2 SET zone = 'grobb', x = '-472.5', y = '60.4', z = '54.7' WHERE id = 333847
The quests need the following recipes. I started the recipe IDs at 9445, you may need to adjust those accordingly.

Code:
INSERT INTO tradeskill_recipe VALUES ('9445','Spiritcharmers Coif Material','75','0','0','1','0',NULL);
INSERT INTO tradeskill_recipe_entries VALUES ('','9445','51027','0','0','1','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9445','51028','0','0','2','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9445','51029','0','0','1','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9445','61095','0','0','0','1');
INSERT INTO tradeskill_recipe_entries VALUES ('','9445','61123','1','0','0','0');

INSERT INTO tradeskill_recipe VALUES ('9446','Spiritcharmers Coif','63','0','0','1','0',NULL);
INSERT INTO tradeskill_recipe_entries VALUES ('','9446','61123','0','0','1','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9446','22671','0','0','1','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9446','17','0','0','0','1');
INSERT INTO tradeskill_recipe_entries VALUES ('','9446','61158','1','0','0','0');


INSERT INTO tradeskill_recipe VALUES ('9447','Spiritcharmers Bracer Material','75','0','0','1','0',NULL);
INSERT INTO tradeskill_recipe_entries VALUES ('','9447','51021','0','0','1','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9447','51022','0','0','1','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9447','51023','0','0','2','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9447','61095','0','0','0','1');
INSERT INTO tradeskill_recipe_entries VALUES ('','9447','61124','1','0','0','0');

INSERT INTO tradeskill_recipe VALUES ('9448','Spiritcharmers Bracer','63','0','0','1','0',NULL);
INSERT INTO tradeskill_recipe_entries VALUES ('','9448','61124','0','0','1','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9448','22672','0','0','1','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9448','17','0','0','0','1');
INSERT INTO tradeskill_recipe_entries VALUES ('','9448','61159','1','0','0','0');


INSERT INTO tradeskill_recipe VALUES ('9449','Spiritcharmers Boots Material','75','0','0','1','0',NULL);
INSERT INTO tradeskill_recipe_entries VALUES ('','9449','51030','0','0','2','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9449','51031','0','0','1','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9449','51032','0','0','1','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9449','61095','0','0','0','1');
INSERT INTO tradeskill_recipe_entries VALUES ('','9449','61126','1','0','0','0');

INSERT INTO tradeskill_recipe VALUES ('9450','Spiritcharmers Boots','63','0','0','1','0',NULL);
INSERT INTO tradeskill_recipe_entries VALUES ('','9450','61126','0','0','1','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9450','22674','0','0','1','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9450','17','0','0','0','1');
INSERT INTO tradeskill_recipe_entries VALUES ('','9450','61161','1','0','0','0');


INSERT INTO tradeskill_recipe VALUES ('9451','Spiritcharmers Gauntlets Material','75','0','0','1','0',NULL);
INSERT INTO tradeskill_recipe_entries VALUES ('','9451','51024','0','0','2','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9451','51025','0','0','1','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9451','51026','0','0','1','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9451','61095','0','0','0','1');
INSERT INTO tradeskill_recipe_entries VALUES ('','9451','61128','1','0','0','0');

INSERT INTO tradeskill_recipe VALUES ('9452','Spiritcharmers Gauntlets','63','0','0','1','0',NULL);
INSERT INTO tradeskill_recipe_entries VALUES ('','9452','61128','0','0','1','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9452','22676','0','0','1','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9452','17','0','0','0','1');
INSERT INTO tradeskill_recipe_entries VALUES ('','9452','61163','1','0','0','0');


INSERT INTO tradeskill_recipe VALUES ('9453','Spiritcharmers Legplates Material','75','0','0','1','0',NULL);
INSERT INTO tradeskill_recipe_entries VALUES ('','9453','51033','0','0','2','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9453','51034','0','0','1','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9453','51035','0','0','1','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9453','61095','0','0','0','1');
INSERT INTO tradeskill_recipe_entries VALUES ('','9453','61127','1','0','0','0');

INSERT INTO tradeskill_recipe VALUES ('9454','Spiritcharmers Legplates','63','0','0','1','0',NULL);
INSERT INTO tradeskill_recipe_entries VALUES ('','9454','61127','0','0','1','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9454','22675','0','0','1','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9454','17','0','0','0','1');
INSERT INTO tradeskill_recipe_entries VALUES ('','9454','61162','1','0','0','0');


INSERT INTO tradeskill_recipe VALUES ('9455','Spiritcharmers Sleeves Material','75','0','0','1','0',NULL);
INSERT INTO tradeskill_recipe_entries VALUES ('','9455','7005','0','0','1','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9455','51039','0','0','1','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9455','51040','0','0','2','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9455','61095','0','0','0','1');
INSERT INTO tradeskill_recipe_entries VALUES ('','9455','61125','1','0','0','0');

INSERT INTO tradeskill_recipe VALUES ('9456','Spiritcharmers Sleeves','63','0','0','1','0',NULL);
INSERT INTO tradeskill_recipe_entries VALUES ('','9456','61125','0','0','1','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9456','22673','0','0','1','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9456','17','0','0','0','1');
INSERT INTO tradeskill_recipe_entries VALUES ('','9456','61160','1','0','0','0');


INSERT INTO tradeskill_recipe VALUES ('9457','Spiritcharmers Tunic Material','75','0','0','1','0',NULL);
INSERT INTO tradeskill_recipe_entries VALUES ('','9457','51036','0','0','2','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9457','51037','0','0','1','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9457','51038','0','0','2','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9457','61095','0','0','0','1');
INSERT INTO tradeskill_recipe_entries VALUES ('','9457','61129','1','0','0','0');

INSERT INTO tradeskill_recipe VALUES ('9458','Spiritcharmers Tunic','63','0','0','1','0',NULL);
INSERT INTO tradeskill_recipe_entries VALUES ('','9458','61129','0','0','1','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9458','22677','0','0','1','0');
INSERT INTO tradeskill_recipe_entries VALUES ('','9458','17','0','0','0','1');
INSERT INTO tradeskill_recipe_entries VALUES ('','9458','61164','1','0','0','0');
Reply With Quote
  #2  
Old 11-05-2007, 02:34 PM
Theeper
Discordant
 
Join Date: May 2004
Posts: 290
Default

And here is the script.

Code:
####################
# Prashnak.pl - 
#
# Zone: Grobb - grobb
#
# Quests: Spiritcharmers Armor, Spiritcharmer Final Job (Staff)
#
#

sub EVENT_SAY {

   if ($text=~/Hail/i) {
      quest::say("Hullo $name, who yoo be? You need be a [Shaman] or me not talk to yoo");
   }

   if ($text=~/i am a shaman/i) {
      quest::say("You is Shaman? Well me is too so I can give yoo some tings to do if yoo want to make yer own [armor]");
   }

   if ($text=~/what armor/i) {
      quest::say("Me can tell yoo where to get tings to craft yer own armor. Yoo den take dese tings with dis armor kit and combine dem. When you have yer armor material take it too da forge and with da pattern I give yoo to make yer armor. I can give yoo recipe fer [Coif], [Bracers], [Sleeves], [Boots], [Legplates], [Gauntlets] and [Tunics]. When yoo ready yoo tell me whut piece you [want to craft]");
   quest::summonitem(61095); # Spiritcharmers Assembly Kit
   }

   if ($text=~/want to craft coif/i) {
      quest::say("Here is yer pattern, once yoo have combined a Water Moccasin Tail, two Mosquito Eyes and a Chunk of Digested Earth in yer kit place it in da forge along with dis pattern to create yer Spiritcharmer Chainmail Coif");
   quest::summonitem(22671); # An Enchanted Coif Pattern
   }

   if ($text=~/want to craft bracers/i) {
      quest::say("Go out into da swamp and seek out a Crab Spider's Carapace, da Poison Sac of a Bleeder, and two Airborne Spores. Once yoo have combined dem in yer kit to make da bracer material take it to a forge along with dis pattern to create yer Spiritcharmer Chainmail Bracer.");
   quest::summonitem(22672); # An Enchanted Bracer Pattern
   }

   if ($text=~/want to craft sleeves/i) {
      quest::say("If Sleeves are what yoo wish to craft you will need to get two Chunks of Mosquito Meat, a Large Fungal Spore, and a Giant Snake Fang den combine dem in yer kit to fashion da necessary material. Take dis pattern to da nearest forge with that material to create yer Sleeves of the Spiritcharmer.");
   quest::summonitem(22673); # An Enchanted Sleeves Pattern
   }

   if ($text=~/want to craft boots/i) {
      quest::say("If yoo want to make Boots of da Spiritcharmer you will need two Kobold Talons, and Amulet from an undead froglock, and Ball of Pulpy Fungus. Combine dem together to make yer mold and put it in da forge along with dis pattern to make yer boots.");
   quest::summonitem(22674); # An Enchanted Boots Pattern
   }

   if ($text=~/want to craft legplates/i) {
      quest::say("If yoo want leggings go get two bull alligator teeh, one larval carapace, and a pristine kobold paw den combine dem in yer kit to create yer Legplates Material.");
   quest::summonitem(22675); # An Enchanted Legplates Pattern
   }

   if ($text=~/want to craft gauntlets/i) {
      quest::say("To create da Gauntlet materials please collect two pristine bleeder skins, a crab spiderling's fang and a mushroom spore. When yoo done and have made yer material put it in da forge with dis pattern to make yer gauntlets.");
   quest::summonitem(22676); # An Enchanted Gauntlets Pattern
   }

   if ($text=~/want to craft tunic/i) {
      quest::say("I'm happy to see that yer training is coming along so well $name. I have no doubt in my mind that yoo are ready to craft yer Tunic. Go collect two burly kobold ears, some moccasin poison, and two bull alligator spines. Come back after yoo finished, I have a [job] for yoo.");
   quest::summonitem(22677); # An Enchanted Tunic Pattern
   }

   if ($text=~/what job/i) {
      quest::say("I want yoo too get some tings for me that need for me special trollie. Get me two giant snake rattles, a set of snake scalez, and an alligator tooth and I will give you a nice shiny ting.");
   }

}

sub EVENT_ITEM {

   if(plugin::check_handin(\%itemcount, 13070 => 1, 13058 => 2, 13725 => 1)) { # Giant Snake Rattles x 2, Snake Scales, Alligator Tooth
      quest::summonitem(61100); # Staff of The Spiritcharmer
      quest::exp(100);

   } else {

      quest::say("I have no need for this $name, you can have it back.");
      plugin::return_items(\%itemcount);

   }

}

#END of FILE Zone:grobb  ID: 40074

Last edited by Theeper; 11-05-2007 at 10:36 PM.. Reason: typos
Reply With Quote
  #3  
Old 11-05-2007, 03:44 PM
Theeper
Discordant
 
Join Date: May 2004
Posts: 290
Default

Here is a couple queries to clean up Prashnak's ID and spawn group to keep it more inline with the zoneID * 1000 standard.

Before running these, make sure to verify the npcID is 40074 and the spawngroupID is 40089. Also make sure 52087 is an available npcID and that 52077 is an available Grobb spawn group. If not, change them to whatever fits.

Code:
UPDATE npc_types SET id = '52087' WHERE id = '40074'
UPDATE spawngroup SET id = '52077', name = 'spawn23871' WHERE id = '40089'
UPDATE spawnentry SET spawngroupID = '52077', npcID = '52087' WHERE npcID = '40074'
UPDATE spawn2 SET spawngroupID = '52077' WHERE spawngroupID = '40089'
Reply With Quote
  #4  
Old 11-06-2007, 01:45 AM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

Thank you! Submitted to PEQ. The only minor issue is noob armor material combines should be classified as pottery, and not quest. This is because most (if not all) of the noob armor containers have a bagtype that tells the client they are pottery containers. Usually, they work as quest combines, but this is just to be sure.
Reply With Quote
  #5  
Old 11-06-2007, 06:17 AM
Theeper
Discordant
 
Join Date: May 2004
Posts: 290
Default

Ahh, so the material combines should be 69 (I think) instead of 75 ?
Reply With Quote
Reply


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