diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/cata_classic/2025_04_16_00_world.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/cata_classic/2025_04_16_00_world.sql b/sql/updates/world/cata_classic/2025_04_16_00_world.sql new file mode 100644 index 00000000000..c26e6f2c4c6 --- /dev/null +++ b/sql/updates/world/cata_classic/2025_04_16_00_world.sql @@ -0,0 +1,13 @@ +UPDATE `creature_template` SET `flags_extra`= `flags_extra` & 1614807039; +-- Remove all leftover entries from retail creatures +DELETE FROM `creature_template_addon` WHERE `entry` IN (160273, 160394, 160433, 160578, 160628, 160737, 161006, 161133, 161265, 162817, 163974, 164123, 164370, 164686, 164803, 164827, 164941, 164945, 164947, 164953, 164955, 164957, 164960, 164962, 165379, 166061, 166163, 166164, 166165, 166166, 166273, 166323, 166854, 166996, 166997, 167008, 167225, 167226, 167886, 168309, 168397, 168624, 168892, 169177, 169572, 170283, 170399, 170557, 171664, 171668, 171791, 172058, 172532, 173118, 173279, 173281, 173300, 173302, 173305, 173325, 173348, 173356, 173365, 173545, 173571, 173819, 174146, 174272, 174575, 174635, 174636, 174666, 174676, 175050, 175051, 175135, 175420, 175732, 176532, 176533, 176554, 177154, 177891, 178081, 178298, 178299, 178355, 178908, 178997, 180803, 181494, 181954, 182082, 182084, 182088, 182599, 182706, 183033, 183452, 183463, 183669, 183671, 183793, 183822, 183857, 183997, 184053, 184088, 184089, 184090, 184094, 184098, 184099, 184100, 184117, 184297, 184493, 184494, 184519, 184585, 184830, 185563, 185749, 186431, 186644, 186737, 186738, 186739, 186962, 187223, 187240, 187246, 188374, 188663, 188690, 188853, 188854, 188855, 188856, 188904, 189602, 189668, 189870, 190221, 190288, 190575, 190609, 190742, 191150, 191610, 191736, 191739, 191932, 191933, 191935, 191936, 192502, 193033, 193223, 193420, 193422, 193428, 193430, 193431, 193509, 193563, 193701, 194602, 194618, 194622, 194650, 194652, 194681, 194685, 194688, 194712, 194713, 194714, 194715, 195432, 195434, 195569, 195638, 196044, 196102, 196205, 196371, 196482, 196947, 196974, 196977, 196978, 196979, 196981, 197081, 197253, 197267, 197269, 197274, 197398, 197406, 197743, 197756, 197979, 198025, 198026, 198146, 198202, 198236, 198482, 198526, 198529, 198530, 198532, 198533, 198883, 198884, 198885, 198886, 198896, 199145, 199340, 199545, 199791, 199809, 200120, 200489, 201093, 202529, 202549, 202656, 202700, 203463, 203596, 204204, 204208, 204929, 205061, 205065, 205067, 205122, 205879, 207353, 211031, 215103, 215104, 215105, 216439); +-- Empty the creature_quest_currency table. None of the data is used in Classic +DELETE FROM `creature_quest_currency`; +-- Remove non-existing quests from quest starters/enders +DELETE FROM `gameobject_queststarter` WHERE `id` IN (180746, 187236, 190049, 206109, 206111, 206116, 206294, 207323, 209673, 209845, 211754, 212181, 212389, 213767, 213973, 214062, 214562, 214871, 214903, 215705, 215844, 215873, 215874, 215875, 215876, 215877, 215879, 215880, 215881, 215884, 215886, 215889, 215891, 215892, 215894, 215895, 215897, 215898, 215899, 215900, 215902, 215903, 215904, 215905, 215906, 215907, 215908, 215914, 215915, 216322, 217851, 217852, 218072, 218750, 218765, 221376, 221413, 224306, 225726, 225778, 226961, 226987, 227069, 227504, 227737, 227806, 229314, 229330, 229331, 229333, 229344, 230303, 230865, 230933, 231100, 231901, 231903, 231918, 232024, 232353, 232397, 232398, 232400, 232405, 232416, 232492, 233099, 233100, 233229, 233263, 233291, 233391, 233956, 234243, 234474, 235129, 236140, 237016, 237021, 237022, 237821, 239120, 239328, 239791, 240317, 240547, 241840, 243392, 243454, 243700, 243836, 243899, 243912, 244453, 244555, 244559, 244651, 244708, 245328, 245688, 245793, 246154, 246250, 246438, 247694, 248398, 248534, 249211, 250383, 250536, 250548, 250990, 251032, 251218, 251220, 251221, 251425, 251571, 251670, 251671, 251672, 251991, 252107, 252232, 252258, 252259, 252260, 252261, 252262, 252263, 252264, 252814, 252815, 252816, 252817, 254010, 258978, 258979, 258980, 259806, 316754, 316755, 401714, 401723, 401724, 401725, 401726, 401727, 401728, 401729, 401730, 401731, 401732, 401733, 401734, 401735, 401736, 401737, 401738, 401739, 401740, 401741, 401742, 401743, 401744, 401745, 401746, 401747, 401748, 401749, 401750, 401751, 401752, 401753, 401754, 401755, 401756, 401757, 405958, 407048); +DELETE FROM `creature_queststarter` WHERE `id` IN (197, 823, 951, 1515, 1750, 2215, 6179, 6774, 6785, 9563, 10305, 11378, 14753, 14754, 15126, 15127, 15295, 15296, 15297, 37172, 37951, 38066, 43929, 47240, 48358, 49748, 53865, 53869); +DELETE FROM `gameobject_questender` WHERE `id` IN (37, 1557, 1585, 1586, 1728, 2289, 2655, 2933, 5619, 61934, 89931, 142071, 148504, 149047, 149502, 164955, 164956, 164957, 174848, 175265, 175924, 175925, 175926, 176192, 176317, 176361, 176392, 176393, 177289, 177544, 179485, 179517, 179551, 180633, 180717, 180746, 181073, 182485, 182796, 182934, 183340, 183341, 183877, 184477, 186267, 187236, 190049, 194655, 195173, 195189, 201575, 202701, 209655, 209784, 209822, 209845, 211316, 213767, 214205, 214206, 214207, 214208, 214209, 214210, 214211, 214212, 214213, 214214, 214217, 214218, 214219, 214220, 214221, 214222, 214223, 214224, 214225, 214226, 215705, 215844, 215872, 215873, 215874, 215875, 215876, 215877, 215879, 215880, 215881, 215884, 215886, 215889, 215891, 215892, 215894, 215895, 215897, 215898, 215899, 215900, 215902, 215903, 215904, 215905, 215906, 215907, 215908, 215914, 215915, 216161, 216162, 216163, 216274, 216452, 216609, 216616, 216837, 217845, 217846, 217847, 217848, 217849, 217850, 217851, 217852, 218077, 218637, 218724, 218765, 218951, 218952, 218953, 218954, 218955, 218956, 218957, 218958, 221413, 223082, 224305, 225726, 226766, 227001, 229220, 230882, 230933, 231183, 231184, 231918, 232353, 232489, 233229, 233263, 233391, 237705, 237790, 239120, 239328, 240317, 240552, 243392, 243402, 243836, 243899, 243912, 244466, 244559, 244923, 245328, 245793, 246438, 246463, 246465, 246466, 246713, 246809, 246884, 246885, 247694, 247704, 248398, 249211, 250383, 250548, 250612, 251218, 251220, 251221, 251670, 251671, 251672, 251870, 251991, 251992, 252107, 252232, 252258, 252259, 252260, 252261, 252262, 252263, 252264, 252814, 252815, 252816, 252817, 252818, 254007, 265435, 316754, 316755, 401714, 401723, 401724, 401725, 401726, 401727, 401728, 401729, 401730, 401731, 401732, 401733, 401734, 401735, 401736, 401737, 401738, 401739, 401740, 401741, 401742, 401743, 401744, 401745, 401746, 401747, 401748, 401749, 401750, 401751, 401752, 401753, 401754, 401755, 401756, 401757, 407048); +DELETE FROM `creature_questender` WHERE `id` IN (19, 197, 239, 263, 264, 267, 268, 273, 294, 295, 344, 469, 661, 823, 912, 916, 928, 951, 1073, 1089, 1093, 1155, 1156, 1217, 1226, 1231, 1309, 1401, 1416, 1422, 1449, 1470, 1497, 1498, 1499, 1500, 1515, 1570, 1661, 1748, 1750, 1855, 1938, 1952, 1992, 2055, 2092, 2104, 2121, 2211, 2228, 2229, 2230, 2263, 2425, 2498, 2500, 2519, 2530, 2542, 2594, 2610, 2703, 2706, 2784, 2787, 2789, 2792, 2817, 2916, 2918, 2920, 2921, 2981, 2991, 3007, 3033, 3065, 3140, 3171, 3189, 3230, 3387, 3391, 3401, 3402, 3430, 3446, 3484, 3515, 3516, 3520, 3600, 3601, 3616, 3690, 3706, 3838, 3848, 3936, 3978, 4047, 4077, 4079, 4080, 4200, 4214, 4217, 4311, 4449, 4450, 4452, 4454, 4485, 4488, 4489, 4495, 4496, 4500, 4501, 4563, 4576, 4630, 4709, 4732, 4752, 4753, 4772, 4773, 4787, 4895, 4926, 4944, 4948, 4949, 4961, 4963, 4968, 5059, 5087, 5088, 5165, 5173, 5204, 5386, 5387, 5413, 5414, 5416, 5418, 5476, 5496, 5592, 5593, 5594, 5597, 5641, 5667, 5675, 5765, 5767, 5769, 5770, 5875, 5878, 5888, 5891, 5895, 5900, 5901, 5907, 5909, 6018, 6031, 6089, 6090, 6134, 6142, 6169, 6171, 6175, 6176, 6178, 6179, 6236, 6266, 6294, 6408, 6410, 6411, 6446, 6467, 6522, 6546, 6566, 6586, 6740, 6768, 6826, 6868, 6946, 6986, 6987, 7010, 7207, 7363, 7406, 7408, 7505, 7506, 7564, 7572, 7643, 7683, 7740, 7750, 7763, 7764, 7773, 7775, 7783, 7794, 7802, 7804, 7825, 7852, 7854, 7870, 7871, 7875, 7877, 7878, 7879, 7880, 7884, 7907, 7944, 7953, 7954, 7956, 7999, 8021, 8022, 8115, 8125, 8126, 8256, 8379, 8390, 8393, 8395, 8403, 8418, 8479, 8509, 8517, 8579, 8583, 8586, 8588, 8737, 8738, 9020, 9077, 9078, 9080, 9087, 9116, 9117, 9118, 9119, 9270, 9273, 9274, 9298, 9516, 9536, 9560, 9563, 9618, 9659, 9660, 9686, 10051, 10118, 10181, 10182, 10219, 10301, 10303, 10304, 10305, 10306, 10307, 10445, 10637, 10667, 10684, 10837, 10838, 10839, 10840, 10856, 10857, 10917, 10918, 10920, 10929, 11034, 11035, 11036, 11039, 11053, 11055, 11056, 11057, 11079, 11191, 11216, 11378, 11536, 11554, 11556, 11615, 11701, 11801, 11811, 11832, 11834, 11872, 11878, 11898, 11939, 12481, 12696, 12724, 12736, 12862, 12863, 13085, 13154, 13220, 13320, 13417, 13447, 13448, 13840, 13841, 14182, 14183, 14185, 14186, 14187, 14188, 14305, 14322, 14325, 14338, 14347, 14368, 14381, 14387, 14437, 14444, 14463, 14470, 14494, 14508, 14524, 14567, 14624, 14625, 14720, 14733, 14736, 14739, 14742, 14753, 14754, 14781, 14822, 14829, 14833, 14841, 14844, 14845, 14847, 14875, 14885, 14984, 15022, 15077, 15079, 15123, 15126, 15127, 15174, 15176, 15180, 15181, 15182, 15183, 15191, 15192, 15282, 15295, 15296, 15297, 15306, 15395, 15399, 15400, 15401, 15403, 15440, 15443, 15444, 15458, 15539, 15540, 15608, 15610, 15612, 15613, 15693, 15991, 16004, 16012, 16013, 16014, 16016, 16031, 16032, 16033, 16073, 16089, 16108, 16109, 16112, 16113, 16115, 16116, 16131, 16132, 16133, 16134, 16135, 16204, 16212, 16268, 16280, 16283, 16361, 16376, 16388, 16478, 16535, 16575, 16576, 16584, 16669, 16684, 16756, 16786, 16787, 16796, 16802, 16819, 16820, 16823, 16832, 16848, 16858, 16888, 16915, 17002, 17006, 17068, 17069, 17070, 17071, 17072, 17076, 17087, 17089, 17204, 17212, 17224, 17240, 17415, 17433, 17435, 17509, 17614, 17675, 17703, 17717, 17718, 17807, 17841, 17856, 17900, 18090, 18098, 18141, 18248, 18252, 18266, 18267, 18383, 18386, 18389, 18390, 18408, 18442, 18443, 18446, 18448, 18481, 18675, 19227, 19265, 19266, 19273, 19310, 19332, 19466, 19569, 19570, 19728, 19860, 19935, 20067, 20201, 20793, 20914, 21006, 21007, 21183, 21460, 21984, 22004, 22127, 22278, 22421, 22832, 22834, 22837, 22924, 22981, 23300, 23338, 23559, 23599, 23761, 23858, 23891, 23897, 23905, 24470, 24537, 24643, 24710, 24711, 24848, 25169, 25223, 25917, 26187, 26471, 26653, 26673, 26860, 26875, 26935, 27102, 27987, 28048, 28266, 28510, 28518, 28703, 28705, 28746, 29156, 29611, 30464, 31412, 32430, 32725, 32971, 33091, 33256, 33258, 33260, 33261, 33801, 33817, 33834, 34341, 34402, 34434, 34570, 34571, 34598, 34674, 34695, 34722, 34745, 34874, 34936, 34990, 34991, 35068, 35081, 35187, 35786, 35817, 36132, 36273, 36335, 36458, 36515, 36517, 36567, 36642, 36644, 36648, 36699, 36700, 36702, 36703, 36704, 36705, 36799, 37019, 37106, 37172, 37812, 37817, 38066, 38243, 38316, 38380, 38441, 38443, 38647, 38738, 38927, 38966, 39055, 39063, 39100, 39116, 39150, 39178, 39180, 39181, 39199, 39283, 39448, 39508, 39605, 39827, 39858, 39884, 40060, 40098, 40105, 40243, 40289, 40475, 40487, 40644, 40712, 40916, 40917, 40920, 41018, 41172, 41209, 41210, 41239, 41252, 41263, 41662, 41663, 42317, 42465, 42470, 42573, 42624, 43169, 43769, 43806, 43929, 44009, 44033, 44204, 44217, 44415, 44919, 45320, 45702, 45712, 46234, 46936, 47240, 47605, 47670, 47684, 48053, 48218, 48358, 48431, 48513, 48998, 49336, 49442, 49622, 49810, 51615, 51616, 51733, 51734, 51735, 51750, 52489, 52684, 52921, 53009, 54603, 54606, 54629, 54636, 54675, 54725); +-- Delete non-existing quest greetings +DELETE FROM `quest_greeting` WHERE `ID` IN (238, 265, 1254, 1267, 1343, 1344, 1356, 1377, 1499, 1518, 1719, 1748, 1776, 1977, 2076, 2080, 2086, 2092, 2094, 2121, 2215, 2263, 2276, 2497, 2700, 2713, 2785, 2786, 2860, 2910, 2920, 2921, 3139, 3143, 3188, 3287, 3337, 3338, 3339, 3390, 3391, 3419, 3453, 3567, 3663, 3666, 3847, 3995, 4049, 4078, 4080, 4454, 4456, 4500, 4630, 4791, 4792, 4794, 5393, 5394, 5396, 5591, 5767, 5770, 6179, 6579, 6986, 7777, 9078, 10260, 16361, 16478, 16786, 16788, 18183, 19309, 23572, 24139, 31082, 34675, 35094, 36644, 37024, 40109, 43738, 45315, 45474, 45878, 48062, 48069, 48070, 48071, 48333, 48339, 48349, 48358, 48360, 48361, 48363, 48459, 49243, 50048, 72976, 73097, 74163, 74223, 75119, 75121, 75127, 75177, 75389, 75392, 75896, 75913, 76609, 76665, 77167, 77928, 78323, 79047, 79281, 79393, 79618, 79627, 79978, 79979, 80001, 80157, 80193, 80389, 80390, 80508, 80553, 80648, 80856, 81076, 81144, 81202, 81361, 81588, 81601, 82126, 82274, 82334, 82569, 82574, 82575, 82610, 82713, 82786, 83773, 84131, 85130, 85601, 86355, 87391, 96705, 109734, 114310, 129876, 156384, 156499, 157113, 157696, 157710, 158422, 159513, 159638, 159639, 159694, 159894, 160439, 160749, 160757, 160959, 161208, 161378, 161421, 161436, 161446, 161474, 161572, 163427, 163576, 164679, 164741, 165397, 165918, 166616, 166723, 166981, 167196, 167291, 167535, 167827, 167833, 167880, 168217, 168381, 168455, 168893, 169359, 169686, 169748, 169772, 169868, 170467, 171001, 172653, 173422, 174922, 177459, 177924, 177928, 178228, 178647, 178829, 178908, 181193, 181266, 181771, 183139, 184062, 184323, 184537, 185853, 185870, 186184, 186228, 186305, 186420, 186618, 186640, 186649, 186688, 186779, 187129, 190180, 191753, 191810, 191895, 192543, 194772, 196416, 196432, 196499, 196566, 196812, 197627, 206585, 232400, 233099, 233100, 287189); +DELETE FROM `quest_greeting_locale` WHERE `ID` IN (238, 265, 1254, 1267, 1343, 1344, 1356, 1377, 1499, 1518, 1719, 1748, 1776, 1977, 2076, 2080, 2086, 2092, 2094, 2121, 2215, 2263, 2276, 2497, 2700, 2713, 2785, 2786, 2860, 2910, 2920, 2921, 3139, 3143, 3188, 3287, 3337, 3338, 3339, 3390, 3391, 3419, 3453, 3567, 3663, 3666, 3847, 3995, 4049, 4078, 4080, 4454, 4456, 4500, 4630, 4791, 4792, 4794, 5393, 5394, 5396, 5591, 5767, 5770, 6179, 6579, 6986, 7777, 9078, 10260, 16361, 16478, 16786, 16788, 18183, 19309, 23572, 24139, 31082, 34675, 35094, 36644, 37024, 40109, 43738, 45315, 45474, 45878, 48062, 48069, 48070, 48071, 48333, 48339, 48349, 48358, 48360, 48361, 48363, 48459, 49243, 50048, 72976, 73097, 74163, 74223, 75119, 75121, 75127, 75177, 75389, 75392, 75896, 75913, 76609, 76665, 77167, 77928, 78323, 79047, 79281, 79393, 79618, 79627, 79978, 79979, 80001, 80157, 80193, 80389, 80390, 80508, 80553, 80648, 80856, 81076, 81144, 81202, 81361, 81588, 81601, 82126, 82274, 82334, 82569, 82574, 82575, 82610, 82713, 82786, 83773, 84131, 85130, 85601, 86355, 87391, 96705, 109734, 114310, 129876, 156384, 156499, 157113, 157696, 157710, 158422, 159513, 159638, 159639, 159694, 159894, 160439, 160749, 160757, 160959, 161208, 161378, 161421, 161436, 161446, 161474, 161572, 163427, 163576, 164679, 164741, 165397, 165918, 166616, 166723, 166981, 167196, 167291, 167535, 167827, 167833, 167880, 168217, 168381, 168455, 168893, 169359, 169686, 169748, 169772, 169868, 170467, 171001, 172653, 173422, 174922, 177459, 177924, 177928, 178228, 178647, 178829, 178908, 181193, 181266, 181771, 183139, 184062, 184323, 184537, 185853, 185870, 186184, 186228, 186305, 186420, 186618, 186640, 186649, 186688, 186779, 187129, 190180, 191753, 191810, 191895, 192543, 194772, 196416, 196432, 196499, 196566, 196812, 197627, 206585, 232400, 233099, 233100, 287189); |