diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2024_10_22_01_world.sql | 54 |
1 files changed, 54 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_10_22_01_world.sql b/sql/updates/world/master/2024_10_22_01_world.sql new file mode 100644 index 00000000000..1f6287412c1 --- /dev/null +++ b/sql/updates/world/master/2024_10_22_01_world.sql @@ -0,0 +1,54 @@ +SET @CONDREFID := 40001; +SET @ATID := 99; +SET @ATPROPERTIESID := 89; +SET @ATSPAWNID := 102; + +-- Areatrigger templates +DELETE FROM `areatrigger_template` WHERE `Id`=@ATID+0 AND `IsCustom`=1; +INSERT INTO `areatrigger_template` (`Id`, `IsCustom`, `Flags`, `ActionSetId`, `ActionSetFlags`, `VerifiedBuild`) VALUES +(@ATID+0, 1, 1, 0, 0, 0); + +DELETE FROM `areatrigger_template_actions` WHERE `AreaTriggerId`=@ATID+0 AND `IsCustom`=1; +INSERT INTO `areatrigger_template_actions` (`AreaTriggerId`, `IsCustom`, `ActionType`, `ActionParam`, `TargetType`) VALUES +(@ATID+0, 1, 0, 130412, 0); + +DELETE FROM `areatrigger_create_properties` WHERE `Id`=@ATPROPERTIESID+0 AND `IsCustom`=1; +INSERT INTO `areatrigger_create_properties` (`Id`, `IsCustom`, `AreaTriggerId`, `IsAreatriggerCustom`, `Flags`, `MoveCurveId`, `ScaleCurveId`, `MorphCurveId`, `FacingCurveId`, `AnimId`, `AnimKitId`, `DecalPropertiesId`, `SpellForVisuals`, `TimeToTarget`, `TimeToTargetScale`, `Shape`, `ShapeData0`, `ShapeData1`, `ShapeData2`, `ShapeData3`, `ShapeData4`, `ShapeData5`, `ShapeData6`, `ShapeData7`, `VerifiedBuild`) VALUES +(@ATPROPERTIESID+0, 1, @ATID+0, 1, 0, 0, 0, 0, 0, -1, 0, 0, NULL, 0, 0, 0, 20, 20, 0, 0, 0, 0, 0, 0, 0); + +DELETE FROM `areatrigger` WHERE `SpawnId`=@ATSPAWNID+0; +INSERT INTO `areatrigger` (`SpawnId`, `AreaTriggerCreatePropertiesId`, `IsCustom`, `MapId`, `SpawnDifficulties`, `PosX`, `PosY`, `PosZ`, `Orientation`, `PhaseUseFlags`, `PhaseId`, `PhaseGroup`, `Comment`, `VerifiedBuild`) VALUES +(@ATSPAWNID+0, @ATPROPERTIESID+0, 1, 1, '0', 1663.346, -4353.692, 26.3505, 0, 1, 0, 0, 'Orgrimmar - Grommash Hold - Art of War Movie Aura Trigger', 0); + +-- Spells +UPDATE `spell_target_position` SET `VerifiedBuild`=56819 WHERE (`ID`=130409 AND `EffectIndex`=2); + +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_art_of_war_movie_aura'; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(130412, 'spell_art_of_war_movie_aura'); + +UPDATE `quest_template_addon` SET `SourceSpellID`=175293 WHERE `ID` IN (29611,29612); + +-- Smart scripts +DELETE FROM `areatrigger_scripts` WHERE `entry`=8463; +INSERT INTO `areatrigger_scripts` VALUES +(8463, 'SmartTrigger'); + +DELETE FROM `smart_scripts` WHERE `entryorguid`=8463 AND `source_type`=2; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `action_param_string`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_param_string`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(8463,2,0,0,'',46,0,100,0,0,0,0,0,0,'',134,130412,0,0,0,0,0,0,NULL,7,0,0,0,0,NULL,0,0,0,0,'Areatrigger 8463 - On trigger - Invoker casts ''Art of War Movie Aura'''); + +-- Conditions +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=30 AND `SourceEntry`=8463; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=28 AND `SourceGroup`=@ATID+0 AND `SourceEntry`=1; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=-@CONDREFID; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(30,0,8463,0,0,6,0,67,0,0,'',0,0,0,'',' Areatrigger 8190 triggers if player is Horde'), +(30,0,8463,0,0,-@CONDREFID,0,0,0,0,'',0,0,0,'','Areatrigger 8190 triggers if condition reference 40001 is fulfilled'), +(28,@ATID+0,1,0,0,6,0,67,0,0,'',0,0,0,'',' Areatrigger 97 triggers if player is Horde'), +(28,@ATID+0,1,0,0,-@CONDREFID,0,0,0,0,'',0,0,0,'','Areatrigger 97 triggers if condition reference 40001 is fulfilled'), +(-@CONDREFID,0,0,0,0,47,0,29611,8,0,'',0,0,0,'','Apply condition reference if quest 29611 is taken'), +(-@CONDREFID,0,0,0,1,47,0,29612,8,0,'',0,0,0,'','Apply condition reference if quest 29612 is taken'), +(-@CONDREFID,0,0,0,2,47,0,49538,8,0,'',0,0,0,'','Apply condition reference if quest 49538 is taken'), +(-@CONDREFID,0,0,0,3,47,0,49852,8,0,'',0,0,0,'','Apply condition reference if quest 49852 is taken'), +(-@CONDREFID,0,0,0,4,47,0,60126,8,0,'',0,0,0,'','Apply condition reference if quest 60126 is taken'); |