werebat
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.
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';
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';