diff options
| author | Shauren <shauren.trinity@gmail.com> | 2016-04-05 20:35:59 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2016-04-05 20:35:59 +0200 |
| commit | 4e673836212424cef55503b852f56aab6b1c4354 (patch) | |
| tree | 0d9910abe23d14d166e28e57be7af8c84e292f51 /sql/updates | |
| parent | 6d2dd48183790da0ee36956952c4a39daf7b551f (diff) | |
Merge branch '3.3.5-instanceextend' into 3.3.5 (PR #16392)
(cherry picked from commit 62aff401f687b56d720a320778950e82b65fbd8b)
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; |