From b49e66199ee4f00ebd87be3370753b14ddccdd4a Mon Sep 17 00:00:00 2001 From: Meji Date: Mon, 1 Aug 2022 00:29:37 +0200 Subject: DB/Trainers: Restore battlepet trainer spells after 2a2aea27b728a9ae5c946b5adf912bcae4ef9eb1 --- sql/updates/world/master/2022_08_01_00_world.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 sql/updates/world/master/2022_08_01_00_world.sql diff --git a/sql/updates/world/master/2022_08_01_00_world.sql b/sql/updates/world/master/2022_08_01_00_world.sql new file mode 100644 index 00000000000..5b743ac86f9 --- /dev/null +++ b/sql/updates/world/master/2022_08_01_00_world.sql @@ -0,0 +1,15 @@ +-- +DELETE FROM `trainer_spell` WHERE `TrainerId`=580; +INSERT INTO `trainer_spell` (`TrainerId`, `SpellId`, `MoneyCost`, `ReqSkillLine`, `ReqSkillRank`, `ReqAbility1`, `ReqAbility2`, `ReqAbility3`, `ReqLevel`, `VerifiedBuild`) VALUES +(580,125610,1000,0,0,0,0,0,1,41079), +(580,10676,500,0,0,119467,0,0,0,41079), +(580,10688,500,0,0,119467,0,0,0,41079), +(580,10707,500,0,0,119467,0,0,0,41079), +(580,10709,500,0,0,119467,0,0,0,41079), +(580,10711,500,0,0,119467,0,0,0,41079), +(580,10714,500,0,0,119467,0,0,0,41079), +(580,35907,500,0,0,119467,0,0,0,41079), +(580,36027,500,0,0,119467,0,0,0,41079), +(580,123212,500,0,0,119467,0,0,0,41079), +(580,123214,500,0,0,119467,0,0,0,41079), +(580,127816,500,0,0,119467,0,0,0,41079); -- cgit v1.2.3