diff options
| author | offl <offl@users.noreply.github.com> | 2020-11-01 02:14:59 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-02-28 23:39:18 +0100 |
| commit | 224f9150a5a022f1ed62edb209ca6c4d1444c6f9 (patch) | |
| tree | 9a5eaa195f9a4faa0927e4def4106ec3017a7776 | |
| parent | 2e2f93b94f52e26d8d9faa8d9930ca3a04e2ed81 (diff) | |
DB/Instance/The Mechanar: Standardize respawn time of gameobjects & fix state
(cherry picked from commit 7b5a30c52f719fe8927f0610cfff822891395828)
| -rw-r--r-- | sql/updates/world/master/2022_02_28_53_world_2020_11_01_00_world.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_02_28_53_world_2020_11_01_00_world.sql b/sql/updates/world/master/2022_02_28_53_world_2020_11_01_00_world.sql new file mode 100644 index 00000000000..947c9b8122e --- /dev/null +++ b/sql/updates/world/master/2022_02_28_53_world_2020_11_01_00_world.sql @@ -0,0 +1,5 @@ +-- +UPDATE `gameobject` SET `spawntimesecs` = 86400 WHERE `id` IN (184465); +UPDATE `gameobject` SET `spawntimesecs` = 0 WHERE `id` IN (184322,184449,184632,185015,184228,184227,184226,184225,183788); +UPDATE `gameobject` SET `state` = 1 WHERE `id` IN (184227,184228); +UPDATE `gameobject` SET `state` = 0 WHERE `id` IN (184449); |