Add Skinspike Potions

werebat · #1 01-26-2013, 12:54 PM

I wrote this to add the skinspike potions to the PoK potion vendors. I use the peqdb and it works great. I run a private server and wanted to be able to buy these when I dont have a shammy.

Code:

insert into merchantlist (merchantid, slot, item, faction_required, level_required, alt_currency_cost)
 select n.id, (select max(slot)+1 from merchantlist where merchantid = n.id), (select id from items where name = 'Distillate of Skinspikes I'), -100, 0, 0 from npc_types n where name = 'Elwin_Razorfur';
insert into merchantlist (merchantid, slot, item, faction_required, level_required, alt_currency_cost)
 select n.id, (select max(slot)+1 from merchantlist where merchantid = n.id), (select id from items where name = 'Distillate of Skinspikes II'), -100, 0, 0 from npc_types n where name = 'Elwin_Razorfur';
insert into merchantlist (merchantid, slot, item, faction_required, level_required, alt_currency_cost)
 select n.id, (select max(slot)+1 from merchantlist where merchantid = n.id), (select id from items where name = 'Distillate of Skinspikes III'), -100, 0, 0 from npc_types n where name = 'Elwin_Razorfur';
insert into merchantlist (merchantid, slot, item, faction_required, level_required, alt_currency_cost)
 select n.id, (select max(slot)+1 from merchantlist where merchantid = n.id), (select id from items where name = 'Distillate of Skinspikes IV'), -100, 0, 0 from npc_types n where name = 'Elwin_Razorfur';
insert into merchantlist (merchantid, slot, item, faction_required, level_required, alt_currency_cost)
 select n.id, (select max(slot)+1 from merchantlist where merchantid = n.id), (select id from items where name = 'Distillate of Skinspikes V'), -100, 0, 0 from npc_types n where name = 'Elwin_Razorfur';
insert into merchantlist (merchantid, slot, item, faction_required, level_required, alt_currency_cost)
 select n.id, (select max(slot)+1 from merchantlist where merchantid = n.id), (select id from items where name = 'Distillate of Skinspikes VI'), -100, 0, 0 from npc_types n where name = 'Ralkor_Stoneclaw';
insert into merchantlist (merchantid, slot, item, faction_required, level_required, alt_currency_cost)
 select n.id, (select max(slot)+1 from merchantlist where merchantid = n.id), (select id from items where name = 'Distillate of Skinspikes VII'), -100, 0, 0 from npc_types n where name = 'Ralkor_Stoneclaw';
insert into merchantlist (merchantid, slot, item, faction_required, level_required, alt_currency_cost)
 select n.id, (select max(slot)+1 from merchantlist where merchantid = n.id), (select id from items where name = 'Distillate of Skinspikes VIII'), -100, 0, 0 from npc_types n where name = 'Ralkor_Stoneclaw';
insert into merchantlist (merchantid, slot, item, faction_required, level_required, alt_currency_cost)
 select n.id, (select max(slot)+1 from merchantlist where merchantid = n.id), (select id from items where name = 'Distillate of Skinspikes IX'), -100, 0, 0 from npc_types n where name = 'Ralkor_Stoneclaw';
insert into merchantlist (merchantid, slot, item, faction_required, level_required, alt_currency_cost)
 select n.id, (select max(slot)+1 from merchantlist where merchantid = n.id), (select id from items where name = 'Distillate of Skinspikes X'), -100, 0, 0 from npc_types n where name = 'Ralkor_Stoneclaw';