diff options
| -rw-r--r-- | sql/updates/world/master/2023_01_10_00_world.sql | 140 |
1 files changed, 140 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_01_10_00_world.sql b/sql/updates/world/master/2023_01_10_00_world.sql new file mode 100644 index 00000000000..b444a979104 --- /dev/null +++ b/sql/updates/world/master/2023_01_10_00_world.sql @@ -0,0 +1,140 @@ +-- SpellGroup does not exist (Issue ref. 14931) +DELETE FROM `spell_group_stack_rules` WHERE `group_id`=2500; + +-- Commands +DELETE FROM `command` WHERE `name` IN ('go ticket', 'go bugticket', 'go complaintticket', 'go suggestionticket'); +INSERT INTO `command` (`name`, `help`) VALUES +('go bugticket', 'Syntax: .go bugticket <ticketId>\nTeleport yourself to the location at which the specified bug ticket was created.'), +('go complaintticket', 'Syntax: .go complaintticket <ticketId>\nTeleport yourself to the location at which the specified complaint ticket was created.'), +('go suggestionticket', 'Syntax: .go suggestionticket <ticketId>\nTeleport yourself to the location at which the specified suggestion ticket was created.'); + +-- npc_text +DELETE FROM `npc_text` WHERE `ID` IN (560007, 560008, 580004, 921061); + +UPDATE `npc_text` SET `BroadcastTextID1`=0, `BroadcastTextID2`=0, `BroadcastTextID3`=0, `BroadcastTextID4`=0, `BroadcastTextID5`=0, `BroadcastTextID6`=0, `BroadcastTextID7`=0 WHERE `ID`=16777215; +UPDATE `npc_text` SET `BroadcastTextID0`=53140 WHERE `ID`=2; +UPDATE `npc_text` SET `Probability0`=1 WHERE `ID` IN (1, 2, 68, 197, 328, 384, 447); + +-- gossip_menu +DELETE FROM `gossip_menu` WHERE `MenuID` IN (31111); +DELETE FROM `gossip_menu` WHERE `TextID` IN (560007, 560008, 580004); + +-- creature_template +UPDATE `creature_template` SET `AIName`='' WHERE `entry` IN (9637, 89713, 97229, 100099); +UPDATE `creature_template` SET `ScriptName`='' WHERE `ScriptName` IN ('npc_stable_master', 'npc_frenzied_bloodseeker_bat'); + +UPDATE `creature_template_addon` SET `auras`=NULL WHERE `entry` IN (397, 519, 599, 636, 710, 818, 881, 951, 1057, 1165, 1399, 2108, 2319, 2567, 2573, 2591, 2743, 3178, 3804, 3892, 4642, 4658, 4719, 4844, 5328, 5343, 5362, 5461, 5498, 5786, 7035, 7379, 7439, 7442, 7726, 8764, 8924, 9451, 10826, 11562, 11577, 11744, 11858, 13096, 13116, 13117, 13546, 15613, 30837, 34695, 34811, 34985, 35007, 35606, 35827, 36094, 36147, 36936, 38415, 38465, 39855, 39949, 40147, 40168, 40291, 40340, 40503, 40586, 40633, 40788, 40844, 40925, 40936, 40969, 41028, 41121, 41272, 41391, 41425, 41444, 41908, 42407, 42521, 42522, 42730, 42731, 42858, 43156, 43169, 43233, 43319, 43438, 43503, 43514, 43575, 43686, 43688, 43689, 43731, 43795, 43913, 43939, 43992, 44029, 44152, 44208, 44351, 44363, 44404, 44443, 44566, 44672, 44673, 44674, 44678, 44683, 44685, 44818, 44823, 44875, 44923, 45066, 45067, 45182, 46367, 46475, 46716, 46718, 47009, 47247, 47248, 47642, 47801, 47805, 48120, 48312, 48314, 48505, 49573, 49760, 49808, 49813, 49896, 49900, 49968, 50057, 50301, 50360, 50716, 50717, 51674, 51710, 51760, 51915, 52956, 53396, 53704, 53761, 53841, 54131, 54373, 54611, 54969, 55019, 55089, 55093, 55220, 55221, 55225, 55341, 55397, 58727, 59309, 59706, 59746, 62193, 62196, 65468, 68442, 68868, 68869, 70733, 89715, 94968, 99828, 101637, 101639, 102269, 104906, 122773, 122778, 132210, 132262, 132266, 144129, 144154, 154867, 190509, 198026); +UPDATE `creature_template_addon` SET `auras`='3616' WHERE `entry`=2434; +UPDATE `creature_template_addon` SET `auras`='60913' WHERE `entry` IN (1275, 1286); +UPDATE `creature_template_addon` SET `auras`='3616' WHERE `entry`=3806; +UPDATE `creature_template_addon` SET `auras`='8601' WHERE `entry`=3807; +UPDATE `creature_template_addon` SET `auras`='96573' WHERE `entry` IN (7381, 7382, 7384, 7385); +UPDATE `creature_template_addon` SET `auras`='46933' WHERE `entry`=35880; +UPDATE `creature_template_addon` SET `auras`='75083 75077' WHERE `entry`=39994; +UPDATE `creature_template_addon` SET `auras`='77458' WHERE `entry`=41364; +UPDATE `creature_template_addon` SET `auras`='83323' WHERE `entry`=42573; +UPDATE `creature_template_addon` SET `auras`='79963' WHERE `entry`=43001; +UPDATE `creature_template_addon` SET `auras`='80611 80762' WHERE `entry`=43119; +UPDATE `creature_template_addon` SET `auras`='80611 80763' WHERE `entry`=43122; +UPDATE `creature_template_addon` SET `auras`='80611 80764' WHERE `entry`=43125; +UPDATE `creature_template_addon` SET `auras`='80611 80766' WHERE `entry`=43126; +UPDATE `creature_template_addon` SET `auras`='80611 80767' WHERE `entry`=43127; +UPDATE `creature_template_addon` SET `auras`='80611 80768' WHERE `entry`=43128; +UPDATE `creature_template_addon` SET `auras`='80611 80769' WHERE `entry`=43129; +UPDATE `creature_template_addon` SET `auras`='80611 80770' WHERE `entry`=43130; +UPDATE `creature_template_addon` SET `auras`='82571' WHERE `entry`=43170; +UPDATE `creature_template_addon` SET `auras`='81717' WHERE `entry`=43809; +UPDATE `creature_template_addon` SET `auras`='82887' WHERE `entry`=44352; +UPDATE `creature_template_addon` SET `auras`='83305' WHERE `entry` IN (44633, 44634, 44642, 44646); +UPDATE `creature_template_addon` SET `auras`='83458' WHERE `entry` IN (44668, 44676, 44677); +UPDATE `creature_template_addon` SET `auras`='29266' WHERE `entry`=44885; +UPDATE `creature_template_addon` SET `auras`='84667' WHERE `entry` IN (45037, 45038); +UPDATE `creature_template_addon` SET `auras`='83305 79976' WHERE `entry`=45429; +UPDATE `creature_template_addon` SET `auras`='89285' WHERE `entry`=47786; +UPDATE `creature_template_addon` SET `auras`='78677' WHERE `entry`=48118; +UPDATE `creature_template_addon` SET `auras`='92399' WHERE `entry`=49457; +UPDATE `creature_template_addon` SET `auras`='79976' WHERE `entry` IN (49793, 51143); +UPDATE `creature_template_addon` SET `auras`='82978' WHERE `entry`=52148; +UPDATE `creature_template_addon` SET `auras`='96573' WHERE `entry`=52831; +UPDATE `creature_template_addon` SET `auras`='107773' WHERE `entry`=54664; +UPDATE `creature_template_addon` SET `auras`='107576' WHERE `entry` IN (55911, 56142); +UPDATE `creature_template_addon` SET `auras`='123240' WHERE `entry`=62822; +UPDATE `creature_template_addon` SET `auras`='142875' WHERE `entry`=70740; +UPDATE `creature_template_addon` SET `auras`='199186' WHERE `entry`=96608; + +-- creature +UPDATE `creature` SET `phaseId`=0 WHERE `phaseId`=1; +UPDATE `creature` SET `phaseId`=177 WHERE `phaseId`=256 AND `map`=571; +UPDATE `creature` SET `MovementType`=0 WHERE `guid` IN (307491, 321943, 450133, 650096, 650118, 651363, 651414, 1051194, 1051196); +UPDATE `creature` SET `MovementType`=1 WHERE `guid` IN (769); + +UPDATE `creature` SET `spawnDifficulties`='0' WHERE `guid` IN (23468, 23469, 23472, 23473, 23474, 23477, 23478, 23481, 86511, 86512, 86513, 86530, 117317, 117318, 117319, 130968, 130969, 130970); +UPDATE `creature` SET `terrainSwapMap`=-1 WHERE `guid` IN (86756, 460627, 460628, 460629, 460630, 460631, 460632, 460633, 460634, 460635, 460636, 460637, 460638, 460639, 460640, 460641, 460642, 460643, 460644, 460645, 460646, 460647, 460648, 460649, 460650, 460651, 460652, 460653, 460654, 460655, 460656, 460657, 460658, 460659, 460660, 460661, 460662, 460663, 460664, 460665, 460666, 460667, 460668, 460669, 460670, 460671, 460672, 460673, 460674, 460675, 460676); +UPDATE `creature` SET `phaseId`=0 WHERE `guid` IN (128465, 129392, 129393, 129394, 129395, 129401, 129402, 129403, 129404, 129432, 129434, 129436, 129824, 129825, 130253, 130254, 130255, 130273, 130284, 130285, 130414, 130417); +UPDATE `creature` SET `phaseId`=0, `phaseGroup`=403 WHERE `guid` IN (130483, 130545, 130546); +UPDATE `creature` SET `wander_distance`=5 WHERE `guid` IN (142489, 142510, 142534, 142553); +UPDATE `creature` SET `equipment_id`=0 WHERE `guid`=259404; +UPDATE `creature` SET `unit_flags`=0, `unit_flags2`=0 WHERE `guid` IN (260121, 260181, 260182, 260188, 260189, 260190, 281834); +UPDATE `creature` SET `wander_distance`=0, `MovementType`=0 WHERE `guid` IN (286267, 286270, 286273, 286274, 286275, 286276, 286277, 286278, 286279, 286280, 286281, 286282, 286284, 286285, 286290, 286291, 286292, 286294, 286296, 286303, 286305, 286312, 286313, 286320, 286321, 286323, 286324, 286325, 286326, 286342, 286346, 286349, 286351, 286352, 286426, 286430, 286440, 286442, 286457, 286459, 286463, 286464); + +DELETE FROM `creature_addon` WHERE `guid` IN (39842, 77937, 77938, 77939, 77940, 85227, 88108, 89377, 89378, 89399, 89400, 89401, 89402, 89403, 89404, 89415, 89419, 251153, 251159, 251163, 314131, 371271, 371273, 452762, 452763, 452764, 563382, 563383, 1251916); +UPDATE `creature_addon` SET `auras`=NULL WHERE `guid` IN (73192, 77583, 106950, 126025, 200879, 251603, 253989, 253992, 253994, 254060, 254133, 254134, 254148, 254870, 254871, 254872, 254873, 254875, 254877, 254878, 254879, 254881, 254884, 254885, 254886, 254888, 254891, 254892, 254895, 254902, 254903, 254908, 254910, 254912, 255017, 255058, 255059, 255060, 255061, 255062, 255063, 255067, 255076, 255080, 255085, 255092, 255095, 255115, 255117, 255119, 255120, 255406, 256279, 256282, 256310, 256668, 256894, 258985, 258990, 258993, 258998, 259005, 259008, 259022, 259023, 259037, 259048, 259060, 259065, 259074, 259075, 259083, 259086, 259087, 259092, 259094, 259095, 259128, 259287, 350145, 350146, 350434, 351046, 351273, 351275, 351278, 351295, 351296, 351297, 351298, 351673, 351680, 351689, 351692, 351696, 351698, 351735, 351746, 351750, 351755, 351764, 351834, 351837, 351839, 351845, 351849, 351850, 351851, 351853, 351855, 351856, 351858, 351859, 351860, 351861, 351862, 351863, 351864, 351865, 351870, 351872, 351873, 351874, 351875, 351877, 351878, 351880, 351881, 351882, 351926, 351970, 351971, 351973, 351975, 351977, 351979, 351980, 351985, 352278, 352279, 352283, 352286, 352297, 352300, 352306, 352307, 352316, 352318, 352320, 352323, 352326, 352327, 352328, 352332, 352333, 352336, 352338, 352343, 352345, 352348, 352355, 352357, 352362, 352369, 352374, 352377, 352385, 352388, 352391, 352393, 352398, 352400, 352403, 352404, 352406, 352411, 352417, 352418, 352419, 352422, 352424, 352425, 352431, 352442, 352446, 352447, 352454, 352464, 352467, 352473, 352476, 352481, 352490, 352491, 352492, 352493, 352497, 352500, 352509, 352513, 352516, 352520, 352522, 352524, 352527, 352531, 352532, 352534, 352537, 352551, 352554, 352555, 352558, 352561, 352563, 352564, 352566, 352568, 352569, 352570, 352575, 352576, 352578, 352581, 352583, 352587, 352591, 352594, 352598, 352602, 352613, 352614, 352617, 352618, 352620, 352621, 352622, 352623, 352624, 352625, 352630, 352632, 352633, 352637, 352639, 352640, 352644, 352645, 352650, 352653, 352656, 352661, 352662, 352663, 352669, 352671, 352672, 352674, 352675, 352676, 352679, 352680, 352681, 352682, 352684, 352690, 352691, 352703, 352705, 352706, 352708, 352709, 352714, 352718, 352723, 352725, 352730, 352733, 352735, 352738, 352743, 352744, 352771, 352772, 352775, 352776, 352779, 352801, 352819, 352820, 352824, 352827, 352837, 352839, 352915, 352916, 352944, 352946, 352953, 352969, 352993, 353002, 353003, 353004, 353006, 353009, 353010, 353012, 353013, 353017, 353023, 353027, 353031, 353033, 353035, 353040, 353044, 353047, 353048, 353056, 353354, 353395, 353404, 353405, 353409, 353410, 353412, 353413, 353415, 353416, 353417, 353419, 353422, 353439, 353450, 353475, 353495, 353596, 353599, 353603, 353655, 353693, 353709, 353794, 353796, 353798, 353803, 353813, 353824, 353826, 353830, 353838, 353839, 353840, 353841, 353858, 353859, 353864, 353870, 353871, 353881, 353882, 353883, 353893, 353895, 353902, 353908, 353910, 353939, 353943, 353969, 353970, 353972, 353973, 353976, 353977, 353979, 353980, 353981, 353982, 353984, 353985, 354122, 354186, 354229, 354230, 354306, 354307, 354385, 354390, 354391, 354392, 354395, 354403, 354405, 354407, 354408, 354409, 354429, 354430, 354985, 354986, 355007, 355008, 355012, 355021, 355027, 355028, 355029, 355030, 355033, 355034, 355036, 355037, 355038, 355074, 355075, 355077, 355078, 355079, 355080, 355081, 355082, 355085, 355087, 355088, 355089, 355090, 355091, 355093, 355100, 355102, 355104, 355107, 355112, 355113, 355114, 355115, 355124, 355184, 355196, 355201, 355239, 355240, 355332, 355537, 355539, 355542, 355543, 355546, 355547, 355549, 355550, 355552, 355553, 355554, 355555, 355556, 355557, 355620, 355627, 355693, 355696, 355697, 355925, 355931, 355943, 355955, 356082, 356314, 356315, 356316, 356317, 356318, 356320, 356323, 356324, 356325, 356326, 356327, 356328, 356332, 356338, 356339, 356340, 356341, 356344, 356345, 356346, 356347, 356348, 356349, 356350, 356351, 356352, 356353, 356354, 356355, 356356, 356357, 356358, 356359, 356360, 356362, 356363, 356364, 356366, 356370, 356373, 356374, 356375, 356379, 356380, 356381, 356383, 356384, 356435, 356447, 356477, 356479, 356487, 356488, 356489, 356499, 356500, 356578, 356581, 356586, 356588, 356591, 356592, 356594, 356595, 356596, 356625, 356627, 356629, 356632, 356633, 356634, 356635, 356636, 356637, 356638, 356639, 356641, 356642, 356643, 356644, 356648, 356656, 356657, 356709, 356721, 356723, 356743, 356762, 356781, 356782, 356847, 356849, 356856, 356863, 356870, 356877, 356879, 356889, 356891, 356896, 356900, 356905, 356906, 356914, 356935, 356973, 356975, 356979, 356986, 356996, 357005, 357007, 357038, 357042, 357047, 357062, 357065, 357066, 357073, 357080, 357093, 357148, 357150, 357153, 357163, 357209, 357215, 357220, 357232, 357236, 357250, 357257, 357259, 357262, 371385, 376397, 376620, 376662, 376663, 376672, 376677, 376679, 376683, 376691, 376841, 377427, 377433, 377453, 377511, 377512, 377513, 377515, 377516, 377568, 377664, 377666, 377668, 377673, 377685, 377688, 377689, 377766, 377772, 377774, 377782, 377788, 377821, 377827, 377830, 377833, 377836, 377839, 377841, 377844, 377864, 377866, 378112, 378315, 378316, 378338, 378557, 378714, 379005, 379006, 379007, 379008, 379010, 379948, 379968, 379983, 379984, 379987, 379996, 380010, 380022, 380031, 380119, 380144, 380155, 380180, 380200, 380202, 380207, 380225, 380230, 380260, 380307, 380308, 380318, 380344, 380662, 380664, 380674, 380678, 380680, 380682, 380718, 380722, 380950, 380951, 380953, 380956, 380958, 380959, 380960, 380964, 380965, 380967, 380969, 380970, 380971, 380972, 380975, 380977, 380978, 380979, 380982, 380983, 380985, 380986, 380987, 380988, 380989, 380990, 380994, 380998, 380999, 381000, 381001, 381002, 381003, 381004, 381005, 381006, 381010, 381011, 381012, 381013, 381014, 381016, 381021, 381022, 381023, 381024, 381026, 381027, 381028, 381030, 381031, 381032, 381085, 381086, 381093, 381098, 381113, 381152, 381621, 381623, 381631, 381678, 381679, 381681, 381691, 381708, 381725, 381728, 381819, 381853, 381861, 381863, 381886, 381887, 381888, 382064, 382066, 382069, 382073, 382076, 382079, 382080, 382084, 382127, 382129, 382132, 382134, 382136, 382137, 382138, 382140, 382212, 382505, 382554, 382556, 382561, 382566, 382572, 382573, 382574, 382575, 382577, 382578, 382581, 382583, 382584, 382585, 382587, 382588, 382589, 382590, 382592, 382593, 382594, 382595, 382596, 382597, 382598, 382602, 382603, 382607, 382608, 382617, 382618, 382621, 382623, 382626, 382628, 382630, 382720, 382721, 382817, 382819, 382823, 382826, 383005, 383313, 383329, 383415, 383425, 383426, 383429, 383437, 383439, 383440, 383446, 383450, 383451, 383453, 383454, 383455, 383456, 383457, 383458, 383460, 383461, 383463, 383464, 383470, 383478, 383483, 383484, 383485, 383489, 383493, 383494, 383496, 383500, 383506, 383508, 383509, 383510, 383513, 383528, 383531, 383538, 383544, 383548, 383659, 383677, 383682, 383683, 383684, 383685, 383764, 383766, 383767, 383770, 383774, 383776, 383777, 383781, 383784, 383896, 383897, 383903, 383906, 383909, 383913, 383914, 383936, 383941, 384257, 384272, 384280, 384286, 384298, 384321, 384330, 384334, 384354, 384420, 384428, 384452, 384460, 384466, 384479, 384482, 384485, 384486, 384498, 384507, 384545, 384567, 384588, 384596, 384598, 384602, 384603, 384604, 384652, 385850, 385851, 385854, 385874, 385878, 385888, 385889, 385891, 385896, 385937, 385939, 385948, 385969, 385996, 385997, 385999, 386006, 386007, 386016, 386021, 386024, 386025, 386054, 386055, 386058, 386061, 386062, 386063, 386944, 386947, 386955, 387421, 387423, 387425, 387427, 387430, 387563, 387717, 387825, 389804, 391155, 391159, 391163, 391174, 391175, 391192, 391199, 391209, 391210, 391213, 391217, 391218, 391451, 391589, 391590, 391591, 391602, 391603, 391604, 391605, 391618, 391625, 391626, 391629, 391641, 391646, 391655, 392285, 392286, 392312, 393090, 393106, 393397, 393420, 393438, 393540, 393543, 393565, 394396, 394399, 394402, 394544, 394547, 394604, 394714, 394875, 394876, 394995, 395055, 395062, 395674, 395675, 395676, 395677, 395678, 395679, 395680, 395681, 395682, 395683, 395684, 395685, 395686, 395687, 395688, 395689, 395690, 395691, 395692, 395693, 395694, 395695, 395696, 452541, 452729, 452766, 452767, 453609, 456992, 650072, 650079, 650083, 650089, 650095, 650100, 650104, 650108, 650114, 650125, 650130, 651679, 651682, 651693, 651706, 651728, 651732, 651740, 651742, 651746, 651751, 651759, 651775, 651784, 651787, 651789, 850130, 1250029); +UPDATE `creature_addon` SET `auras`='107576' WHERE `guid` IN (254509, 254510); +UPDATE `creature_addon` SET `auras`='107773' WHERE `guid`=254536; +UPDATE `creature_addon` SET `auras`='84667' WHERE `guid` IN (350065, 350088); +UPDATE `creature_addon` SET `auras`='83323' WHERE `guid`=350098; +UPDATE `creature_addon` SET `auras`='82839' WHERE `guid`=350842; +UPDATE `creature_addon` SET `auras`='82571' WHERE `guid` IN (352111, 352155, 352174, 352181); +UPDATE `creature_addon` SET `auras`='79976' WHERE `guid` IN (352285, 352294, 352299, 352311, 352321, 352324, 352337, 352339, 352341, 352346, 352352, 352356, 352358, 352364, 352375, 352379, 352380, 352392, 352394, 352405, 352408, 352414, 352415, 352426, 352428, 352435, 352441, 352444, 352448, 352456, 352457, 352466, 352471, 352472, 352474, 352498, 352506, 352512, 352514, 352526, 352528, 352529, 352533, 352535, 352546, 352556, 352559, 352567, 352582, 352589, 352597, 352599, 352607, 352609, 352619, 352626, 352628, 352631, 352638, 352646, 352647, 352649, 352652, 352658, 352660, 352668, 352677, 352683, 352686, 352689, 352693, 352698, 352699, 352702, 352716, 352719, 352721, 352728, 352734, 352741, 352778, 352803, 352813, 352823, 352825, 352835, 352938, 352950, 352954, 352956, 352961, 352971, 352991, 352994, 353007, 353011, 353016, 353022, 353026, 353030, 353032, 353034, 353054, 353055, 353560, 353563, 353564, 353799, 353801, 353810, 353828, 353831, 353844, 353865, 353869, 353901, 353906, 353912, 353941); +UPDATE `creature_addon` SET `auras`='82887' WHERE `guid`=354424; +UPDATE `creature_addon` SET `auras`='81717' WHERE `guid`=356408; +UPDATE `creature_addon` SET `auras`='83305' WHERE `guid` IN (356417, 356418, 356422, 356423, 356428); +UPDATE `creature_addon` SET `auras`='83458' WHERE `guid` IN (356890, 356917, 356960, 356974, 357027, 357053, 357063, 357090, 357094, 357107); +UPDATE `creature_addon` SET `auras`='82839' WHERE `guid` IN (356895, 357084); +UPDATE `creature_addon` SET `auras`='49414 49415' WHERE `guid`=377897; +UPDATE `creature_addon` SET `auras`='78198' WHERE `guid`=378957; +UPDATE `creature_addon` SET `auras`='49415' WHERE `guid`=380026; +UPDATE `creature_addon` SET `auras`='88962' WHERE `guid`=380526; +UPDATE `creature_addon` SET `auras`='89643' WHERE `guid` IN (383436, 383443, 383448, 383707, 383762, 383768); +UPDATE `creature_addon` SET `auras`='86393' WHERE `guid` IN (383692, 383741); +UPDATE `creature_addon` SET `auras`='86376' WHERE `guid`=383759; +UPDATE `creature_addon` SET `auras`='70696 74093 74094 74095 74096' WHERE `guid`=386736; +UPDATE `creature_addon` SET `auras`='76354' WHERE `guid` IN (389379, 389769); +UPDATE `creature_addon` SET `auras`='68327' WHERE `guid`=389426; +UPDATE `creature_addon` SET `auras`='9036 10848' WHERE `guid`=850143; +UPDATE `creature_addon` SET `auras`='370756 371042' WHERE `guid` IN (1251814, 1251836, 1251843); + +-- creature_formations +DELETE `cf` FROM `creature_formations` AS `cf` LEFT JOIN `creature` AS `c` ON `cf`.`memberGUID`=`c`.`guid` WHERE `c`.`guid` IS NULL; +DELETE FROM `creature_formations` WHERE `leaderGUID`=45501; + +-- gameobject_template +UPDATE `gameobject_template` SET `displayId`=1287 WHERE `entry` IN (182523, 182522, 185324); +UPDATE `gameobject_template` SET `displayId`=3972 WHERE `entry`=175885; + +-- gameobject +DELETE FROM `gameobject_overrides` WHERE `spawnId` IN (76181, 76182, 76498, 76579, 76580); + +DELETE FROM `gameobject_addon` WHERE `guid` IN (22991, 34379, 34380, 34381, 34382, 34383, 34384, 34385, 34386, 34387, 34388, 34389, 34390, 34391, 34392, 34393, 34394, 34395, 34396, 34397, 34398, 34399, 34400, 34401, 34402, 34403, 34404, 34405, 34406, 34407, 34408, 34409, 34410, 34411, 34412, 34413, 34414, 34415, 34416, 34417, 34418, 34419, 34420, 34421, 34422, 34423, 34424, 34425, 34426, 34427, 34428, 34429, 34430, 34431, 34432, 34433, 34434, 34435, 34436, 34437, 34438, 34439, 34440, 34441, 34442, 34443, 34444, 34445, 34446, 34447, 34448, 34449, 34450, 34451, 34452, 34453, 34454, 34455, 34456, 34457, 34458, 34459, 34460, 34461, 34462, 34463, 34464, 34465, 34466, 34467, 34468, 34469, 34470, 34471, 34472, 34473, 34474, 34475, 34476, 34477, 34478, 34479, 34480, 34481, 34482, 34483, 34484, 35118, 35119, 35120, 35121, 35122, 35123, 35124, 35125, 35126, 35127, 35128, 35129, 35130, 35131, 35132, 35133, 35134, 35135, 35136, 35137, 35138, 35139, 35140, 35141, 35142, 35143, 35144, 35145, 35147, 35148, 35149, 35150, 35151, 35152, 35153, 35154, 35155, 35156, 35157, 35158, 35159, 35160, 35161, 35162, 35163, 35164, 35165, 35166, 35167, 35168, 35169, 35170, 35171, 35172, 35173, 35174, 35175, 35176, 35177, 35178, 35179, 35180, 35181, 35182, 35183, 35184, 35185, 35186, 35187, 35188, 35189, 35190, 35191, 35192, 35193, 35194, 35195, 35196, 35197, 35198, 35199, 35200, 35201, 35202, 35203, 35204, 35205, 35206, 35207, 35208, 35209, 35210, 35211, 35212, 35213, 35214, 35215, 35216, 35217, 35218, 35219, 35220, 35221, 35222, 35223, 35224, 35226, 35227, 35228, 35229, 35230, 35231, 35232, 35233, 35234, 35235, 35236, 35237, 35238, 35239, 35240, 35241, 35242, 35243, 35244, 35245, 35246, 35247, 35248, 35249, 35250, 35251, 35252, 35253, 35254, 35255, 35256, 35257, 35258, 35259, 35260, 35261, 35262, 35263, 35264, 35265, 35266, 35267, 35268, 35269, 35270, 35271, 35272, 35273, 35274, 35275, 35276, 35277, 35278, 35279, 35280, 35281, 35282, 35283, 35284, 35285, 35286, 35876, 35877, 35878, 35879, 35880, 35881, 35882, 35883, 35884, 35885, 35886, 35887, 35888, 35889, 35890, 35891, 35892, 35893, 35894, 35895, 35896, 35897, 35898, 35899, 35900, 35901, 35902, 35903, 35904, 35905, 35906, 35907, 35908, 35909, 35910, 35911, 35912, 35913, 35914, 35915, 35916, 35917, 35918, 35919, 35920, 35921, 35922, 35923, 35924, 35925, 35926, 35927, 35928, 35929, 35930, 35931, 35932, 35933, 35934, 35935, 35936, 35937, 35938, 35939, 35940, 35941, 35942, 35943, 35944, 35945, 35946, 35947, 35948, 35949, 35950, 35951, 35952, 35953, 35954, 35955, 35956, 35957, 35958, 35959, 35960, 35961, 35962, 35963, 35964, 35965, 35966, 35967, 35968, 35969, 35970, 35971, 35972, 35973, 35974, 35975, 35976, 35977, 35978, 35979, 35980, 35981, 35982, 35983, 35984, 35985, 35986, 35987, 35988, 35989, 35990, 35991, 35992, 35993, 35994, 35995, 35996, 35997, 35998, 35999, 36000, 36001, 36002, 36003, 36004, 36005, 36006, 36007, 36008, 36009, 36010, 36011, 36012, 36013, 36014, 36015, 36016, 36017, 36018, 36019, 36020, 36021, 36022, 36023, 36024, 36025, 36026, 36027, 36028, 36029, 36030, 36031, 36032, 36033, 36034, 36035, 36036, 36037, 36038, 36039, 36040, 36041, 36042, 36043, 36044, 36045, 36046, 36047, 36048, 36049, 36050, 36051, 36052, 36053, 36054, 36055, 36056, 36057, 36058, 36059, 36060, 36061, 36062, 36063, 36064, 36065, 36066, 36067, 36068, 36069, 36070, 36071, 36072, 36073, 36074, 36075, 36076, 36077, 36078, 36079, 36080, 36081, 36082, 36083, 36084, 36085, 36086, 36087, 36088, 36089, 36090, 36091, 36092, 36093, 36094, 36095, 36096, 36097, 36098, 36099, 36100, 36101, 36102, 36103, 36104, 36105, 36106, 36107, 36108, 36196, 36197, 36198, 36199, 36200, 36201, 36202, 36203, 36204, 36205, 36206, 36207, 36208, 36209, 36210, 36211, 36212, 36213, 36214, 36215, 36216, 36217, 36218, 36219, 36220, 36221, 36222, 36223, 36224, 36225, 36226, 36350, 36351, 36352, 36353, 36354, 36355, 36356, 36357, 36358, 36359, 36360, 36361, 36362, 36363, 36364, 36365, 36366, 36367, 36368, 36369, 36370, 36371, 36372, 36373, 36374, 36375, 36376, 36377, 36378, 36379, 36380, 36381, 36382, 36383, 36384, 36637, 36638, 36639, 36640, 36641, 36642, 36643, 36644, 36645, 36646, 36647, 36648, 36649, 36650, 36651, 36652, 36653, 36654, 36655, 36656, 36657, 36658, 36659, 36660, 36661, 36662, 36786, 36787, 36788, 36789, 36790, 36791, 36792, 36793, 36794, 36795, 36796, 36797, 36798, 36799, 36800, 36801, 36802, 36803, 36804, 36805, 36806, 36807, 36808, 36809, 36810, 36811, 36812, 36813, 36814, 36815, 37062, 37063, 37064, 37065, 37066, 37067, 37068, 37069, 37070, 37071, 37072, 37073, 37074, 37075, 37076, 37077, 37078, 37079, 37080, 37081, 37211, 37212, 37213, 37214, 37215, 37216, 37217, 37219, 37220, 37221, 37222, 37223, 37224, 37225, 37226, 37227, 37228, 37229, 37230, 37231, 37232, 37233, 37234, 37235, 37236, 37237, 37238, 37239, 37407, 37442, 37443, 37444, 37445, 37446, 37447, 37448, 37449, 37450, 37519, 37520, 37521, 37522, 37523, 37524, 37525, 37526, 37527, 37580, 37581, 37582, 37583, 37584, 37585, 37697, 37698, 37699, 37804, 37805, 37806, 37807, 37808, 37809, 37810, 37811, 37812, 37813, 37814, 37815, 37816, 37817, 37818, 37819, 37820, 37821, 37822, 37823, 37824, 37825, 37826, 37827, 37828, 37829, 37830, 37831, 37832, 37833, 37834, 37835, 37836, 37837, 37838, 37839, 37840, 37841, 38148, 38149, 38150, 38151, 38152, 38153, 38154, 38155, 38156, 38157, 38158, 38159, 38160, 38161, 38162, 38163, 38164, 38165, 38166, 38167, 38347, 38348, 38349, 38350, 38351, 38352, 38353, 38354, 38355, 38356, 38357, 38358, 38359, 38360, 38361, 38362, 38363, 38364, 38365, 38366, 38367, 38597, 38598, 38599, 38600, 38601, 38602, 38603, 38604, 38605, 38606, 38607, 38608, 38609, 38610, 38611, 38612, 38613, 38614, 38784, 38785, 38786, 38787, 38788, 38789, 38790, 38791, 38792, 38793, 38794, 38795, 38796, 38797, 38798, 38799, 38800, 38801, 38802, 38803, 39033, 39034, 39035, 39036, 39037, 39038, 39039, 39040, 39041, 39042, 39043, 39044, 39045, 39046, 39047, 39048, 39049, 39050, 39051, 39052, 39053, 39054, 39055, 39056, 39057, 39058, 39059, 39060, 39061, 39062, 39063, 39064, 39065, 39066, 39067, 39068, 39069, 39070, 39071, 39072, 39073, 39074, 39075, 39077, 39441, 39442, 39443, 39444, 39445, 39446, 39447, 39448, 39449, 39450, 39452, 39453, 39454, 39455, 39456, 39457, 39458, 39459, 39460, 39461, 39462, 39463, 39464, 39465, 39466, 39467, 39468, 39469, 39470, 39471, 39472, 39473, 39474, 39475, 39476, 39477, 39478, 39479, 39480, 39481, 39593, 39594, 39595, 39596, 39597, 39598, 39599, 39600, 39601, 39602, 39603, 39604, 39605, 39606, 39607, 39608, 39853, 39874, 39875, 39876, 41177, 41178, 41179, 41180, 41181, 41182, 41183, 41184, 41185, 41186, 41187, 41473, 41474, 41475, 41476, 41477, 41478, 41479, 41480, 41481, 41482, 41483, 41484, 41485, 41486, 41487, 41488, 41580, 41581, 41582, 41645, 41646, 41647, 41648, 41649, 41650, 41685, 41686, 41725, 41726, 41727, 41728, 41729, 41730, 41765, 41766, 41767, 41768, 41769, 41770, 41771, 41772, 41773, 41774, 41775, 41776, 41777, 41778, 41779, 41780, 41781, 41782, 41783, 41784, 41785, 41786, 41787, 41788, 41789, 41790, 41791, 41792, 41793, 41794, 41795, 41796, 41797, 41798, 41799, 41800, 41940, 41941, 41942, 41943, 41944, 41945, 41946, 41947, 41948, 41949, 41950, 41951, 41952, 41953, 41954, 41955, 41956, 41957, 41958, 41959, 41960, 41961, 41962, 41963, 41964, 41965, 41966, 41967, 41968, 41969, 41970, 41971, 41972, 41973, 41974, 41975, 41976, 41977, 41978, 41979, 41980, 41981, 41982, 41983, 41984, 41985, 41986, 41987, 41988, 41989, 41990, 41991, 41992, 41993, 41994, 41995, 41996, 41997, 41998, 41999, 42000, 42001, 42002, 42003, 42004, 42005, 42006, 42007, 42008, 42009, 42010, 42011, 42012, 42013, 42014, 42015, 42016, 42017, 42018, 42019, 42020, 42021, 42022, 42023, 42024, 42025, 42026, 42027, 42028, 42029, 42030, 42031, 42032, 42033, 42034, 43050, 43051, 43064, 43065, 43066, 43068, 43069, 43070, 43071, 76167, 76168, 76169, 76170, 76171, 76172, 76173, 76174, 76175, 76176, 76177, 76178, 76179, 76180, 76181, 76182, 76183, 76184, 76185, 76186, 76187, 76188, 76189, 76190, 76191, 76192, 76193, 76194, 76195, 76196, 76197, 76198, 76199, 76239, 76251, 76253, 76256, 76257, 76259, 76260, 76261, 76262, 76263, 76273, 76274, 76275, 76284, 76285, 76286, 76287, 76288, 76289, 76290, 76291, 76292, 76293, 76294, 76295, 76296, 76329, 76330, 76331, 76332, 76333, 76334, 76335, 76336, 76337, 76338, 76339, 76340, 76341, 76342, 76343, 76353, 76354, 76355, 76356, 76357, 76358, 76359, 76360, 76383, 76384, 76385, 76386, 76387, 76388, 76389, 76390, 76391, 76392, 76393, 76394, 76395, 76396, 76397, 76398, 76399, 76400, 76401, 76402, 76403, 76404, 76405, 76406, 76407, 76408, 76409, 76410, 76411, 76412, 76498, 76560, 76561, 76562, 76563, 76564, 76565, 76566, 76567, 76568, 76569, 76570, 76571, 76572, 76573, 76574, 76575, 76576, 76577, 76578, 76579, 76580, 76581, 76582, 76583, 76584, 76585, 76586, 76587, 76588, 76589, 76590, 76591, 76592, 76593, 76594, 76595, 76596, 76597, 76598, 76599, 76600, 76601, 76602, 76603, 76604, 76605, 76606, 76607, 76608, 76609, 76610, 76611, 76612, 76613, 76614, 76615, 76616, 76617, 76618, 76619, 76620, 76621, 76622, 76623, 76624, 76625, 76626, 76627, 76628, 76629, 76630, 76631, 76632, 76633, 76634, 76635, 76636, 76637, 76638, 76639, 76640, 76641, 76642, 76643, 76644, 76645, 76646, 200067, 203029, 203036, 219959, 219960, 224808, 224809, 229455, 235295, 235296, 501832); + +-- spawn_group +DELETE FROM `spawn_group` WHERE `groupId`=2 AND `spawnType`=0 AND `spawnId` IN (377, 378, 379, 380, 381, 382, 383, 384, 85701, 85702, 85707, 86582, 86583, 86584, 86585, 86586, 86849, 86850, 314282, 323854, 361902, 361993, 361994, 361995, 361996, 361997, 362003, 362004, 362005, 362006, 362007, 362008, 362009, 362010, 362011, 362012, 362013, 362014, 362015, 362016, 362017, 362018, 362019, 362020, 362021, 362022, 362023, 362024, 362025, 362026, 362027, 362028, 362029, 362030, 362031, 362032, 362033, 362039, 362040, 362041, 362042, 362043, 362044, 362045, 362046, 362047, 362048, 362049, 362050, 362051, 362052, 362053, 362054, 362055, 362056, 362057, 362058, 362059, 362060, 362061, 362062, 362063, 362064, 362065, 362066, 362068, 362069, 362070, 362071, 362072, 362073, 362074, 362075, 362081, 362082, 362083, 362084, 362085, 362086, 362087, 362188, 362189, 362190); +DELETE FROM `spawn_group` WHERE `groupId`=2 AND `spawnType`=1 AND `spawnId` IN (210704, 210708, 210709, 210713, 219973, 219974, 219975, 219976, 219977, 219978, 219979); +DELETE FROM `spawn_group` WHERE `groupId`=3 AND `spawnType`=0 AND `spawnId` IN (11348, 14387, 15031, 17874, 19107, 21584, 21594, 21692, 23229, 24268, 26987, 29241, 32333, 33115, 37085, 40210, 41759, 50381, 93194, 93301); +DELETE FROM `spawn_group` WHERE `groupId`=43 AND `spawnType`=0 AND `spawnId` IN (201914, 201934, 201954, 201957, 201988, 202000, 202028, 202054, 202098, 202121, 202122, 202145, 202196, 202199, 202227); +DELETE FROM `spawn_group` WHERE `groupId`=223 AND `spawnType`=0 AND `spawnId`=125913; + +-- *_scripts errors +UPDATE `gameobject_template` SET `type`=5 WHERE `entry`=179668; + +DELETE FROM `event_scripts` WHERE `id`=525; -- Invalid gameobject GUID +DELETE FROM `event_scripts` WHERE `id`=9542 AND `command`=9; -- Invalid gameobject GUID + +DELETE FROM `spell_scripts` WHERE `id`=71874; -- Effect is not SPELL_EFFECT_SCRIPT_EFFECT or SPELL_EFFECT_DUMMY +DELETE FROM `waypoint_scripts` WHERE `command` IN (2, 4, 5); -- Deprecated commands + +-- script_waypoint does not exist +DELETE FROM `script_waypoint` WHERE `entry`=17238; + +-- spell_script_names: script/spell does not exist +DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_item_jom_gabbar', 'spell_sha_flametongue'); |