sirikfoll/Midsummer_Misc.sql

## Midsummer_Misc.sql
SET @CCGUID := xxxxxx; -- 15 required
SET @OOGUID := xxxxxx; -- 15 required
SET @CGUID := xxxxxx; -- 168 Required
SET @OGUID := xxxxxx; -- 419 Required

-- Set Earthen Ring Elder ID: 26221 friendly to both factions
UPDATE `creature_template` SET `faction`=35 WHERE `entry`=26221;
UPDATE `quest_template` SET `Method`=2, `MaxLevel`=28,`PrevQuestId`=12012 WHERE `Id`=11917; -- Striking Back
UPDATE `quest_template` SET `Method`=2, `MaxLevel`=38,`PrevQuestId`=12012 WHERE `Id`=11947; -- -//-
UPDATE `quest_template` SET `Method`=2, `MaxLevel`=48,`PrevQuestId`=12012 WHERE `Id`=11948; -- -//-
UPDATE `quest_template` SET `Method`=2, `MaxLevel`=55,`PrevQuestId`=12012 WHERE `Id`=11952; -- -//-
UPDATE `quest_template` SET `Method`=2, `MaxLevel`=63,`PrevQuestId`=12012 WHERE `Id`=11953; -- -//-
UPDATE `quest_template` SET `Method`=2,`PrevQuestId`=12012 WHERE `Id`=11954; -- -//-
UPDATE `quest_template` SET `Method`=2,`PrevQuestId`=12012 WHERE `Id`=11955; -- Ahune, the Frost Lord
UPDATE `quest_template` SET `PrevQuestId`=11955 WHERE `Id`=11696; -- Ahune is here!
UPDATE `quest_template` SET `PrevQuestId`=11731 WHERE `Id`=11921; -- More Torch Tossing /A/
UPDATE `quest_template` SET `PrevQuestId`=11922 WHERE `Id`=11926; -- More Torch Tossing /H/
UPDATE `quest_template` SET `PrevQuestId`=11657 WHERE `Id`=11924; -- More Torch Catching /A/
UPDATE `quest_template` SET `PrevQuestId`=11923 WHERE `Id`=11925; -- More Torch Catching /H/
DELETE FROM `creature_queststarter` WHERE `id` IN (26221,25975,25324);
DELETE FROM `creature` WHERE `guid` BETWEEN @CCGUID AND @CCGUID+14;
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
(@CCGUID, 25866, 1, 1, 1, 0, 0, 3886.6, 771.658, 5.00204, 3.78625, 300, 30, 0, 42, 0, 1, 0, 0, 0),
(@CCGUID+1, 25866, 1, 1, 1, 0, 0, 3873.34, 786.567, 3.15877, 1.19364, 300, 30, 0, 42, 0, 1, 0, 0, 0),
(@CCGUID+2, 25866, 1, 1, 1, 0, 0, 3886.25, 820.325, 1.23753, 1.74656, 300, 30, 0, 42, 0, 1, 0, 0, 0),
(@CCGUID+3, 25866, 1, 1, 1, 0, 0, 3922.2, 795.453, 9.05771, 3.07546, 300, 30, 0, 42, 0, 1, 0, 0, 0),
(@CCGUID+4, 25863, 1, 1, 1, 0, 0, 3956.09, 767.42, 7.88992, 5.17483, 300, 30, 0, 42, 0, 1, 0, 0, 0),
(@CCGUID+5, 25863, 1, 1, 1, 0, 0, 3988.96, 790.529, 6.19678, 0.208762, 300, 30, 0, 42, 0, 1, 0, 0, 0),
(@CCGUID+6, 25863, 1, 1, 1, 0, 0, 3899.13, 764.193, 6.01616, 5.62487, 300, 30, 0, 42, 0, 1, 0, 0, 0),
(@CCGUID+7, 25863, 1, 1, 1, 0, 0, 3923.53, 840.173, 2.29151, 2.07879, 300, 30, 0, 42, 0, 1, 0, 0, 0),
(@CCGUID+8, 25924, 1, 1, 1, 0, 0, 3916.05, 783.268, 9.0577, 0.717698, 300, 0, 0, 44, 0, 0, 0, 0, 0),
(@CCGUID+9, 25866, 1, 1, 1, 0, 0, 3900.86, 799.587, 7.80664, 1.37978, 300, 30, 0, 42, 0, 1, 0, 0, 0),
(@CCGUID+10, 25866, 1, 1, 1, 0, 0, 3950.07, 846.313, 7.9843, 4.16433, 300, 30, 0, 42, 0, 1, 0, 0, 0),
(@CCGUID+11, 25866, 1, 1, 1, 0, 0, 3982.71, 816.306, 8.04045, 4.0481, 300, 30, 0, 42, 0, 1, 0, 0, 0),
(@CCGUID+12, 25866, 1, 1, 1, 0, 0, 3918.32, 760.473, 7.77712, 1.94087, 300, 30, 0, 42, 0, 1, 0, 0, 0),
(@CCGUID+13, 25863, 1, 1, 1, 0, 0, 3922.62, 811.827, 7.79205, 2.56369, 300, 0, 0, 42, 0, 0, 0, 0, 0),
(@CCGUID+14, 25949, 1, 1, 1, 0, 0, 4196.1, 1172.44, 6.68073, 0.688985, 300, 0, 0, 486, 1357, 0, 0, 0, 0);
DELETE FROM `gameobject` WHERE `guid` BETWEEN @OOGUID AND @OOGUID+14;
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
(@OOGUID, 187989, 1, 1, 1, 3955.77, 862.105, 0.1785, 3.93579, 0, 0, 0.922187, -0.386745, 300, 0, 1),
(@OOGUID+1, 187989, 1, 1, 1, 3880.54, 795.812, 2.67948, 0.589994, 0, 0, 0.290737, 0.956803, 300, 0, 1),
(@OOGUID+2, 187989, 1, 1, 1, 3923.8, 748.779, 8.05033, 2.67052, 0, 0, 0.972389, 0.233364, 300, 0, 1),
(@OOGUID+3, 187989, 1, 1, 1, 3959.24, 760.694, 6.12531, 2.76477, 0, 0, 0.982303, 0.1873, 300, 0, 1),
(@OOGUID+4, 187989, 1, 1, 1, 3998.39, 815.017, 4.22604, 3.56744, 0, 0, 0.977417, -0.21132, 300, 0, 1),
(@OOGUID+5, 187989, 1, 1, 1, 3953.32, 808.406, 9.07383, 0.295474, 0, 0, 0.1472, 0.989107, 300, 0, 1),
(@OOGUID+6, 187989, 1, 1, 1, 3944.4, 817.924, 9.05937, 2.23541, 0, 0, 0.899098, 0.437748, 300, 0, 1),
(@OOGUID+7, 187918, 1, 1, 1, 3891.73, 795.127, 7.70466, 3.57844, 0, 0, 0.97624, -0.216691, 300, 0, 1),
(@OOGUID+8, 187918, 1, 1, 1, 3928.2, 818.467, 8.38597, 0.711076, 0, 0, 0.348095, 0.937459, 300, 0, 1),
(@OOGUID+9, 187918, 1, 1, 1, 3956.23, 854.015, 7.9829, 1.18232, 0, 0, 0.557323, 0.830296, 300, 0, 1),
(@OOGUID+10, 187918, 1, 1, 1, 3988.24, 819.46, 8.01849, 5.47452, 0, 0, 0.393407, -0.919365, 300, 0, 1),
(@OOGUID+11, 187918, 1, 1, 1, 3923.81, 758.498, 7.77727, 4.57321, 0, 0, 0.754564, -0.656226, 300, 0, 1),
(@OOGUID+12, 187918, 1, 1, 1, 3947.51, 812.939, 9.06439, 0.920322, 0, 0, 0.444092, 0.895981, 300, 0, 1),
(@OOGUID+13, 187989, 1, 1, 1, 3924.28, 779.525, 9.05821, 2.43535, 0, 0, 0.938298, 0.345828, 300, 0, 1),
(@OOGUID+14, 187989, 1, 1, 1, 3912.78, 792.797, 9.05821, 2.43771, 0, 0, 0.938704, 0.344723, 300, 0, 1);
-- SAI and loot for Twilight Firesworn, Twilight Flameguard and Twilight Speaker Viktor
DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid` IN (25863,25924,25866);
INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
(25863,0,0,0,0,0,100,0,0,1000,7000,7500,11,20793,0,0,0,0,0,2,0,0,0,0,0,0,0,'Firesworn - IC - Cast spell Fireball on victim'),
(25863,0,1,0,4,0,100,0,0,0,0,0,11,184,0,0,0,0,0,1,0,0,0,0,0,0,0,'Firesworn - On aggro - Cast fire shield on self'),
(25863,0,2,0,4,0,100,0,0,0,0,0,1,0,1000,0,0,0,0,1,0,0,0,0,0,0,0,'Firesworn - On aggro - Say Text 0'),
(25924,0,0,0,0,0,100,0,0,1000,7000,7500,11,20793,0,0,0,0,0,2,0,0,0,0,0,0,0,'Speaker Viktor - IC - Cast spell Fireball on victim'),
(25924,0,1,0,4,0,100,0,0,0,0,0,1,0,1000,0,0,0,0,1,0,0,0,0,0,0,0,'Speaker Viktor - On aggro - Say Text 0'),
(25866,0,0,0,4,0,100,0,0,0,0,0,1,0,1000,0,0,0,0,1,0,0,0,0,0,0,0,'Flameguard - On aggro - Say Text 0');
UPDATE `creature_template` SET `lootid`=25866,`AIName`= 'SmartAI' WHERE `entry`=25866;
UPDATE `creature_template` SET `lootid`=25863,`unit_class`=8,`AIName`= 'SmartAI' WHERE `entry`=25863;
UPDATE `creature_template` SET `AIName`= 'SmartAI',`lootid` =25924,`unit_class`=8 WHERE `entry`=25924;
DELETE FROM `creature_loot_template` WHERE `entry`IN (25866,25863,25924);
INSERT INTO `creature_loot_template` VALUES
(25866,35277,0,100,1,1,0,1,1,'Twilight Correspondence'),
(25863,35277,0,100,1,1,0,1,1,'Twilight Correspondence'),
(25924,35277,0,100,1,1,0,1,1,'Twilight Correspondence');
-- Add SAI for quest "Unusual activity"
UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry` IN (26534,25324);
DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid` IN (26534,25324);
INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
(26534,0,0,0,1,0,100,1,6000,10000,0,0,12,25324,3,60000,0,0,0,23,0,0,0,0,0,0,0,'Totem - On event update - Summon guide'),
(25324,0,0,0,54,0,100,0,0,0,0,0,29,0,0,0,0,0,0,7,0,0,0,0,0,0,0,'Earthen ring Guide - On just summonned - Follow Totem'),
(25324,0,1,0,64,0,100,0,0,0,0,0,1,0,1500,0,0,0,0,1,0,0,0,0,0,0,0,'Earthen ring Guide - On gossip hello - Say text 0');
-- Earthen Ring Guide text
DELETE FROM `creature_text` WHERE `entry` IN (25324,25863,25924,25866);
INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`,`BroadcastTextId`) VALUES
(25324,0,1,'What is it you need?',12,0,100,1,1500,0,'Earthen ring guide',25739),
(25324,0,2,'Have you discovered something?',12,0,100,1,1500,0,'Earthen ring guide',25740),
(25324,0,3,'The elemental spirits are restless...',12,0,100,1,1500,0,'Earthen ring guide',25741),
(25863,0,0,'You are not allowed to interfere!',12,0,100,1,1500,0,'Twilight Firesworn',25098),
(25924,0,0,'Our vision will be realized!',12,0,100,1,1500,0,'Twilight Speaker Viktor',25099),
(25866,0,0,'The elements will crush you!',12,0,100,1,1500,0,'Twilight Speaker Viktor',25100);
-- SAI for Briatha
UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=25949;
DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=25949;
DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=2594900;
INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
(25949,0,0,0,10,0,100,0,1,20,40000,40000,80,2594900,2,0,0,0,0,1,0,0,0,0,0,0,0,'Briatha - OOC LOS - Call Timed ActionList'),
(2594900,9,0,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Briatha - Action list - Talk0'),
(2594900,9,1,0,0,0,100,0,6000,6000,0,0,1,0,4000,0,0,0,0,9,25951,0,15,0,0,0,0,'Emissary - Action list - Say text 0'),
(2594900,9,2,0,0,0,100,0,6000,6000,0,0,1,1,4000,0,0,0,0,1,0,0,0,0,0,0,0,'Briatha - Action list - Say text 1'),
(2594900,9,3,0,0,0,100,0,6000,6000,0,0,1,1,4000,0,0,0,0,9,25951,0,15,0,0,0,0,'Emissary - Action list - Say text 1'),
(2594900,9,4,0,0,0,100,0,6000,6000,0,0,1,2,3500,0,0,0,0,1,0,0,0,0,0,0,0,'Briatha - Action list - Say text 2'),
(2594900,9,5,0,0,0,100,0,0,0,0,0,11,46375,0,0,0,0,0,1,0,0,0,0,0,0,0,'Briatha - Action list - Cast spell quest credit');
-- Briatha and Heretic Emissary text
DELETE FROM `creature_text` WHERE `entry` IN (25949,25951);
INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`,`BroadcastTextId`) VALUES
(25949,0,0,'These stones should be the last of them. Our coordination with Neptulon''s forces will be impeccable.',12,0,100,1,0,0,'Briatha',25123),
(25949,1,0,'And your own preparations? Will the Frost Lord have a path to the portal?',12,0,100,1,0,0,'Briatha',25126),
(25949,2,0,'The ritual in Coilfang will bring Ahune through once he is fully prepared, and the resulting clash between Firelord and Frostlord will rend the foundations of this world. Our ultimate goals are in reach at last....',12,0,100,1,0,0,'Briatha',25128),
(25951,0,0,'Yess. The Tidehunter will be pleased at this development. The Firelord\'s hold will weaken.',12,0,100,1,0,0,'Heretic Emissary',25124),
(25951,1,0,'Skar\'this has informed us well. We have worked our way into the slave pens and await your cryomancerss.',12,0,100,1,0,0,'Heretic Emissary',25127);
DELETE FROM `game_event_creature` WHERE `guid` BETWEEN @CCGUID AND @CCGUID+14 AND `eventEntry`=1;
INSERT INTO `game_event_creature` (`eventEntry`,`guid`) VALUES
(1,@CCGUID),
(1,@CCGUID+1),
(1,@CCGUID+2),
(1,@CCGUID+3),
(1,@CCGUID+4),
(1,@CCGUID+5),
(1,@CCGUID+6),
(1,@CCGUID+7),
(1,@CCGUID+8),
(1,@CCGUID+9),
(1,@CCGUID+10),
(1,@CCGUID+11),
(1,@CCGUID+12),
(1,@CCGUID+13),
(1,@CCGUID+14);
DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN @OOGUID AND @OOGUID+14 AND `eventEntry`=1;
INSERT INTO `game_event_gameobject` (`eventEntry`,`guid`) VALUES
(1,@OOGUID),
(1,@OOGUID+1),
(1,@OOGUID+2),
(1,@OOGUID+3),
(1,@OOGUID+4),
(1,@OOGUID+5),
(1,@OOGUID+6),
(1,@OOGUID+7),
(1,@OOGUID+8),
(1,@OOGUID+9),
(1,@OOGUID+10),
(1,@OOGUID+11),
(1,@OOGUID+12),
(1,@OOGUID+13),
(1,@OOGUID+14);

-- Horde Honor the Flame Quests
DELETE FROM `creature_queststarter` WHERE `quest` IN (11821,11836,11856,11838,11843);
DELETE FROM `creature_questender` WHERE `quest` IN (11847,11849,11854);
INSERT INTO `creature_questender` (`id`, `quest`) VALUES
(25932, 11849), -- Feralas
(25930, 11847), -- Dustwallow marsh
(25937, 11854); -- Nagrand
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Durotar flame!' WHERE `Id`=11846;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Mulgore flame!' WHERE `Id`=11852;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Barrens flame!' WHERE `Id`=11859;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Tanaris flame!' WHERE `Id`=11838;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Ashenvale flame!' WHERE `Id`=11841;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Winterspring flame!' WHERE `Id`=11839;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Desolace flame!' WHERE `Id`=11845;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Thousand Needles flame!' WHERE `Id`=11861;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Feralas flame!' WHERE `Id`=11849;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Dustwallow Marsh flame!' WHERE `Id`=11847;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Silithus flame!' WHERE `Id`=11836;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Stonetalon Mountains flame!' WHERE `Id`=11856;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Hellfire Peninsula flame!' WHERE `Id`=11851;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Shadowmoon Valley flame!' WHERE `Id`=11855;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Nagrand flame!' WHERE `Id`=11854;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Netherstorm flame!' WHERE `Id`=11835;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Blades Edge Mountains flame! ' WHERE `Id`=11843;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Terokkar flame!' WHERE `Id`=11858;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Zangarmarsh flame!' WHERE `Id`=11863;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Zul''Drak flame!' WHERE `Id`=13500;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Borean Tundra flame!' WHERE `Id`=13493;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Sholazar Basin flame!' WHERE `Id`=13494;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Dragonblight flame!' WHERE `Id`=13495;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Crystalsong Forest flame!' WHERE `Id`=13499;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Storm Peaks flame!' WHERE `Id`=13498;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Grizzly Hills flame!' WHERE `Id`=13497;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Howling Fjords flame!' WHERE `Id`=13496;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Ghostland flame!' WHERE `Id`=11850;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Eversong woods flame!' WHERE `Id`=11848;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Hillsbrad Foothills flame!' WHERE `Id`=11853;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Swamp of sorrows flame!' WHERE `Id`=11857;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Cape of Stranglethorn flame!' WHERE `Id`=11837;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Burning Steppes flame!' WHERE `Id`=11844;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Hinterlands flame!' WHERE `Id`=11860;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Silverpine Forest flame!' WHERE `Id`=11584;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Tirisfal Glades flame!' WHERE `Id`=11862;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Badlands flame!' WHERE `Id`=11842;
UPDATE `quest_template` SET `RequiredRaces`=690,`OfferRewardText`='Honor the Arathi Highlands flame!' WHERE `Id`=11840;
UPDATE `creature_template` SET `npcflag`=3, `unit_flags`=33356 WHERE `entry`=32816;
UPDATE `creature_template` SET `npcflag`=3, `unit_flags`=33536 WHERE `entry`=32813;
UPDATE `creature_template` SET `npcflag`=3, `unit_flags`=33536 WHERE `entry`=32812;
UPDATE `creature_template` SET `npcflag`=3, `unit_flags`=33536 WHERE `entry`=32811;
UPDATE `creature_template` SET `npcflag`=3, `unit_flags`=33536 WHERE `entry`=25946;
UPDATE `creature_template` SET `npcflag`=3, `unit_flags`=33536 WHERE `entry`=25938;
UPDATE `creature_template` SET `npcflag`=3, `unit_flags`=33536 WHERE `entry`=25936;
UPDATE `creature_template` SET `npcflag`=3, `unit_flags`=33536 WHERE `entry`=25933;
UPDATE `creature_template` SET `npcflag`=3, `unit_flags`=33536 WHERE `entry`=25931;
UPDATE `creature_template` SET `npcflag`=3, `unit_flags`=33536 WHERE `entry`=25929;
UPDATE `creature_template` SET `npcflag`=3, `unit_flags`=33536 WHERE `entry`=25926;
UPDATE `creature_template` SET `npcflag`=3, `unit_flags`=33536 WHERE `entry`=25918;
-- Alliance Honor the Flame Quests
DELETE FROM `creature_questender` WHERE `quest` IN (11805,11812,11815,11834,11833,11831,11817,11811,11806,11809,11826,11824,11826,11827,11819,11583,11828,11816,11810,11808,11804,11832,11813,11814,11820,11822,13485,13487,13489,13488,13492,13490,13486,13491,11823,11821,11830,11818,11825,11807,11829);
INSERT INTO `creature_questender` (`id`, `quest`) VALUES
(25883, 11805), -- Ashenvale
(25894, 11812), -- Desolace
(25897, 11815), -- Dustwallow Marsh
(25917, 11834), -- Winterspring
(25916, 11833), -- Tanaris
(25914, 11831), -- Silithus
(25899, 11817), -- Feralas
(25893, 11811), -- Darkshore
(25888, 11806), -- Azuremyst Isle
(25891, 11809), -- Bloodmyst Isle
(25906, 11824), -- Teldrassil
(25908, 11826), -- The Hinterlands
(25909, 11827), -- The Western Plaguelands
(25901, 11819), -- Hillsbrad Foothills
(25910, 11583), -- Westfall
(25911, 11828), -- Wetlands
(25898, 11816), -- Elwynn Forest
(25892, 11810), -- Burning Steppes
(25890, 11808), -- Blasted Lands
(25887, 11804), -- Arathi Highlands
(25915, 11832), -- Cape of Stranglethorn
(25895, 11813), -- Dun Morogh
(25896, 11814), -- Duskwood
(25902, 11820), -- Loch Modan
(25904, 11822), -- Redridge Mountains
(32801, 13485), -- Borean Tundra
(32803, 13487), -- Dragonblight
(32805, 13489), -- Grizzly Hills
(32804, 13488), -- Howling Fjord
(32808, 13492), -- Zul'Drak
(32806, 13490), -- The Storm Peaks
(32802, 13486), -- Sholazar Basin
(32807, 13491), -- Crystalsong Forest
(25905, 11823), -- Shadowmoon Valley
(25903, 11821), -- Nagrand
(25913, 11830), -- Netherstorm
(25900, 11818), -- Hellfire Peninsula
(25907, 11825), -- Terokkar
(25889, 11807), -- Blade's Edge
(25912, 11829); -- Zangarmarsh
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Ashenvale flame!' WHERE `Id`=11805;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Desolace flame!' WHERE `Id`=11812;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Dustwallow Marsh flame!' WHERE `Id`=11815;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Winterspring flame!' WHERE `Id`=11834;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Tanaris flame!' WHERE `Id`=11833;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Silithus flame!' WHERE `Id`=11831;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Feralas flame!' WHERE `Id`=11817;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Darkshore flame!' WHERE `Id`=11811;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Azuremyst Isle flame!' WHERE `Id`=11806;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Bloodmyst Isle flame!' WHERE `Id`=11809;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Teldrassil flame!' WHERE `Id`=11824;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Hinterlands flame!' WHERE `Id`=11826;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Western Plaguelands flame!' WHERE `Id`=11827;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Hillsbrad Foothills flame!' WHERE `Id`=11819;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Westfall flame!' WHERE `Id`=11583;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Wetlands flame!' WHERE `Id`=11828;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Elwynn Forest flame!' WHERE `Id`=11816;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Burning Steppes flame!' WHERE `Id`=11810;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Blasted Lands flame!' WHERE `Id`=11808;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Arathi Highlands flame!' WHERE `Id`=11804;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Cape of Stranglethorn flame!' WHERE `Id`=11832;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Dun Morogh flame!' WHERE `Id`=11813;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Duskwood flame!' WHERE `Id`=11814;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Loch Modan flame!' WHERE `Id`=11820;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Redridge Mountains flame!' WHERE `Id`=11822;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Borean Tundra flame!' WHERE `Id`=13485;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Dragonblight flame!' WHERE `Id`=13487;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Grizzly Hills flame!' WHERE `Id`=13489;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Howling Fjord flame!' WHERE `Id`=13488;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Zul''Drak flame!' WHERE `Id`=13492;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Storm Peaks flame!' WHERE `Id`=13490;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Sholazar Basin flame!' WHERE `Id`=13486;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Crystalsong Forest flame!' WHERE `Id`=13491;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Shadowmoon Valley flame!' WHERE `Id`=11823;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Nagrand flame!' WHERE `Id`=11821;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Netherstorm flame!' WHERE `Id`=11830;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Hellfire Peninsula flame!' WHERE `Id`=11818;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Terokkar flame!' WHERE `Id`=11825;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Blade''s Edge Mountains flame!' WHERE `Id`=11807;
UPDATE `quest_template` SET `RequiredRaces`=1101,`OfferRewardText`='Honor the Zangarmarsh flame!' WHERE `Id`=11829;
UPDATE `creature_template` SET `gossip_menu_id`=9203, `npcflag`=3, `unit_flags`=33536 WHERE `entry`=32803;
UPDATE `creature_template` SET `gossip_menu_id`=9203, `npcflag`=3, `unit_flags`=33536 WHERE `entry`=32804;
UPDATE `creature_template` SET `gossip_menu_id`=9203, `npcflag`=3, `unit_flags`=33536 WHERE `entry`=32805;
UPDATE `creature_template` SET `npcflag`=3, `unit_flags`=33536 WHERE `entry`=25888;
UPDATE `creature_template` SET `npcflag`=3, `unit_flags`=33536 WHERE `entry`=25891;
UPDATE `creature_template` SET `npcflag`=3, `unit_flags`=33536 WHERE `entry`=25892;
UPDATE `creature_template` SET `npcflag`=3, `unit_flags`=33536 WHERE `entry`=25903;
UPDATE `creature_template` SET `npcflag`=3, `unit_flags`=33536 WHERE `entry`=25905;
UPDATE `creature_template` SET `npcflag`=3, `unit_flags`=33536 WHERE `entry`=25907;
UPDATE `creature_template` SET `npcflag`=3, `unit_flags`=33536 WHERE `entry`=25909;
UPDATE `creature_template` SET `npcflag`=3, `unit_flags`=33536 WHERE `entry`=25912;
UPDATE `creature_template` SET `npcflag`=3, `unit_flags`=33536 WHERE `entry`=25913;
UPDATE `creature_template` SET `npcflag`=3, `unit_flags`=33536 WHERE `entry`=32808;
UPDATE `creature_template` SET `npcflag`=3, `unit_flags`=33536 WHERE `entry`=25889;
-- Northrend Alliance's Bonfire Quests
DELETE FROM `gameobject_queststarter` WHERE `quest` IN (13441,13450,13451,13453,13454,13455,13457,13458);
-- Northrend Horde's Bonfire Quests
DELETE FROM `gameobject_queststarter` WHERE `quest` IN (13440,13442,13443,13444,13445,13446,13447,13449);
-- Stealing the flame
DELETE FROM `creature_queststarter` WHERE `quest` IN (11933,11935);
DELETE FROM `spell_scripts` WHERE `id` IN (29137,29135,29126,46671,29139,29138,29136,46672);
INSERT INTO `spell_scripts` (`id`, `effIndex`,`command`, `datalong`, `datalong2`) VALUES
(29137, 2, 15,29101, 2),
(29135, 2, 15,29102, 2),
(29126, 2, 15,29099, 2),
(46671, 2, 15,46690, 2),
(29139, 2, 15,29133, 2),
(29136, 2, 15,29130, 2),
(29138, 2, 15,29132, 2),
(46672, 2, 15,46689, 2);
-- A Thief's Reward
DELETE FROM `creature_queststarter` WHERE `quest` IN (9365,9339);
INSERT INTO `creature_queststarter` (`id`, `quest`) VALUES
(16817, 9365), -- Alliance
(16818, 9339); -- Horde
DELETE FROM `creature_questender` WHERE `quest` IN (9365,9339);
INSERT INTO `creature_questender` (`id`, `quest`) VALUES
(16817, 9365), -- Alliance
(16818, 9339); -- Horde
-- Alliance Desecrate the flame
DELETE FROM `gameobject_queststarter` WHERE `id` IN (187958,187952,187953,187950,187973,187971,187968,187965,187961,187957,187959,187948,187963,187967,187949,187970,187975,187966,187955,194048,194033,194034,194037,194046,194043,194042,194039,187962,187960,187964,187969,187951,187956,187972,187559,187974,187954,187947);
DELETE FROM `gameobject_questender`   WHERE `id` IN (187958,187952,187953,187950,187973,187971,187968,187965,187961,187957,187959,187948,187963,187967,187949,187970,187975,187966,187955,194048,194033,194034,194037,194046,194043,194042,194039,187962,187960,187964,187969,187951,187956,187972,187559,187974,187954,187947);
INSERT INTO `gameobject_questender` (`id`, `quest`) VALUES
(187958, 11770), -- Durotar
(187957, 11769), -- Desolace
(187965, 11777), -- Mulgore
(187953, 11803), -- Winterspring
(187971, 11783), -- Barrens
(187961, 11773), -- Feralas
(187948, 11765), -- Ashenvale
(187959, 11771), -- Dustwallow marsh
(187973, 11785), -- Thousand Needles
(187950, 11800), -- Silithus
(187968, 11780), -- Stonetalon Mountains
(187952, 11802), -- Tanaris
(187963, 11775), -- Hellfire Peninsula
(187967, 11779), -- Shadowmoon Valley
(187949, 11799), -- Netherstorm
(187970, 11782), -- Terokkar
(187975, 11787), -- Zangarmarsh
(187955, 11767), -- Blade' Edge
(187966, 11778), -- Nagrand
(194048, 13458), -- Zul'Drak
(194033, 13441), -- Borean Tundra
(194034, 13450), -- Sholazar Basin
(194037, 13451), -- Dragonblight
(194046, 13457), -- Crystalsong Forest
(194043, 13455), -- Storm Peaks
(194042, 13454), -- Grizzly Hills
(194039, 13453), -- Howling Fjords
(187962, 11774), -- Ghostland
(187960, 11772), -- Eversong woods
(187964, 11776), -- Hillsbrad Foothills
(187969, 11781), -- Swamp of sorrows
(187951, 11801), -- Cape of Stranglethorn
(187956, 11768), -- Burning Steppes
(187972, 11784), -- The Hinterlands
(187559, 11580), -- Silverpine Forest
(187974, 11786), -- Tirisfal Glades
(187954, 11766), -- Badlands
(187947, 11764); -- Arathi Highlands
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Zul''Drak bonfire!' WHERE `id`=13458;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Crystalsong Forest bonfire!' WHERE `id`=13457;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Storm Peaks bonfire!' WHERE `id`=13455;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Grizzly Hills bonfire!' WHERE `id`=13454;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Howling Fjord bonfire!' WHERE `id`=13453;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Dragonblight bonfire!' WHERE `id`=13451;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Sholazar Basin bonfire!' WHERE `id`=13450;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Borean Tundra bonfire!' WHERE `id`=13441;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Winterspring bonfire!' WHERE `id`=11803;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Tanaris bonfire!' WHERE `id`=11802;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Stranglethorn Vale bonfire!' WHERE `id`=11801;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Silithus bonfire!' WHERE `id`=11800;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Netherstorm bonfire!' WHERE `id`=11799;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Zangarmarsh bonfire!' WHERE `id`=11787;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Dustwallow Marsh bonfire!' WHERE `id`=11771;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Hinterlands bonfire!' WHERE `id`=11784;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Terokkar Forest bonfire!' WHERE `id`=11782;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Shadowmoon Valley bonfire!' WHERE `id`=11779;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Nagrand bonfire!' WHERE `id`=11778;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Hillsbrad Foothills Bonfire!' WHERE `id`=11776;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Hellfire Peninsula bonfire!' WHERE `id`=11775;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Feralas bonfire!' WHERE `id`=11773;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Desolace bonfire!' WHERE `id`=11769;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Burning Steppes bonfire!' WHERE `id`=11768;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Blade''s Edge Mountains bonfire!' WHERE `id`=11767;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Ashenvale bonfire!' WHERE `id`=11765;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Arathi Highlands bonfire!' WHERE `id`=11764;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Silverpine bonfire!' WHERE `id`=11580;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Durotar bonfire!' WHERE `id`=11770;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Mulgore bonfire!' WHERE `id`=11777;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Barrens bonfire!' WHERE `id`=11783;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Thousand Needles bonfire!' WHERE `id`=11785;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Stonetalon Mountains bonfire!' WHERE `id`=11780;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Ghostlands bonfire!' WHERE `id`=11774;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Eversong Woods bonfire!' WHERE `id`=11772;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Swamp of Sorrows bonfire!' WHERE `id`=11781;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Tirisfal Glades bonfire!' WHERE `id`=11786;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Horde''s Badlands bonfire!' WHERE `id`=11766;
-- Horde  Desecrate the flame
DELETE FROM `gameobject_queststarter` WHERE `id` IN (187916,187924,187927,187946,187945,187943,187929,187923,187917,187921,187936,187938,187939,187931,187564,187940,187928,187922,187920,187914,187944,187925,187926,187932,187934,194032,194036,194040,194038,194049,194044,194035,194045,187935,187933,187942,187930,187937,187919,187941);
DELETE FROM `gameobject_questender`   WHERE `id` IN (187916,187924,187927,187946,187945,187943,187929,187923,187917,187921,187936,187938,187939,187931,187564,187940,187928,187922,187920,187914,187944,187925,187926,187932,187934,194032,194036,194040,194038,194049,194044,194035,194045,187935,187933,187942,187930,187937,187919,187941);
INSERT INTO `gameobject_questender` (`id`, `quest`) VALUES
(187916, 11734), -- Ashenvale
(187924, 11741), -- Desolace
(187927, 11744), -- Dustwallow Marsh
(187946, 11763), -- Winterspring
(187945, 11762), -- Tanaris
(187943, 11760), -- Silithus
(187929, 11746), -- Feralas
(187923, 11740), -- Darkshore
(187917, 11735), -- Azuremyst Isle
(187921, 11738), -- Bloodmyst Isle
(187936, 11753), -- Teldrassil
(187938, 11755), -- The Hinterlands
(187939, 11756), -- The Western Plaguelands
(187931, 11748), -- Hillsbrad Foothills
(187564, 11581), -- Westfall
(187940, 11757), -- Wetlands
(187928, 11745), -- Elwynn Forest
(187922, 11739), -- Burning Steppes
(187920, 11737), -- Blasted Lands
(187914, 11732), -- Arathi Highlands
(187944, 11761), -- Cape of Stranglethorn
(187925, 11742), -- Dun Morogh
(187926, 11743), -- Duskwood
(187932, 11749), -- Loch Modan
(187934, 11751), -- Redridge Mountains
(194032, 13440), -- Borean Tundra
(194036, 13443), -- Dragonblight
(194040, 13445), -- Grizzly
(194038, 13444), -- Howling Fjord
(194049, 13449), -- Zul'Drak
(194044, 13446), -- The Storm Peaks
(194035, 13442), -- Sholazar Basin
(194045, 13447), -- Crystalsong Forest
(187935, 11752), -- Shadowmoon Valley
(187933, 11750), -- Nagrand
(187942, 11759), -- Netherstorm
(187930, 11747), -- Hellfire Peninsula
(187937, 11754), -- Terokkar
(187919, 11736), -- Blade's Edge
(187941, 11758); -- Zangarmarsh
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Zul''Drak bonfire!' WHERE `id`=13449;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Crystalsong Forest bonfire!' WHERE `id`=13447;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Storm Peaks bonfire!' WHERE `id`=13446;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Grizzly Hills bonfire!' WHERE `id`=13445;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Howling Fjord bonfire!' WHERE `id`=13444;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Dragonblight bonfire!' WHERE `id`=13443;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Sholazar Basin bonfire!' WHERE `id`=13442;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Borean Tundra bonfire!' WHERE `id`=13440;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Winterspring bonfire!' WHERE `id`=11763;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Tanaris bonfire!' WHERE `id`=11762;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Stranglethorn Vale bonfire!' WHERE `id`=11761;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Silithus bonfire!' WHERE `id`=11760;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Netherstorm bonfire!' WHERE `id`=11759;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Zangarmarsh bonfire!' WHERE `id`=11758;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Wetlands bonfire!' WHERE `id`=11757;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Western Plaguelands bonfire!' WHERE `id`=11756;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Hinterlands bonfire!' WHERE `id`=11755;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Terokkar Forest bonfire!' WHERE `id`=11754;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Teldrassil bonfire!' WHERE `id`=11753;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Shadowmoon Valley bonfire!' WHERE `id`=11752;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Redridge Mountains bonfire!' WHERE `id`=11751;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Nagrand bonfire!' WHERE `id`=11750;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Loch Modan bonfire!' WHERE `id`=11749;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Hillsbrad Foothills Bonfire!' WHERE `id`=11748;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Hellfire Peninsula bonfire!' WHERE `id`=11747;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Feralas bonfire!' WHERE `id`=11746;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Elywnn Forest bonfire!' WHERE `id`=11745;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Dustwallow Marsh bonfire!' WHERE `id`=11744;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Duskwood bonfire!' WHERE `id`=11743;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Dun Morogh bonfire!' WHERE `id`=11742;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Desolace bonfire!' WHERE `id`=11741;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Darkshore bonfire!' WHERE `id`=11740;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Burning Steppes bonfire!' WHERE `id`=11739;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Bloodmyst Isle bonfire!' WHERE `id`=11738;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Blasted Lands bonfire!' WHERE `id`=11737;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Blade''s Edge Mountains bonfire!' WHERE `id`=11736;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Azuremyst Isle bonfire!' WHERE `id`=11735;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Ashenvale bonfire!' WHERE `id`=11734;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Arathi Highlands bonfire!' WHERE `id`=11732;
UPDATE `quest_template` SET `OfferRewardText`='Desecrate the Alliance''s Westfall bonfire!' WHERE `id`=11581;

-- Fix quests Incense for the Festival Scorchlings and Incense for the Summer Scorchlings
DELETE FROM `creature_queststarter` WHERE `quest`=11964;
-- SAI for Festival Talespinner
UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=16818;
DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=16818;
INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
(16818,0,0,0,19,0,100,0,11966,0,0,0,11,46826,0,0,0,0,0,7,0,0,0,0,0,0,0,'Festival Talespinner - On target quest accepted - Cast Flame Keeper Breadcrumb');
-- SAI for Festival Loremaster
UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=16817;
DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=16817;
INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
(16817,0,0,0,19,0,100,0,11964,0,0,0,11,46825,0,0,0,0,0,7,0,0,0,0,0,0,0,'Festival Loremaster - On target quest accepted - Cast Flame Warden Breadcrumb');
-- Whisp of Ragnaros flag not selectable
UPDATE `creature_template` SET `unit_flags`=33554432 WHERE `entry`=26502;
-- SAI for Festival Schorchling
UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=26520;
DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=26520;
DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=2652000;
INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
(26520,0,0,0,8,0,100,0,47104,0,0,0,80,2652000,0,0,0,0,0,1,0,0,0,0,0,0,0,'Festival Scorchling - On spell hit - Run script '),
(2652000,9,1,0,0,0,100,0,0,0,0,0,1,0,2000,0,0,0,0,21,3,0,0,0,0,0,0,'Festival Scorchling - Action list - Say text 0'),
(2652000,9,2,0,0,0,100,0,1000,1000,0,0,1,1,1000,0,0,0,0,1,0,0,0,0,0,0,0,'Festival Scorchling - Action list - Say text 1'),
(2652000,9,3,0,0,0,100,0,2000,2000,0,0,11,47114,0,0,0,0,0,1,0,0,0,0,0,0,0,'Festival Scorchling - Action list - Cast grow'),
(2652000,9,4,0,0,0,100,0,0,0,0,0,1,2,2000,0,0,0,0,1,0,0,0,0,0,0,0,'Festival Scorchling - Action list - Say text 2'),
(2652000,9,5,0,0,0,100,0,3000,3000,0,0,11,47114,0,0,0,0,0,1,0,0,0,0,0,0,0,'Festival Scorchling - Action list - Cast grow'),
(2652000,9,6,0,0,0,100,0,0,0,0,0,1,3,2000,0,0,0,0,1,0,0,0,0,0,0,0,'Festival Scorchling - Action list - Say text 3'),
(2652000,9,7,0,0,0,100,0,3000,3000,0,0,11,47114,0,0,0,0,0,1,0,0,0,0,0,0,0,'Festival Scorchling - Action list - Cast grow'),
(2652000,9,8,0,0,0,100,0,0,0,0,0,1,4,2000,0,0,0,0,1,0,0,0,0,0,0,0,'Festival Scorchling - Action list - Say text 4'),
(2652000,9,9,0,0,0,100,0,1000,1000,0,0,1,5,1000,0,0,0,0,1,0,0,0,0,0,0,0,'Festival Scorchling - Action list - Say text 5'),
(2652000,9,10,0,0,0,100,0,2000,2000,0,0,11,47114,0,0,0,0,0,1,0,0,0,0,0,0,0,'Festival Scorchling - Action list - Cast grow'),
(2652000,9,11,0,0,0,100,0,0,0,0,0,1,6,2000,0,0,0,0,1,0,0,0,0,0,0,0,'Festival Scorchling - Action list - Say text 6'),
(2652000,9,12,0,0,0,100,0,3000,3000,0,0,11,47114,0,0,0,0,0,1,0,0,0,0,0,0,0,'Festival Scorchling - Action list - Cast grow'),
(2652000,9,13,0,0,0,100,0,0,0,0,0,1,7,2000,0,0,0,0,1,0,0,0,0,0,0,0,'Festival Scorchling - Action list - Say text 7'),
(2652000,9,14,0,0,0,100,0,0,0,0,0,11,47120,0,0,0,0,0,1,0,0,0,0,0,0,0,'Festival Scorchling - Action list - Summon Whisp of Ragnaros'),
(2652000,9,15,0,0,0,100,0,0,0,0,0,75,45889,0,0,0,0,0,11,26502,10,0,0,0,0,0,'Festival Scorchling - Action list - Aura Scorchling Blast'),
(2652000,9,16,0,0,0,100,0,3000,3000,0,0,11,47114,0,0,0,0,0,1,0,0,0,0,0,0,0,'Festival Scorchling - Action list - Cast grow'),
(2652000,9,17,0,0,0,100,0,0,0,0,0,41,0,0,0,0,0,0,11,26502,10,0,0,0,0,0,'Festival Scorchling - Action list - Despawn Whisp of Ragnaros '),
(2652000,9,18,0,0,0,100,0,0,0,0,0,1,8,2000,0,0,0,0,1,0,0,0,0,0,0,0,'Festival Scorchling - Action list - Say text 8'),
(2652000,9,19,0,0,0,100,0,0,0,0,0,11,47114,0,0,0,0,0,1,0,0,0,0,0,0,0,'Festival Scorchling - Action list - Cast grow'),
(2652000,9,20,0,0,0,100,0,0,0,0,0,1,9,1000,0,0,0,0,1,0,0,0,0,0,0,0,'Festival Scorchling - Action list - Say text 9'),
(2652000,9,21,0,0,0,100,0,1000,1000,0,0,11,46660,0,0,0,0,0,1,0,0,0,0,0,0,0,'Festival Scorchling - Action list - Cast Extinguished'),
(2652000,9,22,0,0,0,100,0,0,0,0,0,28,47114,0,0,0,0,0,1,0,0,0,0,0,0,0,'Festival Scorchling - Action list - Remove aura from grow'),
(2652000,9,23,0,0,0,100,0,3000,3000,0,0,1,10,2000,0,0,0,0,1,0,0,0,0,0,0,0,'Festival Scorchling - Action list - Say text 10');
-- Festival Scorchling texts
DELETE FROM `creature_text` WHERE `entry`= 26520;
INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`,`BroadcastTextId`) VALUES
(26520,0,0,'Thank you again, $n, for this delectable incense.',12,0,100,1,1000,0,'Festival Scorchling',25699),
(26520,1,0,'%s devours the incense.  It\'s ravenous!',16,0,100,1,1000,0,'Festival Scorchling',25717),
(26520,2,0,'So good! So packed with energy!',12,0,100,1,1000,0,'Festival Scorchling',25718),
(26520,3,0,'It has everything a growing scorchling needs!',12,0,100,1,1000,0,'Festival Scorchling',25719),
(26520,4,0,'I can feel the power SURGING within me!',12,0,100,1,1000,0,'Festival Scorchling',25730),
(26520,5,0,'%s bellows with laughter!',16,0,100,1,1000,0,'Festival Scorchling',25720),
(26520,6,0,'Now! Finally! Our plans can take effect!',12,0,100,1,1000,0,'Festival Scorchling',25721),
(26520,7,0,'KNEEL, LITTLE MORTAL! KNEEL BEFORE THE MIGHT OF THE HERALD OF RAGNAROS!',12,0,100,1,1000,0,'Festival Scorchling',25722),
(26520,8,0,'YOU WILL ALL PERISH IN FLAMES!',12,0,100,1,1000,0,'Festival Scorchling',25723),
(26520,9,0,'%s blinks...',16,0,100,1,1000,0,'Festival Scorchling',25724),
(26520,10,0,'Ah. I was merely jesting...',12,0,100,1,1000,0,'Festival Scorchling',25725);
-- SAI for Summer Schorchling
UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=26401;
DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=26401;
DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=2640100;
INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
(26401,0,0,0,8,0,100,0,47104,0,0,0,80,2640100,0,0,0,0,0,1,0,0,0,0,0,0,0,'Summer Scorchling - On spell hit - Start script'),
(2640100,9,1,0,0,0,100,0,0,0,0,0,1,0,2000,0,0,0,0,21,3,0,0,0,0,0,0,'Summer Scorchling - Action list - Say text 0'),
(2640100,9,2,0,0,0,100,0,1000,1000,0,0,1,1,1000,0,0,0,0,1,0,0,0,0,0,0,0,'Summer Scorchling - Action list - Say text 1'),
(2640100,9,3,0,0,0,100,0,2000,2000,0,0,11,47114,0,0,0,0,0,1,0,0,0,0,0,0,0,'Summer Scorchling - Action list - Cast grow'),
(2640100,9,4,0,0,0,100,0,0,0,0,0,1,2,2000,0,0,0,0,1,0,0,0,0,0,0,0,'Summer Scorchling - Action list - Say text 2'),
(2640100,9,5,0,0,0,100,0,3000,3000,0,0,11,47114,0,0,0,0,0,1,0,0,0,0,0,0,0,'Actionlist - Action 5 - Cast grow'),
(2640100,9,6,0,0,0,100,0,0,0,0,0,1,3,2000,0,0,0,0,1,0,0,0,0,0,0,0,'Summer Scorchling - Action list - Say text 3'),
(2640100,9,7,0,0,0,100,0,3000,3000,0,0,11,47114,0,0,0,0,0,1,0,0,0,0,0,0,0,'Summer Scorchling - Action list - Cast grow'),
(2640100,9,8,0,0,0,100,0,0,0,0,0,1,4,2000,0,0,0,0,1,0,0,0,0,0,0,0,'Summer Scorchling - Action list - Say text 4'),
(2640100,9,9,0,0,0,100,0,1000,1000,0,0,1,5,1000,0,0,0,0,1,0,0,0,0,0,0,0,'Summer Scorchling - Action list - Say text 5'),
(2640100,9,10,0,0,0,100,0,2000,2000,0,0,11,47114,0,0,0,0,0,1,0,0,0,0,0,0,0,'Summer Scorchling - Action list - Cast grow'),
(2640100,9,11,0,0,0,100,0,0,0,0,0,1,6,2000,0,0,0,0,1,0,0,0,0,0,0,0,'Summer Scorchling - Action list - Say text 6'),
(2640100,9,12,0,0,0,100,0,3000,3000,0,0,11,47114,0,0,0,0,0,1,0,0,0,0,0,0,0,'Summer Scorchling - Action list - Cast grow'),
(2640100,9,13,0,0,0,100,0,0,0,0,0,1,7,2000,0,0,0,0,1,0,0,0,0,0,0,0,'Summer Scorchling - Action list - Say text 7'),
(2640100,9,14,0,0,0,100,0,0,0,0,0,11,47120,0,0,0,0,0,1,0,0,0,0,0,0,0,'Summer Scorchling - Action list - Summon Whisp of Ragnaros'),
(2640100,9,15,0,0,0,100,0,0,0,0,0,75,45889,0,0,0,0,0,11,26502,10,0,0,0,0,0,'Summer Scorchling - Action list - Aura Scorchling Blast'),
(2640100,9,16,0,0,0,100,0,3000,3000,0,0,11,47114,0,0,0,0,0,1,0,0,0,0,0,0,0,'Summer Scorchling - Action list - Cast grow'),
(2640100,9,17,0,0,0,100,0,0,0,0,0,41,0,0,0,0,0,0,11,26502,10,0,0,0,0,0,'Summer Scorchling - Action list - Despawn Whisp of Ragnaros '),
(2640100,9,18,0,0,0,100,0,0,0,0,0,1,8,2000,0,0,0,0,1,0,0,0,0,0,0,0,'Summer Scorchling - Action list - Say text 8'),
(2640100,9,19,0,0,0,100,0,0,0,0,0,11,47114,0,0,0,0,0,1,0,0,0,0,0,0,0,'Summer Scorchling - Action list - Cast grow'),
(2640100,9,20,0,0,0,100,0,0,0,0,0,1,9,1000,0,0,0,0,1,0,0,0,0,0,0,0,'Summer Scorchling - Action list - Say text 9'),
(2640100,9,21,0,0,0,100,0,1000,1000,0,0,11,46660,0,0,0,0,0,1,0,0,0,0,0,0,0,'Summer Scorchling - Action list - Cast Extinguished'),
(2640100,9,22,0,0,0,100,0,0,0,0,0,28,47114,0,0,0,0,0,1,0,0,0,0,0,0,0,'Summer Scorchling - Action list - Remove aura from grow'),
(2640100,9,23,0,0,0,100,0,3000,3000,0,0,1,10,2000,0,0,0,0,1,0,0,0,0,0,0,0,'Summer Scorchling - Action list - Say text 10');
-- Summer Scorchling texts
DELETE FROM `creature_text` WHERE `entry`= 26401;
INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`,`BroadcastTextId`) VALUES
(26401,0,0,'Thank you again, $n, for this delectable incense.',12,0,100,1,1000,0,'Summer Scorchling',25699),
(26401,1,0,'%s devours the incense.  It\'s ravenous!',16,0,100,1,1000,0,'Summer Scorchling',25717),
(26401,2,0,'So good! So packed with energy!',12,0,100,1,1000,0,'Summer Scorchling',25718),
(26401,3,0,'It has everything a growing scorchling needs!',12,0,100,1,1000,0,'Summer Scorchling',25719),
(26401,4,0,'I can feel the power SURGING within me!',12,0,100,1,1000,0,'Summer Scorchling',25730),
(26401,5,0,'%s bellows with laughter!',16,0,100,1,1000,0,'Summer Scorchling',25720),
(26401,6,0,'Now! Finally! Our plans can take effect!',12,0,100,1,1000,0,'Summer Scorchling',25721),
(26401,7,0,'KNEEL, LITTLE MORTAL! KNEEL BEFORE THE MIGHT OF THE HERALD OF RAGNAROS!',12,0,100,1,1000,0,'Summer Scorchling',25722),
(26401,8,0,'YOU WILL ALL PERISH IN FLAMES!',12,0,100,1,1000,0,'Summer Scorchling',25723),
(26401,9,0,'%s blinks...',16,0,100,1,1000,0,'Summer Scorchling',25724),
(26401,10,0,'Ah. I was merely jesting...',12,0,100,1,1000,0,'Summer Scorchling',25725);
-- Add conditions for spell Scorchling Gets Incense
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=47104;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition` ,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
(13,1,47104,0,1,31,0,3,26520,0,0,0,'','Scorchling gets incense can hit Festival Scorchling'),
(13,1,47104,0,2,31,0,3,26401,0,0,0,'','Scorchling gets incense can hit Summer Scorchling');


-- Add missing spawns,misc changes gameobjects/creatures related to Midsummer event
UPDATE `gameobject` SET `position_x`=-7596.67, `position_y`=-2079.81, `position_z`=125.968, `orientation`=3.20786, `rotation2`=0.999451, `rotation3`=-0.0331301 WHERE `guid`=52517 AND `id`=188021;
UPDATE `gameobject` SET `position_x`=-7591.5, `position_y`=-2080.49, `position_z`=126.518 WHERE `guid`=50934 AND `id`=181307;
UPDATE `creature` SET `orientation`=3.14884 WHERE `guid`=202758;
UPDATE `creature` SET `modelid`=21085 WHERE `guid`=202746;
UPDATE `creature` SET `modelid`=21086 WHERE `guid`=202749;
UPDATE `creature` SET `modelid`=16436 WHERE `guid`=202748;

DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID AND @OGUID+39;
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
(@OGUID+0, 181355, 1, 1, 1, -2335.13, -621.407, -7.62503, 5.5, 0, 0, 0.414693, 0.909961, 180, 100, 1), -- Mulgore
(@OGUID+1, 188020, 1, 1, 1, -2327.16, -631.314, -8.68343, 5.5, 0, 0, 0.398749, 0.91706, 180, 100, 1),
(@OGUID+2, 181605, 1, 1, 1, -2342.39, -609.245, -7.76984, 5.5, 0, 0, 0.25038, -0.968148, 0, 100, 1),
(@OGUID+3, 181306, 1, 1, 1, -2323.77, -610.206, -9.16689, 5.5, 0, 0, 0.843391, 0.5373, 180, 100, 1),
(@OGUID+4, 181302, 1, 1, 1, -2326.25, -610.633, -8.98158, 1.58409, 0, 0, 0.711791, 0.702392, 180, 100, 1),
(@OGUID+5, 181302, 1, 1, 1, -2325.28, -608.627, -9.18096, 1.58409, 0, 0, 0.711791, 0.702392, 180, 100, 1),
(@OGUID+6, 188020, 1, 1, 1, -2318.53, -608.976, -9.42005, 5.5, 0, 0, 0.469472, 0.882948, 180, 100, 1),
(@OGUID+7, 188021, 1, 1, 1, -2326.65, -613.461, -8.78372, 1.19925, 0, 0, 0.564334, 0.825546, 180, 100, 1),
(@OGUID+8, 181355, 1, 1, 1, -2330.4, -606.562, -8.87822, 5.5, 0, 0, 0.414693, 0.909961, 180, 100, 1),
(@OGUID+9, 187965, 1, 1, 1, -2329.42, -624.806, -8.27507, 5.5, 0, 0, 0.766044, -0.642788, 0, 100, 1),
(@OGUID+10, 181376, 1, 1, 1, -2329.42, -624.806, -6.27507, 5.5, 0, 0, -0.34202, 0.939693, 180, 0, 1),
(@OGUID+11, 188020, 1, 1, 1, -2337.14, -602.794, -8.71659, 5.5, 0, 0, 0.477159, 0.878817, 180, 100, 1),
(@OGUID+12, 181355, 1, 1, 1, -2320.03, -612.344, -9.38502, 5.5, 0, 0, 0.21644, -0.976296, 180, 100, 1),
(@OGUID+13, 188020, 1, 1, 1, -2348.37, -615.991, -6.85173, 5.82288, 0, 0, 0.228128, -0.973631, 300, 0, 1),
(@OGUID+14, 181305, 1, 1, 1, -2330.42, -611.458, -8.53482, 6.06204, 0, 0, 0.110346, -0.993893, 300, 0, 1),
(@OGUID+15, 181307, 1, 1, 1, -2330.98, -609.979, -7.54302, 5.68898, 0, 0, 0.292752, -0.956188, 300, 0, 1),
(@OGUID+16, 181305, 0, 1, 1, -7591.14, -2081, 125.519, 3.49137, 0, 0, 0.984746, -0.174, 300, 0, 1), -- Burning Steppes
(@OGUID+17, 181302, 0, 1, 1, -7594.62, -2076.47, 126.604, 3.71993, 0, 0, 0.958482, -0.285154, 300, 0, 1),
(@OGUID+18, 181355, 0, 1, 1, -6685.84, -2205.18, 249.466, 3.56287, 0, 0, 0.977897, -0.209085, 300, 0, 1),-- Badlands
(@OGUID+19, 181355, 0, 1, 1, -6685.35, -2190.66, 247.391, 4.19511, 0, 0, 0.864441, -0.502734, 300, 0, 1),
(@OGUID+20, 181355, 0, 1, 1, -6710.1, -2202.15, 248.991, 6.13819, 0, 0, 0.0724366, -0.997373, 300, 0, 1),
(@OGUID+21, 188021, 0, 1, 1, -140.643, -811.518, 55.3504, 2.31117, 0, 0, 0.915031, 0.403384, 300, 0, 1),-- Hillsbrad Foothills
(@OGUID+22, 188021, 530, 1, 1, -2238.65, -11884.9, 27.2942, 5.0887, 0, 0, 0.562366, -0.826888, 300, 0, 1),-- Bloodmyst Isle
(@OGUID+23, 181355, 530, 1, 1, -2247.36, -11891.2, 27.273, 5.12561, 0, 0, 0.547009, -0.837127, 300, 0, 1),
(@OGUID+24, 181376, 530, 1, 1, -2254.78, -11896.3, 27.4979, 5.24028, 0, 0, 0.498141, -0.867096, 300, 0, 1),
(@OGUID+25, 187921, 530, 1, 1, -2254.78, -11896.3, 27.4979, 5.24028, 0, 0, 0.498141, -0.867096, 300, 0, 1),
(@OGUID+26, 181355, 530, 1, 1, -2263.35, -11897.7, 27.4214, 4.9112, 0, 0, 0.633442, -0.77379, 300, 0, 1),
(@OGUID+27, 188020, 530, 1, 1, -2267.6, -11910.3, 26.5801, 3.82107, 0, 0, 0.942842, -0.333239, 300, 0, 1),
(@OGUID+28, 181305, 530, 1, 1, -2234.49, -11884.7, 29.2704, 2.36494, 0, 0, 0.925544, 0.378641, 300, 0, 1),
(@OGUID+29, 181307, 530, 1, 1, -2233.15, -11884.7, 30.2608, 3.17861, 0, 0, 0.999829, -0.0185081, 300, 0, 1),
(@OGUID+30, 181605, 530, 1, 1, -2232.01, -11915.4, 26.5822, 1.82694, 0, 0, 0.791628, 0.611003, 300, 0, 1),
(@OGUID+31, 188020, 530, 1, 1, -2246.85, -11930.2, 27.0976, 3.92552, 0, 0, 0.92416, -0.382005, 300, 0, 1),
(@OGUID+32, 181355, 530, 1, 1, -2229.91, -11931.1, 29.9614, 2.41049, 0, 0, 0.933927, 0.357465, 300, 0, 1),
(@OGUID+33, 188020, 530, 1, 1, -2206.14, -11905.5, 29.0653, 0.581295, 0, 0, 0.286573, 0.958058, 300, 0, 1),
(@OGUID+34, 188020, 530, 1, 1, -2218.01, -11884.8, 29.2497, 3.56425, 0, 0, 0.977754, -0.209757, 300, 0, 1),
(@OGUID+35, 181355, 530, 1, 1, -2207.24, -11920.6, 31.7791, 1.97971, 0, 0, 0.835947, 0.548811, 300, 0, 1),
(@OGUID+36, 181355, 530, 1, 1, -2224.91, -11879.8, 29.7914, 1.97971, 0, 0, 0.835947, 0.548811, 300, 0, 1),
(@OGUID+37, 181302, 530, 1, 1, -2243.58, -11886.5, 28.3418, 0.455247, 0, 0, 0.225663, 0.974205, 300, 0, 1),
(@OGUID+38, 181302, 530, 1, 1, -2241.55, -11887.8, 28.4584, 1.37809, 0, 0, 0.635801, 0.771853, 300, 0, 1),
(@OGUID+39, 181306, 530, 1, 1, -2243.06, -11888.3, 28.1292, 1.35453, 0, 0, 0.626664, 0.77929, 300, 0, 1);
DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID AND @CGUID+31;
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
(@CGUID, 16781, 1, 1, 1, 16446, 0, -2336.91, -619.347, -7.48957, 1.3426, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Mulgore
(@CGUID+1, 16781, 1, 1, 1, 16438, 0, -2333.01, -607.47, -8.5825, 4.26458, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+2, 16781, 1, 1, 1, 16445, 0, -2336.15, -605.978, -8.47793, 5.03898, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+3, 16781, 1, 1, 1, 16438, 0, -2336.28, -611.022, -8.02869, 1.1973, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+4, 25994, 1, 1, 1, 23789, 1, -2344.99, -615.533, -7.06313, 0.976602, 300, 0, 0, 1651, 0, 0, 0, 0, 0),
(@CGUID+5, 16781, 0, 1, 1, 21083, 0, -8255.11, -2614.33, 133.154, 0.508745, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Burning Steppes
(@CGUID+6, 16781, 0, 1, 1, 16413, 0, -8253.26, -2611.61, 133.154, 4.93446, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+7, 16781, 0, 1, 1, 16412, 0, -8262.75, -2643.66, 133.39, 5.27218, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+8, 16781, 0, 1, 1, 16435, 0, -8259.55, -2650.01, 133.476, 2.09132, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+9, 25962, 0, 1, 1, 23791, 0, -8245.74, -2607.85, 133.155, 3.51183, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+10, 25962, 0, 1, 1, 23791, 0, 992.05, -1438.97, 64.3942, 5.22073, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Western Plaguelands
(@CGUID+11, 16781, 0, 1, 1, 16435, 0, 989.633, -1444.97, 63.2034, 0.579809, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+12, 16781, 0, 1, 1, 16447, 0, 1003.8, -1434.55, 63.5274, 3.86513, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+13, 16781, 0, 1, 1, 16412, 0, 997.675, -1428.17, 65.905, 4.35443, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+14, 16781, 0, 1, 1, 16431, 0, 1007.68, -1441.76, 62.6307, 2.69567, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+15, 25909, 0, 1, 1, 16339, 0, 1002.08, -1454.41, 61.1954, 5.05265, 300, 0, 0, 42, 0, 0, 0, 0, 0),
(@CGUID+16, 16781, 530, 1, 1, 16414, 0, -2227.85, -11887.9, 28.3225, 4.4168, 300, 0, 0, 1524, 0, 0, 0, 0, 0),-- Bloodmyst Isle
(@CGUID+17, 16781, 530, 1, 1, 16434, 0, -2230.5, -11891.1, 27.6743, 0.651601, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+18, 16781, 530, 1, 1, 16412, 0, -2246.13, -11921, 25.4183, 6.15017, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+19, 16781, 530, 1, 1, 21083, 0, -2240.57, -11922.3, 26.6757, 2.72819, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+20, 25962, 530, 1, 1, 23791, 0, -2224.37, -11912.7, 26.95, 2.63237, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+21, 25962, 1, 1, 1, 23791, 0, -4426.59, 3463.45, 14.9376, 6.14436, 300, 0, 0, 1524, 0, 0, 0, 0, 0),-- Feralas
(@CGUID+22, 16781, 1, 1, 1, 16433, 0, -4406.22, 3458.47, 13.1618, 2.99649, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+23, 16781, 1, 1, 1, 16447, 0, -4408.65, 3454.41, 14.0291, 1.02042, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+24, 16781, 1, 1, 1, 16414, 0, -4411.13, 3457.27, 13.6321, 6.03912, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+25, 16781, 1, 1, 1, 16413, 0, -4417.18, 3487.8, 12.7708, 5.29378, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+26, 16781, 530, 1, 1, 16413, 0, -4204.91, -12289.1, 1.57936, 1.63705, 300, 0, 0, 1524, 0, 0, 0, 0, 0),-- Azuremyst Isle
(@CGUID+27, 16781, 530, 1, 1, 16412, 0, -4205.15, -12284.2, 2.51655, 4.81948, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+28, 16781, 530, 1, 1, 21084, 0, -4204.2, -12322.9, 2.18588, 1.49174, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+29, 16781, 530, 1, 1, 16433, 0, -4204.16, -12316.3, 1.96402, 4.73543, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+30, 16781, 530, 1, 1, 16448, 0, -4194.72, -12303.8, 0.665216, 3.58718, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+31, 25962, 530, 1, 1, 23791, 0, -4189.94, -12310.1, -0.885672, 3.28087, 300, 0, 0, 1524, 0, 0, 0, 0, 0);
-- Outland Horde
DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+40 AND @OGUID+73;
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
(@OGUID+40, 188021, 530, 1, 1, -3065.99, 2385.69, 62.3736, 2.08047, 0, 0, 0.862523, 0.506019, 300, 0, 1), -- Shadowmoon Valley
(@OGUID+41, 188020, 530, 1, 1, -3045.07, 2384.62, 62.3369, 3.34888, 0, 0, 0.994634, -0.10346, 300, 0, 1),
(@OGUID+42, 181605, 530, 1, 1, -3045.53, 2393.71, 61.5344, 3.48476, 0, 0, 0.985316, -0.170741, 300, 0, 1),
(@OGUID+43, 181355, 530, 1, 1, -3051.54, 2384.15, 62.8406, 3.5845, 0, 0, 0.975579, -0.21965, 300, 0, 1),
(@OGUID+44, 181376, 530, 1, 1, -3059.17, 2374.85, 65.1011, 2.03334, 0, 0, 0.850361, 0.526199, 300, 0, 1),
(@OGUID+45, 187967, 530, 1, 1, -3059.17, 2374.85, 63.1011, 2.03334, 0, 0, 0.850361, 0.526199, 300, 0, 1),
(@OGUID+46, 188020, 530, 1, 1, -3082.82, 2371.64, 62.3845, 0.325101, 0, 0, 0.161836, 0.986818, 300, 0, 1),
(@OGUID+47, 181305, 530, 1, 1, -3067.53, 2387.47, 62.1022, 2.2666, 0, 0, 0.905816, 0.423671, 300, 0, 1),
(@OGUID+48, 181307, 530, 1, 1, -3066.21, 2387.82, 63.0923, 2.58076, 0, 0, 0.96094, 0.276755, 300, 0, 1),
(@OGUID+49, 181306, 530, 1, 1, -3061.06, 2385.06, 62.9053, 3.68032, 0, 0, 0.963941, -0.266117, 300, 0, 1),
(@OGUID+50, 181302, 530, 1, 1, -3062.49, 2384.41, 62.8574, 3.88531, 0, 0, 0.931654, -0.363346, 300, 0, 1),
(@OGUID+51, 181302, 530, 1, 1, -3062.11, 2386.29, 62.7605, 3.23892, 0, 0, 0.998816, -0.0486467, 300, 0, 1),
(@OGUID+52, 181355, 530, 1, 1, -3083.01, 2388.64, 62.5579, 5.67117, 0, 0, 0.301252, -0.953545, 300, 0, 1),
(@OGUID+53, 181355, 530, 1, 1, -3075.49, 2375.19, 61.7323, 5.22193, 0, 0, 0.506076, -0.862489, 300, 0, 1),
(@OGUID+54, 181355, 530, 1, 1, -3065.87, 2401.47, 61.8687, 5.24138, 0, 0, 0.497663, -0.86737, 300, 0, 1),
(@OGUID+55, 188020, 530, 1, 1, -3088.61, 2389.5, 61.8999, 0.53056, 0, 0, 0.26218, 0.965019, 300, 0, 1),
(@OGUID+56, 188020, 530, 1, 1, -3062.43, 2404.35, 61.4089, 3.57398, 0, 0, 0.976721, -0.214514, 300, 0, 1),
(@OGUID+57, 188021, 530, 1, 1, 2930.82, 3700.62, 143.562, 2.68546, 0, 0, 0.974105, 0.226094, 300, 0, 1),-- Netherstorm
(@OGUID+58, 188020, 530, 1, 1, 2939, 3710.42, 143.775, 5.91502, 0, 0, 0.183045, -0.983104, 300, 0, 1),
(@OGUID+59, 188020, 530, 1, 1, 2929.71, 3714.03, 144.258, 5.84826, 0, 0, 0.215752, -0.976448, 300, 0, 1),
(@OGUID+60, 188020, 530, 1, 1, 2926.49, 3680.92, 143.656, 5.85611, 0, 0, 0.211916, -0.977288, 300, 0, 1),
(@OGUID+61, 188020, 530, 1, 1, 2914.81, 3686.23, 144.3, 5.85611, 0, 0, 0.211916, -0.977288, 300, 0, 1),
(@OGUID+62, 181355, 530, 1, 1, 2916.61, 3688.95, 144.099, 5.95036, 0, 0, 0.165644, -0.986186, 300, 0, 1),
(@OGUID+63, 181355, 530, 1, 1, 2936.48, 3709.34, 143.92, 1.22619, 0, 0, 0.575402, 0.817871, 300, 0, 1),
(@OGUID+64, 181355, 530, 1, 1, 2930.48, 3712.12, 144.464, 5.82155, 0, 0, 0.228773, -0.97348, 300, 0, 1),
(@OGUID+65, 181355, 530, 1, 1, 2924.86, 3684.41, 143.645, 5.79079, 0, 0, 0.243717, -0.969846, 300, 0, 1),
(@OGUID+66, 181376, 530, 1, 1, 2921.26, 3690.47, 145.838, 5.94709, 0, 0, 0.167258, -0.985913, 300, 0, 1),
(@OGUID+67, 187949, 530, 1, 1, 2922.17, 3690.15, 143.809, 5.94709, 0, 0, 0.167258, -0.985913, 300, 0, 1),
(@OGUID+68, 181605, 530, 1, 1, 2917.63, 3677.32, 144.166, 1.11217, 0, 0, 0.527867, 0.849327, 300, 0, 1),
(@OGUID+69, 181305, 530, 1, 1, 2929.17, 3694.77, 143.652, 3.48177, 0, 0, 0.98557, -0.169269, 300, 0, 1),
(@OGUID+70, 181307, 530, 1, 1, 2927.52, 3695.79, 144.646, 6.06337, 0, 0, 0.109686, -0.993966, 300, 0, 1),
(@OGUID+71, 181302, 530, 1, 1, 2934.2, 3699.41, 143.281, 5.29132, 0, 0, 0.475852, -0.879525, 300, 0, 1),
(@OGUID+72, 181302, 530, 1, 1, 2932.66, 3699.09, 143.42, 3.97499, 0, 0, 0.91443, -0.404745, 300, 0, 1),
(@OGUID+73, 181306, 530, 1, 1, 2933.35, 3701.68, 143.353, 4.69363, 0, 0, 0.713707, -0.700444, 300, 0, 1);
DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+32 AND @CGUID+47;
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
(@CGUID+32, 16781, 530, 1, 1, 21085, 0, -3061.44, 2392.12, 62.0978, 0.0381287, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Shadowmoon Valley
(@CGUID+33, 16781, 530, 1, 1, 16438, 0, -3058.96, 2387.94, 62.7011, 1.21073, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+34, 16781, 530, 1, 1, 16443, 0, -3055.48, 2394.64, 61.4168, 3.79155, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+35, 16781, 530, 1, 1, 16432, 0, -3047.02, 2383.16, 62.5462, 2.35427, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+36, 25994, 530, 1, 1, 23789, 1, -3050.94, 2390.53, 61.9839, 0.536069, 300, 0, 0, 1651, 0, 0, 0, 0, 0),
(@CGUID+37, 16781, 530, 1, 1, 16444, 0, 2269.74, 6134.05, 137.055, 6.04866, 300, 0, 0, 1524, 0, 0, 0, 0, 0),-- Blade's Edge
(@CGUID+38, 16781, 530, 1, 1, 16442, 0, 2271.41, 6128.35, 137.214, 0.679679, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+39, 16781, 530, 1, 1, 21085, 0, 2271.34, 6158.77, 138.457, 0.683606, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+40, 16781, 530, 1, 1, 16436, 0, 2300.8, 6167.7, 136.322, 5.55072, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+41, 16781, 530, 1, 1, 21086, 0, 2304.68, 6161.6, 134.924, 1.72976, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+42, 25994, 530, 1, 1, 23789, 1, 2279.56, 6162.76, 137.703, 0.112621, 300, 0, 0, 1651, 0, 0, 0, 0, 0),
(@CGUID+43, 16781, 530, 1, 1, 16432, 0, 2933.41, 3708.45, 144.048, 5.94399, 300, 0, 0, 1524, 0, 0, 0, 0, 0),-- Netherstorm
(@CGUID+44, 16781, 530, 1, 1, 16431, 0, 2935.32, 3705.25, 143.374, 1.8505, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+45, 16781, 530, 1, 1, 16442, 0, 2917.5, 3683.52, 144.197, 0.0558533, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+46, 16781, 530, 1, 1, 16436, 0, 2922.56, 3684.94, 143.823, 3.96478, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+47, 25994, 530, 1, 1, 23789, 1, 2919.92, 3676.76, 144.123, 1.41695, 300, 0, 0, 1651, 0, 0, 0, 0, 0);
-- Outland Alliance
DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+74 AND @OGUID+142;
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
(@OGUID+74, 188020, 530, 1, 1, 3124.32, 3767.21, 141.72, 6.15712, 0, 0, 0.0629915, -0.998014, 300, 0, 1),-- Netherstorm
(@OGUID+75, 188020, 530, 1, 1, 3118.47, 3768.31, 142, 5.99611, 0, 0, 0.143044, -0.989716, 300, 0, 1),
(@OGUID+76, 188020, 530, 1, 1, 3128.04, 3723.67, 142.125, 3.6241, 0, 0, 0.971039, -0.238921, 300, 0, 1),
(@OGUID+77, 181355, 530, 1, 1, 3129.41, 3728.35, 141.836, 3.15679, 0, 0, 0.999971, -0.00759801, 300, 0, 1),
(@OGUID+78, 181355, 530, 1, 1, 3118.56, 3728.18, 145.543, 3.26674, 0, 0, 0.998043, -0.0625352, 300, 0, 1),
(@OGUID+79, 181355, 530, 1, 1, 3106.03, 3725.62, 144.981, 3.3335, 0, 0, 0.9954, -0.0958082, 300, 0, 1),
(@OGUID+80, 181605, 530, 1, 1, 3113, 3717.87, 144.699, 1.34645, 0, 0, 0.62351, 0.781815, 300, 0, 1),
(@OGUID+81, 181302, 530, 1, 1, 3119, 3742.2, 142.069, 1.01658, 0, 0, 0.486685, 0.873577, 300, 0, 1),
(@OGUID+82, 181302, 530, 1, 1, 3120.72, 3741.49, 141.941, 1.31503, 0, 0, 0.611153, 0.791512, 300, 0, 1),
(@OGUID+83, 181306, 530, 1, 1, 3119.22, 3739.92, 141.977, 1.78627, 0, 0, 0.779042, 0.626972, 300, 0, 1),
(@OGUID+84, 181376, 530, 1, 1, 3121.5, 3753.88, 141.851, 5.85856, 0, 0, 0.21072, -0.977546, 300, 0, 1),
(@OGUID+85, 187942, 530, 1, 1, 3121.5, 3753.88, 141.851, 5.85856, 0, 0, 0.21072, -0.977546, 300, 0, 1),
(@OGUID+86, 188021, 530, 1, 1, 3124.08, 3743.19, 141.84, 0.373246, 0, 0, 0.185542, 0.982636, 300, 0, 1),
(@OGUID+87, 188021, 530, 1, 1, -2518.07, 7554.87, -1.84913, 5.25355, 0, 0, 0.492375, -0.870383, 300, 0, 1),-- Nagrand
(@OGUID+88, 188020, 530, 1, 1, -2503.95, 7557.49, -1.08408, 5.53944, 0, 0, 0.363359, -0.931649, 300, 0, 1),
(@OGUID+89, 181355, 530, 1, 1, -2508.99, 7559.45, -1.49399, 5.21507, 0, 0, 0.509029, -0.860749, 300, 0, 1),
(@OGUID+90, 181305, 530, 1, 1, -2514.58, 7556.29, -1.9083, 3.55317, 0, 0, 0.9789, -0.204338, 300, 0, 1),
(@OGUID+91, 181307, 530, 1, 1, -2514.36, 7557.85, -0.918236, 4.60717, 0, 0, 0.743311, -0.668946, 300, 0, 1),
(@OGUID+92, 181302, 530, 1, 1, -2521.68, 7558.76, -1.93354, 5.38786, 0, 0, 0.43286, -0.901461, 300, 0, 1),
(@OGUID+93, 181302, 530, 1, 1, -2520.13, 7560.14, -1.93178, 4.59147, 0, 0, 0.748542, -0.663088, 300, 0, 1),
(@OGUID+94, 181306, 530, 1, 1, -2519.97, 7558.77, -1.99031, 3.1212, 0, 0, 0.999948, 0.0101965, 300, 0, 1),
(@OGUID+95, 188020, 530, 1, 1, -2528.76, 7534.67, -0.445196, 5.47583, 0, 0, 0.392805, -0.919622, 300, 0, 1),
(@OGUID+96, 181355, 530, 1, 1, -2530.75, 7540.66, -2.24676, 5.41692, 0, 0, 0.419715, -0.907656, 300, 0, 1),
(@OGUID+97, 181376, 530, 1, 1, -2526.69, 7548.83, -2.23534, 5.32817, 0, 0, 0.459565, -0.888144, 300, 0, 1),
(@OGUID+98, 187933, 530, 1, 1, -2526.69, 7548.83, -2.23534, 5.32817, 0, 0, 0.459565, -0.888144, 300, 0, 1),
(@OGUID+99, 188020, 530, 1, 1, -2511.48, 7518.87, -1.20825, 2.42299, 0, 0, 0.936142, 0.351621, 300, 0, 1),
(@OGUID+100, 181355, 530, 1, 1, -2506.01, 7514.91, -3.26091, 2.33267, 0, 0, 0.919314, 0.393525, 300, 0, 1),
(@OGUID+101, 181355, 530, 1, 1, -2485.85, 7534.2, -1.6549, 2.33267, 0, 0, 0.919314, 0.393525, 300, 0, 1),
(@OGUID+102, 188020, 530, 1, 1, -2489.07, 7542.57, -0.865097, 2.31931, 0, 0, 0.916666, 0.399654, 300, 0, 1),
(@OGUID+103, 181605, 530, 1, 1, -2502.95, 7522.09, -2.46418, 2.29811, 0, 0, 0.912378, 0.40935, 300, 0, 1),
(@OGUID+104, 188021, 530, 1, 1, -3953.72, 2048.88, 95.0652, 4.6418, 0, 0, 0.731618, -0.681714, 300, 0, 1),-- Shadowmoon Valley
(@OGUID+105, 181376, 530, 1, 1, -3941.98, 2048.49, 95.0656, 4.87742, 0, 0, 0.646421, -0.762981, 300, 0, 1),
(@OGUID+106, 187935, 530, 1, 1, -3941.98, 2048.49, 95.0656, 4.87742, 0, 0, 0.646421, -0.762981, 300, 0, 1),
(@OGUID+107, 181355, 530, 1, 1, -3959.23, 2040.55, 95.0649, 1.26694, 0, 0, 0.591944, 0.805979, 300, 0, 1),
(@OGUID+108, 181605, 530, 1, 1, -3965.24, 2039.3, 95.0659, 1.35098, 0, 0, 0.625278, 0.780402, 300, 0, 1),
(@OGUID+109, 188020, 530, 1, 1, -3951.26, 2032.03, 95.1979, 1.40988, 0, 0, 0.647988, 0.761651, 300, 0, 1),
(@OGUID+110, 181355, 530, 1, 1, -3947.07, 2032.04, 96.8815, 1.47585, 0, 0, 0.672754, 0.739866, 300, 0, 1),
(@OGUID+111, 188020, 530, 1, 1, -3932.45, 2051.71, 95.072, 0.10612, 0, 0, 0.0530353, 0.998593, 300, 0, 1),
(@OGUID+112, 188020, 530, 1, 1, -3931.76, 2044.1, 95.1721, 6.1741, 0, 0, 0.054514, -0.998513, 300, 0, 1),
(@OGUID+113, 181305, 530, 1, 1, -3951.84, 2053.02, 95.0649, 4.37555, 0, 0, 0.815632, -0.578571, 300, 0, 1),
(@OGUID+114, 181307, 530, 1, 1, -3953.39, 2052.79, 96.0565, 0.143821, 0, 0, 0.0718485, 0.997416, 300, 0, 1),
(@OGUID+115, 181302, 530, 1, 1, -3956.31, 2051.68, 95.0653, 4.80752, 0, 0, 0.672688, -0.739927, 300, 0, 1),
(@OGUID+116, 181302, 530, 1, 1, -3956.72, 2051.26, 96.3085, 0.346454, 0, 0, 0.172362, 0.985034, 300, 0, 1),
(@OGUID+117, 181306, 530, 1, 1, -3958.88, 2051.04, 95.0648, 6.24637, 0, 0, 0.0184091, -0.999831, 300, 0, 1),
(@OGUID+118, 188021, 530, 1, 1, 192.163, 6006.97, 22.1, 6.08217, 0, 0, 0.100341, -0.994953, 300, 0, 1),-- Zangarmarsh
(@OGUID+119, 181376, 530, 1, 1, 194.982, 6019.23, 21.9713, 6.05151, 0, 0, 0.115576, -0.993299, 300, 0, 1),
(@OGUID+120, 187941, 530, 1, 1, 192.209, 6015.13, 22.1067, 0.00709009, 0, 0, 0.00354504, 0.999994, 300, 0, 1),
(@OGUID+121, 188020, 530, 1, 1, 179.856, 6024.08, 22.3978, 3.98117, 0, 0, 0.913175, -0.407568, 300, 0, 1),
(@OGUID+122, 181355, 530, 1, 1, 182.649, 6013.91, 22.7399, 3.85237, 0, 0, 0.937511, -0.347954, 300, 0, 1),
(@OGUID+123, 181305, 530, 1, 1, 191.325, 6003.18, 24.2265, 1.22679, 0, 0, 0.575647, 0.817698, 300, 0, 1),
(@OGUID+124, 181307, 530, 1, 1, 190.107, 6002.77, 25.2167, 1.22679, 0, 0, 0.575647, 0.817698, 300, 0, 1),
(@OGUID+125, 181302, 530, 1, 1, 187.76, 6009.34, 23.9554, 6.21407, 0, 0, 0.0345506, -0.999403, 300, 0, 1),
(@OGUID+126, 181302, 530, 1, 1, 187.695, 6007.28, 24.1424, 0.567843, 0, 0, 0.280122, 0.959964, 300, 0, 1),
(@OGUID+127, 181306, 530, 1, 1, 190.136, 6008.65, 23.9259, 4.04009, 0, 0, 0.900774, -0.434289, 300, 0, 1),
(@OGUID+128, 181355, 530, 1, 1, 199.014, 6031.23, 20.5566, 3.50209, 0, 0, 0.983799, -0.179273, 300, 0, 1),
(@OGUID+129, 188020, 530, 1, 1, 201.225, 6033.47, 20.1022, 3.0819, 0, 0, 0.999555, 0.0298411, 300, 0, 1),
(@OGUID+130, 188020, 530, 1, 1, 201.553, 5989.88, 20.7907, 3.02849, 0, 0, 0.998401, 0.0565203, 300, 0, 1),
(@OGUID+131, 181355, 530, 1, 1, 199.671, 5991.72, 21.7141, 0.161778, 0, 0, 0.0808006, 0.99673, 300, 0, 1),
(@OGUID+132, 181605, 530, 1, 1, 188.262, 5991.39, 23.7141, 3.08425, 0, 0, 0.999589, 0.0286686, 300, 0, 1),
(@OGUID+133, 188020, 530, 1, 1, 177.593, 5991.78, 22.1575, 6.11588, 0, 0, 0.0835527, -0.996503, 300, 0, 1),
(@OGUID+134, 181355, 530, 1, 1, 180.409, 5994.73, 22.8062, 5.91168, 0, 0, 0.184688, -0.982797, 300, 0, 1),
(@OGUID+135, 188021, 530, 1, 1, -3005.53, 4160.88, 4.18469, 0.149162, 0, 0, 0.0745119, 0.99722, 300, 0, 1),-- Terokkar
(@OGUID+136, 181376, 530, 1, 1, -3004.07, 4152.48, 3.64988, 1.75455, 0, 0, 0.769001, 0.639247, 300, 0, 1),
(@OGUID+137, 187937, 530, 1, 1, -3004.07, 4152.48, 3.64988, 1.75455, 0, 0, 0.769001, 0.639247, 300, 0, 1),
(@OGUID+138, 188020, 530, 1, 1, -3007.02, 4177.26, 4.07658, 4.79326, 0, 0, 0.677945, -0.735112, 300, 0, 1),
(@OGUID+139, 181355, 530, 1, 1, -3006.14, 4169.56, 3.93771, 6.15906, 0, 0, 0.0620252, -0.998075, 300, 0, 1),
(@OGUID+140, 181355, 530, 1, 1, -3000.22, 4138.67, 2.05751, 1.71684, 0, 0, 0.756811, 0.653634, 300, 0, 1),
(@OGUID+141, 188020, 530, 1, 1, -2996.65, 4116.85, 4.33362, 1.75611, 0, 0, 0.769498, 0.638649, 300, 0, 1),
(@OGUID+142, 181605, 530, 1, 1, -2988.84, 4126.66, 4.88284, 3.26329, 0, 0, 0.998149, -0.0608107, 300, 0, 1);
DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+48 AND @CGUID+76;
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
(@CGUID+48, 16781, 530, 1, 1, 21084, 0, 3105.5, 3720.48, 144.815, 0.250816, 300, 0, 0, 1524, 0, 0, 0, 0, 0),-- Netherstorm
(@CGUID+49, 16781, 530, 1, 1, 16435, 0, 3115.55, 3726.49, 145.316, 4.10869, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+50, 16781, 530, 1, 1, 16447, 0, 3120.66, 3721, 145.281, 2.74995, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+51, 16781, 530, 1, 1, 16412, 0, 3125.3, 3727.87, 142.621, 5.58132, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+52, 25962, 530, 1, 1, 23791, 0, 3106.88, 3712.88, 144.328, 0.980452, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+53, 16781, 530, 1, 1, 16412, 0, -2504.03, 7528.3, -0.64438, 0.776008, 300, 0, 0, 1524, 0, 0, 0, 0, 0),-- Nagrand
(@CGUID+54, 16781, 530, 1, 1, 16447, 0, -2500.29, 7532.45, -0.97989, 2.51488, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+55, 16781, 530, 1, 1, 16413, 0, -2507.02, 7550.21, -0.997479, 1.49936, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+56, 16781, 530, 1, 1, 16431, 0, -2508.9, 7555.52, -1.63478, 4.96375, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+57, 25962, 530, 1, 1, 23791, 0, -2488.89, 7531.11, -2.0437, 2.29261, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+58, 16781, 530, 1, 1, 16431, 0, -3965.57, 2049.6, 95.0651, 0.431277, 300, 0, 0, 1524, 0, 0, 0, 0, 0),-- Shadowmoon Valley
(@CGUID+59, 16781, 530, 1, 1, 21084, 0, -3960.94, 2053.54, 95.0651, 3.89645, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+60, 16781, 530, 1, 1, 16434, 0, -3972.67, 2034.69, 95.0653, 0.376299, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+61, 16781, 530, 1, 1, 16447, 0, -3968.36, 2038.44, 95.0653, 3.94672, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+62, 25962, 530, 1, 1, 23791, 0, -3962.59, 2045.64, 95.0653, 4.66928, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+63, 16781, 530, 1, 1, 16434, 0, 183.656, 6001.85, 23.9098, 5.76245, 300, 0, 0, 1524, 0, 0, 0, 0, 0),-- Zangarmarsh
(@CGUID+64, 16781, 530, 1, 1, 16433, 0, 183.666, 5998.61, 23.7887, 1.12075, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+65, 16781, 530, 1, 1, 16435, 0, 181.842, 5991.56, 22.9939, 0.808944, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+66, 16781, 530, 1, 1, 16433, 0, 184.16, 5995.16, 23.7236, 4.20658, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+67, 25962, 530, 1, 1, 23791, 0, 191.919, 5998.19, 24.2443, 4.56315, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+68, 25962, 530, 1, 1, 23791, 0, 2050.24, 6603.09, 138.073, 3.04753, 300, 0, 0, 1524, 0, 0, 0, 0, 0),-- Blade's Edge
(@CGUID+69, 16781, 530, 1, 1, 16412, 0, 2048.81, 6582.75, 135.962, 2.2637, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+70, 16781, 530, 1, 1, 16434, 0, 2044.15, 6588.86, 135.588, 5.3888, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+71, 16781, 530, 1, 1, 16448, 0, 2035.12, 6612.1, 138.394, 1.97939, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+72, 16781, 530, 1, 1, 16433, 0, 2031.53, 6616.98, 138.934, 5.30162, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+73, 25962, 530, 1, 1, 23791, 0, -2986.96, 4130.72, 5.04767, 2.64597, 300, 0, 0, 1524, 0, 0, 0, 0, 0),-- Terokkar
(@CGUID+74, 16781, 530, 1, 1, 16448, 0, -2999.23, 4136.4, 2.31857, 4.96681, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+75, 16781, 530, 1, 1, 16434, 0, -2997.71, 4131.23, 3.04313, 1.92339, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+76, 16781, 530, 1, 1, 16442, 0, -2992.17, 4134.37, 3.88179, 3.20281, 300, 0, 0, 1524, 0, 0, 0, 0, 0);
-- Northrend Horde
DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+143 AND @OGUID+268;
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
(@OGUID+143, 188021, 571, 1, 1, 4454.99, 5625.29, 56.8959, 4.29074, 0, 0, 0.839423, -0.543479, 300, 0, 1),-- Borean Tundra
(@OGUID+144, 188020, 571, 1, 1, 4425.93, 5623.18, 54.1981, 1.06747, 0, 0, 0.508751, 0.860913, 300, 0, 1),
(@OGUID+145, 188020, 571, 1, 1, 4438.21, 5646.36, 59.8882, 4.28367, 0, 0, 0.841339, -0.540508, 300, 0, 1),
(@OGUID+146, 188020, 571, 1, 1, 4476.71, 5632.46, 60.6755, 4.46182, 0, 0, 0.789922, -0.613208, 300, 0, 1),
(@OGUID+147, 188020, 571, 1, 1, 4470.92, 5609.85, 56.8847, 4.46182, 0, 0, 0.789922, -0.613208, 300, 0, 1),
(@OGUID+148, 181605, 571, 1, 1, 4470.25, 5621.62, 58.661, 1.19849, 0, 0, 0.56402, 0.825761, 300, 0, 1),
(@OGUID+149, 181355, 571, 1, 1, 4472.86, 5630.19, 59.8352, 4.29296, 0, 0, 0.838819, -0.54441, 300, 0, 1),
(@OGUID+150, 181355, 571, 1, 1, 4468.37, 5613.21, 57.1389, 1.30374, 0, 0, 0.606674, 0.794951, 300, 0, 1),
(@OGUID+151, 181355, 571, 1, 1, 4429.57, 5625.52, 54.9768, 1.37443, 0, 0, 0.634385, 0.773017, 300, 0, 1),
(@OGUID+152, 181355, 571, 1, 1, 4438.18, 5641.68, 58.4478, 1.00136, 0, 0, 0.480023, 0.877256, 300, 0, 1),
(@OGUID+153, 194033, 571, 1, 1, 4441.05, 5627.71, 56.3487, 4.54665, 0, 0, 0.763211, -0.646149, 300, 0, 1),
(@OGUID+154, 181376, 571, 1, 1, 4441.05, 5627.71, 58.3487, 4.69194, 0, 0, 0.714298, -0.699841, 300, 0, 1),
(@OGUID+155, 181305, 571, 1, 1, 4457.34, 5627.04, 57.2747, 0.298436, 0, 0, 0.148665, 0.988888, 300, 0, 1),
(@OGUID+156, 181307, 571, 1, 1, 4457.69, 5628.67, 58.2895, 4.7218, 0, 0, 0.703772, -0.710426, 300, 0, 1),
(@OGUID+157, 181302, 571, 1, 1, 4450.11, 5628.14, 56.7657, 1.65482, 0, 0, 0.73618, 0.676786, 300, 0, 1),
(@OGUID+158, 181302, 571, 1, 1, 4451.86, 5626.77, 56.7422, 0.725691, 0, 0, 0.354936, 0.934891, 300, 0, 1),
(@OGUID+159, 181306, 571, 1, 1, 4450.1, 5626.02, 56.6652, 1.32259, 0, 0, 0.614141, 0.789196, 300, 0, 1),
(@OGUID+160, 188021, 571, 1, 1, 3776.27, 1479.31, 91.7672, 3.0495, 0, 0, 0.99894, 0.0460317, 300, 0, 1),-- Dragonblight
(@OGUID+161, 188020, 571, 1, 1, 3773.6, 1491.79, 90.9616, 4.7656, 0, 0, 0.688046, -0.725667, 300, 0, 1),
(@OGUID+162, 188020, 571, 1, 1, 3779.89, 1492.12, 90.4649, 4.7656, 0, 0, 0.688046, -0.725667, 300, 0, 1),
(@OGUID+163, 181355, 571, 1, 1, 3778.33, 1469.59, 92.0022, 4.64779, 0, 0, 0.729573, -0.683903, 300, 0, 1),
(@OGUID+164, 181355, 571, 1, 1, 3771.26, 1470.33, 92.3044, 1.40802, 0, 0, 0.64728, 0.762252, 300, 0, 1),
(@OGUID+165, 194037, 571, 1, 1, 3773.85, 1464.02, 92.4174, 6.10863, 0, 0, 0.087167, -0.996194, 300, 0, 1),
(@OGUID+166, 181376, 571, 1, 1, 3773.85, 1464.02, 94.4174, 6.10863, 0, 0, 0.087167, -0.996194, 300, 0, 1),
(@OGUID+167, 181305, 571, 1, 1, 3781.69, 1479.45, 91.1799, 3.55216, 0, 0, 0.979003, -0.203846, 300, 0, 1),
(@OGUID+168, 181307, 571, 1, 1, 3781.29, 1478.05, 92.1919, 4.88734, 0, 0, 0.642628, -0.766178, 300, 0, 1),
(@OGUID+169, 181302, 571, 1, 1, 3777.92, 1483, 91.6054, 3.43435, 0, 0, 0.989306, -0.145857, 300, 0, 1),
(@OGUID+170, 181302, 571, 1, 1, 3776.35, 1482.86, 91.7922, 4.69099, 0, 0, 0.714632, -0.699501, 300, 0, 1),
(@OGUID+171, 181306, 571, 1, 1, 3777.17, 1481, 91.7202, 2.13923, 0, 0, 0.877016, 0.480461, 300, 0, 1),
(@OGUID+172, 181605, 571, 1, 1, 3776.57, 1488.67, 91.3695, 0.109765, 0, 0, 0.0548551, 0.998494, 300, 0, 1),
(@OGUID+173, 181358, 571, 1, 1, 3807.96, 1478.17, 90.0332, 3.09271, 0, 0, 0.999701, 0.0244413, 300, 0, 1),
(@OGUID+174, 188021, 571, 1, 1, 3367.71, -2126.35, 124.935, 0.20145, 0, 0, 0.100555, 0.994932, 300, 0, 1),-- Grizzly Hills
(@OGUID+175, 188020, 571, 1, 1, 3378.53, -2152.36, 124.326, 1.7272, 0, 0, 0.760187, 0.649704, 300, 0, 1),
(@OGUID+176, 188020, 571, 1, 1, 3364.78, -2153.98, 124.066, 1.67615, 0, 0, 0.743357, 0.668895, 300, 0, 1),
(@OGUID+177, 188020, 571, 1, 1, 3368.13, -2094.44, 122.167, 4.85309, 0, 0, 0.655653, -0.755062, 300, 0, 1),
(@OGUID+178, 188020, 571, 1, 1, 3358.46, -2095.84, 122.702, 4.85702, 0, 0, 0.65417, -0.756348, 300, 0, 1),
(@OGUID+179, 181355, 571, 1, 1, 3360.44, -2102.71, 123.301, 4.93556, 0, 0, 0.623972, -0.781447, 300, 0, 1),
(@OGUID+180, 181355, 571, 1, 1, 3366.44, -2142.59, 124.385, 0.12135, 0, 0, 0.060638, 0.99816, 300, 0, 1),
(@OGUID+181, 181355, 571, 1, 1, 3372.23, -2141.88, 124.779, 0.12135, 0, 0, 0.060638, 0.99816, 300, 0, 1),
(@OGUID+182, 181305, 571, 1, 1, 3368.46, -2120.32, 124.972, 4.52273, 0, 0, 0.770885, -0.636974, 300, 0, 1),
(@OGUID+183, 181307, 571, 1, 1, 3367.51, -2120.73, 125.963, 0.112713, 0, 0, 0.0563269, 0.998412, 300, 0, 1),
(@OGUID+184, 181302, 571, 1, 1, 3364.09, -2126.28, 124.594, 1.64817, 0, 0, 0.733926, 0.67923, 300, 0, 1),
(@OGUID+185, 181302, 571, 1, 1, 3363.96, -2124.64, 124.71, 0.774805, 0, 0, 0.377785, 0.925894, 300, 0, 1),
(@OGUID+186, 181306, 571, 1, 1, 3365.8, -2125.85, 124.807, 4.92171, 0, 0, 0.629368, -0.777107, 300, 0, 1),
(@OGUID+187, 181355, 571, 1, 1, 3368.61, -2102.49, 122.991, 3.15926, 0, 0, 0.999961, -0.00883358, 300, 0, 1),
(@OGUID+188, 181605, 571, 1, 1, 3370.82, -2150.59, 124.43, 1.7102, 0, 0, 0.754638, 0.656142, 300, 0, 1),
(@OGUID+189, 194042, 571, 1, 1, 3368.48, -2135.25, 124.53, 0.20224, 0, 0, 0.100948, 0.994892, 300, 0, 1),
(@OGUID+190, 181376, 571, 1, 1, 3366.29, -2135.71, 126.592, 0.275273, 0, 0, 0.137202, 0.990543, 300, 0, 1),
(@OGUID+191, 188021, 571, 1, 1, 2598.68, -4341.88, 275.709, 4.15841, 0, 0, 0.873519, -0.48679, 300, 0, 1),-- Howling Fjord
(@OGUID+192, 188020, 571, 1, 1, 2568.84, -4325.53, 277.908, 0.773361, 0, 0, 0.377116, 0.926166, 300, 0, 1),
(@OGUID+193, 181355, 571, 1, 1, 2573.18, -4321.63, 277.706, 5.89809, 0, 0, 0.191362, -0.981519, 300, 0, 1),
(@OGUID+194, 181355, 571, 1, 1, 2585.37, -4330.36, 276.802, 5.59728, 0, 0, 0.336267, -0.941767, 300, 0, 1),
(@OGUID+195, 188020, 571, 1, 1, 2583.94, -4336.2, 275.877, 4.28332, 0, 0, 0.841436, -0.540357, 300, 0, 1),
(@OGUID+196, 194039, 571, 1, 1, 2579.72, -4325.59, 276.934, 5.77529, 0, 0, 0.251227, -0.967928, 300, 0, 1),
(@OGUID+197, 181376, 571, 1, 1, 2577.57, -4325.97, 278.995, 0.226445, 0, 0, 0.112981, 0.993597, 300, 0, 1),
(@OGUID+198, 188020, 571, 1, 1, 2601.28, -4351.41, 275.622, 3.9414, 0, 0, 0.921098, -0.389331, 300, 0, 1),
(@OGUID+199, 188020, 571, 1, 1, 2610.63, -4359.39, 276.012, 3.96889, 0, 0, 0.91566, -0.401954, 300, 0, 1),
(@OGUID+200, 181355, 571, 1, 1, 2585.83, -4354.56, 276.176, 0.915263, 0, 0, 0.441825, 0.897101, 300, 0, 1),
(@OGUID+201, 181355, 571, 1, 1, 2593.08, -4361.44, 275.514, 2.42794, 0, 0, 0.93701, 0.349302, 300, 0, 1),
(@OGUID+202, 181605, 571, 1, 1, 2584.82, -4363.27, 275.305, 0.908194, 0, 0, 0.438651, 0.898658, 300, 0, 1),
(@OGUID+203, 181302, 571, 1, 1, 2598.83, -4338.72, 276.13, 1.4619, 0, 0, 0.667577, 0.744541, 300, 0, 1),
(@OGUID+204, 181302, 571, 1, 1, 2597, -4339.46, 275.976, 1.84439, 0, 0, 0.796929, 0.604073, 300, 0, 1),
(@OGUID+205, 181306, 571, 1, 1, 2598.77, -4340.42, 275.851, 3.60996, 0, 0, 0.972704, -0.23205, 300, 0, 1),
(@OGUID+206, 181305, 571, 1, 1, 2602.92, -4344.35, 275.756, 3.60446, 0, 0, 0.973338, -0.229375, 300, 0, 1),
(@OGUID+207, 181307, 571, 1, 1, 2603.7, -4344.96, 276.749, 3.60446, 0, 0, 0.973338, -0.229375, 300, 0, 1),
(@OGUID+208, 188021, 571, 1, 1, 5285.44, -2771.26, 292.418, 2.22832, 0, 0, 0.897541, 0.440932, 300, 0, 1),-- Zul'Drak
(@OGUID+209, 188020, 571, 1, 1, 5305.23, -2759.31, 292.211, 2.32649, 0, 0, 0.918095, 0.396361, 300, 0, 1),
(@OGUID+210, 188020, 571, 1, 1, 5300.14, -2753.37, 292.419, 2.27937, 0, 0, 0.908502, 0.417882, 300, 0, 1),
(@OGUID+211, 188020, 571, 1, 1, 5272.4, -2788.86, 292.419, 2.16077, 0, 0, 0.88214, 0.470987, 300, 0, 1),
(@OGUID+212, 188020, 571, 1, 1, 5267.47, -2781.49, 292.419, 2.16077, 0, 0, 0.88214, 0.470987, 300, 0, 1),
(@OGUID+213, 181605, 571, 1, 1, 5276.31, -2779.24, 292.419, 0.767265, 0, 0, 0.374292, 0.927311, 300, 0, 1),
(@OGUID+214, 181355, 571, 1, 1, 5273.81, -2783.22, 292.419, 2.0506, 0, 0, 0.854871, 0.518841, 300, 0, 1),
(@OGUID+215, 181355, 571, 1, 1, 5280.99, -2777.12, 292.419, 2.19198, 0, 0, 0.88938, 0.457168, 300, 0, 1),
(@OGUID+216, 181376, 571, 1, 1, 5294.92, -2761.88, 292.419, 2.12359, 0, 0, 0.873231, 0.487306, 300, 0, 1),
(@OGUID+217, 194048, 571, 1, 1, 5294.92, -2761.88, 292.419, 2.12359, 0, 0, 0.873231, 0.487306, 300, 0, 1),
(@OGUID+218, 181305, 571, 1, 1, 5289.89, -2768.68, 292.419, 6.05528, 0, 0, 0.113708, -0.993514, 300, 0, 1),
(@OGUID+219, 181307, 571, 1, 1, 5290.46, -2768.24, 293.42, 0.654878, 0, 0, 0.321619, 0.946869, 300, 0, 1),
(@OGUID+220, 181302, 571, 1, 1, 5285.31, -2775.88, 292.419, 1.63505, 0, 0, 0.729456, 0.684028, 300, 0, 1),
(@OGUID+221, 181302, 571, 1, 1, 5282.75, -2774.74, 292.419, 2.02383, 0, 0, 0.847848, 0.53024, 300, 0, 1),
(@OGUID+222, 181306, 571, 1, 1, 5283.45, -2776.25, 292.419, 5.98302, 0, 0, 0.149522, -0.988758, 300, 0, 1),
(@OGUID+223, 188021, 571, 1, 1, 5504.05, 4879.15, -198.169, 6.24464, 0, 0, 0.0192691, -0.999814, 300, 0, 1),-- Sholazar Basin
(@OGUID+224, 194034, 571, 1, 1, 5499.12, 4869.82, -197.467, 5.88414, 0, 0, 0.198201, -0.980161, 300, 0, 1),
(@OGUID+225, 181376, 571, 1, 1, 5497.1, 4868.86, -195.368, 0.418565, 0, 0, 0.207758, 0.97818, 300, 0, 1),
(@OGUID+226, 188020, 571, 1, 1, 5500.69, 4859.37, -197.247, 0.114598, 0, 0, 0.0572678, 0.998359, 300, 0, 1),
(@OGUID+227, 188020, 571, 1, 1, 5525.06, 4861.98, -197.564, 0.106744, 0, 0, 0.0533468, 0.998576, 300, 0, 1),
(@OGUID+228, 188020, 571, 1, 1, 5516.82, 4892.55, -196.273, 3.38578, 0, 0, 0.992556, -0.121792, 300, 0, 1),
(@OGUID+229, 188020, 571, 1, 1, 5496.17, 4892.9, -198.774, 3.03235, 0, 0, 0.998509, 0.0545924, 300, 0, 1),
(@OGUID+230, 181355, 571, 1, 1, 5495.91, 4883.4, -198.56, 6.25326, 0, 0, 0.0149618, -0.999888, 300, 0, 1),
(@OGUID+231, 181355, 571, 1, 1, 5515.37, 4883.68, -197.054, 0.0242677, 0, 0, 0.0121336, 0.999926, 300, 0, 1),
(@OGUID+232, 181605, 571, 1, 1, 5515.33, 4863.4, -198.357, 4.06043, 0, 0, 0.896311, -0.443427, 300, 0, 1),
(@OGUID+233, 181302, 571, 1, 1, 5507.71, 4879.47, -198.299, 0.657298, 0, 0, 0.322765, 0.946479, 300, 0, 1),
(@OGUID+234, 181302, 571, 1, 1, 5505.69, 4877.91, -198.203, 0.292873, 0, 0, 0.145914, 0.989297, 300, 0, 1),
(@OGUID+235, 181306, 571, 1, 1, 5507.58, 4877.19, -198.261, 2.40952, 0, 0, 0.933753, 0.357918, 300, 0, 1),
(@OGUID+236, 181305, 571, 1, 1, 5505.18, 4882.54, -198.365, 3.11481, 0, 0, 0.99991, 0.0133924, 300, 0, 1),
(@OGUID+237, 181307, 571, 1, 1, 5505.92, 4882.53, -197.375, 3.13444, 0, 0, 0.999994, 0.00357527, 300, 0, 1),
(@OGUID+238, 188021, 571, 1, 1, 5537.66, -737.121, 149.903, 3.31719, 0, 0, 0.996148, -0.0876849, 300, 0, 1),-- Crystalsong Forest
(@OGUID+239, 188020, 571, 1, 1, 5545.47, -751.288, 152.872, 3.29205, 0, 0, 0.997172, -0.0751598, 300, 0, 1),
(@OGUID+240, 188020, 571, 1, 1, 5534.63, -751.743, 152.043, 6.26479, 0, 0, 0.0091994, -0.999958, 300, 0, 1),
(@OGUID+241, 188020, 571, 1, 1, 5528.85, -718.125, 149.06, 0.120616, 0, 0, 0.0602714, 0.998182, 300, 0, 1),
(@OGUID+242, 188020, 571, 1, 1, 5538.1, -716.912, 150.739, 0.277696, 0, 0, 0.138402, 0.990376, 300, 0, 1),
(@OGUID+243, 181355, 571, 1, 1, 5521.75, -729.266, 148.2, 0.10176, 0, 0, 0.050858, 0.998706, 300, 0, 1),
(@OGUID+244, 181355, 571, 1, 1, 5523.81, -747.375, 150.338, 6.06293, 0, 0, 0.109904, -0.993942, 300, 0, 1),
(@OGUID+245, 181376, 571, 1, 1, 5531.08, -726.827, 148.981, 5.3977, 0, 0, 0.428418, -0.903581, 300, 0, 1),
(@OGUID+246, 194046, 571, 1, 1, 5530.53, -726.151, 148.904, 5.3977, 0, 0, 0.428418, -0.903581, 300, 0, 1),
(@OGUID+247, 181605, 571, 1, 1, 5539.79, -749.386, 152.047, 1.77309, 0, 0, 0.774893, 0.632092, 300, 0, 1),
(@OGUID+248, 181302, 571, 1, 1, 5540.05, -734.53, 149.889, 1.3152, 0, 0, 0.611221, 0.79146, 300, 0, 1),
(@OGUID+249, 181302, 571, 1, 1, 5539.56, -736.342, 150.01, 0.0978369, 0, 0, 0.048899, 0.998804, 300, 0, 1),
(@OGUID+250, 181306, 571, 1, 1, 5541.73, -735.983, 150.224, 2.34957, 0, 0, 0.922608, 0.385739, 300, 0, 1),
(@OGUID+251, 181305, 571, 1, 1, 5544.59, -739.644, 150.773, 3.64391, 0, 0, 0.968625, -0.248527, 300, 0, 1),
(@OGUID+252, 181307, 571, 1, 1, 5544.71, -740.658, 151.776, 4.72383, 0, 0, 0.70305, -0.711141, 300, 0, 1),
(@OGUID+253, 188021, 571, 1, 1, 6151.36, -1017.1, 407.519, 1.69575, 0, 0, 0.749875, 0.66158, 300, 0, 1),-- The Storm Peaks
(@OGUID+254, 188020, 571, 1, 1, 6132.71, -1015.73, 409.439, 1.61878, 0, 0, 0.723865, 0.689942, 300, 0, 1),
(@OGUID+255, 188020, 571, 1, 1, 6132.91, -1025.75, 409.86, 1.60476, 0, 0, 0.719011, 0.694998, 300, 0, 1),
(@OGUID+256, 188020, 571, 1, 1, 6175.57, -1021.52, 408.539, 1.75031, 0, 0, 0.767644, 0.640876, 300, 0, 1),
(@OGUID+257, 188020, 571, 1, 1, 6173.75, -1011.53, 407.582, 1.75031, 0, 0, 0.767644, 0.640876, 300, 0, 1),
(@OGUID+258, 181355, 571, 1, 1, 6159.65, -1016.22, 407.636, 3.2465, 0, 0, 0.998625, -0.0524288, 300, 0, 1),
(@OGUID+259, 181355, 571, 1, 1, 6136.52, -1021.34, 409.514, 3.30462, 0, 0, 0.99668, -0.0814223, 300, 0, 1),
(@OGUID+260, 181355, 571, 1, 1, 6153.47, -1027.3, 408.786, 1.79116, 0, 0, 0.780572, 0.625066, 300, 0, 1),
(@OGUID+261, 181302, 571, 1, 1, 6150.61, -1022.3, 408.201, 1.04268, 0, 0, 0.498041, 0.867154, 300, 0, 1),
(@OGUID+262, 181302, 571, 1, 1, 6151.6, -1020.59, 407.992, 2.47524, 0, 0, 0.945009, 0.327045, 300, 0, 1),
(@OGUID+263, 181306, 571, 1, 1, 6152.41, -1022.41, 408.186, 3.21273, 0, 0, 0.999367, -0.0355623, 300, 0, 1),
(@OGUID+264, 181305, 571, 1, 1, 6155.09, -1017.04, 407.54, 0.888738, 0, 0, 0.429888, 0.902882, 300, 0, 1),
(@OGUID+265, 181307, 571, 1, 1, 6155.22, -1018.19, 408.53, 1.70398, 0, 0, 0.752593, 0.658486, 300, 0, 1),
(@OGUID+266, 181605, 571, 1, 1, 6169.62, -1017.84, 408.118, 3.12084, 0, 0, 0.999946, 0.0103772, 300, 0, 1),
(@OGUID+267, 181376, 571, 1, 1, 6142.18, -1020.42, 408.493, 1.81865, 0, 0, 0.789088, 0.61428, 300, 0, 1),
(@OGUID+268, 194043, 571, 1, 1, 6142.19, -1020.44, 408.496, 1.91604, 0, 0, 0.818053, 0.575142, 300, 0, 1);
DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+77 AND @CGUID+117;
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
(@CGUID+77, 16781, 571, 1, 1, 16438, 0, 4464.65, 5615.53, 56.9756, 0.761036, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Borean Tundra
(@CGUID+78, 16781, 571, 1, 1, 16443, 0, 4463.64, 5619.44, 57.2937, 0.348702, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+79, 16781, 571, 1, 1, 16432, 0, 4468.31, 5631.88, 59.2365, 4.61106, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+80, 16781, 571, 1, 1, 16438, 0, 4431.68, 5629.68, 55.7222, 0.687992, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+81, 16781, 571, 1, 1, 16444, 0, 4437.48, 5636.46, 57.3127, 4.94564, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+82, 25994, 571, 1, 1, 23789, 1, 4469.26, 5627.85, 59.0877, 4.69872, 300, 0, 0, 1651, 0, 0, 0, 0, 0),
(@CGUID+83, 25994, 571, 1, 1, 23789, 1, 3779.24, 1486.12, 91.2991, 1.70099, 300, 0, 0, 1651, 0, 0, 0, 0, 0),      -- Dragonblight
(@CGUID+84, 16781, 571, 1, 1, 16436, 0, 3769.56, 1489.51, 91.3562, 6.25787, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+85, 16781, 571, 1, 1, 16432, 0, 3769.51, 1485.73, 92.0116, 0.944649, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+86, 16781, 571, 1, 1, 16443, 0, 3781.98, 1488.53, 90.6925, 3.65584, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+87, 16781, 571, 1, 1, 21086, 0, 3361.63, -2146.48, 124.113, 6.12412, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Grizzly Hills
(@CGUID+88, 16781, 571, 1, 1, 16442, 0, 3362.85, -2143.59, 124.017, 5.52722, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+89, 16781, 571, 1, 1, 16445, 0, 3365.06, -2149.12, 124.395, 2.17279, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+90, 16781, 571, 1, 1, 16438, 0, 3376.29, -2142.8, 124.829, 3.63755, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+91, 25994, 571, 1, 1, 23789, 1, 3374.3, -2153.8, 123.999, 2.2042, 300, 0, 0, 1651, 0, 0, 0, 0, 0),
(@CGUID+92, 16781, 571, 1, 1, 16436, 0, 2611.27, -4353.51, 276.147, 2.90625, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Howling Fjord
(@CGUID+93, 16781, 571, 1, 1, 16442, 0, 2607.34, -4349.77, 275.811, 4.8831, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+94, 16781, 571, 1, 1, 16431, 0, 2591.12, -4366.18, 275.385, 1.70773, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+95, 16781, 571, 1, 1, 16443, 0, 2589.82, -4356.76, 275.862, 4.90509, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+96, 16781, 571, 1, 1, 21086, 0, 2582.78, -4356.01, 276.146, 6.05884, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+97, 25994, 571, 1, 1, 23789, 1, 2586.97, -4359.34, 275.729, 4.3074, 300, 0, 0, 1651, 0, 0, 0, 0, 0),
(@CGUID+98, 16781, 571, 1, 1, 16446, 0, 5271.7, -2776.47, 292.419, 5.91363, 300, 0, 0, 1524, 0, 0, 0, 0, 0),  -- Zul'Drak
(@CGUID+99, 16781, 571, 1, 1, 16438, 0, 5271.27, -2780.54, 292.419, 1.37088, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+100, 25994, 571, 1, 1, 23789, 1, 5276.13, -2771.1, 292.419, 4.75359, 300, 0, 0, 1651, 0, 0, 0, 0, 0),
(@CGUID+101, 16781, 571, 1, 1, 16436, 0, 5508.26, 4891.52, -197.537, 3.49338, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Sholazar Basin
(@CGUID+102, 16781, 571, 1, 1, 16442, 0, 5503.99, 4886.98, -198.356, 1.25892, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+103, 16781, 571, 1, 1, 16445, 0, 5500.44, 4895, -198.054, 5.57939, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+104, 16781, 571, 1, 1, 16436, 0, 5513.58, 4886.29, -197.178, 2.68991, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+105, 16781, 571, 1, 1, 16444, 0, 5511.2, 4870.94, -198.257, 4.65341, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+106, 25994, 571, 1, 1, 23789, 1, 5509.13, 4864.95, -198.144, 6.08048, 300, 0, 0, 1651, 0, 0, 0, 0, 0),
(@CGUID+107, 16781, 571, 1, 1, 16446, 0, 5523.19, -720.827, 148.211, 5.25948, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Crystalsong Forest
(@CGUID+108, 16781, 571, 1, 1, 16438, 0, 5520.46, -724.236, 148.091, 0.741081, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+109, 16781, 571, 1, 1, 16443, 0, 5525.58, -732.861, 148.853, 5.66631, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+110, 16781, 571, 1, 1, 16438, 0, 5535.22, -748.433, 151.399, 5.70637, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+111, 16781, 571, 1, 1, 16438, 0, 5540.74, -753.426, 153.249, 2.39199, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+112, 25994, 571, 1, 1, 23789, 1, 5544.48, -746.126, 151.578, 3.61956, 300, 0, 0, 1651, 0, 0, 0, 0, 0),
(@CGUID+113, 16781, 571, 1, 1, 16438, 0, 6166.94, -1008.14, 407.495, 4.42539, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- The Storm Peaks
(@CGUID+114, 16781, 571, 1, 1, 16442, 0, 6161.54, -1013.07, 407.498, 6.11635, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+115, 16781, 571, 1, 1, 21086, 0, 6164.34, -1020.92, 408.305, 1.35684, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+116, 16781, 571, 1, 1, 29243, 0, 6150.78, -1024.97, 408.505, 2.09119, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+117, 25994, 571, 1, 1, 23789, 1, 6171.72, -1022.75, 408.506, 1.97024, 300, 0, 0, 1651, 0, 0, 0, 0, 0);
-- Northrend Alliance
DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+269 AND @OGUID+379;
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
(@OGUID+269, 188021, 571, 1, 1, 4132.22, 5395.21, 25.7191, 5.17561, 0, 0, 0.525913, -0.850539, 300, 0, 1), -- Borean Tundra
(@OGUID+270, 181376, 571, 1, 1, 4122.37, 5390.27, 27.8408, 5.32484, 0, 0, 0.461047, -0.887376, 300, 0, 1),
(@OGUID+271, 194032, 571, 1, 1, 4122.37, 5390.27, 27.8408, 5.32484, 0, 0, 0.461047, -0.887376, 300, 0, 1),
(@OGUID+272, 188020, 571, 1, 1, 4129.22, 5405.02, 28.1789, 0.481285, 0, 0, 0.238326, 0.971185, 300, 0, 1),
(@OGUID+273, 188020, 571, 1, 1, 4151.06, 5414.97, 28.6058, 3.52863, 0, 0, 0.981333, -0.192314, 300, 0, 1),
(@OGUID+274, 181355, 571, 1, 1, 4156.95, 5401.1, 26.3092, 3.55219, 0, 0, 0.979, -0.203861, 300, 0, 1),
(@OGUID+275, 181355, 571, 1, 1, 4146.21, 5396.35, 26.6994, 3.55219, 0, 0, 0.979, -0.203861, 300, 0, 1),
(@OGUID+276, 181355, 571, 1, 1, 4142.18, 5405.59, 27.1525, 3.55219, 0, 0, 0.979, -0.203861, 300, 0, 1),
(@OGUID+277, 181355, 571, 1, 1, 4153.32, 5410.39, 28.7987, 3.52313, 0, 0, 0.981858, -0.189615, 300, 0, 1),
(@OGUID+278, 181605, 571, 1, 1, 4150.05, 5405.28, 27.8774, 5.08058, 0, 0, 0.565718, -0.824599, 300, 0, 1),
(@OGUID+279, 181305, 571, 1, 1, 4135.12, 5397.23, 25.5887, 3.85927, 0, 0, 0.936306, -0.351186, 300, 0, 1),
(@OGUID+280, 181307, 571, 1, 1, 4135.05, 5398.94, 26.5787, 4.14594, 0, 0, 0.876539, -0.481331, 300, 0, 1),
(@OGUID+281, 181306, 571, 1, 1, 4129.8, 5391.77, 26.5704, 0.0579356, 0, 0, 0.0289637, 0.99958, 300, 0, 1),
(@OGUID+282, 181302, 571, 1, 1, 4131.99, 5391.45, 26.3998, 2.4746, 0, 0, 0.944904, 0.327349, 300, 0, 1),
(@OGUID+283, 181302, 571, 1, 1, 4131.99, 5391.45, 27.643, 2.4746, 0, 0, 0.944904, 0.327349, 300, 0, 1),
(@OGUID+284, 188020, 571, 1, 1, 3931.83, -573.606, 240.92, 4.44752, 0, 0, 0.794288, -0.607542, 300, 0, 1), -- Dragonblight
(@OGUID+285, 188021, 571, 1, 1, 3935.16, -604.422, 242.038, 0.314754, 0, 0, 0.156728, 0.987642, 300, 0, 1),
(@OGUID+286, 188020, 571, 1, 1, 3945.42, -581.269, 241.426, 3.2757, 0, 0, 0.997753, -0.0670037, 300, 0, 1),
(@OGUID+287, 194036, 571, 1, 1, 3936.15, -583.456, 240.5, 4.0611, 0, 0, 0.896162, -0.443727, 300, 0, 1),
(@OGUID+288, 181605, 571, 1, 1, 3943.7, -620.329, 242.649, 4.94546, 0, 0, 0.620095, -0.784527, 300, 0, 1),
(@OGUID+289, 181355, 571, 1, 1, 3939.36, -612.531, 242.424, 0.532305, 0, 0, 0.263021, 0.96479, 300, 0, 1),
(@OGUID+290, 181355, 571, 1, 1, 3935.15, -599.189, 241.726, 3.43592, 0, 0, 0.989191, -0.146634, 300, 0, 1),
(@OGUID+291, 181302, 571, 1, 1, 3932.46, -602.261, 241.839, 4.80251, 0, 0, 0.674536, -0.738242, 300, 0, 1),
(@OGUID+292, 181302, 571, 1, 1, 3933.35, -604.422, 242.14, 5.11746, 0, 0, 0.550417, -0.83489, 300, 0, 1),
(@OGUID+293, 181306, 571, 1, 1, 3930.72, -604.611, 242.786, 0.606916, 0, 0, 0.298822, 0.954309, 300, 0, 1),
(@OGUID+294, 181305, 571, 1, 1, 3937.87, -603.327, 241.851, 0.273907, 0, 0, 0.136526, 0.990636, 300, 0, 1),
(@OGUID+295, 181307, 571, 1, 1, 3937.11, -604.845, 242.841, 1.2478, 0, 0, 0.584205, 0.811606, 300, 0, 1),
(@OGUID+296, 188020, 571, 1, 1, 3951.62, -594.388, 242.067, 3.25449, 0, 0, 0.998407, -0.0564201, 300, 0, 1),
(@OGUID+297, 188020, 571, 1, 1, 3956.41, -622.677, 240.615, 3.44377, 0, 0, 0.988608, -0.150516, 300, 0, 1),
(@OGUID+298, 181376, 571, 1, 1, 3938.9, -583.532, 241.562, 3.02279, 0, 0, 0.998236, 0.0593654, 300, 0, 1),
(@OGUID+299, 188020, 571, 1, 1, 3395.09, -2897.63, 202.415, 3.91647, 0, 0, 0.92588, -0.377817, 300, 0, 1), -- Grizzly Hills
(@OGUID+300, 188020, 571, 1, 1, 3386.89, -2887.49, 201.433, 3.52822, 0, 0, 0.981373, -0.192111, 300, 0, 1),
(@OGUID+301, 188021, 571, 1, 1, 3411.02, -2887.95, 200.943, 2.32304, 0, 0, 0.917409, 0.397946, 300, 0, 1),
(@OGUID+302, 181376, 571, 1, 1, 3403.4, -2896.41, 201.988, 2.32303, 0, 0, 0.917408, 0.397948, 300, 0, 1),
(@OGUID+303, 194040, 571, 1, 1, 3403.4, -2896.41, 201.988, 2.32303, 0, 0, 0.917408, 0.397948, 300, 0, 1),
(@OGUID+304, 188020, 571, 1, 1, 3407.51, -2863.88, 200.72, 0.993352, 0, 0, 0.476506, 0.879171, 300, 0, 1),
(@OGUID+305, 188020, 571, 1, 1, 3417.07, -2866.24, 201.045, 1.32715, 0, 0, 0.615936, 0.787796, 300, 0, 1),
(@OGUID+306, 181355, 571, 1, 1, 3402.62, -2873.88, 201.036, 5.86281, 0, 0, 0.208643, -0.977992, 300, 0, 1),
(@OGUID+307, 181355, 571, 1, 1, 3420.67, -2873.09, 201.803, 6.15576, 0, 0, 0.0636678, -0.997971, 300, 0, 1),
(@OGUID+308, 181605, 571, 1, 1, 3418.83, -2879.6, 202.108, 2.79897, 0, 0, 0.985362, 0.170475, 300, 0, 1),
(@OGUID+309, 181305, 571, 1, 1, 3412.23, -2891.48, 201.275, 5.57692, 0, 0, 0.345838, -0.938294, 300, 0, 1),
(@OGUID+310, 181307, 571, 1, 1, 3411.04, -2891.93, 202.266, 5.61226, 0, 0, 0.329204, -0.944259, 300, 0, 1),
(@OGUID+311, 181302, 571, 1, 1, 3413.25, -2886.38, 200.913, 5.401, 0, 0, 0.426929, -0.904285, 300, 0, 1),
(@OGUID+312, 181302, 571, 1, 1, 3415.21, -2887.65, 201.016, 0.378376, 0, 0, 0.188062, 0.982157, 300, 0, 1),
(@OGUID+313, 181306, 571, 1, 1, 3415.86, -2885.54, 201.257, 2.86024, 0, 0, 0.990121, 0.140215, 300, 0, 1),
(@OGUID+314, 188021, 571, 1, 1, 5613.46, -2625.78, 292.419, 1.55992, 0, 0, 0.703251, 0.710942, 300, 0, 1), -- Zul'Drak
(@OGUID+315, 181355, 571, 1, 1, 5603.68, -2629.45, 293.617, 4.60018, 0, 0, 0.745644, -0.666345, 300, 0, 1),
(@OGUID+316, 181355, 571, 1, 1, 5626.09, -2630.44, 292.882, 1.48451, 0, 0, 0.675952, 0.736946, 300, 0, 1),
(@OGUID+317, 188020, 571, 1, 1, 5636.45, -2626.42, 292.419, 6.27937, 0, 0, 0.00190917, -0.999998, 300, 0, 1),
(@OGUID+318, 188020, 571, 1, 1, 5636.13, -2618.64, 292.199, 0.0786426, 0, 0, 0.0393112, 0.999227, 300, 0, 1),
(@OGUID+319, 188020, 571, 1, 1, 5582.98, -2620.34, 292.42, 0.0385866, 0, 0, 0.0192921, 0.999814, 300, 0, 1),
(@OGUID+320, 188020, 571, 1, 1, 5581.71, -2626.78, 292.419, 6.27386, 0, 0, 0.00466193, -0.999989, 300, 0, 1),
(@OGUID+321, 181605, 571, 1, 1, 5587.73, -2625.06, 292.41, 0.0409415, 0, 0, 0.0204693, 0.99979, 300, 0, 1),
(@OGUID+322, 181305, 571, 1, 1, 5616.57, -2625.53, 292.41, 0.749368, 0, 0, 0.365978, 0.930623, 300, 0, 1),
(@OGUID+323, 181307, 571, 1, 1, 5616.55, -2626.93, 293.402, 1.55676, 0, 0, 0.702126, 0.712053, 300, 0, 1),
(@OGUID+324, 181302, 571, 1, 1, 5611.85, -2625.48, 292.361, 4.696, 0, 0, 0.712879, -0.701287, 300, 0, 1),
(@OGUID+325, 181302, 571, 1, 1, 5609.81, -2625.66, 292.34, 5.23792, 0, 0, 0.499163, -0.866508, 300, 0, 1),
(@OGUID+326, 181306, 571, 1, 1, 5610.02, -2623.6, 292.418, 0.308762, 0, 0, 0.153769, 0.988107, 300, 0, 1),
(@OGUID+327, 181376, 571, 1, 1, 5626.92, -2622.29, 292.417, 1.6785, 0, 0, 0.744143, 0.668021, 300, 0, 1),
(@OGUID+328, 194049, 571, 1, 1, 5626.92, -2622.29, 292.417, 1.6785, 0, 0, 0.744143, 0.668021, 300, 0, 1),
(@OGUID+329, 188021, 571, 1, 1, 5357.4, 4835.99, -195.101, 1.59976, 0, 0, 0.717272, 0.696793, 300, 0, 1), -- Sholazar Basin
(@OGUID+330, 181376, 571, 1, 1, 5369.18, 4842.41, -197.357, 4.53948, 0, 0, 0.765523, -0.643408, 300, 0, 1),
(@OGUID+331, 194035, 571, 1, 1, 5369.18, 4842.41, -197.357, 4.53948, 0, 0, 0.765523, -0.643408, 300, 0, 1),
(@OGUID+332, 181355, 571, 1, 1, 5359.07, 4827.41, -197.019, 0.176586, 0, 0, 0.0881781, 0.996105, 300, 0, 1),
(@OGUID+333, 181355, 571, 1, 1, 5357.57, 4845.13, -195.788, 1.41909, 0, 0, 0.651487, 0.75866, 300, 0, 1),
(@OGUID+334, 181605, 571, 1, 1, 5357.67, 4855.99, -193.827, 2.00813, 0, 0, 0.843662, 0.536875, 300, 0, 1),
(@OGUID+335, 188020, 571, 1, 1, 5364.57, 4869.43, -193.105, 4.59916, 0, 0, 0.745985, -0.665963, 300, 0, 1),
(@OGUID+336, 188020, 571, 1, 1, 5354.34, 4871.09, -189.818, 4.65099, 0, 0, 0.728478, -0.685069, 300, 0, 1),
(@OGUID+337, 188021, 571, 1, 1, 2464.17, -4907.57, 263.922, 1.71737, 0, 0, 0.756984, 0.653433, 300, 0, 1), -- Howling Fjord
(@OGUID+338, 181305, 571, 1, 1, 2466.21, -4913.1, 264.166, 1.87838, 0, 0, 0.807079, 0.590443, 300, 0, 1),
(@OGUID+339, 181307, 571, 1, 1, 2466.44, -4913.46, 265.097, 2.75802, 0, 0, 0.981666, 0.190611, 300, 0, 1),
(@OGUID+340, 181302, 571, 1, 1, 2461.97, -4910.5, 263.936, 2.04881, 0, 0, 0.854405, 0.519608, 300, 0, 1),
(@OGUID+341, 181302, 571, 1, 1, 2462.99, -4912.18, 264.014, 2.58759, 0, 0, 0.96188, 0.273472, 300, 0, 1),
(@OGUID+342, 181306, 571, 1, 1, 2460.13, -4911.21, 263.948, 0.18113, 0, 0, 0.0904413, 0.995902, 300, 0, 1),
(@OGUID+343, 181376, 571, 1, 1, 2454.19, -4910.31, 263.893, 1.66082, 0, 0, 0.738208, 0.674573, 300, 0, 1),
(@OGUID+344, 194038, 571, 1, 1, 2454.19, -4910.31, 263.893, 1.66082, 0, 0, 0.738208, 0.674573, 300, 0, 1),
(@OGUID+345, 188020, 571, 1, 1, 2440.82, -4917.07, 264.587, 3.04862, 0, 0, 0.99892, 0.0464672, 300, 0, 1),
(@OGUID+346, 188020, 571, 1, 1, 2438.66, -4906.68, 263.066, 3.01328, 0, 0, 0.997943, 0.0641126, 300, 0, 1),
(@OGUID+347, 188020, 571, 1, 1, 2484.02, -4906.27, 266.191, 3.40989, 0, 0, 0.991016, -0.133745, 300, 0, 1),
(@OGUID+348, 188020, 571, 1, 1, 2480.96, -4899.1, 265.064, 3.50885, 0, 0, 0.983188, -0.182596, 300, 0, 1),
(@OGUID+349, 181605, 571, 1, 1, 2477.58, -4905.4, 265.055, 3.54262, 0, 0, 0.979964, -0.199174, 300, 0, 1),
(@OGUID+350, 181355, 571, 1, 1, 2444.4, -4912.06, 263.951, 4.8615, 0, 0, 0.652474, -0.757811, 300, 0, 1),
(@OGUID+351, 181355, 571, 1, 1, 2479.59, -4904.05, 265.144, 5.29976, 0, 0, 0.472136, -0.881526, 300, 0, 1),
(@OGUID+352, 188021, 571, 1, 1, 5136.25, -701.964, 172.182, 5.14116, 0, 0, 0.540484, -0.841354, 300, 0, 1), -- Crystalsong Forest
(@OGUID+353, 181376, 571, 1, 1, 5144.94, -695.736, 171.284, 5.22017, 0, 0, 0.506833, -0.862045, 300, 0, 1),
(@OGUID+354, 194045, 571, 1, 1, 5144.94, -695.736, 171.284, 5.22017, 0, 0, 0.506833, -0.862045, 300, 0, 1),
(@OGUID+355, 188020, 571, 1, 1, 5157.7, -692.213, 168.342, 3.56062, 0, 0, 0.978132, -0.207985, 300, 0, 1),
(@OGUID+356, 181355, 571, 1, 1, 5153.61, -694.632, 169.363, 0.505421, 0, 0, 0.250029, 0.968238, 300, 0, 1),
(@OGUID+357, 188020, 571, 1, 1, 5122.22, -708.294, 175.114, 0.416673, 0, 0, 0.206832, 0.978376, 300, 0, 1),
(@OGUID+358, 181355, 571, 1, 1, 5126.09, -706.472, 174.339, 3.55198, 0, 0, 0.979021, -0.203758, 300, 0, 1),
(@OGUID+359, 181605, 571, 1, 1, 5151.54, -709.361, 169.826, 2.02988, 0, 0, 0.849448, 0.527672, 300, 0, 1),
(@OGUID+360, 181305, 571, 1, 1, 5133.04, -698.409, 172.585, 2.84669, 0, 0, 0.989149, 0.146918, 300, 0, 1),
(@OGUID+361, 181307, 571, 1, 1, 5134.11, -697.857, 173.575, 3.61874, 0, 0, 0.971676, -0.236315, 300, 0, 1),
(@OGUID+362, 181302, 571, 1, 1, 5130.8, -703.896, 173.441, 0.0954414, 0, 0, 0.0477026, 0.998862, 300, 0, 1),
(@OGUID+363, 181302, 571, 1, 1, 5130.87, -703.854, 174.684, 0.535265, 0, 0, 0.264449, 0.9644, 300, 0, 1),
(@OGUID+364, 181306, 571, 1, 1, 5131.38, -705.369, 173.303, 0.248594, 0, 0, 0.123977, 0.992285, 300, 0, 1),
(@OGUID+365, 188021, 571, 1, 1, 6071.62, -1109.83, 419.2, 0.405097, 0, 0, 0.201166, 0.979557, 300, 0, 1), -- Storm Peaks
(@OGUID+366, 181305, 571, 1, 1, 6068.33, -1111.01, 420.335, 0.181236, 0, 0, 0.0904939, 0.995897, 300, 0, 1),
(@OGUID+367, 181307, 571, 1, 1, 6068.13, -1112.28, 421.326, 1.41274, 0, 0, 0.649077, 0.760723, 300, 0, 1),
(@OGUID+368, 181302, 571, 1, 1, 6075.71, -1107.72, 419.811, 0.0485033, 0, 0, 0.0242493, 0.999706, 300, 0, 1),
(@OGUID+369, 181302, 571, 1, 1, 6074.48, -1109.44, 419.993, 0.613205, 0, 0, 0.301821, 0.953365, 300, 0, 1),
(@OGUID+370, 181306, 571, 1, 1, 6076.77, -1109.03, 419.873, 0.174952, 0, 0, 0.0873647, 0.996176, 300, 0, 1),
(@OGUID+371, 188020, 571, 1, 1, 6087.35, -1102.33, 417.415, 1.96409, 0, 0, 0.831634, 0.555324, 300, 0, 1),
(@OGUID+372, 181355, 571, 1, 1, 6088.04, -1106.9, 418.348, 3.61421, 0, 0, 0.972209, -0.234116, 300, 0, 1),
(@OGUID+373, 181355, 571, 1, 1, 6083.72, -1098.45, 417.139, 3.61421, 0, 0, 0.972209, -0.234116, 300, 0, 1),
(@OGUID+374, 188020, 571, 1, 1, 6052.44, -1113.82, 420.864, 1.8769, 0, 0, 0.806644, 0.591038, 300, 0, 1),
(@OGUID+375, 181355, 571, 1, 1, 6052.45, -1106.76, 421.632, 0.193794, 0, 0, 0.0967457, 0.995309, 300, 0, 1),
(@OGUID+376, 181355, 571, 1, 1, 6056.56, -1118.19, 420.868, 0.130963, 0, 0, 0.0654346, 0.997857, 300, 0, 1),
(@OGUID+377, 181605, 571, 1, 1, 6061.69, -1112.97, 420.771, 5.40099, 0, 0, 0.426933, -0.904283, 300, 0, 1),
(@OGUID+378, 181376, 571, 1, 1, 6081.58, -1107.81, 419.498, 5.2117, 0, 0, 0.510478, -0.859891, 300, 0, 1),
(@OGUID+379, 194044, 571, 1, 1, 6081.58, -1107.81, 419.498, 5.2117, 0, 0, 0.510478, -0.859891, 300, 0, 1);
DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+118 AND @CGUID+156;
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
(@CGUID+118, 25962, 571, 1, 1, 23791, 0, 4141.22, 5399.12, 26.8254, 0.573149, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Borean
(@CGUID+119, 16781, 571, 1, 1, 16434, 0, 4142.22, 5389.34, 26.5072, 1.07266, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+120, 16781, 571, 1, 1, 16435, 0, 4141.25, 5394.58, 27.4716, 5.24156, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+121, 16781, 571, 1, 1, 16412, 0, 4147.28, 5407.75, 28.0446, 1.51327, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+122, 16781, 571, 1, 1, 16413, 0, 4145.26, 5412.3, 28.2783, 5.25177, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+123, 16781, 571, 1, 1, 21084, 0, 3946.4, -634.725, 242.332, 2.18478, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Dragonblight
(@CGUID+124, 16781, 571, 1, 1, 16435, 0, 3944.54, -631.516, 242.718, 5.2062, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+125, 16781, 571, 1, 1, 16434, 0, 3942.9, -606.703, 241.48, 2.36464, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+126, 16781, 571, 1, 1, 21083, 0, 3940.65, -603.007, 241.622, 5.10253, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+127, 25962, 571, 1, 1, 23791, 0, 3954.38, -609.752, 240.94, 3.62441, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+128, 25962, 571, 1, 1, 23791, 0, 3417.9, -2882.62, 201.901, 2.50837, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Grizzly Hills
(@CGUID+129, 16781, 571, 1, 1, 21083, 0, 3410.97, -2879.33, 201.095, 0.0940601, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+130, 16781, 571, 1, 1, 16435, 0, 3413.05, -2875.08, 200.954, 4.47815, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+131, 16781, 571, 1, 1, 16414, 0, 3416.95, -2876.6, 201.513, 3.22073, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+132, 25962, 571, 1, 1, 23791, 0, 5605.14, -2622.99, 292.418, 3.07023, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Zul'Drak
(@CGUID+133, 16781, 571, 1, 1, 21083, 0, 5598.5, -2620.43, 292.418, 3.79122, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+134, 16781, 571, 1, 1, 16412, 0, 5595.44, -2624.43, 292.418, 0.957505, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+135, 16781, 571, 1, 1, 16448, 0, 5591.45, -2618.79, 292.418, 5.53402, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+136, 16781, 571, 1, 1, 16414, 0, 5608.18, -2627.1, 292.38, 2.59506, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+137, 16781, 571, 1, 1, 16433, 0, 5350.19, 4865.15, -189.023, 5.81181, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Sholazar Basin
(@CGUID+138, 16781, 571, 1, 1, 21084, 0, 5349.94, 4860.03, -189.519, 5.81181, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+139, 16781, 571, 1, 1, 16412, 0, 5359.3, 4851.5, -195.433, 2.15971, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+140, 16781, 571, 1, 1, 16434, 0, 5361.68, 4857.43, -195.012, 2.85086, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+141, 25962, 571, 1, 1, 23791, 0, 5359.25, 4865.19, -192.408, 4.29363, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+142, 16781, 571, 1, 1, 21084, 0, 2475.51, -4899.2, 264.631, 4.34609, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Howling Fjord
(@CGUID+143, 16781, 571, 1, 1, 16412, 0, 2473.2, -4903.93, 264.472, 1.13459, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+144, 16781, 571, 1, 1, 16434, 0, 2470.25, -4897.93, 264.079, 5.37967, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+145, 16781, 571, 1, 1, 16435, 0, 2460.73, -4908.81, 263.856, 1.98283, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+146, 25962, 571, 1, 1, 23791, 0, 2474.94, -4910.43, 265.088, 1.51708, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+147, 16781, 571, 1, 1, 16448, 0, 5158.08, -705.974, 168.467, 3.02341, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Crystal Song
(@CGUID+148, 16781, 571, 1, 1, 16434, 0, 5156.52, -702.266, 168.843, 4.44812, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+149, 16781, 571, 1, 1, 16433, 0, 5151.8, -705.612, 169.955, 0.254876, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+150, 16781, 571, 1, 1, 21084, 0, 5128.25, -708.394, 173.711, 1.15808, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+151, 25962, 571, 1, 1, 23791, 0, 5145.91, -709.484, 170.821, 0.499922, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+152, 16781, 571, 1, 1, 16434, 0, 6065.56, -1113.57, 420.54, 4.16241, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Storm Peaks
(@CGUID+153, 16781, 571, 1, 1, 16412, 0, 6066.28, -1119.17, 420.628, 1.60201, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+154, 16781, 571, 1, 1, 16442, 0, 6061.11, -1119.26, 420.736, 0.384647, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+155, 16781, 571, 1, 1, 16447, 0, 6057.52, -1108.18, 421.177, 5.5188, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+156, 25962, 571, 1, 1, 23791, 0, 6055.79, -1113.41, 420.965, 0.639908, 300, 0, 0, 1524, 0, 0, 0, 0, 0);
-- Add missing objects and creatures from capital cities and fix some minor misc on already spawned ones
DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+380 AND @OGUID+418;
INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
(@OGUID+380, 181376, 530, 1, 1, -3794.02, -11502.1, -134.74, 5.00689, 0, 0, 0.59571, -0.8032, 300, 0, 1),-- The Exodar
(@OGUID+381, 188128, 530, 1, 1, -3794.02, -11502.1, -134.74, 5.00689, 0, 0, 0.59571, -0.8032, 300, 0, 1),
(@OGUID+382, 181305, 530, 1, 1, -3794.46, -11519.8, -134.94, 1.89985, 0, 0, 0.813373, 0.581743, 300, 0, 1),
(@OGUID+383, 181307, 530, 1, 1, -3795.81, -11519.3, -133.928, 0.0211825, 0, 0, 0.010591, 0.999944, 300, 0, 1),
(@OGUID+384, 181302, 530, 1, 1, -3800.48, -11515.8, -134.966, 6.21562, 0, 0, 0.0337776, -0.999429, 300, 0, 1),
(@OGUID+385, 181302, 530, 1, 1, -3800.87, -11517.1, -135.02, 2.979, 0, 0, 0.996697, 0.0812088, 300, 0, 1),
(@OGUID+386, 181302, 530, 1, 1, -3800.86, -11516.4, -133.722, 2.56666, 0, 0, 0.958966, 0.283523, 300, 0, 1),
(@OGUID+387, 181306, 530, 1, 1, -3799.04, -11517.6, -134.986, 3.29551, 0, 0, 0.99704, -0.0768831, 300, 0, 1),
(@OGUID+388, 188020, 530, 1, 1, -3793.84, -11533.9, -134.975, 5.90226, 0, 0, 0.189314, -0.981916, 300, 0, 1),
(@OGUID+389, 188020, 530, 1, 1, -3774.53, -11496.2, -134.493, 2.69547, 0, 0, 0.975225, 0.221214, 300, 0, 1),
(@OGUID+390, 181355, 530, 1, 1, -3772.21, -11491.7, -134.447, 4.23172, 0, 0, 0.855095, -0.518471, 300, 0, 1),
(@OGUID+391, 181355, 530, 1, 1, -3797.16, -11540.5, -134.957, 1.12154, 0, 0, 0.531839, 0.846846, 300, 0, 1),
(@OGUID+392, 187708, 530, 1, 1, -3768.73, -11511.2, -134.479, 2.70805, 0, 0, 0.976597, 0.215078, 300, 0, 1),
(@OGUID+393, 187708, 530, 1, 1, -3773.26, -11519.4, -134.56, 2.53526, 0, 0, 0.954396, 0.298543, 300, 0, 1),
(@OGUID+394, 187708, 530, 1, 1, -3776.32, -11511.5, -134.569, 5.69256, 0, 0, 0.291037, -0.956712, 300, 0, 1),
(@OGUID+395, 187708, 530, 1, 1, -3775.23, -11506.7, -134.539, 5.79074, 0, 0, 0.243745, -0.969839, 300, 0, 1),
(@OGUID+396, 187708, 530, 1, 1, -3780.47, -11514.1, -134.626, 5.66115, 0, 0, 0.30603, -0.952022, 300, 0, 1),
(@OGUID+397, 181306, 530, 1, 1, 9791.79, -7248.75, 26.0815, 4.80477, 0, 0, 0.673703, -0.739003, 300, 0, 1), -- Silvermoon
(@OGUID+398, 187708, 530, 1, 1, 9817.67, -7227.84, 26.1104, 3.89843, 0, 0, 0.929251, -0.36945, 300, 0, 1),
(@OGUID+399, 187708, 530, 1, 1, 9810.38, -7226.95, 26.0582, 0.898206, 0, 0, 0.434157, 0.900837, 300, 0, 1),
(@OGUID+400, 187708, 530, 1, 1, 9819.87, -7234.51, 26.1176, 0.898206, 0, 0, 0.434157, 0.900837, 300, 0, 1),
(@OGUID+401, 187708, 530, 1, 1, 9823.56, -7229.12, 26.1209, 3.78847, 0, 0, 0.948148, -0.317829, 300, 0, 1),
(@OGUID+402, 187708, 530, 1, 1, 9817.55, -7221.36, 26.1142, 3.80025, 0, 0, 0.946259, -0.323409, 300, 0, 1),
(@OGUID+403, 188020, 530, 1, 1, 9819.17, -7251.91, 26.1485, 5.37496, 0, 0, 0.438667, -0.89865, 300, 0, 1),
(@OGUID+404, 188020, 530, 1, 1, 9795.99, -7270.21, 26.3648, 2.06541, 0, 0, 0.858689, 0.512496, 300, 0, 1),
(@OGUID+405, 188021, 0, 1, 1, 1802.13, 222.644, 59.9682, 1.02433, 0, 0, 0.490064, 0.871686, 300,100,1),-- Undercity and Ironforge
(@OGUID+406, 188021, 0, 1, 1, -4711.33, -1224.68, 501.66, 3.95557, 0, 0, 0.918317, -0.395846, 300,100,1),
(@OGUID+407, 181376, 0, 1, 1, -4700.28, -1224.34, 501.659, -2.14675, 0, 0, 0.878817, -0.477159, 180,100,1),
(@OGUID+408, 181305, 0, 1, 1, -8833.44, 875.047, 98.5645, 3.04849, 0, 0, 0.998917, 0.0465366, 300, 0, 1),-- Stormwind and Darnassus
(@OGUID+409, 181307, 0, 1, 1, -8832.66, 876.386, 99.5549, 4.18967, 0, 0, 0.865805, -0.500381, 300, 0, 1),
(@OGUID+410, 181302, 0, 1, 1, -8831.75, 880.124, 98.4636, 4.62321, 0, 0, 0.737923, -0.674885, 300, 0, 1),
(@OGUID+411, 181302, 0, 1, 1, -8829.84, 879.278, 98.5062, 5.90498, 0, 0, 0.187978, -0.982173, 300, 0, 1),
(@OGUID+412, 181302, 0, 1, 1, -8830.09, 879.49, 99.7495, 3.72942, 0, 0, 0.957117, -0.289703, 300, 0, 1),
(@OGUID+413, 181306, 0, 1, 1, -8830.36, 881.029, 98.4529, 4.14019, 0, 0, 0.877919, -0.478809, 300, 0, 1),
(@OGUID+414, 187708, 0, 1, 1, -8816.54, 854.183, 98.882, 4.34518, 0, 0, 0.824323, -0.56612, 300, 0, 1),
(@OGUID+415, 187708, 0, 1, 1, -8815.11, 860.487, 98.96, 4.75751, 0, 0, 0.690976, -0.722877, 300, 0, 1),
(@OGUID+416, 187708, 0, 1, 1, -8818.01, 865.253, 98.9761, 4.47084, 0, 0, 0.787149, -0.616763, 300, 0, 1),
(@OGUID+417, 181306, 1, 1, 1, 8705.34, 970.3, 12.2316, 5.19882, 0, 0, 0.516009, -0.856583, 300, 0, 1),
(@OGUID+418, 181307, 1, 1, 1, 8703.78, 967.116, 13.6598, 4.10868, 0, 0, 0.885353, -0.46492, 300, 0, 1);
DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+157 AND @CGUID+167;
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) VALUES
(@CGUID+157, 26221, 530, 1, 1, 0, 1, -3796.67, -11496.8, -134.748, 2.2101, 300, 0, 0, 8982, 3155, 0, 0, 0, 0),-- The Exodar
(@CGUID+158, 16781, 530, 1, 1, 0, 0, -3814.35, -11505.7, -138.534, 2.81721, 120, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+159, 16781, 530, 1, 1, 0, 0, -3816.08, -11510.3, -138.573, 1.88337, 120, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+160, 26124, 530, 1, 1, 0, 0, 9790.85, -7250.58, 26.1002, 5.48896, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Silvermoon
(@CGUID+161, 16781, 0, 1, 1, 16434, 0, -8823.33, 857.655, 99.0305, 1.57502, 300, 0, 0, 1524, 0, 0, 0, 0, 0), -- Stormwind and Darnassus
(@CGUID+162, 16781, 0, 1, 1, 16433, 0, -8824.21, 861.431, 98.9968, 4.82972, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+163, 16781, 0, 1, 1, 16433, 0, -8826.99, 859.058, 99.0299, 0.149527, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+164, 16781, 1, 1, 1, 16434, 0, 8720.84, 963.484, 11.851, 1.43676, 300, 0, 0, 1524, 0, 0, 0, 0, 0),
(@CGUID+165, 26221, 0, 1, 1, 0, 1, -8832.81, 861.687, 98.8931, 0.880735, 300, 0, 0, 8982, 3155, 0, 0, 0, 0),
(@CGUID+166, 26123, 0, 1, 1, 0, 0, -8827.68, 875.783, 98.6689, 4.60823, 300, 0, 0, 3052, 0, 0, 0, 0, 0),
(@CGUID+167, 16817, 0, 1, 1, 16354, 0, -8831.73, 854.756, 99.1285, 5.71407, 300, 0, 0, 3052, 0, 0, 0, 0, 0);
DELETE FROM `game_event_creature` WHERE `eventEntry`=1 AND `guid` BETWEEN @CGUID AND @CGUID+167;
INSERT INTO `game_event_creature` (`eventEntry`,`guid`) VALUES
(1,@CGUID+0),
(1,@CGUID+1),
(1,@CGUID+2),
(1,@CGUID+3),
(1,@CGUID+4),
(1,@CGUID+5),
(1,@CGUID+6),
(1,@CGUID+7),
(1,@CGUID+8),
(1,@CGUID+9),
(1,@CGUID+10),
(1,@CGUID+11),
(1,@CGUID+12),
(1,@CGUID+13),
(1,@CGUID+14),
(1,@CGUID+15),
(1,@CGUID+16),
(1,@CGUID+17),
(1,@CGUID+18),
(1,@CGUID+19),
(1,@CGUID+20),
(1,@CGUID+21),
(1,@CGUID+22),
(1,@CGUID+23),
(1,@CGUID+24),
(1,@CGUID+25),
(1,@CGUID+26),
(1,@CGUID+27),
(1,@CGUID+28),
(1,@CGUID+29),
(1,@CGUID+30),
(1,@CGUID+31),
(1,@CGUID+32),
(1,@CGUID+33),
(1,@CGUID+34),
(1,@CGUID+35),
(1,@CGUID+36),
(1,@CGUID+37),
(1,@CGUID+38),
(1,@CGUID+39),
(1,@CGUID+40),
(1,@CGUID+41),
(1,@CGUID+42),
(1,@CGUID+43),
(1,@CGUID+44),
(1,@CGUID+45),
(1,@CGUID+46),
(1,@CGUID+47),
(1,@CGUID+48),
(1,@CGUID+49),
(1,@CGUID+50),
(1,@CGUID+51),
(1,@CGUID+52),
(1,@CGUID+53),
(1,@CGUID+54),
(1,@CGUID+55),
(1,@CGUID+56),
(1,@CGUID+57),
(1,@CGUID+58),
(1,@CGUID+59),
(1,@CGUID+60),
(1,@CGUID+61),
(1,@CGUID+62),
(1,@CGUID+63),
(1,@CGUID+64),
(1,@CGUID+65),
(1,@CGUID+66),
(1,@CGUID+67),
(1,@CGUID+68),
(1,@CGUID+69),
(1,@CGUID+70),
(1,@CGUID+71),
(1,@CGUID+72),
(1,@CGUID+73),
(1,@CGUID+74),
(1,@CGUID+75),
(1,@CGUID+76),
(1,@CGUID+77),
(1,@CGUID+78),
(1,@CGUID+79),
(1,@CGUID+80),
(1,@CGUID+81),
(1,@CGUID+82),
(1,@CGUID+83),
(1,@CGUID+84),
(1,@CGUID+85),
(1,@CGUID+86),
(1,@CGUID+87),
(1,@CGUID+88),
(1,@CGUID+89),
(1,@CGUID+90),
(1,@CGUID+91),
(1,@CGUID+92),
(1,@CGUID+93),
(1,@CGUID+94),
(1,@CGUID+95),
(1,@CGUID+96),
(1,@CGUID+97),
(1,@CGUID+98),
(1,@CGUID+99),
(1,@CGUID+100),
(1,@CGUID+101),
(1,@CGUID+102),
(1,@CGUID+103),
(1,@CGUID+104),
(1,@CGUID+105),
(1,@CGUID+106),
(1,@CGUID+107),
(1,@CGUID+108),
(1,@CGUID+109),
(1,@CGUID+110),
(1,@CGUID+111),
(1,@CGUID+112),
(1,@CGUID+113),
(1,@CGUID+114),
(1,@CGUID+115),
(1,@CGUID+116),
(1,@CGUID+117),
(1,@CGUID+118),
(1,@CGUID+119),
(1,@CGUID+120),
(1,@CGUID+121),
(1,@CGUID+122),
(1,@CGUID+123),
(1,@CGUID+124),
(1,@CGUID+125),
(1,@CGUID+126),
(1,@CGUID+127),
(1,@CGUID+128),
(1,@CGUID+129),
(1,@CGUID+130),
(1,@CGUID+131),
(1,@CGUID+132),
(1,@CGUID+133),
(1,@CGUID+134),
(1,@CGUID+135),
(1,@CGUID+136),
(1,@CGUID+137),
(1,@CGUID+138),
(1,@CGUID+139),
(1,@CGUID+140),
(1,@CGUID+141),
(1,@CGUID+142),
(1,@CGUID+143),
(1,@CGUID+144),
(1,@CGUID+145),
(1,@CGUID+146),
(1,@CGUID+147),
(1,@CGUID+148),
(1,@CGUID+149),
(1,@CGUID+150),
(1,@CGUID+151),
(1,@CGUID+152),
(1,@CGUID+153),
(1,@CGUID+154),
(1,@CGUID+155),
(1,@CGUID+156),
(1,@CGUID+157),
(1,@CGUID+158),
(1,@CGUID+159),
(1,@CGUID+160),
(1,@CGUID+161),
(1,@CGUID+162),
(1,@CGUID+163),
(1,@CGUID+164),
(1,@CGUID+165),
(1,@CGUID+166),
(1,@CGUID+167);
DELETE FROM `game_event_gameobject` WHERE `eventEntry`=1 AND `guid` BETWEEN @OGUID AND @OGUID+418;
INSERT INTO `game_event_gameobject` (`eventEntry`,`guid`) VALUES
(1,@OGUID+0),
(1,@OGUID+1),
(1,@OGUID+2),
(1,@OGUID+3),
(1,@OGUID+4),
(1,@OGUID+5),
(1,@OGUID+6),
(1,@OGUID+7),
(1,@OGUID+8),
(1,@OGUID+9),
(1,@OGUID+10),
(1,@OGUID+11),
(1,@OGUID+12),
(1,@OGUID+13),
(1,@OGUID+14),
(1,@OGUID+15),
(1,@OGUID+16),
(1,@OGUID+17),
(1,@OGUID+18),
(1,@OGUID+19),
(1,@OGUID+20),
(1,@OGUID+21),
(1,@OGUID+22),
(1,@OGUID+23),
(1,@OGUID+24),
(1,@OGUID+25),
(1,@OGUID+26),
(1,@OGUID+27),
(1,@OGUID+28),
(1,@OGUID+29),
(1,@OGUID+30),
(1,@OGUID+31),
(1,@OGUID+32),
(1,@OGUID+33),
(1,@OGUID+34),
(1,@OGUID+35),
(1,@OGUID+36),
(1,@OGUID+37),
(1,@OGUID+38),
(1,@OGUID+39),
(1,@OGUID+40),
(1,@OGUID+41),
(1,@OGUID+42),
(1,@OGUID+43),
(1,@OGUID+44),
(1,@OGUID+45),
(1,@OGUID+46),
(1,@OGUID+47),
(1,@OGUID+48),
(1,@OGUID+49),
(1,@OGUID+50),
(1,@OGUID+51),
(1,@OGUID+52),
(1,@OGUID+53),
(1,@OGUID+54),
(1,@OGUID+55),
(1,@OGUID+56),
(1,@OGUID+57),
(1,@OGUID+58),
(1,@OGUID+59),
(1,@OGUID+60),
(1,@OGUID+61),
(1,@OGUID+62),
(1,@OGUID+63),
(1,@OGUID+64),
(1,@OGUID+65),
(1,@OGUID+66),
(1,@OGUID+67),
(1,@OGUID+68),
(1,@OGUID+69),
(1,@OGUID+70),
(1,@OGUID+71),
(1,@OGUID+72),
(1,@OGUID+73),
(1,@OGUID+74),
(1,@OGUID+75),
(1,@OGUID+76),
(1,@OGUID+77),
(1,@OGUID+78),
(1,@OGUID+79),
(1,@OGUID+80),
(1,@OGUID+81),
(1,@OGUID+82),
(1,@OGUID+83),
(1,@OGUID+84),
(1,@OGUID+85),
(1,@OGUID+86),
(1,@OGUID+87),
(1,@OGUID+88),
(1,@OGUID+89),
(1,@OGUID+90),
(1,@OGUID+91),
(1,@OGUID+92),
(1,@OGUID+93),
(1,@OGUID+94),
(1,@OGUID+95),
(1,@OGUID+96),
(1,@OGUID+97),
(1,@OGUID+98),
(1,@OGUID+99),
(1,@OGUID+100),
(1,@OGUID+101),
(1,@OGUID+102),
(1,@OGUID+103),
(1,@OGUID+104),
(1,@OGUID+105),
(1,@OGUID+106),
(1,@OGUID+107),
(1,@OGUID+108),
(1,@OGUID+109),
(1,@OGUID+110),
(1,@OGUID+111),
(1,@OGUID+112),
(1,@OGUID+113),
(1,@OGUID+114),
(1,@OGUID+115),
(1,@OGUID+116),
(1,@OGUID+117),
(1,@OGUID+118),
(1,@OGUID+119),
(1,@OGUID+120),
(1,@OGUID+121),
(1,@OGUID+122),
(1,@OGUID+123),
(1,@OGUID+124),
(1,@OGUID+125),
(1,@OGUID+126),
(1,@OGUID+127),
(1,@OGUID+128),
(1,@OGUID+129),
(1,@OGUID+130),
(1,@OGUID+131),
(1,@OGUID+132),
(1,@OGUID+133),
(1,@OGUID+134),
(1,@OGUID+135),
(1,@OGUID+136),
(1,@OGUID+137),
(1,@OGUID+138),
(1,@OGUID+139),
(1,@OGUID+140),
(1,@OGUID+141),
(1,@OGUID+142),
(1,@OGUID+143),
(1,@OGUID+144),
(1,@OGUID+145),
(1,@OGUID+146),
(1,@OGUID+147),
(1,@OGUID+148),
(1,@OGUID+149),
(1,@OGUID+150),
(1,@OGUID+151),
(1,@OGUID+152),
(1,@OGUID+153),
(1,@OGUID+154),
(1,@OGUID+155),
(1,@OGUID+156),
(1,@OGUID+157),
(1,@OGUID+158),
(1,@OGUID+159),
(1,@OGUID+160),
(1,@OGUID+161),
(1,@OGUID+162),
(1,@OGUID+163),
(1,@OGUID+164),
(1,@OGUID+165),
(1,@OGUID+166),
(1,@OGUID+167),
(1,@OGUID+168),
(1,@OGUID+169),
(1,@OGUID+170),
(1,@OGUID+171),
(1,@OGUID+172),
(1,@OGUID+173),
(1,@OGUID+174),
(1,@OGUID+175),
(1,@OGUID+176),
(1,@OGUID+177),
(1,@OGUID+178),
(1,@OGUID+179),
(1,@OGUID+180),
(1,@OGUID+181),
(1,@OGUID+182),
(1,@OGUID+183),
(1,@OGUID+184),
(1,@OGUID+185),
(1,@OGUID+186),
(1,@OGUID+187),
(1,@OGUID+188),
(1,@OGUID+189),
(1,@OGUID+190),
(1,@OGUID+191),
(1,@OGUID+192),
(1,@OGUID+193),
(1,@OGUID+194),
(1,@OGUID+195),
(1,@OGUID+196),
(1,@OGUID+197),
(1,@OGUID+198),
(1,@OGUID+199),
(1,@OGUID+200),
(1,@OGUID+201),
(1,@OGUID+202),
(1,@OGUID+203),
(1,@OGUID+204),
(1,@OGUID+205),
(1,@OGUID+206),
(1,@OGUID+207),
(1,@OGUID+208),
(1,@OGUID+209),
(1,@OGUID+210),
(1,@OGUID+211),
(1,@OGUID+212),
(1,@OGUID+213),
(1,@OGUID+214),
(1,@OGUID+215),
(1,@OGUID+216),
(1,@OGUID+217),
(1,@OGUID+218),
(1,@OGUID+219),
(1,@OGUID+220),
(1,@OGUID+221),
(1,@OGUID+222),
(1,@OGUID+223),
(1,@OGUID+224),
(1,@OGUID+225),
(1,@OGUID+226),
(1,@OGUID+227),
(1,@OGUID+228),
(1,@OGUID+229),
(1,@OGUID+230),
(1,@OGUID+231),
(1,@OGUID+232),
(1,@OGUID+233),
(1,@OGUID+234),
(1,@OGUID+235),
(1,@OGUID+236),
(1,@OGUID+237),
(1,@OGUID+238),
(1,@OGUID+239),
(1,@OGUID+240),
(1,@OGUID+241),
(1,@OGUID+242),
(1,@OGUID+243),
(1,@OGUID+244),
(1,@OGUID+245),
(1,@OGUID+246),
(1,@OGUID+247),
(1,@OGUID+248),
(1,@OGUID+249),
(1,@OGUID+250),
(1,@OGUID+251),
(1,@OGUID+252),
(1,@OGUID+253),
(1,@OGUID+254),
(1,@OGUID+255),
(1,@OGUID+256),
(1,@OGUID+257),
(1,@OGUID+258),
(1,@OGUID+259),
(1,@OGUID+260),
(1,@OGUID+261),
(1,@OGUID+262),
(1,@OGUID+263),
(1,@OGUID+264),
(1,@OGUID+265),
(1,@OGUID+266),
(1,@OGUID+267),
(1,@OGUID+268),
(1,@OGUID+269),
(1,@OGUID+270),
(1,@OGUID+271),
(1,@OGUID+272),
(1,@OGUID+273),
(1,@OGUID+274),
(1,@OGUID+275),
(1,@OGUID+276),
(1,@OGUID+277),
(1,@OGUID+278),
(1,@OGUID+279),
(1,@OGUID+280),
(1,@OGUID+281),
(1,@OGUID+282),
(1,@OGUID+283),
(1,@OGUID+284),
(1,@OGUID+285),
(1,@OGUID+286),
(1,@OGUID+287),
(1,@OGUID+288),
(1,@OGUID+289),
(1,@OGUID+290),
(1,@OGUID+291),
(1,@OGUID+292),
(1,@OGUID+293),
(1,@OGUID+294),
(1,@OGUID+295),
(1,@OGUID+296),
(1,@OGUID+297),
(1,@OGUID+298),
(1,@OGUID+299),
(1,@OGUID+300),
(1,@OGUID+301),
(1,@OGUID+302),
(1,@OGUID+303),
(1,@OGUID+304),
(1,@OGUID+305),
(1,@OGUID+306),
(1,@OGUID+307),
(1,@OGUID+308),
(1,@OGUID+309),
(1,@OGUID+310),
(1,@OGUID+311),
(1,@OGUID+312),
(1,@OGUID+313),
(1,@OGUID+314),
(1,@OGUID+315),
(1,@OGUID+316),
(1,@OGUID+317),
(1,@OGUID+318),
(1,@OGUID+319),
(1,@OGUID+320),
(1,@OGUID+321),
(1,@OGUID+322),
(1,@OGUID+323),
(1,@OGUID+324),
(1,@OGUID+325),
(1,@OGUID+326),
(1,@OGUID+327),
(1,@OGUID+328),
(1,@OGUID+329),
(1,@OGUID+330),
(1,@OGUID+331),
(1,@OGUID+332),
(1,@OGUID+333),
(1,@OGUID+334),
(1,@OGUID+335),
(1,@OGUID+336),
(1,@OGUID+337),
(1,@OGUID+338),
(1,@OGUID+339),
(1,@OGUID+340),
(1,@OGUID+341),
(1,@OGUID+342),
(1,@OGUID+343),
(1,@OGUID+344),
(1,@OGUID+345),
(1,@OGUID+346),
(1,@OGUID+347),
(1,@OGUID+348),
(1,@OGUID+349),
(1,@OGUID+350),
(1,@OGUID+351),
(1,@OGUID+352),
(1,@OGUID+353),
(1,@OGUID+354),
(1,@OGUID+355),
(1,@OGUID+356),
(1,@OGUID+357),
(1,@OGUID+358),
(1,@OGUID+359),
(1,@OGUID+360),
(1,@OGUID+361),
(1,@OGUID+362),
(1,@OGUID+363),
(1,@OGUID+364),
(1,@OGUID+365),
(1,@OGUID+366),
(1,@OGUID+367),
(1,@OGUID+368),
(1,@OGUID+369),
(1,@OGUID+370),
(1,@OGUID+371),
(1,@OGUID+372),
(1,@OGUID+373),
(1,@OGUID+374),
(1,@OGUID+375),
(1,@OGUID+376),
(1,@OGUID+377),
(1,@OGUID+378),
(1,@OGUID+379),
(1,@OGUID+380),
(1,@OGUID+381),
(1,@OGUID+382),
(1,@OGUID+383),
(1,@OGUID+384),
(1,@OGUID+385),
(1,@OGUID+386),
(1,@OGUID+387),
(1,@OGUID+388),
(1,@OGUID+389),
(1,@OGUID+390),
(1,@OGUID+391),
(1,@OGUID+392),
(1,@OGUID+393),
(1,@OGUID+394),
(1,@OGUID+395),
(1,@OGUID+396),
(1,@OGUID+397),
(1,@OGUID+398),
(1,@OGUID+399),
(1,@OGUID+400),
(1,@OGUID+401),
(1,@OGUID+402),
(1,@OGUID+403),
(1,@OGUID+404),
(1,@OGUID+405),
(1,@OGUID+406),
(1,@OGUID+407),
(1,@OGUID+408),
(1,@OGUID+409),
(1,@OGUID+410),
(1,@OGUID+411),
(1,@OGUID+412),
(1,@OGUID+413),
(1,@OGUID+414),
(1,@OGUID+415),
(1,@OGUID+416),
(1,@OGUID+417),
(1,@OGUID+418);