diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/3643_world_(wintergrasp).sql | 13 | ||||
| -rw-r--r-- | sql/world_spell_full.sql | 16 |
2 files changed, 29 insertions, 0 deletions
diff --git a/sql/updates/3643_world_(wintergrasp).sql b/sql/updates/3643_world_(wintergrasp).sql new file mode 100644 index 00000000000..5d59423d2bd --- /dev/null +++ b/sql/updates/3643_world_(wintergrasp).sql @@ -0,0 +1,13 @@ +DELETE FROM `spell_script_target` WHERE entry IN +(54643); +INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES +(54643,1,23472); + +DELETE FROM `game_event` WHERE `entry` IN (50,51); +INSERT INTO `game_event` (`entry`, `description`, `world_event`) VALUES +(50, 'Wintergrasp Alliance Defence', 5), +(51, 'Wintergrasp Horde Defence', 5); + +DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (54643); +INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES +( 54643,-54643, 2, 'Wintergrasp Defender Teleport');
\ No newline at end of file diff --git a/sql/world_spell_full.sql b/sql/world_spell_full.sql index 7da0d4ddd0f..284072608ba 100644 --- a/sql/world_spell_full.sql +++ b/sql/world_spell_full.sql @@ -1707,6 +1707,13 @@ spell8 = VALUES(spell8); -- -------- -- WINTERGRASP -- -------- + +DELETE FROM `game_event` WHERE `entry` IN (50,51); +INSERT INTO `game_event` (`entry`, `description`, `world_event`) VALUES +(50, 'Wintergrasp Alliance Defence', 5), +(51, 'Wintergrasp Horde Defence', 5); + +-- Build Vehicles DELETE FROM `spell_script_target` WHERE entry IN (56575,56661,56663,56665,56667,56669,61408); INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES @@ -1718,6 +1725,15 @@ INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES (56669, 1, 27852), (61408, 1, 27852); +-- Defender's Portal +DELETE FROM `spell_script_target` WHERE entry IN +(54643); +INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES +(54643,1,23472); +DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (54643); +INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES +( 54643,-54643, 2, 'Wintergrasp Defender Teleport'); + update creature_template set maxhealth = 30000, minhealth = 30000, speed = 2, spell1=50025, spell2=50989, VehicleId = 36 where entry = 27881; update creature_template set maxhealth = 50000, minhealth = 50000, speed = 1.6, spell1=50896, spell2=50652, VehicleId = 106 where entry = 28094; update creature_template set maxhealth = 75000, minhealth = 75000, speed = 1, spell1=51678, VehicleId = 117 where entry IN (28312,32627); |