diff options
| -rw-r--r-- | data/sql/updates/db_world/2021_02_15_01.sql (renamed from data/sql/updates/pending_db_world/rev_1612312014667579200.sql) | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/data/sql/updates/pending_db_world/rev_1612312014667579200.sql b/data/sql/updates/db_world/2021_02_15_01.sql index 71611ab052..4cfa001845 100644 --- a/data/sql/updates/pending_db_world/rev_1612312014667579200.sql +++ b/data/sql/updates/db_world/2021_02_15_01.sql @@ -1,3 +1,19 @@ +-- DB update 2021_02_15_00 -> 2021_02_15_01 +DROP PROCEDURE IF EXISTS `updateDb`; +DELIMITER // +CREATE PROCEDURE updateDb () +proc:BEGIN DECLARE OK VARCHAR(100) DEFAULT 'FALSE'; +SELECT COUNT(*) INTO @COLEXISTS +FROM information_schema.COLUMNS +WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'version_db_world' AND COLUMN_NAME = '2021_02_15_00'; +IF @COLEXISTS = 0 THEN LEAVE proc; END IF; +START TRANSACTION; +ALTER TABLE version_db_world CHANGE COLUMN 2021_02_15_00 2021_02_15_01 bit; +SELECT sql_rev INTO OK FROM version_db_world WHERE sql_rev = '1612312014667579200'; IF OK <> 'FALSE' THEN LEAVE proc; END IF; +-- +-- START UPDATING QUERIES +-- + INSERT INTO `version_db_world` (`sql_rev`) VALUES ('1612312014667579200'); DELETE FROM `quest_offer_reward` WHERE `ID` IN (2,11,12,16,17,19,22,23,24,26,27,30,31,32,34,38,47,52,55,56,57,58,59,60,62,71,76,77,79,88,89,90,91,92,94,96,97,98,99,101,102,103,104,105,113,114,115,116,119,120,121,124,125,128,134,146,147,150,151,152,155,157,159,162,166,168,169,171,173,174,176,178,179,180,181,183,184,185,186,188,190,191,192,193,195,197,204,206,207,208,209,211,214,216,217,218,219,220,221,222,223,224,228,231,235,240,245,246,247,249,253,257,263,267,272,278,279,283,287,289,294,295,296,297,299,303,304,308,311,312,313,317,319,323,329,337,338,341,346,347,353,355,357,358,365,367,368,369,370,372,373,374,375,376,378,380,381,383,385,386,387,388,394,395,396,397,398,399,400,408,411,415,416,417,421,422,423,425,426,427,430,433,434,435,437,441,442,445,447,449,450,451,452,454,455,456,457,459,460,464,466,467,468,470,472,473,474,480,482,483,484,486,487,491,496,498,500,501,503,505,508,510,512,515,520,521,523,527,529,531,532,537,542,543,544,545,546,549,550,552,556,557,558,564,565,566,567,568,570,571,573,574,576,577,579,581,582,583,586,587,589,590,591,592,596,597,598,600,604,605,607,608,609,613,614,615,617,618,622,623,629,630,638,644,646,651,653,660,662,664,665,666,667,673,679,680,681,682,684,685,688,692,693,694,696,697,698,699,704,710,711,712,713,715,716,718,719,720,721,722,726,728,732,733,735,737,739,742,743,744,745,746,747,748,750,754,756,759,760,761,762,765,766,767,768,769,770,771,772,773,775,776,778,781,783,784,786,788,789,791,792,804,806,808,812,813,815,816,817,819,821,822,825,826,828,831,832,835,836,838,842,844,845,846,848,849,850,851,852,853,855,861,867,868,869,871,872,873,876,880,881,882,883,884,885,886,888,891,892,893,896,898,899,906,909,910,911,913,914,915,916,917,919,920,923,925,927,930,931,932,934,936,937,938,939,943,945,947,948,951,952,953,956,957,959,962,963,964,966,971,972,973,975,976,980,981,984,985,986,990,993,994,995,997,1000,1004,1007,1008,1009,1011,1012,1014,1015,1016,1017,1018,1019,1023,1025,1026,1033,1034,1035,1038,1043,1046,1047,1048,1049,1050,1053,1054,1055,1061,1062,1064,1068,1069,1070,1071,1074,1077,1078,1080,1081,1082,1083,1084,1086,1088,1090,1091,1101,1102,1104,1105,1107,1109,1110,1113,1116,1117,1119,1123,1126,1130,1131,1133,1134,1135,1136,1137,1138,1139,1141,1142,1147,1148,1153,1159,1167,1172,1173,1176,1183,1184,1185,1197,1199,1200,1202,1204,1205,1221,1222,1238,1239,1242,1247,1248,1258,1259,1261,1262,1264,1267,1271,1274,1275,1276,1321,1322,1338,1358,1367,1369,1370,1372,1373,1380,1381,1383,1387,1389,1392,1394,1395,1396,1398,1419,1420,1422,1423,1424,1425,1427,1428,1431,1432,1433,1434,1435,1436,1438,1440,1442,1444,1445,1446,1448,1453,1455,1456,1457,1458,1459,1464,1466,1467,1470,1471,1473,1474,1475,1478,1479,1480,1481,1482,1485,1486,1487,1488,1489,1490,1491,1492,1498,1499,1503,1504,1507,1512,1517,1518,1519,1520,1522,1523,1524,1525,1527,1534,1536,1580,1581,1582,1599,1618,1638,1642,1644,1646,1648,1649,1650,1651,1652,1653,1654,1655,1657,1658,1678,1679,1680,1681,1682,1683,1684,1686,1687,1688,1689,1691,1693,1699,1703,1706,1709,1711,1716,1718,1719,1739,1778,1779,1780,1782,1784,1785,1786,1787,1788,1789,1790,1791,1792,1793,1794,1795,1796,1798,1800,1802,1803,1804,1805,1806,1819,1822,1823,1824,1839,1840,1843,1844,1845,1846,1847,1848,1858,1860,1861,1879,1880,1881,1882,1883,1884,1886,1918,1919,1920,1921,1939,1944,1945,1946,1953,1954,1955,1956,1958,1959,1960,1962,1978,1998,1999,2038,2040,2118,2138,2139,2160,2161,2178,2201,2202,2206,2218,2239,2240,2241,2242,2260,2279,2281,2282,2299,2318,2339,2358,2359,2361,2383,2398,2418,2438,2440,2459,2460,2478,2479,2499,2500,2518,2522,2541,2561,2581,2583,2584,2586,2601,2602,2608,2609,2623,2641,2662,2681,2743,2746,2748,2749,2750,2751,2752,2754,2755,2756,2758,2761,2762,2763,2765,2767,2768,2769,2770,2771,2772,2773,2782,2784,2801,2822,2841,2842,2845,2846,2847,2848,2849,2850,2852,2854,2855,2856,2857,2859,2862,2863,2865,2867,2870,2875,2876,2877,2904,2922,2923,2924,2925,2927,2928,2930,2938,2939,2940,2941,2942,2944,2963,2964,2965,2968,2969,2970,2972,2973,2974,2975,2976,2979,2980,2983,2984,2987,2990,2991,2994,2995,2996,2997,2998,2999,3000,3001,3002,3022,3042,3062,3063,3065,3082,3086,3091,3092,3093,3094,3098,3100,3101,3104,3106,3110,3114,3115,3116,3117,3122,3123,3124,3125,3126,3127,3129,3130,3161,3181,3281,3301,3321,3341,3365,3369,3370,3376,3378,3379,3402,3442,3443,3444,3449,3450,3506,3507,3514,3517,3520,3522,3523,3526,3527,3528,3541,3561,3564,3570,3625,3626,3629,3631,3633,3636,3638,3640,3642,3661,3681,3741,3761,3762,3763,3764,3783,3784,3785,3786,3789,3790,3792,3803,3804,3822,3881,3901,3902,3904,3905,3907,3942,3962,4001,4002,4004,4021,4084,4101,4102,4103,4105,4106,4107,4108,4110,4111,4112,4120,4121,4123,4126,4129,4130,4132,4133,4136,4141,4143,4144,4145,4147,4148,4161,4181,4182,4201,4242,4245,4261,4265,4266,4284,4285,4286,4287,4288,4290,4291,4292,4294,4296,4298,4300,4301,4321,4322,4363,4402,4441,4449,4450,4451,4490,4491,4495,4496,4501,4502,4507,4508,4509,4512,4513,4521,4581,4621,4641,4642,4681,4701,4721,4722,4726,4729,4732,4733,4735,4736,4737,4738,4739,4740,4761,4762,4763,4764,4765,4767,4768,4771,4781,4782,4783,4784,4785,4786,4787,4788,4801,4802,4803,4804,4805,4806,4807,4810,4811,4813,4822,4841,4867,4883,4904,4906,4921,4961,4962,4963,4964,4965,4966,4967,4968,4969,4970,4971,4972,4973,4974,4975,4976,4982,4984,5041,5054,5055,5056,5057,5061,5063,5064,5065,5081,5082,5085,5092,5096,5097,5098,5121,5124,5125,5128,5147,5155,5156,5157,5163,5165,5167,5181,5201,5213,5215,5217,5220,5223,5226,5230,5232,5234,5236,5237,5238,5241,5242,5245,5249,5250,5251,5253,5264,5282,5283,5301,5302,5305,5321,5361,5381,5382,5384,5385,5386,5401,5402,5403,5404,5405,5406,5407,5408,5461,5466,5482,5502,5503,5504,5505,5507,5508,5509,5510,5511,5513,5517,5519,5521,5524,5526,5529,5533,5534,5535,5536,5537,5541,5542,5581,5582,5621,5622,5623,5624,5625,5627,5628,5629,5631,5634,5635,5637,5639,5641,5646,5648,5650,5658,5679,5713,5723,5724,5725,5726,5727,5728,5729,5730,5741,5761,5762,5763,5781,5801,5802,5805,5821,5841,5842,5843,5844,5847,5863,5882,5884,5885,5886,5887,5889,5890,5891,5892,5893,5901,5903,5923,5924,5925,5926,5927,5928,5931,5932,5981,6001,6002,6004,6023,6025,6031,6032,6062,6063,6071,6072,6073,6081,6082,6083,6085,6086,6088,6089,6101,6102,6103,6121,6123,6124,6125,6128,6129,6130,6134,6147,6148,6162,6163,6164,6184,6187,6241,6281,6284,6285,6301,6324,6342,6343,6364,6381,6382,6386,6389,6390,6392,6393,6394,6395,6401,6441,6442,6461,6462,6481,6482,6502,6503,6504,6521,6522,6523,6544,6546,6548,6561,6563,6565,6571,6601,6602,6605,6610,6621,6622,6624,6626,6627,6628,6629,6641,6721,6741,6761,6762,6781,6804,6821,6823,6824,6827,6845,6881,6922,6962,6982,6985,7001,7003,7025,7029,7041,7046,7061,7063,7064,7065,7066,7070,7081,7082,7102,7121,7122,7123,7124,7141,7142,7161,7162,7164,7169,7223,7224,7281,7361,7386,7401,7463,7486,7488,7489,7490,7492,7494,7496,7507,7509,7541,7562,7604,7621,7623,7624,7629,7632,7633,7636,7637,7638,7639,7640,7642,7644,7645,7646,7647,7648,7653,7654,7655,7656,7657,7658,7659,7666,7667,7670,7704,7721,7722,7725,7726,7729,7730,7731,7733,7734,7735,7738,7781,7783,7791,7792,7793,7794,7796,7798,7799,7801,7802,7803,7804,7806,7807,7808,7809,7812,7813,7814,7817,7819,7820,7821,7822,7825,7826,7827,7829,7831,7832,7833,7834,7835,7837,7839,7843,7844,7845,7846,7847,7849,7861,7862,7863,7864,7865,7866,7867,7868,7881,7882,7883,7884,7885,7886,7887,7888,7889,7890,7891,7892,7893,7895,7896,7897,7898,7899,7900,7901,7902,7903,7921,7939,7941,7942,7943,7946,8041,8042,8044,8046,8047,8049,8050,8051,8056,8057,8061,8062,8063,8065,8066,8067,8068,8069,8070,8071,8073,8074,8075,8076,8080,8081,8105,8106,8107,8109,8110,8113,8114,8115,8116,8118,8119,8120,8121,8122,8124,8141,8142,8145,8146,8148,8149,8150,8151,8154,8155,8156,8157,8158,8159,8163,8164,8165,8166,8167,8168,8169,8170,8171,8181,8182,8183,8184,8185,8186,8187,8188,8189,8190,8191,8192,8195,8201,8222,8223,8232,8233,8236,8238,8239,8240,8250,8251,8252,8253,8255,8256,8258,8260,8261,8262,8263,8264,8265,8266,8267,8268,8269,8272,8273,8275,8276,8279,8287,8292,8297,8298,8300,8303,8304,8311,8312,8315,8316,8320,8326,8327,8328,8329,8331,8332,8333,8335,8338,8342,8344,8345,8346,8347,8348,8349,8351,8352,8353,8354,8355,8356,8357,8358,8359,8360,8361,8362,8363,8364,8366,8367,8371,8373,8376,8377,8378,8379,8380,8381,8382,8383,8385,8387,8388,8401,8414,8415,8416,8418,8419,8420,8423,8424,8447,8463,8464,8465,8466,8467,8468,8470,8471,8472,8473,8474,8476,8480,8483,8484,8485,8486,8488,8490,8491,8493,8494,8495,8496,8497,8500,8501,8502,8503,8505,8507,8509,8511,8512,8514,8515,8516,8517,8518,8520,8521,8522,8523,8526,8528,8529,8533,8534,8535,8536,8537,8538,8539,8540,8541,8543,8545,8546,8547,8548,8549,8550,8551,8552,8553,8554,8557,8558,8559,8562,8563,8564,8572,8573,8574,8576,8579,8581,8582,8583,8589,8590,8591,8595,8596,8601,8603,8605,8607,8608,8610,8611,8613,8614,8615,8619,8621,8622,8626,8627,8633,8634,8635,8636,8637,8638,8642,8643,8644,8645,8646,8647,8648,8649,8650,8651,8652,8653,8654,8655,8656,8660,8661,8665,8666,8670,8671,8672,8673,8674,8675,8676,8677,8678,8679,8680,8681,8682,8683,8684,8685,8686,8687,8688,8689,8690,8691,8692,8693,8694,8695,8696,8705,8706,8707,8708,8709,8710,8711,8712,8713,8714,8715,8716,8717,8718,8719,8720,8721,8722,8723,8724,8725,8726,8727,8728,8729,8731,8736,8737,8738,8739,8740,8741,8742,8744,8746,8748,8749,8750,8753,8754,8755,8758,8759,8760,8762,8764,8765,8766,8767,8770,8771,8772,8774,8775,8776,8777,8778,8779,8781,8782,8783,8784,8786,8787,8788,8790,8791,8792,8793,8794,8798,8801,8803,8808,8809,8810,8811,8812,8813,8814,8815,8816,8817,8818,8819,8820,8821,8822,8823,8824,8825,8826,8827,8828,8829,8830,8831,8832,8833,8834,8835,8836,8837,8838,8839,8840,8841,8842,8843,8844,8845,8846,8860,8861,8862,8866,8867,8868,8870,8871,8872,8873,8874,8875,8876,8877,8878,8879,8880,8881,8882,8883,8887,8888,8890,8891,8892,8894,8895,8902,8921,8946,8960,8961,8962,8963,8964,8965,8966,8967,8969,8970,8977,8978,8985,8986,8987,8988,8989,8990,8992,8994,8996,8997,8998,8999,9000,9001,9002,9003,9004,9005,9006,9007,9008,9009,9010,9011,9012,9013,9014,9015,9032,9034,9036,9037,9038,9039,9040,9041,9042,9043,9044,9045,9046,9047,9048,9049,9050,9051,9053,9054,9055,9056,9057,9058,9059,9060,9061,9063,9064,9066,9067,9068,9069,9070,9071,9072,9074,9075,9076,9077,9079,9080,9083,9084,9085,9086,9088,9089,9090,9091,9092,9093,9095,9096,9097,9098,9099,9100,9101,9102,9103,9104,9105,9106,9107,9108,9109,9110,9111,9112,9113,9114,9115,9116,9117,9118,9121,9122,9123,9124,9125,9126,9127,9128,9129,9135,9136,9137,9139,9140,9143,9146,9147,9150,9152,9153,9155,9156,9158,9159,9162,9163,9164,9165,9169,9171,9172,9177,9179,9180,9185,9187,9189,9192,9195,9196,9199,9204,9212,9215,9216,9217,9218,9219,9220,9221,9222,9223,9224,9225,9226,9227,9228,9232,9233,9234,9235,9236,9237,9238,9239,9240,9241,9242,9243,9244,9245,9246,9247,9248,9250,9252,9256,9259,9266,9267,9268,9274,9275,9277,9278,9279,9281,9282,9283,9287,9288,9289,9291,9293,9294,9305,9312,9315,9325,9327,9328,9329,9331,9332,9338,9339,9340,9342,9345,9355,9363,9365,9366,9368,9372,9373,9375,9376,9381,9383,9385,9387,9388,9392,9393,9396,9397,9398,9399,9402,9403,9404,9405,9406,9417,9421,9422,9423,9425,9426,9427,9429,9432,9434,9435,9436,9437,9439,9443,9446,9447,9451,9452,9454,9457,9461,9462,9466,9468,9470,9471,9472,9474,9485,9488,9490,9492,9493,9494,9495,9496,9500,9501,9502,9503,9504,9509,9515,9516,9518,9519,9521,9522,9523,9524,9525,9527,9528,9530,9533,9536,9543,9547,9548,9549,9551,9552,9553,9554,9558,9567,9571,9573,9574,9576,9580,9582,9584,9585,9587,9588,9589,9590,9593,9594,9599,9602,9605,9606,9609,9610,9612,9616,9617,9618,9619,9621,9624,9627,9628,9629,9631,9634,9635,9636,9637,9642,9643,9644,9646,9647,9649,9663,9664,9665,9666,9667,9668,9669,9670,9671,9676,9677,9678,9681,9682,9684,9686,9689,9691,9692,9693,9694,9700,9703,9709,9710,9722,9725,9726,9727,9728,9730,9731,9732,9736,9737,9738,9741,9743,9747,9752,9753,9756,9759,9762,9763,9764,9765,9766,9769,9774,9777,9780,9783,9786,9787,9788,9790,9791,9792,9798,9802,9806,9807,9808,9809,9812,9815,9817,9820,9823,9824,9825,9830,9831,9832,9837,9838,9843,9846,9851,9852,9855,9856,9857,9858,9860,9862,9863,9875,9877,9883,9890,9892,9894,9899,9901,9902,9907,9912,9915,9924,9925,9931,9932,9933,9935,9936,9939,9940,9948,9954,9955,9958,9959,9967,9980,9981,9986,9987,9989,9991,10008,10013,10017,10018,10019,10020,10021,10022,10023,10024,10025,10031,10035,10036,10042,10043,10045,10047,10057,10066,10067,10068,10069,10070,10071,10072,10073,10074,10075,10076,10077,10079,10086,10087,10095,10097,10098,10101,10106,10110,10113,10115,10117,10119,10120,10121,10129,10136,10138,10140,10144,10146,10162,10163,10164,10167,10171,10173,10174,10176,10182,10192,10193,10196,10200,10205,10206,10211,10212,10230,10232,10240,10241,10245,10246,10249,10255,10256,10259,10267,10268,10272,10274,10276,10278,10280,10281,10284,10286,10289,10291,10294,10295,10297,10298,10299,10301,10304,10308,10313,10318,10319,10320,10322,10324,10325,10326,10327,10328,10335,10337,10338,10341,10345,10347,10350,10351,10352,10354,10355,10356,10358,10359,10360,10361,10363,10366,10367,10368,10369,10382,10388,10389,10390,10391,10392,10393,10394,10395,10396,10397,10399,10400,10404,10407,10408,10409,10412,10416,10422,10430,10432,10446,10447,10450,10456,10457,10460,10461,10462,10463,10472,10473,10474,10475,10477,10478,10479,10480,10484,10485,10489,10490,10491,10498,10499,10500,10506,10507,10508,10509,10515,10517,10518,10520,10524,10526,10529,10530,10538,10551,10552,10553,10554,10556,10557,10562,10564,10566,10575,10576,10585,10587,10590,10598,10603,10605,10612,10613,10618,10619,10621,10622,10623,10624,10628,10650,10651,10652,10653,10654,10655,10656,10663,10666,10669,10673,10678,10686,10687,10690,10692,10704,10713,10729,10730,10731,10732,10733,10734,10735,10736,10738,10739,10740,10741,10742,10744,10748,10753,10766,10784,10786,10788,10791,10792,10795,10796,10802,10803,10807,10809,10810,10812,10813,10816,10817,10821,10827,10828,10830,10831,10836,10838,10840,10842,10845,10852,10853,10854,10855,10856,10857,10859,10864,10866,10867,10868,10869,10872,10873,10874,10875,10876,10878,10879,10882,10884,10885,10886,10887,10895,10896,10899,10905,10907,10908,10914,10916,10920,10927,10928,10935,10937,10944,10946,10956,10957,10958,10959,10961,10965,10970,10972,10975,10977,10978,10980,10982,10983,10991,10995,10997,11000,11001,11004,11005,11008,11011,11019,11020,11021,11023,11026,11027,11028,11030,11035,11049,11050,11051,11053,11056,11058,11059,11061,11065,11066,11072,11073,11074,11076,11084,11085,11093,11107,11108,11109,11110,11111,11112,11113,11114,11117,11126,11129,11132,11134,11136,11153,11154,11160,11161,11162,11163,11164,11166,11168,11171,11178,11180,11183,11188,11190,11198,11206,11223,11224,11229,11235,11236,11237,11238,11239,11241,11242,11243,11250,11252,11256,11257,11259,11262,11263,11264,11266,11267,11268,11275,11280,11281,11296,11301,11302,11305,11306,11307,11310,11312,11313,11315,11316,11331,11332,11335,11338,11339,11341,11342,11359,11361,11367,11372,11374,11382,11383,11388,11394,11395,11396,11398,11399,11400,11403,11410,11419,11421,11423,11428,11429,11431,11432,11434,11436,11449,11450,11456,11457,11458,11460,11464,11466,11470,11471,11477,11480,11481,11485,11494,11495,11496,11502,11511,11512,11515,11516,11520,11521,11523,11524,11530,11532,11537,11538,11539,11542,11543,11545,11546,11548,11549,11554,11555,11556,11557,11560,11566,11567,11568,11572,11586,11587,11590,11591,11592,11593,11594,11595,11602,11605,11607,11610,11612,11613,11619,11623,11631,11632,11635,11637,11639,11645,11646,11652,11659,11663,11670,11672,11676,11681,11683,11689,11690,11692,11695,11696,11698,11701,11710,11711,11714,11721,11722,11733,11789,11791,11792,11793,11794,11795,11796,11797,11798,11865,11871,11872,11875,11877,11878,11884,11885,11895,11897,11904,11905,11907,11909,11911,11913,11918,11941,11942,11944,11945,11949,11951,11956,11961,11963,11964,11965,11966,11972,11973,11978,11980,11983,11984,11985,11995,12005,12013,12019,12020,12032,12039,12041,12048,12054,12055,12056,12059,12062,12064,12065,12066,12067,12068,12069,12075,12085,12088,12091,12096,12097,12099,12111,12114,12120,12127,12132,12133,12136,12141,12143,12151,12152,12153,12155,12164,12169,12170,12183,12185,12188,12192,12206,12207,12209,12214,12215,12216,12219,12221,12223,12224,12225,12227,12229,12237,12240,12241,12242,12245,12250,12253,12255,12260,12268,12272,12273,12278,12280,12281,12282,12284,12285,12289,12290,12291,12293,12294,12295,12300,12301,12304,12306,12307,12314,12315,12317,12318,12319,12325,12413,12415,12420,12421,12424,12431,12432,12435,12436,12437,12438,12441,12442,12444,12453,12457,12459,12470,12471,12473,12474,12477,12482,12498,12500,12501,12507,12508,12509,12511,12541,12543,12546,12551,12554,12555,12556,12557,12558,12559,12563,12564,12566,12568,12570,12585,12587,12588,12591,12592,12597,12598,12599,12604,12606,12609,12610,12611,12613,12616,12619,12623,12629,12631,12632,12633,12639,12643,12647,12650,12657,12659,12661,12662,12669,12670,12673,12676,12677,12678,12686,12687,12706,12709,12710,12719,12721,12722,12726,12728,12729,12730,12732,12735,12737,12739,12740,12742,12743,12744,12745,12746,12747,12748,12749,12750,12766,12767,12768,12769,12772,12773,12774,12777,12778,12779,12785,12786,12788,12790,12795,12799,12801,12804,12805,12812,12824,12832,12844,12848,12852,12861,12872,12912,12919,12928,12930,12935,12936,12938,12939,12948,12955,12971,12975,12978,12979,12982,12992,12995,12999,13008,13010,13012,13013,13014,13015,13016,13017,13018,13019,13020,13024,13025,13026,13027,13028,13029,13030,13031,13032,13033,13040,13045,13049,13050,13057,13059,13069,13071,13079,13082,13085,13092,13093,13118,13125,13128,13134,13139,13141,13142,13151,13158,13187,13190,13204,13206,13211,13213,13217,13230,13231,13232,13233,13234,13237,13240,13241,13242,13243,13244,13247,13250,13256,13258,13259,13260,13264,13266,13267,13278,13279,13282,13283,13287,13288,13290,13295,13298,13305,13314,13315,13342,13343,13347,13349,13351,13358,13361,13363,13364,13376,13377,13380,13381,13382,13384,13385,13386,13392,13394,13396,13397,13400,13401,13402,13403,13404,13405,13407,13408,13409,13410,13411,13414,13421,13476,13478,13549,13592,13603,13606,13610,13611,13616,13625,13633,13634,13654,13663,13664,13665,13666,13667,13668,13671,13673,13676,13677,13679,13680,13681,13682,13684,13688,13689,13690,13694,13695,13699,13702,13704,13705,13707,13709,13710,13711,13713,13723,13724,13725,13726,13727,13728,13729,13731,13732,13733,13734,13735,13736,13737,13738,13739,13740,13741,13743,13744,13745,13746,13748,13749,13750,13752,13754,13755,13756,13757,13759,13760,13761,13763,13764,13769,13770,13774,13775,13779,13780,13784,13785,13788,13789,13790,13793,13795,13809,13810,13811,13812,13814,13821,13823,13824,13830,13833,13835,13836,13838,13861,13862,13933,14035,14047,14048,14055,14058,14060,14076,14105,14107,14151,14160,14163,14178,14180,14181,14182,14183,14351,14353,14355,14356,14418,14420,14438,14457,24216,24217,24218,24219,24220,24221,24223,24224,24225,24226,24431,24442,24480,24499,24506,24510,24511,24548,24549,24553,24557,24561,24562,24563,24576,24580,24582,24583,24584,24595,24629,24635,24636,24657,24713,24743,24749,24756,24795,24796,24798,24799,24800,24801,24802,24815,24823,24825,24826,24827,24828,24829,24830,24831,24832,24833,24834,24835,24849,24857,24869,24873,24875,24878,24912,25055,25092,25180,25181,25199,25239,25240,25242,25254,25282,25289,25348,25351,25380,25414,25415,25418,25425,25445,25446,26013,26034); @@ -3692,3 +3708,12 @@ INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, (25446, 0, 0, 0, 0, 0, 0, 0, 0, 'I\'m already beginnin\' to see what de frogs are seein\'. Ya done it perfectly, $N. Now Vol\'jin and I will see what Zalazane be plannin\'.', 12340), (26013, 0, 0, 0, 0, 0, 0, 0, 0, 'Thank you again, $c, for rescuing me from Baltharus\'s clutches!$B$BThere is still much work to be done, however....', 12340), (26034, 0, 0, 0, 0, 0, 0, 0, 0, '<Krasus listens intently as you relate your battle with Halion, and then his eyes go wide at the mention of Deathwing.>$B$BWe owe you a debt of gratitude, mortal, for driving the invaders from the Sanctum. But this news of the Destroyer is troubling beyond words. I have much to discuss with the other members of the Accord.$B$BTake these as a token of my thanks, as you gird yourselves for the coming storm.', 12340); + +-- +-- END UPDATING QUERIES +-- +COMMIT; +END // +DELIMITER ; +CALL updateDb(); +DROP PROCEDURE IF EXISTS `updateDb`; |