DB/Trainer: Fixed several Alliance Bandage Trainer spells

- Stormwind / Goldshire
- Ironforge / Kharanos
- Darnassus / Teldrassil
- Exodar / Azure Watch / Blood Watch

Closes #28125

1 files changed, 34 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_07_17_01_world.sql b/sql/updates/world/master/2022_07_17_01_world.sql
new file mode 100644
index 00000000000..a9768264a86
--- /dev/null
+++ b/sql/updates/world/master/2022_07_17_01_world.sql
@@ -0,0 +1,34 @@
+UPDATE `trainer` SET `VerifiedBuild`=44325 WHERE `Id` IN (877, 880);
+
+UPDATE `trainer_spell` SET `MoneyCost`=6175, `VerifiedBuild`=44325 WHERE (`SpellId`=7928 AND `TrainerId` IN (877,880)); -- No Faction found! MoneyCost not recalculated!
+UPDATE `trainer_spell` SET `MoneyCost`=17100, `VerifiedBuild`=44325 WHERE (`SpellId`=7929 AND `TrainerId` IN (877,880)); -- No Faction found! MoneyCost not recalculated!
+UPDATE `trainer_spell` SET `MoneyCost`=1662, `VerifiedBuild`=44325 WHERE (`SpellId`=3278 AND `TrainerId` IN (877,880)); -- No Faction found! MoneyCost not recalculated!
+UPDATE `trainer_spell` SET `MoneyCost`=380, `VerifiedBuild`=44325 WHERE (`SpellId`=3277 AND `TrainerId` IN (877,880)); -- No Faction found! MoneyCost not recalculated!
+UPDATE `trainer_spell` SET `MoneyCost`=142, `VerifiedBuild`=44325 WHERE (`SpellId`=3276 AND `TrainerId` IN (877,880)); -- No Faction found! MoneyCost not recalculated!
+UPDATE `trainer_spell` SET `MoneyCost`=532000, `VerifiedBuild`=44325 WHERE (`SpellId`=18630 AND `TrainerId` IN (877,880)); -- No Faction found! MoneyCost not recalculated!
+UPDATE `trainer_spell` SET `MoneyCost`=43700, `VerifiedBuild`=44325 WHERE (`SpellId`=10840 AND `TrainerId` IN (877,880)); -- No Faction found! MoneyCost not recalculated!
+UPDATE `trainer_spell` SET `MoneyCost`=123500, `VerifiedBuild`=44325 WHERE (`SpellId`=10841 AND `TrainerId` IN (877,880)); -- No Faction found! MoneyCost not recalculated!
+UPDATE `trainer_spell` SET `MoneyCost`=247000, `VerifiedBuild`=44325 WHERE (`SpellId`=18629 AND `TrainerId` IN (877,880)); -- No Faction found! MoneyCost not recalculated!
+UPDATE `trainer_spell` SET `MoneyCost`=332, `VerifiedBuild`=44325 WHERE (`TrainerId`=880 AND `SpellId` IN (74558,88893)); -- No Faction found! MoneyCost not recalculated!
+UPDATE `trainer_spell` SET `VerifiedBuild`=44325 WHERE (`TrainerId`=880 AND `SpellId` IN (74556,27032,45545,7928,7929,3278,3277,74558,88893,74557,27033,45546,3276,18630,10840,10841,18629));
+UPDATE `trainer_spell` SET `MoneyCost`=95, `VerifiedBuild`=44325 WHERE (`TrainerId`=880 AND `SpellId`=74557); -- No Faction found! MoneyCost not recalculated!
+UPDATE `trainer_spell` SET `MoneyCost`=109, `VerifiedBuild`=44325 WHERE (`TrainerId`=880 AND `SpellId`=27033); -- No Faction found! MoneyCost not recalculated!
+UPDATE `trainer_spell` SET `MoneyCost`=48, `VerifiedBuild`=44325 WHERE (`TrainerId`=880 AND `SpellId`=45546); -- No Faction found! MoneyCost not recalculated!
+
+DELETE FROM `creature_trainer` WHERE (`CreatureID`=5150 AND `MenuID`=4762 AND `OptionID`=0);
+INSERT INTO `creature_trainer` (`CreatureID`, `TrainerID`, `MenuID`, `OptionID`) VALUES
+(5150, 880, 4762, 0);
+
+UPDATE `creature_trainer` SET `TrainerID`=877 WHERE (`CreatureID`=6094 AND `MenuID`=5855 AND `OptionID`=0) OR (`CreatureID`=17424 AND `MenuID`=7455 AND `OptionID`=0) OR (`CreatureID`=17214 AND `MenuID`=7380 AND `OptionID`=0) OR (`CreatureID`=16731 AND `MenuID`=5855 AND `OptionID`=0) OR (`CreatureID`=2326 AND `MenuID`=5855 AND `OptionID`=0) OR (`CreatureID`=2329 AND `MenuID`=5855 AND `OptionID`=0);
+UPDATE `creature_trainer` SET `TrainerID`=880 WHERE (`CreatureID`=4211 AND `MenuID`=5855 AND `OptionID`=0);
+
+-- Update Template
+UPDATE `creature_template` SET `gossip_menu_id`=4762, `minlevel`=60, `maxlevel`=60, `npcflag`=83 WHERE `entry`=5150; -- Nissa Firestone
+UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30, `npcflag`=81 WHERE `entry`=2326; -- Thamner Pol
+UPDATE `creature_template` SET `gossip_menu_id`=657, `minlevel`=60, `npcflag`=81 WHERE `entry`=56796; -- Angela Leifeld
+UPDATE `creature_template` SET `npcflag`=81 WHERE `entry`=2329; -- Michelle Belle
+UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30, `npcflag`=83 WHERE `entry`=17424; -- Anchorite Paetheus
+UPDATE `creature_template` SET `minlevel`=50, `maxlevel`=50, `npcflag`=81 WHERE `entry`=16731; -- Nus
+UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30, `npcflag`=83 WHERE `entry`=17214; -- Anchorite Fateema
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `npcflag`=81 WHERE `entry`=4211; -- Dannelor
+UPDATE `creature_template` SET `npcflag`=81 WHERE `entry`=6094; -- Byancie