DB/Drustvar: Implement Quest: "A Pungent Solution"

1 files changed, 199 insertions, 0 deletions

diff --git a/sql/updates/world/master/2025_07_19_08_world.sql b/sql/updates/world/master/2025_07_19_08_world.sql
new file mode 100644
index 00000000000..19612062e46
--- /dev/null
+++ b/sql/updates/world/master/2025_07_19_08_world.sql
@@ -0,0 +1,199 @@
+SET @OGUID := 7000612;
+
+SET @REFERENCEID := 700017;
+
+-- GameObject
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+19;
+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
+(@OGUID+0, 272769, 1643, 8721, 9130, '0', 0, 0, -343.751739501953125, 1478.420166015625, 10.96869468688964843, 6.098571300506591796, 0.569524288177490234, -0.10528564453125, -0.03814983367919921, 0.81431049108505249, 120, 255, 1, 60490), -- Onion (Area: Hangman's Point - Difficulty: 0) CreateObject1
+(@OGUID+1, 272769, 1643, 8721, 9130, '0', 0, 0, -349.1944580078125, 1485.9271240234375, 10.78191089630126953, 6.098571300506591796, 0.569524288177490234, -0.10528564453125, -0.03814983367919921, 0.81431049108505249, 120, 255, 1, 60490), -- Onion (Area: Hangman's Point - Difficulty: 0) CreateObject1
+(@OGUID+2, 272769, 1643, 8721, 9131, '0', 0, 0, -332.390625, 1501.7274169921875, 10.34607696533203125, 6.098571300506591796, 0.569524288177490234, -0.10528564453125, -0.03814983367919921, 0.81431049108505249, 120, 255, 1, 60490), -- Onion (Area: Watcher's Wood - Difficulty: 0) CreateObject1
+(@OGUID+3, 272769, 1643, 8721, 9131, '0', 0, 0, -349.44964599609375, 1531.171875, 10.34592819213867187, 6.098571300506591796, 0.569524288177490234, -0.10528564453125, -0.03814983367919921, 0.81431049108505249, 120, 255, 1, 60490), -- Onion (Area: Watcher's Wood - Difficulty: 0) CreateObject1
+(@OGUID+4, 272769, 1643, 8721, 9131, '0', 0, 0, -346.263885498046875, 1489.732666015625, 10.67344379425048828, 6.098571300506591796, 0.569524288177490234, -0.10528564453125, -0.03814983367919921, 0.81431049108505249, 120, 255, 1, 60490), -- Onion (Area: Watcher's Wood - Difficulty: 0) CreateObject1
+(@OGUID+5, 272769, 1643, 8721, 9131, '0', 0, 0, -344.08160400390625, 1502.48095703125, 10.34280586242675781, 6.098571300506591796, 0.569524288177490234, -0.10528564453125, -0.03814983367919921, 0.81431049108505249, 120, 255, 1, 60490), -- Onion (Area: Watcher's Wood - Difficulty: 0) CreateObject1
+(@OGUID+6, 272769, 1643, 8721, 9131, '0', 0, 0, -335.0625, 1506.1788330078125, 10.34596824645996093, 6.098571300506591796, 0.569524288177490234, -0.10528564453125, -0.03814983367919921, 0.81431049108505249, 120, 255, 1, 60490), -- Onion (Area: Watcher's Wood - Difficulty: 0) CreateObject1
+(@OGUID+7, 272769, 1643, 8721, 9131, '0', 0, 0, -369.274322509765625, 1511.1041259765625, 10.31694793701171875, 6.098571300506591796, 0.569524288177490234, -0.10528564453125, -0.03814983367919921, 0.81431049108505249, 120, 255, 1, 60490), -- Onion (Area: Watcher's Wood - Difficulty: 0) CreateObject1
+(@OGUID+8, 272769, 1643, 8721, 9131, '0', 0, 0, -353.1788330078125, 1518.970458984375, 10.34371185302734375, 6.098571300506591796, 0.569524288177490234, -0.10528564453125, -0.03814983367919921, 0.81431049108505249, 120, 255, 1, 60490), -- Onion (Area: Watcher's Wood - Difficulty: 0) CreateObject1
+(@OGUID+9, 272769, 1643, 8721, 9131, '0', 0, 0, -360.095489501953125, 1531.6805419921875, 10.33778285980224609, 6.098571300506591796, 0.569524288177490234, -0.10528564453125, -0.03814983367919921, 0.81431049108505249, 120, 255, 1, 60490), -- Onion (Area: Watcher's Wood - Difficulty: 0) CreateObject1
+(@OGUID+10, 272769, 1643, 8721, 9131, '0', 0, 0, -355.59027099609375, 1491.9583740234375, 10.44450664520263671, 6.098571300506591796, 0.569524288177490234, -0.10528564453125, -0.03814983367919921, 0.81431049108505249, 120, 255, 1, 60490), -- Onion (Area: Watcher's Wood - Difficulty: 0) CreateObject1
+(@OGUID+11, 272769, 1643, 8721, 9131, '0', 0, 0, -374.001739501953125, 1516.7864990234375, 10.34592914581298828, 6.098571300506591796, 0.569524288177490234, -0.10528564453125, -0.03814983367919921, 0.81431049108505249, 120, 255, 1, 60490), -- Onion (Area: Watcher's Wood - Difficulty: 0) CreateObject1
+(@OGUID+12, 272769, 1643, 8721, 9131, '0', 0, 0, -332.357635498046875, 1520.7291259765625, 10.34595966339111328, 6.098571300506591796, 0.569524288177490234, -0.10528564453125, -0.03814983367919921, 0.81431049108505249, 120, 255, 1, 60490), -- Onion (Area: Watcher's Wood - Difficulty: 0) CreateObject1
+(@OGUID+13, 272769, 1643, 8721, 9131, '0', 0, 0, -363.564239501953125, 1520.8646240234375, 10.34593391418457031, 6.098571300506591796, 0.569524288177490234, -0.10528564453125, -0.03814983367919921, 0.81431049108505249, 120, 255, 1, 60490), -- Onion (Area: Watcher's Wood - Difficulty: 0) CreateObject1
+(@OGUID+14, 272769, 1643, 8721, 9131, '0', 0, 0, -358.87152099609375, 1505.34375, 10.13295459747314453, 6.098571300506591796, 0.569524288177490234, -0.10528564453125, -0.03814983367919921, 0.81431049108505249, 120, 255, 1, 60490), -- Onion (Area: Watcher's Wood - Difficulty: 0) CreateObject1
+(@OGUID+15, 272769, 1643, 8721, 9131, '0', 0, 0, -339.329864501953125, 1527.232666015625, 10.34592914581298828, 6.098571300506591796, 0.569524288177490234, -0.10528564453125, -0.03814983367919921, 0.81431049108505249, 120, 255, 1, 60490), -- Onion (Area: Watcher's Wood - Difficulty: 0) CreateObject1
+(@OGUID+16, 272769, 1643, 8721, 9131, '0', 0, 0, -361.345489501953125, 1548.689208984375, 10.34587287902832031, 6.098571300506591796, 0.569524288177490234, -0.10528564453125, -0.03814983367919921, 0.81431049108505249, 120, 255, 1, 60490), -- Onion (Area: Watcher's Wood - Difficulty: 0) CreateObject1
+(@OGUID+17, 272769, 1643, 8721, 9131, '0', 0, 0, -331.90277099609375, 1547.267333984375, 10.27608489990234375, 6.098571300506591796, 0.569524288177490234, -0.10528564453125, -0.03814983367919921, 0.81431049108505249, 120, 255, 1, 60490), -- Onion (Area: Watcher's Wood - Difficulty: 0) CreateObject1
+(@OGUID+18, 272769, 1643, 8721, 9131, '0', 0, 0, -361.439239501953125, 1551.3853759765625, 10.34599018096923828, 6.098571300506591796, 0.569524288177490234, -0.10528564453125, -0.03814983367919921, 0.81431049108505249, 120, 255, 1, 60490), -- Onion (Area: Watcher's Wood - Difficulty: 0) CreateObject1
+(@OGUID+19, 272769, 1643, 8721, 9131, '0', 0, 0, -362.6475830078125, 1550.34033203125, 10.32822036743164062, 6.098571300506591796, 0.569524288177490234, -0.10528564453125, -0.03814983367919921, 0.81431049108505249, 120, 255, 1, 60490); -- Onion (Area: Watcher's Wood - Difficulty: 0) CreateObject1
+
+-- Template Addon
+DELETE FROM `gameobject_template_addon` WHERE `entry`=272769;
+INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`) VALUES
+(272769, 0, 0x204000, 0, 0); -- Onion
+
+-- Template
+UPDATE `gameobject_template` SET `ContentTuningId`=187, `VerifiedBuild`=60490 WHERE `entry`=272769; -- Onion
+
+-- Loot
+DELETE FROM `gameobject_loot_template` WHERE `Entry` = 75346;
+INSERT INTO `gameobject_loot_template` (`Entry`, `ItemType`, `Item`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
+(75346, 1, @REFERENCEID+0, 100, 0, 1, 1, 1, 1, 'Reference Junk Items');
+
+-- Junk Items: Using best match Entry @REFERENCEID+0
+DELETE FROM `reference_loot_template` WHERE `Entry` = @REFERENCEID+0;
+INSERT INTO `reference_loot_template` (`Entry`, `ItemType`, `Item`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
+(@REFERENCEID+0, 0, 152099, 85, 0, 1, 1, 1, 1, 'Shriveled Onion'),
+(@REFERENCEID+0, 0, 151934, 15, 0, 1, 1, 1, 1, 'Juicy Onion');
+
+-- Spawntracking
+DELETE FROM `spawn_tracking_template` WHERE `SpawnTrackingId` IN (1354541 /*Map: 1643 (Kul Tiras) - Phase: 0*/, 1354543 /*Map: 1643 (Kul Tiras) - Phase: 0*/, 1354542 /*Map: 1643 (Kul Tiras) - Phase: 0*/, 1354544 /*Map: 1643 (Kul Tiras) - Phase: 0*/, 1354557 /*Map: 1643 (Kul Tiras) - Phase: 0*/, 1354548 /*Map: 1643 (Kul Tiras) - Phase: 0*/, 1354547 /*Map: 1643 (Kul Tiras) - Phase: 0*/, 1354551 /*Map: 1643 (Kul Tiras) - Phase: 0*/, 1354559 /*Map: 1643 (Kul Tiras) - Phase: 0*/, 1354546 /*Map: 1643 (Kul Tiras) - Phase: 0*/, 1354549 /*Map: 1643 (Kul Tiras) - Phase: 0*/, 1354550 /*Map: 1643 (Kul Tiras) - Phase: 0*/, 1354558 /*Map: 1643 (Kul Tiras) - Phase: 0*/, 1354553 /*Map: 1643 (Kul Tiras) - Phase: 0*/, 1354555 /*Map: 1643 (Kul Tiras) - Phase: 0*/, 1354552 /*Map: 1643 (Kul Tiras) - Phase: 0*/, 1354554 /*Map: 1643 (Kul Tiras) - Phase: 0*/, 1354560 /*Map: 1643 (Kul Tiras) - Phase: 0*/, 1354545 /*Map: 1643 (Kul Tiras) - Phase: 0*/, 1354556 /*Map: 1643 (Kul Tiras) - Phase: 0*/);
+INSERT INTO `spawn_tracking_template` (`SpawnTrackingId`, `MapId`, `PhaseId`, `PhaseGroup`, `PhaseUseFlags`, `VerifiedBuild`) VALUES
+(1354541, 1643, 0, 0, 0, 60490), -- Map: 1643 (Kul Tiras) - Phase: 0
+(1354543, 1643, 0, 0, 0, 60490), -- Map: 1643 (Kul Tiras) - Phase: 0
+(1354542, 1643, 0, 0, 0, 60490), -- Map: 1643 (Kul Tiras) - Phase: 0
+(1354544, 1643, 0, 0, 0, 60490), -- Map: 1643 (Kul Tiras) - Phase: 0
+(1354557, 1643, 0, 0, 0, 60490), -- Map: 1643 (Kul Tiras) - Phase: 0
+(1354548, 1643, 0, 0, 0, 60490), -- Map: 1643 (Kul Tiras) - Phase: 0
+(1354547, 1643, 0, 0, 0, 60490), -- Map: 1643 (Kul Tiras) - Phase: 0
+(1354551, 1643, 0, 0, 0, 60490), -- Map: 1643 (Kul Tiras) - Phase: 0
+(1354559, 1643, 0, 0, 0, 60490), -- Map: 1643 (Kul Tiras) - Phase: 0
+(1354546, 1643, 0, 0, 0, 60490), -- Map: 1643 (Kul Tiras) - Phase: 0
+(1354549, 1643, 0, 0, 0, 60490), -- Map: 1643 (Kul Tiras) - Phase: 0
+(1354550, 1643, 0, 0, 0, 60490), -- Map: 1643 (Kul Tiras) - Phase: 0
+(1354558, 1643, 0, 0, 0, 60490), -- Map: 1643 (Kul Tiras) - Phase: 0
+(1354553, 1643, 0, 0, 0, 60490), -- Map: 1643 (Kul Tiras) - Phase: 0
+(1354555, 1643, 0, 0, 0, 60490), -- Map: 1643 (Kul Tiras) - Phase: 0
+(1354552, 1643, 0, 0, 0, 60490), -- Map: 1643 (Kul Tiras) - Phase: 0
+(1354554, 1643, 0, 0, 0, 60490), -- Map: 1643 (Kul Tiras) - Phase: 0
+(1354560, 1643, 0, 0, 0, 60490), -- Map: 1643 (Kul Tiras) - Phase: 0
+(1354545, 1643, 0, 0, 0, 60490), -- Map: 1643 (Kul Tiras) - Phase: 0
+(1354556, 1643, 0, 0, 0, 60490); -- Map: 1643 (Kul Tiras) - Phase: 0
+
+DELETE FROM `spawn_tracking_quest_objective` WHERE `QuestObjectiveId` IN (291547,291598);
+INSERT INTO `spawn_tracking_quest_objective` (`SpawnTrackingId`, `QuestObjectiveId`, `VerifiedBuild`) VALUES
+(1354541,291547,60257),
+(1354541,291598,60257),
+(1354543,291547,60257),
+(1354543,291598,60257),
+(1354542,291547,60257),
+(1354542,291598,60257),
+(1354544,291547,60257),
+(1354544,291598,60257),
+(1354557,291547,60257),
+(1354557,291598,60257),
+(1354548,291547,60257),
+(1354548,291598,60257),
+(1354547,291547,60257),
+(1354547,291598,60257),
+(1354551,291547,60257),
+(1354551,291598,60257),
+(1354559,291547,60257),
+(1354559,291598,60257),
+(1354546,291547,60257),
+(1354546,291598,60257),
+(1354549,291547,60257),
+(1354549,291598,60257),
+(1354550,291547,60257),
+(1354550,291598,60257),
+(1354558,291547,60257),
+(1354558,291598,60257),
+(1354553,291547,60257),
+(1354553,291598,60257),
+(1354555,291547,60257),
+(1354555,291598,60257),
+(1354552,291547,60257),
+(1354552,291598,60257),
+(1354554,291547,60257),
+(1354554,291598,60257),
+(1354560,291547,60257),
+(1354560,291598,60257),
+(1354545,291547,60257),
+(1354545,291598,60257),
+(1354556,291547,60257),
+(1354556,291598,60257);
+
+DELETE FROM `spawn_tracking` WHERE (`SpawnType`=1 AND `SpawnId` IN (@OGUID+0,@OGUID+1,@OGUID+2,@OGUID+3,@OGUID+4,@OGUID+5,@OGUID+6,@OGUID+7,@OGUID+8,@OGUID+9,@OGUID+10,@OGUID+11,@OGUID+12,@OGUID+13,@OGUID+14,@OGUID+15,@OGUID+16,@OGUID+17,@OGUID+18,@OGUID+19));
+INSERT INTO `spawn_tracking` (`SpawnTrackingId`, `SpawnType`, `SpawnId`, `QuestObjectiveIds`) VALUES
+(1354541, 1, @OGUID+0, '291598,291547'), -- Onion
+(1354543, 1, @OGUID+1, '291598,291547'), -- Onion
+(1354542, 1, @OGUID+2, '291598,291547'), -- Onion
+(1354544, 1, @OGUID+3, '291598,291547'), -- Onion
+(1354557, 1, @OGUID+4, '291598,291547'), -- Onion
+(1354548, 1, @OGUID+5, '291598,291547'), -- Onion
+(1354547, 1, @OGUID+6, '291598,291547'), -- Onion
+(1354551, 1, @OGUID+7, '291598,291547'), -- Onion
+(1354559, 1, @OGUID+8, '291598,291547'), -- Onion
+(1354546, 1, @OGUID+9, '291598,291547'), -- Onion
+(1354549, 1, @OGUID+10, '291598,291547'), -- Onion
+(1354550, 1, @OGUID+11, '291598,291547'), -- Onion
+(1354558, 1, @OGUID+12, '291598,291547'), -- Onion
+(1354553, 1, @OGUID+13, '291598,291547'), -- Onion
+(1354555, 1, @OGUID+14, '291598,291547'), -- Onion
+(1354552, 1, @OGUID+15, '291598,291547'), -- Onion
+(1354554, 1, @OGUID+16, '291598,291547'), -- Onion
+(1354560, 1, @OGUID+17, '291598,291547'), -- Onion
+(1354545, 1, @OGUID+18, '291598,291547'), -- Onion
+(1354556, 1, @OGUID+19, '291598,291547'); -- Onion
+
+DELETE FROM `spawn_tracking_state` WHERE (`SpawnType`=1 AND `SpawnId` IN (@OGUID+0,@OGUID+1,@OGUID+2,@OGUID+3,@OGUID+4,@OGUID+5,@OGUID+6,@OGUID+7,@OGUID+8,@OGUID+9,@OGUID+10,@OGUID+11,@OGUID+12,@OGUID+13,@OGUID+14,@OGUID+15,@OGUID+16,@OGUID+17,@OGUID+18,@OGUID+19));
+INSERT INTO `spawn_tracking_state` (`SpawnType`, `SpawnId`, `State`, `Visible`, `StateSpellVisualId`, `StateAnimId`, `StateAnimKitId`, `StateWorldEffects`) VALUES
+(1, @OGUID+0, 0, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+0, 1, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+0, 2, 0, NULL, NULL, NULL, NULL),
+(1, @OGUID+1, 0, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+1, 1, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+1, 2, 0, NULL, NULL, NULL, NULL),
+(1, @OGUID+2, 0, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+2, 1, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+2, 2, 0, NULL, NULL, NULL, NULL),
+(1, @OGUID+3, 0, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+3, 1, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+3, 2, 0, NULL, NULL, NULL, NULL),
+(1, @OGUID+4, 0, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+4, 1, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+4, 2, 0, NULL, NULL, NULL, NULL),
+(1, @OGUID+5, 0, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+5, 1, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+5, 2, 0, NULL, NULL, NULL, NULL),
+(1, @OGUID+6, 0, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+6, 1, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+6, 2, 0, NULL, NULL, NULL, NULL),
+(1, @OGUID+7, 0, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+7, 1, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+7, 2, 0, NULL, NULL, NULL, NULL),
+(1, @OGUID+8, 0, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+8, 1, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+8, 2, 0, NULL, NULL, NULL, NULL),
+(1, @OGUID+9, 0, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+9, 1, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+9, 2, 0, NULL, NULL, NULL, NULL),
+(1, @OGUID+10, 0, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+10, 1, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+10, 2, 0, NULL, NULL, NULL, NULL),
+(1, @OGUID+11, 0, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+11, 1, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+11, 2, 0, NULL, NULL, NULL, NULL),
+(1, @OGUID+12, 0, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+12, 1, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+12, 2, 0, NULL, NULL, NULL, NULL),
+(1, @OGUID+13, 0, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+13, 1, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+13, 2, 0, NULL, NULL, NULL, NULL),
+(1, @OGUID+14, 0, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+14, 1, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+14, 2, 0, NULL, NULL, NULL, NULL),
+(1, @OGUID+15, 0, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+15, 1, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+15, 2, 0, NULL, NULL, NULL, NULL),
+(1, @OGUID+16, 0, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+16, 1, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+16, 2, 0, NULL, NULL, NULL, NULL),
+(1, @OGUID+17, 0, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+17, 1, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+17, 2, 0, NULL, NULL, NULL, NULL),
+(1, @OGUID+18, 0, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+18, 1, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+18, 2, 0, NULL, NULL, NULL, NULL),
+(1, @OGUID+19, 0, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+19, 1, 1, NULL, NULL, NULL, NULL),
+(1, @OGUID+19, 2, 0, NULL, NULL, NULL, NULL);