aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOvahlord <dreadkiller@gmx.de>2025-04-15 10:40:17 +0200
committerOvahlord <dreadkiller@gmx.de>2025-04-15 10:40:17 +0200
commit0bd533688eab84962a50fe10f72f2e53eae847c8 (patch)
treed02e9e21087f9c6b34cb61c674af6a7d9e20438b
parentf6b38add80ec827a11216b0ee698e4cead49988e (diff)
DB/Trainers: added trainer data for Draenei starting zone class trainers
-rw-r--r--sql/updates/world/cata_classic/2025_04_15_01_world.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/cata_classic/2025_04_15_01_world.sql b/sql/updates/world/cata_classic/2025_04_15_01_world.sql
new file mode 100644
index 00000000000..f5c13c76ab2
--- /dev/null
+++ b/sql/updates/world/cata_classic/2025_04_15_01_world.sql
@@ -0,0 +1,12 @@
+UPDATE `trainer_spell` SET `MoneyCost`=105 WHERE (`TrainerId`=15 AND `SpellId`=1494);
+UPDATE `trainer_spell` SET `MoneyCost`=60 WHERE (`TrainerId`=145 AND `SpellId`=100);
+UPDATE `trainer_spell` SET `MoneyCost`=140 WHERE (`TrainerId`=145 AND `SpellId`=34428);
+
+DELETE FROM `creature_trainer` WHERE (`CreatureID`=16500 AND `MenuID`=7264 AND `OptionID`=0) OR (`CreatureID`=17089 AND `MenuID`=7522 AND `OptionID`=0) OR (`CreatureID`=16502 AND `MenuID`=7349 AND `OptionID`=0) OR (`CreatureID`=16499 AND `MenuID`=7262 AND `OptionID`=0) OR (`CreatureID`=16501 AND `MenuID`=7260 AND `OptionID`=0) OR (`CreatureID`=16503 AND `MenuID`=7263 AND `OptionID`=0);
+INSERT INTO `creature_trainer` (`CreatureID`, `TrainerID`, `MenuID`, `OptionID`) VALUES
+(16500, 44, 7264, 0),
+(17089, 134, 7522, 0),
+(16502, 3, 7349, 0),
+(16499, 15, 7262, 0),
+(16501, 168, 7260, 0),
+(16503, 145, 7263, 0);