DB/Spawns: Lightforged Beacon in Stormwind

closes #27146 by mdx7

1 files changed, 36 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_10_24_04_world.sql b/sql/updates/world/master/2021_10_24_04_world.sql
new file mode 100644
index 00000000000..72ccbb91fc2
--- /dev/null
+++ b/sql/updates/world/master/2021_10_24_04_world.sql
@@ -0,0 +1,36 @@
+-- 
+SET @CGUID := 1050137;
+SET @OGUID := 600017;
+
+DELETE FROM `gameobject_template_addon` WHERE `entry` IN (271723 /*Lightforged Beacon*/);
+INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`) VALUES
+(271723, 114, 0, 0, 0); -- Lightforged Beacon
+
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `npcflag`=16777216, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=34816, `VerifiedBuild`=40593 WHERE `entry`=130758; -- Lightforged Beacon
+UPDATE `creature_template_model` SET `VerifiedBuild`=40593 WHERE (`CreatureID`=130758 AND `Idx`=0); -- Lightforged Beacon
+
+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`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(@CGUID+0, 130758, 0, 1519, 9171, '0', 10034, 0, 0, 0, -8163.1318359375, 777.22918701171875, 76.84771728515625, 6.195094108581542968, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 40593); -- Lightforged Beacon (Area: Stormwind Embassy - Difficulty: 0)
+
+DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`=130758;
+INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES
+(130758, 258298, 3, 0);
+
+DELETE FROM `spell_target_position` WHERE (`ID`=258297 AND `EffectIndex`=0);
+INSERT INTO `spell_target_position` (`ID`, `EffectIndex`, `MapID`, `PositionX`, `PositionY`, `PositionZ`, `VerifiedBuild`) VALUES
+(258297, 0, 1860, 459.0889892578125, 1450.1400146484375, 758.01800537109375, 40593); -- Spell: 258297 (Teleport to Vindicaar) Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS)
+
+UPDATE `gameobject_template` SET `ContentTuningId`=293, `VerifiedBuild`=40593 WHERE `entry`=271723; -- Lightforged Beacon
+
+DELETE FROM `gameobject` WHERE `guid`=@OGUID+0;
+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, 271723, 0, 1519, 9171, '0', 10034, 0, -8163.1318359375, 777.22918701171875, 76.76438140869140625, 6.195094585418701171, 0, 0, -0.04403114318847656, 0.999030172824859619, 120, 255, 1, 40593); -- Lightforged Beacon (Area: Stormwind Embassy - Difficulty: 0)
+
+DELETE FROM `phase_area` WHERE `AreaId`=1519 AND `PhaseId`=10034;
+INSERT INTO `phase_area` (`AreaId`, `PhaseId`, `Comment`) VALUES
+(1519, 10034, 'Cosmetic: Lightforged Beacon (LF Draenei) in Stormwind');
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=26 AND `SourceGroup`=10034 AND `SourceEntry`=1519;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `Comment`) VALUES
+(26, 10034, 1519, 0, 0, 16, 0, 0x20000000, 0, 0, 0, 'Player is race Lightforged Draenei');