diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2024_09_04_02_world.sql | 292 |
1 files changed, 292 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_09_04_02_world.sql b/sql/updates/world/master/2024_09_04_02_world.sql new file mode 100644 index 00000000000..73be912d938 --- /dev/null +++ b/sql/updates/world/master/2024_09_04_02_world.sql @@ -0,0 +1,292 @@ +SET @CGUID := 10001500; +SET @OGUID := 10000039; + +-- Creature +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+64; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `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, 214016, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 1, 1342.876708984375, -163.182296752929687, 1.976996541023254394, 0.042252648621797561, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Arathi Stalwart (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+1, 211137, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 1364.0555419921875, -172.861114501953125, 1.938190102577209472, 5.322542667388916015, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Path Helper (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 424283 - Passive, 424126 - Bot AI Follow Advert) +(@CGUID+2, 214016, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 1, 1348.0625, -185.819442749023437, 1.931861042976379394, 6.181402206420898437, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Arathi Stalwart (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+3, 211111, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 1367.3177490234375, -170.40625, 1.939347624778747558, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Path Helper (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@CGUID+4, 211149, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 1369.09033203125, -174.5, 1.976999521255493164, 5.322542667388916015, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Path Helper (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 424283 - Passive, 424126 - Bot AI Follow Advert) +(@CGUID+5, 211151, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 1370.93408203125, -165.25347900390625, 1.941140532493591308, 5.322542667388916015, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Path Helper (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 424283 - Passive, 424126 - Bot AI Follow Advert) +(@CGUID+6, 211150, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 1371.329833984375, -169.51910400390625, 2.12166762351989746, 5.322542667388916015, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Path Helper (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 424283 - Passive, 424126 - Bot AI Follow Advert) +(@CGUID+7, 214013, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 1398.251708984375, -195.548614501953125, 1.124060750007629394, 3.941495418548583984, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stalker (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@CGUID+8, 211152, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 1362.420166015625, -168.3125, 1.938783526420593261, 5.322542667388916015, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Path Helper (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 424283 - Passive, 424126 - Bot AI Follow Advert) +(@CGUID+9, 225601, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 1420.8507080078125, -185.486114501953125, 1.264777302742004394, 3.976806163787841796, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Mereldar Citizen (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+10, 225601, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 1408.87158203125, -215.907989501953125, 1.294626951217651367, 5.111096858978271484, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Mereldar Citizen (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+11, 214016, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 1, 1333.5052490234375, -158.20660400390625, 8.940931320190429687, 0.211637154221534729, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Arathi Stalwart (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+12, 225601, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 1425.126708984375, -199.913192749023437, 1.294623494148254394, 4.812382221221923828, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Mereldar Citizen (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+13, 214016, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 1, 1382.8697509765625, -225.454864501953125, 1.622406601905822753, 0.739005863666534423, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Arathi Stalwart (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+14, 214016, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 1, 1424.171875, -178.100692749023437, 1.524549722671508789, 3.91639256477355957, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Arathi Stalwart (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+15, 214016, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 1, 1426.529541015625, -145.725692749023437, 13.18272590637207031, 0.794157803058624267, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Arathi Stalwart (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+16, 214016, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 1, 1333.3333740234375, -155.30035400390625, 8.943330764770507812, 6.232818603515625, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Arathi Stalwart (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+17, 214013, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 1410.8367919921875, -217.064239501953125, 1.075066208839416503, 3.843272686004638671, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stalker (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@CGUID+18, 214016, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 1, 1385.90625, -228.543411254882812, 1.614818096160888671, 0.739005863666534423, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Arathi Stalwart (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+19, 214016, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 1, 1346.798583984375, -216.626739501953125, 11.29957771301269531, 0.739005863666534423, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Arathi Stalwart (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+20, 214016, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 1, 1433.0069580078125, -187.416671752929687, 1.539438962936401367, 3.91639256477355957, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Arathi Stalwart (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+21, 214016, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 1, 1379.6302490234375, -222.28472900390625, 1.632066249847412109, 0.739005863666534423, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Arathi Stalwart (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+22, 214016, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 1, 1419.7742919921875, -173.446182250976562, 1.693777203559875488, 3.91639256477355957, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Arathi Stalwart (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+23, 225601, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 1418.4478759765625, -187.182296752929687, 1.806810259819030761, 1.039066433906555175, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Mereldar Citizen (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+24, 225601, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 1418.8385009765625, -183.697921752929687, 1.264777302742004394, 5.177395820617675781, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Mereldar Citizen (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+25, 214016, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 1, 1428.8941650390625, -182.892364501953125, 1.524549722671508789, 3.91639256477355957, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Arathi Stalwart (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+26, 225601, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 1413.52783203125, -210.677078247070312, 1.294626951217651367, 4.489444732666015625, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Mereldar Citizen (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+27, 214016, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 1, 1345.0399169921875, -148.545135498046875, 1.976998329162597656, 5.885342121124267578, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Arathi Stalwart (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+28, 225601, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 1426.7257080078125, -201, 1.294626951217651367, 3.333158016204833984, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Mereldar Citizen (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+29, 225601, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 1412.361083984375, -210.809036254882812, 1.294626951217651367, 5.033165454864501953, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Mereldar Citizen (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+30, 225601, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 1416.5364990234375, -212.69097900390625, 1.488654255867004394, 5.049875736236572265, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Mereldar Citizen (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+31, 212142, 2671, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, -104.214332580566406, 1.879162311553955078, 22.47918319702148437, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stalker (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@CGUID+32, 212142, 2671, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 32.3770751953125, -29.0769252777099609, 17.49703598022460937, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stalker (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@CGUID+33, 212142, 2671, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, -23.7718887329101562, -38.5327987670898437, 63.66963577270507812, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stalker (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@CGUID+34, 212142, 2671, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, -12.1680889129638671, -33.34326171875, 17.50066757202148437, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stalker (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@CGUID+35, 211631, 2671, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 56.67366790771484375, 5.850090980529785156, 16.7742767333984375, 1.106902360916137695, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Hastily Stacked Supplies (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 424858 - Hastily Stacked Supplies, 424859 - Hastily Stacked Supplies) - !!! on transport - transport template not found !!! +(@CGUID+36, 214016, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 1, 1461.8038330078125, -181.204864501953125, 12.101104736328125, 0.873473167419433593, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Arathi Stalwart (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+37, 212142, 2671, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 48.02265167236328125, -24.0555362701416015, 17.43184471130371093, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stalker (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@CGUID+38, 212142, 2671, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 31.96039581298828125, 29.03696632385253906, 17.50253486633300781, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stalker (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@CGUID+39, 212142, 2671, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, -35.11444091796875, 29.05181312561035156, 20.55867767333984375, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stalker (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@CGUID+40, 215167, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 1600, 533.33331298828125, 89.35213470458984375, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stalker (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: ) +(@CGUID+41, 212142, 2671, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 8.966260910034179687, -32.7932586669921875, 17.5115509033203125, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stalker (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@CGUID+42, 212142, 2671, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 47.71186065673828125, 23.47422981262207031, 17.50594520568847656, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stalker (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@CGUID+43, 212142, 2671, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, -35.3961105346679687, -29.6803932189941406, 20.45052146911621093, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stalker (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@CGUID+44, 214016, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 1, 1400.373291015625, -242.798614501953125, 1.575559735298156738, 0.739005863666534423, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Arathi Stalwart (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+45, 211631, 2671, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 52.60895919799804687, -7.16176700592041015, 16.75, 4.206926822662353515, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Hastily Stacked Supplies (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 424858 - Hastily Stacked Supplies, 424859 - Hastily Stacked Supplies) - !!! on transport - transport template not found !!! +(@CGUID+46, 225601, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 1426.890625, -229.55035400390625, 1.294630289077758789, 5.049875736236572265, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Mereldar Citizen (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+47, 214016, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 1, 1396.703125, -239.135421752929687, 1.585051536560058593, 0.739005863666534423, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Arathi Stalwart (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+48, 225601, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 1424.2274169921875, -227.822921752929687, 1.294630289077758789, 4.370117664337158203, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Mereldar Citizen (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+49, 214016, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 1, 1453.0972900390625, -205.571182250976562, 2.047745704650878906, 3.91639256477355957, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Arathi Stalwart (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+50, 212142, 2671, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 9.064076423645019531, 32.68357467651367187, 17.51499557495117187, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stalker (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@CGUID+51, 211644, 2671, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, -39.09136962890625, -18.0779457092285156, 14.03620529174804687, 6.210177421569824218, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Hastily Stacked Supplies (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 424874 - Hastily Stacked Supplies, 424873 - Hastily Stacked Supplies) - !!! on transport - transport template not found !!! +(@CGUID+52, 212142, 2671, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 43.82346725463867187, 40.35549163818359375, 70.89013671875, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stalker (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@CGUID+53, 212142, 2671, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, -11.6590299606323242, 32.92821502685546875, 17.515045166015625, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stalker (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@CGUID+54, 212142, 2671, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 43.82346725463867187, -37.2984619140625, 70.89013671875, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stalker (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@CGUID+55, 212142, 2671, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, -26.055459976196289, 47.02032089233398437, 63.3255462646484375, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stalker (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@CGUID+56, 223594, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 1, 1408.0625, -254.420135498046875, 9.41461181640625, 0.944765985012054443, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- General Steelstrike (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@CGUID+57, 211631, 2671, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 59.4732666015625, 0.00481414794921875, 16.8967132568359375, 3.244863510131835937, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Hastily Stacked Supplies (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 424858 - Hastily Stacked Supplies, 424859 - Hastily Stacked Supplies) - !!! on transport - transport template not found !!! +(@CGUID+58, 212142, 2671, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, -55.6051750183105468, 7.720540523529052734, 20.8372039794921875, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stalker (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@CGUID+59, 214016, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 1, 1392.689208984375, -235.289932250976562, 1.59702301025390625, 0.739005863666534423, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Arathi Stalwart (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+60, 214016, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 1, 1407.923583984375, -250.272567749023437, 1.555396080017089843, 0.739005863666534423, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Arathi Stalwart (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+61, 212142, 2671, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, -88.040130615234375, -4.58251285552978515, 12.9232177734375, 0, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Stalker (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@CGUID+62, 214016, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 1, 1455.7535400390625, -208.927078247070312, 2.172007322311401367, 3.91639256477355957, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Arathi Stalwart (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+63, 214016, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 1, 1404.170166015625, -246.513885498046875, 1.565013408660888671, 0.739005863666534423, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Arathi Stalwart (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 (Auras: 123167 - Mod Scale 95-100%) +(@CGUID+64, 225643, 2662, 14971, 15544, '1,2,8,23', '0', 0, 0, 0, 2074.267333984375, 2133, 1394.885009765625, 3.76270151138305664, 7200, 0, 0, 0, NULL, NULL, NULL, NULL, 56421); -- Stalker (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+64; +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, 714, 0, 0, 0, 0, '123167'), -- Arathi Stalwart - 123167 - Mod Scale 95-100% +(@CGUID+2, 0, 0, 0, 0, 0, 1, 0, 714, 0, 0, 0, 0, '123167'), -- Arathi Stalwart - 123167 - Mod Scale 95-100% +(@CGUID+11, 0, 0, 0, 0, 0, 1, 0, 714, 0, 0, 0, 0, '123167'), -- Arathi Stalwart - 123167 - Mod Scale 95-100% +(@CGUID+13, 0, 0, 0, 0, 0, 1, 0, 714, 0, 0, 0, 0, '123167'), -- Arathi Stalwart - 123167 - Mod Scale 95-100% +(@CGUID+14, 0, 0, 0, 0, 0, 1, 0, 714, 0, 0, 0, 0, '123167'), -- Arathi Stalwart - 123167 - Mod Scale 95-100% +(@CGUID+15, 0, 0, 0, 0, 0, 1, 0, 714, 0, 0, 0, 0, '123167'), -- Arathi Stalwart - 123167 - Mod Scale 95-100% +(@CGUID+16, 0, 0, 0, 0, 0, 1, 0, 714, 0, 0, 0, 0, '123167'), -- Arathi Stalwart - 123167 - Mod Scale 95-100% +(@CGUID+18, 0, 0, 0, 0, 0, 1, 0, 714, 0, 0, 0, 0, '123167'), -- Arathi Stalwart - 123167 - Mod Scale 95-100% +(@CGUID+19, 0, 0, 0, 0, 0, 1, 0, 714, 0, 0, 0, 0, '123167'), -- Arathi Stalwart - 123167 - Mod Scale 95-100% +(@CGUID+20, 0, 0, 0, 0, 0, 1, 0, 714, 0, 0, 0, 0, '123167'), -- Arathi Stalwart - 123167 - Mod Scale 95-100% +(@CGUID+21, 0, 0, 0, 0, 0, 1, 0, 714, 0, 0, 0, 0, '123167'), -- Arathi Stalwart - 123167 - Mod Scale 95-100% +(@CGUID+22, 0, 0, 0, 0, 0, 1, 0, 714, 0, 0, 0, 0, '123167'), -- Arathi Stalwart - 123167 - Mod Scale 95-100% +(@CGUID+25, 0, 0, 0, 0, 0, 1, 0, 714, 0, 0, 0, 0, '123167'), -- Arathi Stalwart - 123167 - Mod Scale 95-100% +(@CGUID+27, 0, 0, 0, 0, 0, 1, 0, 714, 0, 0, 0, 0, '123167'), -- Arathi Stalwart - 123167 - Mod Scale 95-100% +(@CGUID+36, 0, 0, 0, 0, 0, 1, 0, 714, 0, 0, 0, 0, '123167'), -- Arathi Stalwart - 123167 - Mod Scale 95-100% +(@CGUID+44, 0, 0, 0, 0, 0, 1, 0, 714, 0, 0, 0, 0, '123167'), -- Arathi Stalwart - 123167 - Mod Scale 95-100% +(@CGUID+47, 0, 0, 0, 0, 0, 1, 0, 714, 0, 0, 0, 0, '123167'), -- Arathi Stalwart - 123167 - Mod Scale 95-100% +(@CGUID+49, 0, 0, 0, 0, 0, 1, 0, 714, 0, 0, 0, 0, '123167'), -- Arathi Stalwart - 123167 - Mod Scale 95-100% +(@CGUID+59, 0, 0, 0, 0, 0, 1, 0, 714, 0, 0, 0, 0, '123167'), -- Arathi Stalwart - 123167 - Mod Scale 95-100% +(@CGUID+60, 0, 0, 0, 0, 0, 1, 0, 714, 0, 0, 0, 0, '123167'), -- Arathi Stalwart - 123167 - Mod Scale 95-100% +(@CGUID+62, 0, 0, 0, 0, 0, 1, 0, 714, 0, 0, 0, 0, '123167'), -- Arathi Stalwart - 123167 - Mod Scale 95-100% +(@CGUID+63, 0, 0, 0, 0, 0, 1, 0, 714, 0, 0, 0, 0, '123167'); -- Arathi Stalwart - 123167 - Mod Scale 95-100% + +-- GameObject +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+90; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, -83.9275131225585937, 4.028554439544677734, 55.59196853637695312, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 7200, 255, 1, 56421); -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+1, 428530, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1383.9010009765625, -132.892364501953125, 8.923621177673339843, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+2, 446513, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1390.720458984375, -235.126739501953125, 1.354025483131408691, 0.773540377616882324, 0, 0, 0.377199172973632812, 0.926132142543792724, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+3, 428530, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1337.6875, -123.109382629394531, 8.530277252197265625, 2.268925428390502929, 0, 0, 0.906307220458984375, 0.422619491815567016, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+4, 428530, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1340.9896240234375, -191.873260498046875, 8.530277252197265625, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+5, 428530, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1379.2847900390625, -254.430557250976562, 9.534863471984863281, 0.773540377616882324, 0, 0, 0.377199172973632812, 0.926132142543792724, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+6, 428530, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1323.123291015625, -151.720489501953125, 8.530277252197265625, 2.268925428390502929, 0, 0, 0.906307220458984375, 0.422619491815567016, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+7, 252248, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1366.861083984375, -158.73785400390625, 3.239628314971923828, 4.735342979431152343, 0, 0, -0.6989450454711914, 0.715175390243530273, 7200, 255, 1, 56421), -- Instance Portal (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+8, 428530, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1342.48095703125, -109.180557250976562, 8.530277252197265625, 0, 0, 0, 0, 1, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+9, 446513, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1426.1597900390625, -180.809036254882812, 1.01088118553161621, 3.931915283203125, 0, 0, -0.92293453216552734, 0.384956955909729003, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+10, 428530, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1436.217041015625, -158.038192749023437, 1.539687871932983398, 0.773540377616882324, 0, 0, 0.377199172973632812, 0.926132142543792724, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+11, 428530, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1327.2447509765625, -158.996536254882812, 8.530277252197265625, 0.610863447189331054, 0, 0, 0.3007049560546875, 0.953717231750488281, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+12, 446513, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1460.0867919921875, -212.635421752929687, 1.01088118553161621, 3.931915283203125, 0, 0, -0.92293453216552734, 0.384956955909729003, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+13, 428530, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1333.5399169921875, -156.467010498046875, 8.819314956665039062, 0.026604482904076576, 0, 0, 0.013301849365234375, 0.999911487102508544, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+14, 428530, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1342.48095703125, -205.92535400390625, 8.530277252197265625, 0, 0, 0, 0, 1, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+15, 428530, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1453.3177490234375, -174.932296752929687, 1.539687871932983398, 0.773540377616882324, 0, 0, 0.377199172973632812, 0.926132142543792724, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+16, 465500, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1372.37158203125, -134.201385498046875, 1.966290831565856933, 2.356189966201782226, 0, 0, 0.923878669738769531, 0.38268551230430603, 7200, 255, 1, 56421), -- Chair (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+17, 428530, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1410.77783203125, -286.229156494140625, 9.534863471984863281, 0.773540377616882324, 0, 0, 0.377199172973632812, 0.926132142543792724, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+18, 446513, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1427.66845703125, -271.994781494140625, 1.147732257843017578, 0.773540377616882324, 0, 0, 0.377199172973632812, 0.926132142543792724, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+19, 428530, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1461.467041015625, -343.53472900390625, 9.534863471984863281, 0.773540377616882324, 0, 0, 0.377199172973632812, 0.926132142543792724, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+20, 428531, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1425.91845703125, -316.986114501953125, 19.42930221557617187, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+21, 428530, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1526.76220703125, -247.043411254882812, 1.989760994911193847, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+22, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, 32, -29, 24.611572265625, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+23, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, 48.47533035278320312, 24.17536544799804687, 24.19509315490722656, 4.363324165344238281, 0, 0, -0.81915187835693359, 0.573576688766479492, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+24, 428531, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1432.001708984375, -334.463531494140625, 20.77193260192871093, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+25, 410422, 2671, 14971, 15544, '1,2,8,23', '0', 0, 59.4732666015625, 0.00481414794921875, 14.8967132568359375, 3.244879961013793945, 0, 0, -0.99866676330566406, 0.051620587706565856, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! might be temporary spawn !!! +(@OGUID+26, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, 48.47533035278320312, -24.1753997802734375, 24.611572265625, 5.061456203460693359, 0, 0, -0.57357597351074218, 0.819152355194091796, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+27, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, 60.67960739135742187, 9.443180084228515625, 52.22134017944335937, 0, -0.19509029388427734, 0, 0, 0.980785250663757324, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+28, 428530, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1515.1319580078125, -290.73785400390625, 1.292292714118957519, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+29, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, 50.71083450317382812, -22.5359992980957031, 24.611572265625, 5.148722648620605468, 0, 0, -0.53729915618896484, 0.843391716480255126, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+30, 428531, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1420.5504150390625, -321.883697509765625, 20.77193260192871093, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+31, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, 48.47533035278320312, 24.17536544799804687, 55.59196853637695312, 4.363324165344238281, 0, 0, -0.81915187835693359, 0.573576688766479492, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+32, 428530, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1479.6007080078125, -324.0382080078125, 9.534863471984863281, 0.773540377616882324, 0, 0, 0.377199172973632812, 0.926132142543792724, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+33, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, 50.71083450317382812, 22.53603553771972656, 55.59196853637695312, 4.276057243347167968, 0, 0, -0.84339141845703125, 0.537299633026123046, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+34, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, 60.67960739135742187, -9.44318294525146484, 52.22134017944335937, 0, 0.195090293884277343, 0, 0, 0.980785250663757324, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+35, 446513, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1481.4739990234375, -271.822906494140625, 0.880408406257629394, 3.931915283203125, 0, 0, -0.92293453216552734, 0.384956955909729003, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+36, 428530, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1502.96875, -301.873260498046875, 1.292292714118957519, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+37, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, 50.71083450317382812, 22.53603553771972656, 24.19509315490722656, 4.276057243347167968, 0, 0, -0.84339141845703125, 0.537299633026123046, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+38, 465540, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1314.7413330078125, -76.3472213745117187, 132.934906005859375, 0.849963009357452392, 0, 0, 0.412303924560546875, 0.911046385765075683, 7200, 255, 1, 56421), -- Crystal (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+39, 428531, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1420.5504150390625, -321.883697509765625, 27.685333251953125, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+40, 428531, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1432.001708984375, -334.463531494140625, 27.685333251953125, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+41, 446571, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1474.5086669921875, -298.9375, 0.954020082950592041, 0.773540377616882324, 0, 0, 0.377199172973632812, 0.926132142543792724, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+42, 428530, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1524.5972900390625, -279.052093505859375, 1.989760994911193847, 0.773540377616882324, 0, 0, 0.377199172973632812, 0.926132142543792724, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+43, 465470, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1044.32470703125, 1077.9617919921875, 159.700042724609375, 1.005515694618225097, 0, 0, 0.481843948364257812, 0.876257061958312988, 7200, 255, 1, 56421), -- Crystal (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+44, 428530, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1456.048583984375, -319.19964599609375, 9.534863471984863281, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+45, 428535, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1422.63720703125, -313.857635498046875, 19.42930221557617187, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+46, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, 30.77520179748535156, -30.6471996307373046, 57.2427978515625, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+47, 446513, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1456.986083984375, -277.555572509765625, 1.589420080184936523, 2.346413850784301757, 0, 0, 0.9219970703125, 0.387196868658065795, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+48, 428530, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1525.6336669921875, -208.795135498046875, 1.989760994911193847, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+49, 428531, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1464.953125, -298.84375, 18.11857795715332031, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+50, 428531, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1425.91845703125, -316.986114501953125, 26.34270668029785156, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+51, 441748, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1432.2725830078125, -322.16925048828125, 13.81551742553710937, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 7200, 255, 1, 56421), -- Stairs (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+52, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, 50.71083450317382812, -22.5359992980957031, 57.2427978515625, 5.148722648620605468, 0, 0, -0.53729915618896484, 0.843391716480255126, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+53, 428530, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1518.9410400390625, -233.802078247070312, 7.25736236572265625, 0.773540377616882324, 0, 0, 0.377199172973632812, 0.926132142543792724, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+54, 428531, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1437.0972900390625, -329.26910400390625, 26.34270668029785156, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+55, 428530, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1491.2117919921875, -312.171875, 1.292292714118957519, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+56, 446571, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1435.217041015625, -300.37152099609375, 0.954020082950592041, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+57, 428530, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1487.9271240234375, -210.088546752929687, 1.989760994911193847, 0.773540377616882324, 0, 0, 0.377199172973632812, 0.926132142543792724, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+58, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, 48.47533035278320312, -24.1753997802734375, 57.2427978515625, 5.061456203460693359, 0, 0, -0.57357597351074218, 0.819152355194091796, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+59, 428531, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1464.953125, -298.84375, 8.147378921508789062, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+60, 428531, 2662, 14971, 15544, '1,2,8,23', '0', 0, 1434.7847900390625, -331.51214599609375, 19.42930221557617187, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 +(@OGUID+61, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, -46.1498146057128906, -23.4703998565673828, 57.2427978515625, 4.188792228698730468, 0, 0, -0.86602497100830078, 0.50000077486038208, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+62, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, -1.62479829788208007, -32.8193016052246093, 57.2427978515625, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+63, 410425, 2671, 14971, 15544, '1,2,8,23', '0', 0, -39.3101997375488281, -21.0699539184570312, 11.03620529174804687, 1.497787833213806152, 0, 0, 0.680829048156738281, 0.732442378997802734, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! might be temporary spawn !!! +(@OGUID+64, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, -74.2262496948242187, -0.1208682581782341, 24.611572265625, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+65, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, -46.1498146057128906, 23.47037696838378906, 55.59196853637695312, 5.235987663269042968, 0, 0, -0.5, 0.866025388240814208, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+66, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, -46.1498146057128906, -23.4703998565673828, 24.611572265625, 4.188792228698730468, 0, 0, -0.86602497100830078, 0.50000077486038208, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+67, 410425, 2671, 14971, 15544, '1,2,8,23', '0', 0, -39.09136962890625, -18.0779457092285156, 11.03620529174804687, 1.497787833213806152, 0, 0, 0.680829048156738281, 0.732442378997802734, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! might be temporary spawn !!! +(@OGUID+68, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, -42.057708740234375, 30.53785896301269531, 24.19509315490722656, 5.672322273254394531, 0, 0, -0.3007049560546875, 0.953717231750488281, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+69, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, -30.7751941680908203, 30.64715003967285156, 24.19509315490722656, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+70, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, -46.149810791015625, 23.47037696838378906, 24.19509315490722656, 5.235987663269042968, 0, 0, -0.5, 0.866025388240814208, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+71, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, 30.77520179748535156, 30.64719963073730468, 24.19509315490722656, 4.537858963012695312, 0, 0, -0.76604366302490234, 0.642788589000701904, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+72, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, -74.2262496948242187, 0.120869956910610198, 24.19509315490722656, 5.672322273254394531, 0, 0, -0.3007049560546875, 0.953717231750488281, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+73, 467504, 2671, 14971, 15544, '1,2,8,23', '0', 0, -1.77360367774963378, 0.064514793455600738, 16.57279777526855468, 3.114528417587280273, 0, 0, 0.999908447265625, 0.013531646691262722, 7200, 255, 1, 56421), -- The Dawnbreaker (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+74, 410425, 2671, 14971, 15544, '1,2,8,23', '0', 0, -38.8725395202636718, -15.0859375, 11.03620529174804687, 1.497787833213806152, 0, 0, 0.680829048156738281, 0.732442378997802734, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! might be temporary spawn !!! +(@OGUID+75, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, -1.62479829788208007, 32.81926345825195312, 24.19509315490722656, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+76, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, -39, -28, 24.611572265625, 4.537858963012695312, 0, 0, -0.76604366302490234, 0.642788589000701904, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+77, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, -42.057708740234375, -30.5378990173339843, 24.611572265625, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+78, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, -30.7751941680908203, 30.64715003967285156, 55.59196853637695312, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+79, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, -42.057708740234375, -30.5378990173339843, 57.2427978515625, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+80, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, 30.77520179748535156, 30.64719963073730468, 55.59196853637695312, 4.537858963012695312, 0, 0, -0.76604366302490234, 0.642788589000701904, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+81, 410422, 2671, 14971, 15544, '1,2,8,23', '0', 0, 56.67366790771484375, 5.850090980529785156, 14.7742767333984375, 1.106902003288269042, 0, 0, 0.525626182556152343, 0.85071563720703125, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! might be temporary spawn !!! +(@OGUID+82, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, -42.057708740234375, 30.53785896301269531, 55.59196853637695312, 5.672322273254394531, 0, 0, -0.3007049560546875, 0.953717231750488281, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+83, 410422, 2671, 14971, 15544, '1,2,8,23', '0', 0, 52.60895919799804687, -7.16176700592041015, 14.75, 4.206930160522460937, 0, 0, -0.86145496368408203, 0.50783395767211914, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! might be temporary spawn !!! +(@OGUID+84, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, -30.7751941680908203, -30.6471996307373046, 57.2427978515625, 4.537858963012695312, 0, 0, -0.76604366302490234, 0.642788589000701904, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+85, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, -1.62479829788208007, 32.81926345825195312, 55.59196853637695312, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+86, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, -83.9275131225585937, 4.028554439544677734, 24.19509315490722656, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+87, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, -83.927520751953125, -4.0285491943359375, 57.2427978515625, 4.537858963012695312, 0, 0, -0.76604366302490234, 0.642788589000701904, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+88, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, -74.2262496948242187, -0.1208682581782341, 57.2427978515625, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+89, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, -74.2262496948242187, 0.120869956910610198, 55.59196853637695312, 5.672322273254394531, 0, 0, -0.3007049560546875, 0.953717231750488281, 7200, 255, 1, 56421), -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +(@OGUID+90, 413846, 2671, 14971, 15544, '1,2,8,23', '0', 0, -83.9275131225585937, -4.02855110168457031, 24.611572265625, 4.537858963012695312, 0, 0, -0.76604366302490234, 0.642788589000701904, 7200, 255, 1, 56421); -- Collision (Area: Tenir's Ascent - Difficulty: Normal) CreateObject1 - !!! on transport - transport template not found !!! +DELETE FROM `gameobject_addon` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+90; +INSERT INTO `gameobject_addon` (`guid`, `parent_rotation0`, `parent_rotation1`, `parent_rotation2`, `parent_rotation3`, `WorldEffectID`, `AIAnimKitID`) VALUES +(@OGUID+51, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0); -- Stairs + +-- Template Addon +DELETE FROM `creature_template_addon` WHERE `entry` IN (225643 /*225643 (Stalker)*/, 223594 /*223594 (General Steelstrike)*/, 211644 /*211644 (Hastily Stacked Supplies) - Hastily Stacked Supplies, Hastily Stacked Supplies*/, 215167 /*215167 (Stalker)*/, 211631 /*211631 (Hastily Stacked Supplies) - Hastily Stacked Supplies, Hastily Stacked Supplies*/, 212142 /*212142 (Stalker)*/, 225601 /*225601 (Mereldar Citizen) - Mod Scale 95-100%*/, 214016 /*214016 (Arathi Stalwart) - Mod Scale 95-100%*/); +INSERT INTO `creature_template_addon` (`entry`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(225643, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- 225643 (Stalker) +(223594, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 5, ''), -- 223594 (General Steelstrike) +(211644, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 4, '424874 424873'), -- 211644 (Hastily Stacked Supplies) - Hastily Stacked Supplies, Hastily Stacked Supplies +(215167, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 5, ''), -- 215167 (Stalker) +(211631, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 4, '424858 424859'), -- 211631 (Hastily Stacked Supplies) - Hastily Stacked Supplies, Hastily Stacked Supplies +(212142, 0, 0, 0, 3, 0, 1, 0, 0, 0, 0, 0, 4, ''), -- 212142 (Stalker) +(225601, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123167'), -- 225601 (Mereldar Citizen) - Mod Scale 95-100% +(214016, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '123167'); -- 214016 (Arathi Stalwart) - Mod Scale 95-100% + +DELETE FROM `gameobject_template_addon` WHERE `entry` IN (467504 /*The Dawnbreaker*/, 410425 /*Collision*/, 441748 /*Stairs*/, 428535 /*Collision*/, 465470 /*Crystal*/, 446571 /*Collision*/, 465540 /*Crystal*/, 410422 /*Collision*/, 413846 /*Collision*/, 428531 /*Collision*/, 446513 /*Collision*/, 428530 /*Collision*/); +INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`) VALUES +(467504, 1375, 545259552, 0, 0), -- The Dawnbreaker +(410425, 14, 32, 0, 0), -- Collision +(441748, 1375, 32, 0, 0), -- Stairs +(428535, 0, 48, 0, 0), -- Collision +(465470, 0, 32, 0, 0), -- Crystal +(446571, 0, 48, 0, 0), -- Collision +(465540, 0, 32, 0, 0), -- Crystal +(410422, 14, 32, 0, 0), -- Collision +(413846, 0, 48, 0, 0), -- Collision +(428531, 0, 48, 0, 0), -- Collision +(446513, 0, 48, 0, 0), -- Collision +(428530, 0, 48, 0, 0); -- Collision + +-- Template +UPDATE `creature_template` SET `faction`=14, `BaseAttackTime`=2000, `unit_flags`=33554432, `unit_flags2`=2048, `unit_flags3`=1073741825, `flags_extra` = 128 WHERE `entry` IN (225643, 215167, 212142, 214013); -- Stalker +UPDATE `creature_template` SET `faction`=35, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=223594; -- General Steelstrike +UPDATE `creature_template` SET `faction`=14, `BaseAttackTime`=2000, `unit_flags`=33562688, `unit_flags3`=1073741825 WHERE `entry` IN (211644, 211631); -- Hastily Stacked Supplies +UPDATE `creature_template` SET `faction`=3334, `BaseAttackTime`=2000, `unit_flags2`=2048, `unit_flags3`=32769 WHERE `entry`=225601; -- Mereldar Citizen +UPDATE `creature_template` SET `unit_flags3`=1090551809 WHERE `entry` IN (211152, 211150, 211151, 211149, 211111, 211137); -- Path Helper +UPDATE `creature_template` SET `faction`=3334, `speed_run`=1.428571462631225585, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=214016; -- Arathi Stalwart + +DELETE FROM `gameobject_template` WHERE `entry` IN (410425 /*Collision*/, 467504 /*The Dawnbreaker*/, 410422 /*Collision*/, 413846 /*Collision*/, 465470 /*Crystal*/, 465540 /*Crystal*/, 428531 /*Collision*/, 428535 /*Collision*/, 446571 /*Collision*/, 465500 /*Chair*/, 428530 /*Collision*/, 446513 /*Collision*/, 409273 /*The Dawnbreaker*/); +INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `size`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `Data8`, `Data9`, `Data10`, `Data11`, `Data12`, `Data13`, `Data14`, `Data15`, `Data16`, `Data17`, `Data18`, `Data19`, `Data20`, `Data21`, `Data22`, `Data23`, `Data24`, `Data25`, `Data26`, `Data27`, `Data28`, `Data29`, `Data30`, `Data31`, `Data32`, `Data33`, `Data34`, `ContentTuningId`, `VerifiedBuild`) VALUES +(410425, 0, 38005, 'Collision', '', '', '', 1.25, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56421), -- Collision +(467504, 36, 9147, 'The Dawnbreaker', '', '', '', 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 6583, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56421), -- The Dawnbreaker +(410422, 0, 7735, 'Collision', '', '', '', 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56421), -- Collision +(413846, 0, 10403, 'Collision', '', '', '', 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56421), -- Collision +(465470, 1, 88671, 'Crystal', '', '', '', 0.949999988079071044, 0, 0, 0, 0, 0, 1, 0, 0, 0, 5703, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56421), -- Crystal +(465540, 1, 88671, 'Crystal', '', '', '', 0.949999988079071044, 0, 0, 0, 0, 0, 1, 0, 0, 0, 5703, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56421), -- Crystal +(428531, 0, 10403, 'Collision', '', '', '', 0.300000011920928955, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56421), -- Collision +(428535, 0, 10403, 'Collision', '', '', '', 0.5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56421), -- Collision +(446571, 0, 10403, 'Collision', '', '', '', 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56421), -- Collision +(465500, 7, 86167, 'Chair', '', '', '', 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56421), -- Chair +(428530, 0, 10403, 'Collision', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56421), -- Collision +(446513, 0, 10403, 'Collision', '', '', '', 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56421), -- Collision +(409273, 15, 84742, 'The Dawnbreaker', '', '', '', 1, 9456, 20, 5, 0, 0, 0, 2671, 0, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 56421); -- The Dawnbreaker + +-- Creature Equip +DELETE FROM `creature_equip_template` WHERE (`ID`=1 AND `CreatureID` IN (223594,214016)); +INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `AppearanceModID1`, `ItemVisual1`, `ItemID2`, `AppearanceModID2`, `ItemVisual2`, `ItemID3`, `AppearanceModID3`, `ItemVisual3`, `VerifiedBuild`) VALUES +(223594, 1, 218268, 0, 0, 0, 0, 0, 0, 0, 0, 56421), -- General Steelstrike +(214016, 1, 211343, 0, 0, 176819, 0, 0, 0, 0, 0, 56421); -- Arathi Stalwart + +-- Difficulty (Normal) +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2718, `StaticFlags1`=536871168, `VerifiedBuild`=56421 WHERE (`Entry`=225643 AND `DifficultyID`=0); -- 225643 (Stalker) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2718, `StaticFlags1`=268435456, `VerifiedBuild`=56421 WHERE (`Entry`=223594 AND `DifficultyID`=0); -- 223594 (General Steelstrike) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2718, `StaticFlags1`=536871168, `VerifiedBuild`=56421 WHERE (`Entry`=211644 AND `DifficultyID`=0); -- 211644 (Hastily Stacked Supplies) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2718, `StaticFlags1`=536871168, `VerifiedBuild`=56421 WHERE (`Entry`=215167 AND `DifficultyID`=0); -- 215167 (Stalker) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2718, `StaticFlags1`=536871168, `VerifiedBuild`=56421 WHERE (`Entry`=211631 AND `DifficultyID`=0); -- 211631 (Hastily Stacked Supplies) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2718, `StaticFlags1`=536871168, `VerifiedBuild`=56421 WHERE (`Entry`=212142 AND `DifficultyID`=0); -- 212142 (Stalker) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2718, `StaticFlags1`=268435456, `VerifiedBuild`=56421 WHERE (`Entry`=225601 AND `DifficultyID`=0); -- 225601 (Mereldar Citizen) - CanSwim +UPDATE `creature_template_difficulty` SET `VerifiedBuild`=56421 WHERE (`DifficultyID`=1 AND `Entry` IN (211152,211150,211151,211149,211111,211137)); +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2718, `StaticFlags1`=536871168, `VerifiedBuild`=56421 WHERE (`Entry`=214013 AND `DifficultyID`=0); -- 214013 (Stalker) - Sessile, Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2718, `StaticFlags1`=268435456, `VerifiedBuild`=56421 WHERE (`Entry`=214016 AND `DifficultyID`=0); -- 214016 (Arathi Stalwart) - CanSwim + +-- Difficulty (Heroic) +DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID`=2 AND `Entry` IN (223594,215167,225643,211631,211644,214013,225601,214016,212142)); +INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `StaticFlags1`, `StaticFlags2`, `StaticFlags3`, `StaticFlags4`, `StaticFlags5`, `StaticFlags6`, `StaticFlags7`, `StaticFlags8`, `VerifiedBuild`) VALUES +(223594, 2, 0, 0, 2720, 268435456, 0, 0, 0, 0, 0, 0, 0, 56421), -- 223594 (General Steelstrike) - CanSwim +(215167, 2, 0, 0, 2720, 536871168, 0, 0, 0, 0, 0, 0, 0, 56421), -- 215167 (Stalker) - Sessile, Floating +(225643, 2, 0, 0, 2720, 536871168, 0, 0, 0, 0, 0, 0, 0, 56421), -- 225643 (Stalker) - Sessile, Floating +(211631, 2, 0, 0, 2720, 536871168, 0, 0, 0, 0, 0, 0, 0, 56421), -- 211631 (Hastily Stacked Supplies) - Sessile, Floating +(211644, 2, 0, 0, 2720, 536871168, 0, 0, 0, 0, 0, 0, 0, 56421), -- 211644 (Hastily Stacked Supplies) - Sessile, Floating +(214013, 2, 0, 0, 2720, 536871168, 0, 0, 0, 0, 0, 0, 0, 56421), -- 214013 (Stalker) - Sessile, Floating +(225601, 2, 0, 0, 2720, 268435456, 0, 0, 0, 0, 0, 0, 0, 56421), -- 225601 (Mereldar Citizen) - CanSwim +(214016, 2, 0, 0, 2720, 268435456, 0, 0, 0, 0, 0, 0, 0, 56421), -- 214016 (Arathi Stalwart) - CanSwim +(212142, 2, 0, 0, 2720, 536871168, 0, 0, 0, 0, 0, 0, 0, 56421); -- 212142 (Stalker) - Sessile, Floating + +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=10, `CreatureDifficultyID`=274453 WHERE (`Entry`=223594 AND `DifficultyID`=2); -- General Steelstrike +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=10, `CreatureDifficultyID`=276613, `TypeFlags`=16778240, `TypeFlags2`=16 WHERE (`Entry`=225643 AND `DifficultyID`=2); -- Stalker +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=10, `CreatureDifficultyID`=261493, `TypeFlags`=16778240, `TypeFlags2`=16 WHERE (`Entry`=212142 AND `DifficultyID`=2); -- Stalker +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=10, `HealthModifier`=10, `CreatureDifficultyID`=260971, `TypeFlags`=16778240, `TypeFlags2`=16 WHERE (`Entry`=211631 AND `DifficultyID`=2); -- Hastily Stacked Supplies +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=10, `CreatureDifficultyID`=264640, `TypeFlags`=16778240, `TypeFlags2`=16 WHERE (`Entry`=215167 AND `DifficultyID`=2); -- Stalker +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=10, `HealthModifier`=10, `CreatureDifficultyID`=260984, `TypeFlags`=16778240, `TypeFlags2`=16 WHERE (`Entry`=211644 AND `DifficultyID`=2); -- Hastily Stacked Supplies +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=10, `CreatureDifficultyID`=263431, `TypeFlags`=2097224 WHERE (`Entry`=214016 AND `DifficultyID`=2); -- Arathi Stalwart +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=10, `CreatureDifficultyID`=263428, `TypeFlags`=16778240, `TypeFlags2`=16 WHERE (`Entry`=214013 AND `DifficultyID`=2); -- Stalker +UPDATE `creature_template_difficulty` SET `HealthScalingExpansion`=10, `HealthModifier`=0.300000011920928955, `CreatureDifficultyID`=276569, `TypeFlags`=2097224 WHERE (`Entry`=225601 AND `DifficultyID`=2); -- Mereldar Citizen + +-- Model +DELETE FROM `creature_model_info` WHERE `DisplayID`=114424; +INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`) VALUES +(114424, 0.5, 1, 0, 56421); + +UPDATE `creature_model_info` SET `VerifiedBuild`=56421 WHERE `DisplayID` IN (115282, 117752, 115014, 115037, 115036, 117757, 117751, 115035, 115012, 115013, 94282, 115038, 117756); |