diff options
| author | Dr-J <daniel.jarrott0@gmail.com> | 2014-09-11 17:06:08 +0100 |
|---|---|---|
| committer | Dr-J <daniel.jarrott0@gmail.com> | 2014-09-11 17:06:08 +0100 |
| commit | 0e13ae4925af2e06c2fa38855c83518258d17927 (patch) | |
| tree | 9ff4801c7c1a296bb17881f04fef03c3d3833089 /sql | |
| parent | 1e3aa97098bb04e8f1312dc40e692d1a2f90b5ae (diff) | |
DB/Misc: Some additions to https://github.com/TrinityCore/TrinityCore/commit/137c8a7de9beaa90441c5aa38e14ad0b09bebffe
Some additions to https://github.com/TrinityCore/TrinityCore/commit/137c8a7de9beaa90441c5aa38e14ad0b09bebffe
* Add a missing npc_text where gossip menu had already existed in db with this text and core script sent this text as gossip but text was not in db
* Correct option id for a option.
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2014_09_11_03_world_misc.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/2014_09_11_03_world_misc.sql b/sql/updates/world/2014_09_11_03_world_misc.sql new file mode 100644 index 00000000000..b6cd07998ef --- /dev/null +++ b/sql/updates/world/2014_09_11_03_world_misc.sql @@ -0,0 +1,5 @@ +DELETE FROM `npc_text` WHERE `ID`=5841; +INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`, `BroadcastTextID0`, `lang0`, `prob0`, `em0_0`, `em0_1`, `em0_2`, `em0_3`, `em0_4`, `em0_5`, `text1_0`, `text1_1`, `BroadcastTextID1`, `lang1`, `prob1`, `em1_0`, `em1_1`, `em1_2`, `em1_3`, `em1_4`, `em1_5`, `text2_0`, `text2_1`, `BroadcastTextID2`, `lang2`, `prob2`, `em2_0`, `em2_1`, `em2_2`, `em2_3`, `em2_4`, `em2_5`, `text3_0`, `text3_1`, `BroadcastTextID3`, `lang3`, `prob3`, `em3_0`, `em3_1`, `em3_2`, `em3_3`, `em3_4`, `em3_5`, `text4_0`, `text4_1`, `BroadcastTextID4`, `lang4`, `prob4`, `em4_0`, `em4_1`, `em4_2`, `em4_3`, `em4_4`, `em4_5`, `text5_0`, `text5_1`, `BroadcastTextID5`, `lang5`, `prob5`, `em5_0`, `em5_1`, `em5_2`, `em5_3`, `em5_4`, `em5_5`, `text6_0`, `text6_1`, `BroadcastTextID6`, `lang6`, `prob6`, `em6_0`, `em6_1`, `em6_2`, `em6_3`, `em6_4`, `em6_5`, `text7_0`, `text7_1`, `BroadcastTextID7`, `lang7`, `prob7`, `em7_0`, `em7_1`, `em7_2`, `em7_3`, `em7_4`, `em7_5`, `VerifiedBuild`) VALUES +(5841, 'I only make my mounts available to those who are considered exalted to Orgrimmar and the Orcish race. Go prove yourself to us, and I''ll make my mighty wolves available for your inspection.', 'I only make my mounts available to those who are considered exalted to Orgrimmar and the Orcish race. Go prove yourself to us, and I''ll make my mighty wolves available for your inspection.', 8414, 0, 1, 0, 1, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); + +UPDATE `gossip_menu_option` SET `id`=0 WHERE `menu_id`=3185 AND `id`=1; |