From 0bd533688eab84962a50fe10f72f2e53eae847c8 Mon Sep 17 00:00:00 2001 From: Ovahlord Date: Tue, 15 Apr 2025 10:40:17 +0200 Subject: DB/Trainers: added trainer data for Draenei starting zone class trainers --- sql/updates/world/cata_classic/2025_04_15_01_world.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 sql/updates/world/cata_classic/2025_04_15_01_world.sql (limited to 'sql/updates') 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); -- cgit v1.2.3