From 76d0498aae83914b3321039e605e198abe383ac4 Mon Sep 17 00:00:00 2001 From: megamage Date: Sat, 30 May 2009 15:05:54 -0500 Subject: *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 --- sql/updates/3643_world_(wintergrasp).sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 sql/updates/3643_world_(wintergrasp).sql (limited to 'sql/updates') 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 -- cgit v1.2.3