Prashnak.pl (Spiritcharmers Armor)

[Theeper]

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.

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.

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');

[Theeper]

And here is the script.

####################
# 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

[Theeper]

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.

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'

[cavedude]

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.

[Theeper]

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