DB/Misc: fixed a bunch of startup errors

1 files changed, 12 insertions, 0 deletions

diff --git a/sql/updates/world/cata_classic/2024_12_24_00_world.sql b/sql/updates/world/cata_classic/2024_12_24_00_world.sql
new file mode 100644
index 00000000000..3fb48f7c426
--- /dev/null
+++ b/sql/updates/world/cata_classic/2024_12_24_00_world.sql
@@ -0,0 +1,12 @@
+DELETE FROM `quest_visual_effect`;
+DELETE FROM `creature_template_addon` WHERE `entry` IN (56479, 56394, 55123, 55083, 55021, 55020, 55019, 54993, 54975, 54943, 54902, 54901, 54900, 54787, 54786, 54734, 54611, 54609, 54608, 54587, 54586, 54567, 54135, 54131, 54058, 54057, 54056, 54046, 54045, 54044, 53714, 53704, 53566, 53565, 49160, 49155, 49126, 48973, 48940, 48834, 48827, 48826, 48824, 48823, 48811, 48810, 43282, 43281, 43280, 40684, 40682, 40675, 40674, 40673, 40672, 40671, 40670, 40424, 40422, 40420, 40418, 40145, 40144, 40143, 39945, 39944, 39922, 39920, 39864, 39823, 39815, 39805, 39311, 39310, 39309, 39307, 39306, 39305, 39304, 39303, 39302, 39301, 39300, 39299, 39296, 39289, 39288, 39287, 39286, 39285, 39284, 39234, 39233, 39232, 39168, 39167, 39166, 39122, 39121, 39120, 39001, 39000, 38790, 38789, 38788, 38787, 38786, 38785, 38784, 38774, 38773, 38772, 38771, 38770, 38769, 38761, 38760, 38759, 38758, 38736, 38734, 38733, 38726, 38724, 38723, 38722, 38721, 38702, 38701, 38700, 38699, 38694, 38693, 38692, 38691, 38690, 38689, 38688, 38687, 38686, 38685, 38684, 38683, 38682, 38681, 38680, 38679, 38678, 38677, 38676, 38675, 38641, 38635, 38634, 38633, 38632, 38631, 38630, 38629, 38628, 38626, 38625, 38605, 38604, 38602, 38590, 38586, 38585, 38583, 38582, 38550, 38549, 38483, 38481, 38480, 38479, 38462, 38446, 38445, 38444, 38436, 38435, 38434, 38431, 38418, 38408, 38407, 38406, 38405, 38404, 38403, 38402, 38401, 38400, 38399, 38398, 38397, 38396, 38395, 38394, 38393, 38390, 38388, 38352, 38351, 38350, 38349, 38304, 38303, 38299, 38298, 38297, 38296, 38267, 38266, 38265, 38262, 38261, 38258, 38257, 38256, 38220, 38219, 38185, 38174, 38170, 38169, 38168, 38166, 38138, 38129, 38128, 38123, 38108, 38106, 38103, 38102, 38101, 38100, 38099, 38098, 38097, 38096, 38095, 38094, 38093, 38092, 38091, 38090, 38089, 38088, 38087, 38086, 38085, 38084, 38083, 38082, 38081, 38080, 38079, 38078, 38077, 38076, 38075, 38074, 38073, 38072, 38064, 38063, 38062, 38061, 38059, 38058, 38031, 38026, 38025, 38000, 37959, 37958, 37957, 37731, 37730, 37720, 37678, 37677, 37656, 37644, 37642, 37641, 37640, 37639, 37637, 37636, 37629, 37627, 37622, 37613, 37612, 37611, 37609, 37551, 37550, 37549, 37506, 37505, 37504, 37466, 37464, 37377, 37363, 37343, 37341, 37329, 37323, 37321, 37236, 37233, 36938, 36572, 36571, 36566, 36538, 36498, 36358, 36357, 36091, 36090, 36089, 36088, 36087, 36086, 36085, 36084, 36083, 36082, 36067, 35749, 35748, 35747, 35746, 35745, 35744, 35743, 35742, 35741, 35740, 35739, 35738, 35737, 35736, 35735, 35734, 35733, 35732, 35731, 35730, 35729, 35728, 35726, 35725, 35724, 35723, 35722, 35721, 35720, 35719, 35718, 35717, 35716, 35715, 35714, 35713, 35712, 35711, 35710, 35709, 35708, 35707, 35706, 35705, 35704, 35703, 35702, 35701, 35700, 35699, 35697, 35696, 35695, 35694, 35693, 35692, 35691, 35690, 35689, 35688, 35687, 35686, 35685, 35684, 35683, 35682, 35681, 35680, 35676, 35675, 35674, 35673, 35672, 35671, 35670, 35669, 35668, 35667, 35666, 35665, 35664, 35663, 35662, 35656, 35655, 35616, 35615, 35568, 35560, 35559, 35546, 35544, 35543, 35542, 35541, 35540, 35539, 35538, 35537, 35536, 35535, 35534, 35533, 35532, 35531, 35530, 35529, 35528, 35527, 35525, 35524, 35523, 35522, 35521, 35520, 35519, 35518, 35517, 35516, 35515, 35514, 35513, 35512, 35511, 35490, 35449, 35448, 35447, 35440, 35439, 35438, 35436, 35433, 35431, 35429, 35427, 35421, 35419, 35417, 35415, 35413, 35410, 35405, 35403, 35360, 35359, 35358, 35357, 35356, 35355, 35354, 35353, 35352, 35351, 35350, 35349, 35348, 35347, 35280, 35279, 35278, 35272, 35271, 35270, 35269, 35268, 35267, 35266, 35265, 35264, 35263, 35262, 35216, 34649, 34648, 34566, 34443, 34442, 34332, 34296, 34277, 34276, 34257, 34256, 34255, 34247, 34245, 34237, 34236, 34235, 34229, 34226, 34222, 34221, 34218, 34216, 34215, 34201, 34200, 34186, 34185, 34175, 34171, 34169, 34166, 34165, 34162, 34152, 34148, 34113, 34111, 34110, 34109, 34108, 34106, 34105, 34054, 34045, 34016, 34003, 33999, 33995, 33994, 33989, 33986, 33984, 33968, 33967, 33955, 33954, 33911, 33910, 33909, 33908, 33888, 33887, 33886, 33885, 33852, 33851, 33850, 33839, 33835, 33832, 33831, 33830, 33829, 33828, 33827, 33815, 33789, 33773, 33758, 33757, 33741, 33737, 33735, 33734, 33733, 33732, 33731, 33730, 33729, 33724, 33723, 33700, 33694, 33693, 33692, 33691, 33689, 33668, 33664, 33449, 33393, 33392, 33391, 33360, 33234, 33191, 33190, 33154, 33149, 33148, 33147, 33116, 33070, 32846, 32796, 32795, 32555, 32554, 32553, 32552, 32551, 32368, 32313, 32138, 32136, 32056, 32023, 32010, 32004, 32002, 31920, 31917, 31822, 31821, 31722, 31680, 31679, 31676, 31674, 31673, 31669, 31659, 31657, 31656, 31617, 31616, 31615, 31612, 31611, 31610, 31607, 31604, 31603, 31602, 31601, 31600, 31599, 31598, 31597, 31596, 31595, 31594, 31593, 31592, 31591, 31590, 31589, 31588, 31586, 31585, 31561, 31560, 31559, 31558, 31538, 31537, 31536, 31533, 31519, 31518, 31512, 31511, 31510, 31509, 31508, 31504, 31503, 31502, 31501, 31469, 31465, 31464, 31449, 31448, 31447, 31441, 31394, 31391, 31390, 31388, 31386, 31373, 31368, 31367, 31365, 31359, 31217, 31212, 31211, 31210, 30991, 30974, 30973, 30972, 30936, 30935, 30934, 30928, 30925, 30905, 30903, 30823, 30822, 30819, 30810, 30807, 30805, 30794, 30788, 30775, 30774, 30748, 30603, 30602, 30601, 30600, 30540, 30532, 30529, 30522, 30521, 30518, 30510, 30509, 30508, 30498, 30497, 30496, 30495, 30459, 30457, 30398, 30397, 30389, 30097, 30087, 30075, 30068, 30061, 30047, 30018, 30016, 30015, 29991, 29990, 29988, 29986, 29985, 29955, 29941, 29940, 29900, 29899, 29898, 29852, 29842, 29837, 29835, 29833, 29831, 29828, 29825, 29824, 29823, 29718, 29701, 29615, 29609, 29576, 29575, 29574, 29448, 29447, 29446, 29417, 29388, 29379, 29373, 29371, 29363, 29362, 29359, 29357, 29356, 29355, 29354, 29353, 29347, 29324, 29286, 29278, 29274, 29273, 29268, 29256, 29249, 29248, 29247, 29243, 29242, 29241, 29229, 28171, 26651, 26341, 25579, 25578, 25574, 25573, 25569, 25567, 25562, 25560, 25557, 25556, 25555, 25552, 25550, 25549, 25546, 25543, 25541, 24857, 22686, 22629, 22627, 22594, 22593, 22570, 22566, 22564, 22563, 22558, 22556, 22526, 22525, 22300, 22172, 22171, 22170, 22167, 22129, 21988, 21919, 21918, 21915, 21914, 21712, 21626, 21624, 21623, 21622, 21621, 21620, 21618, 21617, 21616, 21613, 21607, 21605, 21604, 21603, 21602, 21601, 21600, 21599, 21598, 21595, 21594, 21592, 21590, 21589, 21588, 21587, 21586, 21585, 21582, 21581, 21559, 21558, 21551, 21537, 21533, 21526, 21525, 20993, 20746, 20745, 20738, 20737, 20706, 20698, 20697, 20691, 20690, 20665, 20663, 20662, 20657, 20656, 20654, 20653, 20652, 20646, 20645, 20640, 20639, 20637, 20636, 20633, 20632, 20630, 20629, 20597, 20596, 20595, 20592, 20581, 20579, 20578, 20575, 20571, 20569, 20568, 20550, 20548, 20535, 20531, 20522, 20521, 20321, 20319, 20318, 20317, 20316, 20315, 20311, 20307, 20306, 20304, 20303, 20299, 20298, 20268, 20267, 20266, 20256, 20190, 20188, 20184, 20183, 20182, 20170, 20169, 20168, 19895, 19894, 19893, 18621, 18620, 18615, 18607, 18602, 18601, 18436, 18435, 18434, 18433, 18432, 18058);
+DELETE FROM `serverside_spell` WHERE `Id` IN (40418, 42123, 44039, 45784, 68485, 72562, 72564, 81040, 89832);
+DELETE FROM `serverside_spell_effect` WHERE `SpellID` IN (40418, 42123, 44039, 45784, 68485, 72562, 72564, 81040, 89832);
+DELETE FROM `spell_custom_attr` WHERE `entry` IN (66765, 66809, 165961, 184689, 244410, 244761);
+DELETE FROM `creature_summoned_data` WHERE `CreatureID` IN (80087, 90382, 91911, 93011, 93117, 93230, 94377, 94400, 94410, 94580, 98227, 98228, 98229, 98290, 98292, 98354, 99916, 99917, 99918, 120590, 124630, 149917, 151088, 151089, 154170, 154327, 156622, 156626, 156662, 157051, 164577, 165359, 165360, 166782, 166784, 166787, 166792, 166797, 166800, 166814, 166916, 166996, 166997, 167126, 167146, 174955, 175034, 182084, 182088, 198883, 198896);
+DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (30935, 32795, 32796, 34045, 34111, 34162, 35410, 35413, 35415, 35417, 35419, 35421, 35427, 35429, 35431, 35431, 35433, 35433, 35436, 36357, 36358, 40470, 40471, 40472, 48803, 48804, 48820, 48821, 48913, 48939, 49072, 51101, 51102, 51103, 58662, 58674, 59304, 59359, 59705, 59706, 60908, 62809, 65379, 68491, 71047, 71051, 83670, 96568, 97043, 97068, 99804, 101013, 101518, 101704, 102108, 102325, 102327, 102423, 105794, 112694, 116404, 122450, 130758, 131817, 135219, 135521, 137196, 137199, 137201, 138410, 138421, 138422, 138423, 139645, 142029, 142030, 142031, 142032, 142035, 142040, 142042, 142043, 142044, 142046, 142050, 142051, 142052, 142053, 142055, 142056, 142069, 142111, 142119, 142139, 142453, 142613, 143022, 143272, 143444, 143502, 144110, 144175, 144176, 144177, 144178, 144327, 144328, 148904, 148906, 153198, 154729, 154745, 154765, 155134, 155602, 156345, 156518, 156595, 157496, 157498, 158456, 158463, 158558, 158559, 158560, 158561, 158753, 158755, 167027, 167142, 175732, 180803, 189870, 190288, 197802, 198509, 199790, 205445);
+DELETE FROM `vehicle_template_accessory` WHERE `entry` IN (40470, 40470, 40471, 40471, 40471, 40471, 40472, 40472, 40472, 40472, 48820, 48820, 48820, 48820, 48820, 48821, 48821, 48821, 48821, 48821, 48939, 56739, 58662, 58674, 59359, 59359, 59359, 59359, 59359, 59705, 62809, 62809, 97043, 97068, 99804, 101013, 101638, 101640, 102108, 102325, 102327, 114323, 114323, 114323, 122450, 122450, 131817, 131817, 131817, 131817, 131817, 131817, 131817, 131817, 135219, 154765, 156345, 158561, 158561, 158561, 158561, 158561, 175732, 199790);
+DELETE FROM `vehicle_template_accessory` WHERE `accessory_entry` IN (0, 54131, 58664, 58727, 59982, 59982, 59982, 59982, 59982, 59706, 62821, 62822, 97208, 94968, 99828, 102375, 101637, 101639, 102104, 98291, 102326, 114341, 114343, 114344, 122778, 122773, 132137, 132137, 132137, 132137, 132137, 132137, 132137, 132137, 133685, 154729, 154867, 158558, 158559, 158560, 158559, 158560, 178355, 199791);
+DELETE FROM `spell_area` WHERE `spell` IN (100709, 100711, 102194, 102194, 102194, 102393, 102393, 102395, 102395, 102396, 102396, 102396, 102397, 102398, 102399, 102400, 102403, 102403, 102403, 102429, 102429, 102521, 102868, 102869, 102870, 102871, 102871, 102872, 102873, 102873, 102874, 102875, 102875, 103051, 104018, 104028, 104334, 104566, 104567, 104762, 105001, 105001, 105005, 105005, 105095, 105096, 105156, 105157, 105158, 105160, 105161, 105162, 105306, 105307, 105307, 105308, 105308, 105525, 106394, 106493, 106494, 107027, 107028, 107032, 107033, 108694, 108695, 108822, 108823, 108834, 108835, 108842, 108842, 108844, 108844, 108879, 108914, 108931, 109067, 109100, 109303, 114455, 114735, 114735, 115446, 115447, 115447, 115448, 115448, 115449, 116571, 117501, 117783, 118028, 119305, 119306, 119307, 128574, 128943, 131526, 161625, 161625, 163341, 164609, 164611, 164877, 164877, 214608, 247532, 305420, 305420, 305421, 305421, 312605, 312605, 321690, 321690, 321691, 321691, 321692, 321692, 321693, 321693, 325429, 346797, 346799, 369731, 370112, 372995, 372995, 372995, 372995);
+DELETE FROM `access_requirement` WHERE `mapId` IN (959, 959, 960, 960, 961, 961, 962, 994, 994, 1001, 1001, 1004, 1004, 1007, 1007, 1011, 1011, 1175, 1175, 1176, 1176, 1182, 1182, 1195, 1195, 1208, 1208, 1209, 1209, 1279, 1279, 1358, 1358, 509, 996, 996, 996, 996, 1008, 1008, 1008, 1008, 1009, 1009, 1009, 1009, 1098, 1098, 1098, 1098, 1136, 1136, 1136, 1136, 1205, 1205, 1205, 1205, 1228, 1228, 1228, 1228, 2569, 2569, 2569, 2569, 2450, 2450, 2450, 2450, 2481, 2481, 2481, 2481);
+UPDATE `playercreateinfo` SET `npe_map`= NULL, `npe_position_x`= NULL, `npe_position_y`= NULL, `npe_position_z`= NULL, `npe_position_z`= NULL, `npe_transport_guid`= NULL, `intro_movie_id`= NULL, `intro_scene_id`= NULL, `npe_intro_scene_id`= NULL;