aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorratkosrb <35845488+ratkosrb@users.noreply.github.com>2021-12-21 19:50:12 +0100
committerShauren <shauren.trinity@gmail.com>2021-12-21 19:50:12 +0100
commit72093e98e1bdbd3b83d8030d1cb50306bb04b028 (patch)
tree83784486b449e67e8f38949b4a6d38bd5793f53e /sql
parent460549799ee6116ca39751226e3aededab04ac6a (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> (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
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2021_12_21_15_world_2020_02_16_01_world.sql7
1 files changed, 7 insertions, 0 deletions
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';