aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2024_11_08_05_world.sql114
1 files changed, 114 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_11_08_05_world.sql b/sql/updates/world/master/2024_11_08_05_world.sql
new file mode 100644
index 00000000000..5b3feda1210
--- /dev/null
+++ b/sql/updates/world/master/2024_11_08_05_world.sql
@@ -0,0 +1,114 @@
+SET @OGUID := 10800399;
+
+-- Gameobject templates
+DELETE FROM `gameobject_template` WHERE `entry` IN (464929, 464928, 464927, 464926);
+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
+(464929, 2, 98384, 'Candy Bucket', '', '', '', 1, 0, 27779, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 425, 57212), -- Candy Bucket
+(464928, 2, 98384, 'Candy Bucket', '', '', '', 1, 0, 27778, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 425, 57212), -- Candy Bucket
+(464927, 2, 98384, 'Candy Bucket', '', '', '', 1, 0, 27777, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 425, 57212), -- Candy Bucket
+(464926, 2, 98384, 'Candy Bucket', '', '', '', 1, 0, 27776, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 425, 57212); -- Candy Bucket
+
+DELETE FROM `gameobject_template_addon` WHERE `entry` IN (464929, 464928, 464927, 464926);
+INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`) VALUES
+(464929, 35, 0x4, 0, 0), -- Candy Bucket
+(464928, 35, 0x4, 0, 0), -- Candy Bucket
+(464927, 35, 0x4, 0, 0), -- Candy Bucket
+(464926, 35, 0x4, 0, 0); -- Candy Bucket
+
+-- Quests
+DELETE FROM `quest_offer_reward` WHERE `ID` IN (84581, 84580, 84582, 84579);
+INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES
+(84581, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 57212), -- Candy Bucket
+(84580, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 57212), -- Candy Bucket
+(84582, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 57212), -- Candy Bucket
+(84579, 0, 0, 0, 0, 0, 0, 0, 0, 'Candy buckets like this are located in inns throughout the realms. Go ahead... take some!', 57212); -- Candy Bucket
+
+DELETE FROM `gameobject_queststarter` WHERE `id` IN (464929, 464928, 464927, 464926);
+INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES
+(464928, 84581, 57212),
+(464927, 84580, 57212),
+(464929, 84582, 57212),
+(464926, 84579, 57212);
+
+DELETE FROM `gameobject_questender` WHERE `id` IN (464929, 464928, 464927, 464926);
+INSERT INTO `gameobject_questender` (`id`, `quest`, `VerifiedBuild`) VALUES
+(464928, 84581, 57212),
+(464927, 84580, 57212),
+(464929, 84582, 57212),
+(464926, 84579, 57212);
+
+-- Gameobject spawns
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+31;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
+-- Faerin's Advance
+(@OGUID+0, 180405, 2601, 14752, 14945, '0', 0, 0, 685.1649169921875, -1596.44970703125, -986.12109375, 0.312640219926834106, 0.008785724639892578, 0.016153335571289062, 0.155496597290039062, 0.987665295600891113, 120, 255, 1, 57212), -- G_Pumpkin_01 (Area: Faerin's Advance - Difficulty: 0) CreateObject1
+(@OGUID+1, 180406, 2601, 14752, 14945, '0', 0, 0, 680.91668701171875, -1595.16845703125, -986.92059326171875, 6.011493682861328125, 0, 0, -0.13542842864990234, 0.990787088871002197, 120, 255, 1, 57212), -- G_Pumpkin_02 (Area: Faerin's Advance - Difficulty: 0) CreateObject1
+(@OGUID+2, 180407, 2601, 14752, 14945, '0', 0, 0, 682.82293701171875, -1596.21875, -986.3262939453125, 0.732989370822906494, -0.00004053115844726, 0.011440277099609375, 0.358281135559082031, 0.933543682098388671, 120, 255, 1, 57212), -- G_Pumpkin_03 (Area: Faerin's Advance - Difficulty: 0) CreateObject1
+(@OGUID+3, 180408, 2601, 14752, 14945, '0', 0, 0, 690.7882080078125, -1581.59033203125, -974.231689453125, 5.630537033081054687, -0.04174423217773437, -0.01031112670898437, -0.32106208801269531, 0.946081519126892089, 120, 255, 1, 57212), -- G_WitchHat_01 (Area: Faerin's Advance - Difficulty: 0) CreateObject1
+(@OGUID+4, 180415, 2601, 14752, 14946, '0', 0, 0, 691.3367919921875, -1572.013916015625, -980.94866943359375, 0.367140263319015502, 0, 0, 0.1825408935546875, 0.983198225498199462, 120, 255, 1, 57212), -- CandleBlack01 (Area: Pillar-nest Vosh - Difficulty: 0) CreateObject1
+(@OGUID+5, 180415, 2601, 14752, 14945, '0', 0, 0, 700.26214599609375, -1583.0399169921875, -980.912353515625, 0.367140263319015502, 0, 0, 0.1825408935546875, 0.983198225498199462, 120, 255, 1, 57212), -- CandleBlack01 (Area: Faerin's Advance - Difficulty: 0) CreateObject1
+(@OGUID+6, 180415, 2601, 14752, 14945, '0', 0, 0, 686.8680419921875, -1575.5416259765625, -980.93426513671875, 6.229013919830322265, 0, 0, -0.02708244323730468, 0.999633193016052246, 120, 255, 1, 57212), -- CandleBlack01 (Area: Faerin's Advance - Difficulty: 0) CreateObject1
+(@OGUID+7, 180415, 2601, 14752, 14945, '0', 0, 0, 695.76739501953125, -1586.625, -980.954345703125, 0, 0, 0, 0, 1, 120, 255, 1, 57212), -- CandleBlack01 (Area: Faerin's Advance - Difficulty: 0) CreateObject1
+(@OGUID+8, 180523, 2601, 14752, 14945, '0', 0, 0, 686.75518798828125, -1572.203125, -987.27996826171875, 0, 0, 0, 0, 1, 120, 255, 1, 57212), -- Apple Bob (Area: Faerin's Advance - Difficulty: 0) CreateObject1
+(@OGUID+9, 464926, 2601, 14752, 14945, '0', 0, 0, 695.842041015625, -1584.21875, -987.39019775390625, 4.487949371337890625, 0, 0, -0.78184413909912109, 0.623473942279815673, 120, 255, 1, 57212), -- Candy Bucket (Area: Faerin's Advance - Difficulty: 0) CreateObject1
+-- Weaver's Lair
+(@OGUID+10, 180405, 2601, 14752, 14755, '0', 0, 0, -303.67535400390625, -1410.90283203125, -1087.3621826171875, 5.076570510864257812, 0.017495155334472656, 0.005661964416503906, -0.56740760803222656, 0.823231697082519531, 120, 255, 1, 57212), -- G_Pumpkin_01 (Area: Weaver's Lair - Difficulty: 0) CreateObject1
+(@OGUID+11, 180406, 2601, 14752, 14755, '0', 0, 0, -300.017364501953125, -1397.9722900390625, -1084.5076904296875, 4.947373390197753906, -0.16889333724975585, 0.301237106323242187, -0.54531002044677734, 0.763785481452941894, 120, 255, 1, 57212), -- G_Pumpkin_02 (Area: Weaver's Lair - Difficulty: 0) CreateObject1
+(@OGUID+12, 180407, 2601, 14752, 14755, '0', 0, 0, -308.482635498046875, -1425.5711669921875, -1087.393798828125, 5.145113945007324218, 0.00918436050415039, 0.006821632385253906, -0.53882122039794921, 0.842342495918273925, 120, 255, 1, 57212), -- G_Pumpkin_03 (Area: Weaver's Lair - Difficulty: 0) CreateObject1
+(@OGUID+13, 180408, 2601, 14752, 14755, '0', 0, 0, -316.317718505859375, -1432.9757080078125, -1085.0902099609375, 4.714815616607666015, -0.05248832702636718, 0.034543991088867187, -0.70540332794189453, 0.706015467643737792, 120, 255, 1, 57212), -- G_WitchHat_01 (Area: Weaver's Lair - Difficulty: 0) CreateObject1
+(@OGUID+14, 180415, 2601, 14752, 14755, '0', 0, 0, -239.809036254882812, -1442.3663330078125, -1086.8780517578125, 6.229013919830322265, 0, 0, -0.02708244323730468, 0.999633193016052246, 120, 255, 1, 57212), -- CandleBlack01 (Area: Weaver's Lair - Difficulty: 0) CreateObject1
+(@OGUID+15, 180523, 2601, 14752, 14755, '0', 0, 0, -275.119781494140625, -1449.734375, -1086.02783203125, 0, 0, 0, 0, 1, 120, 255, 1, 57212), -- Apple Bob (Area: Weaver's Lair - Difficulty: 0) CreateObject1
+(@OGUID+16, 464929, 2601, 14752, 14755, '0', 0, 0, -237.80035400390625, -1439.6875, -1088.120361328125, 4.816136837005615234, 0, 0, -0.66949176788330078, 0.742819488048553466, 120, 255, 1, 57212), -- Candy Bucket (Area: Weaver's Lair - Difficulty: 0) CreateObject1
+-- Wildcamp Ul'ar
+(@OGUID+17, 180405, 2601, 14752, 14766, '0', 0, 0, -1493.8472900390625, -607.60418701171875, -1357.8739013671875, 5.076570510864257812, 0.017495155334472656, 0.005661964416503906, -0.56740760803222656, 0.823231697082519531, 120, 255, 1, 57212), -- G_Pumpkin_01 (Area: Wildcamp Ul'ar - Difficulty: 0) CreateObject1
+(@OGUID+18, 180406, 2601, 14752, 14766, '0', 0, 0, -1507.107666015625, -617.94964599609375, -1358.2008056640625, 4.370656967163085937, 0, 0, -0.81704330444335937, 0.5765763521194458, 120, 255, 1, 57212), -- G_Pumpkin_02 (Area: Wildcamp Ul'ar - Difficulty: 0) CreateObject1
+(@OGUID+19, 180407, 2601, 14752, 14766, '0', 0, 0, -1502.720458984375, -592.47052001953125, -1357.6849365234375, 5.145113945007324218, 0.00918436050415039, 0.006821632385253906, -0.53882122039794921, 0.842342495918273925, 120, 255, 1, 57212), -- G_Pumpkin_03 (Area: Wildcamp Ul'ar - Difficulty: 0) CreateObject1
+(@OGUID+20, 180408, 2601, 14752, 14766, '0', 0, 0, -1484.3385009765625, -617.31597900390625, -1348.0562744140625, 4.746544361114501953, -0.0034499168395996, -0.03753471374511718, -0.69393539428710937, 0.719049990177154541, 120, 255, 1, 57212), -- G_WitchHat_01 (Area: Wildcamp Ul'ar - Difficulty: 0) CreateObject1
+(@OGUID+21, 180415, 2601, 14752, 14766, '0', 0, 0, -1503.3472900390625, -616.58856201171875, -1357.9542236328125, 6.229013919830322265, 0, 0, -0.02708244323730468, 0.999633193016052246, 120, 255, 1, 57212), -- CandleBlack01 (Area: Wildcamp Ul'ar - Difficulty: 0) CreateObject1
+(@OGUID+22, 180523, 2601, 14752, 14766, '0', 0, 0, -1488.765625, -591.6007080078125, -1357.49267578125, 0, 0, 0, 0, 1, 120, 255, 1, 57212), -- Apple Bob (Area: Wildcamp Ul'ar - Difficulty: 0) CreateObject1
+(@OGUID+23, 464928, 2601, 14752, 14766, '0', 0, 0, -1490.02783203125, -613.00518798828125, -1358.025634765625, 4.624428749084472656, 0, 0, -0.73751163482666015, 0.675334393978118896, 120, 255, 1, 57212), -- Candy Bucket (Area: Wildcamp Ul'ar - Difficulty: 0) CreateObject1
+-- Mmarl
+(@OGUID+24, 180405, 2601, 14752, 14767, '0', 0, 0, -1314.5035400390625, -2868.132080078125, -1184.9091796875, 3.054005861282348632, -0.0140852928161621, 0.011821746826171875, 0.998865127563476562, 0.0439351387321949, 120, 255, 1, 57212), -- G_Pumpkin_01 (Area: 0Mmarl - Difficulty: 0) CreateObject1
+(@OGUID+25, 180405, 2601, 14752, 14767, '0', 0, 0, -1361.84033203125, -2852.614501953125, -1185.38671875, 4.4309234619140625, 0.018387794494628906, -0.00017929077148437, -0.79926395416259765, 0.600698769092559814, 120, 255, 1, 57212), -- G_Pumpkin_01 (Area: Mmarl - Difficulty: 0) CreateObject1
+(@OGUID+26, 180406, 2601, 14752, 14767, '0', 0, 0, -1327.9322509765625, -2915.53125, -1185.648193359375, 1.844140172004699707, 0, 0, 0.796854019165039062, 0.60417187213897705, 120, 255, 1, 57212), -- G_Pumpkin_02 (Area: Mmarl - Difficulty: 0) CreateObject1
+(@OGUID+27, 180407, 2601, 14752, 14767, '0', 0, 0, -1376.0538330078125, -2901.432373046875, -1185.6280517578125, 6.247280120849609375, 0.004252910614013671, 0.0106201171875, -0.01799392700195312, 0.99977266788482666, 120, 255, 1, 57212), -- G_Pumpkin_03 (Area: Mmarl - Difficulty: 0) CreateObject1
+(@OGUID+28, 180408, 2601, 14752, 14767, '0', 0, 0, -1327.138916015625, -2888.432373046875, -1182.918701171875, 5.777016639709472656, 0.015492439270019531, -0.03436183929443359, -0.24954128265380859, 0.967630267143249511, 120, 255, 1, 57212), -- G_WitchHat_01 (Area: Mmarl - Difficulty: 0) CreateObject1
+(@OGUID+29, 180415, 2601, 14752, 14767, '0', 0, 0, -1320.763916015625, -2861.038330078125, -1181.5469970703125, 6.229013919830322265, 0, 0, -0.02708244323730468, 0.999633193016052246, 120, 255, 1, 57212), -- CandleBlack01 (Area: Mmarl - Difficulty: 0) CreateObject1
+(@OGUID+30, 180523, 2601, 14752, 14767, '0', 0, 0, -1341.5069580078125, -2869.123291015625, -1185.6256103515625, 0, 0, 0, 0, 1, 120, 255, 1, 57212), -- Apple Bob (Area: Mmarl - Difficulty: 0) CreateObject1
+(@OGUID+31, 464927, 2601, 14752, 14767, '0', 0, 0, -1329.9757080078125, -2891.076416015625, -1185.6256103515625, 5.635345935821533203, 0, 0, -0.31828498840332031, 0.94799506664276123, 120, 255, 1, 57212); -- Candy Bucket (Area: Mmarl - Difficulty: 0) CreateObject1
+
+-- Event spawns
+DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+31;
+INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES
+(12, @OGUID+0),
+(12, @OGUID+1),
+(12, @OGUID+2),
+(12, @OGUID+3),
+(12, @OGUID+4),
+(12, @OGUID+5),
+(12, @OGUID+6),
+(12, @OGUID+7),
+(12, @OGUID+8),
+(12, @OGUID+9),
+(12, @OGUID+10),
+(12, @OGUID+11),
+(12, @OGUID+12),
+(12, @OGUID+13),
+(12, @OGUID+14),
+(12, @OGUID+15),
+(12, @OGUID+16),
+(12, @OGUID+17),
+(12, @OGUID+18),
+(12, @OGUID+19),
+(12, @OGUID+20),
+(12, @OGUID+21),
+(12, @OGUID+22),
+(12, @OGUID+23),
+(12, @OGUID+24),
+(12, @OGUID+25),
+(12, @OGUID+26),
+(12, @OGUID+27),
+(12, @OGUID+28),
+(12, @OGUID+29),
+(12, @OGUID+30),
+(12, @OGUID+31);