diff options
| -rw-r--r-- | sql/updates/world/master/2022_10_02_02_world.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_10_02_02_world.sql b/sql/updates/world/master/2022_10_02_02_world.sql new file mode 100644 index 00000000000..9be546f986e --- /dev/null +++ b/sql/updates/world/master/2022_10_02_02_world.sql @@ -0,0 +1,14 @@ +-- Update Creatures in Phase 169 to 378 +UPDATE `creature` SET `PhaseId`=378 WHERE `guid` IN (251602,251604,251605,251606,251608,251609,251610,251611,251612,251613,251614,251616,251617,251618,251619,251620,251621,251622,251623,251624,251625,251626,251627,251628,251629,251630,251631,251632,251633,251634,251635,251636,251637,251638,251639,251640,251641,251642,251643,251644,251645,251646,251647,251648,251649,251650,251651,251652,251653,251654,251655,251656,251657,251658,251659,251660,251661,251662,251663,251664,251665,251666,251667,251668,251669,251670,251671,251672,251673,251674,251675,251676,251677,251678,251679,251680,251681,251682,251683,251684,251685,251686,251687,251688,251689,251690,251691,251692,251693,251694,251695,251696,251697,251698,251699,251700,251701,251702,251703,251704,251705,251706,251707,251708,251709,251710,251711,251712,251713,251717,251718,251719,251720,251722,251723,251724,251725,251726,251727,251728,251729,251730,251731,251732,251733,251734,251735,251736,251737,251738,251739,251740,251741,251742,251743,251744,251745,251746,251747,251748,251749,251750,251751,251752,251753,251754,251755,251756,251757,251758,251759,251760,251761,251762,251763,251764,251765,251766,251767,251768,251769,251770,251771,251772,251773,251774,251775,251776,251777,251778,251779,251780,251781,251782,251783,251784,251785,251786,251787,251788,251789,251790,251791,251792,251793,251794,251795,251796,251797,251798,251799,251800,251801,251802,251803,251804,251805,251806,251807,251808,251809,251810,251811,251812,251813,251814,251815,251816,251817,251818,251819,251820,251821,251822,251823,251824,251825,251826,251827,251828,251829,251830,251831,251832,251833,251834,251835,251836,251837,251838,251839,251840,251841,251842,251843,251844,251845,251846,251847,251848,251849,251850,251851,251852,251853,251854,251855,251856,251857,251858,251859,251860,251861,251862,251863,251864,251865,251866,251867,251868,251869,251870,251871,251872,251873,251874,251875,251876,251877,251878,251879,251880,251881,251882,251883,251884,251885,251886,251887,251888,251889,251890,251891,251892,251893,251894,251895,251896,251897,251898,251899,251900,251901,251902,251903,251904,251905,251906,251907,251908,251909,251910,251911,251912,251913,251914,251915,251916,251917,251918,251919,251920,251921,251922,251923,251924,251925,251926,251927,251928,251929,251930,251931,251932,251934,251935,251936,251938,251939,251940,251941,251942,251943,251944,251945,251946,251947,251948,251949,251950,251951,251952,251953,251954,251955,251956,251957,251958,251959,251960,251961,251962,251963,251964,251965,251966,251967,251968,251969,251970,251971,251972,251973,251974,251975,251976,251977,251978,251979,251980,251981,251982,251983,251984,251985,251986,251987,251988,251989,251990,251991,251992,251993,251994,251995,251996,251997,251998,251999,252000,252001,252002,252003,252004,252005,252006,252007,252008,252009,252010,252011,252012,252013,252014,252015,252016,252017,252018,252019,252020,252021,252022,252023,252024,252025,252026,252027,252028,252029,252030,252031,252032,252033,252034,252035,252036,252037,252038,252039,252040,252041,252042,252043,252044,252045,252046,252047,252048,252049,252050,252051,252052,252053,252054,252055,252056,252057,252058,252059,252060,252061,252062,252063,252064,252065,252066,252067,252068,252069,252070,252071,252072,252073,252074,252075,252076,252077,252078,252079,252080,252081,252082,252083,252084,252085,252086,252087,252088,252089,252090,252091,252092,252093,252094,252095,252096,252097,252098,252099,252100,252101,252102,252103,252104,252105,252106,252107,252108,252109,252110,252111,252112,252113,252114,252115,252116,252117,252118,252119,252120,252121,252122,252123,252124,252125,252126,252127,252128,252129,252130,252131,252132,252133,252134,252135,252136,252137,252138,252139,252140,252141,252142,252143,252144,252145,252146,252147,252148,252149,252150,252151,252152,252153,252154,252155,252156,252157,252158,252159,252160,252161,252162,252163,252164,252165,252166,252167,252168,252169,252170,252171,252172,252173,252174,252175,252176,252177,252178,252179,252180,252181,252182,252183,252184,252185,252186,252187,252188,252189,252190,252191,252192,252193,252194,252195,252196,252197,252198,252199,252200,252201,252202,252203,252204,252205,252206,252207,252208,252209,252210,252211,252212,252213,252214,252215,252216,252217,252218,252219,252220,252221,252222,252223,252224,252225,252226,252227,252228,252229,252230,252231,252233,252234,252235,252236,252237,252239); + +-- Update GameObject in Phase 169 to 378 +UPDATE `gameobject` SET `PhaseId`=378 WHERE `guid` IN (222438,222439,222440,222441,222442,222443,222444,222445,222446,222447,222448,222449,222450,222451,222452,222453,222454,222455,222456,222457,222458,222459,222460,222461,222462,222463,222464,222465,222466,222467,222468,222469,222470,222471,222472,222473,222474,222475,222476,222477,222478,222479,222480,222481,222482,222483,222484,222485,222486,222487,222488,222489,222490,222491,222492,222493,222494,222495,222496,222497,222498,222499,222500,222501,222502,222503,222504,222505,222506,222507,222508,222509,222510,222511,222512,222513,222514,222515,222516,222517,222518,222519,222520,222521,222522,222523,222524,222525,222526,222527,222528,222529,222530,222531,222532,222533,222534,222535,222536,222537,222538,222539,222540,222541,222542,222543,222544,222545,222546,222547,222548,222549,222550,222551,222552,222553,222554,222555,222556,222557,222558,222559,222560,222561,222562,222563,222564,222565,222566,222567,222568,222569,222570,222571,222572,222573,222574,222575,222576,222577,222578,222579,222580,222581,222582,222583,222584,222585,222586,222587,222588,222589,222590,222591,222592,222593,222594,222595,222596,222597,222598,222599,222600,222601,222602,222603,222604,222605,222606,222607,222608,222609,222610,222611,222612,222613,222614,222615,222616,222617,222618,222619,222620,222621,222622,222623,222624,222625,222626); + +-- PhaseGroup 574 for Evol Fingers, Fizz Lighters, Maxx Avalanche, Brett "Coins" McQuid, Sally "Salvager" Sandscrew +UPDATE `creature` SET `PhaseId` = 0, `PhaseGroup` = 574 WHERE `guid` IN (251721, 251716, 251603, 251714, 251715); + +-- PhaseGroup 572 for Sister Goldskimmer, Meggs Dreadshredder +UPDATE `creature` SET `PhaseId` = 0, `PhaseGroup` = 572 WHERE `guid` IN (251607, 251615); + +-- PhaseGroup 570 for Ace, Gobber Izzy +UPDATE `creature` SET `PhaseId` = 0, `PhaseGroup` = 570 WHERE `guid` IN (252681, 252688, 252682); |