DB/Trainers: Add missing conditions required to learn spells from trainers part2

Ref #9635

1 files changed, 16 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2019_01_01_01_world_335.sql b/sql/updates/world/3.3.5/2019_01_01_01_world_335.sql
new file mode 100644
index 00000000000..d6545492bc5
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_01_01_01_world_335.sql
@@ -0,0 +1,16 @@
+-- 
+UPDATE `trainer_spell` SET `ReqAbility1`=17040 WHERE `SpellId`= 36136; -- 30089;
+UPDATE `trainer_spell` SET `ReqAbility1`=17040 WHERE `SpellId`= 36137; -- 30093;
+UPDATE `trainer_spell` SET `ReqAbility1`=20222 WHERE `SpellId`= 36954; -- 30542;
+UPDATE `trainer_spell` SET `ReqAbility1`=20219 WHERE `SpellId`= 36955; -- 30544;
+UPDATE `trainer_spell` SET `ReqAbility1`=34090 WHERE `SpellId`= 44155; -- 34060;
+UPDATE `trainer_spell` SET `ReqAbility1`=34091 WHERE `SpellId`= 44157; -- 34061;
+UPDATE `trainer_spell` SET `ReqAbility1`=20219 WHERE `SpellId`= 56473; -- 40895;
+UPDATE `trainer_spell` SET `ReqAbility1`=9787 WHERE `SpellId`= 55183; -- 41186;
+UPDATE `trainer_spell` SET `ReqAbility1`=9787 WHERE `SpellId`= 55184; -- 41187;
+UPDATE `trainer_spell` SET `ReqAbility1`=9787 WHERE `SpellId`= 55185; -- 41188;
+UPDATE `trainer_spell` SET `ReqAbility1`=9788 WHERE `SpellId`= 55186; -- 41189;
+UPDATE `trainer_spell` SET `ReqAbility1`=9788 WHERE `SpellId`= 55187; -- 41190;
+UPDATE `trainer_spell` SET `ReqAbility1`=20222 WHERE `SpellId`= 56514; -- 42641;
+UPDATE `trainer_spell` SET `ReqAbility1`=34090 WHERE `SpellId`= 60969; -- 44554;
+UPDATE `trainer_spell` SET `ReqAbility1`=34091 WHERE `SpellId`= 60971; -- 44558;