DB/Drustvar: Added Ulfar in Ulfars Den

1 files changed, 63 insertions, 0 deletions

diff --git a/sql/updates/world/master/2024_05_26_01_world.sql b/sql/updates/world/master/2024_05_26_01_world.sql
new file mode 100644
index 00000000000..b9d467c6193
--- /dev/null
+++ b/sql/updates/world/master/2024_05_26_01_world.sql
@@ -0,0 +1,63 @@
+SET @CGUID := 7000559;
+SET @NPCTEXTID := 570041;
+
+DELETE FROM `phase_name` WHERE `ID`=12645;
+INSERT INTO `phase_name` (`ID`, `Name`) VALUES
+(12645, 'Cosmetic: See Ulfar in Ulfars Den');
+
+DELETE FROM `phase_area` WHERE `PhaseId`=12645;
+INSERT INTO `phase_area` (`AreaId`, `PhaseId`, `Comment`) VALUES
+(9965, 12645, 'Cosmetic: See Ulfar in Ulfars Den');
+
+DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId` = 26) AND (`SourceGroup` IN (12645));
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `Comment`) VALUES 
+(26, 12645, 0, 0, 0, 48, 0, 388248, 0, 1, '', 1, 'Player doesn\'t have quest objective 388248 == 1'),
+(26, 12645, 0, 0, 1, 47, 0, 54731, 66, 0, '', 0, 'Player have Balance in All Things (54731) in state complete, rewarded');
+
+DELETE FROM `creature` WHERE `guid`=@CGUID+0;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curHealthPct`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES
+(@CGUID+0, 141159, 1643, 8721, 9965, '0', 12645, 0, 0, 0, -489, 2710.79248046875, 279.670654296875, 5.194651603698730468, 120, 0, 0, 100, 0, NULL, NULL, NULL, NULL, 54847); -- Ulfar (Area: Ulfar's Den - Difficulty: 0) CreateObject1
+
+UPDATE `creature_template_difficulty` SET `StaticFlags1`=268435456, `VerifiedBuild`=54847 WHERE (`Entry`=141159 AND `DifficultyID`=0); -- 141159 (Ulfar) - CanSwim
+
+DELETE FROM `creature_template_gossip` WHERE (`CreatureID`=141159 AND `MenuID`=23072) OR (`CreatureID`=149386 AND `MenuID`=23899);
+INSERT INTO `creature_template_gossip` (`CreatureID`, `MenuID`, `VerifiedBuild`) VALUES
+(141159, 23072, 54847), -- Ulfar
+(149386, 23899, 54847); -- Ulfar
+
+DELETE FROM `npc_text` WHERE `ID` BETWEEN @NPCTEXTID+0 AND @NPCTEXTID+2;
+INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES
+(@NPCTEXTID+0, 1, 0, 0, 0, 0, 0, 0, 0, 161422, 0, 0, 0, 0, 0, 0, 0, 54847), -- 141159 (Ulfar)
+(@NPCTEXTID+1, 1, 0, 0, 0, 0, 0, 0, 0, 168297, 0, 0, 0, 0, 0, 0, 0, 54847), -- 141159 (Ulfar)
+(@NPCTEXTID+2, 1, 0, 0, 0, 0, 0, 0, 0, 170289, 0, 0, 0, 0, 0, 0, 0, 54847); -- 149386 (Ulfar)
+
+DELETE FROM `gossip_menu` WHERE (`MenuID`=23310 AND `TextID`=@NPCTEXTID+0) OR (`MenuID`=23072 AND `TextID`=@NPCTEXTID+1) OR (`MenuID`=23899 AND `TextID`=@NPCTEXTID+2);
+INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES
+(23310, @NPCTEXTID+0, 54847), -- 141159 (Ulfar)
+(23072, @NPCTEXTID+1, 54847), -- 141159 (Ulfar)
+(23899, @NPCTEXTID+2, 54847); -- 149386 (Ulfar)
+
+DELETE FROM `gossip_menu_option` WHERE (`MenuID`=23072 AND `OptionID` IN (2,6));
+INSERT INTO `gossip_menu_option` (`MenuID`, `GossipOptionID`, `OptionID`, `OptionNpc`, `OptionText`, `OptionBroadcastTextID`, `Language`, `Flags`, `ActionMenuID`, `ActionPoiID`, `GossipNpcOptionID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `SpellID`, `OverrideIconID`, `VerifiedBuild`) VALUES
+(23072, 49063, 2, 0, 'Are you a druid as well?', 161426, 0, 0, 23310, 0, NULL, 0, 0, NULL, 0, NULL, NULL, 54847),
+(23072, 49067, 6, 0, '|cFF0000FF(Quest)|r Tell me how I can help.', 168298, 0, 0, 0, 0, NULL, 0, 0, NULL, 0, NULL, NULL, 54847);
+
+UPDATE `gossip_menu_option` SET `GossipOptionID`=49062, `OptionBroadcastTextID`=25092, `ActionMenuID`=23307, `VerifiedBuild`=54847 WHERE (`MenuID`=23072 AND `OptionID`=1); -- OptionBroadcastTextID: 25092 - 38470 - 47091 - 47632 - 62792 - 65124 - 79414 - 97339 - 153888 - 161428 - 166571 - 176081 - 185133 - 224837
+UPDATE `gossip_menu_option` SET `GossipOptionID`=49065, `ActionMenuID`=23311, `VerifiedBuild`=54847 WHERE (`MenuID`=23072 AND `OptionID`=4);
+UPDATE `gossip_menu_option` SET `GossipOptionID`=49155, `OptionBroadcastTextID`=61781, `ActionMenuID`=23072, `VerifiedBuild`=54847 WHERE (`MenuID`=23307 AND `OptionID`=0); -- OptionBroadcastTextID: 61781 - 121489 - 152386 - 157767 - 171009
+UPDATE `gossip_menu_option` SET `GossipOptionID`=49156, `OptionBroadcastTextID`=61781, `ActionMenuID`=23072, `VerifiedBuild`=54847 WHERE (`MenuID`=23310 AND `OptionID`=0); -- OptionBroadcastTextID: 61781 - 121489 - 152386 - 157767 - 171009
+UPDATE `gossip_menu_option` SET `GossipOptionID`=49157, `OptionBroadcastTextID`=61781, `ActionMenuID`=23072, `VerifiedBuild`=54847 WHERE (`MenuID`=23311 AND `OptionID`=0); -- OptionBroadcastTextID: 61781 - 121489 - 152386 - 157767 - 171009
+
+-- 
+DELETE FROM `creature_model_info` WHERE `DisplayID`=90894;
+INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`) VALUES
+(90894, 5, 0, 0, 54847);
+
+UPDATE `creature_model_info` SET `BoundingRadius`=1, `CombatReach`=1, `VerifiedBuild`=54847 WHERE `DisplayID`=86573;
+UPDATE `creature_model_info` SET `VerifiedBuild`=54847 WHERE `DisplayID` IN (87111, 87519, 87518, 80850, 79761, 79843, 80951, 78516, 80766, 87930, 85030, 83401, 56156, 85176, 83402, 85032, 83399, 52598, 79282, 134, 79676, 87425, 86520, 85390, 86698, 81081, 86525, 81144, 2537, 86519);
+UPDATE `creature_model_info` SET `BoundingRadius`=0.866801261901855468, `CombatReach`=2, `VerifiedBuild`=54847 WHERE `DisplayID`=86555;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.859295487403869628, `CombatReach`=0.400000005960464477, `VerifiedBuild`=54847 WHERE `DisplayID` IN (80910, 45598, 45906);
+UPDATE `creature_model_info` SET `BoundingRadius`=0.25, `CombatReach`=0.25, `VerifiedBuild`=54847 WHERE `DisplayID`=81097;
+UPDATE `creature_model_info` SET `BoundingRadius`=2.588892936706542968, `CombatReach`=1.5, `VerifiedBuild`=54847 WHERE `DisplayID`=60055;
+UPDATE `creature_model_info` SET `BoundingRadius`=1.881773948669433593, `CombatReach`=2.299999952316284179, `VerifiedBuild`=54847 WHERE `DisplayID`=53283;
+UPDATE `creature_model_info` SET `BoundingRadius`=0.434602528810501098, `VerifiedBuild`=54847 WHERE `DisplayID`=52607;
\ No newline at end of file