aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorratkosrb <35845488+ratkosrb@users.noreply.github.com>2020-02-16 14:36:56 +0200
committerGitHub <noreply@github.com>2020-02-16 13:36:56 +0100
commit6176ce92ea01fd33b11c2e7f8e9ebb509e80c944 (patch)
treeee2dba0ebbe1ab433c09bbe14c58c600175dab50 /sql
parentbaa87c43bae9df507427b3fe2d86ba25f059fdef (diff)
Core/Creature: Use proper name for wander distance. (#24133)
* Use proper name for wander distance. * Rename db field. * Fix query. * Remove underscore from chat command. * Rename the handler too. * Update chat command description. * Fix remaining issues. * Rename 2020_99_99_99_world_335.sql to 2020_02_16_01_world.sql Co-authored-by: Giacomo Pozzoni <giacomopoz@gmail.com>
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/3.3.5/2020_02_16_01_world.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_02_16_01_world.sql b/sql/updates/world/3.3.5/2020_02_16_01_world.sql
new file mode 100644
index 00000000000..9252ade8290
--- /dev/null
+++ b/sql/updates/world/3.3.5/2020_02_16_01_world.sql
@@ -0,0 +1,7 @@
+-- Use more appropriate name for distance used by random movement generator.
+ALTER TABLE `creature`
+ CHANGE COLUMN `spawndist` `wander_distance` FLOAT NOT NULL DEFAULT '0' AFTER `spawntimesecs`;
+
+-- Update name used by chat command.
+UPDATE `trinity_string` SET `content_default`='Wander distance changed to: %f' WHERE `entry`=297;
+UPDATE `command` SET `name`='npc set wanderdistance', `help`='Syntax: .npc set wanderdistance #dist\r\n\r\nAdjust wander distance of selected creature to dist.' WHERE `name`='npc set spawndist';