aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorMeji <alvaro.megias@outlook.com>2024-07-19 14:44:26 +0200
committerGitHub <noreply@github.com>2024-07-19 14:44:26 +0200
commit1426f58ff007eac2d9719b41f9189d82b733789e (patch)
tree62616bd2ae6e0c312cc1a403dd515ab4b78c1569 /sql
parent53f0f2e5da3e7e6a9e6fa926e2f51ac8b506caa9 (diff)
Core/AreaTriggers: Added ActionSet flags for serverside areatriggers (#30072)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2024_07_19_00_world.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_07_19_00_world.sql b/sql/updates/world/master/2024_07_19_00_world.sql
new file mode 100644
index 00000000000..5c637411122
--- /dev/null
+++ b/sql/updates/world/master/2024_07_19_00_world.sql
@@ -0,0 +1,9 @@
+ALTER TABLE `areatrigger_template`
+ ADD `ActionSetId` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `Flags`,
+ ADD `ActionSetFlags` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `ActionSetId`;
+
+UPDATE `areatrigger_template` SET `ActionSetFlags`=8 WHERE `Id`=48 AND `IsCustom`=1;
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=28 AND `SourceGroup`=48 AND `SourceEntry`=1;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(28,48,1,0,0,36,0,0,0,0,'',1,0,0,'','Only trigger areatrigger when player is dead');