diff options
| -rw-r--r-- | sql/updates/world/master/2023_02_20_06_world.sql | 3 | ||||
| -rw-r--r-- | sql/updates/world/master/2023_03_04_01_world.sql | 9 |
2 files changed, 10 insertions, 2 deletions
diff --git a/sql/updates/world/master/2023_02_20_06_world.sql b/sql/updates/world/master/2023_02_20_06_world.sql index 2cf86e5561d..184adfe2193 100644 --- a/sql/updates/world/master/2023_02_20_06_world.sql +++ b/sql/updates/world/master/2023_02_20_06_world.sql @@ -368,5 +368,4 @@ INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES (@EVENT, @OGUID+137), (@EVENT, @OGUID+138), (@EVENT, @OGUID+139), -(@EVENT, @OGUID+140), -(@EVENT, @OGUID+141); +(@EVENT, @OGUID+140); diff --git a/sql/updates/world/master/2023_03_04_01_world.sql b/sql/updates/world/master/2023_03_04_01_world.sql new file mode 100644 index 00000000000..5de55d0b5db --- /dev/null +++ b/sql/updates/world/master/2023_03_04_01_world.sql @@ -0,0 +1,9 @@ +-- Orgrimmar trainers +UPDATE `trainer` SET `VerifiedBuild`=47631 WHERE `Id` IN (136, 62, 27, 407, 122, 196, 163, 10, 63, 56, 46, 880, 91, 386, 29, 133, 373); + +UPDATE `trainer_spell` SET `VerifiedBuild`=47631 WHERE (`TrainerId`=136 AND `SpellId` IN (264639,88015,88006,264633,6412,6415,93741,6499,2544,2541,2539,37836,3399,6500,2546,3400,18238,4094,21175,46684,46688,18244,18243,18240)) OR (`TrainerId`=62 AND `SpellId` IN (264466,217645,104698,95471,74234,74202,74225,74193,74232,74200,74239,74223,74207,74191,74238,74230,74214,74198,74237,74229,74213,74197,74189,74236,74220,74212,74132,74235,74211,74195,74226,74201,74240,74192,74231,74199,264457,7426,7748,7457,7771,7420,14807,14293,13538,13529,13503,13501,13485,13421,7863,13626,13622,13607,13378,7779,7857,7788,7745,13646,13890,13887,13858,13836,13822,13815,13746,13700,13695,13693,13663,13661,13648,13644,13642,13640,13637,13631,13635,14810,14809,13659,63746,217637,13939,13937,13935,13917,13905,17181,17180,13948,13943,13941,20023,20013,20028,20016,20012,20008)) OR (`TrainerId`=27 AND `SpellId` IN (330158,330157,330156,330155,330154,264441,76179,76262,76281,76280,76180,76263,76291,76178,76474,76441,76438,76437,76436,76435,76434,76433,76293,76289,76288,76287,76286,76285,76283,76270,76269,76267,76266,76265,76264,76261,76260,76259,76258,76182,76181,330143,330142,330141,330140,330134,9983,3320,3319,3294,2739,2738,264435,8880,7408,3326,3324,3323,3293,3116,2666,2665,2661,2737,2662,9987,9986,9985,3491,3337,3333,3296,19667,19666,7817,6517,8768,3331,3328,3292,3117,2675,2674,2672,2670,2668,2742,2741,2740,2664,280671,9916,9993,15972,9918,19668,3508,3506,3502,9920,9921,9935,9926,9931,9928,7223,3501,16663,16647,16646,16730,16658,16657,16649,16641,16640,9968,9961,9959,16969,16644,16643,16642,16662,16653,16652,16971,10001,19669,16639)) OR (`TrainerId`=407 AND `SpellId` IN (12760,12718,12716,12717,8895,12715,12902,12905,12903,12899,12897,12895,12907,12759,12906,12908,12758,12754,12755,84413,95705,95707,84412,264484,95703,94748,84408,81720,84431,84415,84430,84406,84429,84421,81725,84428,84420,81724,81716,84411,84403,81715,84418,84410,81722,81714,84417,84409,84432,84416,264478,7430,3931,3929,3977,3925,3923,3922,3979,3958,15255,12603,12599,3962,3961,12595,12594,12591,12589,12590,12586,12585,3967,3965,3963,12615,3939,3956,9271,8334,6458,3955,3953,3950,3949,3946,3945,3942,3941,3978,3938,3937,3936,3934,3932,3973,12584,39895,12617,63750,12622,12619,12618,19788,23070,19791,19790,19825,19795,19794,23071,19792)) OR (`TrainerId`=122 AND `SpellId` IN (264244,96252,96254,96253,80477,80478,93935,94162,80726,80725,80508,80251,80250,80248,80247,80246,80245,80244,80243,80237,78866,80723,80721,80720,80719,80498,80497,80496,80493,80494,80495,80492,80491,80490,80488,80487,80486,80484,80482,80269,80481,80480,80479,264212,2331,2334,3170,2337,2332,7934,63732,7845,7841,7836,7837,7179,3447,3177,3176,3173,3171,3449,22808,7181,12609,11457,11448,11451,11450,11449,3452,3448,3450,114786,17551,17573,17572,17557,17556,17555,17553,17552,11478,11467,11465,11461,11460,15833)) OR (`TrainerId`=196 AND `SpellId` IN (265862,265856)) OR (`TrainerId`=163 AND `SpellId` IN (330241,330240,330239,330238,330237,264623,134585,99537,94743,75250,75264,75249,75247,74964,75248,75268,75260,75267,75263,75266,75262,75259,75261,75258,75265,75255,75292,75296,75290,75294,75269,75291,75295,75270,75297,75293,75141,75142,75145,75144,75146,75251,75252,75253,75254,75256,75257,330226,330225,330224,330223,330222,264617,3841,2394,2393,2392,2386,3840,2385,3914,8776,8465,7624,7623,3755,12046,12045,2402,2964,2396,3842,2397,2395,3852,3839,3859,8760,8758,8467,6690,3757,3813,6521,3845,63742,3855,3866,3850,3848,2406,2401,2399,3843,12071,12055,12052,3861,3865,8762,8764,3871,8791,8804,8799,8774,8772,8770,8766,12070,12069,12067,12065,12061,12053,12049,12050,12048,8489,8483,18453,18451,18442,18437,18424,18423,18411,18407,18403,12082,12076,18446,18444,18441,18438,18421,18420,18417,18416,18415,18402,18401,12092,12088,12079,12077,12074,12073,12072,18414,18413,18410,18409,18406,18450,18449)) OR (`TrainerId`=10 AND `SpellId` IN (271617,271663,271673,271659,271657,271661,271665)) OR (`TrainerId`=63 AND `SpellId` IN (264501,86654,89373,86653,89372,86652,89371,86643,86403,89370,86642,86402,89369,86649,86641,86609,86401,85785,89368,86648,86640,86616,86615,86375,86005,86004,264495,50598,50605,50612,52739,52843,48248,53462,58484,58472,92026,59478,59475,48247,58473,58485,57707,57706,57704,57703,58565,59480,59489,60336,59387,58476,58486,50599,50606,50614,59486,59484,57710,57709,57708,59491,59487,58478,58487,50600,50607,50616,59490,57712,57711,50609,50618,58480,58488,50601,50608,50617,59502,59494,59493)) OR (`TrainerId`=56 AND `SpellId` IN (330200,330199,330198,330197,330196,264584,163218,163216,99536,99535,84950,78436,78427,78432,78423,78398,78437,78405,78428,78396,78380,78419,78410,78433,78424,78415,78399,78438,78406,78420,78388,78411,78379,78416,78439,78407,330185,330184,330183,330181,330180,264578,226106,226107,226105,9065,3759,2162,2161,3756,2160,3816,3753,2153,226120,226116,226125,226119,226112,226117,226111,226121,226114,226108,226118,226113,226123,226122,226110,226124,226109,226115,20649,20648,9145,9074,9068,7135,3780,3760,3818,3770,3768,2166,3764,2168,3766,2167,2165,3817,3761,2159,3763,226126,226129,226134,226128,226127,226137,226132,226130,226131,226135,226133,226136,20650,9206,9201,9198,9196,7156,7151,7147,6661,10518,10511,10507,10499,10487,10482,3776,3774,24654,36076,36075,10650,24655,10647,36074,10630,10632,22331,19103,19102,19098,19092,19091,19083,19082,19072,19071,19065,19055,19052,10558,10556,10552,10548,19058,19047)) OR (`TrainerId`=46 AND `SpellId` IN (33392,33389)) OR (`TrainerId`=880 AND `SpellId` IN (7928,7929,3278,3277,74558,74556,88893,74557,27033,27032,45546,45545,3276,18630,10840,10841,18629)) OR (`TrainerId`=91 AND `SpellId` IN (265844,74537,84038,74530,74529,265838,2659,3304,2658,3569,3308,3307,10098,16153,10097,70524)) OR (`TrainerId`=386 AND `SpellId` IN (90266,33389,33392,34092)) OR (`TrainerId`=29 AND `SpellId` IN (264541,73622,99544,99543,99542,99541,99540,99539,73266,73270,73246,73268,73267,73243,73274,73250,73234,73281,73249,73241,73240,73279,73247,73239,73230,73226,73222,73225,73232,73228,73227,73223,73620,73496,73494,73478,73621,73497,73495,264533,36523,37818,32178,32179,26928,26927,26926,25280,25278,25490,25287,25284,25283,32801,25617,25612,25610,36524,38175,25615,25613,25498,25321,25318,25317,25305,32807,34959,34955,26880,26876,63743,26874,26872,25621,25620,32809,32808,34961,34960,36526,36525,62941,26911,26908,26907,26903,26902,26885,26883)) OR (`TrainerId`=133 AND `SpellId` IN (265826,265820)) OR (`TrainerId`=373 AND `SpellId` IN (158763,110394,89727,89725,89723,89726,89724,89129,80836)); + +DELETE FROM `creature_trainer` WHERE `CreatureID`=56068 AND `OptionID`=29500; +DELETE FROM `creature_trainer` WHERE `CreatureID`=3345; +INSERT INTO `creature_trainer` (`CreatureID`, `TrainerID`, `MenuID`, `OptionID`) VALUES +(3345, 62, 4168, 0); |