diff options
| author | Gooyeth <migmadmu@hotmail.com> | 2018-04-24 08:05:07 -0600 |
|---|---|---|
| committer | jackpoz <giacomopoz@gmail.com> | 2018-04-24 16:05:07 +0200 |
| commit | 59f80f555c2b7608ee2457e8f4a93d0418022a1b (patch) | |
| tree | f4033ac99eba40bff7d4ac8a1ff3208799c6ddbd /sql | |
| parent | 71188062314ee94402d9d3e228fd5b46e8865b18 (diff) | |
Core/Battleground: Fix arena distribution timer where it is less than the current unix time. (#21859)
* Core/Battleground: Fix arena distribution timer where it is less than the current unix time.
* fix bracket
* fix when the timer starts for the first time.
* m_NextAutoDistributionTime instead of GetGameTime.
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 3 | ||||
| -rw-r--r-- | sql/updates/characters/3.3.5/9999_99_99_99_characters.sql | 2 |
2 files changed, 4 insertions, 1 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index e824e6bee60..34db0502992 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -2622,7 +2622,8 @@ INSERT INTO `updates` VALUES ('2017_10_29_00_characters.sql','8CFC473E7E87E58C317A72016BF69E9050D3BC83','ARCHIVED','2017-04-19 00:07:40',25), ('2017_11_27_00_characters.sql','6FF1F84B8985ADFC7FF97F0BF8E53403CF13C320','ARCHIVED','2017-11-27 22:08:42',0), ('2018_01_13_00_characters.sql','E3C0DA9995BA71ED5A267294470CD03DC51862DD','ARCHIVED','2018-01-13 00:00:00',0), -('2018_02_19_00_characters.sql','FE5C5F9B88F0791549DDE680942493781E2269E6','RELEASED','2018-02-18 19:49:38',0); +('2018_02_19_00_characters.sql','FE5C5F9B88F0791549DDE680942493781E2269E6','RELEASED','2018-02-18 19:49:38',0), +('9999_99_99_99_characters.sql','77264AB7BEF421C0A4BB81EEAFD0D8C1CBCA840F','RELEASED','2018-04-20 09:38:10',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/characters/3.3.5/9999_99_99_99_characters.sql b/sql/updates/characters/3.3.5/9999_99_99_99_characters.sql new file mode 100644 index 00000000000..303a1dd9ffd --- /dev/null +++ b/sql/updates/characters/3.3.5/9999_99_99_99_characters.sql @@ -0,0 +1,2 @@ +-- +UPDATE `worldstates` SET `value`=UNIX_TIMESTAMP() WHERE `entry`=20001 AND `value` < UNIX_TIMESTAMP(); |