aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sql/updates/world/cata_classic/2024_11_03_00_world.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/updates/world/cata_classic/2024_11_03_00_world.sql b/sql/updates/world/cata_classic/2024_11_03_00_world.sql
new file mode 100644
index 00000000000..4620dd26e3f
--- /dev/null
+++ b/sql/updates/world/cata_classic/2024_11_03_00_world.sql
@@ -0,0 +1 @@
+UPDATE `creature_template` SET `npcflag`= `npcflag` | 0x20 WHERE `entry` IN (198, 328, 331, 354, 373, 375, 376, 377, 459, 460, 461, 542, 837, 895, 897, 906, 911, 912, 913, 914, 915, 916, 917, 918, 925, 926, 927, 928, 944, 985, 986, 987, 988, 1226, 1228, 1229, 1231, 1232, 1234, 1403, 1404, 1406, 1408, 1409, 1411, 1901, 2119, 2122, 2123, 2124, 2126, 2127, 2128, 2129, 2130, 2131, 2217, 2218, 2219, 2485, 2489, 2492, 2942, 3030, 3031, 3032, 3033, 3034, 3036, 3038, 3039, 3040, 3041, 3042, 3043, 3044, 3045, 3046, 3047, 3048, 3049, 3059, 3060, 3061, 3062, 3063, 3064, 3065, 3066, 3153, 3154, 3155, 3156, 3157, 3169, 3170, 3171, 3172, 3173, 3324, 3325, 3326, 3327, 3328, 3344, 3352, 3353, 3354, 3401, 3403, 3406, 3407, 3408, 3593, 3594, 3595, 3596, 3597, 3598, 3599, 3600, 3601, 3602, 3706, 3707, 3963, 4087, 4089, 4090, 4091, 4092, 4138, 4146, 4163, 4165, 4205, 4214, 4215, 4217, 4218, 4219, 4563, 4564, 4565, 4566, 4567, 4568, 4582, 4583, 4584, 4593, 4594, 4595, 4606, 4607, 4608, 4892, 4985, 4986, 4987, 4988, 4989, 4990, 4991, 4992, 4993, 5039, 5113, 5114, 5115, 5116, 5117, 5141, 5142, 5143, 5144, 5145, 5146, 5147, 5148, 5149, 5165, 5166, 5167, 5171, 5172, 5173, 5479, 5480, 5484, 5489, 5491, 5492, 5495, 5496, 5497, 5498, 5501, 5504, 5505, 5506, 5515, 5516, 5517, 5612, 5880, 5882, 5883, 5884, 5885, 5957, 5958, 5959, 5960, 5961, 5962, 5963, 5964, 5965, 5966, 5967, 5968, 5969, 5970, 5971, 5972, 5973, 5994, 6014, 6018, 7311, 7312, 7315, 7488, 8140, 8141, 8142, 8308, 8664, 9465, 10291, 10930, 11397, 11401, 11406, 12042, 13283, 13417, 13476, 15279, 15280, 15283, 15284, 15285, 15513, 16266, 16269, 16270, 16275, 16276, 16279, 16499, 16500, 16501, 16502, 16503, 16646, 16647, 16648, 16651, 16652, 16653, 16654, 16655, 16658, 16659, 16660, 16661, 16672, 16673, 16674, 16679, 16680, 16681, 16684, 16685, 16686, 16721, 16738, 16749, 16755, 16756, 16759, 16761, 16770, 16771, 17089, 17110, 17120, 17121, 17122, 17204, 17212, 17219, 17480, 17481, 17482, 17483, 17504, 17505, 17509, 17510, 17511, 17513, 17514, 17519, 17520, 17844, 18270, 19247, 19340, 20406, 20407, 20791, 23103, 23127, 23128, 23534, 23566, 26324, 26325, 26326, 26327, 26328, 26329, 26330, 26331, 26332, 27703, 27704, 27705, 27916, 28471, 28472, 28474, 28956, 28958, 29156, 29194, 29195, 29196, 31084, 32712, 34600, 34673, 34689, 34692, 34693, 34695, 34696, 34697, 35281, 35758, 35778, 35780, 35786, 35805, 35806, 35807, 35839, 35869, 35870, 35871, 35872, 35873, 35874, 36518, 36519, 36520, 36521, 36523, 36524, 36525, 36628, 36629, 36630, 36631, 36632, 36651, 36652, 36664, 36699, 36700, 36702, 36703, 36704, 36705, 36857, 37115, 37121, 37724, 37737, 38037, 38122, 38242, 38243, 38244, 38245, 38246, 38247, 38465, 38466, 38467, 38513, 38514, 38515, 38516, 38517, 38518, 38793, 38794, 38795, 38796, 38797, 38798, 38799, 38911, 39100, 39116, 39206, 39214, 42323, 42324, 42331, 42366, 42618, 43001, 43004, 43005, 43006, 43008, 43009, 43010, 43011, 43012, 43013, 43015, 43277, 43278, 43455, 43464, 43795, 43796, 43870, 43881, 43883, 43892, 43909, 44128, 44129, 44247, 44249, 44250, 44380, 44393, 44394, 44395, 44396, 44455, 44459, 44461, 44464, 44465, 44468, 44469, 44723, 44725, 44726, 44735, 44740, 44743, 44978, 45019, 45023, 45029, 45095, 45137, 45138, 45139, 45306, 45337, 45339, 45347, 45709, 45713, 45714, 45717, 45718, 45720, 46667, 46983, 47233, 47246, 47247, 47248, 47253, 47767, 47788, 48612, 48613, 48614, 48615, 48616, 48618, 49713, 49715, 49716, 49718, 49720, 49730, 49736, 49741, 49745, 49749, 49760, 49769, 49781, 49782, 49784, 49786, 49791, 49793, 49806, 49808, 49870, 49894, 49895, 49896, 49900, 49901, 49902, 49909, 49915, 49916, 49923, 49927, 49939, 49940, 49942, 49945, 49946, 49949, 49950, 49952, 49954, 49955, 49957, 49958, 49959, 49961, 49962, 49963, 49964, 49966, 49968, 49997, 49998, 50001, 50002, 50004, 50006, 50007, 50010, 50011, 50012, 50013, 50015, 50016, 50017, 50018, 50019, 50020, 50021, 50022, 50023, 50024, 50025, 50027, 50028, 50029, 50031, 50032, 50033, 50034, 50035, 50127, 50128, 50130, 50136, 50137, 50142, 50144, 50147, 50148, 50149, 50150, 50151, 50152, 50153, 50155, 50156, 50157, 50158, 50160, 50163, 50166, 50171, 50174, 50492, 50497, 50498, 50499, 50500, 50501, 50502, 50505, 50506, 50507, 50609, 50690, 50714, 50715, 50716, 50717, 50720, 50723, 50729, 50732, 51637, 51638, 51639, 51640, 51998, 52290, 52292, 52299, 52317, 52318, 52319, 52335, 53403, 53404, 53405);