diff options
| author | tkrokli <tkrokli@hotmail.com> | 2016-06-08 05:30:26 +0200 |
|---|---|---|
| committer | tkrokli <tkrokli@hotmail.com> | 2016-06-08 21:59:24 +0200 |
| commit | c214f987d730169e106b37fa1fe5f8565609374b (patch) | |
| tree | f3d4fc3a59fd5f8ba8edf57c5562343e70118bd3 /sql | |
| parent | 7c25f3cffd0c4e15a9ff08982914fd95d5cafe2f (diff) | |
Core/Scripts: npc_grandmother gossip text moved to DB
Removing one more hardcoded text line from core scripts.
Also adding correct gossip to the npc_grandmother script.
Gossip changes in this script:
- remove hardcoded text from core script
- use existing npc_text IDs in gossip enum
- add missing text rows to gossip_menu_option
- use values from gossip_menu_option in enum
- replace spawn coordinates 0.0f with GetPosition()
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2016_07_07_77_world.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_07_07_77_world.sql b/sql/updates/world/3.3.5/2016_07_07_77_world.sql new file mode 100644 index 00000000000..ecff9eb7ce6 --- /dev/null +++ b/sql/updates/world/3.3.5/2016_07_07_77_world.sql @@ -0,0 +1,6 @@ +-- NPC ID 17603 Grandmother gossip_menu_option (new rows) +DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (7441,7442,7443); +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`) VALUES +(7441,0,0,"Oh, grandmother, what big ears you have.", 14217,0,0,7442,0,0,0,'',0), +(7442,0,0,"Oh, grandmother, what big eyes you have.", 14219,0,0,7443,0,0,0,'',0), +(7443,0,0,"Oh, grandmother, what phat lewts you have.",14221,0,0, 0,0,0,0,'',0); |