diff options
Diffstat (limited to 'sql')
-rw-r--r-- | sql/updates/world/master/2025_09_13_00_world.sql | 39 |
1 files changed, 39 insertions, 0 deletions
diff --git a/sql/updates/world/master/2025_09_13_00_world.sql b/sql/updates/world/master/2025_09_13_00_world.sql new file mode 100644 index 00000000000..e88d27a82e8 --- /dev/null +++ b/sql/updates/world/master/2025_09_13_00_world.sql @@ -0,0 +1,39 @@ +SET @ATID := 165; +SET @ATIDSPAWN := 261; +SET @ATCP := 159; + +-- Serverside Areatrigger +DELETE FROM `areatrigger_template` WHERE (`Id` = @ATID+0 AND `IsCustom` = 1); +INSERT INTO `areatrigger_template` (`Id`, `IsCustom`, `Flags`, `VerifiedBuild`) VALUES +(@ATID+0, 1, 1, 0); + +DELETE FROM `areatrigger` WHERE `SpawnId` BETWEEN @ATIDSPAWN+0 AND @ATIDSPAWN+0; +INSERT INTO `areatrigger` (`SpawnId`, `AreaTriggerCreatePropertiesId`, `IsCustom`, `MapId`, `SpawnDifficulties`, `PosX`, `PosY`, `PosZ`, `Orientation`, `PhaseUseFlags`, `PhaseId`, `PhaseGroup`, `ScriptName`, `Comment`, `VerifiedBuild`) VALUES +(@ATIDSPAWN+0, @ATCP+0, 1, 1643, '0', -1040.8680419921875, 1283.74658203125, 6.949351787567138671, 1.218581557273864746, 0, 0, 0, 'SmartAreaTriggerAI', 'Drustvar - trigger conversation for Evelyn Pare', 0); + +DELETE FROM `areatrigger_create_properties` WHERE (`Id`= @ATCP+0 AND `IsCustom`=1) OR (`Id`= @ATCP+1 AND `IsCustom`=1) OR (`Id`= @ATCP+2 AND `IsCustom`=1); +INSERT INTO `areatrigger_create_properties` (`Id`, `IsCustom`, `AreaTriggerId`, `IsAreatriggerCustom`, `Flags`, `MoveCurveId`, `ScaleCurveId`, `MorphCurveId`, `FacingCurveId`, `AnimId`, `AnimKitId`, `DecalPropertiesId`, `SpellForVisuals`, `TimeToTargetScale`, `Shape`, `ShapeData0`, `ShapeData1`, `ShapeData2`, `ShapeData3`, `ShapeData4`, `ShapeData5`, `ShapeData6`, `ShapeData7`, `ScriptName`, `VerifiedBuild`) VALUES +(@ATCP+0, 1, @ATID+0, 1, 0, 0, 0, 0, 0, -1, 0, 0, NULL, 0, 0, 15, 15, 0, 0, 0, 0, 0, 0, '', 0); + +-- Conversation +DELETE FROM `conversation_template` WHERE `Id`=6209; +INSERT INTO `conversation_template` (`Id`, `FirstLineID`, `TextureKitId`, `VerifiedBuild`) VALUES +(6209, 13865, 0, 63003); + +DELETE FROM `conversation_actors` WHERE (`ConversationId`=6209 AND `Idx`=0); +INSERT INTO `conversation_actors` (`ConversationId`, `ConversationActorId`, `ConversationActorGuid`, `Idx`, `CreatureId`, `CreatureDisplayInfoId`, `NoActorObject`, `ActivePlayerObject`, `VerifiedBuild`) VALUES +(6209, 60393, 7003584, 0, 0, 0, 0, 0, 63003); -- Full: 0x204268CD607B598000029000004150E0 Creature/0 R4250/S656 Map: 1643 (Kul Tiras) Entry: 126310 (Evelyn Pare) Low: 4280544 + +DELETE FROM `conversation_line_template` WHERE `Id` IN (13866, 13865); +INSERT INTO `conversation_line_template` (`Id`, `UiCameraID`, `ActorIdx`, `Flags`, `ChatType`, `VerifiedBuild`) VALUES +(13866, 0, 0, 0, 0, 63003), +(13865, 0, 0, 0, 0, 63003); + +-- Serverside AT smart ai +DELETE FROM `smart_scripts` WHERE (`entryorguid` = @ATID+0 AND `source_type` = 12); +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 +(@ATID+0, 12, 0, 0, '', 46, 0, 100, 0, 0, 0, 0, 0, 0, '', 143, 6209, 0, 0, 0, 0, 0, 0, NULL, 7, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 'On areatrigger enter - invoker: start conversation 6209'); + +DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId` = 28 AND `SourceGroup` = (@ATID+0) AND `SourceEntry` = 1); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(28, (@ATID+0), 1, 0, 0, 47, 0, 48171, 2, 0, '', 0, 0, 0, '', 'Only trigger areatrigger when quest 48171 is complete'); |