Code:
-- Fix Warrior's Bladestorm
DELETE FROM `spell_linked_spell` where `spell_trigger` in (46924);
INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES
('46924', '-13810', '2', 'Bladestorm immune at Frost Trap'),
('46924', '-51514', '2', 'Bladestorm immune at Hex'),
('46924', '-116', '2', 'Bladestorm immune at FrostBolt'),
('46924', '-45524', '2', 'Bladestorm immune at Chains of Ice'),
('46924', '-68766', '2', 'Bladestorm immune at Desecration'),
('46924', '-58617', '2', 'Bladestorm immune at Glyph of Heart Strike');
-- Fix Npc Dame Evniki Kapsalis vending list
DELETE FROM npc_vendor WHERE entry=34885;
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','42943','0','0','2674');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','42944','0','0','2673');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','42945','0','0','2673');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','42946','0','0','2674');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','42947','0','0','2674');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','42948','0','0','2675');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','42949','0','0','2673');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','42950','0','0','2673');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','42951','0','0','2673');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','42952','0','0','2673');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','42984','0','0','2673');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','42985','0','0','2673');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','42991','0','0','2675');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','42992','0','0','2675');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','46843','0','0','2597');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','46874','0','0','2598');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','47179','0','0','2600');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','47180','0','0','2600');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','47541','0','0','2603');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','48677','0','0','2673');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','48683','0','0','2673');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','48685','0','0','2673');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','48687','0','0','2673');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','48689','0','0','2673');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','48691','0','0','2673');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','48716','0','0','2675');
insert into `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) values('34885','0','48718','0','0','2674');
Share This Thread