Prashnak.pl (Spiritcharmers Armor)

Theeper · #1 11-05-2007, 02:33 PM

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