diff options
| -rw-r--r-- | sql/updates/world/master/2017_05_10_06_world.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_05_10_06_world.sql b/sql/updates/world/master/2017_05_10_06_world.sql new file mode 100644 index 00000000000..97b6263eabe --- /dev/null +++ b/sql/updates/world/master/2017_05_10_06_world.sql @@ -0,0 +1,6 @@ +-- +DELETE FROM `creature_model_info` WHERE `DisplayID` IN (546,2156,2157,4921,4977,4978,6765,7268,7269,7270,10932,11254,11267,11730,14692,14693,14933,16188,17328,17378,17675,17698,17702,18270,18362,18363,18372,18379,18736,19141,19609,20065,20964,21137,21251,23056,24273,24446,24447,24472,24891,25202,25579,26363,27561,27721,28283,28733,30650,31812,33216,33068,33069,31533,29680,35525,37284,31477,33071,33072,31530,37096,34788,35520,35534,35548,35521,35535,36787,35549,36788,29930,30029,31532,31534,31791,32782,32783,33066,33067,34878,34879,34882,34883,34884,34886,35358,35359,36430,36431,36432,36646,37584,37586,45262,45390,46377,48005,48149,50357,51187,51466,52527,52622,53942,56875,60176,63520,63638,64072,64773,64917,65045,65223,65499,66708,66709,66710,66711,66713,66714,66715,66724,66725,66726,66727,68353,70322,70332,71476,71743,71810,67522,67517,67511,69537,65661,66497,66689,66691,66695,66700,66701,66702,66703,66712,67418,67473,67515,67553,67701,68046,68047,68049,68050,68052,68190,68228,68229,68668,68817,68823,69200,70452,70453,70454,70455,70456,70457,70588,71983,72639,74294,74295,74570,74667); +UPDATE `creature_template` SET `spell1` = 0 WHERE `spell1` IN (6673,8050,6331,21562,324,2457,2136,1459,15571,689,8129,8056,8145,2944,15473,33663,19503,12328,46045,44583,10,91065,95494,91066,91937,90250,90212,90169,90487,90486,90491,90526,90308,90653,90659,90665,90668,90692,90693,90697,90695,90705,90704,90715,90712,90737,90756,90839,90303,90844,90851,90849,90856,90858,90867,90866,90870,90868,90872,90875,90906,90912,90918,90921,90915,90931,90930,90955,90959,90939,90947,90933,90981,91736,91735,90979,91010,90995,91005,91006,91016,91028,91037,91035,91033,91081,91091,91039,91049,91043,92748,91046,91051,91054,91057,91063,91040,91286,91718,91863,91859,92842); +UPDATE `creature_template` SET `spell2` = 0 WHERE `spell2` IN (6673,8050,6331,21562,324,2457,2136,1459,15571,689,8129,8056,8145,2944,15473,33663,19503,12328,46045,44583,10,91065,95494,91066,91937,90250,90212,90169,90487,90486,90491,90526,90308,90653,90659,90665,90668,90692,90693,90697,90695,90705,90704,90715,90712,90737,90756,90839,90303,90844,90851,90849,90856,90858,90867,90866,90870,90868,90872,90875,90906,90912,90918,90921,90915,90931,90930,90955,90959,90939,90947,90933,90981,91736,91735,90979,91010,90995,91005,91006,91016,91028,91037,91035,91033,91081,91091,91039,91049,91043,92748,91046,91051,91054,91057,91063,91040,91286,91718,91863,91859,92842); +UPDATE `creature_template` SET `spell3` = 0 WHERE `spell3` IN (6673,8050,6331,21562,324,2457,2136,1459,15571,689,8129,8056,8145,2944,15473,33663,19503,12328,46045,44583,10,91065,95494,91066,91937,90250,90212,90169,90487,90486,90491,90526,90308,90653,90659,90665,90668,90692,90693,90697,90695,90705,90704,90715,90712,90737,90756,90839,90303,90844,90851,90849,90856,90858,90867,90866,90870,90868,90872,90875,90906,90912,90918,90921,90915,90931,90930,90955,90959,90939,90947,90933,90981,91736,91735,90979,91010,90995,91005,91006,91016,91028,91037,91035,91033,91081,91091,91039,91049,91043,92748,91046,91051,91054,91057,91063,91040,91286,91718,91863,91859,92842); +UPDATE `creature_template` SET `spell4` = 0 WHERE `spell4` IN (6673,8050,6331,21562,324,2457,2136,1459,15571,689,8129,8056,8145,2944,15473,33663,19503,12328,46045,44583,10,91065,95494,91066,91937,90250,90212,90169,90487,90486,90491,90526,90308,90653,90659,90665,90668,90692,90693,90697,90695,90705,90704,90715,90712,90737,90756,90839,90303,90844,90851,90849,90856,90858,90867,90866,90870,90868,90872,90875,90906,90912,90918,90921,90915,90931,90930,90955,90959,90939,90947,90933,90981,91736,91735,90979,91010,90995,91005,91006,91016,91028,91037,91035,91033,91081,91091,91039,91049,91043,92748,91046,91051,91054,91057,91063,91040,91286,91718,91863,91859,92842); |