diff options
| author | Meji <alvaro.megias@outlook.com> | 2024-02-28 20:19:09 +0100 |
|---|---|---|
| committer | Meji <alvaro.megias@outlook.com> | 2024-02-28 20:19:09 +0100 |
| commit | 0676cbed944e914b6cd0eb501b286a699cbed2f2 (patch) | |
| tree | eea3134cd75b38937d79f163489e812b1b75fd2e | |
| parent | 91284f3f8ec24d627a865d3983336f3ef8a194a7 (diff) | |
DB/Stormwind: Update Love is in the Air stuff (Dragonflight)
| -rw-r--r-- | sql/updates/world/master/2024_02_28_04_world.sql | 455 |
1 files changed, 455 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_02_28_04_world.sql b/sql/updates/world/master/2024_02_28_04_world.sql new file mode 100644 index 00000000000..9d200bf04b5 --- /dev/null +++ b/sql/updates/world/master/2024_02_28_04_world.sql @@ -0,0 +1,455 @@ +-- Models +DELETE FROM `creature_model_info` WHERE `DisplayID` IN (116270, 106564, 116796, 112195, 115882, 115867, 115866, 115695, 115637, 115574, 100578, 111028, 111029, 111025, 114080, 85253, 106562, 114079, 107225, 106561, 106563, 115557, 115485, 115391, 114945, 114859, 114848, 109691, 109692, 88423, 114911, 114719, 114670, 114493, 114490, 114492, 114489, 114482, 114475, 114464, 114463, 114462, 114461, 114460, 113856, 113854, 112157, 112136, 112000, 111677, 110998, 116580, 116571, 116385, 88008); +INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`) VALUES +(116270, 0.165866583585739135, 1, 0, 53262), +(106564, 0.647762596607208251, 0.60000002384185791, 0, 53262), +(116796, 0.424281775951385498, 1, 0, 53262), +(112195, 0.122499994933605194, 0.349999994039535522, 0, 53262), +(115882, 0.305999994277954101, 1.5, 0, 53262), +(115867, 0.347000002861022949, 1.5, 0, 53262), +(115866, 1, 1.5, 0, 53262), +(115695, 2.157046794891357421, 10, 0, 53262), +(115637, 0.305999994277954101, 1.5, 0, 53262), +(115574, 0.347000002861022949, 1.5, 0, 53262), +(100578, 0.280177772045135498, 1, 0, 53262), +(111028, 0.218090236186981201, 0, 0, 53262), +(111029, 0.218090236186981201, 0, 0, 53262), +(111025, 0.218090236186981201, 0, 0, 53262), +(114080, 0.529112696647644042, 0.699999988079071044, 0, 53262), +(85253, 0.176249995827674865, 0.75, 0, 53262), +(106562, 0.647762596607208251, 0.60000002384185791, 0, 53262), +(114079, 0.529112696647644042, 0.699999988079071044, 0, 53262), +(107225, 0.384812593460083007, 1.5, 0, 53262), +(106561, 0.647762596607208251, 0.60000002384185791, 0, 53262), +(106563, 0.647762596607208251, 0.60000002384185791, 0, 53262), +(115557, 0.388999998569488525, 1.5, 0, 53262), +(115485, 0.305999994277954101, 1.5, 0, 53262), +(115391, 0.347222000360488891, 1.5, 0, 53262), +(114945, 0.275399982929229736, 1.349999904632568359, 0, 53262), +(114859, 0.305999994277954101, 1.5, 0, 53262), +(114848, 0.305999994277954101, 1.5, 0, 53262), +(109691, 0.208000004291534423, 1.5, 0, 53262), +(109692, 0.382999986410140991, 1.5, 0, 53262), +(88423, 0.347000002861022949, 1.5, 0, 53262), +(114911, 0.305999994277954101, 1.5, 0, 53262), +(114719, 0.652579903602600097, 0, 0, 53262), +(114670, 0.5, 1, 0, 53262), +(114493, 0.305999994277954101, 1.5, 0, 53262), +(114490, 0.388999998569488525, 1.5, 0, 53262), +(114492, 0.388999998569488525, 1.5, 0, 53262), +(114489, 0.305999994277954101, 1.5, 0, 53262), +(114482, 0.305999994277954101, 1.5, 0, 53262), +(114475, 0.305999994277954101, 1.5, 0, 53262), +(114464, 0.208000004291534423, 1.5, 0, 53262), +(114463, 0.305999994277954101, 1.5, 0, 53262), +(114462, 0.347000002861022949, 1.5, 0, 53262), +(114461, 0.347000002861022949, 1.5, 0, 53262), +(114460, 0.208000004291534423, 1.5, 0, 53262), +(113856, 0.347222000360488891, 1.5, 0, 53262), +(113854, 0.347222000360488891, 1.5, 0, 53262), +(112157, 0.305999994277954101, 1.5, 0, 53262), +(112136, 0.347222000360488891, 1.5, 0, 53262), +(112000, 0.388999998569488525, 1.5, 0, 53262), +(111677, 2.298517704010009765, 0, 0, 53262), +(110998, 0.208000004291534423, 1.5, 0, 53262), +(116580, 0.413213968276977539, 0, 0, 53262), +(116571, 0.413213968276977539, 0, 0, 53262), +(116385, 0.494568407535552978, 1.5, 0, 53262), +(88008, 0.200000002980232238, 0.377999991178512573, 0, 53262); + +UPDATE `creature_model_info` SET `VerifiedBuild`=53262 WHERE `DisplayID` IN (116639, 116640, 105214, 88061, 74903, 88443, 79382, 107683, 37817, 26347, 20109, 87563, 100577, 107226, 107223, 107224, 100271, 60611, 51535, 7119, 8353, 89221, 91954, 33678, 82587, 91937, 37997, 91935, 82584, 39631, 82854, 13069, 28913, 70272, 18553, 77940, 68020, 28158, 93394, 107926, 107889, 18487, 26300, 35274, 26299, 25644, 25623, 25880, 26390, 81362, 25983, 25567, 71286, 113855, 62185, 30815, 105104, 26375, 111365, 64062, 110548, 110546, 76222, 110242, 110234, 110231, 110189, 110178, 110176, 110175, 110174, 110173, 110172, 110164, 68845, 110154, 110153, 110111, 104198, 104187, 109896, 109889, 109706, 109621, 109614, 109492, 74513, 109485, 109484, 110325, 94031, 94032, 108810, 108812, 108842, 108856, 108854, 108857, 108855, 108866, 110238, 110225, 110237, 105546, 107560, 31992, 106965, 106966, 105247, 27153, 100186, 100185, 100184, 100180, 100179, 100178, 100177, 100176, 100175, 100174, 100173, 100172, 100171, 100170, 100169, 100168, 100167, 100166, 100165, 100164, 100163, 100162, 100161, 100160, 100003, 100004, 100159, 99666, 913, 99615, 78345, 99375, 100727, 98599, 98571, 25777, 25375, 99917, 10569, 3300, 3304, 98008, 71257, 96328, 96084, 96423, 96332, 96086, 96326, 96329, 89870, 24877, 95808, 95595, 95596, 95599, 95600, 95602, 95603, 95605, 95606, 95608, 95609, 95610, 95611, 95616, 95617, 95619, 95621, 95626, 95627, 95628, 95629, 95041, 93533, 93532, 93520, 93516, 83234, 93415, 93417, 93410, 93412, 81532, 85210, 92463, 92464, 92198, 28048, 2270, 91081, 91080, 87011, 91079, 89885, 56857, 99420, 17514, 18327, 90360, 90359, 90354, 90344, 90339, 90340, 90336, 90331, 90329, 90208, 90206, 90201, 90209, 90207, 46209, 67053, 18930, 90104, 26069, 26067, 89932, 89933, 89930, 89931, 20988, 20985, 89786, 89785, 90197, 89777, 89772, 89771, 89374, 77406, 77405, 77407, 87815, 5369, 85246, 44820, 77690, 77687, 87694, 87508, 87182, 88608, 88610, 88614, 88612, 18889, 18890, 83233, 83231, 46929, 82897, 5131, 68512, 81436, 41667, 78428, 73494, 73152, 72724, 57211, 72447, 72181, 28067, 68729, 68632, 16910, 66221, 66222, 63521, 63522, 17241, 60713, 60711, 60207, 60316, 99416, 19619, 59145, 58785, 58478, 99415, 5586, 5448, 58003, 57081, 46544, 51166, 36743, 49021, 47980, 12917, 31953, 47711, 47710, 47467, 47231, 46986, 46026, 43726, 43725, 43724, 43723, 43722, 38459, 41281, 39641, 43721, 43720, 43719, 43718, 43717, 45873, 45875, 45872, 45876, 45870, 36620, 42782, 42722, 42720, 42352, 42279, 42278, 42277, 42276, 42275, 42274, 42273, 42250, 654, 19283, 10008, 26747, 26741, 40027, 40013, 39809, 39532, 39501, 39184, 21512, 38800, 38804, 38684, 38688, 99399, 38685, 38686, 38683, 19091, 38626, 38596, 38422, 70765, 31840, 31842, 31737, 31839, 38008, 37874, 22769, 33303, 37850, 99381, 37720, 37719, 37706, 37311, 37310, 36839, 36816, 36815, 36814, 37087, 36792, 36791, 36790, 36786, 31174, 257, 36656, 36758, 36597, 99379, 36213, 99500, 35540, 35539, 35537, 37372, 99187, 34396, 34336, 34160, 34070, 80, 34115, 99497, 99498, 33840, 33839, 33838, 719, 99667, 33751, 33750, 33748, 33747, 33746, 33745, 33743, 33740, 99393, 33529, 33528, 33527, 33523, 99396, 99395, 33520, 33519, 33518, 33507, 33506, 33496, 33495, 33494, 33471, 33470, 33469, 33468, 19335, 33220, 32939, 33497, 1659, 18054, 18055, 99401, 28507, 15921, 19670, 45881, 32928, 32729, 31852, 21072, 30728, 16925, 30846, 30320, 30284, 27823, 29796, 29515, 29514, 28282, 28111, 21342, 27510, 99383, 27261, 26853, 26450, 26119, 26118, 26117, 26116, 26115, 26114, 26113, 26112, 26111, 26110, 26109, 26108, 26107, 26106, 25943, 5003, 99501, 5008, 25341, 33948, 25901, 25899, 25898, 88847, 88841, 99504, 99503, 25848, 99505, 25847, 25336, 25319, 24135, 344, 19732, 19598, 19216, 81304, 18858, 18860, 17759, 17718, 17703, 17717, 17697, 17696, 17694, 17250, 16854, 81303, 15992, 15870, 15871, 15294, 15873, 15864, 15874, 15594, 15614, 15321, 14375, 14583, 14338, 14582, 8632, 14500, 14493, 14492, 14472, 14431, 13171, 12919, 12920, 12925, 12921, 12922, 12669, 12924, 12910, 5567, 13049, 11746, 11747, 11044, 10625, 10477, 10591, 99394, 10131, 9249, 8809, 7992, 7991, 7673, 7008, 6844, 6061, 6007, 6446, 7613, 5444, 5378, 4951, 4888, 4887, 4885, 4867, 5000, 4996, 4558, 5076, 3444, 3445, 3448, 3449, 3316, 3315, 3314, 3310, 3309, 99390, 3313, 3308, 3311, 3307, 3306, 99398, 3302, 3301, 99506, 99425, 3296, 3298, 3295, 19803, 3292, 3286, 3291, 99496, 3285, 3289, 3284, 3283, 3282, 3288, 3281, 4997, 5081, 99164, 3133, 3010, 5078, 5547, 2974, 3238, 2961, 4469, 2405, 2181, 1418, 2176, 1141, 3234, 1696, 99421, 1694, 1697, 1544, 1541, 5043, 1505, 2968, 1072, 1573, 99430, 1437, 1436, 1450, 1060, 11686, 5075, 1525, 856, 99951, 34004, 99949, 99947, 99950, 18931, 5077, 5565, 4449, 48989, 1357, 1519, 1509, 5570, 5549, 5553, 1758, 1765, 5074, 5545, 5552, 5551, 3258, 4998, 99418, 1473, 1472, 134, 1524, 1438, 1508, 262, 221, 338, 1501, 1498, 1500, 1503, 99422, 1502, 1518, 1522, 1511, 1521, 1516, 1523, 1513, 1512, 1515, 1520, 1517, 1510, 99186, 99185, 99193, 1486, 99423, 99424, 1477, 1491, 1489, 99417, 1494, 1480, 99198, 99194, 1441, 99499, 1443, 1432, 1447, 1427, 1446, 1445, 1423, 1449, 1439, 1429, 1448, 1440, 1434, 1444, 1431, 5548, 5073, 99392, 1499, 1507, 328, 4626, 2363, 32831, 5546, 3246, 1469, 1495, 5128, 5728, 5080, 1484, 2402, 1756, 2404, 5082, 1433, 33164, 5446, 99391, 3167, 99389, 366); +UPDATE `creature_model_info` SET `BoundingRadius`=0.249518632888793945, `CombatReach`=0.300000011920928955, `VerifiedBuild`=53262 WHERE `DisplayID`=70663; +UPDATE `creature_model_info` SET `BoundingRadius`=0.5, `VerifiedBuild`=53262 WHERE `DisplayID` IN (79383, 79380); +UPDATE `creature_model_info` SET `BoundingRadius`=1, `CombatReach`=1.5, `VerifiedBuild`=53262 WHERE `DisplayID` IN (73720, 57785); +UPDATE `creature_model_info` SET `BoundingRadius`=0.280177772045135498, `CombatReach`=1, `VerifiedBuild`=53262 WHERE `DisplayID`=87564; +UPDATE `creature_model_info` SET `BoundingRadius`=0.347222000360488891, `CombatReach`=1.5, `VerifiedBuild`=53262 WHERE `DisplayID`=59963; +UPDATE `creature_model_info` SET `BoundingRadius`=0.208000004291534423, `CombatReach`=1.5, `VerifiedBuild`=53262 WHERE `DisplayID` IN (64218, 12923); +UPDATE `creature_model_info` SET `BoundingRadius`=1, `CombatReach`=10, `VerifiedBuild`=53262 WHERE `DisplayID`=93505; +UPDATE `creature_model_info` SET `BoundingRadius`=0.375978022813796997, `CombatReach`=1.649999976158142089, `VerifiedBuild`=53262 WHERE `DisplayID`=100074; +UPDATE `creature_model_info` SET `BoundingRadius`=0.416666418313980102, `CombatReach`=1.80000007152557373, `VerifiedBuild`=53262 WHERE `DisplayID`=87530; +UPDATE `creature_model_info` SET `BoundingRadius`=1.333333373069763183, `VerifiedBuild`=53262 WHERE `DisplayID`=76046; +UPDATE `creature_model_info` SET `BoundingRadius`=1.593578934669494628, `VerifiedBuild`=53262 WHERE `DisplayID` IN (93617, 54859); +UPDATE `creature_model_info` SET `BoundingRadius`=1.20000004768371582, `VerifiedBuild`=53262 WHERE `DisplayID`=76043; +UPDATE `creature_model_info` SET `BoundingRadius`=0.75, `VerifiedBuild`=53262 WHERE `DisplayID`=87578; +UPDATE `creature_model_info` SET `BoundingRadius`=0.508511066436767578, `CombatReach`=1.833333253860473632, `VerifiedBuild`=53262 WHERE `DisplayID`=88674; +UPDATE `creature_model_info` SET `BoundingRadius`=0.239520639181137084, `VerifiedBuild`=53262 WHERE `DisplayID`=92505; +UPDATE `creature_model_info` SET `BoundingRadius`=0.216235101222991943, `CombatReach`=0.779591858386993408, `VerifiedBuild`=53262 WHERE `DisplayID`=5585; +UPDATE `creature_model_info` SET `BoundingRadius`=0.893873512744903564, `CombatReach`=2.5, `VerifiedBuild`=53262 WHERE `DisplayID`=14554; + +UPDATE `creature_template_model` SET `VerifiedBuild`=53262 WHERE (`Idx`=9 AND `CreatureID` IN (195830,214987,213411,169177,212899,187193,212670,200208,213414,139088)) OR (`Idx`=8 AND `CreatureID` IN (195830,214987,211915,213411,169177,212899,187193,212670,211916,200208,173219,213414,139088)) OR (`Idx`=7 AND `CreatureID` IN (195830,214987,211915,213411,169177,212899,187193,187196,212670,211916,200208,173219,213414,139088,213413)) OR (`Idx`=6 AND `CreatureID` IN (195830,214987,211915,211944,213411,169177,212899,193786,187193,211945,187196,212670,211916,211871,200208,173219,213414,139088,213413)) OR (`Idx`=5 AND `CreatureID` IN (195830,214987,211915,211944,213411,169177,212899,193786,187193,211945,187196,212670,211916,211871,200208,193812,173219,213414,139088,213413)) OR (`Idx`=4 AND `CreatureID` IN (195830,214987,211915,211944,213411,169177,1756,212899,193786,214391,187193,149131,211945,187196,29016,212670,211916,211871,200208,193812,173219,213414,212669,211913,139088,213413)) OR (`Idx`=3 AND `CreatureID` IN (195830,214987,149467,151249,149469,26125,68,211915,149616,211944,112698,213411,169177,214423,133441,58193,1756,53626,149433,149445,212899,193786,29712,186180,214391,187193,198071,149131,51081,149438,99541,211945,214094,112694,187196,29016,158120,149458,158125,29088,14496,149436,212670,15892,211916,211871,200208,193812,158119,52806,158123,65051,173219,213414,212669,211913,139088,42339,43102,133433,213413,65048)) OR (`Idx`=2 AND `CreatureID` IN (195830,214987,149467,151249,149469,26125,68,211915,149616,211944,112698,213411,169177,214423,133441,58193,1756,53626,149433,149445,212899,193786,29712,186180,214391,187193,214093,198071,149131,51081,149438,99541,211945,214094,112694,149124,187196,29016,158120,149458,158125,29088,14496,149436,143622,212670,49907,42421,215261,15892,211916,211871,29152,112686,200208,49540,193812,158119,52806,158123,65051,173219,213414,215464,212669,211913,139088,211872,43103,42339,4075,43102,133433,213412,213413,65048)) OR (`Idx`=1 AND `CreatureID` IN (195830,214902,214987,149467,1976,15879,151249,149469,152643,26125,68,211915,173220,149616,183978,52361,211944,214475,721,112698,213411,60931,169177,214423,1933,133441,58193,1756,53626,149433,149445,212899,162935,193786,203229,29712,186180,1423,72654,35845,197611,148124,32520,214391,147785,187193,180538,214093,198071,149131,213431,51081,149438,18927,99541,155739,148796,212392,211945,214094,112694,149124,187196,29016,158120,149458,149626,214260,29144,158125,133675,216439,29088,214422,14496,149436,143622,212670,151187,202700,49907,148233,147741,185672,42421,51348,215261,15892,211916,211871,149374,29152,112686,149099,200208,200261,49540,61080,15880,193812,158119,147714,173545,52806,158123,65051,173219,15214,23837,36817,213414,215464,94,212669,211913,180701,139088,198096,111190,211872,212340,43103,50088,38821,42339,4075,43102,203243,29019,133433,213412,213413,65048)) OR (`Idx`=0 AND `CreatureID` IN (195830,29288,214092,65061,142788,63607,2620,43825,43034,142666,5519,42782,197269,5510,14497,151251,5384,198629,151287,2708,85816,206596,197609,175416,1286,50669,211802,213096,214902,143098,214987,49908,164940,1324,54216,1370,1419,149467,1309,11827,197287,42288,198526,43822,1303,18375,43769,1976,15879,1863,212583,211803,211805,213097,1212,65058,2879,151249,209790,6089,163007,43693,4269,54219,54026,197762,1349,1435,149469,85817,5506,30713,152643,46180,176221,2198,2456,1298,141270,1427,40438,61836,12784,12780,26125,68,213392,211915,212886,198079,29293,26548,104549,65076,44394,43723,44880,176234,1416,44239,173220,164962,1325,6122,149616,158440,5567,198505,1347,185468,183978,4961,52361,50525,211944,212517,18406,214475,721,165189,212887,112698,88067,213411,62106,69334,60931,69822,43840,44235,176225,176243,6173,11069,656,169177,5502,1733,1414,85819,30730,1313,5386,185467,214423,23050,1292,44583,1291,18376,1933,142641,29300,133441,47325,58193,43725,44236,176224,151247,44243,1756,6090,54214,53626,149433,1305,149445,5498,198581,202548,44245,14438,2455,277,212899,3518,12779,2334,162935,61895,62822,213093,32638,193786,29298,203229,65071,65072,61809,176240,5489,80069,5509,1646,5482,164955,175435,3626,29712,150122,174146,198589,1333,173508,1299,49748,12480,176226,146633,176230,186180,1423,29299,65066,65065,142787,44393,176245,50435,72654,44238,164953,35845,153292,14561,176192,1323,14450,197611,148124,151937,198579,198532,43820,1257,176244,1285,32520,417,42218,15895,212587,211909,29287,214391,43451,47320,43824,1649,5484,5516,44241,164939,164956,147785,84745,158456,11828,198482,5566,1315,1318,179896,1402,8719,198533,1287,48632,52030,174170,17252,15898,15894,187193,180538,29294,158512,201230,133369,88080,214093,65068,43823,1351,197253,7798,173706,7207,167429,50424,112958,198071,5081,149131,1429,49893,3520,1320,1366,1477,52029,211874,213431,44749,51081,7917,2442,88081,214106,957,20716,197267,7232,5413,51938,1439,209303,214120,47688,5505,149438,5520,89174,1304,1300,44246,43692,56925,176233,18927,483,62821,99541,15897,29297,53352,36674,193694,172572,19269,143208,24729,340,6946,164947,50432,5495,155739,148796,2485,1311,1415,158463,130828,1314,1316,11068,83890,83883,212392,29093,69975,211945,14721,211887,32639,52654,4982,214094,112694,70296,65060,65063,6579,176238,176236,50434,5491,12336,34997,213790,58167,61839,1327,54218,1348,1368,5496,149121,149124,1310,1308,49701,284,87501,61837,175420,29142,61834,18357,213457,38066,15893,187196,4984,158589,30217,29016,158120,65074,68868,58195,63596,44396,142668,5518,43695,5492,5513,5517,2504,35365,15187,2285,4960,61840,61841,3629,199145,164961,55684,53641,149458,3627,52408,103033,3628,149626,158436,198509,1312,1405,14423,1319,1395,12785,36812,1295,51440,18360,65153,214447,4959,211873,214259,214260,125210,198515,29144,158125,126332,43841,133675,56796,928,5515,1440,171789,108180,1350,216439,54442,158753,206381,197610,57800,5499,83882,157496,28347,58154,216379,8670,15659,4974,49877,352,143820,17804,3937,15562,29290,29088,6171,209299,133409,11026,153897,14563,5514,1472,93296,1751,175138,165505,176554,164957,7208,62913,214422,44252,14559,54217,14496,149436,84751,198506,207684,204198,52031,52358,198551,1275,6174,4981,482,18359,88403,143622,211810,213094,212670,158488,151187,176239,202700,47324,142789,49907,5511,43842,34998,164941,164943,8383,54215,9584,148233,147741,1141,297,198529,1346,185672,5565,1431,1297,14439,279,42421,213606,51348,215261,15892,211916,211871,29295,149374,29154,29152,198530,112686,214091,214104,65078,65069,45226,176227,155011,164954,164952,164948,53991,149099,1307,200208,85307,4078,158755,112912,185670,157498,12783,5564,200261,44773,12481,69974,50523,35477,49540,14394,61080,61165,1860,15880,16085,213177,30,193812,29292,66876,158119,16908,176242,176222,5512,10782,176203,164949,14560,9977,147714,173545,82564,114246,185669,338,1317,176237,12781,50480,61838,71526,43819,583,212584,211812,5917,11397,29296,52806,36799,158123,65051,151256,1752,173219,164950,164942,15214,54443,209307,331,1413,23837,68980,5500,36817,12787,5493,44774,1289,5193,54660,43768,213414,215464,94,212737,213262,212669,211913,213294,180701,139088,29289,416,133408,88070,167032,151255,17103,44237,164960,164945,13283,1341,54117,198096,84749,201312,199602,113211,1321,6740,1367,50524,15872,111190,211872,1412,212340,43103,176241,207353,214988,142786,69823,43724,176231,50088,175137,1328,31146,918,38821,7295,461,5504,1339,73190,87503,5494,46602,1432,175051,42339,4075,132969,214256,211908,213560,29291,43102,203243,1444,20407,173819,29725,44392,93307,1326,51998,1371,5497,5694,85818,5503,43694,2795,11096,52359,1478,19848,61896,214446,211864,212677,141902,29019,133433,213412,213413,201194,65048,45306,176246,176223,376,1750,176220,5483,164946,199149,114832,28355,6267,83878,176235,12786,1428,2457,1301,44582,1294,71527,176229,1302,198531)) OR (`Idx`=17 AND `CreatureID` IN (214987,213411,212899,213414)) OR (`Idx`=16 AND `CreatureID` IN (214987,213411,212899,213414)) OR (`Idx`=15 AND `CreatureID` IN (214987,213411,212899,213414)) OR (`Idx`=14 AND `CreatureID` IN (214987,213411,212899,213414)) OR (`Idx`=13 AND `CreatureID` IN (214987,213411,212899,212670,213414)) OR (`Idx`=12 AND `CreatureID` IN (214987,213411,212899,212670,213414)) OR (`Idx`=11 AND `CreatureID` IN (214987,213411,169177,212899,212670,213414,139088)) OR (`Idx`=10 AND `CreatureID` IN (214987,213411,169177,212899,212670,200208,213414,139088)) OR (`Idx`=52 AND `CreatureID`=213414) OR (`Idx`=51 AND `CreatureID`=213414) OR (`Idx`=50 AND `CreatureID`=213414) OR (`Idx`=49 AND `CreatureID`=213414) OR (`Idx`=48 AND `CreatureID`=213414) OR (`Idx`=47 AND `CreatureID`=213414) OR (`Idx`=46 AND `CreatureID`=213414) OR (`Idx`=45 AND `CreatureID`=213414) OR (`Idx`=44 AND `CreatureID`=213414) OR (`Idx`=43 AND `CreatureID`=213414) OR (`Idx`=42 AND `CreatureID`=213414) OR (`Idx`=41 AND `CreatureID`=213414) OR (`Idx`=40 AND `CreatureID`=213414) OR (`Idx`=39 AND `CreatureID`=213414) OR (`Idx`=38 AND `CreatureID`=213414) OR (`Idx`=37 AND `CreatureID`=213414) OR (`Idx`=36 AND `CreatureID`=213414) OR (`Idx`=35 AND `CreatureID`=213414) OR (`Idx`=34 AND `CreatureID`=213414) OR (`Idx`=33 AND `CreatureID`=213414) OR (`Idx`=32 AND `CreatureID`=213414) OR (`Idx`=31 AND `CreatureID`=213414) OR (`Idx`=30 AND `CreatureID`=213414) OR (`Idx`=29 AND `CreatureID`=213414) OR (`Idx`=28 AND `CreatureID`=213414) OR (`Idx`=27 AND `CreatureID`=213414) OR (`Idx`=26 AND `CreatureID`=213414) OR (`Idx`=25 AND `CreatureID`=213414) OR (`Idx`=24 AND `CreatureID`=213414) OR (`Idx`=23 AND `CreatureID`=213414) OR (`Idx`=22 AND `CreatureID`=213414) OR (`Idx`=21 AND `CreatureID`=213414) OR (`Idx`=20 AND `CreatureID`=213414) OR (`Idx`=19 AND `CreatureID`=213414) OR (`Idx`=18 AND `CreatureID`=213414); + +-- Difficulties +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=53262 WHERE (`DifficultyID`=0 AND `Entry` IN (216439,209790,209303,201312,201194,200261,200208,199602,199149,199145,198629,198589,198581,198579,198551,198533,198532,198531,198530,198529,198526,198515,198509,198506,198505,198482,198096,198079,198071,197762,197611,197610,197609,197287,197269,197267,197253,195830,193812,193786,187196,187193,186180,185672,185670,185669,185468,185467,183978,180701,180538,179896,176554,176246,176245,176244,176243,176242,176241,176240,176239,176238,176237,176236,176235,176234,176233,176231,176230,176229,176227,176226,176225,176224,176223,176222,176221,176220,176203,176192,175435,175420,175416,175138,175137,175051,174170,174146,173819,173706,173545,173220,173219,172572,171789,169177,167429,167032,165505,164962,164961,164960,164957,164956,164955,164954,164953,164952,164950,164949,164948,164947,164946,164945,164943,164942,164941,164940,164939,163007,162935,158755,158753,158589,158512,158488,158463,158456,158440,158436,158125,158123,158120,158119,157498,157496,155739,155011,153292,152643,151937,151287,151256,151255,151251,151249,151247,151187,150122,149626,149616,149469,149467,149458,149445,149438,149436,149433,149374,149131,149124,149121,149099,148796,148233,148124,147785,147741,147714,146633,143622,143208,143098,142789,142788,142787,142786,142668,142666,142641,141902,141270,139088,133675,133441,133433,133409,133408,133369,132969,130828,126332,125210,114832,114246,113211,112958,112912,112698,112694,112686,111190,104549,103033,99541,93307,93296,89174,88081,88080,88070,88067,87503,87501,85819,85818,85817,85816,85307,84751,84749,84745,83890,83883,83882,83878,82564,80069,73190,72654,71527,71526,70296,69975,69974,69823,69822,69334,68980,68868,65153,65078,65076,65074,65072,65071,65069,65068,65066,65065,65063,65061,65060,65058,65051,65048,63607,63596,62913,62822,62821,62106,61896,61895,61841,61840,61839,61838,61837,61836,61834,61809,61165,61080,60931,58195,58193,58167,58154,57800,56925,56796,55684,54660,54443,54442,54219,54218,54217,54216,54215,54214,54117,54026,53991,53641,53352,52806,52654,52408,52361,52359,52358,52031,52030,52029,51998,51938,51440,51348,50669,50525,50524,50523,50480,50435,50434,50432,50424,50088,49908,49907,49893,49877,49748,49701,49540,48632,47688,47325,47324,47320,46602,46180,45306,45226,44880,44774,44773,44749,44583,44582,44395,44394,44393,44392,44252,44246,44245,44243,44241,44239,44238,44237,44236,44235,43842,43841,43840,43825,43824,43823,43822,43820,43819,43769,43768,43725,43724,43723,43690,43694,43693,43692,43451,43103,43102,43034,42782,42421,42339,42288,42218,40438,38821,38066,36817,36812,36799,36674,35845,35477,35365,34998,34997,32639,32638,32520,31146,30730,30713,30217,29725,29712,29300,29299,29298,29297,29296,29295,29294,29293,29292,29291,29290,29289,29288,29287,29154,29152,29144,29142,29093,29088,29019,29016,28355,28347,26548,24729,23837,23050,20716,20407,19848,19269,18927,18406,18376,18375,18362,18360,18359,18357,17804,17103,16908,16085,15898,15897,15895,15894,15893,15892,15659,15562,15214,15187,14721,14563,14561,14560,14559,14497,14450,14439,14438,14423,14394,13283,12787,12786,12785,12784,12783,12781,12780,12779,12481,12480,12336,11828,11827,11397,11096,11069,11068,11026,10782,9977,9584,8719,8670,8383,7917,7798,7295,7232,7208,7207,6946,6740,6579,6267,6174,6173,6171,6122,6090,6089,5917,5694,5567,5566,5565,5564,5520,5519,5518,5517,5516,5515,5514,5513,5512,5511,5510,5509,5506,5505,5504,5503,5502,5500,5499,5498,5497,5496,5495,5494,5493,5492,5491,5489,5484,5483,5482,5413,5386,5384,5193,5081,4984,4982,4981,4974,4961,4960,4959,4269,4078,4075,3937,3629,3628,3627,3626,3520,3518,2879,2795,2708,2620,2504,2485,2457,2456,2455,2442,2334,2285,2198,1976,1933,1756,1752,1751,1750,1733,1649,1646,1478,1477,1472,1444,1440,1439,1435,1432,1431,1429,1428,1427,1423,1419,1416,1415,1414,1413,1412,1405,1402,1395,1371,1370,1368,1367,1366,1351,1350,1349,1348,1347,1346,1341,1339,1333,1328,1327,1326,1325,1324,1323,1321,1320,1319,1318,1317,1316,1315,1314,1313,1312,1311,1310,1309,1308,1307,1305,1304,1303,1302,1301,1300,1299,1298,1297,1295,1294,1292,1291,1289,1287,1286,1285,1275,1257,1212,1141,957,928,918,721,656,583,483,482,461,376,352,340,338,331,308,297,284,279,277,94,68,30)); +UPDATE `creature_template_difficulty` SET `ContentTuningID`=371, `VerifiedBuild`=53262 WHERE (`Entry`=216379 AND `DifficultyID`=0); -- Buggsy +UPDATE `creature_template_difficulty` SET `ContentTuningID`=419, `VerifiedBuild`=53262 WHERE (`DifficultyID`=0 AND `Entry` IN (215464,215261)); -- [DNT] Light +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=214988 AND `DifficultyID`=0); -- Andrew +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=214987 AND `DifficultyID`=0); -- Playful Critter +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=214902 AND `DifficultyID`=0); -- [DNT] Streamer Bunny +UPDATE `creature_template_difficulty` SET `ContentTuningID`=419, `VerifiedBuild`=53262 WHERE (`Entry`=214475 AND `DifficultyID`=0); -- [DNT] Stalker +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`DifficultyID`=0 AND `Entry` IN (214447,214446)); -- O.D.I.E. +UPDATE `creature_template_difficulty` SET `ContentTuningID`=883, `VerifiedBuild`=53262 WHERE (`Entry`=214423 AND `DifficultyID`=0); -- Stormwind City Guard +UPDATE `creature_template_difficulty` SET `ContentTuningID`=883, `VerifiedBuild`=53262 WHERE (`Entry`=214422 AND `DifficultyID`=0); -- Stormwind City Patroller +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=214391 AND `DifficultyID`=0); -- Playful Fawn +UPDATE `creature_template_difficulty` SET `ContentTuningID`=861, `VerifiedBuild`=53262 WHERE (`Entry`=214260 AND `DifficultyID`=0); -- [DNT] Hitching Post Bunny +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=214259 AND `DifficultyID`=0); -- Heartseeker Mana Ray +UPDATE `creature_template_difficulty` SET `ContentTuningID`=371, `VerifiedBuild`=53262 WHERE (`Entry`=214256 AND `DifficultyID`=0); -- Heartseeker Moth +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=214120 AND `DifficultyID`=0); -- Howard Freeman +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`DifficultyID`=0 AND `Entry` IN (214106,213790)); -- Fishing Boat +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=214104 AND `DifficultyID`=0); -- Marina Hollyden +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`DifficultyID`=0 AND `Entry` IN (214094,214093,213412)); -- Dog +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=214092 AND `DifficultyID`=0); -- Mairinn Boulderbreaker +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=214091 AND `DifficultyID`=0); -- Mitiis +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=213560 AND `DifficultyID`=0); -- Steamwheedle Sleuther +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=213457 AND `DifficultyID`=0); -- Galvus Ironhammer +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=213431 AND `DifficultyID`=0); -- [DNT] Portal Bunny +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`DifficultyID`=0 AND `Entry` IN (213414,212670,212669,211916,211915,211913,211872,211871)); -- Gala Attendee +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=213413 AND `DifficultyID`=0); -- Cat +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=213411 AND `DifficultyID`=0); -- Pettable Critter +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=213392 AND `DifficultyID`=0); -- Bordol Dewgarden +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=213294 AND `DifficultyID`=0); -- Simeon Griswold +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=213262 AND `DifficultyID`=0); -- Ying +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=213177 AND `DifficultyID`=0); -- Lost Puppy +UPDATE `creature_template_difficulty` SET `ContentTuningID`=861, `VerifiedBuild`=53262 WHERE (`Entry`=213097 AND `DifficultyID`=0); -- Food Cart +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=213096 AND `DifficultyID`=0); -- Guo Plumpaw +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=213094 AND `DifficultyID`=0); -- Bimble Longberry +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=213093 AND `DifficultyID`=0); -- Sraaz +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2736, `VerifiedBuild`=53262 WHERE (`Entry`=212899 AND `DifficultyID`=0); -- Greyguard Elite +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=212887 AND `DifficultyID`=0); -- Doelia Moonwater +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=212886 AND `DifficultyID`=0); -- Melanie Charles +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=212737 AND `DifficultyID`=0); -- Bubbi Gearcrank +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=212677 AND `DifficultyID`=0); -- Gabbo Blinkwink +UPDATE `creature_template_difficulty` SET `ContentTuningID`=864, `VerifiedBuild`=53262 WHERE (`Entry`=212587 AND `DifficultyID`=0); -- Wobbley Sugarfizz +UPDATE `creature_template_difficulty` SET `ContentTuningID`=864, `VerifiedBuild`=53262 WHERE (`Entry`=212584 AND `DifficultyID`=0); -- Billibub Cogspinner +UPDATE `creature_template_difficulty` SET `ContentTuningID`=864, `VerifiedBuild`=53262 WHERE (`Entry`=212583 AND `DifficultyID`=0); -- Statiks Quikfuse +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=212517 AND `DifficultyID`=0); -- Suspicious Crate +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=212392 AND `DifficultyID`=0); -- [DNT] Smell Bunny - Crate +UPDATE `creature_template_difficulty` SET `ContentTuningID`=419, `VerifiedBuild`=53262 WHERE (`Entry`=212340 AND `DifficultyID`=0); -- Light +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`DifficultyID`=0 AND `Entry` IN (211945,211944)); -- Lovely Reveler +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=211909 AND `DifficultyID`=0); -- Thomas Bright +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=211908 AND `DifficultyID`=0); -- Miguel Bright +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=211887 AND `DifficultyID`=0); -- Sylandra Silverbreeze +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=211874 AND `DifficultyID`=0); -- Aioluus +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=211873 AND `DifficultyID`=0); -- Bang Sparknozzle +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=211864 AND `DifficultyID`=0); -- Maurice Guichi +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=211812 AND `DifficultyID`=0); -- Kiera Torres +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=211810 AND `DifficultyID`=0); -- Ronathan Graham +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=211805 AND `DifficultyID`=0); -- Fedelma Graybeard +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=211803 AND `DifficultyID`=0); -- Bonnie Stoutjaw +UPDATE `creature_template_difficulty` SET `ContentTuningID`=378, `VerifiedBuild`=53262 WHERE (`Entry`=211802 AND `DifficultyID`=0); -- Luciana Delgado +UPDATE `creature_template_difficulty` SET `ContentTuningID`=865, `VerifiedBuild`=53262 WHERE (`Entry`=209307 AND `DifficultyID`=0); -- Lorraine Darktide +UPDATE `creature_template_difficulty` SET `ContentTuningID`=865, `VerifiedBuild`=53262 WHERE (`Entry`=209299 AND `DifficultyID`=0); -- Haoqi the Curious +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2678, `VerifiedBuild`=53262 WHERE (`Entry`=207684 AND `DifficultyID`=0); -- Stagecoach +UPDATE `creature_template_difficulty` SET `ContentTuningID`=1281, `VerifiedBuild`=53262 WHERE (`Entry`=207353 AND `DifficultyID`=0); -- Arko'narin Starshade +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2678, `VerifiedBuild`=53262 WHERE (`Entry`=206596 AND `DifficultyID`=0); -- Delivery Imp +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2678, `VerifiedBuild`=53262 WHERE (`Entry`=206381 AND `DifficultyID`=0); -- Notary Imp +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2678, `VerifiedBuild`=53262 WHERE (`Entry`=204198 AND `DifficultyID`=0); -- Assistant Phineas +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2589, `VerifiedBuild`=53262 WHERE (`DifficultyID`=0 AND `Entry` IN (203243,203229)); -- Rumble Gamer +UPDATE `creature_template_difficulty` SET `ContentTuningID`=1281, `VerifiedBuild`=53262 WHERE (`Entry`=202700 AND `DifficultyID`=0); -- Lysander Starshade +UPDATE `creature_template_difficulty` SET `ContentTuningID`=371, `VerifiedBuild`=53262 WHERE (`Entry`=202548 AND `DifficultyID`=0); -- Volatile Self-Driving Toolbox +UPDATE `creature_template_difficulty` SET `ContentTuningID`=81, `VerifiedBuild`=53262 WHERE (`Entry`=201230 AND `DifficultyID`=0); -- Mizzen +UPDATE `creature_template_difficulty` SET `ContentTuningID`=371, `VerifiedBuild`=53262 WHERE (`Entry`=173508 AND `DifficultyID`=0); -- Lost Quill +UPDATE `creature_template_difficulty` SET `ContentTuningID`=708, `VerifiedBuild`=53262 WHERE (`Entry`=153897 AND `DifficultyID`=0); -- Blingtron 7000 +UPDATE `creature_template_difficulty` SET `ContentTuningID`=371, `VerifiedBuild`=53262 WHERE (`Entry`=143820 AND `DifficultyID`=0); -- Kunchong Hatchling +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=-3, `LevelScalingDeltaMax`=-3, `VerifiedBuild`=53262 WHERE (`Entry`=108180 AND `DifficultyID`=0); -- Lucas Stockton +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=-2, `LevelScalingDeltaMax`=-2, `VerifiedBuild`=53262 WHERE (`Entry`=66876 AND `DifficultyID`=0); -- Tyler Stockton +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMin`=-3, `LevelScalingDeltaMax`=-2, `VerifiedBuild`=53262 WHERE (`Entry`=53626 AND `DifficultyID`=0); -- Stormwind Orphan +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMax`=-4, `VerifiedBuild`=53262 WHERE (`Entry`=51081 AND `DifficultyID`=0); -- Nathan Stockton +UPDATE `creature_template_difficulty` SET `ContentTuningID`=877, `VerifiedBuild`=53262 WHERE (`Entry`=15880 AND `DifficultyID`=0); -- Pat's Firework Guy - GREEN +UPDATE `creature_template_difficulty` SET `ContentTuningID`=877, `VerifiedBuild`=53262 WHERE (`Entry`=15879 AND `DifficultyID`=0); -- Pat's Firework Guy - BLUE +UPDATE `creature_template_difficulty` SET `ContentTuningID`=877, `VerifiedBuild`=53262 WHERE (`Entry`=15872 AND `DifficultyID`=0); -- Pat's Firework Cluster Guy (BLUE) +UPDATE `creature_template_difficulty` SET `ContentTuningID`=482, `VerifiedBuild`=53262 WHERE (`Entry`=14505 AND `DifficultyID`=0); -- Dreadsteed +UPDATE `creature_template_difficulty` SET `LevelScalingDeltaMax`=-3, `VerifiedBuild`=53262 WHERE (`Entry`=14496 AND `DifficultyID`=0); -- Stormwind Orphan + +-- Vendors +DELETE FROM `npc_vendor` WHERE (`entry`=211887 AND `item`=22218 AND `ExtendedCost`=2728 AND `type`=1) OR (`entry`=211887 AND `item`=50163 AND `ExtendedCost`=2727 AND `type`=1) OR (`entry`=211887 AND `item`=3422 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=211887 AND `item`=3421 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=211887 AND `item`=3420 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=211887 AND `item`=3419 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=211887 AND `item`=211359 AND `ExtendedCost`=2733 AND `type`=1) OR (`entry`=211887 AND `item`=211358 AND `ExtendedCost`=2733 AND `type`=1) OR (`entry`=211887 AND `item`=211357 AND `ExtendedCost`=2733 AND `type`=1) OR (`entry`=211887 AND `item`=211355 AND `ExtendedCost`=2733 AND `type`=1) OR (`entry`=211887 AND `item`=211354 AND `ExtendedCost`=2733 AND `type`=1) OR (`entry`=211887 AND `item`=211352 AND `ExtendedCost`=2733 AND `type`=1) OR (`entry`=211887 AND `item`=211364 AND `ExtendedCost`=2727 AND `type`=1) OR (`entry`=211887 AND `item`=211363 AND `ExtendedCost`=2727 AND `type`=1) OR (`entry`=211887 AND `item`=211362 AND `ExtendedCost`=2727 AND `type`=1) OR (`entry`=211887 AND `item`=211351 AND `ExtendedCost`=2727 AND `type`=1) OR (`entry`=211887 AND `item`=211361 AND `ExtendedCost`=2727 AND `type`=1) OR (`entry`=211887 AND `item`=211360 AND `ExtendedCost`=2727 AND `type`=1) OR (`entry`=211887 AND `item`=211264 AND `ExtendedCost`=2727 AND `type`=1) OR (`entry`=211887 AND `item`=210965 AND `ExtendedCost`=2725 AND `type`=1) OR (`entry`=211812 AND `item`=204337 AND `ExtendedCost`=5791 AND `type`=1) OR (`entry`=211812 AND `item`=187998 AND `ExtendedCost`=5791 AND `type`=1) OR (`entry`=211812 AND `item`=167732 AND `ExtendedCost`=5791 AND `type`=1) OR (`entry`=211812 AND `item`=151615 AND `ExtendedCost`=5791 AND `type`=1) OR (`entry`=211812 AND `item`=122341 AND `ExtendedCost`=5791 AND `type`=1) OR (`entry`=211812 AND `item`=122339 AND `ExtendedCost`=5790 AND `type`=1) OR (`entry`=211812 AND `item`=72146 AND `ExtendedCost`=3690 AND `type`=1) OR (`entry`=211812 AND `item`=165670 AND `ExtendedCost`=6450 AND `type`=1) OR (`entry`=211812 AND `item`=142341 AND `ExtendedCost`=3690 AND `type`=1) OR (`entry`=211812 AND `item`=34480 AND `ExtendedCost`=2726 AND `type`=1) OR (`entry`=211812 AND `item`=50161 AND `ExtendedCost`=2733 AND `type`=1) OR (`entry`=211812 AND `item`=50160 AND `ExtendedCost`=2733 AND `type`=1) OR (`entry`=211812 AND `item`=116155 AND `ExtendedCost`=2729 AND `type`=1) OR (`entry`=211812 AND `item`=22235 AND `ExtendedCost`=2729 AND `type`=1) OR (`entry`=211812 AND `item`=22200 AND `ExtendedCost`=2727 AND `type`=1) OR (`entry`=211812 AND `item`=21813 AND `ExtendedCost`=2728 AND `type`=1) OR (`entry`=211812 AND `item`=210975 AND `ExtendedCost`=6149 AND `type`=1) OR (`entry`=211812 AND `item`=210974 AND `ExtendedCost`=2729 AND `type`=1) OR (`entry`=211812 AND `item`=211864 AND `ExtendedCost`=3690 AND `type`=1) OR (`entry`=211812 AND `item`=210973 AND `ExtendedCost`=3690 AND `type`=1) OR (`entry`=211812 AND `item`=205156 AND `ExtendedCost`=2729 AND `type`=1) OR (`entry`=211810 AND `item`=210821 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=211810 AND `item`=81403 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=211810 AND `item`=102539 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=211810 AND `item`=210819 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=211810 AND `item`=7228 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=211810 AND `item`=4538 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=211864 AND `item`=155810 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=211864 AND `item`=42436 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=211864 AND `item`=42433 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=211864 AND `item`=49909 AND `ExtendedCost`=2726 AND `type`=1) OR (`entry`=211805 AND `item`=128833 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=211805 AND `item`=128834 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=211805 AND `item`=81415 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=211805 AND `item`=63299 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=211805 AND `item`=44627 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=211805 AND `item`=44623 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=211805 AND `item`=40042 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=211805 AND `item`=40035 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=211805 AND `item`=2723 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=212886 AND `item`=210927 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=212886 AND `item`=128842 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=212886 AND `item`=2596 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=212886 AND `item`=62790 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=212886 AND `item`=144418 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=212886 AND `item`=19222 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=211873 AND `item`=34258 AND `ExtendedCost`=2727 AND `type`=1) OR (`entry`=211873 AND `item`=116648 AND `ExtendedCost`=2729 AND `type`=1) OR (`entry`=211873 AND `item`=144339 AND `ExtendedCost`=6149 AND `type`=1) OR (`entry`=211873 AND `item`=22261 AND `ExtendedCost`=2726 AND `type`=1) OR (`entry`=211873 AND `item`=210318 AND `ExtendedCost`=2725 AND `type`=1) OR (`entry`=211873 AND `item`=211976 AND `ExtendedCost`=2727 AND `type`=1) OR (`entry`=212587 AND `item`=210695 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=213093 AND `item`=8950 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=213096 AND `item`=210841 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=213096 AND `item`=210842 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=213094 AND `item`=81920 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=213094 AND `item`=81919 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=213094 AND `item`=58265 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=213094 AND `item`=58264 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=213094 AND `item`=35948 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=213094 AND `item`=35949 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=213094 AND `item`=27856 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=213094 AND `item`=8953 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=213094 AND `item`=4602 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=213094 AND `item`=4539 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=213094 AND `item`=4538 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=213094 AND `item`=4537 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=213094 AND `item`=4536 AND `ExtendedCost`=0 AND `type`=1); +INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES +(211810, 7, 210821, 0, 0, 1, 0, 0, 53262), -- Berry Chocolate Tart +(211810, 6, 81403, 0, 0, 1, 0, 0, 53262), -- Dried Peaches +(211810, 5, 102539, 0, 0, 1, 0, 0, 53262), -- Fresh Strawberries +(211810, 4, 210819, 0, 0, 1, 0, 0, 53262), -- Chocolate-Covered Cherries +(211810, 3, 7228, 0, 0, 1, 0, 0, 53262), -- Tigule's Strawberry Ice Cream +(211810, 2, 4538, 0, 0, 1, 0, 0, 53262), -- Snapvine Watermelon +(211812, 21, 204337, 0, 5791, 1, 0, 0, 53262), -- Awakened Heirloom Scabbard +(211812, 20, 187998, 0, 5791, 1, 0, 0, 53262), -- Eternal Heirloom Scabbard +(211812, 19, 167732, 0, 5791, 1, 0, 0, 53262), -- Battle-Hardened Heirloom Scabbard +(211812, 18, 151615, 0, 5791, 1, 0, 0, 53262), -- Weathered Heirloom Scabbard +(211812, 17, 122341, 0, 5791, 1, 0, 0, 53262), -- Timeworn Heirloom Scabbard +(211812, 16, 122339, 0, 5790, 1, 0, 0, 53262), -- Ancient Heirloom Scabbard +(211812, 15, 72146, 0, 3690, 1, 0, 0, 53262), -- Swift Lovebird +(211812, 14, 165670, 0, 6450, 1, 0, 0, 53262), -- Peddlefeet's Lovely Hearthstone +(211812, 13, 142341, 0, 3690, 1, 0, 0, 53262), -- Love Boat +(211812, 12, 34480, 0, 2726, 1, 0, 0, 53262), -- Romantic Picnic Basket +(211812, 11, 50161, 0, 2733, 1, 0, 0, 53262), -- Dinner Suit Box +(211812, 10, 50160, 0, 2733, 1, 0, 0, 53262), -- Lovely Dress Box +(211812, 9, 116155, 0, 2729, 1, 0, 0, 53262), -- Lovebird Hatchling +(211812, 8, 22235, 0, 2729, 1, 0, 0, 53262), -- Truesilver Shafted Arrow +(211812, 7, 22200, 0, 2727, 1, 0, 0, 53262), -- Silver Shafted Arrow +(211812, 6, 21813, 0, 2728, 1, 0, 0, 53262), -- Bag of Heart Candies +(211812, 5, 210975, 0, 6149, 1, 0, 0, 53262), -- Date Simulation Modulator +(211812, 4, 210974, 0, 2729, 1, 0, 0, 53262), -- Eyes For You Only +(211812, 3, 211864, 0, 3690, 1, 0, 0, 53262), -- Exquisite Love Boat +(211812, 2, 210973, 0, 3690, 1, 0, 0, 53262), -- Heartseeker Mana Ray +(211812, 1, 205156, 0, 2729, 1, 0, 0, 53262), -- Heartseeker Moth +(211864, 5, 155810, 0, 0, 1, 0, 0, 53262), -- Tirasreli Gourmet Chocolate +(211864, 4, 42436, 0, 0, 1, 0, 0, 53262), -- Chocolate Celebration Cake +(211864, 3, 42433, 0, 0, 1, 0, 0, 53262), -- Chocolate Cake Slice +(211864, 2, 49909, 0, 2726, 1, 0, 0, 53262), -- Box of Chocolates +(211805, 9, 128833, 0, 0, 1, 0, 0, 53262), -- Kaldorei Ginger Wine +(211805, 8, 128834, 0, 0, 1, 0, 0, 53262), -- Bradensbrook Gorse Wine +(211805, 7, 81415, 0, 0, 1, 0, 0, 53262), -- Pandaren Plum Wine +(211805, 6, 63299, 0, 0, 1, 0, 0, 53262), -- Sunkissed Wine +(211805, 5, 44627, 0, 0, 1, 0, 0, 53262), -- Bottle of Peaked Dalaran Red +(211805, 4, 44623, 0, 0, 1, 0, 0, 53262), -- Bottle of Dalaran Red +(211805, 3, 40042, 0, 0, 1, 0, 0, 53262), -- Caraway Burnwine +(211805, 2, 40035, 0, 0, 1, 0, 0, 53262), -- Northrend Honey Mead +(211805, 1, 2723, 0, 0, 1, 0, 0, 53262), -- Bottle of Dalaran Noir +(211887, 20, 22218, 0, 2728, 1, 0, 0, 53262), -- Handful of Rose Petals +(211887, 19, 50163, 0, 2727, 1, 0, 0, 53262), -- Lovely Rose +(211887, 18, 3422, 0, 0, 1, 0, 0, 53262), -- Beautiful Wildflowers +(211887, 17, 3421, 0, 0, 1, 0, 0, 53262), -- Simple Wildflowers +(211887, 16, 3420, 0, 0, 1, 0, 0, 53262), -- Black Rose +(211887, 15, 3419, 0, 0, 1, 0, 0, 53262), -- Red Rose +(211887, 14, 211359, 0, 2733, 1, 0, 0, 53262), -- Eternal Black Rose +(211887, 13, 211358, 0, 2733, 1, 0, 0, 53262), -- Eternal Blue Rose +(211887, 12, 211357, 0, 2733, 1, 0, 0, 53262), -- Eternal Orange Rose +(211887, 11, 211355, 0, 2733, 1, 0, 0, 53262), -- Eternal Pink Rose +(211887, 10, 211354, 0, 2733, 1, 0, 0, 53262), -- Eternal White Rose +(211887, 9, 211352, 0, 2733, 1, 0, 0, 53262), -- Eternal Yellow Rose +(211887, 8, 211364, 0, 2727, 1, 0, 0, 53262), -- Rose of Tragedy +(211887, 7, 211363, 0, 2727, 1, 0, 0, 53262), -- Rose of Dreams Fulfilled +(211887, 6, 211362, 0, 2727, 1, 0, 0, 53262), -- Rose of Independence +(211887, 5, 211351, 0, 2727, 1, 0, 0, 53262), -- Rose of Friendship +(211887, 4, 211361, 0, 2727, 1, 0, 0, 53262), -- Rose of Joy +(211887, 3, 211360, 0, 2727, 1, 0, 0, 53262), -- Rose of Purity +(211887, 2, 211264, 0, 2727, 1, 0, 0, 53262), -- Rose of Romance +(211887, 1, 210965, 0, 2725, 1, 0, 0, 53262), -- Single-Use Bouquet +(212886, 6, 210927, 0, 0, 1, 0, 0, 53262), -- Fruity Cocktail Flight +(212886, 5, 128842, 0, 0, 1, 0, 0, 53262), -- Tideskorn Mead Ale +(212886, 4, 2596, 0, 0, 1, 0, 0, 53262), -- Skin of Dwarven Stout +(212886, 3, 62790, 0, 0, 1, 0, 0, 53262), -- Darkbrew Lager +(212886, 2, 144418, 0, 0, 1, 0, 0, 53262), -- Stormwind Stout +(212886, 1, 19222, 0, 0, 1, 0, 0, 53262), -- Cheap Beer +(211873, 6, 34258, 0, 2727, 1, 0, 0, 53262), -- Lovely Fireworks +(211873, 5, 116648, 0, 2729, 1, 0, 0, 53262), -- Manufactured Love Prism +(211873, 4, 144339, 0, 6149, 1, 0, 0, 53262), -- Sturdy Love Fool +(211873, 3, 22261, 0, 2726, 1, 0, 0, 53262), -- Love Fool +(211873, 2, 210318, 0, 2725, 1, 0, 0, 53262), -- Chocolate Bon-Bomb +(211873, 1, 211976, 0, 2727, 1, 0, 0, 53262), -- Pink Brightbursts +(212587, 1, 210695, 0, 0, 1, 0, 1, 53262), -- Delightful Chocolate Sample +(213093, 1, 8950, 0, 0, 1, 0, 0, 53262), -- Homemade Cherry Pie +(213096, 3, 210841, 0, 0, 1, 0, 0, 53262), -- Buttered Oysters +(213096, 2, 210842, 0, 0, 1, 0, 0, 53262), -- Fresh Fig +(213094, 14, 81920, 0, 0, 1, 0, 0, 53262), -- Plump Fig +(213094, 13, 81919, 0, 0, 1, 0, 0, 53262), -- Red Raspberry +(213094, 12, 58265, 0, 0, 1, 0, 0, 53262), -- Highland Pomegranate +(213094, 11, 58264, 0, 0, 1, 0, 0, 53262), -- Sour Green Apple +(213094, 10, 35948, 0, 0, 1, 0, 0, 53262), -- Savory Snowplum +(213094, 9, 35949, 0, 0, 1, 0, 0, 53262), -- Tundra Berries +(213094, 8, 27856, 0, 0, 1, 0, 0, 53262), -- Skethyl Berries +(213094, 7, 8953, 0, 0, 1, 0, 0, 53262), -- Deep Fried Plantains +(213094, 6, 4602, 0, 0, 1, 0, 0, 53262), -- Moon Harvest Pumpkin +(213094, 5, 4539, 0, 0, 1, 0, 0, 53262), -- Goldenbark Apple +(213094, 4, 4538, 0, 0, 1, 0, 0, 53262), -- Snapvine Watermelon +(213094, 3, 4537, 0, 0, 1, 0, 0, 53262), -- Tel'Abim Banana +(213094, 2, 4536, 0, 0, 1, 0, 0, 53262); -- Shiny Red Apple + +-- Gameobject templates +DELETE FROM `gameobject_template` WHERE `entry` IN (419653 /*Gold Pile*/, 419652 /*Gold Pile*/, 387696 /*Rumble Coin Bag*/, 412188 /*Cup of Kafa*/, 412181 /*Steamy Romance Novels*/, 412142 /*Lovely Bouquet*/, 412140 /*Shiny New Weapon*/, 412182 /*Historic Lore Books*/, 334348 /*Beach Chair*/, 410851 /*Valentine Arch (x3.00)*/, 412186 /*Glass of Wine*/, 412189 /*Lemon Silverleaf Tea*/, 412180 /*Reading Chair*/, 419186 /*Gold Pile*/, 411703 /*Gift*/, 413961 /*Curious Swirling Pool*/, 412141 /*Book of "I.O.U." Favor Coupons*/, 415567 /*Gold Pile (Small)*/, 417298 /*Crate*/, 412762 /*Flower Wreath*/, 412183 /*Stack of Books*/, 386157 /*Rumble Foil Bag*/, 419192 /*Gold Pile*/, 414196 /*Hitching Post*/, 415694 /*Wheelchair - Small [DNT]*/, 414159 /*Crate*/, 386140 /*Rumble Foil Bag*/, 411551 /*Scenic Getaway Portal*/, 413566 /*Fizz Buzz*/, 412139 /*Barrel of Wine*/, 398823 /*Suspiciously Glowing Bucket*/); +INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `size`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `Data8`, `Data9`, `Data10`, `Data11`, `Data12`, `Data13`, `Data14`, `Data15`, `Data16`, `Data17`, `Data18`, `Data19`, `Data20`, `Data21`, `Data22`, `Data23`, `Data24`, `Data25`, `Data26`, `Data27`, `Data28`, `Data29`, `Data30`, `Data31`, `Data32`, `Data33`, `Data34`, `ContentTuningId`, `VerifiedBuild`) VALUES +(387696, 3, 68890, 'Rumble Coin Bag', 'lootall', '', '', 0.5, 2173, 0, 10, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5584, 117205, 0, 0, 0, 0, 877, 53262), -- Rumble Coin Bag +(412188, 10, 77710, 'Cup of Kafa', '', '', '', 0.5, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 396589, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 53262), -- Cup of Kafa +(412181, 10, 74548, 'Steamy Romance Novels', 'lootall', '', '', 1, 0, 0, 0, 3000, 0, 0, 1, 0, 0, 0, 427689, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 115997, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 378, 53262), -- Steamy Romance Novels +(412142, 5, 10515, 'Lovely Bouquet', '', '', '', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 378, 53262), -- Lovely Bouquet +(412140, 5, 85542, 'Shiny New Weapon', '', '', '', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 378, 53262), -- Shiny New Weapon +(412182, 10, 51573, 'Historic Lore Books', 'lootall', '', '', 1, 0, 0, 0, 3000, 0, 0, 1, 0, 0, 0, 427691, 0, 0, 1, 0, 0, 0, 0, 1, 0, 1, 0, 115997, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 378, 53262), -- Historic Lore Books +(334348, 5, 9153, 'Beach Chair', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1281, 53262), -- Beach Chair +(410851, 5, 85945, 'Valentine Arch (x3.00)', '', '', '', 3, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 53262), -- Valentine Arch (x3.00) +(412186, 10, 30913, 'Glass of Wine', '', '', '', 1, 0, 0, 0, 3000, 0, 0, 0, 0, 0, 0, 55296, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 378, 53262), -- Glass of Wine +(412189, 10, 77709, 'Lemon Silverleaf Tea', '', '', '', 0.5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 391594, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 53262), -- Lemon Silverleaf Tea +(412180, 7, 9153, 'Reading Chair', 'vehichlecursor', '', '', 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 378, 53262), -- Reading Chair +(419186, 5, 10287, 'Gold Pile', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 53262), -- Gold Pile +(411703, 5, 49429, 'Gift', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 53262), -- Gift +(413961, 25, 86062, 'Curious Swirling Pool', '', '', '', 1, 7, 120649, 2, 6, 1628, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 53262), -- Curious Swirling Pool +(412141, 5, 31570, 'Book of \"I.O.U.\" Favor Coupons', '', '', '', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 378, 53262), -- Book of "I.O.U." Favor Coupons +(415567, 5, 35854, 'Gold Pile (Small)', '', '', '', 0.5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 53262), -- Gold Pile (Small) +(417298, 5, 86339, 'Crate', '', '', '', 0.800000011920928955, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 53262), -- Crate +(412762, 5, 85816, 'Flower Wreath', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 53262), -- Flower Wreath +(412183, 5, 85784, 'Stack of Books', 'lootall', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 378, 53262), -- Stack of Books +(386157, 3, 74449, 'Rumble Foil Bag', 'lootall', '', '', 0.5, 2173, 0, 10, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5546, 116647, 0, 0, 0, 0, 877, 53262), -- Rumble Foil Bag +(419192, 5, 7343, 'Gold Pile', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 53262), -- Gold Pile +(414196, 5, 16674, 'Hitching Post', '', '', '', 0.25, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 53262), -- Hitching Post +(415694, 5, 13401, 'Wheelchair - Small [DNT]', '', '', '', 0.899999976158142089, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 53262), -- Wheelchair - Small [DNT] +(414159, 5, 86339, 'Crate', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 53262), -- Crate +(386140, 3, 74449, 'Rumble Foil Bag', 'lootall', '', '', 0.5, 2173, 0, 10, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5542, 116044, 0, 0, 0, 0, 877, 53262), -- Rumble Foil Bag +(411551, 10, 9381, 'Scenic Getaway Portal', '', '', '', 2, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 32934, 1, 0, 0, 1, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 378, 53262), -- Scenic Getaway Portal +(413566, 10, 74454, 'Fizz Buzz', '', '', '', 1.10000002384185791, 0, 0, 0, 3000, 0, 0, 0, 0, 0, 0, 428414, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 53262), -- Fizz Buzz +(412139, 5, 75825, 'Barrel of Wine', '', '', '', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 378, 53262), -- Barrel of Wine +(398823, 5, 15575, 'Suspiciously Glowing Bucket', '', '', '', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 53262), -- Suspiciously Glowing Bucket +(419653, 5, 10287, 'Gold Pile', '', '', '', 1.5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 53262), -- Gold Pile +(419652, 5, 7343, 'Gold Pile', '', '', '', 1.20000004768371582, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 53262); -- Gold Pile + +UPDATE `gameobject_template` SET `VerifiedBuild`=53262 WHERE `entry` IN (207693, 201475, 202273, 201421, 201647, 175738, 201654, 201659, 201535, 124374, 200309, 197033, 323846, 197057, 197082, 209297, 254122, 197027, 197012, 201522, 197189, 202258, 180772, 201547, 186475, 202274, 202044, 203939, 203933, 202049, 202018, 201446, 201645, 201642, 175746, 201660, 201534, 209049, 254104, 254088, 197043, 197075, 197081, 197096, 202027, 197179, 209039, 197196, 207723, 227906, 278332, 278310, 202059, 201418, 201665, 201656, 201666, 201688, 201678, 201672, 201679, 201529, 364431, 200313, 201510, 209050, 254092, 197034, 197056, 197070, 197091, 197010, 254118, 197126, 197120, 201546, 248412, 195468, 202057, 296065, 193585, 193584, 203951, 203936, 92011, 21582, 201533, 364426, 364436, 364427, 209052, 202007, 254096, 254095, 383582, 197073, 197060, 197008, 334877, 302808, 202253, 197174, 180774, 201549, 180770, 1731, 232224, 206560, 204988, 203987, 203943, 203930, 202061, 202022, 201530, 323840, 197050, 197088, 197030, 197031, 201989, 202024, 197178, 270011, 201552, 197141, 376979, 208438, 207695, 180047, 203926, 202056, 202051, 201454, 201655, 201680, 201528, 201995, 201997, 254090, 212212, 197052, 197092, 197025, 175729, 197024, 197123, 197150, 197147, 197172, 180773, 1619, 281864, 278331, 201419, 203954, 180755, 202035, 201451, 201658, 201668, 210181, 201543, 201524, 201540, 201538, 364435, 201493, 201489, 1684, 202009, 254121, 197035, 175758, 197021, 201511, 201515, 197182, 197193, 201548, 201985, 202054, 202053, 339222, 278328, 214404, 201481, 201462, 203932, 202062, 202012, 201644, 175727, 201690, 201681, 201526, 201537, 201488, 209041, 201993, 201999, 140911, 197040, 197093, 197069, 197065, 197062, 197048, 202026, 201518, 201554, 190536, 206305, 292845, 278311, 207691, 206594, 201459, 202020, 202015, 201450, 201495, 201490, 202030, 202034, 206623, 202003, 197041, 197097, 197023, 201555, 197183, 197180, 197139, 203801, 180871, 180854, 192150, 207718, 278330, 273853, 35591, 214405, 207692, 202045, 203947, 202021, 202017, 201643, 201670, 201683, 201536, 201541, 209042, 254106, 323845, 197076, 197068, 197064, 197045, 197085, 254110, 202256, 197175, 206304, 248410, 201619, 278327, 201485, 201482, 201463, 201478, 202267, 203924, 203934, 202064, 202046, 201981, 201661, 201652, 364434, 205190, 201994, 197074, 197067, 197049, 197089, 202006, 202023, 201500, 197176, 197177, 197190, 197185, 203762, 201545, 180870, 207721, 207719, 278324, 218719, 203952, 203948, 203927, 201457, 201646, 175752, 201671, 201691, 201676, 351981, 200314, 201496, 209051, 201982, 197038, 197046, 193981, 377200, 202025, 201558, 201560, 180869, 204284, 202001, 232234, 207694, 203935, 203941, 201456, 202019, 202014, 201452, 201641, 201669, 175753, 201692, 206110, 364429, 200312, 209054, 201998, 254103, 197039, 197077, 197090, 197014, 197017, 322639, 254114, 254111, 197022, 201987, 197098, 197186, 281339, 259114, 197144, 180777, 293894, 195467, 202043, 201461, 201477, 193583, 202272, 202016, 201445, 175745, 201422, 364432, 200306, 201516, 201505, 254097, 421496, 254105, 207661, 386352, 201506, 201501, 197099, 202260, 201551, 197124, 201986, 298865, 278333, 278326, 204987, 201417, 202013, 201453, 175730, 201648, 201651, 201687, 201677, 201682, 364439, 200315, 201499, 202031, 202032, 209044, 202002, 202011, 254100, 92015, 311875, 254123, 201503, 202004, 197125, 197184, 197122, 180880, 180872, 180873, 180353, 180878, 205144, 201474, 202270, 203953, 203949, 203925, 201689, 201525, 364428, 200307, 201520, 202029, 209045, 254101, 332224, 197061, 197071, 197063, 254117, 254113, 1561, 254109, 197029, 197134, 197121, 197149, 197146, 180771, 197143, 180855, 180766, 247015, 292846, 227909, 232235, 205105, 267647, 204281, 203955, 203950, 203929, 201447, 201649, 175735, 201662, 175750, 201667, 201685, 201674, 201531, 364438, 201992, 254098, 254102, 254089, 197042, 105174, 258986, 254115, 254107, 202005, 180769, 201553, 180757, 208437, 227907, 350063, 201479, 201415, 202058, 201455, 207416, 281118, 201527, 364430, 201521, 201507, 201502, 201991, 197007, 197084, 197026, 197011, 205553, 201519, 202010, 197136, 202257, 197117, 197132, 197145, 384744, 207722, 278329, 205104, 203931, 203937, 202048, 201664, 201694, 201686, 201673, 175739, 201532, 201539, 364433, 201498, 201491, 209046, 254119, 254120, 197083, 197015, 197087, 197191, 197148, 205107, 294556, 180883, 202000, 203751, 281304, 202052, 203938, 203928, 201448, 201675, 201544, 200310, 209043, 201983, 254099, 254093, 197078, 197051, 197047, 197044, 105175, 197079, 197013, 197009, 254112, 197032, 201523, 201509, 197135, 203978, 197131, 205106, 180763, 227908, 273855, 201484, 201480, 203942, 203944, 202050, 201980, 201684, 364437, 200311, 209053, 209048, 202008, 254091, 266152, 323844, 197020, 197018, 201508, 197181, 197138, 202259, 201550, 209692, 3800, 202060, 201460, 202033, 201449, 201663, 201693, 201512, 201494, 209101, 209047, 202758, 209040, 254094, 197036, 323843, 197059, 197072, 197058, 197086, 254116, 254108, 202028, 201497, 197187, 197192, 197140, 197119, 197118, 250672, 197142, 180882, 180868, 180764, 259008, 207720, 316736, 278325, 201483, 201476, 201416, 231870, 203940, 202063, 202036, 21583, 344604, 201657, 201822, 201650, 200317, 200316, 200308, 201504, 323841, 197055, 197053, 197080, 403736, 197028, 201559, 201557, 201513, 197116, 179706, 180881, 3799, 223202, 232225, 203976, 202271, 203988, 202055, 202047, 203946, 203945, 201420, 201458, 180665, 175761, 2657, 21581, 340002, 201843, 201653, 201542, 201492, 201996, 197037, 323842, 197054, 197066, 201514, 375073, 197188, 203800, 197137, 201556, 197133, 197173, 278802, 180879, 170073); +UPDATE `gameobject_template` SET `displayId`=85816, `name`='Wreath', `VerifiedBuild`=53262 WHERE `entry`=181016; -- Standing, Exterior, Medium - Val +UPDATE `gameobject_template` SET `displayId`=85964, `VerifiedBuild`=53262 WHERE `entry`=187265; -- Romantic Umbrella +UPDATE `gameobject_template` SET `displayId`=85963, `name`='Lovely Wreath', `Data3`=1, `VerifiedBuild`=53262 WHERE `entry`=181014; -- Hanging, Square, Large - Val +UPDATE `gameobject_template` SET `displayId`=85956, `name`='Ribbon', `VerifiedBuild`=53262 WHERE `entry`=181018; -- Hanging, Tall/Thin, Medium - Val +UPDATE `gameobject_template` SET `displayId`=85959, `name`='Hanging Streamer', `VerifiedBuild`=53262 WHERE `entry`=181017; -- Hanging, Streamer - Val +UPDATE `gameobject_template` SET `displayId`=85957, `name`='Ribbon', `VerifiedBuild`=53262 WHERE `entry`=181020; -- Hanging, Square, Medium - Val +UPDATE `gameobject_template` SET `name`='Lovely Streamers', `VerifiedBuild`=53262 WHERE `entry`=181055; -- Hanging, Streamer x3 - Val +UPDATE `gameobject_template` SET `displayId`=85951, `name`='Crate', `VerifiedBuild`=53262 WHERE `entry`=181015; -- Standing, Large - Val +UPDATE `gameobject_template` SET `displayId`=85963, `name`='Lovely Wreath', `VerifiedBuild`=53262 WHERE `entry`=187575; -- Hanging, Square, Small - Val +UPDATE `gameobject_template` SET `displayId`=87309, `name`='Floating Wreath', `VerifiedBuild`=53262 WHERE `entry`=181027; -- Floating, Medium - Val +UPDATE `gameobject_template` SET `displayId`=85956, `name`='Ribbon', `VerifiedBuild`=53262 WHERE `entry`=187668; -- Hanging, Tall/Thin, Small - Val +UPDATE `gameobject_template` SET `displayId`=85955, `name`='Huge Ribbon', `Data3`=1, `VerifiedBuild`=53262 WHERE `entry`=181025; -- Hanging, Tall/Thin, Large - Val +UPDATE `gameobject_template` SET `displayId`=85960, `name`='Wreath', `VerifiedBuild`=53262 WHERE `entry`=181022; -- Standing, Giant - Val +UPDATE `gameobject_template` SET `displayId`=85954, `name`='Rose Vase', `VerifiedBuild`=53262 WHERE `entry`=181019; -- Standing, Interior, Medium - Val +UPDATE `gameobject_template` SET `ContentTuningId`=2651, `VerifiedBuild`=53262 WHERE `entry`=355054; -- Portal to Oribos + +UPDATE `gameobject_questitem` SET `VerifiedBuild`=53262 WHERE (`Idx`=0 AND `GameObjectEntry` IN (204284,205144,344604,140911,105174,203751,105175,203801,203762,203800,278802)); + +DELETE FROM `gameobject_template_addon` WHERE `entry` IN (419653 /*Gold Pile*/, 419652 /*Gold Pile*/, 419192 /*Gold Pile*/, 419186 /*Gold Pile*/, 417298 /*Crate*/, 415694 /*Wheelchair - Small [DNT]*/, 415567 /*Gold Pile (Small)*/, 414196 /*Hitching Post*/, 414159 /*Crate*/, 413566 /*Fizz Buzz*/, 412189 /*Lemon Silverleaf Tea*/, 412188 /*Cup of Kafa*/, 412186 /*Glass of Wine*/, 412183 /*Stack of Books*/, 412182 /*Historic Lore Books*/, 412181 /*Steamy Romance Novels*/, 411551 /*Scenic Getaway Portal*/, 410851 /*Valentine Arch (x3.00)*/, 387696 /*Rumble Coin Bag*/, 386157 /*Rumble Foil Bag*/, 386140 /*Rumble Foil Bag*/, 384744 /*Warcraft Rumble Machine*/, 376979 /*Soft Purple Pillow*/, 350063 /*Chromie's Hourglass*/, 344604 /*Fearbreaker*/, 339222 /*Mechagnome*/, 334348 /*Beach Chair*/, 316736 /*Kul Tiran*/, 298865 /*Dark Iron Dwarf*/, 281118 /*Gryphon Roost*/, 273855 /*Lightforged Draenei*/, 273853 /*Void Elf*/, 250672 /*Jeremy's Newer Test Object*/, 227908 /*Log Bundle*/, 227907 /*Keg Stand*/); +INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`) VALUES +(419192, 114, 0, 0, 0), -- Gold Pile +(419186, 114, 0, 0, 0), -- Gold Pile +(419653, 114, 0, 0, 0), -- Gold Pile +(419652, 114, 0, 0, 0), -- Gold Pile +(417298, 114, 0, 0, 0), -- Crate +(415694, 114, 545259520, 0, 0), -- Wheelchair - Small [DNT] +(415567, 114, 0, 0, 0), -- Gold Pile (Small) +(414196, 0, 8192, 0, 0), -- Hitching Post +(414159, 114, 0, 0, 0), -- Crate +(413566, 0, 0, 24393, 0), -- Fizz Buzz +(412189, 0, 262144, 0, 0), -- Lemon Silverleaf Tea +(412188, 0, 262144, 0, 0), -- Cup of Kafa +(412186, 0, 262144, 0, 0), -- Glass of Wine +(412183, 0, 8192, 0, 0), -- Stack of Books +(412182, 0, 262176, 24465, 0), -- Historic Lore Books +(412181, 0, 262144, 24466, 0), -- Steamy Romance Novels +(411551, 534, 579076128, 0, 27656), -- Scenic Getaway Portal +(410851, 114, 32, 0, 0), -- Valentine Arch (x3.00) +(387696, 0, 2113536, 0, 0), -- Rumble Coin Bag +(386157, 0, 2113536, 2099, 0), -- Rumble Foil Bag +(386140, 0, 0, 2099, 0), -- Rumble Foil Bag +(384744, 0, 4, 0, 0), -- Warcraft Rumble Machine +(376979, 0, 545259520, 0, 0), -- Soft Purple Pillow +(350063, 1375, 0, 0, 0), -- Chromie's Hourglass +(344604, 0, 4, 0, 0), -- Fearbreaker +(339222, 0, 262144, 0, 0), -- Mechagnome +(334348, 0, 8192, 0, 0), -- Beach Chair +(316736, 0, 262144, 0, 0), -- Kul Tiran +(298865, 0, 262144, 0, 0), -- Dark Iron Dwarf +(281118, 0, 8192, 0, 0), -- Gryphon Roost +(273855, 0, 262144, 0, 0), -- Lightforged Draenei +(273853, 0, 262144, 0, 0), -- Void Elf +(250672, 1375, 0, 0, 0), -- Jeremy's Newer Test Object +(227908, 114, 0, 0, 0), -- Log Bundle +(227907, 114, 0, 0, 0); -- Keg Stand + +UPDATE `gameobject_template_addon` SET `AIAnimKitID`=3503 WHERE `entry`=383582; -- Portal to Valdrakken +UPDATE `gameobject_template_addon` SET `AIAnimKitID`=3503 WHERE `entry`=355054; -- Portal to Oribos +UPDATE `gameobject_template_addon` SET `AIAnimKitID`=3503 WHERE `entry`=332224; -- Portal to Caverns of Time +UPDATE `gameobject_template_addon` SET `AIAnimKitID`=3503 WHERE `entry`=323846; -- Portal to Shattrath +UPDATE `gameobject_template_addon` SET `AIAnimKitID`=3503 WHERE `entry`=323845; -- Portal to Boralus +UPDATE `gameobject_template_addon` SET `AIAnimKitID`=3503 WHERE `entry`=323844; -- Portal to Jade Forest +UPDATE `gameobject_template_addon` SET `AIAnimKitID`=3503 WHERE `entry`=323843; -- Portal to the Exodar +UPDATE `gameobject_template_addon` SET `AIAnimKitID`=3503 WHERE `entry`=323842; -- Portal to Dalaran, Crystalsong Forest +UPDATE `gameobject_template_addon` SET `AIAnimKitID`=3503 WHERE `entry`=323841; -- Portal to Azsuna +UPDATE `gameobject_template_addon` SET `AIAnimKitID`=3503 WHERE `entry`=323840; -- Portal to Stormshield, Ashran +UPDATE `gameobject_template_addon` SET `WorldEffectID`=8830 WHERE `entry`=281339; -- Hero's Call Board +UPDATE `gameobject_template_addon` SET `flags`=8196 WHERE `entry`=278802; -- Weathered Supply Crate +UPDATE `gameobject_template_addon` SET `faction`=12 WHERE `entry`=259114; -- [DNT] Command Table Collision Cylinder +UPDATE `gameobject_template_addon` SET `flags`=278528 WHERE `entry`=204281; -- Worm Mound +UPDATE `gameobject_template_addon` SET `flags`=4 WHERE `entry`=203801; -- Sack of Confectioner's Sugar +UPDATE `gameobject_template_addon` SET `WorldEffectID`=16227 WHERE `entry` IN (197190, 197189, 197188); -- Barbershop Chair +UPDATE `gameobject_template_addon` SET `flags`=545259520 WHERE `entry`=187265; -- Romantic Umbrella +UPDATE `gameobject_template_addon` SET `flags`=32 WHERE `entry`=181025; -- Hanging, Tall/Thin, Large - Val +UPDATE `gameobject_template_addon` SET `flags`=545259520 WHERE `entry`=181017; -- Hanging, Streamer - Val +UPDATE `gameobject_template_addon` SET `flags`=32 WHERE `entry`=181014; -- Hanging, Square, Large - Val + +-- Quests +DELETE FROM `quest_template` WHERE `ID` IN (78332 /*I Smell Trouble*/, 78328 /*Take a Look Around*/, 76114 /*Report to the Trading Post*/, 78329 /*Love is in the Air*/); +INSERT INTO `quest_template` (`ID`, `QuestType`, `QuestPackageID`, `ContentTuningID`, `QuestSortID`, `QuestInfoID`, `SuggestedGroupNum`, `RewardNextQuest`, `RewardXPDifficulty`, `RewardXPMultiplier`, `RewardMoneyDifficulty`, `RewardMoneyMultiplier`, `RewardSpell`, `RewardHonor`, `RewardKillHonor`, `StartItem`, `RewardArtifactXPDifficulty`, `RewardArtifactXPMultiplier`, `RewardArtifactCategoryID`, `Flags`, `FlagsEx`, `FlagsEx2`, `RewardSkillLineID`, `RewardNumSkillUps`, `PortraitGiver`, `PortraitGiverMount`, `PortraitGiverModelSceneID`, `PortraitTurnIn`, `RewardItem1`, `RewardItem2`, `RewardItem3`, `RewardItem4`, `RewardAmount1`, `RewardAmount2`, `RewardAmount3`, `RewardAmount4`, `ItemDrop1`, `ItemDrop2`, `ItemDrop3`, `ItemDrop4`, `ItemDropQuantity1`, `ItemDropQuantity2`, `ItemDropQuantity3`, `ItemDropQuantity4`, `RewardChoiceItemID1`, `RewardChoiceItemID2`, `RewardChoiceItemID3`, `RewardChoiceItemID4`, `RewardChoiceItemID5`, `RewardChoiceItemID6`, `RewardChoiceItemQuantity1`, `RewardChoiceItemQuantity2`, `RewardChoiceItemQuantity3`, `RewardChoiceItemQuantity4`, `RewardChoiceItemQuantity5`, `RewardChoiceItemQuantity6`, `RewardChoiceItemDisplayID1`, `RewardChoiceItemDisplayID2`, `RewardChoiceItemDisplayID3`, `RewardChoiceItemDisplayID4`, `RewardChoiceItemDisplayID5`, `RewardChoiceItemDisplayID6`, `POIContinent`, `POIx`, `POIy`, `POIPriority`, `RewardTitle`, `RewardArenaPoints`, `RewardFactionID1`, `RewardFactionID2`, `RewardFactionID3`, `RewardFactionID4`, `RewardFactionID5`, `RewardFactionValue1`, `RewardFactionValue2`, `RewardFactionValue3`, `RewardFactionValue4`, `RewardFactionValue5`, `RewardFactionCapIn1`, `RewardFactionCapIn2`, `RewardFactionCapIn3`, `RewardFactionCapIn4`, `RewardFactionCapIn5`, `RewardFactionOverride1`, `RewardFactionOverride2`, `RewardFactionOverride3`, `RewardFactionOverride4`, `RewardFactionOverride5`, `RewardFactionFlags`, `AreaGroupID`, `TimeAllowed`, `AllowableRaces`, `TreasurePickerID`, `Expansion`, `ManagedWorldStateID`, `QuestSessionBonus`, `LogTitle`, `LogDescription`, `QuestDescription`, `AreaDescription`, `QuestCompletionLog`, `RewardCurrencyID1`, `RewardCurrencyID2`, `RewardCurrencyID3`, `RewardCurrencyID4`, `RewardCurrencyQty1`, `RewardCurrencyQty2`, `RewardCurrencyQty3`, `RewardCurrencyQty4`, `PortraitGiverText`, `PortraitGiverName`, `PortraitTurnInText`, `PortraitTurnInName`, `AcceptedSoundKitID`, `CompleteSoundKitID`, `VerifiedBuild`) VALUES +(78332, 2, 0, 378, -376, 0, 0, 0, 5, 1, 5, 1, 0, 0, 0, 210332, 0, 1, 0, 306184200, 8256, 0, 0, 0, 0, 0, 0, 0, 49927, 0, 0, 0, 15, 0, 0, 0, 210332, 210413, 210416, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 6130900294268439629, 0, 9, 0, 0, 'I Smell Trouble', 'Use O.D.I.E.\'s Remote Control to find clues around Stormwind.', 'You smell that funny odor too? Smells like smoke, cheap cologne, and alchemical nonsense. You ask me, I think the Crown Chemical Co. is up to something. Want to help me get to the bottom of it?\n\nWell, take a look at my pal here. Sure, he looks like a pooch, but this is O.D.I.E.! The Olfactory Detection and Inspection Engine! With this little fella, you and I can sniff out whatever the Crown is plotting from a mile away!\n\nAre you in? I could use a good partner to solve this.', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 53262), -- I Smell Trouble +(78328, 2, 0, 378, -376, 0, 0, 0, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 0, 33554440, 64, 0, 0, 0, 0, 0, 0, 0, 49927, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 6130900294268439629, 0, 9, 0, 0, 'Take a Look Around', 'Meet the vendors and visitors at the Gala of Gifts.', 'The Gala of Gifts is here to showcase the many wonderful artisans carefully crafting gifts just for you and your loved ones.\n\nYou should see what they have to offer, and talk to the other attendees. Who knows, you might just find the perfect gift for someone you care about!', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 53262), -- Take a Look Around +(76114, 2, 0, 444, -615, 102, 0, 0, 1, 1, 1, 1, 396864, 0, 0, 0, 0, 1, 0, 57147392, 8320, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 18446744073709551615, 0, 9, 0, 0, 'Report to the Trading Post', 'Return to the Trading Post to collect your Trader\'s Tender from the Collector\'s Cache.', '<The glint of a distant object catches your eye. You suddenly remember that you have tender to collect for use at T&W Trading Post.>', '', '', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 53262), -- Report to the Trading Post +(78329, 2, 0, 378, -376, 0, 0, 78328, 1, 1, 1, 1, 0, 0, 0, 0, 0, 1, 0, 8, 64, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 7, 7, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 6130900294268439629, 0, 9, 0, 0, 'Love is in the Air', 'Visit the Gala of Gifts at the gates of Stormwind.', 'Smell these roses! My partner got them for me at the Gala of Gifts.\n\nInterested in seeing things yourself? Head to the gates of Stormwind. There are gifts, and food, and you should taste the chocolate, it\'s delicious!', '', 'Speak with Luciana Delgado at the Gala of Gifts.', 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', 890, 878, 53262); -- Love is in the Air + +UPDATE `quest_template` SET `VerifiedBuild`=53262 WHERE `ID` IN (83, 11, 26152, 40, 14482, 106, 27234, 57486, 27863, 26653, 29078, 25896, 26666, 27752, 27246, 52026, 47, 27407, 26793, 28172, 88, 25619, 27210, 26688, 42978, 46, 25629, 26717, 47960, 60, 26209, 44700, 176, 27753, 27249, 46735, 52, 46736, 56775, 50047, 5545, 32009, 27754, 27216, 46268, 60545, 62, 75890, 50046, 32008, 53847, 27299, 27242, 27183, 28174, 40519, 56119, 85, 28238, 26620, 53436, 123, 27251, 46277, 14048, 26618, 50599, 50601, 37112, 25439, 27188, 26623, 43806, 49929); + +DELETE FROM `quest_details` WHERE `ID` IN (78328 /*Take a Look Around*/, 78332 /*I Smell Trouble*/, 78329 /*Love is in the Air*/); +INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES +(78328, 1, 0, 0, 0, 0, 0, 0, 0, 53262), -- Take a Look Around +(78332, 1, 0, 0, 0, 0, 0, 0, 0, 53262), -- I Smell Trouble +(78329, 669, 0, 0, 0, 0, 0, 0, 0, 53262); -- Love is in the Air + +DELETE FROM `quest_request_items` WHERE `ID` IN (78328 /*Take a Look Around*/); +INSERT INTO `quest_request_items` (`ID`, `EmoteOnComplete`, `EmoteOnIncomplete`, `EmoteOnCompleteDelay`, `EmoteOnIncompleteDelay`, `CompletionText`, `VerifiedBuild`) VALUES +(78328, 0, 1, 0, 0, 'Have you seen all of the wares available?', 53262); -- Take a Look Around + +DELETE FROM `quest_offer_reward` WHERE `ID` IN (76114 /*Report to the Trading Post*/, 78328 /*Take a Look Around*/); +INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES +(76114, 1, 0, 0, 0, 0, 0, 0, 0, 'Hope ye like this month''s collection of new and exotic wares, $n.', 53262), -- Report to the Trading Post +(78328, 1, 0, 0, 0, 0, 0, 0, 0, 'Aren''t the wares just marvelous? I find myself just a little jealous of the talent--and I find it hard to resist picking up everything they''ve made!\n\nDid anything catch your eye?', 53262); -- Take a Look Around + +DELETE FROM `quest_description_conditional` WHERE (`QuestId`=78329 AND `PlayerConditionId`=0 AND `QuestgiverCreatureId`=215197 AND `locale`='enUS') OR (`QuestId`=78332 AND `PlayerConditionId`=114725 AND `QuestgiverCreatureId`=38066 AND `locale`='enUS') OR (`QuestId`=76114 AND `PlayerConditionId`=923 AND `QuestgiverCreatureId`=0 AND `locale`='enUS') OR (`QuestId`=75890 AND `PlayerConditionId`=110815 AND `QuestgiverCreatureId`=0 AND `locale`='enUS'); +INSERT INTO `quest_description_conditional` (`QuestId`, `PlayerConditionId`, `QuestgiverCreatureId`, `locale`, `Text`, `OrderIndex`, `VerifiedBuild`) VALUES +(78329, 0, 215197, 'enUS', 'Hey there friend! Do you like gifts? How about flowers? Food? Chocolate? Vacations to scenic lands?\n\nOh, I\'m getting ahead of myself! Come to the Gala of Gifts, where all this and more is yours!\n\nI can take you there with this portal. Just touch it and imagine being surrounded by love!', 0, 53262), -- Love is in the Air +(78332, 114725, 38066, 'enUS', '$n! Boy am I glad to see you.\n\nListen $n, we may have gotten rid of the Crown Chemical Co., but I got a bad feeling we haven\'t seen the last of them.\n\nWell, take a look at my pal here. Sure, he looks like a pooch, but this is O.D.I.E.! The Olfactory Detection and Inspection Engine! With this little fella, you and I can sniff out whatever the Crown is plotting from a mile away!\n\nWhat do you say, partners again?', 0, 53262), -- I Smell Trouble +(76114, 923, 0, 'enUS', '<The glint of a distant object catches your eye. You suddenly remember that you have tender to collect for use at Zen\'shiri Trading Post.>', 0, 53262), -- Report to the Trading Post +(75890, 110815, 0, 'enUS', '<Fine penmanship fills the scroll.>\n\n$n,\n\nIt has been quite some time since we last spoke. I would not be here were it not for your aid in Jaedenar long ago, and I have not forgotten you. \n\nIt seems that your strength is needed in Shadow Hold hold once more -- the Wardens have need of you.\n\nMeet me near the embassy in Stormwind. Tyrande has called the Wardens to action, and your help would be greatly appreciated.\n\nArko\'narin Starshade', 0, 53262); -- The Clarion Call + +DELETE FROM `quest_offer_reward_conditional` WHERE (`QuestId`=76114 AND `PlayerConditionId`=923 AND `QuestgiverCreatureId`=185472 AND `locale`='enUS'); +INSERT INTO `quest_offer_reward_conditional` (`QuestId`, `PlayerConditionId`, `QuestgiverCreatureId`, `locale`, `Text`, `OrderIndex`, `VerifiedBuild`) VALUES +(76114, 923, 185472, 'enUS', 'Hope ya like this month\'s collection of new and exotic wares, $n.', 0, 53262); -- Report to the Trading Post + +UPDATE `quest_poi` SET `VerifiedBuild`=53262 WHERE (`QuestID`=78329 AND `BlobIndex`=2 AND `Idx1`=3) OR (`QuestID`=78329 AND `BlobIndex`=1 AND `Idx1`=2) OR (`QuestID`=78329 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=78329 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=78328 AND `BlobIndex`=0 AND `Idx1`=2) OR (`QuestID`=78328 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=78328 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=78332 AND `BlobIndex`=0 AND `Idx1`=5) OR (`QuestID`=78332 AND `BlobIndex`=0 AND `Idx1`=4) OR (`QuestID`=78332 AND `BlobIndex`=0 AND `Idx1`=3) OR (`QuestID`=78332 AND `BlobIndex`=0 AND `Idx1`=2) OR (`QuestID`=78332 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=78332 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=76114 AND `BlobIndex`=1 AND `Idx1`=3) OR (`QuestID`=76114 AND `BlobIndex`=0 AND `Idx1`=2) OR (`QuestID`=76114 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=76114 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=32009 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=32009 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=32008 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=32008 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=75890 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=75890 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=60545 AND `BlobIndex`=0 AND `Idx1`=6) OR (`QuestID`=60545 AND `BlobIndex`=1 AND `Idx1`=5) OR (`QuestID`=60545 AND `BlobIndex`=0 AND `Idx1`=4) OR (`QuestID`=60545 AND `BlobIndex`=0 AND `Idx1`=3) OR (`QuestID`=60545 AND `BlobIndex`=0 AND `Idx1`=2) OR (`QuestID`=60545 AND `BlobIndex`=1 AND `Idx1`=1) OR (`QuestID`=60545 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=56119 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=56119 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=53436 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=53436 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=50601 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=50599 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=49929 AND `BlobIndex`=1 AND `Idx1`=2) OR (`QuestID`=49929 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=49929 AND `BlobIndex`=0 AND `Idx1`=0) OR (`QuestID`=14048 AND `BlobIndex`=0 AND `Idx1`=1) OR (`QuestID`=14048 AND `BlobIndex`=0 AND `Idx1`=0); + +UPDATE `quest_poi_points` SET `VerifiedBuild`=53262 WHERE (`QuestID`=78329 AND `Idx1`=3 AND `Idx2`=0) OR (`QuestID`=78329 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=78329 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=78329 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=78328 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=78328 AND `Idx1`=1 AND `Idx2`=11) OR (`QuestID`=78328 AND `Idx1`=1 AND `Idx2`=10) OR (`QuestID`=78328 AND `Idx1`=1 AND `Idx2`=9) OR (`QuestID`=78328 AND `Idx1`=1 AND `Idx2`=8) OR (`QuestID`=78328 AND `Idx1`=1 AND `Idx2`=7) OR (`QuestID`=78328 AND `Idx1`=1 AND `Idx2`=6) OR (`QuestID`=78328 AND `Idx1`=1 AND `Idx2`=5) OR (`QuestID`=78328 AND `Idx1`=1 AND `Idx2`=4) OR (`QuestID`=78328 AND `Idx1`=1 AND `Idx2`=3) OR (`QuestID`=78328 AND `Idx1`=1 AND `Idx2`=2) OR (`QuestID`=78328 AND `Idx1`=1 AND `Idx2`=1) OR (`QuestID`=78328 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=78328 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=78332 AND `Idx1`=5 AND `Idx2`=0) OR (`QuestID`=78332 AND `Idx1`=4 AND `Idx2`=11) OR (`QuestID`=78332 AND `Idx1`=4 AND `Idx2`=10) OR (`QuestID`=78332 AND `Idx1`=4 AND `Idx2`=9) OR (`QuestID`=78332 AND `Idx1`=4 AND `Idx2`=8) OR (`QuestID`=78332 AND `Idx1`=4 AND `Idx2`=7) OR (`QuestID`=78332 AND `Idx1`=4 AND `Idx2`=6) OR (`QuestID`=78332 AND `Idx1`=4 AND `Idx2`=5) OR (`QuestID`=78332 AND `Idx1`=4 AND `Idx2`=4) OR (`QuestID`=78332 AND `Idx1`=4 AND `Idx2`=3) OR (`QuestID`=78332 AND `Idx1`=4 AND `Idx2`=2) OR (`QuestID`=78332 AND `Idx1`=4 AND `Idx2`=1) OR (`QuestID`=78332 AND `Idx1`=4 AND `Idx2`=0) OR (`QuestID`=78332 AND `Idx1`=3 AND `Idx2`=11) OR (`QuestID`=78332 AND `Idx1`=3 AND `Idx2`=10) OR (`QuestID`=78332 AND `Idx1`=3 AND `Idx2`=9) OR (`QuestID`=78332 AND `Idx1`=3 AND `Idx2`=8) OR (`QuestID`=78332 AND `Idx1`=3 AND `Idx2`=7) OR (`QuestID`=78332 AND `Idx1`=3 AND `Idx2`=6) OR (`QuestID`=78332 AND `Idx1`=3 AND `Idx2`=5) OR (`QuestID`=78332 AND `Idx1`=3 AND `Idx2`=4) OR (`QuestID`=78332 AND `Idx1`=3 AND `Idx2`=3) OR (`QuestID`=78332 AND `Idx1`=3 AND `Idx2`=2) OR (`QuestID`=78332 AND `Idx1`=3 AND `Idx2`=1) OR (`QuestID`=78332 AND `Idx1`=3 AND `Idx2`=0) OR (`QuestID`=78332 AND `Idx1`=2 AND `Idx2`=11) OR (`QuestID`=78332 AND `Idx1`=2 AND `Idx2`=10) OR (`QuestID`=78332 AND `Idx1`=2 AND `Idx2`=9) OR (`QuestID`=78332 AND `Idx1`=2 AND `Idx2`=8) OR (`QuestID`=78332 AND `Idx1`=2 AND `Idx2`=7) OR (`QuestID`=78332 AND `Idx1`=2 AND `Idx2`=6) OR (`QuestID`=78332 AND `Idx1`=2 AND `Idx2`=5) OR (`QuestID`=78332 AND `Idx1`=2 AND `Idx2`=4) OR (`QuestID`=78332 AND `Idx1`=2 AND `Idx2`=3) OR (`QuestID`=78332 AND `Idx1`=2 AND `Idx2`=2) OR (`QuestID`=78332 AND `Idx1`=2 AND `Idx2`=1) OR (`QuestID`=78332 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=78332 AND `Idx1`=1 AND `Idx2`=11) OR (`QuestID`=78332 AND `Idx1`=1 AND `Idx2`=10) OR (`QuestID`=78332 AND `Idx1`=1 AND `Idx2`=9) OR (`QuestID`=78332 AND `Idx1`=1 AND `Idx2`=8) OR (`QuestID`=78332 AND `Idx1`=1 AND `Idx2`=7) OR (`QuestID`=78332 AND `Idx1`=1 AND `Idx2`=6) OR (`QuestID`=78332 AND `Idx1`=1 AND `Idx2`=5) OR (`QuestID`=78332 AND `Idx1`=1 AND `Idx2`=4) OR (`QuestID`=78332 AND `Idx1`=1 AND `Idx2`=3) OR (`QuestID`=78332 AND `Idx1`=1 AND `Idx2`=2) OR (`QuestID`=78332 AND `Idx1`=1 AND `Idx2`=1) OR (`QuestID`=78332 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=78332 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=76114 AND `Idx1`=3 AND `Idx2`=0) OR (`QuestID`=76114 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=76114 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=76114 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=32009 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=32009 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=32008 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=32008 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=75890 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=75890 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=60545 AND `Idx1`=6 AND `Idx2`=0) OR (`QuestID`=60545 AND `Idx1`=5 AND `Idx2`=0) OR (`QuestID`=60545 AND `Idx1`=4 AND `Idx2`=0) OR (`QuestID`=60545 AND `Idx1`=3 AND `Idx2`=0) OR (`QuestID`=60545 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=60545 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=60545 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=56119 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=56119 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=53436 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=53436 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=50601 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=50599 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=49929 AND `Idx1`=2 AND `Idx2`=0) OR (`QuestID`=49929 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=49929 AND `Idx1`=0 AND `Idx2`=0) OR (`QuestID`=14048 AND `Idx1`=1 AND `Idx2`=0) OR (`QuestID`=14048 AND `Idx1`=0 AND `Idx2`=0); + +DELETE FROM `quest_objectives` WHERE `ID` IN (444329 /*444329*/, 444328 /*444328*/, 444316 /*444316*/, 445194 /*445194*/, 444958 /*444958*/, 445493 /*445493*/, 444669 /*444669*/, 444302 /*444302*/, 444301 /*444301*/, 444300 /*444300*/, 444299 /*444299*/, 436312 /*436312*/, 445599 /*445599*/); +INSERT INTO `quest_objectives` (`ID`, `QuestID`, `Type`, `Order`, `StorageIndex`, `ObjectID`, `Amount`, `Flags`, `Flags2`, `ProgressBarWeight`, `Description`, `VerifiedBuild`) VALUES +(444329, 78332, 1, 3, 2, 210417, 1, 34, 1, 0, 'Third clue found', 53262), -- 444329 +(444328, 78332, 1, 2, 1, 210416, 1, 34, 1, 0, 'Second clue found', 53262), -- 444328 +(444316, 78332, 1, 1, 0, 210413, 1, 34, 1, 0, 'First clue found', 53262), -- 444316 +(445194, 78332, 0, 0, 3, 213498, 1, 4, 0, 0, 'Use O.D.I.E.''s Remote Control near the Trade District Fountain', 53262), -- 445194 +(444958, 78328, 0, 6, 5, 213776, 6, 28, 0, 0, 'HIDDEN - POI blob', 53262), -- 444958 +(445493, 78328, 0, 5, 6, 213262, 1, 0, 0, 0, 'Ying met', 53262), -- 445493 +(444669, 78328, 0, 4, 4, 212677, 1, 0, 0, 0, 'Gabbo Blinkwink met', 53262), -- 444669 +(444302, 78328, 0, 3, 3, 211887, 1, 0, 0, 0, 'Sylandra Silverbreeze met', 53262), -- 444302 +(444301, 78328, 0, 2, 2, 211873, 1, 0, 0, 0, 'Bang Sparknozzle met', 53262), -- 444301 +(444300, 78328, 0, 1, 1, 211864, 1, 0, 0, 0, 'Maurice Guichi met', 53262), -- 444300 +(444299, 78328, 0, 0, 0, 211812, 1, 0, 0, 0, 'Kiera Torres met', 53262), -- 444299 +(436312, 76114, 0, 0, 4, 201462, 1, 0, 0, 0, 'Return to the Trading Post', 53262), -- 436312 +(445599, 78329, 0, 0, 0, 215197, 1, 4, 0, 0, 'Portal taken to the Gala of Gifts', 53262); -- 445599 + +UPDATE `quest_objectives` SET `VerifiedBuild`=53262 WHERE `ID` IN (296295, 252108, 251970, 391353, 296291, 258677, 266040, 252033, 251906, 266999, 266998, 266167, 252573, 266076, 254941, 267560, 265836, 265976, 254263, 266338, 337847, 251758, 267137, 252826, 252825, 252824, 252823, 265459, 265852, 265523, 285830, 254717, 265868, 266720, 251686, 265757, 265756, 265755, 265754, 252698, 254275, 289535, 252387, 252386, 289536, 256660, 289293, 405017, 406745, 406744, 253881, 266330, 266329, 257714, 252864, 252863, 390274, 255375, 341370, 265856, 336204, 254151, 289167, 264862, 336214); + +DELETE FROM `quest_visual_effect` WHERE (`Index`=0 AND `ID` IN (445599,444329,444328,444316,445493,444669,444302,444301,444300,444299,436312)) OR (`Index`=1 AND `ID`=436312); +INSERT INTO `quest_visual_effect` (`ID`, `Index`, `VisualEffect`, `VerifiedBuild`) VALUES +(445599, 0, 24666, 53262), +(444329, 0, 24138, 53262), +(444328, 0, 24137, 53262), +(444316, 0, 24136, 53262), +(445493, 0, 2099, 53262), +(444669, 0, 2099, 53262), +(444302, 0, 2099, 53262), +(444301, 0, 2099, 53262), +(444300, 0, 2099, 53262), +(444299, 0, 2099, 53262), +(436312, 1, 21160, 53262), +(436312, 0, 20821, 53262); + +UPDATE `quest_visual_effect` SET `VerifiedBuild`=53262 WHERE (`Index`=0 AND `ID` IN (391353,252698,337847,405017,406745,406744)) OR (`Index`=1 AND `ID`=406745); + +UPDATE `quest_reward_display_spell` SET `VerifiedBuild`=53262 WHERE (`QuestID`=53847 AND `Idx`=0); + +-- Misc +DELETE FROM `spell_target_position` WHERE (`EffectIndex`=0 AND `ID` IN (426637,427568,426638,426636,426886)); +INSERT INTO `spell_target_position` (`ID`, `EffectIndex`, `MapID`, `PositionX`, `PositionY`, `PositionZ`, `VerifiedBuild`) VALUES +(426637, 0, 870, 1685.0799560546875, -1614.6199951171875, 522.6099853515625, 53262), -- Spell: 426637 (Exciting Getaway) Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(427568, 0, 0, -13130.400390625, -1519.6700439453125, 97.20999908447265625, 53262), -- Spell: 427568 (Lakeside Getaway) Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(426638, 0, 1, 6876.41015625, -2392.93994140625, 554.21002197265625, 53262), -- Spell: 426638 (Relaxing Getaway) Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(426636, 0, 1220, 2818.31005859375, 6767.47998046875, 214.82000732421875, 53262), -- Spell: 426636 (Romantic Getaway) Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) +(426886, 0, 1, -5817.8701171875, 576.78997802734375, 165.2100067138671875, 53262); -- Spell: 426886 (Feralas Getaway) Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS) + +UPDATE `spell_target_position` SET `VerifiedBuild`=53262 WHERE (`EffectIndex`=0 AND `ID` IN (33690,53140,393590,132621)); |