aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorWyrserth <43747507+Wyrserth@users.noreply.github.com>2019-06-05 23:01:38 +0200
committerccrs <ccrs@users.noreply.github.com>2019-06-05 23:01:38 +0200
commit41931c069d442c0e15a344023d2bbf8c1b0820d9 (patch)
tree261b9223e7c44407dfd0e578b90e56819d7f41aa /sql
parentfb28cee6eeb97b722ebce54a444de9f13717752c (diff)
Script/ZulGurub: implement several RP texts (#23358)
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/3.3.5/9999_99_99_99_world.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/9999_99_99_99_world.sql b/sql/updates/world/3.3.5/9999_99_99_99_world.sql
new file mode 100644
index 00000000000..e17fc33b1e7
--- /dev/null
+++ b/sql/updates/world/3.3.5/9999_99_99_99_world.sql
@@ -0,0 +1,10 @@
+UPDATE `creature_text` SET `TextRange`=3 WHERE `CreatureID`=14834 AND `GroupId` IN (2, 3);
+DELETE FROM `creature_text` WHERE `CreatureID`=14834 AND `GroupId`=4;
+INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
+(14834, 4, 0, "Your callous disregard for the sovereign might of the Gurubashi Empire has been noted. The inhabitants of Zul'Gurub have been alerted to your presence.", 16, 0, 100, 0, 0, 0, 10550, 3, "hakkar SAY_ENTRANCE");
+
+DELETE FROM `areatrigger_scripts` WHERE `entry` IN (3957, 3958, 3960);
+INSERT INTO `areatrigger_scripts` (`entry`, `ScriptName`) VALUES
+(3957, 'at_zulgurub_entrance'),
+(3958, 'at_zulgurub_entrance'),
+(3960, 'at_zulgurub_entrance');