mirror of
https://github.com/araxiaonline/AscEmu.git
synced 2026-06-13 03:02:22 -04:00
d80fa7402f
Remove/Update duplicate go spawns from db Update go commands to reflect the origine of a spawn
169 lines
14 KiB
SQL
169 lines
14 KiB
SQL
-- Update min_build for duplicate spawns
|
|
|
|
UPDATE gameobject_spawns SET min_build = 8606 WHERE id IN(13743,491,1822,2224,5341,4973,4967,34846,71664,34857,6613,10410,10356,10357,9851,9838,9873,9872,9853,10317,10251,10278,10618,10616,10617,10621,10622,10625,10433,10428,10444,10523,10827,13802,13803,30834,14342,14341,14337,49709,17503,45368,45357,45358,45359,45372,45360,45361,45370,45362,45375,50015,45354,45347,45369,45348,45349,45355,45350,45351,45374,45366,45365,45352,45353,45338,45339,45340,45364,45377,45356,45341,45367,45342,45363,45376,45343,45373,45344,45345,45371,45346,18803,18804,18805,18807,45510,20458,20459,29753,20688,20700,20694,20706,20680,20695,20692,20702,20697,20704,20679,20676,20678,20708,20696,20698,6608,56161,21125,21149,21130,21766,21770,40106,21959,21981,21964,22039,22045,22051,22048,22036,22070,22073,22074,22131,22132,22134,22130,22135,22138,22136,22137,22125,22120,22121,22122,22126,22129,22128,22150,22152,22160,22170,22188,22215,106759,20493,22544,22630,22635,22637,22681,22843,23193,23192,23350,23673,23931,24021,24029,24049,24690,24691,24692,24693,24699,24743,150052,150053,25129,25140,25146,25167,25184,25188,25192,25235,25339,25343,25348,50479,25577,25614,25740,164381,164380,20463,20464,20473,20467,25972,25973,25974);
|
|
|
|
-- Delete duplicate spawns for build 8606
|
|
|
|
DELETE FROM gameobject_spawns WHERE id IN(600067,601023,602115,602827,605666,5480,605428,607395,607733,610646,611289,611874,612431,612424,612340,612333,612343,612342,612356,612269,611935,611986,612840,612839,612838,612831,612833,612826,612665,612663,612697,612727,613620,629183,629181,616016,616594,616597,616606,617621,619644,619706,619715,619716,619721,619724,619727,619734,619737,619738,619739,620696,621998,621999,622000,622001,622002,622003,622004,622005,622006,622007,622008,622009,622010,622011,622012,622013,622014,622015,622016,622017,622018,622019,622020,622021,622022,622023,622024,622025,622026,622027,623087,623088,623089,623091,623164,615947,615949,624171,624520,624514,624525,624519,624521,624515,624523,624527,624522,624518,624526,624530,624529,624531,624528,624517,624708,624730,625695,625691,625684,626024,626028,636180,626136,626132,626125,626190,626206,626203,626201,626200,630666,626289,626287,626314,626312,626310,626313,626309,626306,626308,626307,626300,626294,626304,626303,626299,626296,626297,626334,626336,626373,626391,626397,626410,626513,626608,626925,627004,627008,627010,633727,627226,627428,627436,627545,629310,629241,627870,627878,627893,628199,628200,628201,628202,630425,628169,628417,628418,632250,631404,631413,631488,628551,628555,631263,631415,628612,628615,631233,630301,631477,628932,629194,629417,629341,629555,629556,629554,629553,628744,628739,628743);
|
|
|
|
-- Update spawns based on cata z UPDATE (no need for a new spawn id since it is the same go just the z-position changed.)
|
|
UPDATE gameobject_spawns SET id = 42753 WHERE id = 646077;
|
|
UPDATE gameobject_spawns SET id = 42691 WHERE id = 646079;
|
|
UPDATE gameobject_spawns SET id = 32368 WHERE id = 646172;
|
|
UPDATE gameobject_spawns SET id = 87072 WHERE id = 646053;
|
|
UPDATE gameobject_spawns SET id = 45135 WHERE id = 646062;
|
|
UPDATE gameobject_spawns SET id = 87205 WHERE id = 646066;
|
|
UPDATE gameobject_spawns SET id = 45004 WHERE id = 646040;
|
|
UPDATE gameobject_spawns SET id = 44816 WHERE id = 646011;
|
|
UPDATE gameobject_spawns SET id = 76067 WHERE id = 655932;
|
|
UPDATE gameobject_spawns SET id = 79141 WHERE id = 649513;
|
|
UPDATE gameobject_spawns SET id = 79261 WHERE id = 647313;
|
|
UPDATE gameobject_spawns SET id = 79269 WHERE id = 647344;
|
|
UPDATE gameobject_spawns SET id = 79257 WHERE id = 647308;
|
|
UPDATE gameobject_spawns SET id = 79267 WHERE id = 647317;
|
|
UPDATE gameobject_spawns SET id = 79265 WHERE id = 647357;
|
|
UPDATE gameobject_spawns SET id = 79297 WHERE id = 646543;
|
|
UPDATE gameobject_spawns SET id = 79296 WHERE id = 646541;
|
|
UPDATE gameobject_spawns SET id = 79224 WHERE id = 646455;
|
|
UPDATE gameobject_spawns SET id = 79690 WHERE id = 647335;
|
|
UPDATE gameobject_spawns SET id = 79683 WHERE id = 647305;
|
|
UPDATE gameobject_spawns SET id = 79689 WHERE id = 647306;
|
|
UPDATE gameobject_spawns SET id = 79693 WHERE id = 647360;
|
|
UPDATE gameobject_spawns SET id = 79726 WHERE id = 647091;
|
|
UPDATE gameobject_spawns SET id = 79722 WHERE id = 646534;
|
|
UPDATE gameobject_spawns SET id = 63462 WHERE id = 651118;
|
|
UPDATE gameobject_spawns SET id = 82673 WHERE id = 651101;
|
|
UPDATE gameobject_spawns SET id = 82685 WHERE id = 651109;
|
|
UPDATE gameobject_spawns SET id = 80118 WHERE id = 650062;
|
|
UPDATE gameobject_spawns SET id = 80005 WHERE id = 649496;
|
|
UPDATE gameobject_spawns SET id = 80109 WHERE id = 647330;
|
|
UPDATE gameobject_spawns SET id = 80107 WHERE id = 647312;
|
|
UPDATE gameobject_spawns SET id = 80113 WHERE id = 647359;
|
|
UPDATE gameobject_spawns SET id = 80112 WHERE id = 647321;
|
|
UPDATE gameobject_spawns SET id = 79974 WHERE id = 646836;
|
|
UPDATE gameobject_spawns SET id = 79977 WHERE id = 646805;
|
|
UPDATE gameobject_spawns SET id = 80140 WHERE id = 646533;
|
|
UPDATE gameobject_spawns SET id = 80141 WHERE id = 646542;
|
|
UPDATE gameobject_spawns SET id = 80142 WHERE id = 646560;
|
|
UPDATE gameobject_spawns SET id = 80075 WHERE id = 646459;
|
|
UPDATE gameobject_spawns SET id = 80243 WHERE id = 649526;
|
|
UPDATE gameobject_spawns SET id = 80423 WHERE id = 650113;
|
|
UPDATE gameobject_spawns SET id = 80439 WHERE id = 647098;
|
|
UPDATE gameobject_spawns SET id = 80371 WHERE id = 646804;
|
|
UPDATE gameobject_spawns SET id = 80372 WHERE id = 646809;
|
|
UPDATE gameobject_spawns SET id = 80374 WHERE id = 646786;
|
|
UPDATE gameobject_spawns SET id = 80373 WHERE id = 646783;
|
|
UPDATE gameobject_spawns SET id = 80435 WHERE id = 646540;
|
|
UPDATE gameobject_spawns SET id = 80436 WHERE id = 646555;
|
|
UPDATE gameobject_spawns SET id = 78448 WHERE id = 649395;
|
|
UPDATE gameobject_spawns SET id = 78435 WHERE id = 646795;
|
|
UPDATE gameobject_spawns SET id = 80858 WHERE id = 651392;
|
|
UPDATE gameobject_spawns SET id = 81300 WHERE id = 650060;
|
|
UPDATE gameobject_spawns SET id = 81284 WHERE id = 647337;
|
|
UPDATE gameobject_spawns SET id = 81281 WHERE id = 647315;
|
|
UPDATE gameobject_spawns SET id = 625439 WHERE id = 647332;
|
|
UPDATE gameobject_spawns SET id = 81283 WHERE id = 647316;
|
|
UPDATE gameobject_spawns SET id = 81282 WHERE id = 647322;
|
|
UPDATE gameobject_spawns SET id = 81277 WHERE id = 647328;
|
|
UPDATE gameobject_spawns SET id = 81285 WHERE id = 647311;
|
|
UPDATE gameobject_spawns SET id = 625430 WHERE id = 647466;
|
|
UPDATE gameobject_spawns SET id = 625425 WHERE id = 647476;
|
|
UPDATE gameobject_spawns SET id = 81328 WHERE id = 647090;
|
|
UPDATE gameobject_spawns SET id = 625399 WHERE id = 647089;
|
|
UPDATE gameobject_spawns SET id = 625396 WHERE id = 647082;
|
|
UPDATE gameobject_spawns SET id = 625398 WHERE id = 647101;
|
|
UPDATE gameobject_spawns SET id = 81327 WHERE id = 647088;
|
|
UPDATE gameobject_spawns SET id = 625397 WHERE id = 647086;
|
|
UPDATE gameobject_spawns SET id = 81326 WHERE id = 647084;
|
|
UPDATE gameobject_spawns SET id = 625393 WHERE id = 647103;
|
|
UPDATE gameobject_spawns SET id = 81325 WHERE id = 647108;
|
|
UPDATE gameobject_spawns SET id = 81189 WHERE id = 646819;
|
|
UPDATE gameobject_spawns SET id = 81621 WHERE id = 649477;
|
|
UPDATE gameobject_spawns SET id = 81716 WHERE id = 647325;
|
|
UPDATE gameobject_spawns SET id = 81720 WHERE id = 647310;
|
|
UPDATE gameobject_spawns SET id = 625526 WHERE id = 647319;
|
|
UPDATE gameobject_spawns SET id = 81717 WHERE id = 647326;
|
|
UPDATE gameobject_spawns SET id = 625530 WHERE id = 647334;
|
|
UPDATE gameobject_spawns SET id = 81718 WHERE id = 647309;
|
|
UPDATE gameobject_spawns SET id = 81719 WHERE id = 647318;
|
|
UPDATE gameobject_spawns SET id = 81713 WHERE id = 647462;
|
|
UPDATE gameobject_spawns SET id = 625503 WHERE id = 647205;
|
|
UPDATE gameobject_spawns SET id = 625495 WHERE id = 647087;
|
|
UPDATE gameobject_spawns SET id = 625498 WHERE id = 647083;
|
|
UPDATE gameobject_spawns SET id = 81760 WHERE id = 647095;
|
|
UPDATE gameobject_spawns SET id = 625502 WHERE id = 647092;
|
|
UPDATE gameobject_spawns SET id = 625493 WHERE id = 647110;
|
|
UPDATE gameobject_spawns SET id = 81758 WHERE id = 647102;
|
|
UPDATE gameobject_spawns SET id = 625497 WHERE id = 647104;
|
|
UPDATE gameobject_spawns SET id = 625501 WHERE id = 647115;
|
|
UPDATE gameobject_spawns SET id = 82695 WHERE id = 651112;
|
|
UPDATE gameobject_spawns SET id = 63509 WHERE id = 651107;
|
|
UPDATE gameobject_spawns SET id = 82033 WHERE id = 649495;
|
|
UPDATE gameobject_spawns SET id = 82047 WHERE id = 649452;
|
|
UPDATE gameobject_spawns SET id = 82240 WHERE id = 647096;
|
|
UPDATE gameobject_spawns SET id = 82241 WHERE id = 647100;
|
|
UPDATE gameobject_spawns SET id = 82068 WHERE id = 647028;
|
|
UPDATE gameobject_spawns SET id = 82114 WHERE id = 646846;
|
|
UPDATE gameobject_spawns SET id = 82000 WHERE id = 646799;
|
|
UPDATE gameobject_spawns SET id = 82212 WHERE id = 646546;
|
|
UPDATE gameobject_spawns SET id = 82233 WHERE id = 646538;
|
|
UPDATE gameobject_spawns SET id = 82225 WHERE id = 646547;
|
|
UPDATE gameobject_spawns SET id = 82213 WHERE id = 646539;
|
|
UPDATE gameobject_spawns SET id = 82211 WHERE id = 646548;
|
|
UPDATE gameobject_spawns SET id = 82221 WHERE id = 646549;
|
|
UPDATE gameobject_spawns SET id = 82228 WHERE id = 646562;
|
|
UPDATE gameobject_spawns SET id = 82210 WHERE id = 646551;
|
|
UPDATE gameobject_spawns SET id = 82220 WHERE id = 646544;
|
|
UPDATE gameobject_spawns SET id = 82217 WHERE id = 646559;
|
|
UPDATE gameobject_spawns SET id = 82222 WHERE id = 646537;
|
|
UPDATE gameobject_spawns SET id = 82219 WHERE id = 646552;
|
|
UPDATE gameobject_spawns SET id = 82232 WHERE id = 646561;
|
|
UPDATE gameobject_spawns SET id = 82226 WHERE id = 646570;
|
|
UPDATE gameobject_spawns SET id = 82223 WHERE id = 646573;
|
|
UPDATE gameobject_spawns SET id = 82215 WHERE id = 646572;
|
|
UPDATE gameobject_spawns SET id = 82231 WHERE id = 646567;
|
|
UPDATE gameobject_spawns SET id = 82218 WHERE id = 646574;
|
|
UPDATE gameobject_spawns SET id = 82094 WHERE id = 646397;
|
|
UPDATE gameobject_spawns SET id = 82688 WHERE id = 651119;
|
|
UPDATE gameobject_spawns SET id = 82565 WHERE id = 647347;
|
|
UPDATE gameobject_spawns SET id = 82564 WHERE id = 647338;
|
|
UPDATE gameobject_spawns SET id = 82630 WHERE id = 647085;
|
|
UPDATE gameobject_spawns SET id = 82629 WHERE id = 647105;
|
|
UPDATE gameobject_spawns SET id = 82631 WHERE id = 647106;
|
|
UPDATE gameobject_spawns SET id = 82529 WHERE id = 646842;
|
|
UPDATE gameobject_spawns SET id = 82606 WHERE id = 646919;
|
|
UPDATE gameobject_spawns SET id = 82403 WHERE id = 646802;
|
|
UPDATE gameobject_spawns SET id = 82402 WHERE id = 646806;
|
|
UPDATE gameobject_spawns SET id = 82399 WHERE id = 646798;
|
|
UPDATE gameobject_spawns SET id = 82400 WHERE id = 646785;
|
|
UPDATE gameobject_spawns SET id = 82618 WHERE id = 646557;
|
|
UPDATE gameobject_spawns SET id = 82619 WHERE id = 646553;
|
|
UPDATE gameobject_spawns SET id = 82620 WHERE id = 646571;
|
|
UPDATE gameobject_spawns SET id = 82621 WHERE id = 646576;
|
|
UPDATE gameobject_spawns SET id = 82689 WHERE id = 651121;
|
|
UPDATE gameobject_spawns SET id = 82751 WHERE id = 647113;
|
|
UPDATE gameobject_spawns SET id = 82722 WHERE id = 646794;
|
|
UPDATE gameobject_spawns SET id = 82749 WHERE id = 646575;
|
|
UPDATE gameobject_spawns SET id = 76127 WHERE id = 655976;
|
|
UPDATE gameobject_spawns SET id = 76153 WHERE id = 655969;
|
|
UPDATE gameobject_spawns SET id = 76188 WHERE id = 655992;
|
|
UPDATE gameobject_spawns SET id = 84088 WHERE id = 646791;
|
|
UPDATE gameobject_spawns SET id = 75593 WHERE id = 655857;
|
|
UPDATE gameobject_spawns SET id = 76025 WHERE id = 655860;
|
|
UPDATE gameobject_spawns SET id = 76288 WHERE id = 655533;
|
|
UPDATE gameobject_spawns SET id = 76294 WHERE id = 655544;
|
|
UPDATE gameobject_spawns SET id = 76293 WHERE id = 655543;
|
|
UPDATE gameobject_spawns SET id = 80504 WHERE id = 647016;
|
|
UPDATE gameobject_spawns SET id = 80523 WHERE id = 646564;
|
|
UPDATE gameobject_spawns SET id = 93905 WHERE id = 655808;
|
|
UPDATE gameobject_spawns SET id = 94180 WHERE id = 655826;
|
|
UPDATE gameobject_spawns SET id = 98310 WHERE id = 655715;
|
|
UPDATE gameobject_spawns SET id = 98327 WHERE id = 655806;
|
|
UPDATE gameobject_spawns SET id = 98780 WHERE id = 656021;
|
|
|
|
-- DELET from go spawns where entry, map, x, y, z is duplicate
|
|
|
|
DELETE FROM gameobject_spawns WHERE id IN(120346,4846,35534,35535,94359,94319,94322,94318,94899,94891,94895,94893,95930,95933,95928,95934,95935,95927,95931,95925,95926,95929,95891,95892,95893,95912,95894,95890,95910,95883,95903,95884,95906,95888,95900,95886,95889,95887,95913,95901,95908,95885,95897,95905,95902,95898,95882,95878,95895,95899,95880,95879,95869,95868,95871,95874,95873,95865,95866,95858,95863,95867,95864,95861,95855,95856,95857,95846,95870,95849,95839,95837,95852,95833,95848,95841,95842,95831,95851,95843,95832,95836,95948,95945,95773,95772,95955,95726,95729,95747,95724,95730,95762,95733,95734,95725,95735,95760,95759,95737,95728,95756,95758,95763,95731,95757,95764,95761,95746,95727,95732,95739,95742,95743,95745,95748,95741,95738,96337,96338,96327,96329,96330,96312,96308,96311,96322,96319,96306,96304,96310,96318,96307,96314,96316,96300,96224,96228,96235,96243,96230,96225,96244,96220,96223,96233,96219,96226,96218,96227,96231,96217,96222,96229,96232,96236,96234,96207,96205,96191,96199,96196,96174,96197,96192,96200,96188,96175,96183,96177,96182,96178,96176,96187,96180,96185,96190,96179,96056,96061,96054,96064,96049,96057,96014,96063,96002,96066,96003,96021,96036,96025,96022,96026,96031,96029,96023,96018,96017,96020,96033,96010,96068,96027,96015,95986,96024,96009,96028,96008,96005,96019,96013,96034,96032,96016,96007,96011,96006,96012,96000,96038,95983,96047,95979,96065,96030,95999,96059,96037,96035,95998,96067,96172,96166,96163,96161,96051,96170,96071,96004,95996,96053,95997,96173,96162,96171,96160,96159,96169,96164,96168,96158,96156,96155,96167,96152,96149,96157,96165,96153,96150,96151,96154,96045,95984,95989,95987,96039,96147,96074,96081,96070,96077,96148,96060,96050,95992,95994,96043,95995,95988,96058,95981,95985,95990,95978,95993,96080,96073,96097,95991,95980,95982,96096,96087,96099,96095,96062,96083,96072,96084,96094,96076,96090,96089,96086,96085,96100,96126,96131,96137,96133,96140,96146,96121,96113,96118,96145,96143,96124,96116,96114,96135,96141,96120,96119,96115,96123,96138,96139,96117,96127,96144,96136,96130,96132,96142,96129,96125,96105,96134,96107,96106,103289,103294,103296,103297,103298,103287,103184,103190,103192,103181,103188,103170,103171,103156,103159,103153,103161,103167,103216,103223,103219,103220,103229,103225,103227,103230,103448,103450,103449,103465,103453,103443,103441,103474,103482,103472,89748,89747,105718,105721,105728,105729,105691,105692);
|
|
|
|
INSERT INTO `world_db_version` (`id`, `LastUpdate`) VALUES ('115', '20221221_00_duplicate_gameobject_spawns');
|