*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

1 files changed, 13 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