From 7ea2510980d4b1c96f0341e9c8b9d5784862dc72 Mon Sep 17 00:00:00 2001 From: maanuel Date: Wed, 23 Dec 2009 02:30:44 -0300 Subject: Zul'drak: Support for quest The Amphitheater of Anguish: Magnataur!. --HG-- branch : trunk --- sql/FULL/world_script_texts.sql | 3 ++- sql/FULL/world_script_waypoints.sql | 10 ++++++++++ sql/FULL/world_scripts_full.sql | 1 + sql/updates/6742_world_script_texts.sql | 3 +++ sql/updates/6742_world_script_waypoints.sql | 9 +++++++++ sql/updates/6742_world_scriptnames.sql | 1 + 6 files changed, 26 insertions(+), 1 deletion(-) create mode 100644 sql/updates/6742_world_script_texts.sql create mode 100644 sql/updates/6742_world_script_waypoints.sql create mode 100644 sql/updates/6742_world_scriptnames.sql (limited to 'sql') diff --git a/sql/FULL/world_script_texts.sql b/sql/FULL/world_script_texts.sql index 82787a3bdfa..5f55f9b4a4d 100644 --- a/sql/FULL/world_script_texts.sql +++ b/sql/FULL/world_script_texts.sql @@ -1621,7 +1621,7 @@ INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1` (0,-1568022,'Da Amani gonna rule again!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12076,1,0,0,'nalorakk SAY_SLAY2'), (0,-1568023,'I... be waitin'' on da udda side....',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12077,1,0,0,'nalorakk SAY_DEATH'), --- -1 571 000 SHOLAZAR BASIN +-- -1 571 000 NORTHREND (28217,-1571000,'You save me! We thank you. We going to go back to village now. You come too... you can stay with us! Puppy-men kind of mean anyway. ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'npc_injured_rainspeaker_oracle SAY_END_IRO'), (28217,-1571001,'Let me know when you ready to go, okay?',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'npc_injured_rainspeaker_oracle SAY_QUEST_ACCEPT_IRO '), (28217,-1571002,'Home time!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'npc_injured_rainspeaker_oracle SAY_START_IRO'), @@ -1657,6 +1657,7 @@ INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1` (30020,-1571032,'Whisker! Where are you? Assist me!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,0,0,''), (30007,-1571033,'The champion of the Winterax trolls has challenged you, Treeofdoom! I hope you''re ready!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,''), (30007,-1571034,'Hailling from the distant mountains of Alterac, one of the fiercest competitors this arena has ever seen: KORRAK THE BLOODRAGER!!!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,13363,1,0,0,''), + (30007,-1571035,'The battle is about to begin! Am I reading this card right It... It''s the nefarious magnataur lord, STINKBEARD! Yes, folks, STINKBEARD! Chitchat dosen''t stand a chance!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,13363,1,0,0,''), -- -1 574 000 UTGARDE KEEP (23953,-1574000,'Your blood is mine!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,13221,1,0,0,'keleseth SAY_AGGRO'), diff --git a/sql/FULL/world_script_waypoints.sql b/sql/FULL/world_script_waypoints.sql index be2380d7d30..563fddb48d9 100644 --- a/sql/FULL/world_script_waypoints.sql +++ b/sql/FULL/world_script_waypoints.sql @@ -1779,3 +1779,13 @@ INSERT INTO `script_waypoint` VALUES (30023, 4, 5740.416, -2997.536, 277.263, 0, ''), (30023, 5, 5743.790, -3004.050, 273.570, 0, ''), (30023, 6, 5764.240, -2993.788, 272.944, 0, ''); + +DELETE FROM `script_waypoint` WHERE `entry`=30017; +INSERT INTO `script_waypoint` VALUES + (30017, 1, 5790.975, -2927.297, 286.277, 0, ''), + (30017, 2, 5803.003, -2952.998, 286.277, 0, ''), + (30017, 3, 5805.184, -2958.513, 282.899, 0, ''), + (30017, 4, 5807.038, -2961.449, 280.250, 0, ''), + (30017, 5, 5808.862, -2965.138, 277.089, 0, ''), + (30017, 6, 5811.703, -2970.821, 273.569, 0, ''), + (30017, 7, 5789.979, -2980.250, 273.584, 0, ''); diff --git a/sql/FULL/world_scripts_full.sql b/sql/FULL/world_scripts_full.sql index d4d45bb7dcc..e70a46eccca 100644 --- a/sql/FULL/world_scripts_full.sql +++ b/sql/FULL/world_scripts_full.sql @@ -1361,6 +1361,7 @@ UPDATE `creature_template` SET `ScriptName`='npc_orinoko_tuskbreaker' WHERE `ent UPDATE `creature_template` SET `ScriptName`='npc_korrak_bloodrager' WHERE `entry`=30023; UPDATE `creature_template` SET `ScriptName`='npc_yggdras' WHERE `entry`=30014; UPDATE `creature_template` SET `ScriptName`='npc_released_offspring_harkoa' WHERE `entry`=28526; +UPDATE `creature_template` SET `ScriptName`='npc_stinkbeard' WHERE `entry`=30017; /* ZUL'FARRAK */ UPDATE `creature_template` SET `ScriptName`='npc_sergeant_bly' WHERE `entry`=7604; diff --git a/sql/updates/6742_world_script_texts.sql b/sql/updates/6742_world_script_texts.sql new file mode 100644 index 00000000000..5bc4684c3c2 --- /dev/null +++ b/sql/updates/6742_world_script_texts.sql @@ -0,0 +1,3 @@ +DELETE FROM `script_texts` WHERE `entry`=-1571035; +INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1`,`content_loc2`,`content_loc3`,`content_loc4`,`content_loc5`,`content_loc6`,`content_loc7`,`content_loc8`,`sound`,`type`,`language`,`emote`,`comment`) VALUES + (30007,-1571035,'The battle is about to begin! Am I reading this card right It... It''s the nefarious magnataur lord, STINKBEARD! Yes, folks, STINKBEARD! Chitchat dosen''t stand a chance!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,13363,1,0,0,''); diff --git a/sql/updates/6742_world_script_waypoints.sql b/sql/updates/6742_world_script_waypoints.sql new file mode 100644 index 00000000000..306b6ca3552 --- /dev/null +++ b/sql/updates/6742_world_script_waypoints.sql @@ -0,0 +1,9 @@ +DELETE FROM `script_waypoint` WHERE `entry`=30017; +INSERT INTO `script_waypoint` VALUES + (30017, 1, 5790.975, -2927.297, 286.277, 0, ''), + (30017, 2, 5803.003, -2952.998, 286.277, 0, ''), + (30017, 3, 5805.184, -2958.513, 282.899, 0, ''), + (30017, 4, 5807.038, -2961.449, 280.250, 0, ''), + (30017, 5, 5808.862, -2965.138, 277.089, 0, ''), + (30017, 6, 5811.703, -2970.821, 273.569, 0, ''), + (30017, 7, 5789.979, -2980.250, 273.584, 0, ''); diff --git a/sql/updates/6742_world_scriptnames.sql b/sql/updates/6742_world_scriptnames.sql new file mode 100644 index 00000000000..60b96643ab1 --- /dev/null +++ b/sql/updates/6742_world_scriptnames.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `ScriptName`='npc_stinkbeard' WHERE `entry`=30017; -- cgit v1.2.3