diff options
| author | tkrokli <tkrokli@users.noreply.github.com> | 2016-08-25 09:07:45 +0200 |
|---|---|---|
| committer | joschiwald <joschiwald.trinity@gmail.com> | 2017-02-18 16:23:19 +0100 |
| commit | ac88c6ec17d1e97a366a78df2dcc7f3b2fd9a1d8 (patch) | |
| tree | d3e96ee6c37675eebdad38a7ec0806b24187b5b2 /sql | |
| parent | d01dbdc52806626e7c0a03448f80c42e3fa1f4ec (diff) | |
Core/Scripts: move npc_experience hardcoded text to DB
(cherry picked from commit 8df4706992f0fa39af5892dce2c23a0dde5bd9c1)
Rename 2016_08_28_17750_world.sql to 2016_08_25_05_world.sql
(cherry picked from commit 9c41af16cae65c6a7cc97a22fd877993eb9dfa49)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2017_02_18_25_world_2016_08_25_05_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/master/2017_02_18_25_world_2016_08_25_05_world.sql b/sql/updates/world/master/2017_02_18_25_world_2016_08_25_05_world.sql new file mode 100644 index 00000000000..75b89a1159f --- /dev/null +++ b/sql/updates/world/master/2017_02_18_25_world_2016_08_25_05_world.sql @@ -0,0 +1,8 @@ +-- NPC 35364 Slahtz <Experience Eliminator> / 35365 Behsten <Experience Eliminator> +UPDATE `creature_template` SET `gossip_menu_id`= 10638 WHERE `entry`= 35365; -- 35364 already OK + +UPDATE `gossip_menu_option` SET `box_money`= 100000, `box_text`= 'Are you certain you wish to stop gaining experience?', `BoxBroadcastTextID`= 35535 WHERE `menu_id`= 10638 AND `id`= 0; + +DELETE FROM `gossip_menu_option` WHERE `menu_id`= 10638 AND `id`= 1; +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 +(10638,1,0,'I wish to start gaining experience again.',35532,1,1,0,0,0,100000,'Are you certain you wish to start gaining experience again?',35533,0); |