diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2014_05_03_00_world_creature_template.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/2014_05_03_01_world_gossip_menu_option.sql | 11 |
2 files changed, 13 insertions, 0 deletions
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); 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; |