aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorazazel <none@none>2010-09-16 13:14:14 +0600
committerazazel <none@none>2010-09-16 13:14:14 +0600
commit236356628ab04cd520e89551e95ac7583a9945bd (patch)
tree33400d7f4c9cbc01d6f7c9519d50489371a379fc /sql/updates
parent9739bea487bf9e5791379db51b56f58016fb2386 (diff)
Scripts/Quests:
* add support for quest 12634 Some Make Lemonade, Some Make Liquor (implement 51840 spell and Adventurous Dwarf AI, thanks akadabeer) * implement dummy effect for 49587 Seeds of Nature's Wrath spell (used in quest 12459 That Which Creates Can Also Destroy) * implement dummy effect for 19512 Apply Salve spell (used in quest 6124/6129 Curing the Sick) Scripts/Misc: some cleanup in chat log Core/Locales: fix issue when default locale for trinity_string strings was not used (thanks Aokromes for testing). --HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/9948_world_script_name.sql2
-rw-r--r--sql/updates/9948_world_script_texts.sql4
-rw-r--r--sql/updates/9948_world_spell_script_names.sql7
3 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/9948_world_script_name.sql b/sql/updates/9948_world_script_name.sql
new file mode 100644
index 00000000000..acd7f5ed785
--- /dev/null
+++ b/sql/updates/9948_world_script_name.sql
@@ -0,0 +1,2 @@
+-- Add script name to the Adventurous Dwarf
+UPDATE `creature_template` SET `npcflag`=1, `ScriptName`='npc_adventurous_dwarf' WHERE `entry`=28604;
diff --git a/sql/updates/9948_world_script_texts.sql b/sql/updates/9948_world_script_texts.sql
new file mode 100644
index 00000000000..8d52e0be8ec
--- /dev/null
+++ b/sql/updates/9948_world_script_texts.sql
@@ -0,0 +1,4 @@
+DELETE FROM `script_texts` WHERE `entry` IN (-1571043,-1571042);
+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
+(28604,-1571042,'Ouch! Watch where you''re tugging!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'adventurous dwarf SAY_DWARF_OUCH'),
+(28604,-1571043,'Glad I could help!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'adventurous dwarf SAY_DWARF_HELP');
diff --git a/sql/updates/9948_world_spell_script_names.sql b/sql/updates/9948_world_spell_script_names.sql
new file mode 100644
index 00000000000..38ccd4aa8b1
--- /dev/null
+++ b/sql/updates/9948_world_spell_script_names.sql
@@ -0,0 +1,7 @@
+DELETE FROM `spell_script_names` WHERE `spell_id`=51840 AND `ScriptName`='spell_q12634_despawn_fruit_tosser';
+DELETE FROM `spell_script_names` WHERE `spell_id`=49587 AND `ScriptName`='spell_q12459_seeds_of_natures_wrath';
+DELETE FROM `spell_script_names` WHERE `spell_id`=19512 AND `ScriptName`='spell_q6124_6129_apply_salve';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+(51840,'spell_q12634_despawn_fruit_tosser'),
+(49587,'spell_q12459_seeds_of_natures_wrath'),
+(19512,'spell_q6124_6129_apply_salve'); \ No newline at end of file