*Allow to spawn correct npc for defender/attacker in wintergrasp based on game event. Now only xxx Champion is spawned based on faction for test. Other npc and gameobjects requires DB support (now in db the defender is always horde and attacker always alliance, and the data of counterpart is missing)

*Fix defenders' portal (now only useable for horde)
*Display random model if the model id in creature table is one of those in creature_template table (in this case they should be 0 actually).

--HG--
branch : trunk

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);