DB/GameObjects: Deleted no longer valid gameobject templates

1 files changed, 8 insertions, 0 deletions

diff --git a/sql/updates/world/2015_05_09_01_world.sql b/sql/updates/world/2015_05_09_01_world.sql
new file mode 100644
index 00000000000..b3ddc193f24
--- /dev/null
+++ b/sql/updates/world/2015_05_09_01_world.sql
@@ -0,0 +1,8 @@
+UPDATE `gameobject` SET `id`=208246 WHERE `guid`=11765;
+UPDATE `gameobject` SET `id`=208247 WHERE `guid`=11766;
+UPDATE `gameobject` SET `id`=186043 WHERE `id`=186052;
+
+DELETE FROM `gameobject_template` WHERE `entry` IN (37, 38, 59, 167, 249, 251, 254, 337, 711, 1593, 1599, 1631, 1632, 1638, 1720, 1738, 1739, 1752, 1753, 1754, 1755, 1763, 1798, 1803, 1818, 1821, 1828, 1830, 1871, 1888, 1889, 1890, 1896, 1905, 1906, 1912, 1922, 1927, 1930, 1931, 1932, 1935, 1938, 1942, 1965, 1968, 1993, 1994, 1995, 1996, 2003, 2004, 2007, 2008, 2035, 2130, 2148, 2149, 2151, 2188, 2413, 2414, 2572, 2573, 2649, 2650, 2658, 2842, 2848, 2858, 2933, 3085, 3089, 3224, 3239, 3253, 3254, 3265, 3270, 3306, 3638, 3639, 3760, 3761, 3767, 3768, 4004, 4005, 4102, 4103, 6293, 6294, 6295, 6906, 6907, 6908, 9847, 10388, 12144, 12666, 13756, 13952, 15001, 15002, 15003, 15004, 15005, 15885, 16431, 17184, 17188, 17189, 18046, 18084, 18085, 18087, 19000, 19001, 19002, 19003, 19004, 19005, 19006, 19007, 19008, 19009, 19010, 19011, 19012, 19013, 19014, 19026, 19029, 19031, 19032, 19034, 19035, 19036, 19037, 19038, 19039, 19040, 19041, 19042, 19043, 19044, 19045, 19046, 19047, 19048, 19049, 19050, 19051, 19052, 19053, 19054, 19055, 19056, 19057, 19058, 19059, 19060, 19061, 19062, 19063, 19064, 19065, 19066, 19067, 19068, 19069, 19070, 19071, 19072, 19073, 19074, 19075, 19076, 19077, 19078, 19079, 19080, 19081, 19082, 19083, 19084, 19085, 19086, 19087, 19088, 19089, 19090, 19091, 19092, 19093, 19094, 19095, 19096, 19097, 19098, 19099, 19100, 19101, 19102, 19103, 19104, 19105, 19106, 19107, 19108, 19109, 19110, 19111, 19112, 19113, 19114, 19115, 19116, 19117, 19118, 19119, 19120, 19121, 19122, 19123, 19124, 19125, 19126, 19127, 19128, 19129, 19130, 19131, 19132, 19133, 19134, 19135, 19136, 19137, 19138, 19139, 19140, 19141, 19142, 19143, 19144, 19145, 19146, 19147, 19148, 19149, 19150, 19151, 19152, 19153, 19154, 19155, 19156, 19157, 19158, 19159, 19160, 19161, 19162, 19163, 19164, 19165, 19166, 19167, 19168, 19169, 19170, 19171, 19172, 19173, 19174, 19175, 19176, 19177, 19178, 19179, 19180, 19181, 19182, 19183, 19184, 19185, 19186, 19187, 19188, 19189, 19190, 19191, 19192, 19193, 19194, 19195, 19196, 19197, 19198, 19199, 19200, 19201, 19202, 19203, 19204, 19205, 19206, 19207, 19208, 19209, 19210, 19211, 19212, 19213, 19214, 19215, 19216, 19217, 19218, 19219, 19220, 19221, 19222, 19223, 19224, 19225, 19226, 19227, 19228, 19229, 19230, 19231, 19232, 19233, 19234, 19235, 19236, 19237, 19238, 19239, 19240, 19241, 19242, 19243, 19244, 19245, 19246, 19247, 19248, 19249, 19250, 19251, 19252, 19253, 19254, 19255, 19256, 19257, 19258, 19259, 19260, 19261, 19262, 19263, 19264, 19265, 19266, 19267, 19268, 19269, 19270, 19271, 19272, 19273, 19274, 19275, 19276, 19277, 19278, 19279, 19280, 19281, 19282, 19285, 19286, 19287, 19288, 19289, 19290, 19291, 19292, 19293, 19294, 19295, 19296, 19297, 19298, 19299, 19301, 19302, 19303, 19304, 19305, 19306, 19307, 19308, 19309, 19311, 19312, 19313, 19314, 19315, 19316, 19317, 19318, 19319, 19320, 19321, 19322, 19323, 19324, 19325, 19326, 19327, 19328, 19329, 19330, 19331, 19332, 19333, 19334, 19335, 19336, 19337, 19338, 19339, 19340, 19341, 19342, 19343, 19344, 19345, 19346, 19347, 19348, 19349, 19350, 19351, 19352, 19353, 19354, 19355, 19356, 19357, 19358, 19359, 19360, 19361, 19362, 19363, 19364, 19365, 19366, 19367, 19368, 19369, 19370, 19371, 19372, 19374, 19375, 19376, 19377, 19378, 19379, 19380, 19381, 19382, 19383, 19384, 19385, 19386, 19387, 19388, 19389, 19390, 19391, 19392, 19393, 19394, 19395, 19396, 19397, 19398, 19399, 19400, 19401, 19402, 19403, 19404, 19405, 19406, 19407, 19408, 19409, 19410, 19411, 19412, 19413, 19414, 19415, 19416, 19417, 19418, 19419, 19420, 19421, 19422, 19423, 19424, 19425, 19426, 19427, 19428, 19429, 19430, 19431, 19432, 19433, 19434, 19435, 19436, 19437, 19438, 19439, 19440, 19441, 19442, 19443, 19444, 19445, 19446, 19447, 19448, 19449, 19450, 19451, 19452, 19453, 19454, 19455, 19456, 19457, 19458, 19459, 19460, 19461, 19462, 19463, 19464, 19465, 19466, 19467, 19468, 19469, 19470, 19471, 19472, 19473, 19474, 19475, 19476, 19477, 19478, 19479, 19480, 19481, 19482, 19483, 19484, 19485, 19486, 19487, 19488, 19489, 19490, 19491, 19492, 19493, 19494, 19495, 19496, 19497, 19498, 19499, 19500, 19501, 19502, 19503, 19504, 19505, 19506, 19507, 19508, 19509, 19510, 19511, 19512, 19513, 19514, 19515, 19516, 19517, 19518, 19519, 19520, 19521, 19522, 19523, 19524, 19525, 19526, 19527, 19528, 19529, 19530, 19531, 19532, 19533, 19536, 19537, 19577, 19582, 19584, 19588, 19589, 19593, 19604, 19605, 19606, 19607, 19608, 19609, 19610, 19611, 19612, 19613, 19614, 19615, 19616, 19617, 19618, 19619, 19620, 19621, 19622, 19623, 19624, 19625, 19626, 19627, 19628, 19629, 19630, 19631, 19632, 19633, 19634, 19635, 19636, 19637, 19638, 19639, 19640, 19641, 19642, 19643, 19644, 19645, 19646, 19647, 19648, 19649, 19650, 19651, 19652, 19653, 19654, 19655, 19656, 19657, 19658, 19659, 19660, 19661, 19662, 19663, 19664, 19665, 19848, 19849, 19850, 19851, 19852, 19853, 19854, 19855, 19856, 19857, 19858, 19859, 19901, 19902, 20352, 20356, 20811, 20812, 20816, 20817, 20818, 20819, 20820, 20821, 20822, 20823, 20824, 20827, 20850, 20873, 20874, 20875, 20876, 20878, 20879, 20881, 20924, 20926, 20972, 20983, 21015, 21016, 21282, 21511, 21628, 21629, 21630, 21631, 21653, 21654, 21655, 21656, 22205, 22207, 22208, 22249, 22256, 22542, 22618, 22663, 22796, 22797, 22798, 22799, 22800, 22801, 22802, 22808, 22809, 22810, 22816, 22817, 23505, 23880, 23881, 24397, 24493, 24500, 24501, 24502, 24503, 24504, 24505, 24510, 24511, 25334, 25342, 25352, 25355, 25356, 25357, 26480, 26482, 26483, 26485, 26486, 26487, 26488, 26489, 26490, 26491, 26492, 26493, 26497, 26498, 28048, 28049, 28050, 28051, 28052, 28053, 28054, 28055, 28056, 28605, 28606, 28607, 28608, 28609, 28610, 28611, 28612, 28613, 31576, 32056, 32057, 32109, 32110, 32348, 32350, 32351, 32352, 32353, 32354, 32356, 32357, 32359, 32360, 32361, 32362, 32363, 32364, 32365, 32366, 32367, 32368, 32370, 32371, 32372, 32373, 32374, 32375, 32376, 32377, 32378, 32379, 32380, 32381, 32384, 32386, 32388, 32390, 32392, 32393, 32394, 32395, 32396, 32397, 32398, 32399, 32400, 32401, 32402, 32403, 32405, 32406, 32407, 32408, 32409, 32410, 32411, 32412, 32413, 32414, 32417, 32418, 32419, 32420, 32421, 32423, 32428, 32430, 32434, 32436, 32438, 32440, 32595, 32783, 32784, 32785, 32786, 32787, 32788, 32789, 32790, 32791, 32792, 32793, 34357, 34358, 34359, 34361, 34362, 34363, 35572, 35573, 35574, 35575, 35576, 35577, 35578, 35579, 35580, 35581, 35582, 35583, 35584, 35585, 35588, 35589, 36645, 36990, 36991, 36992, 36993, 36994, 36995, 37473, 37474, 37475, 37476, 37477, 37479, 37480, 37481, 37482, 37483, 37484, 37485, 37486, 37487, 37488, 37489, 37490, 37491, 37492, 37493, 38019, 38020, 38021, 38022, 38023, 38024, 38025, 38026, 38027, 40198, 40299, 55616, 56820, 57709, 57710, 57725, 57726, 57727, 57748, 57749, 57750, 57751, 57752, 57753, 59529, 59530, 60394, 61927, 61928, 61952, 61953, 64849, 64850, 67234, 69425, 69431, 70518, 70519, 70520, 70521, 70522, 70523, 70524, 70525, 70526, 70527, 70528, 70530, 70531, 70532, 70533, 70534, 70535, 70536, 70537, 70538, 70539, 70540, 70541, 70542, 70543, 70544, 70545, 70546, 70547, 70548, 70549, 70551, 70552, 70553, 70554, 70555, 70556, 70557, 74077, 74446, 74731, 80024, 82139, 82140, 83763, 88498, 91738, 92098, 94189, 100028, 100035, 101750, 111993, 111994, 111995, 111996, 111998, 112000, 112015, 112023, 112024, 112028, 112068, 112214, 112318, 113540, 113791, 138316, 138317, 138318, 138493, 140106, 140107, 140108, 140211, 140212, 140213, 140357, 140358, 140359, 140360, 140931, 141076, 141077, 141078, 141839, 141840, 141841, 141843, 141845, 141860, 141861, 141971, 142018, 142019, 142020, 142021, 142036, 142071, 142101, 142111, 142119, 142196, 142693, 142708, 142709, 142710, 142711, 142947, 142948, 142958, 142966, 143332, 143987, 143988, 143989, 143990, 144570, 146088, 146089, 146090, 147065, 147078, 147079, 147080, 147536, 147557, 148507, 148890, 148896, 148897, 148907, 148908, 149420, 149480, 149481, 149482, 149483, 150075, 150713, 151286, 151980, 151981, 151982, 151992, 152098, 152324, 152608, 152619, 153113, 153578, 153583, 163313, 164644, 164651, 164699, 164700, 164701, 164702, 164703, 164705, 165557, 169286, 170033, 170034, 170047, 170053, 170054, 170067, 171567, 171568, 171619, 171620, 171621, 171622, 171648, 171649, 171674, 171675, 171676, 171677, 171718, 171719, 171720, 171721, 171757, 171758, 171759, 171760, 171761, 171762, 171763, 172943, 172998, 172999, 173000, 173001, 173002, 173003, 173004, 173005, 173124, 173126, 173201, 173227, 173228, 173229, 173230, 173231, 174797, 174864, 174865, 174866, 174867, 174868, 174869, 174870, 174871, 174946, 174968, 175087, 175226, 175230, 175233, 175320, 175329, 175330, 175331, 175406, 175591, 175592, 175593, 175594, 175595, 175596, 175597, 175598, 175599, 175600, 175601, 175602, 175603, 175604, 175605, 175630, 175631, 175632, 175644, 175645, 175646, 175647, 175648, 175649, 175650, 175651, 175652, 175653, 175654, 175655, 175656, 175657, 175663, 175664, 175665, 175666, 175667, 175668, 175671, 175672, 175674, 175677, 175678, 175864, 175904, 175948, 176004, 176005, 176006, 176007, 176008, 176009, 176010, 176011, 176012, 176013, 176014, 176015, 176016, 176017, 176018, 176019, 176020, 176021, 176022, 176023, 176024, 176025, 176026, 176027, 176028, 176029, 176030, 176031, 176032, 176033, 176034, 176035, 176036, 176037, 176038, 176039, 176040, 176041, 176042, 176043, 176044, 176045, 176046, 176047, 176048, 176049, 176050, 176051, 176052, 176053, 176054, 176055, 176056, 176057, 176058, 176059, 176060, 176061, 176062, 176063, 176064, 176065, 176066, 176067, 176068, 176069, 176070, 176071, 176072, 176073, 176074, 176075, 176076, 176077, 176078, 176079, 176080, 176081, 176082, 176083, 176084, 176085, 176098, 176099, 176100, 176101, 176102, 176103, 176104, 176105, 176106, 176107, 176108, 176109, 176113, 176191, 176197, 176198, 176200, 176204, 176210, 176265, 176282, 176290, 176292, 176293, 176294, 176361, 176364, 176365, 176369, 176370, 176393, 176505, 176632, 176642, 176705, 176786, 176791, 176885, 176886, 176887, 176888, 176889, 176890, 176891, 176892, 176904, 176996, 177084, 177223, 177237, 177238, 177244, 177274, 177289, 177290, 177291, 177364, 177424, 178400, 179147, 179586, 179587, 179588, 179597, 179682, 179846, 179924, 179963, 180245, 180323, 180367, 180526, 180688, 180689, 181099, 181137, 181167, 181229, 181260, 181596, 181639, 182650, 182654, 182655, 182656, 182657, 182658, 182659, 182660, 182666, 182698, 182703, 182707, 182708, 182709, 182710, 182714, 182715, 182718, 182719, 182721, 182722, 182728, 182837, 182838, 182848, 183409, 183445, 184084, 184127, 184128, 184129, 184130, 184131, 184132, 184161, 184171, 184172, 184173, 184174, 184175, 184176, 184177, 184178, 184179, 184180, 184181, 184182, 184183, 184184, 184185, 184186, 184187, 184188, 184189, 184190, 184191, 184192, 184193, 184194, 184195, 184196, 184197, 184198, 184199, 184200, 184201, 184202, 184206, 184207, 184208, 184209, 184210, 184211, 184213, 184214, 184215, 184216, 184217, 184218, 184219, 184220, 184221, 184222, 184223, 184224, 184225, 184226, 184227, 184228, 184247, 184461, 184468, 184524, 184525, 184526, 184527, 184528, 184529, 184599, 184618, 184648, 184649, 184650, 184651, 184733, 184818, 184847, 185433, 185471, 186052, 186132, 186898, 187260, 187366, 188177, 188178, 190000, 190001, 190007, 190008, 190009, 190010, 190011, 190400, 190671, 190682, 191621, 191714, 191715, 191846, 191847, 191848, 191849, 192012, 192013, 192136, 192137, 192138, 192139, 192170, 192387, 192388, 192389, 192391, 192392, 192393, 192394, 192464, 192465, 192466, 192467, 192468, 192489, 192490, 192499, 192500, 192503, 192504, 192505, 192506, 192507, 192508, 192509, 192510, 192511, 192512, 192513, 192514, 192517, 192526, 192527, 192528, 192529, 192530, 192531, 192570, 192571, 192585, 192635, 192663, 192664, 192665, 192666, 192671, 192672, 192673, 192674, 192677, 192678, 192679, 192680, 192681, 192682, 192704, 192705, 192732, 192733, 192775, 192776, 192863, 192864, 192903, 192904, 193010, 193011, 193031, 193032, 193033, 193034, 193035, 193036, 193037, 193039, 193040, 193041, 193042, 193182, 193183, 193210, 193211, 193212, 193213, 193457, 193458, 193459, 193460, 193461, 193462, 193463, 193464, 193465, 193587, 193588, 193600, 193601, 193608, 193609, 194030, 194031, 194235, 194236, 194338, 194339, 194576, 194578, 194579, 194580, 194581, 194582, 194583, 194584, 194585, 194586, 194587, 195477, 195478, 195479, 195480, 195481, 195486, 195592, 195593, 195594, 195595, 195596, 195598, 195624, 195625, 195626, 195627, 195628, 195629, 196391, 196392, 196417, 196467, 196468, 196469, 196470, 200000, 200001, 200292, 200293, 200294, 200295, 201747, 201756, 201762, 201763, 201764, 201765, 201766, 201767, 201849, 201850, 201960, 201961, 201984, 202078, 202209, 202210, 202265, 202266, 202315, 202316, 202317, 202318, 202347, 202348, 202349, 202350, 202698, 202718, 202823, 202825, 202827, 202829, 203433, 203434, 203435, 203436, 203606, 203959, 203960, 203961, 203962, 204051, 204052, 204053, 204054, 204285, 204286, 204287, 204288, 204644, 204648, 204649, 204652, 204653, 204654, 204659, 204660, 204661, 204857, 204858, 204863, 204864, 204963, 204964, 206035, 206036, 206345, 206346, 206347, 206348, 206362, 206363, 206364, 206365, 206438, 206439, 206660, 206661, 206968, 206969, 207339, 207340, 207341, 207342, 207366, 207367, 207368, 207369, 207370, 207371, 207372, 207373, 207746, 207747, 207841, 207842, 207879, 207880, 207895, 207896, 207897, 207898, 207899, 207900, 207976, 207977, 207978, 207979, 207980, 207981, 208349, 208350, 208513, 208514, 208515, 208516, 208517, 208518, 208519, 208520, 208521, 208522, 208523, 208524, 208525, 208526, 208527, 208528, 208532, 208837, 208838, 208922, 208923, 208924, 208925, 209060, 209061, 209062, 209063, 209839, 209840, 209841, 210008, 210009, 210010, 210011, 210012, 210013, 210014, 210077, 210078, 210095, 210096, 210104, 210105, 210114, 210115, 210133, 210134, 210135, 210136, 210170, 210215, 210286, 210312, 210313, 210327, 210328, 210329, 210330, 210331, 210332, 210334, 210335, 210336, 210337, 210338, 210339, 210341, 210342, 210343, 210344, 210345, 210347, 210349, 211016);
+DELETE FROM `gameobject` WHERE `id` IN (37, 38, 59, 167, 249, 251, 254, 337, 711, 1593, 1599, 1631, 1632, 1638, 1720, 1738, 1739, 1752, 1753, 1754, 1755, 1763, 1798, 1803, 1818, 1821, 1828, 1830, 1871, 1888, 1889, 1890, 1896, 1905, 1906, 1912, 1922, 1927, 1930, 1931, 1932, 1935, 1938, 1942, 1965, 1968, 1993, 1994, 1995, 1996, 2003, 2004, 2007, 2008, 2035, 2130, 2148, 2149, 2151, 2188, 2413, 2414, 2572, 2573, 2649, 2650, 2658, 2842, 2848, 2858, 2933, 3085, 3089, 3224, 3239, 3253, 3254, 3265, 3270, 3306, 3638, 3639, 3760, 3761, 3767, 3768, 4004, 4005, 4102, 4103, 6293, 6294, 6295, 6906, 6907, 6908, 9847, 10388, 12144, 12666, 13756, 13952, 15001, 15002, 15003, 15004, 15005, 15885, 16431, 17184, 17188, 17189, 18046, 18084, 18085, 18087, 19000, 19001, 19002, 19003, 19004, 19005, 19006, 19007, 19008, 19009, 19010, 19011, 19012, 19013, 19014, 19026, 19029, 19031, 19032, 19034, 19035, 19036, 19037, 19038, 19039, 19040, 19041, 19042, 19043, 19044, 19045, 19046, 19047, 19048, 19049, 19050, 19051, 19052, 19053, 19054, 19055, 19056, 19057, 19058, 19059, 19060, 19061, 19062, 19063, 19064, 19065, 19066, 19067, 19068, 19069, 19070, 19071, 19072, 19073, 19074, 19075, 19076, 19077, 19078, 19079, 19080, 19081, 19082, 19083, 19084, 19085, 19086, 19087, 19088, 19089, 19090, 19091, 19092, 19093, 19094, 19095, 19096, 19097, 19098, 19099, 19100, 19101, 19102, 19103, 19104, 19105, 19106, 19107, 19108, 19109, 19110, 19111, 19112, 19113, 19114, 19115, 19116, 19117, 19118, 19119, 19120, 19121, 19122, 19123, 19124, 19125, 19126, 19127, 19128, 19129, 19130, 19131, 19132, 19133, 19134, 19135, 19136, 19137, 19138, 19139, 19140, 19141, 19142, 19143, 19144, 19145, 19146, 19147, 19148, 19149, 19150, 19151, 19152, 19153, 19154, 19155, 19156, 19157, 19158, 19159, 19160, 19161, 19162, 19163, 19164, 19165, 19166, 19167, 19168, 19169, 19170, 19171, 19172, 19173, 19174, 19175, 19176, 19177, 19178, 19179, 19180, 19181, 19182, 19183, 19184, 19185, 19186, 19187, 19188, 19189, 19190, 19191, 19192, 19193, 19194, 19195, 19196, 19197, 19198, 19199, 19200, 19201, 19202, 19203, 19204, 19205, 19206, 19207, 19208, 19209, 19210, 19211, 19212, 19213, 19214, 19215, 19216, 19217, 19218, 19219, 19220, 19221, 19222, 19223, 19224, 19225, 19226, 19227, 19228, 19229, 19230, 19231, 19232, 19233, 19234, 19235, 19236, 19237, 19238, 19239, 19240, 19241, 19242, 19243, 19244, 19245, 19246, 19247, 19248, 19249, 19250, 19251, 19252, 19253, 19254, 19255, 19256, 19257, 19258, 19259, 19260, 19261, 19262, 19263, 19264, 19265, 19266, 19267, 19268, 19269, 19270, 19271, 19272, 19273, 19274, 19275, 19276, 19277, 19278, 19279, 19280, 19281, 19282, 19285, 19286, 19287, 19288, 19289, 19290, 19291, 19292, 19293, 19294, 19295, 19296, 19297, 19298, 19299, 19301, 19302, 19303, 19304, 19305, 19306, 19307, 19308, 19309, 19311, 19312, 19313, 19314, 19315, 19316, 19317, 19318, 19319, 19320, 19321, 19322, 19323, 19324, 19325, 19326, 19327, 19328, 19329, 19330, 19331, 19332, 19333, 19334, 19335, 19336, 19337, 19338, 19339, 19340, 19341, 19342, 19343, 19344, 19345, 19346, 19347, 19348, 19349, 19350, 19351, 19352, 19353, 19354, 19355, 19356, 19357, 19358, 19359, 19360, 19361, 19362, 19363, 19364, 19365, 19366, 19367, 19368, 19369, 19370, 19371, 19372, 19374, 19375, 19376, 19377, 19378, 19379, 19380, 19381, 19382, 19383, 19384, 19385, 19386, 19387, 19388, 19389, 19390, 19391, 19392, 19393, 19394, 19395, 19396, 19397, 19398, 19399, 19400, 19401, 19402, 19403, 19404, 19405, 19406, 19407, 19408, 19409, 19410, 19411, 19412, 19413, 19414, 19415, 19416, 19417, 19418, 19419, 19420, 19421, 19422, 19423, 19424, 19425, 19426, 19427, 19428, 19429, 19430, 19431, 19432, 19433, 19434, 19435, 19436, 19437, 19438, 19439, 19440, 19441, 19442, 19443, 19444, 19445, 19446, 19447, 19448, 19449, 19450, 19451, 19452, 19453, 19454, 19455, 19456, 19457, 19458, 19459, 19460, 19461, 19462, 19463, 19464, 19465, 19466, 19467, 19468, 19469, 19470, 19471, 19472, 19473, 19474, 19475, 19476, 19477, 19478, 19479, 19480, 19481, 19482, 19483, 19484, 19485, 19486, 19487, 19488, 19489, 19490, 19491, 19492, 19493, 19494, 19495, 19496, 19497, 19498, 19499, 19500, 19501, 19502, 19503, 19504, 19505, 19506, 19507, 19508, 19509, 19510, 19511, 19512, 19513, 19514, 19515, 19516, 19517, 19518, 19519, 19520, 19521, 19522, 19523, 19524, 19525, 19526, 19527, 19528, 19529, 19530, 19531, 19532, 19533, 19536, 19537, 19577, 19582, 19584, 19588, 19589, 19593, 19604, 19605, 19606, 19607, 19608, 19609, 19610, 19611, 19612, 19613, 19614, 19615, 19616, 19617, 19618, 19619, 19620, 19621, 19622, 19623, 19624, 19625, 19626, 19627, 19628, 19629, 19630, 19631, 19632, 19633, 19634, 19635, 19636, 19637, 19638, 19639, 19640, 19641, 19642, 19643, 19644, 19645, 19646, 19647, 19648, 19649, 19650, 19651, 19652, 19653, 19654, 19655, 19656, 19657, 19658, 19659, 19660, 19661, 19662, 19663, 19664, 19665, 19848, 19849, 19850, 19851, 19852, 19853, 19854, 19855, 19856, 19857, 19858, 19859, 19901, 19902, 20352, 20356, 20811, 20812, 20816, 20817, 20818, 20819, 20820, 20821, 20822, 20823, 20824, 20827, 20850, 20873, 20874, 20875, 20876, 20878, 20879, 20881, 20924, 20926, 20972, 20983, 21015, 21016, 21282, 21511, 21628, 21629, 21630, 21631, 21653, 21654, 21655, 21656, 22205, 22207, 22208, 22249, 22256, 22542, 22618, 22663, 22796, 22797, 22798, 22799, 22800, 22801, 22802, 22808, 22809, 22810, 22816, 22817, 23505, 23880, 23881, 24397, 24493, 24500, 24501, 24502, 24503, 24504, 24505, 24510, 24511, 25334, 25342, 25352, 25355, 25356, 25357, 26480, 26482, 26483, 26485, 26486, 26487, 26488, 26489, 26490, 26491, 26492, 26493, 26497, 26498, 28048, 28049, 28050, 28051, 28052, 28053, 28054, 28055, 28056, 28605, 28606, 28607, 28608, 28609, 28610, 28611, 28612, 28613, 31576, 32056, 32057, 32109, 32110, 32348, 32350, 32351, 32352, 32353, 32354, 32356, 32357, 32359, 32360, 32361, 32362, 32363, 32364, 32365, 32366, 32367, 32368, 32370, 32371, 32372, 32373, 32374, 32375, 32376, 32377, 32378, 32379, 32380, 32381, 32384, 32386, 32388, 32390, 32392, 32393, 32394, 32395, 32396, 32397, 32398, 32399, 32400, 32401, 32402, 32403, 32405, 32406, 32407, 32408, 32409, 32410, 32411, 32412, 32413, 32414, 32417, 32418, 32419, 32420, 32421, 32423, 32428, 32430, 32434, 32436, 32438, 32440, 32595, 32783, 32784, 32785, 32786, 32787, 32788, 32789, 32790, 32791, 32792, 32793, 34357, 34358, 34359, 34361, 34362, 34363, 35572, 35573, 35574, 35575, 35576, 35577, 35578, 35579, 35580, 35581, 35582, 35583, 35584, 35585, 35588, 35589, 36645, 36990, 36991, 36992, 36993, 36994, 36995, 37473, 37474, 37475, 37476, 37477, 37479, 37480, 37481, 37482, 37483, 37484, 37485, 37486, 37487, 37488, 37489, 37490, 37491, 37492, 37493, 38019, 38020, 38021, 38022, 38023, 38024, 38025, 38026, 38027, 40198, 40299, 55616, 56820, 57709, 57710, 57725, 57726, 57727, 57748, 57749, 57750, 57751, 57752, 57753, 59529, 59530, 60394, 61927, 61928, 61952, 61953, 64849, 64850, 67234, 69425, 69431, 70518, 70519, 70520, 70521, 70522, 70523, 70524, 70525, 70526, 70527, 70528, 70530, 70531, 70532, 70533, 70534, 70535, 70536, 70537, 70538, 70539, 70540, 70541, 70542, 70543, 70544, 70545, 70546, 70547, 70548, 70549, 70551, 70552, 70553, 70554, 70555, 70556, 70557, 74077, 74446, 74731, 80024, 82139, 82140, 83763, 88498, 91738, 92098, 94189, 100028, 100035, 101750, 111993, 111994, 111995, 111996, 111998, 112000, 112015, 112023, 112024, 112028, 112068, 112214, 112318, 113540, 113791, 138316, 138317, 138318, 138493, 140106, 140107, 140108, 140211, 140212, 140213, 140357, 140358, 140359, 140360, 140931, 141076, 141077, 141078, 141839, 141840, 141841, 141843, 141845, 141860, 141861, 141971, 142018, 142019, 142020, 142021, 142036, 142071, 142101, 142111, 142119, 142196, 142693, 142708, 142709, 142710, 142711, 142947, 142948, 142958, 142966, 143332, 143987, 143988, 143989, 143990, 144570, 146088, 146089, 146090, 147065, 147078, 147079, 147080, 147536, 147557, 148507, 148890, 148896, 148897, 148907, 148908, 149420, 149480, 149481, 149482, 149483, 150075, 150713, 151286, 151980, 151981, 151982, 151992, 152098, 152324, 152608, 152619, 153113, 153578, 153583, 163313, 164644, 164651, 164699, 164700, 164701, 164702, 164703, 164705, 165557, 169286, 170033, 170034, 170047, 170053, 170054, 170067, 171567, 171568, 171619, 171620, 171621, 171622, 171648, 171649, 171674, 171675, 171676, 171677, 171718, 171719, 171720, 171721, 171757, 171758, 171759, 171760, 171761, 171762, 171763, 172943, 172998, 172999, 173000, 173001, 173002, 173003, 173004, 173005, 173124, 173126, 173201, 173227, 173228, 173229, 173230, 173231, 174797, 174864, 174865, 174866, 174867, 174868, 174869, 174870, 174871, 174946, 174968, 175087, 175226, 175230, 175233, 175320, 175329, 175330, 175331, 175406, 175591, 175592, 175593, 175594, 175595, 175596, 175597, 175598, 175599, 175600, 175601, 175602, 175603, 175604, 175605, 175630, 175631, 175632, 175644, 175645, 175646, 175647, 175648, 175649, 175650, 175651, 175652, 175653, 175654, 175655, 175656, 175657, 175663, 175664, 175665, 175666, 175667, 175668, 175671, 175672, 175674, 175677, 175678, 175864, 175904, 175948, 176004, 176005, 176006, 176007, 176008, 176009, 176010, 176011, 176012, 176013, 176014, 176015, 176016, 176017, 176018, 176019, 176020, 176021, 176022, 176023, 176024, 176025, 176026, 176027, 176028, 176029, 176030, 176031, 176032, 176033, 176034, 176035, 176036, 176037, 176038, 176039, 176040, 176041, 176042, 176043, 176044, 176045, 176046, 176047, 176048, 176049, 176050, 176051, 176052, 176053, 176054, 176055, 176056, 176057, 176058, 176059, 176060, 176061, 176062, 176063, 176064, 176065, 176066, 176067, 176068, 176069, 176070, 176071, 176072, 176073, 176074, 176075, 176076, 176077, 176078, 176079, 176080, 176081, 176082, 176083, 176084, 176085, 176098, 176099, 176100, 176101, 176102, 176103, 176104, 176105, 176106, 176107, 176108, 176109, 176113, 176191, 176197, 176198, 176200, 176204, 176210, 176265, 176282, 176290, 176292, 176293, 176294, 176361, 176364, 176365, 176369, 176370, 176393, 176505, 176632, 176642, 176705, 176786, 176791, 176885, 176886, 176887, 176888, 176889, 176890, 176891, 176892, 176904, 176996, 177084, 177223, 177237, 177238, 177244, 177274, 177289, 177290, 177291, 177364, 177424, 178400, 179147, 179586, 179587, 179588, 179597, 179682, 179846, 179924, 179963, 180245, 180323, 180367, 180526, 180688, 180689, 181099, 181137, 181167, 181229, 181260, 181596, 181639, 182650, 182654, 182655, 182656, 182657, 182658, 182659, 182660, 182666, 182698, 182703, 182707, 182708, 182709, 182710, 182714, 182715, 182718, 182719, 182721, 182722, 182728, 182837, 182838, 182848, 183409, 183445, 184084, 184127, 184128, 184129, 184130, 184131, 184132, 184161, 184171, 184172, 184173, 184174, 184175, 184176, 184177, 184178, 184179, 184180, 184181, 184182, 184183, 184184, 184185, 184186, 184187, 184188, 184189, 184190, 184191, 184192, 184193, 184194, 184195, 184196, 184197, 184198, 184199, 184200, 184201, 184202, 184206, 184207, 184208, 184209, 184210, 184211, 184213, 184214, 184215, 184216, 184217, 184218, 184219, 184220, 184221, 184222, 184223, 184224, 184225, 184226, 184227, 184228, 184247, 184461, 184468, 184524, 184525, 184526, 184527, 184528, 184529, 184599, 184618, 184648, 184649, 184650, 184651, 184733, 184818, 184847, 185433, 185471, 186052, 186132, 186898, 187260, 187366, 188177, 188178, 190000, 190001, 190007, 190008, 190009, 190010, 190011, 190400, 190671, 190682, 191621, 191714, 191715, 191846, 191847, 191848, 191849, 192012, 192013, 192136, 192137, 192138, 192139, 192170, 192387, 192388, 192389, 192391, 192392, 192393, 192394, 192464, 192465, 192466, 192467, 192468, 192489, 192490, 192499, 192500, 192503, 192504, 192505, 192506, 192507, 192508, 192509, 192510, 192511, 192512, 192513, 192514, 192517, 192526, 192527, 192528, 192529, 192530, 192531, 192570, 192571, 192585, 192635, 192663, 192664, 192665, 192666, 192671, 192672, 192673, 192674, 192677, 192678, 192679, 192680, 192681, 192682, 192704, 192705, 192732, 192733, 192775, 192776, 192863, 192864, 192903, 192904, 193010, 193011, 193031, 193032, 193033, 193034, 193035, 193036, 193037, 193039, 193040, 193041, 193042, 193182, 193183, 193210, 193211, 193212, 193213, 193457, 193458, 193459, 193460, 193461, 193462, 193463, 193464, 193465, 193587, 193588, 193600, 193601, 193608, 193609, 194030, 194031, 194235, 194236, 194338, 194339, 194576, 194578, 194579, 194580, 194581, 194582, 194583, 194584, 194585, 194586, 194587, 195477, 195478, 195479, 195480, 195481, 195486, 195592, 195593, 195594, 195595, 195596, 195598, 195624, 195625, 195626, 195627, 195628, 195629, 196391, 196392, 196417, 196467, 196468, 196469, 196470, 200000, 200001, 200292, 200293, 200294, 200295, 201747, 201756, 201762, 201763, 201764, 201765, 201766, 201767, 201849, 201850, 201960, 201961, 201984, 202078, 202209, 202210, 202265, 202266, 202315, 202316, 202317, 202318, 202347, 202348, 202349, 202350, 202698, 202718, 202823, 202825, 202827, 202829, 203433, 203434, 203435, 203436, 203606, 203959, 203960, 203961, 203962, 204051, 204052, 204053, 204054, 204285, 204286, 204287, 204288, 204644, 204648, 204649, 204652, 204653, 204654, 204659, 204660, 204661, 204857, 204858, 204863, 204864, 204963, 204964, 206035, 206036, 206345, 206346, 206347, 206348, 206362, 206363, 206364, 206365, 206438, 206439, 206660, 206661, 206968, 206969, 207339, 207340, 207341, 207342, 207366, 207367, 207368, 207369, 207370, 207371, 207372, 207373, 207746, 207747, 207841, 207842, 207879, 207880, 207895, 207896, 207897, 207898, 207899, 207900, 207976, 207977, 207978, 207979, 207980, 207981, 208349, 208350, 208513, 208514, 208515, 208516, 208517, 208518, 208519, 208520, 208521, 208522, 208523, 208524, 208525, 208526, 208527, 208528, 208532, 208837, 208838, 208922, 208923, 208924, 208925, 209060, 209061, 209062, 209063, 209839, 209840, 209841, 210008, 210009, 210010, 210011, 210012, 210013, 210014, 210077, 210078, 210095, 210096, 210104, 210105, 210114, 210115, 210133, 210134, 210135, 210136, 210170, 210215, 210286, 210312, 210313, 210327, 210328, 210329, 210330, 210331, 210332, 210334, 210335, 210336, 210337, 210338, 210339, 210341, 210342, 210343, 210344, 210345, 210347, 210349, 211016);
+
+DELETE FROM `smart_scripts` WHERE `entryorguid`=2933 AND `source_type`=1;