aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorSupabad <supabad.trinity@gmail.com>2011-04-05 15:15:15 +0200
committerleak <leakzx@googlemail.com>2011-04-06 11:35:50 +0200
commit3e22e88f4e0a56f191121d878fcae53f95b371b7 (patch)
tree61b094ad041446a8281892b4d78ade963d68088a /sql/updates
parentdc8fd3cbc3740f226862045f2f23c3da8320b3bf (diff)
Scripts/Nagrand: Add core support for quest 9923,9924,9955
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/2011_04_03_12_world_script_text.sql5
-rw-r--r--sql/updates/world/2011_04_03_12_world_scriptname.sql2
2 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/2011_04_03_12_world_script_text.sql b/sql/updates/world/2011_04_03_12_world_script_text.sql
new file mode 100644
index 00000000000..a0755059223
--- /dev/null
+++ b/sql/updates/world/2011_04_03_12_world_script_text.sql
@@ -0,0 +1,5 @@
+DELETE FROM `script_texts` WHERE `npc_entry` IN (18445,20812,18369);
+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
+(18445,-1800071, 'Thanks, $C! I''m sure my dad will reward you greatly! Bye!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,NULL),
+(20812,-1800072, 'This is the last time I get caught!I promise! Bye!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,NULL),
+(18369,-1800073, 'Thank you for saving me again!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,NULL);
diff --git a/sql/updates/world/2011_04_03_12_world_scriptname.sql b/sql/updates/world/2011_04_03_12_world_scriptname.sql
new file mode 100644
index 00000000000..69b8d5b7120
--- /dev/null
+++ b/sql/updates/world/2011_04_03_12_world_scriptname.sql
@@ -0,0 +1,2 @@
+UPDATE `creature_template` SET `ScriptName` = 'npc_corki' WHERE `entry` IN (18445,20812,18369);
+UPDATE `gameobject_template` SET `ScriptName` = 'go_corkis_prison' WHERE `entry` IN (182349,182350,182521);