aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMeji <alvaro.megias@outlook.com>2022-08-01 00:29:37 +0200
committerModoX <moardox@gmail.com>2022-08-01 00:30:06 +0200
commitb49e66199ee4f00ebd87be3370753b14ddccdd4a (patch)
tree257db7c4615f39da94937fe7bdd61dddc8c25e3a
parented2a2f032a35b35a5c0cf7a1e651630229581986 (diff)
DB/Trainers: Restore battlepet trainer spells after 2a2aea27b728a9ae5c946b5adf912bcae4ef9eb1
-rw-r--r--sql/updates/world/master/2022_08_01_00_world.sql15
1 files changed, 15 insertions, 0 deletions
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);