From e53baa7d908801b666fe987c03ebe29b4e5988cf Mon Sep 17 00:00:00 2001
From: Aokromes <aokromes@gmail.com>
Date: Fri, 15 Jan 2016 10:01:10 +0100
Subject: DB/Misc: Rename few files

---
 sql/updates/world/2015_11_09_02_world335.sql  |  7 -------
 sql/updates/world/2015_11_09_02_world_335.sql |  7 +++++++
 sql/updates/world/2015_12_16_02_world335.sql  |  7 -------
 sql/updates/world/2015_12_16_02_world_335.sql |  7 +++++++
 sql/updates/world/2016_01_02_00_world335.sql  | 20 --------------------
 sql/updates/world/2016_01_02_00_world_335.sql | 20 ++++++++++++++++++++
 sql/updates/world/2016_01_10_05_world335.sql  | 21 ---------------------
 sql/updates/world/2016_01_10_05_world_335.sql | 21 +++++++++++++++++++++
 sql/updates/world/2016_01_12_01_world335.sql  |  5 -----
 sql/updates/world/2016_01_12_01_world_335.sql |  5 +++++
 sql/updates/world/2016_01_12_02_world335.sql  |  4 ----
 sql/updates/world/2016_01_12_02_world_335.sql |  4 ++++
 12 files changed, 64 insertions(+), 64 deletions(-)
 delete mode 100644 sql/updates/world/2015_11_09_02_world335.sql
 create mode 100644 sql/updates/world/2015_11_09_02_world_335.sql
 delete mode 100644 sql/updates/world/2015_12_16_02_world335.sql
 create mode 100644 sql/updates/world/2015_12_16_02_world_335.sql
 delete mode 100644 sql/updates/world/2016_01_02_00_world335.sql
 create mode 100644 sql/updates/world/2016_01_02_00_world_335.sql
 delete mode 100644 sql/updates/world/2016_01_10_05_world335.sql
 create mode 100644 sql/updates/world/2016_01_10_05_world_335.sql
 delete mode 100644 sql/updates/world/2016_01_12_01_world335.sql
 create mode 100644 sql/updates/world/2016_01_12_01_world_335.sql
 delete mode 100644 sql/updates/world/2016_01_12_02_world335.sql
 create mode 100644 sql/updates/world/2016_01_12_02_world_335.sql

(limited to 'sql/updates')

diff --git a/sql/updates/world/2015_11_09_02_world335.sql b/sql/updates/world/2015_11_09_02_world335.sql
deleted file mode 100644
index 84c0fd423ad..00000000000
--- a/sql/updates/world/2015_11_09_02_world335.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `creature_template_addon` WHERE `entry` in(46891,46894,46901,46908);
-
-DELETE FROM `creature` WHERE `guid` in(144891,144867,144862,144861,144859,144929,144931,144934,144942,144946,144948,144950,145010);
-
-DELETE FROM `game_event_creature` WHERE `guid` in(144891,144867,144862,144861,144859,144929,144931,144934,144942,144946,144948,144950,145010);
-
-DELETE FROM `game_event_gameobject` WHERE `guid` in (78509,78510,78511,78655,78656,78657,78658,78659,78660,78661,78662,78663,78664,78665,78666,78667,78735,78736,78737,78738,78739,78740,78741,78742,78743,78744,78745,78746,78747,78748,78749,78750,78751,78752,78752,78753,78754);
diff --git a/sql/updates/world/2015_11_09_02_world_335.sql b/sql/updates/world/2015_11_09_02_world_335.sql
new file mode 100644
index 00000000000..84c0fd423ad
--- /dev/null
+++ b/sql/updates/world/2015_11_09_02_world_335.sql
@@ -0,0 +1,7 @@
+DELETE FROM `creature_template_addon` WHERE `entry` in(46891,46894,46901,46908);
+
+DELETE FROM `creature` WHERE `guid` in(144891,144867,144862,144861,144859,144929,144931,144934,144942,144946,144948,144950,145010);
+
+DELETE FROM `game_event_creature` WHERE `guid` in(144891,144867,144862,144861,144859,144929,144931,144934,144942,144946,144948,144950,145010);
+
+DELETE FROM `game_event_gameobject` WHERE `guid` in (78509,78510,78511,78655,78656,78657,78658,78659,78660,78661,78662,78663,78664,78665,78666,78667,78735,78736,78737,78738,78739,78740,78741,78742,78743,78744,78745,78746,78747,78748,78749,78750,78751,78752,78752,78753,78754);
diff --git a/sql/updates/world/2015_12_16_02_world335.sql b/sql/updates/world/2015_12_16_02_world335.sql
deleted file mode 100644
index 20c1ac94a39..00000000000
--- a/sql/updates/world/2015_12_16_02_world335.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-  DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` in(19,20) AND `SourceEntry`=254;
-
-  INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
-  (19, 0, 254, 0, 0, 29, 0, 314, 200, 0, 1, 0, 0, '', 'Show quest \'Digging Through the Dirt\' only if no Eliza nearby'),
-  (20, 0, 254, 0, 0, 29, 0, 314, 200, 0, 1, 0, 0, '', 'Show quest \'Digging Through the Dirt\' only if no Eliza nearby'),
-  (19, 0, 254, 0, 0, 8, 0, 253, 0, 0, 1, 0, 0, '', 'Show quest \'Digging Through the Dirt\' only if quest \'Bride of the Embalmer\' is not rewarded'),
-  (19, 0, 254, 0, 0, 28, 0, 253, 0, 0, 1, 0, 0, '', 'Show quest \'Digging Through the Dirt\' only if quest \'Bride of the Embalmer\' is not completed');
diff --git a/sql/updates/world/2015_12_16_02_world_335.sql b/sql/updates/world/2015_12_16_02_world_335.sql
new file mode 100644
index 00000000000..20c1ac94a39
--- /dev/null
+++ b/sql/updates/world/2015_12_16_02_world_335.sql
@@ -0,0 +1,7 @@
+  DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` in(19,20) AND `SourceEntry`=254;
+
+  INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+  (19, 0, 254, 0, 0, 29, 0, 314, 200, 0, 1, 0, 0, '', 'Show quest \'Digging Through the Dirt\' only if no Eliza nearby'),
+  (20, 0, 254, 0, 0, 29, 0, 314, 200, 0, 1, 0, 0, '', 'Show quest \'Digging Through the Dirt\' only if no Eliza nearby'),
+  (19, 0, 254, 0, 0, 8, 0, 253, 0, 0, 1, 0, 0, '', 'Show quest \'Digging Through the Dirt\' only if quest \'Bride of the Embalmer\' is not rewarded'),
+  (19, 0, 254, 0, 0, 28, 0, 253, 0, 0, 1, 0, 0, '', 'Show quest \'Digging Through the Dirt\' only if quest \'Bride of the Embalmer\' is not completed');
diff --git a/sql/updates/world/2016_01_02_00_world335.sql b/sql/updates/world/2016_01_02_00_world335.sql
deleted file mode 100644
index b46a41bc6e9..00000000000
--- a/sql/updates/world/2016_01_02_00_world335.sql
+++ /dev/null
@@ -1,20 +0,0 @@
--- Move EPL tower gryphon master to SAI
-DELETE FROM `gossip_menu_option` WHERE menu_id = 7379;
-INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `OptionBroadcastTextID`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`, `BoxBroadcastTextID`) VALUES
-(7379, 0, 0, 'Take me to Northpass Tower.',13562,1,1,0,0,0,0,NULL,0),
-(7379, 1, 0, 'Take me to Eastwall Tower.',13563,1,1,0,0,0,0,NULL,0),
-(7379, 2, 0, 'Take me to Crown Guard Tower.',13564,1,1,0,0,0,0,NULL,0);
-
--- Creating a new SmartAI script for [Creature] ENTRY 17209 (name: William Kielar)
-
--- Table creature_template
-UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = 17209;
-
--- Table smart_scripts
-DELETE FROM `smart_scripts` WHERE (source_type = 0 AND entryorguid = 17209);
-INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
-(17209, 0, 0, 3, 62, 0, 100, 0, 7379, 0, 0, 0, 52, 494, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'William Kielar - On Gossip Option 0 Selected - Activate Taxi Path 494'),
-(17209, 0, 1, 3, 62, 0, 100, 0, 7379, 1, 0, 0, 52, 495, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'William Kielar - On Gossip Option 1 Selected - Activate Taxi Path 495'),
-(17209, 0, 2, 3, 62, 0, 100, 0, 7379, 2, 0, 0, 52, 496, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'William Kielar - On Gossip Option 2 Selected - Activate Taxi Path 496'),
-(17209, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'William Kielar - On Gossip Option 0 Selected - Close Gossip');
-
diff --git a/sql/updates/world/2016_01_02_00_world_335.sql b/sql/updates/world/2016_01_02_00_world_335.sql
new file mode 100644
index 00000000000..b46a41bc6e9
--- /dev/null
+++ b/sql/updates/world/2016_01_02_00_world_335.sql
@@ -0,0 +1,20 @@
+-- Move EPL tower gryphon master to SAI
+DELETE FROM `gossip_menu_option` WHERE menu_id = 7379;
+INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `OptionBroadcastTextID`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`, `BoxBroadcastTextID`) VALUES
+(7379, 0, 0, 'Take me to Northpass Tower.',13562,1,1,0,0,0,0,NULL,0),
+(7379, 1, 0, 'Take me to Eastwall Tower.',13563,1,1,0,0,0,0,NULL,0),
+(7379, 2, 0, 'Take me to Crown Guard Tower.',13564,1,1,0,0,0,0,NULL,0);
+
+-- Creating a new SmartAI script for [Creature] ENTRY 17209 (name: William Kielar)
+
+-- Table creature_template
+UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = 17209;
+
+-- Table smart_scripts
+DELETE FROM `smart_scripts` WHERE (source_type = 0 AND entryorguid = 17209);
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
+(17209, 0, 0, 3, 62, 0, 100, 0, 7379, 0, 0, 0, 52, 494, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'William Kielar - On Gossip Option 0 Selected - Activate Taxi Path 494'),
+(17209, 0, 1, 3, 62, 0, 100, 0, 7379, 1, 0, 0, 52, 495, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'William Kielar - On Gossip Option 1 Selected - Activate Taxi Path 495'),
+(17209, 0, 2, 3, 62, 0, 100, 0, 7379, 2, 0, 0, 52, 496, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'William Kielar - On Gossip Option 2 Selected - Activate Taxi Path 496'),
+(17209, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'William Kielar - On Gossip Option 0 Selected - Close Gossip');
+
diff --git a/sql/updates/world/2016_01_10_05_world335.sql b/sql/updates/world/2016_01_10_05_world335.sql
deleted file mode 100644
index 7fb021cc9dd..00000000000
--- a/sql/updates/world/2016_01_10_05_world335.sql
+++ /dev/null
@@ -1,21 +0,0 @@
-DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (5066,5090,5091,5093,5094,5095,10373,10374);
-
-INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
-(19, 0, 5066, 0, 0, 14, 0, 5092, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
-(20, 0, 5066, 0, 0, 14, 0, 5092, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
-(19, 0, 5090, 0, 0, 14, 0, 5092, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
-(20, 0, 5090, 0, 0, 14, 0, 5092, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
-(19, 0, 5091, 0, 0, 14, 0, 5092, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
-(20, 0, 5091, 0, 0, 14, 0, 5092, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
-(19, 0, 5093, 0, 0, 14, 0, 5096, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
-(20, 0, 5093, 0, 0, 14, 0, 5096, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
-(19, 0, 5094, 0, 0, 14, 0, 5096, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
-(20, 0, 5094, 0, 0, 14, 0, 5096, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
-(19, 0, 5095, 0, 0, 14, 0, 5096, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
-(20, 0, 5095, 0, 0, 14, 0, 5096, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
-(19, 0, 10373, 0, 0, 14, 0, 5092, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
-(20, 0, 10373, 0, 0, 14, 0, 5092, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
-(19, 0, 10374, 0, 0, 14, 0, 5096, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
-(20, 0, 10374, 0, 0, 14, 0, 5096, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)');
-
-UPDATE `quest_template_addon` SET `NextQuestID`=0 WHERE  `ID` IN (5066,5090,5091,5093,5094,5095,10373,10374);
diff --git a/sql/updates/world/2016_01_10_05_world_335.sql b/sql/updates/world/2016_01_10_05_world_335.sql
new file mode 100644
index 00000000000..7fb021cc9dd
--- /dev/null
+++ b/sql/updates/world/2016_01_10_05_world_335.sql
@@ -0,0 +1,21 @@
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` IN (19,20) AND `SourceEntry` IN (5066,5090,5091,5093,5094,5095,10373,10374);
+
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES 
+(19, 0, 5066, 0, 0, 14, 0, 5092, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
+(20, 0, 5066, 0, 0, 14, 0, 5092, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
+(19, 0, 5090, 0, 0, 14, 0, 5092, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
+(20, 0, 5090, 0, 0, 14, 0, 5092, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
+(19, 0, 5091, 0, 0, 14, 0, 5092, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
+(20, 0, 5091, 0, 0, 14, 0, 5092, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
+(19, 0, 5093, 0, 0, 14, 0, 5096, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
+(20, 0, 5093, 0, 0, 14, 0, 5096, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
+(19, 0, 5094, 0, 0, 14, 0, 5096, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
+(20, 0, 5094, 0, 0, 14, 0, 5096, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
+(19, 0, 5095, 0, 0, 14, 0, 5096, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
+(20, 0, 5095, 0, 0, 14, 0, 5096, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
+(19, 0, 10373, 0, 0, 14, 0, 5092, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
+(20, 0, 10373, 0, 0, 14, 0, 5092, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
+(19, 0, 10374, 0, 0, 14, 0, 5096, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)'),
+(20, 0, 10374, 0, 0, 14, 0, 5096, 0, 0, 0, 0, 0, '', 'Call to Arms: The Plaguelands (Breadcrumb)');
+
+UPDATE `quest_template_addon` SET `NextQuestID`=0 WHERE  `ID` IN (5066,5090,5091,5093,5094,5095,10373,10374);
diff --git a/sql/updates/world/2016_01_12_01_world335.sql b/sql/updates/world/2016_01_12_01_world335.sql
deleted file mode 100644
index c3206e70ac4..00000000000
--- a/sql/updates/world/2016_01_12_01_world335.sql
+++ /dev/null
@@ -1,5 +0,0 @@
--- Insert missing gossip_menu_option 21213 for Sorcerer Ashcrombe and 21214 for Deathstalker Adamant:
-DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (21213,21214) AND `OptionBroadcastTextID`= 2802;
-INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`OptionBroadcastTextID`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`box_coded`,`box_money`,`box_text`,`BoxBroadcastTextID`) VALUES
-(21213,0,0,'Please unlock the courtyard door.',2802,1,1,0,0,0,0,'',0),
-(21214,0,0,'Please unlock the courtyard door.',2802,1,1,0,0,0,0,'',0);
diff --git a/sql/updates/world/2016_01_12_01_world_335.sql b/sql/updates/world/2016_01_12_01_world_335.sql
new file mode 100644
index 00000000000..c3206e70ac4
--- /dev/null
+++ b/sql/updates/world/2016_01_12_01_world_335.sql
@@ -0,0 +1,5 @@
+-- Insert missing gossip_menu_option 21213 for Sorcerer Ashcrombe and 21214 for Deathstalker Adamant:
+DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (21213,21214) AND `OptionBroadcastTextID`= 2802;
+INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`OptionBroadcastTextID`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`box_coded`,`box_money`,`box_text`,`BoxBroadcastTextID`) VALUES
+(21213,0,0,'Please unlock the courtyard door.',2802,1,1,0,0,0,0,'',0),
+(21214,0,0,'Please unlock the courtyard door.',2802,1,1,0,0,0,0,'',0);
diff --git a/sql/updates/world/2016_01_12_02_world335.sql b/sql/updates/world/2016_01_12_02_world335.sql
deleted file mode 100644
index 354d0bc129d..00000000000
--- a/sql/updates/world/2016_01_12_02_world335.sql
+++ /dev/null
@@ -1,4 +0,0 @@
--- Insert missing gossip_menu_option 3801 for Myranda the Hag:
-DELETE FROM `gossip_menu_option` WHERE `menu_id`= 3801 AND `OptionBroadcastTextID`= 7306;
-INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`OptionBroadcastTextID`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`box_coded`,`box_money`,`box_text`,`BoxBroadcastTextID`) VALUES
-(3801,0,0,'I am ready for the illusion, Myranda.',7306,2,3,0,0,0,0,'',0);
diff --git a/sql/updates/world/2016_01_12_02_world_335.sql b/sql/updates/world/2016_01_12_02_world_335.sql
new file mode 100644
index 00000000000..354d0bc129d
--- /dev/null
+++ b/sql/updates/world/2016_01_12_02_world_335.sql
@@ -0,0 +1,4 @@
+-- Insert missing gossip_menu_option 3801 for Myranda the Hag:
+DELETE FROM `gossip_menu_option` WHERE `menu_id`= 3801 AND `OptionBroadcastTextID`= 7306;
+INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`OptionBroadcastTextID`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`box_coded`,`box_money`,`box_text`,`BoxBroadcastTextID`) VALUES
+(3801,0,0,'I am ready for the illusion, Myranda.',7306,2,3,0,0,0,0,'',0);
-- 
cgit v1.2.3