From 463f831b29c392fc98ea778f7781d41df7a87349 Mon Sep 17 00:00:00 2001 From: ZxBiohazardZx Date: Fri, 20 May 2011 23:26:39 +0200 Subject: DB/Pools: Adding pool for herbs in Desolace --- sql/updates/world/2011_05_20_03_pool_template.sql | 264 --------------------- .../world/2011_05_20_03_world_pool_template.sql | 264 +++++++++++++++++++++ .../world/2011_05_20_04_world_pool_template.sql | 188 +++++++++++++++ 3 files changed, 452 insertions(+), 264 deletions(-) delete mode 100644 sql/updates/world/2011_05_20_03_pool_template.sql create mode 100644 sql/updates/world/2011_05_20_03_world_pool_template.sql create mode 100644 sql/updates/world/2011_05_20_04_world_pool_template.sql (limited to 'sql') diff --git a/sql/updates/world/2011_05_20_03_pool_template.sql b/sql/updates/world/2011_05_20_03_pool_template.sql deleted file mode 100644 index 77a3545d16a..00000000000 --- a/sql/updates/world/2011_05_20_03_pool_template.sql +++ /dev/null @@ -1,264 +0,0 @@ -SET @Rest := 814; -- Leftover area (49 nodes) -SET @Area361 := @Rest+1; -- Area 361 (85 nodes) -SET @Area1763 := @Rest+2; -- Area 1763 (19 nodes) -SET @Area1766 := @Rest+3; -- Area 1766 (17 nodes) -SET @Area1767 := @Rest+4; -- Area 1767 (45 nodes) -SET @Area2481 := @Rest+5; -- Area 2481 (13 nodes) -SET @Area2618 := @Rest+6; -- Area 2618 (14 nodes) - -DELETE FROM `pool_template` WHERE `entry` BETWEEN @Rest AND @Rest+6 ; -INSERT INTO `pool_template` (`entry`,`max_limit`,`description`) VALUES -(@Rest ,10, 'Master Herbs Zone 361 Leftover Areas (10 out of 49 nodes)'), -(@Area361,17, 'Master Herbs Zone 361 Area 361 (17 out of 85 nodes)'), -(@Area1763,4, 'Master Herbs Zone 361 Area 1763 (4 out of 19 nodes)'), -(@Area1766,3, 'Master Herbs Zone 361 Area 1766 (3 out of 17 nodes)'), -(@Area1767,9, 'Master Herbs Zone 361 Area 1767 (9 out of 45 nodes)'), -(@Area2481,9, 'Master Herbs Zone 361 Area 2481 (3 out of 13 nodes)'), -(@Area2618,9, 'Master Herbs Zone 361 Area 2618 (3 out of 14 nodes)'); - -DELETE FROM `pool_gameobject` WHERE `pool_entry` BETWEEN @REST AND @REST+6 ; -INSERT INTO `pool_gameobject` (`guid`,`pool_entry`,`chance`,`description`) VALUES --- Nodes are numbered based on GUID, comment shows area and type --- Pooled per area for more randomness -(15955,@Area361,0,'Arthas Tears,Zone 361,Area 361,node 3'), -(15964,@Area361,0,'Arthas Tears,Zone 361,Area 361,node 6'), -(15965,@Area361,0,'Arthas Tears,Zone 361,Area 361,node 7'), -(15981,@Area361,0,'Arthas Tears,Zone 361,Area 361,node 10'), -(16004,@Area361,0,'Arthas Tears,Zone 361,Area 361,node 14'), -(16006,@Area361,0,'Arthas Tears,Zone 361,Area 361,node 15'), -(16020,@Area361,0,'Arthas Tears,Zone 361,Area 361,node 20'), -(16023,@Area361,0,'Arthas Tears,Zone 361,Area 361,node 21'), -(16024,@Area361,0,'Arthas Tears,Zone 361,Area 361,node 22'), -(16031,@Area361,0,'Sungrass,Zone 361,Area 361,node 24'), -(16062,@Area361,0,'Sungrass,Zone 361,Area 361,node 25'), -(16073,@Area361,0,'Sungrass,Zone 361,Area 361,node 26'), -(16074,@Area361,0,'Sungrass,Zone 361,Area 361,node 27'), -(16091,@Area361,0,'Sungrass,Zone 361,Area 361,node 29'), -(16156,@Area361,0,'Sungrass,Zone 361,Area 361,node 31'), -(16177,@Area361,0,'Sungrass,Zone 361,Area 361,node 33'), -(16259,@Area361,0,'Sungrass,Zone 361,Area 361,node 36'), -(16451,@Area361,0,'Gromsblood,Zone 361,Area 361,node 39'), -(16452,@Area361,0,'Gromsblood,Zone 361,Area 361,node 40'), -(16455,@Area361,0,'Gromsblood,Zone 361,Area 361,node 41'), -(16459,@Area361,0,'Gromsblood,Zone 361,Area 361,node 42'), -(16460,@Area361,0,'Gromsblood,Zone 361,Area 361,node 43'), -(16461,@Area361,0,'Gromsblood,Zone 361,Area 361,node 44'), -(16466,@Area361,0,'Gromsblood,Zone 361,Area 361,node 46'), -(16467,@Area361,0,'Gromsblood,Zone 361,Area 361,node 47'), -(16469,@Area361,0,'Gromsblood,Zone 361,Area 361,node 49'), -(16471,@Area361,0,'Gromsblood,Zone 361,Area 361,node 51'), -(16483,@Area361,0,'Gromsblood,Zone 361,Area 361,node 55'), -(16484,@Area361,0,'Gromsblood,Zone 361,Area 361,node 56'), -(16485,@Area361,0,'Gromsblood,Zone 361,Area 361,node 57'), -(16487,@Area361,0,'Gromsblood,Zone 361,Area 361,node 59'), -(16492,@Area361,0,'Gromsblood,Zone 361,Area 361,node 64'), -(16493,@Area361,0,'Gromsblood,Zone 361,Area 361,node 65'), -(16494,@Area361,0,'Gromsblood,Zone 361,Area 361,node 66'), -(16495,@Area361,0,'Gromsblood,Zone 361,Area 361,node 67'), -(16496,@Area361,0,'Gromsblood,Zone 361,Area 361,node 68'), -(16505,@Area361,0,'Gromsblood,Zone 361,Area 361,node 71'), -(16507,@Area361,0,'Gromsblood,Zone 361,Area 361,node 73'), -(16508,@Area361,0,'Gromsblood,Zone 361,Area 361,node 74'), -(16509,@Area361,0,'Gromsblood,Zone 361,Area 361,node 75'), -(16512,@Area361,0,'Gromsblood,Zone 361,Area 361,node 76'), -(16514,@Area361,0,'Gromsblood,Zone 361,Area 361,node 78'), -(16516,@Area361,0,'Gromsblood,Zone 361,Area 361,node 79'), -(16520,@Area361,0,'Gromsblood,Zone 361,Area 361,node 82'), -(16525,@Area361,0,'Gromsblood,Zone 361,Area 361,node 85'), -(16528,@Area361,0,'Gromsblood,Zone 361,Area 361,node 86'), -(16532,@Area361,0,'Gromsblood,Zone 361,Area 361,node 89'), -(16542,@Area361,0,'Gromsblood,Zone 361,Area 361,node 92'), -(18966,@Area361,0,'Golden Sansam,Zone 361,Area 361,node 97'), -(18975,@Area361,0,'Golden Sansam,Zone 361,Area 361,node 99'), -(19002,@Area361,0,'Golden Sansam,Zone 361,Area 361,node 103'), -(19028,@Area361,0,'Golden Sansam,Zone 361,Area 361,node 104'), -(19036,@Area361,0,'Golden Sansam,Zone 361,Area 361,node 105'), -(19253,@Area361,0,'Golden Sansam,Zone 361,Area 361,node 124'), -(19276,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 125'), -(19307,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 126'), -(19360,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 130'), -(19377,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 131'), -(19379,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 132'), -(19382,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 135'), -(19409,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 138'), -(19412,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 139'), -(19447,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 144'), -(19459,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 148'), -(19461,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 149'), -(19462,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 150'), -(19463,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 151'), -(19486,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 154'), -(19521,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 159'), -(19545,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 161'), -(19561,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 165'), -(19562,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 166'), -(19623,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 172'), -(19631,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 173'), -(19655,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 177'), -(19892,@Area361,0,'Plaguebloom,Zone 361,Area 361,node 183'), -(19945,@Area361,0,'Plaguebloom,Zone 361,Area 361,node 193'), -(20005,@Area361,0,'Plaguebloom,Zone 361,Area 361,node 208'), -(20037,@Area361,0,'Plaguebloom,Zone 361,Area 361,node 220'), -(20039,@Area361,0,'Plaguebloom,Zone 361,Area 361,node 222'), -(20066,@Area361,0,'Plaguebloom,Zone 361,Area 361,node 231'), -(20067,@Area361,0,'Plaguebloom,Zone 361,Area 361,node 232'), -(20068,@Area361,0,'Plaguebloom,Zone 361,Area 361,node 233'), -(20076,@Area361,0,'Plaguebloom,Zone 361,Area 361,node 234'), -(20131,@Area361,0,'Plaguebloom,Zone 361,Area 361,node 242'), -(16473,@Rest,0,'Gromsblood,Zone 361,Area 1761,node 52'), -(16530,@Rest,0,'Gromsblood,Zone 361,Area 1761,node 88'), -(19098,@Rest,0,'Golden Sansam,Zone 361,Area 1761,node 110'), -(19997,@Rest,0,'Plaguebloom,Zone 361,Area 1761,node 206'), -(19998,@Rest,0,'Plaguebloom,Zone 361,Area 1761,node 207'), -(20078,@Rest,0,'Plaguebloom,Zone 361,Area 1761,node 235'), -(16535,@Rest,0,'Gromsblood,Zone 361,Area 1762,node 90'), -(18986,@Rest,0,'Golden Sansam,Zone 361,Area 1762,node 100'), -(19043,@Rest,0,'Golden Sansam,Zone 361,Area 1762,node 106'), -(19070,@Rest,0,'Golden Sansam,Zone 361,Area 1762,node 108'), -(19575,@Rest,0,'Dreamfoil,Zone 361,Area 1762,node 169'), -(19576,@Rest,0,'Dreamfoil,Zone 361,Area 1762,node 170'), -(19827,@Rest,0,'Mountain Silversage,Zone 361,Area 1762,node 179'), -(20098,@Rest,0,'Plaguebloom,Zone 361,Area 1762,node 238'), -(15953,@Area1763,0,'Arthas Tears,Zone 361,Area 1763,node 1'), -(15960,@Area1763,0,'Arthas Tears,Zone 361,Area 1763,node 4'), -(15976,@Area1763,0,'Arthas Tears,Zone 361,Area 1763,node 8'), -(15978,@Area1763,0,'Arthas Tears,Zone 361,Area 1763,node 9'), -(16018,@Area1763,0,'Arthas Tears,Zone 361,Area 1763,node 19'), -(16157,@Area1763,0,'Sungrass,Zone 361,Area 1763,node 32'), -(16203,@Area1763,0,'Sungrass,Zone 361,Area 1763,node 34'), -(16474,@Area1763,0,'Gromsblood,Zone 361,Area 1763,node 53'), -(16480,@Area1763,0,'Gromsblood,Zone 361,Area 1763,node 54'), -(16500,@Area1763,0,'Gromsblood,Zone 361,Area 1763,node 69'), -(16524,@Area1763,0,'Gromsblood,Zone 361,Area 1763,node 84'), -(16536,@Area1763,0,'Gromsblood,Zone 361,Area 1763,node 91'), -(19001,@Area1763,0,'Golden Sansam,Zone 361,Area 1763,node 102'), -(19111,@Area1763,0,'Golden Sansam,Zone 361,Area 1763,node 112'), -(19154,@Area1763,0,'Golden Sansam,Zone 361,Area 1763,node 117'), -(19380,@Area1763,0,'Dreamfoil,Zone 361,Area 1763,node 133'), -(19580,@Area1763,0,'Dreamfoil,Zone 361,Area 1763,node 171'), -(19660,@Area1763,0,'Dreamfoil,Zone 361,Area 1763,node 178'), -(19985,@Area1763,0,'Plaguebloom,Zone 361,Area 1763,node 204'), -(16513,@Rest,0,'Gromsblood,Zone 361,Area 1764,node 77'), -(16518,@Rest,0,'Gromsblood,Zone 361,Area 1764,node 80'), -(16519,@Rest,0,'Gromsblood,Zone 361,Area 1764,node 81'), -(16522,@Rest,0,'Gromsblood,Zone 361,Area 1764,node 83'), -(16529,@Rest,0,'Gromsblood,Zone 361,Area 1764,node 87'), -(19381,@Rest,0,'Dreamfoil,Zone 361,Area 1765,node 134'), -(19635,@Rest,0,'Dreamfoil,Zone 361,Area 1765,node 174'), -(20040,@Rest,0,'Plaguebloom,Zone 361,Area 1765,node 223'), -(15995,@Area1766,0,'Arthas Tears,Zone 361,Area 1766,node 11'), -(16009,@Area1766,0,'Arthas Tears,Zone 361,Area 1766,node 16'), -(16016,@Area1766,0,'Arthas Tears,Zone 361,Area 1766,node 18'), -(16231,@Area1766,0,'Sungrass,Zone 361,Area 1766,node 35'), -(18998,@Area1766,0,'Golden Sansam,Zone 361,Area 1766,node 101'), -(19399,@Area1766,0,'Dreamfoil,Zone 361,Area 1766,node 137'), -(19500,@Area1766,0,'Dreamfoil,Zone 361,Area 1766,node 157'), -(19962,@Area1766,0,'Plaguebloom,Zone 361,Area 1766,node 198'), -(19964,@Area1766,0,'Plaguebloom,Zone 361,Area 1766,node 199'), -(19983,@Area1766,0,'Plaguebloom,Zone 361,Area 1766,node 202'), -(20022,@Area1766,0,'Plaguebloom,Zone 361,Area 1766,node 216'), -(20023,@Area1766,0,'Plaguebloom,Zone 361,Area 1766,node 217'), -(20024,@Area1766,0,'Plaguebloom,Zone 361,Area 1766,node 218'), -(20048,@Area1766,0,'Plaguebloom,Zone 361,Area 1766,node 224'), -(20049,@Area1766,0,'Plaguebloom,Zone 361,Area 1766,node 225'), -(20050,@Area1766,0,'Plaguebloom,Zone 361,Area 1766,node 226'), -(20095,@Area1766,0,'Plaguebloom,Zone 361,Area 1766,node 237'), -(15962,@Area1767,0,'Arthas Tears,Zone 361,Area 1767,node 5'), -(16025,@Area1767,0,'Arthas Tears,Zone 361,Area 1767,node 23'), -(16284,@Area1767,0,'Sungrass,Zone 361,Area 1767,node 37'), -(16285,@Area1767,0,'Sungrass,Zone 361,Area 1767,node 38'), -(18948,@Area1767,0,'Golden Sansam,Zone 361,Area 1767,node 95'), -(19076,@Area1767,0,'Golden Sansam,Zone 361,Area 1767,node 109'), -(19106,@Area1767,0,'Golden Sansam,Zone 361,Area 1767,node 111'), -(19130,@Area1767,0,'Golden Sansam,Zone 361,Area 1767,node 114'), -(19131,@Area1767,0,'Golden Sansam,Zone 361,Area 1767,node 115'), -(19132,@Area1767,0,'Golden Sansam,Zone 361,Area 1767,node 116'), -(19167,@Area1767,0,'Golden Sansam,Zone 361,Area 1767,node 118'), -(19177,@Area1767,0,'Golden Sansam,Zone 361,Area 1767,node 119'), -(19187,@Area1767,0,'Golden Sansam,Zone 361,Area 1767,node 120'), -(19236,@Area1767,0,'Golden Sansam,Zone 361,Area 1767,node 122'), -(19391,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 136'), -(19413,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 140'), -(19432,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 143'), -(19449,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 145'), -(19450,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 146'), -(19451,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 147'), -(19485,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 153'), -(19487,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 155'), -(19515,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 158'), -(19539,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 160'), -(19546,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 162'), -(19547,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 163'), -(19572,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 167'), -(19574,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 168'), -(19638,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 175'), -(19651,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 176'), -(19917,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 187'), -(19959,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 196'), -(19965,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 200'), -(19974,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 201'), -(19984,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 203'), -(20006,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 209'), -(20007,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 210'), -(20008,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 211'), -(20009,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 212'), -(20052,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 227'), -(20065,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 230'), -(20090,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 236'), -(20106,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 239'), -(20107,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 240'), -(20117,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 241'), -(16501,@Rest,0,'Gromsblood,Zone 361,Area 1769,node 70'), -(16543,@Rest,0,'Gromsblood,Zone 361,Area 1769,node 93'), -(18967,@Rest,0,'Golden Sansam,Zone 361,Area 1998,node 98'), -(19118,@Rest,0,'Golden Sansam,Zone 361,Area 1998,node 113'), -(19414,@Rest,0,'Dreamfoil,Zone 361,Area 1998,node 141'), -(19415,@Rest,0,'Dreamfoil,Zone 361,Area 1998,node 142'), -(19878,@Rest,0,'Plaguebloom,Zone 361,Area 1998,node 180'), -(19879,@Rest,0,'Plaguebloom,Zone 361,Area 1998,node 181'), -(19919,@Rest,0,'Plaguebloom,Zone 361,Area 1998,node 188'), -(19961,@Rest,0,'Plaguebloom,Zone 361,Area 1998,node 197'), -(15997,@Rest,0,'Arthas Tears,Zone 361,Area 2478,node 12'), -(16489,@Rest,0,'Gromsblood,Zone 361,Area 2478,node 61'), -(19231,@Rest,0,'Golden Sansam,Zone 361,Area 2478,node 121'), -(19317,@Rest,0,'Dreamfoil,Zone 361,Area 2478,node 127'), -(19347,@Rest,0,'Dreamfoil,Zone 361,Area 2478,node 129'), -(19930,@Rest,0,'Plaguebloom,Zone 361,Area 2478,node 192'), -(19995,@Rest,0,'Plaguebloom,Zone 361,Area 2478,node 205'), -(20019,@Rest,0,'Plaguebloom,Zone 361,Area 2478,node 213'), -(20020,@Rest,0,'Plaguebloom,Zone 361,Area 2478,node 214'), -(20021,@Rest,0,'Plaguebloom,Zone 361,Area 2478,node 215'), -(19950,@Rest,0,'Plaguebloom,Zone 361,Area 2479,node 194'), -(19951,@Rest,0,'Plaguebloom,Zone 361,Area 2479,node 195'), -(16154,@Rest,0,'Sungrass,Zone 361,Area 2480,node 30'), -(19239,@Rest,0,'Golden Sansam,Zone 361,Area 2480,node 123'), -(19927,@Rest,0,'Plaguebloom,Zone 361,Area 2480,node 190'), -(19928,@Rest,0,'Plaguebloom,Zone 361,Area 2480,node 191'), -(20053,@Rest,0,'Plaguebloom,Zone 361,Area 2480,node 228'), -(16468,@Area2481,0,'Gromsblood,Zone 361,Area 2481,node 48'), -(16486,@Area2481,0,'Gromsblood,Zone 361,Area 2481,node 58'), -(16488,@Area2481,0,'Gromsblood,Zone 361,Area 2481,node 60'), -(16490,@Area2481,0,'Gromsblood,Zone 361,Area 2481,node 62'), -(16491,@Area2481,0,'Gromsblood,Zone 361,Area 2481,node 63'), -(18965,@Area2481,0,'Golden Sansam,Zone 361,Area 2481,node 96'), -(19471,@Area2481,0,'Dreamfoil,Zone 361,Area 2481,node 152'), -(19907,@Area2481,0,'Plaguebloom,Zone 361,Area 2481,node 184'), -(19908,@Area2481,0,'Plaguebloom,Zone 361,Area 2481,node 185'), -(19909,@Area2481,0,'Plaguebloom,Zone 361,Area 2481,node 186'), -(19926,@Area2481,0,'Plaguebloom,Zone 361,Area 2481,node 189'), -(20036,@Area2481,0,'Plaguebloom,Zone 361,Area 2481,node 219'), -(20038,@Area2481,0,'Plaguebloom,Zone 361,Area 2481,node 221'), -(15954,@Area2618,0,'Arthas Tears,Zone 361,Area 2618,node2'), -(16000,@Area2618,0,'Arthas Tears,Zone 361,Area 2618,node 13'), -(16010,@Area2618,0,'Arthas Tears,Zone 361,Area 2618,node 17'), -(16088,@Area2618,0,'Sungrass,Zone 361,Area 2618,node 28'), -(16465,@Area2618,0,'Gromsblood,Zone 361,Area 2618,node 45'), -(16470,@Area2618,0,'Gromsblood,Zone 361,Area 2618,node 50'), -(16506,@Area2618,0,'Gromsblood,Zone 361,Area 2618,node 72'), -(16545,@Area2618,0,'Gromsblood,Zone 361,Area 2618,node 94'), -(19055,@Area2618,0,'Golden Sansam,Zone 361,Area 2618,node 107'), -(19320,@Area2618,0,'Dreamfoil,Zone 361,Area 2618,node 128'), -(19488,@Area2618,0,'Dreamfoil,Zone 361,Area 2618,node 156'), -(19557,@Area2618,0,'Dreamfoil,Zone 361,Area 2618,node 164'), -(19888,@Area2618,0,'Plaguebloom,Zone 361,Area 2618,node 182'), -(20061,@Area2618,0,'Plaguebloom,Zone 361,Area 2618,node 229'); diff --git a/sql/updates/world/2011_05_20_03_world_pool_template.sql b/sql/updates/world/2011_05_20_03_world_pool_template.sql new file mode 100644 index 00000000000..77a3545d16a --- /dev/null +++ b/sql/updates/world/2011_05_20_03_world_pool_template.sql @@ -0,0 +1,264 @@ +SET @Rest := 814; -- Leftover area (49 nodes) +SET @Area361 := @Rest+1; -- Area 361 (85 nodes) +SET @Area1763 := @Rest+2; -- Area 1763 (19 nodes) +SET @Area1766 := @Rest+3; -- Area 1766 (17 nodes) +SET @Area1767 := @Rest+4; -- Area 1767 (45 nodes) +SET @Area2481 := @Rest+5; -- Area 2481 (13 nodes) +SET @Area2618 := @Rest+6; -- Area 2618 (14 nodes) + +DELETE FROM `pool_template` WHERE `entry` BETWEEN @Rest AND @Rest+6 ; +INSERT INTO `pool_template` (`entry`,`max_limit`,`description`) VALUES +(@Rest ,10, 'Master Herbs Zone 361 Leftover Areas (10 out of 49 nodes)'), +(@Area361,17, 'Master Herbs Zone 361 Area 361 (17 out of 85 nodes)'), +(@Area1763,4, 'Master Herbs Zone 361 Area 1763 (4 out of 19 nodes)'), +(@Area1766,3, 'Master Herbs Zone 361 Area 1766 (3 out of 17 nodes)'), +(@Area1767,9, 'Master Herbs Zone 361 Area 1767 (9 out of 45 nodes)'), +(@Area2481,9, 'Master Herbs Zone 361 Area 2481 (3 out of 13 nodes)'), +(@Area2618,9, 'Master Herbs Zone 361 Area 2618 (3 out of 14 nodes)'); + +DELETE FROM `pool_gameobject` WHERE `pool_entry` BETWEEN @REST AND @REST+6 ; +INSERT INTO `pool_gameobject` (`guid`,`pool_entry`,`chance`,`description`) VALUES +-- Nodes are numbered based on GUID, comment shows area and type +-- Pooled per area for more randomness +(15955,@Area361,0,'Arthas Tears,Zone 361,Area 361,node 3'), +(15964,@Area361,0,'Arthas Tears,Zone 361,Area 361,node 6'), +(15965,@Area361,0,'Arthas Tears,Zone 361,Area 361,node 7'), +(15981,@Area361,0,'Arthas Tears,Zone 361,Area 361,node 10'), +(16004,@Area361,0,'Arthas Tears,Zone 361,Area 361,node 14'), +(16006,@Area361,0,'Arthas Tears,Zone 361,Area 361,node 15'), +(16020,@Area361,0,'Arthas Tears,Zone 361,Area 361,node 20'), +(16023,@Area361,0,'Arthas Tears,Zone 361,Area 361,node 21'), +(16024,@Area361,0,'Arthas Tears,Zone 361,Area 361,node 22'), +(16031,@Area361,0,'Sungrass,Zone 361,Area 361,node 24'), +(16062,@Area361,0,'Sungrass,Zone 361,Area 361,node 25'), +(16073,@Area361,0,'Sungrass,Zone 361,Area 361,node 26'), +(16074,@Area361,0,'Sungrass,Zone 361,Area 361,node 27'), +(16091,@Area361,0,'Sungrass,Zone 361,Area 361,node 29'), +(16156,@Area361,0,'Sungrass,Zone 361,Area 361,node 31'), +(16177,@Area361,0,'Sungrass,Zone 361,Area 361,node 33'), +(16259,@Area361,0,'Sungrass,Zone 361,Area 361,node 36'), +(16451,@Area361,0,'Gromsblood,Zone 361,Area 361,node 39'), +(16452,@Area361,0,'Gromsblood,Zone 361,Area 361,node 40'), +(16455,@Area361,0,'Gromsblood,Zone 361,Area 361,node 41'), +(16459,@Area361,0,'Gromsblood,Zone 361,Area 361,node 42'), +(16460,@Area361,0,'Gromsblood,Zone 361,Area 361,node 43'), +(16461,@Area361,0,'Gromsblood,Zone 361,Area 361,node 44'), +(16466,@Area361,0,'Gromsblood,Zone 361,Area 361,node 46'), +(16467,@Area361,0,'Gromsblood,Zone 361,Area 361,node 47'), +(16469,@Area361,0,'Gromsblood,Zone 361,Area 361,node 49'), +(16471,@Area361,0,'Gromsblood,Zone 361,Area 361,node 51'), +(16483,@Area361,0,'Gromsblood,Zone 361,Area 361,node 55'), +(16484,@Area361,0,'Gromsblood,Zone 361,Area 361,node 56'), +(16485,@Area361,0,'Gromsblood,Zone 361,Area 361,node 57'), +(16487,@Area361,0,'Gromsblood,Zone 361,Area 361,node 59'), +(16492,@Area361,0,'Gromsblood,Zone 361,Area 361,node 64'), +(16493,@Area361,0,'Gromsblood,Zone 361,Area 361,node 65'), +(16494,@Area361,0,'Gromsblood,Zone 361,Area 361,node 66'), +(16495,@Area361,0,'Gromsblood,Zone 361,Area 361,node 67'), +(16496,@Area361,0,'Gromsblood,Zone 361,Area 361,node 68'), +(16505,@Area361,0,'Gromsblood,Zone 361,Area 361,node 71'), +(16507,@Area361,0,'Gromsblood,Zone 361,Area 361,node 73'), +(16508,@Area361,0,'Gromsblood,Zone 361,Area 361,node 74'), +(16509,@Area361,0,'Gromsblood,Zone 361,Area 361,node 75'), +(16512,@Area361,0,'Gromsblood,Zone 361,Area 361,node 76'), +(16514,@Area361,0,'Gromsblood,Zone 361,Area 361,node 78'), +(16516,@Area361,0,'Gromsblood,Zone 361,Area 361,node 79'), +(16520,@Area361,0,'Gromsblood,Zone 361,Area 361,node 82'), +(16525,@Area361,0,'Gromsblood,Zone 361,Area 361,node 85'), +(16528,@Area361,0,'Gromsblood,Zone 361,Area 361,node 86'), +(16532,@Area361,0,'Gromsblood,Zone 361,Area 361,node 89'), +(16542,@Area361,0,'Gromsblood,Zone 361,Area 361,node 92'), +(18966,@Area361,0,'Golden Sansam,Zone 361,Area 361,node 97'), +(18975,@Area361,0,'Golden Sansam,Zone 361,Area 361,node 99'), +(19002,@Area361,0,'Golden Sansam,Zone 361,Area 361,node 103'), +(19028,@Area361,0,'Golden Sansam,Zone 361,Area 361,node 104'), +(19036,@Area361,0,'Golden Sansam,Zone 361,Area 361,node 105'), +(19253,@Area361,0,'Golden Sansam,Zone 361,Area 361,node 124'), +(19276,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 125'), +(19307,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 126'), +(19360,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 130'), +(19377,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 131'), +(19379,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 132'), +(19382,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 135'), +(19409,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 138'), +(19412,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 139'), +(19447,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 144'), +(19459,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 148'), +(19461,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 149'), +(19462,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 150'), +(19463,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 151'), +(19486,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 154'), +(19521,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 159'), +(19545,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 161'), +(19561,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 165'), +(19562,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 166'), +(19623,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 172'), +(19631,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 173'), +(19655,@Area361,0,'Dreamfoil,Zone 361,Area 361,node 177'), +(19892,@Area361,0,'Plaguebloom,Zone 361,Area 361,node 183'), +(19945,@Area361,0,'Plaguebloom,Zone 361,Area 361,node 193'), +(20005,@Area361,0,'Plaguebloom,Zone 361,Area 361,node 208'), +(20037,@Area361,0,'Plaguebloom,Zone 361,Area 361,node 220'), +(20039,@Area361,0,'Plaguebloom,Zone 361,Area 361,node 222'), +(20066,@Area361,0,'Plaguebloom,Zone 361,Area 361,node 231'), +(20067,@Area361,0,'Plaguebloom,Zone 361,Area 361,node 232'), +(20068,@Area361,0,'Plaguebloom,Zone 361,Area 361,node 233'), +(20076,@Area361,0,'Plaguebloom,Zone 361,Area 361,node 234'), +(20131,@Area361,0,'Plaguebloom,Zone 361,Area 361,node 242'), +(16473,@Rest,0,'Gromsblood,Zone 361,Area 1761,node 52'), +(16530,@Rest,0,'Gromsblood,Zone 361,Area 1761,node 88'), +(19098,@Rest,0,'Golden Sansam,Zone 361,Area 1761,node 110'), +(19997,@Rest,0,'Plaguebloom,Zone 361,Area 1761,node 206'), +(19998,@Rest,0,'Plaguebloom,Zone 361,Area 1761,node 207'), +(20078,@Rest,0,'Plaguebloom,Zone 361,Area 1761,node 235'), +(16535,@Rest,0,'Gromsblood,Zone 361,Area 1762,node 90'), +(18986,@Rest,0,'Golden Sansam,Zone 361,Area 1762,node 100'), +(19043,@Rest,0,'Golden Sansam,Zone 361,Area 1762,node 106'), +(19070,@Rest,0,'Golden Sansam,Zone 361,Area 1762,node 108'), +(19575,@Rest,0,'Dreamfoil,Zone 361,Area 1762,node 169'), +(19576,@Rest,0,'Dreamfoil,Zone 361,Area 1762,node 170'), +(19827,@Rest,0,'Mountain Silversage,Zone 361,Area 1762,node 179'), +(20098,@Rest,0,'Plaguebloom,Zone 361,Area 1762,node 238'), +(15953,@Area1763,0,'Arthas Tears,Zone 361,Area 1763,node 1'), +(15960,@Area1763,0,'Arthas Tears,Zone 361,Area 1763,node 4'), +(15976,@Area1763,0,'Arthas Tears,Zone 361,Area 1763,node 8'), +(15978,@Area1763,0,'Arthas Tears,Zone 361,Area 1763,node 9'), +(16018,@Area1763,0,'Arthas Tears,Zone 361,Area 1763,node 19'), +(16157,@Area1763,0,'Sungrass,Zone 361,Area 1763,node 32'), +(16203,@Area1763,0,'Sungrass,Zone 361,Area 1763,node 34'), +(16474,@Area1763,0,'Gromsblood,Zone 361,Area 1763,node 53'), +(16480,@Area1763,0,'Gromsblood,Zone 361,Area 1763,node 54'), +(16500,@Area1763,0,'Gromsblood,Zone 361,Area 1763,node 69'), +(16524,@Area1763,0,'Gromsblood,Zone 361,Area 1763,node 84'), +(16536,@Area1763,0,'Gromsblood,Zone 361,Area 1763,node 91'), +(19001,@Area1763,0,'Golden Sansam,Zone 361,Area 1763,node 102'), +(19111,@Area1763,0,'Golden Sansam,Zone 361,Area 1763,node 112'), +(19154,@Area1763,0,'Golden Sansam,Zone 361,Area 1763,node 117'), +(19380,@Area1763,0,'Dreamfoil,Zone 361,Area 1763,node 133'), +(19580,@Area1763,0,'Dreamfoil,Zone 361,Area 1763,node 171'), +(19660,@Area1763,0,'Dreamfoil,Zone 361,Area 1763,node 178'), +(19985,@Area1763,0,'Plaguebloom,Zone 361,Area 1763,node 204'), +(16513,@Rest,0,'Gromsblood,Zone 361,Area 1764,node 77'), +(16518,@Rest,0,'Gromsblood,Zone 361,Area 1764,node 80'), +(16519,@Rest,0,'Gromsblood,Zone 361,Area 1764,node 81'), +(16522,@Rest,0,'Gromsblood,Zone 361,Area 1764,node 83'), +(16529,@Rest,0,'Gromsblood,Zone 361,Area 1764,node 87'), +(19381,@Rest,0,'Dreamfoil,Zone 361,Area 1765,node 134'), +(19635,@Rest,0,'Dreamfoil,Zone 361,Area 1765,node 174'), +(20040,@Rest,0,'Plaguebloom,Zone 361,Area 1765,node 223'), +(15995,@Area1766,0,'Arthas Tears,Zone 361,Area 1766,node 11'), +(16009,@Area1766,0,'Arthas Tears,Zone 361,Area 1766,node 16'), +(16016,@Area1766,0,'Arthas Tears,Zone 361,Area 1766,node 18'), +(16231,@Area1766,0,'Sungrass,Zone 361,Area 1766,node 35'), +(18998,@Area1766,0,'Golden Sansam,Zone 361,Area 1766,node 101'), +(19399,@Area1766,0,'Dreamfoil,Zone 361,Area 1766,node 137'), +(19500,@Area1766,0,'Dreamfoil,Zone 361,Area 1766,node 157'), +(19962,@Area1766,0,'Plaguebloom,Zone 361,Area 1766,node 198'), +(19964,@Area1766,0,'Plaguebloom,Zone 361,Area 1766,node 199'), +(19983,@Area1766,0,'Plaguebloom,Zone 361,Area 1766,node 202'), +(20022,@Area1766,0,'Plaguebloom,Zone 361,Area 1766,node 216'), +(20023,@Area1766,0,'Plaguebloom,Zone 361,Area 1766,node 217'), +(20024,@Area1766,0,'Plaguebloom,Zone 361,Area 1766,node 218'), +(20048,@Area1766,0,'Plaguebloom,Zone 361,Area 1766,node 224'), +(20049,@Area1766,0,'Plaguebloom,Zone 361,Area 1766,node 225'), +(20050,@Area1766,0,'Plaguebloom,Zone 361,Area 1766,node 226'), +(20095,@Area1766,0,'Plaguebloom,Zone 361,Area 1766,node 237'), +(15962,@Area1767,0,'Arthas Tears,Zone 361,Area 1767,node 5'), +(16025,@Area1767,0,'Arthas Tears,Zone 361,Area 1767,node 23'), +(16284,@Area1767,0,'Sungrass,Zone 361,Area 1767,node 37'), +(16285,@Area1767,0,'Sungrass,Zone 361,Area 1767,node 38'), +(18948,@Area1767,0,'Golden Sansam,Zone 361,Area 1767,node 95'), +(19076,@Area1767,0,'Golden Sansam,Zone 361,Area 1767,node 109'), +(19106,@Area1767,0,'Golden Sansam,Zone 361,Area 1767,node 111'), +(19130,@Area1767,0,'Golden Sansam,Zone 361,Area 1767,node 114'), +(19131,@Area1767,0,'Golden Sansam,Zone 361,Area 1767,node 115'), +(19132,@Area1767,0,'Golden Sansam,Zone 361,Area 1767,node 116'), +(19167,@Area1767,0,'Golden Sansam,Zone 361,Area 1767,node 118'), +(19177,@Area1767,0,'Golden Sansam,Zone 361,Area 1767,node 119'), +(19187,@Area1767,0,'Golden Sansam,Zone 361,Area 1767,node 120'), +(19236,@Area1767,0,'Golden Sansam,Zone 361,Area 1767,node 122'), +(19391,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 136'), +(19413,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 140'), +(19432,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 143'), +(19449,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 145'), +(19450,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 146'), +(19451,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 147'), +(19485,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 153'), +(19487,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 155'), +(19515,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 158'), +(19539,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 160'), +(19546,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 162'), +(19547,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 163'), +(19572,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 167'), +(19574,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 168'), +(19638,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 175'), +(19651,@Area1767,0,'Dreamfoil,Zone 361,Area 1767,node 176'), +(19917,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 187'), +(19959,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 196'), +(19965,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 200'), +(19974,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 201'), +(19984,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 203'), +(20006,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 209'), +(20007,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 210'), +(20008,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 211'), +(20009,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 212'), +(20052,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 227'), +(20065,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 230'), +(20090,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 236'), +(20106,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 239'), +(20107,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 240'), +(20117,@Area1767,0,'Plaguebloom,Zone 361,Area 1767,node 241'), +(16501,@Rest,0,'Gromsblood,Zone 361,Area 1769,node 70'), +(16543,@Rest,0,'Gromsblood,Zone 361,Area 1769,node 93'), +(18967,@Rest,0,'Golden Sansam,Zone 361,Area 1998,node 98'), +(19118,@Rest,0,'Golden Sansam,Zone 361,Area 1998,node 113'), +(19414,@Rest,0,'Dreamfoil,Zone 361,Area 1998,node 141'), +(19415,@Rest,0,'Dreamfoil,Zone 361,Area 1998,node 142'), +(19878,@Rest,0,'Plaguebloom,Zone 361,Area 1998,node 180'), +(19879,@Rest,0,'Plaguebloom,Zone 361,Area 1998,node 181'), +(19919,@Rest,0,'Plaguebloom,Zone 361,Area 1998,node 188'), +(19961,@Rest,0,'Plaguebloom,Zone 361,Area 1998,node 197'), +(15997,@Rest,0,'Arthas Tears,Zone 361,Area 2478,node 12'), +(16489,@Rest,0,'Gromsblood,Zone 361,Area 2478,node 61'), +(19231,@Rest,0,'Golden Sansam,Zone 361,Area 2478,node 121'), +(19317,@Rest,0,'Dreamfoil,Zone 361,Area 2478,node 127'), +(19347,@Rest,0,'Dreamfoil,Zone 361,Area 2478,node 129'), +(19930,@Rest,0,'Plaguebloom,Zone 361,Area 2478,node 192'), +(19995,@Rest,0,'Plaguebloom,Zone 361,Area 2478,node 205'), +(20019,@Rest,0,'Plaguebloom,Zone 361,Area 2478,node 213'), +(20020,@Rest,0,'Plaguebloom,Zone 361,Area 2478,node 214'), +(20021,@Rest,0,'Plaguebloom,Zone 361,Area 2478,node 215'), +(19950,@Rest,0,'Plaguebloom,Zone 361,Area 2479,node 194'), +(19951,@Rest,0,'Plaguebloom,Zone 361,Area 2479,node 195'), +(16154,@Rest,0,'Sungrass,Zone 361,Area 2480,node 30'), +(19239,@Rest,0,'Golden Sansam,Zone 361,Area 2480,node 123'), +(19927,@Rest,0,'Plaguebloom,Zone 361,Area 2480,node 190'), +(19928,@Rest,0,'Plaguebloom,Zone 361,Area 2480,node 191'), +(20053,@Rest,0,'Plaguebloom,Zone 361,Area 2480,node 228'), +(16468,@Area2481,0,'Gromsblood,Zone 361,Area 2481,node 48'), +(16486,@Area2481,0,'Gromsblood,Zone 361,Area 2481,node 58'), +(16488,@Area2481,0,'Gromsblood,Zone 361,Area 2481,node 60'), +(16490,@Area2481,0,'Gromsblood,Zone 361,Area 2481,node 62'), +(16491,@Area2481,0,'Gromsblood,Zone 361,Area 2481,node 63'), +(18965,@Area2481,0,'Golden Sansam,Zone 361,Area 2481,node 96'), +(19471,@Area2481,0,'Dreamfoil,Zone 361,Area 2481,node 152'), +(19907,@Area2481,0,'Plaguebloom,Zone 361,Area 2481,node 184'), +(19908,@Area2481,0,'Plaguebloom,Zone 361,Area 2481,node 185'), +(19909,@Area2481,0,'Plaguebloom,Zone 361,Area 2481,node 186'), +(19926,@Area2481,0,'Plaguebloom,Zone 361,Area 2481,node 189'), +(20036,@Area2481,0,'Plaguebloom,Zone 361,Area 2481,node 219'), +(20038,@Area2481,0,'Plaguebloom,Zone 361,Area 2481,node 221'), +(15954,@Area2618,0,'Arthas Tears,Zone 361,Area 2618,node2'), +(16000,@Area2618,0,'Arthas Tears,Zone 361,Area 2618,node 13'), +(16010,@Area2618,0,'Arthas Tears,Zone 361,Area 2618,node 17'), +(16088,@Area2618,0,'Sungrass,Zone 361,Area 2618,node 28'), +(16465,@Area2618,0,'Gromsblood,Zone 361,Area 2618,node 45'), +(16470,@Area2618,0,'Gromsblood,Zone 361,Area 2618,node 50'), +(16506,@Area2618,0,'Gromsblood,Zone 361,Area 2618,node 72'), +(16545,@Area2618,0,'Gromsblood,Zone 361,Area 2618,node 94'), +(19055,@Area2618,0,'Golden Sansam,Zone 361,Area 2618,node 107'), +(19320,@Area2618,0,'Dreamfoil,Zone 361,Area 2618,node 128'), +(19488,@Area2618,0,'Dreamfoil,Zone 361,Area 2618,node 156'), +(19557,@Area2618,0,'Dreamfoil,Zone 361,Area 2618,node 164'), +(19888,@Area2618,0,'Plaguebloom,Zone 361,Area 2618,node 182'), +(20061,@Area2618,0,'Plaguebloom,Zone 361,Area 2618,node 229'); diff --git a/sql/updates/world/2011_05_20_04_world_pool_template.sql b/sql/updates/world/2011_05_20_04_world_pool_template.sql new file mode 100644 index 00000000000..58e62767263 --- /dev/null +++ b/sql/updates/world/2011_05_20_04_world_pool_template.sql @@ -0,0 +1,188 @@ +SET @Rest := 821; -- Leftover area (41 nodes) +SET @Area405 := @Rest+1; -- Area 405 (40 nodes) +SET @Area596 := @Rest+2; -- Area 596 (18 nodes) +SET @Area598 := @Rest+3; -- Area 598 (20 nodes) +SET @Area602 := @Rest+4; -- Area 602 (27 nodes) +SET @Area607 := @Rest+5; -- Area 607 (22 nodes) + +DELETE FROM `pool_template` WHERE `entry` BETWEEN @Rest AND @Rest+6 ; +INSERT INTO `pool_template` (`entry`,`max_limit`,`description`) VALUES +(@Rest ,10, 'Master Herbs Zone 405 Leftover Areas (10 out of 41 nodes)'), +(@Area405,8, 'Master Herbs Zone 405 Leftover Areas (8 out of 40 nodes)'), +(@Area596,4, 'Master Herbs Zone 405 Leftover Areas (4 out of 18 nodes)'), +(@Area598,5, 'Master Herbs Zone 405 Leftover Areas (5 out of 20 nodes)'), +(@Area602,5, 'Master Herbs Zone 405 Leftover Areas (5 out of 27 nodes)'), +(@Area607,5, 'Master Herbs Zone 405 Leftover Areas (5 out of 22 nodes)'); + +DELETE FROM `pool_gameobject` WHERE `pool_entry` BETWEEN @REST AND @REST+5 ; +INSERT INTO `pool_gameobject` (`guid`,`pool_entry`,`chance`,`description`) VALUES +-- node s are numbered based on GUID, comment shows area and type +-- Pooled per area for more randomness +(3126,@Area405,0,'Bruiseweed,Zone 405,405,node 14'), +(3196,@Area405,0,'Bruiseweed,Zone 405,405,node 16'), +(3197,@Area405,0,'Bruiseweed,Zone 405,405,node 17'), +(3198,@Area405,0,'Bruiseweed,Zone 405,405,node 18'), +(3393,@Area405,0,'Bruiseweed,Zone 405,405,node 25'), +(3588,@Area405,0,'Bruiseweed,Zone 405,405,node 32'), +(3707,@Area405,0,'Bruiseweed,Zone 405,405,node 36'), +(3814,@Area405,0,'Bruiseweed,Zone 405,405,node 44'), +(3939,@Area405,0,'Wild Steelbloom,Zone 405,405,node 47'), +(4200,@Area405,0,'Wild Steelbloom,Zone 405,405,node 51'), +(4206,@Area405,0,'Wild Steelbloom,Zone 405,405,node 52'), +(4226,@Area405,0,'Wild Steelbloom,Zone 405,405,node 53'), +(4251,@Area405,0,'Wild Steelbloom,Zone 405,405,node 54'), +(4286,@Area405,0,'Kingsblood,Zone 405,405,node 55'), +(4316,@Area405,0,'Kingsblood,Zone 405,405,node 56'), +(4334,@Area405,0,'Kingsblood,Zone 405,405,node 57'), +(4338,@Area405,0,'Kingsblood,Zone 405,405,node 58'), +(4340,@Area405,0,'Kingsblood,Zone 405,405,node 59'), +(4358,@Area405,0,'Kingsblood,Zone 405,405,node 60'), +(4389,@Area405,0,'Kingsblood,Zone 405,405,node 62'), +(4398,@Area405,0,'Kingsblood,Zone 405,405,node 63'), +(4400,@Area405,0,'Kingsblood,Zone 405,405,node 64'), +(7336,@Area405,0,'Liferoot,Zone 405,405,node 80'), +(7491,@Area405,0,'Liferoot,Zone 405,405,node 86'), +(16475,@Area405,0,'Gromsblood,Zone 405,405,node 112'), +(18619,@Area405,0,'Wild Steelbloom,Zone 405,405,node 126'), +(18624,@Area405,0,'Kingsblood,Zone 405,405,node 129'), +(18680,@Area405,0,'Grave Moss,Zone 405,405,node 133'), +(29185,@Area405,0,'Liferoot,Zone 405,405,node 135'), +(29186,@Area405,0,'Liferoot,Zone 405,405,node 136'), +(34170,@Area405,0,'Kingsblood,Zone 405,405,node 147'), +(63344,@Area405,0,'Bruiseweed,Zone 405,405,node 151'), +(63386,@Area405,0,'Kingsblood,Zone 405,405,node 152'), +(63410,@Area405,0,'Grave Moss,Zone 405,405,node 153'), +(65114,@Area405,0,'Kingsblood,Zone 405,405,node 155'), +(86317,@Area405,0,'Kingsblood,Zone 405,405,node 158'), +(86348,@Area405,0,'Grave Moss,Zone 405,405,node 160'), +(86827,@Area405,0,'Liferoot,Zone 405,405,node 162'), +(86835,@Area405,0,'Liferoot,Zone 405,405,node 163'), +(87282,@Area405,0,'Grave Moss,Zone 405,405,node 167'), +(4437,@Area596,0,'Grave Moss,Zone 405,596,node 65'), +(4441,@Area596,0,'Grave Moss,Zone 405,596,node 66'), +(4443,@Area596,0,'Grave Moss,Zone 405,596,node 67'), +(4451,@Area596,0,'Grave Moss,Zone 405,596,node 68'), +(4468,@Area596,0,'Grave Moss,Zone 405,596,node 69'), +(4476,@Area596,0,'Grave Moss,Zone 405,596,node 70'), +(4477,@Area596,0,'Grave Moss,Zone 405,596,node 71'), +(4481,@Area596,0,'Grave Moss,Zone 405,596,node 72'), +(4487,@Area596,0,'Grave Moss,Zone 405,596,node 73'), +(4489,@Area596,0,'Grave Moss,Zone 405,596,node 74'), +(4495,@Area596,0,'Grave Moss,Zone 405,596,node 75'), +(4499,@Area596,0,'Grave Moss,Zone 405,596,node 76'), +(4503,@Area596,0,'Grave Moss,Zone 405,596,node 77'), +(4505,@Area596,0,'Grave Moss,Zone 405,596,node 78'), +(4507,@Area596,0,'Grave Moss,Zone 405,596,node 79'), +(86350,@Area596,0,'Grave Moss,Zone 405,596,node 161'), +(87272,@Area596,0,'Kingsblood,Zone 405,596,node 165'), +(87483,@Area596,0,'Grave Moss,Zone 405,596,node 168'), +(4388,@Area598,0,'Kingsblood,Zone 405,598,node 61'), +(8252,@Area598,0,'Stranglekelp,Zone 405,598,node 87'), +(8257,@Area598,0,'Stranglekelp,Zone 405,598,node 88'), +(8258,@Area598,0,'Stranglekelp,Zone 405,598,node 89'), +(8326,@Area598,0,'Stranglekelp,Zone 405,598,node 91'), +(8340,@Area598,0,'Stranglekelp,Zone 405,598,node 92'), +(8352,@Area598,0,'Stranglekelp,Zone 405,598,node 93'), +(8357,@Area598,0,'Stranglekelp,Zone 405,598,node 94'), +(8397,@Area598,0,'Stranglekelp,Zone 405,598,node 95'), +(8398,@Area598,0,'Stranglekelp,Zone 405,598,node 96'), +(8503,@Area598,0,'Stranglekelp,Zone 405,598,node 99'), +(8528,@Area598,0,'Stranglekelp,Zone 405,598,node 100'), +(18620,@Area598,0,'Wild Steelbloom,Zone 405,598,node 127'), +(29195,@Area598,0,'Stranglekelp,Zone 405,598,node 138'), +(29198,@Area598,0,'Stranglekelp,Zone 405,598,node 139'), +(29199,@Area598,0,'Stranglekelp,Zone 405,598,node 140'), +(29201,@Area598,0,'Stranglekelp,Zone 405,598,node 142'), +(29202,@Area598,0,'Stranglekelp,Zone 405,598,node 143'), +(29203,@Area598,0,'Stranglekelp,Zone 405,598,node 144'), +(87274,@Area598,0,'Kingsblood,Zone 405,598,node 166'), +(2920,@Area602,0,'Bruiseweed,Zone 405,602,node 1'), +(2921,@Area602,0,'Bruiseweed,Zone 405,602,node 2'), +(2953,@Area602,0,'Bruiseweed,Zone 405,602,node 4'), +(3083,@Area602,0,'Bruiseweed,Zone 405,602,node 10'), +(3156,@Area602,0,'Bruiseweed,Zone 405,602,node 15'), +(3203,@Area602,0,'Bruiseweed,Zone 405,602,node 19'), +(3771,@Area602,0,'Bruiseweed,Zone 405,602,node 40'), +(3772,@Area602,0,'Bruiseweed,Zone 405,602,node 41'), +(3790,@Area602,0,'Bruiseweed,Zone 405,602,node 43'), +(7464,@Area602,0,'Liferoot,Zone 405,602,node 84'), +(7469,@Area602,0,'Liferoot,Zone 405,602,node 85'), +(16458,@Area602,0,'Gromsblood,Zone 405,602,node 110'), +(16464,@Area602,0,'Gromsblood,Zone 405,602,node 111'), +(16498,@Area602,0,'Gromsblood,Zone 405,602,node 113'), +(16502,@Area602,0,'Gromsblood,Zone 405,602,node 114'), +(16510,@Area602,0,'Gromsblood,Zone 405,602,node 115'), +(16523,@Area602,0,'Gromsblood,Zone 405,602,node 116'), +(16533,@Area602,0,'Gromsblood,Zone 405,602,node 117'), +(16537,@Area602,0,'Gromsblood,Zone 405,602,node 118'), +(16538,@Area602,0,'Gromsblood,Zone 405,602,node 119'), +(16539,@Area602,0,'Gromsblood,Zone 405,602,node 120'), +(16540,@Area602,0,'Gromsblood,Zone 405,602,node 121'), +(16541,@Area602,0,'Gromsblood,Zone 405,602,node 122'), +(16544,@Area602,0,'Gromsblood,Zone 405,602,node 123'), +(28646,@Area602,0,'Liferoot,Zone 405,602,node 134'), +(34831,@Area602,0,'Bruiseweed,Zone 405,602,node 150'), +(86143,@Area602,0,'Gromsblood,Zone 405,602,node 156'), +(2936,@Area607,0,'Bruiseweed,Zone 405,607,node 3'), +(2972,@Area607,0,'Bruiseweed,Zone 405,607,node 5'), +(2973,@Area607,0,'Bruiseweed,Zone 405,607,node 6'), +(3003,@Area607,0,'Bruiseweed,Zone 405,607,node 8'), +(3221,@Area607,0,'Bruiseweed,Zone 405,607,node 20'), +(3251,@Area607,0,'Bruiseweed,Zone 405,607,node 21'), +(3430,@Area607,0,'Bruiseweed,Zone 405,607,node 26'), +(3431,@Area607,0,'Bruiseweed,Zone 405,607,node 27'), +(3432,@Area607,0,'Bruiseweed,Zone 405,607,node 28'), +(3665,@Area607,0,'Bruiseweed,Zone 405,607,node 35'), +(3860,@Area607,0,'Bruiseweed,Zone 405,607,node 45'), +(3861,@Area607,0,'Bruiseweed,Zone 405,607,node 46'), +(16427,@Area607,0,'Ghost Mushroom,Zone 405,607,node 104'), +(16432,@Area607,0,'Ghost Mushroom,Zone 405,607,node 105'), +(16440,@Area607,0,'Ghost Mushroom,Zone 405,607,node 106'), +(16441,@Area607,0,'Ghost Mushroom,Zone 405,607,node 107'), +(16444,@Area607,0,'Ghost Mushroom,Zone 405,607,node 108'), +(16446,@Area607,0,'Ghost Mushroom,Zone 405,607,node 109'), +(18214,@Area607,0,'Ghost Mushroom,Zone 405,607,node 124'), +(34185,@Area607,0,'Ghost Mushroom,Zone 405,607,node 148'), +(34187,@Area607,0,'Bruiseweed,Zone 405,607,node 149'), +(86288,@Area607,0,'Bruiseweed,Zone 405,607,node 157'), +(3123,@Rest,0,'Bruiseweed,Zone 405,603,node 11'), +(3124,@Rest,0,'Bruiseweed,Zone 405,603,node 12'), +(3125,@Rest,0,'Bruiseweed,Zone 405,603,node 13'), +(3320,@Rest,0,'Bruiseweed,Zone 405,603,node 22'), +(3363,@Rest,0,'Bruiseweed,Zone 405,603,node 23'), +(3364,@Rest,0,'Bruiseweed,Zone 405,603,node 24'), +(3566,@Rest,0,'Bruiseweed,Zone 405,603,node 30'), +(3577,@Rest,0,'Bruiseweed,Zone 405,603,node 31'), +(3622,@Rest,0,'Bruiseweed,Zone 405,603,node 34'), +(3718,@Rest,0,'Bruiseweed,Zone 405,603,node 38'), +(3720,@Rest,0,'Bruiseweed,Zone 405,603,node 39'), +(18617,@Rest,0,'Bruiseweed,Zone 405,603,node 125'), +(18621,@Rest,0,'Wild Steelbloom,Zone 405,603,node 128'), +(7362,@Rest,0,'Liferoot,Zone 405,604,node 81'), +(7437,@Rest,0,'Liferoot,Zone 405,604,node 82'), +(7458,@Rest,0,'Liferoot,Zone 405,604,node 83'), +(29188,@Rest,0,'Liferoot,Zone 405,604,node 137'), +(3990,@Rest,0,'Wild Steelbloom,Zone 405,609,node 48'), +(4063,@Rest,0,'Wild Steelbloom,Zone 405,609,node 49'), +(18676,@Rest,0,'Grave Moss,Zone 405,609,node 131'), +(65072,@Rest,0,'Wild Steelbloom,Zone 405,609,node 154'), +(29200,@Rest,0,'Stranglekelp,Zone 405,2324,node 141'), +(4086,@Rest,0,'Wild Steelbloom,Zone 405,2404,node 50'), +(8542,@Rest,0,'Stranglekelp,Zone 405,2405,node 101'), +(8543,@Rest,0,'Stranglekelp,Zone 405,2405,node 102'), +(8557,@Rest,0,'Stranglekelp,Zone 405,2405,node 103'), +(8272,@Rest,0,'Stranglekelp,Zone 405,2408,node 90'), +(8404,@Rest,0,'Stranglekelp,Zone 405,2408,node 97'), +(8447,@Rest,0,'Stranglekelp,Zone 405,2408,node 98'), +(3773,@Rest,0,'Bruiseweed,Zone 405,2617,node 42'), +(18625,@Rest,0,'Kingsblood,Zone 405,2617,node 130'), +(18677,@Rest,0,'Grave Moss,Zone 405,2657,node 132'), +(2979,@Rest,0,'Bruiseweed,Zone 405,599,node 7'), +(3078,@Rest,0,'Bruiseweed,Zone 405,599,node 9'), +(3501,@Rest,0,'Bruiseweed,Zone 405,599,node 29'), +(3599,@Rest,0,'Bruiseweed,Zone 405,599,node 33'), +(3717,@Rest,0,'Bruiseweed,Zone 405,599,node 37'), +(34165,@Rest,0,'Bruiseweed,Zone 405,599,node 145'), +(34168,@Rest,0,'Wild Steelbloom,Zone 405,599,node 146'), +(86326,@Rest,0,'Kingsblood,Zone 405,599,node 159'), +(87250,@Rest,0,'Bruiseweed,Zone 405,599,node 164'); -- cgit v1.2.3