DB/WinterVeil: Update gameobjects and quests (Dragonflight)

1 files changed, 38 insertions, 0 deletions

diff --git a/sql/updates/world/master/2023_12_26_02_world.sql b/sql/updates/world/master/2023_12_26_02_world.sql
new file mode 100644
index 00000000000..bdcafa15ab0
--- /dev/null
+++ b/sql/updates/world/master/2023_12_26_02_world.sql
@@ -0,0 +1,38 @@
+-- Gameobject templates
+UPDATE `gameobject_template` SET `VerifiedBuild`=52649 WHERE `entry` IN (209473, 209474, 209465, 273286, 204678, 208534, 197311, 206547, 197323, 190549, 323852, 204646, 257712, 257729, 257750, 257641, 257779, 257806, 257665, 257790, 257832, 257823, 257643, 257776, 257810, 257802, 257632, 257804, 259122, 257629, 257666, 204657, 204656, 204662, 204215, 243460, 207099, 204622, 210059, 204681, 204686, 351919, 351926, 204701, 195222, 204698, 202813, 202815, 204720, 208270, 206548, 105576, 204203, 257744, 257728, 257725, 257719, 257717, 257714, 257793, 257636, 257684, 257650, 383583, 204650, 206086, 204608, 206725, 202803, 207642, 204712, 351918, 351924, 50805, 207634, 204198, 204632, 204195, 257705, 257761, 257762, 257749, 257809, 257663, 257662, 257627, 257800, 257778, 257685, 257626, 204604, 152614, 307614, 243461, 206708, 204623, 207633, 205090, 204700, 204688, 204937, 208269, 293684, 197314, 197257, 206538, 210181, 257759, 257751, 257681, 257673, 255931, 257829, 257651, 257816, 257781, 257642, 180793, 384744, 204602, 207100, 204710, 204713, 204708, 204707, 204694, 50803, 204721, 206730, 197285, 197312, 206529, 197287, 257747, 257738, 257720, 257752, 204193, 257633, 259120, 257771, 257654, 257683, 257648, 259136, 187236, 205109, 203471, 204210, 243459, 243462, 179707, 204696, 204702, 3301, 186722, 197310, 197280, 206741, 204197, 206530, 204191, 204204, 257691, 257745, 257679, 257814, 258975, 257798, 257831, 257782, 257774, 257834, 257658, 178649, 178430, 207889, 281107, 207101, 351923, 204635, 206545, 204200, 257768, 257735, 257755, 257748, 257777, 257660, 251255, 257678, 257635, 257619, 251253, 387718, 386349, 178645, 206726, 339344, 202804, 204716, 204683, 204616, 204727, 202810, 204693, 197313, 257649, 251254, 257827, 178551, 180743, 204199, 269949, 207098, 206735, 204621, 202802, 207645, 204641, 204711, 351921, 202816, 212212, 332214, 257763, 257623, 257801, 257785, 257689, 257797, 257792, 257812, 257653, 206737, 204647, 180748, 180715, 175788, 206106, 186238, 204207, 204609, 204603, 204625, 273293, 204626, 207641, 351430, 204940, 204689, 197261, 204938, 207630, 197307, 197286, 197278, 204633, 257702, 257731, 257740, 257644, 257670, 257808, 257783, 257775, 257825, 257772, 204666, 204645, 204655, 204163, 206110, 206610, 266354, 204703, 351925, 207640, 204685, 204636, 202817, 208054, 204719, 202808, 257694, 257693, 257734, 257733, 257726, 257739, 257736, 257715, 257754, 257811, 257671, 257803, 257769, 257664, 255930, 257796, 257682, 178432, 206609, 204624, 204715, 204618, 204613, 204680, 205091, 403736, 257696, 257830, 203969, 180746, 178431, 204605, 204194, 278281, 351920, 204705, 204714, 207638, 204617, 204941, 206738, 202801, 206740, 197207, 204205, 257704, 257722, 257668, 257646, 257675, 257784, 257799, 257794, 175080, 178428, 204212, 202590, 203979, 204642, 207636, 197259, 206549, 206546, 257706, 257699, 257742, 257730, 257727, 257723, 257718, 257711, 257721, 251252, 178554, 205142, 206727, 204214, 298892, 204628, 204640, 204706, 202814, 204606, 257692, 257698, 257652, 259146, 257628, 257795, 257836, 257820, 251289, 257789, 257640, 257773, 257645, 257637, 257791, 257621, 251251, 257677, 257655, 259121, 206067, 204665, 206608, 268690, 207096, 204627, 202805, 204718, 204638, 339239, 204612, 209045, 204643, 202800, 202799, 205056, 197315, 206539, 204631, 204607, 323853, 257708, 257697, 257756, 258974, 257787, 257667, 257659, 257656, 257687, 257819, 204663, 175787, 178437, 204610, 204695, 209049, 209050, 257709, 257703, 257680, 257766, 257758, 257676, 257821, 257634, 257817, 323854, 204664, 203378, 259114, 204201, 207094, 204730, 204717, 207639, 349789, 204614, 207631, 204634, 207414, 257713, 257732, 257813, 257805, 254942, 257835, 257770, 257690, 257647, 257788, 341827, 204213, 278802, 204687, 349788, 35591, 204684, 207632, 207635, 204679, 197260, 202798, 197309, 197322, 257701, 257767, 257753, 257672, 178438, 204611, 204209, 203977, 209867, 204637, 206739, 206736, 197279, 197284, 204196, 323851, 257710, 257700, 257743, 257765, 257716, 257764, 257826, 257828, 257786, 257669, 257661, 257639, 178666, 204601, 204620, 350063, 351922, 204615, 202812, 204936, 206729, 251250, 323849, 204651, 204600, 204202, 204709, 210058, 204682, 187376, 202811, 202809, 257746, 257631, 257822, 257638, 257833, 257674, 257780, 204658, 387697, 377216, 180747, 206995, 273300, 206709, 207097, 204729, 207646, 204704, 349791, 204692, 204619, 50804, 204726, 204192, 257707, 257695, 257741, 257760, 257737, 257757, 257620, 257657, 257824, 257630, 257622, 257815, 257807, 204208, 223739, 204639, 204677, 207637, 204699, 204939, 237942, 197276, 202717, 257724, 259138, 257818, 204179, 281340, 178433, 204211, 205108, 223814);
+UPDATE `gameobject_template` SET `VerifiedBuild`=52649 WHERE `entry` IN (36998, 322639, 254103, 202000, 201993, 201986, 202034, 201457, 204987, 201461, 206560, 209101, 201494, 201555, 209039, 36988, 207661, 254110, 258986, 202057, 201999, 201983, 201992, 202063, 205104, 206115, 200311, 201516, 201499, 201538, 201510, 281118, 201497, 201554, 201548, 179882, 178924, 307281, 197026, 254122, 202052, 202049, 202016, 92011, 203976, 201481, 209044, 201680, 178425, 200309, 201543, 201505, 201521, 201496, 201559, 197179, 206084, 202260, 197023, 197030, 197018, 254123, 207723, 207722, 202030, 202022, 193584, 201687, 200315, 201541, 201528, 201490, 197172, 197132, 197191, 197031, 386352, 254108, 254095, 254116, 202005, 201982, 201991, 202009, 202046, 201454, 201482, 201476, 201477, 201475, 201415, 201416, 209042, 201685, 200314, 201500, 197139, 197099, 197027, 197097, 1561, 204284, 209297, 202001, 201996, 202060, 202050, 202018, 202758, 201689, 201672, 201489, 201560, 197141, 197186, 197028, 254104, 254119, 202047, 202035, 202013, 202267, 200306, 201512, 201514, 202257, 202253, 178669, 178436, 206076, 197174, 207205, 207201, 36981, 1731, 197098, 197032, 197011, 254112, 254099, 201995, 207719, 202271, 201462, 201474, 201694, 201683, 201533, 201493, 201557, 206073, 203762, 375073, 197123, 36983, 254111, 254096, 201619, 203955, 197196, 202003, 202020, 202274, 201417, 209047, 209048, 201682, 201535, 201524, 201509, 201513, 206074, 197145, 197178, 197117, 197187, 36985, 335930, 197008, 175729, 377200, 197096, 254107, 202015, 209051, 201449, 201447, 201540, 201526, 201525, 201495, 201515, 206083, 206078, 197119, 259008, 197180, 197181, 207204, 203972, 36987, 254109, 254091, 185582, 254117, 254088, 207720, 202061, 201460, 201421, 201445, 209046, 201451, 201690, 201678, 200312, 201503, 202259, 197147, 197125, 197189, 203978, 207203, 197024, 197029, 203949, 254093, 254120, 202053, 207721, 206623, 202051, 202007, 201418, 201422, 201506, 201558, 201549, 197135, 197182, 197148, 197185, 197188, 310709, 197020, 202002, 202055, 202036, 201980, 202021, 201485, 209040, 201684, 201534, 201539, 201507, 207416, 201518, 201553, 201545, 206079, 197131, 197025, 254102, 294556, 202033, 202014, 201453, 201688, 201692, 197142, 205106, 197133, 197149, 197136, 3803, 36984, 248410, 195467, 203953, 254115, 254100, 201998, 201997, 201459, 201484, 201448, 201542, 201537, 201508, 179706, 281339, 197150, 36980, 36989, 3769, 254097, 254094, 140911, 202045, 201458, 202272, 201463, 201480, 209043, 209054, 175739, 201691, 201681, 200313, 201520, 203800, 206080, 270011, 203987, 203950, 202059, 201456, 209041, 200310, 201527, 201511, 197192, 357515, 36996, 3800, 197022, 206205, 203952, 254105, 202054, 202017, 204988, 201420, 209053, 201677, 201674, 201676, 201552, 202256, 209692, 197176, 1617, 197013, 205553, 254113, 205144, 254092, 207718, 202056, 202032, 202019, 205105, 201455, 193583, 201419, 201446, 201686, 201679, 200308, 201502, 201522, 201550, 197144, 197177, 197175, 197120, 197183, 197173, 197118, 197012, 175758, 208438, 202008, 202064, 202048, 201450, 200307, 201519, 201501, 201546, 197190, 197121, 203801, 197146, 3804, 2724, 180663, 254114, 208437, 248412, 203954, 202062, 201483, 201675, 201530, 201529, 201492, 201551, 197137, 197124, 197134, 3799, 254098, 203988, 203948, 254106, 202006, 202058, 202270, 201531, 201498, 201547, 197138, 197116, 250672, 202258, 207202, 1619, 254090, 203951, 254101, 254118, 254089, 254121, 201989, 201987, 201994, 202044, 201985, 202031, 193585, 180047, 201478, 209052, 201544, 201532, 201491, 197193, 197184, 197122, 190536, 206082, 205107, 290, 307271, 36997, 197021, 195468, 202011, 201981, 202029, 202012, 202273, 201479, 201452, 201693, 201673, 201536, 201504, 201488, 201523, 201556, 197143, 197140);
+UPDATE `gameobject_template` SET `VerifiedBuild`=52649 WHERE `entry` IN (111202, 111227, 171699, 171569, 143342, 143244, 1618, 204117, 171614, 171618, 171583, 176624, 171697, 137644, 303171, 171684, 171602, 32389, 142871, 203615, 171712, 26494, 372, 208872, 205080, 171538, 171608, 178671, 184955, 171594, 143295, 171776, 171636, 203611, 171715, 205221, 203263, 142102, 1749, 178764, 171681, 171768, 171541, 143348, 143333, 171607, 111205, 143326, 176627, 176629, 171572, 190684, 171767, 171769, 143343, 143336, 206975, 171733, 147786, 178558, 111222, 29781, 204116, 143322, 176628, 171573, 171596, 142851, 178556, 171732, 143325, 176924, 208244, 171685, 309564, 203609, 171746, 171734, 171605, 143319, 171524, 178765, 207320, 187294, 171570, 143245, 171771, 171737, 111207, 111220, 32571, 203262, 26449, 149413, 171585, 176626, 171635, 142340, 171603, 171765, 171775, 171729, 143345, 205220, 171740, 171707, 111203, 179984, 171586, 143323, 171703, 32385, 171745, 195259, 143301, 32383, 171660, 171722, 142339, 171755, 171532, 32416, 171736, 175746, 29782, 171588, 144159, 171601, 143296, 32355, 203614, 171773, 171661, 171547, 32404, 171741, 171742, 32581, 203193, 171615, 181688, 143320, 137646, 171633, 171696, 171695, 171543, 171542, 143247, 143347, 143346, 143349, 203195, 171609, 32349, 308115, 171680, 143246, 143256, 307673, 203610, 208870, 171678, 32574, 203260, 171582, 245052, 171545, 171544, 143314, 143243, 171774, 171710, 171606, 171604, 111204, 111224, 111216, 203257, 171610, 171701, 171574, 171694, 34360, 142341, 171646, 32391, 171743, 171717, 171713, 171739, 171709, 147787, 32570, 19874, 171693, 143317, 143273, 171705, 203605, 203464, 171738, 171730, 171731, 203265, 32578, 28603, 171587, 32431, 26499, 171599, 171600, 26495, 143328, 149417, 171735, 111212, 178609, 171616, 171597, 171682, 171593, 171764, 171679, 143344, 171716, 143250, 111225, 111226, 111221, 29780, 205077, 171613, 171580, 171698, 171702, 171700, 308114, 171595, 171766, 171770, 208375, 171756, 32429, 268896, 144162, 32580, 204359, 174746, 171617, 171581, 176625, 142838, 171579, 149418, 171577, 190683, 171546, 203613, 171711, 32358, 137647, 171748, 176231, 171706, 171533, 269, 111215, 111206, 29783, 1748, 386, 34571, 143321, 171634, 171704, 171578, 171575, 171571, 143363, 171723, 171747, 143338, 111217, 32573, 203252, 171611, 190680, 171576, 171692, 171683, 143242, 171772, 150087, 203608, 171714, 149412, 171534, 203249, 32572, 139852, 143318, 143253, 190681, 32425, 195256, 143334, 203607, 37478, 111223, 205079, 171612, 171584, 32427, 143324, 32424, 171598, 171744, 203612, 171647, 203604, 26496, 171708);
+UPDATE `gameobject_template` SET `VerifiedBuild`=52649 WHERE `entry` IN (191492, 204329, 58624, 36093, 113577, 36096, 36090, 113752, 244852, 191488, 58603, 101851, 210110, 113571, 58620, 58611, 210112, 191491, 36077, 58607, 36086, 105175, 58614, 3662, 113753, 98343, 208840, 98347, 175761, 113576, 105174, 191495, 113754, 58616, 175749, 208874, 206863, 202901, 36102, 208839, 267748, 191493, 209862, 191490, 293758, 113570, 178745, 177064, 58608, 58621, 180666, 36105, 267745, 295546, 113568, 98350, 204331, 58596, 3705, 113569, 36085, 37097, 195142, 210111, 175754, 208842, 98354, 267747, 267751, 104593, 210109, 191494, 58617, 58606, 98348, 36113, 58619, 208841, 58597, 207324, 204330, 36073, 267746, 210108, 206861, 212205, 153695, 204334, 187290, 58604, 20654, 278347, 191486, 191497, 191487, 293689, 98349, 113756, 58625, 58627, 58612, 206862, 36094, 36071, 190704, 98351, 36118, 267749, 20650, 20656, 206864, 295545, 202900, 36078, 58615, 58605, 58601, 58629, 20649, 202563, 191496, 36083, 175731, 113572, 177044, 204333, 36092, 20653, 52176, 58599, 58602, 58598, 244854, 58626, 20657, 20651, 293763, 202899, 175725, 58600, 175659, 36091, 113755, 136101, 36082, 267744, 195260, 20652, 175726, 175738, 113574, 204332, 36070, 208876, 20655, 191489, 208828, 77813, 36079, 113575, 58622, 36098, 176594, 170355, 36095, 58623, 267750, 101850);
+UPDATE `gameobject_template` SET `VerifiedBuild`=52649 WHERE `entry` IN (298794, 298787, 298842, 303219, 298914, 298909, 299052, 296889, 281560, 297800, 319229, 214569, 212184, 298822, 298812, 290679, 295568, 295670, 297718, 214894, 215686, 298813, 298790, 298799, 316746, 299053, 296895, 298912, 296883, 302973, 365075, 298820, 298814, 298798, 298784, 298802, 316744, 298911, 298913, 296880, 297797, 292672, 239176, 298946, 298821, 289326, 298809, 302859, 298831, 316984, 297805, 278554, 295671, 295667, 295665, 290460, 272799, 212622, 210804, 288242, 298819, 279684, 298825, 298826, 298804, 297798, 295678, 319231, 297719, 290461, 319230, 307745, 298903, 298900, 291156, 298942, 298791, 298827, 298788, 299054, 297802, 297745, 214988, 323855, 302746, 298815, 310516, 316983, 306854, 281869, 290703, 297720, 291157, 298916, 288225, 298805, 298796, 298838, 290706, 282771, 292803, 295673, 290458, 212182, 215766, 214568, 296451, 298808, 316905, 293983, 268897, 295677, 295666, 365074, 297761, 298940, 214987, 216302, 214893, 215684, 298816, 298806, 291115, 298843, 296891, 297803, 298901, 298818, 316747, 302976, 365073, 297717, 298939, 278212, 212624, 212581, 216301, 323850, 279675, 298801, 298828, 296888, 295551, 297715, 294021, 177284, 288306, 279682, 298829, 299009, 299064, 299051, 295569, 297795, 294368, 369894, 298943, 298823, 298795, 298800, 316745, 297794, 295550, 297807, 297804, 297712, 290736, 297762, 233778, 212621, 176092, 298840, 299048, 297801, 295553, 295668, 295664, 297714, 319233, 212183, 316982, 303130, 281455, 290459, 212623, 298824, 295549, 303132, 297796, 295672, 297716, 298941, 289558, 288591, 292904, 292584, 278211, 215687, 179881, 1744, 1743, 298797, 298830, 298915, 295552, 272677, 297763, 252248, 298899, 298944, 214570, 288312, 288317, 176201, 327525, 298793, 298786, 298803, 279339, 298910, 299047, 299050, 296882, 292802, 290678, 269179, 289529, 298947, 212580, 298817, 298807, 298792, 298789, 298837, 298832, 298844, 299065, 299008, 295669, 365076, 319232, 291155, 214567, 1873, 298811, 298839, 218387, 322601, 295570, 296061, 282450, 316680, 298902, 177285, 298810, 298783, 298785, 298833, 298834, 298841, 280640, 297806, 296060, 297713, 291273, 215767, 212625, 214566, 215683, 176202, 289436, 304055, 297799, 296450, 176203);
+UPDATE `gameobject_template` SET `displayId`=82329, `VerifiedBuild`=52649 WHERE `entry`=187191; -- Standing, Exterior, Medium - Xmas
+UPDATE `gameobject_template` SET `name`='Hanging, Tall/Thin Medium - Xmas', `VerifiedBuild`=52649 WHERE `entry`=187234; -- Tall/Thin Medium - Xmas
+UPDATE `gameobject_template` SET `displayId`=82328, `VerifiedBuild`=52649 WHERE `entry`=178647; -- Christmas Tree
+UPDATE `gameobject_template` SET `displayId`=82325, `VerifiedBuild`=52649 WHERE `entry`=178805; -- Christmas Tree (Medium)
+UPDATE `gameobject_template` SET `displayId`=82329, `VerifiedBuild`=52649 WHERE `entry`=187193; -- Standing, Giant - Xmas
+UPDATE `gameobject_template` SET `displayId`=82325, `VerifiedBuild`=52649 WHERE `entry` IN (178668, 178557, 206104); -- Christmas Tree (Medium)
+UPDATE `gameobject_template` SET `displayId`=82325, `VerifiedBuild`=52649 WHERE `entry`=206077; -- Christmas Tree (Small)
+UPDATE `gameobject_template` SET `displayId`=82329, `VerifiedBuild`=52649 WHERE `entry`=187235; -- Standing, Exterior, Medium - Xmas
+UPDATE `gameobject_template` SET `displayId`=82324, `VerifiedBuild`=52649 WHERE `entry`=178426; -- XMasTreeLargeHorde01
+UPDATE `gameobject_template` SET `displayId`=82325, `VerifiedBuild`=52649 WHERE `entry`=178667; -- Christmas Tree (Medium)
+UPDATE `gameobject_template` SET `displayId`=82328, `VerifiedBuild`=52649 WHERE `entry`=206976; -- Christmas Tree
+UPDATE `gameobject_template` SET `displayId`=82324, `VerifiedBuild`=52649 WHERE `entry`=206937; -- XMasTreeLargeHorde01 (scale 2.0)
+
+-- Quests
+DELETE FROM `quest_offer_reward` WHERE `ID` IN (78504 /*A Gently Shaken Gift*/, 78131 /*A Winter Veil Gift*/);
+INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
+(78504, 0, 0, 0, 0, 0, 0, 0, 0, 'This present looks like it has been shaken a few times. The tag on it reads:$b$bTo a very special $r $c.', 52649), -- A Gently Shaken Gift
+(78131, 0, 0, 0, 0, 0, 0, 0, 0, 'A small tag on this present reads:$b$bHappy holidays, $n!', 52649); -- A Winter Veil Gift
+
+UPDATE `quest_offer_reward` SET `VerifiedBuild`=52649 WHERE `ID` IN (8769, 8744, 8803, 8768);
+
+DELETE FROM `gameobject_queststarter` WHERE `id` IN (187236,180746);
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(187236, 78131, 52649), -- A Winter Veil Gift ended by Winter Veil Gift
+(180746, 78504, 52649); -- A Gently Shaken Gift ended by Gently Shaken Gift
+
+DELETE FROM `gameobject_questender` WHERE `id` IN (187236,180746);
+INSERT INTO `gameobject_questender` (`id`, `quest`, `VerifiedBuild`) VALUES
+(187236, 78131, 52649), -- A Winter Veil Gift ended by Winter Veil Gift
+(180746, 78504, 52649); -- A Gently Shaken Gift ended by Gently Shaken Gift
+
+UPDATE `gameobject_questender` SET `VerifiedBuild`=52649 WHERE (`id`=180748 AND `quest`=8769) OR (`id`=180793 AND `quest`=8803) OR (`id`=180747 AND `quest`=8768) OR (`id`=180743 AND `quest`=8744);