DB/Spawns: Added Lunarfall Lumberjack Phase

Closes #28060

1 files changed, 329 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_07_16_03_world.sql b/sql/updates/world/master/2022_07_16_03_world.sql
new file mode 100644
index 00000000000..c04237faf6a
--- /dev/null
+++ b/sql/updates/world/master/2022_07_16_03_world.sql
@@ -0,0 +1,329 @@
+SET @CGUID := 460545;
+SET @OGUID := 395518;
+
+-- Creature
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+16;
+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, 79394, 1116, 7078, 7078, '0', 3290, 0, 0, 1, 1934.46533203125, 313.7257080078125, 89.472320556640625, 1.800719141960144042, 7200, 0, 0, 2463, 0, 0, 0, 0, 0, 44232), -- Lunarfall Guard (Area: -Unknown- - Difficulty: 0) (Auras: 42459 - Dual Wield)
+(@CGUID+1, 79255, 1116, 7078, 7078, '0', 3290, 0, 0, 1, 1877.451416015625, 253.0902862548828125, 78.26261138916015625, 2.021389961242675781, 7200, 10, 0, 2463, 0, 1, 0, 0, 0, 44232), -- Lumberjack (Area: -Unknown- - Difficulty: 0) (Auras: 158568 - Garrison Lumberjack Test - Carrying Lumber) (possible waypoints or random movement)
+(@CGUID+2, 79422, 1116, 7078, 7078, '0', 3290, 0, 0, 1, 1942.9722900390625, 324.520843505859375, 89.057037353515625, 2.319435834884643554, 7200, 0, 0, 2463, 0, 0, 0, 0, 0, 44232), -- Lunarfall Guard (Area: -Unknown- - Difficulty: 0) (Auras: 42459 - Dual Wield)
+(@CGUID+3, 82169, 1116, 7078, 7078, '0', 3290, 0, 0, 0, 1931.644287109375, 324.782379150390625, 89.20886993408203125, 0.367734491825103759, 7200, 10, 0, 2463, 0, 1, 0, 0, 0, 44232), -- Pippers (Area: -Unknown- - Difficulty: 0) (possible waypoints or random movement)
+(@CGUID+4, 81656, 1116, 7078, 7078, '0', 3290, 0, 0, 0, 1943.234375, 320.711822509765625, 89.04949951171875, 0.637826025485992431, 7200, 0, 0, 2463, 0, 0, 0, 0, 0, 44232), -- Garrison Packmule (Area: -Unknown- - Difficulty: 0)
+(@CGUID+5, 79255, 1116, 7078, 7078, '0', 3290, 0, 0, 1, 1972.333984375, 152.70709228515625, 79.832916259765625, 3.200233936309814453, 7200, 0, 0, 2463, 0, 0, 0, 0, 0, 44232), -- Lumberjack (Area: -Unknown- - Difficulty: 0)
+(@CGUID+6, 79255, 1116, 7078, 7078, '0', 3290, 0, 0, 1, 1780.6475830078125, 128.0037078857421875, 77.74655914306640625, 1.778342843055725097, 7200, 0, 0, 2463, 0, 0, 0, 0, 0, 44232), -- Lumberjack (Area: -Unknown- - Difficulty: 0)
+(@CGUID+7, 79255, 1116, 7078, 7078, '0', 3290, 0, 0, 1, 1778.2308349609375, 122.9129562377929687, 77.62664031982421875, 1.744619488716125488, 7200, 0, 0, 2463, 0, 0, 0, 0, 0, 44232), -- Lumberjack (Area: -Unknown- - Difficulty: 0)
+(@CGUID+8, 79255, 1116, 7078, 7078, '0', 3290, 0, 0, 1, 1782.1756591796875, 115.3199615478515625, 78.2211761474609375, 3.64882659912109375, 7200, 0, 0, 2463, 0, 0, 0, 0, 0, 44232), -- Lumberjack (Area: -Unknown- - Difficulty: 0)
+(@CGUID+9, 82037, 1116, 7078, 7078, '0', 3290, 0, 0, 0, 1743.6859130859375, 298.41748046875, 77.09755706787109375, 3.28266143798828125, 7200, 0, 0, 1970, 0, 0, 0, 0, 0, 44232), -- Lunarfall Raven (Area: -Unknown- - Difficulty: 0) (Auras: 123978 - Mod Scale 95-120%)
+(@CGUID+10, 79255, 1116, 7078, 7078, '0', 3290, 0, 0, 1, 1905.8472900390625, 341.263916015625, 87.8884429931640625, 3.509517669677734375, 7200, 0, 0, 2463, 0, 0, 0, 0, 0, 44232), -- Lumberjack (Area: -Unknown- - Difficulty: 0) (Auras: 158568 - Garrison Lumberjack Test - Carrying Lumber)
+(@CGUID+11, 84038, 1116, 7078, 7078, '0', 3290, 0, 0, 0, 1936.4913330078125, 337.885406494140625, 89.04918670654296875, 2.227719783782958984, 7200, 0, 0, 4926, 0, 0, 0, 0, 0, 44232), -- Lieutenant Thorn (Area: -Unknown- - Difficulty: 0)
+(@CGUID+12, 82168, 1116, 7078, 7078, '0', 3290, 0, 0, 0, 1934.6788330078125, 338.151031494140625, 89.08856201171875, 6.217315673828125, 7200, 0, 0, 2463, 1283, 0, 0, 0, 0, 44232), -- Foreman Zipfizzle (Area: -Unknown- - Difficulty: 0)
+(@CGUID+13, 84455, 1116, 7078, 7078, '0', 3290, 0, 0, 1, 1952.7100830078125, 342.114593505859375, 88.69085693359375, 6.2740325927734375, 7200, 0, 0, 2463, 1283, 0, 0, 0, 0, 44232), -- Assistant Brightstone (Area: -Unknown- - Difficulty: 0)
+(@CGUID+14, 79255, 1116, 7078, 7078, '0', 3290, 0, 0, 1, 1915.0850830078125, 383.881134033203125, 87.661590576171875, 4.032156944274902343, 7200, 0, 0, 2463, 0, 0, 0, 0, 0, 44232), -- Lumberjack (Area: -Unknown- - Difficulty: 0)
+(@CGUID+15, 82167, 1116, 7078, 7078, '0', 3290, 0, 0, 1, 1957.4617919921875, 345.7725830078125, 88.83444976806640625, 4.125303268432617187, 7200, 0, 0, 2463, 0, 0, 0, 0, 0, 44232), -- Jarrod Hamby (Area: -Unknown- - Difficulty: 0)
+(@CGUID+16, 82166, 1116, 7078, 7078, '0', 3290, 0, 0, 1, 1958.296875, 341.998260498046875, 88.78646087646484375, 3.66782999038696289, 7200, 0, 0, 2463, 0, 0, 0, 0, 0, 44232); -- Shelly Hamby (Area: -Unknown- - Difficulty: 0)
+
+DELETE FROM `creature_template_addon` WHERE `entry` IN (82166, 82167, 84455, 79422, 79394);
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(82166, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- 82166 (Shelly Hamby)
+(82167, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- 82167 (Jarrod Hamby)
+(84455, 0, 0, 0, 257, 0, 0, 0, 0, 0, ''), -- 84455 (Assistant Brightstone)
+(79422, 0, 0, 0, 1, 0, 0, 0, 0, 0, '42459'), -- 79422 (Lunarfall Guard) - Dual Wield
+(79394, 0, 0, 0, 1, 0, 0, 0, 0, 0, '42459'); -- 79394 (Lunarfall Guard) - Dual Wield
+
+UPDATE `creature_template` SET `gossip_menu_id`=16811 WHERE `entry`=84038; -- Lieutenant Thorn
+UPDATE `creature_template` SET `gossip_menu_id`=16613 WHERE `entry`=84455; -- Assistant Brightstone
+
+-- GameObjects
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+102;
+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
+-- GameObjects Conditional Visibility
+(@OGUID+0, 230335, 1116, 7078, 7078, '0', 4318, 0, 1930.486083984375, 249.0850677490234375, 76.75655364990234375, 1.36531686782836914, -0.18617200851440429, 0.032605171203613281, 0.633358001708984375, 0.750422894954681396, 7200, 255, 1, 44232), -- Tree Marking (Area: -Unknown- - Difficulty: 0)
+(@OGUID+1, 230335, 1116, 7078, 7078, '0', 4318, 0, 1864.8507080078125, 319.430572509765625, 82.83731842041015625, 3.763987064361572265, 0.097958087921142578, 0.161639213562011718, -0.92913722991943359, 0.317775070667266845, 7200, 255, 1, 44232), -- Tree Marking (Area: -Unknown- - Difficulty: 0)
+(@OGUID+2, 230335, 1116, 7078, 7078, '0', 4318, 0, 1892.3021240234375, 351.401031494140625, 88.80405426025390625, 2.81963658332824707, -0.16075658798217773, -0.09939956665039062, 0.972003936767578125, 0.139589950442314147, 7200, 255, 1, 44232), -- Tree Marking (Area: -Unknown- - Difficulty: 0)
+(@OGUID+3, 230335, 1116, 7078, 7078, '0', 4318, 0, 1899.404541015625, 241.12847900390625, 76.96894073486328125, 5.116973876953125, -0.0248112678527832, 0.187369346618652343, -0.52556896209716796, 0.829490423202514648, 7200, 255, 1, 44232), -- Tree Marking (Area: -Unknown- - Difficulty: 0)
+(@OGUID+4, 230335, 1116, 7078, 7078, '0', 4318, 0, 1801.310791015625, 306.802093505859375, 77.34531402587890625, 4.505525588989257812, 0.032734394073486328, 0.186148643493652343, -0.75086116790771484, 0.632838606834411621, 7200, 255, 1, 44232), -- Tree Marking (Area: -Unknown- - Difficulty: 0)
+(@OGUID+5, 230335, 1116, 7078, 7078, '0', 4318, 0, 1817.454833984375, 266.852447509765625, 77.5069122314453125, 4.838674545288085937, 0.001416683197021484, 0.189000129699707031, -0.63554000854492187, 0.748575866222381591, 7200, 255, 1, 44232), -- Tree Marking (Area: -Unknown- - Difficulty: 0)
+(@OGUID+6, 230335, 1116, 7078, 7078, '0', 4318, 0, 1777.3316650390625, 330.15277099609375, 76.640625, 2.480860710144042968, -0.17521286010742187, -0.07087612152099609, 0.934560775756835937, 0.301451802253723144, 7200, 255, 1, 44232), -- Tree Marking (Area: -Unknown- - Difficulty: 0)
+(@OGUID+7, 230335, 1116, 7078, 7078, '0', 4318, 0, 1787.7725830078125, 279.25347900390625, 77.38541412353515625, 0.126544937491416931, -0.13265895843505859, 0.134627342224121093, 0.08005523681640625, 0.978707432746887207, 7200, 255, 1, 44232), -- Tree Marking (Area: -Unknown- - Difficulty: 0)
+(@OGUID+8, 230335, 1116, 7078, 7078, '0', 4318, 0, 1898.0555419921875, 180.81597900390625, 79.02707672119140625, 2.785678863525390625, -0.16242122650146484, -0.09665584564208984, 0.969493865966796875, 0.15607251226902008, 7200, 255, 1, 44232), -- Tree Marking (Area: -Unknown- - Difficulty: 0)
+(@OGUID+9, 230335, 1116, 7078, 7078, '0', 4318, 0, 1801.8228759765625, 199.06597900390625, 70.08615875244140625, 4.436413764953613281, 0.039145946502685546, 0.184906959533691406, -0.77227687835693359, 0.606519103050231933, 7200, 255, 1, 44232), -- Tree Marking (Area: -Unknown- - Difficulty: 0)
+(@OGUID+10, 230335, 1116, 7078, 7078, '0', 4318, 0, 1752.8785400390625, 286.4913330078125, 77.3194427490234375, 4.838674545288085937, 0.001416683197021484, 0.189000129699707031, -0.63554000854492187, 0.748575866222381591, 7200, 255, 1, 44232), -- Tree Marking (Area: -Unknown- - Difficulty: 0)
+(@OGUID+11, 230335, 1116, 7078, 7078, '0', 4318, 0, 1851.1597900390625, 145.890625, 78.30060577392578125, 0.531421840190887451, -0.15701770782470703, 0.105206489562988281, 0.275197982788085937, 0.942625641822814941, 7200, 255, 1, 44232), -- Tree Marking (Area: -Unknown- - Difficulty: 0)
+(@OGUID+12, 230335, 1116, 7078, 7078, '0', 4318, 0, 1721.2379150390625, 221.3524322509765625, 73.236114501953125, 0.587434291839599609, -0.15990257263183593, 0.100768089294433593, 0.301486015319824218, 0.934549689292907714, 7200, 255, 1, 44232), -- Tree Marking (Area: -Unknown- - Difficulty: 0)
+(@OGUID+13, 230335, 1116, 7078, 7078, '0', 4318, 0, 1741.49658203125, 191.1996612548828125, 73.51926422119140625, 6.281199932098388671, -0.12373924255371093, 0.142868995666503906, 0.01703643798828125, 0.981828272342681884, 7200, 255, 1, 44232), -- Tree Marking (Area: -Unknown- - Difficulty: 0)
+(@OGUID+14, 230335, 1116, 7078, 7078, '0', 4318, 0, 1766.467041015625, 138.1145782470703125, 76.97916412353515625, 0.649101078510284423, -0.16293287277221679, 0.095790863037109375, 0.330153465270996093, 0.924811184406280517, 7200, 255, 1, 44232), -- Tree Marking (Area: -Unknown- - Difficulty: 0)
+(@OGUID+15, 230335, 1116, 7078, 7078, '0', 4318, 0, 1885.392333984375, 133.7447967529296875, 82.97396087646484375, 1.317053794860839843, -0.18533086776733398, 0.037087440490722656, 0.6150665283203125, 0.765486896038055419, 7200, 255, 1, 44232), -- Tree Marking (Area: -Unknown- - Difficulty: 0)
+(@OGUID+16, 230335, 1116, 7078, 7078, '0', 4318, 0, 1907.5677490234375, 155.0885467529296875, 82.68576812744140625, 1.163751959800720214, -0.1819467544555664, 0.05117034912109375, 0.554642677307128906, 0.810338497161865234, 7200, 255, 1, 44232), -- Tree Marking (Area: -Unknown- - Difficulty: 0)
+(@OGUID+17, 230335, 1116, 7078, 7078, '0', 4318, 0, 1926.048583984375, 172.170135498046875, 82.74741363525390625, 2.542114734649658203, -0.17296028137207031, -0.07620811462402343, 0.943353652954101562, 0.272692084312438964, 7200, 255, 1, 44232), -- Tree Marking (Area: -Unknown- - Difficulty: 0)
+(@OGUID+18, 230335, 1116, 7078, 7078, '0', 4318, 0, 1927.0035400390625, 110.4027786254882812, 83.5353851318359375, 1.249569058418273925, -0.18397426605224609, 0.043318748474121093, 0.588891983032226562, 0.7858009934425354, 7200, 255, 1, 44232), -- Tree Marking (Area: -Unknown- - Difficulty: 0)
+-- GameObject spawns for Phase 3290
+(@OGUID+19, 230368, 1116, 7078, 7078, '0', 3290, 0, 1926.0208740234375, 301.517364501953125, 89.996978759765625, 3.87960219383239746, 0, 0, -0.93268680572509765, 0.360687255859375, 7200, 255, 1, 44232), -- Lumber Pile 003 (Area: -Unknown- - Difficulty: 0)
+(@OGUID+20, 230370, 1116, 7078, 7078, '0', 3290, 0, 1875.1666259765625, 251.25347900390625, 78.30197906494140625, 2.341042041778564453, 0, 0, 0.920953750610351562, 0.389671921730041503, 7200, 255, 1, 44232), -- Stack of Logs (Area: -Unknown- - Difficulty: 0)
+(@OGUID+21, 230365, 1116, 7078, 7078, '0', 3290, 0, 1899.5572509765625, 238.7465362548828125, 77.284423828125, 2.829054832458496093, 0.012441635131835937, 0.018025398254394531, 0.987607002258300781, 0.155411377549171447, 7200, 255, 1, 44232), -- Lumber (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+22, 230368, 1116, 7078, 7078, '0', 3290, 0, 1876.4757080078125, 250.923614501953125, 78.39699554443359375, 2.341042041778564453, 0, 0, 0.920953750610351562, 0.389671921730041503, 7200, 255, 1, 44232), -- Lumber Pile 003 (Area: -Unknown- - Difficulty: 0)
+(@OGUID+23, 230370, 1116, 7078, 7078, '0', 3290, 0, 1829.357666015625, 261.263885498046875, 77.79972076416015625, 2.63785719871520996, 0, 0, 0.968448638916015625, 0.249213173985481262, 7200, 255, 1, 44232), -- Stack of Logs (Area: -Unknown- - Difficulty: 0)
+(@OGUID+24, 230370, 1116, 7078, 7078, '0', 3290, 0, 1911.0364990234375, 319.55902099609375, 89.39041900634765625, 2.76129913330078125, 0, 0, 0.981976509094238281, 0.189003005623817443, 7200, 255, 1, 44232), -- Stack of Logs (Area: -Unknown- - Difficulty: 0)
+(@OGUID+25, 230367, 1116, 7078, 7078, '0', 3290, 0, 1924.9757080078125, 303.71875, 90.0986785888671875, 1.86287391185760498, 0.358699321746826171, -0.33128166198730468, 0.682721138000488281, 0.543579936027526855, 7200, 255, 1, 44232), -- Log (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+26, 230366, 1116, 7078, 7078, '0', 3290, 0, 1824.907958984375, 260.19964599609375, 77.44791412353515625, 4.636101245880126953, 0, 0, -0.73355770111083984, 0.679627180099487304, 7200, 255, 1, 44232), -- Lumber 002 (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+27, 230368, 1116, 7078, 7078, '0', 3290, 0, 1912.02783203125, 320.71875, 89.44882965087890625, 2.76129913330078125, 0, 0, 0.981976509094238281, 0.189003005623817443, 7200, 255, 1, 44232), -- Lumber Pile 003 (Area: -Unknown- - Difficulty: 0)
+(@OGUID+28, 230367, 1116, 7078, 7078, '0', 3290, 0, 1908.69970703125, 316.795135498046875, 89.216522216796875, 2.95864272117614746, 0, 0, 0.995819091796875, 0.091347426176071166, 7200, 255, 1, 44232), -- Log (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+29, 230370, 1116, 7078, 7078, '0', 3290, 0, 1875.66845703125, 252.4809112548828125, 78.2335205078125, 2.341042041778564453, 0, 0, 0.920953750610351562, 0.389671921730041503, 7200, 255, 1, 44232), -- Stack of Logs (Area: -Unknown- - Difficulty: 0)
+(@OGUID+30, 230378, 1116, 7078, 7078, '0', 3290, 0, 1934, 299.779510498046875, 90.14701080322265625, 5.573947429656982421, 0.02759552001953125, -0.00713443756103515, -0.3471689224243164, 0.937369346618652343, 7200, 255, 1, 44232), -- Boot and Barrel (Area: -Unknown- - Difficulty: 0)
+(@OGUID+31, 230368, 1116, 7078, 7078, '0', 3290, 0, 1822.6163330078125, 263.357635498046875, 77.7026519775390625, 3.515362262725830078, 0, 0, -0.98258781433105468, 0.185798719525337219, 7200, 255, 1, 44232), -- Lumber Pile 003 (Area: -Unknown- - Difficulty: 0)
+(@OGUID+32, 230366, 1116, 7078, 7078, '0', 3290, 0, 1929.2864990234375, 299.385406494140625, 90.00125885009765625, 5.000339508056640625, 0, 0, -0.59833621978759765, 0.801245152950286865, 7200, 255, 1, 44232), -- Lumber 002 (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+33, 230370, 1116, 7078, 7078, '0', 3290, 0, 1925.6492919921875, 300.22222900390625, 89.906768798828125, 3.87960219383239746, 0, 0, -0.93268680572509765, 0.360687255859375, 7200, 255, 1, 44232), -- Stack of Logs (Area: -Unknown- - Difficulty: 0)
+(@OGUID+34, 230366, 1116, 7078, 7078, '0', 3290, 0, 1907.173583984375, 323.411468505859375, 89.05828094482421875, 3.882046699523925781, 0, 0, -0.93224525451660156, 0.361827045679092407, 7200, 255, 1, 44232), -- Lumber 002 (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+35, 230366, 1116, 7078, 7078, '0', 3290, 0, 1874.4461669921875, 247.5902862548828125, 78.1563262939453125, 3.461794376373291015, 0, 0, -0.98721122741699218, 0.159417659044265747, 7200, 255, 1, 44232), -- Lumber 002 (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+36, 230366, 1116, 7078, 7078, '0', 3290, 0, 1920.4254150390625, 300.666656494140625, 89.665283203125, 4.526621341705322265, 0.015198230743408203, -0.02588176727294921, -0.76920509338378906, 0.638296663761138916, 7200, 255, 1, 44232), -- Lumber 002 (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+37, 230367, 1116, 7078, 7078, '0', 3290, 0, 1933.0416259765625, 302.33160400390625, 89.97173309326171875, 4.076953887939453125, 0, 0, -0.89261627197265625, 0.450817227363586425, 7200, 255, 1, 44232), -- Log (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+38, 230367, 1116, 7078, 7078, '0', 3290, 0, 1912.3663330078125, 317.31597900390625, 89.72934722900390625, 1.832227587699890136, 0.353580474853515625, -0.33673954010009765, 0.674311637878417968, 0.553977549076080322, 7200, 255, 1, 44232), -- Log (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+39, 230365, 1116, 7078, 7078, '0', 3290, 0, 1899.8802490234375, 240.048614501953125, 77.243988037109375, 0.936071038246154785, 0.021897792816162109, 0.000441551208496093, 0.451192855834960937, 0.892157673835754394, 7200, 255, 1, 44232), -- Lumber (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+40, 230369, 1116, 7078, 7078, '0', 3290, 0, 1939.5347900390625, 314.282989501953125, 89.13115692138671875, 5.455011367797851562, 0, 0, -0.40235424041748046, 0.915484070777893066, 7200, 255, 1, 44232), -- Lumbermill Work Bench (Area: -Unknown- - Difficulty: 0)
+(@OGUID+41, 230370, 1116, 7078, 7078, '0', 3290, 0, 1947.935791015625, 314.45660400390625, 89.475128173828125, 4.377310752868652343, 0, 0, -0.81512069702148437, 0.579291164875030517, 7200, 255, 1, 44232), -- Stack of Logs (Area: -Unknown- - Difficulty: 0)
+(@OGUID+42, 230368, 1116, 7078, 7078, '0', 3290, 0, 1947.41845703125, 315.90277099609375, 89.28006744384765625, 4.377310752868652343, 0, 0, -0.81512069702148437, 0.579291164875030517, 7200, 255, 1, 44232), -- Lumber Pile 003 (Area: -Unknown- - Difficulty: 0)
+(@OGUID+43, 230366, 1116, 7078, 7078, '0', 3290, 0, 1951.7552490234375, 315.361114501953125, 89.620391845703125, 5.498048782348632812, 0, 0, -0.38256263732910156, 0.923929572105407714, 7200, 255, 1, 44232), -- Lumber 002 (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+44, 230369, 1116, 7078, 7078, '0', 3290, 0, 1910.8316650390625, 323.439239501953125, 89.2888641357421875, 3.839010953903198242, 0, 0, -0.93981456756591796, 0.341684907674789428, 7200, 255, 1, 44232), -- Lumbermill Work Bench (Area: -Unknown- - Difficulty: 0)
+(@OGUID+45, 230366, 1116, 7078, 7078, '0', 3290, 0, 1943.1666259765625, 312.338531494140625, 89.46453857421875, 5.024329185485839843, 0.021104812622070312, -0.02134132385253906, -0.58830165863037109, 0.808084309101104736, 7200, 255, 1, 44232), -- Lumber 002 (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+46, 230366, 1116, 7078, 7078, '0', 3290, 0, 1902.595458984375, 329.5069580078125, 88.2289886474609375, 4.529582977294921875, 0.015236377716064453, -0.02585983276367187, -0.76825904846191406, 0.639435052871704101, 7200, 255, 1, 44232), -- Lumber 002 (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+47, 230378, 1116, 7078, 7078, '0', 3290, 0, 1942.3316650390625, 316.013885498046875, 89.0526885986328125, 3.887947559356689453, 0.013030052185058593, -0.02534961700439453, -0.93082523345947265, 0.364351481199264526, 7200, 255, 1, 44232), -- Boot and Barrel (Area: -Unknown- - Difficulty: 0)
+(@OGUID+48, 230367, 1116, 7078, 7078, '0', 3290, 0, 1856.7135009765625, 322.5850830078125, 82.676422119140625, 6.011871337890625, -0.11700391769409179, -0.47404861450195312, -0.14653873443603515, 0.860298991203308105, 7200, 255, 1, 44232), -- Log (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+49, 230367, 1116, 7078, 7078, '0', 3290, 0, 1945.79345703125, 317.8663330078125, 89.04793548583984375, 2.360580921173095703, 0.429242134094238281, -0.23273086547851562, 0.79557037353515625, 0.358685523271560668, 7200, 255, 1, 44232), -- Log (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+50, 230366, 1116, 7078, 7078, '0', 3290, 0, 1838.1319580078125, 155.7725677490234375, 77.54938507080078125, 3.414845466613769531, -0.0007481575012207, -0.03000545501708984, -0.99021530151367187, 0.136282086372375488, 7200, 255, 1, 44232), -- Lumber 002 (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+51, 230366, 1116, 7078, 7078, '0', 3290, 0, 1798.9757080078125, 178.8177032470703125, 70.3819427490234375, 5.540373802185058593, 0.025851726531982421, -0.01524925231933593, -0.36262893676757812, 0.931450128555297851, 7200, 255, 1, 44232), -- Lumber 002 (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+52, 230367, 1116, 7078, 7078, '0', 3290, 0, 1813.920166015625, 178.392364501953125, 70.84654998779296875, 3.969456672668457031, 0, 0, -0.91554641723632812, 0.402212321758270263, 7200, 255, 1, 44232), -- Log (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+53, 230368, 1116, 7078, 7078, '0', 3290, 0, 1811.4271240234375, 182.1510467529296875, 70.89409637451171875, 3.772105216979980468, 0, 0, -0.95071697235107421, 0.310060024261474609, 7200, 255, 1, 44232), -- Lumber Pile 003 (Area: -Unknown- - Difficulty: 0)
+(@OGUID+54, 230370, 1116, 7078, 7078, '0', 3290, 0, 1804.8524169921875, 195.0729217529296875, 70.2745819091796875, 3.772105216979980468, 0, 0, -0.95071697235107421, 0.310060024261474609, 7200, 255, 1, 44232), -- Stack of Logs (Area: -Unknown- - Difficulty: 0)
+(@OGUID+55, 230367, 1116, 7078, 7078, '0', 3290, 0, 1803.939208984375, 181.89410400390625, 71.0693206787109375, 2.843007802963256835, 0.47241067886352539, -0.12345314025878906, 0.858221054077148437, 0.158253222703933715, 7200, 255, 1, 44232), -- Log (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+56, 230366, 1116, 7078, 7078, '0', 3290, 0, 1806.5711669921875, 179.4600677490234375, 70.73957061767578125, 4.892839908599853515, 0, 0, -0.6405181884765625, 0.767943024635314941, 7200, 255, 1, 44232), -- Lumber 002 (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+57, 230369, 1116, 7078, 7078, '0', 3290, 0, 1795.0694580078125, 182.3819427490234375, 70.64270782470703125, 3.749436140060424804, 0, 0, -0.95417022705078125, 0.299264430999755859, 7200, 255, 1, 44232), -- Lumbermill Work Bench (Area: -Unknown- - Difficulty: 0)
+(@OGUID+58, 230366, 1116, 7078, 7078, '0', 3290, 0, 1780.8316650390625, 292.260406494140625, 77.1877593994140625, 2.652019739151000976, 0, 0, 0.970189094543457031, 0.242349132895469665, 7200, 255, 1, 44232), -- Lumber 002 (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+59, 230370, 1116, 7078, 7078, '0', 3290, 0, 1785.2135009765625, 294.751739501953125, 77.375, 1.531280994415283203, 0, 0, 0.692998886108398437, 0.720938622951507568, 7200, 255, 1, 44232), -- Stack of Logs (Area: -Unknown- - Difficulty: 0)
+(@OGUID+60, 230370, 1116, 7078, 7078, '0', 3290, 0, 1783.9774169921875, 294.26910400390625, 77.35584259033203125, 1.531280994415283203, 0, 0, 0.692998886108398437, 0.720938622951507568, 7200, 255, 1, 44232), -- Stack of Logs (Area: -Unknown- - Difficulty: 0)
+(@OGUID+61, 230368, 1116, 7078, 7078, '0', 3290, 0, 1784.642333984375, 293.088531494140625, 77.353057861328125, 1.531280994415283203, 0, 0, 0.692998886108398437, 0.720938622951507568, 7200, 255, 1, 44232), -- Lumber Pile 003 (Area: -Unknown- - Difficulty: 0)
+(@OGUID+62, 230370, 1116, 7078, 7078, '0', 3290, 0, 1858.439208984375, 331.375, 82.42960357666015625, 0.657765030860900878, 0, 0, 0.322985649108886718, 0.946403861045837402, 7200, 255, 1, 44232), -- Stack of Logs (Area: -Unknown- - Difficulty: 0)
+(@OGUID+63, 230368, 1116, 7078, 7078, '0', 3290, 0, 1864.5625, 330.951385498046875, 82.988037109375, 0.657765030860900878, 0, 0, 0.322985649108886718, 0.946403861045837402, 7200, 255, 1, 44232), -- Lumber Pile 003 (Area: -Unknown- - Difficulty: 0)
+(@OGUID+64, 230366, 1116, 7078, 7078, '0', 3290, 0, 1872.75, 340.133697509765625, 82.17333984375, 2.994805812835693359, 0.006986618041992187, 0.0291900634765625, 0.996869087219238281, 0.07315179705619812, 7200, 255, 1, 44232), -- Lumber 002 (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+65, 230365, 1116, 7078, 7078, '0', 3290, 0, 1857.5867919921875, 333.142364501953125, 82.30881500244140625, 2.829054832458496093, 0.012441635131835937, 0.018025398254394531, 0.987607002258300781, 0.155411377549171447, 7200, 255, 1, 44232), -- Lumber (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+66, 230366, 1116, 7078, 7078, '0', 3290, 0, 1863.0711669921875, 333.836822509765625, 82.6255340576171875, 1.778501272201538085, 0, 0, 0.776599884033203125, 0.629994153976440429, 7200, 255, 1, 44232), -- Lumber 002 (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+67, 230367, 1116, 7078, 7078, '0', 3290, 0, 1854.392333984375, 334.979156494140625, 82.18959808349609375, 0.855118274688720703, 0, 0, 0.414650917053222656, 0.909980535507202148, 7200, 255, 1, 44232), -- Log (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+68, 230365, 1116, 7078, 7078, '0', 3290, 0, 1865.46875, 331.529510498046875, 82.99362945556640625, 0.936071038246154785, 0.021897792816162109, 0.000441551208496093, 0.451192855834960937, 0.892157673835754394, 7200, 255, 1, 44232), -- Lumber (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+69, 230369, 1116, 7078, 7078, '0', 3290, 0, 1868.876708984375, 333.142364501953125, 83.02490997314453125, 1.735465764999389648, 0, 0, 0.762865066528320312, 0.64655768871307373, 7200, 255, 1, 44232), -- Lumbermill Work Bench (Area: -Unknown- - Difficulty: 0)
+(@OGUID+70, 230335, 1116, 7078, 7078, '0', 3290, 0, 1760.1822509765625, 317.67535400390625, 75.81597137451171875, 4.838674545288085937, 0.001416683197021484, 0.189000129699707031, -0.63554000854492187, 0.748575866222381591, 7200, 255, 1, 44232), -- Tree Marking (Area: -Unknown- - Difficulty: 0)
+(@OGUID+71, 230366, 1116, 7078, 7078, '0', 3290, 0, 1916.1146240234375, 359.732635498046875, 89.1385955810546875, 2.366792917251586914, 0.015661239624023437, 0.025604248046875, 0.925531387329101562, 0.37747955322265625, 7200, 255, 1, 44232), -- Lumber 002 (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+72, 230367, 1116, 7078, 7078, '0', 3290, 0, 1921.0833740234375, 358.369781494140625, 89.25217437744140625, 0.98418360948562622, 0.321428775787353515, -0.42917156219482421, 0.442739486694335937, 0.718663394451141357, 7200, 255, 1, 44232), -- Log (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+73, 230367, 1116, 7078, 7078, '0', 3290, 0, 1952.5052490234375, 320.130218505859375, 89.215118408203125, 4.574664115905761718, 0, 0, -0.75408554077148437, 0.656776189804077148, 7200, 255, 1, 44232), -- Log (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+74, 230366, 1116, 7078, 7078, '0', 3290, 0, 1913.2257080078125, 362.02777099609375, 89.3173675537109375, 5.322003364562988281, 0.014392375946044921, 0.008486747741699218, -0.46234989166259765, 0.886540114879608154, 7200, 255, 1, 44232), -- Lumber 002 (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+75, 230365, 1116, 7078, 7078, '0', 3290, 0, 1945.8507080078125, 356.376739501953125, 88.89362335205078125, 0.950502693653106689, 0.021894454956054687, 0.000598907470703125, 0.45761871337890625, 0.88887876272201538, 7200, 255, 1, 44232), -- Lumber (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+76, 230369, 1116, 7078, 7078, '0', 3290, 0, 1934.6024169921875, 367.236114501953125, 88.90602874755859375, 0.984923303127288818, 0, 0, 0.472796440124511718, 0.881171643733978271, 7200, 255, 1, 44232), -- Lumbermill Work Bench (Area: -Unknown- - Difficulty: 0)
+(@OGUID+77, 230370, 1116, 7078, 7078, '0', 3290, 0, 1952.7899169921875, 340.380218505859375, 88.66776275634765625, 5.891911983489990234, 0, 0, -0.19439125061035156, 0.980924069881439208, 7200, 255, 1, 44232), -- Stack of Logs (Area: -Unknown- - Difficulty: 0)
+(@OGUID+78, 230366, 1116, 7078, 7078, '0', 3290, 0, 1938.859375, 358.642364501953125, 88.859375, 6.091081619262695312, 0, 0, -0.09590435028076171, 0.995390534400939941, 7200, 255, 1, 44232), -- Lumber 002 (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+79, 230374, 1116, 7078, 7078, '0', 3290, 0, 1957.4254150390625, 334.461822509765625, 88.89492034912109375, 4.636805534362792968, 0, 0, -0.73331832885742187, 0.679885447025299072, 7200, 255, 1, 44232), -- Sleeping Cot (Area: -Unknown- - Difficulty: 0)
+(@OGUID+80, 230377, 1116, 7078, 7078, '0', 3290, 0, 1934.6441650390625, 365.57464599609375, 88.857513427734375, 4.166170120239257812, -0.04129934310913085, 0.002737045288085937, -0.8712625503540039, 0.489068955183029174, 7200, 255, 1, 44232), -- Tool Box (Area: -Unknown- - Difficulty: 0)
+(@OGUID+81, 230376, 1116, 7078, 7078, '0', 3290, 0, 1949.545166015625, 343.274322509765625, 88.5760040283203125, 4.386662006378173828, -0.31528091430664062, 0.512528419494628906, -0.62960243225097656, 0.491440087556838989, 7200, 255, 1, 44232), -- Back Pack (Area: -Unknown- - Difficulty: 0)
+(@OGUID+82, 230365, 1116, 7078, 7078, '0', 3290, 0, 1938.8316650390625, 362.779510498046875, 88.93314361572265625, 3.145559072494506835, -0.00944995880126953, -0.01975822448730468, -0.99975776672363281, 0.002169969258829951, 7200, 255, 1, 44232), -- Lumber (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+83, 230367, 1116, 7078, 7078, '0', 3290, 0, 1943.71533203125, 356.810760498046875, 90.6258087158203125, 5.751479148864746093, 0.290145397186279296, 0.054755210876464843, -0.28547954559326171, 0.91176694631576538, 7200, 255, 1, 44232), -- Log (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+84, 230365, 1116, 7078, 7078, '0', 3290, 0, 1938.99658203125, 366.060760498046875, 88.965850830078125, 6.258157730102539062, 0.019621849060058593, -0.00973033905029296, -0.01232337951660156, 0.999684154987335205, 7200, 255, 1, 44232), -- Lumber (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+85, 230370, 1116, 7078, 7078, '0', 3290, 0, 1933.248291015625, 369.947906494140625, 88.9416046142578125, 6.190409183502197265, 0, 0, -0.0463714599609375, 0.99892425537109375, 7200, 255, 1, 44232), -- Stack of Logs (Area: -Unknown- - Difficulty: 0)
+(@OGUID+86, 230366, 1116, 7078, 7078, '0', 3290, 0, 1962.046875, 323.899322509765625, 89.1211090087890625, 0.026276791468262672, 0.02968454360961914, -0.00443744659423828, 0.013275146484375, 0.999461293220520019, 7200, 255, 1, 44232), -- Lumber 002 (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+87, 230368, 1116, 7078, 7078, '0', 3290, 0, 1932.62158203125, 368.557281494140625, 88.8914031982421875, 6.190409183502197265, 0, 0, -0.0463714599609375, 0.99892425537109375, 7200, 255, 1, 44232), -- Lumber Pile 003 (Area: -Unknown- - Difficulty: 0)
+(@OGUID+88, 230366, 1116, 7078, 7078, '0', 3290, 0, 1965.4461669921875, 333.59375, 88.9591217041015625, 5.182993888854980468, 0.022729396820068359, -0.01960182189941406, -0.52241134643554687, 0.85216522216796875, 7200, 255, 1, 44232), -- Lumber 002 (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+89, 230367, 1116, 7078, 7078, '0', 3290, 0, 1948.8680419921875, 359.572906494140625, 89.7602386474609375, 5.508502006530761718, -0.35027933120727539, -0.34295558929443359, -0.42072105407714843, 0.763334572315216064, 7200, 255, 1, 44232), -- Log (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+90, 230367, 1116, 7078, 7078, '0', 3290, 0, 1946.9132080078125, 360.243072509765625, 89.26744842529296875, 0.104574158787727355, 0, 0, 0.052263259887695312, 0.998633325099945068, 7200, 255, 1, 44232), -- Log (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+91, 230377, 1116, 7078, 7078, '0', 3290, 0, 1960.43408203125, 334.5625, 88.91080474853515625, 4.065842151641845703, 0.015230178833007812, -0.02409172058105468, -0.89478015899658203, 0.445596367120742797, 7200, 255, 1, 44232), -- Tool Box (Area: -Unknown- - Difficulty: 0)
+(@OGUID+92, 230377, 1116, 7078, 7078, '0', 3290, 0, 1958.0416259765625, 351.0538330078125, 88.95074462890625, 1.282548904418945312, 0.002597808837890625, -0.04130744934082031, 0.597075462341308593, 0.801116585731506347, 7200, 255, 1, 44232), -- Tool Box (Area: -Unknown- - Difficulty: 0)
+(@OGUID+93, 230370, 1116, 7078, 7078, '0', 3290, 0, 1960.388916015625, 332.817718505859375, 88.9469146728515625, 3.316406488418579101, 0, 0, -0.99618244171142578, 0.08729555457830429, 7200, 255, 1, 44232), -- Stack of Logs (Area: -Unknown- - Difficulty: 0)
+(@OGUID+94, 230369, 1116, 7078, 7078, '0', 3290, 0, 1961.6180419921875, 350.24652099609375, 88.9602508544921875, 2.116451263427734375, 0, 0, 0.871486663818359375, 0.490419209003448486, 7200, 255, 1, 44232), -- Lumbermill Work Bench (Area: -Unknown- - Difficulty: 0)
+(@OGUID+95, 230367, 1116, 7078, 7078, '0', 3290, 0, 1956.548583984375, 350.314239501953125, 88.92618560791015625, 4.244813919067382812, -0.4230208396911621, -0.25234317779541015, -0.74319744110107421, 0.452806681394577026, 7200, 255, 1, 44232), -- Log (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+96, 230366, 1116, 7078, 7078, '0', 3290, 0, 1972.0711669921875, 326.291656494140625, 89.501739501953125, 5.841443061828613281, 0.027846336364746093, -0.011199951171875, -0.218841552734375, 0.975298702716827392, 7200, 255, 1, 44232), -- Lumber 002 (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+97, 230366, 1116, 7078, 7078, '0', 3290, 0, 1974.2274169921875, 331.680572509765625, 89.09647369384765625, 5.769165992736816406, 0.027423381805419921, -0.01219940185546875, -0.253936767578125, 0.966755032539367675, 7200, 255, 1, 44232), -- Lumber 002 (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+98, 230366, 1116, 7078, 7078, '0', 3290, 0, 1969.1302490234375, 347.15277099609375, 88.964996337890625, 3.694168567657470703, 0.003435611724853515, -0.0298166275024414, -0.96160221099853515, 0.272801011800765991, 7200, 255, 1, 44232), -- Lumber 002 (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+99, 230366, 1116, 7078, 7078, '0', 3290, 0, 1966.689208984375, 351.078125, 88.96527862548828125, 3.694168567657470703, 0.003435611724853515, -0.0298166275024414, -0.96160221099853515, 0.272801011800765991, 7200, 255, 1, 44232), -- Lumber 002 (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+100, 230366, 1116, 7078, 7078, '0', 3290, 0, 1977.109375, 330.5069580078125, 89.21875, 2.799148321151733398, 0.009804725646972656, 0.028367996215820312, 0.984957695007324218, 0.170168995857238769, 7200, 255, 1, 44232), -- Lumber 002 (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+101, 230366, 1116, 7078, 7078, '0', 3290, 0, 1975.57470703125, 326.145843505859375, 89.48784637451171875, 2.799148321151733398, 0.009804725646972656, 0.028367996215820312, 0.984957695007324218, 0.170168995857238769, 7200, 255, 1, 44232), -- Lumber 002 (Flavor) (Area: -Unknown- - Difficulty: 0)
+(@OGUID+102, 230366, 1116, 7078, 7078, '0', 3290, 0, 1966.171875, 357.8819580078125, 88.965850830078125, 5.816088199615478515, 0.02770233154296875, -0.01155281066894531, -0.23118782043457031, 0.972446024417877197, 7200, 255, 1, 44232); -- Lumber 002 (Flavor) (Area: -Unknown- - Difficulty: 0)
+
+-- Phase
+DELETE FROM `phase_area` WHERE (`AreaId` = 7078 AND `PhaseId` = 3290);
+INSERT INTO `phase_area` (`AreaId`, `PhaseId`, `Comment`) VALUES
+(7078, 3290, 'Cosmetic - Lumberjacks Carry Wood');
+
+-- Conditions
+DELETE FROM `conditions` WHERE (`SourceTypeOrReferenceId` = 32 AND `SourceGroup` = 8 AND `SourceEntry` = 79470) OR (`SourceTypeOrReferenceId` = 26 AND `SourceGroup` = 3290 AND `SourceEntry` = 7078);
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `Comment`) VALUES
+(32, 8, 79470, 0, 0, 9, 0, 34584, 0, 0, 0, 'Tree Marking gets visible if Quest: 34584 is taken'),
+(32, 8, 79470, 0, 1, 47, 0, 34584, 66, 0, 0, 'OR: Tree Marking gets visible if Quest: 34584 is complete/rewarded'),
+(26, 3290, 7078, 0, 0, 47, 0, 34584, 66, 0, 0, 'Apply Phase 3290 if Quest: 34584 is complete/rewarded'),
+(26, 3290, 7078, 0, 0, 47, 0, 34586, 66, 0, 1, 'Apply Phase 3290 if Quest: 34586 IS NOT complete/rewarded');
+
+-- SAI Script for Lumberjacks
+UPDATE `creature_template` SET `AIName` = 'SmartAI', `ScriptName` = '' WHERE `entry` = 79255;
+
+DELETE FROM `smart_scripts` WHERE `source_type` IN (0, 9) AND `entryOrGuid` IN (-(@CGUID+1), -(@CGUID+10), 7925500, 7925501);
+INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
+(-(@CGUID+1), 0, 0, 0, 34, 0, 100, 0, 2, 10, 0, 0, 80, 7925500, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'OnMovementInform PathID 10 - run Actionlist - to self'),
+(-(@CGUID+1), 0, 1, 0, 34, 0, 100, 0, 2, 23, 0, 0, 80, 7925501, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'OnMovementInform PathID 23 - run Actionlist - to self'),
+(-(@CGUID+10), 0, 0, 0, 34, 0, 100, 0, 2, 6, 0, 0, 80, 7925500, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'OnMovementInform PathID 6 - run Actionlist - to self'),
+(-(@CGUID+10), 0, 1, 0, 34, 0, 100, 0, 2, 12, 0, 0, 80, 7925501, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'OnMovementInform PathID 12 - run Actionlist - to self'),
+-- ActionList
+(7925500, 9, 0, 0, 0, 0, 100, 0, 5000, 5000, 5000, 5000, 11, 158568, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 5s - cast Spell "Garrison Lumberjack Test - Carrying Lumber" - to self'),
+(7925501, 9, 0, 0, 0, 0, 100, 0, 5000, 5000, 5000, 5000, 28, 158568, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'After 5s - Remove Spell "Garrison Lumberjack Test - Carrying Lumber" - to self');
+
+-- Waypoints for CGUID+12
+SET @PATH := @CGUID+12 * 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, 1953.023, 331.2465, 89.05704, NULL, 0),
+(@PATH, 1, 1954.62, 336.2726, 88.79828, NULL, 0),
+(@PATH, 2, 1958.016, 337.3142, 88.94769, NULL, 0),
+(@PATH, 3, 1961.424, 336.5625, 88.96356, NULL, 5163),
+(@PATH, 4, 1954.62, 336.2726, 88.79828, NULL, 0),
+(@PATH, 5, 1953.023, 331.2465, 89.05704, NULL, 0),
+(@PATH, 6, 1947.981, 330.5469, 89.05704, NULL, 0),
+(@PATH, 7, 1944.531, 333.4375, 89.08856, NULL, 0),
+(@PATH, 8, 1942.068, 338.257, 88.96356, NULL, 0),
+(@PATH, 9, 1939.266, 343.1354, 88.96356, NULL, 0),
+(@PATH, 10, 1936.625, 344.8854, 89.00604, NULL, 0),
+(@PATH, 11, 1934.464, 344.1076, 88.93134, NULL, 0),
+(@PATH, 12, 1931.472, 342.375, 88.97594, NULL, 0),
+(@PATH, 13, 1931.731, 338.3455, 88.97594, NULL, 0),
+(@PATH, 14, 1934.679, 338.151, 89.08856, NULL, 3390),
+(@PATH, 15, 1931.472, 342.375, 88.97594, NULL, 0),
+(@PATH, 16, 1934.464, 344.1076, 88.93134, NULL, 0),
+(@PATH, 17, 1936.625, 344.8854, 89.00604, NULL, 0),
+(@PATH, 18, 1939.266, 343.1354, 88.96356, NULL, 0),
+(@PATH, 19, 1942.068, 338.257, 88.96356, NULL, 0),
+(@PATH, 20, 1944.531, 333.4375, 89.08856, NULL, 0),
+(@PATH, 21, 1947.981, 330.5469, 89.05704, NULL, 0);
+
+UPDATE `creature` SET `position_x`= 1953.023, `position_y`= 331.2465, `position_z`= 89.05704, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+12;
+DELETE FROM `creature_addon` WHERE `guid`= @CGUID+12;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES
+(@CGUID+12, @PATH, 1);
+
+-- Waypoints for CGUID+3
+SET @PATH := @CGUID+3 * 10;
+DELETE FROM `waypoint_data` WHERE `id`= @PATH;
+INSERT INTO `waypoint_data` (`id`, `point`, `position_x`, `position_y`, `position_z`, `orientation`, `delay`, `move_type`) VALUES
+(@PATH, 0, 1941.198, 342.4496, 89.05719, NULL, 0, 2),
+(@PATH, 1, 1942.649, 338.6615, 88.96356, NULL, 0, 2),
+(@PATH, 2, 1954.566, 337.1024, 88.55939, NULL, 0, 2),
+(@PATH, 3, 1960.387, 340.1615, 88.83856, NULL, 0, 2),
+(@PATH, 7, 1962.74, 338.2882, 88.96356, NULL, 0, 2),
+(@PATH, 8, 1954.519, 334.1337, 89.05511, NULL, 0, 2),
+(@PATH, 9, 1946.181, 336.1649, 88.96356, NULL, 0, 2),
+(@PATH, 10, 1938.948, 331.4757, 89.05704, NULL, 0, 2),
+(@PATH, 11, 1945.634, 334.5868, 88.92499, NULL, 0, 2),
+(@PATH, 12, 1950.191, 332.9496, 89.05704, NULL, 0, 2),
+(@PATH, 13, 1960.155, 337.8038, 88.89545, NULL, 0, 2),
+(@PATH, 14, 1958.594, 340.9826, 88.83856, NULL, 4262, 2),
+(@PATH, 15, 1950.191, 332.9496, 89.05704, NULL, 0, 2),
+(@PATH, 16, 1938.219, 335.0573, 89.08856, NULL, 0, 2),
+(@PATH, 17, 1938.948, 331.4757, 89.05704, NULL, 0, 2),
+(@PATH, 18, 1946.181, 336.1649, 88.96356, NULL, 0, 2),
+(@PATH, 19, 1954.519, 334.1337, 89.05511, NULL, 0, 2),
+(@PATH, 20, 1962.74, 338.2882, 88.96356, NULL, 0, 2),
+(@PATH, 21, 1960.387, 340.1615, 88.83856, NULL, 0, 2),
+(@PATH, 22, 1954.566, 337.1024, 88.55939, NULL, 0, 2),
+(@PATH, 23, 1942.649, 338.6615, 88.96356, NULL, 0, 2),
+(@PATH, 27, 1936.321, 336.5365, 89.08856, NULL, 0, 2),
+(@PATH, 28, 1931.297, 340.1736, 88.97594, NULL, 0, 2),
+(@PATH, 29, 1924.941, 331.5625, 89.27406, NULL, 0, 2),
+(@PATH, 30, 1932.078, 327.3698, 89.08717, NULL, 0, 2),
+(@PATH, 31, 1929.429, 323.9288, 89.53004, NULL, 0, 2),
+(@PATH, 32, 1924.661, 318.2986, 89.85219, NULL, 0, 2),
+(@PATH, 33, 1914.972, 300.9549, 89.49904, NULL, 0, 2),
+(@PATH, 34, 1928.182, 293.1771, 90.0375, NULL, 0, 2),
+(@PATH, 35, 1935.026, 294.7309, 90.4574, NULL, 0, 2),
+(@PATH, 36, 1938.953, 300.6493, 90.43204, NULL, 0, 2),
+(@PATH, 37, 1938.194, 310.7891, 89.55704, NULL, 0, 2),
+(@PATH, 38, 1938.229, 320.5208, 89.05704, NULL, 0, 2),
+(@PATH, 39, 1939.361, 328.8264, 89.05704, NULL, 0, 2),
+(@PATH, 40, 1943.259, 337.2066, 89.08502, NULL, 0, 2),
+(@PATH, 41, 1934.286, 337.6146, 89.08856, NULL, 0, 2),
+(@PATH, 42, 1937.403, 330.6215, 89.05704, NULL, 0, 2),
+(@PATH, 43, 1943.177, 329.1563, 89.05704, NULL, 4268, 2),
+(@PATH, 44, 1934.286, 337.6146, 89.08856, NULL, 0, 2),
+(@PATH, 45, 1943.259, 337.2066, 89.08502, NULL, 0, 2),
+(@PATH, 46, 1939.361, 328.8264, 89.05704, NULL, 0, 2),
+(@PATH, 47, 1938.229, 320.5208, 89.05704, NULL, 0, 2),
+(@PATH, 48, 1938.149, 310.8802, 89.56387, NULL, 0, 2),
+(@PATH, 49, 1938.953, 300.6493, 90.43204, NULL, 0, 2),
+(@PATH, 50, 1935.026, 294.7309, 90.4574, NULL, 0, 2),
+(@PATH, 51, 1919.276, 296.5538, 89.69277, NULL, 0, 2),
+(@PATH, 52, 1914.972, 300.9549, 89.49904, NULL, 0, 2),
+(@PATH, 53, 1924.661, 318.2986, 89.85219, NULL, 0, 2),
+(@PATH, 54, 1929.429, 323.9288, 89.53004, NULL, 0, 2),
+(@PATH, 55, 1932.078, 327.3698, 89.08717, NULL, 0, 2),
+(@PATH, 56, 1924.941, 331.5625, 89.27406, NULL, 0, 2),
+(@PATH, 57, 1931.297, 340.1736, 88.97594, NULL, 0, 2),
+(@PATH, 58, 1941.198, 342.4496, 89.05719, NULL, 0, 2);
+
+UPDATE `creature` SET `position_x`= 1941.198, `position_y`= 342.4496, `position_z`= 89.05719, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+3;
+DELETE FROM `creature_addon` WHERE `guid`= @CGUID+3;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES
+(@CGUID+3, @PATH, 1);
+
+-- Waypoints for CGUID+1
+SET @PATH := @CGUID+1 * 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, 1862.698, 285.9358, 78.12917, NULL, 0),
+(@PATH, 1, 1863.349, 296.8351, 81.06313, NULL, 0),
+(@PATH, 2, 1873.004, 309.1493, 82.48876, NULL, 0),
+(@PATH, 3, 1881.361, 319.3542, 82.74157, NULL, 0),
+(@PATH, 4, 1889.089, 327.7639, 84.58544, NULL, 0),
+(@PATH, 5, 1894.962, 335.8507, 86.31083, NULL, 0),
+(@PATH, 6, 1900.939, 337.7587, 87.52624, NULL, 0),
+(@PATH, 7, 1913.807, 331.809, 89.12404, NULL, 0),
+(@PATH, 8, 1918.373, 326.8837, 89.6028, NULL, 0),
+(@PATH, 9, 1927.601, 319.4531, 89.72719, NULL, 0),
+(@PATH, 10, 1939.073, 315.9609, 89.05704, NULL, 5501),
+(@PATH, 11, 1931.804, 316.2118, 89.48732, NULL, 0),
+(@PATH, 12, 1915.368, 330.8203, 89.24904, NULL, 0),
+(@PATH, 13, 1911.479, 335.967, 88.53747, NULL, 0),
+(@PATH, 14, 1898.722, 341.408, 87.27677, NULL, 0),
+(@PATH, 15, 1893.321, 337.7813, 85.90922, NULL, 0),
+(@PATH, 16, 1881.453, 323.1198, 82.83947, NULL, 0),
+(@PATH, 17, 1872.29, 311.8507, 82.40307, NULL, 0),
+(@PATH, 18, 1863.672, 291.1111, 79.53164, NULL, 0),
+(@PATH, 19, 1863.524, 282.8889, 77.35012, NULL, 0),
+(@PATH, 20, 1867.391, 275.7917, 77.41521, NULL, 0),
+(@PATH, 21, 1876.972, 261.8785, 78.07084, NULL, 0),
+(@PATH, 22, 1879.71, 254.3229, 78.23966, NULL, 0),
+(@PATH, 23, 1877.451, 253.0903, 78.26261, NULL, 5135),
+(@PATH, 24, 1871.495, 265.4028, 78.07084, NULL, 0),
+(@PATH, 25, 1865.844, 275.9132, 77.54372, NULL, 0);
+
+UPDATE `creature` SET `position_x`= 1862.698, `position_y`= 285.9358, `position_z`= 78.12917, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+1;
+DELETE FROM `creature_addon` WHERE `guid`= @CGUID+1;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES
+(@CGUID+1, @PATH, 1);
+
+-- Waypoints for CGUID+10
+SET @PATH := @CGUID+10 * 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, 1934.892, 360.0746, 88.73492, NULL, 0),
+(@PATH, 1, 1936.755, 354.3264, 88.58856, NULL, 0),
+(@PATH, 2, 1921.911, 347.4531, 88.22594, NULL, 0),
+(@PATH, 3, 1903.816, 340.4809, 87.87145, NULL, 0),
+(@PATH, 4, 1896.769, 338.2813, 86.65153, NULL, 0),
+(@PATH, 5, 1888.401, 338.0955, 85.35661, NULL, 0),
+(@PATH, 6, 1875.938, 339.0868, 82.54911, NULL, 5666),
+(@PATH, 7, 1884.715, 337.3125, 84.38346, NULL, 0),
+(@PATH, 8, 1898.609, 340.1528, 87.09318, NULL, 0),
+(@PATH, 9, 1919.743, 350.8629, 88.39208, NULL, 0),
+(@PATH, 10, 1930.215, 357.3611, 88.60094, NULL, 0),
+(@PATH, 11, 1936.248, 360.5538, 88.83856, NULL, 0),
+(@PATH, 12, 1934.861, 364.033, 88.83502, NULL, 6020),
+(@PATH, 13, 1884.715, 337.3125, 84.38346, NULL, 0),
+(@PATH, 14, 1898.609, 340.1528, 87.09318, NULL, 0),
+(@PATH, 15, 1919.743, 350.8629, 88.39208, NULL, 0),
+(@PATH, 23, 1930.215, 357.3611, 88.60094, NULL, 0),
+(@PATH, 24, 1932.601, 361.7726, 88.82555, NULL, 0),
+(@PATH, 25, 1932.616, 364.7726, 88.82738, NULL, 0);
+
+UPDATE `creature` SET `position_x`= 1934.892, `position_y`= 360.0746, `position_z`= 88.73492, `orientation`= 0, `wander_distance`= 0, `MovementType`= 2 WHERE `guid`= @CGUID+10;
+DELETE FROM `creature_addon` WHERE `guid`= @CGUID+10;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `bytes2`) VALUES
+(@CGUID+10, @PATH, 1);