From 72093e98e1bdbd3b83d8030d1cb50306bb04b028 Mon Sep 17 00:00:00 2001 From: ratkosrb <35845488+ratkosrb@users.noreply.github.com> Date: Tue, 21 Dec 2021 19:50:12 +0100 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 (cherry picked from commit 6176ce92ea01fd33b11c2e7f8e9ebb509e80c944) # Conflicts: # sql/updates/world/master/2020_02_16_01_world.sql # src/server/database/Database/Implementation/WorldDatabase.cpp # src/server/game/Entities/Creature/Creature.cpp # src/server/game/Globals/ObjectMgr.cpp # src/server/game/Globals/ObjectMgr.h # src/server/scripts/Commands/cs_npc.cpp --- .../world/master/2021_12_21_15_world_2020_02_16_01_world.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/master/2021_12_21_15_world_2020_02_16_01_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/master/2021_12_21_15_world_2020_02_16_01_world.sql b/sql/updates/world/master/2021_12_21_15_world_2020_02_16_01_world.sql new file mode 100644 index 00000000000..9252ade8290 --- /dev/null +++ b/sql/updates/world/master/2021_12_21_15_world_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