diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2024_11_28_00_world.sql | 552 |
1 files changed, 552 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_11_28_00_world.sql b/sql/updates/world/master/2024_11_28_00_world.sql new file mode 100644 index 00000000000..6b7243f737d --- /dev/null +++ b/sql/updates/world/master/2024_11_28_00_world.sql @@ -0,0 +1,552 @@ +SET @CGUID := 4000253; +SET @OGUID := 4000108; + +UPDATE `creature_template` SET `unit_flags`=0x0, `unit_flags3`=0x1000001 WHERE `entry`=66473; -- Skyfire Gyrocopter +UPDATE `creature_template` SET `unit_flags`=0x0, `unit_flags2`=0x800 WHERE `entry`=66300; -- Skyfire Marine +UPDATE `creature_template` SET `npcflag`=3, `BaseAttackTime`=2000, `unit_flags`=0x100, `unit_flags2`=0x800 WHERE `entry`=66292; -- Sky Admiral Rogers +UPDATE `creature_template` SET `BaseAttackTime`=2000, `unit_flags2`=0x800 WHERE `entry`=64866; -- Corporal Rasmussen +UPDATE `creature_template` SET `BaseAttackTime`=2000, `unit_flags2`=0x800 WHERE `entry`=64865; -- Airman Rogers +UPDATE `creature_template` SET `BaseAttackTime`=2000, `unit_flags2`=0x800 WHERE `entry`=64864; -- Airman Clifton +UPDATE `creature_template` SET `BaseAttackTime`=2000, `unit_flags2`=0x800 WHERE `entry`=64863; -- Sky Mage Harlan +UPDATE `creature_template` SET `BaseAttackTime`=2000, `unit_flags2`=0x800 WHERE `entry`=64862; -- Airman Ellis +UPDATE `creature_template` SET `BaseAttackTime`=2000, `unit_flags2`=0x800 WHERE `entry`=64861; -- Captain Day +UPDATE `creature_template` SET `BaseAttackTime`=2000, `unit_flags2`=0x800 WHERE `entry`=64860; -- Captain Kerwin +UPDATE `creature_template` SET `unit_flags2`=0x800 WHERE `entry`=64859; -- Sky Captain Callanan +UPDATE `creature_template` SET `BaseAttackTime`=2000, `unit_flags2`=0x800 WHERE `entry`=64858; -- Airman Hicks +UPDATE `creature_template` SET `BaseAttackTime`=2000, `unit_flags`=0x300, `unit_flags2`=0x800 WHERE `entry`=55832; -- Nodd Codejack +UPDATE `creature_template` SET `BaseAttackTime`=2000, `unit_flags`=0x300, `unit_flags2`=0x800 WHERE `entry`=55830; -- Nimm Codejack +UPDATE `creature_template` SET `BaseAttackTime`=2000, `unit_flags`=0x300, `unit_flags2`=0x800 WHERE `entry`=55825; -- Amber Kearnen +UPDATE `creature_template` SET `BaseAttackTime`=2000, `unit_flags`=0x300, `unit_flags2`=0x800 WHERE `entry`=55823; -- Mishka +UPDATE `creature_template` SET `BaseAttackTime`=2000, `unit_flags`=0x300, `unit_flags2`=0x800 WHERE `entry`=55819; -- Sully "The Pickle" McLeary + +DELETE FROM `creature_template_addon` WHERE `entry` IN (66480,66473,66460,66300,66292,64866,64865,64864,64863,64862,64861,64860,64859,64858,55832,55830,55825,55823,55819,55370); +INSERT INTO `creature_template_addon` (`entry`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(66480, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 66480 (Skyfire Engineer) +(66473, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 66473 (Skyfire Gyrocopter) +(66460, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 66460 (Skyfire Gyrocopter Pilot) +(66300, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), -- 66300 (Skyfire Marine) +(66292, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 66292 (Sky Admiral Rogers) +(64866, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- 64866 (Corporal Rasmussen) +(64865, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- 64865 (Airman Rogers) +(64864, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- 64864 (Airman Clifton) +(64863, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- 64863 (Sky Mage Harlan) +(64862, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- 64862 (Airman Ellis) +(64861, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- 64861 (Captain Day) +(64860, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- 64860 (Captain Kerwin) +(64859, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, ''), -- 64859 (Sky Captain Callanan) +(64858, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- 64858 (Airman Hicks) +(55832, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 55832 (Nodd Codejack) +(55830, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 55830 (Nimm Codejack) +(55825, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '131904'), -- 55825 (Amber Kearnen) - Kearnen's Sniper Rifle +(55823, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 55823 (Mishka) +(55819, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 55819 (Sully "The Pickle" McLeary) +(55370, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 0, ''); -- 55370 (General Purpose Bunny ZTO) + +UPDATE `creature_equip_template` SET `VerifiedBuild`=57689 WHERE (`ID`=1 AND `CreatureID` IN (201312,198579,176554,176241,176192,175138,174146,173819,173706,173220,171789,155011,150122,149626,149616,149131,148233,148124,147785,147741,147714,143098,133675,133441,133433,125210,114246,113211,112912,108767,108759,108758,108757,108756,108755,108754,108753,108752,108751,108750,108749,108748,108747,108746,108745,108742,108723,108722,108705,108588,108587,108586,108584,108525,108488,108481,108143,108142,108141,108140,108051,107841,107835,107833,107829,107827,107826,88067,87501,69334,68980,66480,66460,66300,64859,61841,61840,61839,58193,58167,57800,55832,55684,54443,54442,54218,54217,54216,52031,51348,49748,49701,47688,47325,47324,47320,46180,45306,45226,44583,44395,44236,43840,43034,42421,42288,34998,34997,30713,29725,29712,29289,29288,29287,29152,29088,29016,28355,28347,20407,14497,14439,14438,11096,11068,11026,10782,7798,7232,6579,6171,6090,6089,6086,5694,5566,5519,5518,5517,5516,5514,5513,5512,5511,5510,5509,5506,5504,5503,5500,5499,5498,5494,5493,5492,5491,5489,5484,5483,5482,5413,5386,5384,4984,4960,4078,2708,2485,1756,1752,1751,1750,1649,1472,1444,1439,1431,1416,1415,1371,1370,1368,1351,1348,1339,1328,1327,1321,1319,1316,1313,1312,1311,1308,1305,1301,1298,1297,1292,1141,957,928,656,376,340,338,331,68)) OR (`ID`=2 AND `CreatureID` IN (176220,169177,133675,107839,107826,66480,29016,17252,5515)) OR (`ID`=3 AND `CreatureID` IN (176203,169177,133675,29016)) OR (`ID`=4 AND `CreatureID` IN (169177,1976)); + +-- Models +UPDATE `creature_template_model` SET `VerifiedBuild`=57689 WHERE (`Idx`=0 AND `CreatureID` IN (11069,5413,1472,108921,108293,149374,108296,29288,29290,29289,29287,43102,108140,108143,108141,108051,108584,108583,108585,17252,108297,125210,143622,139088,11397,6086,4984,114465,108483,108481,108412,108410,108581,108142,44749,108420,107933,107931,193812,189763,107936,107935,107934,176241,108298,43103,108722,198383,189767,108757,108752,108751,108748,108746,108744,108743,108723,108767,108765,108759,108758,108756,108755,108753,108745,108487,108485,108488,108742,108747,108749,108750,108754,108705,29154,108588,108587,108586,108138,107826,29088,108533,108205,108204,108203,36799,29019,29016,108192,104549,108299,108895,108896,107841,107839,107829,107827,29152,108241,107835,107833,107823,180538,108582,197503,55832,55825,55823,64860,64866,66292,64863,55830,55819,55370,64864,64862,64861,64859,64858,40789,66473,66480,66460,66300,64865,108525,108691,151187,54219,54218,54217,54216,54214,53991,54215,170715,5483,5482,1324,155011,153292,31146,23050,11096,6090,6089,5565,5564,3629,1327,1321,1320,1292,340,176237,176235,176192,87501,44237,28355,28347,4961,3626,2795,1395,1339,1333,1328,55684,53641,5384,656,201194,70296,69334,68868,65069,65068,65066,65051,65048,60931,58193,47325,47324,47320,45226,47688,89715,58167,88067,61081,62954,65078,65076,65074,65072,65060,65058,65065,65061,63607,63596,2620,142789,34997,51938,142788,142787,142786,69823,69822,49908,49907,44392,5517,5516,5515,2879,61080,88080,88081,65071,62106,65063,61809,44394,44393,44236,44235,43840,43825,43824,43823,43725,43724,43723,43034,20407,19269,16908,1649,49748,45306,43842,14563,11026,6579,5519,5518,5512,5511,957,197269,197267,197253,43841,43690,29725,7798,5510,143098,198071,1313,5499,5503,5500,1431,1301,277,113211,14439,8719,8670,6740,175420,175416,141270,44773,29093,15659,4075,1427,1402,1295,1294,1291,55789,34998,24729,15187,1751,1750,189603,93296,17103,4960,2285,1752,1439,50088,165505,189602,175138,61839,61840,176554,176220,176203,173706,171789,173220,173219,169177,1756,61841,201230,87503,1319,56925,50480,44583,44582,198532,179896,44774,29142,50523,50525,149469,175402,97128,2198,38821,133369,209299,112698,176242,176222,42782,1416,80069,7232,5514,5513,5509,8666,10782,1646,3520,197762,83890,83883,83882,83878,54117,54026,53626,14497,14496,14450,1444,157498,157496,108180,71527,71526,50432,50424,14438,7386,1349,1428,1299,1298,1297,112912,42339,5494,5493,231086,231085,149445,149438,1860,198601,1305,149433,216439,149436,207176,155739,147714,149467,230737,207684,173545,148796,5081,37865,151937,149099,148233,148124,147785,147741,89174,52408,5497,3628,2485,1311,1141,331,230765,230735,198096,149458,149131,103033,5566,5498,4078,2708,1419,1307,1300,149121,149124,1314,1347,1346,149616,149626,150122,1413,1415,1310,5694,85307,1414,198509,198506,198505,174146,158755,158753,158463,158456,158440,158436,85819,85818,85817,85816,84751,84749,84745,82564,23837,5567,2334,1429,1309,1308,721,46180,11068,3627,1318,1317,1316,1315,1312,52358,52359,52361,5506,197287,338,30730,230734,201312,199731,185670,185669,185468,185467,183978,152643,52031,51348,49701,42288,30713,5386,224334,224134,223965,199602,198589,198581,198579,198529,198482,185672,49893,11828,11827,224211,114246,68980,57800,54443,54442,49540,5504,1976,1405,1350,66876,42421,29712,15214,1371,1370,1368,1348,165189,51081,7917,173819,56796,50435,50434,44880,12336,6173,6171,5492,5491,5489,5484,4982,1412,1351,1212,928,376,197611,29144,230780,43451,111190,230743,44395,20716,32520,209790,158119,158123,158120,112694,112686,133433,133441,133675,133409,230720,126332,167032,133408,172572,158125,68,133509,21354,33030,18360,63502,31698,35362,65011,69066,64993,71486,70356,69219,68288,65016,63042,59072,56921,54879,54741,54423,47654,40725,40625,40165,25064,32158,31717,28363,28302,18362,14505,304,305,60941,308)) OR (`Idx`=2 AND `CreatureID` IN (108921,43102,143622,139088,6086,114465,108581,193812,43103,198383,107826,29088,29016,108895,107841,107839,107829,107827,29152,107835,107833,107823,66480,66460,66300,65051,65048,58193,62954,49907,198071,4075,173219,169177,1756,149469,175402,112698,53626,14496,42339,149445,149438,149433,149436,149467,230737,230765,230735,149458,149131,149124,149616,230734,199731,224334,224134,223965,224211,49540,42421,29712,51081,230780,230743,158119,158123,158120,112694,112686,133433,133441,230720,158125,68,133509)) OR (`Idx`=1 AND `CreatureID` IN (108921,149374,43102,143622,139088,6086,114465,108581,193812,43103,198383,107826,29088,29019,29016,108895,107841,107839,107829,107827,29152,107835,107833,107823,180538,197503,55370,40789,66480,66460,66300,108525,108691,151187,65051,65048,60931,58193,62954,49907,61080,198071,4075,189603,50088,173220,173219,169177,1756,149469,175402,38821,112698,53626,14496,42339,149445,149438,149433,216439,149436,155739,147714,149467,230737,173545,148796,149099,148233,148124,147785,147741,230765,230735,198096,149458,149131,149124,149616,149626,23837,721,52361,230734,199731,183978,152643,51348,224334,224134,223965,185672,224211,49540,1976,42421,29712,15214,51081,197611,29144,230780,111190,230743,32520,158119,158123,158120,112694,112686,133433,133441,133675,230720,158125,68,133509,40725,40165)) OR (`Idx`=3 AND `CreatureID` IN (43102,139088,6086,114465,108581,193812,198383,107826,29088,29016,108895,107841,107839,107829,107827,107835,107833,107823,66480,66460,66300,65051,65048,58193,198071,173219,169177,1756,149469,175402,112698,53626,14496,42339,149445,149438,149433,149436,149467,230737,230765,230735,149458,149131,149616,230734,199731,224334,224134,223965,29712,51081,230780,230743,158119,158123,158120,112694,133433,133441,230720,158125,68,133509)) OR (`Idx`=11 AND `CreatureID` IN (139088,169177,230737,230765,230735,230734,230780,230743,230720)) OR (`Idx`=10 AND `CreatureID` IN (139088,169177,230737,230765,230735,230734,230780,230743,230720)) OR (`Idx`=9 AND `CreatureID` IN (139088,169177,230737,230765,230735,230734,230780,230743,230720)) OR (`Idx`=8 AND `CreatureID` IN (139088,173219,169177,230737,230765,230735,230734,230780,230743,230720)) OR (`Idx`=7 AND `CreatureID` IN (139088,173219,169177,230737,230765,230735,230734,223965,230780,230743,230720)) OR (`Idx`=6 AND `CreatureID` IN (139088,173219,169177,230737,230765,230735,230734,224334,224134,223965,230780,230743,230720)) OR (`Idx`=5 AND `CreatureID` IN (139088,193812,173219,169177,230737,230765,230735,230734,224334,224134,223965,230780,230743,230720)) OR (`Idx`=4 AND `CreatureID` IN (139088,193812,29016,173219,169177,1756,230737,230765,230735,149131,230734,199731,224334,224134,223965,230780,230743,230720)) OR (`Idx`=28 AND `CreatureID` IN (230737,230765,230735,230734,230780,230743,230720)) OR (`Idx`=27 AND `CreatureID` IN (230737,230765,230735,230734,230780,230743,230720)) OR (`Idx`=26 AND `CreatureID` IN (230737,230765,230735,230734,230780,230743,230720)) OR (`Idx`=25 AND `CreatureID` IN (230737,230765,230735,230734,230780,230743,230720)) OR (`Idx`=24 AND `CreatureID` IN (230737,230765,230735,230734,230780,230743,230720)) OR (`Idx`=23 AND `CreatureID` IN (230737,230765,230735,230734,230780,230743,230720)) OR (`Idx`=22 AND `CreatureID` IN (230737,230765,230735,230734,230780,230743,230720)) OR (`Idx`=21 AND `CreatureID` IN (230737,230765,230735,230734,230780,230743,230720)) OR (`Idx`=20 AND `CreatureID` IN (230737,230765,230735,230734,230780,230743,230720)) OR (`Idx`=19 AND `CreatureID` IN (230737,230765,230735,230734,230780,230743,230720)) OR (`Idx`=18 AND `CreatureID` IN (230737,230765,230735,230734,230780,230743,230720)) OR (`Idx`=17 AND `CreatureID` IN (230737,230765,230735,230734,230780,230743,230720)) OR (`Idx`=16 AND `CreatureID` IN (230737,230765,230735,230734,230780,230743,230720)) OR (`Idx`=15 AND `CreatureID` IN (230737,230765,230735,230734,230780,230743,230720)) OR (`Idx`=14 AND `CreatureID` IN (230737,230765,230735,230734,230780,230743,230720)) OR (`Idx`=13 AND `CreatureID` IN (230737,230765,230735,230734,230780,230743,230720)) OR (`Idx`=12 AND `CreatureID` IN (230737,230765,230735,230734,230780,230743,230720)); + +DELETE FROM `creature_model_info` WHERE `DisplayID` IN (111078, 111075, 114294, 111208, 107063, 113200); +INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`) VALUES +(111078, 0.866400063037872314, 2.40000009536743164, 0, 57689), +(111075, 0.722000002861022949, 2, 0, 57689), +(114294, 1.248929262161254882, 1, 0, 57689), +(111208, 0.917803108692169189, 1.5, 0, 57689), +(107063, 0.187199994921684265, 1.349999904632568359, 0, 57689), +(113200, 1.05910801887512207, 0, 0, 57689); + +UPDATE `creature_model_info` SET `VerifiedBuild`=57689 WHERE `DisplayID` IN (122774, 122773, 104839, 104841, 104842, 104835, 104837, 104836, 104726, 104831, 108882, 116639, 116640, 71286, 113854, 93505, 26375, 111365, 78193, 78196, 64062, 110254, 110242, 110234, 110231, 110176, 110173, 68845, 110154, 110153, 110111, 104846, 104843, 104198, 104187, 109887, 109706, 27823, 109492, 74513, 109485, 109484, 94031, 94032, 107015, 106741, 102032, 105170, 105546, 107560, 106965, 106966, 27153, 100179, 100178, 100174, 100172, 100161, 100003, 100004, 100159, 913, 99615, 99432, 99433, 99431, 78345, 87530, 98599, 98571, 25777, 25375, 10569, 3296, 3300, 3304, 3316, 1488, 98008, 71257, 96325, 96423, 96330, 96326, 96331, 96086, 96328, 96332, 24877, 95808, 93617, 87578, 54859, 93520, 93516, 83230, 93415, 93417, 93411, 93413, 81533, 81532, 85210, 88674, 92464, 92463, 92198, 28048, 89885, 56857, 99420, 18297, 18327, 18322, 90357, 90358, 90355, 90353, 90356, 90341, 90342, 90339, 90338, 90340, 90335, 90333, 90336, 90326, 90331, 90329, 90332, 90206, 90201, 90208, 90209, 90207, 46209, 18930, 90104, 26069, 26067, 89933, 89932, 89930, 89931, 20985, 20988, 89786, 89785, 89777, 90197, 89771, 89772, 77406, 77407, 87815, 5369, 85246, 44820, 87182, 88604, 88615, 18890, 18889, 83236, 83234, 83233, 83232, 82919, 46929, 82897, 5131, 41667, 78428, 14613, 2306, 14614, 73152, 72724, 72447, 72178, 68729, 26989, 70765, 46298, 34537, 34535, 34536, 58990, 61356, 60070, 59188, 58261, 60075, 60519, 60543, 58690, 58502, 60560, 60409, 58786, 60041, 58682, 60487, 25807, 61371, 59971, 58457, 58467, 61187, 31309, 31310, 57267, 57255, 57249, 61502, 57242, 61504, 70625, 66552, 66557, 66546, 66548, 70573, 16936, 33770, 28047, 14753, 3098, 62196, 62786, 68882, 7970, 61189, 61350, 61370, 5553, 58500, 60018, 59187, 60466, 70413, 59189, 23072, 23073, 70351, 70350, 70349, 70329, 70328, 70330, 70327, 70326, 70323, 70325, 70324, 70318, 70320, 70319, 70321, 70317, 70315, 70316, 70314, 70310, 70311, 70312, 70313, 70309, 70308, 70306, 70307, 70302, 70305, 70303, 70304, 70298, 70299, 70297, 70300, 68632, 16910, 65087, 63522, 61764, 17241, 60711, 60207, 60316, 99416, 19619, 59145, 58785, 58478, 99415, 5586, 5448, 58003, 57081, 46544, 36743, 49021, 47980, 47711, 47710, 47467, 47231, 46986, 45192, 45185, 45193, 44634, 45159, 45158, 45157, 45156, 44977, 44979, 44978, 44980, 45220, 43726, 43725, 43724, 43723, 43722, 38459, 41281, 39641, 43721, 43720, 43719, 43718, 43717, 45875, 45873, 45874, 45877, 45870, 45183, 45178, 45177, 45182, 45179, 45181, 45180, 45176, 45205, 36620, 4558, 42352, 42279, 42278, 42277, 42250, 19283, 26748, 26747, 40027, 39809, 39532, 39501, 38871, 38875, 38876, 38870, 38872, 45707, 39184, 38800, 38804, 38684, 38688, 99399, 38685, 38686, 38683, 19091, 38626, 38596, 38422, 37874, 22769, 33303, 37850, 99381, 37310, 37311, 36816, 36814, 37087, 36792, 36791, 36790, 36786, 257, 36656, 36597, 99379, 99500, 35540, 35539, 35537, 99187, 34396, 34336, 34160, 34070, 80, 34115, 99497, 99498, 29961, 33839, 33838, 719, 33743, 33740, 99393, 33529, 33528, 33527, 33523, 99396, 99395, 33496, 33495, 33494, 99397, 19335, 33220, 32939, 33497, 1659, 99401, 18054, 18055, 45881, 28507, 19670, 15921, 32928, 21072, 31174, 30320, 29515, 29514, 21342, 27510, 99383, 27261, 26450, 26109, 26108, 26107, 26106, 25943, 5003, 99501, 5008, 25341, 33948, 25901, 25898, 25899, 25851, 88847, 88841, 99504, 25848, 25847, 99505, 99503, 25336, 25319, 344, 19732, 19598, 81304, 16854, 81303, 15594, 15321, 14375, 14554, 8632, 14500, 14493, 14492, 13049, 11746, 11747, 11044, 10625, 10477, 10591, 99394, 10131, 7992, 7991, 7935, 7008, 6844, 9990, 6007, 5444, 5378, 4887, 4885, 5000, 4996, 4846, 5076, 3444, 3445, 3448, 3449, 3315, 3314, 3310, 3309, 99390, 3313, 3308, 3311, 3307, 3306, 99398, 3302, 99506, 99425, 3298, 3295, 19803, 3292, 99496, 3285, 3289, 3284, 3283, 3282, 3288, 3281, 4997, 5081, 99164, 3010, 5078, 3238, 2961, 2181, 1418, 2176, 1141, 1696, 99421, 1694, 1697, 1544, 5043, 1505, 2968, 1072, 99430, 11686, 5075, 1525, 99949, 99947, 99951, 34004, 99950, 18931, 5077, 5565, 48989, 1357, 5570, 5549, 1758, 5545, 5552, 5551, 4998, 99418, 1473, 1472, 134, 1524, 1438, 1508, 262, 338, 221, 1501, 1498, 1500, 1503, 99422, 1502, 1522, 1511, 1521, 1516, 1512, 1520, 1517, 1510, 99186, 99185, 99193, 1486, 99423, 99424, 1477, 1491, 1489, 99417, 1494, 1480, 99198, 1443, 1432, 1447, 1427, 1446, 1445, 1423, 1449, 1439, 5548, 5073, 99392, 1499, 328, 4626, 2363, 1495, 5728, 5080, 1484, 1433, 99391, 5446, 99389, 3167); +UPDATE `creature_model_info` SET `BoundingRadius`=1.333333373069763183, `VerifiedBuild`=57689 WHERE `DisplayID`=76046; +UPDATE `creature_model_info` SET `BoundingRadius`=0.216235101222991943, `CombatReach`=0.779591858386993408, `VerifiedBuild`=57689 WHERE `DisplayID`=63716; + +-- Difficulties +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10080000, `VerifiedBuild`=57689 WHERE (`Entry`=66480 AND `DifficultyID`=0); -- 66480 (Skyfire Engineer) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x20000000, `VerifiedBuild`=57689 WHERE (`Entry`=66473 AND `DifficultyID`=0); -- 66473 (Skyfire Gyrocopter) - Floating +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10080000, `VerifiedBuild`=57689 WHERE (`Entry`=66460 AND `DifficultyID`=0); -- 66460 (Skyfire Gyrocopter Pilot) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10080000, `VerifiedBuild`=57689 WHERE (`Entry`=66300 AND `DifficultyID`=0); -- 66300 (Skyfire Marine) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10080000, `VerifiedBuild`=57689 WHERE (`Entry`=66292 AND `DifficultyID`=0); -- 66292 (Sky Admiral Rogers) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10080000, `StaticFlags3`=0x40000, `VerifiedBuild`=57689 WHERE (`Entry`=64866 AND `DifficultyID`=0); -- 64866 (Corporal Rasmussen) - Amphibious, CanSwim - AllowInteractionWhileInCombat +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10080000, `StaticFlags3`=0x40000, `VerifiedBuild`=57689 WHERE (`Entry`=64865 AND `DifficultyID`=0); -- 64865 (Airman Rogers) - Amphibious, CanSwim - AllowInteractionWhileInCombat +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10080000, `StaticFlags3`=0x40000, `VerifiedBuild`=57689 WHERE (`Entry`=64864 AND `DifficultyID`=0); -- 64864 (Airman Clifton) - Amphibious, CanSwim - AllowInteractionWhileInCombat +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10080000, `StaticFlags3`=0x40000, `VerifiedBuild`=57689 WHERE (`Entry`=64863 AND `DifficultyID`=0); -- 64863 (Sky Mage Harlan) - Amphibious, CanSwim - AllowInteractionWhileInCombat +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10080000, `StaticFlags3`=0x40000, `VerifiedBuild`=57689 WHERE (`Entry`=64862 AND `DifficultyID`=0); -- 64862 (Airman Ellis) - Amphibious, CanSwim - AllowInteractionWhileInCombat +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10080000, `StaticFlags3`=0x40000, `VerifiedBuild`=57689 WHERE (`Entry`=64861 AND `DifficultyID`=0); -- 64861 (Captain Day) - Amphibious, CanSwim - AllowInteractionWhileInCombat +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10080000, `StaticFlags3`=0x40000, `VerifiedBuild`=57689 WHERE (`Entry`=64860 AND `DifficultyID`=0); -- 64860 (Captain Kerwin) - Amphibious, CanSwim - AllowInteractionWhileInCombat +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10080000, `StaticFlags3`=0x40000, `VerifiedBuild`=57689 WHERE (`Entry`=64859 AND `DifficultyID`=0); -- 64859 (Sky Captain Callanan) - Amphibious, CanSwim - AllowInteractionWhileInCombat +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10080000, `StaticFlags3`=0x40000, `VerifiedBuild`=57689 WHERE (`Entry`=64858 AND `DifficultyID`=0); -- 64858 (Airman Hicks) - Amphibious, CanSwim - AllowInteractionWhileInCombat +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10080000, `VerifiedBuild`=57689 WHERE (`Entry`=55832 AND `DifficultyID`=0); -- 55832 (Nodd Codejack) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10080000, `VerifiedBuild`=57689 WHERE (`Entry`=55830 AND `DifficultyID`=0); -- 55830 (Nimm Codejack) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10080000, `VerifiedBuild`=57689 WHERE (`Entry`=55825 AND `DifficultyID`=0); -- 55825 (Amber Kearnen) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10080000, `VerifiedBuild`=57689 WHERE (`Entry`=55823 AND `DifficultyID`=0); -- 55823 (Mishka) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x10080000, `VerifiedBuild`=57689 WHERE (`Entry`=55819 AND `DifficultyID`=0); -- 55819 (Sully "The Pickle" McLeary) - Amphibious, CanSwim +UPDATE `creature_template_difficulty` SET `StaticFlags1`=0x20000000, `VerifiedBuild`=57689 WHERE (`Entry`=55370 AND `DifficultyID`=0); -- 55370 (General Purpose Bunny ZTO) - Floating - CannotSwim +DELETE FROM `creature_template_difficulty` WHERE `Entry` IN (66480,66473,66460,66300,66292,64866,64865,64864,64863,64862,64861,64860,64859,64858,55832,55830,55825,55823,55819,55370) AND `DifficultyID`=1; + +-- Gossips +DELETE FROM `creature_template_gossip` WHERE (`CreatureID`=66292 AND `MenuID`=14971); +INSERT INTO `creature_template_gossip` (`CreatureID`, `MenuID`, `VerifiedBuild`) VALUES +(66292, 14971, 57689); -- Sky Admiral Rogers + +UPDATE `gossip_menu` SET `VerifiedBuild`=57689 WHERE (`MenuID`=25369 AND `TextID`=40006) OR (`MenuID`=15111 AND `TextID`=21620) OR (`MenuID`=14971 AND `TextID`=21166) OR (`MenuID`=25426 AND `TextID`=40347) OR (`MenuID`=14146 AND `TextID`=8590); +UPDATE `gossip_menu_option` SET `GossipOptionID`=40615, `VerifiedBuild`=57689 WHERE (`MenuID`=14971 AND `OptionID`=1); +UPDATE `gossip_menu_option` SET `GossipOptionID`=41277, `VerifiedBuild`=57689 WHERE (`MenuID`=15111 AND `OptionID`=0); +UPDATE `gossip_menu_option` SET `GossipOptionID`=40614, `VerifiedBuild`=57689 WHERE (`MenuID`=14971 AND `OptionID`=0); + +-- Creature spawns +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+75; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES +(@CGUID+0, 40789, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 0, -7880.4501953125, 1331.9300537109375, 340.028350830078125, 1.56033480167388916, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Generic Controller Bunny (CSA) (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 (Auras: 132223 - FX_AllianceGunship_Idle_Main_Loop) +(@CGUID+1, 40789, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 0, -7915.58984375, 1261.06005859375, 316.726348876953125, 2.032872200012207031, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Generic Controller Bunny (CSA) (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 (Auras: 132221 - FX_Uni_Zeppelin_Propeller_Blades_Loop) +(@CGUID+2, 40789, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 0, -7917.60986328125, 1389.77001953125, 302.996337890625, 2.980149745941162109, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Generic Controller Bunny (CSA) (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 (Auras: 132221 - FX_Uni_Zeppelin_Propeller_Blades_Loop) +(@CGUID+3, 40789, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 0, -7843.47998046875, 1265.739990234375, 308.835357666015625, 5.26434946060180664, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Generic Controller Bunny (CSA) (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 (Auras: 132221 - FX_Uni_Zeppelin_Propeller_Blades_Loop) +(@CGUID+4, 40789, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 0, -7842.080078125, 1389.6600341796875, 301.831329345703125, 2.753256797790527343, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Generic Controller Bunny (CSA) (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 (Auras: 132221 - FX_Uni_Zeppelin_Propeller_Blades_Loop) +(@CGUID+5, 55370, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 0, -7881.20849609375, 1328.6510009765625, 350.846588134765625, 0, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- General Purpose Bunny ZTO (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 (Auras: 130860 - Skyfire Defense Patrols) +(@CGUID+6, 55819, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 0, -7886.45166015625, 1278.298583984375, 358.559478759765625, 5.19431304931640625, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Sully "The Pickle" McLeary (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+7, 55823, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 0, -7884.51220703125, 1266.4322509765625, 358.568023681640625, 5.011447429656982421, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Mishka (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+8, 55825, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 0, -7883.6787109375, 1263.5260009765625, 358.571624755859375, 2.055117130279541015, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Amber Kearnen (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 (Auras: 131904 - Kearnen's Sniper Rifle) +(@CGUID+9, 55830, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 0, -7885.5712890625, 1276.6336669921875, 358.560791015625, 2.30356454849243164, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Nimm Codejack (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+10, 55832, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7882.61962890625, 1265.5086669921875, 358.571319580078125, 3.663313865661621093, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Nodd Codejack (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+11, 64858, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 0, -7877.5869140625, 1329.173583984375, 338.940948486328125, 2.97155928611755371, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Airman Hicks (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+12, 64859, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7880.561, 1309.4548, 338.86606, 4.713801383972167968, 120, 0, 0, 2, NULL, NULL, NULL, NULL, 57689), -- Sky Captain Callanan (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+13, 64860, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 0, -7871.9775390625, 1286.13720703125, 341.750457763671875, 2.807392597198486328, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Captain Kerwin (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+14, 64861, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 0, -7887.7099609375, 1286.3350830078125, 341.642608642578125, 1.766041874885559082, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Captain Day (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+15, 64862, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 0, -7883.44970703125, 1340.9635009765625, 338.9415283203125, 0.084910094738006591, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Airman Ellis (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+16, 64863, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 0, -7880.923828125, 1280.2430419921875, 358.5596923828125, 4.738608360290527343, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Sky Mage Harlan (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+17, 64864, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 0, -7877.4443359375, 1341.3697509765625, 338.93927001953125, 3.084580659866333007, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Airman Clifton (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+18, 64865, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 0, -7884.00537109375, 1329.3385009765625, 338.943206787109375, 0.207194462418556213, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Airman Rogers (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+19, 64866, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 0, -7878.921875, 1280.26220703125, 358.559600830078125, 4.733302116394042968, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Corporal Rasmussen (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+20, 66292, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 0, -7879.80029296875, 1279.515625, 358.560516357421875, 4.728822231292724609, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Sky Admiral Rogers (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+21, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7885.1943359375, 1347.032958984375, 338.946533203125, 0.018319351598620414, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+22, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7883.44970703125, 1317.5208740234375, 338.952301025390625, 0.018319351598620414, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+23, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7885.15087890625, 1319.5555419921875, 338.954254150390625, 0.018319351598620414, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+24, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7885.1337890625, 1315.392333984375, 338.95477294921875, 0.018319351598620414, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+25, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7883.43408203125, 1319.5538330078125, 338.9517822265625, 0.018319351598620414, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+26, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7925.9130859375, 1276.001708984375, 343.511077880859375, 0.126102268695831298, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+27, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7885.173828125, 1317.5225830078125, 338.954833984375, 0.018319351598620414, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+28, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7883.4150390625, 1315.388916015625, 338.9522705078125, 0.018319351598620414, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+29, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7875.63525390625, 1319.435791015625, 338.94091796875, 3.16120314598083496, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+30, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7887.3681640625, 1282.5538330078125, 358.55633544921875, 6.190460205078125, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+31, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7875.67041015625, 1346.9114990234375, 338.939697265625, 3.16120314598083496, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+32, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7875.6943359375, 1351.07470703125, 338.93975830078125, 3.16120314598083496, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+33, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7877.38525390625, 1346.9114990234375, 338.94091796875, 3.16120314598083496, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+34, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7877.21875, 1315.35595703125, 338.9473876953125, 3.16120314598083496, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+35, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7883.60791015625, 1351.111083984375, 338.944122314453125, 0.018319351598620414, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+36, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7885.32666015625, 1351.1146240234375, 338.94525146484375, 0.018319351598620414, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+37, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7883.47900390625, 1347.0225830078125, 338.9453125, 0.018319351598620414, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+38, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7877.35400390625, 1319.4410400390625, 338.943389892578125, 3.16120314598083496, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+39, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7877.29541015625, 1317.3802490234375, 338.945159912109375, 3.16120314598083496, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+40, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7872.69091796875, 1282.875, 358.55609130859375, 3.080678701400756835, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+41, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7875.501953125, 1315.3524169921875, 338.944915771484375, 3.16120314598083496, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+42, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7877.376953125, 1348.9444580078125, 338.94097900390625, 3.16120314598083496, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+43, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7872.0625, 1261.82470703125, 358.56201171875, 3.193963050842285156, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+44, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7883.53125, 1349.0885009765625, 338.94482421875, 0.018319351598620414, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+45, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7875.6474609375, 1348.9427490234375, 338.939727783203125, 3.16120314598083496, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+46, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7877.41162109375, 1351.078125, 338.941009521484375, 3.16120314598083496, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+47, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7888.03466796875, 1261.607666015625, 358.561767578125, 0.088901109993457794, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+48, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7875.578125, 1317.3802490234375, 338.94268798828125, 3.16120314598083496, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+49, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7885.251953125, 1349.09033203125, 338.946044921875, 0.018319351598620414, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+50, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7835.6005859375, 1276.99658203125, 343.510009765625, 3.143929243087768554, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+51, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7837.2534, 1276.9236, 343.41885, 6.248278617858886718, 120, 0, 0, 2, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+52, 66300, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7838.8926, 1273.7327, 343.42136, 0.035018134862184524, 120, 0, 0, 2, NULL, NULL, NULL, NULL, 57689), -- Skyfire Marine (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+53, 66460, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7885.5537109375, 1330.1285400390625, 338.9423828125, 0.188897475600242614, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Gyrocopter Pilot (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+54, 66460, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7885.26220703125, 1342.1822509765625, 338.943603515625, 0.071608141064643859, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Gyrocopter Pilot (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+55, 66460, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7885.13720703125, 1327.7274169921875, 338.945404052734375, 0.113753728568553924, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Gyrocopter Pilot (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+56, 66460, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7885.12158203125, 1339.751708984375, 338.94195556640625, 6.279649734497070312, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Gyrocopter Pilot (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+57, 66460, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7875.78125, 1328.0816650390625, 338.941009521484375, 2.986098051071166992, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Gyrocopter Pilot (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+58, 66460, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7875.72900390625, 1330.123291015625, 338.940185546875, 3.065017223358154296, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Gyrocopter Pilot (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+59, 66460, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7875.71875, 1340.4132080078125, 338.938934326171875, 3.058433771133422851, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Gyrocopter Pilot (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+60, 66460, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7875.81591796875, 1342.451416015625, 338.938934326171875, 3.137352943420410156, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Gyrocopter Pilot (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+61, 66473, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 0, -7894.1494140625, 1317.888916015625, 338.965118408203125, 2.206909894943237304, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Gyrocopter (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+62, 66473, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 0, -7894.15478515625, 1327.890625, 338.965118408203125, 2.206909894943237304, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Gyrocopter (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+63, 66473, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 0, -7893.859375, 1306.3072509765625, 338.965118408203125, 2.206909894943237304, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Gyrocopter (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+64, 66473, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 0, -7894.0380859375, 1341.6475830078125, 338.965118408203125, 2.206909894943237304, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Gyrocopter (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+65, 66473, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 0, -7866.55908203125, 1306.532958984375, 338.965118408203125, 0.826461434364318847, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Gyrocopter (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+66, 66473, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 0, -7867.07275390625, 1328.107666015625, 338.965118408203125, 0.826461434364318847, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Gyrocopter (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+67, 66473, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 0, -7867.330078125, 1341.9444580078125, 338.965118408203125, 0.826461434364318847, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Gyrocopter (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+68, 66473, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 0, -7866.8037109375, 1318.0885009765625, 338.965118408203125, 0.826461434364318847, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Gyrocopter (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+69, 66480, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7892.84716796875, 1356.23095703125, 338.885986328125, 3.191249370574951171, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Engineer (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+70, 66480, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7893.82275390625, 1352.9947509765625, 338.914794921875, 1.610516309738159179, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Engineer (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+71, 66480, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 2, -7873.548828125, 1287.454833984375, 341.7664794921875, 1.134044289588928222, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Engineer (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+72, 66480, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7864.653, 1307.9688, 339.03876, 4.010818, 120, 0, 0, 2, NULL, NULL, NULL, NULL, 57689), -- Skyfire Engineer (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+73, 66480, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7887.296875, 1373.201416015625, 341.854644775390625, 3.001966238021850585, 120, 0, 0, 2, NULL, NULL, NULL, NULL, 57689), -- Skyfire Engineer (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 (possible waypoints or random movement) +(@CGUID+74, 66480, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7872.8037109375, 1304.171875, 339.23492431640625, 4.737676620483398437, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Skyfire Engineer (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@CGUID+75, 66480, 0, 1519, 6555, '0', 1686, 0, 1066, 0, 1, -7872.3662109375, 1303.05908203125, 339.27850341796875, 2.036499977111816406, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689); -- Skyfire Engineer (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 + +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+75; +INSERT INTO `creature_addon` (`guid`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '132223'), -- Generic Controller Bunny (CSA) - 132223 - FX_AllianceGunship_Idle_Main_Loop +(@CGUID+1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '132221'), -- Generic Controller Bunny (CSA) - 132221 - FX_Uni_Zeppelin_Propeller_Blades_Loop +(@CGUID+2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '132221'), -- Generic Controller Bunny (CSA) - 132221 - FX_Uni_Zeppelin_Propeller_Blades_Loop +(@CGUID+3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '132221'), -- Generic Controller Bunny (CSA) - 132221 - FX_Uni_Zeppelin_Propeller_Blades_Loop +(@CGUID+4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '132221'), -- Generic Controller Bunny (CSA) - 132221 - FX_Uni_Zeppelin_Propeller_Blades_Loop +(@CGUID+10, 0, 0, 0, 0, 0, 1, 0, 483, 0, 0, 0, 0, ''), -- Nodd Codejack +(@CGUID+13, 0, 0, 0, 0, 0, 1, 1, 483, 0, 0, 0, 0, ''), -- Captain Kerwin +(@CGUID+61, 0, 0, 0, 3, 0, 1, 0, 416, 0, 0, 0, 0, ''), -- Skyfire Gyrocopter +(@CGUID+62, 0, 0, 0, 3, 0, 1, 0, 416, 0, 0, 0, 0, ''), -- Skyfire Gyrocopter +(@CGUID+63, 0, 0, 0, 3, 0, 1, 0, 416, 0, 0, 0, 0, ''), -- Skyfire Gyrocopter +(@CGUID+64, 0, 0, 0, 3, 0, 1, 0, 416, 0, 0, 0, 0, ''), -- Skyfire Gyrocopter +(@CGUID+65, 0, 0, 0, 3, 0, 1, 0, 416, 0, 0, 0, 0, ''), -- Skyfire Gyrocopter +(@CGUID+66, 0, 0, 0, 3, 0, 1, 0, 416, 0, 0, 0, 0, ''), -- Skyfire Gyrocopter +(@CGUID+67, 0, 0, 0, 3, 0, 1, 0, 416, 0, 0, 0, 0, ''), -- Skyfire Gyrocopter +(@CGUID+68, 0, 0, 0, 3, 0, 1, 0, 416, 0, 0, 0, 0, ''), -- Skyfire Gyrocopter +(@CGUID+69, 0, 0, 0, 0, 0, 1, 0, 69, 0, 0, 0, 0, ''), -- Skyfire Engineer +(@CGUID+70, 0, 0, 0, 0, 0, 1, 0, 69, 0, 0, 0, 0, ''), -- Skyfire Engineer +(@CGUID+71, 0, 0, 0, 0, 0, 1, 0, 173, 0, 0, 0, 0, ''); -- Skyfire Engineer + +-- Paths +SET @MOVERGUID := @CGUID+12; +SET @ENTRY := 64859; +SET @PATHOFFSET := 0; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`=@PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0, NULL, 'Sky Captain Callanan - Cosmetic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`=@PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, -7880.6284, 1356.9219, 338.84875, NULL, 10), +(@PATH, 1, -7880.561, 1309.4548, 338.86606, NULL, 10); + +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@MOVERGUID, @PATH, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, ''); + +SET @MOVERGUID := @CGUID+51; +SET @ENTRY := 66300; +SET @PATHOFFSET := 0; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`=@PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, NULL, 'Skyfire Marine - Cosmetic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`=@PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, -7846.0176, 1279.7692, 343.4193, NULL, 0), +(@PATH, 1, -7852.905, 1282.2535, 343.42096, NULL, 0), +(@PATH, 2, -7852.759, 1284.9567, 343.4159, NULL, 0), +(@PATH, 3, -7852.8438, 1287.606, 342.60815, NULL, 0), +(@PATH, 4, -7853.229, 1290.3317, 341.7832, NULL, 0), +(@PATH, 5, -7855.224, 1295.9688, 340.38583, NULL, 0), +(@PATH, 6, -7858.026, 1298.4705, 338.87704, NULL, 0), +(@PATH, 7, -7861.9307, 1299.8473, 338.83398, NULL, 0), +(@PATH, 8, -7872.6235, 1300.3351, 338.8302, NULL, 0), +(@PATH, 9, -7879.4116, 1300.3055, 338.79767, NULL, 0), +(@PATH, 10, -7889.403, 1300.1163, 338.837, NULL, 0), +(@PATH, 11, -7898.6025, 1299.717, 338.80988, NULL, 0), +(@PATH, 12, -7902.866, 1298.3177, 338.8956, NULL, 0), +(@PATH, 13, -7904.924, 1296.033, 340.08847, NULL, 0), +(@PATH, 14, -7906.0415, 1293.0416, 341.05154, NULL, 0), +(@PATH, 15, -7906.7725, 1290.1024, 341.70874, NULL, 0), +(@PATH, 16, -7907.1665, 1287.3142, 342.55933, NULL, 0), +(@PATH, 17, -7907.1978, 1285.3698, 343.17236, NULL, 0), +(@PATH, 18, -7908.307, 1281.3368, 343.4207, NULL, 0), +(@PATH, 19, -7913.6025, 1278.8577, 343.41888, NULL, 0), +(@PATH, 20, -7924.3315, 1276.0312, 343.41895, NULL, 100), +(@PATH, 21, -7924.3315, 1276.0312, 343.41895, 3.148760318756103515, 7500), +(@PATH, 22, -7918.184, 1278.2014, 343.41904, NULL, 0), +(@PATH, 23, -7909.8457, 1279.118, 343.4194, NULL, 0), +(@PATH, 24, -7907.6895, 1281.033, 343.42065, NULL, 0), +(@PATH, 25, -7907.6753, 1284.4688, 343.41592, NULL, 0), +(@PATH, 26, -7907.7344, 1287.3038, 342.54755, NULL, 0), +(@PATH, 27, -7907.151, 1290.3004, 341.68427, NULL, 0), +(@PATH, 28, -7906.318, 1292.9723, 341.07904, NULL, 0), +(@PATH, 29, -7904.79, 1295.3906, 340.25168, NULL, 0), +(@PATH, 30, -7902.8335, 1297.8229, 339.01328, NULL, 0), +(@PATH, 31, -7898.4844, 1299.481, 338.8192, NULL, 0), +(@PATH, 32, -7893.6494, 1300.0278, 338.8591, NULL, 0), +(@PATH, 33, -7881.1426, 1300.3942, 338.8939, NULL, 0), +(@PATH, 34, -7873.0923, 1300.5278, 338.92905, NULL, 0), +(@PATH, 35, -7864.866, 1300.5243, 338.90698, NULL, 0), +(@PATH, 36, -7861.866, 1299.9305, 338.8307, NULL, 0), +(@PATH, 37, -7857.5176, 1298.8733, 338.9271, NULL, 0), +(@PATH, 38, -7855.9478, 1296.4688, 340.00262, NULL, 0), +(@PATH, 39, -7854.58, 1293.7673, 340.98987, NULL, 0), +(@PATH, 40, -7853.491, 1291.1024, 341.6073, NULL, 0), +(@PATH, 41, -7852.777, 1288.2855, 342.39145, NULL, 0), +(@PATH, 42, -7852.7344, 1285.5035, 343.2705, NULL, 0), +(@PATH, 43, -7852.3403, 1281.3802, 343.42047, NULL, 0), +(@PATH, 44, -7849.528, 1279.8594, 343.41928, NULL, 0), +(@PATH, 45, -7837.2534, 1276.9236, 343.41885, NULL, 100), +(@PATH, 46, -7837.2534, 1276.9236, 343.41885, 6.248278617858886718, 8500); + +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@MOVERGUID, @PATH, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''); + +SET @MOVERGUID := @CGUID+52; +SET @ENTRY := 66300; +SET @PATHOFFSET := 1; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`=@PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0, NULL, 'Skyfire Marine - Cosmetic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`=@PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, -7846.4097, 1273.7361, 343.6446, NULL, 0), +(@PATH, 1, -7863.9966, 1272.8942, 357.75677, NULL, 0), +(@PATH, 2, -7878.991, 1273.0365, 358.4794, NULL, 0), +(@PATH, 3, -7894.1475, 1273.1771, 358.09357, NULL, 0), +(@PATH, 4, -7895.9844, 1272.7726, 357.92953, NULL, 0), +(@PATH, 5, -7913.762, 1272.842, 343.65237, NULL, 0), +(@PATH, 6, -7921.799, 1273.4219, 343.421, NULL, 7500), +(@PATH, 7, -7913.7935, 1272.9462, 343.631, NULL, 0), +(@PATH, 8, -7896.021, 1272.9115, 357.89813, NULL, 0), +(@PATH, 9, -7877.3438, 1272.9601, 358.47733, NULL, 0), +(@PATH, 10, -7864.4897, 1273.2709, 357.9572, NULL, 0), +(@PATH, 11, -7846.616, 1273.4618, 343.78818, NULL, 0), +(@PATH, 12, -7838.8926, 1273.7327, 343.42136, NULL, 3800); + +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@MOVERGUID, @PATH, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''); + +SET @MOVERGUID := @CGUID+72; +SET @ENTRY := 66480; +SET @PATHOFFSET := 0; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`=@PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, NULL, 'Skyfire Engineer - Cosmetic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`=@PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, -7862.738, 1312.1034, 338.84222, NULL, 0), +(@PATH, 1, -7863.125, 1331.7899, 338.7575, NULL, 0), +(@PATH, 2, -7863.1196, 1334.849, 338.82037, NULL, 0), +(@PATH, 3, -7863.96, 1347.4584, 338.97427, NULL, 0), +(@PATH, 4, -7864.8022, 1350.5955, 338.91898, NULL, 0), +(@PATH, 5, -7868.318, 1359.0747, 339.27142, NULL, 0), +(@PATH, 6, -7871.818, 1366.0122, 341.89938, NULL, 0), +(@PATH, 7, -7876.1875, 1374.4879, 341.87177, NULL, 0), +(@PATH, 8, -7875.0176, 1378.4791, 341.89627, NULL, 7200), +(@PATH, 9, -7871.8516, 1366.3435, 341.77032, NULL, 0), +(@PATH, 10, -7868.2676, 1358.9098, 339.20435, NULL, 0), +(@PATH, 11, -7865.252, 1351.901, 338.84836, NULL, 0), +(@PATH, 12, -7864.1465, 1347.3024, 338.84946, NULL, 0), +(@PATH, 13, -7863.613, 1342.0243, 338.79236, NULL, 0), +(@PATH, 14, -7863.1284, 1334.8524, 338.81598, NULL, 0), +(@PATH, 15, -7862.993, 1331.7899, 338.75705, NULL, 0), +(@PATH, 16, -7862.799, 1317.0087, 338.80948, NULL, 0), +(@PATH, 17, -7862.6953, 1312.1041, 338.84222, NULL, 0), +(@PATH, 18, -7862.8506, 1310.1046, 338.84662, NULL, 0), +(@PATH, 19, -7864.653, 1307.9688, 339.03876, NULL, 7200); + +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@MOVERGUID, @PATH, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''); + +SET @MOVERGUID := @CGUID+73; +SET @ENTRY := 66480; +SET @PATHOFFSET := 1; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`=@PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, NULL, 'Skyfire Engineer - Cosmetic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`=@PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, -7891.354, 1365.4479, 341.8876, NULL, 0), +(@PATH, 1, -7894.981, 1359.0243, 339.26117, NULL, 0), +(@PATH, 2, -7896.5054, 1354.5625, 338.83893, NULL, 0), +(@PATH, 3, -7897.2935, 1350.3959, 338.86145, NULL, 0), +(@PATH, 4, -7897.6025, 1347.0625, 338.88513, NULL, 0), +(@PATH, 5, -7898.2173, 1334.7848, 338.75882, NULL, 0), +(@PATH, 6, -7898.0923, 1331.565, 338.7538, NULL, 0), +(@PATH, 7, -7898.1997, 1311.8455, 338.83524, NULL, 0), +(@PATH, 8, -7898.1284, 1309.794, 338.86075, NULL, 0), +(@PATH, 9, -7897.7065, 1307.3125, 338.8441, NULL, 0), +(@PATH, 10, -7896.3027, 1306.5127, 339.10785, NULL, 7200), +(@PATH, 11, -7898.2407, 1311.794, 338.83527, NULL, 0), +(@PATH, 12, -7898.2344, 1331.5641, 338.75293, NULL, 0), +(@PATH, 13, -7897.993, 1334.5938, 338.76266, NULL, 0), +(@PATH, 14, -7897.354, 1347.0192, 338.8489, NULL, 0), +(@PATH, 15, -7897.094, 1350.3959, 338.86142, NULL, 0), +(@PATH, 16, -7896.434, 1354.9618, 338.8368, NULL, 0), +(@PATH, 17, -7895.1978, 1358.9185, 339.23346, NULL, 0), +(@PATH, 18, -7890.538, 1365.3993, 341.89276, NULL, 0), +(@PATH, 19, -7888.1284, 1368.8524, 341.78775, NULL, 0), +(@PATH, 20, -7886.337, 1370.8108, 341.7793, NULL, 0), +(@PATH, 21, -7887.297, 1373.2014, 341.85464, NULL, 250), +(@PATH, 22, -7887.297, 1373.2014, 341.85464, 3.001966238021850585, 7200); + +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@MOVERGUID, @PATH, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''); + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+5; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 215648, 0, 1519, 6555, '0', 1686, 0, 1066, -7893.98095703125, 1355.5555419921875, 338.81695556640625, 0, 0, 0, 0, 1, 120, 255, 1, 57689), -- Medical Supply Crate (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@OGUID+1, 215648, 0, 1519, 6555, '0', 1686, 0, 1066, -7895.234375, 1354.65283203125, 338.831878662109375, 0, 0, 0, 0, 1, 120, 255, 1, 57689), -- Medical Supply Crate (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@OGUID+2, 215648, 0, 1519, 6555, '0', 1686, 0, 1066, -7892.52783203125, 1354.90625, 338.81634521484375, 0, 0, 0, 0, 1, 120, 255, 1, 57689), -- Medical Supply Crate (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@OGUID+3, 215648, 0, 1519, 6555, '0', 1686, 0, 1066, -7894.48974609375, 1354.6822509765625, 339.892852783203125, 0, 0, 0, 0, 1, 120, 255, 1, 57689), -- Medical Supply Crate (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@OGUID+4, 215648, 0, 1519, 6555, '0', 1686, 0, 1066, -7892.501953125, 1353.515625, 338.827392578125, 0, 0, 0, 0, 1, 120, 255, 1, 57689), -- Medical Supply Crate (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 +(@OGUID+5, 215648, 0, 1519, 6555, '0', 1686, 0, 1066, -7893.88525390625, 1354.171875, 338.818756103515625, 0, 0, 0, 0, 1, 120, 255, 1, 57689); -- Medical Supply Crate (Area: Northern Elwynn Mountains - Difficulty: 0) CreateObject1 + +-- Scenes +DELETE FROM `scene_template` WHERE `SceneId`=90; +INSERT INTO `scene_template` (`SceneId`, `Flags`, `ScriptPackageID`, `Encrypted`) VALUES +(90, 0, 239, 0); + +-- Phases +DELETE FROM `phase_area` WHERE `AreaId`=6555 AND `PhaseId`=1686; +INSERT INTO `phase_area` (`AreaId`, `PhaseId`, `Comment`) VALUES +(6555, 1686, 'Northern Elwynn Mountains - Stormwind - 5.0 Phased Terrain Master'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=26 AND `SourceGroup`=1686; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(26,1686,0,0,0,47,0,29548,8,0,'',0,0,0,'','Apply phase 1686 if quest 29548 is taken'); + +UPDATE `conditions` SET `ConditionValue2`=66, `Comment`='Apply condition reference if quest 29548 is complete | rewarded' WHERE `SourceTypeOrReferenceId`=-40003 AND `ElseGroup`=1; + +-- Terrain swap +DELETE FROM `terrain_swap_defaults` WHERE `MapId`=0 AND `TerrainSwapMap`=1066; +INSERT INTO `terrain_swap_defaults` (`MapId`, `TerrainSwapMap`, `Comment`) VALUES +(0, 1066, 'Eastern Kingdoms - Stormwind Gunship Pandaria Start Area'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=25 AND `SourceEntry`=1066; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(25,0,1066,0,0,47,0,29548,8,0,'',0,0,0,'','Apply terrain swap 1074 if quest 29548 is taken'); + +-- Smart scripts +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (55370,55819,55823,55830,55832,64861,66292,66300,66480); + +UPDATE `creature` SET `StringId`='StormwindCityGunship' WHERE `guid`=@CGUID+5 AND `id`=55370; + +DELETE FROM `smart_scripts` WHERE `entryorguid`=55370 AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `action_param_string`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_param_string`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(55370,0,0,0,'',11,0,100,0,0,0,0,0,0,'',11,130860,0,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'General Purpose Bunny ZTO - On respawn - Cast ''Skyfire Defense Patrols'''); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry`=55370; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(22,1,55370,0,0,58,1,0,0,0,'StormwindCityGunship',0,0,0,'','Trigger smart event if object has StringId ''StormwindCityGunship'''); + +DELETE FROM `smart_scripts` WHERE `entryorguid`=55819 AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `action_param_string`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_param_string`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(55819,0,0,0,'',1,0,100,0,0,1200,1200,1200,0,'',10,6,273,274,396,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Sully "The Pickle" McLeary - Out of combat (1.2s) - Play random emote'); + +DELETE FROM `smart_scripts` WHERE `entryorguid`=55823 AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `action_param_string`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_param_string`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(55823,0,0,0,'',1,0,100,0,0,1200,1200,1200,0,'',10,6,273,274,396,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Mishka - Out of combat (1.2s) - Play random emote'); + +DELETE FROM `smart_scripts` WHERE `entryorguid`=55830 AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `action_param_string`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_param_string`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(55830,0,0,0,'',1,0,100,0,0,1200,1200,1200,0,'',10,6,273,274,396,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Nimm Codejack - Out of combat (1.2s) - Play random emote'); + +DELETE FROM `smart_scripts` WHERE `entryorguid`=55832 AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `action_param_string`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_param_string`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(55832,0,0,0,'',1,0,100,0,0,60000,60000,60000,0,'',1,0,0,1,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Nodd Codejack - Out of combat (60s) - Talk'); + +DELETE FROM `creature_text` WHERE `CreatureID`=55832 AND `GroupID`=0; +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(55832, 0, 0, '13 gyromantic destabilizers? Check. 10 gnumatic flangegrips? Check. Now where did I put my favorite wrench?', 12, 0, 100, 0, 0, 0, 67697, 0, 'Nodd Codejack'), +(55832, 0, 1, 'Hmm. Only 2 tons of explosives for this mission? Seems a bit light to me. This seems like the kind of mission we are going to need way more explosives for. Like... goblin pyromaniac explosives.', 12, 0, 100, 0, 0, 0, 67698, 0, 'Nodd Codejack'), +(55832, 0, 2, 'Only thirty gyrocopters? We are going to need way more than that before this is over.', 12, 0, 100, 0, 0, 0, 67699, 0, 'Nodd Codejack'); + +UPDATE `creature` SET `StringId`='StormwindCityGunship' WHERE `guid`=@CGUID+14 AND `id`=64861; + +SET @ENTRY := 64861; +SET @PATHOFFSET := 0; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +SET @ACTIONLIST := 64861 * 100; +DELETE FROM `smart_scripts` WHERE `entryorguid`=64861 AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid` BETWEEN @ACTIONLIST+0 AND @ACTIONLIST+2; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `action_param_string`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_param_string`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(64861,0,0,0,'',11,0,100,0,0,0,0,0,0,'',22,1,0,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Captain Day - On respawn - Set event phase 1'), +(64861,0,1,0,'',1,0x1,100,0,0,0,500,500,0,'',88,@ACTIONLIST+0,@ACTIONLIST+2,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Captain Day - Out of combat (500ms) - Call random timed actionlist (Event phase 1)'), +(64861,0,2,0,'',1,0x4,100,0,0,0,1200,1200,0,'',5,432,0,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Captain Day - Out of combat (1.2s) - Play emote (Event phase 3)'), +(@ACTIONLIST+0,9,0,0,'',0,0,100,0,0,0,0,0,0,'',22,2,0,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Actionlist - Captain Day - Set event phase 2'), +(@ACTIONLIST+0,9,1,0,'',0,0,100,0,0,0,0,0,0,'',17,0,0,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Actionlist - Captain Day - Remove emote state'), +(@ACTIONLIST+0,9,2,0,'',0,0,100,0x20,0,0,0,0,0,'',53,0,@PATH+0,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Actionlist - Captain Day - Start scripted path 1'), +(@ACTIONLIST+0,9,3,0,'',0,0,100,0,5600,5600,0,0,0,'',5,5,0,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Actionlist - Captain Day - Play emote'), +(@ACTIONLIST+0,9,4,0,'',0,0,100,0x20,2400,2400,0,0,0,'',53,0,@PATH+1,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Actionlist - Captain Day - Start scripted path 2'), +(@ACTIONLIST+0,9,5,0,'',0,0,100,0,6000,6000,0,0,0,'',22,1,0,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Actionlist - Captain Day - Set event phase 1'), +(@ACTIONLIST+1,9,0,0,'',0,0,100,0,0,0,0,0,0,'',22,2,0,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Actionlist - Captain Day - Set event phase 2'), +(@ACTIONLIST+1,9,1,0,'',0,0,100,0,0,0,0,0,0,'',17,483,0,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Actionlist - Captain Day - Set emote state'), +(@ACTIONLIST+1,9,2,0,'',0,0,100,0,60000,60000,0,0,0,'',22,1,0,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Actionlist - Captain Day - Set event phase 1'), +(@ACTIONLIST+2,9,0,0,'',0,0,100,0,0,0,0,0,0,'',22,3,0,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Actionlist - Captain Day - Set event phase 3'), +(@ACTIONLIST+2,9,1,0,'',0,0,100,0,0,0,0,0,0,'',17,0,0,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Actionlist - Captain Day - Remove emote state'), +(@ACTIONLIST+2,9,2,0,'',0,0,100,0,60000,60000,0,0,0,'',22,1,0,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Actionlist - Captain Day - Set event phase 1'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry`=64861; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(22,1,64861,0,0,58,1,0,0,0,'StormwindCityGunship',0,0,0,'','Trigger smart event if object has StringId ''StormwindCityGunship'''); + +DELETE FROM `waypoint_path` WHERE `PathId` IN (@PATH+0, @PATH+1); +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH+0, 0, 0x2, NULL, 'Sky Captain Callanan - Scripted Path'), +(@PATH+1, 0, 0x2, NULL, 'Sky Captain Callanan - Scripted Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId` IN (@PATH+0, @PATH+1); +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH+0, 0, -7886.0146, 1283.6763, 341.90405, NULL, 0), -- Splines +(@PATH+0, 1, -7884.5146, 1283.6763, 341.90405, NULL, 0), -- Splines +(@PATH+0, 2, -7884.0146, 1283.6763, 341.90405, NULL, 0), -- Splines +(@PATH+0, 3, -7881.5146, 1283.6763, 341.90405, NULL, 0), -- Splines +(@PATH+0, 4, -7880.2646, 1283.6763, 341.90405, NULL, 0), -- Splines +(@PATH+0, 5, -7879.0146, 1283.6763, 341.90405, NULL, 0), -- Splines +(@PATH+0, 6, -7877.3193, 1283.5173, 341.6655, NULL, 0), +(@PATH+0, 7, -7872.2085, 1284.2882, 341.66284, NULL, 0), +(@PATH+0, 9, -7871.1514, 1284.7635, 341.9276, NULL, 0), -- Splines +(@PATH+0, 10, -7871.6494, 1285.1077, 341.65417, NULL, 0), +(@PATH+1, 0, -7875.0547, 1284.4609, 341.91223, NULL, 0), -- Splines +(@PATH+1, 1, -7876.5547, 1284.2109, 341.91223, NULL, 0), -- Splines +(@PATH+1, 2, -7878.8047, 1284.2109, 341.91223, NULL, 0), -- Splines +(@PATH+1, 3, -7880.0547, 1283.9609, 341.91223, NULL, 0), -- Splines +(@PATH+1, 4, -7881.0547, 1283.7109, 341.91223, NULL, 0), -- Splines +(@PATH+1, 5, -7882.96, 1283.3142, 341.67032, NULL, 0), +(@PATH+1, 6, -7887.155, 1283.5278, 341.6458, NULL, 0), +(@PATH+1, 7, -7887.71, 1286.3351, 341.6426, NULL, 0); + +UPDATE `creature` SET `StringId`='StormwindCityGunship' WHERE `guid`=@CGUID+20 AND `id`=66292; + +DELETE FROM `smart_scripts` WHERE `entryorguid`=66292 AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `action_param_string`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_param_string`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(66292,0,0,0,'',11,0,100,0,0,0,0,0,0,'',11,132606,0,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Sky Admiral Rogers - On respawn - Cast ''Summon Collision Object'''); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry`=66292; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(22,1,66292,0,0,58,1,0,0,0,'StormwindCityGunship',0,0,0,'','Trigger smart event if object has StringId ''StormwindCityGunship'''); + +SET @ENTRY := 66300; +SET @PATHOFFSET := 0; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +SET @ACTIONLIST := 66300 * 100; +DELETE FROM `smart_scripts` WHERE `entryorguid`=66300 AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid` BETWEEN @ACTIONLIST+0 AND @ACTIONLIST+1; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `action_param_string`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_param_string`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(66300,0,0,0,'',40,0,100,0,21,@PATH+0,0,0,0,'',80,@ACTIONLIST+0,2,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Skyfire Marine - On cosmetic path 1 node 21 reached - Call timed actionlist 1'), +(66300,0,1,0,'',40,0,100,0,46,@PATH+0,0,0,0,'',80,@ACTIONLIST+1,2,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Skyfire Marine - On cosmetic path 1 node 46 reached - Call timed actionlist 2'), +(@ACTIONLIST+0,9,0,0,'',0,0,100,0,400,400,0,0,0,'',17,378,0,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Actionlist - Skyfire Marine - Set emote state'), +(@ACTIONLIST+0,9,1,0,'',0,0,100,0,7100,7100,0,0,0,'',17,0,0,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Actionlist - Skyfire Marine - Remove emote state'), +(@ACTIONLIST+1,9,0,0,'',0,0,100,0,0,0,0,0,0,'',5,66,0,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Actionlist - Skyfire Marine - Play emote'), +(@ACTIONLIST+1,9,1,0,'',0,0,100,0,3600,3600,0,0,0,'',17,378,0,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Actionlist - Skyfire Marine - Set emote state'), +(@ACTIONLIST+1,9,2,0,'',0,0,100,0,4900,4900,0,0,0,'',17,0,0,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Actionlist - Skyfire Marine - Remove emote state'); + +SET @ENTRY := 66480; +SET @PATHOFFSET := 0; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +SET @ACTIONLIST := 66480 * 100; +DELETE FROM `smart_scripts` WHERE `entryorguid`=66480 AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid`=@ACTIONLIST+0; +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `Difficulties`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `action_param7`, `action_param_string`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_param_string`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(66480,0,0,0,'',40,0,100,0,8,@PATH+0,0,0,0,'',80,@ACTIONLIST+0,2,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Skyfire Engineer - On cosmetic path 1 node 8 reached - Call timed actionlist'), +(66480,0,1,0,'',40,0,100,0,19,@PATH+0,0,0,0,'',80,@ACTIONLIST+0,2,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Skyfire Engineer - On cosmetic path 1 node 19 reached - Call timed actionlist'), +(66480,0,2,0,'',40,0,100,0,10,@PATH+1,0,0,0,'',80,@ACTIONLIST+0,2,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Skyfire Engineer - On cosmetic path 2 node 10 reached - Call timed actionlist'), +(66480,0,3,0,'',40,0,100,0,22,@PATH+1,0,0,0,'',80,@ACTIONLIST+0,2,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Skyfire Engineer - On cosmetic path 2 node 22 reached - Call timed actionlist'), +(66480,0,4,0,'',1,0,100,0,0,5000,3600,8600,0,'',10,1,6,273,274,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Skyfire Engineer - Out of combat (3.6-8.6s) - Play random emote'), +(@ACTIONLIST+0,9,0,0,'',0,0,100,0,0,0,0,0,0,'',5,539,0,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Actionlist - Skyfire Engineer - Play emote'), +(@ACTIONLIST+0,9,1,0,'',0,0,100,0,1200,1200,0,0,0,'',5,539,0,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Actionlist - Skyfire Engineer - Play emote'), +(@ACTIONLIST+0,9,2,0,'',0,0,100,0,1200,1200,0,0,0,'',5,539,0,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Actionlist - Skyfire Engineer - Play emote'), +(@ACTIONLIST+0,9,3,0,'',0,0,100,0,1200,1200,0,0,0,'',5,539,0,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Actionlist - Skyfire Engineer - Play emote'), +(@ACTIONLIST+0,9,4,0,'',0,0,100,0,1200,1200,0,0,0,'',5,539,0,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Actionlist - Skyfire Engineer - Play emote'), +(@ACTIONLIST+0,9,5,0,'',0,0,100,0,1200,1200,0,0,0,'',5,539,0,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Actionlist - Skyfire Engineer - Play emote'), +(@ACTIONLIST+0,9,6,0,'',0,0,100,0,1200,1200,0,0,0,'',5,539,0,0,0,0,0,0,NULL,1,0,0,0,0,NULL,0,0,0,0,'Actionlist - Skyfire Engineer - Play emote'); + +UPDATE `creature` SET `StringId`='RandomEmote' WHERE `guid` IN (@CGUID+74, @CGUID+75) AND `id`=66480; + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry`=66480; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ConditionStringValue1`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(22,5,66480,0,0,58,1,0,0,0,'RandomEmote',0,0,0,'','Trigger smart event if object has StringId ''RandomEmote'''); |