diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2022_10-24_01_world.sql | 1250 |
1 files changed, 1250 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_10-24_01_world.sql b/sql/updates/world/master/2022_10-24_01_world.sql new file mode 100644 index 00000000000..0743b3b8f63 --- /dev/null +++ b/sql/updates/world/master/2022_10-24_01_world.sql @@ -0,0 +1,1250 @@ +SET @CGUID := 650960; +SET @OGUID := 400221; + +-- Creature +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+382; +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, 114465, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8463.658203125, 1193.828125, 5.703125, 5.313868522644042968, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Darnassus Sentinel (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+1, 108420, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8530.8837890625, 1143.592041015625, 19.10568428039550781, 4.86376953125, 120, 0, 0, 323600, 0, 0, 0, 0, 0, 45745), -- Training Dummy (Area: Stormwind Harbor - Difficulty: 0) (Auras: 98892 - Training Dummy Marker) +(@CGUID+2, 108581, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8500.1455078125, 1165.5242919921875, 17.79158401489257812, 2.689786195755004882, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Gnome Engineer (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+3, 107826, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8461.701171875, 1148.7847900390625, 19.13516616821289062, 1.433399558067321777, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+4, 107827, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8544.5830078125, 1142.0208740234375, 19.03516578674316406, 1.550777077674865722, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+5, 108051, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8446.8642578125, 1202.529541015625, 5.411701202392578125, 1.478258967399597167, 120, 0, 0, 3236, 1534, 0, 0, 0, 0, 45745), -- Alasdair Whitepeak (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+8, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8511.794921875, 1124.642333984375, 18.0326080322265625, 0.018503643572330474, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+9, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8461.046875, 1249.9185791015625, 5.313554286956787109, 4.607669353485107421, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+10, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8505.591796875, 1182.7447509765625, 17.42935562133789062, 0.69627922773361206, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+11, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8490.314453125, 1115.9097900390625, 18.30398750305175781, 3.190068721771240234, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+12, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8487.59375, 1249.60009765625, 5.31356048583984375, 4.78220224380493164, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+13, 107841, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8454.685546875, 1149.0867919921875, 19.13516616821289062, 2.035080194473266601, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+14, 108420, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8471.9033203125, 1143.1458740234375, 18.18923759460449218, 3.118461370468139648, 120, 0, 0, 323600, 0, 0, 0, 0, 0, 45745), -- Training Dummy (Area: Stormwind Harbor - Difficulty: 0) (Auras: 98892 - Training Dummy Marker) +(@CGUID+15, 108420, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8526.0380859375, 1143.41845703125, 19.04227447509765625, 4.922250747680664062, 120, 0, 0, 323600, 0, 0, 0, 0, 0, 45745), -- Training Dummy (Area: Stormwind Harbor - Difficulty: 0) (Auras: 98892 - Training Dummy Marker) +(@CGUID+16, 108581, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8493.861328125, 1168.5816650390625, 17.79158401489257812, 2.443313360214233398, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Gnome Engineer (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+17, 108581, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8538.96875, 1164.7135009765625, 17.7916107177734375, 1.087662696838378906, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Gnome Engineer (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+18, 107823, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8489.7919921875, 1197.4132080078125, 5.627997875213623046, 3.21943211555480957, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+19, 108412, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8477.7431640625, 1217.0260009765625, 5.26683807373046875, 1.535407662391662597, 120, 0, 0, 3236, 1534, 0, 0, 0, 0, 45745), -- Clavicus Knavingham (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+20, 108420, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8516.78125, 1144.0504150390625, 19.11979293823242187, 4.835427284240722656, 120, 0, 0, 323600, 0, 0, 0, 0, 0, 45745), -- Training Dummy (Area: Stormwind Harbor - Difficulty: 0) (Auras: 98892 - Training Dummy Marker) +(@CGUID+21, 108581, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8554.5205078125, 1167.8541259765625, 17.79162406921386718, 0.588176190853118896, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Gnome Engineer (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+22, 108581, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8501.5205078125, 1164.8367919921875, 17.79158592224121093, 1.90658271312713623, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Gnome Engineer (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+23, 108483, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8498.4306640625, 1207.4322509765625, 5.374481201171875, 1.166474699974060058, 120, 0, 0, 3236, 1534, 0, 0, 0, 0, 45745), -- Tasha Highfoot (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+24, 107827, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8526.732421875, 1121.1910400390625, 19.13516616821289062, 5.369287967681884765, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+25, 108481, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8497.3037109375, 1202.8021240234375, 5.518375396728515625, 0.396119117736816406, 120, 0, 0, 3236, 1534, 0, 0, 0, 0, 45745), -- Gussof Forgefire (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+26, 43102, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8426.8896484375, 1261.18994140625, -42.3698692321777343, 1.535889744758605957, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Rock Lobster (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+27, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8569.9755859375, 1195.560546875, 5.584058284759521484, 1.710422635078430175, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+28, 107826, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8471.1845703125, 1123.5242919921875, 19.13516807556152343, 4.788257598876953125, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) (Auras: 145953 - Cosmetic - Sleep Zzz) +(@CGUID+29, 53950, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8514.9931640625, 1305.2100830078125, 6.181744098663330078, 1.535889744758605957, 120, 0, 0, 1604, 100, 0, 0, 0, 0, 45745), -- Hired Courier (Area: Stormwind Harbor - Difficulty: 0) (Auras: 29266 - Permanent Feign Death) +(@CGUID+30, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8424.888671875, 1195.6185302734375, 5.586038589477539062, 1.256637096405029296, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+31, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8528.6669921875, 1246.060302734375, 5.3133544921875, 3.17211151123046875, 120, 10, 0, 23582, 0, 1, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(@CGUID+32, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8446.6455078125, 1208.3966064453125, 5.193141937255859375, 3.106436014175415039, 120, 10, 0, 23582, 0, 1, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(@CGUID+33, 107833, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8461.5732421875, 1123.3941650390625, 19.13516807556152343, 4.577039241790771484, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) (Auras: 145953 - Cosmetic - Sleep Zzz) +(@CGUID+34, 108420, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8471.8681640625, 1155.498291015625, 18.2070770263671875, 3.114397525787353515, 120, 0, 0, 323600, 0, 0, 0, 0, 0, 45745), -- Training Dummy (Area: Stormwind Harbor - Difficulty: 0) (Auras: 98892 - Training Dummy Marker) +(@CGUID+35, 107835, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8434.626953125, 1150.484375, 20.7584686279296875, 5.901097297668457031, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+36, 107835, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8409.5625, 1167.3680419921875, 17.7978363037109375, 1.492067933082580566, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+37, 108420, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8535.5205078125, 1143.4444580078125, 19.10452461242675781, 4.59384918212890625, 120, 0, 0, 323600, 0, 0, 0, 0, 0, 45745), -- Training Dummy (Area: Stormwind Harbor - Difficulty: 0) (Auras: 98892 - Training Dummy Marker) +(@CGUID+38, 53954, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8514.6142578125, 1305.486083984375, 6.182001113891601562, 5.619960308074951171, 120, 0, 0, 1604, 0, 0, 0, 0, 0, 45745), -- Blood Spatter (Area: Stormwind Harbor - Difficulty: 0) (Auras: 29266 - Permanent Feign Death, 28559 - Untrackable) +(@CGUID+39, 107841, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8526.044921875, 1141.6510009765625, 18.96725273132324218, 1.566928625106811523, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+40, 108420, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8520.9326171875, 1143.8992919921875, 19.13447761535644531, 4.835427284240722656, 120, 0, 0, 323600, 0, 0, 0, 0, 0, 45745), -- Training Dummy (Area: Stormwind Harbor - Difficulty: 0) (Auras: 98892 - Training Dummy Marker) +(@CGUID+41, 108420, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8471.8056640625, 1149.1197509765625, 18.265625, 3.170018196105957031, 120, 0, 0, 323600, 0, 0, 0, 0, 0, 45745), -- Training Dummy (Area: Stormwind Harbor - Difficulty: 0) (Auras: 98892 - Training Dummy Marker) +(@CGUID+42, 108581, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8520.2080078125, 1171.1285400390625, 17.61199760437011718, 3.915131092071533203, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Gnome Engineer (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+43, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8490.234375, 1124.640625, 18.47506523132324218, 3.099007606506347656, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+44, 108141, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8436.732421875, 1213.9879150390625, 5.245804786682128906, 2.35421299934387207, 120, 0, 0, 3236, 1534, 0, 0, 0, 0, 45745), -- Brother Zuo (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+45, 107839, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8473.685546875, 1149.265625, 18.10994338989257812, 6.205743312835693359, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+46, 53961, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8515.6923828125, 1306.9774169921875, 6.18283843994140625, 0, 120, 0, 0, 1604, 0, 0, 0, 0, 0, 45745), -- Blood Spatter (Small) (Area: Stormwind Harbor - Difficulty: 0) (Auras: 29266 - Permanent Feign Death, 28559 - Untrackable) +(@CGUID+47, 53954, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8514.8994140625, 1306.21875, 6.182374477386474609, 5.619960308074951171, 120, 0, 0, 1604, 0, 0, 0, 0, 0, 45745), -- Blood Spatter (Area: Stormwind Harbor - Difficulty: 0) (Auras: 29266 - Permanent Feign Death, 28559 - Untrackable) +(@CGUID+48, 107827, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8491.8994140625, 1142.359375, 18.1123504638671875, 3.065468788146972656, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+49, 107827, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8535.5244140625, 1141.810791015625, 18.99629974365234375, 1.56840527057647705, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+50, 114465, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8460.595703125, 1191.623291015625, 5.664844512939453125, 2.309646129608154296, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Darnassus Sentinel (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+51, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8461.419921875, 1293.6724853515625, 5.31356048583984375, 3.106686115264892578, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+52, 53961, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8514.935546875, 1306.7274169921875, 6.182691097259521484, 0, 120, 0, 0, 1604, 0, 0, 0, 0, 0, 45745), -- Blood Spatter (Small) (Area: Stormwind Harbor - Difficulty: 0) (Auras: 29266 - Permanent Feign Death, 28559 - Untrackable) +(@CGUID+53, 107827, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8409.3642578125, 1169.82470703125, 17.7978363037109375, 4.650029659271240234, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+54, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8486.083984375, 1293.9378662109375, 5.313554286956787109, 0.01745329238474369, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+55, 107833, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8473.9970703125, 1143.1353759765625, 18.0737762451171875, 0.005013950634747743, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+56, 53961, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8515.5068359375, 1306.439208984375, 6.182505607604980468, 0, 120, 0, 0, 1604, 0, 0, 0, 0, 0, 45745), -- Blood Spatter (Small) (Area: Stormwind Harbor - Difficulty: 0) (Auras: 29266 - Permanent Feign Death, 28559 - Untrackable) +(@CGUID+57, 114465, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8460.7412109375, 1193.69970703125, 5.592391490936279296, 3.589044094085693359, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Darnassus Sentinel (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+58, 108420, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8544.5517578125, 1143.5816650390625, 19.11476898193359375, 4.5916900634765625, 120, 0, 0, 323600, 0, 0, 0, 0, 0, 45745), -- Training Dummy (Area: Stormwind Harbor - Difficulty: 0) (Auras: 98892 - Training Dummy Marker) +(@CGUID+59, 32520, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8680.671875, 730.748291015625, 159.0923919677734375, 0, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Totally Generic Bunny (All Phase) (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+60, 108581, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8551.78125, 1173.279541015625, 17.73284339904785156, 3.837976932525634765, 120, 10, 0, 3236, 0, 1, 0, 0, 0, 45745), -- Gnome Engineer (Area: Stormwind Harbor - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+61, 108581, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8528.826171875, 1173.564208984375, 17.64035224914550781, 4.767015933990478515, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Gnome Engineer (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+62, 107835, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8444.4755859375, 1141.9879150390625, 19.40514755249023437, 4.623383045196533203, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+63, 108420, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8540.26953125, 1143.7222900390625, 19.0595855712890625, 4.752087116241455078, 120, 0, 0, 323600, 0, 0, 0, 0, 0, 45745), -- Training Dummy (Area: Stormwind Harbor - Difficulty: 0) (Auras: 98892 - Training Dummy Marker) +(@CGUID+64, 53966, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8515.3349609375, 1306.13720703125, 6.182314872741699218, 0, 120, 0, 0, 1604, 852, 0, 0, 0, 0, 45745), -- Spider Summoner (Ship) (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+65, 43102, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8565.6298828125, 1277.3900146484375, -58.4476661682128906, 1.553343057632446289, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Rock Lobster (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+66, 107827, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8520.9775390625, 1141.99658203125, 19.13416671752929687, 1.547191262245178222, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+67, 108140, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8449.328125, 1230, 5.313578605651855468, 4.59477853775024414, 120, 0, 0, 3236, 1534, 0, 0, 0, 0, 45745), -- Doc Lightspanner (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+68, 32520, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8290.09375, 1388.640625, 30.0042724609375, 0, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Totally Generic Bunny (All Phase) (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+69, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8549.33203125, 1181.01220703125, 17.49878120422363281, 2.457881927490234375, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+70, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8484.5048828125, 1196.4410400390625, 5.646368980407714843, 1.503065705299377441, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+71, 107826, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8501.8818359375, 1208.3194580078125, 5.357813835144042968, 5.594708919525146484, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+72, 107827, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8475.0068359375, 1122.7882080078125, 19.13115501403808593, 1.359431385993957519, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+73, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8579.5830078125, 1195.2109375, 5.565848350524902343, 1.518436431884765625, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+74, 188374, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8437.984375, 1225.9617919921875, 5.313569545745849609, 6.178342819213867187, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Millbert (Area: Stormwind Harbor - Difficulty: 0) (Auras: 370841 - Cosmetic - Carry Box) +(@CGUID+75, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8475.197265625, 1196.31201171875, 5.823928356170654296, 1.710422635078430175, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+76, 108420, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8493.70703125, 1154.8524169921875, 18.39711570739746093, 6.259609699249267578, 120, 0, 0, 323600, 0, 0, 0, 0, 0, 45745), -- Training Dummy (Area: Stormwind Harbor - Difficulty: 0) (Auras: 98892 - Training Dummy Marker) +(@CGUID+77, 107835, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8530.859375, 1141.7291259765625, 18.99119758605957031, 1.583900809288024902, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+78, 107839, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8491.841796875, 1155.359375, 18.23073577880859375, 3.406975269317626953, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+79, 107839, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8516.84765625, 1142.1475830078125, 19.10321235656738281, 1.535911798477172851, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+80, 107823, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8491.701171875, 1149.079833984375, 18.377655029296875, 3.443790912628173828, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+81, 108581, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8511.0595703125, 1167.23095703125, 17.79159355163574218, 2.309036731719970703, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Gnome Engineer (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+82, 108581, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8518.7119140625, 1169.3472900390625, 17.7099151611328125, 2.310123443603515625, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Gnome Engineer (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+83, 107839, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8473.873046875, 1155.5086669921875, 18.06051254272460937, 6.278010368347167968, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+84, 108143, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8450.7607421875, 1211.6353759765625, 5.228898048400878906, 1.388527989387512207, 120, 0, 0, 3236, 1534, 0, 0, 0, 0, 45745), -- Kinndy Brightsocket (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+85, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8414.9990234375, 1195.7548828125, 5.702553272247314453, 1.780235767364501953, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+86, 107833, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8540.28515625, 1141.98095703125, 18.9511871337890625, 1.561823606491088867, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+87, 68, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8481.2294921875, 1132.8211669921875, 18.46377372741699218, 1.662348866462707519, 120, 0, 0, 17687, 0, 0, 0, 0, 0, 45745), -- Stormwind City Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+88, 107833, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8446.4912109375, 1142.060791015625, 19.47524642944335937, 4.63353586196899414, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+89, 107833, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8466.1923828125, 1123.5347900390625, 19.13516807556152343, 4.4508514404296875, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) (Auras: 145953 - Cosmetic - Sleep Zzz) +(@CGUID+90, 107833, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8445.9033203125, 1139.2222900390625, 19.01909828186035156, 1.180440783500671386, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+91, 108420, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8493.7431640625, 1142.5, 18.34520339965820312, 0.191373690962791442, 120, 0, 0, 323600, 0, 0, 0, 0, 0, 45745), -- Training Dummy (Area: Stormwind Harbor - Difficulty: 0) (Auras: 98892 - Training Dummy Marker) +(@CGUID+92, 108420, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8493.64453125, 1148.4739990234375, 18.59841537475585937, 6.257720947265625, 120, 0, 0, 323600, 0, 0, 0, 0, 0, 45745), -- Training Dummy (Area: Stormwind Harbor - Difficulty: 0) (Auras: 98892 - Training Dummy Marker) +(@CGUID+93, 114465, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8463.044921875, 1190.8680419921875, 5.788194656372070312, 1.543762087821960449, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Darnassus Sentinel (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+94, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8617.025390625, 1240.6279296875, 5.315483570098876953, 0.523598790168762207, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+95, 6086, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8593.7890625, 1246.0025634765625, 5.313799381256103515, 4.101523876190185546, 120, 0, 0, 3208, 0, 0, 0, 0, 0, 45745), -- Auberdine Sentinel (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+96, 6086, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8606.9775390625, 1239.413330078125, 5.314605712890625, 0.506145477294921875, 120, 0, 0, 3208, 0, 0, 0, 0, 0, 45745), -- Auberdine Sentinel (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+97, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8591.546875, 1253.98193359375, 5.31371927261352539, 3.769911050796508789, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+98, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8647.90234375, 1303.360107421875, 5.31557464599609375, 0.48869219422340393, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+99, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8624.76953125, 1315.9771728515625, 5.315581321716308593, 3.490658521652221679, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+100, 6086, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8632.423828125, 1322.6668701171875, 5.315583705902099609, 3.630284786224365234, 120, 0, 0, 3208, 0, 0, 0, 0, 0, 45745), -- Auberdine Sentinel (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+101, 6086, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8645.2509765625, 1315.32861328125, 5.315582275390625, 0.558505356311798095, 120, 0, 0, 3208, 0, 0, 0, 0, 0, 45745), -- Auberdine Sentinel (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+102, 43102, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8597.5400390625, 1355.25, -56.0909690856933593, 0.855211317539215087, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Rock Lobster (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+103, 43102, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8550.23046875, 1338.239990234375, -44.937469482421875, 1.570796370506286621, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Rock Lobster (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+104, 107826, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8411.296875, 1155.407958984375, 18.02757453918457031, 5.70809793472290039, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+105, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8395.0283203125, 1249.5264892578125, 5.313546657562255859, 4.939281940460205078, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+106, 107829, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8415.09765625, 1148.0504150390625, 18.04560089111328125, 6.214940071105957031, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+107, 107839, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8460.9150390625, 1119.54345703125, 19.13516807556152343, 3.998519659042358398, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+108, 108583, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8389.984375, 1197.9461669921875, 5.655332088470458984, 1.593897581100463867, 120, 0, 0, 3236, 1534, 0, 0, 0, 0, 45745), -- Voraatios the Benedictive (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+109, 108584, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8392.6845703125, 1196.876708984375, 5.652462959289550781, 1.591224312782287597, 120, 0, 0, 3236, 1534, 0, 0, 0, 0, 45745), -- Bemora (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+110, 107841, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8413.0576171875, 1151.3385009765625, 18.03237724304199218, 5.991336822509765625, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+111, 108581, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8389.3798828125, 1226.157958984375, 5.31358194351196289, 5.925539970397949218, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Gnome Engineer (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+112, 108581, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8394.3662109375, 1232.701416015625, 5.328525543212890625, 5.995366573333740234, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Gnome Engineer (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+113, 108748, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8405.6767578125, 1155.342041015625, 18.02757453918457031, 5.394287109375, 120, 0, 0, 8090, 0, 0, 0, 0, 0, 45745), -- Audra Stoneshield (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+114, 107839, 0, 1519, 4411, '0', 6666, 0, 0, 2, -8380.5048828125, 1211.890625, 5.230903148651123046, 3.73871922492980957, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) (Auras: 215601 - Holy Enchantment) +(@CGUID+115, 29016, 0, 1519, 4411, '0', 6666, 0, 0, 3, -8445.5859375, 1109.7984619140625, 19.13516807556152343, 1.29154360294342041, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Steam Tank Engineer (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+116, 108582, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8384.7548828125, 1232.8697509765625, 5.313561439514160156, 3.231005668640136718, 120, 0, 0, 3232764, 0, 0, 0, 0, 0, 45745), -- DX-9000 Spider Tank "Legionkiller" (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+117, 108722, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8410.0576171875, 1147.7239990234375, 18.027130126953125, 5.709260940551757812, 120, 0, 0, 8090, 1534, 0, 0, 0, 0, 45745), -- Ramall Trueoak (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+118, 107826, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8415.6201171875, 1139.2586669921875, 18.12597846984863281, 6.239623546600341796, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+119, 107823, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8413.62890625, 1131.0260009765625, 18.6442413330078125, 0.681548714637756347, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+120, 108585, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8386.4931640625, 1196.35595703125, 5.816654205322265625, 0.793776988983154296, 120, 0, 0, 3236, 1534, 0, 0, 0, 0, 45745), -- Loranea (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+121, 107827, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8465.4326171875, 1115.6353759765625, 19.13516807556152343, 0.685052394866943359, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+122, 107841, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8457.671875, 1118.5572509765625, 19.13516807556152343, 3.426964759826660156, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+123, 107829, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8414.796875, 1141.82470703125, 18.08846664428710937, 6.217907905578613281, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+124, 107823, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8466.1923828125, 1106.7222900390625, 19.1351776123046875, 4.741634845733642578, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+125, 107829, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8414.845703125, 1135.10595703125, 18.24728584289550781, 0.038710642606019973, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+126, 107839, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8392.14453125, 1155.421875, 25.37613487243652343, 4.575038909912109375, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+127, 107833, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8394.8525390625, 1155.2847900390625, 24.95028305053710937, 4.512651920318603515, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+128, 107841, 0, 1519, 4411, '0', 6666, 0, 0, 2, -8384.345703125, 1211.0885009765625, 5.22743082046508789, 0.19700150191783905, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) (Auras: 215601 - Holy Enchantment) +(@CGUID+129, 108581, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8381.640625, 1225.0191650390625, 5.313580036163330078, 2.093642950057983398, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Gnome Engineer (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+130, 108581, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8390.408203125, 1238.8646240234375, 5.313554763793945312, 0.621855020523071289, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Gnome Engineer (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+131, 107829, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8397.9345703125, 1159.3853759765625, 22.23839187622070312, 4.504285335540771484, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+132, 108752, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8410.2724609375, 1133.5677490234375, 18.24720382690429687, 0.550386965274810791, 120, 0, 0, 6470, 3801, 0, 0, 0, 0, 45745), -- Ciarra Neil (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+133, 107841, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8417.0048828125, 1136.8367919921875, 18.17353057861328125, 0.326800763607025146, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+134, 108757, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8411.5869140625, 1139.1319580078125, 18.1083831787109375, 6.255608558654785156, 120, 0, 0, 8090, 1534, 0, 0, 0, 0, 45745), -- Haagios (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+135, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8511.9462890625, 1114.65625, 18.08612060546875, 6.146229743957519531, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+136, 107826, 0, 1519, 4411, '0', 6666, 0, 0, 2, -8384.2451171875, 1197.732666015625, 5.810724735260009765, 3.536278963088989257, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) (Auras: 215601 - Holy Enchantment) +(@CGUID+137, 107827, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8462.5908203125, 1114.4635009765625, 19.13516807556152343, 1.79095458984375, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+138, 107827, 0, 1519, 4411, '0', 6666, 0, 0, 2, -8381.7724609375, 1208.3072509765625, 5.315972328186035156, 1.553992271423339843, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) (Auras: 215601 - Holy Enchantment) +(@CGUID+139, 108743, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8410.732421875, 1145.0728759765625, 18.04861259460449218, 5.862226009368896484, 120, 0, 0, 6470, 3801, 0, 0, 0, 0, 45745), -- Niall Frostdrift (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+140, 107835, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8456.611328125, 1108.7135009765625, 19.13516807556152343, 3.064608097076416015, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) (Auras: 145953 - Cosmetic - Sleep Zzz) +(@CGUID+141, 108746, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8403.6025390625, 1156.8367919921875, 18.02757644653320312, 5.159473419189453125, 120, 0, 0, 8090, 100, 0, 0, 0, 0, 45745), -- Zelena Moonbreak (Area: Stormwind Harbor - Difficulty: 0) (Auras: 42459 - Dual Wield) +(@CGUID+142, 108767, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8398.5087890625, 1135.0201416015625, 18.03283309936523437, 5.514045238494873046, 120, 0, 0, 8090, 0, 0, 0, 0, 0, 45745), -- Kiruud the Relentless (Area: Stormwind Harbor - Difficulty: 0) (Auras: 42459 - Dual Wield) +(@CGUID+143, 108765, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8395.9326171875, 1133.14111328125, 18.09496498107910156, 2.511414527893066406, 120, 0, 0, 6470, 3801, 0, 0, 0, 0, 45745), -- Seona Fireweaver (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+144, 107829, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8466.169921875, 1104.2586669921875, 19.1351776123046875, 1.583674311637878417, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+145, 108751, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8407.814453125, 1130.8629150390625, 18.26743507385253906, 0.460718870162963867, 120, 0, 0, 6470, 3801, 0, 0, 0, 0, 45745), -- Arctic Whitemace (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+146, 108744, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8404.013671875, 1126.8646240234375, 18.1941680908203125, 0.676472842693328857, 120, 0, 0, 6470, 3801, 0, 0, 0, 0, 45745), -- Tessa Wybroff (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+147, 108742, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8380.7236328125, 1154.407958984375, 18.078125, 4.061006546020507812, 120, 0, 0, 6470, 3801, 0, 0, 0, 0, 45745), -- Fen Cinderpaw (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+148, 29016, 0, 1519, 4411, '0', 6666, 0, 0, 2, -8432.1630859375, 1108.17822265625, 19.13516807556152343, 4.625122547149658203, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Steam Tank Engineer (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+149, 107827, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8387.92578125, 1156.3646240234375, 21.70509719848632812, 5.034399032592773437, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+150, 29016, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8416.248046875, 1122.0025634765625, 19.0691680908203125, 3.246312379837036132, 120, 10, 0, 11791, 0, 1, 0, 0, 0, 45745), -- Steam Tank Engineer (Area: Stormwind Harbor - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+151, 107833, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8408.3525390625, 1123.93408203125, 18.45720481872558593, 1.198794841766357421, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+152, 108723, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8406.53125, 1127.5242919921875, 18.32019615173339843, 0.696434736251831054, 120, 0, 0, 8090, 1534, 0, 0, 0, 0, 45745), -- Kihra (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+153, 108750, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8378.9013671875, 1152.388916015625, 18.027130126953125, 3.774073362350463867, 120, 0, 0, 8090, 0, 0, 0, 0, 0, 45745), -- Eunna Young (Area: Stormwind Harbor - Difficulty: 0) (Auras: 42459 - Dual Wield) +(@CGUID+154, 107829, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8399.0673828125, 1121.640625, 18.16595458984375, 1.515712499618530273, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+155, 107823, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8403.67578125, 1122.10595703125, 18.26777076721191406, 1.342660903930664062, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+156, 108749, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8377.1962890625, 1142.623291015625, 18.09779739379882812, 3.717847347259521484, 120, 0, 0, 8090, 0, 0, 0, 0, 0, 45745), -- Bridgette Hicks (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+157, 107829, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8377.560546875, 1155.6666259765625, 18.13140678405761718, 3.77096414566040039, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+158, 29019, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8373.84375, 1252.470703125, 5.230222702026367187, 1.653323292732238769, 120, 10, 0, 11791, 0, 1, 0, 0, 0, 45745), -- Dockhand (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(@CGUID+159, 108747, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8378.142578125, 1144.66845703125, 18.074066162109375, 3.166964530944824218, 120, 0, 0, 8090, 100, 0, 0, 0, 0, 45745), -- Kymba Quickwidget (Area: Stormwind Harbor - Difficulty: 0) (Auras: 42459 - Dual Wield) +(@CGUID+160, 29016, 0, 1519, 4411, '0', 6666, 0, 0, 3, -8415.4892578125, 1113.46875, 19.11725616455078125, 3.525565147399902343, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Steam Tank Engineer (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+161, 107839, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8375.36328125, 1146.8992919921875, 18.0749053955078125, 3.206325292587280273, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+162, 107826, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8376.154296875, 1149.9791259765625, 18.06537818908691406, 3.216290235519409179, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+163, 108755, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8393.4794921875, 1124.7066650390625, 18.16493606567382812, 1.829251885414123535, 120, 0, 0, 8090, 1534, 0, 0, 0, 0, 45745), -- Stormsinger Taalos (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+164, 108754, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8377.642578125, 1146.6163330078125, 18.06423759460449218, 3.70283365249633789, 120, 0, 0, 8090, 1534, 0, 0, 0, 0, 45745), -- Fingall Flamehammer (Area: Stormwind Harbor - Difficulty: 0) (Auras: 42459 - Dual Wield) +(@CGUID+165, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8365.546875, 1195.1480712890625, 5.755657672882080078, 1.466076612472534179, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+166, 108756, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8387.033203125, 1124.91845703125, 18.28472328186035156, 1.856171011924743652, 120, 0, 0, 8090, 1534, 0, 0, 0, 0, 45745), -- Navea the Purifier (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+167, 107835, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8347.263671875, 1226.892333984375, 5.313573360443115234, 2.717757940292358398, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+168, 107823, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8382.7880859375, 1125.9566650390625, 18.58748817443847656, 2.377802848815917968, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+169, 108586, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8343.9580078125, 1214.3941650390625, 5.261771678924560546, 4.509032249450683593, 120, 0, 0, 3236, 1534, 0, 0, 0, 0, 45745), -- Len-Shu (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+180, 108758, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8390.169921875, 1125.6771240234375, 18.20318794250488281, 1.576051235198974609, 120, 0, 0, 8090, 1534, 0, 0, 0, 0, 45745), -- Lightshielder Baetrix (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+181, 107823, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8375.5400390625, 1137.2257080078125, 18.22733306884765625, 3.009039640426635742, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+182, 107835, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8375.4130859375, 1140.4427490234375, 18.15145301818847656, 2.935845375061035156, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+183, 107839, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8396.705078125, 1120.1353759765625, 18.12257003784179687, 1.664530515670776367, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+184, 107826, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8384.2412109375, 1123.9375, 18.44595909118652343, 2.142566442489624023, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+185, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8406.751953125, 1113.1319580078125, 18.14539337158203125, 1.343903541564941406, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+186, 107835, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8349.5087890625, 1227.907958984375, 5.313571929931640625, 5.875719547271728515, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+187, 108745, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8382.904296875, 1129.7725830078125, 18.58471107482910156, 2.558037996292114257, 120, 0, 0, 8090, 100, 0, 0, 0, 0, 45745), -- Antone Sula (Area: Stormwind Harbor - Difficulty: 0) (Auras: 42459 - Dual Wield) +(@CGUID+188, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8369.4794921875, 1249.177001953125, 5.313549518585205078, 4.642575740814208984, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+189, 29019, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8363.470703125, 1245.5452880859375, 5.313354015350341796, 2.076941728591918945, 120, 10, 0, 11791, 0, 1, 0, 0, 0, 45745), -- Dockhand (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(@CGUID+190, 107833, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8376.08203125, 1133.9583740234375, 18.35461616516113281, 2.844053506851196289, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+191, 107835, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8388.7255859375, 1121.6649169921875, 18.19020462036132812, 1.991399645805358886, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+192, 107839, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8345.263671875, 1204.267333984375, 5.554970264434814453, 1.486075282096862792, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+193, 108759, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8380.7451171875, 1133.09033203125, 18.30968666076660156, 2.419204950332641601, 120, 0, 0, 8090, 1534, 0, 0, 0, 0, 45745), -- Loranea (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+194, 108753, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8378.671875, 1135.6510009765625, 18.186431884765625, 2.651986360549926757, 120, 0, 0, 6470, 3801, 0, 0, 0, 0, 45745), -- Rorin Rivershade (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+195, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8356.154296875, 1195.38134765625, 5.736004352569580078, 1.692969322204589843, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+196, 107835, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8394, 1121.0833740234375, 18.12985420227050781, 1.712321996688842773, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+197, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8357.185546875, 1147.6927490234375, 18.73090362548828125, 3.305382251739501953, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+198, 29016, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8429.484375, 1103.31298828125, 19.0691680908203125, 3.665191411972045898, 120, 10, 0, 11791, 0, 1, 0, 0, 0, 45745), -- Steam Tank Engineer (Area: Stormwind Harbor - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+199, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8384.86328125, 1112.578125, 18.09598541259765625, 1.867502331733703613, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+200, 108705, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8359.0400390625, 1143.814208984375, 18.51388931274414062, 3.205023527145385742, 120, 0, 0, 32360, 0, 0, 0, 0, 0, 45745), -- Sergeant Crowler (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+201, 29016, 0, 1519, 4411, '0', 6666, 0, 0, 2, -8347.2431640625, 1155.7244873046875, 19.13516807556152343, 5.759586334228515625, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Steam Tank Engineer (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+202, 107826, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8334.375, 1209.2291259765625, 5.420139312744140625, 4.49941110610961914, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+203, 108138, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8332.37890625, 1189.8507080078125, 5.806749820709228515, 1.699095726013183593, 120, 0, 0, 3301, 0, 0, 0, 0, 0, 45745), -- Rebecca Laughlin (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+204, 29016, 0, 1519, 4411, '0', 6666, 0, 0, 3, -8347.384765625, 1144.263916015625, 19.13516807556152343, 1.082104086875915527, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Steam Tank Engineer (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+205, 108587, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8333.138671875, 1213.453125, 5.293403148651123046, 1.795453071594238281, 120, 0, 0, 3236, 1534, 0, 0, 0, 0, 45745), -- Su-Lai Snowpetal (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+206, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8356.890625, 1140.4010009765625, 18.46701431274414062, 3.109834909439086914, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+207, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8394.17578125, 1291.9520263671875, 5.313550472259521484, 0.01745329238474369, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+208, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8305.59375, 1196.0103759765625, 5.706089496612548828, 1.378810048103332519, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+209, 1308, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8324.814453125, 1194.8228759765625, 5.926961421966552734, 2.217727184295654296, 120, 0, 0, 12381, 0, 0, 0, 0, 0, 45745), -- Owen Vaughn (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+210, 107827, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8323.67578125, 1250.3367919921875, 5.313563346862792968, 1.479735374450683593, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+211, 107829, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8328.6826171875, 1208.892333984375, 5.439281940460205078, 5.158908367156982421, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+212, 108588, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8326.171875, 1206.71875, 5.506467342376708984, 2.813979148864746093, 120, 0, 0, 3236, 1534, 0, 0, 0, 0, 45745), -- Haomi (Area: Stormwind Harbor - Difficulty: 0) (Auras: 42459 - Dual Wield) +(@CGUID+213, 107823, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8338.6630859375, 1263.248291015625, 5.24458169937133789, 1.983043074607849121, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+214, 107841, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8336.8095703125, 1263.2413330078125, 5.244242668151855468, 1.837407588958740234, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+215, 107839, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8325.1787109375, 1236.720458984375, 5.517617225646972656, 5.830356121063232421, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+216, 107829, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8325.3173828125, 1233.873291015625, 5.5523529052734375, 0.023526364937424659, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+217, 29016, 0, 1519, 4411, '0', 6666, 0, 0, 2, -8325.0283203125, 1144.470458984375, 19.07303810119628906, 2.39110112190246582, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Steam Tank Engineer (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+218, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8369.4404296875, 1292.12548828125, 5.313552379608154296, 3.124139308929443359, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+219, 108533, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8317.986328125, 1224.3177490234375, 5.313580989837646484, 0.049695119261741638, 120, 0, 0, 3560, 0, 0, 0, 0, 0, 45745), -- Lenny "Fingers" McCoy (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+220, 29016, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8341.822265625, 1144.2896728515625, 19.152130126953125, 2.473378658294677734, 120, 10, 0, 11791, 0, 1, 0, 0, 0, 45745), -- Steam Tank Engineer (Area: Stormwind Harbor - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+221, 107841, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8322.3818359375, 1235.015625, 5.313561439514160156, 2.990770339965820312, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+222, 108487, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8314.326171875, 1249.3072509765625, 5.31356668472290039, 1.600097537040710449, 120, 0, 0, 3236, 1534, 0, 0, 0, 0, 45745), -- Ella (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+223, 108488, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8311.7783203125, 1249.1788330078125, 5.31356668472290039, 1.489748835563659667, 120, 0, 0, 3236, 1534, 0, 0, 0, 0, 45745), -- Sam (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+224, 108485, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8313.033203125, 1249.2760009765625, 5.31356668472290039, 1.641142129898071289, 120, 0, 0, 3236, 1534, 0, 0, 0, 0, 45745), -- Alaina Hearthsong (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+225, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8303.4873046875, 1249.7486572265625, 5.313550472259521484, 4.799655437469482421, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+226, 108895, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8298.0244140625, 1286.193359375, 5.313985824584960937, 5.089562416076660156, 120, 10, 0, 3236, 0, 1, 0, 0, 0, 45745), -- Ironforge Blastsmith (Area: Stormwind Harbor - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+227, 108895, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8298.28125, 1290.201416015625, 5.392902374267578125, 3.110714912414550781, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Ironforge Blastsmith (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+228, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8369.517578125, 1341.7943115234375, 5.313549518585205078, 3.141592741012573242, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+229, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8395.0830078125, 1341.68408203125, 5.313553333282470703, 0, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+230, 108895, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8300.1044921875, 1260.5382080078125, 5.33747720718383789, 1.4535064697265625, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Ironforge Blastsmith (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+231, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8299.763671875, 1301.65283203125, 5.321547985076904296, 0.022117020562291145, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+232, 108895, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8298.53125, 1275.545166015625, 5.376166820526123046, 4.029369831085205078, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Ironforge Blastsmith (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+233, 43102, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8451.5595703125, 1315.719970703125, -51.7682685852050781, 0.436332315206527709, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Rock Lobster (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+234, 29019, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8467.77734375, 1318.8609619140625, 5.3133544921875, 5.16617441177368164, 120, 10, 0, 11791, 0, 1, 0, 0, 0, 45745), -- Dockhand (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(@CGUID+235, 43102, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8354.4296875, 1331.8800048828125, -45.9962692260742187, 0.820304751396179199, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Rock Lobster (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+236, 43102, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8416.330078125, 1357, -54.0679664611816406, 1.797689080238342285, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Rock Lobster (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+237, 43102, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8313.509765625, 1327.719970703125, -52.8567695617675781, 2.042035102844238281, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Rock Lobster (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+238, 107839, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8300.8173828125, 1318.2257080078125, 5.3287353515625, 6.251865863800048828, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+239, 107827, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8300.984375, 1334.126708984375, 5.335453033447265625, 6.182022571563720703, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+240, 107841, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8296.3486328125, 1326.3038330078125, 5.3375244140625, 0.001139832893386483, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+241, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8460.9677734375, 1350.1051025390625, 5.313559532165527343, 3.159045934677124023, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+242, 107835, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8300.8095703125, 1326.279541015625, 5.33869791030883789, 0.001139832893386483, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+243, 107826, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8300.798828125, 1322.3004150390625, 5.333777904510498046, 6.219724655151367187, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+244, 107823, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8300.923828125, 1330.1910400390625, 5.339847564697265625, 0.023749005049467086, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+245, 107829, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8300.8955078125, 1337.9635009765625, 5.330959796905517578, 6.216236591339111328, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+246, 107841, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8296.3388671875, 1322.32470703125, 5.332173824310302734, 6.21972513198852539, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+247, 107826, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8345.064453125, 1369.875, 8.924798011779785156, 3.143033981323242187, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+248, 107835, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8296.359375, 1318.248291015625, 5.327135086059570312, 6.251866340637207031, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+249, 108921, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8335.7451171875, 1362.5625, 14.90705204010009765, 3.30626225471496582, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Deck Hand (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+250, 109412, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8335.8525390625, 1364.654541015625, 9.074026107788085937, 1.422418832778930664, 120, 0, 0, 6472, 100, 0, 0, 0, 0, 45745), -- Lorcan Flintedge (Area: Stormwind Harbor - Difficulty: 0) (Auras: 42459 - Dual Wield) +(@CGUID+251, 108923, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8335.65625, 1374.3941650390625, 9.147710800170898437, 1.145597577095031738, 120, 0, 0, 6472, 0, 0, 0, 0, 0, 45745), -- First Mate Tidesong (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+252, 107839, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8300.953125, 1341.9322509765625, 5.326524734497070312, 0.0370648093521595, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+253, 107827, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8296.435546875, 1337.9879150390625, 5.324470043182373046, 6.216236591339111328, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+254, 108920, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8336.8720703125, 1377.1822509765625, 9.173743247985839843, 0.343310236930847167, 120, 0, 0, 6472, 0, 0, 0, 0, 0, 45745), -- Captain Angelica (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+255, 107835, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8296.4638671875, 1330.2135009765625, 5.333245277404785156, 0.023749005049467086, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+256, 107823, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8327.66015625, 1375.6875, 8.962499618530273437, 6.216236591339111328, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+257, 107823, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8296.5244140625, 1334.1510009765625, 5.328850746154785156, 6.182022571563720703, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+258, 43102, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8355.8603515625, 1388.56005859375, -52.7305679321289062, 1.535889744758605957, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Rock Lobster (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+259, 107826, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8301.1923828125, 1346.236083984375, 5.321980953216552734, 0.005607551895081996, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+260, 107835, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8301.1982421875, 1350.013916015625, 5.317695140838623046, 6.256113529205322265, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+261, 107826, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8296.734375, 1346.2586669921875, 5.319905757904052734, 0.005607551895081996, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+262, 108921, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8335.4462890625, 1392.1875, 9.540899276733398437, 1.982496380805969238, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Deck Hand (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+263, 107835, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8296.4931640625, 1341.9566650390625, 5.322306632995605468, 0.0370648093521595, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+264, 68, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8300.5263671875, 1359.9461669921875, 5.313493728637695312, 6.279373645782470703, 120, 0, 0, 17687, 0, 0, 0, 0, 0, 45745), -- Stormwind City Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+265, 107835, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8296.73828125, 1350.0364990234375, 5.317857742309570312, 6.256113529205322265, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+266, 108895, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8284.6328125, 1283.8702392578125, 5.313354969024658203, 4.373723983764648437, 120, 10, 0, 3236, 0, 1, 0, 0, 0, 45745), -- Ironforge Blastsmith (Area: Stormwind Harbor - Difficulty: 0) (possible waypoints or random movement) +(@CGUID+267, 108895, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8283.9375, 1265.7691650390625, 5.322933673858642578, 6.160633087158203125, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Ironforge Blastsmith (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+268, 108895, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8281.6787109375, 1274.6458740234375, 5.326344966888427734, 5.572930812835693359, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Ironforge Blastsmith (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+269, 108895, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8280.7080078125, 1260.2274169921875, 5.316996574401855468, 1.054499387741088867, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Ironforge Blastsmith (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+270, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8291.7373046875, 1170.5264892578125, 17.7196044921875, 3.181014299392700195, 120, 10, 0, 23582, 0, 1, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(@CGUID+271, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8295.93359375, 1195.884033203125, 5.709116458892822265, 1.675516128540039062, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+272, 29016, 0, 1519, 4411, '0', 6666, 0, 0, 3, -8310.87109375, 1157.794189453125, 18.71750640869140625, 4.415682792663574218, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Steam Tank Engineer (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+273, 29016, 0, 1519, 4411, '0', 6666, 0, 0, 2, -8311.494140625, 1146.9605712890625, 19.07639503479003906, 2.670353651046752929, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Steam Tank Engineer (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+274, 107835, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8275.576171875, 1208.8646240234375, 5.511489391326904296, 5.408518314361572265, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+275, 108192, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8272.9775390625, 1205.38720703125, 5.678043365478515625, 2.077126502990722656, 120, 0, 0, 3236, 1534, 0, 0, 0, 0, 45745), -- Milton Sheaf (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+276, 107833, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8272.013671875, 1210.90625, 5.433180809020996093, 0.34286653995513916, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+277, 107835, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8277.6005859375, 1203.2447509765625, 5.677919864654541015, 2.4221038818359375, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+278, 107826, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8263.6025390625, 1226.3541259765625, 5.313575267791748046, 0.534111857414245605, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+279, 107835, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8260.501953125, 1224.3038330078125, 5.313578605651855468, 0.682014763355255126, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+280, 107839, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8268.8525390625, 1206.032958984375, 5.636074542999267578, 4.783174037933349609, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+281, 36799, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8275.51953125, 1247.449951171875, 5.313563346862792968, 3.822271108627319335, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Recruiter Burns (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+282, 29154, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8345.115234375, 1105.473388671875, 57.34548568725585937, 5.445427417755126953, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Thargold Ironwing (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+283, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8277.6826171875, 1250.190185546875, 5.313550472259521484, 4.485496044158935546, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+284, 68, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8334.2080078125, 1110.4403076171875, 57.34548568725585937, 2.181661605834960937, 120, 0, 0, 17687, 0, 0, 0, 0, 0, 45745), -- Stormwind City Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+285, 107833, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8263.1513671875, 1230.498291015625, 5.313580036163330078, 0.070741012692451477, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+286, 107841, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8264.888671875, 1238.013916015625, 5.313573360443115234, 0.149186015129089355, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+287, 29088, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8322.8759765625, 1108.40087890625, 57.34549331665039062, 1.274090290069580078, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Stormwind Cannoneer (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+288, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8256.330078125, 1214.1910400390625, 5.273015499114990234, 1.76960146427154541, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+289, 107823, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8259.8095703125, 1239.46533203125, 5.313570022583007812, 6.210344791412353515, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+290, 107835, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8255.8017578125, 1237.513916015625, 5.313571929931640625, 0.095033302903175354, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+291, 108203, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8250.767578125, 1242.720458984375, 5.313561439514160156, 4.093451499938964843, 120, 0, 0, 3236, 1534, 0, 0, 0, 0, 45745), -- Matthew Deyling (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+292, 107841, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8255.486328125, 1232.7899169921875, 5.313570022583007812, 0.146918073296546936, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+293, 108204, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8239.34375, 1231.2691650390625, 5.313571929931640625, 2.267637491226196289, 120, 0, 0, 3236, 1534, 0, 0, 0, 0, 45745), -- Esmund Brightshield (Area: Stormwind Harbor - Difficulty: 0) (Auras: 182938 - Arcane Channeling) +(@CGUID+294, 108895, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8278.5107421875, 1288.517333984375, 5.33099365234375, 2.298360109329223632, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Ironforge Blastsmith (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+295, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8280.716796875, 1301.5416259765625, 5.313327789306640625, 3.106700897216796875, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+296, 108205, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8240.263671875, 1241.517333984375, 5.313564777374267578, 4.089086532592773437, 120, 0, 0, 3236, 1534, 0, 0, 0, 0, 45745), -- Bloodrose (Area: Stormwind Harbor - Difficulty: 0) (Auras: 182938 - Arcane Channeling) +(@CGUID+297, 108896, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8284.326171875, 1333.8697509765625, 5.327531814575195312, 3.209949254989624023, 120, 0, 0, 9708, 0, 0, 0, 0, 0, 45745), -- Commander Sharp (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+298, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8210.998046875, 1196.1644287109375, 5.711739540100097656, 1.308996915817260742, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+299, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8281.015625, 1359.8524169921875, 5.327433586120605468, 3.177756547927856445, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+300, 108910, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8282.0517578125, 1369.9930419921875, 5.323863029479980468, 0.636360764503479003, 120, 0, 0, 6472, 0, 0, 0, 0, 0, 45745), -- 7th Legion Submariner (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+301, 108910, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8279.6630859375, 1368.37158203125, 5.307554244995117187, 0.5712624192237854, 120, 0, 0, 6472, 0, 0, 0, 0, 0, 45745), -- 7th Legion Submariner (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+302, 108910, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8281.294921875, 1380.5364990234375, 5.271648406982421875, 6.029977321624755859, 120, 0, 0, 6472, 0, 0, 0, 0, 0, 45745), -- 7th Legion Submariner (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+303, 108910, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8282.267578125, 1376.6180419921875, 5.279612541198730468, 6.224997520446777343, 120, 0, 0, 6472, 0, 0, 0, 0, 0, 45745), -- 7th Legion Submariner (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+304, 108911, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8275.1787109375, 1377.2569580078125, 5.9588165283203125, 2.948133230209350585, 120, 0, 0, 48540, 0, 0, 0, 0, 0, 45745), -- Duke August Foehammer (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+305, 108910, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8283.314453125, 1379.6910400390625, 5.271128654479980468, 6.055790901184082031, 120, 0, 0, 6472, 0, 0, 0, 0, 0, 45745), -- 7th Legion Submariner (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+306, 108910, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8283.638671875, 1374.2725830078125, 5.315975666046142578, 0.229304566979408264, 120, 0, 0, 6472, 0, 0, 0, 0, 0, 45745), -- 7th Legion Submariner (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+307, 108910, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8278.9892578125, 1380.71533203125, 5.299350261688232421, 5.540805816650390625, 120, 0, 0, 6472, 0, 0, 0, 0, 0, 45745), -- 7th Legion Submariner (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+308, 108910, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8279.16015625, 1372.9617919921875, 5.307575225830078125, 0.714596450328826904, 120, 0, 0, 6472, 0, 0, 0, 0, 0, 45745), -- 7th Legion Submariner (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+309, 108910, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8282.0244140625, 1383.4305419921875, 5.258905887603759765, 5.658954143524169921, 120, 0, 0, 6472, 0, 0, 0, 0, 0, 45745), -- 7th Legion Submariner (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+310, 108910, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8281.86328125, 1372.6492919921875, 5.30363321304321289, 0.418831616640090942, 120, 0, 0, 6472, 0, 0, 0, 0, 0, 45745), -- 7th Legion Submariner (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+311, 108910, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8283.3720703125, 1377.4322509765625, 5.28874063491821289, 6.203416347503662109, 120, 0, 0, 6472, 0, 0, 0, 0, 0, 45745), -- 7th Legion Submariner (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+312, 108910, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8279.3095703125, 1384.0382080078125, 5.291071414947509765, 5.438819408416748046, 120, 0, 0, 6472, 0, 0, 0, 0, 0, 45745), -- 7th Legion Submariner (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+313, 108916, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8302.408203125, 1392.9461669921875, 4.774630546569824218, 5.544354915618896484, 120, 0, 0, 9708, 0, 0, 0, 0, 0, 45745), -- Knight Dameron (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+314, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8303.314453125, 1383.2552490234375, 5.313564777374267578, 0.085785746574401855, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+315, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8302.9287109375, 1395.9757080078125, 4.649316787719726562, 6.194953441619873046, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+316, 68, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8277.9599609375, 1393.3819580078125, 4.737194061279296875, 3.209982633590698242, 120, 0, 0, 17687, 0, 0, 0, 0, 0, 45745), -- Stormwind City Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+317, 43102, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8289.7197265625, 1428.8399658203125, -68.68426513671875, 2.844886541366577148, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Rock Lobster (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+318, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8201.576171875, 1196.40673828125, 5.699021339416503906, 1.815142393112182617, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+319, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8178.6630859375, 1130.51708984375, 18.02756881713867187, 2.251474618911743164, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+320, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8125.27587890625, 1245.34765625, 8.541004180908203125, 4.258603572845458984, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+321, 29152, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8113.62841796875, 1258.601806640625, 7.892336368560791015, 2.603639125823974609, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Stormwind Dock Worker (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+322, 29152, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8108.94384765625, 1252.8101806640625, 54.65299224853515625, 2.076941728591918945, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Stormwind Dock Worker (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+323, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8097.7177734375, 1227.8773193359375, 7.885998725891113281, 3.857177734375, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+324, 29152, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8100.65283203125, 1255.560546875, 37.78493499755859375, 2.408554315567016601, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Stormwind Dock Worker (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+325, 29152, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8149.84912109375, 1301.56640625, 29.30518341064453125, 2.478367567062377929, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Stormwind Dock Worker (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+326, 29152, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8090.2021484375, 1218.0328369140625, 7.802228450775146484, 6.09725046157836914, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Stormwind Dock Worker (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+327, 29152, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8106.49658203125, 1288.8531494140625, 23.19568061828613281, 2.548180580139160156, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Stormwind Dock Worker (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+328, 29152, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8116.6728515625, 1289.144287109375, 5.776582717895507812, 3.473205089569091796, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Stormwind Dock Worker (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+329, 29152, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8077.28662109375, 1298.0386962890625, 17.40115737915039062, 0.890567183494567871, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Stormwind Dock Worker (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+330, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8232.7490234375, 1097.4337158203125, 18.00304985046386718, 1.727875947952270507, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+331, 29088, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8306.1845703125, 1088.3875732421875, 57.34549331665039062, 0.349065840244293212, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Stormwind Cannoneer (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+332, 29088, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8314.4384765625, 1099.1129150390625, 57.34549331665039062, 0.541052043437957763, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Stormwind Cannoneer (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+333, 68, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8394.59765625, 1071.2340087890625, 31.71361732482910156, 2.426007747650146484, 120, 0, 0, 17687, 0, 0, 0, 0, 0, 45745), -- Stormwind City Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+334, 107823, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8427.84765625, 1078.6597900390625, 19.34542083740234375, 2.087890625, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) (Auras: 145953 - Cosmetic - Sleep Zzz) +(@CGUID+335, 107827, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8452.513671875, 1095.1353759765625, 19.13517379760742187, 3.890377759933471679, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+336, 107827, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8441.419921875, 1077.1336669921875, 19.23015975952148437, 1.793367385864257812, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) (Auras: 145953 - Cosmetic - Sleep Zzz) +(@CGUID+337, 107841, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8450.4033203125, 1078.0364990234375, 19.1351776123046875, 1.608866691589355468, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+338, 107841, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8459.060546875, 1077.1302490234375, 19.12939643859863281, 1.56719362735748291, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) (Auras: 145953 - Cosmetic - Sleep Zzz) +(@CGUID+339, 107936, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8482.2158203125, 1089.703125, 18.04474067687988281, 3.116557836532592773, 120, 0, 0, 32360, 0, 0, 0, 0, 0, 45745), -- Officer Carven (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+340, 107935, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8484.6357421875, 1087.03125, 18.02981376647949218, 1.652215003967285156, 120, 0, 0, 32360, 0, 0, 0, 0, 0, 45745), -- Officer Blythe (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+341, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8438.357421875, 1048.9908447265625, 46.17970657348632812, 0.788933813571929931, 120, 10, 0, 23582, 0, 1, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(@CGUID+342, 107933, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8512.5380859375, 1078.8958740234375, 19.5770111083984375, 1.562319517135620117, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Recruiter Gearburns (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+343, 107841, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8511.98828125, 1085.19140625, 18.06924247741699218, 4.757324695587158203, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+344, 107934, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8495.111328125, 1078.69970703125, 18.02757644653320312, 1.562319517135620117, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Recruiter Lee (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+345, 107827, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8527.8486328125, 1112.4722900390625, 19.13516616821289062, 2.232239723205566406, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+346, 68, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8491.40625, 1072.4617919921875, 18.02758026123046875, 1.601266026496887207, 120, 0, 0, 17687, 0, 0, 0, 0, 0, 45745), -- Stormwind City Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+347, 107931, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8503.611328125, 1078.6163330078125, 18.02757644653320312, 1.562319517135620117, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Recruiter Barker (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+348, 107833, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8503.748046875, 1082.1632080078125, 18.02757644653320312, 4.704221725463867187, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+349, 107835, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8503.8076171875, 1086.4635009765625, 18.02757644653320312, 4.730600833892822265, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+350, 107835, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8529.357421875, 1114.41845703125, 19.13516616821289062, 5.390200614929199218, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+351, 107823, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8503.841796875, 1084.345458984375, 18.02757644653320312, 4.829215049743652343, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+352, 68, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8516.685546875, 1073.1771240234375, 18.02757644653320312, 1.580089092254638671, 120, 0, 0, 17687, 0, 0, 0, 0, 0, 45745), -- Stormwind City Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+353, 107823, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8539.2744140625, 1088.046875, 19.11594390869140625, 6.22437286376953125, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) (Auras: 145953 - Cosmetic - Sleep Zzz) +(@CGUID+354, 29088, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8480.427734375, 1039.580810546875, 59.82266616821289062, 0.855211317539215087, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Stormwind Cannoneer (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+355, 108142, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8555.783203125, 1095.29345703125, 19.13516616821289062, 1.630129456520080566, 120, 0, 0, 3236, 1534, 0, 0, 0, 0, 45745), -- Archibald Arlison (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+356, 107841, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8558.6806640625, 1100.170166015625, 19.13516616821289062, 0.477241665124893188, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+357, 107826, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8556.4736328125, 1101.2708740234375, 19.13516616821289062, 3.602466583251953125, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+358, 107829, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8565.892578125, 1099.13720703125, 19.13516616821289062, 2.632296562194824218, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+359, 107823, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8562.126953125, 1087.829833984375, 19.13516616821289062, 1.016773104667663574, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) (Auras: 145953 - Cosmetic - Sleep Zzz) +(@CGUID+360, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8569.2705078125, 1116.4617919921875, 18.44173812866210937, 1.378810048103332519, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+361, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8590.689453125, 1126.46533203125, 18.43061447143554687, 0.855211317539215087, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+362, 29088, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8536.875, 1044.09716796875, 59.82855224609375, 1.902408838272094726, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Stormwind Cannoneer (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+363, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8589.333984375, 1021.82977294921875, 96.21038055419921875, 5.441699981689453125, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+364, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8420.30859375, 1035.177734375, 68.51216888427734375, 1.774838924407958984, 120, 10, 0, 23582, 0, 1, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) (possible waypoints or random movement) +(@CGUID+365, 29019, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8516.08203125, 993.7734375, 59.47325515747070312, 5.08168649673461914, 120, 0, 0, 11791, 0, 0, 0, 0, 0, 45745), -- Dockhand (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+366, 68, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8485.1923828125, 979.69989013671875, 72.82076263427734375, 2.076941728591918945, 120, 0, 0, 17687, 0, 0, 0, 0, 0, 45745), -- Stormwind City Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+367, 29712, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8486.630859375, 1349.1773681640625, 5.31356048583984375, 0.069813169538974761, 120, 0, 0, 23582, 0, 0, 0, 0, 0, 45745), -- Stormwind Harbor Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+368, 107841, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8512.2578125, 1091.185302734375, 18.06924247741699218, 4.757320880889892578, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+369, 107826, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8512.13671875, 1088.1314697265625, 18.06924247741699218, 4.756018638610839843, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+370, 107823, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8512.44140625, 1094.1827392578125, 18.06924247741699218, 4.694812297821044921, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+371, 108410, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8477.673828125, 1221.046875, 5.203011989593505859, 4.50206613540649414, 120, 0, 0, 3236, 1534, 0, 0, 0, 0, 45745), -- Thurgrum Deepforge (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+372, 68, 0, 1519, 4411, '0', 6666, 0, 0, 1, -8531.9423828125, 1130.517333984375, 18.3087921142578125, 1.491311073303222656, 120, 0, 0, 17687, 0, 0, 0, 0, 0, 45745), -- Stormwind City Guard (Area: Stormwind Harbor - Difficulty: 0) (Auras: ) +(@CGUID+373, 107833, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8345.2587890625, 1376.376708984375, 8.957735061645507812, 3.143033981323242187, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+374, 107826, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8512.150390625, 1082.1141357421875, 18.06924247741699218, 4.741685867309570312, 120, 0, 0, 3236, 0, 0, 0, 0, 0, 45745), -- Alliance Recruit (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+375, 108691, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8557.630859375, 1197.1949462890625, 38.7316131591796875, 3.546323776245117187, 120, 0, 0, 32360, 0, 0, 0, 0, 0, 45745), -- Gnomeregan Gyrocopter (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+376, 108691, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8537.8125, 1169.4010009765625, 17.73902320861816406, 1.583544850349426269, 120, 0, 0, 32360, 0, 0, 0, 0, 0, 45745), -- Gnomeregan Gyrocopter (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+377, 108691, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8557.564453125, 1178.26708984375, 38.60478973388671875, 1.26516878604888916, 120, 0, 0, 32360, 0, 0, 0, 0, 0, 45745), -- Gnomeregan Gyrocopter (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+378, 108691, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8521.2158203125, 1169.5069580078125, 17.6475830078125, 1.465020298957824707, 120, 0, 0, 32360, 0, 0, 0, 0, 0, 45745), -- Gnomeregan Gyrocopter (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+379, 108691, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8484.470703125, 1192.953857421875, 38.72677230834960937, 5.609706401824951171, 120, 0, 0, 32360, 0, 0, 0, 0, 0, 45745), -- Gnomeregan Gyrocopter (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+380, 108691, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8553.451171875, 1169.5086669921875, 17.7916107177734375, 1.456831097602844238, 120, 0, 0, 32360, 0, 0, 0, 0, 0, 45745), -- Gnomeregan Gyrocopter (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+381, 108691, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8495.564453125, 1169.74658203125, 17.79158592224121093, 1.465020298957824707, 120, 0, 0, 32360, 0, 0, 0, 0, 0, 45745), -- Gnomeregan Gyrocopter (Area: Stormwind Harbor - Difficulty: 0) +(@CGUID+382, 108691, 0, 1519, 4411, '0', 6666, 0, 0, 0, -8512.16015625, 1169.640625, 17.79159355163574218, 1.583544850349426269, 120, 0, 0, 32360, 0, 0, 0, 0, 0, 45745); -- Gnomeregan Gyrocopter (Area: Stormwind Harbor - Difficulty: 0) + +-- Creature Addon +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+382; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+358, 0, 0, 0, 1, 69, 0, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+359, 0, 0, 0, 1, 0, 0, 0, 0, 0, '145953'), -- Alliance Recruit - 145953 - Cosmetic - Sleep Zzz +(@CGUID+346, 0, 2410, 0, 257, 0, 0, 0, 0, 0, ''), -- Stormwind City Guard +(@CGUID+352, 0, 2410, 0, 257, 0, 0, 0, 0, 0, ''), -- Stormwind City Guard +(@CGUID+372, 0, 2410, 0, 257, 0, 0, 0, 0, 0, ''), -- Stormwind City Guard +(@CGUID+87, 0, 2410, 0, 257, 0, 0, 0, 0, 0, ''), -- Stormwind City Guard +(@CGUID+149, 0, 0, 0, 1, 415, 0, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+72, 0, 0, 0, 1, 69, 0, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+335, 0, 0, 0, 1, 69, 0, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+24, 0, 0, 0, 1, 69, 0, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+3, 0, 0, 0, 1, 69, 0, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+13, 0, 0, 0, 1, 69, 0, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+28, 0, 0, 0, 1, 0, 0, 0, 0, 0, '145953'), -- Alliance Recruit - 145953 - Cosmetic - Sleep Zzz +(@CGUID+89, 0, 0, 0, 1, 0, 0, 0, 0, 0, '145953'), -- Alliance Recruit - 145953 - Cosmetic - Sleep Zzz +(@CGUID+33, 0, 0, 0, 1, 0, 0, 0, 0, 0, '145953'), -- Alliance Recruit - 145953 - Cosmetic - Sleep Zzz +(@CGUID+140, 0, 0, 0, 1, 0, 0, 0, 0, 0, '145953'), -- Alliance Recruit - 145953 - Cosmetic - Sleep Zzz +(@CGUID+334, 0, 0, 0, 1, 0, 0, 0, 0, 0, '145953'), -- Alliance Recruit - 145953 - Cosmetic - Sleep Zzz +(@CGUID+336, 0, 0, 0, 1, 0, 0, 0, 0, 0, '145953'), -- Alliance Recruit - 145953 - Cosmetic - Sleep Zzz +(@CGUID+338, 0, 0, 0, 1, 0, 0, 0, 0, 0, '145953'), -- Alliance Recruit - 145953 - Cosmetic - Sleep Zzz +(@CGUID+122, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+107, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+137, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+337, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+88, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+62, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+35, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+82, 0, 0, 0, 1, 613, 0, 0, 0, 0, ''), -- Gnome Engineer +(@CGUID+81, 0, 0, 0, 1, 613, 0, 0, 0, 0, ''), -- Gnome Engineer +(@CGUID+42, 0, 0, 0, 1, 69, 0, 0, 0, 0, ''), -- Gnome Engineer +(@CGUID+21, 0, 0, 0, 1, 69, 0, 0, 0, 0, ''), -- Gnome Engineer +(@CGUID+290, 0, 0, 0, 1, 426, 0, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+285, 0, 0, 0, 1, 426, 0, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+276, 0, 0, 0, 1, 415, 0, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+289, 0, 0, 0, 1, 426, 0, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+280, 0, 0, 0, 1, 483, 0, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+292, 0, 0, 0, 1, 426, 0, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+274, 0, 0, 0, 1, 483, 0, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+277, 0, 0, 0, 1, 483, 0, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+288, 0, 2410, 0, 257, 0, 0, 0, 0, 0, ''), -- Stormwind Harbor Guard +(@CGUID+238, 0, 0, 0, 1, 0, 7685, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+248, 0, 0, 0, 1, 0, 7685, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+243, 0, 0, 0, 1, 0, 7685, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+246, 0, 0, 0, 1, 0, 7685, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+242, 0, 0, 0, 1, 0, 7685, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+240, 0, 0, 0, 1, 0, 7685, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+244, 0, 0, 0, 1, 0, 7685, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+255, 0, 0, 0, 1, 0, 7685, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+239, 0, 0, 0, 1, 0, 7685, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+257, 0, 0, 0, 1, 0, 7685, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+245, 0, 0, 0, 1, 0, 7685, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+253, 0, 0, 0, 1, 0, 7685, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+252, 0, 0, 0, 1, 0, 7685, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+263, 0, 0, 0, 1, 0, 7685, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+259, 0, 0, 0, 1, 0, 7685, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+261, 0, 0, 0, 1, 0, 7685, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+260, 0, 0, 0, 1, 0, 7685, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+265, 0, 0, 0, 1, 0, 7685, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+269, 0, 0, 0, 1, 69, 0, 0, 0, 0, ''), -- Ironforge Blastsmith +(@CGUID+268, 0, 0, 0, 1, 69, 0, 0, 0, 0, ''), -- Ironforge Blastsmith +(@CGUID+294, 0, 0, 0, 1, 69, 0, 0, 0, 0, ''), -- Ironforge Blastsmith +(@CGUID+232, 0, 0, 0, 1, 69, 0, 0, 0, 0, ''), -- Ironforge Blastsmith +(@CGUID+230, 0, 0, 8, 1, 0, 0, 0, 0, 0, ''), -- Ironforge Blastsmith +(@CGUID+227, 0, 0, 8, 1, 0, 0, 0, 0, 0, ''), -- Ironforge Blastsmith +(@CGUID+267, 0, 0, 8, 1, 0, 0, 0, 0, 0, ''), -- Ironforge Blastsmith +(@CGUID+249, 0, 0, 8, 1, 0, 0, 0, 0, 0, ''), -- Deck Hand +(@CGUID+262, 0, 0, 0, 1, 69, 0, 0, 0, 0, ''), -- Deck Hand +(@CGUID+251, 0, 0, 0, 1, 483, 0, 0, 0, 0, ''), -- First Mate Tidesong +(@CGUID+205, 0, 0, 0, 1, 572, 0, 0, 0, 0, ''), -- Su-Lai Snowpetal +(@CGUID+213, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+214, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+211, 0, 0, 0, 1, 415, 0, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+202, 0, 0, 0, 1, 415, 0, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+192, 0, 0, 0, 1, 415, 0, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+129, 0, 0, 0, 1, 69, 0, 0, 0, 0, ''), -- Gnome Engineer +(@CGUID+130, 0, 0, 0, 1, 69, 0, 0, 0, 0, ''), -- Gnome Engineer +(@CGUID+111, 0, 0, 0, 1, 613, 0, 0, 0, 0, ''), -- Gnome Engineer +(@CGUID+23, 0, 0, 0, 1, 613, 0, 0, 0, 0, ''), -- Tasha Highfoot +(@CGUID+71, 0, 0, 0, 1, 69, 0, 0, 0, 0, ''), -- Alliance Recruit +(@CGUID+19, 0, 0, 0, 1, 483, 0, 0, 0, 0, ''), -- Clavicus Knavingham +(@CGUID+353, 0, 0, 0, 1, 0, 0, 0, 0, 0, '145953'); -- Alliance Recruit - 145953 - Cosmetic - Sleep Zzz + +-- Creature Template addon +DELETE FROM `creature_template_addon` WHERE `entry` IN (108142, 108691, 108205, 108204, 108138, 108588, 108896, 109412, 188374, 108525); +INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(108142, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- 108142 (Archibald Arlison) +(108691, 0, 71971, 50331648, 1, 0, 0, 0, 0, 4, ''), -- 108691 (Gnomeregan Gyrocopter) +(108205, 0, 0, 0, 1, 0, 0, 0, 0, 0, '182938'), -- 108205 (Bloodrose) - Arcane Channeling +(108204, 0, 0, 0, 1, 0, 0, 0, 0, 0, '182938'), -- 108204 (Esmund Brightshield) - Arcane Channeling +(108138, 0, 0, 0, 257, 0, 0, 0, 0, 0, ''), -- 108138 (Rebecca Laughlin) +(108588, 0, 0, 0, 1, 0, 0, 0, 0, 0, '42459'), -- 108588 (Haomi) - Dual Wield +(108896, 0, 28912, 0, 1, 0, 0, 0, 0, 0, ''), -- 108896 (Commander Sharp) +(109412, 0, 0, 0, 1, 0, 0, 0, 0, 0, '42459'), -- 109412 (Lorcan Flintedge) - Dual Wield +(188374, 0, 0, 0, 1, 0, 0, 0, 0, 0, '370841'), -- 188374 (Millbert) - Cosmetic - Carry Box +(108525, 0, 27913, 50331648, 1, 0, 0, 0, 0, 4, ''); -- 108525 (Stormwind Gryphon Rider) + +-- Creature Template +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108142; -- Archibald Arlison +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=107931; -- Recruiter Barker +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=107934; -- Recruiter Lee +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=107933; -- Recruiter Gearburns +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=107935; -- Officer Blythe +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=107936; -- Officer Carven +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45, `unit_flags3`=16777216 WHERE `entry`=108292; -- Wrathguard Illusion +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=33536, `unit_flags2`=67110912, `unit_flags3`=16777216 WHERE `entry`=108298; -- Dreadlord Illusion +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45, `faction`=11, `speed_run`=1.428571462631225585, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048, `unit_flags3`=8388608 WHERE `entry`=108916; -- Knight Dameron +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45, `faction`=1819, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=108911; -- Duke August Foehammer +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45, `faction`=1819, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=108910; -- 7th Legion Submariner +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45, `unit_flags3`=16777216 WHERE `entry`=108241; -- Felguard Illusion +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108896; -- Commander Sharp +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108205; -- Bloodrose +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108204; -- Esmund Brightshield +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45, `faction`=16, `BaseAttackTime`=2000, `unit_flags`=33536, `unit_flags2`=67110912, `unit_flags3`=16777216 WHERE `entry`=108296; -- Doomguard Illusion +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108203; -- Matthew Deyling +UPDATE `creature_template` SET `gossip_menu_id`=9776 WHERE `entry`=29154; -- Thargold Ironwing +UPDATE `creature_template` SET `unit_flags3`=8388608 WHERE `entry`=36799; -- Recruiter Burns +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108192; -- Milton Sheaf +UPDATE `creature_template` SET `gossip_menu_id`=0, `minlevel`=45, `maxlevel`=45, `npcflag`=0 WHERE `entry`=108920; -- Captain Angelica +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45, `faction`=1819, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=108923; -- First Mate Tidesong +UPDATE `creature_template` SET `gossip_menu_id`=19930, `minlevel`=45, `maxlevel`=45, `faction`=1819, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=109412; -- Lorcan Flintedge +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45, `faction`=1819, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=108921; -- Deck Hand +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108895; -- Ironforge Blastsmith +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45, `unit_flags`=33536 WHERE `entry`=108485; -- Alaina Hearthsong +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108488; -- Sam +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108487; -- Ella +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108533; -- Lenny "Fingers" McCoy +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108588; -- Haomi +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108587; -- Su-Lai Snowpetal +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108138; -- Rebecca Laughlin +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108705; -- Sergeant Crowler +UPDATE `creature_template` SET `gossip_menu_id`=19861, `minlevel`=45, `maxlevel`=45 WHERE `entry`=108753; -- Rorin Rivershade +UPDATE `creature_template` SET `gossip_menu_id`=19861, `minlevel`=45, `maxlevel`=45 WHERE `entry`=108759; -- Loranea +UPDATE `creature_template` SET `gossip_menu_id`=19861, `minlevel`=45, `maxlevel`=45 WHERE `entry`=108745; -- Antone Sula +UPDATE `creature_template` SET `gossip_menu_id`=19861, `minlevel`=45, `maxlevel`=45 WHERE `entry`=108758; -- Lightshielder Baetrix +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108586; -- Len-Shu +UPDATE `creature_template` SET `gossip_menu_id`=19861, `minlevel`=45, `maxlevel`=45 WHERE `entry`=108756; -- Navea the Purifier +UPDATE `creature_template` SET `gossip_menu_id`=19861, `minlevel`=45, `maxlevel`=45 WHERE `entry`=108754; -- Fingall Flamehammer +UPDATE `creature_template` SET `gossip_menu_id`=19861, `minlevel`=45, `maxlevel`=45 WHERE `entry`=108755; -- Stormsinger Taalos +UPDATE `creature_template` SET `gossip_menu_id`=19861, `minlevel`=45, `maxlevel`=45 WHERE `entry`=108747; -- Kymba Quickwidget +UPDATE `creature_template` SET `gossip_menu_id`=19861, `minlevel`=45, `maxlevel`=45 WHERE `entry`=108749; -- Bridgette Hicks +UPDATE `creature_template` SET `gossip_menu_id`=19861, `minlevel`=45, `maxlevel`=45 WHERE `entry`=108750; -- Eunna Young +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108723; -- Kihra +UPDATE `creature_template` SET `gossip_menu_id`=19861, `minlevel`=45, `maxlevel`=45 WHERE `entry`=108742; -- Fen Cinderpaw +UPDATE `creature_template` SET `gossip_menu_id`=19861, `minlevel`=45, `maxlevel`=45 WHERE `entry`=108744; -- Tessa Wybroff +UPDATE `creature_template` SET `gossip_menu_id`=19861, `minlevel`=45, `maxlevel`=45 WHERE `entry`=108751; -- Arctic Whitemace +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108765; -- Seona Fireweaver +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108767; -- Kiruud the Relentless +UPDATE `creature_template` SET `gossip_menu_id`=19861, `minlevel`=45, `maxlevel`=45 WHERE `entry`=108746; -- Zelena Moonbreak +UPDATE `creature_template` SET `gossip_menu_id`=19861, `minlevel`=45, `maxlevel`=45 WHERE `entry`=108743; -- Niall Frostdrift +UPDATE `creature_template` SET `gossip_menu_id`=19861, `minlevel`=45, `maxlevel`=45 WHERE `entry`=108757; -- Haagios +UPDATE `creature_template` SET `gossip_menu_id`=19861, `minlevel`=45, `maxlevel`=45 WHERE `entry`=108752; -- Ciarra Neil +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108585; -- Loranea +UPDATE `creature_template` SET `gossip_menu_id`=19861, `minlevel`=45, `maxlevel`=45 WHERE `entry`=108722; -- Ramall Trueoak +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108582; -- DX-9000 Spider Tank "Legionkiller" +UPDATE `creature_template` SET `gossip_menu_id`=19861, `minlevel`=45, `maxlevel`=45 WHERE `entry`=108748; -- Audra Stoneshield +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108584; -- Bemora +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108583; -- Voraatios the Benedictive +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry` IN (107829, 107839, 107835, 107833, 107823, 107841, 107827, 107826); -- Alliance Recruit +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30, `unit_flags3`=8388608 WHERE `entry`=6086; -- Auberdine Sentinel +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `speed_run`=1.142857193946838378 WHERE `entry`=68; -- Stormwind City Guard +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108143; -- Kinndy Brightsocket +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=12, `BaseAttackTime`=2000, `unit_flags`=33536, `unit_flags2`=2048, `dynamicflags`=128 WHERE `entry`=188374; -- Millbert +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108140; -- Doc Lightspanner +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30 WHERE `entry`=53966; -- Spider Summoner (Ship) +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108410; -- Thurgrum Deepforge +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30 WHERE `entry`=53961; -- Blood Spatter (Small) +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108141; -- Brother Zuo +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30 WHERE `entry`=53954; -- Blood Spatter +UPDATE `creature_template` SET `minlevel`=30, `maxlevel`=30 WHERE `entry`=53950; -- Hired Courier +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108481; -- Gussof Forgefire +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108483; -- Tasha Highfoot +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108691; -- Gnomeregan Gyrocopter +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108412; -- Clavicus Knavingham +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=29712; -- Stormwind Harbor Guard +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108525; -- Stormwind Gryphon Rider +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108051; -- Alasdair Whitepeak +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=108581; -- Gnome Engineer +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45, `unit_flags3`=8388609 WHERE `entry`=108420; -- Training Dummy +UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45 WHERE `entry`=114465; -- Darnassus Sentinel + +-- GameObjects +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+157; +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, 258301, 0, 1519, 4411, '0', 6666, 0, -8333.798828125, 1215.01220703125, 5.18945932388305664, 5.192355155944824218, 0, 0, -0.51877307891845703, 0.854911983013153076, 120, 255, 1, 45745), -- Noodle Cart (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+1, 258302, 0, 1519, 4411, '0', 6666, 0, -8339.3212890625, 1215.8350830078125, 5.176270484924316406, 6.134833335876464843, 0, 0, -0.07410812377929687, 0.997250199317932128, 120, 255, 1, 45745), -- Bubbling Pot (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+2, 258254, 0, 1519, 4411, '0', 6666, 0, -8555.72265625, 1098.420166015625, 19.095794677734375, 0.331612616777420043, 0, 0, 0.165047645568847656, 0.986285567283630371, 120, 255, 1, 45745), -- Campfire (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+3, 258255, 0, 1519, 4411, '0', 6666, 0, -8462.888671875, 1117.59375, 19.095794677734375, 1.876227378845214843, 0, 0, 0.806444168090820312, 0.59131026268005371, 120, 255, 1, 45745), -- Campfire (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+4, 259041, 0, 1519, 4411, '0', 6666, 0, -8336.3095703125, 1377.9097900390625, 3.843682289123535156, 4.674936771392822265, 0, 0, -0.72022342681884765, 0.693742215633392333, 120, 255, 1, 45745), -- Alliance Battleship (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+5, 257878, 0, 1519, 4411, '0', 6666, 0, -8500.6201171875, 1200.779541015625, 5.524630069732666015, 0.618159353733062744, 0, 0, 0.304182052612304687, 0.952613890171051025, 120, 255, 1, 45745), -- Forge (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+6, 257879, 0, 1519, 4411, '0', 6666, 0, -8497.9599609375, 1208.09033203125, 5.269229888916015625, 1.101297259330749511, 0, 0, 0.523240089416503906, 0.852185308933258056, 120, 255, 1, 45745), -- Anvil (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+7, 257880, 0, 1519, 4411, '0', 6666, 0, -8491.3994140625, 1197.3004150390625, 5.550350189208984375, 3.304533243179321289, 0, 0, -0.99668312072753906, 0.081380166113376617, 120, 255, 1, 45745), -- 7.0 Pre-Launch - Orgrimmar - Template Object (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+8, 257881, 0, 1519, 4411, '0', 6666, 0, -8491.8095703125, 1200.3992919921875, 5.470489978790283203, 0.105985648930072784, 0, 0, 0.052968025207519531, 0.99859619140625, 120, 255, 1, 45745), -- 7.0 Pre-Launch - Orgrimmar - Template Object (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+9, 251237, 0, 1519, 4411, '0', 6666, 0, -8393.59375, 1189.673583984375, 5.677083492279052734, 1.864276647567749023, 0, 0, 0.802896499633789062, 0.596118450164794921, 120, 255, 1, 45745), -- Draenei Crate 2 (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+10, 250877, 0, 1519, 4411, '0', 6666, 0, -8539, 1079.4132080078125, 18.97775077819824218, 0.053614363074302673, 0, 0, 0.026803970336914062, 0.999640703201293945, 120, 255, 1, 45745), -- Bedroll (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+11, 250877, 0, 1519, 4411, '0', 6666, 0, -8526.9326171875, 1097.0711669921875, 18.71255302429199218, 3.194147586822509765, 0, 0, -0.99965476989746093, 0.026274340227246284, 120, 255, 1, 45745), -- Bedroll (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+12, 251146, 0, 1519, 4411, '0', 6666, 0, -8467.4462890625, 1235.861083984375, 5.23023843765258789, 3.145498991012573242, 0, 0, -0.99999809265136718, 0.001953125, 120, 255, 1, 45745), -- 7.0 Pre-Launch - Stormwind - Template (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+13, 251238, 0, 1519, 4411, '0', 6666, 0, -8398.3056640625, 1189.986083984375, 5.518725395202636718, 3.857890844345092773, 0, 0, -0.93654727935791015, 0.350541293621063232, 120, 255, 1, 45745), -- Supply Stack (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+14, 251289, 0, 1519, 4411, '0', 6666, 0, -8540.3193359375, 1164.5260009765625, 17.70827674865722656, 0.914613246917724609, 0, 0, 0.441533088684082031, 0.897244989871978759, 120, 255, 1, 45745), -- Tools 1 (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+15, 251146, 0, 1519, 4411, '0', 6666, 0, -8279.919921875, 1269.7725830078125, 5.246700763702392578, 3.146377086639404296, 0, 0, -0.99999713897705078, 0.002392079913988709, 120, 255, 1, 45745), -- 7.0 Pre-Launch - Stormwind - Template (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+16, 258301, 0, 1519, 4411, '0', 6666, 0, -8333.798828125, 1215.01220703125, 5.18945932388305664, 5.192355155944824218, 0, 0, -0.51877307891845703, 0.854911983013153076, 120, 255, 1, 45745), -- Noodle Cart (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+17, 251242, 0, 1519, 4411, '0', 6666, 0, -8379.0205078125, 1192.7066650390625, 5.6872100830078125, 1.245473861694335937, 0, 0, 0.583260536193847656, 0.812285125255584716, 120, 255, 1, 45745), -- Crystal Bucket (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+18, 258302, 0, 1519, 4411, '0', 6666, 0, -8339.3212890625, 1215.8350830078125, 5.176270484924316406, 6.134833335876464843, 0, 0, -0.07410812377929687, 0.997250199317932128, 120, 255, 1, 45745), -- Bubbling Pot (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+19, 251254, 0, 1519, 4411, '0', 6666, 0, -8329.8017578125, 1206.482666015625, 6.50574493408203125, 2.018958568572998046, 0, 0, 0.846554756164550781, 0.532301664352416992, 120, 255, 1, 45745), -- Grilled Fish (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+20, 251146, 0, 1519, 4411, '0', 6666, 0, -8467.46875, 1233.2117919921875, 5.230245113372802734, 3.145498991012573242, 0, 0, -0.99999809265136718, 0.001953125, 120, 255, 1, 45745), -- 7.0 Pre-Launch - Stormwind - Template (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+21, 251232, 0, 1519, 4411, '0', 6666, 0, -8378.794921875, 1196.546875, 5.701794147491455078, 1.583562850952148437, 0, 0, 0.711606025695800781, 0.702578723430633544, 120, 255, 1, 45745), -- Basket Closed (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+22, 251246, 0, 1519, 4411, '0', 6666, 0, -8338.892578125, 1220.9305419921875, 5.651279926300048828, 5.12699747085571289, 0, 0, -0.54642868041992187, 0.837505638599395751, 120, 255, 1, 45745), -- Pandaren Barrel (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+23, 250877, 0, 1519, 4411, '0', 6666, 0, -8539.6962890625, 1071.0728759765625, 19.04119491577148437, 6.261673927307128906, 0, 0, -0.01075553894042968, 0.999942123889923095, 120, 255, 1, 45745), -- Bedroll (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+24, 250877, 0, 1519, 4411, '0', 6666, 0, -8468.326171875, 1076.9305419921875, 18.73444747924804687, 1.559106945991516113, 0, 0, 0.702961921691894531, 0.711227476596832275, 120, 255, 1, 45745), -- Bedroll (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+25, 250660, 0, 1519, 4411, '0', 6666, 0, -8246.908203125, 1680.9879150390625, 5.234462738037109375, 4.460095405578613281, 0, 0, -0.7904510498046875, 0.612525224685668945, 120, 255, 1, 45745), -- Alliance Battleship (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+26, 251195, 0, 1519, 4411, '0', 6666, 0, -8493.529296875, 1204.6319580078125, 6.094130516052246093, 2.137740135192871093, 0, 0, 0.876657485961914062, 0.481115013360977172, 120, 255, 1, 45745), -- Keg of Armor Polish (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+27, 251195, 0, 1519, 4411, '0', 6666, 0, -8494.3662109375, 1205.685791015625, 6.04096841812133789, 2.102820158004760742, 0, 0, 0.868124008178710937, 0.496347367763519287, 120, 255, 1, 45745), -- Keg of Armor Polish (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+28, 251226, 0, 1519, 4411, '0', 6666, 0, -8390.5556640625, 1193.5711669921875, 5.7796783447265625, 0.982307255268096923, 0, 0, 0.471643447875976562, 0.881789386272430419, 120, 255, 1, 45745), -- Draenei Pillow 1 (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+29, 250877, 0, 1519, 4411, '0', 6666, 0, -8527.888671875, 1070.157958984375, 18.42666816711425781, 3.185353994369506835, 0, 0, -0.99976062774658203, 0.021878868341445922, 120, 255, 1, 45745), -- Bedroll (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+30, 250877, 0, 1519, 4411, '0', 6666, 0, -8566.2431640625, 1092.46875, 19.05183219909667968, 0.362297356128692626, 0, 0, 0.180159568786621093, 0.983637392520904541, 120, 255, 1, 45745), -- Bedroll (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+31, 251227, 0, 1519, 4411, '0', 6666, 0, -8394.2861328125, 1193.6632080078125, 5.616719245910644531, 1.583562850952148437, 0, 0, 0.711606025695800781, 0.702578723430633544, 120, 255, 1, 45745), -- Draenei Pillow 2 (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+32, 251146, 0, 1519, 4411, '0', 6666, 0, -8481.2880859375, 1224.170166015625, 5.230251789093017578, 0.038679629564285278, 0, 0, 0.019338607788085937, 0.999813020229339599, 120, 255, 1, 45745), -- 7.0 Pre-Launch - Stormwind - Template (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+33, 251146, 0, 1519, 4411, '0', 6666, 0, -8481.513671875, 1232.375, 5.23023843765258789, 0.038679629564285278, 0, 0, 0.019338607788085937, 0.999813020229339599, 120, 255, 1, 45745), -- 7.0 Pre-Launch - Stormwind - Template (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+34, 251289, 0, 1519, 4411, '0', 6666, 0, -8507.4267578125, 1168.017333984375, 17.70825576782226562, 3.136808395385742187, 0, 0, 0.999997138977050781, 0.002392079913988709, 120, 255, 1, 45745), -- Tools 1 (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+35, 204284, 0, 1519, 4411, '0', 6666, 0, -8565.6201171875, 1277.3800048828125, -58.527801513671875, 0.925023794174194335, 0, 0, 0.446197509765625, 0.894934535026550292, 120, 255, 1, 45745), -- Stormwind Lobster Trap (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+36, 258254, 0, 1519, 4411, '0', 6666, 0, -8555.72265625, 1098.420166015625, 19.095794677734375, 0.331612616777420043, 0, 0, 0.165047645568847656, 0.986285567283630371, 120, 255, 1, 45745), -- Campfire (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+37, 258255, 0, 1519, 4411, '0', 6666, 0, -8462.888671875, 1117.59375, 19.095794677734375, 1.876227378845214843, 0, 0, 0.806444168090820312, 0.59131026268005371, 120, 255, 1, 45745), -- Campfire (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+38, 259041, 0, 1519, 4411, '0', 6666, 0, -8336.3095703125, 1377.9097900390625, 3.843682289123535156, 4.674936771392822265, 0, 0, -0.72022342681884765, 0.693742215633392333, 120, 255, 1, 45745), -- Alliance Battleship (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+39, 251022, 0, 1519, 4411, '0', 6666, 0, -8440.689453125, 1213.920166015625, 5.166817665100097656, 5.550057411193847656, 0, 0, -0.35840988159179687, 0.933564305305480957, 120, 255, 1, 45745), -- Medical Supply Crate (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+40, 251146, 0, 1519, 4411, '0', 6666, 0, -8481.470703125, 1229.4444580078125, 5.230245113372802734, 0.038679629564285278, 0, 0, 0.019338607788085937, 0.999813020229339599, 120, 255, 1, 45745), -- 7.0 Pre-Launch - Stormwind - Template (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+41, 251023, 0, 1519, 4411, '0', 6666, 0, -8449.64453125, 1224.8367919921875, 9.074051856994628906, 0, 0, 0, 0, 1, 120, 255, 1, 45745), -- Medical Supply Crate (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+42, 250660, 0, 1519, 4411, '0', 6666, 0, -8655.55078125, 1636.5208740234375, 5.234462738037109375, 4.410251140594482421, 0, 0, -0.80546951293945312, 0.592637240886688232, 120, 255, 1, 45745), -- Alliance Battleship (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+43, 251253, 0, 1519, 4411, '0', 6666, 0, -8340.0205078125, 1206.717041015625, 6.461926937103271484, 1.436185121536254882, 0, 0, 0.657949447631835937, 0.753062129020690917, 120, 255, 1, 45745), -- Fried Rice (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+44, 250877, 0, 1519, 4411, '0', 6666, 0, -8562.169921875, 1087.7552490234375, 19.05183219909667968, 0.984406054019927978, 0, 0, 0.472568511962890625, 0.881293952465057373, 120, 255, 1, 45745), -- Bedroll (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+45, 251146, 0, 1519, 4411, '0', 6666, 0, -8467.4619140625, 1238.484375, 5.23023843765258789, 3.145498991012573242, 0, 0, -0.99999809265136718, 0.001953125, 120, 255, 1, 45745), -- 7.0 Pre-Launch - Stormwind - Template (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+46, 250660, 0, 1519, 4411, '0', 6666, 0, -8370.4169921875, 1633.357666015625, 5.234462738037109375, 4.410251140594482421, 0, 0, -0.80546951293945312, 0.592637240886688232, 120, 255, 1, 45745), -- Alliance Battleship (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+47, 251146, 0, 1519, 4411, '0', 6666, 0, -8280.0625, 1281.73095703125, 5.240396976470947265, 3.129240036010742187, 0, 0, 0.999980926513671875, 0.006176323629915714, 120, 255, 1, 45745), -- 7.0 Pre-Launch - Stormwind - Template (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+48, 251146, 0, 1519, 4411, '0', 6666, 0, -8279.9970703125, 1273.2899169921875, 5.244849205017089843, 3.120375871658325195, 0, 0, 0.999943733215332031, 0.010608184151351451, 120, 255, 1, 45745), -- 7.0 Pre-Launch - Stormwind - Template (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+49, 251146, 0, 1519, 4411, '0', 6666, 0, -8467.5087890625, 1227.4114990234375, 5.230245113372802734, 3.145498991012573242, 0, 0, -0.99999809265136718, 0.001953125, 120, 255, 1, 45745), -- 7.0 Pre-Launch - Stormwind - Template (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+50, 251289, 0, 1519, 4411, '0', 6666, 0, -8549.517578125, 1161.8350830078125, 18.4892425537109375, 5.409069061279296875, 0, 0, -0.42327594757080078, 0.906000852584838867, 120, 255, 1, 45745), -- Tools 1 (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+51, 251230, 0, 1519, 4411, '0', 6666, 0, -8387.296875, 1192.0728759765625, 5.784722328186035156, 1.583562850952148437, 0, 0, 0.711606025695800781, 0.702578723430633544, 120, 255, 1, 45745), -- Draenei Barrel (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+52, 204284, 0, 1519, 4411, '0', 6666, 0, -8426.8603515625, 1261.050048828125, -42.4457015991210937, 1.954769015312194824, 0, 0, 0.829037666320800781, 0.559192776679992675, 120, 255, 1, 45745), -- Stormwind Lobster Trap (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+53, 251146, 0, 1519, 4411, '0', 6666, 0, -8279.9931640625, 1265.6492919921875, 5.247582435607910156, 3.129240036010742187, 0, 0, 0.999980926513671875, 0.006176323629915714, 120, 255, 1, 45745), -- 7.0 Pre-Launch - Stormwind - Template (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+54, 251146, 0, 1519, 4411, '0', 6666, 0, -8481.638671875, 1235.2396240234375, 5.23023843765258789, 0.038679629564285278, 0, 0, 0.019338607788085937, 0.999813020229339599, 120, 255, 1, 45745), -- 7.0 Pre-Launch - Stormwind - Template (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+55, 251242, 0, 1519, 4411, '0', 6666, 0, -8401.1142578125, 1193.092041015625, 5.422146320343017578, 1.583562850952148437, 0, 0, 0.711606025695800781, 0.702578723430633544, 120, 255, 1, 45745), -- Crystal Bucket (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+56, 209034, 0, 1519, 4411, '0', 6666, 0, -8515.001953125, 1305.795166015625, 6.09877634048461914, 3.22885894775390625, 0, 0, -0.99904823303222656, 0.043619260191917419, 120, 255, 1, 45745), -- Courier Sword (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+57, 250660, 0, 1519, 4411, '0', 6666, 0, -8740.060546875, 1499.3975830078125, 5.234462738037109375, 4.410251140594482421, 0, 0, -0.80546951293945312, 0.592637240886688232, 120, 255, 1, 45745), -- Alliance Battleship (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+58, 251236, 0, 1519, 4411, '0', 6666, 0, -8387.267578125, 1189.7864990234375, 5.766869068145751953, 2.35595560073852539, 0, 0, 0.923833847045898437, 0.382793724536895751, 120, 255, 1, 45745), -- Draenei Crate 1 (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+59, 250877, 0, 1519, 4411, '0', 6666, 0, -8539.23828125, 1097.1492919921875, 19.05183219909667968, 6.236527442932128906, 0, 0, -0.02332687377929687, 0.999727904796600341, 120, 255, 1, 45745), -- Bedroll (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+60, 250877, 0, 1519, 4411, '0', 6666, 0, -8450.5244140625, 1077.295166015625, 19.05184364318847656, 1.559106945991516113, 0, 0, 0.702961921691894531, 0.711227476596832275, 120, 255, 1, 45745), -- Bedroll (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+61, 250877, 0, 1519, 4411, '0', 6666, 0, -8565.6943359375, 1105.09375, 19.05183219909667968, 5.898975372314453125, 0, 0, -0.19092559814453125, 0.981604516506195068, 120, 255, 1, 45745), -- Bedroll (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+62, 250877, 0, 1519, 4411, '0', 6666, 0, -8554.294921875, 1086.66845703125, 19.05183219909667968, 1.801772117614746093, 0, 0, 0.783877372741699218, 0.620915651321411132, 120, 255, 1, 45745), -- Bedroll (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+63, 250660, 0, 1519, 4411, '0', 6666, 0, -8183.1162109375, 1377.9271240234375, 5.023183345794677734, 4.601384162902832031, 0, 0, -0.74524402618408203, 0.666791856288909912, 120, 255, 1, 45745), -- Alliance Battleship (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+64, 251146, 0, 1519, 4411, '0', 6666, 0, -8481.3994140625, 1226.7899169921875, 5.230245113372802734, 0.038679629564285278, 0, 0, 0.019338607788085937, 0.999813020229339599, 120, 255, 1, 45745), -- 7.0 Pre-Launch - Stormwind - Template (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+65, 251289, 0, 1519, 4411, '0', 6666, 0, -8495.357421875, 1161.6649169921875, 18.48919105529785156, 1.500185012817382812, 0, 0, 0.681706428527832031, 0.731625854969024658, 120, 255, 1, 45745), -- Tools 1 (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+66, 251252, 0, 1519, 4411, '0', 6666, 0, -8344.296875, 1206.986083984375, 6.525890827178955078, 0.541761219501495361, 0, 0, 0.267580032348632812, 0.963535666465759277, 120, 255, 1, 45745), -- Dumplings (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+67, 250877, 0, 1519, 4411, '0', 6666, 0, -8459.029296875, 1077.2760009765625, 19.04638099670410156, 1.559106945991516113, 0, 0, 0.702961921691894531, 0.711227476596832275, 120, 255, 1, 45745), -- Bedroll (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+68, 251146, 0, 1519, 4411, '0', 6666, 0, -8467.5361328125, 1230.2760009765625, 5.230245113372802734, 3.145498991012573242, 0, 0, -0.99999809265136718, 0.001953125, 120, 255, 1, 45745), -- 7.0 Pre-Launch - Stormwind - Template (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+69, 251146, 0, 1519, 4411, '0', 6666, 0, -8481.9443359375, 1238.2117919921875, 5.23023843765258789, 0.038679629564285278, 0, 0, 0.019338607788085937, 0.999813020229339599, 120, 255, 1, 45745), -- 7.0 Pre-Launch - Stormwind - Template (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+70, 251146, 0, 1519, 4411, '0', 6666, 0, -8467.310546875, 1224.43408203125, 5.230245113372802734, 3.145498991012573242, 0, 0, -0.99999809265136718, 0.001953125, 120, 255, 1, 45745), -- 7.0 Pre-Launch - Stormwind - Template (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+71, 251347, 0, 1519, 4411, '0', 6666, 0, -8253.185546875, 1377.954833984375, -22.9229297637939453, 4.704849720001220703, 0, 0, -0.70976734161376953, 0.704436182975769042, 120, 255, 1, 45745), -- Submarine (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+72, 251240, 0, 1519, 4411, '0', 6666, 0, -8374.2236328125, 1192.3211669921875, 5.923388481140136718, 5.11735391616821289, -0.05184173583984375, -0.01449394226074218, -0.55086135864257812, 0.832858979701995849, 120, 255, 1, 45745), -- Draenei Wagon (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+73, 251244, 0, 1519, 4411, '0', 6666, 0, -8406.66015625, 1189.3367919921875, 6.108919620513916015, 4.201544761657714843, -0.04783201217651367, -0.04436111450195312, -0.86052608489990234, 0.505211830139160156, 120, 255, 1, 45745), -- Draenei Wagon 2 (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+74, 257878, 0, 1519, 4411, '0', 6666, 0, -8500.6201171875, 1200.779541015625, 5.524630069732666015, 0.618159353733062744, 0, 0, 0.304182052612304687, 0.952613890171051025, 120, 255, 1, 45745), -- Forge (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+75, 251224, 0, 1519, 4411, '0', 6666, 0, -8390.4033203125, 1189.5, 5.766936779022216796, 1.583562850952148437, 0, 0, 0.711606025695800781, 0.702578723430633544, 120, 255, 1, 45745), -- Draenei Chest (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+76, 257879, 0, 1519, 4411, '0', 6666, 0, -8497.9599609375, 1208.09033203125, 5.269229888916015625, 1.101297259330749511, 0, 0, 0.523240089416503906, 0.852185308933258056, 120, 255, 1, 45745), -- Anvil (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+77, 257880, 0, 1519, 4411, '0', 6666, 0, -8491.3994140625, 1197.3004150390625, 5.550350189208984375, 3.304533243179321289, 0, 0, -0.99668312072753906, 0.081380166113376617, 120, 255, 1, 45745), -- 7.0 Pre-Launch - Orgrimmar - Template Object (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+78, 257881, 0, 1519, 4411, '0', 6666, 0, -8491.8095703125, 1200.3992919921875, 5.470489978790283203, 0.105985648930072784, 0, 0, 0.052968025207519531, 0.99859619140625, 120, 255, 1, 45745), -- 7.0 Pre-Launch - Orgrimmar - Template Object (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+79, 250660, 0, 1519, 4411, '0', 6666, 0, -8304.8681640625, 1801.03125, 5.234462738037109375, 4.460095405578613281, 0, 0, -0.7904510498046875, 0.612525224685668945, 120, 255, 1, 45745), -- Alliance Battleship (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+80, 251229, 0, 1519, 4411, '0', 6666, 0, -8390.23828125, 1200.5504150390625, 5.396089076995849609, 1.586499810218811035, 0, 0, 0.712636947631835937, 0.701533019542694091, 120, 255, 1, 45745), -- Draenei Table (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+81, 250877, 0, 1519, 4411, '0', 6666, 0, -8427.873046875, 1078.6771240234375, 19.25949668884277343, 1.874828219413757324, 0, 0, 0.8060302734375, 0.591874301433563232, 120, 255, 1, 45745), -- Bedroll (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+82, 251230, 0, 1519, 4411, '0', 6666, 0, -8384.294921875, 1194.1492919921875, 5.732638835906982421, 1.583562850952148437, 0, 0, 0.711606025695800781, 0.702578723430633544, 120, 255, 1, 45745), -- Draenei Barrel (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+83, 250877, 0, 1519, 4411, '0', 6666, 0, -8441.4619140625, 1077.25, 19.14162635803222656, 1.559106945991516113, 0, 0, 0.702961921691894531, 0.711227476596832275, 120, 255, 1, 45745), -- Bedroll (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+84, 250660, 0, 1519, 4411, '0', 6666, 0, -8186.99853515625, 1604.7552490234375, 5.234462738037109375, 4.415465354919433593, 0, 0, -0.80392169952392578, 0.594735145568847656, 120, 255, 1, 45745), -- Alliance Battleship (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+85, 251251, 0, 1519, 4411, '0', 6666, 0, -8331.8857421875, 1206.734375, 6.501019954681396484, 1.583562850952148437, 0, 0, 0.711606025695800781, 0.702578723430633544, 120, 255, 1, 45745), -- Baked Fowl (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+86, 250660, 0, 1519, 4411, '0', 6666, 0, -8615.96875, 1490.6597900390625, 5.234462738037109375, 4.410251140594482421, 0, 0, -0.80546951293945312, 0.592637240886688232, 120, 255, 1, 45745), -- Alliance Battleship (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+87, 251146, 0, 1519, 4411, '0', 6666, 0, -8279.9970703125, 1285.8663330078125, 5.238301753997802734, 3.146377086639404296, 0, 0, -0.99999713897705078, 0.002392079913988709, 120, 255, 1, 45745), -- 7.0 Pre-Launch - Stormwind - Template (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+88, 251235, 0, 1519, 4411, '0', 6666, 0, -8388.3037109375, 1200.4617919921875, 6.712012290954589843, 1.583562850952148437, 0, 0, 0.711606025695800781, 0.702578723430633544, 120, 255, 1, 45745), -- Light-Infused Crystals (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+89, 251289, 0, 1519, 4411, '0', 6666, 0, -8523.8486328125, 1161.9600830078125, 18.48921012878417968, 0.627105712890625, 0, 0, 0.308440208435058593, 0.951243758201599121, 120, 255, 1, 45745), -- Tools 1 (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+90, 251231, 0, 1519, 4411, '0', 6666, 0, -8378.732421875, 1194.2552490234375, 5.6875, 1.583562850952148437, 0, 0, 0.711606025695800781, 0.702578723430633544, 120, 255, 1, 45745), -- Basket Empty (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+91, 251228, 0, 1519, 4411, '0', 6666, 0, -8386.5712890625, 1194.0521240234375, 5.74946451187133789, 1.583562850952148437, 0, 0, 0.711606025695800781, 0.702578723430633544, 120, 255, 1, 45745), -- Draenei Pillow 3 (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+92, 251250, 0, 1519, 4411, '0', 6666, 0, -8342.263671875, 1206.7742919921875, 6.495608329772949218, 1.583562850952148437, 0, 0, 0.711606025695800781, 0.702578723430633544, 120, 255, 1, 45745), -- Baked Fish (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+93, 251230, 0, 1519, 4411, '0', 6666, 0, -8394.9443359375, 1191.3646240234375, 5.600694656372070312, 1.583562850952148437, 0, 0, 0.711606025695800781, 0.702578723430633544, 120, 255, 1, 45745), -- Draenei Barrel (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+94, 251241, 0, 1519, 4411, '0', 6666, 0, -8390.2158203125, 1200.359375, 5.3760528564453125, 5.0154266357421875, -0.01326894760131835, -0.02732276916503906, -0.59186935424804687, 0.805461406707763671, 120, 255, 1, 45745), -- Rug (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+95, 251146, 0, 1519, 4411, '0', 6666, 0, -8280.06640625, 1289.375, 5.236306190490722656, 3.120375871658325195, 0, 0, 0.999943733215332031, 0.010608184151351451, 120, 255, 1, 45745), -- 7.0 Pre-Launch - Stormwind - Template (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+96, 251146, 0, 1519, 4411, '0', 6666, 0, -8280.0537109375, 1277.7882080078125, 5.242333412170410156, 3.120375871658325195, 0, 0, 0.999943733215332031, 0.010608184151351451, 120, 255, 1, 45745), -- 7.0 Pre-Launch - Stormwind - Template (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+97, 251255, 0, 1519, 4411, '0', 6666, 0, -8333.97265625, 1206.548583984375, 6.504469871520996093, 3.234861612319946289, 0, 0, -0.99891281127929687, 0.046617437154054641, 120, 255, 1, 45745), -- Ribs (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+98, 251223, 0, 1519, 4411, '0', 6666, 0, -8381.42578125, 1193.6754150390625, 5.637152671813964843, 1.938066720962524414, 0, 0, 0.824338912963867187, 0.566096603870391845, 120, 255, 1, 45745), -- Draenei Chest (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+99, 251088, 0, 1519, 4411, '0', 6666, 0, -8243.4755859375, 1236.4896240234375, 5.230231285095214843, 0.082018256187438964, 0.010574817657470703, -0.00346279144287109, 0.041035652160644531, 0.999095737934112548, 120, 255, 1, 45745), -- Rune (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+100, 251242, 0, 1519, 4411, '0', 6666, 0, -8385.2783203125, 1188.1927490234375, 5.812928199768066406, 3.301337957382202148, 0, 0, -0.9968118667602539, 0.079787679016590118, 120, 255, 1, 45745), -- Crystal Bucket (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+101, 251225, 0, 1519, 4411, '0', 6666, 0, -8399.1181640625, 1194.017333984375, 5.395833492279052734, 0.86591571569442749, 0, 0, 0.419557571411132812, 0.907728731632232666, 120, 255, 1, 45745), -- Draenei Chest (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+102, 251021, 0, 1519, 4411, '0', 6666, 0, -8452.4423828125, 1214.217041015625, 5.116276741027832031, 4.679366588592529296, 0, 0, -0.71868515014648437, 0.695335626602172851, 120, 255, 1, 45745), -- Medical Supply Crate (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+103, 251246, 0, 1519, 4411, '0', 6666, 0, -8335.609375, 1220.529541015625, 5.623012065887451171, 4.217307090759277343, 0, 0, -0.85880851745605468, 0.512296736240386962, 120, 255, 1, 45745), -- Pandaren Barrel (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+104, 251233, 0, 1519, 4411, '0', 6666, 0, -8392.2255859375, 1200.1910400390625, 6.620556831359863281, 1.583562850952148437, 0, 0, 0.711606025695800781, 0.702578723430633544, 120, 255, 1, 45745), -- Light-Infused Crystals (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+105, 251247, 0, 1519, 4411, '0', 6666, 0, -8337.3505859375, 1219.8680419921875, 5.57643890380859375, 3.727490186691284179, 0, 0, -0.95739650726318359, 0.288776576519012451, 120, 255, 1, 45745), -- Pandaren Barrel 2 (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+106, 250877, 0, 1519, 4411, '0', 6666, 0, -8539.154296875, 1088.064208984375, 19.03152847290039062, 6.09316253662109375, 0, 0, -0.09486865997314453, 0.995489776134490966, 120, 255, 1, 45745), -- Bedroll (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+107, 250877, 0, 1519, 4411, '0', 6666, 0, -8526.7587890625, 1087.9132080078125, 18.24492073059082031, 3.127781867980957031, 0, 0, 0.999976158142089843, 0.006905339658260345, 120, 255, 1, 45745), -- Bedroll (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+108, 250877, 0, 1519, 4411, '0', 6666, 0, -8527.267578125, 1079.5660400390625, 18.13395118713378906, 3.08431410789489746, 0, 0, 0.999589920043945312, 0.028635311871767044, 120, 255, 1, 45745), -- Bedroll (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+109, 251234, 0, 1519, 4411, '0', 6666, 0, -8390.294921875, 1200.8958740234375, 6.610365867614746093, 1.583562850952148437, 0, 0, 0.711606025695800781, 0.702578723430633544, 120, 255, 1, 45745), -- Light-Infused Crystals (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+110, 250877, 0, 1519, 4411, '0', 6666, 0, -8420.5595703125, 1083.9617919921875, 19.26856803894042968, 2.462148189544677734, 0, 0, 0.942847251892089843, 0.333225220441818237, 120, 255, 1, 45745), -- Bedroll (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+111, 251146, 0, 1519, 4411, '0', 6666, 0, -8279.982421875, 1261.704833984375, 5.246307373046875, 3.120375871658325195, 0, 0, 0.999943733215332031, 0.010608184151351451, 120, 255, 1, 45745), -- 7.0 Pre-Launch - Stormwind - Template (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+112, 251238, 0, 1519, 4411, '0', 6666, 0, -8382.89453125, 1190.079833984375, 5.769097328186035156, 5.983847618103027343, 0, 0, -0.14911079406738281, 0.988820493221282958, 120, 255, 1, 45745), -- Supply Stack (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+113, 293894, 0, 1519, 4411, '0', 6666, 0, -8645.388671875, 1308.27783203125, 5.233562946319580078, 0, 0, 0, 0, 1, 120, 255, 0, 45745), -- Portal to Darnassus (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+114, 204284, 0, 1519, 4411, '0', 6666, 0, -8597.5400390625, 1355.1600341796875, -56.1716995239257812, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 120, 255, 1, 45745), -- Stormwind Lobster Trap (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+115, 204284, 0, 1519, 4411, '0', 6666, 0, -8550.25, 1338.1400146484375, -45.0208015441894531, 1.099556446075439453, 0, 0, 0.522498130798339843, 0.852640450000762939, 120, 255, 1, 45745), -- Stormwind Lobster Trap (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+116, 164760, 0, 1519, 4411, '0', 6666, 0, -8513.072265625, 1322.333984375, 6.06749725341796875, 2.303835391998291015, 0, 0, 0.913545608520507812, 0.406736314296722412, 120, 255, 1, 45745), -- Wooden Chair (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+117, 258304, 0, 1519, 4411, '0', 6666, 0, -8343.17578125, 1204.1007080078125, 5.47872018814086914, 1.474801421165466308, 0, 0, 0.672366142272949218, 0.740218758583068847, 120, 255, 1, 45745), -- Chair (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+118, 258305, 0, 1519, 4411, '0', 6666, 0, -8341.3701171875, 1204.2083740234375, 5.479097843170166015, 1.448621988296508789, 0, 0, 0.662619590759277343, 0.748956084251403808, 120, 255, 1, 45745), -- Chair (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+119, 258307, 0, 1519, 4411, '0', 6666, 0, -8344.783203125, 1209.1632080078125, 5.3210906982421875, 4.878195762634277343, 0, 0, -0.64612388610839843, 0.763232588768005371, 120, 255, 1, 45745), -- Chair (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+120, 258308, 0, 1519, 4411, '0', 6666, 0, -8342.892578125, 1209.0660400390625, 5.329493999481201171, 4.686212062835693359, 0, 0, -0.71630096435546875, 0.697791457176208496, 120, 255, 1, 45745), -- Chair (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+121, 258306, 0, 1519, 4411, '0', 6666, 0, -8339.595703125, 1204.16845703125, 5.482140064239501953, 1.352629423141479492, 0, 0, 0.62592315673828125, 0.779884755611419677, 120, 255, 1, 45745), -- Chair (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+122, 258309, 0, 1519, 4411, '0', 6666, 0, -8341.0576171875, 1209.171875, 5.326238155364990234, 4.738570213317871093, 0, 0, -0.69779014587402343, 0.716302275657653808, 120, 255, 1, 45745), -- Chair (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+123, 258310, 0, 1519, 4411, '0', 6666, 0, -8339.294921875, 1209.1180419921875, 5.3291015625, 4.616398811340332031, 0, 0, -0.74021720886230468, 0.672367811203002929, 120, 255, 1, 45745), -- Chair (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+124, 258312, 0, 1519, 4411, '0', 6666, 0, -8332.3525390625, 1208.954833984375, 5.350359439849853515, 4.869470596313476562, 0, 0, -0.64944744110107421, 0.760406434535980224, 120, 255, 1, 45745), -- Chair (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+125, 258313, 0, 1519, 4411, '0', 6666, 0, -8330.638671875, 1209.0521240234375, 5.349018573760986328, 4.581490039825439453, 0, 0, -0.75183963775634765, 0.659345984458923339, 120, 255, 1, 45745), -- Chair (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+126, 258315, 0, 1519, 4411, '0', 6666, 0, -8329.12890625, 1204.1007080078125, 5.489162921905517578, 1.352629423141479492, 0, 0, 0.62592315673828125, 0.779884755611419677, 120, 255, 1, 45745), -- Chair (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+127, 258316, 0, 1519, 4411, '0', 6666, 0, -8330.935546875, 1204.0625, 5.490406513214111328, 1.562067151069641113, 0, 0, 0.704013824462890625, 0.710186243057250976, 120, 255, 1, 45745), -- Chair (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+128, 258317, 0, 1519, 4411, '0', 6666, 0, -8332.6513671875, 1203.984375, 5.492976665496826171, 1.300268411636352539, 0, 0, 0.60529327392578125, 0.796002507209777832, 120, 255, 1, 45745), -- Chair (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+129, 258318, 0, 1519, 4411, '0', 6666, 0, -8334.4580078125, 1204.060791015625, 5.490244388580322265, 1.32644820213317871, 0, 0, 0.615660667419433593, 0.788011372089385986, 120, 255, 1, 45745), -- Chair (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+130, 204284, 0, 1519, 4411, '0', 6666, 0, -8451.6904296875, 1315.6700439453125, -51.8484001159667968, 3.804818391799926757, 0, 0, -0.94551849365234375, 0.325568377971649169, 120, 255, 1, 45745), -- Stormwind Lobster Trap (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+131, 204284, 0, 1519, 4411, '0', 6666, 0, -8354.5, 1331.780029296875, -46.085601806640625, 4.136432647705078125, 0, 0, -0.87881660461425781, 0.477159708738327026, 120, 255, 1, 45745), -- Stormwind Lobster Trap (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+132, 204284, 0, 1519, 4411, '0', 6666, 0, -8416.490234375, 1356.7900390625, -54.1426010131835937, 0.27925160527229309, 0, 0, 0.139172554016113281, 0.990268170833587646, 120, 255, 1, 45745), -- Stormwind Lobster Trap (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+133, 204284, 0, 1519, 4411, '0', 6666, 0, -8313.4697265625, 1327.5799560546875, -52.9394989013671875, 2.129300594329833984, 0, 0, 0.874619483947753906, 0.484810054302215576, 120, 255, 1, 45745), -- Stormwind Lobster Trap (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+134, 211319, 0, 1519, 4411, '0', 6666, 0, -8333.75390625, 1362.032958984375, 8.909482002258300781, 4.321861743927001953, 0, 0, -0.83086585998535156, 0.5564727783203125, 120, 255, 1, 45745), -- Relief Bucket (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+135, 204284, 0, 1519, 4411, '0', 6666, 0, -8355.9599609375, 1388.4599609375, -52.8485984802246093, 1.204277276992797851, 0, 0, 0.56640625, 0.824126183986663818, 120, 255, 1, 45745), -- Stormwind Lobster Trap (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+136, 175727, 0, 1519, 4411, '0', 6666, 0, -8274.7275390625, 1206.451416015625, 6.39814615249633789, 2.262314796447753906, -0.01293325424194335, 0.010180473327636718, 0.904757499694824218, 0.425608962774276733, 120, 255, 1, 45745), -- The War of the Ancients (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+137, 21583, 0, 1519, 4411, '0', 6666, 0, -8274.33203125, 1206.798583984375, 6.413589000701904296, 2.202923536300659179, -0.01262521743774414, 0.010560035705566406, 0.891721725463867187, 0.45228472352027893, 120, 255, 1, 45745), -- The Kaldorei and the Well of Eternity (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+138, 175740, 0, 1519, 4411, '0', 6666, 0, -8280.0283203125, 1204.3385009765625, 6.341889858245849609, 1.824241042137145996, -0.01041221618652343, 0.012747764587402343, 0.790659904479980468, 0.612034320831298828, 120, 255, 1, 45745), -- The Last Guardian (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+139, 258276, 0, 1519, 4411, '0', 6666, 0, -8271.4736328125, 1213.9132080078125, 5.241162300109863281, 5.305802345275878906, 0, 0, -0.46947097778320312, 0.882947921752929687, 120, 255, 1, 45745), -- Chair (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+140, 258281, 0, 1519, 4411, '0', 6666, 0, -8278.375, 1205.3055419921875, 5.515467643737792968, 3.761187076568603515, 0, 0, -0.95239543914794921, 0.304865479469299316, 120, 255, 1, 45745), -- Chair (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+141, 258282, 0, 1519, 4411, '0', 6666, 0, -8278.970703125, 1202.640625, 5.581439971923828125, 2.172931671142578125, 0, 0, 0.88498687744140625, 0.46561598777770996, 120, 255, 1, 45745), -- Chair (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+142, 258283, 0, 1519, 4411, '0', 6666, 0, -8281.830078125, 1202.9739990234375, 5.55713510513305664, 0.479964137077331542, 0, 0, 0.237685203552246093, 0.971342265605926513, 120, 255, 1, 45745), -- Chair (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+143, 258284, 0, 1519, 4411, '0', 6666, 0, -8281.0205078125, 1205.795166015625, 5.501578807830810546, 5.31452798843383789, 0, 0, -0.46561431884765625, 0.88498777151107788, 120, 255, 1, 45745), -- Chair (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+144, 258287, 0, 1519, 4411, '0', 6666, 0, -8271.9287109375, 1203.7447509765625, 5.819287300109863281, 2.286378860473632812, 0, 0, 0.909960746765136718, 0.414694398641586303, 120, 255, 1, 45745), -- Chair (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+145, 175758, 0, 1519, 4411, '0', 6666, 0, -8273.4638671875, 1207.451416015625, 6.418070793151855468, 2.108719825744628906, -0.01211404800415039, 0.011142730712890625, 0.869437217712402343, 0.493769198656082153, 120, 255, 1, 45745), -- Archimonde's Return and the Flight to Kalimdor (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+146, 175724, 0, 1519, 4411, '0', 6666, 0, -8273.97265625, 1207.1771240234375, 6.457468509674072265, 2.159631252288818359, -0.01239395141601562, 0.010830879211425781, 0.881723403930664062, 0.471479535102844238, 120, 255, 1, 45745), -- Sargeras and the Betrayal (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+147, 258322, 0, 1519, 4411, '0', 6666, 0, -8263.091796875, 1231.59033203125, 5.230246543884277343, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 45745), -- Bench (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+148, 258275, 0, 1519, 4411, '0', 6666, 0, -8268.251953125, 1213.1649169921875, 5.255051136016845703, 3.752462387084960937, 0, 0, -0.95371627807617187, 0.300707906484603881, 120, 255, 1, 45745), -- Chair (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+149, 258277, 0, 1519, 4411, '0', 6666, 0, -8269.033203125, 1210.282958984375, 5.364426136016845703, 2.12057352066040039, 0, 0, 0.872495651245117187, 0.488621890544891357, 120, 255, 1, 45745), -- Chair (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+150, 175741, 0, 1519, 4411, '0', 6666, 0, -8269.92578125, 1212.173583984375, 6.14416360855102539, 2.901802539825439453, -0.01547813415527343, 0.005599021911621093, 0.992679595947265625, 0.119650825858116149, 120, 255, 1, 45745), -- Kil'jaeden and the Shadow Pact (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+151, 258319, 0, 1519, 4411, '0', 6666, 0, -8263.607421875, 1238.171875, 5.230231285095214843, 0.061086613684892654, 0, 0, 0.030538558959960937, 0.999533593654632568, 120, 255, 1, 45745), -- Bench (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+152, 258321, 0, 1519, 4411, '0', 6666, 0, -8259.2275390625, 1231.6597900390625, 5.230241775512695312, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 45745), -- Bench (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+153, 258234, 0, 1519, 4411, '0', 6666, 0, -8259.6337890625, 1238.279541015625, 5.230234622955322265, 0.087265998125076293, 0, 0, 0.043619155883789062, 0.999048233032226562, 120, 255, 1, 45745), -- Bench (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+154, 258320, 0, 1519, 4411, '0', 6666, 0, -8255.373046875, 1231.96875, 5.23023843765258789, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 45745), -- Bench (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+155, 258233, 0, 1519, 4411, '0', 6666, 0, -8255.826171875, 1238.5399169921875, 5.230231285095214843, 0.087265998125076293, 0, 0, 0.043619155883789062, 0.999048233032226562, 120, 255, 1, 45745), -- Bench (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+156, 204284, 0, 1519, 4411, '0', 6666, 0, -8289.5400390625, 1428.72998046875, -68.7674026489257812, 2.652894020080566406, 0, 0, 0.970294952392578125, 0.241925001144409179, 120, 255, 1, 45745), -- Stormwind Lobster Trap (Area: Stormwind Harbor - Difficulty: 0) +(@OGUID+157, 164759, 0, 1519, 4411, '0', 6666, 0, -8514.2685546875, 1323.6898193359375, 6.06749725341796875, 5.366890430450439453, 0, 0, -0.44228744506835937, 0.896873354911804199, 120, 255, 1, 45745); -- Wooden Chair (Area: Stormwind Harbor - Difficulty: 0) + +-- GameObject Addon +DELETE FROM `gameobject_addon` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+157; +INSERT INTO `gameobject_addon` (`guid`, `parent_rotation0`, `parent_rotation1`, `parent_rotation2`, `parent_rotation3`, `WorldEffectID`, `AIAnimKitID`) VALUES +(@OGUID+39, 0, 0, 0, 1, 2437, 0), -- Medical Supply Crate +(@OGUID+41, 0, 0, 0, 1, 2437, 0), -- Medical Supply Crate +(@OGUID+102, 0, 0, 0, 1, 2437, 0), -- Medical Supply Crate +(@OGUID+116, 0, 0, -0.71325039863586425, 0.700909316539764404, 0, 0), -- Wooden Chair +(@OGUID+157, 0, 0, -0.71325039863586425, 0.700909316539764404, 0, 0); -- Wooden Chair + +-- GameObject Template Addon +DELETE FROM `gameobject_template_addon` WHERE `entry` IN (251234 /*Light-Infused Crystals*/, 251247 /*Pandaren Barrel 2*/, 251233 /*Light-Infused Crystals*/, 251021 /*Medical Supply Crate*/, 251225 /*Draenei Chest*/, 251088 /*Rune*/, 251223 /*Draenei Chest*/, 251255 /*Ribs*/, 251241 /*Rug*/, 251250 /*Baked Fish*/, 251228 /*Draenei Pillow 3*/, 251231 /*Basket Empty*/, 251235 /*Light-Infused Crystals*/, 251251 /*Baked Fowl*/, 251229 /*Draenei Table*/, 251224 /*Draenei Chest*/, 251244 /*Draenei Wagon 2*/, 251240 /*Draenei Wagon*/, 251347 /*Submarine*/, 251252 /*Dumplings*/, 251236 /*Draenei Crate 1*/, 251230 /*Draenei Barrel*/, 251253 /*Fried Rice*/, 251023 /*Medical Supply Crate*/, 251022 /*Medical Supply Crate*/, 251227 /*Draenei Pillow 2*/, 251226 /*Draenei Pillow 1*/, 251195 /*Keg of Armor Polish*/, 250660 /*Alliance Battleship*/, 251246 /*Pandaren Barrel*/, 251232 /*Basket Closed*/, 251254 /*Grilled Fish*/, 251242 /*Crystal Bucket*/, 251238 /*Supply Stack*/, 251146 /*7.0 Pre-Launch - Stormwind - Template*/, 251237 /*Draenei Crate 2*/, 257881 /*7.0 Pre-Launch - Orgrimmar - Template Object*/, 257880 /*7.0 Pre-Launch - Orgrimmar - Template Object*/, 257879 /*Anvil*/, 257878 /*Forge*/, 259041 /*Alliance Battleship*/, 258255 /*Campfire*/, 258254 /*Campfire*/, 258302 /*Bubbling Pot*/, 258301 /*Noodle Cart*/); +INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`) VALUES +(251234, 0, 262176, 0, 0), -- Light-Infused Crystals +(251247, 0, 32, 0, 0), -- Pandaren Barrel 2 +(251233, 0, 262176, 0, 0), -- Light-Infused Crystals +(251021, 0, 2113568, 2437, 0), -- Medical Supply Crate +(251225, 0, 32, 0, 0), -- Draenei Chest +(251088, 0, 32, 0, 0), -- Rune +(251223, 0, 32, 0, 0), -- Draenei Chest +(251255, 0, 262176, 0, 0), -- Ribs +(251241, 0, 32, 0, 0), -- Rug +(251250, 0, 262176, 0, 0), -- Baked Fish +(251228, 0, 32, 0, 0), -- Draenei Pillow 3 +(251231, 0, 32, 0, 0), -- Basket Empty +(251235, 0, 262176, 0, 0), -- Light-Infused Crystals +(251251, 0, 262176, 0, 0), -- Baked Fowl +(251229, 0, 32, 0, 0), -- Draenei Table +(251224, 0, 32, 0, 0), -- Draenei Chest +(251244, 0, 32, 0, 0), -- Draenei Wagon 2 +(251240, 0, 32, 0, 0), -- Draenei Wagon +(251347, 0, 32, 0, 0), -- Submarine +(251252, 0, 262176, 0, 0), -- Dumplings +(251236, 0, 32, 0, 0), -- Draenei Crate 1 +(251230, 0, 32, 0, 0), -- Draenei Barrel +(251253, 0, 262176, 0, 0), -- Fried Rice +(251023, 0, 2113568, 2437, 0), -- Medical Supply Crate +(251022, 0, 2113568, 2437, 0), -- Medical Supply Crate +(251227, 0, 32, 0, 0), -- Draenei Pillow 2 +(251226, 0, 32, 0, 0), -- Draenei Pillow 1 +(251195, 0, 262144, 0, 0), -- Keg of Armor Polish +(250660, 0, 1048608, 0, 0), -- Alliance Battleship +(251246, 0, 32, 0, 0), -- Pandaren Barrel +(251232, 0, 32, 0, 0), -- Basket Closed +(251254, 0, 262176, 0, 0), -- Grilled Fish +(251242, 0, 32, 0, 0), -- Crystal Bucket +(251238, 0, 32, 0, 0), -- Supply Stack +(251146, 0, 32, 0, 0), -- 7.0 Pre-Launch - Stormwind - Template +(251237, 0, 32, 0, 0), -- Draenei Crate 2 +(257881, 0, 32, 0, 0), -- 7.0 Pre-Launch - Orgrimmar - Template Object +(257880, 0, 32, 0, 0), -- 7.0 Pre-Launch - Orgrimmar - Template Object +(257879, 0, 32, 0, 0), -- Anvil +(257878, 0, 32, 0, 0), -- Forge +(259041, 0, 1048608, 0, 0), -- Alliance Battleship +(258255, 0, 32, 0, 0), -- Campfire +(258254, 0, 32, 0, 0), -- Campfire +(258302, 0, 32, 0, 0), -- Bubbling Pot +(258301, 0, 32, 0, 0); -- Noodle Cart + +-- GameObject Template +UPDATE `gameobject_template` SET `VerifiedBuild`=45745 WHERE `entry` IN (164759, 258320, 258233, 258321, 258319, 258234, 258322, 258277, 258275, 175741, 258276, 258287, 175758, 175724, 21583, 175727, 258281, 258282, 175740, 258284, 258283, 211319, 258318, 258317, 258316, 258315, 258313, 258312, 258310, 258309, 258306, 258308, 258307, 258305, 258304, 164760, 293894, 209034, 204284); +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry` IN (259041, 250660); -- Alliance Battleship +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry` IN (258254, 258255); -- Campfire +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=257878; -- Forge +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=258302; -- Bubbling Pot +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry` IN (257881, 257880); -- 7.0 Pre-Launch - Orgrimmar - Template Object +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=251241; -- Rug +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=251251; -- Baked Fowl +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry` IN (251233, 251234, 251235); -- Light-Infused Crystals +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=251252; -- Dumplings +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=251230; -- Draenei Barrel +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=251229; -- Draenei Table +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=251231; -- Basket Empty +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=251255; -- Ribs +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=251240; -- Draenei Wagon +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=251242; -- Crystal Bucket +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry` IN (251022, 251021, 251023); -- Medical Supply Crate +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=251247; -- Pandaren Barrel 2 +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=251244; -- Draenei Wagon 2 +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=251236; -- Draenei Crate 1 +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=251232; -- Basket Closed +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=251250; -- Baked Fish +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=251253; -- Fried Rice +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=251227; -- Draenei Pillow 2 +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry` IN (251225, 251223, 251224); -- Draenei Chest +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=251237; -- Draenei Crate 2 +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=251347; -- Submarine +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=251088; -- Rune +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=251228; -- Draenei Pillow 3 +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=251195; -- Keg of Armor Polish +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=251254; -- Grilled Fish +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=251246; -- Pandaren Barrel +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=251146; -- 7.0 Pre-Launch - Stormwind - Template +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=251238; -- Supply Stack +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=250877; -- Bedroll +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=251289; -- Tools 1 +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=251226; -- Draenei Pillow 1 +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=258301; -- Noodle Cart +UPDATE `gameobject_template` SET `ContentTuningId`=356, `VerifiedBuild`=45745 WHERE `entry`=257879; -- Anvil + +-- Creature Equip template +DELETE FROM `creature_equip_template` WHERE (`CreatureID`=107839 AND `ID`=2); +INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `AppearanceModID1`, `ItemVisual1`, `ItemID2`, `AppearanceModID2`, `ItemVisual2`, `ItemID3`, `AppearanceModID3`, `ItemVisual3`, `VerifiedBuild`) VALUES +(107839, 2, 864, 0, 0, 0, 0, 0, 0, 0, 0, 45745); -- Alliance Recruit + +-- Creature Movement +DELETE FROM `creature_template_movement` WHERE `CreatureID` = 108691; +INSERT INTO `creature_template_movement` (`CreatureId`, `Ground`, `Swim`, `Flight`, `Rooted`, `Chase`, `Random`, `InteractionPauseTimer`) VALUES +(108691, 0, 0, 1, 0, 0, 0, NULL); + +-- Spell area for Skybox +DELETE FROM `spell_area` WHERE `spell` = 214608 AND `area` = 4411; +INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `flags`, `quest_start_status`, `quest_end_status`) VALUES +(214608, 4411, 40519, 44663, 0, 0, 2, 3, 74, 11); + +-- Phasing +DELETE FROM `phase_area` WHERE `AreaId` = 4411 AND `PhaseId` IN (6666, 13306); +INSERT INTO `phase_area` (`AreaId`,`PhaseId`,`Comment`) VALUES +(4411, 6666, 'Pre-Broken Shore Stormwind Harbor'), +(4411, 13306, 'Pre-Broken Shore Stormwind Harbor - Ramp'); + +DELETE FROM `phase_name` WHERE `ID` IN (6666, 13306); +INSERT INTO `phase_name` (`ID`,`Name`) VALUES +(6666, 'Pre-Broken Shore Stormwind Habor'), +(13306, 'Pre-Broken Shore Stormwind Habor - Ramp'); + +DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId` = 26 AND `SourceGroup` IN (6666, 13306) AND `SourceEntry` = 4411); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `Comment`) VALUES +(26, 6666, 4411, 0, 0, 47, 0, 40519, 8 | 2 | 64, 0, 0, 'Apply Phase 6666 if Quest 40519 is taken | completed | rewarded'), +(26, 6666, 4411, 0, 0, 47, 0, 44663, 64, 0, 1, 'Apply Phase 6666 if Quest 44663 is not rewarded'), +(26, 13306, 4411, 0, 0, 47, 0, 40519, 8 | 2 | 64, 0, 0, 'Apply Phase 13306 if Quest 40519 is taken | completed | rewarded'), +(26, 13306, 4411, 0, 0, 47, 0, 44663, 64, 0, 1, 'Apply Phase 13306 if Quest 6821 is not rewarded'); + +-- Scaling +DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=0 AND `Entry` IN (108292,108298,108241,108296,6086,53966,53961,53954,53950,108297)); +INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES +(108292, 0, 0, 0, 356, 45745), +(108298, 0, 0, 0, 356, 45745), +(108241, 0, 0, 0, 356, 45745), +(108296, 0, 0, 0, 356, 45745), +(6086, 0, 0, 0, 2108, 45745), +(53966, 0, 0, 0, 861, 45745), +(53961, 0, 0, 0, 861, 45745), +(53954, 0, 0, 0, 861, 45745), +(53950, 0, 0, 0, 861, 45745), +(108297, 0, 0, 0, 356, 45745); + +-- Vendor Data +DELETE FROM `npc_vendor` WHERE (`entry`=1308 AND `item`=188152 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=108138 AND `item`=5976 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=108138 AND `item`=15198 AND `ExtendedCost`=5962 AND `type`=1) OR (`entry`=108138 AND `item`=15196 AND `ExtendedCost`=5962 AND `type`=1) OR (`entry`=108138 AND `item`=19032 AND `ExtendedCost`=5992 AND `type`=1) OR (`entry`=108138 AND `item`=19506 AND `ExtendedCost`=5992 AND `type`=1) OR (`entry`=108138 AND `item`=31774 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=108138 AND `item`=23999 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=108138 AND `item`=64901 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=108138 AND `item`=64902 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=108138 AND `item`=64903 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=108138 AND `item`=67531 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=108138 AND `item`=45574 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=108533 AND `item`=97921 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=108533 AND `item`=138385 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=108533 AND `item`=138384 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=108533 AND `item`=138382 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=108533 AND `item`=138383 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=108586 AND `item`=117474 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=108586 AND `item`=117473 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=108586 AND `item`=117472 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=108586 AND `item`=117452 AND `ExtendedCost`=0 AND `type`=1); +INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES +(1308, 2, 188152, 0, 0, 1, 0, 0, 45745), -- Gateway Control Shard +(108138, 12, 5976, 0, 0, 1, 0, 0, 45745), -- Guild Tabard +(108138, 11, 15198, 0, 5962, 1, 0, 0, 45745), -- Knight's Colors +(108138, 10, 15196, 0, 5962, 1, 0, 0, 45745), -- Private's Tabard +(108138, 9, 19032, 0, 5992, 1, 0, 0, 45745), -- Stormpike Battle Tabard +(108138, 8, 19506, 0, 5992, 1, 0, 0, 45745), -- Silverwing Battle Tabard +(108138, 7, 31774, 0, 0, 1, 0, 0, 45745), -- Kurenai Tabard +(108138, 6, 23999, 0, 0, 1, 0, 0, 45745), -- Honor Hold Tabard +(108138, 5, 64901, 0, 0, 1, 12252, 0, 45745), -- Mantle of Stormwind +(108138, 4, 64902, 0, 0, 1, 12252, 0, 45745), -- Cape of Stormwind +(108138, 3, 64903, 0, 0, 1, 12252, 0, 45745), -- Shroud of Stormwind +(108138, 2, 67531, 0, 0, 1, 12251, 0, 45745), -- Stormwind Satchel +(108138, 1, 45574, 0, 0, 1, 0, 0, 45745), -- Stormwind Tabard +(108533, 5, 97921, 0, 0, 1, 0, 0, 45745), -- Bom'bay's Color-Seein' Sauce +(108533, 4, 138385, 0, 0, 1, 0, 0, 45745), -- Lucky Shirt +(108533, 3, 138384, 0, 0, 1, 0, 0, 45745), -- Lucky Charm +(108533, 2, 138382, 0, 0, 1, 0, 0, 45745), -- Lucky Rat's Tooth +(108533, 1, 138383, 0, 0, 1, 0, 0, 45745), -- Old Lucky Coin +(108586, 4, 117474, 0, 0, 1, 0, 0, 45745), -- Rylak Sausages +(108586, 3, 117473, 0, 0, 1, 0, 0, 45745), -- Pickled Elekk Hooves +(108586, 2, 117472, 0, 0, 1, 0, 0, 45745), -- Grilled Gorgrond Surprise +(108586, 1, 117452, 0, 0, 1, 0, 0, 45745); -- Gorgrond Mineral Water + +-- Waypoints for CGUID+363 +SET @PATH := (@CGUID+363) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, -8510.51, 949.2531, 96.51216, NULL, 0), +(@PATH, 1, -8535.311, 952.0538, 96.71056, NULL, 0), +(@PATH, 2, -8545.017, 962.062, 96.68385, NULL, 0), +(@PATH, 3, -8564.381, 983.8884, 96.44182, NULL, 0), +(@PATH, 4, -8571.524, 993.6271, 96.36514, NULL, 0), +(@PATH, 5, -8580.669, 1005.541, 96.28225, NULL, 0), +(@PATH, 6, -8586.875, 1019.077, 96.16861, NULL, 0), +(@PATH, 7, -8604.854, 1039.209, 96.18464, NULL, 0), +(@PATH, 8, -8586.875, 1019.077, 96.16861, NULL, 0), +(@PATH, 9, -8580.669, 1005.541, 96.28225, NULL, 0), +(@PATH, 10, -8571.524, 993.6271, 96.36514, NULL, 0), +(@PATH, 11, -8564.381, 983.8884, 96.44182, NULL, 0), +(@PATH, 12, -8545.017, 962.062, 96.68385, NULL, 0), +(@PATH, 13, -8535.311, 952.0538, 96.71056, NULL, 0), +(@PATH, 14, -8510.51, 949.2531, 96.51216, NULL, 0), +(@PATH, 15, -8490.954, 951.4664, 96.30904, NULL, 0), +(@PATH, 16, -8481.771, 955.3033, 96.33279, NULL, 0), +(@PATH, 17, -8458.89, 977.1547, 96.30904, NULL, 0), +(@PATH, 18, -8436.071, 996.3249, 96.36818, NULL, 0), +(@PATH, 19, -8458.84, 977.1962, 96.30904, NULL, 0), +(@PATH, 20, -8481.771, 955.3033, 96.33279, NULL, 0), +(@PATH, 21, -8490.954, 951.4664, 96.30904, NULL, 0); + +UPDATE `creature` SET `position_x`= -8510.51, `position_y`= 949.2531, `position_z`= 96.51216, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+363; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+363; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+363, @PATH, 1); + +-- Waypoints for CGUID+364 +SET @PATH := (@CGUID+364) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, -8399.659, 1046.967, 68.52675, NULL, 0), +(@PATH, 1, -8406.388, 1049.458, 68.51216, NULL, 0), +(@PATH, 2, -8412.033, 1049.239, 68.51216, NULL, 0), +(@PATH, 3, -8416.558, 1047.092, 68.51216, NULL, 0), +(@PATH, 4, -8419.694, 1043.185, 68.51216, NULL, 0), +(@PATH, 5, -8420.548, 1036.334, 68.54513, NULL, 0), +(@PATH, 6, -8418.053, 1024.265, 68.51215, NULL, 0), +(@PATH, 7, -8430.958, 1014.584, 75.07448, NULL, 0), +(@PATH, 8, -8448.758, 999.7491, 79.45544, NULL, 0), +(@PATH, 9, -8466.758, 985.998, 79.15817, NULL, 0), +(@PATH, 10, -8448.758, 999.7491, 79.45544, NULL, 0), +(@PATH, 11, -8430.958, 1014.584, 75.07448, NULL, 0), +(@PATH, 12, -8418.053, 1024.265, 68.51215, NULL, 0), +(@PATH, 13, -8420.548, 1036.334, 68.54513, NULL, 0), +(@PATH, 14, -8419.694, 1043.185, 68.51216, NULL, 0), +(@PATH, 15, -8416.558, 1047.092, 68.51216, NULL, 0), +(@PATH, 16, -8412.033, 1049.239, 68.51216, NULL, 0), +(@PATH, 17, -8406.388, 1049.458, 68.51216, NULL, 0), +(@PATH, 18, -8399.659, 1046.967, 68.52675, NULL, 0), +(@PATH, 19, -8390.372, 1043.123, 68.51216, NULL, 0), +(@PATH, 20, -8366.223, 1061.28, 57.72314, NULL, 0), +(@PATH, 21, -8344.169, 1080.097, 57.37533, NULL, 0), +(@PATH, 22, -8331.262, 1091.611, 57.31336, NULL, 0), +(@PATH, 23, -8344.169, 1080.097, 57.37533, NULL, 0), +(@PATH, 24, -8366.223, 1061.28, 57.72314, NULL, 0), +(@PATH, 25, -8390.372, 1043.123, 68.51216, NULL, 0); + +UPDATE `creature` SET `position_x`= -8399.659, `position_y`= 1046.967, `position_z`= 68.52675, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+364; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+364; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+364, @PATH, 1); + +-- Waypoints for CGUID+341 +SET @PATH := (@CGUID+341) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, -8400.794, 1075.946, 31.7196, NULL, 0), +(@PATH, 1, -8397.671, 1086.549, 29.41692, NULL, 0), +(@PATH, 2, -8395.961, 1107.979, 19.89705, NULL, 0), +(@PATH, 3, -8395.935, 1116.135, 17.96996, NULL, 0), +(@PATH, 4, -8395.961, 1107.979, 19.89705, NULL, 0), +(@PATH, 5, -8397.671, 1086.549, 29.41692, NULL, 0), +(@PATH, 6, -8400.794, 1075.946, 31.7196, NULL, 0), +(@PATH, 7, -8412.029, 1068.872, 31.7196, NULL, 0), +(@PATH, 8, -8431.488, 1055.909, 40.97847, NULL, 0), +(@PATH, 9, -8448.238, 1039.041, 53.5966, NULL, 0), +(@PATH, 10, -8464.138, 1029.035, 59.51215, NULL, 0), +(@PATH, 11, -8483.146, 1027.786, 59.7439, NULL, 0), +(@PATH, 12, -8464.138, 1029.035, 59.51215, NULL, 0), +(@PATH, 13, -8448.238, 1039.041, 53.5966, NULL, 0), +(@PATH, 14, -8431.488, 1055.909, 40.97847, NULL, 0), +(@PATH, 15, -8412.029, 1068.872, 31.7196, NULL, 0); + +UPDATE `creature` SET `position_x`= -8400.794, `position_y`= 1075.946, `position_z`= 31.7196, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+341; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+341; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+341, @PATH, 1); + +-- Waypoints for CGUID+60 +SET @PATH := (@CGUID+60) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, -8546.276, 1177.882, 17.60952, NULL, 0), +(@PATH, 1, -8530.627, 1177.66, 17.63781, NULL, 0), +(@PATH, 2, -8513.906, 1177.974, 17.62352, NULL, 0), +(@PATH, 3, -8507.757, 1178.127, 17.64993, NULL, 0), +(@PATH, 4, -8505.795, 1173.578, 17.68895, NULL, 10074), +(@PATH, 5, -8507.757, 1178.127, 17.64993, NULL, 0), +(@PATH, 6, -8513.906, 1177.974, 17.62352, NULL, 0), +(@PATH, 7, -8530.627, 1177.66, 17.63781, NULL, 0), +(@PATH, 8, -8546.276, 1177.882, 17.60952, NULL, 0), +(@PATH, 9, -8551.781, 1173.28, 17.73284, NULL, 10063); + +UPDATE `creature` SET `position_x`= -8546.276, `position_y`= 1177.882, `position_z`= 17.60952, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+60; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+60; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+60, @PATH, 1); + +-- Waypoints for CGUID+220 +SET @PATH := (@CGUID+220) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, -8330.277, 1139.626, 18.90213, NULL, 0), +(@PATH, 1, -8338.677, 1141.807, 19.02713, NULL, 0), +(@PATH, 2, -8341.822, 1144.29, 19.15213, NULL, 22092), +(@PATH, 3, -8333.334, 1143.177, 19.02713, NULL, 23378), +(@PATH, 4, -8329.256, 1139.975, 18.90213, NULL, 0), +(@PATH, 5, -8320.707, 1140.153, 18.90213, NULL, 0), +(@PATH, 6, -8317.431, 1145.047, 19.02713, NULL, 29403); + +UPDATE `creature` SET `position_x`= -8330.277, `position_y`= 1139.626, `position_z`= 18.90213, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+220; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+220; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+220, @PATH, 1); + +-- Waypoints for CGUID+150 +SET @PATH := (@CGUID+150) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, -8419.116, 1126.676, 19.06917, NULL, 0), +(@PATH, 1, -8420.849, 1129.353, 18.85921, NULL, 0), +(@PATH, 2, -8423.114, 1128.677, 18.94417, NULL, 0), +(@PATH, 3, -8422.651, 1126.724, 19.06917, NULL, 10504), +(@PATH, 4, -8427.568, 1123.782, 19.06917, NULL, 0), +(@PATH, 5, -8427.253, 1120.467, 19.06917, NULL, 25489), +(@PATH, 6, -8425.388, 1126.362, 19.06917, NULL, 0), +(@PATH, 7, -8420.282, 1127.108, 19.00362, NULL, 0), +(@PATH, 8, -8414.95, 1123.927, 19.06917, NULL, 0), +(@PATH, 9, -8416.248, 1122.003, 19.06917, NULL, 36756); + +UPDATE `creature` SET `position_x`= -8419.116, `position_y`= 1126.676, `position_z`= 19.06917, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+150; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+150; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+150, @PATH, 1); + +-- Waypoints for CGUID+270 +SET @PATH := (@CGUID+270) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, -8229.291, 1170.029, 17.68237, NULL, 0), +(@PATH, 1, -8278.599, 1171.045, 17.7196, NULL, 0), +(@PATH, 2, -8301.696, 1170.134, 17.71961, NULL, 0), +(@PATH, 3, -8278.599, 1171.045, 17.7196, NULL, 0), +(@PATH, 4, -8229.291, 1170.029, 17.68237, NULL, 0), +(@PATH, 5, -8205.958, 1172.401, 17.73533, NULL, 0); + +UPDATE `creature` SET `position_x`= -8229.291, `position_y`= 1170.029, `position_z`= 17.68237, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+270; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+270; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+270, @PATH, 1); + +-- Waypoints for CGUID+321 +SET @PATH := (@CGUID+321) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, -8114.611, 1259.188, 7.892336, NULL, 0), +(@PATH, 1, -8098.006, 1249.281, 8.767336, NULL, 0), +(@PATH, 2, -8086.922, 1261.266, 8.2605, NULL, 0), +(@PATH, 3, -8086.253, 1277.079, 7.973274, NULL, 0), +(@PATH, 4, -8115.943, 1302.066, 7.88038, NULL, 0), +(@PATH, 5, -8086.253, 1277.079, 7.973274, NULL, 0), +(@PATH, 6, -8086.922, 1261.266, 8.2605, NULL, 0), +(@PATH, 7, -8098.006, 1249.281, 8.767336, NULL, 0), +(@PATH, 8, -8114.611, 1259.188, 7.892336, NULL, 0), +(@PATH, 9, -8136.474, 1273.335, 7.889561, NULL, 0); + +UPDATE `creature` SET `position_x`= -8114.611, `position_y`= 1259.188, `position_z`= 7.892336, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+321; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+321; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+321, @PATH, 1); + +-- Waypoints for CGUID+326 +SET @PATH := (@CGUID+326) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, -8068.455, 1244.447, 7.969118, NULL, 0), +(@PATH, 1, -8046.319, 1265.435, 9.961094, NULL, 0), +(@PATH, 2, -8048.064, 1277.22, 8.148955, NULL, 0), +(@PATH, 3, -8056.742, 1285.233, 7.898955, NULL, 0), +(@PATH, 4, -8073.368, 1302.083, 7.896749, NULL, 0), +(@PATH, 5, -8056.742, 1285.233, 7.898955, NULL, 0), +(@PATH, 6, -8048.064, 1277.22, 8.148955, NULL, 0), +(@PATH, 7, -8046.319, 1265.435, 9.961094, NULL, 0), +(@PATH, 8, -8068.455, 1244.447, 7.969118, NULL, 0), +(@PATH, 9, -8086.316, 1227.96, 7.677228, NULL, 0), +(@PATH, 10, -8104.837, 1209.826, 7.301755, NULL, 0), +(@PATH, 11, -8104.577, 1203.61, 7.551755, NULL, 0), +(@PATH, 12, -8104.837, 1209.826, 7.301755, NULL, 0), +(@PATH, 13, -8086.316, 1227.96, 7.677228, NULL, 0); + +UPDATE `creature` SET `position_x`= -8068.455, `position_y`= 1244.447, `position_z`= 7.969118, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+326; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+326; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+326, @PATH, 1); + +-- Waypoints for CGUID+226 +SET @PATH := (@CGUID+226) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, -8293.91, 1275.809, 5.313354, NULL, 0), +(@PATH, 1, -8294.161, 1265.714, 5.313354, NULL, 0), +(@PATH, 2, -8298.545, 1265.813, 5.313354, NULL, 5891), +(@PATH, 3, -8294.724, 1277.917, 5.313355, NULL, 0), +(@PATH, 4, -8294.896, 1292.168, 5.313354, NULL, 0), +(@PATH, 5, -8300.497, 1292.436, 5.382405, NULL, 6437); + +UPDATE `creature` SET `position_x`= -8293.91, `position_y`= 1275.809, `position_z`= 5.313354, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+226; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+226; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+226, @PATH, 1); + +-- Waypoints for CGUID+266 +SET @PATH := (@CGUID+266) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, -8286.856, 1278.153, 5.313354, NULL, 0), +(@PATH, 1, -8286.861, 1285.672, 5.313354, NULL, 0), +(@PATH, 2, -8283.967, 1285.76, 5.313355, NULL, 5414), +(@PATH, 3, -8286.728, 1277.924, 5.313354, NULL, 0), +(@PATH, 4, -8286.716, 1269.7, 5.313354, NULL, 0), +(@PATH, 5, -8283.658, 1269.411, 5.313354, NULL, 5496); + +UPDATE `creature` SET `position_x`= -8286.856, `position_y`= 1278.153, `position_z`= 5.313354, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+266; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+266; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+266, @PATH, 1); + +-- Waypoints for CGUID+32 +SET @PATH := (@CGUID+32) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, -8475.846, 1209.424, 5.320824, NULL, 0), +(@PATH, 1, -8510.788, 1214.557, 5.190891, NULL, 0), +(@PATH, 2, -8475.846, 1209.424, 5.320824, NULL, 0), +(@PATH, 3, -8444.612, 1208.325, 5.18425, NULL, 0), +(@PATH, 4, -8419.291, 1208.162, 5.281563, NULL, 0), +(@PATH, 5, -8444.612, 1208.325, 5.18425, NULL, 0); + +UPDATE `creature` SET `position_x`= -8475.846, `position_y`= 1209.424, `position_z`= 5.320824, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+32; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+32; +INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes2`) VALUES +(@CGUID+32, @PATH, 2410, 257); + +-- Waypoints for CGUID+31 +SET @PATH := (@CGUID+31) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, -8558.985, 1239.222, 5.393101, NULL, 0), +(@PATH, 1, -8584.936, 1235.224, 5.393101, NULL, 0), +(@PATH, 2, -8593.689, 1237.97, 5.393101, NULL, 0), +(@PATH, 3, -8596.938, 1243.012, 5.393101, NULL, 0), +(@PATH, 4, -8593.689, 1237.97, 5.393101, NULL, 0), +(@PATH, 5, -8584.936, 1235.224, 5.393101, NULL, 0), +(@PATH, 6, -8558.985, 1239.222, 5.393101, NULL, 0), +(@PATH, 7, -8549.759, 1245.416, 5.393101, NULL, 0), +(@PATH, 8, -8526.583, 1246.124, 5.313354, NULL, 0), +(@PATH, 9, -8521.271, 1234.52, 5.313355, NULL, 0), +(@PATH, 10, -8503.136, 1233.855, 5.313354, NULL, 0), +(@PATH, 11, -8473.279, 1244.646, 5.404755, NULL, 0), +(@PATH, 12, -8473.544, 1248.154, 5.39212, NULL, 0), +(@PATH, 13, -8503.136, 1233.855, 5.313354, NULL, 0), +(@PATH, 14, -8521.271, 1234.52, 5.313355, NULL, 0), +(@PATH, 15, -8526.583, 1246.124, 5.313354, NULL, 0), +(@PATH, 16, -8549.759, 1245.416, 5.393101, NULL, 0); + +UPDATE `creature` SET `position_x`= -8558.985, `position_y`= 1239.222, `position_z`= 5.393101, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+31; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+31; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+31, @PATH, 1); + +-- Waypoints for CGUID+158 +SET @PATH := (@CGUID+158) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, -8373.257, 1324.163, 5.313354, NULL, 10613), +(@PATH, 1, -8379.228, 1312.783, 5.313354, NULL, 0), +(@PATH, 2, -8380.141, 1299.856, 5.378013, NULL, 0), +(@PATH, 3, -8376.221, 1265.028, 5.313354, NULL, 0), +(@PATH, 4, -8361.548, 1158.6, 17.96915, NULL, 0), +(@PATH, 5, -8372.714, 1127.194, 19.01928, NULL, 0), +(@PATH, 6, -8375.056, 1118.154, 19.09496, NULL, 0), +(@PATH, 7, -8373.721, 1113.185, 19.09496, NULL, 7691), +(@PATH, 8, -8374.737, 1123.714, 19.09496, NULL, 0), +(@PATH, 9, -8371.545, 1129.919, 18.81713, NULL, 0), +(@PATH, 10, -8365.591, 1146.693, 18.27713, NULL, 0), +(@PATH, 11, -8374.185, 1256.586, 5.230223, NULL, 0), +(@PATH, 12, -8380.175, 1299.527, 5.331606, NULL, 0), +(@PATH, 13, -8378.091, 1324.128, 5.313354, NULL, 0); + +UPDATE `creature` SET `position_x`= -8373.257, `position_y`= 1324.163, `position_z`= 5.313354, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+158; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+158; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+158, @PATH, 1); + +-- Waypoints for CGUID+189 +SET @PATH := (@CGUID+189) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, -8371.707, 1239.771, 5.387228, NULL, 0), +(@PATH, 1, -8371.647, 1224.997, 5.390843, NULL, 0), +(@PATH, 2, -8328.411, 1226.274, 5.230225, NULL, 8968), +(@PATH, 3, -8363.596, 1244.123, 5.230242, NULL, 0), +(@PATH, 4, -8363.471, 1245.545, 5.313354, NULL, 17247); + +UPDATE `creature` SET `position_x`= -8371.707, `position_y`= 1239.771, `position_z`= 5.387228, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+189; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+189; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+189, @PATH, 1); + +-- Waypoints for CGUID+234 +SET @PATH := (@CGUID+234) * 10; +DELETE FROM `waypoint_data` WHERE `id`= @PATH; +INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`) VALUES +(@PATH, 0, -8471.007, 1311.486, 5.313354, NULL, 0), +(@PATH, 1, -8471.222, 1268.183, 5.313354, NULL, 0), +(@PATH, 2, -8469.946, 1248.675, 5.230234, NULL, 0), +(@PATH, 3, -8450.389, 1234.392, 5.313354, NULL, 0), +(@PATH, 4, -8428.398, 1225.226, 5.313354, NULL, 0), +(@PATH, 5, -8402.25, 1230.661, 5.313354, NULL, 0), +(@PATH, 6, -8396.396, 1248.257, 5.419862, NULL, 0), +(@PATH, 7, -8389.8, 1255.921, 5.230223, NULL, 0), +(@PATH, 8, -8386.434, 1289.044, 5.327344, NULL, 0), +(@PATH, 9, -8388.218, 1308.078, 5.313354, NULL, 12164), +(@PATH, 10, -8387.928, 1281.509, 5.313354, NULL, 0), +(@PATH, 11, -8389.672, 1261.436, 5.313354, NULL, 0), +(@PATH, 12, -8390.705, 1248.424, 5.230217, NULL, 0), +(@PATH, 13, -8398.755, 1229.639, 5.375839, NULL, 0), +(@PATH, 14, -8427.549, 1224.418, 5.313355, NULL, 0), +(@PATH, 15, -8442.797, 1231.163, 5.313355, NULL, 0), +(@PATH, 16, -8464.288, 1243.83, 5.327602, NULL, 0), +(@PATH, 17, -8466.695, 1255.199, 5.230225, NULL, 0), +(@PATH, 18, -8469.892, 1288.597, 5.313354, NULL, 0), +(@PATH, 19, -8471.203, 1311.749, 5.313354, NULL, 0), +(@PATH, 20, -8470.382, 1320.346, 5.313354, NULL, 0), +(@PATH, 21, -8467.777, 1318.861, 5.313354, NULL, 9736); + +UPDATE `creature` SET `position_x`= -8471.007, `position_y`= 1311.486, `position_z`= 5.313354, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+234; +DELETE FROM `creature_addon` WHERE `guid`= @CGUID+234; +INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES +(@CGUID+234, @PATH, 1); |