DB/Creature: Audrey Burnhep <Battle Pet Trainer>

Closes #22789

1 files changed, 30 insertions, 0 deletions

diff --git a/sql/updates/world/master/2019_01_26_00_world.sql b/sql/updates/world/master/2019_01_26_00_world.sql
new file mode 100644
index 00000000000..4e21d77ce1a
--- /dev/null
+++ b/sql/updates/world/master/2019_01_26_00_world.sql
@@ -0,0 +1,30 @@
+-- 
+DELETE FROM `spell_target_position` WHERE (`ID`=130702 AND `EffectIndex`=0);
+INSERT INTO `spell_target_position` (`ID`, `EffectIndex`, `MapID`, `PositionX`, `PositionY`, `PositionZ`, `VerifiedBuild`) VALUES
+(130702, 0, 870, -307.16, -1772.89, 62.32, 28153);
+
+UPDATE `trainer_spell` SET `MoneyCost`=425, `VerifiedBuild`=28153 WHERE (`TrainerId`=580 AND `SpellId`=35907);
+UPDATE `trainer_spell` SET `MoneyCost`=850 WHERE (`TrainerId`=580 AND `SpellId`=125610);
+
+DELETE FROM `npc_vendor` WHERE (`entry`=63596 AND `item`=98715 AND `ExtendedCost`=4301 AND `type`=1) OR (`entry`=63596 AND `item`=98715 AND `ExtendedCost`=4300 AND `type`=1) OR (`entry`=63596 AND `item`=98715 AND `ExtendedCost`=4299 AND `type`=1) OR (`entry`=63596 AND `item`=98715 AND `ExtendedCost`=4298 AND `type`=1) OR (`entry`=63596 AND `item`=98715 AND `ExtendedCost`=4297 AND `type`=1) OR (`entry`=63596 AND `item`=98715 AND `ExtendedCost`=4296 AND `type`=1) OR (`entry`=63596 AND `item`=98715 AND `ExtendedCost`=4295 AND `type`=1) OR (`entry`=63596 AND `item`=98715 AND `ExtendedCost`=4294 AND `type`=1) OR (`entry`=63596 AND `item`=98715 AND `ExtendedCost`=4293 AND `type`=1) OR (`entry`=63596 AND `item`=98715 AND `ExtendedCost`=4292 AND `type`=1);
+INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES
+(63596, 10, 98715, 0, 4301, 1, 0, 0, 28153),
+(63596, 9, 98715, 0, 4300, 1, 0, 0, 28153), 
+(63596, 8, 98715, 0, 4299, 1, 0, 0, 28153), 
+(63596, 7, 98715, 0, 4298, 1, 0, 0, 28153), 
+(63596, 6, 98715, 0, 4297, 1, 0, 0, 28153), 
+(63596, 5, 98715, 0, 4296, 1, 0, 0, 28153), 
+(63596, 4, 98715, 0, 4295, 1, 0, 0, 28153), 
+(63596, 3, 98715, 0, 4294, 1, 0, 0, 28153), 
+(63596, 2, 98715, 0, 4293, 1, 0, 0, 28153), 
+(63596, 1, 98715, 0, 4292, 1, 0, 0, 28153); 
+
+DELETE FROM `gossip_menu_option` WHERE (`MenuId`=22082 AND `OptionIndex`=0) OR (`MenuId`=22201 AND `OptionIndex`=3) OR (`MenuId`=22081 AND `OptionIndex`=0);
+INSERT INTO `gossip_menu_option` (`MenuId`, `OptionIndex`, `OptionIcon`, `OptionText`, `OptionBroadcastTextId`, `VerifiedBuild`) VALUES
+(22082, 0, 0, 'What do we know about the void elves?', 0, 28153),
+(22201, 3, 0, 'What can you tell me about the Dark Iron dwarves?', 0, 28153),
+(22081, 0, 0, 'What can you tell me about the Lightforged draenei?', 0, 28153);
+
+DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=112694;
+INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES
+(112694, 224326, 1, 0);