Core/Commands: Add .guild list GM command to list all guilds (#30930)

1 files changed, 16 insertions, 0 deletions

diff --git a/sql/updates/world/master/2025_08_25_02_world.sql b/sql/updates/world/master/2025_08_25_02_world.sql
new file mode 100644
index 00000000000..04618e9ce48
--- /dev/null
+++ b/sql/updates/world/master/2025_08_25_02_world.sql
@@ -0,0 +1,16 @@
+--
+DELETE FROM `command` WHERE `name`='guild list';
+INSERT INTO `command` (`name`, `help`) VALUES
+('guild list','Syntax: .guild list.  Lists every guild: ID | Name | Leader | Creation date | Members | Bank gold');
+
+-- Strings for .guild list output
+DELETE FROM `trinity_string` WHERE `entry` BETWEEN 1219 AND 1222;
+INSERT INTO `trinity_string` (`entry`,`content_default`) VALUES
+-- Title
+(1219,'%s=== Guild list ===%s'),
+-- Header (6 string args for labels)
+(1220,'%s  ID   |           Name           |      Leader      |    Creation date    | Members | Bank gold%s'),
+-- Row (id, name, gm, created, members, bankGold)
+(1221,'%6u | %-24.24s | %-16.16s | %-19s | %7u | %10u'),
+-- Total
+(1222,'%sTotal guilds: %u%s');