diff options
| author | treeston <treeston.mmoc@gmail.com> | 2016-01-25 01:03:56 +0100 |
|---|---|---|
| committer | treeston <treeston.mmoc@gmail.com> | 2016-02-10 19:35:11 +0100 |
| commit | 6102a7937ddb0cf145c72fe056fc5ac4b4c3b1b5 (patch) | |
| tree | e1b3d156889486829bd88a18368ab806a6149b9a /sql/updates | |
| parent | cfed2d7a3ddf4f8121d3359f9888e6116fc82e62 (diff) | |
Maps/Instances: Implement handling of CMSG_SET_SAVED_INSTANCE_EXTEND
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/characters/2016_01_24_instanceextend.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/2016_01_25_instanceextend.sql | 6 |
2 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/characters/2016_01_24_instanceextend.sql b/sql/updates/characters/2016_01_24_instanceextend.sql new file mode 100644 index 00000000000..c93c1fd15cd --- /dev/null +++ b/sql/updates/characters/2016_01_24_instanceextend.sql @@ -0,0 +1,2 @@ +-- extend=0 is normal, extend=1 is extended, extend=2 is expired +ALTER TABLE `character_instance` ADD COLUMN `extendState` TINYINT(2) UNSIGNED NOT NULL DEFAULT '1'; diff --git a/sql/updates/world/2016_01_25_instanceextend.sql b/sql/updates/world/2016_01_25_instanceextend.sql new file mode 100644 index 00000000000..5feb4f44163 --- /dev/null +++ b/sql/updates/world/2016_01_25_instanceextend.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; |