From f1c51e2a8d3e1cfe7cb8ebf08260d2c74b8b56cb Mon Sep 17 00:00:00 2001 From: Teleqraph Date: Sat, 19 Aug 2023 20:09:52 +0200 Subject: Scripts/Spells: Implement Efflorescence and Spirit Blossoms (#29176) Co-authored-by: Shauren --- sql/updates/world/master/2023_08_19_02_world.sql | 26 ++++++++++++++++++++++++ 1 file changed, 26 insertions(+) create mode 100644 sql/updates/world/master/2023_08_19_02_world.sql (limited to 'sql') diff --git a/sql/updates/world/master/2023_08_19_02_world.sql b/sql/updates/world/master/2023_08_19_02_world.sql new file mode 100644 index 00000000000..c0246eceeff --- /dev/null +++ b/sql/updates/world/master/2023_08_19_02_world.sql @@ -0,0 +1,26 @@ +DELETE FROM `areatrigger_template` WHERE `Id`=13091 AND `IsServerSide`=0; +INSERT INTO `areatrigger_template` (`Id`,`IsServerSide`,`Data0`,`Data1`,`VerifiedBuild`) VALUES +(13091,0,10,10,50585); + +DELETE FROM `areatrigger_create_properties` WHERE `Id`=9049; +INSERT INTO `areatrigger_create_properties` (`Id`, `AreaTriggerId`, `MoveCurveId`, `ScaleCurveId`, `MorphCurveId`, `FacingCurveId`, `AnimId`, `AnimKitId`, `DecalPropertiesId`, `TimeToTarget`, `TimeToTargetScale`, `Shape`, `ShapeData0`, `ShapeData1`, `ShapeData2`, `ShapeData3`, `ShapeData4`, `ShapeData5`, `ShapeData6`, `ShapeData7`, `ScriptName`, `VerifiedBuild`) VALUES +(9049, 13091, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 10, 10, 0, 0, 0, 0, 0, 0, '', 50585); + +DELETE FROM `creature_template_addon` WHERE `entry`=47649; +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `MountCreatureID`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvPFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(47649, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''); + +DELETE FROM `creature_template_difficulty` WHERE `Entry`=47649 AND `DifficultyID`!=0; + +DELETE FROM `creature_template_movement` WHERE `CreatureId`=47649; +INSERT INTO `creature_template_movement` (`CreatureId`,`Flight`,`Rooted`) VALUES +(47649,1,1); + +UPDATE `creature_template` SET `faction`=35,`speed_run`=1,`unit_flags`=0x2000200,`unit_flags2`=0x4000000,`unit_flags3`=0x1000000,`flags_extra`=0x80,`ScriptName`='npc_dru_efflorescence' WHERE `entry`=47649; + +DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_dru_efflorescence', 'spell_dru_efflorescence_dummy', 'spell_dru_efflorescence_heal', 'spell_dru_spring_blossoms'); +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(145205, 'spell_dru_efflorescence'), +(81262, 'spell_dru_efflorescence_dummy'), +(81269, 'spell_dru_efflorescence_heal'), +(81269, 'spell_dru_spring_blossoms'); -- cgit v1.2.3