diff options
| author | Traesh <Traesh@users.noreply.github.com> | 2025-09-06 23:05:02 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2025-09-06 23:05:02 +0200 |
| commit | b6b0eced74676816ae41d46ddb0ae7fa74068d3f (patch) | |
| tree | aa26a648e909c3ee0ce704866074caeb28818a2c /sql | |
| parent | 31beaf0ba1b4ba9742b86e29d0aeef4fbbaf4983 (diff) | |
Core/Spells: Implemented setting spell to cast on arrival from SPELL_EFFECT_JUMP_CHARGE in database (#30210)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2025_09_06_00_world.sql | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/sql/updates/world/master/2025_09_06_00_world.sql b/sql/updates/world/master/2025_09_06_00_world.sql new file mode 100644 index 00000000000..26981e387c3 --- /dev/null +++ b/sql/updates/world/master/2025_09_06_00_world.sql @@ -0,0 +1,24 @@ +ALTER TABLE `jump_charge_params` ADD COLUMN `triggerSpellId` INT(11) NULL AFTER `parabolicCurveId`; + +DELETE FROM `jump_charge_params` WHERE `id` IN (529,530,531,592,574,566,661,557,707,658,719,660,700,693,649,720,648,647,709,702); +INSERT INTO `jump_charge_params` (`id`,`speed`,`treatSpeedAsMoveTimeSeconds`,`jumpGravity`,`spellVisualId`,`progressCurveId`,`parabolicCurveId`,`triggerSpellId`) VALUES +(529, 0.5, 1, 47.8086, NULL, NULL, NULL, NULL), +(530, 0.5, 1, 47.8086, NULL, NULL, NULL, NULL), +(531, 0.15, 1, 526.293, NULL, NULL, NULL, NULL), +(592, 0.3, 1, 266.666, 109373, NULL, NULL, NULL), +(574, 0.04, 1, 5234.23, 108414, NULL, NULL, NULL), +(566, 1, 1, 39.3676, 108168, NULL, NULL, NULL), +(557, 1.25, 1, 19.2911, 109373, NULL, NULL, NULL), +(661, 0.75, 1, 70.9219, NULL, 392, NULL, NULL), +(707, 2, 1, 19.2911, NULL, NULL, NULL, NULL), +(658, 2, 1, 19.2911, 116541, NULL, NULL, 374075), +(719, 2, 1, 23.976, NULL, NULL, NULL, NULL), +(660, 1, 1, 23.9521, NULL, NULL, NULL, NULL), +(700, 0.75, 1, 73.6797, 119220, NULL, NULL, NULL), +(693, 1, 1, 6.96146, 93595, NULL, NULL, 382441), +(649, 0.75, 1, 42.5531, NULL, NULL, NULL, 369696), +(720, 5, 1, 3.19871, NULL, NULL, NULL, NULL), +(648, 0.35, 1, 189.37, NULL, NULL, NULL, 369602), +(647, 0.5, 1, 84.7985, NULL, NULL, NULL, 369424), +(709, 0.233, 1, 19.2911, NULL, NULL, NULL, NULL), +(702, 0.5, 1, 19.2911, NULL, NULL, NULL, NULL); |