EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)
-   -   Add Skinspike Potions (https://www.eqemulator.org/forums/showthread.php?t=36346)

werebat 01-26-2013 12:54 PM

Add Skinspike Potions
 
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';



All times are GMT -4. The time now is 02:02 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.