Scripts/Silithus: Fix Wind Stones gameobjects (fixes many quests in this zone). Closes #95

3 files changed, 88 insertions, 0 deletions

diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql
index 02b59566830..e045235d83f 100644
--- a/sql/scripts/world_scripts_full.sql
+++ b/sql/scripts/world_scripts_full.sql
@@ -99,6 +99,8 @@ UPDATE `gameobject_template` SET `ScriptName`='go_dragonflayer_cage' WHERE entry
 UPDATE `gameobject_template` SET `ScriptName`='go_black_cage' WHERE `entry`=195310;
 UPDATE `gameobject_template` SET `ScriptName`='go_massive_seaforium_charge' WHERE `entry`=190752;
 UPDATE `gameobject_template` SET `ScriptName`='go_harpoon_launcher' WHERE `entry` IN (192175,192176,192177);
+UPDATE `gameobject_template` SET `ScriptName`='go_wind_stone' WHERE `entry` IN (180456,180461,180466,180518,180529,180534,180539,180544,180549,180554,180559,180564);
+
 
 /* GUARD */
 UPDATE `creature_template` SET `ScriptName`='guard_generic' WHERE `entry` IN (68,1976,3218,3296,3502,4624,9460,11190,15184);
diff --git a/sql/updates/world/2011_07_05_03_world_go_script_names.sql b/sql/updates/world/2011_07_05_03_world_go_script_names.sql
new file mode 100644
index 00000000000..154b886c2f0
--- /dev/null
+++ b/sql/updates/world/2011_07_05_03_world_go_script_names.sql
@@ -0,0 +1 @@
+UPDATE `gameobject_template` SET `ScriptName`='go_wind_stone' WHERE `entry` IN (180456,180461,180466,180518,180529,180534,180539,180544,180549,180554,180559,180564);
diff --git a/sql/updates/world/2011_07_05_03_world_misc.sql b/sql/updates/world/2011_07_05_03_world_misc.sql
new file mode 100644
index 00000000000..ab7b6669f83
--- /dev/null
+++ b/sql/updates/world/2011_07_05_03_world_misc.sql
@@ -0,0 +1,85 @@
+DELETE FROM `gossip_menu` WHERE `entry` IN (6543,6540,6542) AND `text_id` IN (7771,7772,7773,7776);
+INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES
+(6540,7771),
+(6542,7772),
+(6543,7776);
+
+DELETE FROM `creature_text` WHERE `entry` IN (15209,15211,15212,15307,15206,15207,15208,15220,15203,15204,15205,15305);
+INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
+(15209,0,0, 'The Abyssal Council does not tolerate deceit! Feel our wrath, little human!',12,0,100,0,0,0, 'Crimson Templar - SAY_TEMPLAR_AGGRO'),
+(15211,0,0, 'The Abyssal Council does not tolerate deceit! Feel our wrath, little human!',12,0,100,0,0,0, 'Azure Templar - SAY_TEMPLAR_AGGRO'),
+(15212,0,0, 'The Abyssal Council does not tolerate deceit! Feel our wrath, little human!',12,0,100,0,0,0, 'Hoary Templar - SAY_TEMPLAR_AGGRO'),
+(15307,0,0, 'The Abyssal Council does not tolerate deceit! Feel our wrath, little human!',12,0,100,0,0,0, 'Earthen Templar - SAY_TEMPLAR_AGGRO'),
+(15206,0,0, 'What? Such a small, frail thing beckons me? This will not do unpunished!',12,0,100,0,0,0, 'The Duke of Cynders - SAY_DUKE_AGGRO'),
+(15207,0,0, 'What? Such a small, frail thing beckons me? This will not do unpunished!',12,0,100,0,0,0, 'The Duke of Fathoms - SAY_DUKE_AGGRO'),
+(15208,0,0, 'What? Such a small, frail thing beckons me? This will not do unpunished!',12,0,100,0,0,0, 'The Duke of Shards - SAY_DUKE_AGGRO'),
+(15220,0,0, 'What? Such a small, frail thing beckons me? This will not do unpunished!',12,0,100,0,0,0, 'The Duke of Zephyrs - SAY_DUKE_AGGRO'),
+(15203,0,0, 'Your treachery only speeds your doom. This world will fall to darkness!',14,0,100,0,0,0, 'Prince Skaldrenox - YELL_ROYAL_AGGRO'),
+(15204,0,0, 'Your treachery only speeds your doom. This world will fall to darkness!',14,0,100,0,0,0, 'High Marshal Whirlaxis - YELL_ROYAL_AGGRO'),
+(15205,0,0, 'Your treachery only speeds your doom. This world will fall to darkness!',14,0,100,0,0,0, 'Baron Kazum - YELL_ROYAL_AGGRO'),
+(15305,0,0, 'Your treachery only speeds your doom. This world will fall to darkness!',14,0,100,0,0,0, 'Lord Skwol - YELL_ROYAL_AGGRO');
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (24734,24744,24756,24758,24760,24763,24765,24768,24770,24772,24784,24786,24788,24789,24790);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`, `Comment`) VALUES
+(13,0,24734,0,18,0,180529,0,0, '', 'Summon Templar Random - Lesser Wind Stone'),
+(13,0,24734,0,18,0,180456,0,0, '', 'Summon Templar Random - Lesser Wind Stone'),
+(13,0,24734,0,18,0,180518,0,0, '', 'Summon Templar Random - Lesser Wind Stone'),
+(13,0,24734,0,18,0,180544,0,0, '', 'Summon Templar Random - Lesser Wind Stone'),
+(13,0,24734,0,18,0,180549,0,0, '', 'Summon Templar Random - Lesser Wind Stone'),
+(13,0,24734,0,18,0,180564,0,0, '', 'Summon Templar Random - Lesser Wind Stone'),
+(13,0,24744,0,18,0,180529,0,0, '', 'Summon Templar Fire - Lesser Wind Stone'),
+(13,0,24744,0,18,0,180456,0,0, '', 'Summon Templar Fire - Lesser Wind Stone'),
+(13,0,24744,0,18,0,180518,0,0, '', 'Summon Templar Fire - Lesser Wind Stone'),
+(13,0,24744,0,18,0,180544,0,0, '', 'Summon Templar Fire - Lesser Wind Stone'),
+(13,0,24744,0,18,0,180549,0,0, '', 'Summon Templar Fire - Lesser Wind Stone'),
+(13,0,24744,0,18,0,180564,0,0, '', 'Summon Templar Fire - Lesser Wind Stone'),
+(13,0,24756,0,18,0,180529,0,0, '', 'Summon Templar Air - Lesser Wind Stone'),
+(13,0,24756,0,18,0,180456,0,0, '', 'Summon Templar Air - Lesser Wind Stone'),
+(13,0,24756,0,18,0,180518,0,0, '', 'Summon Templar Air - Lesser Wind Stone'),
+(13,0,24756,0,18,0,180544,0,0, '', 'Summon Templar Air - Lesser Wind Stone'),
+(13,0,24756,0,18,0,180549,0,0, '', 'Summon Templar Air - Lesser Wind Stone'),
+(13,0,24756,0,18,0,180564,0,0, '', 'Summon Templar Air - Lesser Wind Stone'),
+(13,0,24758,0,18,0,180529,0,0, '', 'Summon Templar Earth - Lesser Wind Stone'),
+(13,0,24758,0,18,0,180456,0,0, '', 'Summon Templar Earth - Lesser Wind Stone'),
+(13,0,24758,0,18,0,180518,0,0, '', 'Summon Templar Earth - Lesser Wind Stone'),
+(13,0,24758,0,18,0,180544,0,0, '', 'Summon Templar Earth - Lesser Wind Stone'),
+(13,0,24758,0,18,0,180549,0,0, '', 'Summon Templar Earth - Lesser Wind Stone'),
+(13,0,24758,0,18,0,180564,0,0, '', 'Summon Templar Earth - Lesser Wind Stone'),
+(13,0,24760,0,18,0,180529,0,0, '', 'Summon Templar Water - Lesser Wind Stone'),
+(13,0,24760,0,18,0,180456,0,0, '', 'Summon Templar Water - Lesser Wind Stone'),
+(13,0,24760,0,18,0,180518,0,0, '', 'Summon Templar Water - Lesser Wind Stone'),
+(13,0,24760,0,18,0,180544,0,0, '', 'Summon Templar Water - Lesser Wind Stone'),
+(13,0,24760,0,18,0,180549,0,0, '', 'Summon Templar Water - Lesser Wind Stone'),
+(13,0,24760,0,18,0,180564,0,0, '', 'Summon Templar Water - Lesser Wind Stone'),
+--
+(13,0,24763,0,18,0,180534,0,0, '', 'Summon Duke Random - Wind Stone'),
+(13,0,24763,0,18,0,180461,0,0, '', 'Summon Duke Random - Wind Stone'),
+(13,0,24763,0,18,0,180554,0,0, '', 'Summon Duke Random - Wind Stone'),
+(13,0,24765,0,18,0,180534,0,0, '', 'Summon Duke Fire - Wind Stone'),
+(13,0,24765,0,18,0,180461,0,0, '', 'Summon Duke Fire - Wind Stone'),
+(13,0,24765,0,18,0,180554,0,0, '', 'Summon Duke Fire - Wind Stone'),
+(13,0,24768,0,18,0,180534,0,0, '', 'Summon Duke Air - Wind Stone'),
+(13,0,24768,0,18,0,180461,0,0, '', 'Summon Duke Air - Wind Stone'),
+(13,0,24768,0,18,0,180554,0,0, '', 'Summon Duke Air - Wind Stone'),
+(13,0,24770,0,18,0,180534,0,0, '', 'Summon Duke Earth - Wind Stone'),
+(13,0,24770,0,18,0,180461,0,0, '', 'Summon Duke Earth - Wind Stone'),
+(13,0,24770,0,18,0,180554,0,0, '', 'Summon Duke Earth - Wind Stone'),
+(13,0,24772,0,18,0,180534,0,0, '', 'Summon Duke Water - Wind Stone'),
+(13,0,24772,0,18,0,180461,0,0, '', 'Summon Duke Water - Wind Stone'),
+(13,0,24772,0,18,0,180554,0,0, '', 'Summon Duke Water - Wind Stone'),
+--
+(13,0,24784,0,18,0,180466,0,0, '', 'Summon Royal Random - Greater Wind Stone'),
+(13,0,24784,0,18,0,180539,0,0, '', 'Summon Royal Random - Greater Wind Stone'),
+(13,0,24784,0,18,0,180559,0,0, '', 'Summon Royal Random - Greater Wind Stone'),
+(13,0,24786,0,18,0,180466,0,0, '', 'Summon Royal Fire - Greater Wind Stone'),
+(13,0,24786,0,18,0,180539,0,0, '', 'Summon Royal Fire - Greater Wind Stone'),
+(13,0,24786,0,18,0,180559,0,0, '', 'Summon Royal Fire - Greater Wind Stone'),
+(13,0,24788,0,18,0,180466,0,0, '', 'Summon Royal Air - Greater Wind Stone'),
+(13,0,24788,0,18,0,180539,0,0, '', 'Summon Royal Air - Greater Wind Stone'),
+(13,0,24788,0,18,0,180559,0,0, '', 'Summon Royal Air - Greater Wind Stone'),
+(13,0,24789,0,18,0,180466,0,0, '', 'Summon Royal Earth - Greater Wind Stone'),
+(13,0,24789,0,18,0,180539,0,0, '', 'Summon Royal Earth - Greater Wind Stone'),
+(13,0,24789,0,18,0,180559,0,0, '', 'Summon Royal Earth - Greater Wind Stone'),
+(13,0,24790,0,18,0,180466,0,0, '', 'Summon Royal Water - Greater Wind Stone'),
+(13,0,24790,0,18,0,180539,0,0, '', 'Summon Royal Water - Greater Wind Stone'),
+(13,0,24790,0,18,0,180559,0,0, '', 'Summon Royal Water - Greater Wind Stone');