diff options
| -rw-r--r-- | sql/updates/world/2013_11_03_04_world_creature_template.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/2013_11_03_04_world_creature_template.sql b/sql/updates/world/2013_11_03_04_world_creature_template.sql new file mode 100644 index 00000000000..9dfe9bfbe98 --- /dev/null +++ b/sql/updates/world/2013_11_03_04_world_creature_template.sql @@ -0,0 +1,8 @@ +-- +UPDATE `creature_template` SET `spell1` = 0 WHERE `entry` IN(314, 619, 657, 660, 670, 677, 699, 731, 762, 771, 784, 942, 950, 1029, 1144, 1726, 1808, 1831, 1909, 1912, 1913, 1915, 2071, 2169, 2272, 2534, 2555, 2598, 2894, 3252, 3253, 3416, 3458, 3748, 3750, 3771, 3863, 3922, 3927, 3993, 4057, 4297, 4380, 4440, 4518, 4519, 5451, 5650, 5712, 5715, 5715, 5715, 5822, 5836, 5865, 6212, 6228, 6286, 6427, 7206, 7441, 7738, 7738, 7738, 8551, 8553, 8555, 8978, 9016, 9024, 9257, 9266, 11076, 11077, 11466, 11582, 11613, 11882, 12225, 15430, 15439, 16925, 16944, 17129, 17235, 17395, 18064, 18257, 18327, 18413, 19754, 20109, 20866, 21468, 21804, 21859, 22265, 23051, 5348, 18679, 20691, 24860, 23593, 27664, 40281); +UPDATE `creature_template` SET `spell2` = 0 WHERE `entry` IN(458, 670, 815, 1041, 2337, 2358, 2553, 2555, 2654, 2755, 2894, 3198, 3199, 3203, 3265, 3458, 3728, 3771, 3854, 3927, 4440, 4518, 4519, 4520, 4522, 4530, 4668, 4718, 4811, 5457, 5650, 5836, 6168, 6286, 7441, 7607, 9266, 10374, 11324, 11388, 11668, 13280, 14530, 16345, 16873, 16911, 16912, 17320, 17395, 18037, 18326, 18696, 18859, 19405, 19792, 19987, 19992, 21050, 21710, 22384, 15328, 16184, 21229); +UPDATE `creature_template` SET `spell3` = 0 WHERE `entry` IN(332, 397, 642, 660, 669, 679, 1057, 1364, 1564, 2358, 2534, 2553, 2570, 3725, 3927, 4532, 4813, 4852, 5717, 6008, 6231, 7342, 7728, 7795, 9266, 10596, 11496, 13282, 14523, 16021, 16449, 16473, 18069, 18080, 18210, 18312, 19405, 19424, 19544, 19747, 19806, 19992, 19998, 20248, 20445, 20459, 20929, 21178, 22018, 22363, 22821, 15328, 15863, 16054, 20648, 20302, 22910, 18617, 37575); +UPDATE `creature_template` SET `spell4` = 0 WHERE `entry` IN(397, 1060, 1564, 2590, 3899, 4463, 4852, 7271, 7607, 9039, 10321, 10419, 13280, 16146, 19298, 19994, 20648, 20302, 20301); +UPDATE `creature_template` SET `spell5` = 0 WHERE `entry` = 27678; +UPDATE `creature_template` SET `spell6` = 0 WHERE `entry` = 28668; +UPDATE `creature_template` SET `spell8` = 0 WHERE `entry` IN(16573, 29256); |