diff options
| -rw-r--r-- | sql/updates/world/cata_classic/2024_10_06_01_world.sql | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/sql/updates/world/cata_classic/2024_10_06_01_world.sql b/sql/updates/world/cata_classic/2024_10_06_01_world.sql new file mode 100644 index 00000000000..b384c93cbc0 --- /dev/null +++ b/sql/updates/world/cata_classic/2024_10_06_01_world.sql @@ -0,0 +1,30 @@ +-- Creatures +DELETE FROM `creature_static_flags_override` WHERE `SpawnId` IN (395475,395522,395523,395542,395570,460002,460043,650356,850856,850858,850861,850862,850864,850865,850866,850867,850868,850871,850973,851014,851023,851084,851100,851115,851127,851155,851158,851182,851194,851201,1050851,1050886,1050973,1050980,1050981,1051014,6000695,8000023,8000024,9000012,9000013,9000211,9000224,9001454,9001469); + +UPDATE `creature` SET `spawnDifficulties`='9' WHERE `map` IN (409,469,531); +UPDATE `creature` SET `spawnDifficulties`='148' WHERE `map`=509; +UPDATE `creature` SET `spawnDifficulties`='3,4,5,6' WHERE `map`=967; + +DELETE FROM `creature` WHERE `map` IN (860,870,1001,1004,1007,1116,1158,1195,1220,1265,1502,1544,1642,1643,1860,2081,2106,2107,2297,2444,2454); + +DELETE FROM `game_event_creature` WHERE `guid` IN (396644,396645,396646,396647,396675,396676,396677,396678,3800120); + +-- Gameobjects +UPDATE `gameobject` SET `spawnDifficulties`='9' WHERE `map` IN (409,469,531); +UPDATE `gameobject` SET `spawnDifficulties`='148' WHERE `map`=509; +UPDATE `gameobject` SET `spawnDifficulties`='3,4,5,6' WHERE `map`=967; + +DELETE FROM `gameobject` WHERE `map` IN (860,870,1001,1004,1007,1116,1158,1195,1220,1265,1502,1544,1642,1643,1860,2081,2106,2107,2297,2444,2454); +DELETE FROM `gameobject` WHERE `guid` >= 6000000; + +DELETE FROM `gameobject_addon` WHERE `guid` IN (395645,400468,400475,400479,400481,600000,600001,600002,600003,600004,600005,600006,600007,600009,600010,600011,600012,600013,600014); + +DELETE FROM `game_event_gameobject` WHERE `guid` IN (400428,400429,400430,400431,400432,400433,400434,400435,400436,400437,400438,400439,400440,400441,400442,400443,400444,400445,400446,400447,400448,400449,400450,400451,400452,400453,400454,400455,400456,400457,400458,400459,400460,400461,400462,400463,400464,400465,400466,500491,500492,500493,500494,500495,500496,500497,500498,500499,500500,500501,500502,500503,500504,500505,500506,500507,500508,500509,500510,500511,6000179,6000180,6000181,6000182,6000183,6000184,6000185,6000186,6000187,6000188,6000189,6000190,6000191,6000192,6000193,6000194,6000195,6000196,6000197,6000198,6000199,6000200,6000201,6000202,6000203,6000204,6000205,6000206,6000207,6000208,6000209,6000210,6000211,6000212,6000213,6000214,6000215,6000216,6000217,6000218,6000219,6000220,6000221,6000222,6000223,6000224,6000225,6000226,6000227,6000228,6000229,6000230,6000231,6000232,6000233,6000234,6000235,6000236,6000237,6000238,6000239,6000240,6000241,6000242,6000243,6000244,6000245,6000246,6000247,6000248,6000249,6000250,6000251,6000252,6000253,6000254,6000255,6000256,6000257,6000258,6000259,6000260,6000261,6000262,6000263,6000264,6000265,6000266,6000267,6000268,6000269,6000270,6000271,6000272,6000273,6000274,6000275,6000276,6000277,6000278,6000279,6000280,6000281,6000282,6000283,6000284,6000285,6000286,6000287,6000288,6000289,6000290,6000291,6000292,6000293,6000294,6000295,6000296,6000297,6000298,6000299,6000300,6000301,6000302,6000303,6000304,6000305,6000306,6000307,6000308,6000309,6000310,6000311,6000312,6000313,6000314,6000315,6000316,6000317,6000318,6000319,6000320,6000321,6000322,6000323,6000324,6000325,6000326,6000327,6000328,6000329,6000330,6000331,6000332,6000333,6000334,6000335,6000336,6000337,6000338,6000339,6000340,6000341,6000342,6000343,6000344,6000345,6000346,6000347,6000348,6000349,6000350,6000351,6000352,6000353,6000354,6000355,6000356,6000357,6000358,6000359,6000360,6000361,6000362,6000363,6000364,6000365,6000366,6000367,6000368,6000369,6000370,6000371,6000372,6000373,6000374,6000375,6000376,6000377,6000378,6000379,6000380,6000381,6000382,6000383,6000384,6000385,6000386,6000387,6000388,6000389,6000390,6000391,6000392,6000393,6000394,6000395,6000396,6000397,6000398,6000399,6000400,6000401,6000402,6000403,6000404,6000405,6000406,6000407,6000408,6000409,6000410,6000411,6000412,6000413,6000414,6000415,6000416,6000417,6000418,6000419,6000420,6000421,6000422,6000423,6000424,6000425,6000426,6000427,6000428,6000429,6000430,6000431,6000432,6000433,6000434,6000435,6000436,6000437,6000438,6000439,6000440,6000441,6000442,6000443,6000444,6000445,6000446,6000447,6000448,6000449,6000450,6000451,6000452,6000453,6000454,6000455,6000456,6000457,6000458,6000459,6000460,6000461,6000462,6000463,6000464,6000465,6000466,6000467,6000468,6000469,6000470,6000471,6000472,6000473,6000474,6000475,6000476,6000477,6000478,6000479,6000480,6000481,6000482,6000483,6000484,6000485,6000486,6000487,6000488,6000492,6000493,6000494,6000495,6000496,6000497,6000498,6000499,6000500,6000501,6000502,6000503,6000504,6000505,6000506,6000507,6000508,6000509,6000510,6000511,6000512,6000513,6000514,6000515,6000516,6000517,6000518,6000519,6000520,6000521,6000522,6000523,6000524,6000525,6000526,6000527,6000528,6000529,6000530,6000531,6000532,6000533,6000534,6000535,6000536,6000537,6000538,6000539,6000540,6000541,6000542,6000543,6000544,6000545,6000546,6000547,6000548,6000549,6000550,6000551,6000552,6000553,6000554,6000555,6000556,6000557,6000558,6000559,6000560,6000561,6000562,6000563,6000564,6000565,6000566,6000567,6000568,6000569,6000570,6000571,6000572,6000573,6000574,6000575,6000576,6000577,7000014,7000015,7000016,7000017,7000018,7000019,7000020,7000021,7000022,7000023,7000024,7000025,7000026,7000027,7000028,7000029,7000030,7000031,7000032,7000033,7000034,7000035,7000036,7000037,7000038,7000039,7000040,7000041,7000042,7000043,7000044,7000045,7000046,7000047,7000048,7000049,7000050,7000051,7000052,7000053,7000054,7000055,7000056,7000057,7000058,7000059,7000060,7000061,7000062,7000063,7000064,7000065,7000066,7000067,7000068,7000069,7000070,7000071,7000072,7000073,7000074,7000075,7000076,7000077,7000078,7000079,7000080,7000081,7000082,7000083,7000084,7000085,7000086,7000087,7000088,7000089,7000090,7000091,7000092,7000093,7000094,7000095,7000096,7000097,7000099,7000100,7000101,7000102,7000103,7000104,7000105,7000106,7000107,7000108,7000109,7000110,7000111,7000112,7000113,7000114,7000115,7000116,7000117,7000118,7000119,7000120,7000121,7000122,7000123,7000124,7000125,7000126,7000127,7000128,7000129,7000130,7000131,7000132,7000133,7000134,7000135,7000136,7000137,7000138,7000139,7000140,9003369,9003370,9003371,9003372,9003373,9003374,9003376,9003377,9003378,9003379,9003380,9003381,9003383,9003384,9003385,9003386,9003387,9003388,9003389,9003390,9003391,9003392,9003393,9003394,9003397,9003398,9003399,9003400,9003401,9003402,9003404,9003405,9003406,9003407,9003408,9003409,9003411,9003412,9003413,9003414,9003415,9003416,9003418,9003419,9003420,9003421,9003422,9003423,9003425,9003426,9003427,9003428,9003429,9003430,9003432,9003433,9003434,9003435,9003436,9003437,9003439,9003440,9003441,9003442,9003443,9003444,9003446,9003447,9003448,9003449,9003450,9003451,9003453,9003454,9003455,9003456,9003457,9003458,9003460,9003461,9003462,9003463,9003464,9003465,9003467,9003468,9003469,9003470,9003471,9003472,9003474,9003475,9003476,9003477,9003478,9003479,9003481,9003482,9003483,9003484,9003485,9003486,9003488,9003489,9003490,9003491,9003492,9003493,9003495,9003496,9003497,9003498,9003499,9003500,9003502,9003503,9003504,9003505,9003506,9003507,9003509,9003510,9003511,9003512,9003513,9003514,9003516,9003517,9003518,9003519,9003520,9003521,9003523,9003524,9003525,9003526,9003527,9003528,9003530,9003531,9003532,9003533,9003534,9003535,9003537,9003538,9003539,9003540,9003541,9003542,9003544,9003545,9003546,9003547,9003548,9003549,9003551,9003552,9003553,9003554,9003555,9003556,9003557,9003558,9003559,9003560,9003561,9003562,9003563,9003564,9003565,9003566,9003567,9003568,9003569,9003570,9003571,9003572,9003573,9003574,9003575,9003576,9003577,9003578,9003579,9003580,9003581,9003582,9003583,9003584,9003585,9003586,9003587,9003588,9003589,9003590,9003591,9003592,9003593,9003594,9003595,9003596,9003597,9003598,9003599,9003600,9003601,9003602,9003603,9003604,9003605,9003606,9003607,9003608,9003609,9003610,9003611,9003612,9003613,9003614,9003615,9003616,9003617,9003618,9003619,9003620,9003621,9003622,9003623,9003624,9003625,9003626,9003627,9003628,9003629,9003630,9003631,9003632,9003633,9003634,9003635,9003636,9003637,9003638,9003639,9003640,9003641,9003642,9003643,9003644,9003645,9003646,9003647,9003648,9003649,9003650,9003651,9003652,9003653,9003654,9003655,9003656,9003657,9003658,9003659,9003660,9003661,9003662,9003663,9003664,9003665,9003666,9003667,9003668,9003669,9003670,9003671,9003672,9003673,9003674,9003675,9003676,9003677,9003678,9003679,9003680,9003681,9003682,9003683,9003684,9003685,9003686,9003687,9003688,9003689,9003690,9003691,9003692,9003693,9003694,9003695,9003696,9003697,9003698,9003699,9003700,9003701,9003702,9003703,9003704,9003705,9003706,9003707,9003708,9003709,9003710,9003711,9003712,9003713,9003714,9003715,9003716,9003717,9003718,9003719,9003720,9003721,9003722,9003723,9003724,9003725,9003726,9003727,9003728,9003729,9003730,9003731,9003732,9003733,9003734,9003735,9003736,9003737,9003738,9003739,9003740,9003741,9003742,9003743,9003744,9003745,9003746,9003747,9003748,9003749,9003750,9003751,9003752,9003753,9003754,9003755,9003756,9003757,9003758,9003759,9003760,9003761,9003762,9003763,9003764,9003765,9003766,9003767,9003768,9003769,9003770,9003771,9003772,9003773,9003774,9003775,9003776,9003777,9003778,9003779,9003780,9003781,9003782,9003783,9003784,9003785,9003786,9003787,9003790,9003791,9003792,9003793,9003807,9003808,9003809,9003810,9003811,9003812,9003814,9003815,9003816,9003817,9003818,9003819,9003821,9003822,9003823,9003824,9003825,9003826,9003828,9003829,9003830,9003831,9003832,9003833,9003835,9003836,9003837,9003838,9003839,9003840,9003842,9003843,9003844,9003845,9003846,9003847,9003849,9003850,9003851,9003852,9003853,9003854,9003856,9003857,9003858,9003859,9003860,9003861,9800034,9800035,9800036,9800037,9800038,9800039,9800040,9800041,9800046,9800047,9800048,9800049,9800050,9800051,9800052,9800053,6000000,6000001,6000002,6000003,6000004,6000005,6000006,6000007,6000008,6000009,6000010,6000011,6000012,6000013,6000014,6000015,6000016,6000017,6000018,6000019,6000020,6000021,6000022,6000023,6000024,6000025,6000026,6000027,6000028,6000029,6000030,6000031,6000032,6000033,6000034,6000035,6000036,6000037,6000038,6000039,6000040,6000041,6000042,6000043,6000044,6000045,6000046,6000047,6000048,6000049,6000050,6000051,6000052,6000053,6000054,6000055,6000056,6000057,6000058,6000059,6000060,6000061,6000062,6000063,6000064,9000378,9000379,9000380,9000381,9000382,9000383,9000384,9000385,9000386,9000387,9000388,9000389,9000390,9000391,9000392,9000393,9000394,9000395,9000396,9000397,9000398,9000399,9000400,9000401,9000402,9000403,9000404,9000405,9000406,9000407,9000408,9000409,9000410,9000411,9000412,9000413,9000414,9000415,9000416,9000417,9000418,9000419,9000420,9000421,9000422,9000423,9000424,9000425,9000426,9000427,9000428,9000429,9000430,9000431,9000432,9000433,9000434,9000435,9000436,9000437,9000438,9000439,9000440,9000441,9000442,9000443,9000444,9000445,9000446,9000447,9000448,9000449,9000450,9000451,9000452,9000453,9000454,9000455,9000456,9000457,9000458,9000459,9000460,9000461,9000462,9000463,9000464,9000465,9000466,9000467,9000468,9000469,9000470,9000471,9000472,9000473,9000474,9000475,9000476,9000477,9000478,9000479,9000480,9000481,9000482,9000483,9000484,9000485,9000486,9000487,9000488,9000489,9000490,9000491,9000492,9000493,9000494,9000495,9000496,9000497,9000498,9000499,9000500,9000501,9000502,9000503,9000504,9000505,9000506,9000507,9000508,9000509,9000510,9000511,9000512,9000513,9000514,9000515,9000516,9000517,9000518,9000519,9000520,9000521,9000522,9000523,9000524,9000525,9000526,9000527,9000528,9000529,9000530,9000531,9000532,9000533,9000534,9000535,9000536,9000537,9000538,9000539,9000540,9000541,9000542,9000543,9000544,9000545,9000546,9000547,9000548,9000549,9000550,9000551,9000552,9000553,9000554,9000555,9000556,9000557,9000558,9000559,9000560,9000561,9000562,9000563,9000564,9000565,9000566,9000567,9000568,9000569,9000570,9000571,9000572,9000573,9000574,9000575,9000576,9000577,9000578,9000579,9000580,9000581,9000582,9000583,9000584,9000585,9000586,9000587,9000588,9000589,9000590,9000591,9000592,9000593,9000594,9000595,9000596,9000597,9000598,9000599,9000600,9000601,9000602,9000603,9000604,9000605,9000606,9000607,9000608,9000609,9000610,9000611,9000644,9000645,9000646,9000647,9000648,9000649,9000650,9000651,9000652,9000653,9000654,9000655,9000656,9000657,9000658,9000659,9000660,9000661,9000662,9000663,9000664,9000665,9000666,9000667,9000668,9000669,9000670,9000671,9000672,9000673,9000674,9000675,9000676,9000677,9000678,9000679,9000680,9000681,9000682,9000683,9000684,9000685,9000686,9000687,9000688,9000689,9000690,9000691,9000692,9000693,9000694,9000695,9000696,9000697,9000698,9000699,9000700,9000701,9000702,9000703,9000704,9000705,9000706,9000707,9000708,9000709,9000710,9000711,9000712,9000713,9000714,9000715,9000716,9000717,9000718,9000719,9000720,9000721,9000722,9000723,9000724,9000725,9000726,9000727,9000728,9000729,9000730,9000731,9000732,9000733,9000734,9000735,9000736,9000737,9000738,9000739,9000740,9000741,9000742,9000743,9000744,9000745,9000746,9000747,9000748,9000749,9000750,9000751,9000752,9000753,9000754,9000755,9000756,9000757,9000758,9000759,9000760,9000761,9000762,9000763,9000764,9000765,9000766,9000767,9000768,9000769,9000770,9000771,9000772,9000773,9000774,9000775,9000776,9000777,9000778,9000779,9000780,9000781,9000782,9000783,9000784,9000785,9000786,9000787,9000788,9000789,9000790,9000791,9000792,9000793,9000794,9000795,9000796,9000797,9000798,9000799,9000800,9000801,9000802,9000803,9000804,9000805,9000806,9000807,9000808,9000809,9000810,9000811,9000812,9000813,9000814,9000815,9000816,9000817,9000818,9000819,9000820,9000821,9000822,9000823,9000824,9000825,9000826,9000827,9000828,9000829,9000830,9000831,9000832,9000833,9000834,9000835,9000836,9000837,9000838,9000839,9000840,9000841,9000842,9000843,9000844,9000845,9000846,9000847,9000848,9000849,9000850,9000851,9000852,9000853,9000854,9000855,9000856,9000857,9000858,9000859,9000860,9000861,9000862,9000863,9000864,9000865,9000866,9000867,9000868,9000869,9000870,9000871,9000872,9000873,9000874,9000875,9000876,9000877,9000878,9000879,9000880,9000881,9000882,9000883,9000884,9000885,9000886,9000887,9000888,9000889,9000890,9000891,9000892,9000893,9000894,9000895,9000896,9000897,9000898,9000899,9000900,9000901,9000902,9000903,9000904,9000905,9000906,9000907,9000908,9000909,9000910,9000911,9000912,9000913,9000914,9000915,9000916,9000917,9000918,9000919,9000920,9000921,9000922,9000923,9000924,9000925,9000926,9000927,9000928,9000929,9000930,9000931,9000932,9000933,9000934,9000935,9000936,9000937,9000938,9000939,9000940,9000941,9000942,9000943,9000944,9000945,9000946,9000947,9000948,9000949,9000950,9000951,9000952,9000953,9000954,9000955,9000956,9000957,9000958,9000959,9000960,9000961,9000962,9000963,9000964,9000965,9000966,9000967,9000968,9000969,9000970,9000971,9000972,9000973,9000974,9000975,9000976,9000977,9000978,9000979,9000980,9000981,9000982,9000983,9000984,9000985,9000986,9000987,9000988,9000989,9000990,9000991,9000992,9000993,9000994,9000995,9000996,9000997,9000998,9000999,9001000,9001001,9001002,9001003,9001004,9001005,9001006,9001007,9001008,9001009,9001010,9001011,9001012,9001013,9001014,9001015,9001016,9001017,9001018,9001019,9001020,9001021,9001022,9001023,9001024,9001025,9001026,9001027,9001028,9001029,9001030,9001031,9001032,9001033,9001034,9001035,9001036,9001037,9001038,9001039,9001040,9001041,9001042,9001043,9001044,9001045,9001046,9001047,9001048,9001049,9001050,9001051,9001052,9001053,9001054,9001055,9001056,9001057,9001058,9001059,9001060,9001061,9001062,9001063,9001064,9001065,9001066,9001067,9001068,9001069,9001070,9001071,9001072,9001073,9001074,9001075,9001076,9001077,9001078,9001079,9001080,9001081,9001082,9001083,9001084,9001085,9001086,9001087,9001088,9001089,9001090,9001091,9001092,9001093,9001094,9001095,9001096,9001097,9001098,9001099,9001100,9001101,9001102,9001103,9001104,9001105,9001106,9001107,9001108,9001109,9001110,9001111,9001112,9001113,9001114,9001115,9001116,9001117,9001118,9001119,9001120,9001121,9001122,9001123,9001124,9001125,9001126,9001127,9001128,9001129,9001130,9001131,9001132,9001133,9001134,9001135,9001136,9001137,9001138,9001139,9001140,9001141,9001142,9001143,9001144,9001145,9001146,9001147,9001148,9001149,9001150,9001151,9001152,9001153,9001154,9001155,9001156,9001157,9001158,9001159,9001160,9001161,9001162,9001163,9001164,9001165,9001166,9001167,9001168,9001169,9001170,9001171,9001172,9001173,9001174,9001175,9001176,9001177,9001178,9001179,9001180,9001181,9001182,9001183,9001184,9001185,9001186,9001187,9001188,9001189,9001190,9001191,9001192,9001193,9001194,9001195,9001196,9001197,9001198,9001199,9001200,9001201,9001202,9001203,9001204,9001205,9001206,9001207,9001208,9001209,9001210,9001211,9001212,9001213,9001214,9001215,9001216,9001217,9001218,9001219,9001220,9001221,9001222,9001223,9001224,9001225,9001226,9001227,9001228,9001229,9001230,9001231,9001232,9001233,9001234,9001235,9001236,9001237,9001238,9001239,9001240,9001241,9001242,9001243,9001244,9001245,9001246,9001247,9001248,9001249,9001250,9001251,9001252,9001253,9001254,9001255,9001256,9001257,9001258,9001259,9001260,9001261,9001262,9001263,9001264,9001265,9001266,9001267,9001268,9001269,9001270,9001271,9001272,9001273,9001274,9001275,9001276,9001277,9001278,9001279,9001280,9001281,9001282,9001283,9001284,9001285,9001286,9001287,9001288,9001289,9001290,9001291,9001292,9001293,9001294,9001295,9001296,9001297,9001298,9001299,9001300,9001301,9001302,9001303,9001304,9001305,9001306,9001307,9001308,9001309,9001310,9001311,9001312,9001313,9001314,9001315,9001316,9001317,9001318,9001319,9001320,9001321,9001322,9001323,9001324,9001325,9001326,9001327,9001328,9001329,9001330,9001331,9001332,9001333,9001334,9001335,9001336,9001337,9001338,9001339,9001340,9001341,9001342,9001343,9001344,9001345,9001346,9001347,9001348,9001349,9001350,9001351,9001352,9001353,9001354,9001355,9001356,9001357,9001358,9001359,9001360,9001361,9001362,9001363,9001364,9001365,9001366,9001367,9001368,9001369,9001370,9001371,9001372,9001373,9001374,9001375,9001376,9001377,9001378,9001379,9001380,9001381,9001382,9001383,9001384,9001385,9001386,9001387,9001388,9001389,9001390,9001391,9001392,9001393,9001394,9001395,9001396,9001397,9001398,9001399,9001400,9001401,9001402,9001403,9001404,9001405,9001406,9001407,9001408,9001409,9001410,9001411,9001412,9001413,9001414,9001415,9001416,9001417,9001418,9001419,9001420,9001421,9001422,9001423,9001424,9001425,9001426,9001427,9001428,9001429,9001430,9001431,9001432,9001433,9001434,9001435,9001436,9001437,9001438,9001439,9001440,9001441,9001442,9001443,9001444,9001445,9001446,9001447,9001448,9001449,9001450,9001451,9001452,9001453,9001454,9001455,9001456,9001457,9001458,9001459,9001460,9001461,9001462,9001463,9001464,9001465,9001466,9001467,9001468,9001469,9001470,9001471,9001472,9001473,9001474,9001475,9001476,9001477,9001478,9001479,9001480,9001481,9001482,9001483,9001484,9001485,9001486,9001487,9001488,9001489,9001490,9001491,9001492,9001493,9001494,9001495,9001496,9001497,9001498,9001499,9001500,9001501,9001502,9001503,9001504,9001505,9001506,9001507,9001508,9001509,9001510,9001511,9001512,9001513,9001514,9001515,9001516,9001517,9001518,9001519,9001520,9001521,9001522,9001523,9001524,9001525,9001526,9001527,9001528,9001529,9001530,9001531,9001532,9001533,9001534,9001535,9001536,9001537,9001538,9001539,9001540,9001541,9001542,9001543,9001544,9001545,9001546,9001547,9001548,9001549,9001550,9001551,9001552,9001553,9001554,9001555,9001556,9001557,9001558,9001559,9001560,9001561,9001562,9001563,9001564,9001565,9001566,9001567,9001568,9001569,9001570,9001571,9001572,9001573,9001574,9001575,9001576,9001577,9001578,9001579,9001580,9001581,9001582,9001583,9001584,9001585,9001586,9001587,9001588,9001589,9001590,9001591,9001592,9001593,9001594,9001595,9001596,9001597,9001598,9001599,9001600,9001601,9001602,9001603,9001604,9001605,9001606,9001607,9001608,9001609,9001610,9001611,9001612,9001613,9001614,9001615,9001616,9001617,9001618,9001619,9001620,9001621,9001622,9001623,9001624,9001625,9001626,9001627,9001628,9001629,9001630,9001631,9001632,9001633,9001634,9001635,9001636,9001637,9001638,9001639,9001640,9001641,9001642,9001643,9001644,9001645,9001646,9001647,9001648,9001649,9001650,9001651,9001652,9001653,9001654,9001655,9001656,9001657,9001658,9001659,9001660,9001661,9001662,9001663,9001664,9001665,9001666,9001667,9001668,9001669,9001670,9001671,9001672,9001673,9001674,9001675,9001676,9001677,9001678,9001679,9001680,9001681,9001682,9001683,9001684,9001685,9001686,9001687,9001688,9001689,9001690,9001691,9001692,9001693,9001694,9001695,9001696,9001697,9001698,9001699,9001700,9001701,9001702,9001703,9001704,9001705,9001706,9001707,9001708,9001709,9001710,9001711,9001712,9001713,9001714,9001715,9001716,9001717,9001718,9001719,9001720,9001721,9001722,9001723,9001724,9001725,9001726,9001727,9001728,9001729,9001730,9001731,9001732,9001733,9001734,9001735,9001736,9001737,9001738,9001739,9001740,9001741,9001742,9001743,9001744,9001745,9001746,9001747,9001748,9001749,9001750,9001751,9001752,9001753,9001754,9001755,9001756,9001757,9001758,9001759,9001760,9001761,9001762,9001763,9001764,9001765,9001766,9001767,9001768,9001769,9001770,9001771,9001772,9001773,9001774,9001775,9001776,9001777,9001778,9001779,9001780,9001781,9001782,9001783,9001784,9001785,9001786,9001787,9001788,9001789,9001790,9001791,9001792,9001793,9001794,9001795,9001796,9001797,9001798,9001799,9001800,9001801,9001802,9001803,9001804,9001805,9001806,9001807,9001808,9001809,9001810,9001811,9001812,9001813,9001814,9001815,9001816,9001817,9001818,9001819,9001820,9001821,9001822,9001823,9001824,9001825,9001826,9001827,9001828,9001829,9001830,9001831,9001832,9001833,9001834,9001835,9001836,9001837,9001838,9001839,9001840,9001841,9001842,9001843,9001844,9001845,9001846,9001847,9001848,9001849,9001850,9001851,9001852,9001853,9001854,9001855,9001856,9001857,9001858,9001859,9001860,9001861,9001862,9001863,9001864,9001865,9001866,9001867,9001868,9001869,9001870,9001871,9001872,9001873,9001874,9001875,9001876,9001877,9001878,9001879,9001880,9001881,9001882,9001883,9001884,9001885,9001886,9001887,9001888,9001889,9001890,9001891,9001892,9001893,9001894,9001895,9001896,9001897,9001898,9001899,9001900,9001901,9001902,9001903,9001904,9001905,9001906,9001907,9001908,9001909,9001910,9001911,9001912,9001913,9001914,9001915,9001916,9001917,9001918,9001919,9001920,9001921,9001922,9001923,9001924,9001925,9001926,9001927,9001928,9001929,9001930,9001931,9001932,9001933,9001934,9001935,9001936,9001937,9001938,9001939,9001940,9001941,9001942,9001943,9001944,9001945,9001946,9001947,9001948,9001949,9001950,9001951,9001952,9001953,9001954,9001955,9001956,9001957,9001958,9001959,9001960,9001961,9001962,9001963,9001964,9001965,9001966,9001967,9001968,9001969,9001970,9001971,9001972,9001973,9001974,9001975,9001976,9001977,9001978,9001979,9001980,9001981,9001982,9001983,9001984,9001985,9001986,9001987,9001988,9001989,9001990,9001991,9001992,9001993,9001994,9001995,9001996,9001997,9001998,9001999,9002000,9002001,9002002,9002003,9002004,9002005,9002006,9002007,9002008,9002009,9002010,9002011,9002012,9002013,9002014,9002015,9002016,9002017,9002018,9002019,9002020,9002021,9002022,9002023,9002024,9002025,9002026,9002027,9002028,9002029,9002030,9002031,9002032,9002033,9002034,9002035,9002036,9002037,9002038,9002039,9002040,9002041,9002042,9002043,9002044,9002045,9002046,9002047,9002048,9002049,9002050,9002051,9002052,9002053,9002054,9002055,9002056,9002057,9002058,9002059,9002060,9002061,9002062,9002063,9002064,9002065,9002066,9002067,9002068,9002069,9002070,9002071,9002072,9002073,9002074,9002075,9002076,9002077,9002078,9002079,9002080,9002081,9002082,9002083,9002084,9002085,9002086,9002087,9002088,9002089,9002090,9002091,9002092,9002093,9002094,9002095,9002096,9002097,9002098,9002099,9002100,9002101,9002102,9002103,9002104,9002105,9002106,9002107,9002108,9002109,9002110,9002111,9002112,9002113,9002114,9002115,9002116,9002117,9002118,9002119,9002120,9002121,9002122,9002123,9002124,9002125,9002126,9002127,9002128,9002129,9002130,9002131,9002132,9002133,9002134,9002135,9002136,9002137,9002138,9002139,9002140,9002141,9002142,9002143,9002144,9002145,9002146,9002147,9002148,9002149,9002150,9002151,9002152,9002153,9002154,9002155,9002156,9002157,9002158,9002159,9002160,9002161,9002162,9002163,9002164,9002165,9002166,9002167,9002168,9002169,9002170,9002171,9002172,9002173,9002174,9002175,9002176,9002177,9002178,9002179,9002180,9002181,9002182,9002183,9002184,9002185,9002186,9002187,9002188,9002189,9002190,9002191,9002192,9002193,9002194,9002195,9002196,9002197,9002198,9002199,9002200,9002201,9002202,9002203,9002204,9002205,9002206,9002207,9002208,9002209,9002210,9002211,9002212,9002213,9002214,9002215,9002216,9002217,9002218,9002219,9002220,9002221,9002222,9002223,9002224,9002225,9002226,9002227,9002228,9002229,9002230,9002231,9002232,9002233,9002234,9002235,9002236,9002237,9002238,9002239,9002240,9002241,9002242,9002243,9002244,9002245,9002246,9002247,9002248,9002249,9002250,9002251,9002252,9002253,9002254,9002255,9002256,9002257,9002258,9002259,9002260,9002261,9002262,9002263,9002264,9002265,9002266,9002267,9002268,9002269,9002270,9002271,9002272,9002273,9002274,9002275,9002276,9002277,9002278,9002279,9002280,9002281,9002282,9002283,9002284,9002285,9002286,9002287,9002288,9002289,9002290,9002291,9002292,9002293,9002294,9002295,9002296,9002297,9002298,9002299,9002300,9002301,9002302,9002303,9002304,9002305,9002306,9002307,9002308,9002309,9002310,9002311,9002312,9002313,9002314,9002315,9002316,9002317,9002318,9002319,9002320,9002321,9002322,9002323,9002324,9002325,9002326,9002327,9002328,9002329,9002330,9002331,9002332,9002333,9002334,9002335,9002336,9002337,9002338,9002339,9002340,9002341,9002342,9002343,9002344,9002345,9002346,9002347,9002348,9002349,9002350,9002351,9002352,9002353,9002354,9002355,9002356,9002357,9002358,9002359,9002360,9002361,9002362,9002363,9002364,9002365,9002366,9002367,9002368,9002369,9002370,9002371,9002372,9002373,9002374,9002375,9002376,9002377,9002378,9002379,9002380,9002381,9002382,9002383,9002384,9002385,9002386,9002387,9002388,9002389,9002390,9002391,9002392,9002393,9002394,9002395,9002396,9002397,9002398,9002399,9002400,9002401,9002402,9002403,9002404,9002405,9002406,9002407,9002408,9002409,9002410,9002411,9002412,9002413,9002414,9002415,9002416,9002417,9002418,9002419,9002420,9002421,9002422,9002423,9002424,9002425,9002426,9002427,9002428,9002429,9002430,9002431,9002432,9002433,9002434,9002435,9002436,9002437,9002438,9002439,9002440,9002441,9002442,9002443,9002444,9002445,9002446,9002447,9002448,9002449,9002450,9002451,9002452,9002453,9002454,9002455,9002456,9002457,9002458,9002459,9002460,9002461,9002462,9002463,9002464,9002465,9002466,9002467,9002468,9002469,9002470,9002471,9002472,9002473,9002474,9002475,9002476,9002477,9002478,9002479,9002480,9002481,9002482,9002483,9002484,9002485,9002486,9002487,9002488,9002489,9002490,9002491,9002492,9002493,9002494,9002495,9002496,9002497,9002498,9002499,9002500,9002501,9002502,9002503,9002504,9002505,9002506,9002507,9002508,9002509,9002510,9002511,9002512,9002513,9002514,9002515,9002516,9002517,9002518,9002519,9002520,9002521,9002522,9002523,9002524,9002525,9002526,9002527,9002528,9002529,9002530,9002531,9002532,9002533,9002534,9002535,9002536,9002537,9002538,9002539,9002540,9002541,9002542,9002543,9002544,9002545,9002546,9002547,9002548,9002549,9002550,9002551,9002552,9002553,9002554,9002555,9002556,9002557,9002558,9002559,9002560,9002561,9002562,9002563,9002564,9002565,9002566,9002567,9002568,9002569,9002570,9002571,9002572,9002573,9002574,9002575,9002576,9002577,9002578,9002579,9002580,9002581,9002582,9002583,9002584,9002585,9002586,9002587,9002588,9002589,9002590,9002591,9002592,9002593,9002594,9002595,9002596,9002597,9002598,9002599,9002600,9002601,9002602,9002603,9002604,9002605,9002606,9002607,9002608,9002609,9002610,9002611,9002612,9002613,9002614,9002615,9002616,9002617,9002618,9002619,9002620,9002621,9002622,9002623,9002624,9002625,9002626,9002627,9002628,9002629,9002630,9002631,9002632,9002633,9002634,9002635,9002636,9002637,9002638,9002639,9002640,9002641,9002642,9002643,9002644,9002645,9002646,9002647,9002648,9002649,9002650,9002651,9002652,9002653,9002654,9002655,9002656,9002657,9002658,9002659,9002660,9002661,9002662,9002663,9002664,9002665,9002666,9002667,9002668,9002669,9002670,9002671,9002672,9002673,9002674,9002675,9002676,9002677,9002678,9002679,9002680,9002681,9002682,9002683,9002684,9002685,9002686,9002687,9002688,9002689,9002690,9002691,9002692,9002693,9002694,9002695,9002696,9002697,9002698,9002699,9002700,9002701,9002702,9002703,9002704,9002705,9002706,9002707,9002708,9002709,9002710,9002711,9002712,9002713,9002714,9002715,9002716,9002717,9002718,9002719,9002720,9002721,9002722,9002723,9002724,9002725,9002726,9002727,9002728,9002729,9002730,9002731,9002732,9002733,9002734,9002735,9002736,9002737,9002738,9002739,9002740,9002741,9002742,9002743,9002744,9002745,9002746,9002747,9002748,9002749,9002750,9002751,9002752,9002753,9002754,9002755,9002756,9002757,9002758,9002759,9002760,9002761,9002762,9002763,9002764,9002765,9002766,9002767,9002768,9002769,9002770,9002771,9002772,9002773,9002774,9002775,9002776,9002777,9002778,9002779,9002780,9002781,9002782,9002783,9002784,9002785,9002786,9002787,9002788,9002789,9002790,9002791,9002792,9002793,9002794,9002795,9002796,9002797,9002798,9002799,9002800,9002801,9002802,9002803,9002804,9002805,9002806,9002807,9002808,9002809,9002810,9002811,9002812,9002813,9002814,9002815,9002816,9002817,9002818,9002819,9002820,9002821,9002822,9002823,9002824,9002825,9002826,9002827,9002828,9002829,9002830,9002831,9002832,9002833,9002834,9002835,9002836,9002837,9002838,9002839,9002840,9002841,9002842,9002843,9002844,9002845,9002846,9002847,9002848,9002849,9002850,9002851,9002852,9002853,9002854,9002855,9002856,9002857,9002858,9002859,9002860,9002861,9002862,9002863,9002864,9002865,9002866,9002867,9002868,9002869,9002870,9002871,9002872,9002873,9002874,9002875,9002876,9002877,9002878,9002879,9002880,9002881,9002882,9002883,9002884,9002885,9002886,9002887,9002888,9002889,9002890,9002891,9002892,9002893,9002894,9002895,9002896,9002897,9002898,9002899,9002900,9002901,9002902,9002903,9002904,9002905,9002906,9002907,9002908,9002909,9002910,9002911,9002912,9002913,9002914,9002915,9002916,9002917,9002918,9002919,9002920,9002921,9002922,9002923,9002924,9002925,9002926,9002927,9002928,9002929,9002930,9002931,9002932,9002933,9002934,9002935,9002936,9002937,9002938,9002939,9002940,9002941,9002942,9002943,9002944,9002945,9002946,9002947,9002948,9002949,9002950,9002951,9002952,9002953,9002954,9002955,9002956,9002957,9002958,9002959,9002960,9002961,9002962,9002963,9002964,9002965,9002966,9002967,9002968,9002969,9002970,9002971,9002972,9002973,9002974,9002975,9002976,9002977,9002978,9002979,9002980,9002981,9002982,9002983,9002984,9002985,9002986,9002987,9002988,9002989,9002990,9002991,9002992,9002993,9002994,9002995,9002996,9002997,9002998,9002999,9003000,9003001,9003002,9003003,9003004,9003005,9003006,9003007,9003008,9003009,9003010,9003011,9003012,9003013,9003014,9003015,9003016,9003017,9003018,9003019,9003020,9003021,9003022,9003023,9003024,9003025,9003026,9003027,9003028,9003029,9003030,9003031,9003032,9003033,9003034,9003035,9003036,9003037,9003038,9003039,9003040,9003041,9003042,9003043,9003044,9003045,9003046,9003047,9003048,9003049,9003050,9003051,9003052,9003053,9003054,9003055,9003056,9003057,9003058,9003059,9003060,9003061,9003062,9003063,9003064,9003065,9003066,9003067,9003068,9003069,9003070,9003071,9003072,9003073,9003074,9003075,9003076,9003077,9003078,9003079,9003080,9003081,9003082,9003083,9003084,9003085,9003086,9003087,9003088,9003089,9003090,9003091,9003092,9003093,9003094,9003095,9003096,9003097,9003098,9003099,9003100,9003101,9003102,9003103,9003104,9003105,9003106,9003107,9003108,9003109,9003110,9003111,9003112,9003113,9003114,9003115,9003116,9003117,9003118,9003119,9003120,9003121,9003122,9003123,9003124,9003125,9003126,9003127,9003128,9003129,9003130,9003131,9003132,9003133,9003134,9003135,9003136,9003137,9003138,9003139,9003140,9003141,9003142,9003143,9003144,9003145,9003146,9003147,9003148,9003149,9003150,9003151,9003152,9003153,9003154,9003155,9003156,9003157,9003158,9003159,9003160,9003161,9003162,9003163,9003164,9003165,9003166,9003167,9003168,9003169,9003170,9003171,9003172,9003173,9003174,9003175,9003176,9003177,9003178,9003179,9003180,9003181,9003182,9003183,9003184,9003185,9003186,9003187,9003188,9003189,9003190,9003191,9003192,9003193,9003194,9003195,9003196,9003197,9003198,9003199,9003200,9003201,9003202,9003203,9003204,9003205,9003206,9003207,9003208,9003209,9003210,9003211,9003212,9003213,9003214,9003215,9003216,9003217,9003218,9003219,9003220,9003221,9003222,9003223,9003224,9003225,9003226,9003227,9003228,9003229,9003230,9003231,9003232,9003233,9003234,9003235,9003236,9003237,9003238,9003239,9003240,9003241,9003242,9003243,9003244,9003245,9003246,9003247,9003248,9003249,9003250,9003251,9003252,9003253,9003254,9003255,9003256,9003257,9003258,9003259,9003260,9003261,9003262,9003263,9003264,9003265,9003266,9003267,9003268,9003269,9003270,9003271,9003272,9003273,9003274,9003275,9003276,9003277,9003278,9003279,9003280,9003281,9003282,9003283,9003284,9003285,9003286,9003287,9003288,9003289,9003290,9003291,9003292,9003293,9003294,9003295,9003296,9003297,9003298,9003299,9003300,9003301,9003302,9003303,9003304,9003305,9003306,9003307,9003308,9003309,9003310,9003311,9003312,9003313,9003314,9003315,9003316,9003317,9003318,9003319,9003360,9003361,9003362,9003363,9003364,9003365,9003366,9003367,9003368,9800000,9800001,9800002,9800003,9800004,9800005,9800006,9800007,9800008,9800009,9800010,9800011,9800012,9800019,9800020,9800021,9800022,9800023,9800024,9800025,9800026,9800027,9800028); + +-- Spells +DELETE FROM `spell_learn_spell` WHERE `entry`=125610; + +DELETE FROM `spell_totem_model` WHERE `SpellID` IN (188592,188616); + +-- Transports +DELETE FROM `transports` WHERE `entry` IN (333479, 349879, 294556, 272677, 375073); |