nocombatunscripted.sql

-- Set CREATURE_FLAG_EXTRA_NO_COMBAT for all creatures with  CREATURE_DIFFICULTYFLAGS_IGNORE_COMBAT that are NOT scripted.
UPDATE `creature_template` SET `flags_extra`= `flags_extra` | 0x2000 WHERE `entry` IN (1182, 14122, 15546, 15904, 15910, 16400, 16897, 16898, 16899, 17059, 17060, 17176, 17211, 17231, 17293, 17469, 17529, 17611, 17687, 17847, 18308, 18370, 18409, 18458, 18491, 18504, 18564, 18581, 18793, 18891, 19159, 19211, 19212, 19297, 19376, 19387, 19388, 19437, 19439, 19464, 19483, 19484, 19597, 19677, 19727, 19845, 19922, 19939, 20003, 20023, 20024, 20084, 20093, 20133, 20148, 20155, 20156, 20229, 20286, 20288, 20289, 20391, 20392, 20431, 20605, 20608, 20709, 20736, 20804, 20858, 20978, 21030, 21041, 21092, 21094, 21095, 21096, 21157, 21160, 21203, 21290, 21322, 21414, 21436, 21437, 21438, 21439, 21440, 21447, 21664, 21682, 21683, 21684, 21726, 21747, 21748, 21750, 21752, 21756, 21761, 21791, 21792, 21793, 21794, 21855, 21856, 22054, 22114, 22228, 22232, 22233, 22235, 22240, 22246, 22269, 22277, 22279, 22280, 22340, 22389, 22422, 22430, 22449, 22457, 22463, 21252, 229,, 15809, 15896, 15925, 15933, 16092, 17451, 17470, 18156, 18157, 18158, 18479, 19198, 19577, 19750, 20462, 20675, 21002, 21144, 21149, 21150, 21281, 21689, 21812, 21933, 21934, 22131, 22161, 22207, 22335, 22418, 22521, 23088, 23113, 23116, 23230, 23702, 23703, 23537, 18163, 18164, 23121, 23124, 23189, 23190, 23241, 23250, 23252, 23307, 23340, 23342, 23344, 23345, 23346, 23348, 23358, 23387, 23405, 23429, 23448, 23472, 23499, 23503, 23508, 23509, 23709, 23894, 24536, 23705, 23716, 23877, 23878, 23879, 23880, 24187, 24325, 24504, 24551, 25173, 24675, 25063, 24666, 24809, 25172, 25640, 25703, 25848, 25879, 25953, 25964, 25965, 25966, 26057, 26230, 26262, 26346, 27890, 26834, 26775, 26774, 27305, 29589, 29588, 29218, 32637, 25762, 23041, 23557, 23771, 23806, 23996, 24012, 24112, 24114, 24221, 24260, 24280, 24326, 24471, 24721, 24817, 24820, 24913, 24973, 25229, 25230, 25231, 25232, 25252, 25254, 25255, 25269, 25293, 25349, 25384, 25423, 25525, 25614, 26286, 26365, 26523, 26668, 26777, 26778, 26832, 27123, 27171, 27241, 27257, 27268, 27282, 27303, 27307, 27308, 27309, 27327, 27369, 27375, 27384, 27392, 27403, 27404, 27454, 27583, 27625, 27669, 27671, 27714, 27757, 27832, 27847, 27868, 27881, 27894, 27908, 27942, 27999, 28055, 28061, 28094, 28130, 28144, 28150, 28174, 28183, 28235, 28237, 28260, 28265, 28301, 28312, 28319, 28366, 28509, 28525, 28542, 28543, 28544, 28567, 28614, 28616, 28655, 28656, 28719, 28724, 28781, 28823, 28833, 28852, 28853, 28884, 28886, 28887, 28891, 28894, 28904, 28947, 29011, 29048, 29165, 29192, 29265, 29276, 29326, 29365, 29399, 29416, 29425, 29460, 29522, 29580, 29581, 29598, 29619, 29682, 29685, 29708, 29742, 29748, 29754, 29790, 29791, 29849, 30054, 30078, 30090, 30101, 30121, 30172, 30173, 30181, 30288, 30332, 30334, 30337, 30413, 30454, 30465, 30492, 30494, 30560, 30563, 30639, 30648, 30650, 30684, 30702, 30741, 30828, 30857, 30878, 30896, 30897, 30898, 30899, 30948, 31013, 31103, 31118, 31138, 31204, 31253, 31264, 31282, 31324, 31406, 31407, 31408, 31409, 31415, 31517, 31526, 31553, 31576, 31577, 31653, 31684, 31827, 31831, 31838, 31840, 31856, 31869, 31880, 32152, 32154, 32155, 32159, 32179, 32182, 32183, 32200, 32204, 32214, 32215, 32217, 32221, 32305, 32316, 32431, 32448, 32473, 32512, 32513, 32525, 32528, 32531, 32532, 32567, 32574, 32594, 32627, 32629, 32634, 32635, 32636, 32647, 32654, 32655, 32656, 32661, 32694, 32866, 32879, 32892, 32984, 33059, 33060, 33061, 33062, 33063, 33064, 33067, 33080, 33086, 33104, 33105, 33109, 33138, 33140, 33141, 33146, 33167, 33184, 33185, 33233, 33337, 33377, 33378, 33380, 33406, 33425, 33426, 33441, 33500, 33503, 33516, 33531, 33575, 33576, 33660, 33661, 33715, 33742, 33783, 33784, 33790, 33791, 33792, 33793, 33794, 33795, 33796, 33798, 33799, 33800, 33809, 33835, 33842, 33843, 33863, 33870, 33881, 33882, 33991, 34000, 34050, 34071, 34096, 34099, 34100, 34107, 34120, 34125, 34128, 34144, 34145, 34211, 34223, 34224, 34230, 34250, 34286, 34307, 34313, 36557, 36559, 35311, 35614, 34704, 34720, 35014, 35820, 35821, 36093, 34944, 34929, 34935, 35336, 35819, 36356, 36355, 35335, 34778, 34777, 34862, 35083, 35080, 35084, 35079, 35104, 35105, 34819, 35644, 36558, 36731, 36794, 36983, 37227, 37488, 37519, 37528, 37547, 37593, 37947, 37948, 38028, 36659, 37006, 37013, 37690, 37782, 37824, 37930, 37986, 38107, 38159, 38234, 38308, 38309, 38317, 38422, 38458, 38879, 38163, 37880, 36212, 36530, 36643, 36710, 37918, 37950, 38068, 38186, 35493, 37074, 37118, 36215, 35110, 35107, 34827, 36605, 37882, 35910, 34893, 35109, 35895, 34891, 35108, 35588, 37192, 37191, 37799, 38757, 38429, 38548, 38556, 37186, 38223, 38589, 40246, 39794, 40083, 40091, 40100, 37530, 37535, 37732, 37787, 37788, 37932, 38067, 38158, 38162, 38528, 39125, 39190, 39253, 39264, 39421, 39466, 39623, 39624, 39711, 39817, 39820, 39842, 40006, 40141, 40231, 40425, 40426, 40468, 40469, 40478, 40492);