diff options
| author | tkrokli <tkrokli@users.noreply.github.com> | 2016-08-23 13:30:27 +0200 |
|---|---|---|
| committer | SnapperRy <snapperryen@gmail.com> | 2016-08-23 13:30:27 +0200 |
| commit | 8a0990376de608a58054a8103f856ac0952d6114 (patch) | |
| tree | 844c78903c4da009a0ba655b5f3dca6f9bb43c3b /sql | |
| parent | 831975fa3426bdec9f9c0647d690e6c9664d5f72 (diff) | |
Core/Scripts: npc_wormhole #define text moved to DB (#17805)
Another core script hardcoded text removal:
- removed #define text from script
- added the text to gossip_menu_option
- added and renamed enum to match DB entries
- minor additional adjustments and comments
Closes #6841
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2016_08_21_08_world.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_08_21_08_world.sql b/sql/updates/world/3.3.5/2016_08_21_08_world.sql new file mode 100644 index 00000000000..d7697d28ad7 --- /dev/null +++ b/sql/updates/world/3.3.5/2016_08_21_08_world.sql @@ -0,0 +1,10 @@ +-- NPC ID / entry 35646 Wormhole (summoned by item 48933 Wormhole Generator: Northrend) + +DELETE FROM `gossip_menu_option` WHERE `menu_id`= 10668; +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 +(10668, 0, 0, 'Borean Tundra', 35939, 1, 1, 0, 0, 0, 0, '', 0, 0), +(10668, 1, 0, 'Howling Fjord', 35943, 1, 1, 0, 0, 0, 0, '', 0, 0), +(10668, 2, 0, 'Sholazar Basin', 35940, 1, 1, 0, 0, 0, 0, '', 0, 0), +(10668, 3, 0, 'Icecrown', 35941, 1, 1, 0, 0, 0, 0, '', 0, 0), +(10668, 4, 0, 'Storm Peaks', 35942, 1, 1, 0, 0, 0, 0, '', 0, 0), +(10668, 5, 0, 'Underground...', 36022, 1, 1, 0, 0, 0, 0, '', 0, 0); |