diff options
| author | Aokromes <jipr@hotmail.com> | 2013-04-27 05:02:07 -0700 |
|---|---|---|
| committer | Aokromes <jipr@hotmail.com> | 2013-04-27 05:02:07 -0700 |
| commit | e486cd7623fb2a8f62db8520d0a242be3ff3baf0 (patch) | |
| tree | 1ff943c676da5b359e5199c6e21ee28c3a1bb812 /sql/updates | |
| parent | 1ce50f84425147a98b2bd9897fdc79ff58cf4560 (diff) | |
| parent | 678cade1163080263bdea9e349fbb67b7af15ea7 (diff) | |
Merge pull request #9662 from xjose93/GuildRename
Guild rename
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/2013_04_16_01_world_misc.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/2013_04_16_01_world_misc.sql b/sql/updates/world/2013_04_16_01_world_misc.sql new file mode 100644 index 00000000000..4c7561a0e69 --- /dev/null +++ b/sql/updates/world/2013_04_16_01_world_misc.sql @@ -0,0 +1,10 @@ +DELETE FROM `command` WHERE `name` = 'guild rename'; +INSERT INTO `command` (`name`, `security`, `help`) VALUES +('guild rename', 3, 'Syntax: .guild rename "$GuildName" "$NewGuildName" \n\n Rename a guild named $GuildName with $NewGuildName. Guild name and new guild name must in quotes.'); + +SET @ENTRY1 := 96; +SET @ENTRY2 := 97; +DELETE FROM `trinity_string` WHERE `entry` IN (@ENTRY1, @ENTRY2); +INSERT INTO `trinity_string` (`entry`, `content_default`) VALUES +(@ENTRY1, 'The guild name \'%s\' is already taken'), +(@ENTRY2, 'Changed guild name \'%s\' to \'%s\''); |