aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorMuru <timurdelimin@gmail.com>2025-01-01 21:32:45 +0700
committerGitHub <noreply@github.com>2025-01-01 15:32:45 +0100
commit13b47c7780ae7f8b6454d38560af697e49648184 (patch)
tree56437b85eb434afa41b0def306836655bc6c32f4 /sql
parent151a50d2aa6e10efe7fc14e0bd22aaef9effa859 (diff)
Scripts/Spells: Implement warlock talent "Bilescourge Bombers" (#30560)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2025_01_01_00_world.sql15
1 files changed, 15 insertions, 0 deletions
diff --git a/sql/updates/world/master/2025_01_01_00_world.sql b/sql/updates/world/master/2025_01_01_00_world.sql
new file mode 100644
index 00000000000..90307e92803
--- /dev/null
+++ b/sql/updates/world/master/2025_01_01_00_world.sql
@@ -0,0 +1,15 @@
+DELETE FROM `spell_script_names` WHERE `spell_id` = 267211;
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(267211, 'spell_warl_bilescourge_bombers');
+
+DELETE FROM `areatrigger_create_properties` WHERE (`IsCustom`=0 AND `Id` IN (13045,15141));
+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
+(13045, 0, 17676, 0, 0, 0, 0, 0, 0, -1, 0, 0, NULL, 0, 5760, 4, 8, 8, 10, 10, 0.300000011920928955, 0.300000011920928955, 0, 0, 58238), -- Spell: 267211 (Bilescourge Bombers)
+(15141, 0, 19764, 0, 0, 0, 0, 0, 0, -1, 0, 0, NULL, 0, 5760, 0, 1, 1, 0, 0, 0, 0, 0, 0, 58238); -- Spell: 282248 (Bilescourge Bombers)
+
+DELETE FROM `areatrigger_template` WHERE (`IsCustom`=0 AND `Id` IN (17676, 19764));
+INSERT INTO `areatrigger_template` (`Id`, `IsCustom`, `Flags`, `VerifiedBuild`) VALUES
+(17676, 0, 0, 58238),
+(19764, 0, 0, 58238);
+
+UPDATE `areatrigger_create_properties` SET `ScriptName`='at_warl_bilescourge_bombers' WHERE `Id`=15141 AND `IsCustom`=0;