diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/9948_world_script_name.sql | 2 | ||||
| -rw-r--r-- | sql/updates/9948_world_script_texts.sql | 4 | ||||
| -rw-r--r-- | sql/updates/9948_world_spell_script_names.sql | 7 |
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 |