1 files changed, 1 insertions, 0 deletions
diff --git a/sql/updates/world/2014_04_17_02_world_creature_template.sql b/sql/updates/world/2014_04_17_02_world_creature_template.sql
new file mode 100644
index 00000000000..a2013274b9e
--- /dev/null
+++ b/sql/updates/world/2014_04_17_02_world_creature_template.sql
@@ -0,0 +1 @@
+UPDATE `creature_template` SET `flags_extra`=`flags_extra`|0x80 WHERE `entry` IN (16914, 16995, 17001, 17231, 17274, 17611, 17687, 17992, 17999, 18225, 18242, 18306, 18307, 18553, 18555, 18729, 18757, 18759, 19041, 19215, 19276, 19277, 19278, 19279, 19326, 19328, 19329, 19358, 19359, 19376, 19381, 19439, 19555, 19597, 19654, 19677, 19727, 19870, 20003, 20023, 20024, 20093, 20114, 20286, 20288, 20289, 20391, 20431, 20473, 20475, 20476, 20520, 20608, 20676, 20709, 20769, 20796, 20825, 20889, 20982, 21073, 21075, 21080, 21095, 21097, 21109, 21116, 21119, 21120, 21159, 21241, 21290, 21351, 21365, 21419, 21447, 21456, 21498, 21512, 21641, 21654, 21756, 21791, 21792, 21793, 21794, 21807, 21814, 21855, 21856, 21921, 21924, 21939, 21940, 21946, 21957, 21967, 22008, 22039, 22054, 22083, 22121, 22139, 22228, 22240, 22246, 22269, 22288, 22320, 22340, 22400, 22417, 22422, 22436, 22449, 22470, 22474, 22503, 22504, 22519, 22520, 22523, 22831, 22851, 22905, 23378, 23443, 22833, 22872, 22934, 23409, 23454, 22986, 15730, 16137, 17163, 17367, 17368, 17369, 18582, 18599, 18665, 19010, 19198, 19563, 19577, 20128, 20425, 20602, 20675, 20863, 20979, 21281, 21297, 21321, 21360, 21418, 21473, 21800, 21880, 21910, 21929, 21933, 21934, 22057, 22250, 22418, 22524, 22838, 23037, 23040, 23056, 23059, 23063, 23078, 23116, 23173, 23199, 23212, 23255, 23260, 23262, 23278, 23301, 23310, 23323, 23328, 23382, 23385, 23395, 23500, 23512, 23808, 23488, 24109, 23686, 23758, 24034, 19237, 22296, 22829, 22839, 22866, 22867, 22868, 22916, 22921, 22927, 23043, 23046, 23057, 23058, 23081, 23138, 23155, 23209, 23213, 23225, 23228, 23240, 23250, 23275, 23277, 23307, 23308, 23312, 23313, 23315, 23317, 23369, 23379, 23398, 23424, 23425, 23438, 23442, 23444, 23445, 23845, 23850, 23852, 23853, 23854, 23855, 24171, 24220, 23583, 23585, 23807, 23813, 23814, 23815, 23832, 23893, 23920, 24363, 24412, 24630, 24938, 25115, 24745, 24781, 24809, 24903, 24904, 24908, 24936, 25038, 25068, 25114, 25172, 25213, 25640, 25735, 25744, 25745, 25746, 25782, 25855, 25952, 25964, 25965, 25966, 25971, 25972, 25973, 26057, 26120, 26121, 26190, 26230, 26239, 26251, 26254, 26262, 26346, 26391, 27723, 27890, 26834, 26775, 26774, 27893, 29589, 29588, 28481, 24771, 23750, 23805, 23810, 23821, 23921, 23922, 23923, 23924, 23974, 24000, 24008, 24012, 24087, 24092, 24093, 24094, 24098, 24100, 24101, 24102, 24158, 24165, 24166, 24167, 24170, 24182, 24183, 24184, 24185, 24193, 24194, 24221, 24260, 24269, 24288, 24289, 24290, 24326, 24335, 24336, 24449, 24454, 24465, 24466, 24471, 24513, 24526, 24538, 24645, 24646, 24647, 24651, 24652, 24655, 24665, 24705, 24707, 24725, 24756, 24778, 24817, 24826, 24827, 24828, 24829, 24831, 24832, 24845, 24861, 24862, 24865, 24883, 24902, 24913, 24983, 25342, 25343, 25402, 25403, 25404, 25405, 25431, 25436, 25441, 25442, 25443, 25471, 25472, 25473, 25669, 25670, 25671, 25672, 25698, 25771, 25845, 25846, 25847, 25995, 26041, 26086, 26093, 26094, 26129, 26130, 26162, 26175, 26193, 26264, 26265, 26297, 26373, 26403, 26444, 26445, 26468, 26469, 26470, 26477, 26498, 26559, 26591, 26612, 26656, 26675, 26700, 26785, 26789, 26804, 26855, 26856, 26857, 26918, 26927, 26937, 27047, 27048, 27180, 27222, 27223, 27263, 27264, 27265, 27297, 27306, 27323, 27326, 27339, 27353, 27369, 27375, 27384, 27392, 27396, 27402, 27403, 27413, 27418, 27420, 27446, 27448, 27449, 27453, 27454, 27466, 27529, 27568, 27569, 27572, 27583, 27589, 27622, 27660, 27663, 27669, 27679, 27688, 27689, 27702, 27710, 27757, 27802, 27851, 27869, 27880, 27889, 27921, 27929, 27931, 27988, 27994, 28008, 28055, 28064, 28128, 28190, 28198, 28230, 28237, 28240, 28248, 28254, 28260, 28265, 28273, 28279, 28293, 28294, 28295, 28296, 28299, 28300, 28304, 28305, 28307, 28316, 28330, 28333, 28352, 28367, 28454, 28455, 28456, 28457, 28458, 28459, 28460, 28461, 28462, 28463, 28466, 28469, 28478, 28483, 28485, 28509, 28520, 28525, 28542, 28543, 28544, 28617, 28627, 28631, 28632, 28633, 28643, 28648, 28655, 28663, 28664, 28724, 28738, 28739, 28740, 28741, 28751, 28761, 28762, 28770, 28773, 28777, 28778, 28786, 28789, 28816, 28823, 28839, 28852, 28874, 28882, 28927, 28928, 28929, 28932, 28935, 29011, 29027, 29038, 29079, 29081, 29094, 29099, 29100, 29105, 29138, 29170, 29184, 29192, 29215, 29276, 29326, 29345, 29397, 29401, 29416, 29425, 29459, 29521, 29558, 29577, 29580, 29581, 29595, 29597, 29599, 29655, 29685, 29747, 29752, 29771, 29772, 29773, 29805, 29812, 29815, 29816, 29870, 29871, 29876, 29877, 29881, 29928, 29999, 30050, 30078, 30079, 30091, 30101, 30103, 30122, 30125, 30126, 30130, 30131, 30132, 30133, 30138, 30139, 30151, 30153, 30207, 30209, 30210, 30211, 30212, 30302, 30327, 30339, 30342, 30366, 30384, 30391, 30402, 30415, 30421, 30435, 30442, 30492, 30514, 30559, 30577, 30588, 30589, 30598, 30614, 30616, 30646, 30648, 30649, 30650, 30651, 30655, 30669, 30700, 30707, 30712, 30742, 30744, 30745, 30749, 30832, 30857, 30878, 30887, 30896, 30950, 30990, 30995, 31006, 31047, 31049, 31077, 31092, 31105, 31117, 31246, 31264, 31272, 31312, 31353, 31358, 31364, 31400, 31481, 31517, 31576, 31577, 31641, 31643, 31653, 31683, 31684, 31690, 31743, 31745, 31767, 31773, 31777, 31794, 31811, 31817, 31845, 31869, 31880, 31887, 31888, 31915, 32167, 32168, 32200, 32202, 32214, 32215, 32217, 32221, 32224, 32232, 32256, 32264, 32266, 32277, 32298, 32314, 32318, 32319, 32328, 32339, 32366, 32427, 32431, 32442, 32448, 32504, 32520, 32527, 32530, 32531, 32532, 32575, 32606, 32608, 32647, 32662, 32694, 32742, 32768, 32788, 32790, 32782, 32784, 32819, 32824, 32825, 32827, 32829, 32831, 32926, 32938, 33045, 33108, 33170, 33174, 33192, 33212, 33233, 33280, 33282, 33292, 33337, 33342, 33364, 33365, 33366, 33367, 33369, 33370, 33377, 33575, 33661, 33742, 33779, 33835, 33874, 33953, 33958, 33990, 33991, 34146, 34150, 34151, 34157, 34194, 34213, 34319, 26688, 34735, 35614, 34381, 35089, 35106, 34810, 36155, 35014, 34743, 34781, 35376, 35820, 34854, 35227, 35226, 35062, 35821, 34755, 36093, 35015, 34562, 34741, 34899, 34737, 34739, 34740, 36209, 34738, 35055, 35297, 36099, 34548, 34879, 36551, 36944, 36945, 36946, 36947, 36967, 36983, 37543, 37574, 37906, 36934, 37158, 38751, 37814, 37503, 38035, 37564, 35228, 36737, 35018, 36189, 38121, 38199, 38548, 37801, 37745, 38289, 38310, 38353, 38527, 38528, 38587, 38588, 38870, 38882, 38907, 39135, 39581, 39672, 39743, 39744, 39841, 39842, 40151, 40199, 40218, 40263, 40363, 40479, 40506, 40617);