diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2019_07_24_00_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/master/2019_07_24_00_world.sql b/sql/updates/world/master/2019_07_24_00_world.sql new file mode 100644 index 00000000000..125ce27f162 --- /dev/null +++ b/sql/updates/world/master/2019_07_24_00_world.sql @@ -0,0 +1,8 @@ +-- +DELETE FROM `creature` WHERE `guid` IN (355791, 355721, 355707, 354501, 351854, 351852, 351848, 353440, 353438, 353496, 353494, 353513, 353507, 353503, 353476, 350438, 353479, 355072, 350439, 350432, 354478, 354475, 354476, 354453, 354521, 354420, 354599, 354589, 354584, 354516, 354517, 354543, 354542, 354556, 354607, 354608, 350205, 350222, 350187, 350190, 350221, 350186, 350215, 350188, 350343, 350198, 350212, 350344, 350195, 351954, 350214, 350211, 350108, 350218, 350324, 350327, 350325, 350208, 350223, 351955, 350220, 350224, 354454, 354474, 350726, 354207, 354994, 354150, 350723, 356652, 356731, 356655, 356733, 356749, 356450, 356536, 356780, 356446, 356725, 356441, 356703, 356746, 350623, 354197, 350647, 350626, 354199, 354144, 350680, 350672, 354149, 350711, 354645, 354206, 350732, 350719, 354643, 354164, 354161, 350730, 350716, 354252, 350553, 350739, 354647, 354166, 354650, 354163, 350736, 350759, 356616, 356753, 356470, 356474, 356728, 356745, 356705, 356744, 356706, 356843, 350628, 354132, 350673, 350699, 354157, 354147, 350702, 350717, 354201, 354999, 354249, 350554, 350555, 355000, 354250, 350721, 350725, 354652, 354247, 354995, 354248, 350549, 350740, 354208, 354151, 350733, 350737, 354655, 354167, 354253, 350749, 350745, 354654, 354169, 354630, 350543, 350754, 354629, 356532, 350742, 354658, 354648, 354158, 356761, 350617, 350639, 354137, 350642, 350663, 354136, 354145, 354142, 350648, 354141, 350669, 354200, 350624, 350715, 354202, 354196, 350622, 350646, 354198, 350625, 350679, 354143, 354148, 350671, 350710, 350731, 354644, 354205, 354642, 354152, 350718, 350720, 354159, 350727, 350552, 354251, 354646, 354165, 350738, 350735, 354649, 354162, 350758, 353481, 352026, 352162, 352154, 352159, 355472, 350784, 352282, 352382, 352376, 352437, 352833, 352833, 352828, 352828, 352821, 352821, 353042, 352334, 352608, 352291, 352372, 352774, 352773, 352832, 352832, 352829, 352829, 353037, 352351, 352310, 355798, 356076, 356064, 355729, 355720, 355716, 355714, 355712, 355732, 355744, 355772, 352610, 355858, 356018, 356019, 356020, 356321, 355998, 355996, 356319, 355970, 355961, 356371, 356313, 356377, 355954, 356343, 356322, 356361, 356028, 356030, 356342, 356331, 356001, 356006, 356014, 356334, 356336, 355993, 356333, 356335, 352791, 353084, 353528, 353531, 353531, 353248, 353248, 353119, 353525, 353525, 353176, 353176, 353129, 353129, 353069, 353069, 353342, 353541, 353541, 353087, 353087, 353155, 353155, 353539, 353083, 353159, 353159, 353100, 353100, 353137, 353137, 352996, 352996, 353134, 353134, 353124, 353124, 352959, 352959, 353142, 352974, 352974, 353077, 353526, 353526, 353173, 353173, 352958, 353189, 353196, 353178, 353178, 353169, 353169, 353540, 353540, 353078, 353078, 353163, 352768, 352861, 352929, 352858, 352870, 353514, 352880, 352931, 352875, 353112, 353005, 353518, 353318, 353186, 353123, 352975, 353198, 353160, 353177, 353177, 353131, 353131, 353089, 353089, 353330, 353080, 353338, 353188, 353158, 353097, 353141, 353141, 353113, 353113, 353075, 353075, 353549, 353549, 353345, 353345, 353538, 353190, 353104, 353341, 353179, 353174, 353125, 353108, 353092, 353172, 353114, 353319, 353185, 353122, 353071, 353329, 353329, 353197, 353197, 353165, 353165, 353139, 353139, 353105, 353105, 353074, 353074, 353181, 353120, 353766, 353536, 353344, 353184, 353164, 353127, 353085, 353547, 353547, 353182, 353182, 353187, 353156, 353138, 353115, 353098, 352977, 353759, 353759, 353519, 353519, 353091, 353091, 353523, 353324, 353210, 353146, 353193, 353193, 353171, 353171, 353150, 353150, 353107, 353107, 353093, 353093, 353157, 353136, 353095, 353777, 353524, 353200, 353167, 353088, 353110, 353548, 353548, 353166, 353166, 353130, 353130, 353103, 353103, 353320, 353199, 353183, 353161, 353111, 353072, 352957, 353321, 353321, 353133, 353133, 353094, 353094, 353079, 353079, 353175, 353140, 353118, 353086, 353773, 353116, 353099, 353343, 353147, 353101, 353194, 352987, 353121, 353073, 353780, 353106, 353076, 353170, 353109, 353090, 353527, 353527, 353135, 353135, 353126, 353126, 353081, 353081, 352976, 352976, 353764, 353132, 353132, 353102, 351408, 354301, 353220, 353206, 353231, 353218, 353224, 351265, 351259, 351255, 351258, 353215, 353203, 353228, 353208, 353211, 353271, 353621, 353615, 353698, 356471, 356730, 356653, 356732, 356750, 356559, 356553, 356511, 356543, 356541, 356519, 356548, 356518, 356552, 356517, 356546, 356523, 356514, 356530, 356512, 356535, 356531, 356516, 356522, 356515, 356513, 351407, 354303, 354304, 351410, 351413, 351409, 354302, 354299, 351411, 351417, 351429, 351423, 351426, 351430, 351425, 351431, 356045, 351446, 356416, 356904, 357136, 356915, 357125, 357165, 356909, 357116, 357172, 356913, 356911, 357135, 357166, 356903, 357137, 357173, 357132, 357154, 357040, 357046, 357108, 357110, 356998, 357124, 357123, 357020, 357127, 357017, 357129, 356943, 356948, 356932, 356910, 356907, 356908, 357134, 357168, 356899, 357109, 357115, 357113, 357122, 357133, 357128, 357126, 357016, 357151, 357032, 356912, 357139, 357018, 350799, 351208, 354265, 354264, 351209, 350802, 354261, 351213, 351211, 354260, 351214, 357121, 357118, 351747, 351761, 351762, 350236, 351610, 351671, 350239, 350232, 350199, 350341, 350250, 351094, 354338, 353661, 353663, 355198, 353672, 353664, 355202, 353677, 353676, 353700, 353679, 353668, 353670, 353674, 353678, 353683, 355206, 353702, 353682, 353701, 353680, 353703, 353706, 351216, 354371, 350101, 354110, 354241, 354118, 354240, 354125, 354188, 354189, 354127, 354121, 354185, 354123, 354235, 354126, 354184, 354231, 354128, 354138); + +DELETE FROM `creature_addon` WHERE `guid` IN (355791, 355721, 355707, 354501, 351854, 351852, 351848, 353440, 353438, 353496, 353494, 353513, 353507, 353503, 353476, 350438, 353479, 355072, 350439, 350432, 354478, 354475, 354476, 354453, 354521, 354420, 354599, 354589, 354584, 354516, 354517, 354543, 354542, 354556, 354607, 354608, 350205, 350222, 350187, 350190, 350221, 350186, 350215, 350188, 350343, 350198, 350212, 350344, 350195, 351954, 350214, 350211, 350108, 350218, 350324, 350327, 350325, 350208, 350223, 351955, 350220, 350224, 354454, 354474, 350726, 354207, 354994, 354150, 350723, 356652, 356731, 356655, 356733, 356749, 356450, 356536, 356780, 356446, 356725, 356441, 356703, 356746, 350623, 354197, 350647, 350626, 354199, 354144, 350680, 350672, 354149, 350711, 354645, 354206, 350732, 350719, 354643, 354164, 354161, 350730, 350716, 354252, 350553, 350739, 354647, 354166, 354650, 354163, 350736, 350759, 356616, 356753, 356470, 356474, 356728, 356745, 356705, 356744, 356706, 356843, 350628, 354132, 350673, 350699, 354157, 354147, 350702, 350717, 354201, 354999, 354249, 350554, 350555, 355000, 354250, 350721, 350725, 354652, 354247, 354995, 354248, 350549, 350740, 354208, 354151, 350733, 350737, 354655, 354167, 354253, 350749, 350745, 354654, 354169, 354630, 350543, 350754, 354629, 356532, 350742, 354658, 354648, 354158, 356761, 350617, 350639, 354137, 350642, 350663, 354136, 354145, 354142, 350648, 354141, 350669, 354200, 350624, 350715, 354202, 354196, 350622, 350646, 354198, 350625, 350679, 354143, 354148, 350671, 350710, 350731, 354644, 354205, 354642, 354152, 350718, 350720, 354159, 350727, 350552, 354251, 354646, 354165, 350738, 350735, 354649, 354162, 350758, 353481, 352026, 352162, 352154, 352159, 355472, 350784, 352282, 352382, 352376, 352437, 352833, 352833, 352828, 352828, 352821, 352821, 353042, 352334, 352608, 352291, 352372, 352774, 352773, 352832, 352832, 352829, 352829, 353037, 352351, 352310, 355798, 356076, 356064, 355729, 355720, 355716, 355714, 355712, 355732, 355744, 355772, 352610, 355858, 356018, 356019, 356020, 356321, 355998, 355996, 356319, 355970, 355961, 356371, 356313, 356377, 355954, 356343, 356322, 356361, 356028, 356030, 356342, 356331, 356001, 356006, 356014, 356334, 356336, 355993, 356333, 356335, 352791, 353084, 353528, 353531, 353531, 353248, 353248, 353119, 353525, 353525, 353176, 353176, 353129, 353129, 353069, 353069, 353342, 353541, 353541, 353087, 353087, 353155, 353155, 353539, 353083, 353159, 353159, 353100, 353100, 353137, 353137, 352996, 352996, 353134, 353134, 353124, 353124, 352959, 352959, 353142, 352974, 352974, 353077, 353526, 353526, 353173, 353173, 352958, 353189, 353196, 353178, 353178, 353169, 353169, 353540, 353540, 353078, 353078, 353163, 352768, 352861, 352929, 352858, 352870, 353514, 352880, 352931, 352875, 353112, 353005, 353518, 353318, 353186, 353123, 352975, 353198, 353160, 353177, 353177, 353131, 353131, 353089, 353089, 353330, 353080, 353338, 353188, 353158, 353097, 353141, 353141, 353113, 353113, 353075, 353075, 353549, 353549, 353345, 353345, 353538, 353190, 353104, 353341, 353179, 353174, 353125, 353108, 353092, 353172, 353114, 353319, 353185, 353122, 353071, 353329, 353329, 353197, 353197, 353165, 353165, 353139, 353139, 353105, 353105, 353074, 353074, 353181, 353120, 353766, 353536, 353344, 353184, 353164, 353127, 353085, 353547, 353547, 353182, 353182, 353187, 353156, 353138, 353115, 353098, 352977, 353759, 353759, 353519, 353519, 353091, 353091, 353523, 353324, 353210, 353146, 353193, 353193, 353171, 353171, 353150, 353150, 353107, 353107, 353093, 353093, 353157, 353136, 353095, 353777, 353524, 353200, 353167, 353088, 353110, 353548, 353548, 353166, 353166, 353130, 353130, 353103, 353103, 353320, 353199, 353183, 353161, 353111, 353072, 352957, 353321, 353321, 353133, 353133, 353094, 353094, 353079, 353079, 353175, 353140, 353118, 353086, 353773, 353116, 353099, 353343, 353147, 353101, 353194, 352987, 353121, 353073, 353780, 353106, 353076, 353170, 353109, 353090, 353527, 353527, 353135, 353135, 353126, 353126, 353081, 353081, 352976, 352976, 353764, 353132, 353132, 353102, 351408, 354301, 353220, 353206, 353231, 353218, 353224, 351265, 351259, 351255, 351258, 353215, 353203, 353228, 353208, 353211, 353271, 353621, 353615, 353698, 356471, 356730, 356653, 356732, 356750, 356559, 356553, 356511, 356543, 356541, 356519, 356548, 356518, 356552, 356517, 356546, 356523, 356514, 356530, 356512, 356535, 356531, 356516, 356522, 356515, 356513, 351407, 354303, 354304, 351410, 351413, 351409, 354302, 354299, 351411, 351417, 351429, 351423, 351426, 351430, 351425, 351431, 356045, 351446, 356416, 356904, 357136, 356915, 357125, 357165, 356909, 357116, 357172, 356913, 356911, 357135, 357166, 356903, 357137, 357173, 357132, 357154, 357040, 357046, 357108, 357110, 356998, 357124, 357123, 357020, 357127, 357017, 357129, 356943, 356948, 356932, 356910, 356907, 356908, 357134, 357168, 356899, 357109, 357115, 357113, 357122, 357133, 357128, 357126, 357016, 357151, 357032, 356912, 357139, 357018, 350799, 351208, 354265, 354264, 351209, 350802, 354261, 351213, 351211, 354260, 351214, 357121, 357118, 351747, 351761, 351762, 350236, 351610, 351671, 350239, 350232, 350199, 350341, 350250, 351094, 354338, 353661, 353663, 355198, 353672, 353664, 355202, 353677, 353676, 353700, 353679, 353668, 353670, 353674, 353678, 353683, 355206, 353702, 353682, 353701, 353680, 353703, 353706, 351216, 354371, 350101, 354110, 354241, 354118, 354240, 354125, 354188, 354189, 354127, 354121, 354185, 354123, 354235, 354126, 354184, 354231, 354128, 354138); + +DELETE FROM `gameobject` WHERE `guid` IN (223305, 223300, 223304, 223309, 223844, 223278, 223900, 223632, 223663, 223655, 224140, 224136, 224135, 224144, 224138, 224147, 224145, 223322, 223856, 223485, 223854, 223486, 223324, 223853, 223487, 223851, 223488, 223491, 224188, 224187, 223873, 223499, 223876); + +DELETE FROM `gameobject_addon` WHERE `guid` IN (223305, 223300, 223304, 223309, 223844, 223278, 223900, 223632, 223663, 223655, 224140, 224136, 224135, 224144, 224138, 224147, 224145, 223322, 223856, 223485, 223854, 223486, 223324, 223853, 223487, 223851, 223488, 223491, 224188, 224187, 223873, 223499, 223876); |