diff options
| author | Killyana <morphone1@gmail.com> | 2019-07-19 01:24:22 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-12-16 22:07:32 +0100 |
| commit | 27991ff0ba9b673beecf39a72dc0b24f539360d1 (patch) | |
| tree | be60bb8f76eac4def037aeff2bc3aed114fd406b | |
| parent | 879e7094b78e90ebec607b4a169d613aed1b295c (diff) | |
DB/Pooling: Fix Storm Peaks Ore pool
(cherry picked from commit 28b8c369bb75d0a73c61e3a7e1694f989ca20cb7)
| -rw-r--r-- | sql/updates/world/master/2021_12_16_14_world_2019_07_19_01_world.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_16_14_world_2019_07_19_01_world.sql b/sql/updates/world/master/2021_12_16_14_world_2019_07_19_01_world.sql new file mode 100644 index 00000000000..5926ebafc18 --- /dev/null +++ b/sql/updates/world/master/2021_12_16_14_world_2019_07_19_01_world.sql @@ -0,0 +1,4 @@ +-- +DELETE FROM `pool_template` WHERE `entry`=11389; +DELETE FROM `pool_members` WHERE `spawnId`=11389 AND `type`=2 AND `poolSpawnId`=9907; +UPDATE `pool_members` SET `poolSpawnId`=11212 WHERE `spawnId` IN (162689,162939) AND `poolSpawnId`=11389; |