diff options
| author | Aokromes <Aokromes@users.noreply.github.com> | 2025-03-31 20:12:20 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2025-03-31 20:12:20 +0200 |
| commit | 32fbb07158dc7c4af6895888e357154c01e7c8d0 (patch) | |
| tree | 928b9e236fdb42bbb01f85f46eca5add3b7e8789 | |
| parent | af4f436206dd7c364b7979403a9a28ec665c490c (diff) | |
DB/Gameobject: Fix overlapping Water Barrels/Food Crates in Stormwind City
closes #27079
by CraftedRO
| -rw-r--r-- | sql/updates/world/3.3.5/2025_03_31_04_world.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2025_03_31_04_world.sql b/sql/updates/world/3.3.5/2025_03_31_04_world.sql new file mode 100644 index 00000000000..50b12fff558 --- /dev/null +++ b/sql/updates/world/3.3.5/2025_03_31_04_world.sql @@ -0,0 +1,10 @@ +-- +SET @POOL=594; +DELETE FROM `pool_template` WHERE `entry`=@POOL; +INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES +(@POOL, 1, "Water Barrel and Food Crate7"); + +DELETE FROM `pool_members` WHERE `type`=1 AND `poolSpawnId`=@POOL; +INSERT INTO `pool_members` (`type`, `spawnId`, `poolSpawnId`, `chance`, `description`) VALUES +(1, 32287, @POOL, 0, "Water Barrel and Food Crate - Spawn 7"), +(1, 32742, @POOL, 0, "Water Barrel and Food Crate - Spawn 7"); |