diff options
| author | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2011-03-29 11:22:28 +0200 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2011-03-29 11:22:28 +0200 |
| commit | 40390c362976eeba6479dd8cd46bd538df0a8451 (patch) | |
| tree | 64f594c655d73d9481cd4c3b7e128e802e768546 | |
| parent | 8bce7071c8f8b146a4477bc01cc660058183e1b2 (diff) | |
DB/Spawns: Increase some mining pools to more reasonable values
| -rw-r--r-- | sql/updates/world/2011_03_29_01_world_pool_template.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/2011_03_29_01_world_pool_template.sql b/sql/updates/world/2011_03_29_01_world_pool_template.sql new file mode 100644 index 00000000000..37f565c21f3 --- /dev/null +++ b/sql/updates/world/2011_03_29_01_world_pool_template.sql @@ -0,0 +1,14 @@ +-- update some maxcounts in spawnpools +UPDATE `pool_template` SET `max_limit`=15 WHERE `pool`=896; -- Wintergrasp from 20 to 15 +UPDATE `pool_template` SET `max_limit`=35 WHERE `pool`=897; -- Icecrown from 20 to 35 +UPDATE `pool_template` SET `max_limit`=10 WHERE `pool`=2001; -- Alterac Mountains (outer section) from 4 to 10 +UPDATE `pool_template` SET `max_limit`=45 WHERE `pool`=2002; -- Arathi Highlands (Main Section) from 10 to 45 +UPDATE `pool_template` SET `max_limit`=25 WHERE `pool`=2004; -- Badlands from 9 to 25 +UPDATE `pool_template` SET `max_limit`=20 WHERE `pool`=2005; -- Blasted Lands from 8 to 20 +UPDATE `pool_template` SET `max_limit`=40 WHERE `pool`=2007; -- Burning Steppes from 10 to 40 +UPDATE `pool_template` SET `max_limit`=15 WHERE `pool`=2008; -- Dun Morogh from 12 to 15 +UPDATE `pool_template` SET `max_limit`=20 WHERE `pool`=2009; -- Duskwood from 16 to 20 +UPDATE `pool_template` SET `max_limit`=10 WHERE `pool`=2012; -- Eversong Woods from 6 to 10 +UPDATE `pool_template` SET `max_limit`=10 WHERE `pool`=2014; -- Hillsbrad Foothills (Main Section) from 5 to 10 +UPDATE `pool_template` SET `max_limit`= 3 WHERE `pool`=2016; -- Hillsbrad Foothills (Azurelode Mine) - Special Mineral GOs ONLY from 4 to 3 +UPDATE `pool_template` SET `max_limit`=20 WHERE `pool`=2018; -- Loch Modan from 9 to 20 |