From f2fdcdf8f38e2da1e6d7d28e959fcf0165838b90 Mon Sep 17 00:00:00 2001 From: Shauren Date: Wed, 3 Nov 2010 16:44:34 +0100 Subject: Core/Scripts: Added enum for generic script texts, fixed one broken text Scripts/Icecrown Citadel: Blood-Queen Lana'Thel will no longer spawn for Blood Princes intro if they were already killed --HG-- branch : trunk --- sql/scripts/world_script_texts.sql | 4 ++-- sql/updates/10284_world_spell_script_names.sql | 1 - sql/updates/10349_world_script_texts.sql | 5 +++++ 3 files changed, 7 insertions(+), 3 deletions(-) create mode 100644 sql/updates/10349_world_script_texts.sql (limited to 'sql') diff --git a/sql/scripts/world_script_texts.sql b/sql/scripts/world_script_texts.sql index d8f9ebd8534..1bb9000b492 100644 --- a/sql/scripts/world_script_texts.sql +++ b/sql/scripts/world_script_texts.sql @@ -36,8 +36,8 @@ INSERT INTO `script_texts` (`npc_entry`,`entry`,`content_default`,`content_loc1` (0,-1000001,'%s goes into a killing frenzy!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,2,0,0,'EMOTE_GENERIC_FRENZY_KILL'), (0,-1000002,'%s goes into a frenzy!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,2,0,0,'EMOTE_GENERIC_FRENZY'), (0,-1000003,'%s becomes enraged!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,2,0,0,'EMOTE_GENERIC_ENRAGED'), - (0,-1000004,'goes into a berserker rage!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,2,0,0,'EMOTE_GENERIC_BERSERK'), - (0,-1000005,'UNUSED',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,'REUSE ME'), + (0,-1000004,'%s goes into a berserker rage!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,2,0,0,'EMOTE_GENERIC_BERSERK'), + (0,-1000005,'%s goes into a berserker rage!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,3,0,0,'EMOTE_GENERIC_BERSERK_RAID'), -- -- Normal text entries. Say/Yell/Whisper/Emote for any regular world object. diff --git a/sql/updates/10284_world_spell_script_names.sql b/sql/updates/10284_world_spell_script_names.sql index 08bc5a3826a..571fb59d3a5 100644 --- a/sql/updates/10284_world_spell_script_names.sql +++ b/sql/updates/10284_world_spell_script_names.sql @@ -22,4 +22,3 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES (72087,'spell_valanar_kinetic_bomb_knockback'), (73001,'spell_blood_council_shadow_prison'), (72999,'spell_blood_council_shadow_prison_damage'); - diff --git a/sql/updates/10349_world_script_texts.sql b/sql/updates/10349_world_script_texts.sql new file mode 100644 index 00000000000..c3928860fe7 --- /dev/null +++ b/sql/updates/10349_world_script_texts.sql @@ -0,0 +1,5 @@ +-- Fix broken string +UPDATE `script_texts` SET `content_default`='%s goes into a berserker rage!' WHERE `entry`=-1000004; + +-- Reuse unused +UPDATE `script_texts` SET `content_default`='%s goes into a berserker rage!',`type`=3,`comment`='EMOTE_GENERIC_BERSERK_RAID' WHERE `entry`=-1000005; -- cgit v1.2.3