diff options
| author | Killyana <morphone1@gmail.com> | 2019-07-19 01:24:22 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2019-07-19 01:24:22 +0200 |
| commit | 28b8c369bb75d0a73c61e3a7e1694f989ca20cb7 (patch) | |
| tree | 3de3718d3c69b7666bf143d0ab305f0b3b6575d6 | |
| parent | 246a8661fd6879666c6601dc6513954661bb55b9 (diff) | |
DB/Pooling: Fix Storm Peaks Ore pool
| -rw-r--r-- | sql/updates/world/3.3.5/2019_07_19_01_world.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_07_19_01_world.sql b/sql/updates/world/3.3.5/2019_07_19_01_world.sql new file mode 100644 index 00000000000..5926ebafc18 --- /dev/null +++ b/sql/updates/world/3.3.5/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; |