From 9c41af16cae65c6a7cc97a22fd877993eb9dfa49 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Thu, 25 Aug 2016 09:10:06 +0200 Subject: Rename 2016_08_28_17750_world.sql to 2016_08_25_05_world.sql --- sql/updates/world/3.3.5/2016_08_25_05_world.sql | 8 ++++++++ sql/updates/world/3.3.5/2016_08_28_17750_world.sql | 8 -------- 2 files changed, 8 insertions(+), 8 deletions(-) create mode 100644 sql/updates/world/3.3.5/2016_08_25_05_world.sql delete mode 100644 sql/updates/world/3.3.5/2016_08_28_17750_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2016_08_25_05_world.sql b/sql/updates/world/3.3.5/2016_08_25_05_world.sql new file mode 100644 index 00000000000..75b89a1159f --- /dev/null +++ b/sql/updates/world/3.3.5/2016_08_25_05_world.sql @@ -0,0 +1,8 @@ +-- NPC 35364 Slahtz / 35365 Behsten +UPDATE `creature_template` SET `gossip_menu_id`= 10638 WHERE `entry`= 35365; -- 35364 already OK + +UPDATE `gossip_menu_option` SET `box_money`= 100000, `box_text`= 'Are you certain you wish to stop gaining experience?', `BoxBroadcastTextID`= 35535 WHERE `menu_id`= 10638 AND `id`= 0; + +DELETE FROM `gossip_menu_option` WHERE `menu_id`= 10638 AND `id`= 1; +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`,`VerifiedBuild`) VALUES +(10638,1,0,'I wish to start gaining experience again.',35532,1,1,0,0,0,100000,'Are you certain you wish to start gaining experience again?',35533,0); diff --git a/sql/updates/world/3.3.5/2016_08_28_17750_world.sql b/sql/updates/world/3.3.5/2016_08_28_17750_world.sql deleted file mode 100644 index 75b89a1159f..00000000000 --- a/sql/updates/world/3.3.5/2016_08_28_17750_world.sql +++ /dev/null @@ -1,8 +0,0 @@ --- NPC 35364 Slahtz / 35365 Behsten -UPDATE `creature_template` SET `gossip_menu_id`= 10638 WHERE `entry`= 35365; -- 35364 already OK - -UPDATE `gossip_menu_option` SET `box_money`= 100000, `box_text`= 'Are you certain you wish to stop gaining experience?', `BoxBroadcastTextID`= 35535 WHERE `menu_id`= 10638 AND `id`= 0; - -DELETE FROM `gossip_menu_option` WHERE `menu_id`= 10638 AND `id`= 1; -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`,`VerifiedBuild`) VALUES -(10638,1,0,'I wish to start gaining experience again.',35532,1,1,0,0,0,100000,'Are you certain you wish to start gaining experience again?',35533,0); -- cgit v1.2.3