From 42be4c1da7969582f347cb58d672634d5db0a24d Mon Sep 17 00:00:00 2001 From: Aokromes Date: Sat, 3 May 2014 07:21:59 +0200 Subject: DB/Creature: Remove trigger flags from Dead Caravan mobs By phoenixfight, closes #11986 --- sql/updates/world/2014_05_03_00_world_creature_template.sql | 2 ++ 1 file changed, 2 insertions(+) create mode 100644 sql/updates/world/2014_05_03_00_world_creature_template.sql (limited to 'sql') diff --git a/sql/updates/world/2014_05_03_00_world_creature_template.sql b/sql/updates/world/2014_05_03_00_world_creature_template.sql new file mode 100644 index 00000000000..c17c1cf07cd --- /dev/null +++ b/sql/updates/world/2014_05_03_00_world_creature_template.sql @@ -0,0 +1,2 @@ +-- +UPDATE `creature_template` SET `flags_extra`=0 WHERE `entry` IN (25342,25343); -- cgit v1.2.3 From 91839946b59121135f92bb05aa4b9c71b3737198 Mon Sep 17 00:00:00 2001 From: untaught Date: Sat, 3 May 2014 17:52:50 +0200 Subject: DB/Gossip: Fix some gossip stuff --- sql/updates/world/2014_05_03_01_world_gossip_menu_option.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 sql/updates/world/2014_05_03_01_world_gossip_menu_option.sql (limited to 'sql') diff --git a/sql/updates/world/2014_05_03_01_world_gossip_menu_option.sql b/sql/updates/world/2014_05_03_01_world_gossip_menu_option.sql new file mode 100644 index 00000000000..2120623365e --- /dev/null +++ b/sql/updates/world/2014_05_03_01_world_gossip_menu_option.sql @@ -0,0 +1,11 @@ +UPDATE `gossip_menu_option` SET `option_id`=3,`npc_option_npcflag`=128 WHERE `menu_id`=11104 AND `id`=0; +UPDATE `gossip_menu_option` SET `option_id`=4,`npc_option_npcflag`=8192 WHERE `menu_id`=9683 AND `id`=0; +UPDATE `gossip_menu_option` SET `option_id`=5,`npc_option_npcflag`=16 WHERE `menu_id`=3626 AND `id`=0; +UPDATE `gossip_menu_option` SET `option_id`=12,`npc_option_npcflag`=1048576 WHERE `menu_id`=10601 AND `id`=0; +UPDATE `gossip_menu_option` SET `option_id`=15,`npc_option_npcflag`=4096 WHERE `menu_id`=9848 AND `id`=0; +UPDATE `gossip_menu_option` SET `option_id`=1,`npc_option_npcflag`=1 WHERE `menu_id` IN (10211,11398,11016,11014,10949,10948,10860,10614,9280,9297,9418,9492,9669,9928,10012,10200,10204,10206,10366,10477) AND `id`=0; +UPDATE `gossip_menu_option` SET `option_id`=1,`npc_option_npcflag`=1 WHERE `menu_id` IN (11016,10204,9297,10464,10465,10316,10949) AND `id`=1; +UPDATE `gossip_menu_option` SET `option_id`=1,`npc_option_npcflag`=1 WHERE `menu_id` IN (10614,11014,11016) AND `id`=3; +UPDATE `gossip_menu_option` SET `option_id`=1,`npc_option_npcflag`=1 WHERE `menu_id`=11014 AND `id`=4; +UPDATE `gossip_menu_option` SET `option_id`=1,`npc_option_npcflag`=1 WHERE `menu_id` IN (11014,11016) AND `id`=5; +UPDATE `gossip_menu_option` SET `option_id`=1,`npc_option_npcflag`=1 WHERE `menu_id`=10318 AND `id`=7; -- cgit v1.2.3