diff options
| -rw-r--r-- | sql/updates/world/master/2017_08_20_02_world.sql | 44 |
1 files changed, 44 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_08_20_02_world.sql b/sql/updates/world/master/2017_08_20_02_world.sql new file mode 100644 index 00000000000..6a5a31b9f52 --- /dev/null +++ b/sql/updates/world/master/2017_08_20_02_world.sql @@ -0,0 +1,44 @@ +UPDATE `quest_objectives` SET `Order`=1 WHERE `ID` IN (251751,251824,252021,252060,252614,252678,252979,257329,259088,259227,266134,267648,268422,268566,269144,269147,269177,269215,269233,269238,269242,269265,269299,269736,269756,270132,270838,271269,271893,271912, +272347,273036,273071,273142,273152,273268,273393,273399,273536,273665,273699,273718,273720,273955,274301,274341,274415,274607,274817,274914,274943,274979,274980,275018,275020,275098,275148,275425,275534,275537,276253,276259,276262,276266,276388,276761,276799,276814, +276859,277056,277118,277132,277147,277151,277162,277165,277167,277168,277169,277170,277172,277173,277175,277177,277179,277180,277181,277182,277186,277187,277188,277192,277193,277194,277200,277202,277205,277206,277207,277240,277243,277306,277332,277456,277457,277473, +277503,277505,277528,277536,277556,277564,277603,277629,277695,277742,277769,277789,277815,277818,277825,277827,277831,277854,277871,277889,277999,278011,278014,278031,278060,278062,278223,278228,278230,278236,278275,278317,278346,278376,278390,278401,278432,278465, +278473,278500,278524,278529,278585,278645,278675,278681,278729,278745,278821,278827,278870,278873,278892,278912,278928,278931,278937,278940,278950,279019,279105,279111,279127,279136,279144,279159,279202,279208,279216,279251,279292,279299,279313,279319,279326,279403, +279406,279418,279428,279507,279658,279685,279701,279709,279715,279724,279732,279737,279752,279761,279764,279765,279774,279777,279812,279837,279840,279850,279862,279870,279897,279925,279938,279951,279965,280009,280013,280017,280024,280040,280042,280051,280129,280137, +280146,280155,280160,280170,280173,280179,280194,280196,280221,280224,280229,280234,280241,280292,280297,280304,280324,280411,280464,280505,280508,280574,280638,280663,280714,280722,280771,280828,280835,280837,280843,280850,280856,280882,280885,280928,280935,280957, +280970,280982,281121,281158,281160,281198,281244,281273,281274,281282,281304,281318,281389,281585,281593,281600,281614,281637,281679,281807,281810,281811,281830,281836,281879,281891,281892,281899,281904,281958,281966,281977,281979,282035,282068,282074,282080,282105, +282122,282130,282131,282136,282259,282321,282352,282368,282423,282428,282463,282660,282671,282704,282708,282722,282735,282801,282818,283020,283030,283080,283135,283140,283166,283186,283270,283294,283319,283323,283336,283339,283363,283389,283427,283489,283498,283519, +283529,283554,283565,283577,283580,283617,283639,283649,283653,283668,283670,283672,283674,283681,283685,283696,283713,283715,283780,283797,283819,283843,283844,283887,283889,283910,283927,284015,284114,284119,284134,284158,284176,284205,284229,284237,284248,284252, +284334,284378,284382,284412,284423,284426,284432,284436,284446,284450,284460,284476,284499,284527,284533,284566,284570,284582,284583,284594,284613,284635,284670,284685,284706,284708,284713,284726,284737,284756,284764,284793,284801,284809,284875,284878,284895,284919, +284925,284931,284954,285007,285029,285078,285103,285110,285171,285208,285235,285299,285316,285318,285323,285337,285410,285440,285515,285518,285520,285522,285606,285636,285640,285653,285673,285686,285742,285849,285903,285981,285993,286055,286060,286062,286082,286138, +286159,286243,286260,286272,286273,286274,286311,286343,286351,286456,286481,286537,286580,286637,286661,286665,286667,286691,286729,286744,286778); +UPDATE `quest_objectives` SET `Order`=2 WHERE `ID` IN (251752,252022,252061,252615,252679,259228,268882,269148,269178,269216,269234,269239,269243,269300,269330,269757,270133,270839,271195,271894,271913,273037,273072,273143,273153,273400,273700,273721,274302,274420, +274608,274818,274946,275099,275316,275535,275538,275616,276254,276258,276263,276267,276800,276815,276870,277133,277152,277215,277269,277273,277307,277504,277557,277604,277630,277743,277796,277816,277855,277872,277891,278000,278012,278015,278224,278237,278318,278347, +278367,278394,278418,278466,278491,278525,278526,278530,278586,278646,278682,278730,278746,278822,278871,278932,278941,278955,279020,279046,279051,279106,279107,279137,279148,279160,279209,279217,279252,279289,279301,279327,279419,279508,279686,279710,279716,279726, +279745,279800,279813,279835,279841,279851,279863,279871,279898,279939,280014,280025,280052,280115,280127,280147,280156,280174,280180,280197,280212,280231,280293,280298,280325,280401,280443,280465,280509,280575,280664,280680,280715,280723,280773,280824,280825,280834, +280838,280857,280886,280933,280958,280971,281065,281071,281123,281145,281156,281161,281206,281210,281319,281390,281580,281586,281613,281628,281638,281680,281865,281893,281900,281946,281952,282017,282057,282081,282106,282121,282124,282309,282399,282702,282709,282802, +282813,283081,283102,283187,283325,283340,283477,283520,283530,283555,283569,283578,283622,283626,283654,283666,283675,283693,283714,283790,283820,283845,283876,283885,283890,284016,284111,284120,284150,284163,284206,284335,284379,284413,284424,284447,284451,284472, +284477,284500,284528,284530,284534,284595,284614,284704,284728,284738,284757,284810,284845,284896,284926,284932,284952,285030,285104,285172,285209,285214,285300,285319,285324,285346,285389,285411,285467,285477,285510,285641,285654,285674,285850,285904,286061,286083, +286100,286136,286179,286244,286313,286344,286352,286457,286482,286638,286728,286788,286790,286792,286796,286800,286802,286804,286809,286811,286852); +UPDATE `quest_objectives` SET `Order`=3 WHERE `ID` IN (251753,252062,252616,252680,259229,269149,269179,269217,269235,269240,269244,269758,270134,271270,271895,271915,273144,273154,273722,274609,274947,275299,276255,276257,276260,276268,276816,276869,277153,277214, +277472,277605,277631,277744,277797,277892,278001,278016,278395,278492,278519,278531,278587,278648,278683,278731,278929,278933,278942,279021,279215,279509,279626,279633,279711,279725,279757,279814,279864,279899,280053,280096,280148,280157,280164,280181,280198,280213, +280233,280263,280326,280333,280466,280576,280665,280716,280774,280839,280887,280920,281030,281084,281190,281208,281320,281396,281581,281681,281863,281901,281903,282073,282075,282083,282132,282353,282717,283082,283162,283274,283313,283341,283499,283556,283579,283676, +283818,283846,283930,284113,284121,284159,284164,284207,284250,284259,284336,284448,284535,284599,284615,284705,284739,284758,284811,284876,284927,284933,285079,285105,285111,285210,285301,285325,285412,285441,285466,285519,285521,285523,285642,285655,285675,285905, +286054,286084,286137,286220,286245,286320,286353,286458,286538,286624,286636,286639); +UPDATE `quest_objectives` SET `Order`=4 WHERE `ID` IN (259230,259230,269150,269180,269342,270135,271353,271896,274948,275300,276871,277156,277216,277272,277308,277606,277633,277745,277860,277893,278002,278018,278397,278409,278413,278532,278588,278669,278732,278934, +278973,278998,279022,279321,279510,279712,279818,279935,279993,280158,280186,280214,280299,280303,280327,280467,280526,280557,280577,280666,280717,280769,280776,280840,280921,281085,281193,281209,281400,281682,281967,282082,282354,282719,283083,283334,283342,283557, +283647,283697,283827,283847,284160,284165,284208,284260,284337,284600,284877,284928,284934,285106,285211,285239,285644,285657,285676,286354,286546,286575,286596,286625,286640); +UPDATE `quest_objectives` SET `Order`=5 WHERE `ID` IN (269343,270136,271354,271897,274949,275301,276880,277157,277523,277543,277634,277667,277894,277937,278017,278366,278398,278589,278857,278935,279511,279857,279892,280005,280159,280215,280407,280667,280725,280775, +280990,281195,281333,281417,281683,282084,283084,283335,283343,283558,284135,284149,284209,284478,284601,284646,284929,284935,284986,285107,285241,285645,285658,286143,286535,286576,286626); +UPDATE `quest_objectives` SET `Order`=6 WHERE `ID` IN (270137,270137,271194,276733,276884,277158,277309,277677,277895,278399,278410,278590,278647,279512,279936,280006,280216,280668,280724,280777,280858,281196,281685,281831,282758,283085,283559,284161,284166,284930, +284936,285188,285646,285659,286545,286627,286679); +UPDATE `quest_objectives` SET `Order`=7 WHERE `ID` IN (270138,270138,271271,276885,277159,277310,277896,278400,278591,279513,280062,280101,280217,280727,281334,281686,281832,283086,284162,284167,284491,284611,285469,286392); +UPDATE `quest_objectives` SET `Order`=8 WHERE `ID` IN (270139,270139,271202,277160,277938,278592,279273,279514,279937,280334,280500,281687,283087,283837,284151,284168,286393,286539); +UPDATE `quest_objectives` SET `Order`=9 WHERE `ID` IN (270140,270140,271284,277940,278593,279332,279515,280501,281335,281688,284177,284493,286117,286385,286492,286693); +UPDATE `quest_objectives` SET `Order`=10 WHERE `ID` IN (278360,278737,279333,279516,279928,280502,284745,286386,286493,286541,286694); +UPDATE `quest_objectives` SET `Order`=11 WHERE `ID` IN (278704,279344,279517,279930,281103,284746,286387,286544); +UPDATE `quest_objectives` SET `Order`=12 WHERE `ID` IN (278705,279345,279518,279741,284502); +UPDATE `quest_objectives` SET `Order`=13 WHERE `ID` IN (279519,279703,279929,284505); +UPDATE `quest_objectives` SET `Order`=14 WHERE `ID` IN (279520,286542); +UPDATE `quest_objectives` SET `Order`=15 WHERE `ID`=284506; +UPDATE `quest_objectives` SET `Order`=16 WHERE `ID`=286543; +UPDATE `quest_objectives` SET `Order`=17 WHERE `ID`=284470; |