From 6176ce92ea01fd33b11c2e7f8e9ebb509e80c944 Mon Sep 17 00:00:00 2001 From: ratkosrb <35845488+ratkosrb@users.noreply.github.com> Date: Sun, 16 Feb 2020 14:36:56 +0200 Subject: 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 --- sql/updates/world/3.3.5/2020_02_16_01_world.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/3.3.5/2020_02_16_01_world.sql (limited to 'sql') 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'; -- cgit v1.2.3