diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2019_01_01_00_world_335.sql | 60 |
1 files changed, 60 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_01_01_00_world_335.sql b/sql/updates/world/3.3.5/2019_01_01_00_world_335.sql new file mode 100644 index 00000000000..c05360193cd --- /dev/null +++ b/sql/updates/world/3.3.5/2019_01_01_00_world_335.sql @@ -0,0 +1,60 @@ +-- +UPDATE `trainer_spell` SET `ReqAbility1`=9788 WHERE `SpellId`= 34529; -- 23563; +UPDATE `trainer_spell` SET `ReqAbility1`=9788 WHERE `SpellId`= 34530; -- 23564; +UPDATE `trainer_spell` SET `ReqAbility1`=9788 WHERE `SpellId`= 36256; -- 23565; +UPDATE `trainer_spell` SET `ReqAbility1`=20219 WHERE `SpellId`= 30574; -- 23828; +UPDATE `trainer_spell` SET `ReqAbility1`=20219 WHERE `SpellId`= 30575; -- 23829; +UPDATE `trainer_spell` SET `ReqAbility1`=20219 WHERE `SpellId`= 30569; -- 23835; +UPDATE `trainer_spell` SET `ReqAbility1`=20222 WHERE `SpellId`= 30563; -- 23836; +UPDATE `trainer_spell` SET `ReqAbility1`=20222 WHERE `SpellId`= 30565; -- 23838; +UPDATE `trainer_spell` SET `ReqAbility1`=20222 WHERE `SpellId`= 30566; -- 23839; +UPDATE `trainer_spell` SET `ReqAbility1`=17039 WHERE `SpellId`= 34535; -- 28425; +UPDATE `trainer_spell` SET `ReqAbility1`=17039 WHERE `SpellId`= 34537; -- 28426; +UPDATE `trainer_spell` SET `ReqAbility1`=17039 WHERE `SpellId`= 36258; -- 28427; +UPDATE `trainer_spell` SET `ReqAbility1`=17039 WHERE `SpellId`= 34538; -- 28428; +UPDATE `trainer_spell` SET `ReqAbility1`=17039 WHERE `SpellId`= 34540; -- 28429; +UPDATE `trainer_spell` SET `ReqAbility1`=17039 WHERE `SpellId`= 36259; -- 28430; +UPDATE `trainer_spell` SET `ReqAbility1`=17041 WHERE `SpellId`= 34541; -- 28431; +UPDATE `trainer_spell` SET `ReqAbility1`=17041 WHERE `SpellId`= 34542; -- 28432; +UPDATE `trainer_spell` SET `ReqAbility1`=17041 WHERE `SpellId`= 36260; -- 28433; +UPDATE `trainer_spell` SET `ReqAbility1`=17041 WHERE `SpellId`= 34543; -- 28434; +UPDATE `trainer_spell` SET `ReqAbility1`=17041 WHERE `SpellId`= 34544; -- 28435; +UPDATE `trainer_spell` SET `ReqAbility1`=17041 WHERE `SpellId`= 36261; -- 28436; +UPDATE `trainer_spell` SET `ReqAbility1`=17040 WHERE `SpellId`= 34545; -- 28437; +UPDATE `trainer_spell` SET `ReqAbility1`=17040 WHERE `SpellId`= 34546; -- 28438; +UPDATE `trainer_spell` SET `ReqAbility1`=17040 WHERE `SpellId`= 36262; -- 28439; +UPDATE `trainer_spell` SET `ReqAbility1`=17040 WHERE `SpellId`= 34547; -- 28440; +UPDATE `trainer_spell` SET `ReqAbility1`=17040 WHERE `SpellId`= 34548; -- 28441; +UPDATE `trainer_spell` SET `ReqAbility1`=17040 WHERE `SpellId`= 36263; -- 28442; +UPDATE `trainer_spell` SET `ReqAbility1`=9788 WHERE `SpellId`= 34533; -- 28483; +UPDATE `trainer_spell` SET `ReqAbility1`=9788 WHERE `SpellId`= 34534; -- 28484; +UPDATE `trainer_spell` SET `ReqAbility1`=9788 WHERE `SpellId`= 36257; -- 28485; +UPDATE `trainer_spell` SET `ReqAbility1`=10656 WHERE `SpellId`= 35575; -- 29515; +UPDATE `trainer_spell` SET `ReqAbility1`=10656 WHERE `SpellId`= 35576; -- 29516; +UPDATE `trainer_spell` SET `ReqAbility1`=10656 WHERE `SpellId`= 35577; -- 29517; +UPDATE `trainer_spell` SET `ReqAbility1`=10656 WHERE `SpellId`= 35580; -- 29519; +UPDATE `trainer_spell` SET `ReqAbility1`=10656 WHERE `SpellId`= 35582; -- 29520; +UPDATE `trainer_spell` SET `ReqAbility1`=10656 WHERE `SpellId`= 35584; -- 29521; +UPDATE `trainer_spell` SET `ReqAbility1`=10660 WHERE `SpellId`= 35585; -- 29522; +UPDATE `trainer_spell` SET `ReqAbility1`=10660 WHERE `SpellId`= 35588; -- 29523; +UPDATE `trainer_spell` SET `ReqAbility1`=10660 WHERE `SpellId`= 35587; -- 29524; +UPDATE `trainer_spell` SET `ReqAbility1`=10658 WHERE `SpellId`= 35589; -- 29525; +UPDATE `trainer_spell` SET `ReqAbility1`=10658 WHERE `SpellId`= 35590; -- 29526; +UPDATE `trainer_spell` SET `ReqAbility1`=10658 WHERE `SpellId`= 35591; -- 29527; +UPDATE `trainer_spell` SET `ReqAbility1`=10658 WHERE `SpellId`= 36074; -- 29964; +UPDATE `trainer_spell` SET `ReqAbility1`=10660 WHERE `SpellId`= 36075; -- 29970; +UPDATE `trainer_spell` SET `ReqAbility1`=10656 WHERE `SpellId`= 36076; -- 29971; +UPDATE `trainer_spell` SET `ReqAbility1`=10658 WHERE `SpellId`= 36077; -- 29973; +UPDATE `trainer_spell` SET `ReqAbility1`=10660 WHERE `SpellId`= 36078; -- 29974; +UPDATE `trainer_spell` SET `ReqAbility1`=10656 WHERE `SpellId`= 36079; -- 29975; +UPDATE `trainer_spell` SET `ReqAbility1`=9788 WHERE `SpellId`= 36122; -- 30069; +UPDATE `trainer_spell` SET `ReqAbility1`=9788 WHERE `SpellId`= 36124; -- 30070; +UPDATE `trainer_spell` SET `ReqAbility1`=9787 WHERE `SpellId`= 36125; -- 30071; +UPDATE `trainer_spell` SET `ReqAbility1`=9787 WHERE `SpellId`= 36126; -- 30072; +UPDATE `trainer_spell` SET `ReqAbility1`=9787 WHERE `SpellId`= 36128; -- 30073; +UPDATE `trainer_spell` SET `ReqAbility1`=9788 WHERE `SpellId`= 36129; -- 30074; +UPDATE `trainer_spell` SET `ReqAbility1`=9788 WHERE `SpellId`= 36130; -- 30076; +UPDATE `trainer_spell` SET `ReqAbility1`=17039 WHERE `SpellId`= 36131; -- 30077; +UPDATE `trainer_spell` SET `ReqAbility1`=17039 WHERE `SpellId`= 36133; -- 30086; +UPDATE `trainer_spell` SET `ReqAbility1`=17041 WHERE `SpellId`= 36134; -- 30087; +UPDATE `trainer_spell` SET `ReqAbility1`=17041 WHERE `SpellId`= 36135; -- 30088; |