diff options
| -rw-r--r-- | sql/updates/world/2011_04_11_03_world_arena_season_5.sql | 5 | ||||
| -rw-r--r-- | sql/updates/world/2011_04_13_00_world_pool_template.sql | 51 |
2 files changed, 53 insertions, 3 deletions
diff --git a/sql/updates/world/2011_04_11_03_world_arena_season_5.sql b/sql/updates/world/2011_04_11_03_world_arena_season_5.sql index 5d88b5df981..2336f3974fe 100644 --- a/sql/updates/world/2011_04_11_03_world_arena_season_5.sql +++ b/sql/updates/world/2011_04_11_03_world_arena_season_5.sql @@ -12,7 +12,7 @@ SET @Doris := 32385; SET @Tristia := 32380; SET @Dirgehammer := 32381; -DELETE FROM `creature` WHERE `id` IN (@BG_Zar,@Moonstrike,@ZomBocom,@Xazi,@Nargle,@Kezzik,@Argex,@Thunderhorn,@Doris,@Tristia,@Dirgehammer); +DELETE FROM `creature` WHERE `id` IN (@BG_Zar,@Moonstrike,@ZomBocom,@Xazi,@Nargle,@Krezzik,@Argex,@Thunderhorn,@Doris,@Tristia,@Dirgehammer); INSERT INTO creature (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES @@ -68,7 +68,6 @@ SET @1930RT_2250AP := 2469; SET @1930RT_1200AP := 2468; SET @1930RT_4500AP := 2460; SET @1930RT_3150AP := 2466; -SET @1930RT_1350AP := 2467; SET @1750RT_1350AP := 2463; SET @2050RT_1750AP := 2470; SET @1810RT_2250AP := 2465; @@ -274,7 +273,7 @@ VALUES (@ZomBocom,0,41290,0,0,@7200HP_200AP), -- Savage Gladiator Gloves Druid3 (@ZomBocom,0,41324,0,0,@12000HP_350AP), -- Savage Gladiator Helm Druid3 (@ZomBocom,0,41301,0,0,@12000HP_350AP), -- Savage Gladiator Legs Druid3 -(@ZomBocom,0,41278,0,0,@9600HP_200AP), -- Savage Gladiator Shoulders Druid3 +(@ZomBocom,0,41278,0,0,@9600HP_275AP), -- Savage Gladiator Shoulders Druid3 (@ZomBocom,0,41084,0,0,@12000HP_350AP), -- Savage Gladiator Chest Hunter (@ZomBocom,0,41140,0,0,@7200HP_200AP), -- Savage Gladiator Gloves Hunter (@ZomBocom,0,41154,0,0,@12000HP_350AP), -- Savage Gladiator Helm Hunter diff --git a/sql/updates/world/2011_04_13_00_world_pool_template.sql b/sql/updates/world/2011_04_13_00_world_pool_template.sql new file mode 100644 index 00000000000..86f96d97509 --- /dev/null +++ b/sql/updates/world/2011_04_13_00_world_pool_template.sql @@ -0,0 +1,51 @@ +-- increase the static 15 to 10-25% of maxpoolsize to hopefully get more blizzlike spawncounts +UPDATE `pool_template` SET `max_limit`=20 WHERE `entry`=948; -- increase pool: MASTER Herbs Silithus zone 1377 ( by 5) +UPDATE `pool_template` SET `max_limit`=75 WHERE `entry`=949; -- increase pool: MASTER Herbs Stonetalon Mountains zone 406 ( by 60) +UPDATE `pool_template` SET `max_limit`=55 WHERE `entry`=950; -- increase pool: MASTER Herbs Redridge Mountains zone 44 ( by 40) +UPDATE `pool_template` SET `max_limit`=80 WHERE `entry`=951; -- increase pool: MASTER Herbs Westfall zone 40 ( by 65) +UPDATE `pool_template` SET `max_limit`=55 WHERE `entry`=952; -- increase pool: MASTER Herbs Loch Modan zone 38 ( by 40) +UPDATE `pool_template` SET `max_limit`=45 WHERE `entry`=953; -- increase pool: MASTER Herbs Tirisfal Glades zone 85 ( by 30) +UPDATE `pool_template` SET `max_limit`=60 WHERE `entry`=954; -- increase pool: MASTER Herbs Western Plaguelands zone 28 ( by 45) +UPDATE `pool_template` SET `max_limit`=45 WHERE `entry`=955; -- increase pool: MASTER Herbs Mulgore zone 215 ( by 30) +UPDATE `pool_template` SET `max_limit`=60 WHERE `entry`=956; -- increase pool: MASTER Herbs Silverpine Forest zone 130 ( by 45) +UPDATE `pool_template` SET `max_limit`=35 WHERE `entry`=957; -- increase pool: MASTER Herbs Teldrassil zone 141 ( by 20) +UPDATE `pool_template` SET `max_limit`=70 WHERE `entry`=958; -- increase pool: MASTER Herbs Hillsbrad Foothills zone 267 ( by 55) +UPDATE `pool_template` SET `max_limit`=85 WHERE `entry`=959; -- increase pool: MASTER Herbs Arathi Highlands zone 45 ( by 120) +UPDATE `pool_template` SET `max_limit`=95 WHERE `entry`=960; -- increase pool: MASTER Herbs Ashenvale zone 331 ( by 105) +UPDATE `pool_template` SET `max_limit`=85 WHERE `entry`=961; -- increase pool: MASTER Herbs Darkshore zone 148 ( by 85) +UPDATE `pool_template` SET `max_limit`=35 WHERE `entry`=962; -- increase pool: MASTER Herbs Thousand Needles zone 400 ( by 20) +UPDATE `pool_template` SET `max_limit`=35 WHERE `entry`=963; -- increase pool: MASTER Herbs Tanaris zone 440 ( by 20) +UPDATE `pool_template` SET `max_limit`=65 WHERE `entry`=964; -- increase pool: MASTER Herbs Feralas zone 357 ( by 50) +UPDATE `pool_template` SET `max_limit`=90 WHERE `entry`=965; -- increase pool: MASTER Herbs Hinterlands zone 47 ( by 75) +UPDATE `pool_template` SET `max_limit`=75 WHERE `entry`=966; -- increase pool: MASTER Herbs Un'Goro Crater zone 490 ( by 60) +UPDATE `pool_template` SET `max_limit`=75 WHERE `entry`=967; -- increase pool: MASTER Herbs Winterspring zone 618 ( by 60) +UPDATE `pool_template` SET `max_limit`=90 WHERE `entry`=968; -- increase pool: MASTER Herbs Eastern Plaguelands zone 139 ( by 110) +UPDATE `pool_template` SET `max_limit`=30 WHERE `entry`=969; -- increase pool: MASTER Herbs Ghostlands zone 3433 ( by 15) +UPDATE `pool_template` SET `max_limit`=40 WHERE `entry`=970; -- increase pool: MASTER Herbs Eversong Woods zone 3430 ( by 25) +UPDATE `pool_template` SET `max_limit`=30 WHERE `entry`=971; -- increase pool: MASTER Herbs Azuremyst Isle zone 3524 ( by 15) +UPDATE `pool_template` SET `max_limit`=60 WHERE `entry`=972; -- increase pool: MASTER Herbs Hellfire Peninsula zone 3483 ( by 45) +UPDATE `pool_template` SET `max_limit`=40 WHERE `entry`=973; -- increase pool: MASTER Herbs Nagrand zone 3518 ( by 25) +UPDATE `pool_template` SET `max_limit`=40 WHERE `entry`=974; -- increase pool: MASTER Herbs Netherstorm zone 3523 ( by 25) +UPDATE `pool_template` SET `max_limit`=95 WHERE `entry`=975; -- increase pool: MASTER Herbs Zangarmarsh zone 3521 ( by 80) +UPDATE `pool_template` SET `max_limit`=45 WHERE `entry`=976; -- increase pool: MASTER Herbs Shadowmoon Valley zone 3520 ( by 30) +UPDATE `pool_template` SET `max_limit`=65 WHERE `entry`=977; -- increase pool: MASTER Herbs Terokkar Forest zone 3519 ( by 50) +UPDATE `pool_template` SET `max_limit`=35 WHERE `entry`=978; -- increase pool: MASTER Herbs Blade's Edge Mountains zone 3522 ( by 20) +UPDATE `pool_template` SET `max_limit`=40 WHERE `entry`=980; -- increase pool: MASTER Herbs Icecrown zone 210 ( by 25) +UPDATE `pool_template` SET `max_limit`=35 WHERE `entry`=981; -- increase pool: MASTER Herbs Storm Peaks zone 67 ( by 20) +UPDATE `pool_template` SET `max_limit`=40 WHERE `entry`=982; -- increase pool: MASTER Herbs Sholazar Basin zone 3711 ( by 25) +UPDATE `pool_template` SET `max_limit`=40 WHERE `entry`=983; -- increase pool: MASTER Herbs Zul'drak zone 66 ( by 25) +UPDATE `pool_template` SET `max_limit`=20 WHERE `entry`=984; -- increase pool: MASTER Herbs Grizzly Hills zone 394 ( by 5) +UPDATE `pool_template` SET `max_limit`=35 WHERE `entry`=985; -- increase pool: MASTER Herbs Dragonblight zone 65 ( by 20) +UPDATE `pool_template` SET `max_limit`=30 WHERE `entry`=986; -- increase pool: MASTER Herbs Howling Fjord zone 495 ( by 15) +UPDATE `pool_template` SET `max_limit`=25 WHERE `entry`=987; -- increase pool: MASTER Herbs Borean Tundra zone 3537 ( by 10) +UPDATE `pool_template` SET `max_limit`=100 WHERE `entry`=988; -- increase pool: MASTER Herbs Stranglethorn Vale zone 33 ( by 165) +UPDATE `pool_template` SET `max_limit`=85 WHERE `entry`=990; -- increase pool: MASTER Herbs Azshara zone 16 ( by 115) +UPDATE `pool_template` SET `max_limit`=25 WHERE `entry`=991; -- increase pool: MASTER Herbs Dustwallow Marsh zone 15 ( by 10) +UPDATE `pool_template` SET `max_limit`=75 WHERE `entry`=992; -- increase pool: MASTER Herbs Durotar zone 14 ( by 60) +UPDATE `pool_template` SET `max_limit`=40 WHERE `entry`=993; -- increase pool: MASTER Herbs Elwynn Forest zone 12 ( by 25) +UPDATE `pool_template` SET `max_limit`=90 WHERE `entry`=994; -- increase pool: MASTER Herbs Wetlands zone 11 ( by 85) +UPDATE `pool_template` SET `max_limit`=80 WHERE `entry`=995; -- increase pool: MASTER Herbs Duskwood zone 10 ( by 65) +UPDATE `pool_template` SET `max_limit`=85 WHERE `entry`=996; -- increase pool: MASTER Herbs Swamp of Sorrows zone 8 ( by 85) +UPDATE `pool_template` SET `max_limit`=30 WHERE `entry`=997; -- increase pool: MASTER Herbs Blasted Lands zone 4 ( by 15) +UPDATE `pool_template` SET `max_limit`=45 WHERE `entry`=998; -- increase pool: MASTER Herbs Badlands zone 3 ( by 30) +UPDATE `pool_template` SET `max_limit`=40 WHERE `entry`=999; -- increase pool: MASTER Herbs Dun Morogh zone 1 ( by 25) |