aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorAnubisss <none@none>2009-05-20 23:08:46 +0200
committerAnubisss <none@none>2009-05-20 23:08:46 +0200
commit425bb9fb55aec1c8d64cd6798b9a8f253d16e99a (patch)
tree79164a6ae89e5411e6a762a8c2644b5f46bea706 /sql
parenta78ade9503138aff02352bdb782ee62203a8f742 (diff)
*Merge SD2.
*r978: Added few basic parts for ramparts instance script to be used in further development. *r979: Added support for quest 9686. - Skip this patch. Its already scripted. *r980: Added gossip to play movie cutscene after quest 12499/12500 rewarded. *r981: Clean up some code and correcting icon for gossip items. - Just use enums. *r982: Added support for quest 938 (consider it a test for similar quests) --HG-- branch : trunk
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/3433_world.sql10
-rw-r--r--sql/world_scripts_full.sql6
2 files changed, 16 insertions, 0 deletions
diff --git a/sql/updates/3433_world.sql b/sql/updates/3433_world.sql
new file mode 100644
index 00000000000..0d5b0eeda61
--- /dev/null
+++ b/sql/updates/3433_world.sql
@@ -0,0 +1,10 @@
+UPDATE `instance_template` SET `script` = 'instance_ramparts' WHERE `map` = 543;
+
+UPDATE `creature_template` SET `ScriptName` = 'npc_alexstrasza_wr_gate' WHERE `entry` = 31333;
+
+UPDATE `creature_template` SET `ScriptName` = 'npc_mist' WHERE `entry` = 3568;
+
+DELETE FROM `script_texts` WHERE `entry` IN (-1000411, -1000412);
+INSERT INTO script_texts (entry,content_default,sound,type,language,emote,comment) VALUES
+(-1000411, 'Mist! I feared I would never see you again! Yes, I am well, do not worry for me. You must rest and recover your health.', 0, 0, 7, 0, 'mist SAY_AT_HOME'),
+(-1000412, 'growls in acknowledgement before straightening and making her way off into the forest.', 0, 2, 0, 0, 'mist EMOTE_AT_HOME');
diff --git a/sql/world_scripts_full.sql b/sql/world_scripts_full.sql
index ce502d37bf9..b8423969e7d 100644
--- a/sql/world_scripts_full.sql
+++ b/sql/world_scripts_full.sql
@@ -403,6 +403,9 @@ UPDATE `gameobject_template` SET `ScriptName`='go_defias_cannon' WHERE `entry`=1
UPDATE `gameobject_template` SET `ScriptName`='go_door_lever_dm' WHERE `entry`=101833;
UPDATE `gameobject_template` SET `ScriptName`='go_main_chambers_access_panel' WHERE `entry` IN (184125,184126);
+/* DRAGONBLIGHT */
+UPDATE `creature_template` SET `ScriptName`='npc_alexstrasza_wr_gate' WHERE `entry`=31333;
+
/* DEADWIND PASS */
/* DESOLACE */
@@ -479,6 +482,8 @@ UPDATE `creature_template` SET `ScriptName`='mob_broggok_poisoncloud' WHERE `ent
UPDATE `creature_template` SET `ScriptName`='mob_shadowmoon_channeler' WHERE `entry`=17653;
/* HELLFIRE RAMPARTS */
+UPDATE `instance_template` SET `script`='instance_ramparts' WHERE `map`=543;
+
/* Vazruden,Omor the Unscarred,Watchkeeper Gargolmar */
UPDATE `creature_template` SET `ScriptName`='boss_omor_the_unscarred' WHERE `entry`=17308;
UPDATE `creature_template` SET `ScriptName`='boss_watchkeeper_gargolmar' WHERE `entry`=17306;
@@ -848,6 +853,7 @@ UPDATE `creature_template` SET `ScriptName`='npc_stone_watcher_of_norgannon' WHE
UPDATE `creature_template` SET `ScriptName`='npc_OOX17' WHERE `entry`=7784;
/* TELDRASSIL */
+UPDATE `creature_template` SET `ScriptName`='npc_mist' WHERE `entry`=3568;
/* TEMPEST KEEP */