diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2025_01_24_01_world.sql | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/sql/updates/world/master/2025_01_24_01_world.sql b/sql/updates/world/master/2025_01_24_01_world.sql new file mode 100644 index 00000000000..60cb016042b --- /dev/null +++ b/sql/updates/world/master/2025_01_24_01_world.sql @@ -0,0 +1,27 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_summon_amberleaf_troublemaker'; + +DELETE FROM `spell_target_position` WHERE `ID` IN (274343, 114698, 102207); +INSERT INTO `spell_target_position` (`ID`, `EffectIndex`, `OrderIndex`, `MapID`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `VerifiedBuild`) VALUES +(274343, 0, 0, 1864, 3890.8254, -1248.8317, 115.37704, NULL, 58630), +(274343, 0, 1, 1864, 3891.2378, -1239.0885, 113.49874, NULL, 58630), +(274343, 0, 2, 1864, 3893.4775, -1259.2014, 113.48286, NULL, 58630), +(274343, 0, 3, 1864, 3895.1963, -1230.0226, 113.33343, NULL, 58630), +(274343, 0, 4, 1864, 3897.9368, -1266.1163, 113.27721, NULL, 58630), +(274343, 0, 5, 1864, 3901.125, -1222.0486, 113.06683, NULL, 58630), +(274343, 0, 6, 1864, 3904.9348, -1272.2205, 112.99738, NULL, 58630), + +(102207, 0, 0, 860, 1239.606, 3732.9072, 94.0207, NULL, 58630), +(102207, 0, 1, 860, 1226.9045, 3696.5312, 93.174614, NULL, 58630), +(102207, 0, 2, 860, 1216.5017, 3732.6094, 92.79299, NULL, 58630), +(102207, 0, 3, 860, 1223.4375, 3700.6067, 93.851036, NULL, 58630), + +(114698, 0, 0, 860, 1181.8802, 3446.1953, 102.41484, NULL, 58630), +(114698, 0, 1, 860, 1186.4254, 3446.265, 102.409, NULL, 58630), +(114698, 0, 2, 860, 1184.158, 3448.5808, 102.42686, NULL, 58630), +(114698, 0, 3, 860, 1181.8923, 3437.5764, 102.60773, NULL, 58630), +(114698, 0, 4, 860, 1186.5817, 3443.6372, 102.41002, NULL, 58630), +(114698, 0, 5, 860, 1188.6007, 3445.9895, 102.409, NULL, 58630), +(114698, 0, 6, 860, 1181.6615, 3451.1711, 102.8552, NULL, 58630), +(114698, 0, 7, 860, 1188.3351, 3443.039, 102.41056, NULL, 58630), +(114698, 0, 8, 860, 1187.9219, 3448.9497, 102.44913, NULL, 58630), +(114698, 0, 9, 860, 1187.408, 3440.7612, 102.5322, NULL, 58630); |