diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2025_08_25_02_world.sql | 16 |
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'); |