DB/Dornogal: Added some more spawns

1 files changed, 492 insertions, 0 deletions

diff --git a/sql/updates/world/master/2024_09_06_00_world.sql b/sql/updates/world/master/2024_09_06_00_world.sql
new file mode 100644
index 00000000000..b584b1613aa
--- /dev/null
+++ b/sql/updates/world/master/2024_09_06_00_world.sql
@@ -0,0 +1,492 @@
+SET @CGUID := 10001565;
+SET @OGUID := 10000130;
+
+SET @NPCTEXTID := 600002;
+
+-- Creature
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+71;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES
+(@CGUID+0, 219014, 2552, 14771, 14771, '0', '0', 0, 0, 4, 2701.639892578125, -2687.4931640625, 223.432098388671875, 2.438660860061645507, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Oathsworn Peacekeeper (Area: Dornogal - Difficulty: 0) CreateObject1 (Auras: 18950 - Invisibility and Stealth Detection)
+(@CGUID+1, 219014, 2552, 14771, 14771, '0', '0', 0, 0, 1, 2659.2353515625, -2636.692626953125, 225.0185546875, 2.335898637771606445, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Oathsworn Peacekeeper (Area: Dornogal - Difficulty: 0) CreateObject1 (Auras: 18950 - Invisibility and Stealth Detection)
+(@CGUID+2, 219382, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2606.970458984375, -2706.220458984375, 219.734649658203125, 6.228060722351074218, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Unbound Trader (Area: Dornogal - Difficulty: 0) CreateObject1 (Auras: 459770 - [DNT] Earthen Carry Cosmetic Random, 382759 - Conversation Aura: Talk Only [DNT])
+(@CGUID+3, 219014, 2552, 14771, 14771, '0', '0', 0, 0, 1, 2637.6025390625, -2712.41845703125, 220.8609161376953125, 2.353227138519287109, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Oathsworn Peacekeeper (Area: Dornogal - Difficulty: 0) CreateObject1 (Auras: 18950 - Invisibility and Stealth Detection)
+(@CGUID+4, 219014, 2552, 14771, 14771, '0', '0', 0, 0, 2, 2563.35498046875, -2739.3212890625, 204.5569915771484375, 2.23367476463317871, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Oathsworn Peacekeeper (Area: Dornogal - Difficulty: 0) CreateObject1 (Auras: 18950 - Invisibility and Stealth Detection)
+(@CGUID+5, 219014, 2552, 14771, 14771, '0', '0', 0, 0, 6, 2573.993896484375, -2730.260498046875, 204.5569915771484375, 2.790517807006835937, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Oathsworn Peacekeeper (Area: Dornogal - Difficulty: 0) CreateObject1 (Auras: 18950 - Invisibility and Stealth Detection)
+(@CGUID+6, 219014, 2552, 14771, 14771, '0', '0', 0, 0, 1, 2615.463623046875, -2707.791748046875, 220.926544189453125, 2.335961818695068359, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Oathsworn Peacekeeper (Area: Dornogal - Difficulty: 0) CreateObject1 (Auras: 18950 - Invisibility and Stealth Detection)
+(@CGUID+7, 219014, 2552, 14771, 14771, '0', '0', 0, 0, 2, 2648.10595703125, -2717.507080078125, 223.5502471923828125, 2.35945749282836914, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Oathsworn Peacekeeper (Area: Dornogal - Difficulty: 0) CreateObject1 (Auras: 18950 - Invisibility and Stealth Detection)
+(@CGUID+8, 219014, 2552, 14771, 14771, '0', '0', 0, 0, 3, 2680.790771484375, -2657.357666015625, 225.85150146484375, 2.335582733154296875, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Oathsworn Peacekeeper (Area: Dornogal - Difficulty: 0) CreateObject1 (Auras: 18950 - Invisibility and Stealth Detection)
+(@CGUID+9, 219382, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2609.8994140625, -2706.382080078125, 219.734649658203125, 2.968693733215332031, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Unbound Trader (Area: Dornogal - Difficulty: 0) CreateObject1 (Auras: 459770 - [DNT] Earthen Carry Cosmetic Random)
+(@CGUID+10, 219014, 2552, 14771, 14771, '0', '0', 0, 0, 3, 2665.28125, -2630.928955078125, 225.0172271728515625, 2.54509139060974121, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Oathsworn Peacekeeper (Area: Dornogal - Difficulty: 0) CreateObject1 (Auras: 18950 - Invisibility and Stealth Detection)
+(@CGUID+11, 219014, 2552, 14771, 14771, '0', '0', 0, 0, 6, 2691.670166015625, -2672.255126953125, 220.742767333984375, 0.783158957958221435, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Oathsworn Peacekeeper (Area: Dornogal - Difficulty: 0) CreateObject1 (Auras: 18950 - Invisibility and Stealth Detection)
+(@CGUID+12, 219014, 2552, 14771, 14771, '0', '0', 0, 0, 7, 2715.608642578125, -2673.767333984375, 223.432098388671875, 2.308794021606445312, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Oathsworn Peacekeeper (Area: Dornogal - Difficulty: 0) CreateObject1 (Auras: 18950 - Invisibility and Stealth Detection)
+(@CGUID+13, 219040, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2640.90966796875, -2721.3212890625, 220.8609161376953125, 2.365347146987915039, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Auctioneer Prana (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+14, 219037, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2643.12841796875, -2728.763916015625, 223.5502471923828125, 2.351990461349487304, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Auctioneer Durzin (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+15, 219014, 2552, 14771, 14771, '0', '0', 0, 0, 1, 2622.048583984375, -2701.1494140625, 220.938934326171875, 2.368603706359863281, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Oathsworn Peacekeeper (Area: Dornogal - Difficulty: 0) CreateObject1 (Auras: 18950 - Invisibility and Stealth Detection)
+(@CGUID+16, 219039, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2635.43408203125, -2726.857666015625, 220.8609161376953125, 2.33922743797302246, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Auctioneer Zyrgas (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+17, 219014, 2552, 14771, 14771, '0', '0', 0, 0, 3, 2626.40283203125, -2723.513916015625, 220.8609161376953125, 2.348376989364624023, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Oathsworn Peacekeeper (Area: Dornogal - Difficulty: 0) CreateObject1 (Auras: 18950 - Invisibility and Stealth Detection)
+(@CGUID+18, 229927, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2609.0859375, -2708.225830078125, 219.734649658203125, 2.263186216354370117, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Unbound Crafter (Area: Dornogal - Difficulty: 0) CreateObject1 (Auras: 459180 - [DNT] Earthen Laborer Carry Cosmetic)
+(@CGUID+19, 219382, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2630.80126953125, -2707.967041015625, 220.8661041259765625, 4.070153713226318359, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Unbound Trader (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+20, 219014, 2552, 14771, 14771, '0', '0', 0, 0, 7, 2631.612060546875, -2734.02783203125, 223.5502471923828125, 2.365560770034790039, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Oathsworn Peacekeeper (Area: Dornogal - Difficulty: 0) CreateObject1 (Auras: 18950 - Invisibility and Stealth Detection)
+(@CGUID+21, 219382, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2634.05126953125, -2724.2587890625, 220.8609161376953125, 5.848297595977783203, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Unbound Trader (Area: Dornogal - Difficulty: 0) CreateObject1 (Auras: 463535 - [DNT] Inspect Gem)
+(@CGUID+22, 219014, 2552, 14771, 14771, '0', '0', 0, 0, 5, 2700.25341796875, -2663.510498046875, 220.8196868896484375, 3.947758197784423828, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Oathsworn Peacekeeper (Area: Dornogal - Difficulty: 0) CreateObject1 (Auras: 18950 - Invisibility and Stealth Detection)
+(@CGUID+23, 229927, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2550.6416015625, -2723.65625, 204.6116790771484375, 4.712392330169677734, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Unbound Crafter (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+24, 219014, 2552, 14771, 14771, '0', '0', 0, 0, 5, 2685.646728515625, -2652.48095703125, 225.8522491455078125, 2.399427175521850585, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Oathsworn Peacekeeper (Area: Dornogal - Difficulty: 0) CreateObject1 (Auras: 18950 - Invisibility and Stealth Detection)
+(@CGUID+25, 219036, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2704.8359375, -2683.835205078125, 220.742767333984375, 2.007072210311889648, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Ardgaz (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+26, 219023, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2674.10498046875, -2662.069580078125, 225.81756591796875, 1.612093925476074218, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Counter Targrin (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+27, 219053, 2552, 14771, 14771, '0', '0', 0, 0, 1, 2616.99560546875, -2752.65283203125, 204.699005126953125, 4.415776252746582031, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Warpweaver Dezeeran (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+28, 219054, 2552, 14771, 14771, '0', '0', 0, 0, 1, 2635.271728515625, -2745.083251953125, 200.882110595703125, 3.461587429046630859, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Vaultkeeper Xir (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+29, 219029, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2690.489501953125, -2645.838623046875, 225.81756591796875, 3.151028633117675781, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Counter Bardra (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+30, 219208, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2590.82958984375, -2810.659423828125, 198.806488037109375, 1.811390638351440429, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Dusty Mouse (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+31, 214947, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2590.16357421875, -2671.613037109375, 222.342254638671875, 1.728316783905029296, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 56421), -- Eye of Topaz (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+32, 214947, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2637.416259765625, -2634.4921875, 223.221954345703125, 2.212726354598999023, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 56421), -- Eye of Topaz (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+33, 219208, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2608.853515625, -2806.25, 198.8087615966796875, 1.111767292022705078, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 56421), -- Dusty Mouse (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+34, 214947, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2593.22509765625, -2706.913818359375, 222.79766845703125, 1.415592074394226074, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 56421), -- Eye of Topaz (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+35, 214947, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2560.41845703125, -2680.81884765625, 203.527008056640625, 5.213816165924072265, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 56421), -- Eye of Topaz (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+36, 214947, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2568.854248046875, -2712.40234375, 205.6481475830078125, 4.57540130615234375, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 56421), -- Eye of Topaz (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+37, 219208, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2584.385009765625, -2792.7919921875, 204.7781982421875, 3.078702449798583984, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 56421), -- Dusty Mouse (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+38, 214947, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2636.702392578125, -2632.649658203125, 222.390899658203125, 1.928939700126647949, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 56421), -- Eye of Topaz (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+39, 219208, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2613.939453125, -2775.739990234375, 204.610565185546875, 5.426168441772460937, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 56421), -- Dusty Mouse (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+40, 219316, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2631.244873046875, -2784.251708984375, 205.29443359375, 3.154923439025878906, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Wurdin (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+41, 219052, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2563.020751953125, -2764, 205.252105712890625, 1.105097293853759765, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56421), -- Wireweaver Grelka (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+42, 214947, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2637.791748046875, -2677.5068359375, 223.32232666015625, 6.235367298126220703, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 56421), -- Eye of Topaz (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+43, 214947, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2609.14794921875, -2654.0712890625, 222.9970703125, 4.102640628814697265, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 56421), -- Eye of Topaz (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+44, 214947, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2608.259765625, -2760.349853515625, 221.9788360595703125, 5.438277244567871093, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 56421), -- Eye of Topaz (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+45, 219197, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2586.78466796875, -2847.085205078125, 198.89208984375, 3.976556301116943359, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56461), -- Griftah (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+46, 219208, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2566.900146484375, -2863.19091796875, 198.8087615966796875, 2.770439624786376953, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 56461), -- Dusty Mouse (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+47, 219159, 2552, 14771, 14771, '0', '0', 0, 0, 1, 2580.962646484375, -2888.314208984375, 199.200714111328125, 0.837805986404418945, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56461), -- Displaced Rogue (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+48, 219311, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2606.2734375, -2891.626708984375, 198.9535980224609375, 2.366627693176269531, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56461), -- Kordan (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+49, 219159, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2580.642333984375, -2894.838623046875, 199.450653076171875, 1.516540288925170898, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56461), -- Displaced Rogue (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+50, 219063, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2554.83251953125, -2891.27783203125, 200.116790771484375, 0.281286805868148803, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56461), -- Ms. Xiulan (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+51, 219208, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2610.9375, -2853.646484375, 198.8087615966796875, 5.887230873107910156, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 56461), -- Dusty Mouse (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+52, 226418, 2552, 14771, 14771, '0', '0', 0, 0, 1, 2577.944580078125, -2847.57470703125, 198.89208984375, 5.564330101013183593, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56461), -- Steelvein Trader (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+53, 219159, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2584.5625, -2890.510498046875, 198.89208984375, 6.093565940856933593, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56461), -- Displaced Rogue (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+54, 219208, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2567.091796875, -2883.53759765625, 199.6466827392578125, 4.372292041778564453, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 56461), -- Dusty Mouse (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+55, 226418, 2552, 14771, 14771, '0', '0', 0, 0, 1, 2562.260498046875, -2885.59033203125, 200.136627197265625, 4.094864845275878906, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56461), -- Steelvein Trader (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+56, 219056, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2561.0322265625, -2898.897705078125, 200.116790771484375, 1.101243257522583007, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56461), -- Mister Chu (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+57, 219208, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2601.97998046875, -2871.626953125, 198.8087615966796875, 1.44051826000213623, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 56461), -- Dusty Mouse (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+58, 219055, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2562.9384765625, -2894.130126953125, 200.116790771484375, 0.810734927654266357, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56461), -- Madam Goya (Area: Dornogal - Difficulty: 0) CreateObject1 (Auras: 397053 - Crafting Order Vendor Controller, 182641 - Game Object Despawn Periodic)
+(@CGUID+59, 219162, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2566.18408203125, -2859.232666015625, 200.0854644775390625, 5.57581186294555664, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56461), -- Edmond Smith (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+60, 219312, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2573.689208984375, -2828.8681640625, 199.3890228271484375, 6.2483978271484375, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56461), -- Gorenda (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+61, 219079, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2570.389892578125, -2858.376708984375, 198.89208984375, 0.836628854274749755, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56461), -- Relorin Lighthand (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+62, 219160, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2572.079833984375, -2856.907958984375, 198.89208984375, 3.987182378768920898, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56461), -- Hargrin (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+63, 219159, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2587.171875, -2890.819580078125, 198.89208984375, 3.121660470962524414, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56461), -- Displaced Rogue (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+64, 226418, 2552, 14771, 14771, '0', '0', 0, 0, 1, 2603.598876953125, -2875.61279296875, 198.892120361328125, 2.391331195831298828, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56461), -- Steelvein Trader (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+65, 219159, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2588.692626953125, -2889.725830078125, 198.89208984375, 2.417294263839721679, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56461), -- Displaced Rogue (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+66, 219065, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2580.780517578125, -2852.52783203125, 198.89208984375, 6.098943710327148437, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56461), -- Grundaz (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+67, 219159, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2591.2578125, -2886.866455078125, 198.9387969970703125, 2.941254854202270507, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56461), -- Displaced Rogue (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+68, 219208, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2603.3583984375, -2897.080078125, 199.172088623046875, 4.288686752319335937, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 56461), -- Dusty Mouse (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+69, 219208, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2649.4169921875, -2842.927978515625, 198.6576385498046875, 2.96806502342224121, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 56461), -- Dusty Mouse (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+70, 219209, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2582.0927734375, -2893.080078125, 199.1844482421875, 6.020493984222412109, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 56461), -- Tiny Sewer Rat (Area: Dornogal - Difficulty: 0) CreateObject1
+(@CGUID+71, 219195, 2552, 14771, 14771, '0', '0', 0, 0, 0, 2580.47314453125, -2893.788330078125, 199.629791259765625, 0, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 56461); -- Giant Sewer Rat (Area: Dornogal - Difficulty: 0) CreateObject1
+DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+71;
+INSERT INTO `creature_addon` (`guid`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(@CGUID+2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '459770 382759'), -- Unbound Trader - 459770 - [DNT] Earthen Carry Cosmetic Random, 382759 - Conversation Aura: Talk Only [DNT]
+(@CGUID+9, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '459770'), -- Unbound Trader - 459770 - [DNT] Earthen Carry Cosmetic Random
+(@CGUID+18, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '459180'), -- Unbound Crafter - 459180 - [DNT] Earthen Laborer Carry Cosmetic
+(@CGUID+19, 0, 0, 0, 0, 0, 1, 0, 1023, 0, 0, 0, 0, ''), -- Unbound Trader
+(@CGUID+21, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '463535'), -- Unbound Trader - 463535 - [DNT] Inspect Gem
+(@CGUID+23, 0, 0, 5, 0, 0, 1, 0, 0, 0, 0, 0, 0, ''), -- Unbound Crafter
+(@CGUID+40, 0, 0, 0, 0, 0, 1, 0, 415, 0, 0, 0, 0, ''), -- Wurdin
+(@CGUID+47, 0, 0, 0, 0, 0, 1, 0, 743, 0, 0, 0, 0, ''), -- Displaced Rogue
+(@CGUID+49, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''), -- Displaced Rogue
+(@CGUID+52, 0, 0, 0, 0, 0, 0, 0, 0, 30335, 0, 0, 0, ''), -- Steelvein Trader
+(@CGUID+53, 0, 0, 0, 0, 0, 1, 0, 0, 29089, 0, 0, 0, ''), -- Displaced Rogue
+(@CGUID+55, 0, 0, 0, 0, 0, 0, 0, 720, 0, 0, 0, 0, ''), -- Steelvein Trader
+(@CGUID+59, 0, 0, 0, 0, 0, 1, 0, 757, 0, 0, 0, 0, ''), -- Edmond Smith
+(@CGUID+60, 0, 0, 0, 0, 0, 1, 0, 415, 0, 0, 0, 0, ''), -- Gorenda
+(@CGUID+63, 0, 0, 0, 0, 0, 0, 0, 0, 29089, 0, 0, 0, ''), -- Displaced Rogue
+(@CGUID+64, 0, 0, 0, 0, 0, 0, 0, 0, 30335, 0, 0, 0, ''), -- Steelvein Trader
+(@CGUID+65, 0, 0, 0, 0, 0, 0, 0, 720, 0, 0, 0, 0, ''), -- Displaced Rogue
+(@CGUID+67, 0, 0, 0, 0, 0, 0, 0, 720, 0, 0, 0, 0, ''); -- Displaced Rogue
+
+-- GameObject
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+118;
+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, 452644, 2552, 14771, 14771, '0', '0', 0, 2563.0634765625, -2759.75048828125, 205.1883392333984375, 1.117011547088623046, 0, 0, 0.529919624328613281, 0.848047912120819091, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+1, 459299, 2552, 14771, 14771, '0', '0', 0, 2790.2236328125, -2750.87890625, 235.5539703369140625, 3.970627307891845703, 0, 0, -0.91531085968017578, 0.402748137712478637, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+2, 440938, 2552, 14771, 14771, '0', '0', 0, 2464.394775390625, -2209.784912109375, 163.361175537109375, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 56421), -- Gate (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+3, 433630, 2552, 14771, 14771, '0', '0', 0, 2773.705322265625, -2843.7265625, 223.44757080078125, 1.580898761749267578, 0, 0, 0.710669517517089843, 0.703526020050048828, 120, 255, 1, 56421), -- Stool (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+4, 459282, 2552, 14771, 14771, '0', '0', 0, 2668.30810546875, -2656.05126953125, 225.6018829345703125, 1.178098201751708984, 0, 0, 0.555570602416992187, 0.831469357013702392, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+5, 459272, 2552, 14771, 14771, '0', '0', 0, 2783.18017578125, -2748.8046875, 254.8867950439453125, 3.080448389053344726, 0, 0, 0.999532699584960937, 0.030567342415452003, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+6, 433640, 2552, 14771, 14771, '0', '0', 0, 2753.2763671875, -2843.560546875, 227.344512939453125, 1.4114837646484375, 0, 0, 0.648598670959472656, 0.761130571365356445, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+7, 452645, 2552, 14771, 14771, '0', '0', 0, 2633.19775390625, -2783.13330078125, 204.9889984130859375, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+8, 441169, 2552, 14771, 14771, '0', '0', 0, 3581.064208984375, -2438.5, 957.498046875, 3.593751907348632812, -0.2376713752746582, -0.18511867523193359, -0.92043018341064453, 0.249101698398590087, 120, 255, 1, 56421), -- Dormant Rock Giant (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+9, 428868, 2552, 14771, 14771, '0', '0', 0, 2617.59033203125, -2622.045166015625, 219.7758331298828125, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 56421), -- Bench (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+10, 433631, 2552, 14771, 14771, '0', '0', 0, 2772.31494140625, -2843.755859375, 223.4429473876953125, 4.660550594329833984, 0, 0, -0.72519493103027343, 0.688543617725372314, 120, 255, 1, 56421), -- Stool (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+11, 459283, 2552, 14771, 14771, '0', '0', 0, 2681.991455078125, -2637.494873046875, 225.5929412841796875, 4.310965538024902343, 0, 0, -0.83388519287109375, 0.55193793773651123, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+12, 428931, 2552, 14771, 14771, '0', '0', 0, 2460.01904296875, -2716.28125, 201.162322998046875, 3.970627307891845703, 0, 0, -0.91531085968017578, 0.402748137712478637, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+13, 459273, 2552, 14771, 14771, '0', '0', 0, 2783.2568359375, -2746.43359375, 254.8867950439453125, 3.124123096466064453, 0, 0, 0.99996185302734375, 0.008734640665352344, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+14, 452646, 2552, 14771, 14771, '0', '0', 0, 2564.8681640625, -2776.26220703125, 205.00909423828125, 4.686212062835693359, 0, 0, -0.71630096435546875, 0.697791457176208496, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+15, 467001, 2552, 14771, 14771, '0', '0', 0, 2537.04248046875, -2610.32470703125, 181.47662353515625, 3.159062385559082031, 0, 0, -0.99996185302734375, 0.008734640665352344, 120, 255, 1, 56421), -- Anvil (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+16, 428869, 2552, 14771, 14771, '0', '0', 0, 2617.780517578125, -2572.5556640625, 219.7649688720703125, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 56421), -- Bench (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+17, 459276, 2552, 14771, 14771, '0', '0', 0, 2788.001953125, -2714.45068359375, 221.7736053466796875, 0.767943859100341796, 0, 0, 0.374606132507324218, 0.927184045314788818, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+18, 428996, 2552, 14771, 14771, '0', '0', 0, 2474.40625, -2674.345458984375, 200.3131866455078125, 4.703663349151611328, 0, 0, -0.71018505096435546, 0.704015016555786132, 120, 255, 1, 56421), -- Leatherworker's Tool Bench (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+19, 459274, 2552, 14771, 14771, '0', '0', 0, 2779.7978515625, -2746.4345703125, 254.8867950439453125, 0.061086613684892654, 0, 0, 0.030538558959960937, 0.999533593654632568, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+20, 452647, 2552, 14771, 14771, '0', '0', 0, 2520.03369140625, -2775.68798828125, 202.177581787109375, 4.703663349151611328, 0, 0, -0.71018505096435546, 0.704015016555786132, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+21, 465666, 2552, 14771, 14771, '0', '0', 0, 2566.8798828125, -2756.95849609375, 205.16876220703125, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 56421), -- Lapidary's Mirror (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+22, 428958, 2552, 14771, 14771, '0', '0', 0, 2823.420166015625, -2733.166748046875, 257.528656005859375, 3.953172922134399414, 0, 0, -0.91879081726074218, 0.394744753837585449, 120, 255, 1, 56421), -- Bench (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+23, 467002, 2552, 14771, 14771, '0', '0', 0, 2521.322998046875, -2626.48779296875, 181.425018310546875, 0.767943859100341796, 0, 0, 0.374606132507324218, 0.927184045314788818, 120, 255, 1, 56421), -- Anvil (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+24, 433636, 2552, 14771, 14771, '0', '0', 0, 2775.291748046875, -2830.7998046875, 223.4458770751953125, 4.04067230224609375, 0, 0, -0.90064716339111328, 0.434551119804382324, 120, 255, 1, 56421), -- Stool (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+25, 428870, 2552, 14771, 14771, '0', '0', 0, 2617.720458984375, -2605.8681640625, 219.6887969970703125, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 56421), -- Bench (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+26, 452653, 2552, 14771, 14771, '0', '0', 0, 2498.68359375, -2681.6044921875, 181.4014739990234375, 1.544615507125854492, 0, 0, 0.697790145874023437, 0.716302275657653808, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+27, 433625, 2552, 14771, 14771, '0', '0', 0, 2773.567626953125, -2839.2216796875, 223.5163726806640625, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 56421), -- Stool (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+28, 459275, 2552, 14771, 14771, '0', '0', 0, 2781.76513671875, -2744.7822265625, 254.8867950439453125, 4.668760299682617187, 0, 0, -0.72236251831054687, 0.691514551639556884, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+29, 465667, 2552, 14771, 14771, '0', '0', 0, 2563.369140625, -2756.896728515625, 205.16876220703125, 1.596976161003112792, 0, 0, 0.716301918029785156, 0.697790443897247314, 120, 255, 1, 56421), -- Lapidary's Mirror (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+30, 447138, 2552, 14771, 14771, '0', '0', 0, 2792.697021484375, -2602.170166015625, 219.6816253662109375, 3.019413232803344726, 0, 0, 0.998134613037109375, 0.061051756143569946, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+31, 428898, 2552, 14771, 14771, '0', '0', 0, 2675.264892578125, -2533.37158203125, 221.13043212890625, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+32, 433637, 2552, 14771, 14771, '0', '0', 0, 2755.777099609375, -2833.392822265625, 227.374267578125, 3.085526466369628906, 0, 0, 0.999607086181640625, 0.028029426932334899, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+33, 463872, 2552, 14771, 14771, '0', '0', 0, 2521.701416015625, -2754.038330078125, 204.313262939453125, 0.645771682262420654, 0, 0, 0.317304611206054687, 0.948323667049407958, 120, 255, 1, 56421), -- Mailbox (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+34, 429065, 2552, 14771, 14771, '0', '0', 0, 2790.647705078125, -2665.116455078125, 224.289581298828125, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 120, 255, 1, 56421), -- Bench (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+35, 433626, 2552, 14771, 14771, '0', '0', 0, 2773.635986328125, -2837.956787109375, 223.504974365234375, 6.277152538299560546, 0, 0, -0.00301647186279296, 0.999995410442352294, 120, 255, 1, 56421), -- Stool (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+36, 466205, 2552, 14771, 14771, '0', '0', 0, 2802.4326171875, -2735.20703125, 235.5844268798828125, 5.163228034973144531, 0.020595073699951171, -0.02781009674072265, -0.53050518035888671, 0.84697502851486206, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+37, 433638, 2552, 14771, 14771, '0', '0', 0, 2753.221435546875, -2831.21044921875, 227.3692474365234375, 4.84711456298828125, 0, 0, -0.65790653228759765, 0.753099620342254638, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+38, 452659, 2552, 14771, 14771, '0', '0', 0, 2559.812744140625, -2896.993408203125, 200.00909423828125, 0.794123053550720214, 0, 0, 0.386710166931152343, 0.922201275825500488, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+39, 446368, 2552, 14771, 14771, '0', '0', 0, 2693.3330078125, -2687.28369140625, 228.25286865234375, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 120, 255, 1, 56421), -- Guild Vault (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+40, 428925, 2552, 14771, 14771, '0', '0', 0, 2455.19970703125, -2733.585205078125, 201.1471710205078125, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+41, 442368, 2552, 14771, 14771, '0', '0', 0, 2260.7744140625, -2670.944580078125, 265.40557861328125, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 120, 255, 1, 56421), -- 442368 (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+42, 433627, 2552, 14771, 14771, '0', '0', 0, 2773.701904296875, -2836.7802734375, 223.5070037841796875, 6.2408905029296875, 0, 0, -0.02114582061767578, 0.999776422977447509, 120, 255, 1, 56421), -- Stool (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+43, 441164, 2552, 14771, 14771, '0', '0', 0, 3024.775146484375, -3229.875, 220.221099853515625, 3.383082389831542968, 0.2770843505859375, 0.056103706359863281, -0.95141029357910156, 0.122045405209064483, 120, 255, 1, 56421), -- Dormant Rock Giant (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+44, 428943, 2552, 14771, 14771, '0', '0', 0, 2656.748291015625, -2619.44970703125, 224.2151641845703125, 0.741763234138488769, 0, 0, 0.362437248229980468, 0.932008147239685058, 120, 255, 1, 56421), -- Mailbox (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+45, 466206, 2552, 14771, 14771, '0', '0', 0, 2813.6689453125, -2750.76953125, 238.26861572265625, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+46, 440938, 2552, 14771, 14771, '0', '0', 0, 2593.3876953125, -2556.132080078125, 181.9781036376953125, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 56421), -- Gate (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+47, 459271, 2552, 14771, 14771, '0', '0', 0, 2781.84521484375, -2750.30078125, 254.8867950439453125, 1.570798397064208984, 0, 0, 0.7071075439453125, 0.707105994224548339, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+48, 433639, 2552, 14771, 14771, '0', '0', 0, 2755.285888671875, -2841.08251953125, 227.3687591552734375, 3.713781118392944335, 0, 0, -0.95935344696044921, 0.282207340002059936, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+49, 459272, 2552, 14771, 14771, '0', '0', 0, 2790.492919921875, -2712.12255859375, 221.7736053466796875, 3.865906238555908203, 0, 0, -0.9351348876953125, 0.354291886091232299, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+50, 459278, 2552, 14771, 14771, '0', '0', 0, 2675.230712890625, -2644.078125, 225.7088623046875, 0.776671826839447021, 0, 0, 0.378648757934570312, 0.925540447235107421, 120, 255, 1, 56421), -- Bench (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+51, 429067, 2552, 14771, 14771, '0', '0', 0, 2782.14501953125, -2656.579833984375, 224.2892303466796875, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 120, 255, 1, 56421), -- Bench (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+52, 454424, 2552, 14771, 14771, '0', '0', 0, 3650.403564453125, -3602.335205078125, 183.8083343505859375, 2.253613471984863281, 0.024065494537353515, -0.11708736419677734, 0.893575668334960937, 0.432705342769622802, 120, 255, 1, 56421), -- Dormant Rock Giant (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+53, 428936, 2552, 14771, 14771, '0', '0', 0, 2551.1416015625, -2723.65625, 204.6116790771484375, 4.712392330169677734, 0, 0, -0.70710563659667968, 0.707107901573181152, 120, 255, 1, 56421), -- Bench (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+54, 452643, 2552, 14771, 14771, '0', '0', 0, 2567.697265625, -2759.52392578125, 205.1883392333984375, 2.007128477096557617, 0, 0, 0.84339141845703125, 0.537299633026123046, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+55, 433632, 2552, 14771, 14771, '0', '0', 0, 2770.97021484375, -2843.791748046875, 223.451446533203125, 4.660553455352783203, 0, 0, -0.72519397735595703, 0.688544631004333496, 120, 255, 1, 56421), -- Stool (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+56, 459273, 2552, 14771, 14771, '0', '0', 0, 2788.87060546875, -2710.391845703125, 221.7736053466796875, 3.90954136848449707, 0, 0, -0.92718315124511718, 0.37460830807685852, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+57, 459279, 2552, 14771, 14771, '0', '0', 0, 2672.552001953125, -2647.05078125, 225.7088623046875, 0.776671826839447021, 0, 0, 0.378648757934570312, 0.925540447235107421, 120, 255, 1, 56421), -- Bench (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+58, 428927, 2552, 14771, 14771, '0', '0', 0, 2456.3212890625, -2715.810791015625, 201.0980224609375, 5.462882041931152343, 0, 0, -0.39874839782714843, 0.917060375213623046, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+59, 459300, 2552, 14771, 14771, '0', '0', 0, 2810.037109375, -2737.626953125, 238.29473876953125, 1.082105159759521484, 0, 0, 0.515038490295410156, 0.857167065143585205, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+60, 428993, 2552, 14771, 14771, '0', '0', 0, 2604.876708984375, -2869.505126953125, 198.8313751220703125, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 120, 255, 1, 56421), -- Mailbox (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+61, 441166, 2552, 14771, 14771, '0', '0', 0, 1027.0069580078125, -2597.734375, 67.95830535888671875, 4.797432422637939453, 0.013546943664550781, -0.0426034927368164, -0.67509746551513671, 0.736372768878936767, 120, 255, 1, 56421), -- Dormant Rock Giant (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+62, 434052, 2552, 14771, 14771, '0', '0', 0, 2688.7431640625, -2545.15283203125, 220.8695068359375, 3.857182979583740234, 0, 0, -0.93667125701904296, 0.350209832191467285, 120, 255, 1, 56421), -- Stool (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+63, 432823, 2552, 14771, 14771, '0', '0', 0, 3227.093505859375, -2847.00244140625, 371.299407958984375, 5.492420196533203125, 0, 0, -0.38516139984130859, 0.922849237918853759, 120, 255, 1, 56421), -- Door (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+64, 433633, 2552, 14771, 14771, '0', '0', 0, 2770.85400390625, -2830.796875, 223.4444427490234375, 1.556595683097839355, 0, 0, 0.702068328857421875, 0.712109625339508056, 120, 255, 1, 56421), -- Stool (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+65, 428867, 2552, 14771, 14771, '0', '0', 0, 2617.721435546875, -2588.132080078125, 219.8520050048828125, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 56421), -- Bench (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+66, 459274, 2552, 14771, 14771, '0', '0', 0, 2786.42529296875, -2712.83837890625, 221.7736053466796875, 0.846484839916229248, 0, 0, 0.410718917846679687, 0.911761999130249023, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+67, 459301, 2552, 14771, 14771, '0', '0', 0, 2788.455078125, -2748.66015625, 235.5539703369140625, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+68, 428097, 2552, 14771, 14771, '0', '0', 0, 2773.4853515625, -2627.552001953125, 224.3715362548828125, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 56421), -- Bench (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+69, 430486, 2552, 14771, 14771, '0', '0', 0, 2598.98779296875, -2702.267333984375, 219.4811553955078125, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 56421), -- Mailbox (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+70, 459284, 2552, 14771, 14771, '0', '0', 0, 2679.118408203125, -2634.590087890625, 225.5676116943359375, 3.394674062728881835, 0, 0, -0.99200439453125, 0.126203224062919616, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+71, 428932, 2552, 14771, 14771, '0', '0', 0, 2451.81591796875, -2731.725830078125, 201.1471710205078125, 4.633852005004882812, 0, 0, -0.73432159423828125, 0.678801715373992919, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+72, 434053, 2552, 14771, 14771, '0', '0', 0, 2688.404541015625, -2548.98779296875, 220.8695068359375, 2.487092971801757812, 0, 0, 0.946929931640625, 0.321440041065216064, 120, 255, 1, 56421), -- Stool (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+73, 433634, 2552, 14771, 14771, '0', '0', 0, 2772.294677734375, -2830.728759765625, 223.4479522705078125, 1.633221268653869628, 0, 0, 0.728829383850097656, 0.684695363044738769, 120, 255, 1, 56421), -- Stool (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+74, 459275, 2552, 14771, 14771, '0', '0', 0, 2786.64794921875, -2710.27880859375, 221.7736053466796875, 5.454157352447509765, 0, 0, -0.40274524688720703, 0.915312111377716064, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+75, 428921, 2552, 14771, 14771, '0', '0', 0, 2742.264892578125, -2627.55029296875, 224.4719390869140625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 56421), -- Bench (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+76, 459302, 2552, 14771, 14771, '0', '0', 0, 2837.1767578125, -2745.37890625, 243.9663543701171875, 1.579524636268615722, 0, 0, 0.710186004638671875, 0.704014122486114501, 120, 255, 1, 56421), -- Bench (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+77, 428894, 2552, 14771, 14771, '0', '0', 0, 2676.561767578125, -2533.420166015625, 221.13043212890625, 1.605701684951782226, 0, 0, 0.719339370727539062, 0.694658815860748291, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+78, 452645, 2552, 14771, 14771, '0', '0', 0, 2573.82763671875, -2828.87451171875, 199.3238067626953125, 0, 0, 0, 0, 1, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+79, 459285, 2552, 14771, 14771, '0', '0', 0, 2666.065185546875, -2653.69091796875, 225.6018829345703125, 0.174534037709236145, 0, 0, 0.087156295776367187, 0.996194660663604736, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+80, 434054, 2552, 14771, 14771, '0', '0', 0, 2685.455810546875, -2548.895751953125, 220.8695068359375, 1.012289404869079589, 0, 0, 0.484808921813964843, 0.87462007999420166, 120, 255, 1, 56421), -- Stool (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+81, 433635, 2552, 14771, 14771, '0', '0', 0, 2773.74560546875, -2830.78076171875, 223.454925537109375, 1.375832438468933105, 0, 0, 0.634928703308105468, 0.772570729255676269, 120, 255, 1, 56421), -- Stool (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+82, 428922, 2552, 14771, 14771, '0', '0', 0, 2460.28466796875, -2719.861083984375, 201.1374359130859375, 2.382372379302978515, 0, 0, 0.928809165954589843, 0.370558410882949829, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+83, 459286, 2552, 14771, 14771, '0', '0', 0, 2663.05859375, -2650.75634765625, 225.59765625, 1.169370889663696289, 0, 0, 0.551937103271484375, 0.833885729312896728, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+84, 428934, 2552, 14771, 14771, '0', '0', 0, 2453.241455078125, -2731.697998046875, 201.1471710205078125, 4.738570213317871093, 0, 0, -0.69779014587402343, 0.716302275657653808, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+85, 459276, 2552, 14771, 14771, '0', '0', 0, 2779.7724609375, -2748.689453125, 254.8867950439453125, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+86, 428923, 2552, 14771, 14771, '0', '0', 0, 2456.701416015625, -2719.6806640625, 201.1589508056640625, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+87, 459271, 2552, 14771, 14771, '0', '0', 0, 2790.60693359375, -2714.12451171875, 221.7736053466796875, 2.356194972991943359, 0, 0, 0.923879623413085937, 0.382683247327804565, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+88, 441162, 2552, 14771, 14771, '0', '0', 0, 1894.6302490234375, -2687.361083984375, 141.157257080078125, 5.988608360290527343, 0.140343189239501953, -0.25971031188964843, -0.09673595428466796, 0.950524330139160156, 120, 255, 1, 56421), -- Dormant Rock Giant (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+89, 428917, 2552, 14771, 14771, '0', '0', 0, 2448.4931640625, -2731.795166015625, 201.1471710205078125, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+90, 459287, 2552, 14771, 14771, '0', '0', 0, 2684.213134765625, -2639.878173828125, 225.5929412841796875, 3.307414531707763671, 0, 0, -0.99656486511230468, 0.082815870642662048, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+91, 428935, 2552, 14771, 14771, '0', '0', 0, 2567.673583984375, -2723.947998046875, 204.4093780517578125, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 120, 255, 1, 56421), -- Bench (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+92, 428918, 2552, 14771, 14771, '0', '0', 0, 2450.822998046875, -2747.63720703125, 200.24761962890625, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+93, 433628, 2552, 14771, 14771, '0', '0', 0, 2773.640380859375, -2835.2001953125, 223.538360595703125, 4.081234931945800781, 0, 0, -0.89164924621582031, 0.45272684097290039, 120, 255, 1, 56421), -- Stool (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+94, 446366, 2552, 14771, 14771, '0', '0', 0, 2710.320068359375, -2682.614990234375, 227.784942626953125, 2.369606494903564453, 0, 0, 0.926424980163574218, 0.376479417085647583, 120, 255, 1, 56421), -- The Great Vault (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+95, 459280, 2552, 14771, 14771, '0', '0', 0, 2660.8369140625, -2648.374267578125, 225.59765625, 0.165804952383041381, 0, 0, 0.082807540893554687, 0.996565580368041992, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+96, 452645, 2552, 14771, 14771, '0', '0', 0, 2550.973388671875, -2758.244384765625, 204.9889984130859375, 2.391098499298095703, 0, 0, 0.930417060852050781, 0.366502493619918823, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+97, 459298, 2552, 14771, 14771, '0', '0', 0, 2837.250732421875, -2740.38671875, 244.0092620849609375, 4.716722488403320312, 0, 0, -0.70557308197021484, 0.708637177944183349, 120, 255, 1, 56421), -- Bench (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+98, 452661, 2552, 14771, 14771, '0', '0', 0, 2623.38671875, -2570.240234375, 183.334228515625, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+99, 433629, 2552, 14771, 14771, '0', '0', 0, 2775.070556640625, -2843.598876953125, 223.4630584716796875, 4.694422245025634765, 0, 0, -0.71343040466308593, 0.700726091861724853, 120, 255, 1, 56421), -- Stool (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+100, 446367, 2552, 14771, 14771, '0', '0', 0, 2715.267333984375, -2665.239990234375, 228.1408233642578125, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 120, 255, 1, 56421), -- Guild Vault (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+101, 459281, 2552, 14771, 14771, '0', '0', 0, 2676.896240234375, -2632.207763671875, 225.5676116943359375, 4.310965538024902343, 0, 0, -0.83388519287109375, 0.55193793773651123, 120, 255, 1, 56421), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+102, 441785, 2552, 14771, 14771, '0', '0', 0, 2260.7744140625, -2670.944580078125, 265.40557861328125, 0.785396754741668701, 0, 0, 0.38268280029296875, 0.923879802227020263, 120, 255, 1, 56421), -- 441785 (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+103, 377531, 2552, 14771, 14771, '0', '0', 0, 2746.62841796875, -2664.140625, 225.606719970703125, 1.237192630767822265, 0, 0, 0.579892158508300781, 0.814693212509155273, 120, 255, 1, 56421), -- Draconic Hourglass (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+104, 377117, 2552, 14771, 14771, '0', '0', 0, 2749.001708984375, -2668.1337890625, 226.8239898681640625, 0.771524608135223388, 0, 0, 0.376265525817871093, 0.926511883735656738, 120, 255, 1, 56421), -- Dragon Jewelry Box (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+105, 428728, 2552, 14771, 14771, '0', '0', 0, 2982.549560546875, -2398.02783203125, 266.244873046875, 0, 0, 0, 0, 1, 120, 255, 1, 56421), -- Portal to Stormwind (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+106, 428729, 2552, 14771, 14771, '0', '0', 0, 2918.693603515625, -2334.536376953125, 266.244873046875, 0, 0, 0, 0, 1, 120, 255, 1, 56421), -- Portal to Orgrimmar (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+107, 385537, 2552, 14771, 14771, '0', '0', 0, 2770.252685546875, -2659.392333984375, 226.5789947509765625, 0.023222491145133972, 0, 0, 0.011610984802246093, 0.999932587146759033, 120, 255, 1, 56421), -- [DNT] Hourglass 01 (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+108, 389674, 2552, 14771, 14771, '0', '0', 0, 2746.345458984375, -2658.552001953125, 226.9882354736328125, 2.715246438980102539, 0, 0, 0.977364540100097656, 0.211562186479568481, 120, 255, 1, 56421), -- Blacktalon Map (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+109, 456208, 2552, 14771, 14771, '0', '0', 0, 2539.506103515625, -2583.541748046875, 181.407958984375, 0, 0, 0, 0, 1, 120, 255, 1, 56421), -- The Catalyst (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+110, 385537, 2552, 14771, 14771, '0', '0', 0, 2766.5947265625, -2667.951416015625, 225.606719970703125, 1.616776823997497558, 0, 0, 0.723175048828125, 0.69066476821899414, 120, 255, 1, 56421), -- [DNT] Hourglass 01 (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+111, 377308, 2552, 14771, 14771, '0', '0', 0, 2747.776123046875, -2667.366455078125, 227.6908721923828125, 2.315067052841186523, 0, 0, 0.915815353393554687, 0.401599615812301635, 120, 255, 1, 56421), -- Dragon Book Pile (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+112, 377531, 2552, 14771, 14771, '0', '0', 0, 2746.548583984375, -2659.75, 225.606719970703125, 1.237192630767822265, 0, 0, 0.579892158508300781, 0.814693212509155273, 120, 255, 1, 56421), -- Draconic Hourglass (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+113, 385537, 2552, 14771, 14771, '0', '0', 0, 2759.9931640625, -2668.052001953125, 225.606719970703125, 1.583638906478881835, 0, 0, 0.711632728576660156, 0.702551662921905517, 120, 255, 1, 56421), -- [DNT] Hourglass 01 (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+114, 402552, 2552, 14771, 14771, '0', '0', 0, 2746.862060546875, -2665.744873046875, 226.9690704345703125, 5.118732929229736328, 0, 0, -0.54988479614257812, 0.835240483283996582, 120, 255, 1, 56421), -- Scroll Stack 2 (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+115, 428974, 2552, 14771, 14771, '0', '0', 0, 2436.15625, -2765.28466796875, 200.0900115966796875, 1.527163028717041015, 0, 0, 0.6915130615234375, 0.722363948822021484, 120, 255, 1, 56461), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+116, 428924, 2552, 14771, 14771, '0', '0', 0, 2445.16845703125, -2733.92529296875, 201.1471710205078125, 0.008726147934794425, 0, 0, 0.004363059997558593, 0.999990463256835937, 120, 255, 1, 56461), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+117, 428926, 2552, 14771, 14771, '0', '0', 0, 2446.92529296875, -2731.760498046875, 201.1471710205078125, 4.668757438659667968, 0, 0, -0.72236347198486328, 0.691513597965240478, 120, 255, 1, 56461), -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+(@OGUID+118, 428875, 2552, 14771, 14771, '0', '0', 0, 2421.97216796875, -2757.59033203125, 200.2057952880859375, 5.45415496826171875, 0, 0, -0.40274620056152343, 0.915311694145202636, 120, 255, 1, 56461); -- Chair (Area: Dornogal - Difficulty: 0) CreateObject1
+DELETE FROM `gameobject_addon` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+118;
+INSERT INTO `gameobject_addon` (`guid`, `parent_rotation0`, `parent_rotation1`, `parent_rotation2`, `parent_rotation3`, `WorldEffectID`, `AIAnimKitID`) VALUES
+(@OGUID+0, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair
+(@OGUID+1, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair
+(@OGUID+2, 0, 0, 0.70710688829421997, 0.707106649875640869, 0, 0), -- Gate
+(@OGUID+3, 0, 0, 1, -0.00000004371138828, 0, 0), -- Stool
+(@OGUID+4, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Chair
+(@OGUID+5, 0, 0, 0.70710688829421997, 0.707106649875640869, 0, 0), -- Chair
+(@OGUID+6, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair
+(@OGUID+7, 0, 0, 0.000000087422776573, 1, 0, 0), -- Chair
+(@OGUID+10, 0, 0, 1, -0.00000004371138828, 0, 0), -- Stool
+(@OGUID+11, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Chair
+(@OGUID+13, 0, 0, 0.70710688829421997, 0.707106649875640869, 0, 0), -- Chair
+(@OGUID+14, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair
+(@OGUID+17, 0, 0, 0.923879504203796386, 0.38268357515335083, 0, 0), -- Chair
+(@OGUID+19, 0, 0, 0.70710688829421997, 0.707106649875640869, 0, 0), -- Chair
+(@OGUID+20, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair
+(@OGUID+21, 0, 0, 1, -0.00000004371138828, 16227, 0), -- Lapidary's Mirror
+(@OGUID+24, 0, 0, 1, -0.00000004371138828, 0, 0), -- Stool
+(@OGUID+26, 0, 0, -0.70710676908493041, 0.707106769084930419, 0, 0), -- Chair
+(@OGUID+27, 0, 0, 1, -0.00000004371138828, 0, 0), -- Stool
+(@OGUID+28, 0, 0, 0.70710688829421997, 0.707106649875640869, 0, 0), -- Chair
+(@OGUID+29, 0, 0, 1, -0.00000004371138828, 16227, 0), -- Lapidary's Mirror
+(@OGUID+32, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair
+(@OGUID+35, 0, 0, 1, -0.00000004371138828, 0, 0), -- Stool
+(@OGUID+36, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair
+(@OGUID+37, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair
+(@OGUID+38, 0, 0, 0.923879504203796386, -0.38268348574638366, 0, 0), -- Chair
+(@OGUID+39, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Guild Vault
+(@OGUID+42, 0, 0, 1, -0.00000004371138828, 0, 0), -- Stool
+(@OGUID+45, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair
+(@OGUID+46, 0, 0, 0.713250935077667236, 0.700908839702606201, 0, 0), -- Gate
+(@OGUID+47, 0, 0, 0.70710688829421997, 0.707106649875640869, 0, 0), -- Chair
+(@OGUID+48, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair
+(@OGUID+49, 0, 0, 0.923879504203796386, 0.38268357515335083, 0, 0), -- Chair
+(@OGUID+50, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Bench
+(@OGUID+54, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair
+(@OGUID+55, 0, 0, 1, -0.00000004371138828, 0, 0), -- Stool
+(@OGUID+56, 0, 0, 0.923879504203796386, 0.38268357515335083, 0, 0), -- Chair
+(@OGUID+57, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Bench
+(@OGUID+59, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair
+(@OGUID+63, 0, 0, -0.70710676908493041, 0.707106769084930419, 0, 0), -- Door
+(@OGUID+64, 0, 0, 1, -0.00000004371138828, 0, 0), -- Stool
+(@OGUID+66, 0, 0, 0.923879504203796386, 0.38268357515335083, 0, 0), -- Chair
+(@OGUID+67, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair
+(@OGUID+70, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Chair
+(@OGUID+73, 0, 0, 1, -0.00000004371138828, 0, 0), -- Stool
+(@OGUID+74, 0, 0, 0.923879504203796386, 0.38268357515335083, 0, 0), -- Chair
+(@OGUID+76, 0, 0, 1, -0.00000004371138828, 0, 0), -- Bench
+(@OGUID+78, 0, 0, 1, -0.00000004371138828, 0, 0), -- Chair
+(@OGUID+79, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Chair
+(@OGUID+81, 0, 0, 1, -0.00000004371138828, 0, 0), -- Stool
+(@OGUID+83, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Chair
+(@OGUID+85, 0, 0, 0.70710688829421997, 0.707106649875640869, 0, 0), -- Chair
+(@OGUID+87, 0, 0, 0.923879504203796386, 0.38268357515335083, 0, 0), -- Chair
+(@OGUID+90, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Chair
+(@OGUID+93, 0, 0, 1, -0.00000004371138828, 0, 0), -- Stool
+(@OGUID+94, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- The Great Vault
+(@OGUID+95, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Chair
+(@OGUID+96, 0, 0, -0.36650115251541137, 0.930417597293853759, 0, 0), -- Chair
+(@OGUID+97, 0, 0, 1, -0.00000004371138828, 0, 0), -- Bench
+(@OGUID+98, 0, 0, 0.000000087422776573, 1, 0, 0), -- Chair
+(@OGUID+99, 0, 0, 1, -0.00000004371138828, 0, 0), -- Stool
+(@OGUID+100, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Guild Vault
+(@OGUID+101, 0, 0, -0.38268330693244934, 0.923879623413085937, 0, 0), -- Chair
+(@OGUID+105, 0, 0, 0, 1, 0, 3503), -- Portal to Stormwind
+(@OGUID+106, 0, 0, 0, 1, 0, 3503), -- Portal to Orgrimmar
+(@OGUID+109, 0, 0, 0, 1, 27021, 0); -- The Catalyst
+
+-- Template Addon
+DELETE FROM `gameobject_template_addon` WHERE `entry` IN (456208 /*The Catalyst*/, 428729 /*Portal to Orgrimmar*/, 428728 /*Portal to Stormwind*/, 377117 /*Dragon Jewelry Box*/, 441785 /*441785*/, 446367 /*Guild Vault*/, 446366 /*The Great Vault*/, 428918 /*Chair*/, 428923 /*Chair*/, 432823 /*Door*/, 428927 /*Chair*/, 442368 /*442368*/, 446368 /*Guild Vault*/, 447138 /*Chair*/, 465667 /*Lapidary's Mirror*/, 465666 /*Lapidary's Mirror*/, 440938 /*Gate*/,428875 /*Chair*/, 428926 /*Chair*/, 428924 /*Chair*/);
+INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`) VALUES
+(456208, 0, 0, 27021, 0), -- The Catalyst
+(428729, 1735, 32, 0, 3503), -- Portal to Orgrimmar
+(428728, 1732, 32, 0, 3503), -- Portal to Stormwind
+(377117, 190, 0, 0, 0), -- Dragon Jewelry Box
+(441785, 0, 32, 0, 0), -- 441785
+(446367, 35, 0, 0, 0), -- Guild Vault
+(446366, 0, 262144, 0, 0), -- The Great Vault
+(428918, 114, 0, 0, 0), -- Chair
+(428923, 114, 0, 0, 0), -- Chair
+(432823, 0, 32, 0, 0), -- Door
+(428927, 114, 0, 0, 0), -- Chair
+(442368, 0, 32, 0, 0), -- 442368
+(446368, 35, 0, 0, 0), -- Guild Vault
+(447138, 114, 0, 0, 0), -- Chair
+(465667, 35, 0, 16227, 0), -- Lapidary's Mirror
+(465666, 35, 0, 16227, 0), -- Lapidary's Mirror
+(440938, 0, 34, 0, 0), -- Gate
+(428875, 114, 0, 0, 0), -- Chair
+(428926, 114, 0, 0, 0), -- Chair
+(428924, 114, 0, 0, 0); -- Chair
+
+DELETE FROM `creature_template_addon` WHERE `entry` IN (219054, 219014, 219055);
+INSERT INTO `creature_template_addon` (`entry`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES
+(219054, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''), -- 219054 (Vaultkeeper Xir)
+(219014, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, '18950'), -- 219014 (Oathsworn Peacekeeper) - Invisibility and Stealth Detection
+(219055, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '397053 182641'); -- 219055 (Madam Goya) - Crafting Order Vendor Controller, Game Object Despawn Periodic
+
+-- Template
+UPDATE `creature_template` SET `faction`=3407, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=219313; -- Aredi
+UPDATE `creature_template` SET `faction`=3407, `npcflag`=131076, `BaseAttackTime`=2000, `unit_flags`=512, `unit_flags2`=2048 WHERE `entry`=219029; -- Counter Bardra
+UPDATE `creature_template` SET `faction`=35, `npcflag`=536870912, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=219054; -- Vaultkeeper Xir
+UPDATE `creature_template` SET `faction`=35, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=220564; -- Speakeasy Runeguard
+UPDATE `creature_template` SET `faction`=3407, `speed_run`=1, `BaseAttackTime`=2000, `unit_flags`=33555200, `unit_flags2`=67110912, `unit_flags3`=16777216, `VehicleId`=8307 WHERE `entry`=214838; -- Earthen Wagon
+UPDATE `creature_template` SET `faction`=35, `npcflag`=268435585, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=219053; -- Warpweaver Dezeeran
+UPDATE `creature_template` SET `faction`=3407, `npcflag`=128, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=219319; -- Yorda
+UPDATE `creature_template` SET `faction`=3407, `npcflag`=1125899906842625, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=219052; -- Wireweaver Grelka
+UPDATE `creature_template` SET `faction`=3407, `npcflag`=131076, `BaseAttackTime`=2000, `unit_flags`=512, `unit_flags2`=2048 WHERE `entry`=219023; -- Counter Targrin
+UPDATE `creature_template` SET `faction`=3407, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=219314; -- Trangad
+UPDATE `creature_template` SET `faction`=3407, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=229927; -- Unbound Crafter
+UPDATE `creature_template` SET `faction`=3407, `npcflag`=128, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=219316; -- Wurdin
+UPDATE `creature_template` SET `faction`=3407, `npcflag`=2097152, `BaseAttackTime`=1000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=219039; -- Auctioneer Zyrgas
+UPDATE `creature_template` SET `faction`=190, `BaseAttackTime`=2000, `unit_flags`=64, `unit_flags2`=2048, `unit_flags3`=67108864 WHERE `entry`=220300; -- Bandtail Kestrel
+UPDATE `creature_template` SET `faction`=3407, `npcflag`=4224, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=219321; -- Grotir
+UPDATE `creature_template` SET `faction`=3407, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=219142; -- Oathsworn Worker
+UPDATE `creature_template` SET `faction`=2092, `speed_run`=1, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=220796; -- Delver's Dirigible
+UPDATE `creature_template` SET `faction`=3407, `npcflag`=2097152, `BaseAttackTime`=1000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=219037; -- Auctioneer Durzin
+UPDATE `creature_template` SET `faction`=3407, `npcflag`=2097152, `BaseAttackTime`=1000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=219040; -- Auctioneer Prana
+UPDATE `creature_template` SET `faction`=3407, `npcflag`=128, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=219036; -- Ardgaz
+UPDATE `creature_template` SET `faction`=2092, `speed_run`=1, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048 WHERE `entry`=226696; -- Seasonal Delver's Dirigible
+UPDATE `creature_template` SET `faction`=3407, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=230031; -- Oathsworn Worker
+UPDATE `creature_template` SET `faction`=190, `BaseAttackTime`=2000, `unit_flags2`=2048, `unit_flags3`=67108864 WHERE `entry`=214772; -- Limestone Falcon
+UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags2`=2048, `unit_flags3`=67108864 WHERE `entry`=214824; -- Cart Hauler
+UPDATE `creature_template` SET `faction`=3407, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=219382; -- Unbound Trader
+UPDATE `creature_template` SET `faction`=35, `speed_run`=1, `BaseAttackTime`=2000, `unit_flags`=33555200, `unit_flags2`=67110912, `unit_flags3`=16777216 WHERE `entry`=227389; -- Earthen Crate
+UPDATE `creature_template` SET `faction`=188, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=219208; -- Dusty Mouse
+UPDATE `creature_template` SET `faction`=190, `BaseAttackTime`=2000, `unit_flags2`=2048, `unit_flags3`=67108864 WHERE `entry`=215070; -- Ashwhite Kestrel
+UPDATE `creature_template` SET `faction`=3409, `speed_run`=1, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=214948; -- Roaming Stormrook
+UPDATE `creature_template` SET `faction`=3408, `npcflag`=1, `speed_run`=1.428571462631225585, `BaseAttackTime`=2000, `unit_flags`=64, `unit_flags2`=2048, `unit_flags3`=8388608 WHERE `entry`=219014; -- Oathsworn Peacekeeper
+UPDATE `creature_template` SET `faction`=90, `speed_run`=0.857142865657806396, `BaseAttackTime`=1940, `unit_flags3`=16777216 WHERE `entry`=143622; -- Wild Imp
+UPDATE `creature_template` SET `faction`=3407, `npcflag`=4224, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=219065; -- Grundaz
+UPDATE `creature_template` SET `faction`=3407, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=219160; -- Hargrin
+UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=219079; -- Relorin Lighthand
+UPDATE `creature_template` SET `faction`=3407, `npcflag`=128, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=219312; -- Gorenda
+UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags2`=2048, `unit_flags3`=1073741824 WHERE `entry`=219162; -- Edmond Smith
+UPDATE `creature_template` SET `faction`=35, `npcflag`=2147483648, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=219055; -- Madam Goya
+UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=219056; -- Mister Chu
+UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=220673; -- Jade Quilen Statue
+UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=768, `unit_flags2`=2048, `unit_flags3`=67108864 WHERE `entry`=219195; -- Giant Sewer Rat
+UPDATE `creature_template` SET `faction`=3407, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry` IN (226418, 226419); -- Steelvein Trader
+UPDATE `creature_template` SET `faction`=35, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=219063; -- Ms. Xiulan
+UPDATE `creature_template` SET `faction`=3407, `npcflag`=128, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=219311; -- Kordan
+UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=219159; -- Displaced Rogue
+UPDATE `creature_template` SET `faction`=35, `npcflag`=128, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=219197; -- Griftah
+UPDATE `creature_template` SET `faction`=35, `npcflag`=16777216, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=219209; -- Tiny Sewer Rat
+
+-- Difficulty
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `StaticFlags1`=268435456, `VerifiedBuild`=56421 WHERE (`Entry`=219313 AND `DifficultyID`=0); -- 219313 (Aredi) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `StaticFlags1`=268435456, `VerifiedBuild`=56421 WHERE (`Entry`=219029 AND `DifficultyID`=0); -- 219029 (Counter Bardra) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `StaticFlags1`=268435456, `VerifiedBuild`=56421 WHERE (`Entry`=219054 AND `DifficultyID`=0); -- 219054 (Vaultkeeper Xir) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2797, `StaticFlags1`=268435456, `StaticFlags3`=33554432, `VerifiedBuild`=56421 WHERE (`Entry`=220564 AND `DifficultyID`=0); -- 220564 (Speakeasy Runeguard) - CanSwim - CannotTurn
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `StaticFlags1`=268435456, `VerifiedBuild`=56421 WHERE (`Entry`=219053 AND `DifficultyID`=0); -- 219053 (Warpweaver Dezeeran) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `StaticFlags1`=268435456, `VerifiedBuild`=56421 WHERE (`Entry`=219319 AND `DifficultyID`=0); -- 219319 (Yorda) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `StaticFlags1`=268435456, `VerifiedBuild`=56421 WHERE (`Entry`=219052 AND `DifficultyID`=0); -- 219052 (Wireweaver Grelka) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `StaticFlags1`=268435456, `VerifiedBuild`=56421 WHERE (`Entry`=219023 AND `DifficultyID`=0); -- 219023 (Counter Targrin) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `StaticFlags1`=268435456, `VerifiedBuild`=56421 WHERE (`Entry`=219314 AND `DifficultyID`=0); -- 219314 (Trangad) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `StaticFlags1`=268435456, `VerifiedBuild`=56421 WHERE (`Entry`=229927 AND `DifficultyID`=0); -- 229927 (Unbound Crafter) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `StaticFlags1`=268435456, `VerifiedBuild`=56421 WHERE (`Entry`=219316 AND `DifficultyID`=0); -- 219316 (Wurdin) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `VerifiedBuild`=56421 WHERE (`Entry`=219039 AND `DifficultyID`=0); -- 219039 (Auctioneer Zyrgas) - 
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2797, `StaticFlags1`=805306368, `VerifiedBuild`=56421 WHERE (`Entry`=220300 AND `DifficultyID`=0); -- 220300 (Bandtail Kestrel) - CanSwim, Floating
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `StaticFlags1`=268435456, `VerifiedBuild`=56421 WHERE (`Entry`=219321 AND `DifficultyID`=0); -- 219321 (Grotir) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `StaticFlags1`=268435456, `VerifiedBuild`=56421 WHERE (`Entry`=219142 AND `DifficultyID`=0); -- 219142 (Oathsworn Worker) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2145, `VerifiedBuild`=56421 WHERE (`Entry`=220796 AND `DifficultyID`=0); -- 220796 (Delver's Dirigible) - 
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `VerifiedBuild`=56421 WHERE (`Entry`=219037 AND `DifficultyID`=0); -- 219037 (Auctioneer Durzin) - 
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `VerifiedBuild`=56421 WHERE (`Entry`=219040 AND `DifficultyID`=0); -- 219040 (Auctioneer Prana) - 
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `StaticFlags1`=268435456, `VerifiedBuild`=56421 WHERE (`Entry`=219036 AND `DifficultyID`=0); -- 219036 (Ardgaz) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2145, `VerifiedBuild`=56421 WHERE (`Entry`=226696 AND `DifficultyID`=0); -- 226696 (Seasonal Delver's Dirigible) - 
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `StaticFlags1`=268435456, `VerifiedBuild`=56421 WHERE (`Entry`=219382 AND `DifficultyID`=0); -- 219382 (Unbound Trader) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=81, `StaticFlags1`=268435456, `VerifiedBuild`=56421 WHERE (`Entry`=219208 AND `DifficultyID`=0); -- 219208 (Dusty Mouse) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `StaticFlags1`=268435456, `VerifiedBuild`=56461 WHERE (`Entry`=219065 AND `DifficultyID`=0); -- 219065 (Grundaz) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `StaticFlags1`=268435456, `VerifiedBuild`=56461 WHERE (`Entry`=219160 AND `DifficultyID`=0); -- 219160 (Hargrin) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `StaticFlags1`=268435456, `VerifiedBuild`=56461 WHERE (`Entry`=219079 AND `DifficultyID`=0); -- 219079 (Relorin Lighthand) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `StaticFlags1`=268435456, `VerifiedBuild`=56461 WHERE (`Entry`=219312 AND `DifficultyID`=0); -- 219312 (Gorenda) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2462, `StaticFlags1`=536870912, `StaticFlags3`=256, `VerifiedBuild`=56461 WHERE (`Entry`=224318 AND `DifficultyID`=0); -- 224318 (Tunnel to Azj-Kahet) - Floating - CannotSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `StaticFlags1`=805306624, `VerifiedBuild`=56461 WHERE (`Entry`=219162 AND `DifficultyID`=0); -- 219162 (Edmond Smith) - Sessile, CanSwim, Floating
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `StaticFlags1`=268435456, `VerifiedBuild`=56461 WHERE (`Entry`=219055 AND `DifficultyID`=0); -- 219055 (Madam Goya) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `StaticFlags1`=268435456, `VerifiedBuild`=56461 WHERE (`Entry`=219056 AND `DifficultyID`=0); -- 219056 (Mister Chu) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2829, `StaticFlags1`=268435456, `VerifiedBuild`=56461 WHERE (`Entry`=228001 AND `DifficultyID`=0); -- 228001 (Nipper) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2797, `StaticFlags1`=268435456, `VerifiedBuild`=56461 WHERE (`Entry`=220673 AND `DifficultyID`=0); -- 220673 (Jade Quilen Statue) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `StaticFlags1`=268435456, `VerifiedBuild`=56461 WHERE (`Entry`=219195 AND `DifficultyID`=0); -- 219195 (Giant Sewer Rat) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `StaticFlags1`=268435456, `VerifiedBuild`=56461 WHERE (`Entry`=226418 AND `DifficultyID`=0); -- 226418 (Steelvein Trader) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `StaticFlags1`=268435456, `VerifiedBuild`=56461 WHERE (`Entry`=226419 AND `DifficultyID`=0); -- 226419 (Steelvein Trader) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `StaticFlags1`=268435456, `VerifiedBuild`=56461 WHERE (`Entry`=219063 AND `DifficultyID`=0); -- 219063 (Ms. Xiulan) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `StaticFlags1`=268435456, `VerifiedBuild`=56461 WHERE (`Entry`=219311 AND `DifficultyID`=0); -- 219311 (Kordan) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `StaticFlags1`=268435456, `VerifiedBuild`=56461 WHERE (`Entry`=219159 AND `DifficultyID`=0); -- 219159 (Displaced Rogue) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=2734, `StaticFlags1`=268435456, `VerifiedBuild`=56461 WHERE (`Entry`=219197 AND `DifficultyID`=0); -- 219197 (Griftah) - CanSwim
+UPDATE `creature_template_difficulty` SET `ContentTuningID`=81, `StaticFlags1`=268435456, `VerifiedBuild`=56461 WHERE (`Entry`=219209 AND `DifficultyID`=0); -- 219209 (Tiny Sewer Rat) - CanSwim
+
+-- Model Info
+DELETE FROM `creature_model_info` WHERE `DisplayID`=120822;
+INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`) VALUES
+(120822, 0.347000002861022949, 1.5, 0, 56461);
+
+UPDATE `creature_model_info` SET `VerifiedBuild`=56461 WHERE `DisplayID` IN (117714, 117683, 117712, 117716, 117708, 117721, 117775, 117715, 121434, 117691, 117720, 120821, 121435, 117719, 117774, 117713, 4959, 82235);
+
+-- Spellclick
+DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` = 219209;
+INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES
+(219209, 438887, 1, 0);
+
+-- Vendor
+DELETE FROM `npc_vendor` WHERE (`entry`=219312 AND `item`=227317 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219312 AND `item`=227318 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219312 AND `item`=227310 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219312 AND `item`=227309 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219311 AND `item`=227701 AND `ExtendedCost`=9121 AND `type`=1) OR (`entry`=219311 AND `item`=227700 AND `ExtendedCost`=9121 AND `type`=1) OR (`entry`=219311 AND `item`=227699 AND `ExtendedCost`=9121 AND `type`=1) OR (`entry`=219197 AND `item`=224763 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219197 AND `item`=228921 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219197 AND `item`=201410 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219197 AND `item`=74918 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219197 AND `item`=199177 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219197 AND `item`=202046 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219197 AND `item`=27940 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219197 AND `item`=200271 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219197 AND `item`=200269 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219197 AND `item`=200268 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219197 AND `item`=200265 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219197 AND `item`=27978 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219065 AND `item`=188152 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219065 AND `item`=64670 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219065 AND `item`=138293 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219065 AND `item`=85663 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219065 AND `item`=2901 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219065 AND `item`=7005 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219065 AND `item`=39505 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219065 AND `item`=6256 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219065 AND `item`=10498 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219065 AND `item`=6219 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219065 AND `item`=20815 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219065 AND `item`=6218 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219065 AND `item`=5956 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219065 AND `item`=222701 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219065 AND `item`=222700 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219065 AND `item`=222699 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219065 AND `item`=222697 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219065 AND `item`=222696 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219065 AND `item`=222695 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219065 AND `item`=224764 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219065 AND `item`=38682 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219065 AND `item`=200860 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219065 AND `item`=211806 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=219316 AND `item`=228723 AND `ExtendedCost`=0 AND `type`=1);
+INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES
+(219312, 4, 227317, 0, 0, 1, 0, 0, 56461), -- Lava Cola
+(219312, 3, 227318, 0, 0, 1, 0, 0, 56461), -- Quicksilver Sipper
+(219312, 2, 227310, 0, 0, 1, 0, 0, 56461), -- Magmalaid
+(219312, 1, 227309, 0, 0, 1, 0, 0, 56461), -- Titanshake
+(219311, 3, 227701, 0, 9121, 1, 0, 0, 56461), -- Preserved Defender's Kris
+(219311, 2, 227700, 0, 9121, 1, 0, 0, 56461), -- Preserved Defender's Spear
+(219311, 1, 227699, 0, 9121, 1, 0, 0, 56461), -- Earthen Ceremonial Chopper
+(219197, 12, 224763, 0, 0, 1, 0, 0, 56461), -- Design: Cubic Blasphemia
+(219197, 11, 228921, 0, 0, 1, 0, 0, 56461), -- Griftah's Heavy-Duty Embellishing Powder
+(219197, 10, 201410, 0, 0, 1, 0, 0, 56461), -- Powerful Purple Thing
+(219197, 9, 74918, 0, 0, 1, 0, 0, 56461), -- Problem Solving Pendant
+(219197, 8, 199177, 0, 0, 1, 0, 0, 56461), -- Ash Feather Amulet
+(219197, 7, 202046, 0, 0, 1, 0, 0, 56461), -- Lucky Tortollan Charm
+(219197, 6, 27940, 0, 0, 1, 0, 0, 56461), -- Marvelous Madstone of Immortality
+(219197, 5, 200271, 0, 0, 1, 0, 0, 56461), -- Infallible Hornswog Ward
+(219197, 4, 200269, 0, 0, 1, 0, 0, 56461), -- Talisman of the Dragon Hoard
+(219197, 3, 200268, 0, 0, 1, 0, 0, 56461), -- Crumbling Elemental Stone
+(219197, 2, 200265, 0, 0, 1, 0, 0, 56461), -- Lucky Dragon's Claw
+(219197, 1, 27978, 0, 0, 1, 0, 0, 56461), -- Soap on a Rope
+(219065, 23, 188152, 0, 0, 1, 0, 0, 56461), -- Gateway Control Shard
+(219065, 22, 64670, 0, 0, 1, 0, 0, 56461), -- Vanishing Powder
+(219065, 21, 138293, 0, 0, 1, 0, 0, 56461), -- Explorer's Pack
+(219065, 20, 85663, 0, 0, 1, 0, 0, 56461), -- Herbalist's Spade
+(219065, 19, 2901, 0, 0, 1, 0, 0, 56461), -- Mining Pick
+(219065, 18, 7005, 0, 0, 1, 0, 0, 56461), -- Skinning Knife
+(219065, 17, 39505, 0, 0, 1, 0, 0, 56461), -- Virtuoso Inking Set
+(219065, 16, 6256, 0, 0, 1, 0, 0, 56461), -- Fishing Pole
+(219065, 15, 10498, 0, 0, 1, 0, 0, 56461), -- Gyromatic Micro-Adjustor
+(219065, 14, 6219, 0, 0, 1, 0, 0, 56461), -- Arclight Spanner
+(219065, 13, 20815, 0, 0, 1, 0, 0, 56461), -- Jeweler's Toolset
+(219065, 12, 6218, 0, 0, 1, 0, 0, 56461), -- Runed Copper Rod
+(219065, 11, 5956, 0, 0, 1, 0, 0, 56461), -- Blacksmith Hammer
+(219065, 10, 222701, 0, 0, 1, 0, 0, 56461), -- Clumped Flour
+(219065, 9, 222700, 0, 0, 1, 0, 0, 56461), -- Granulated Spices
+(219065, 8, 222699, 0, 0, 1, 0, 0, 56461), -- Khaz Algar Tomato
+(219065, 7, 222697, 0, 0, 1, 0, 0, 56461), -- Coreway Dust
+(219065, 6, 222696, 0, 0, 1, 0, 0, 56461), -- Crunchy Peppers
+(219065, 5, 222695, 0, 0, 1, 0, 0, 56461), -- Twined Herbs
+(219065, 4, 224764, 0, 0, 1, 0, 0, 56461), -- Mosswool Thread
+(219065, 3, 38682, 0, 0, 1, 0, 0, 56461), -- Enchanting Vellum
+(219065, 2, 200860, 0, 0, 1, 0, 0, 56461), -- Draconic Stopper
+(219065, 1, 211806, 0, 0, 1, 0, 0, 56461), -- Gilded Vial
+(219316, 1, 228723, 0, 0, 1, 0, 0, 56461); -- Earthen Pet Rock
+
+-- Gossip
+DELETE FROM `creature_template_gossip` WHERE (`CreatureID`=219052 AND `MenuID` = 35474) OR (`CreatureID`=219063 AND `MenuID`=33103);
+INSERT INTO `creature_template_gossip` (`CreatureID`, `MenuID`, `VerifiedBuild`) VALUES
+(219052, 35474, 56461), -- Wireweaver Grelka
+(219063, 33103, 56461); -- Ms. Xiulan
+
+DELETE FROM `npc_text` WHERE `ID` BETWEEN @NPCTEXTID+0 AND @NPCTEXTID+2;
+INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES
+(@NPCTEXTID+0, 1, 0, 0, 0, 0, 0, 0, 0, 267826, 0, 0, 0, 0, 0, 0, 0, 56461), -- 219052 (Wireweaver Grelka)
+(@NPCTEXTID+1, 1, 0, 0, 0, 0, 0, 0, 0, 267830, 0, 0, 0, 0, 0, 0, 0, 56461), -- 219052 (Wireweaver Grelka)
+(@NPCTEXTID+2, 1, 0, 0, 0, 0, 0, 0, 0, 251360, 0, 0, 0, 0, 0, 0, 0, 56461); -- 219063 (Ms. Xiulan)
+
+DELETE FROM `gossip_menu` WHERE (`MenuID`=35474 AND `TextID`=@NPCTEXTID+0) OR (`MenuID`=35475 AND `TextID`=@NPCTEXTID+1) OR (`MenuID`=33103 AND `TextID`=@NPCTEXTID+2);
+INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES
+(35474, @NPCTEXTID+0, 56461), -- 219052 (Wireweaver Grelka)
+(35475, @NPCTEXTID+1, 56461), -- 219052 (Wireweaver Grelka)
+(33103, @NPCTEXTID+2, 56461); -- 219063 (Ms. Xiulan)
+
+DELETE FROM `gossip_menu_option` WHERE (`MenuID`=35474 AND `OptionID`=0);
+INSERT INTO `gossip_menu_option` (`MenuID`, `GossipOptionID`, `OptionID`, `OptionNpc`, `OptionText`, `OptionBroadcastTextID`, `Language`, `Flags`, `ActionMenuID`, `ActionPoiID`, `GossipNpcOptionID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `SpellID`, `OverrideIconID`, `VerifiedBuild`) VALUES
+(35474, 123209, 0, 0, 'Does your hair--er, wire, actually grow?', 0, 0, 0, 35475, 0, NULL, 0, 0, NULL, 0, NULL, NULL, 56461);