diff options
| author | offl <offl@users.noreply.github.com> | 2020-11-01 02:14:59 +0200 |
|---|---|---|
| committer | offl <offl@users.noreply.github.com> | 2020-11-01 02:14:59 +0200 |
| commit | 7b5a30c52f719fe8927f0610cfff822891395828 (patch) | |
| tree | cdeb93d426ac41f6df4cdc76709608a483edc7ad | |
| parent | b57530ebb143965863b0974adfc95fb8a4e365ee (diff) | |
DB/Instance/The Mechanar: Standardize respawn time of gameobjects & fix state
| -rw-r--r-- | sql/updates/world/3.3.5/2020_11_01_00_world.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_11_01_00_world.sql b/sql/updates/world/3.3.5/2020_11_01_00_world.sql new file mode 100644 index 00000000000..947c9b8122e --- /dev/null +++ b/sql/updates/world/3.3.5/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); |