Core/Commands: Implement .neargraveyard (find nearest graveyard from dbc). (#17301)

(cherry picked from commit e2c01899272d1e6c6bbf990676b818cceaf18c9c)

2 files changed, 13 insertions, 0 deletions

diff --git a/sql/updates/auth/6.x/2016_09_03_02_auth_2016_06_06_00_auth.sql b/sql/updates/auth/6.x/2016_09_03_02_auth_2016_06_06_00_auth.sql
new file mode 100644
index 00000000000..0e203d847ae
--- /dev/null
+++ b/sql/updates/auth/6.x/2016_09_03_02_auth_2016_06_06_00_auth.sql
@@ -0,0 +1,5 @@
+DELETE FROM `rbac_permissions` WHERE `id` = 841;
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES (841, 'Command: .debug neargraveyard');
+
+DELETE FROM `rbac_linked_permissions` WHERE `id` = 196 AND `linkedId` = 841;
+INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES (196, 841);
diff --git a/sql/updates/world/6.x/2016_09_03_04_world_2016_06_06_01_world.sql b/sql/updates/world/6.x/2016_09_03_04_world_2016_06_06_01_world.sql
new file mode 100644
index 00000000000..fc47dc4bf14
--- /dev/null
+++ b/sql/updates/world/6.x/2016_09_03_04_world_2016_06_06_01_world.sql
@@ -0,0 +1,8 @@
+DELETE FROM `command` WHERE `name` = 'debug neargraveyard';
+INSERT INTO `command` (`name`, `permission`, `help`) VALUES 
+('debug neargraveyard', 841, 'Syntax: .debug neargraveyard [linked]\nFind the nearest graveyard from dbc or db (if linked)');
+
+DELETE FROM `trinity_string` WHERE `entry` IN (82, 83);
+INSERT INTO `trinity_string` (`entry`, `content_default`, `content_loc6`, `content_loc7`) VALUES 
+(82, 'Nearest graveyard found: %u (%.3f %.3f %.3f)', 'Cementerio mas cercano encontrado: %u (%.3f %.3f %.3f)', 'Cementerio mas cercano encontrado: %u (%.3f %.3f %.3f)'),
+(83, 'There are no graveyards near', 'No se ha encontrado ningun cementerio cerca', 'No se ha encontrado ningun cementerio cerca');