diff options
| author | Naddley <64811442+Naddley@users.noreply.github.com> | 2024-05-05 05:35:33 +0200 |
|---|---|---|
| committer | ModoX <moardox@gmail.com> | 2024-05-05 05:59:39 +0200 |
| commit | ee6ba02a77c7ab1327fe114db180657a0f0ca64b (patch) | |
| tree | 3380981ca3a96895024509da4d8d83ed64b548d2 /sql | |
| parent | 62156f57b285ee252c2c4143236a3df95f219ca5 (diff) | |
Scripts/ScarletHalls: Reverted Call Reinforcements to TARGET_DEST_DB
* 62156f57b285ee252c2c4143236a3df95f219ca5 followup
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2024_05_05_00_world.sql | 10 |
1 files changed, 7 insertions, 3 deletions
diff --git a/sql/updates/world/master/2024_05_05_00_world.sql b/sql/updates/world/master/2024_05_05_00_world.sql index 1d11beb06b5..677113b7043 100644 --- a/sql/updates/world/master/2024_05_05_00_world.sql +++ b/sql/updates/world/master/2024_05_05_00_world.sql @@ -21,16 +21,20 @@ INSERT INTO `serverside_spell_effect` (`SpellID`, `EffectIndex`, `DifficultyID`, (128930, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0); -- Script Names -DELETE FROM `spell_script_names` WHERE `spell_id` IN (111216, 111394, 112953, 113969, 111755, 111756, 128930); +DELETE FROM `spell_script_names` WHERE `spell_id` IN (111216, 111394, 112953, 113959, 111755, 111756, 128930); INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (111216, 'spell_harlan_blades_of_light'), (111394, 'spell_harlan_blades_of_light_selector'), (112953, 'spell_harlan_leave_vehicle'), (113959, 'spell_scarlet_defender_heavy_armor'), -(111755, 'spell_call_reinforcements_right'), -(111756, 'spell_call_reinforcements_left'), (128930, 'spell_eject_spirits_of_redemption'); +-- Spelltarget Pos. +DELETE FROM `spell_target_position` WHERE `ID` IN (111755, 111756); +INSERT INTO `spell_target_position` (`ID`, `EffectIndex`, `MapID`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `VerifiedBuild`) VALUES +(111755, 0, 1001, 1182.020, 447.325, 11.98933, NULL, 0), +(111756, 0, 1001, 1181.833, 440.649, 11.98763, NULL, 0); + -- Conditions DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId` = 13) AND (`SourceEntry` IN (111394)); INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `Comment`) VALUES |