From 6c0ff5717f14e90dfd92cf963c0805adae3c668b Mon Sep 17 00:00:00 2001 From: joschiwald Date: Mon, 21 Apr 2014 21:39:51 +0200 Subject: Scripts/Gnomeregan: moved Blastmaster Emi gossip to db --- sql/updates/world/2014_04_20_02_creature_text.sql | 4 ---- sql/updates/world/2014_04_20_02_world_creature_text.sql | 4 ++++ sql/updates/world/2014_04_20_03_gossip_menu_option.sql | 2 -- .../world/2014_04_20_03_world_gossip_menu_option.sql | 2 ++ sql/updates/world/2014_04_21_05_world_gossip_menu.sql | 13 +++++++++++++ 5 files changed, 19 insertions(+), 6 deletions(-) delete mode 100644 sql/updates/world/2014_04_20_02_creature_text.sql create mode 100644 sql/updates/world/2014_04_20_02_world_creature_text.sql delete mode 100644 sql/updates/world/2014_04_20_03_gossip_menu_option.sql create mode 100644 sql/updates/world/2014_04_20_03_world_gossip_menu_option.sql create mode 100644 sql/updates/world/2014_04_21_05_world_gossip_menu.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_04_20_02_creature_text.sql b/sql/updates/world/2014_04_20_02_creature_text.sql deleted file mode 100644 index 0a5a064a72d..00000000000 --- a/sql/updates/world/2014_04_20_02_creature_text.sql +++ /dev/null @@ -1,4 +0,0 @@ --- -DELETE FROM `creature_text` WHERE `entry`=17123; -INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `broadcasttextid`) VALUES -(17123,0,0,'Welcome, kind spirit. What has brought you to us?',12,0,100,0,0,0,'',13512); diff --git a/sql/updates/world/2014_04_20_02_world_creature_text.sql b/sql/updates/world/2014_04_20_02_world_creature_text.sql new file mode 100644 index 00000000000..0a5a064a72d --- /dev/null +++ b/sql/updates/world/2014_04_20_02_world_creature_text.sql @@ -0,0 +1,4 @@ +-- +DELETE FROM `creature_text` WHERE `entry`=17123; +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `broadcasttextid`) VALUES +(17123,0,0,'Welcome, kind spirit. What has brought you to us?',12,0,100,0,0,0,'',13512); diff --git a/sql/updates/world/2014_04_20_03_gossip_menu_option.sql b/sql/updates/world/2014_04_20_03_gossip_menu_option.sql deleted file mode 100644 index 7e6b7224173..00000000000 --- a/sql/updates/world/2014_04_20_03_gossip_menu_option.sql +++ /dev/null @@ -1,2 +0,0 @@ --- -UPDATE `gossip_menu_option` SET `option_text`='Chief Ashtotem, I have misplaced the token that you gave me.', `OptionBroadcastTextID`=22811 WHERE `menu_id`=8898 AND `id`=0; diff --git a/sql/updates/world/2014_04_20_03_world_gossip_menu_option.sql b/sql/updates/world/2014_04_20_03_world_gossip_menu_option.sql new file mode 100644 index 00000000000..7e6b7224173 --- /dev/null +++ b/sql/updates/world/2014_04_20_03_world_gossip_menu_option.sql @@ -0,0 +1,2 @@ +-- +UPDATE `gossip_menu_option` SET `option_text`='Chief Ashtotem, I have misplaced the token that you gave me.', `OptionBroadcastTextID`=22811 WHERE `menu_id`=8898 AND `id`=0; diff --git a/sql/updates/world/2014_04_21_05_world_gossip_menu.sql b/sql/updates/world/2014_04_21_05_world_gossip_menu.sql new file mode 100644 index 00000000000..9403c6f4de4 --- /dev/null +++ b/sql/updates/world/2014_04_21_05_world_gossip_menu.sql @@ -0,0 +1,13 @@ +UPDATE `creature_template` SET `gossip_menu_id`=1080, `speed_walk`=1, `speed_run`=1.142857, `rangeattacktime`=2000 WHERE `entry`=7998; + +DELETE FROM `gossip_menu` WHERE `entry`=1080; +INSERT INTO `gossip_menu` (`entry`, `text_id`) VALUES +(1080, 1693); -- 7998 + +DELETE FROM `gossip_menu_option` WHERE `menu_id`=1080; +INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `OptionBroadcastTextID`, `option_id`, `npc_option_npcflag`, `box_coded`, `box_money`, `box_text`, `BoxBroadcastTextID`) VALUES +(1080, 0, 0, 'I am ready to begin.', 4084, 1, 1, 0, 0, '', 0); -- 7998 + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=1080; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(15,1080,0,0,0,13,1,1,0,0,0,0,0,'','Show gossip option only if Blastmaster Emi Encounter is not started'); -- cgit v1.2.3