diff options
| -rw-r--r-- | sql/updates/world/cata_classic/2025_01_19_00_world.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/cata_classic/2025_01_19_00_world.sql b/sql/updates/world/cata_classic/2025_01_19_00_world.sql new file mode 100644 index 00000000000..676362a55bd --- /dev/null +++ b/sql/updates/world/cata_classic/2025_01_19_00_world.sql @@ -0,0 +1,9 @@ +DELETE FROM `phase_area` WHERE `AreaId` IN (5834, 6052, 6066, 6292, 6384, 6386, 6719, 6796, 7004, 7025, 7037, 7039, 7040, 7041, 7078, 7085, 7129, 7334, 7338, 7340, 7342, 7344, 7345, 7346, 7348, 7349, 7351, 7352, 7355, 7356, 7357, 7358, 7359, 7360, 7361, 7362, 7364, 7366, 7502, 7554, 7571, 7599, 7633, 7705, 7741, 7742, 7765, 7813, 8670, 8717, 8718, 9171, 9334, 9358, 9359, 9365, 9796, 9802, 10424, 10452, 10453, 10523, 10527, 10528, 10529, 10530, 10565, 10588, 10639, 11013, 11473, 12825, 12917, 13307, 13377, 13499, 13646, 13852, 13862, 13921); +DELETE FROM `world_state` WHERE `ID` IN (6306, 6319, 6321, 6330, 6331, 6334, 6335, 6375, 6378, 6400, 6428, 6431, 6436, 6444, 6450, 6463, 6465, 6466, 6470, 6473, 6521, 6525, 6529, 6542, 6558, 6579, 6580, 6583, 6585, 6586, 6589, 6592, 6594, 6625, 6649, 6658, 6677, 6700, 6729, 6735, 6738, 6741, 6747, 6786, 6944, 7329, 7502, 7507, 7543, 7563, 7565, 7570, 7571, 7575, 7577, 7582, 7603, 7605, 7671, 8109, 8202, 8225, 8236, 8253, 8258, 8260, 8268, 8272, 8276, 8285, 8299, 8356, 8415, 8524, 8529, 8563, 8565, 8566, 8586, 8591, 8592, 8595, 8597, 8614, 8615, 8620, 8622, 8623, 8624, 8625, 8626, 8653, 8655, 8661, 8665, 8667, 8669, 8678, 8691, 8699, 8703, 8705, 8720, 8724, 8731, 8733, 8738, 8746, 8755, 8761, 8770, 8771, 8772, 8773, 8799, 8800, 8805, 8806, 8808, 8809, 8831, 8843, 8848, 8851, 8852, 8853, 8863, 8866, 8874, 8884, 8903, 8923, 8930, 8948, 9020, 9038, 9060, 9175, 9219, 9233, 9235, 9297, 9298, 9341, 9354, 9356, 9373, 9808, 9809, 10004, 10010, 10039, 10041, 10043, 10048, 10051, 10060, 10092, 10094, 10097, 10099, 10101, 10141, 10177, 10179, 10208, 10335, 10365, 10367, 10369, 10371, 10381, 10382, 10384, 10386, 10388, 10390, 10392, 10397, 10398, 10401, 10479, 10482, 10484, 10562, 10563, 10564, 10565, 10566, 10580, 10582, 10584, 10586, 10592, 10593, 10594, 10640, 10668, 10707, 10713, 10718, 10721, 10728, 10730, 10737, 10742, 10758, 10762, 10767, 10771, 10906, 10922, 10953, 11037, 11083, 11089, 11091, 11093, 11101, 11377, 11442, 11476, 11498, 11502, 11887, 12051, 12053, 12150, 12521, 12534, 12542, 12546, 12548, 12554, 12556, 12560, 12566, 12597, 12613, 12670, 12773, 12815, 12861, 12863, 12865, 12967, 12996, 13019, 13026, 13121, 13122, 13123, 13131, 13139, 13401, 13507, 13517, 13534, 13536, 13543, 13547, 13551, 13553, 13560, 13565, 13571, 13576, 13593, 13788, 13812, 13814, 13816, 13818, 14017, 14137, 14139, 14141, 14143, 14403, 14405, 14406, 14408, 14419, 14421, 14423, 14425, 14432, 14435, 14437, 14439, 14441, 14522, 14549, 14553, 14554, 14557, 14560, 14563, 14597, 14694, 14696, 14715, 14718, 14721, 14724, 14736, 14861, 14862, 14864, 14866, 14892, 14894, 14895, 14931, 15039, 15059, 15062, 15168, 15170, 15205, 15480, 15481, 16217, 16219, 16221, 16223, 16310, 16316, 16433, 16475, 16542, 16560, 16562, 16563, 16567, 16568, 16569, 17042, 17043, 17142, 17145, 17161, 17163, 17182, 17303, 17305, 17306, 17322, 17323, 17324, 17325, 17326, 17327, 17328, 17329, 17330, 17331, 17342, 17355, 17356, 17357, 17358, 17359, 17360, 17361, 17362, 17363, 17364, 17365, 17366, 17367, 17368, 17371, 17377, 17399, 17451, 17680, 17712, 17713, 18015, 18046, 18047, 18048, 18064, 18066, 18071, 18073, 18083, 18085, 18116, 18117, 18123, 18130, 18147, 18179, 18211, 18224, 18606, 18607, 18608, 18609, 18627, 18628, 18629, 18630, 18652, 18654, 18656, 18699, 18704, 18705, 18706, 18707, 18708, 18709, 18710, 18773, 18775, 18778, 18780, 18781, 18783, 18785, 18788, 18789, 18790, 18794, 18802, 18805, 18808, 18810, 18812, 18815, 18817, 18819, 18824, 19029, 19047, 19056, 19146, 19158, 19208, 19279, 19342, 19388, 19396, 19410, 19415, 19735, 20084, 20228, 20232, 20242, 20256, 20260, 20264, 20268, 20275, 20346, 20347, 20348, 20353, 20360, 20362, 20366, 20439, 20449, 20451, 20456, 20538, 20545, 20546, 20547, 20549, 20550, 20551, 20552, 20554, 20555, 20556, 20557, 20558, 20659, 20700, 20838, 20839, 21151, 21176, 21182, 21213, 21218, 21220, 21225, 21229, 21242, 21268, 21302, 21322, 21338, 21427, 22869, 22980, 23730, 23747, 23970, 24880, 24882, 24906, 25146, 25219, 25259, 25395, 25413, 25456, 25457, 25468, 26001); +DELETE FROM `npc_vendor` WHERE `entry` IN (26383, 26384, 54943, 62822, 63014, 63061, 63067, 63070, 63073, 63075, 63077, 63080, 63083, 63086, 63596, 63626, 64922, 68363, 68364, 68402, 68792, 68794, 68989, 68993, 69322, 69323, 69333, 69334, 69974, 69975, 69977, 69978, 70752, 71304, 73151, 73190, 73701, 73913, 73914, 76117, 77378, 78564, 78568, 80159, 80998, 81314, 81346, 81347, 81348, 82386, 82776, 84246, 85484, 85849, 85932, 85946, 85950, 85955, 86175, 86176, 86178, 86387, 86389, 86390, 86391, 87049, 87365, 87501, 88155, 88230, 88235, 89257, 89640, 89939, 90086, 90866, 91079, 91321, 91457, 92000, 92184, 92245, 92489, 92501, 92932, 92936, 93188, 93225, 93526, 93539, 93543, 93545, 93906, 93907, 93945, 94099, 94100, 95057, 95118, 95791, 96507, 96780, 96791, 96792, 96793, 96794, 96795, 96975, 96990, 97001, 97005, 97213, 97342, 97359, 97360, 97361, 97364, 97366, 97786, 97852, 97854, 97856, 97857, 97858, 97866, 97867, 97869, 97874, 97876, 98109, 98112, 99205, 99206, 99207, 99574, 99903, 99905, 99912, 100196, 100437, 101759, 101846, 102193, 103796, 103797, 105637, 106902, 106904, 106940, 107376, 107599, 107610, 107619, 107760, 108138, 108533, 108534, 108537, 108553, 108554, 108555, 108556, 108559, 108560, 108586, 108792, 108825, 109372, 109377, 109383, 109685, 109688, 109912, 110531, 110974, 112629, 112634, 113404, 115805, 119390, 121542, 121543, 123395, 123633, 123635, 123639, 123675, 123735, 124289, 124295, 126075, 130368, 130399, 132224, 132228, 132323, 132705, 133341, 133536, 135153, 135446, 135808, 136041, 136059, 136061, 136063, 136071, 136091, 139567, 142068, 142094, 142095, 142167, 142169, 142176, 142188, 142191, 143109, 143114, 143244, 143246, 144129, 146626, 146633, 148228, 149540, 149718, 149721, 152775, 152780, 152829, 152849, 152871, 152941, 152948, 153008, 153012, 153030, 153116, 153146, 153166, 153167, 153574, 154003, 154980, 155131, 155133, 156663, 156688, 156689, 156690, 156692, 156694, 156696, 156732, 156733, 156769, 156777, 156800, 164736, 164947, 167213, 167429, 167881, 168353, 169524, 173369, 173370, 175050, 175051, 177829, 179896, 181681, 185563, 187412, 188142, 188377, 188386, 188391, 191161, 193015, 194470, 201312, 204926, 205350, 211805, 211810, 211812, 211864, 211873, 211887, 212587, 212886, 213093, 213094, 213096); +DELETE FROM `creature_template_addon` WHERE `entry` IN (56622, 56730, 57164, 57205, 57431, 57621, 57625, 57626, 57709, 57710, 57748, 57752, 57753, 57769, 57779, 57797, 58342, 58632, 58633, 58662, 58664, 58674, 58676, 58701, 58722, 58727, 58783, 58823, 58875, 58876, 59080, 59099, 59113, 59150, 59153, 59155, 59175, 59184, 59191, 59198, 59200, 59209, 59223, 59241, 59299, 59302, 59303, 59304, 59309, 59359, 59360, 59368, 59373, 59467, 59480, 59481, 59503, 59613, 59626, 59642, 59706, 59722, 59746, 59789, 59929, 59980, 59982, 60033, 60040, 60197, 60411, 60761, 60931, 61071, 61080, 61142, 61158, 61255, 61326, 61328, 61367, 61369, 61411, 61439, 61696, 61809, 62019, 62020, 62106, 62114, 62115, 62117, 62118, 62119, 62120, 62121, 62177, 62178, 62181, 62182, 62184, 62189, 62193, 62194, 62195, 62196, 62197, 62198, 62199, 62200, 62364, 62373, 62419, 62445, 62450, 62731, 62821, 62822, 62884, 62885, 62886, 62887, 62888, 62904, 62913, 62915, 62916, 62921, 62922, 62924, 62925, 62927, 62982, 63014, 63015, 63061, 63063, 63067, 63068, 63069, 63070, 63073, 63074, 63075, 63077, 63078, 63079, 63080, 63083, 63084, 63085, 63086, 63238, 63239, 63241, 63242, 63296, 63309, 63332, 63596, 63607, 63626, 64105, 64367, 64446, 64562, 64563, 64929, 65008, 65043, 65048, 65051, 65055, 65058, 65059, 65060, 65061, 65062, 65063, 65064, 65065, 65066, 65068, 65069, 65070, 65071, 65072, 65074, 65075, 65076, 65078, 65089, 65094, 65097, 65146, 65147, 65223, 65248, 65379, 65467, 65468, 65469, 65470, 65471, 65546, 66022, 66091, 66305, 66352, 66364, 66372, 66437, 66802, 66804, 66805, 66806, 66807, 66808, 66815, 66819, 67260, 67267, 67319, 67329, 67370, 67382, 67383, 67384, 67559, 68231, 68232, 68233, 68238, 68239, 68323, 68363, 68364, 68402, 68403, 68404, 68405, 68406, 68407, 68408, 68426, 68434, 68442, 68491, 68492, 68526, 68535, 68537, 68539, 68540, 68541, 68553, 68764, 68765, 68767, 68768, 68792, 68794, 68796, 68797, 68798, 68799, 68801, 68803, 68807, 68808, 68810, 68811, 68868, 68869, 68952, 68963, 68979, 68986, 68990, 68991, 68992, 68993, 68994, 69333, 69334, 69822, 69823, 69974, 69975, 69977, 69978, 70165, 70296, 70301, 70354, 70713, 70714, 70716, 70718, 70719, 70720, 70721, 70722, 70723, 70726, 70733, 70740, 70743, 70751, 70752, 70790, 70906, 70907, 70908, 71047, 71051, 71100, 71134, 71304, 71467, 71982, 72254, 72559, 72623, 72628, 72647, 72674, 72677, 72785, 72793, 72939, 73101, 73151, 73190, 73324, 73546, 73548, 73595, 73637, 73639, 73642, 73645, 73646, 73678, 73805, 73857, 73913, 73914, 74056, 74146, 74228, 74333, 74388, 74630, 75685, 76380, 77209, 77370, 77376, 77488, 77518, 77617, 78333, 78467, 78564, 79219, 79228, 79242, 79243, 79274, 79285, 79394, 79422, 79567, 79603, 79796, 79891, 79893, 79894, 79953, 80026, 80159, 80769, 80793, 80800, 80801, 80818, 80998, 81152, 81214, 81346, 81347, 81348, 81406, 81492, 81636, 81695, 81696, 81714, 81824, 81829, 81895, 81907, 81926, 82037, 82165, 82166, 82167, 82175, 82270, 82308, 82378, 82386, 82401, 82417, 82425, 82647, 82776, 83491, 83878, 83882, 83890, 84246, 84341, 84372, 84455, 84516, 84776, 85312, 85484, 85519, 85522, 85523, 85525, 85546, 85773, 86470, 86832, 87501, 88067, 88070, 88206, 88543, 88701, 88702, 88703, 88704, 88705, 88706, 89174, 89175, 89639, 89713, 89715, 89734, 89736, 89830, 89978, 90148, 90230, 90241, 90382, 91457, 91911, 92870, 92879, 93094, 93105, 93127, 93296, 93307, 93337, 93475, 93487, 93492, 93628, 93716, 93759, 93819, 93823, 94580, 94651, 94704, 94705, 94960, 94968, 95049, 95226, 95674, 95675, 95676, 95832, 95833, 95834, 95842, 95843, 95893, 96159, 96401, 96420, 96502, 96507, 96535, 96536, 96538, 96545, 96568, 96572, 96574, 96608, 96609, 96637, 96640, 96648, 96655, 96664, 96677, 96679, 96754, 96756, 96765, 97068, 97081, 97083, 97084, 97087, 97097, 97142, 97163, 97182, 97185, 97197, 97200, 97202, 97208, 97219, 97365, 97594, 97603, 97604, 97712, 97795, 98291, 98482, 98483, 98484, 98486, 98497, 98611, 98618, 98621, 98622, 98905, 98907, 98919, 98973, 99160, 99188, 99804, 99828, 99914, 99915, 101013, 101064, 101436, 101459, 101637, 101638, 101639, 101640, 101697, 101704, 101712, 101748, 101943, 101950, 101951, 101976, 101995, 102104, 102108, 102246, 102267, 102269, 102279, 102281, 102282, 102325, 102326, 102327, 102375, 102423, 102431, 102671, 102742, 102769, 102830, 103115, 103133, 103135, 103421, 103605, 103614, 103617, 103801, 103810, 104906, 105311, 105312, 105329, 105794, 105802, 105804, 105814, 105821, 105965, 106250, 106262, 106263, 106303, 107494, 108138, 108142, 108204, 108205, 108525, 108588, 108691, 108896, 108950, 109412, 109685, 109688, 109734, 109795, 109825, 109854, 109860, 110441, 111109, 111374, 112958, 113270, 113813, 113924, 113927, 114246, 114263, 114275, 114278, 114279, 114323, 114341, 114343, 114344, 114360, 114361, 114532, 114534, 114537, 114538, 114539, 114547, 114548, 114590, 114614, 114639, 114640, 114712, 114784, 114785, 114786, 114787, 114788, 114789, 114791, 114832, 114840, 114922, 114932, 116285, 116404, 117783, 117784, 118524, 118889, 120590, 120652, 121235, 121541, 122450, 122773, 122778, 122963, 122965, 122967, 122968, 122969, 122971, 122972, 122973, 122986, 123395, 123639, 123745, 123746, 124720, 125216, 125524, 125843, 125977, 126022, 126030, 126075, 126389, 126390, 127315, 127352, 127799, 128156, 128434, 128435, 128455, 128956, 129255, 129552, 129553, 129985, 130368, 130399, 130560, 130681, 130907, 130909, 130911, 130986, 130993, 131318, 131383, 131402, 131436, 131817, 132051, 132137, 132210, 132214, 132215, 132224, 132225, 132262, 132266, 132323, 132325, 132328, 132334, 132358, 132398, 133007, 133271, 133362, 133663, 133685, 133835, 133836, 133852, 133870, 133912, 134284, 134419, 134701, 135808, 136059, 136061, 136071, 138187, 138281, 138740, 139088, 139375, 141274, 141504, 141540, 141554, 141678, 141684, 141900, 141903, 142094, 142167, 142169, 142188, 142612, 142656, 142816, 143248, 143261, 143263, 143567, 144118, 144119, 144120, 144122, 144123, 144124, 144125, 144126, 144127, 144128, 144129, 144130, 144132, 144133, 144135, 144147, 144148, 144152, 144153, 144154, 144156, 144159, 144163, 144306, 145714, 146626, 146633, 147662, 147695, 147714, 147741, 147785, 148124, 148242, 148250, 148263, 148265, 148768, 148795, 148796, 149099, 149131, 149258, 149626, 149719, 150414, 150418, 150426, 150459, 150513, 150543, 151091, 151187, 151256, 152643, 152775, 152780, 152829, 152849, 152871, 152941, 152948, 153008, 153009, 153012, 153014, 153016, 153029, 153030, 153054, 153070, 153071, 153072, 153073, 153074, 153075, 153082, 153098, 153101, 153102, 153104, 153105, 153116, 153146, 153159, 153160, 153161, 153162, 153166, 153167, 153198, 153211, 153227, 153242, 153266, 153292, 153574, 153581, 153582, 153583, 153931, 154003, 154012, 154013, 154078, 154086, 154103, 154268, 154299, 154300, 154301, 154313, 154327, 154463, 154477, 154508, 154605, 154630, 154631, 154632, 154729, 154730, 154745, 154765, 154867, 154980, 155011, 155034, 155131, 155133, 155134, 155135, 155194, 155269, 155280, 155303, 155320, 155345, 155602, 155739, 156345, 156398, 156479, 156501, 156532, 156607, 156662, 156698, 156814, 156821, 156825, 156828, 156891, 156900, 157049, 157091, 157093, 157114, 157300, 157328, 157496, 157498, 157997, 158145, 158436, 158440, 158456, 158509, 158510, 158558, 158559, 158560, 158561, 158659, 158753, 158803, 159468, 159470, 159471, 159485, 159486, 159487, 159523, 159524, 159528, 159529, 159530, 159543, 159545, 159549, 159550, 159551, 159552, 159558, 159559, 159567, 159568, 159569, 159571, 159572, 159587, 159704); +UPDATE `gameobject_addon` SET `WorldEffectID`= 0 WHERE `WorldEffectID`= 569; +DELETE FROM `game_tele` WHERE `id` IN (1001, 1524, 1525, 1526, 1527, 1528, 1529, 1530, 1531, 1532, 1533, 1534, 1535, 1536, 1537, 1538, 1539, 1540, 1541, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1549, 1550, 1551, 1552, 1553, 1554, 1555, 1556, 1557, 1558, 1559, 1560, 1561, 1562, 1563, 1564, 1565, 1566, 1567, 1568, 1569, 1570, 1571, 1572, 1573, 1574, 1575, 1576, 1577, 1578, 1579, 1580, 1581, 1582, 1583, 1584, 1585, 1586, 1587, 1588, 1589, 1590, 1591, 1592, 1594, 1595, 1596, 1597, 1598, 1599, 1600, 1601, 1602, 1603, 1604, 1605, 1606, 1607, 1608, 1609, 1610, 1611, 1612, 1613, 1614, 1615, 1616, 1617, 1618, 1619, 1620, 1621, 1622, 1623, 1624, 1625, 1626, 1627, 1628, 1629, 1630, 1631, 1632, 1633, 1634, 1635, 1636, 1637, 1638, 1639, 1640, 1641, 1642, 1643, 1644, 1645, 1646, 1647, 1648, 1649, 1650, 1651, 1652, 1653, 1654, 1655, 1656, 1657, 1658, 1659, 1660, 1661, 1662, 1663, 1664, 1665, 1666, 1667, 1668, 1669, 1670, 1671, 1672, 1673, 1674, 1675, 1676, 1677, 1678, 1683, 1684, 1685, 1686, 1687, 1688, 1689, 1690, 1691, 1692, 1693, 1694, 1695, 1696, 1697, 1698, 1699, 1700, 1701, 1702, 1703, 1704, 1705, 1706, 1707, 1708, 1709, 1710, 1711, 1712, 1713, 1714, 1715, 1716, 1717, 1718, 1719, 1720, 1721, 1722, 1723, 1724, 1725, 1726, 1727, 1728, 1729, 1730, 1731, 1732, 1733, 1734, 1735, 1736, 1737, 1738, 1739, 1740, 1741, 1742, 1743, 1744, 1745, 1746, 1747, 1748, 1749, 1750, 1751, 1752, 1753, 1754, 1755, 1756, 1757, 1824, 1825, 1826, 1827, 1828, 1829, 1830, 1831, 1832, 1833, 1834, 1835, 1836, 1837, 1838, 1839, 1840, 1841, 1842, 1843, 1844, 1845, 1846, 1847, 1848, 1849, 1850, 1851, 1852, 1853, 1854, 1855, 1856, 1857, 1858, 1859, 1860, 1861, 1862, 1863, 1864, 1865, 1866, 1867, 1868, 1869, 1870, 1871, 1872, 1873, 1874, 1875, 1876, 1877, 1878, 1879, 1880, 1881, 1882, 1883, 1884, 1885, 1886, 1887, 1888, 1889, 1890, 1891, 1892, 1893, 1894, 1895, 1896, 1897, 1898, 1899, 1900, 1901, 1902, 1903, 1904, 1905, 1906, 1907, 1908, 1909, 1910, 1911, 1912, 1913, 1914, 1915, 1916, 1917, 1918, 1919, 1920, 1921, 1922, 1923, 1924, 1925, 1926, 1927, 1928, 1929, 1930, 1931, 1932, 1933, 1934, 1935, 1936, 1937, 1938, 1939, 1940, 1941, 1942, 1943, 1944, 1945, 1946, 1947, 1948, 1949, 1950, 1951, 1952, 1953, 1954, 1955, 1956, 1957, 1958, 1959, 1960, 1961, 1962, 1963, 1964, 1965, 1966, 1967, 1968, 1969, 1970, 1971, 1972, 1973, 1974, 1975, 1976, 1977, 1978, 1979, 1980, 1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989, 1990, 1991, 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024, 2025, 2026, 2027, 2028, 2029, 2030, 2031, 2032, 2033, 2034, 2035, 2036, 2037, 2038, 2039, 2040, 2041, 2042, 2043, 2044, 2045, 2046, 2048, 2049, 2050, 2051, 2052, 2053, 2054, 2055, 2056, 2057, 2058, 2059, 2060, 2061, 2062, 2063, 2064, 2065, 2066, 2067, 2068, 2069, 2070, 2071, 2072, 2073, 2074, 2075, 2076, 2077, 2078, 2079, 2080, 2081, 2082, 2083, 2084, 2085, 2086, 2087, 2088, 2089, 2090, 2091, 2092, 2093, 2094, 2095, 2096, 2097, 2098, 2099, 2100, 2101, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2109, 2110, 2111, 2112, 2113, 2114, 2115, 2116, 2117, 2118, 2119, 2120, 2121, 2122, 2123, 2124, 2125, 2126, 2127, 2128, 2129, 2130, 2131, 2132, 2133, 2134, 2135, 2136, 2137, 2138, 2139, 2140, 2141, 2142, 2143, 2144, 2145, 2146, 2147, 2148, 2149, 2150, 2151, 2152, 2153, 2154, 2155, 2156, 2157, 2158, 2159, 2160, 2161, 2162, 2163, 2164, 2165, 2166); +-- Prune disallowed unit flags +UPDATE `creature_template` SET `unit_flags`= `unit_flags` & 0x2000340; +UPDATE `creature_template` SET `unit_flags2`= `unit_flags2` & 0x4034823; |