[NPC] Clouds in Northrend into a pool system

Hi,

this does the spawns of clouds in a pool system. It’s only for the clouds in northrend (cinder, arctic, steam).

edit edition from Nay’s qry

SET @POOL := XXX; – Set by TDB team (pool_template.entry - need 6)
SET @GUID := XXX; – Set by TDB team (creature.guid - need 91)

SET @Artic := 24879; – Arctic Cloud
SET @Cinder := 32522; – Cinder Cloud
SET @Steam := 32544; – Steam Cloud

DELETE FROM pool_template WHERE entry BETWEEN @POOL+0 AND @POOL+5;
INSERT INTO pool_template (entry,max_limit,description) VALUES
(@POOL+0,3, ‘Arctic Cloud’),
(@POOL+1,3, ‘Arctic Cloud’),
(@POOL+2,3, ‘Arctic Cloud’),
(@POOL+3,4, ‘Cinder Cloud’),
(@POOL+4,3, ‘Steam Cloud’),
(@POOL+5,1, ‘Steam Cloud’);

DELETE FROM pool_creature WHERE (guid BETWEEN @GUID+0 AND @GUID+90) AND (pool_entry BETWEEN @POOL+0 AND @POOL+5);
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@GUID+0,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+1,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+2,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+3,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+4,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+5,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+6,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+7,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+8,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+9,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+10,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+11,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+12,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+13,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+14,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+15,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+16,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+17,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+18,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+19,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+20,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+21,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+22,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+23,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+24,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+25,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+26,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+27,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+28,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+29,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+30,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+31,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+32,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+33,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+34,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+35,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+36,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+37,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+38,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+39,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+40,@POOL+2,0, ‘Arctic Cloud - Icecrow’),
(@GUID+41,@POOL+2,0, ‘Arctic Cloud - Icecrow’),
(@GUID+42,@POOL+2,0, ‘Arctic Cloud - Icecrow’),
(@GUID+43,@POOL+2,0, ‘Arctic Cloud - Icecrow’),
(@GUID+44,@POOL+2,0, ‘Arctic Cloud - Icecrow’),
(@GUID+45,@POOL+2,0, ‘Arctic Cloud - Icecrow’),
(@GUID+46,@POOL+2,0, ‘Arctic Cloud - Icecrow’),
(@GUID+47,@POOL+2,0, ‘Arctic Cloud - Icecrow’),
(@GUID+48,@POOL+2,0, ‘Arctic Cloud - Icecrow’),
(@GUID+49,@POOL+2,0, ‘Arctic Cloud - Icecrow’),
(@GUID+50,@POOL+2,0, ‘Arctic Cloud - Icecrow’),
(@GUID+51,@POOL+3,0, ‘Cinder Cloud’),
(@GUID+52,@POOL+3,0, ‘Cinder Cloud’),
(@GUID+53,@POOL+3,0, ‘Cinder Cloud’),
(@GUID+54,@POOL+3,0, ‘Cinder Cloud’),
(@GUID+55,@POOL+3,0, ‘Cinder Cloud’),
(@GUID+56,@POOL+3,0, ‘Cinder Cloud’),
(@GUID+57,@POOL+3,0, ‘Cinder Cloud’),
(@GUID+58,@POOL+3,0, ‘Cinder Cloud’),
(@GUID+59,@POOL+3,0, ‘Cinder Cloud’),
(@GUID+60,@POOL+3,0, ‘Cinder Cloud’),
(@GUID+61,@POOL+3,0, ‘Cinder Cloud’),
(@GUID+62,@POOL+3,0, ‘Cinder Cloud’),
(@GUID+63,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+64,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+65,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+66,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+67,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+68,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+69,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+70,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+71,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+72,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+73,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+74,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+75,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+76,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+77,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+78,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+79,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+80,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+81,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+82,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+83,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+84,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+85,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+86,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+87,@POOL+5,0, ‘Steam Cloud - Borean Tundra’),
(@GUID+88,@POOL+5,0, ‘Steam Cloud - Borean Tundra’),
(@GUID+89,@POOL+5,0, ‘Steam Cloud - Borean Tundra’),
(@GUID+90,@POOL+5,0, ‘Steam Cloud - Borean Tundra’);

DELETE FROM creature WHERE id IN (@Artic,@Cinder,@Steam);
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
(@GUID+0,@Artic,571,1,1,0,0,8154.26,-50.2582,853.637,6.10438,300,5,0,42,0,0,1,0,0,0),
(@GUID+1,@Artic,571,1,1,0,0,7585.26,-292.083,1126.52,6.10438,300,5,0,42,0,0,1,0,0,0),
(@GUID+2,@Artic,571,1,1,0,0,8234.87,-690.383,927.345,6.10438,300,5,0,42,0,0,1,0,0,0),
(@GUID+3,@Artic,571,1,1,0,0,7419.3,-903.758,909.254,6.10438,300,5,0,42,0,0,1,0,0,0),
(@GUID+4,@Artic,571,1,1,0,0,6286.04,-576.583,424.563,2.5426,300,5,0,42,0,0,1,0,0,0),
(@GUID+5,@Artic,571,1,1,0,0,5925.67,-626.371,478.491,2.5426,300,5,0,42,0,0,1,0,0,0),
(@GUID+6,@Artic,571,1,1,0,0,6503.32,-1038.15,485.395,2.5426,300,5,0,42,0,0,1,0,0,0),
(@GUID+7,@Artic,571,1,1,0,0,6286.04,-1323.4,426.505,3.31622,300,5,0,42,0,0,1,0,0,0),
(@GUID+8,@Artic,571,1,1,0,0,6926.17,-2091.55,805.349,3.31622,300,5,0,42,0,0,1,0,0,0),
(@GUID+9,@Artic,571,1,1,0,0,6992.55,-2141.33,737.069,3.31622,300,5,0,42,0,0,1,0,0,0),
(@GUID+10,@Artic,571,1,1,0,0,7153.77,-2248.02,759.305,3.31622,300,5,0,42,0,0,1,0,0,0),
(@GUID+11,@Artic,571,1,1,0,0,7229.63,-3044.62,845.739,3.31622,300,5,0,42,0,0,1,0,0,0),
(@GUID+12,@Artic,571,1,1,0,0,7518.88,-3094.41,842.155,3.31622,300,5,0,42,0,0,1,0,0,0),
(@GUID+13,@Artic,571,1,1,0,0,7893.47,-3322.01,857.378,3.31622,300,5,0,42,0,0,1,0,0,0),
(@GUID+14,@Artic,571,1,1,0,0,2762.83,1406.18,131.607,0.00340319,300,5,0,42,0,0,1,0,0,0),
(@GUID+15,@Artic,571,1,1,0,0,2845.1,1972.63,140.6,0.00340319,300,5,0,42,0,0,1,0,0,0),
(@GUID+16,@Artic,571,1,1,0,0,3073.22,-214.625,93.7885,0.00340319,300,5,0,42,0,0,1,0,0,0),
(@GUID+17,@Artic,571,1,1,0,0,3248.98,1187.46,134.375,0.00340319,300,5,0,42,0,0,1,0,0,0),
(@GUID+18,@Artic,571,1,1,0,0,3260.2,-1218.52,78.6832,0.00340319,300,5,0,42,0,0,1,0,0,0),
(@GUID+19,@Artic,571,1,1,0,0,3458.4,1804.38,75.0776,0.00340319,300,5,0,42,0,0,1,0,0,0),
(@GUID+20,@Artic,571,1,1,0,0,3585.54,-1083.92,111.125,0.00340319,300,5,0,42,0,0,1,0,0,0),
(@GUID+21,@Artic,571,1,1,0,0,3589.28,671.492,77.7206,0.00340319,300,5,0,42,0,0,1,0,0,0),
(@GUID+22,@Artic,571,1,1,0,0,3611.72,-102.458,59.6765,0.00340319,300,5,0,42,0,0,1,0,0,0),
(@GUID+23,@Artic,571,1,1,0,0,3708.95,1804.38,101.572,0.00340319,300,5,0,42,0,0,1,0,0,0),
(@GUID+24,@Artic,571,1,1,0,0,3880.97,1187.46,55.4913,0.00340319,300,5,0,42,0,0,1,0,0,0),
(@GUID+25,@Artic,571,1,1,0,0,4023.07,357.425,41.9114,0.00340319,300,5,0,42,0,0,1,0,0,0),
(@GUID+26,@Artic,571,1,1,0,0,4116.56,26.5337,52.568,0.00340319,300,5,0,42,0,0,1,0,0,0),
(@GUID+27,@Artic,571,1,1,0,0,4307.28,-820.325,147.814,0.00340319,300,5,0,42,0,0,1,0,0,0),
(@GUID+28,@Artic,571,1,1,0,0,4486.78,-242.667,90.8629,0.00340319,300,5,0,42,0,0,1,0,0,0),
(@GUID+29,@Artic,571,1,1,0,0,4561.57,-1280.21,159.549,0.00340319,300,5,0,42,0,0,1,0,0,0),
(@GUID+30,@Artic,571,1,1,0,0,4576.53,1630.52,286.716,0.00340319,300,5,0,42,0,0,1,0,0,0),
(@GUID+31,@Artic,571,1,1,0,0,4815.86,-309.966,229.377,0.00340319,300,5,0,42,0,0,1,0,0,0),
(@GUID+32,@Artic,571,1,1,0,0,4924.31,845.35,178.601,0.00340319,300,5,0,42,0,0,1,0,0,0),
(@GUID+33,@Artic,571,1,1,0,0,5122.51,1047.25,223.784,3.4733,300,5,0,42,0,0,1,0,0,0),
(@GUID+34,@Artic,571,1,1,0,0,6019.36,2383.58,518.105,4.83412,300,5,0,42,0,0,1,0,0,0),
(@GUID+35,@Artic,571,1,1,0,0,6144.8,1580.92,620.674,4.83412,300,5,0,42,0,0,1,0,0,0),
(@GUID+36,@Artic,571,1,1,0,0,6393.17,-211.808,678.76,6.10438,300,5,0,42,0,0,1,0,0,0),
(@GUID+37,@Artic,571,1,1,0,0,6504.39,1474.31,437.27,4.83412,300,5,0,42,0,0,1,0,0,0),
(@GUID+38,@Artic,571,1,1,0,0,6717.53,184.454,626.635,6.10438,300,5,0,42,0,0,1,0,0,0),
(@GUID+39,@Artic,571,1,1,0,0,6845.56,-789.958,731.38,6.10438,300,5,0,42,0,0,1,0,0,0),
(@GUID+40,@Artic,571,1,1,0,0,7064.68,2860.17,418.75,4.83412,300,5,0,42,0,0,1,0,0,0),
(@GUID+41,@Artic,571,1,1,0,0,7273.74,721.812,482.114,4.83412,300,5,0,42,0,0,1,0,0,0),
(@GUID+42,@Artic,571,1,1,0,0,7390.81,1806.67,433.04,4.83412,300,5,0,42,0,0,1,0,0,0),
(@GUID+43,@Artic,571,1,1,0,0,7518.88,77.7668,801.405,6.10438,300,5,0,42,0,0,1,0,0,0),
(@GUID+44,@Artic,571,1,1,0,0,7670.96,2966.77,531.154,4.83412,300,5,0,42,0,0,1,0,0,0),
(@GUID+45,@Artic,571,1,1,0,0,7679.32,797.062,479.98,4.83412,300,5,0,42,0,0,1,0,0,0),
(@GUID+46,@Artic,571,1,1,0,0,7718.02,42.2043,1021.67,6.10438,300,5,0,42,0,0,1,0,0,0),
(@GUID+47,@Artic,571,1,1,0,0,7984.55,1568.38,460.722,4.83412,300,5,0,42,0,0,1,0,0,0),
(@GUID+48,@Artic,571,1,1,0,0,8016.75,-2916.6,1137.52,3.31622,300,5,0,42,0,0,1,0,0,0),
(@GUID+49,@Artic,571,1,1,0,0,8227.06,3280.31,655.771,4.83412,300,5,0,42,0,0,1,0,0,0),
(@GUID+50,@Artic,571,1,1,0,0,8306.51,960.104,582.006,4.83412,300,5,0,42,0,0,1,0,0,0),
(@GUID+51,@Cinder,571,1,1,0,0,4311.02,1495.92,133.764,1.42942,300,5,0,42,0,0,1,0,0,0),
(@GUID+52,@Cinder,571,1,1,0,0,4347.75,1395.21,134.203,1.42942,300,5,0,42,0,0,1,0,0,0),
(@GUID+53,@Cinder,571,1,1,0,0,4393.29,1490.31,123.673,4.82626,300,5,0,42,0,0,1,0,0,0),
(@GUID+54,@Cinder,571,1,1,0,0,4408.25,1406.18,132.796,4.82626,300,5,0,42,0,0,1,0,0,0),
(@GUID+55,@Cinder,571,1,1,0,0,6419.15,4981.92,-69.5219,1.81657,300,5,0,42,0,0,1,0,0,0),
(@GUID+56,@Cinder,571,1,1,0,0,6488.85,4942.72,-57.9343,1.81657,300,5,0,42,0,0,1,0,0,0),
(@GUID+57,@Cinder,571,1,1,0,0,6517.9,4859.95,-52.7975,1.81657,300,5,0,42,0,0,1,0,0,0),
(@GUID+58,@Cinder,571,1,1,0,0,4217.27,1770.67,352.922,6.2282,300,5,0,42,0,0,1,0,0,0),
(@GUID+59,@Cinder,571,1,1,0,0,4235.12,1883.72,355.337,6.2282,300,5,0,42,0,0,1,0,0,0),
(@GUID+60,@Cinder,571,1,1,0,0,4330.32,1723.07,366.032,6.2282,300,5,0,42,0,0,1,0,0,0),
(@GUID+61,@Cinder,571,1,1,0,0,4342.22,1868.84,356.522,6.2282,300,5,0,42,0,0,1,0,0,0),
(@GUID+62,@Cinder,571,1,1,0,0,4375.93,1782.57,356.84,6.2282,300,5,0,42,0,0,1,0,0,0),
(@GUID+63,@Steam,571,1,1,0,0,3452.67,4685.5,-12.9957,2.27993,300,5,0,4979,0,0,1,0,0,0),
(@GUID+64,@Steam,571,1,1,0,0,3698.67,4904.56,-13.6717,2.27993,300,5,0,4979,0,0,1,0,0,0),
(@GUID+65,@Steam,571,1,1,0,0,4033.07,4524.1,-1.63039,2.27993,300,5,0,4979,0,0,1,0,0,0),
(@GUID+66,@Steam,571,1,1,0,0,4079.2,5089.02,-1.50956,2.27993,300,5,0,4979,0,0,1,0,0,0),
(@GUID+67,@Steam,571,1,1,0,0,4740.55,5008.06,-55.5771,5.40584,300,5,0,4979,0,0,1,0,0,0),
(@GUID+68,@Steam,571,1,1,0,0,4920.89,4070.89,-17.9628,5.40584,300,5,0,4979,0,0,1,0,0,0),
(@GUID+69,@Steam,571,1,1,0,0,5112.28,5953.37,-61.9079,5.40584,300,5,0,4979,0,0,1,0,0,0),
(@GUID+70,@Steam,571,1,1,0,0,5152.94,3810.09,-7.13058,0.803393,300,5,0,4979,0,0,1,0,0,0),
(@GUID+71,@Steam,571,1,1,0,0,5158.75,4184.73,-88.1236,5.40584,300,5,0,4979,0,0,1,0,0,0),
(@GUID+72,@Steam,571,1,1,0,0,5179.07,5739.91,-83.8105,5.40584,300,5,0,4979,0,0,1,0,0,0),
(@GUID+73,@Steam,571,1,1,0,0,5248.77,4707.48,-133.847,5.40584,300,5,0,4979,0,0,1,0,0,0),
(@GUID+74,@Steam,571,1,1,0,0,5254.58,5008.06,-135.353,5.40584,300,5,0,4979,0,0,1,0,0,0),
(@GUID+75,@Steam,571,1,1,0,0,5376.56,4433.04,-135.251,5.40584,300,5,0,4979,0,0,1,0,0,0),
(@GUID+76,@Steam,571,1,1,0,0,5393.98,5940.3,-49.8372,5.40584,300,5,0,4979,0,0,1,0,0,0),
(@GUID+77,@Steam,571,1,1,0,0,5501.44,3609.7,-17.8316,0.803393,300,5,0,4979,0,0,1,0,0,0),
(@GUID+78,@Steam,571,1,1,0,0,5585.66,3810.09,-15.5887,0.504939,300,5,0,4979,0,0,1,0,0,0),
(@GUID+79,@Steam,571,1,1,0,0,5588.23,3643.99,-23.6778,0.504939,300,5,0,4979,0,0,1,0,0,0),
(@GUID+80,@Steam,571,1,1,0,0,5608.89,6005.64,-39.6709,5.40584,300,5,0,4979,0,0,1,0,0,0),
(@GUID+81,@Steam,571,1,1,0,0,5788.95,5744.27,-69.0541,5.40584,300,5,0,4979,0,0,1,0,0,0),
(@GUID+82,@Steam,571,1,1,0,0,5817.99,4171.66,-101.138,5.40584,300,5,0,4979,0,0,1,0,0,0),
(@GUID+83,@Steam,571,1,1,0,0,5931.25,4820.74,-110.276,5.40584,300,5,0,4979,0,0,1,0,0,0),
(@GUID+84,@Steam,571,1,1,0,0,5980.62,4337.2,-85.2827,5.40584,300,5,0,4979,0,0,1,0,0,0),
(@GUID+85,@Steam,571,1,1,0,0,6131.64,4568.08,-91.79,5.40584,300,5,0,4979,0,0,1,0,0,0),
(@GUID+86,@Steam,571,1,1,0,0,6149.07,4297.99,-56.5222,5.40584,300,5,0,4979,0,0,1,0,0,0),
(@GUID+87,@Steam,571,1,1,0,0,6231,5577.32,-27.9032,5.40584,300,5,0,4979,0,0,1,0,0,0),
(@GUID+88,@Steam,571,1,1,0,0,6346.55,4258.79,-47.6791,5.40584,300,5,0,4979,0,0,1,0,0,0),
(@GUID+89,@Steam,571,1,1,0,0,6436.58,5360.92,-33.6846,5.40584,300,5,0,4979,0,0,1,0,0,0),
(@GUID+90,@Steam,571,1,1,0,0,6459.81,4520.2,-62.7745,5.40584,300,5,0,4979,0,0,1,0,0,0);

-- Northrend Cloud spawns and pooling

[CODE][Err] 1366 - Incorrect integer value: ‘’ for column ‘guid’ at row 1

[Err] – Steam Cloud 32544

– Stormpikes

INSERT INTO creature VALUES

(‘’, @AC, 571, 1, 1, 0, 0, 8154.26, -50.2582, 853.637, 6.10438, 300, 0, 0, 42, 0, 0, 0, 0, 0, 0);[/CODE]
correct it please

You need to add manual GUIDs…

Please remove unneeded spacing.

– Brian

@Fuchs and Brian: I hope it is what you wanted.

@Sp@ce: That is not helpful. I try my best, but I don’t know many things.

Removed unneeded spacing, credit goes to erimioa

[SPOILER]-- select highest ID
SELECT @highid := MAX(entry) FROM pool_template;
– pool_template insert
SET @pool1 := @highid+1;
SET @pool2 := @highid+2;
SET @pool3 := @highid+3;
SET @pool4 := @highid+4;
SET @pool5 := @highid+5;
SET @pool6 := @highid+6;
INSERT INTO pool_template (entry,max_limit,description) VALUES
(@pool1,3, ‘Arctic Cloud (24879)’),
(@pool2,3, ‘Arctic Cloud (24879)’),
(@pool3,3, ‘Arctic Cloud (24879)’),
(@pool4,4, ‘Cinder Cloud (32522)’),
(@pool5,3, ‘Steam Cloud (32544)’),
(@pool6,1, ‘Steam Cloud (32544)’);
– delete old spawns (it’s to many fals to use the old spawns)
DELETE FROM creature WHERE id IN (24879,32522,32544);
– insert new spawns – thats exactly the points of spawn by wowhead.com
SET @AC := 24879; – Arctic Clouds 24879
SET @CC := 32522; – Cinder Cloud 32522
SET @SC := 32544; – Steam Cloud 32544
INSERT INTO creature (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
(@AC,571,1,1,0,0,8154.26,-50.2582,853.637,6.10438,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool1,0, ‘Arctic Cloud (24879)-Stormpikes’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,7585.26,-292.083,1126.52,6.10438,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool1,0, ‘Arctic Cloud (24879)-Stormpikes’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,8234.87,-690.383,927.345,6.10438,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool1,0, ‘Arctic Cloud (24879)-Stormpikes’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,7419.3,-903.758,909.254,6.10438,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool1,0, ‘Arctic Cloud (24879)-Stormpikes’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,6286.04,-576.583,424.563,2.5426,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool1,0, ‘Arctic Cloud (24879)-Stormpikes’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,5925.67,-626.371,478.491,2.5426,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool1,0, ‘Arctic Cloud (24879)-Stormpikes’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,6503.32,-1038.15,485.395,2.5426,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool1,0, ‘Arctic Cloud (24879)-Stormpikes’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,6286.04,-1323.4,426.505,3.31622,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool1,0, ‘Arctic Cloud (24879)-Stormpikes’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,6926.17,-2091.55,805.349,3.31622,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool1,0, ‘Arctic Cloud (24879)-Stormpikes’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,6992.55,-2141.33,737.069,3.31622,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool1,0, ‘Arctic Cloud (24879)-Stormpikes’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,7153.77,-2248.02,759.305,3.31622,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool1,0, ‘Arctic Cloud (24879)-Stormpikes’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,7229.63,-3044.62,845.739,3.31622,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool1,0, ‘Arctic Cloud (24879)-Stormpikes’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,7518.88,-3094.41,842.155,3.31622,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool1,0, ‘Arctic Cloud (24879)-Stormpikes’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,7893.47,-3322.01,857.378,3.31622,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool1,0, ‘Arctic Cloud (24879)-Stormpikes’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,7518.88,77.7668,801.405,6.10438,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool1,0, ‘Arctic Cloud (24879)-Stormpikes’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,7718.02,42.2043,1021.67,6.10438,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool1,0, ‘Arctic Cloud (24879)-Stormpikes’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,6845.56,-789.958,731.38,6.10438,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool1,0, ‘Arctic Cloud (24879)-Stormpikes’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,6717.53,184.454,626.635,6.10438,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool1,0, ‘Arctic Cloud (24879)-Stormpikes’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,8016.75,-2916.6,1137.52,3.31622,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool1,0, ‘Arctic Cloud (24879)-Stormpikes’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,6393.17,-211.808,678.76,6.10438,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool1,0, ‘Arctic Cloud (24879)-Stormpikes’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,3260.2,-1218.52,78.6832,0.00340319,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool2,0, ‘Arctic Cloud (24879)-Dragonsblight’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,3585.54,-1083.92,111.125,0.00340319,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool2,0, ‘Arctic Cloud (24879)-Dragonsblight’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,4307.28,-820.325,147.814,0.00340319,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool2,0, ‘Arctic Cloud (24879)-Dragonsblight’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,4561.57,-1280.21,159.549,0.00340319,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool2,0, ‘Arctic Cloud (24879)-Dragonsblight’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,4815.86,-309.966,229.377,0.00340319,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool2,0, ‘Arctic Cloud (24879)-Dragonsblight’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,4486.78,-242.667,90.8629,0.00340319,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool2,0, ‘Arctic Cloud (24879)-Dragonsblight’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,4116.56,26.5337,52.568,0.00340319,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool2,0, ‘Arctic Cloud (24879)-Dragonsblight’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,3611.72,-102.458,59.6765,0.00340319,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool2,0, ‘Arctic Cloud (24879)-Dragonsblight’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,3073.22,-214.625,93.7885,0.00340319,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool2,0, ‘Arctic Cloud (24879)-Dragonsblight’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,4023.07,357.425,41.9114,0.00340319,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool2,0, ‘Arctic Cloud (24879)-Dragonsblight’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,3589.28,671.492,77.7206,0.00340319,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool2,0, ‘Arctic Cloud (24879)-Dragonsblight’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,3880.97,1187.46,55.4913,0.00340319,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool2,0, ‘Arctic Cloud (24879)-Dragonsblight’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,3248.98,1187.46,134.375,0.00340319,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool2,0, ‘Arctic Cloud (24879)-Dragonsblight’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,2762.83,1406.18,131.607,0.00340319,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool2,0, ‘Arctic Cloud (24879)-Dragonsblight’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,2845.1,1972.63,140.6,0.00340319,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool2,0, ‘Arctic Cloud (24879)-Dragonsblight’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,3458.4,1804.38,75.0776,0.00340319,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool2,0, ‘Arctic Cloud (24879)-Dragonsblight’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,3708.95,1804.38,101.572,0.00340319,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool2,0, ‘Arctic Cloud (24879)-Dragonsblight’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,4576.53,1630.52,286.716,0.00340319,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool2,0, ‘Arctic Cloud (24879)-Dragonsblight’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,4924.31,845.35,178.601,0.00340319,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool2,0, ‘Arctic Cloud (24879)-Dragonsblight’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,5122.51,1047.25,223.784,3.4733,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool2,0, ‘Arctic Cloud (24879)-Dragonsblight’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,7273.74,721.812,482.114,4.83412,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool3,0, ‘Arctic Cloud (24879)-Icecrow’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,7679.32,797.062,479.98,4.83412,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool3,0, ‘Arctic Cloud (24879)-Icecrow’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,8306.51,960.104,582.006,4.83412,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool3,0, ‘Arctic Cloud (24879)-Icecrow’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,7984.55,1568.38,460.722,4.83412,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool3,0, ‘Arctic Cloud (24879)-Icecrow’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,7390.81,1806.67,433.04,4.83412,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool3,0, ‘Arctic Cloud (24879)-Icecrow’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,6504.39,1474.31,437.27,4.83412,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool3,0, ‘Arctic Cloud (24879)-Icecrow’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,6144.8,1580.92,620.674,4.83412,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool3,0, ‘Arctic Cloud (24879)-Icecrow’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,6019.36,2383.58,518.105,4.83412,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool3,0, ‘Arctic Cloud (24879)-Icecrow’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,7064.68,2860.17,418.75,4.83412,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool3,0, ‘Arctic Cloud (24879)-Icecrow’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,7670.96,2966.77,531.154,4.83412,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool3,0, ‘Arctic Cloud (24879)-Icecrow’);
INSERT INTO creature (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
(@AC,571,1,1,0,0,8227.06,3280.31,655.771,4.83412,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool3,0, ‘Arctic Cloud (24879)-Icecrow’);
INSERT INTO creature (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
(@CC,571,1,256,0,0,4342.22,1868.84,356.522,6.2282,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool4,0, ‘Cinder Cloud (32522)’);
INSERT INTO creature (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
(@CC,571,1,256,0,0,4235.12,1883.72,355.337,6.2282,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool4,0, ‘Cinder Cloud (32522)’);
INSERT INTO creature (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
(@CC,571,1,256,0,0,4217.27,1770.67,352.922,6.2282,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool4,0, ‘Cinder Cloud (32522)’);
INSERT INTO creature (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
(@CC,571,1,256,0,0,4330.32,1723.07,366.032,6.2282,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool4,0, ‘Cinder Cloud (32522)’);
INSERT INTO creature (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
(@CC,571,1,256,0,0,4375.93,1782.57,356.84,6.2282,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool4,0, ‘Cinder Cloud (32522)’);
INSERT INTO creature (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
(@CC,571,1,1,0,0,4311.02,1495.92,133.764,1.42942,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool4,0, ‘Cinder Cloud (32522)’);
INSERT INTO creature (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
(@CC,571,1,1,0,0,4347.75,1395.21,134.203,1.42942,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool4,0, ‘Cinder Cloud (32522)’);
INSERT INTO creature (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
(@CC,571,1,1,0,0,4408.25,1406.18,132.796,4.82626,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool4,0, ‘Cinder Cloud (32522)’);
INSERT INTO creature (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
(@CC,571,1,1,0,0,4393.29,1490.31,123.673,4.82626,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool4,0, ‘Cinder Cloud (32522)’);
INSERT INTO creature (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
(@CC,571,1,1,0,0,6419.15,4981.92,-69.5219,1.81657,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool4,0, ‘Cinder Cloud (32522)’);
INSERT INTO creature (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
(@CC,571,1,1,0,0,6517.9,4859.95,-52.7975,1.81657,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool4,0, ‘Cinder Cloud (32522)’);
INSERT INTO creature (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
(@CC,571,1,1,0,0,6488.85,4942.72,-57.9343,1.81657,300,0,0,42,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool4,0, ‘Cinder Cloud (32522)’);
INSERT INTO creature (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
(@SC,571,1,1,0,0,5376.56,4433.04,-135.251,5.40584,300,0,0,4979,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool5,0, ‘Steam Cloud (32544)-Sholazar’);
INSERT INTO creature (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
(@SC,571,1,1,0,0,5112.28,5953.37,-61.9079,5.40584,300,0,0,4979,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool5,0, ‘Steam Cloud (32544)-Sholazar’);
INSERT INTO creature (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
(@SC,571,1,1,0,0,5393.98,5940.3,-49.8372,5.40584,300,0,0,4979,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool5,0, ‘Steam Cloud (32544)-Sholazar’);
INSERT INTO creature (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
(@SC,571,1,1,0,0,5608.89,6005.64,-39.6709,5.40584,300,0,0,4979,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool5,0, ‘Steam Cloud (32544)-Sholazar’);
INSERT INTO creature (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
(@SC,571,1,1,0,0,5788.95,5744.27,-69.0541,5.40584,300,0,0,4979,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool5,0, ‘Steam Cloud (32544)-Sholazar’);
INSERT INTO creature (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
(@SC,571,1,1,0,0,6231,5577.32,-27.9032,5.40584,300,0,0,4979,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool5,0, ‘Steam Cloud (32544)-Sholazar’);
INSERT INTO creature (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
(@SC,571,1,1,0,0,6436.58,5360.92,-33.6846,5.40584,300,0,0,4979,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool5,0, ‘Steam Cloud (32544)-Sholazar’);
INSERT INTO creature (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
(@SC,571,1,1,0,0,5817.99,4171.66,-101.138,5.40584,300,0,0,4979,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool5,0, ‘Steam Cloud (32544)-Sholazar’);
INSERT INTO creature (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
(@SC,571,1,1,0,0,5980.62,4337.2,-85.2827,5.40584,300,0,0,4979,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool5,0, ‘Steam Cloud (32544)-Sholazar’);
INSERT INTO creature (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
(@SC,571,1,1,0,0,6149.07,4297.99,-56.5222,5.40584,300,0,0,4979,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool5,0, ‘Steam Cloud (32544)-Sholazar’);
INSERT INTO creature (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
(@SC,571,1,1,0,0,6346.55,4258.79,-47.6791,5.40584,300,0,0,4979,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool5,0, ‘Steam Cloud (32544)-Sholazar’);
INSERT INTO creature (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
(@SC,571,1,1,0,0,6459.81,4520.2,-62.7745,5.40584,300,0,0,4979,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool5,0, ‘Steam Cloud (32544)-Sholazar’);
INSERT INTO creature (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
(@SC,571,1,1,0,0,6131.64,4568.08,-91.79,5.40584,300,0,0,4979,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool5,0, ‘Steam Cloud (32544)-Sholazar’);
INSERT INTO creature (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
(@SC,571,1,1,0,0,5931.25,4820.74,-110.276,5.40584,300,0,0,4979,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool5,0, ‘Steam Cloud (32544)-Sholazar’);
INSERT INTO creature (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
(@SC,571,1,1,0,0,5248.77,4707.48,-133.847,5.40584,300,0,0,4979,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool5,0, ‘Steam Cloud (32544)-Sholazar’);
INSERT INTO creature (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
(@SC,571,1,1,0,0,5254.58,5008.06,-135.353,5.40584,300,0,0,4979,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool5,0, ‘Steam Cloud (32544)-Sholazar’);
INSERT INTO creature (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
(@SC,571,1,1,0,0,4740.55,5008.06,-55.5771,5.40584,300,0,0,4979,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool5,0, ‘Steam Cloud (32544)-Sholazar’);
INSERT INTO creature (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
(@SC,571,1,1,0,0,5179.07,5739.91,-83.8105,5.40584,300,0,0,4979,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool5,0, ‘Steam Cloud (32544)-Sholazar’);
INSERT INTO creature (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
(@SC,571,1,1,0,0,5152.94,3810.09,-7.13058,0.803393,300,0,0,4979,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool5,0, ‘Steam Cloud (32544)-Sholazar’);
INSERT INTO creature (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
(@SC,571,1,1,0,0,5501.44,3609.7,-17.8316,0.803393,300,0,0,4979,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool5,0, ‘Steam Cloud (32544)-Sholazar’);
INSERT INTO creature (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
(@SC,571,1,1,0,0,5588.23,3643.99,-23.6778,0.504939,300,0,0,4979,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool5,0, ‘Steam Cloud (32544)-Sholazar’);
INSERT INTO creature (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
(@SC,571,1,1,0,0,4920.89,4070.89,-17.9628,5.40584,300,0,0,4979,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool5,0, ‘Steam Cloud (32544)-Sholazar’);
INSERT INTO creature (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
(@SC,571,1,1,0,0,5158.75,4184.73,-88.1236,5.40584,300,0,0,4979,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool5,0, ‘Steam Cloud (32544)-Sholazar’);
INSERT INTO creature (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
(@SC,571,1,1,0,0,5585.66,3810.09,-15.5887,0.504939,300,0,0,4979,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool5,0, ‘Steam Cloud (32544)-Sholazar’);
INSERT INTO creature (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
(@SC,571,1,1,0,0,4079.2,5089.02,-1.50956,2.27993,300,0,0,4979,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool6,0, ‘Steam Cloud (32544)-Borean Tundra’);
INSERT INTO creature (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
(@SC,571,1,1,0,0,4033.07,4524.1,-1.63039,2.27993,300,0,0,4979,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool6,0, ‘Steam Cloud (32544)-Borean Tundra’);
INSERT INTO creature (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
(@SC,571,1,1,0,0,3698.67,4904.56,-13.6717,2.27993,300,0,0,4979,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool6,0, ‘Steam Cloud (32544)-Borean Tundra’);
INSERT INTO creature (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
(@SC,571,1,1,0,0,3452.67,4685.5,-12.9957,2.27993,300,0,0,4979,0,0,0,0,0,0);
SET @guid := LAST_INSERT_ID();
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@guid,@pool6,0, ‘Steam Cloud (32544)-Borean Tundra’);
– Random Movement
UPDATE creature SET spawndist=5 WHERE id IN (24879,32522,32544);
UPDATE creature SET MovementType=1 WHERE id IN (24879,32522,32544);

-- [NPC] Clouds in Northrend

[/SPOILER]

I dislike

[CODE]SELECT @highid := MAX(entry) FROM pool_template;
SET @guid := LAST_INSERT_ID();[/sql]
I wonder if it’s just me.

Edit: also lacking deletes before inserts

Another thing, what’s the source (current spawns?)and why does Cinder spawns got phasemask 256?

[/CODE]

[SPOILER]-- Northrend Cloud spawns and pooling
SET @POOL := XXX; – Set by TDB team (pool_template.entry - need 6)
SET @GUID := XXX; – Set by TDB team (creature.guid - need 91)

SET @Artic := 24879; – Arctic Cloud
SET @Cinder := 32522; – Cinder Cloud
SET @Steam := 32544; – Steam Cloud

UPDATE creature SET spawndist=5,MovementType=1 WHERE id IN (@Artic,@Cinder,@Steam);

DELETE FROM pool_template WHERE entry BETWEEN @POOL+0 AND @POOL+5;
INSERT INTO pool_template (entry,max_limit,description) VALUES
(@POOL+0,3, ‘Arctic Cloud’),
(@POOL+1,3, ‘Arctic Cloud’),
(@POOL+2,3, ‘Arctic Cloud’),
(@POOL+3,4, ‘Cinder Cloud’),
(@POOL+4,3, ‘Steam Cloud’),
(@POOL+5,1, ‘Steam Cloud’);

DELETE FROM pool_creature WHERE (guid BETWEEN @GUID+0 AND @GUID+90) AND (pool_entry BETWEEN @POOL+0 AND @POOL+5);
INSERT INTO pool_creature (guid,pool_entry,chance,description) VALUES
(@GUID+0,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+1,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+2,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+3,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+4,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+5,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+6,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+7,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+8,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+9,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+10,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+11,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+12,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+13,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+14,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+15,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+16,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+17,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+18,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+19,@POOL+0,0, ‘Arctic Cloud - Stormpikes’),
(@GUID+20,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+21,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+22,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+23,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+24,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+25,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+26,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+27,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+28,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+29,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+30,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+31,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+32,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+33,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+34,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+35,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+36,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+37,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+38,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+39,@POOL+1,0, ‘Arctic Cloud - Dragonsblight’),
(@GUID+40,@POOL+2,0, ‘Arctic Cloud - Icecrow’),
(@GUID+41,@POOL+2,0, ‘Arctic Cloud - Icecrow’),
(@GUID+42,@POOL+2,0, ‘Arctic Cloud - Icecrow’),
(@GUID+43,@POOL+2,0, ‘Arctic Cloud - Icecrow’),
(@GUID+44,@POOL+2,0, ‘Arctic Cloud - Icecrow’),
(@GUID+45,@POOL+2,0, ‘Arctic Cloud - Icecrow’),
(@GUID+46,@POOL+2,0, ‘Arctic Cloud - Icecrow’),
(@GUID+47,@POOL+2,0, ‘Arctic Cloud - Icecrow’),
(@GUID+48,@POOL+2,0, ‘Arctic Cloud - Icecrow’),
(@GUID+49,@POOL+2,0, ‘Arctic Cloud - Icecrow’),
(@GUID+50,@POOL+2,0, ‘Arctic Cloud - Icecrow’),
(@GUID+51,@POOL+3,0, ‘Cinder Cloud’),
(@GUID+52,@POOL+3,0, ‘Cinder Cloud’),
(@GUID+53,@POOL+3,0, ‘Cinder Cloud’),
(@GUID+54,@POOL+3,0, ‘Cinder Cloud’),
(@GUID+55,@POOL+3,0, ‘Cinder Cloud’),
(@GUID+56,@POOL+3,0, ‘Cinder Cloud’),
(@GUID+57,@POOL+3,0, ‘Cinder Cloud’),
(@GUID+58,@POOL+3,0, ‘Cinder Cloud’),
(@GUID+59,@POOL+3,0, ‘Cinder Cloud’),
(@GUID+60,@POOL+3,0, ‘Cinder Cloud’),
(@GUID+61,@POOL+3,0, ‘Cinder Cloud’),
(@GUID+62,@POOL+3,0, ‘Cinder Cloud’),
(@GUID+63,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+64,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+65,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+66,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+67,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+68,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+69,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+70,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+71,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+72,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+73,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+74,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+75,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+76,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+77,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+78,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+79,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+80,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+81,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+82,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+83,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+84,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+85,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+86,@POOL+4,0, ‘Steam Cloud - Sholazar’),
(@GUID+87,@POOL+5,0, ‘Steam Cloud - Borean Tundra’),
(@GUID+88,@POOL+5,0, ‘Steam Cloud - Borean Tundra’),
(@GUID+89,@POOL+5,0, ‘Steam Cloud - Borean Tundra’),
(@GUID+90,@POOL+5,0, ‘Steam Cloud - Borean Tundra’);

DELETE FROM creature WHERE id IN (@Artic,@Cinder,@Steam);
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
(@GUID+0,@Artic,571,1,1,0,0,8154.26,-50.2582,853.637,6.10438,300,0,0,42,0,0,0,0,0,0),
(@GUID+1,@Artic,571,1,1,0,0,7585.26,-292.083,1126.52,6.10438,300,0,0,42,0,0,0,0,0,0),
(@GUID+2,@Artic,571,1,1,0,0,8234.87,-690.383,927.345,6.10438,300,0,0,42,0,0,0,0,0,0),
(@GUID+3,@Artic,571,1,1,0,0,7419.3,-903.758,909.254,6.10438,300,0,0,42,0,0,0,0,0,0),
(@GUID+4,@Artic,571,1,1,0,0,6286.04,-576.583,424.563,2.5426,300,0,0,42,0,0,0,0,0,0),
(@GUID+5,@Artic,571,1,1,0,0,5925.67,-626.371,478.491,2.5426,300,0,0,42,0,0,0,0,0,0),
(@GUID+6,@Artic,571,1,1,0,0,6503.32,-1038.15,485.395,2.5426,300,0,0,42,0,0,0,0,0,0),
(@GUID+7,@Artic,571,1,1,0,0,6286.04,-1323.4,426.505,3.31622,300,0,0,42,0,0,0,0,0,0),
(@GUID+8,@Artic,571,1,1,0,0,6926.17,-2091.55,805.349,3.31622,300,0,0,42,0,0,0,0,0,0),
(@GUID+9,@Artic,571,1,1,0,0,6992.55,-2141.33,737.069,3.31622,300,0,0,42,0,0,0,0,0,0),
(@GUID+10,@Artic,571,1,1,0,0,7153.77,-2248.02,759.305,3.31622,300,0,0,42,0,0,0,0,0,0),
(@GUID+11,@Artic,571,1,1,0,0,7229.63,-3044.62,845.739,3.31622,300,0,0,42,0,0,0,0,0,0),
(@GUID+12,@Artic,571,1,1,0,0,7518.88,-3094.41,842.155,3.31622,300,0,0,42,0,0,0,0,0,0),
(@GUID+13,@Artic,571,1,1,0,0,7893.47,-3322.01,857.378,3.31622,300,0,0,42,0,0,0,0,0,0),
(@GUID+14,@Artic,571,1,1,0,0,2762.83,1406.18,131.607,0.00340319,300,0,0,42,0,0,0,0,0,0),
(@GUID+15,@Artic,571,1,1,0,0,2845.1,1972.63,140.6,0.00340319,300,0,0,42,0,0,0,0,0,0),
(@GUID+16,@Artic,571,1,1,0,0,3073.22,-214.625,93.7885,0.00340319,300,0,0,42,0,0,0,0,0,0),
(@GUID+17,@Artic,571,1,1,0,0,3248.98,1187.46,134.375,0.00340319,300,0,0,42,0,0,0,0,0,0),
(@GUID+18,@Artic,571,1,1,0,0,3260.2,-1218.52,78.6832,0.00340319,300,0,0,42,0,0,0,0,0,0),
(@GUID+19,@Artic,571,1,1,0,0,3458.4,1804.38,75.0776,0.00340319,300,0,0,42,0,0,0,0,0,0),
(@GUID+20,@Artic,571,1,1,0,0,3585.54,-1083.92,111.125,0.00340319,300,0,0,42,0,0,0,0,0,0),
(@GUID+21,@Artic,571,1,1,0,0,3589.28,671.492,77.7206,0.00340319,300,0,0,42,0,0,0,0,0,0),
(@GUID+22,@Artic,571,1,1,0,0,3611.72,-102.458,59.6765,0.00340319,300,0,0,42,0,0,0,0,0,0),
(@GUID+23,@Artic,571,1,1,0,0,3708.95,1804.38,101.572,0.00340319,300,0,0,42,0,0,0,0,0,0),
(@GUID+24,@Artic,571,1,1,0,0,3880.97,1187.46,55.4913,0.00340319,300,0,0,42,0,0,0,0,0,0),
(@GUID+25,@Artic,571,1,1,0,0,4023.07,357.425,41.9114,0.00340319,300,0,0,42,0,0,0,0,0,0),
(@GUID+26,@Artic,571,1,1,0,0,4116.56,26.5337,52.568,0.00340319,300,0,0,42,0,0,0,0,0,0),
(@GUID+27,@Artic,571,1,1,0,0,4307.28,-820.325,147.814,0.00340319,300,0,0,42,0,0,0,0,0,0),
(@GUID+28,@Artic,571,1,1,0,0,4486.78,-242.667,90.8629,0.00340319,300,0,0,42,0,0,0,0,0,0),
(@GUID+29,@Artic,571,1,1,0,0,4561.57,-1280.21,159.549,0.00340319,300,0,0,42,0,0,0,0,0,0),
(@GUID+30,@Artic,571,1,1,0,0,4576.53,1630.52,286.716,0.00340319,300,0,0,42,0,0,0,0,0,0),
(@GUID+31,@Artic,571,1,1,0,0,4815.86,-309.966,229.377,0.00340319,300,0,0,42,0,0,0,0,0,0),
(@GUID+32,@Artic,571,1,1,0,0,4924.31,845.35,178.601,0.00340319,300,0,0,42,0,0,0,0,0,0),
(@GUID+33,@Artic,571,1,1,0,0,5122.51,1047.25,223.784,3.4733,300,0,0,42,0,0,0,0,0,0),
(@GUID+34,@Artic,571,1,1,0,0,6019.36,2383.58,518.105,4.83412,300,0,0,42,0,0,0,0,0,0),
(@GUID+35,@Artic,571,1,1,0,0,6144.8,1580.92,620.674,4.83412,300,0,0,42,0,0,0,0,0,0),
(@GUID+36,@Artic,571,1,1,0,0,6393.17,-211.808,678.76,6.10438,300,0,0,42,0,0,0,0,0,0),
(@GUID+37,@Artic,571,1,1,0,0,6504.39,1474.31,437.27,4.83412,300,0,0,42,0,0,0,0,0,0),
(@GUID+38,@Artic,571,1,1,0,0,6717.53,184.454,626.635,6.10438,300,0,0,42,0,0,0,0,0,0),
(@GUID+39,@Artic,571,1,1,0,0,6845.56,-789.958,731.38,6.10438,300,0,0,42,0,0,0,0,0,0),
(@GUID+40,@Artic,571,1,1,0,0,7064.68,2860.17,418.75,4.83412,300,0,0,42,0,0,0,0,0,0),
(@GUID+41,@Artic,571,1,1,0,0,7273.74,721.812,482.114,4.83412,300,0,0,42,0,0,0,0,0,0),
(@GUID+42,@Artic,571,1,1,0,0,7390.81,1806.67,433.04,4.83412,300,0,0,42,0,0,0,0,0,0),
(@GUID+43,@Artic,571,1,1,0,0,7518.88,77.7668,801.405,6.10438,300,0,0,42,0,0,0,0,0,0),
(@GUID+44,@Artic,571,1,1,0,0,7670.96,2966.77,531.154,4.83412,300,0,0,42,0,0,0,0,0,0),
(@GUID+45,@Artic,571,1,1,0,0,7679.32,797.062,479.98,4.83412,300,0,0,42,0,0,0,0,0,0),
(@GUID+46,@Artic,571,1,1,0,0,7718.02,42.2043,1021.67,6.10438,300,0,0,42,0,0,0,0,0,0),
(@GUID+47,@Artic,571,1,1,0,0,7984.55,1568.38,460.722,4.83412,300,0,0,42,0,0,0,0,0,0),
(@GUID+48,@Artic,571,1,1,0,0,8016.75,-2916.6,1137.52,3.31622,300,0,0,42,0,0,0,0,0,0),
(@GUID+49,@Artic,571,1,1,0,0,8227.06,3280.31,655.771,4.83412,300,0,0,42,0,0,0,0,0,0),
(@GUID+50,@Artic,571,1,1,0,0,8306.51,960.104,582.006,4.83412,300,0,0,42,0,0,0,0,0,0),
(@GUID+51,@Cinder,571,1,1,0,0,4311.02,1495.92,133.764,1.42942,300,0,0,42,0,0,0,0,0,0),
(@GUID+52,@Cinder,571,1,1,0,0,4347.75,1395.21,134.203,1.42942,300,0,0,42,0,0,0,0,0,0),
(@GUID+53,@Cinder,571,1,1,0,0,4393.29,1490.31,123.673,4.82626,300,0,0,42,0,0,0,0,0,0),
(@GUID+54,@Cinder,571,1,1,0,0,4408.25,1406.18,132.796,4.82626,300,0,0,42,0,0,0,0,0,0),
(@GUID+55,@Cinder,571,1,1,0,0,6419.15,4981.92,-69.5219,1.81657,300,0,0,42,0,0,0,0,0,0),
(@GUID+56,@Cinder,571,1,1,0,0,6488.85,4942.72,-57.9343,1.81657,300,0,0,42,0,0,0,0,0,0),
(@GUID+57,@Cinder,571,1,1,0,0,6517.9,4859.95,-52.7975,1.81657,300,0,0,42,0,0,0,0,0,0),
(@GUID+58,@Cinder,571,1,256,0,0,4217.27,1770.67,352.922,6.2282,300,0,0,42,0,0,0,0,0,0),
(@GUID+59,@Cinder,571,1,256,0,0,4235.12,1883.72,355.337,6.2282,300,0,0,42,0,0,0,0,0,0),
(@GUID+60,@Cinder,571,1,256,0,0,4330.32,1723.07,366.032,6.2282,300,0,0,42,0,0,0,0,0,0),
(@GUID+61,@Cinder,571,1,256,0,0,4342.22,1868.84,356.522,6.2282,300,0,0,42,0,0,0,0,0,0),
(@GUID+62,@Cinder,571,1,256,0,0,4375.93,1782.57,356.84,6.2282,300,0,0,42,0,0,0,0,0,0),
(@GUID+63,@Steam,571,1,1,0,0,3452.67,4685.5,-12.9957,2.27993,300,0,0,4979,0,0,0,0,0,0),
(@GUID+64,@Steam,571,1,1,0,0,3698.67,4904.56,-13.6717,2.27993,300,0,0,4979,0,0,0,0,0,0),
(@GUID+65,@Steam,571,1,1,0,0,4033.07,4524.1,-1.63039,2.27993,300,0,0,4979,0,0,0,0,0,0),
(@GUID+66,@Steam,571,1,1,0,0,4079.2,5089.02,-1.50956,2.27993,300,0,0,4979,0,0,0,0,0,0),
(@GUID+67,@Steam,571,1,1,0,0,4740.55,5008.06,-55.5771,5.40584,300,0,0,4979,0,0,0,0,0,0),
(@GUID+68,@Steam,571,1,1,0,0,4920.89,4070.89,-17.9628,5.40584,300,0,0,4979,0,0,0,0,0,0),
(@GUID+69,@Steam,571,1,1,0,0,5112.28,5953.37,-61.9079,5.40584,300,0,0,4979,0,0,0,0,0,0),
(@GUID+70,@Steam,571,1,1,0,0,5152.94,3810.09,-7.13058,0.803393,300,0,0,4979,0,0,0,0,0,0),
(@GUID+71,@Steam,571,1,1,0,0,5158.75,4184.73,-88.1236,5.40584,300,0,0,4979,0,0,0,0,0,0),
(@GUID+72,@Steam,571,1,1,0,0,5179.07,5739.91,-83.8105,5.40584,300,0,0,4979,0,0,0,0,0,0),
(@GUID+73,@Steam,571,1,1,0,0,5248.77,4707.48,-133.847,5.40584,300,0,0,4979,0,0,0,0,0,0),
(@GUID+74,@Steam,571,1,1,0,0,5254.58,5008.06,-135.353,5.40584,300,0,0,4979,0,0,0,0,0,0),
(@GUID+75,@Steam,571,1,1,0,0,5376.56,4433.04,-135.251,5.40584,300,0,0,4979,0,0,0,0,0,0),
(@GUID+76,@Steam,571,1,1,0,0,5393.98,5940.3,-49.8372,5.40584,300,0,0,4979,0,0,0,0,0,0),
(@GUID+77,@Steam,571,1,1,0,0,5501.44,3609.7,-17.8316,0.803393,300,0,0,4979,0,0,0,0,0,0),
(@GUID+78,@Steam,571,1,1,0,0,5585.66,3810.09,-15.5887,0.504939,300,0,0,4979,0,0,0,0,0,0),
(@GUID+79,@Steam,571,1,1,0,0,5588.23,3643.99,-23.6778,0.504939,300,0,0,4979,0,0,0,0,0,0),
(@GUID+80,@Steam,571,1,1,0,0,5608.89,6005.64,-39.6709,5.40584,300,0,0,4979,0,0,0,0,0,0),
(@GUID+81,@Steam,571,1,1,0,0,5788.95,5744.27,-69.0541,5.40584,300,0,0,4979,0,0,0,0,0,0),
(@GUID+82,@Steam,571,1,1,0,0,5817.99,4171.66,-101.138,5.40584,300,0,0,4979,0,0,0,0,0,0),
(@GUID+83,@Steam,571,1,1,0,0,5931.25,4820.74,-110.276,5.40584,300,0,0,4979,0,0,0,0,0,0),
(@GUID+84,@Steam,571,1,1,0,0,5980.62,4337.2,-85.2827,5.40584,300,0,0,4979,0,0,0,0,0,0),
(@GUID+85,@Steam,571,1,1,0,0,6131.64,4568.08,-91.79,5.40584,300,0,0,4979,0,0,0,0,0,0),
(@GUID+86,@Steam,571,1,1,0,0,6149.07,4297.99,-56.5222,5.40584,300,0,0,4979,0,0,0,0,0,0),
(@GUID+87,@Steam,571,1,1,0,0,6231,5577.32,-27.9032,5.40584,300,0,0,4979,0,0,0,0,0,0),
(@GUID+88,@Steam,571,1,1,0,0,6346.55,4258.79,-47.6791,5.40584,300,0,0,4979,0,0,0,0,0,0),
(@GUID+89,@Steam,571,1,1,0,0,6436.58,5360.92,-33.6846,5.40584,300,0,0,4979,0,0,0,0,0,0),
(@GUID+90,@Steam,571,1,1,0,0,6459.81,4520.2,-62.7745,5.40584,300,0,0,4979,0,0,0,0,0,0);


[/SPOILER]

P.S 210 lines instead 490, defined guids, deletes before inserts and cleaner format is improvement.

Finally some TDB POWER!

TY Nay

damnit i had it done but forgot to upload it, double work ftl

Ahah /emoticons/default_tongue.png

By the way, it is really bad when a fix takes longer to be re-written than writing it from scratch.

The idea from nay is good. I have never think to do it with @guid+x.

SELECT @highid := MAX(entry) FROM pool_template;SET @guid := LAST_INSERT_ID();

I do this, because “how I can do it, without merge problem”. By my server I have choose anyone entry, look if it exist and write this number into the qry.

Another thing’ date=’ what’s the source (current spawns?)and why does Cinder spawns got phasemask 256?
[/quote’]
That is a fail from me. It was something for Wintergrasp.In germany it is late, I revised the qry von Nay tomorrow, because spawndistance and randommove isn’t nice, too.

Thanks for the help.

Eri

Hey, I have a full life with study and fam.

question still stands on the source of this fix /emoticons/default_smile.png

until yesterday stands the source in my code: www.wowhead.com

accurate:

http://www.wowhead.com/npc=24879#map

http://www.wowhead.com/npc=32522#map

http://www.wowhead.com/npc=32544#map

Moved to completed section.

Posted on tracker.