DB/Misc: Added spawns for voidelf start zone

By Naddley and modox.
Closes #26892 closes #26893

1 files changed, 550 insertions, 0 deletions

diff --git a/sql/updates/world/master/2021_09_21_00_world.sql b/sql/updates/world/master/2021_09_21_00_world.sql
new file mode 100644
index 00000000000..b7842fae7cc
--- /dev/null
+++ b/sql/updates/world/master/2021_09_21_00_world.sql
@@ -0,0 +1,550 @@
+
+SET @CGUID := 650000;
+SET @OGUID := 400000;
+
+-- creature_template
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=2501, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=132627; -- Void Initiate
+UPDATE `creature_template` SET `minlevel`=45, `maxlevel`=45, `faction`=14, `BaseAttackTime`=2000, `unit_flags`=33554688, `unit_flags2`=67667968 WHERE `entry`=133011; -- Rampant Shadow
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=2501, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=132632; -- Instructor Duskwalker
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `BaseAttackTime`=2000, `unit_flags`=33536, `unit_flags2`=4196352 WHERE `entry`=133422; -- Shadreen
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `BaseAttackTime`=2000, `unit_flags`=33554432, `unit_flags2`=4196352 WHERE `entry`=132730; -- Voidstorm Visual Bunny
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `BaseAttackTime`=2000, `unit_flags`=33554432, `unit_flags2`=2048 WHERE `entry`=132397; -- Void Suppression Visual Bunny
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=2501, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=132386; -- Rift Warden
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `npcflag`=3, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=131345; -- Alleria Windrunner
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=2774, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=132407; -- Umbral Ranger
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=2501, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=33556480 WHERE `entry`=132382; -- Magister Umbric
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `speed_walk`=0.400000005960464477, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=132400; -- Curious Voidstalker
+UPDATE `creature_template` SET `faction`=190, `BaseAttackTime`=2000, `unit_flags2`=2048 WHERE `entry`=132970; -- Nascent Voidling
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `npcflag`=65537, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=132657; -- Atynar
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=2501, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=132616; -- Silvermoon Scholar
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `npcflag`=4224, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=132705; -- Danessa
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=2774, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=132659; -- Veiled Riftblade
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=2774, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=132648; -- Veiled Riftblade
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=2501, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=132671; -- High Elf Wayfarer
+UPDATE `creature_template` SET `gossip_menu_id`=22068, `minlevel`=60, `maxlevel`=60, `faction`=2501, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=126773; -- Locus-Walker
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=2774, `speed_walk`=0.400000005960464477, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=2048 WHERE `entry`=132676; -- Voidstalker
+UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60, `faction`=2501, `npcflag`=1, `BaseAttackTime`=2000, `unit_flags`=32768, `unit_flags2`=34816 WHERE `entry`=132385; -- Locus Researcher
+
+UPDATE `creature_template` SET `gossip_menu_id`=22070 WHERE `entry`=132671; -- High Elf Wayfarer
+UPDATE `creature_template` SET `gossip_menu_id`=22066 WHERE `entry`=132382; -- Magister Umbric
+UPDATE `creature_template` SET `gossip_menu_id`=22067 WHERE `entry`=131345; -- Alleria Windrunner
+UPDATE `creature_template` SET `gossip_menu_id`=7288 WHERE `entry`=132657; -- Atynar
+UPDATE `creature_template` SET `gossip_menu_id`=22080 WHERE `entry`=132648; -- Veiled Riftblade
+UPDATE `creature_template` SET `gossip_menu_id`=22068 WHERE `entry`=126773; -- Locus-Walker
+UPDATE `creature_template` SET `gossip_menu_id`=22080 WHERE `entry`=132659; -- Veiled Riftblade
+UPDATE `creature_template` SET `gossip_menu_id`=22070 WHERE `entry`=132616; -- Silvermoon Scholar
+UPDATE `creature_template` SET `gossip_menu_id`=22086, `unit_flags2`=2048 WHERE `entry`=132385; -- Locus Researcher
+UPDATE `creature_template` SET `gossip_menu_id`=22107 WHERE `entry`=132632; -- Instructor Duskwalker
+UPDATE `creature_template` SET `gossip_menu_id`=22089, `npcflag`=1 WHERE `entry`=132386; -- Rift Warden
+
+-- creature
+DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+69;
+INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
+(@CGUID+0, 132970, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2093.801025390625, 3268.243896484375, 53.267120361328125, 1.584842920303344726, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 40000), -- 132970 (Area: 9415 - Difficulty: 0) (possible waypoints or random movement)
+(@CGUID+1, 126773, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2066.685791015625, 3288.502685546875, 58.43724822998046875, 1.660136818885803222, 7200, 0, 0, 353730, 100, 0, 0, 0, 0, 40000), -- 126773 (Area: 9415 - Difficulty: 0)
+(@CGUID+2, 132385, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2100.17529296875, 3301.45654296875, 53.71509933471679687, 4.794808387756347656, 7200, 0, 0, 9433, 5751, 0, 0, 0, 0, 40000), -- 132385 (Area: 9415 - Difficulty: 0) (Auras: 260888 - 260888)
+(@CGUID+3, 132385, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2087.494873046875, 3285.0869140625, 55.46343994140625, 0.287531912326812744, 7200, 0, 0, 9433, 5751, 0, 0, 0, 0, 40000), -- 132385 (Area: 9415 - Difficulty: 0) (Auras: 260888 - 260888)
+(@CGUID+4, 132616, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2108.291748046875, 3360.334228515625, 58.51019287109375, 2.734210014343261718, 7200, 0, 0, 9433, 5751, 0, 0, 0, 0, 40000), -- 132616 (Area: 9415 - Difficulty: 0)
+(@CGUID+5, 132616, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2104.382080078125, 3360.994873046875, 58.35615921020507812, 5.917802810668945312, 7200, 0, 0, 9433, 5751, 0, 0, 0, 0, 40000), -- 132616 (Area: 9415 - Difficulty: 0)
+(@CGUID+6, 132400, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2145.373291015625, 3289.123291015625, 63.90410995483398437, 3.926990985870361328, 7200, 10, 0, 2948, 0, 1, 0, 0, 0, 40000), -- 132400 (Area: 9415 - Difficulty: 0) (possible waypoints or random movement)
+(@CGUID+7, 132400, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2127.89208984375, 3356.01416015625, 62.54990005493164062, 2.456208705902099609, 7200, 0, 0, 2948, 0, 0, 0, 0, 0, 40000), -- 132400 (Area: 9415 - Difficulty: 0)
+(@CGUID+8, 132970, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2069.656982421875, 3383.002197265625, 57.51847076416015625, 3.137434244155883789, 7200, 10, 0, 5, 0, 1, 0, 0, 0, 40000), -- 132970 (Area: 9415 - Difficulty: 0) (possible waypoints or random movement)
+(@CGUID+9, 132648, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2065.947998046875, 3321.10498046875, 56.7400665283203125, 0.116367354989051818, 7200, 0, 0, 11791, 2434, 0, 0, 0, 0, 40000), -- 132648 (Area: 9415 - Difficulty: 0) (Auras: )
+(@CGUID+10, 132970, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2102.975830078125, 3399.3134765625, 53.3644256591796875, 3.376831531524658203, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 40000), -- 132970 (Area: 9415 - Difficulty: 0)
+(@CGUID+11, 131345, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2138.361083984375, 3319.132080078125, 55.03425216674804687, 3.620402097702026367, 7200, 0, 0, 176865, 1500, 0, 0, 0, 0, 40000), -- 131345 (Area: 9415 - Difficulty: 0)
+(@CGUID+12, 132616, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2060.255126953125, 3296.22216796875, 58.4375, 5.41023111343383789, 7200, 0, 0, 9433, 5751, 0, 0, 0, 0, 40000), -- 132616 (Area: 9415 - Difficulty: 0)
+(@CGUID+13, 132616, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2102.197998046875, 3382.31689453125, 58.27863311767578125, 2.881384849548339843, 7200, 0, 0, 9433, 5751, 0, 0, 0, 0, 40000), -- 132616 (Area: 9415 - Difficulty: 0)
+(@CGUID+14, 132648, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2128.458251953125, 3296.829833984375, 55.7786102294921875, 0.876535236835479736, 7200, 0, 0, 11791, 2434, 0, 0, 0, 0, 40000), -- 132648 (Area: 9415 - Difficulty: 0) (Auras: )
+(@CGUID+15, 132648, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2160.98095703125, 3313.3056640625, 55.28152084350585937, 2.553715705871582031, 7200, 0, 0, 11791, 2434, 0, 0, 0, 0, 40000), -- 132648 (Area: 9415 - Difficulty: 0) (Auras: )
+(@CGUID+16, 132386, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2089.576416015625, 3304.283935546875, 55.61410140991210937, 5.338119029998779296, 7200, 10, 0, 9433, 5751, 1, 0, 0, 0, 40000), -- 132386 (Area: 9415 - Difficulty: 0) (possible waypoints or random movement)
+(@CGUID+17, 132705, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2111.026123046875, 3340.65625, 56.90955734252929687, 3.524914264678955078, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40000), -- 132705 (Area: 9415 - Difficulty: 0)
+(@CGUID+18, 132671, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2063.845458984375, 3295.552001953125, 58.43724822998046875, 4.927199363708496093, 7200, 0, 0, 9433, 5751, 0, 0, 0, 0, 40000), -- 132671 (Area: 9415 - Difficulty: 0)
+(@CGUID+19, 132676, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2036.9678955078125, 3277.87255859375, 59.36427688598632812, 1.527870655059814453, 7200, 10, 0, 11791, 0, 1, 0, 0, 0, 40000), -- 132676 (Area: 9415 - Difficulty: 0) (possible waypoints or random movement)
+(@CGUID+20, 132648, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2067.40283203125, 3356.729248046875, 56.99066543579101562, 3.755258083343505859, 7200, 0, 0, 11791, 2434, 0, 0, 0, 0, 40000), -- 132648 (Area: 9415 - Difficulty: 0) (Auras: )
+(@CGUID+21, 132407, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2088.166748046875, 3248.010498046875, 75.2839508056640625, 2.455939531326293945, 7200, 0, 0, 11791, 2434, 0, 0, 0, 0, 40000), -- 132407 (Area: 9415 - Difficulty: 0) (Auras: )
+(@CGUID+22, 132659, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2087.050048828125, 3312.6572265625, 55.68055343627929687, 2.75619053840637207, 7200, 0, 0, 17687, 2434, 0, 0, 0, 0, 40000), -- 132659 (Area: 9415 - Difficulty: 0) (Auras: )
+(@CGUID+23, 132659, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2128.970458984375, 3331.278564453125, 55.04636001586914062, 4.070834636688232421, 7200, 0, 0, 17687, 2434, 0, 0, 0, 0, 40000), -- 132659 (Area: 9415 - Difficulty: 0) (Auras: )
+(@CGUID+24, 132407, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2127.663330078125, 3389.028564453125, 74.507232666015625, 3.704462289810180664, 7200, 0, 0, 11791, 2434, 0, 0, 0, 0, 40000), -- 132407 (Area: 9415 - Difficulty: 0) (Auras: )
+(@CGUID+25, 132616, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2098.842041015625, 3381.713623046875, 58.21001434326171875, 0.501430094242095947, 7200, 0, 0, 9433, 5751, 0, 0, 0, 0, 40000), -- 132616 (Area: 9415 - Difficulty: 0)
+(@CGUID+26, 132659, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2129.71533203125, 3299.736083984375, 56.02498245239257812, 4.904619216918945312, 7200, 0, 0, 17687, 2434, 0, 0, 0, 0, 40000), -- 132659 (Area: 9415 - Difficulty: 0) (Auras: )
+(@CGUID+27, 132970, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2083.228515625, 3395.840087890625, 53.60660552978515625, 5.968535900115966796, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 40000), -- 132970 (Area: 9415 - Difficulty: 0)
+(@CGUID+28, 132970, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2084.448974609375, 3297.544189453125, 55.195831298828125, 2.488246917724609375, 7200, 0, 0, 5, 0, 0, 0, 0, 0, 40000), -- 132970 (Area: 9415 - Difficulty: 0)
+(@CGUID+29, 132676, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2127.401123046875, 3390.81591796875, 74.4622344970703125, 3.781807184219360351, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40000), -- 132676 (Area: 9415 - Difficulty: 0)
+(@CGUID+30, 132385, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2112.401123046875, 3295.848876953125, 53.93426513671875, 3.982182025909423828, 7200, 0, 0, 9433, 5751, 0, 0, 0, 0, 40000), -- 132385 (Area: 9415 - Difficulty: 0) (Auras: 260888 - 260888)
+(@CGUID+31, 132616, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2067.335205078125, 3295.760498046875, 58.484375, 4.566042900085449218, 7200, 0, 0, 9433, 5751, 0, 0, 0, 0, 40000), -- 132616 (Area: 9415 - Difficulty: 0)
+(@CGUID+32, 132616, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2100.201416015625, 3383.9921875, 58.22832489013671875, 5.072414875030517578, 7200, 0, 0, 9433, 5751, 0, 0, 0, 0, 40000), -- 132616 (Area: 9415 - Difficulty: 0)
+(@CGUID+33, 132648, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2131.8525390625, 3297.482666015625, 55.88489532470703125, 2.732207298278808593, 7200, 0, 0, 11791, 2434, 0, 0, 0, 0, 40000), -- 132648 (Area: 9415 - Difficulty: 0) (Auras: )
+(@CGUID+34, 132648, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2085.177001953125, 3379.760498046875, 58.96516036987304687, 4.963398456573486328, 7200, 0, 0, 11791, 2434, 0, 0, 0, 0, 40000), -- 132648 (Area: 9415 - Difficulty: 0) (Auras: )
+(@CGUID+35, 132382, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2138.875, 3317.006103515625, 55.03580093383789062, 3.035698890686035156, 7200, 0, 0, 47165, 5751, 0, 0, 0, 0, 40000), -- 132382 (Area: 9415 - Difficulty: 0)
+(@CGUID+36, 132671, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2061.286376953125, 3291.822021484375, 58.43891525268554687, 5.769347667694091796, 7200, 0, 0, 9433, 5751, 0, 0, 0, 0, 40000), -- 132671 (Area: 9415 - Difficulty: 0)
+(@CGUID+37, 132648, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2062.553955078125, 3365.827392578125, 56.5369720458984375, 3.996781587600708007, 7200, 0, 0, 11791, 2434, 0, 0, 0, 0, 40000), -- 132648 (Area: 9415 - Difficulty: 0) (Auras: )
+(@CGUID+38, 132407, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2038.9842529296875, 3277.73046875, 59.2404937744140625, 1.539597272872924804, 7200, 10, 0, 11791, 2434, 1, 0, 0, 0, 40000), -- 132407 (Area: 9415 - Difficulty: 0) (Auras: ) (possible waypoints or random movement)
+(@CGUID+39, 132397, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2102.567626953125, 3285.864501953125, 53.87302780151367187, 0, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40000), -- 132397 (Area: 9415 - Difficulty: 0) (Auras: )
+(@CGUID+40, 132400, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2089.501708984375, 3346.94189453125, 67.485107421875, 5.271542549133300781, 7200, 0, 0, 2948, 0, 0, 0, 0, 0, 40000), -- 132400 (Area: 9415 - Difficulty: 0)
+(@CGUID+41, 132659, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2163.522705078125, 3326.7509765625, 54.5111541748046875, 3.447463512420654296, 7200, 0, 0, 17687, 2434, 0, 0, 0, 0, 40000), -- 132659 (Area: 9415 - Difficulty: 0) (Auras: )
+(@CGUID+42, 132657, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2111.598876953125, 3369.264892578125, 58.50302505493164062, 2.872334241867065429, 7200, 0, 0, 11791, 2434, 0, 0, 0, 0, 40000), -- 132657 (Area: 9415 - Difficulty: 0)
+(@CGUID+43, 132407, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2182.725830078125, 3298.764892578125, 86.83847808837890625, 2.560807228088378906, 7200, 0, 0, 11791, 2434, 0, 0, 0, 0, 40000), -- 132407 (Area: 9415 - Difficulty: 0) (Auras: )
+(@CGUID+44, 132676, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2089.4306640625, 3248.932373046875, 75.41204833984375, 2.482355833053588867, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40000), -- 132676 (Area: 9415 - Difficulty: 0)
+(@CGUID+45, 132659, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2069.017333984375, 3342.96875, 58.41061782836914062, 3.298889636993408203, 7200, 0, 0, 17687, 2434, 0, 0, 0, 0, 40000), -- 132659 (Area: 9415 - Difficulty: 0) (Auras: )
+(@CGUID+46, 132407, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2036.197998046875, 3386.74951171875, 51.6214447021484375, 1.558592677116394042, 7200, 10, 0, 11791, 2434, 1, 0, 0, 0, 40000), -- 132407 (Area: 9415 - Difficulty: 0) (Auras: ) (possible waypoints or random movement)
+(@CGUID+47, 132676, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2038.237548828125, 3386.3291015625, 52.32087326049804687, 1.59211742877960205, 7200, 10, 0, 11791, 0, 1, 0, 0, 0, 40000), -- 132676 (Area: 9415 - Difficulty: 0) (possible waypoints or random movement)
+(@CGUID+48, 132407, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2082.81591796875, 3420.571044921875, 74.7094268798828125, 3.921868324279785156, 7200, 0, 0, 11791, 2434, 0, 0, 0, 0, 40000), -- 132407 (Area: 9415 - Difficulty: 0) (Auras: )
+(@CGUID+49, 132400, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2020.6148681640625, 3311.888916015625, 52.42333602905273437, 3.894581317901611328, 7200, 10, 0, 2948, 0, 1, 0, 0, 0, 40000), -- 132400 (Area: 9415 - Difficulty: 0) (possible waypoints or random movement)
+(@CGUID+50, 132400, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2067.896240234375, 3402.9951171875, 71.61466217041015625, 4.184472084045410156, 7200, 0, 0, 2948, 0, 0, 0, 0, 0, 40000), -- 132400 (Area: 9415 - Difficulty: 0)
+(@CGUID+51, 132386, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2061.73095703125, 3400.518310546875, 55.67570114135742187, 5.164243698120117187, 7200, 0, 0, 9433, 5751, 0, 0, 0, 0, 40000), -- 132386 (Area: 9415 - Difficulty: 0)
+(@CGUID+52, 132730, 1865, 9415, 9415, '0', '0', 0, 0, 0, 1755.0225830078125, 3115.11279296875, 26.2295379638671875, 0, 7200, 0, 0, 11791, 0, 0, 0, 0, 0, 40000), -- 132730 (Area: 9415 - Difficulty: 0) (Auras: 262605 - 262605)
+(@CGUID+53, 132400, 1865, 9415, 9415, '0', '0', 0, 0, 0, 2046.4788818359375, 3246.912841796875, 63.22140121459960937, 5.624480247497558593, 7200, 0, 0, 2948, 0, 0, 0, 0, 0, 40000), -- 132400 (Area: 9415 - Difficulty: 0)
+(@CGUID+54, 132400, 1865, 9415, 9531, '0', '0', 0, 0, 0, 1851.9326171875, 3285.454833984375, 99.08359527587890625, 0.44966861605644226, 7200, 0, 0, 2948, 0, 0, 0, 0, 0, 40000), -- 132400 (Area: 9531 - Difficulty: 0)
+(@CGUID+55, 132407, 1865, 9415, 9531, '0', '0', 0, 0, 0, 1910.404541015625, 3321.0869140625, 99.70343780517578125, 0.511330127716064453, 7200, 0, 0, 11791, 2434, 0, 0, 0, 0, 40000), -- 132407 (Area: 9531 - Difficulty: 0) (Auras: )
+(@CGUID+56, 132386, 1865, 9415, 9531, '0', '0', 0, 0, 0, 1898.2725830078125, 3328.8681640625, 98.51544189453125, 3.483804225921630859, 7200, 0, 0, 9433, 5751, 0, 0, 0, 0, 40000), -- 132386 (Area: 9531 - Difficulty: 0)
+(@CGUID+57, 132632, 1865, 9415, 9531, '0', '0', 0, 0, 0, 1870.8367919921875, 3320.295166015625, 96.41725921630859375, 4.584060192108154296, 7200, 0, 0, 47165, 5751, 0, 0, 0, 0, 40000), -- 132632 (Area: 9531 - Difficulty: 0) (Auras: 261666 - 261666)
+(@CGUID+58, 132627, 1865, 9415, 9531, '0', '0', 0, 0, 0, 1866.0208740234375, 3316.373291015625, 96.03749847412109375, 0.677931070327758789, 7200, 0, 0, 9433, 5751, 0, 0, 0, 0, 40000), -- 132627 (Area: 9531 - Difficulty: 0) (Auras: 261666 - 261666)
+(@CGUID+59, 132400, 1865, 9415, 9531, '0', '0', 0, 0, 0, 1866.857666015625, 3354.496826171875, 104.75, 5.527802467346191406, 7200, 0, 0, 2948, 0, 0, 0, 0, 0, 40000), -- 132400 (Area: 9531 - Difficulty: 0)
+(@CGUID+60, 132407, 1865, 9415, 9531, '0', '0', 0, 0, 0, 1887.6788330078125, 3281.5478515625, 101.7134628295898437, 5.131228446960449218, 7200, 0, 0, 11791, 2434, 0, 0, 0, 0, 40000), -- 132407 (Area: 9531 - Difficulty: 0) (Auras: )
+(@CGUID+61, 132400, 1865, 9415, 9531, '0', '0', 0, 0, 0, 1879.4979248046875, 3265.7666015625, 93.00585174560546875, 1.564995288848876953, 7200, 0, 0, 2948, 0, 0, 0, 0, 0, 40000), -- 132400 (Area: 9531 - Difficulty: 0)
+(@CGUID+62, 133011, 1865, 9415, 9531, '0', '0', 0, 0, 0, 1874.2899169921875, 3328.6650390625, 97.2993011474609375, 4.244513988494873046, 7200, 0, 0, 1456, 1534, 0, 0, 0, 0, 40000), -- 133011 (Area: 9531 - Difficulty: 0) (Auras: 211929 - 211929)
+(@CGUID+63, 132400, 1865, 9415, 9531, '0', '0', 0, 0, 0, 1912.7012939453125, 3279.434814453125, 78.44783782958984375, 5.874368667602539062, 7200, 0, 0, 2948, 0, 0, 0, 0, 0, 40000), -- 132400 (Area: 9531 - Difficulty: 0)
+(@CGUID+64, 132400, 1865, 9415, 9531, '0', '0', 0, 0, 0, 1926.8260498046875, 3347.119140625, 103.0895233154296875, 4.743458271026611328, 7200, 0, 0, 2948, 0, 0, 0, 0, 0, 40000), -- 132400 (Area: 9531 - Difficulty: 0)
+(@CGUID+65, 132385, 1865, 9415, 9531, '0', '0', 0, 0, 0, 1895.3228759765625, 3327.447021484375, 98.16204833984375, 1.00004732608795166, 7200, 0, 0, 9433, 5751, 0, 0, 0, 0, 40000), -- 132385 (Area: 9531 - Difficulty: 0)
+(@CGUID+66, 132407, 1865, 9415, 9531, '0', '0', 0, 0, 0, 1818.6981201171875, 3311.803955078125, 90.04522705078125, 0.812946915626525878, 7200, 0, 0, 11791, 2434, 0, 0, 0, 0, 40000), -- 132407 (Area: 9531 - Difficulty: 0) (Auras: )
+(@CGUID+67, 132386, 1865, 9415, 9531, '0', '0', 0, 0, 0, 1834.3524169921875, 3287.443603515625, 91.43531036376953125, 4.268019676208496093, 7200, 0, 0, 9433, 5751, 0, 0, 0, 0, 40000), -- 132386 (Area: 9531 - Difficulty: 0)
+(@CGUID+68, 132627, 1865, 9415, 9531, '0', '0', 0, 0, 0, 1871.513916015625, 3315.74658203125, 96.47585296630859375, 1.697870612144470214, 7200, 0, 0, 9433, 5751, 0, 0, 0, 0, 40000), -- 132627 (Area: 9531 - Difficulty: 0) (Auras: 261666 - 261666)
+(@CGUID+69, 132627, 1865, 9415, 9531, '0', '0', 0, 0, 0, 1873.953125, 3313.21435546875, 96.6637725830078125, 1.972912907600402832, 7200, 0, 0, 9433, 5751, 0, 0, 0, 0, 40000); -- 132627 (Area: 9531 - Difficulty: 0) (Auras: 261666 - 261666)
+
+-- creature addon
+DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+69;
+INSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES
+(@CGUID+0, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 132970
+(@CGUID+1, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 126773
+(@CGUID+2, 0, 0, 0, 257, 0, 0, 0, 0, '260888'), -- 132385 - 260888 - 260888
+(@CGUID+3, 0, 0, 0, 257, 0, 0, 0, 0, '260888'), -- 132385 - 260888 - 260888
+(@CGUID+4, 0, 0, 1, 257, 0, 0, 0, 0, ''), -- 132616
+(@CGUID+5, 0, 0, 0, 257, 0, 0, 0, 0, ''), -- 132616
+(@CGUID+6, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 132400
+(@CGUID+7, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 132400
+(@CGUID+8, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 132970
+(@CGUID+9, 0, 0, 0, 256, 0, 0, 0, 0, ''), -- 132648
+(@CGUID+10, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 132970
+(@CGUID+11, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 131345
+(@CGUID+12, 0, 0, 0, 257, 0, 0, 0, 0, ''), -- 132616
+(@CGUID+13, 0, 0, 0, 257, 0, 0, 0, 0, ''), -- 132616
+(@CGUID+14, 0, 0, 0, 256, 0, 0, 0, 0, ''), -- 132648
+(@CGUID+15, 0, 0, 0, 256, 0, 0, 0, 0, ''), -- 132648
+(@CGUID+16, 0, 0, 0, 257, 0, 0, 0, 0, ''), -- 132386
+(@CGUID+17, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 132705
+(@CGUID+18, 0, 0, 0, 257, 0, 0, 0, 0, ''), -- 132671
+(@CGUID+19, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 132676
+(@CGUID+20, 0, 0, 0, 256, 0, 0, 0, 0, ''), -- 132648
+(@CGUID+21, 0, 0, 0, 258, 0, 0, 0, 0, ''), -- 132407
+(@CGUID+22, 0, 0, 0, 257, 0, 0, 0, 0, ''), -- 132659
+(@CGUID+23, 0, 0, 0, 257, 0, 0, 0, 0, ''), -- 132659
+(@CGUID+24, 0, 0, 0, 258, 0, 0, 0, 0, ''), -- 132407
+(@CGUID+25, 0, 0, 0, 257, 0, 0, 0, 0, ''), -- 132616
+(@CGUID+26, 0, 0, 0, 257, 0, 0, 0, 0, ''), -- 132659
+(@CGUID+27, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 132970
+(@CGUID+28, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 132970
+(@CGUID+29, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 132676
+(@CGUID+30, 0, 0, 0, 257, 0, 0, 0, 0, '260888'), -- 132385 - 260888 - 260888
+(@CGUID+31, 0, 0, 0, 257, 0, 0, 0, 0, ''), -- 132616
+(@CGUID+32, 0, 0, 0, 257, 0, 0, 0, 0, ''), -- 132616
+(@CGUID+33, 0, 0, 0, 256, 0, 0, 0, 0, ''), -- 132648
+(@CGUID+34, 0, 0, 0, 256, 0, 0, 0, 0, ''), -- 132648
+(@CGUID+35, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 132382
+(@CGUID+36, 0, 0, 0, 257, 0, 0, 0, 0, ''), -- 132671
+(@CGUID+37, 0, 0, 0, 256, 0, 0, 0, 0, ''), -- 132648
+(@CGUID+38, 0, 0, 0, 258, 0, 0, 0, 0, ''), -- 132407
+(@CGUID+39, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 132397
+(@CGUID+40, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 132400
+(@CGUID+41, 0, 0, 0, 257, 0, 0, 0, 0, ''), -- 132659
+(@CGUID+42, 0, 0, 0, 257, 0, 0, 0, 0, ''), -- 132657
+(@CGUID+43, 0, 0, 0, 258, 0, 0, 0, 0, ''), -- 132407
+(@CGUID+44, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 132676
+(@CGUID+45, 0, 0, 0, 257, 0, 0, 0, 0, ''), -- 132659
+(@CGUID+46, 0, 0, 0, 258, 0, 0, 0, 0, ''), -- 132407
+(@CGUID+47, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 132676
+(@CGUID+48, 0, 0, 0, 258, 0, 0, 0, 0, ''), -- 132407
+(@CGUID+49, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 132400
+(@CGUID+50, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 132400
+(@CGUID+51, 0, 0, 0, 257, 0, 0, 0, 0, ''), -- 132386
+(@CGUID+52, 0, 0, 0, 1, 0, 0, 0, 0, '262605'), -- 132730 - 262605 - 262605
+(@CGUID+53, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 132400
+(@CGUID+54, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 132400
+(@CGUID+55, 0, 0, 0, 258, 0, 0, 0, 0, ''), -- 132407
+(@CGUID+56, 0, 0, 0, 257, 0, 0, 0, 0, ''), -- 132386
+(@CGUID+57, 0, 0, 0, 257, 0, 0, 0, 0, '261666'), -- 132632 - 261666 - 261666
+(@CGUID+58, 0, 0, 0, 257, 0, 0, 0, 0, '261666'), -- 132627 - 261666 - 261666
+(@CGUID+59, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 132400
+(@CGUID+60, 0, 0, 0, 258, 0, 0, 0, 0, ''), -- 132407
+(@CGUID+61, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 132400
+(@CGUID+62, 0, 0, 0, 1, 0, 0, 0, 0, '211929'), -- 133011 - 211929 - 211929
+(@CGUID+63, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 132400
+(@CGUID+64, 0, 0, 0, 1, 0, 0, 0, 0, ''), -- 132400
+(@CGUID+65, 0, 0, 0, 257, 0, 0, 0, 0, ''), -- 132385
+(@CGUID+66, 0, 0, 0, 258, 0, 0, 0, 0, ''), -- 132407
+(@CGUID+67, 0, 0, 0, 257, 0, 0, 0, 0, ''), -- 132386
+(@CGUID+68, 0, 0, 0, 257, 0, 0, 0, 0, '261666'), -- 132627 - 261666 - 261666
+(@CGUID+69, 0, 0, 0, 257, 0, 0, 0, 0, '261666'); -- 132627 - 261666 - 261666
+
+-- npc scaling
+DELETE FROM `creature_template_scaling` WHERE (`DifficultyID`=0 AND `Entry` IN (133011,132627,132632,132730,132657,132397,132382,132659,132407,132676,132671,132705,132386,131345,132648,132400,132616,132385,126773,132970));
+INSERT INTO `creature_template_scaling` (`Entry`, `DifficultyID`, `LevelScalingDeltaMin`, `LevelScalingDeltaMax`, `ContentTuningID`, `VerifiedBuild`) VALUES
+(133011, 0, 0, 0, 337, 40000),
+(132627, 0, 0, 0, 293, 40000),
+(132632, 0, 0, 0, 293, 40000),
+(132730, 0, 0, 0, 293, 40000),
+(132657, 0, 0, 0, 293, 40000),
+(132397, 0, 0, 0, 293, 40000),
+(132382, 0, 0, 0, 293, 40000),
+(132659, 0, 0, 0, 293, 40000),
+(132407, 0, 0, 0, 293, 40000),
+(132676, 0, 0, 0, 293, 40000),
+(132671, 0, 0, 0, 293, 40000),
+(132705, 0, 0, 0, 293, 40000),
+(132386, 0, 0, 0, 293, 40000),
+(131345, 0, 0, 0, 293, 40000),
+(132648, 0, 0, 0, 293, 40000),
+(132400, 0, 0, 0, 293, 40000),
+(132616, 0, 0, 0, 293, 40000),
+(132385, 0, 0, 0, 293, 40000),
+(126773, 0, 0, 0, 293, 40000),
+(132970, 0, 0, 0, 81, 40000);
+
+-- creature Model info
+DELETE FROM `creature_model_info` WHERE `DisplayID` IN (82511, 82558, 82403, 82400, 69732, 82559, 82523, 82557, 11686, 82409, 82404, 82526, 82520, 82596, 82402, 82549, 82512, 78869, 82548, 79002, 82513, 82401, 78749, 78511);
+INSERT INTO `creature_model_info` (`DisplayID`, `BoundingRadius`, `CombatReach`, `DisplayID_Other_Gender`, `VerifiedBuild`) VALUES
+(82511, 0.347222000360488891, 1.5, 0, 40000),
+(82558, 0.347222000360488891, 1.5, 0, 40000),
+(82403, 0.347222000360488891, 1.5, 0, 40000),
+(82400, 0.347222000360488891, 1.5, 0, 40000),
+(69732, 0.5, 1, 0, 40000),
+(82559, 0.347222000360488891, 1.5, 0, 40000),
+(82523, 0.347222000360488891, 1.5, 0, 40000),
+(82557, 0.312499791383743286, 1.349999904632568359, 0, 40000),
+(11686, 0.5, 1, 0, 40000),
+(82409, 0.347222000360488891, 1.5, 0, 40000),
+(82404, 0.399305284023284912, 1.724999904632568359, 0, 40000),
+(82526, 0.347222000360488891, 1.5, 0, 40000),
+(82520, 0.382999986410140991, 1.5, 0, 40000),
+(82596, 0.347222000360488891, 1.5, 0, 40000),
+(82402, 0.347222000360488891, 1.5, 0, 40000),
+(82549, 0.347222000360488891, 1.5, 0, 40000),
+(82512, 0.382999986410140991, 1.5, 0, 40000),
+(78869, 0.430167853832244873, 0, 0, 40000),
+(82548, 0.347222000360488891, 1.5, 0, 40000),
+(79002, 1.299441218376159667, 0.60000002384185791, 0, 40000),
+(82513, 0.382999986410140991, 1.5, 0, 40000),
+(82401, 0.347222000360488891, 1.5, 0, 40000),
+(78749, 0.757361590862274169, 1.20000004768371582, 0, 40000),
+(78511, 0.30430692434310913, 0.75, 0, 40000);
+
+-- creature_template_model
+DELETE FROM `creature_template_model` WHERE (`Idx`=3 AND `CreatureID`=132627) OR (`Idx`=2 AND `CreatureID`=132627) OR (`Idx`=1 AND `CreatureID` IN (132627,132730,132659,132616,132648,132385,132397,132407,132386,132671,176308)) OR (`Idx`=0 AND `CreatureID` IN (132627,132632,133011,132730,132382,132659,132400,132676,132616,132648,132657,131345,132385,132705,126773,132397,132407,132386,132671,132970,53270,64993,33030,35362,73780,65011,77178,29929,305,76084,71486,69831,69204,68211,67437,66062,66063,66060,65078,65076,65072,65071,65065,65063,65061,65060,65058,65009,65007,65006,63553,63552,62454,62106,61809,60941,59101,55272,53276,52807,48632,47841,47353,39209,39208,35168,33904,33892,31239,32633,32206,32158,31851,31778,31698,31717,29582,27707,28302,24488,20850,20848,20849,20847,20846,19658,18362,18375,18376,18406,18359,18357,18360,15715,15714,15666,14602,14547,14548,14546,14561,14560,14559,14553,14552,14551,14556,14555,14565,14505,14336,10180,11147,9158,7749,7739,7690,7687,6074,4779,4777,4710,4269,304,307,308,21354,65074,284,179883,174032,179595,176308,161015));
+INSERT INTO `creature_template_model` (`CreatureID`, `Idx`, `CreatureDisplayID`, `DisplayScale`, `Probability`, `VerifiedBuild`) VALUES
+(132627, 3, 82559, 1, 1, 40000), -- 132627
+(132627, 2, 82558, 1, 1, 40000), -- 132627
+(132627, 1, 82511, 1, 1, 40000), -- 132627
+(132627, 0, 82509, 1, 1, 40000), -- 132627
+(132632, 0, 82523, 1, 1, 40000), -- 132632
+(133011, 0, 69732, 1, 1, 40000), -- 133011
+(132730, 1, 11686, 1, 1, 40000), -- 132730
+(132730, 0, 1126, 1, 0, 40000), -- 132730
+(132382, 0, 82404, 1, 1, 40000), -- 132382
+(132659, 1, 82549, 1, 1, 40000), -- 132659
+(132659, 0, 82548, 1, 1, 40000), -- 132659
+(132400, 0, 79002, 1, 1, 40000), -- 132400
+(132676, 0, 79002, 1, 1, 40000), -- 132676
+(132616, 1, 82513, 1, 1, 40000), -- 132616
+(132616, 0, 82512, 1, 1, 40000), -- 132616
+(132648, 1, 82549, 1, 1, 40000), -- 132648
+(132648, 0, 82548, 1, 1, 40000), -- 132648
+(132657, 0, 82557, 1, 1, 40000), -- 132657
+(131345, 0, 78869, 1, 1, 40000), -- 131345
+(132385, 1, 82401, 1, 1, 40000), -- 132385
+(132385, 0, 82400, 1, 1, 40000), -- 132385
+(132705, 0, 82596, 1, 1, 40000), -- 132705
+(126773, 0, 78749, 1, 1, 40000), -- 126773
+(132397, 1, 11686, 1, 1, 40000), -- 132397
+(132397, 0, 1126, 1, 0, 40000), -- 132397
+(132407, 1, 82409, 1, 1, 40000), -- 132407
+(132407, 0, 82526, 1, 1, 40000), -- 132407
+(132386, 1, 82402, 1, 1, 40000), -- 132386
+(132386, 0, 82403, 1, 1, 40000), -- 132386
+(132671, 1, 82520, 1, 1, 40000), -- 132671
+(132671, 0, 82519, 1, 1, 40000), -- 132671
+(132970, 0, 78511, 1, 1, 40000), -- 132970
+(53270, 0, 34955, 1, 0, 40000), -- 53270
+(64993, 0, 43697, 1, 0, 40000), -- 64993
+(33030, 0, 28060, 1, 0, 40000), -- 33030
+(35362, 0, 29794, 1, 0, 40000), -- 35362
+(73780, 0, 51359, 1, 0, 40000), -- 73780
+(65011, 0, 43708, 1, 0, 40000), -- 65011
+(77178, 0, 53774, 1, 0, 40000), -- 77178
+(29929, 0, 25871, 1, 1, 40000), -- 29929
+(305, 0, 2410, 1, 1, 40000), -- 305
+(76084, 0, 53038, 1, 1, 40000), -- 76084
+(71486, 0, 48931, 1, 0, 40000), -- 71486
+(69831, 0, 47717, 1, 0, 40000), -- 69831
+(69204, 0, 47238, 1, 0, 40000), -- 69204
+(68211, 0, 72873, 1, 0, 40000), -- 68211
+(67437, 0, 42147, 1, 0, 40000), -- 67437
+(66062, 0, 44757, 1, 0, 40000), -- 66062
+(66063, 0, 43900, 1, 0, 40000), -- 66063
+(66060, 0, 44759, 1, 0, 40000), -- 66060
+(65078, 0, 43726, 1, 0, 40000), -- 65078
+(65076, 0, 43725, 1, 0, 40000), -- 65076
+(65072, 0, 43723, 1, 0, 40000), -- 65072
+(65071, 0, 43722, 1, 0, 40000), -- 65071
+(65065, 0, 43721, 1, 0, 40000), -- 65065
+(65063, 0, 43720, 1, 0, 40000), -- 65063
+(65061, 0, 43719, 1, 0, 40000), -- 65061
+(65060, 0, 43718, 1, 0, 40000), -- 65060
+(65058, 0, 43717, 1, 0, 40000), -- 65058
+(65009, 0, 43706, 1, 0, 40000), -- 65009
+(65007, 0, 43705, 1, 0, 40000), -- 65007
+(65006, 0, 43704, 1, 0, 40000), -- 65006
+(63553, 0, 41991, 1, 0, 40000), -- 63553
+(63552, 0, 41989, 1, 0, 40000), -- 63552
+(62454, 0, 42498, 1, 0, 40000), -- 62454
+(62106, 0, 42352, 1, 0, 40000), -- 62106
+(61809, 0, 42250, 1, 0, 40000), -- 61809
+(60941, 0, 41711, 1, 0, 40000), -- 60941
+(59101, 0, 40590, 1, 0, 40000), -- 59101
+(55272, 0, 39096, 1, 0, 40000), -- 55272
+(53276, 0, 38261, 1, 1, 40000), -- 53276
+(52807, 0, 38046, 1, 1, 40000), -- 52807
+(48632, 0, 36213, 1, 1, 40000), -- 48632
+(47841, 0, 37145, 1, 0, 40000), -- 47841
+(47353, 0, 35757, 1, 1, 40000), -- 47353
+(39209, 0, 31368, 1, 1, 40000), -- 39209
+(39208, 0, 31367, 1, 1, 40000), -- 39208
+(35168, 0, 29755, 1, 1, 40000), -- 35168
+(33904, 0, 28954, 1, 1, 40000), -- 33904
+(33892, 0, 28953, 1, 1, 40000), -- 33892
+(31239, 0, 27525, 1, 0, 40000), -- 31239
+(32633, 0, 27237, 1, 1, 40000), -- 32633
+(32206, 0, 27820, 1, 1, 40000), -- 32206
+(32158, 0, 25836, 1, 1, 40000), -- 32158
+(31851, 0, 27243, 1, 0, 40000), -- 31851
+(31778, 0, 25831, 1, 0, 40000), -- 31778
+(31698, 0, 27796, 1, 0, 40000), -- 31698
+(31717, 0, 25833, 1, 1, 40000), -- 31717
+(29582, 0, 28108, 1, 0, 40000), -- 29582
+(27707, 0, 24757, 1, 1, 40000), -- 27707
+(28302, 0, 25280, 1, 1, 40000), -- 28302
+(24488, 0, 22473, 1, 1, 40000), -- 24488
+(20850, 0, 19872, 1, 0, 40000), -- 20850
+(20848, 0, 19871, 1, 0, 40000), -- 20848
+(20849, 0, 19873, 1, 0, 40000), -- 20849
+(20847, 0, 19870, 1, 0, 40000), -- 20847
+(20846, 0, 19869, 1, 0, 40000), -- 20846
+(19658, 0, 17063, 1, 0, 40000), -- 19658
+(18362, 0, 17717, 1, 0, 40000), -- 18362
+(18375, 0, 17703, 1, 0, 40000), -- 18375
+(18376, 0, 17718, 1, 0, 40000), -- 18376
+(18406, 0, 17759, 1, 0, 40000), -- 18406
+(18359, 0, 17696, 1, 0, 40000), -- 18359
+(18357, 0, 17694, 1, 0, 40000), -- 18357
+(18360, 0, 17697, 1, 0, 40000), -- 18360
+(15715, 0, 15679, 1, 1, 40000), -- 15715
+(15714, 0, 15680, 1, 1, 40000), -- 15714
+(15666, 0, 15672, 1, 1, 40000), -- 15666
+(14602, 0, 14632, 1, 1, 40000), -- 14602
+(14547, 0, 14346, 1, 1, 40000), -- 14547
+(14548, 0, 14576, 1, 1, 40000), -- 14548
+(14546, 0, 14347, 1, 1, 40000), -- 14546
+(14561, 0, 14583, 1, 1, 40000), -- 14561
+(14560, 0, 14338, 1, 1, 40000), -- 14560
+(14559, 0, 14582, 1, 1, 40000), -- 14559
+(14553, 0, 14374, 1, 1, 40000), -- 14553
+(14552, 0, 14376, 1, 1, 40000), -- 14552
+(14551, 0, 14377, 1, 1, 40000), -- 14551
+(14556, 0, 14331, 1, 1, 40000), -- 14556
+(14555, 0, 14332, 1, 1, 40000), -- 14555
+(14565, 0, 14584, 1, 1, 40000), -- 14565
+(14505, 0, 14554, 1, 1, 40000), -- 14505
+(14336, 0, 14330, 1, 1, 40000), -- 14336
+(10180, 0, 9476, 1, 1, 40000), -- 10180
+(11147, 0, 10661, 1, 1, 40000), -- 11147
+(9158, 0, 8469, 1, 1, 40000), -- 9158
+(7749, 0, 6569, 1, 1, 40000), -- 7749
+(7739, 0, 9473, 1, 1, 40000), -- 7739
+(7690, 0, 6448, 1, 1, 40000), -- 7690
+(7687, 0, 6444, 1, 1, 40000), -- 7687
+(6074, 0, 6080, 1, 1, 40000), -- 6074
+(4779, 0, 2785, 1, 1, 40000), -- 4779
+(4777, 0, 2786, 1, 1, 40000), -- 4777
+(4710, 0, 2736, 1, 1, 40000), -- 4710
+(4269, 0, 2405, 1, 1, 40000), -- 4269
+(304, 0, 2346, 1, 1, 40000), -- 304
+(307, 0, 2409, 1, 1, 40000), -- 307
+(308, 0, 2402, 1, 1, 40000), -- 308
+(21354, 0, 19250, 1, 1, 40000), -- 21354
+(65074, 0, 43724, 1, 0, 40000), -- 65074
+(284, 0, 2404, 1, 1, 40000), -- 284
+(179883, 0, 100767, 2.5, 1, 40000), -- 179883
+(174032, 0, 93511, 1, 1, 40000), -- 174032
+(179595, 0, 101347, 1, 1, 40000), -- 179595
+(176308, 1, 100403, 1, 1, 40000), -- 176308
+(176308, 0, 33559, 1, 0, 40000), -- 176308
+(161015, 0, 92704, 1, 1, 40000); -- 161015
+
+-- npc_vendor
+DELETE FROM `npc_vendor` WHERE (`entry`=132705 AND `item`=3857 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=132705 AND `item`=18567 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=132705 AND `item`=3466 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=132705 AND `item`=2880 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=132705 AND `item`=180733 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=132705 AND `item`=5956 AND `ExtendedCost`=0 AND `type`=1) OR (`entry`=132705 AND `item`=2901 AND `ExtendedCost`=0 AND `type`=1);
+INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `ExtendedCost`, `type`, `PlayerConditionID`, `IgnoreFiltering`, `VerifiedBuild`) VALUES
+(132705, 7, 3857, 0, 0, 1, 0, 0, 40120), -- 3857
+(132705, 6, 18567, 0, 0, 1, 0, 0, 40120), -- 18567
+(132705, 5, 3466, 0, 0, 1, 0, 0, 40120), -- 3466
+(132705, 4, 2880, 0, 0, 1, 0, 0, 40120), -- 2880
+(132705, 3, 180733, 0, 0, 1, 0, 0, 40120), -- 180733
+(132705, 2, 5956, 0, 0, 1, 0, 0, 40120), -- 5956
+(132705, 1, 2901, 0, 0, 1, 0, 0, 40120); -- 2901
+
+-- creature_equip_template
+DELETE FROM `creature_equip_template` WHERE (`ID`=1 AND `CreatureID` IN (131345,132659,126773,132407,132648));
+INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `AppearanceModID1`, `ItemVisual1`, `ItemID2`, `AppearanceModID2`, `ItemVisual2`, `ItemID3`, `AppearanceModID3`, `ItemVisual3`) VALUES
+(131345, 1, 0, 0, 0, 0, 0, 0, 151781, 0, 0), -- 131345
+(132659, 1, 33295, 0, 0, 153892, 0, 0, 0, 0, 0), -- 132659
+(126773, 1, 124381, 0, 0, 0, 0, 0, 0, 0, 0), -- 126773
+(132407, 1, 0, 0, 0, 0, 0, 0, 105125, 0, 0), -- 132407
+(132648, 1, 31604, 0, 0, 0, 0, 0, 0, 0, 0); -- 132648
+
+-- gossip_menu
+DELETE FROM `gossip_menu` WHERE (`MenuId`=22066 AND `TextId`=33795) OR (`MenuId`=22067 AND `TextId`=33796) OR (`MenuId`=7288 AND `TextId`=8618) OR (`MenuId`=22089 AND `TextId`=33825) OR (`MenuId`=22107 AND `TextId`=33847) OR (`MenuId`=22086 AND `TextId`=33823) OR (`MenuId`=22080 AND `TextId`=33813) OR (`MenuId`=22070 AND `TextId`=33799) OR (`MenuId`=22156 AND `TextId`=33943) OR (`MenuId`=22068 AND `TextId`=33797) OR (`MenuId`=22065 AND `TextId`=33794);
+INSERT INTO `gossip_menu` (`MenuId`, `TextId`, `VerifiedBuild`) VALUES
+(22066, 33795, 40120), -- 132382
+(22067, 33796, 40120), -- 131345
+(7288, 8618, 40120), -- 132657
+(22089, 33825, 40120), -- 132386
+(22107, 33847, 40120), -- 132632
+(22086, 33823, 40120), -- 132385
+(22080, 33813, 40120), -- 132648
+(22070, 33799, 40120), -- 132671
+(22156, 33943, 40120), -- 126773
+(22068, 33797, 40120), -- 126773
+(22065, 33794, 40120); -- 132385
+
+-- gossip_menu_option
+DELETE FROM `gossip_menu_option` WHERE (`OptionIndex`=0 AND `MenuId` IN (7288,22068));
+INSERT INTO `gossip_menu_option` (`MenuId`, `OptionIndex`, `OptionIcon`, `OptionText`, `OptionBroadcastTextId`, `VerifiedBuild`) VALUES
+(7288, 0, 5, 'Make this inn your home.', 0, 40120),
+(22068, 0, 0, 'What do you know of Telogrus?', 0, 40120);
+
+-- npc_text
+DELETE FROM `npc_text` WHERE `ID` IN (33823 /*33823*/, 8618 /*8618*/, 33943 /*33943*/, 33797 /*33797*/, 33799 /*33799*/, 33794 /*33794*/, 33813 /*33813*/, 33795 /*33795*/, 33796 /*33796*/, 33847 /*33847*/, 33825 /*33825*/);
+INSERT INTO `npc_text` (`ID`, `Probability0`, `Probability1`, `Probability2`, `Probability3`, `Probability4`, `Probability5`, `Probability6`, `Probability7`, `BroadcastTextId0`, `BroadcastTextId1`, `BroadcastTextId2`, `BroadcastTextId3`, `BroadcastTextId4`, `BroadcastTextId5`, `BroadcastTextId6`, `BroadcastTextId7`, `VerifiedBuild`) VALUES
+(33823, 1, 0, 0, 0, 0, 0, 0, 0, 146090, 0, 0, 0, 0, 0, 0, 0, 40120), -- 33823
+(8618, 1, 0, 0, 0, 0, 0, 0, 0, 12528, 0, 0, 0, 0, 0, 0, 0, 40120), -- 8618
+(33943, 1, 0, 0, 0, 0, 0, 0, 0, 146920, 0, 0, 0, 0, 0, 0, 0, 40120), -- 33943
+(33797, 1, 0, 0, 0, 0, 0, 0, 0, 145896, 0, 0, 0, 0, 0, 0, 0, 40120), -- 33797
+(33799, 1, 1, 0, 0, 0, 0, 0, 0, 145897, 145898, 0, 0, 0, 0, 0, 0, 40120), -- 33799
+(33794, 1, 1, 0, 0, 0, 0, 0, 0, 145890, 145892, 0, 0, 0, 0, 0, 0, 40120), -- 33794
+(33813, 1, 1, 0, 0, 0, 0, 0, 0, 146006, 146148, 0, 0, 0, 0, 0, 0, 40120), -- 33813
+(33795, 1, 1, 1, 0, 0, 0, 0, 0, 145893, 146231, 147276, 0, 0, 0, 0, 0, 40120), -- 33795
+(33796, 1, 1, 1, 0, 0, 0, 0, 0, 145895, 147271, 147272, 0, 0, 0, 0, 0, 40120), -- 33796
+(33847, 1, 0, 0, 0, 0, 0, 0, 0, 146362, 0, 0, 0, 0, 0, 0, 0, 40120), -- 33847
+(33825, 1, 1, 1, 1, 0, 0, 0, 0, 146098, 146099, 146517, 146516, 0, 0, 0, 0, 40120); -- 33825
+
+-- Gossip_menu_option
+UPDATE `gossip_menu_option` SET `OptionType` = 1, `OptionNpcFlag` = 1, `VerifiedBuild` = 40120 WHERE `MenuId` = 22068 AND `OptionIndex` = 0;
+DELETE FROM `gossip_menu_option_action` WHERE (`MenuId`=22068 AND `OptionIndex`=0);
+INSERT INTO `gossip_menu_option_action` (`MenuId`, `OptionIndex`, `ActionMenuId`, `ActionPoiId`) VALUES
+(22068, 0, 22156, 0);
+
+-- spell_target_position
+DELETE FROM `spell_target_position` WHERE (`EffectIndex`=0 AND `ID` IN (258310,260866,259377));
+INSERT INTO `spell_target_position` (`ID`, `EffectIndex`, `MapID`, `PositionX`, `PositionY`, `PositionZ`, `VerifiedBuild`) VALUES
+(258310, 0, 0, -8166.64990234375, 784.719970703125, 76.3600006103515625, 40120), -- Spell: 258310 (Teleport: Stormwind) Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS)
+(260866, 0, 1865, 1902.18994140625, 3302.929931640625, 95.5, 40120), -- Spell: 260866 (Teleport: Fate's Veil Island 1) Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS)
+(259377, 0, 1865, 2127.360107421875, 3316.06005859375, 54.70000076293945312, 40120); -- Spell: 259377 (Teleport: Telogrus Rift) Efffect: 252 (SPELL_EFFECT_TELEPORT_UNITS)
+
+-- quest_starter
+DELETE FROM `creature_queststarter` WHERE `id`=131345 AND `quest`=49788;
+INSERT INTO `creature_queststarter`(`id`, `quest`) VALUES 
+(131345, 49788);
+
+-- gameobject
+DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+45;
+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, 280969, 1865, 9415, 9415, '0', '0', 0, 2135.22216796875, 3331.068603515625, 54.97393798828125, 5.988194942474365234, -0.01469659805297851, -0.05117321014404296, -0.14711952209472656, 0.98768472671508789, 7200, 255, 1, 40000), -- 280969 (Area: 9415 - Difficulty: 0)
+(@OGUID+1, 280959, 1865, 9415, 9415, '0', '0', 0, 2167.58154296875, 3321.947998046875, 54.39636611938476562, 3.994499444961547851, 0, 0, -0.91043853759765625, 0.413644403219223022, 7200, 255, 1, 40000), -- 280959 (Area: 9415 - Difficulty: 0)
+(@OGUID+2, 280959, 1865, 9415, 9415, '0', '0', 0, 2167.546875, 3317.942626953125, 54.75832748413085937, 6.065781593322753906, 0, 0, -0.10848808288574218, 0.994097769260406494, 7200, 255, 1, 40000), -- 280959 (Area: 9415 - Difficulty: 0)
+(@OGUID+3, 280800, 1865, 9415, 9415, '0', '0', 0, 2102.62841796875, 3285.803955078125, 57.57932662963867187, 0, 0, 0, 0, 1, 7200, 255, 1, 40000), -- 280800 (Area: 9415 - Difficulty: 0)
+(@OGUID+4, 268668, 1865, 9415, 9415, '0', '0', 0, 2137.036376953125, 3330.950439453125, 55.11678314208984375, 5.621202945709228515, -0.00369119644165039, -0.02361297607421875, -0.32479476928710937, 0.945482492446899414, 7200, 255, 1, 40000), -- 268668 (Area: 9415 - Difficulty: 0)
+(@OGUID+5, 221625, 1865, 9415, 9415, '0', '0', 0, 2165.210205078125, 3317.861083984375, 54.71223068237304687, 0.590611636638641357, -0.05905675888061523, -0.01426029205322265, 0.290700912475585937, 0.954883217811584472, 7200, 255, 1, 40000), -- 221625 (Area: 9415 - Difficulty: 0)
+(@OGUID+6, 280794, 1865, 9415, 9415, '0', '0', 0, 1908.1129150390625, 3298.9306640625, 95.544219970703125, 0, 0, 0, 0, 1, 7200, 255, 1, 40000), -- 280794 (Area: 9415 - Difficulty: 0)
+(@OGUID+7, 280949, 1865, 9415, 9415, '0', '0', 0, 2110.942626953125, 3379.4306640625, 58.33880615234375, 4.063357830047607421, 0, 0, -0.895660400390625, 0.444738656282424926, 7200, 255, 1, 40000), -- 280949 (Area: 9415 - Difficulty: 0)
+(@OGUID+8, 280968, 1865, 9415, 9415, '0', '0', 0, 2115.626708984375, 3368.2822265625, 58.55398941040039062, 6.095187664031982421, 0, 0, -0.09386062622070312, 0.995585381984710693, 7200, 255, 1, 40000), -- 280968 (Area: 9415 - Difficulty: 0)
+(@OGUID+9, 280968, 1865, 9415, 9415, '0', '0', 0, 2169.875, 3319.361083984375, 54.34086990356445312, 6.179501533508300781, 0, 0, -0.05181884765625, 0.998656511306762695, 7200, 255, 1, 40000), -- 280968 (Area: 9415 - Difficulty: 0)
+(@OGUID+10, 280963, 1865, 9415, 9415, '0', '0', 0, 2109.772705078125, 3380.41064453125, 58.56341552734375, 2.522846221923828125, -0.05001211166381835, -0.03036689758300781, 0.95140838623046875, 0.302322298288345336, 7200, 255, 1, 40000), -- 280963 (Area: 9415 - Difficulty: 0)
+(@OGUID+11, 280958, 1865, 9415, 9415, '0', '0', 0, 2171.0712890625, 3322.493896484375, 54.44314956665039062, 3.528738260269165039, 0, 0, -0.9813232421875, 0.192366078495979309, 7200, 255, 1, 40000), -- 280958 (Area: 9415 - Difficulty: 0)
+(@OGUID+12, 280958, 1865, 9415, 9415, '0', '0', 0, 2169.57470703125, 3316.247314453125, 55.10287857055664062, 5.654347419738769531, 0, 0, -0.30926418304443359, 0.950976133346557617, 7200, 255, 1, 40000), -- 280958 (Area: 9415 - Difficulty: 0)
+(@OGUID+13, 280967, 1865, 9415, 9415, '0', '0', 0, 2111.076416015625, 3379.420166015625, 58.78490447998046875, 4.105897903442382812, 0.052279472351074218, -0.00080013275146484, -0.88531875610351562, 0.462035655975341796, 7200, 255, 1, 40000), -- 280967 (Area: 9415 - Difficulty: 0)
+(@OGUID+14, 280949, 1865, 9415, 9415, '0', '0', 0, 2134.83154296875, 3331.7978515625, 54.96714019775390625, 4.853682518005371093, 0, 0, -0.65542984008789062, 0.755256056785583496, 7200, 255, 1, 40000), -- 280949 (Area: 9415 - Difficulty: 0)
+(@OGUID+15, 280964, 1865, 9415, 9415, '0', '0', 0, 2116.57470703125, 3367.04345703125, 58.54189682006835937, 6.232558250427246093, -0.0229034423828125, 0.018891334533691406, -0.024871826171875, 0.999249696731567382, 7200, 255, 1, 40000), -- 280964 (Area: 9415 - Difficulty: 0)
+(@OGUID+16, 280964, 1865, 9415, 9415, '0', '0', 0, 2113.94091796875, 3363.1953125, 58.9280548095703125, 0.354084372520446777, -0.02673721313476562, -0.54664802551269531, 0.069499969482421875, 0.834044814109802246, 7200, 255, 1, 40000), -- 280964 (Area: 9415 - Difficulty: 0)
+(@OGUID+17, 280970, 1865, 9415, 9415, '0', '0', 0, 2111.583251953125, 3340.908935546875, 56.81538772583007812, 5.974820137023925781, 0.04787445068359375, 0.026080131530761718, -0.15476322174072265, 0.986446261405944824, 7200, 255, 1, 40000), -- 280970 (Area: 9415 - Difficulty: 0)
+(@OGUID+18, 253044, 1865, 9415, 9415, '0', '0', 0, 2105.385498046875, 3359.28125, 58.36912155151367187, 1.06929934024810791, 0, 0, 0.509539604187011718, 0.860447168350219726, 7200, 255, 1, 40000), -- 253044 (Area: 9415 - Difficulty: 0)
+(@OGUID+19, 253044, 1865, 9415, 9415, '0', '0', 0, 2108.303955078125, 3360.40283203125, 58.42418289184570312, 2.421695709228515625, 0, 0, 0.935914993286132812, 0.352225959300994873, 7200, 255, 1, 40000), -- 253044 (Area: 9415 - Difficulty: 0)
+(@OGUID+20, 280975, 1865, 9415, 9415, '0', '0', 0, 2109.90625, 3340.607666015625, 57.60308074951171875, 2.729029417037963867, 0.477239131927490234, 0.548095703125, -0.51122379302978515, 0.458785504102706909, 7200, 255, 1, 40000), -- 280975 (Area: 9415 - Difficulty: 0)
+(@OGUID+21, 280946, 1865, 9415, 9415, '0', '0', 0, 2134.970458984375, 3332.66064453125, 54.92321395874023437, 1.764855861663818359, 0, 0, 0.772283554077148437, 0.635277986526489257, 7200, 255, 1, 40000), -- 280946 (Area: 9415 - Difficulty: 0)
+(@OGUID+22, 280973, 1865, 9415, 9415, '0', '0', 0, 2110.45654296875, 3343.09716796875, 56.9272613525390625, 2.114426612854003906, 0, 0, 0.870989799499511718, 0.491301089525222778, 7200, 255, 1, 40000), -- 280973 (Area: 9415 - Difficulty: 0)
+(@OGUID+23, 280971, 1865, 9415, 9415, '0', '0', 0, 2109.875, 3340.137939453125, 56.09220504760742187, 0.399324953556060791, 0, 0, 0.198338508605957031, 0.980133593082427978, 7200, 255, 1, 40000), -- 280971 (Area: 9415 - Difficulty: 0)
+(@OGUID+24, 280959, 1865, 9415, 9415, '0', '0', 0, 2107.272705078125, 3340.569580078125, 56.59068679809570312, 5.181279182434082031, 0, 0, -0.5234994888305664, 0.852025985717773437, 7200, 255, 1, 40000), -- 280959 (Area: 9415 - Difficulty: 0)
+(@OGUID+25, 221625, 1865, 9415, 9415, '0', '0', 0, 2165.369873046875, 3319.829833984375, 54.53283309936523437, 6.19910430908203125, -0.03406715393066406, 0.009043693542480468, -0.04174041748046875, 0.998506546020507812, 7200, 255, 1, 40000), -- 221625 (Area: 9415 - Difficulty: 0)
+(@OGUID+26, 280967, 1865, 9415, 9415, '0', '0', 0, 2106.173583984375, 3360.819580078125, 58.38729476928710937, 4.83340311050415039, -0.00909042358398437, -0.02855873107910156, -0.6625070571899414, 0.748455822467803955, 7200, 255, 1, 40000), -- 280967 (Area: 9415 - Difficulty: 0)
+(@OGUID+27, 280949, 1865, 9415, 9415, '0', '0', 0, 2106.022705078125, 3360.272705078125, 58.3411865234375, 1.659677505493164062, 0, 0, 0.737822532653808593, 0.67499476671218872, 7200, 255, 1, 40000), -- 280949 (Area: 9415 - Difficulty: 0)
+(@OGUID+28, 280959, 1865, 9415, 9415, '0', '0', 0, 2140.395751953125, 3331.8916015625, 54.98600387573242187, 4.834675788879394531, 0, 0, -0.66257762908935546, 0.748993277549743652, 7200, 255, 1, 40000), -- 280959 (Area: 9415 - Difficulty: 0)
+(@OGUID+29, 280963, 1865, 9415, 9415, '0', '0', 0, 2112.854248046875, 3378.2275390625, 58.72557449340820312, 2.481723785400390625, -0.03787565231323242, -0.0332489013671875, 0.945216178894042968, 0.322531104087829589, 7200, 255, 1, 40000), -- 280963 (Area: 9415 - Difficulty: 0)
+(@OGUID+30, 280974, 1865, 9415, 9415, '0', '0', 0, 2113.28466796875, 3344.541748046875, 58.1446075439453125, 1.554195523262023925, 0.447363853454589843, 0.520063400268554687, 0.470463752746582031, 0.55503469705581665, 7200, 255, 1, 40000), -- 280974 (Area: 9415 - Difficulty: 0)
+(@OGUID+31, 280945, 1865, 9415, 9415, '0', '0', 0, 2110.407958984375, 3366.880126953125, 59.57371902465820312, 0, 0, 0, 0, 1, 7200, 255, 1, 40000), -- 280945 (Area: 9415 - Difficulty: 0)
+(@OGUID+32, 280972, 1865, 9415, 9415, '0', '0', 0, 2113.732666015625, 3344.57373046875, 56.76467132568359375, 1.771139740943908691, 0, 0, 0.774275779724121093, 0.632848322391510009, 7200, 255, 1, 40000), -- 280972 (Area: 9415 - Difficulty: 0)
+(@OGUID+33, 279607, 1865, 9415, 9415, '0', '0', 0, 2149.69091796875, 3331.38720703125, 54.9962921142578125, 0, 0, 0, 0, 1, 7200, 255, 1, 40000), -- 279607 (Area: 9415 - Difficulty: 0)
+(@OGUID+34, 280967, 1865, 9415, 9415, '0', '0', 0, 2115.866455078125, 3368.704833984375, 58.62358474731445312, 4.52684783935546875, 0.029671669006347656, 0.000721931457519531, -0.76950550079345703, 0.637950122356414794, 7200, 255, 1, 40000), -- 280967 (Area: 9415 - Difficulty: 0)
+(@OGUID+35, 280958, 1865, 9415, 9415, '0', '0', 0, 2115.366455078125, 3363.470458984375, 58.47637176513671875, 2.912093162536621093, 0, 0, 0.9934234619140625, 0.114498049020767211, 7200, 255, 1, 40000), -- 280958 (Area: 9415 - Difficulty: 0)
+(@OGUID+36, 280958, 1865, 9415, 9415, '0', '0', 0, 2170.15625, 3319.627685546875, 54.70170974731445312, 4.034273624420166015, 0, 0, -0.90203285217285156, 0.431667417287826538, 7200, 255, 1, 40000), -- 280958 (Area: 9415 - Difficulty: 0)
+(@OGUID+37, 280793, 1865, 9415, 9415, '0', '0', 0, 2044.4149169921875, 3333.40283203125, 58.31357955932617187, 0, 0, 0, 0, 1, 7200, 255, 1, 40000), -- 280793 (Area: 9415 - Difficulty: 0)
+(@OGUID+38, 280960, 1865, 9415, 9415, '0', '0', 0, 2117.203125, 3369.780517578125, 58.68408966064453125, 1.304993152618408203, 0, 0, 0.607172012329101562, 0.794570446014404296, 7200, 255, 1, 40000), -- 280960 (Area: 9415 - Difficulty: 0)
+(@OGUID+39, 280944, 1865, 9415, 9415, '0', '0', 0, 2110.416748046875, 3366.8837890625, 58.33392333984375, 0, 0, 0, 0, 1, 7200, 255, 1, 40000), -- 280944 (Area: 9415 - Difficulty: 0)
+(@OGUID+40, 280964, 1865, 9415, 9415, '0', '0', 0, 2103.932373046875, 3361.099853515625, 58.27219009399414062, 6.232558250427246093, -0.0229034423828125, 0.018891334533691406, -0.024871826171875, 0.999249696731567382, 7200, 255, 1, 40000), -- 280964 (Area: 9415 - Difficulty: 0)
+(@OGUID+41, 281015, 1865, 9415, 9531, '0', '0', 0, 1896.404541015625, 3330.208251953125, 99.4635162353515625, 2.720252752304077148, -0.00408411026000976, -0.07554435729980468, 0.974903106689453125, 0.209380730986595153, 7200, 255, 1, 40000), -- 281015 (Area: 9531 - Difficulty: 0)
+(@OGUID+42, 280960, 1865, 9415, 9531, '0', '0', 0, 1895.79345703125, 3329.642333984375, 98.2798004150390625, 6.164352893829345703, 0.078107833862304687, -0.00561714172363281, -0.05912303924560546, 0.995174407958984375, 7200, 255, 1, 40000), -- 280960 (Area: 9531 - Difficulty: 0)
+(@OGUID+43, 281022, 1865, 9415, 9531, '0', '0', 0, 1895.66845703125, 3329.166748046875, 99.2807769775390625, 1.043002486228942871, 0.055757045745849609, -0.04433917999267578, 0.498427391052246093, 0.863999605178833007, 7200, 255, 1, 40000), -- 281022 (Area: 9531 - Difficulty: 0)
+(@OGUID+44, 281016, 1865, 9415, 9531, '0', '0', 0, 1894.9254150390625, 3329.619873046875, 99.28421783447265625, 0.982507288455963134, 0.067705154418945312, -0.05675506591796875, 0.4722747802734375, 0.877012789249420166, 7200, 255, 1, 40000), -- 281016 (Area: 9531 - Difficulty: 0)
+(@OGUID+45, 280949, 1865, 9415, 9531, '0', '0', 0, 1896.095458984375, 3329.732666015625, 97.89945220947265625, 4.590495109558105468, 0, 0, -0.74886322021484375, 0.662724554538726806, 7200, 255, 1, 40000); -- 280949 (Area: 9531 - Difficulty: 0)
+
+-- gameobject_addon
+DELETE FROM `gameobject_addon` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+45;
+INSERT INTO `gameobject_addon` (`guid`, `parent_rotation0`, `parent_rotation1`, `parent_rotation2`, `parent_rotation3`, `WorldEffectID`, `AIAnimKitID`) VALUES
+(@OGUID+33, 0, 0, 0, 1, 8785, 0); -- 279607
+
+-- gameobject_template
+DELETE FROM `gameobject_template` WHERE `entry` IN (281016 /*281016*/, 281022 /*281022*/, 281015 /*281015*/, 280975 /*280975*/, 280967 /*280967*/, 280971 /*280971*/, 280972 /*280972*/, 280959 /*280959*/, 280964 /*280964*/, 280944 /*280944*/, 280800 /*280800*/, 268668 /*268668*/, 280960 /*280960*/, 253044 /*253044*/, 280968 /*280968*/, 280945 /*280945*/, 280969 /*280969*/, 280973 /*280973*/, 280793 /*280793*/, 221625 /*221625*/, 280949 /*280949*/, 280946 /*280946*/, 280794 /*280794*/, 280974 /*280974*/, 280970 /*280970*/, 280958 /*280958*/, 280963 /*280963*/, 279607 /*279607*/);
+INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `size`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `Data8`, `Data9`, `Data10`, `Data11`, `Data12`, `Data13`, `Data14`, `Data15`, `Data16`, `Data17`, `Data18`, `Data19`, `Data20`, `Data21`, `Data22`, `Data23`, `Data24`, `Data25`, `Data26`, `Data27`, `Data28`, `Data29`, `Data30`, `Data31`, `Data32`, `Data33`, `ContentTuningId`, `VerifiedBuild`) VALUES
+(281016, 5, 19297, 'Quill', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 863, 40000), -- 281016
+(281022, 5, 29876, 'Scroll', '', '', '', 0.699999988079071044, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 863, 40000), -- 281022
+(281015, 5, 15411, 'Book', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 863, 40000), -- 281015
+(280975, 5, 4175, 'Sword', 'questinteract', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 863, 40000), -- 280975
+(280967, 5, 8603, 'Rug', '', '', '', 0.449999988079071044, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 863, 40000), -- 280967
+(280971, 8, 47377, 'Anvil', '', '', '', 1, 1, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 863, 40000), -- 280971
+(280972, 5, 26249, 'Workbench', 'questinteract', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 863, 40000), -- 280972
+(280959, 5, 22545, 'Supply Crate Stack 02', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 863, 40000), -- 280959
+(280964, 5, 23602, 'Pillow', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 863, 40000), -- 280964
+(280944, 19, 6476, 'Mailbox', '', '', '', 0.800000011920928955, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40000), -- 280944
+(280800, 5, 47248, 'Void Orb', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 863, 40000), -- 280800
+(268668, 5, 11604, 'Stool', '', '', '', 0.75, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 337, 40000), -- 268668
+(280960, 5, 15420, 'Wooden Table', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 863, 40000), -- 280960
+(253044, 10, 35385, 'Pillow', '', '', '', 0.75, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 339, 40000), -- 253044
+(280968, 5, 15325, 'Cloth Tent', '', '', '', 1.20000004768371582, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 863, 40000), -- 280968
+(280945, 5, 44342, 'Mailbox', '', '', '', 0.349999994039535522, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 863, 40000), -- 280945
+(280969, 5, 30875, 'Rug', '', '', '', 0.400000005960464477, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 863, 40000), -- 280969
+(280973, 5, 15597, 'Workbench', 'questinteract', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 863, 40000), -- 280973
+(280793, 22, 42710, 'Rift to Fathom\'s Edge', '', '', '', 0.25, 260866, -1, 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 863, 40000), -- 280793
+(221625, 5, 6448, 'Medical Supply Crate', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 40000), -- 221625
+(280949, 5, 15325, 'Cloth Tent', '', '', '', 0.75, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 863, 40000), -- 280949
+(280946, 5, 34378, 'Command Table', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 863, 40000), -- 280946
+(280794, 22, 42710, 'Rift to Telogrus', '', '', '', 0.25, 259377, -1, 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 863, 40000), -- 280794
+(280974, 5, 15947, 'Crystal', 'questinteract', '', '', 0.100000001490116119, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 863, 40000), -- 280974
+(280970, 5, 36368, 'Rug', '', '', '', 0.800000011920928955, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 863, 40000), -- 280970
+(280958, 5, 17621, 'Supply Crate Stack 01', '', '', '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 863, 40000), -- 280958
+(280963, 5, 10561, 'Bed', '', '', '', 0.75, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 863, 40000), -- 280963
+(279607, 22, 42710, 'Rift to Stormwind', '', '', '', 0.25, 258310, -1, 0, 1, 1, 55254, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 863, 40000); -- 279607