diff options
| author | Naddley <64811442+Naddley@users.noreply.github.com> | 2022-02-02 23:26:22 +0100 |
|---|---|---|
| committer | ModoX <moardox@gmail.com> | 2022-02-03 05:34:28 +0100 |
| commit | 48ad9dad852cf41ac60e9f54c70667d281ec76b0 (patch) | |
| tree | 6a4a05478ea75c9d7f9ec9b1ff8c7f40229cab82 | |
| parent | e81b5838a6780a73946047c627583cdb837df58d (diff) | |
DB/Spawns: Added spawns for initial Bastion quests
Closes #27673
| -rw-r--r-- | sql/updates/world/master/2022_02_03_00_world.sql | 654 |
1 files changed, 654 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_02_03_00_world.sql b/sql/updates/world/master/2022_02_03_00_world.sql new file mode 100644 index 00000000000..5db143463e7 --- /dev/null +++ b/sql/updates/world/master/2022_02_03_00_world.sql @@ -0,0 +1,654 @@ +-- +SET @CGUID := 1050435; +SET @OGUID := 600172; + +-- Creature spawn +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+135; +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`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(@CGUID+0, 166227, 2222, 10534, 11013, '0', 14024, 0, 0, 0, -4261.234375, -3922.979248046875, 6561.40478515625, 1.353411555290222167, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41488), -- Kleia (Area: -Unknown- - Difficulty: 0) +(@CGUID+1, 165107, 2222, 10534, 11013, '0', 14027, 0, 0, 0, -4344.0712890625, -4227.89599609375, 6555.88671875, 5.335544586181640625, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41488), -- Kleia (Area: -Unknown- - Difficulty: 0) +(@CGUID+2, 166124, 2222, 10534, 11013, '0', 15180, 0, 0, 0, -4348.0849609375, -4254.78125, 6555.83984375, 4.39337921142578125, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41488), -- Sika (Area: -Unknown- - Difficulty: 0) +(@CGUID+3, 166124, 2222, 10534, 11013, '0', 15181, 0, 0, 0, -4338.01220703125, -4230.11279296875, 6555.88671875, 2.611382246017456054, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41488), -- Sika (Area: -Unknown- - Difficulty: 0) +(@CGUID+4, 158509, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4363.22998046875, -4236.87646484375, 6558.65087890625, 4.074697494506835937, 7200, 3, 0, 1830, 0, 1, 0, 0, 0, 41488), -- Effervescent Glimmerfly (Area: -Unknown- - Difficulty: 0) +(@CGUID+5, 158509, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4306.9619140625, -4254.45263671875, 6556.4580078125, 2.972917079925537109, 7200, 3, 0, 1830, 0, 1, 0, 0, 0, 41488), -- Effervescent Glimmerfly (Area: -Unknown- - Difficulty: 0) +(@CGUID+6, 158509, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4374.8955078125, -4247.08837890625, 6560.38134765625, 3.380265712738037109, 7200, 3, 0, 1830, 0, 1, 0, 0, 0, 41488), -- Effervescent Glimmerfly (Area: -Unknown- - Difficulty: 0) +(@CGUID+7, 158509, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4309.40283203125, -4262.6630859375, 6556.91552734375, 2.388590574264526367, 7200, 3, 0, 1830, 0, 1, 0, 0, 0, 41488), -- Effervescent Glimmerfly (Area: -Unknown- - Difficulty: 0) +(@CGUID+8, 158509, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4279.43359375, -4197.50390625, 6555.921875, 0.600722908973693847, 7200, 3, 0, 1830, 0, 1, 0, 0, 0, 41488), -- Effervescent Glimmerfly (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+9, 158509, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4416.294921875, -4209.76953125, 6554.6640625, 4.007224082946777343, 7200, 3, 0, 1830, 0, 1, 0, 0, 0, 41488), -- Effervescent Glimmerfly (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+10, 158509, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4255.43505859375, -4244.02587890625, 6556.572265625, 5.641602516174316406, 7200, 3, 0, 1830, 0, 1, 0, 0, 0, 41488), -- Effervescent Glimmerfly (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+11, 158509, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4420.43310546875, -4203.19140625, 6556.3701171875, 0.119242608547210693, 7200, 3, 0, 1830, 0, 1, 0, 0, 0, 41488), -- Effervescent Glimmerfly (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+12, 158509, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4357.482421875, -4160.12841796875, 6556.8525390625, 0.133640483021736145, 7200, 3, 0, 1830, 0, 1, 0, 0, 0, 41488), -- Effervescent Glimmerfly (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+13, 158509, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4423.4921875, -4230.99267578125, 6556.46728515625, 1.603203296661376953, 7200, 3, 0, 1830, 0, 1, 0, 0, 0, 41488), -- Effervescent Glimmerfly (Area: -Unknown- - Difficulty: 0) +(@CGUID+14, 158509, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4411.029296875, -4204.23291015625, 6554.59814453125, 5.171086311340332031, 7200, 3, 0, 1830, 0, 1, 0, 0, 0, 41488), -- Effervescent Glimmerfly (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+15, 158509, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4288.515625, -4182.77734375, 6557.01611328125, 4.000127315521240234, 7200, 3, 0, 1830, 0, 1, 0, 0, 0, 41488), -- Effervescent Glimmerfly (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+16, 158509, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4394.48974609375, -4251.45947265625, 6553.84228515625, 2.469704151153564453, 7200, 3, 0, 1830, 0, 1, 0, 0, 0, 41488), -- Effervescent Glimmerfly (Area: -Unknown- - Difficulty: 0) +(@CGUID+17, 158509, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4312.85791015625, -4271.17333984375, 6556.89208984375, 5.182507991790771484, 7200, 3, 0, 1830, 0, 1, 0, 0, 0, 41488), -- Effervescent Glimmerfly (Area: -Unknown- - Difficulty: 0) +(@CGUID+18, 158509, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4374.2939453125, -4289.0634765625, 6556.07177734375, 4.374045848846435546, 7200, 3, 0, 1830, 0, 1, 0, 0, 0, 41488), -- Effervescent Glimmerfly (Area: -Unknown- - Difficulty: 0) +(@CGUID+19, 158509, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4349.3681640625, -4299.3564453125, 6555.857421875, 1.167762279510498046, 7200, 3, 0, 1830, 0, 1, 0, 0, 0, 41488), -- Effervescent Glimmerfly (Area: -Unknown- - Difficulty: 0) +(@CGUID+20, 158509, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4326.98486328125, -4327.923828125, 6555.1884765625, 2.270607709884643554, 7200, 3, 0, 1830, 0, 1, 0, 0, 0, 41488), -- Effervescent Glimmerfly (Area: -Unknown- - Difficulty: 0) +(@CGUID+21, 158509, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4285.50439453125, -4193.05029296875, 6556.4296875, 5.704111099243164062, 7200, 3, 0, 1830, 0, 1, 0, 0, 0, 41488), -- Effervescent Glimmerfly (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+22, 158510, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4371.451171875, -4227.59912109375, 6557.41259765625, 4.127566814422607421, 7200, 3, 0, 3050, 0, 1, 0, 0, 0, 41488), -- Eternal Glimmerfly (Area: -Unknown- - Difficulty: 0) +(@CGUID+23, 158510, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4319.52880859375, -4256.6025390625, 6561.77197265625, 2.759197235107421875, 7200, 3, 0, 3050, 0, 1, 0, 0, 0, 41488), -- Eternal Glimmerfly (Area: -Unknown- - Difficulty: 0) +(@CGUID+24, 158510, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4375.79541015625, -4161.16552734375, 6558.55615234375, 0.546603918075561523, 7200, 3, 0, 3050, 0, 1, 0, 0, 0, 41488), -- Eternal Glimmerfly (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+25, 158510, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4272.84912109375, -4270.5947265625, 6558.19873046875, 4.249482154846191406, 7200, 3, 0, 3050, 0, 1, 0, 0, 0, 41488), -- Eternal Glimmerfly (Area: -Unknown- - Difficulty: 0) +(@CGUID+26, 158281, 2222, 10534, 11013, '0', 14025, 0, 0, 0, -4341.455078125, -4230.1962890625, 6555.88671875, 1.767760992050170898, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Greeter Mnemis (Area: -Unknown- - Difficulty: 0) (Auras: 138767 - Custom - Permanent Feign Death) +(@CGUID+27, 158281, 2222, 10534, 11013, '0', 14026, 0, 0, 0, -4341.455078125, -4230.1962890625, 6555.88671875, 1.767760992050170898, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Greeter Mnemis (Area: -Unknown- - Difficulty: 0)(Area: -Unknown- - Difficulty: 0) +(@CGUID+28, 170179, 2222, 10534, 11013, '0', 15895, 0, 0, 0, -4290.31103515625, -4309.14599609375, 6554.33203125, 5.592580795288085937, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kleia (Area: -Unknown- - Difficulty: 0) +(@CGUID+29, 165107, 2222, 10534, 11013, '0', 15190, 0, 0, 0, -4343.80029296875, -4237.98779296875, 6555.86376953125, 4.401084423065185546, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kleia (Area: -Unknown- - Difficulty: 0) +(@CGUID+30, 166306, 2222, 10534, 11013, '0', 15190, 0, 0, 0, -4345.5400390625, -4243.953125, 6555.83984375, 1.303908705711364746, 7200, 0, 0, 183000, 0, 0, 2, 0, 0, 41793), -- Kalisthene (Area: -Unknown- - Difficulty: 0) +(@CGUID+31, 166124, 2222, 10534, 11013, '0', 15190, 0, 0, 0, -4341.9755859375, -4245.720703125, 6555.83984375, 2.175177812576293945, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Sika (Area: -Unknown- - Difficulty: 0) (Auras: 313123 - -Unknown-) +(@CGUID+32, 158281, 2222, 10534, 11013, '0', 15935, 0, 0, 0, -4341.455078125, -4230.1962890625, 6555.88671875, 4.465909957885742187, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Greeter Mnemis (Area: -Unknown- - Difficulty: 0) (Auras: 138767 - Custom - Permanent Feign Death) +(@CGUID+33, 154631, 2222, 10534, 11013, '0', 0, 0, 0, 1, -4312.27978515625, -4049.8125, 6556.8671875, 6.031661510467529296, 7200, 0, 0, 294775, 100, 0, 0, 0, 0, 41793), -- Elysian Bulwark (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+34, 174794, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4294.671875, -4110.88037109375, 6559.21484375, 5.658568382263183593, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Steward (Area: -Unknown- - Difficulty: 0) +(@CGUID+35, 166164, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4354.1806640625, -4275.18408203125, 6557.41845703125, 1.285644173622131347, 7200, 0, 0, 1830000, 46600, 0, 0, 0, 0, 41793), -- Centurion Colossus (Area: -Unknown- - Difficulty: 0) (Auras: 320712 - -Unknown-) +(@CGUID+36, 174635, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4324.5244140625, -4103.34716796875, 6559.21484375, 0.612976610660552978, 7200, 0, 0, 6100, 100, 0, 0, 0, 0, 41793), -- Depleted Praetor (Area: -Unknown- - Difficulty: 0) (Auras: 201326 - Permanent Feign Death (Spawn, Untrackable, No Stun), 29266 - Permanent Feign Death) +(@CGUID+37, 154631, 2222, 10534, 11013, '0', 0, 0, 0, 1, -4277.06103515625, -4058.364501953125, 6556.8671875, 2.916287183761596679, 7200, 0, 0, 294775, 100, 0, 0, 0, 0, 41793), -- Elysian Bulwark (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+38, 174635, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4306.44970703125, -4026.6337890625, 6561.208984375, 1.38062906265258789, 7200, 0, 0, 6100, 100, 0, 0, 0, 0, 41793), -- Depleted Praetor (Area: -Unknown- - Difficulty: 0) (Auras: 201326 - Permanent Feign Death (Spawn, Untrackable, No Stun), 29266 - Permanent Feign Death) +(@CGUID+39, 174794, 2222, 10534, 11013, '0', 0, 0, 0, 1, -4284.8271484375, -4058.86181640625, 6555.96826171875, 3.87931370735168457, 7200, 10, 0, 6100, 0, 1, 0, 0, 0, 41793), -- Kyrian Steward (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+40, 154630, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4271.88720703125, -4035.52783203125, 6561.208984375, 1.263059496879577636, 7200, 0, 0, 176865, 100, 0, 0, 0, 0, 41793), -- Elysian Guardian (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+41, 174794, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4321.3837890625, -4133.470703125, 6561.35546875, 4.813039302825927734, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Steward (Area: -Unknown- - Difficulty: 0) (Auras: 314020 - -Unknown-) +(@CGUID+42, 174794, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4276.55712890625, -4009.833251953125, 6559.09765625, 2.048217535018920898, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Steward (Area: -Unknown- - Difficulty: 0) (Auras: 314020 - -Unknown-) +(@CGUID+43, 174635, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4293.189453125, -4111.625, 6559.21484375, 2.026627779006958007, 7200, 0, 0, 6100, 100, 0, 0, 0, 0, 41793), -- Depleted Praetor (Area: -Unknown- - Difficulty: 0) (Auras: 201326 - Permanent Feign Death (Spawn, Untrackable, No Stun), 29266 - Permanent Feign Death) +(@CGUID+44, 174794, 2222, 10534, 11013, '0', 0, 0, 0, 1, -4282.29052734375, -3948.49169921875, 6561.32080078125, 6.069844722747802734, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Steward (Area: -Unknown- - Difficulty: 0) +(@CGUID+45, 174794, 2222, 10534, 11013, '0', 0, 0, 0, 1, -4322.720703125, -3928.41845703125, 6563.82421875, 4.204681396484375, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Steward (Area: -Unknown- - Difficulty: 0) +(@CGUID+46, 154631, 2222, 10534, 11013, '0', 0, 0, 0, 1, -4298.81591796875, -3946.395751953125, 6561.404296875, 0.623532295227050781, 7200, 0, 0, 294775, 100, 0, 0, 0, 0, 41793), -- Elysian Bulwark (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+47, 174636, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4239.70166015625, -3961.376708984375, 6561.404296875, 1.891175508499145507, 7200, 0, 0, 73200, 100, 0, 0, 0, 0, 41793), -- Depleted Goliath (Area: -Unknown- - Difficulty: 0) (Auras: 201326 - Permanent Feign Death (Spawn, Untrackable, No Stun), 314842 - -Unknown-) +(@CGUID+48, 154630, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4244.3662109375, -3910.229248046875, 6561.7763671875, 2.138147830963134765, 7200, 0, 0, 176865, 100, 0, 0, 0, 0, 41793), -- Elysian Guardian (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+49, 174635, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4269.90625, -3903.875, 6561.7763671875, 1.163639426231384277, 7200, 0, 0, 6100, 100, 0, 0, 0, 0, 41793), -- Depleted Praetor (Area: -Unknown- - Difficulty: 0) (Auras: 201326 - Permanent Feign Death (Spawn, Untrackable, No Stun), 29266 - Permanent Feign Death) +(@CGUID+50, 174635, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4342.90087890625, -4155.19775390625, 6556.0537109375, 5.160524368286132812, 7200, 0, 0, 6100, 100, 0, 0, 0, 0, 41793), -- Depleted Praetor (Area: -Unknown- - Difficulty: 0) (Auras: 201326 - Permanent Feign Death (Spawn, Untrackable, No Stun), 29266 - Permanent Feign Death) +(@CGUID+51, 174635, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4302.4619140625, -4165.68603515625, 6556.0537109375, 3.810816049575805664, 7200, 0, 0, 6100, 100, 0, 0, 0, 0, 41793), -- Depleted Praetor (Area: -Unknown- - Difficulty: 0) (Auras: 201326 - Permanent Feign Death (Spawn, Untrackable, No Stun), 29266 - Permanent Feign Death) +(@CGUID+52, 156228, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4274.98779296875, -4165.8037109375, 6557.046875, 3.87874770164489746, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Aspirant (Area: -Unknown- - Difficulty: 0) +(@CGUID+53, 156228, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4362.02783203125, -4171.50341796875, 6552.396484375, 4.954581260681152343, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Aspirant (Area: -Unknown- - Difficulty: 0) +(@CGUID+54, 164369, 2222, 10534, 11013, '0', 0, 0, 0, 0, -3914.4462890625, -5639.67724609375, 6644.3359375, 5.588767051696777343, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Purity Vesper (Area: -Unknown- - Difficulty: 0) (Auras: 327141 - -Unknown-) +(@CGUID+55, 154630, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4379.05224609375, -4172.94970703125, 6552.10546875, 5.248474597930908203, 7200, 0, 0, 176865, 100, 0, 0, 0, 0, 41793), -- Elysian Guardian (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+56, 156228, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4395.88916015625, -4135.56787109375, 6579.3603515625, 1.790779948234558105, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Aspirant (Area: -Unknown- - Difficulty: 0) +(@CGUID+57, 174794, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4283.70654296875, -4201.6962890625, 6552.10546875, 5.14376688003540039, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Steward (Area: -Unknown- - Difficulty: 0) (Auras: 313123 - -Unknown-) +(@CGUID+58, 174794, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4263.9755859375, -4192.517578125, 6550.97900390625, 5.142459392547607421, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Steward (Area: -Unknown- - Difficulty: 0) (Auras: 313115 - -Unknown-) +(@CGUID+59, 154630, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4281.048828125, -4201.84228515625, 6553.22998046875, 3.662294626235961914, 7200, 0, 0, 176865, 100, 0, 0, 0, 0, 41793), -- Elysian Guardian (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+60, 173057, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4252.48974609375, -4190.97412109375, 6550.97900390625, 4.367832183837890625, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 41793), -- Steward Caterer (Area: -Unknown- - Difficulty: 0) (Auras: 338429 - -Unknown-) +(@CGUID+61, 174794, 2222, 10534, 11013, '0', 0, 0, 0, 1, -4280.62158203125, -4207.38134765625, 6552.12109375, 4.815523147583007812, 7200, 10, 0, 6100, 0, 1, 0, 0, 0, 41793), -- Kyrian Steward (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+62, 154631, 2222, 10534, 11013, '0', 0, 0, 0, 1, -4369.77490234375, -4201.26611328125, 6552.05078125, 0.014702185988426208, 7200, 10, 0, 294775, 100, 1, 0, 0, 0, 41793), -- Elysian Bulwark (Area: -Unknown- - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(@CGUID+63, 158599, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4255.95166015625, -4209.6943359375, 6551.1083984375, 0, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Visit Northwest Station (Area: -Unknown- - Difficulty: 0) +(@CGUID+64, 158332, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4403.14404296875, -4173.798828125, 6552.73974609375, 0, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Visit Southwest Station (Area: -Unknown- - Difficulty: 0) +(@CGUID+65, 156228, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4267.71533203125, -4223.71728515625, 6551.18212890625, 2.484003782272338867, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Aspirant (Area: -Unknown- - Difficulty: 0) +(@CGUID+66, 156228, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4408.4150390625, -4180.533203125, 6552.73974609375, 1.432271480560302734, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Aspirant (Area: -Unknown- - Difficulty: 0) +(@CGUID+67, 158464, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4341.47412109375, -4230.15625, 6555.88671875, 0, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Speak to the Greeter Again (Area: -Unknown- - Difficulty: 0) +(@CGUID+68, 154630, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4329.2431640625, -4237.86474609375, 6555.83984375, 3.304216384887695312, 7200, 0, 0, 176865, 100, 0, 0, 0, 0, 41793), -- Elysian Guardian (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+69, 156228, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4402.09033203125, -4192.26416015625, 6556.26171875, 5.747358322143554687, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Aspirant (Area: -Unknown- - Difficulty: 0) +(@CGUID+70, 154630, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4356.5625, -4230.0869140625, 6555.83984375, 5.494059562683105468, 7200, 0, 0, 176865, 100, 0, 0, 0, 0, 41793), -- Elysian Guardian (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+71, 156398, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4330.0537109375, -4268.9375, 6555.83984375, 2.02642059326171875, 7200, 0, 0, 73200, 1864, 0, 0, 0, 0, 41793), -- Centurion Goliath (Area: -Unknown- - Difficulty: 0) (Auras: 320712 - -Unknown-) +(@CGUID+72, 154630, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4400.69970703125, -4197.98291015625, 6552.10546875, 5.991235733032226562, 7200, 0, 0, 176865, 100, 0, 0, 0, 0, 41793), -- Elysian Guardian (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+73, 166161, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4371.9375, -4253.38720703125, 6555.83984375, 0, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Anima (Area: -Unknown- - Difficulty: 0) +(@CGUID+74, 158504, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4327.9462890625, -4266.04150390625, 6555.849609375, 2.730207681655883789, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Steward (Area: -Unknown- - Difficulty: 0) +(@CGUID+75, 166161, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4348.03125, -4254.876953125, 6555.83984375, 0, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Anima (Area: -Unknown- - Difficulty: 0) +(@CGUID+76, 174635, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4270.13720703125, -4231.92724609375, 6553.20703125, 3.232571840286254882, 7200, 0, 0, 6100, 100, 0, 0, 0, 0, 41793), -- Depleted Praetor (Area: -Unknown- - Difficulty: 0) (Auras: 201326 - Permanent Feign Death (Spawn, Untrackable, No Stun), 29266 - Permanent Feign Death) +(@CGUID+77, 166161, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4327.4912109375, -4265.74658203125, 6555.85205078125, 0, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Anima (Area: -Unknown- - Difficulty: 0) +(@CGUID+78, 166163, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4370.6005859375, -4256.56591796875, 6555.83984375, 0.238095119595527648, 7200, 0, 0, 73200, 1864, 0, 0, 0, 0, 41793), -- Centurion Goliath (Area: -Unknown- - Difficulty: 0) (Auras: 320712 - -Unknown-) +(@CGUID+79, 174794, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4270.31787109375, -4244.65625, 6552.10546875, 4.581229209899902343, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Steward (Area: -Unknown- - Difficulty: 0) (Auras: 309313 - -Unknown-) +(@CGUID+80, 166223, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4349.33154296875, -4256.705078125, 6555.83984375, 0, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Anima Canister (Area: -Unknown- - Difficulty: 0) +(@CGUID+81, 158504, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4368.42529296875, -4251.408203125, 6555.84033203125, 5.454096794128417968, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Steward (Area: -Unknown- - Difficulty: 0) +(@CGUID+82, 163974, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4036.796875, -5727.7275390625, 6592.32421875, 5.215366363525390625, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Purity Vesper (Area: -Unknown- - Difficulty: 0) (Auras: 327143 - -Unknown-) +(@CGUID+83, 166161, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4372.03662109375, -4259.8818359375, 6555.83984375, 0, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Anima (Area: -Unknown- - Difficulty: 0) +(@CGUID+84, 154631, 2222, 10534, 11013, '0', 0, 0, 0, 1, -4277.75537109375, -4259.86962890625, 6552.146484375, 2.685513496398925781, 7200, 0, 0, 294775, 100, 0, 0, 0, 0, 41793), -- Elysian Bulwark (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+85, 174794, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4408.109375, -4225.10791015625, 6552.10546875, 1.256108641624450683, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Steward (Area: -Unknown- - Difficulty: 0) (Auras: 314020 - -Unknown-) +(@CGUID+86, 158504, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4360.02978515625, -4266.59375, 6557.44775390625, 0.758761227130889892, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Steward (Area: -Unknown- - Difficulty: 0) +(@CGUID+87, 156228, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4269.328125, -4247.11279296875, 6552.43359375, 2.918255567550659179, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Aspirant (Area: -Unknown- - Difficulty: 0) +(@CGUID+88, 166161, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4330.21875, -4272.92041015625, 6555.83984375, 0, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Anima (Area: -Unknown- - Difficulty: 0) +(@CGUID+89, 174794, 2222, 10534, 11013, '0', 0, 0, 0, 1, -4345.93408203125, -4275.4150390625, 6557.3349609375, 3.735004663467407226, 7200, 10, 0, 6100, 0, 1, 0, 0, 0, 41793), -- Kyrian Steward (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+90, 174794, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4352.11474609375, -4274.55712890625, 6557.41845703125, 5.284432411193847656, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Steward (Area: -Unknown- - Difficulty: 0) +(@CGUID+91, 154630, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4340.67529296875, -4281.001953125, 6557.4033203125, 2.145615577697753906, 7200, 0, 0, 176865, 100, 0, 0, 0, 0, 41793), -- Elysian Guardian (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+92, 166161, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4343.27783203125, -4280.84033203125, 6557.41796875, 0, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Anima (Area: -Unknown- - Difficulty: 0) +(@CGUID+93, 154630, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4368.4150390625, -4273.4931640625, 6557.40283203125, 0.515967190265655517, 7200, 0, 0, 176865, 100, 0, 0, 0, 0, 41793), -- Elysian Guardian (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+94, 166161, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4366.62158203125, -4272.65087890625, 6557.41845703125, 0, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Anima (Area: -Unknown- - Difficulty: 0) +(@CGUID+95, 164370, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4166.32470703125, -5768.89404296875, 6703.50634765625, 4.567749500274658203, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Purity Vesper (Area: -Unknown- - Difficulty: 0) (Auras: 327142 - -Unknown-) +(@CGUID+96, 174794, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4407.296875, -4284.55224609375, 6552.1689453125, 4.085874557495117187, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Steward (Area: -Unknown- - Difficulty: 0) (Auras: 313123 - -Unknown-) +(@CGUID+97, 156228, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4435.3369140625, -4258.2900390625, 6556.23974609375, 0.227498382329940795, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Aspirant (Area: -Unknown- - Difficulty: 0) (Auras: 133464 - Read Scroll) +(@CGUID+98, 158329, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4433.02978515625, -4267.486328125, 6556.251953125, 0, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Visit Southeast Station (Area: -Unknown- - Difficulty: 0) +(@CGUID+99, 174666, 2222, 10534, 11013, '0', 0, 0, 0, 1, -4396.80029296875, -4313.48291015625, 6556.7666015625, 0.3157731294631958, 7200, 0, 0, 14149200, 52400, 0, 0, 0, 0, 41793), -- Kyrestia the Firstborne (Area: -Unknown- - Difficulty: 0) (Auras: 343156 - -Unknown-) +(@CGUID+100, 174676, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4336.88720703125, -4329.7275390625, 6553.1845703125, 3.570982217788696289, 7200, 0, 0, 1179100, 0, 0, 0, 0, 0, 42010), -- Thenios (Area: -Unknown- - Difficulty: 0) (Auras: 343156 - -Unknown-) +(@CGUID+101, 174794, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4438.927734375, -4262.810546875, 6556.15625, 0.94623953104019165, 7200, 10, 0, 6100, 0, 1, 0, 0, 0, 41793), -- Kyrian Steward (Area: -Unknown- - Difficulty: 0) (Auras: 310757 - -Unknown-) (possible waypoints or random movement) +(@CGUID+102, 156228, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4301.71337890625, -4338.189453125, 6554.8427734375, 0.47592926025390625, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Aspirant (Area: -Unknown- - Difficulty: 0) +(@CGUID+103, 156228, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4432.81591796875, -4277.8681640625, 6556.23974609375, 5.739529609680175781, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Aspirant (Area: -Unknown- - Difficulty: 0) (Auras: 133464 - Read Scroll) +(@CGUID+104, 158659, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4537.3994140625, -4282.24853515625, 6543.5703125, 0.129900470376014709, 7200, 0, 0, 24400, 100, 0, 0, 0, 0, 41793), -- Herculon (Area: -Unknown- - Difficulty: 0) (Auras: 320704 - -Unknown-, 119073 - Permanent Feign Death (Stun, Untrackable)) +(@CGUID+105, 174794, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4262.35400390625, -4298.87841796875, 6554.421875, 5.668157100677490234, 7200, 10, 0, 6100, 0, 1, 0, 0, 0, 41793), -- Kyrian Steward (Area: -Unknown- - Difficulty: 0) (Auras: 316394 - -Unknown-) (possible waypoints or random movement) +(@CGUID+106, 156228, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4292.79150390625, -4332.4755859375, 6554.32421875, 0.149141818284988403, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Aspirant (Area: -Unknown- - Difficulty: 0) +(@CGUID+108, 156228, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4273.23779296875, -4302.83837890625, 6553.45263671875, 4.812844276428222656, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Aspirant (Area: -Unknown- - Difficulty: 0) +(@CGUID+109, 174794, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4369.07470703125, -4332.09033203125, 6552.11767578125, 4.66277170181274414, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Steward (Area: -Unknown- - Difficulty: 0) (Auras: 314020 - -Unknown-) +(@CGUID+110, 156228, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4260.267578125, -4300.2431640625, 6554.34033203125, 4.30701446533203125, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Aspirant (Area: -Unknown- - Difficulty: 0) +(@CGUID+111, 174635, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4444.32470703125, -4284.22900390625, 6559.16796875, 1.357992172241210937, 7200, 0, 0, 6100, 100, 0, 0, 0, 0, 41793), -- Depleted Praetor (Area: -Unknown- - Difficulty: 0) (Auras: 201326 - Permanent Feign Death (Spawn, Untrackable, No Stun), 29266 - Permanent Feign Death) +(@CGUID+112, 157093, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4370.6005859375, -4256.56591796875, 6555.83984375, 0.238095119595527648, 7200, 0, 0, 73200, 1864, 0, 0, 0, 0, 41793), -- Centurion Goliath (Area: -Unknown- - Difficulty: 0) (Auras: 320712 - -Unknown-, 314842 - -Unknown-, 306346 - -Unknown-) +(@CGUID+113, 154630, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4448.75341796875, -4254.921875, 6559.16796875, 5.548104286193847656, 7200, 0, 0, 176865, 100, 0, 0, 0, 0, 41793), -- Elysian Guardian (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+114, 174794, 2222, 10534, 11013, '0', 0, 0, 0, 1, -4371.57958984375, -4362.02099609375, 6557.91845703125, 2.876597166061401367, 7200, 10, 0, 6100, 0, 1, 0, 0, 0, 41793), -- Kyrian Steward (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+115, 166166, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4354.1806640625, -4275.18408203125, 6557.41845703125, 1.285644173622131347, 7200, 0, 0, 1830000, 1864, 0, 0, 0, 0, 41793), -- Centurion Colossus (Area: -Unknown- - Difficulty: 0) (Auras: 320712 - -Unknown-) +(@CGUID+116, 174635, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4391.47900390625, -4356.2587890625, 6557.861328125, 0.992093563079833984, 7200, 0, 0, 6100, 100, 0, 0, 0, 0, 41793), -- Depleted Praetor (Area: -Unknown- - Difficulty: 0) (Auras: 201326 - Permanent Feign Death (Spawn, Untrackable, No Stun), 29266 - Permanent Feign Death) +(@CGUID+117, 166332, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4268.79541015625, -4324.26025390625, 6553.23291015625, 0, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Visit Northeast Station (Area: -Unknown- - Difficulty: 0) +(@CGUID+118, 154630, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4361.03466796875, -4364.861328125, 6557.8046875, 2.697628736495971679, 7200, 0, 0, 176865, 100, 0, 0, 0, 0, 41793), -- Elysian Guardian (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+119, 156228, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4289.60400390625, -4333.97216796875, 6553.8046875, 0.693373680114746093, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Aspirant (Area: -Unknown- - Difficulty: 0) +(@CGUID+120, 166165, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4330.0537109375, -4268.9375, 6555.92333984375, 2.02642059326171875, 7200, 0, 0, 73200, 1864, 0, 0, 0, 0, 41793), -- Centurion Goliath (Area: -Unknown- - Difficulty: 0) (Auras: 320712 - -Unknown-) +(@CGUID+121, 158599, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4255.95166015625, -4209.6943359375, 6551.19189453125, 0, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Visit Northwest Station (Area: -Unknown- - Difficulty: 0) +(@CGUID+122, 168397, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4469.8916015625, -4156.85498046875, 6589.7744140625, 0.451219946146011352, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 41793), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+123, 168397, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4423.98779296875, -4104.19091796875, 6583.07763671875, 0.060125350952148437, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 41793), -- Soulwing Flitter (Area: -Unknown- - Difficulty: 0) +(@CGUID+124, 159704, 2222, 10534, 11013, '0', 15190, 0, 0, 0, -4353.06591796875, -4251.79150390625, 6564.05615234375, 0.95115596055984497, 7200, 0, 0, 73200, 0, 0, 0, 0, 0, 41793), -- Ascended Champion (Area: -Unknown- - Difficulty: 0) +(@CGUID+125, 159704, 2222, 10534, 11013, '0', 15190, 0, 0, 0, -4342.689453125, -4254.4931640625, 6564.0654296875, 1.704015135765075683, 7200, 0, 0, 73200, 0, 0, 0, 0, 0, 41793), -- Ascended Champion (Area: -Unknown- - Difficulty: 0) +(@CGUID+126, 159704, 2222, 10534, 11013, '0', 15190, 0, 0, 0, -4334.9306640625, -4250.892578125, 6560.72607421875, 2.097420454025268554, 7200, 0, 0, 73200, 0, 0, 0, 0, 0, 41793), -- Ascended Champion (Area: -Unknown- - Difficulty: 0) +(@CGUID+127, 159704, 2222, 10534, 11013, '0', 15190, 0, 0, 0, -4357.34228515625, -4244.5380859375, 6560.72607421875, 0.532435119152069091, 7200, 0, 0, 73200, 0, 0, 0, 0, 0, 41793), -- Ascended Champion (Area: -Unknown- - Difficulty: 0) +(@CGUID+128, 166161, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4356.18212890625, -4281.26416015625, 6557.41845703125, 0, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Anima (Area: -Unknown- - Difficulty: 0) +(@CGUID+129, 154631, 2222, 10534, 11013, '0', 0, 0, 0, 1, -4419.98974609375, -4240.173828125, 6552.1640625, 5.518218040466308593, 7200, 0, 0, 294775, 100, 0, 0, 0, 0, 41793), -- Elysian Bulwark (Area: -Unknown- - Difficulty: 0) (Auras: ) +(@CGUID+130, 174636, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4410.23974609375, -4288.986328125, 6552.16455078125, 0.892083346843719482, 7200, 0, 0, 73200, 100, 0, 0, 0, 0, 41793), -- Depleted Goliath (Area: -Unknown- - Difficulty: 0) (Auras: 201326 - Permanent Feign Death (Spawn, Untrackable, No Stun), 314842 - -Unknown-) +(@CGUID+131, 174794, 2222, 10534, 11013, '0', 0, 0, 0, 1, -4407.158203125, -4286.97216796875, 6552.16015625, 4.733524799346923828, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Steward (Area: -Unknown- - Difficulty: 0) +(@CGUID+132, 174635, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4363.74658203125, -4314.515625, 6552.75830078125, 4.864284992218017578, 7200, 0, 0, 6100, 100, 0, 0, 0, 0, 41793), -- Depleted Praetor (Area: -Unknown- - Difficulty: 0) (Auras: 201326 - Permanent Feign Death (Spawn, Untrackable, No Stun), 29266 - Permanent Feign Death) +(@CGUID+133, 174794, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4291.87353515625, -3929.786376953125, 6561.404296875, 4.835690498352050781, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Steward (Area: -Unknown- - Difficulty: 0) (Auras: 314020 - -Unknown-) +(@CGUID+134, 174794, 2222, 10534, 11013, '0', 0, 0, 0, 0, -4361.23095703125, -4173.52978515625, 6552.10546875, 1.829863190650939941, 7200, 0, 0, 6100, 0, 0, 0, 0, 0, 41793), -- Kyrian Steward (Area: -Unknown- - Difficulty: 0) (Auras: 309313 - -Unknown-) +(@CGUID+135, 156228, 2222, 10534, 11013, '0', '0', 0, 0, 0, -4271.57275390625, -4246.67041015625, 6552.10546875, 5.968544483184814453, 120, 0, 0, 6100, 0, 0, 0, 0, 0, 42010); -- Kyrian Aspirant (Area: Vestibule of Eternity - Difficulty: 0) + +UPDATE `creature` SET `npcflag`=2, `unit_flags`=537166592, `unit_flags2`=2049, `unit_flags3`=8194 WHERE `guid` IN ((@CGUID+32), (@CGUID+26)); + +-- Creature Addon +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+135; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES +(@CGUID+26, 0, 0, 262144, 1, 0, 18797, 0, 0, '138767'), -- Greeter Mnemis - 138767 - Custom - Permanent Feign Death +(@CGUID+31, 0, 0, 0, 0, 0, 0, 0, 0, '313123'), -- Sika - 313123 - -Unknown- +(@CGUID+32, 0, 0, 262144, 1, 0, 18797, 0, 0, '138767'), -- Greeter Mnemis - 138767 - Custom - Permanent Feign Death +(@CGUID+41, 0, 0, 0, 0, 0, 0, 0, 0, '314020'), -- Kyrian Steward - 314020 - -Unknown- +(@CGUID+42, 0, 0, 0, 0, 0, 0, 0, 0, '314020'), -- Kyrian Steward - 314020 - -Unknown- +(@CGUID+52, 0, 0, 1, 1, 0, 0, 0, 0, ''), -- Kyrian Aspirant +(@CGUID+53, 0, 0, 0, 1, 882, 0, 0, 0, ''), -- Kyrian Aspirant +(@CGUID+56, 0, 0, 1, 1, 0, 0, 0, 0, ''), -- Kyrian Aspirant +(@CGUID+57, 0, 0, 0, 0, 0, 0, 0, 0, '313123'), -- Kyrian Steward - 313123 - -Unknown- +(@CGUID+58, 0, 0, 0, 0, 0, 0, 0, 0, '313115'), -- Kyrian Steward - 313115 - -Unknown- +(@CGUID+60, 0, 0, 0, 1, 0, 0, 0, 0, '338429'), -- Steward Caterer - 338429 - -Unknown- +(@CGUID+66, 0, 0, 1, 1, 0, 0, 0, 0, ''), -- Kyrian Aspirant +(@CGUID+79, 0, 0, 0, 0, 0, 0, 0, 0, '309313'), -- Kyrian Steward - 309313 - -Unknown- +(@CGUID+85, 0, 0, 0, 0, 0, 0, 0, 0, '314020'), -- Kyrian Steward - 314020 - -Unknown- +(@CGUID+87, 0, 0, 0, 1, 882, 0, 0, 0, ''), -- Kyrian Aspirant +(@CGUID+96, 0, 0, 0, 0, 0, 0, 0, 0, '313123'), -- Kyrian Steward - 313123 - -Unknown- +(@CGUID+97, 0, 0, 0, 1, 0, 0, 0, 0, '133464'), -- Kyrian Aspirant - 133464 - Read Scroll +(@CGUID+102, 0, 0, 0, 1, 732, 0, 0, 0, ''), -- Kyrian Aspirant +(@CGUID+103, 0, 0, 0, 1, 0, 0, 0, 0, '133464'), -- Kyrian Aspirant - 133464 - Read Scroll +(@CGUID+106, 0, 0, 8, 1, 0, 0, 0, 0, ''), -- Kyrian Aspirant +(@CGUID+108, 0, 0, 1, 1, 0, 0, 0, 0, ''), -- Kyrian Aspirant +(@CGUID+109, 0, 0, 0, 0, 0, 0, 0, 0, '314020'), -- Kyrian Steward - 314020 - -Unknown- +(@CGUID+110, 0, 0, 8, 1, 0, 0, 0, 0, ''), -- Kyrian Aspirant +(@CGUID+119, 0, 0, 1, 1, 0, 0, 0, 0, ''), -- Kyrian Aspirant +(@CGUID+133, 0, 0, 0, 0, 0, 0, 0, 0, '314020'), -- Kyrian Steward - 314020 - -Unknown- +(@CGUID+134, 0, 0, 0, 0, 0, 0, 0, 0, '309313'); -- Kyrian Steward - 309313 - -Unknown- + +-- creature_template_ data +UPDATE `creature_template` SET `gossip_menu_id`=25436, `npcflag`=3 WHERE `entry`=166227; -- Kleia +UPDATE `creature_template` SET `gossip_menu_id`=25439 WHERE `entry`=166124; -- Sika +UPDATE `creature_template` SET `gossip_menu_id`=24642, `npcflag`=3, `unit_flags`=33536, `unit_flags2`=2048, `unit_flags3`=2 WHERE `entry`=158281; -- Greeter Mnemis +UPDATE `creature_template` SET `unit_flags2`=0, `dynamicflags`=0 WHERE `entry`=166165; -- Centurion Goliath +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `unit_flags`=33587968 WHERE `entry`=174676; -- Thenios +UPDATE `creature_template` SET `minlevel`=63, `maxlevel`=63 WHERE `entry`=174666; -- Kyrestia the Firstborne +UPDATE `creature_template` SET `gossip_menu_id`=26243 WHERE `entry`=173057; -- Steward Caterer +UPDATE `creature_template` SET `gossip_menu_id`=26577 WHERE `entry`=174794; -- Kyrian Steward +UPDATE `creature_template` SET `gossip_menu_id`=26576 WHERE `entry`=158659; -- Herculon +UPDATE `creature_template` SET `gossip_menu_id`=26579 WHERE `entry`=156228; -- Kyrian Aspirant +UPDATE `creature_template` SET `gossip_menu_id`=26578 WHERE `entry`=158504; -- Kyrian Steward + +DELETE FROM `creature_template_addon` WHERE `entry` IN (158509, 158510, 159704, 158659, 174676, 170283, 166273, 166165, 166166, 157093, 174666, 164370, 163974, 166163, 156398, 174636, 154630, 174635, 166164, 154631); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES +(158509, 0, 0, 50331648, 1, 0, 0, 0, 0, ''), -- 158509 (Effervescent Glimmerfly) +(158510, 0, 0, 50331648, 1, 0, 0, 0, 0, ''), -- 158510 (Eternal Glimmerfly) +(159704, 0, 0, 50331648, 0, 0, 0, 0, 0, ''), -- 159704 (Ascended Champion) +(158659, 0, 0, 262144, 1, 0, 18608, 0, 0, '320704 119073'), -- 158659 (Herculon) - -Unknown-, Permanent Feign Death (Stun, Untrackable) +(174676, 0, 0, 50331648, 1, 0, 13118, 0, 0, '343156'), -- 174676 (Thenios) - -Unknown- +(170283, 0, 0, 50331648, 1, 0, 0, 0, 0, '312861'), -- 170283 (Tariesh) - -Unknown- +(166273, 0, 0, 0, 1, 0, 0, 0, 0, '324101'), -- 166273 (Image of Greeter Mnemis) - -Unknown- +(166165, 0, 0, 0, 1, 0, 20126, 0, 0, '320712'), -- 166165 (Centurion Goliath) - -Unknown- +(166166, 0, 0, 0, 1, 0, 0, 0, 0, '320712'), -- 166166 (Centurion Colossus) - -Unknown- +(157093, 0, 0, 262144, 1, 0, 0, 0, 0, '320712 314842 306346'), -- 157093 (Centurion Goliath) - -Unknown-, -Unknown-, -Unknown- +(174666, 0, 0, 50331648, 1, 0, 8800, 0, 0, '343156'), -- 174666 (Kyrestia the Firstborne) - -Unknown- +(164370, 0, 0, 0, 1, 0, 0, 0, 0, '327142'), -- 164370 (Purity Vesper) - -Unknown- +(163974, 0, 0, 0, 1, 0, 0, 0, 0, '327143'), -- 163974 (Purity Vesper) - -Unknown- +(166163, 0, 0, 0, 1, 0, 18742, 0, 0, '320712'), -- 166163 (Centurion Goliath) - -Unknown- +(156398, 0, 0, 0, 1, 0, 0, 0, 0, '320712'), -- 156398 (Centurion Goliath) - -Unknown- +(174636, 0, 0, 262144, 1, 0, 0, 0, 0, '201326 314842'), -- 174636 (Depleted Goliath) - Permanent Feign Death (Spawn, Untrackable, No Stun), -Unknown- +(154630, 0, 0, 1, 257, 0, 0, 0, 0, ''), -- 154630 (Elysian Guardian) +(174635, 0, 0, 262144, 1, 0, 18797, 0, 0, '201326 29266'), -- 174635 (Depleted Praetor) - Permanent Feign Death (Spawn, Untrackable, No Stun), Permanent Feign Death +(166164, 0, 0, 0, 1, 0, 0, 0, 0, '320712'), -- 166164 (Centurion Colossus) - -Unknown- +(154631, 0, 0, 0, 257, 0, 0, 0, 0, ''); -- 154631 (Elysian Bulwark) + +UPDATE `creature_template_addon` SET `visibilityDistanceType`=5 WHERE `entry`=163974; -- 163974 (Purity Vesper) - -Unknown- +UPDATE `creature_template_addon` SET `visibilityDistanceType`=3 WHERE `entry`=158659; -- 158659 (Herculon) - -Unknown-, Permanent Feign Death (Stun, Untrackable) +UPDATE `creature_template_addon` SET `aiAnimKit`=11860 WHERE `entry`=166165; -- 166165 (Centurion Goliath) - -Unknown- +UPDATE `creature_template_addon` SET `visibilityDistanceType`=5 WHERE `entry`=164370; -- 164370 (Purity Vesper) - -Unknown- +UPDATE `creature_template_addon` SET `visibilityDistanceType`=4 WHERE `entry`=166166; -- 166166 (Centurion Colossus) - -Unknown- + +-- Creature Movement +DELETE FROM `creature_template_movement` WHERE `CreatureId` IN (158509, 158510, 166306, 159704, 174666, 170283); +INSERT INTO `creature_template_movement`(`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`) VALUES +(158509, 1, 1, 1, 0, 0, 0), +(158510, 1, 1, 1, 0, 0, 0), +(166306, 1, 1, 1, 0, 0, 0), +(159704, 1, 1, 1, 0, 0, 0), +(174666, 1, 1, 1, 0, 0, 0), +(170283, 1, 0, 0, 0, 0, 0); + +-- GameObject Spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+42; +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, 354926, 2222, 10534, 11013, '0', 0, 0, -3772.78466796875, -2946.366455078125, 6675.61279296875, 1.22173166275024414, 0, 0, 0.573576927185058593, 0.819151699542999267, 7200, 255, 1, 41793), -- Gateway (Area: -Unknown- - Difficulty: 0) +(@OGUID+1, 353378, 2222, 10534, 11013, '0', 0, 0, -4196.205078125, -3955.94091796875, 6564.42041015625, 6.027167320251464843, 0, 0, -0.12765979766845703, 0.991818010807037353, 7200, 255, 1, 41793), -- Spirit Obelisk (Area: -Unknown- - Difficulty: 0) +(@OGUID+2, 349888, 2222, 10534, 11013, '0', 0, 0, -4261.90625, -4200.27783203125, 6550.8955078125, 6.102933406829833984, 0, 0, -0.09000396728515625, 0.995941400527954101, 7200, 255, 1, 41793), -- Bench (Area: -Unknown- - Difficulty: 0) +(@OGUID+3, 349525, 2222, 10534, 11013, '0', 0, 0, -4257.52099609375, -4200.4931640625, 6550.8955078125, 6.059298992156982421, 0, 0, -0.1117095947265625, 0.99374091625213623, 7200, 255, 1, 41793), -- Bench (Area: -Unknown- - Difficulty: 0) +(@OGUID+4, 358544, 2222, 10534, 11013, '0', 0, 0, -4247.1806640625, -4193.1181640625, 6552.0556640625, 4.122488021850585937, 0, 0, -0.88212203979492187, 0.471020907163619995, 7200, 255, 1, 41793), -- Journey Toward Ascension: The Aspirant's Crucible (Area: -Unknown- - Difficulty: 0) +(@OGUID+5, 335698, 2222, 10534, 11013, '0', 0, 0, -4406.1162109375, -4171.43603515625, 6556.34375, 5.585768699645996093, 0, 0, -0.34168434143066406, 0.939814746379852294, 7200, 255, 1, 41793), -- Pure Thought Vesper (Area: -Unknown- - Difficulty: 0) +(@OGUID+6, 349898, 2222, 10534, 11013, '0', 0, 0, -4234.33349609375, -4182.63916015625, 6578.91650390625, 0.028909223154187202, -0.0029306411743164, -0.09013748168945312, 0.014012336730957031, 0.995826423168182373, 7200, 255, 1, 41793), -- Laestrite Deposit (Area: -Unknown- - Difficulty: 0) +(@OGUID+7, 349527, 2222, 10534, 11013, '0', 0, 0, -4252.359375, -4201.6318359375, 6550.8955078125, 6.102933406829833984, 0, 0, -0.09000396728515625, 0.995941400527954101, 7200, 255, 1, 41793), -- Bench (Area: -Unknown- - Difficulty: 0) +(@OGUID+8, 349523, 2222, 10534, 11013, '0', 0, 0, -4257.40283203125, -4210.8681640625, 6550.98388671875, 0.395704030990600585, 0, 0, 0.196563720703125, 0.980491042137145996, 7200, 255, 1, 41793), -- Bench (Area: -Unknown- - Difficulty: 0) +(@OGUID+9, 349887, 2222, 10534, 11013, '0', 0, 0, -4261.76220703125, -4212.66845703125, 6550.8955078125, 0.395704030990600585, 0, 0, 0.196563720703125, 0.980491042137145996, 7200, 255, 1, 41793), -- Bench (Area: -Unknown- - Difficulty: 0) +(@OGUID+10, 349528, 2222, 10534, 11013, '0', 0, 0, -4252.5556640625, -4209.4375, 6550.95751953125, 0.395704030990600585, 0, 0, 0.196563720703125, 0.980491042137145996, 7200, 255, 1, 41793), -- Bench (Area: -Unknown- - Difficulty: 0) +(@OGUID+11, 358537, 2222, 10534, 11013, '0', 0, 0, -4409.2431640625, -4219.9931640625, 6553.01708984375, 5.528980731964111328, 0, 0, -0.36822795867919921, 0.929735541343688964, 7200, 255, 1, 41793), -- Roles In Bastion: The Watcher (Area: -Unknown- - Difficulty: 0) +(@OGUID+12, 358535, 2222, 10534, 11013, '0', 0, 0, -4402.49658203125, -4212.30224609375, 6552.99072265625, 5.754353046417236328, 0, 0, -0.26134586334228515, 0.965245187282562255, 7200, 255, 1, 41793), -- Roles In Bastion: The Collector (Area: -Unknown- - Difficulty: 0) +(@OGUID+13, 349889, 2222, 10534, 11013, '0', 0, 0, -4255.46337890625, -4222.54150390625, 6550.8955078125, 0.814583063125610351, 0, 0, 0.396123886108398437, 0.918197095394134521, 7200, 255, 1, 41793), -- Bench (Area: -Unknown- - Difficulty: 0) +(@OGUID+14, 349508, 2222, 10534, 11013, '0', 0, 0, -4349.23291015625, -4256.69970703125, 6555.75634765625, 0, 0, 0, 0, 1, 7200, 255, 0, 41793), -- Anima Canister (Area: -Unknown- - Difficulty: 0) +(@OGUID+15, 358545, 2222, 10534, 11013, '0', 0, 0, -4243.60400390625, -4205.7255859375, 6552.759765625, 3.526241540908813476, 0, 0, -0.98156261444091796, 0.191140905022621154, 7200, 255, 1, 41793), -- Journey Toward Ascension: The Five Rites (Area: -Unknown- - Difficulty: 0) +(@OGUID+16, 349524, 2222, 10534, 11013, '0', 0, 0, -4247.60595703125, -4215.48095703125, 6550.8955078125, 0.814583063125610351, 0, 0, 0.396123886108398437, 0.918197095394134521, 7200, 255, 1, 41793), -- Bench (Area: -Unknown- - Difficulty: 0) +(@OGUID+17, 358538, 2222, 10534, 11013, '0', 0, 0, -4404.359375, -4211.3369140625, 6551.4443359375, 5.761508941650390625, 0, 0, -0.25789070129394531, 0.966174066066741943, 7200, 255, 1, 41793), -- [DNT] Statue Base (Area: -Unknown- - Difficulty: 0) +(@OGUID+18, 349526, 2222, 10534, 11013, '0', 0, 0, -4252.07275390625, -4219.4375, 6550.8955078125, 0.814583063125610351, 0, 0, 0.396123886108398437, 0.918197095394134521, 7200, 255, 1, 41793), -- Bench (Area: -Unknown- - Difficulty: 0) +(@OGUID+19, 358538, 2222, 10534, 11013, '0', 0, 0, -4410.6474609375, -4218.4912109375, 6551.4443359375, 5.516196250915527343, 0, 0, -0.37416362762451171, 0.927362680435180664, 7200, 255, 1, 41793), -- [DNT] Statue Base (Area: -Unknown- - Difficulty: 0) +(@OGUID+20, 358542, 2222, 10534, 11013, '0', 0, 0, -4404.15478515625, -4211.1630859375, 6552.28759765625, 5.74442291259765625, 0, 0, -0.26613521575927734, 0.963935673236846923, 7200, 255, 1, 41793), -- [DNT] Collector Statue (Area: -Unknown- - Difficulty: 0) +(@OGUID+21, 358546, 2222, 10534, 11013, '0', 0, 0, -4239.189453125, -4218.50537109375, 6552.0556640625, 2.684284448623657226, 0, 0, 0.973972320556640625, 0.22666691243648529, 7200, 255, 1, 41793), -- Journey Toward Ascension: The Final Rite (Area: -Unknown- - Difficulty: 0) +(@OGUID+22, 358538, 2222, 10534, 11013, '0', 0, 0, -4416.42529296875, -4225.25537109375, 6551.48486328125, 5.728654861450195312, 0, 0, -0.27372646331787109, 0.961807548999786376, 7200, 255, 1, 41793), -- [DNT] Statue Base (Area: -Unknown- - Difficulty: 0) +(@OGUID+23, 358540, 2222, 10534, 11013, '0', 0, 0, -4410.77978515625, -4218.26220703125, 6552.69873046875, 5.509294986724853515, 0, 0, -0.37736129760742187, 0.926066100597381591, 7200, 255, 1, 41793), -- [DNT] Watcher Statue (Area: -Unknown- - Difficulty: 0) +(@OGUID+24, 358536, 2222, 10534, 11013, '0', 0, 0, -4414.736328125, -4226.265625, 6553.06298828125, 5.725128173828125, 0, 0, -0.2754220962524414, 0.961323380470275878, 7200, 255, 1, 41793), -- Roles In Bastion: The Bearer (Area: -Unknown- - Difficulty: 0) +(@OGUID+25, 358541, 2222, 10534, 11013, '0', 0, 0, -4416.52978515625, -4225.376953125, 6552.77490234375, 5.743532180786132812, 0, 0, -0.26656436920166015, 0.963817119598388671, 7200, 255, 1, 41793), -- [DNT] Bearer Statue (Area: -Unknown- - Difficulty: 0) +(@OGUID+26, 335697, 2222, 10534, 11013, '0', 0, 0, -4431.6005859375, -4258.85595703125, 6558.0947265625, 0.903828561305999755, 0, 0, 0.436688423156738281, 0.899612843990325927, 7200, 255, 1, 41793), -- Compendium of Arrival (Area: -Unknown- - Difficulty: 0) +(@OGUID+27, 335697, 2222, 10534, 11013, '0', 0, 0, -4434.00341796875, -4253.625, 6558.0947265625, 0.172211706638336181, 0, 0, 0.085999488830566406, 0.996295154094696044, 7200, 255, 1, 41793), -- Compendium of Arrival (Area: -Unknown- - Difficulty: 0) +(@OGUID+28, 358534, 2222, 10534, 11013, '0', 0, 0, -4394.6025390625, -4312.703125, 6553.5458984375, 0.311930149793624877, 0, 0, 0.155333518981933593, 0.987862110137939453, 7200, 255, 1, 41793), -- The Archon (Area: -Unknown- - Difficulty: 0) +(@OGUID+29, 358538, 2222, 10534, 11013, '0', 0, 0, -4396.67041015625, -4313.29541015625, 6551.47119140625, 0.307829827070236206, 0, 0, 0.153307914733886718, 0.988178491592407226, 7200, 255, 1, 41793), -- [DNT] Statue Base (Area: -Unknown- - Difficulty: 0) +(@OGUID+30, 358532, 2222, 10534, 11013, '0', 0, 0, -4338.501953125, -4328.13916015625, 6553.27197265625, 2.457208633422851562, 0, 0, 0.942021369934082031, 0.335552871227264404, 7200, 255, 1, 41793), -- The Paragons (Area: -Unknown- - Difficulty: 0) +(@OGUID+31, 358538, 2222, 10534, 11013, '0', 0, 0, -4336.90625, -4329.55908203125, 6551.541015625, 2.416913270950317382, 0, 0, 0.935070037841796875, 0.354463011026382446, 7200, 255, 1, 41793), -- [DNT] Statue Base (Area: -Unknown- - Difficulty: 0) +(@OGUID+32, 336427, 2222, 10534, 11013, '0', 0, 0, -4440.51416015625, -4282.5625, 6556.16259765625, 5.172155380249023437, 0, 0, -0.52738094329833984, 0.849628925323486328, 7200, 255, 1, 41793), -- Depleted Anima Canister (Area: -Unknown- - Difficulty: 0) +(@OGUID+33, 336427, 2222, 10534, 11013, '0', 0, 0, -4444.2880859375, -4254.88916015625, 6556.16259765625, 0, 0, 0, 0, 1, 7200, 255, 1, 41793), -- Depleted Anima Canister (Area: -Unknown- - Difficulty: 0) +(@OGUID+34, 336427, 2222, 10534, 11013, '0', 0, 0, -4446.20166015625, -4253.34033203125, 6556.40478515625, 0, 0, 0, 0, 1, 7200, 255, 1, 41793), -- Depleted Anima Canister (Area: -Unknown- - Difficulty: 0) +(@OGUID+35, 336427, 2222, 10534, 11013, '0', 0, 0, -4438.97412109375, -4282.47412109375, 6556.15966796875, 1.8974151611328125, 0, 0, 0.812663078308105468, 0.582733869552612304, 7200, 255, 1, 41793), -- Depleted Anima Canister (Area: -Unknown- - Difficulty: 0) +(@OGUID+36, 336427, 2222, 10534, 11013, '0', 0, 0, -4446.17529296875, -4280.796875, 6556.1875, 0.998009443283081054, 0, 0, 0.478551864624023437, 0.878059267997741699, 7200, 255, 1, 41793), -- Depleted Anima Canister (Area: -Unknown- - Difficulty: 0) +(@OGUID+37, 336427, 2222, 10534, 11013, '0', 0, 0, -4449.26025390625, -4258.6962890625, 6556.15625, 0, 0, 0, 0, 1, 7200, 255, 1, 41793), -- Depleted Anima Canister (Area: -Unknown- - Difficulty: 0) +(@OGUID+38, 336690, 2222, 10534, 11013, '0', 0, 0, -4172.40625, -4160.75341796875, 6582.76025390625, 0.440140038728713989, 0, 0, 0.218297958374023437, 0.975882172584533691, 7200, 255, 1, 41793), -- Rising Glory (Area: -Unknown- - Difficulty: 0) +(@OGUID+39, 336691, 2222, 10534, 11013, '0', 0, 0, -4487.2724609375, -4282.7587890625, 6602.25146484375, 0, 0, 0, 0, 1, 7200, 255, 1, 41793), -- Nightshade (Area: -Unknown- - Difficulty: 0) +(@OGUID+40, 336427, 2222, 10534, 11013, '0', 0, 0, -4517.453125, -4264.705078125, 6543.48681640625, 0, 0, 0, 0, 1, 7200, 255, 1, 41793), -- Depleted Anima Canister (Area: -Unknown- - Difficulty: 0) +(@OGUID+41, 336427, 2222, 10534, 11013, '0', 0, 0, -4517.783203125, -4263.05224609375, 6543.5556640625, 0, 0, 0, 0, 1, 7200, 255, 1, 41793), -- Depleted Anima Canister (Area: -Unknown- - Difficulty: 0) +(@OGUID+42, 336427, 2222, 10534, 11013, '0', 0, 0, -4514.73779296875, -4301.8974609375, 6544.4287109375, 0, 0, 0, 0, 1, 7200, 255, 1, 41793); -- Depleted Anima Canister (Area: -Unknown- - Difficulty: 0) + +-- GameObject Template +DELETE FROM `gameobject_template_addon` WHERE `entry` IN (336691 /*Nightshade*/, 336690 /*Rising Glory*/, 335697 /*Compendium of Arrival*/, 349508 /*Anima Canister*/, 349898 /*Laestrite Deposit*/, 335698 /*Pure Thought Vesper*/, 353378 /*Spirit Obelisk*/, 354926 /*Gateway*/); +INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`) VALUES +(336691, 0, 278528, 0, 0), -- Nightshade +(336690, 0, 278528, 0, 0), -- Rising Glory +(335697, 0, 262144, 0, 0), -- Compendium of Arrival +(349508, 0, 262145, 0, 0), -- Anima Canister +(349898, 94, 278528, 0, 0), -- Laestrite Deposit +(335698, 0, 262144, 0, 0), -- Pure Thought Vesper +(353378, 0, 32, 0, 0), -- Spirit Obelisk +(354926, 0, 1048608, 0, 0); -- Gateway + +-- Quest stuff +DELETE FROM `quest_details` WHERE `ID` IN (59774, 57102, 57584, 60735, 57261); +INSERT INTO `quest_details` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `VerifiedBuild`) VALUES +(59774, 1, 1, 0, 0, 0, 0, 0, 0, 41488), -- Welcome to Eternity +(57102, 1, 1, 0, 0, 0, 0, 0, 0, 41488), -- Pardon Our Dust +(57584, 1, 1, 1, 0, 0, 0, 0, 0, 41793), -- A Fate Most Noble +(60735, 1, 1, 1, 0, 0, 0, 0, 0, 41793), -- Trouble in Paradise +(57261, 669, 669, 0, 0, 0, 0, 0, 0, 41793); -- Walk the Path; Aspirant + +DELETE FROM `quest_offer_reward` WHERE `ID` IN (59773, 59774, 57102, 57584, 60735); +INSERT INTO `quest_offer_reward` (`ID`, `Emote1`, `Emote2`, `Emote3`, `Emote4`, `EmoteDelay1`, `EmoteDelay2`, `EmoteDelay3`, `EmoteDelay4`, `RewardText`, `VerifiedBuild`) VALUES +(59773, 273, 0, 0, 0, 0, 0, 0, 0, 'The way is open again! Archon be praised!', 41488), -- Seek the Ascended +(59774, 273, 0, 0, 0, 0, 0, 0, 0, 'The Greeter will soon answer all of your questions. That is its purpose, after all.\n\n<Kleia smiles at you.>\n\nI hope you are excited. I certainly am!', 41488), -- Welcome to Eternity +(57102, 273, 0, 0, 0, 0, 0, 0, 0, '<The centurion emits a soft chime.>', 41488), -- Pardon Our Dust +(57584, 1, 0, 0, 0, 0, 0, 0, 0, 'I hope that was informative and relaxing.', 41793), -- A Fate Most Noble +(60735, 669, 0, 0, 0, 0, 0, 0, 0, '<Kalisthene peers down at you.>\n\nWe have heard you, mortal.', 41793); -- Trouble in Paradise + +DELETE FROM `quest_request_items` WHERE `ID`=57102; +INSERT INTO `quest_request_items` (`ID`, `EmoteOnComplete`, `EmoteOnIncomplete`, `EmoteOnCompleteDelay`, `EmoteOnIncompleteDelay`, `CompletionText`, `VerifiedBuild`) VALUES +(57102, 0, 0, 0, 0, '<The centurion is unresponsive.>', 41488); -- Pardon Our Dust + +DELETE FROM `creature_queststarter` WHERE `id` IN (166227, 165107, 158281, 166306) AND `quest` IN (59774, 57102, 57584, 60735, 57261); +INSERT INTO `creature_queststarter`(`id`, `quest`) VALUES +(166227, 59774), +(165107, 57102), +(158281, 57584), +(165107, 60735), +(166306, 57261); + +DELETE FROM `creature_questender` WHERE `id` IN (166227, 165107, 158281, 166306) AND `quest` IN (59773, 59774, 57102, 57584, 60735, 57261); +INSERT INTO `creature_questender`(`id`, `quest`) VALUES +(166227, 59773), +(165107, 59774), +(158281, 57102), +(165107, 57584), +(166306, 60735), +(165107, 57261); + +DELETE FROM `quest_template_addon` WHERE `ID` IN (59774, 57102, 57584, 60735, 57261); +INSERT INTO `quest_template_addon`(`ID`, `MaxLevel`, `AllowableClasses`, `SourceSpellID`, `PrevQuestID`, `NextQuestID`, `ExclusiveGroup`, `BreadcrumbForQuestId`, `RewardMailTemplateID`, `RewardMailDelay`, `RequiredSkillID`, `RequiredSkillPoints`, `RequiredMinRepFaction`, `RequiredMaxRepFaction`, `RequiredMinRepValue`, `RequiredMaxRepValue`, `ProvidedItemCount`, `SpecialFlags`, `ScriptName`) VALUES +(59774, 0, 0, 0, 59773, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(57102, 0, 0, 0, 59774, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(57584, 0, 0, 0, 57102, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(60735, 0, 0, 0, 57584, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), +(57261, 0, 0, 0, 60735, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''); + +-- Gossip stuff +DELETE FROM `gossip_menu` WHERE (`MenuID` =25436 AND `TextID` =40132) OR (`MenuID` =25439 AND `TextID` =40137) OR (`MenuID` =24642 AND `TextID` =38738) OR (`MenuID` =25892 AND `TextID` =40946) OR (`MenuID` =26606 AND `TextID` =42349) OR (`MenuID` =26605 AND `TextID` =42348) OR (`MenuID` =25476 AND `TextID` =40213) OR (`MenuID` =25475 AND `TextID` =40212) OR (`MenuID` =24644 AND `TextID` =38740) OR (`MenuID` =25439 AND `TextID` =42294) OR (`MenuID` =25436 AND `TextID` IN (39182,41070)) OR (`MenuID` =26577 AND `TextID` =42252) OR (`MenuID` =26243 AND `TextID` =41670) OR (`MenuID` =26576 AND `TextID` =42251) OR (`MenuID` =26579 AND `TextID` =42255) OR (`MenuID`=26578 AND `TextID`=42253); +INSERT INTO `gossip_menu` (`MenuID` , `TextID` , `VerifiedBuild`) VALUES +(25436, 40132, 41488), -- 166227 (Kleia) +(25439, 40137, 41793), -- 166124 (Sika) +(24642, 38738, 41793), -- 158281 (Greeter Mnemis) +(25892, 40946, 41793), -- 158281 (Greeter Mnemis) +(26606, 42349, 41793), -- 158281 (Greeter Mnemis) +(26605, 42348, 41793), -- 158281 (Greeter Mnemis) +(25476, 40213, 41793), -- 158281 (Greeter Mnemis) +(25475, 40212, 41793), -- 158281 (Greeter Mnemis) +(24644, 38740, 41793), -- 158281 (Greeter Mnemis) +(25439, 42294, 41793), -- 166124 (Sika) +(25436, 39182, 41793), -- 165107 (Kleia) +(25436, 41070, 41793), -- 165107 (Kleia) +(26577, 42252, 42010), -- 174794 +(26243, 41670, 42010), -- 173057 +(26576, 42251, 42010), -- 158659 (Herculon) +(26579, 42255, 42010), -- 156228 (Kyrian Aspirant) +(26578, 42253, 42010); -- 158504 (Kyrian Steward) + +DELETE FROM `gossip_menu_option` WHERE (`MenuID` =25436 AND `OptionID`=0) OR (`MenuID` =24642 AND `OptionID` IN (0, 1)) OR (`MenuID` =25892 AND `OptionID` IN (0, 1, 2, 3, 4)) OR (`MenuID` =26606 AND `OptionID`=0) OR (`MenuID` =26605 AND `OptionID`=0) OR (`MenuID` =25476 AND `OptionID`=0) OR (`MenuID` =25475 AND `OptionID` IN (0, 1)) OR (`MenuID` =24644 AND `OptionID` =0) OR (`MenuID` =25436 AND `OptionID` =1) OR (`MenuID` =26243 AND `OptionID` =0); +INSERT INTO `gossip_menu_option`(`MenuID` , `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextId`, `OptionType`, `OptionNpcFlag`, `ActionMenuId`, `VerifiedBuild`) VALUES +(25436, 0, 0, 'Lead on, Kleia.', 0, 1, 3, 0, 41488), +(24642, 1, 0, 'I have some questions.', 0, 1, 1, 25892, 41793), +(24642, 0, 0, 'I think there might have been a mistake.', 0, 1, 1, 0, 41793), +(25892, 4, 0, 'Never mind.', 0, 1, 1, 24642, 41793), +(25892, 3, 0, 'What can you tell me about centurions?', 0, 1, 1, 26606, 41793), +(25892, 2, 0, 'What are these little owl-things?', 0, 1, 1, 26605, 41793), +(25892, 1, 0, 'What is your purpose?', 133811, 1, 1, 25475, 41793), -- OptionBroadcastTextID: 133811 - 198913 +(25892, 0, 0, 'What can you tell me about Bastion?', 0, 1, 1, 24644, 41793), +(26606, 0, 0, 'I have something else to ask.', 0, 1, 1, 25892, 41793), +(26605, 0, 0, 'I have something else to ask.', 0, 1, 1, 25892, 41793), +(25476, 0, 0, 'I have something else to ask.', 0, 1, 1, 25892, 41793), +(25475, 1, 0, 'I have something else to ask.', 0, 1, 1, 0, 41793), +(25475, 0, 0, 'Who is the Archon?', 0, 1, 1, 25476, 41793), +(24644, 0, 0, 'I have something else to ask.', 0, 1, 1, 25892, 41793), +(25436, 1, 0, '<Tell Kleia what you saw in the Maw.>', 0, 1, 1, 0, 41793), +(26243, 0, 0, '<Take a drink from the tray.>', 0, 1, 1, 0, 42010); + +-- Phasing +DELETE FROM `phase_area` WHERE `AreaId` = 11013 AND `PhaseId` IN (14024, 14027, 15180, 15181, 14025, 14026, 15895, 15935, 15190); +INSERT INTO `phase_area`(`AreaId`, `PhaseId`, `Comment`) VALUES +(11013, 14024, 'Bastion - Chapter 1 - Kleia init spawn'), +(11013, 14027, 'Bastion - Chapter 1 - Kleia after Quest 59774 is complete'), +(11013, 15180, 'Bastion - Chapter 1 - Sika init spawn'), +(11013, 15181, 'Bastion - Chapter 1 - Sika after Quest 57102 IS complete/rewarded'), +(11013, 14025, 'Bastion - Chapter 1 - Greeter Mnemis init spawn'), +(11013, 14026, 'Bastion - Chapter 1 - Greeter Mnemis after Quest 57584 Is rewarded'), +(11013, 15895, 'Bastion - Chapter 1 - Kleia while Quest 57584 IS taken'), +(11013, 15935, 'Bastion - Chapter 1 - Greeter Mnemis Final Phase after Quest'), +(11013, 15190, 'Bastion - Chapter 1 - Kalisthene init spawn'); + +-- Conditions Phasing / Gossips +DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId` = 26 AND `SourceGroup` = 14024 AND `SourceEntry` = 11013) OR (`SourceTypeOrReferenceId` = 26 AND `SourceGroup` = 14027 AND `SourceEntry` = 11013) OR (`SourceTypeOrReferenceId` = 15 AND `SourceGroup` = 25436 AND `SourceEntry` IN (0, 1)) OR (`SourceTypeOrReferenceId` = 26 AND `SourceGroup` = 15180 AND `SourceEntry` = 11013) OR (`SourceTypeOrReferenceId` = 26 AND `SourceGroup` = 15181 AND `SourceEntry` = 11013) OR (`SourceTypeOrReferenceId` = 26 AND `SourceGroup` = 14025 AND `SourceEntry` = 11013) OR (`SourceTypeOrReferenceId` = 26 AND `SourceGroup` = 14026 AND `SourceEntry` = 11013) OR (`SourceTypeOrReferenceId` = 15 AND `SourceGroup` = 24642 AND `SourceEntry` = 0) OR (`SourceTypeOrReferenceId` = 26 AND `SourceGroup` = 15895 AND `SourceEntry` = 11013) OR (`SourceTypeOrReferenceId` = 26 AND `SourceGroup` = 15935 AND `SourceEntry` = 11013) OR (`SourceTypeOrReferenceId` = 26 AND `SourceGroup` = 15190 AND `SourceEntry` = 11013); +INSERT INTO `conditions`(`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +-- Kleia init. spawn Phasing +(26, 14024, 11013, 0, 0, 47, 0, 59773, 66, 0, 0, 0, 0, '', 'Allow Phase 14024 if Quest 59773 IS complete/rewarded'), +(26, 14024, 11013, 0, 0, 47, 0, 59774, 66, 0, 1, 0, 0, '', 'Allow Phase 14024 if Quest Quest 59774 IS NOT complete/rewarded'), +-- Kleia after Quest 59774 is complete +(26, 14027, 11013, 0, 0, 47, 0, 59774, 66, 0, 0, 0, 0, '', 'Allow Phase 14027 if Quest 59774 IS complete/rewarded'), +(26, 14027, 11013, 0, 0, 48, 0, 392770, 0, 1, 1, 0, 0, '', 'Allow Phase 14027 if Quest Credit 392770 IS NOT rewarded'), +(26, 14027, 11013, 0, 0, 47, 0, 57584, 64, 0, 1, 0, 0, '', 'Allow Phase 14027 if Quest 59774 IS NOT complete/rewarded'), +(26, 14027, 11013, 0, 1, 47, 0, 57584, 66, 0, 0, 0, 0, '', 'OR Allow Phase 14027 if Quest 57584 IS complete/rewarded'), +(26, 14027, 11013, 0, 1, 48, 0, 404742, 0, 1, 1, 0, 0, '', 'OR Allow Phase 14027 if Quest Credit 404742 IS NOT rewarded'), +(26, 14027, 11013, 0, 1, 47, 0, 60735, 66, 0, 1, 0, 0, '', 'OR Allow Phase 14027 if Quest 60735 IS NOT complete/rewarded'), +-- Kleia Gossip +(15, 25436, 0, 0, 0, 9, 0, 59774, 0, 0, 0, 0, 0, '', 'Allow Gossip Menu 25436 0 if Quest 59774 IS taken'), +(15, 25436, 0, 0, 0, 48, 0, 396925, 0, 1, 1, 0, 0, '', 'Allow Gossip Menu 25436 0 if Quest Credit 396925 IS NOT rewarded'), +(15, 25436, 1, 0, 0, 9, 0, 60735, 0, 0, 0, 0, 0, '', 'Allow Gossip Menu if Quest 60735 IS taken'), +-- Sika Phasing +(26, 15180, 11013, 0, 0, 47, 0, 59773, 66, 0, 0, 0, 0, '', 'Allow Phase 15180 if Quest 59773 IS complete/rewarded'), +(26, 15180, 11013, 0, 0, 47, 0, 57102, 66, 0, 1, 0, 0, '', 'Allow Phase 15180 if Quest 57102 IS NOT complete/rewarded'), +-- Sika Phase after 57102 is rewarded +(26, 15181, 11013, 0, 0, 47, 0, 57102, 66, 0, 0, 0, 0, '', 'Allow Phase 15181 if Quest 57102 IS complete/rewarded'), +(26, 15181, 11013, 0, 0, 48, 0, 404742, 0, 1, 1, 0, 0, '', 'Allow Phase 15181 if Questcredit 404742 IS NOT rewarded'), +(26, 15181, 11013, 0, 0, 47, 0, 60735, 66, 0, 1, 0, 0, '', 'Allow Phase 15181 if Quest 60735 IS NOT complete/rewarded'), +-- Greeter Mnemis Phasing +(26, 14025, 11013, 0, 0, 47, 0, 59773, 66, 0, 0, 0, 0, '', 'Allow Phase 14025 if Quest 59773 IS complete/rewarded'), +(26, 14025, 11013, 0, 0, 8, 0, 57102, 0, 0, 1, 0, 0, '', 'Allow Phase 14025 if Quest 57102 IS NOT complete/rewarded'), +-- Greeter Mnemis (Alive Phase) +(26, 14026, 11013, 0, 0, 8, 0, 57102, 0, 0, 0, 0, 0, '', 'Allow Phase 14026 if Quest 57102 IS rewarded'), +(26, 14026, 11013, 0, 0, 48, 0, 404742, 0, 1, 1, 0, 0, '', 'Allow Phase 15935 if Quest Credit 404742 IS NOT rewarded'), +-- Greeter Mnemis Gossip +(15, 24642, 0, 0, 0, 9, 0, 57584, 0, 0, 0, 0, 0, '', 'Allow Gossip Menu if Quest 57584 IS taken'), +(15, 24642, 0, 0, 0, 48, 0, 392770, 0, 1, 1, 0, 0, '', 'Allow Gossip Menu if Quest Credit 392770 IS NOT rewarded'), +-- Kleia (Quest: A Fate Most Noble) +(26, 15895, 11013, 0, 0, 48, 0, 392770, 0, 1, 0, 0, 0, '', 'Allow Phase 15895 if Quest Credit 392770 IS rewarded'), +(26, 15895, 11013, 0, 0, 48, 0, 392682, 0, 1, 1, 0, 0, '', 'Allow Phase 15895 if Quest Credit 392682 IS NOT rewarded'), +-- Greeter Mnemis Final Phase +(26, 15935, 11013, 0, 0, 48, 0, 404742, 0, 1, 0, 0, 0, '', 'Allow Phase 15935 if Quest Credit 404742 IS rewarded'), +-- Kalisthene init spawn Phasing +(26, 15190, 11013, 0, 0, 48, 0, 404742, 0, 1, 0, 0, 0, '', 'Allow Phase 15190 if Quest Credit 404742 IS rewarded'), +(26, 15190, 11013, 0, 1, 47, 0, 60735, 66, 0, 0, 0, 0, '', 'Allow Phase 15190 if Quest 60735 IS complete/rewarded'), +(26, 15190, 11013, 0, 1, 9, 0, 57261, 0, 0, 1, 0, 0, '', 'Allow Phase 15190 if Quest 57261 IS NOT Taken'); + +-- Conditions ConditionalSpawns +DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId` = 32 AND `SourceGroup` = 5 AND `SourceEntry` IN (166163, 157093, 166164, 166166, 156398, 166165)); +INSERT INTO `conditions`(`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +-- Centurion Goliath (right Side) +(32, 5, 166163, 0, 0, 48, 0, 396943, 0, 2, 1, 0, 0, '', 'Spawn of creature with entry 166163 requires Quest Credit 396943 IS NOT rewarded'), +(32, 5, 166163, 0, 0, 47, 0, 57102, 66, 0, 1, 0, 0, '', 'Spawn of creature with entry 166163 requires Quest 57102 IS NOT complete/rewarded'), +-- Centurion Goliath (right Side, after Credit reward) +(32, 5, 157093, 0, 0, 48, 0, 396943, 0, 2, 0, 0, 0, '', 'Spawn of creature with entry 157093 requires Quest Credit 396943 rewarded'), +(32, 5, 157093, 0, 1, 47, 0, 57102, 66, 0, 0, 0, 0, '', 'OR Spawn of creature with entry 157093 requires Quest 57102 complete/rewarded'), +-- Centurion Colossus +(32, 5, 166164, 0, 0, 48, 0, 396945, 0, 5, 1, 0, 0, '', 'Spawn of creature with entry 166164 requires Quest Credit 396945 IS NOT rewarded'), +(32, 5, 166164, 0, 0, 47, 0, 57102, 66, 0, 1, 0, 0, '', 'Spawn of creature with entry 166163 requires Quest 57102 IS NOT complete/rewarded'), +-- Centurion Colossus (after Credit Reward) +(32, 5, 166166, 0, 0, 48, 0, 396945, 0, 5, 0, 0, 0, '', 'Spawn of creature with entry 166166 requires Quest Credit 396945 rewarded'), +(32, 5, 166166, 0, 1, 47, 0, 57102, 66, 0, 0, 0, 0, '', 'OR Spawn of creature with entry 166166 requires Quest 57102 complete/rewarded'), +-- Centurion Goliath (left Side) +(32, 5, 156398, 0, 0, 48, 0, 396944, 0, 3, 1, 0, 0, '', 'Spawn of creature with entry 156398 requires Quest Credit 396944 IS NOT rewarded'), +(32, 5, 156398, 0, 0, 47, 0, 57102, 66, 0, 1, 0, 0, '', 'Spawn of creature with entry 156398 requires Quest 57102 IS NOT complete/rewarded'), +-- Centurion Goliath (left Side, after Credit reward) +(32, 5, 166165, 0, 0, 48, 0, 396944, 0, 3, 0, 0, 0, '', 'Spawn of creature with entry 166165 requires Quest Credit 396944 rewarded'), +(32, 5, 166165, 0, 1, 47, 0, 57102, 66, 0, 0, 0, 0, '', 'OR Spawn of creature with entry 166165 requires Quest 57102 complete/rewarded'); + +-- Creature Text +DELETE FROM `creature_text` WHERE `CreatureID` = 158281; +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `comment`) VALUES +(158281, 0, 0, 'Anima reserves now nominal. Initializing.', 12, 0, 100, 1, 0, 158110, 180370, 'Greeter Mnemis to Player'), +(158281, 1, 0, 'Goodbye.', 12, 0, 100, 0, 0, 158121, 113727, 'Greeter Mnemis to Kalisthene'); -- BroadcastTextID: 62090 - 113727 - 113733 - 113746 - 116585 - 116630 - 117052 - 127497 - 140047 - 181610 + +-- NPC Text +DELETE FROM `npc_text` WHERE `ID` IN (42294, 41670, 42252, 42251, 42255); +INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES +(42294, 1, 0, 0, 0, 0, 0, 0, 0, 206190, 0, 0, 0, 0, 0, 0, 0, 41793), -- 42294 +(41670, 1, 1, 1, 1, 1, 0, 0, 0, 204097, 204099, 204100, 204103, 204104, 0, 0, 0, 42010), -- 41670 +(42252, 1, 1, 1, 1, 1, 1, 1, 1, 206225, 206226, 206227, 206228, 206220, 206221, 206222, 206223, 42010), -- 42252 +(42251, 1, 0, 0, 0, 0, 0, 0, 0, 206454, 0, 0, 0, 0, 0, 0, 0, 42010), -- 42251 +(42255, 1, 1, 1, 1, 1, 1, 1, 1, 206251, 206252, 206253, 206254, 206255, 206256, 206257, 206258, 42010); -- 42255 + +-- Page Text +DELETE FROM `page_text` WHERE `ID` IN (8215 /*8215*/, 8220 /*8220*/, 8221 /*8221*/, 8219 /*8219*/, 8222 /*8222*/, 8216 /*8216*/, 8217 /*8217*/, 8218 /*8218*/); +INSERT INTO `page_text` (`ID`, `Text`, `NextPageID`, `PlayerConditionID`, `Flags`, `VerifiedBuild`) VALUES +(8215, 'Kyrestia, the Firstborne, Archon of Bastion, has presided over this realm since the Shadowlands came into being.\n\nShe is the example, the beacon in the darkness, for aspirants and ascended alike. Her light illuminates the path you now walk. Her will keeps Bastion aloft! Her infinite wisdom safeguards us for all time.\n\nShe awaits you at the end of this long road, for it is she who will grant you the gift of flight and it is she who will charge you with our most sacred task.\n\nThe Archon\'s eyes are surely upon you in this moment!', 0, 0, 0, 42010), -- 8215 +(8220, 'Each temple is presided over by a Paragon. These ancient beings demonstrate the ultimate expression of their respective virtue, and are responsible for the care and training of all aspirants that enter their domain.\n\nPresiding over the Temple of Purity is Vesiphone, known for her grace and compassion.\n\nPresiding over the Temple of Courage is Xandria, known for her indomitable will and unyielding strength.\n\nPresiding over the Temple of Humility is Chyrus, known for his insight and approachable nature.\n\nPresiding over the Temple of Wisdom is Thenios, known for his longevity of purpose and clarity of thought.\n\nPresiding over the Temple of Loyalty is Devos, known for her unwavering commitment to her people and the Archon.\n\nEach is bolstered by their chosen Hand, selected for their excellence in service to their temple. You should expect to meet them all on your journey, as they will be an invaluable resource to complete the Five Rites.', 0, 0, 0, 42010), -- 8220 +(8221, 'Collectors maintain the realm and contribute to all of Bastion\'s great works. They are responsible for the collection and ordering of anima in our realm.\n\nA Collector may take the form of a Forgelite, or perhaps a scholar. They craft armor, furnishings, carve statues, build fantastic works of architecture, and write our many stories and songs. They weave masterful works from anima itself. They are great craftsmen and musicians.\n\nA Collector will, over the course of their eternity, dedicate themselves to honing their skill and perfecting the arts of their choice. They find a worthwhile existence in great works and are the source of Bastion\'s considerable beauty.\n\nThere are many Collectors, but no two are the same. In this role you will serve to bolster this realm that you now call home.', 0, 0, 0, 42010), -- 8221 +(8219, 'Watchers perform a difficult and emotionally taxing role among the kyrian.\n\nIt is they who linger at the edge of the Veil and greet mortal souls who seek to cross into the Shadowlands. It is the Watchers who weigh that soul, peer into its existence and judge whether it is their time.\n\nAs a Watcher, you will be burdened with that soul\'s memories, and you will see and know things that will weigh heavy on your mind. This role is only for the strong of heart, for those who can endure with the Purpose in mind at all times.\n\nFew ultimately choose this path, but those that do are held among the highest regard.', 0, 0, 0, 42010), -- 8219 +(8222, 'Bearers perform the vital task of bearing souls across the Veil to Oribos, where they will be given the fate they earned in life.\n\nBearers are known for their adventurous spirit and indomitable will. They will see countless worlds beyond the Shadowlands. They will encounter beings of all shapes and sizes that will be carried to Oribos to serve the Purpose. By their arms, and their will, the great cycle continues.\n\nBeing a Bearer is a grave responsibility, but no kyrian will know more of the worlds beyond than those who bear mortal souls.', 0, 0, 0, 42010), -- 8222 +(8216, 'Welcome to Bastion!\n\nYou are about to embark on a long, arduous journey. Your ultimate goal is to reach ascension, but there are many steps you will take along the way.\n\nFirst, you will cultivate the core skills needed for your journey in the Aspirant\'s Crucible. There you will learn the art of combat, or hone your existing skills if you are already well versed. You will be instructed in the art of meditation, and taught to access your most deeply held memories and emotions. You will be introduced to our ways and customs under the tutelage of more experienced aspirants.\n\nOnce you are deemed ready, you will undergo your first cleansing and shed one of many burdens that bind you to the life that came before. Only then will you gain the form and title of an aspirant.\n\nYour journey then continues through the Five Rites.', 0, 0, 0, 42010), -- 8216 +(8217, 'After achieving the form and role of aspirant, you will continue to the longest part of your journey.\n\nYou will venture through the five temples: Purity, Courage, Humility, Wisdom, and Loyalty. There you will learn their virtues and undergo a final ritual that will test your merit against these values. These are known as the Five Rites.\n\nThe Rite of Purity will help you be at peace with your past.\nThe Rite of Courage will teach you to stand against all odds.\nThe Rite of Humility will show you your place in the cosmos.\nThe Rite of Wisdom will ensure you understand your purpose.\nThe Rite of Loyalty will deepen your bond with those who walk beside you.\n\nThis journey may encompass eons. It may stretch into time incalculable. It will be fraught with setbacks and disappointments, yes, but also joy and achievement unlike any you have known before. You will grow. You will become the best version of yourself. \n\nWhen you are ready, you will ascend.', 0, 0, 0, 42010), -- 8217 +(8218, 'Once you have completed the Five Rites, all that remains is to demonstrate your worthiness to the Archon herself.\n\nYou will be given your first opportunity to perform our sacred task. You will venture to another world, piercing the Veil, and retrieve a single mortal soul. You will serve the grand Purpose, and by your hand the Shadowlands will continue as it always has.\n\nOn your return you will be elevated to the rank of Ascended, and you will be free to soar among the clouds of Bastion forever after.', 0, 0, 0, 42010); -- 8218 + +-- SAI Scripts +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry` IN (166227, 158281, 165107); + +DELETE FROM `smart_scripts` WHERE (`entryorguid` = 166227 AND `source_type` IN (0, 1)) OR (`entryorguid` = 158281 AND `source_type` IN (0, 1)) OR (`entryorguid` = 165107 AND `source_type` IN (0, 1)); +INSERT INTO `smart_scripts`(`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `event_param5`, `event_param_string`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_param4`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +-- Kleia [Quest: Welcome to Eternity) +(166227, 0, 0, 1, 62, 0, 100, 0, 25436, 0, 0, 0, 0, '', 33, 166227, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Kleia - OnGossipSelect 25436 0 - reward Credit - to Invoker'), +(166227, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'SAI Link 0 - close Gossip - to Invoker'), +-- Greeter Msnemis (Quest: A Fate Most Noble) +(158281, 0, 0, 1, 62, 0, 100, 0, 24642, 0, 0, 0, 0, '', 33, 158281, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Greeter Mnemis - OnGossipSelect 24642 0 - reward Credit - to Invoker'), +(158281, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'SAI Link 0 - close Gossip - to Invoker'), +-- Kleia [Quest: Trouble in Paradise) +(165107, 0, 0, 1, 62, 0, 100, 0, 25436, 1, 0, 0, 0, '', 33, 165107, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'Kleia - OnGossipSelect 25436 1 - reward Credit - to Invoker'), +(165107, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, '', 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 'SAI Link 0 - close Gossip - to Invoker'); + +-- Waypoints for @CGUID+114 +SET @PATH := @CGUID+114 * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data`(`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(@PATH, 3, -4361.92, -4363.84, 6557.66, 5.4137, 6987, 0, 0, 100, 0), +(@PATH, 2, -4362.95, -4316.67, 6552.15, 1.8598, 8459, 0, 0, 100, 0), +(@PATH, 1, -4364.92, -4317.76, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 0, -4389.92, -4356.72, 6557.87, 0, 6850, 0, 0, 100, 0); + +UPDATE `creature` SET `position_x`= -4389.922, `position_y`= -4356.721, `position_z`= 6557.867, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+114; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+114; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+114, @PATH, 1); + +-- Waypoints for @CGUID+101 -- Need Spline +SET @PATH := @CGUID+101 * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data`(`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(@PATH, 2, -4434.6, -4275.85, 6556.19, 0, 6128, 0, 0, 100, 0), +(@PATH, 1, -4435.48, -4275.75, 6556.16, 0, 0, 0, 0, 100, 0), +(@PATH, 0, -4435.9, -4260.36, 6556.16, 0, 5343, 0, 0, 100, 0); + +UPDATE `creature` SET `position_x`= -4435.901, `position_y`= -4260.356, `position_z`= 6556.156, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+101; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+101; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`, `auras`) VALUES +(@CGUID+101, @PATH, 1, '310757'); + +-- Waypoints for @CGUID+61 +SET @PATH := @CGUID+61 * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data`(`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(@PATH, 0, -4281.83, -4203.69, 6552.23, 0, 7564, 0, 0, 100, 0), +(@PATH, 1, -4272.03, -4230.47, 6552.13, 0, 6613, 0, 0, 100, 0), +(@PATH, 2, -4281.69, -4204.97, 6552.13, 0, 0, 0, 0, 100, 0); + +UPDATE `creature` SET `position_x`= -4281.827, `position_y`= -4203.686, `position_z`= 6552.23, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+61; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+61; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+61, @PATH, 1); + +-- Waypoints for @CGUID+62 THIS NEEDS TO BE CONVERTED TO CYCLEPATH WPs +SET @PATH := @CGUID+62 * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data`(`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(@PATH, 0, -4292.29, -4269.81, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 1, -4293.16, -4272.83, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 2, -4295.57, -4277.5, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 3, -4298.13, -4282.21, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 4, -4303.96, -4290.4, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 5, -4310.62, -4298.15, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 6, -4315.7, -4302.84, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 7, -4319.94, -4305.84, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 8, -4330.21, -4312.24, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 9, -4341.28, -4318.21, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 10, -4354.29, -4324.06, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 11, -4359.91, -4325.65, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 12, -4367.33, -4326.45, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 13, -4374.64, -4323.59, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 14, -4378.36, -4320.71, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 15, -4385.18, -4312.83, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 16, -4391.71, -4303.98, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 17, -4397.47, -4292.34, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 18, -4400.65, -4284.54, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 19, -4402.16, -4279.28, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 20, -4402.68, -4274.61, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 21, -4403.89, -4262.98, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 22, -4405.14, -4252.86, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 23, -4405.12, -4248.89, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 24, -4404.65, -4243.97, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 25, -4402.84, -4235.94, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 26, -4399.3, -4227.52, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 27, -4395.3, -4218.91, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 28, -4389.34, -4211.51, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 29, -4381.94, -4205.26, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 30, -4372.45, -4201.31, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 31, -4367.01, -4201.23, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 32, -4365.45, -4201.64, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 33, -4358.94, -4200.9, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 34, -4347.57, -4200.81, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 35, -4336.97, -4200.97, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 36, -4330.79, -4202.69, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 37, -4323.82, -4206.32, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 38, -4313.91, -4212.74, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 39, -4307.47, -4219.27, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 40, -4306.42, -4220.56, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 41, -4302.1, -4223.5, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 42, -4299.98, -4225.24, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 43, -4295.87, -4231.72, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 44, -4292.66, -4245.02, 6552.02, 0, 0, 0, 0, 100, 0), +(@PATH, 45, -4291.49, -4259.87, 6552.02, 0, 0, 0, 0, 100, 0); + +UPDATE `creature` SET `position_x`= -4293.1562, `position_y`= -4272.828, `position_z`= 6552.107, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+62; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+62; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+62, @PATH, 1); + +-- Waypoints for @CGUID+89 +SET @PATH := @CGUID+89 * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data`(`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(@PATH, 0, -4332.93, -4268.4, 6555.88, 0, 7300, 0, 0, 100, 0), +(@PATH, 1, -4345.93, -4275.42, 6557.33, 0, 7288, 0, 0, 100, 0), +(@PATH, 2, -4366.9, -4258.26, 6555.76, 0, 6785, 0, 0, 100, 0), +(@PATH, 3, -4334.8, -4267.45, 6555.76, 0, 0, 0, 0, 100, 0); + +UPDATE `creature` SET `position_x`= -4332.934, `position_y`= -4268.397, `position_z`= 6555.881, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+89; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+89; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+89, @PATH, 1); + +-- Waypoints for @CGUID+105 +SET @PATH := @CGUID+105 * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data`(`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(@PATH, 0, -4262.35, -4298.88, 6554.42, 0, 6887, 0, 0, 100, 0), +(@PATH, 1, -4294.27, -4330.06, 6554.25, 0, 6086, 0, 0, 100, 0), +(@PATH, 2, -4263.46, -4298.1, 6554.26, 0, 0, 0, 0, 100, 0); + +UPDATE `creature` SET `position_x`= -4262.354, `position_y`= -4298.878, `position_z`= 6554.422, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+105; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+105; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`, `auras`) VALUES +(@CGUID+105, @PATH, 1, '316394'); + +-- Waypoints for @CGUID+45 +SET @PATH := @CGUID+45 * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data`(`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(@PATH, 3, -4331.21, -3921.71, 6564.22, 0, 6608, 0, 0, 100, 0), +(@PATH, 2, -4322.72, -3928.42, 6563.82, 0, 7355, 0, 0, 100, 0), +(@PATH, 1, -4322.81, -3927.46, 6563.65, 0, 0, 0, 0, 100, 0), +(@PATH, 0, -4321.44, -3916.93, 6563.65, 0, 6544, 0, 0, 100, 0); + +UPDATE `creature` SET `position_x`= -4321.444, `position_y`= -3916.931, `position_z`= 6563.645, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+45; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+45; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+45, @PATH, 1); + +-- Waypoints for @CGUID+44 +SET @PATH := @CGUID+44 * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data`(`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(@PATH, 0, -4243.92, -3957.51, 6561.32, 0, 0, 0, 0, 100, 0), +(@PATH, 1, -4242.58, -3958.67, 6561.44, 0, 6224, 0, 0, 100, 0), +(@PATH, 2, -4295.91, -3947.54, 6561.32, 0, 8314, 0, 0, 100, 0); + +UPDATE `creature` SET `position_x`= -4243.92, `position_y`= -3957.512, `position_z`= 6561.321, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+44; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+44; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+44, @PATH, 1); + +-- Waypoints for @CGUID+39 +SET @PATH := @CGUID+39 * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data`(`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`, `action`, `action_chance`, `wpguid`) VALUES +(@PATH, 2, -4311, -4047.57, 6556.78, 0, 6968, 0, 0, 100, 0), +(@PATH, 1, -4276.93, -4055.91, 6556.97, 0, 7373, 0, 0, 100, 0), +(@PATH, 0, -4278.29, -4054.78, 6556.78, 0, 0, 0, 0, 100, 0); + +UPDATE `creature` SET `position_x`= -4278.292, `position_y`= -4054.78, `position_z`= 6556.784, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+39; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+39; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+39, @PATH, 1); |