diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/characters/2016_04_05_00_characters_2016_02_10_00_characters.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/2016_04_05_07_world_2016_02_10_07_world.sql | 6 |
2 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/characters/2016_04_05_00_characters_2016_02_10_00_characters.sql b/sql/updates/characters/2016_04_05_00_characters_2016_02_10_00_characters.sql new file mode 100644 index 00000000000..d49ed155bc8 --- /dev/null +++ b/sql/updates/characters/2016_04_05_00_characters_2016_02_10_00_characters.sql @@ -0,0 +1,2 @@ +-- extend=0 is expired, extend=1 is normal, extend=2 is extended +ALTER TABLE `character_instance` ADD COLUMN `extendState` TINYINT(2) UNSIGNED NOT NULL DEFAULT '1'; diff --git a/sql/updates/world/2016_04_05_07_world_2016_02_10_07_world.sql b/sql/updates/world/2016_04_05_07_world_2016_02_10_07_world.sql new file mode 100644 index 00000000000..5feb4f44163 --- /dev/null +++ b/sql/updates/world/2016_04_05_07_world_2016_02_10_07_world.sql @@ -0,0 +1,6 @@ +-- +DELETE FROM `command` WHERE `name`="debug raidreset"; +INSERT INTO `command` (`name`,`permission`,`help`) VALUES ("debug raidreset",414,"Syntax: .debug raidreset mapid [difficulty] +Forces a global reset of the specified map on all difficulties (or only the specific difficulty if specified). Effectively the same as setting the specified map's reset timer to now."); + +UPDATE `trinity_string` SET `content_default`="Map: %d | ID: %d | perm: %s | extended: %s | diff: %d | canReset: %s | TTR: %s" WHERE `entry`=5045; |