diff options
| -rw-r--r-- | sql/updates/world/master/2024_11_27_01_world.sql | 407 |
1 files changed, 407 insertions, 0 deletions
diff --git a/sql/updates/world/master/2024_11_27_01_world.sql b/sql/updates/world/master/2024_11_27_01_world.sql new file mode 100644 index 00000000000..007e3cf5610 --- /dev/null +++ b/sql/updates/world/master/2024_11_27_01_world.sql @@ -0,0 +1,407 @@ +SET @CGUID := 10004551; +SET @OGUID := 10001114; + +SET @NPCTEXTID := 600045; + +-- Creature +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+30; +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, 225323, 2552, 14717, 14772, '0', 0, 0, 0, 0, 1079.1510009765625, -1882.1353759765625, 77.11034393310546875, 4.120485782623291015, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Ginger (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@CGUID+1, 217439, 2552, 14717, 14772, '0', 0, 0, 0, 0, 985.9913330078125, -1844.8697509765625, 92.38242340087890625, 4.408520698547363281, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Iridi (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@CGUID+2, 223652, 2552, 14717, 14772, '0', 0, 0, 0, 0, 1048.8125, -1835.4791259765625, 77.57830810546875, 2.985262870788574218, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Kurron (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@CGUID+3, 217450, 2552, 14717, 14772, '0', 0, 0, 0, 3, 1030.2135009765625, -1920.2447509765625, 78.7917022705078125, 3.879571437835693359, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Unbound Protector (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@CGUID+4, 217450, 2552, 14717, 14772, '0', 0, 0, 0, 1, 1016.23089599609375, -1880.5052490234375, 78.2829742431640625, 2.442274332046508789, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Unbound Protector (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@CGUID+5, 223648, 2552, 14717, 14772, '0', 0, 0, 0, 0, 1051.298583984375, -1898.7222900390625, 74.32220458984375, 0.873009741306304931, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Betta (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@CGUID+6, 218535, 2552, 14717, 14772, '0', 0, 0, 0, 0, 1033.84375, -1845.111083984375, 78.13128662109375, 3.968085050582885742, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Germira (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@CGUID+7, 212708, 2552, 14717, 14772, '0', 0, 0, 0, 1, 1076.732666015625, -1895.0086669921875, 76.95966339111328125, 4.962317943572998046, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Freysworn Cruton (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@CGUID+8, 218729, 2552, 14717, 14772, '0', 0, 0, 0, 0, 1073.7396240234375, -1880.57470703125, 77.11034393310546875, 4.859591960906982421, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Yeonin (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@CGUID+9, 225405, 2552, 14717, 14772, '0', 0, 0, 0, 0, 1066.8367919921875, -1940.38720703125, 85.0833587646484375, 4.739321708679199218, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Bisdina (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@CGUID+10, 227790, 2552, 14717, 14772, '0', 0, 0, 0, 0, 1040.0347900390625, -1825.3853759765625, 80.697418212890625, 4.928842067718505859, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Kothilde (Area: Freywold Village - Difficulty: 0) CreateObject1 (Auras: 458803 - [DNT] 11.0 Z1 - Earthen Shoveling (RPS)) +(@CGUID+11, 217450, 2552, 14717, 14772, '0', 0, 0, 0, 1, 1061.4478759765625, -1977.7708740234375, 83.5718994140625, 6.121231555938720703, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Unbound Protector (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@CGUID+12, 217450, 2552, 14717, 14772, '0', 0, 0, 0, 4, 1080.85595703125, -1939.35595703125, 85.153594970703125, 4.786212921142578125, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Unbound Protector (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@CGUID+13, 217450, 2552, 14717, 14772, '0', 0, 0, 0, 4, 977.58331298828125, -1845.779541015625, 92.62384033203125, 5.041874885559082031, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Unbound Protector (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@CGUID+14, 216094, 2552, 14717, 14772, '0', 0, 0, 0, 1, 962.6944580078125, -1949.03125, 79.864776611328125, 5.678026676177978515, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Kodun (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@CGUID+15, 217450, 2552, 14717, 14772, '0', 0, 0, 0, 1, 955.10418701171875, -1910.470458984375, 82.20006561279296875, 4.896975994110107421, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Unbound Protector (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@CGUID+16, 217450, 2552, 14717, 14772, '0', 0, 0, 0, 4, 955.3038330078125, -1920.470458984375, 82.201507568359375, 1.876337170600891113, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Unbound Protector (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@CGUID+17, 230543, 2552, 14717, 14772, '0', 0, 0, 0, 0, 935.69268798828125, -1921.4427490234375, 81.94881439208984375, 0.775799036026000976, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Archivist Rohlnar (Area: Freywold Village - Difficulty: 0) CreateObject1 (Auras: 452224 - Cosmetic - Reading Book - All Races [DNT]) +(@CGUID+18, 225406, 2552, 14717, 14772, '0', 0, 0, 0, 0, 915.51214599609375, -1921.7742919921875, 75.5316162109375, 1.643771171569824218, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Marisda (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@CGUID+19, 217440, 2552, 14717, 14772, '0', 0, 0, 0, 0, 913.11114501953125, -1921.7396240234375, 75.529052734375, 1.319953203201293945, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Albetha (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@CGUID+20, 217450, 2552, 14717, 14772, '0', 0, 0, 0, 1, 907.01910400390625, -1927.642333984375, 78.58917236328125, 1.531588673591613769, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Unbound Protector (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@CGUID+21, 224424, 2552, 14717, 14772, '0', 0, 0, 0, 1, 892.22052001953125, -1891.3038330078125, 90.406494140625, 0.861715853214263916, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Velkura (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@CGUID+22, 223649, 2552, 14717, 14772, '0', 0, 0, 0, 0, 870.58160400390625, -1895.3333740234375, 84.9724273681640625, 0.047206658869981765, 120, 0, 0, 0, NULL, NULL, NULL, NULL, 57689), -- Maluc (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@CGUID+23, 222499, 2552, 14717, 14772, '0', 0, 0, 0, 0, 939.62847900390625, -1943.6805419921875, 96.0151214599609375, 0, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 57689), -- Mossy Snail (Area: Freywold Village - Difficulty: 0) CreateObject2 +(@CGUID+24, 215038, 2552, 14717, 14772, '0', 0, 0, 0, 0, 1014.7100830078125, -1934.123291015625, 80.24932861328125, 4.320961475372314453, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 57689), -- Thistlestar (Area: Freywold Village - Difficulty: 0) CreateObject2 +(@CGUID+25, 215035, 2552, 14717, 14772, '0', 0, 0, 0, 0, 984.154541015625, -1936.13720703125, 79.86316680908203125, 2.894485950469970703, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 57689), -- Freefoot Mouse (Area: Freywold Village - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+26, 215035, 2552, 14717, 14772, '0', 0, 0, 0, 0, 1040, -1944.03125, 81.31775665283203125, 4.268261909484863281, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 57689), -- Freefoot Mouse (Area: Freywold Village - Difficulty: 0) CreateObject2 +(@CGUID+27, 215035, 2552, 14717, 14772, '0', 0, 0, 0, 0, 991.4444580078125, -1887.8697509765625, 80.127685546875, 3.550877809524536132, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 57689), -- Freefoot Mouse (Area: Freywold Village - Difficulty: 0) CreateObject2 (possible waypoints or random movement) +(@CGUID+28, 215034, 2552, 14717, 14772, '0', 0, 0, 0, 0, 962.40625, -1910.3055419921875, 81.817230224609375, 3.501403093338012695, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 57689), -- Salt-Ear Ferret (Area: Freywold Village - Difficulty: 0) CreateObject2 +(@CGUID+29, 215038, 2552, 14717, 14772, '0', 0, 0, 0, 0, 1091.7725830078125, -1943.4896240234375, 88.516632080078125, 4.754819393157958984, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 57689), -- Thistlestar (Area: Freywold Village - Difficulty: 0) CreateObject2 +(@CGUID+30, 215038, 2552, 14717, 14772, '0', 0, 0, 0, 0, 1104.1180419921875, -1952.8350830078125, 86.3384246826171875, 3.757572650909423828, 120, 3, 0, 1, NULL, NULL, NULL, NULL, 57689); -- Thistlestar (Area: Freywold Village - Difficulty: 0) CreateObject2 +DELETE FROM `creature_addon` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+30; +INSERT INTO `creature_addon` (`guid`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(@CGUID+7, 0, 0, 0, 0, 0, 1, 0, 1029, 0, 0, 0, 0, ''), -- Freysworn Cruton +(@CGUID+9, 0, 0, 0, 0, 0, 1, 0, 461, 0, 0, 0, 0, ''), -- Bisdina +(@CGUID+16, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, ''); -- Unbound Protector + +-- Delete duplicate spawn +DELETE FROM `creature` WHERE `guid` = 10000717; +DELETE FROM `creature_addon` WHERE `guid` = 10000717; + +-- GameObject +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+76; +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, 433035, 2552, 14717, 14772, '0', 0, 0, 926.171875, -1875.6961669921875, 89.86664581298828125, 4.817109584808349609, 0, 0, -0.66913032531738281, 0.74314504861831665, 120, 255, 1, 57689), -- Anvil (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+1, 446256, 2552, 14717, 14772, '0', 0, 0, 910.444580078125, -1907.7132568359375, 75.4457244873046875, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+2, 446257, 2552, 14717, 14772, '0', 0, 0, 910.085205078125, -1933.5672607421875, 78.5132598876953125, 3.18142867088317871, 0, 0, -0.9998016357421875, 0.019916549324989318, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+3, 446259, 2552, 14717, 14772, '0', 0, 0, 918.26409912109375, -1931.2679443359375, 78.50266265869140625, 4.721115589141845703, 0, 0, -0.70401477813720703, 0.71018528938293457, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+4, 446188, 2552, 14717, 14772, '0', 0, 0, 944.4034423828125, -1835.730712890625, 93.95055389404296875, 0.611037492752075195, 0, 0, 0.300787925720214843, 0.953691065311431884, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+5, 446189, 2552, 14717, 14772, '0', 0, 0, 946.58148193359375, -1836.1864013671875, 93.95055389404296875, 2.155655384063720703, 0, 0, 0.880931854248046875, 0.473243147134780883, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+6, 446236, 2552, 14717, 14772, '0', 0, 0, 900.3719482421875, -1916.1572265625, 76.20111846923828125, 1.589601755142211914, 0, 0, 0.713724136352539062, 0.700426876544952392, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+7, 446156, 2552, 14717, 14772, '0', 0, 0, 946.88555908203125, -1851.5687255859375, 70.016815185546875, 2.16420149803161621, 0, 0, 0.882946014404296875, 0.469474554061889648, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+8, 446190, 2552, 14717, 14772, '0', 0, 0, 945.8955078125, -1831.8553466796875, 93.95055389404296875, 3.752633571624755859, 0, 0, -0.9536905288696289, 0.300789564847946166, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+9, 466212, 2552, 14717, 14772, '0', 0, 0, 953.29937744140625, -1974.3875732421875, 74.4226837158203125, 4.084058284759521484, 0, 0, -0.89100933074951171, 0.453984975814819335, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+10, 446237, 2552, 14717, 14772, '0', 0, 0, 914.31781005859375, -1927.498291015625, 78.50252532958984375, 4.729841232299804687, 0, 0, -0.70090961456298828, 0.71325010061264038, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+11, 446157, 2552, 14717, 14772, '0', 0, 0, 944.88677978515625, -1851.4217529296875, 70.016815185546875, 0.654495000839233398, 0, 0, 0.321437835693359375, 0.94693070650100708, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+12, 446191, 2552, 14717, 14772, '0', 0, 0, 947.2008056640625, -1833.69580078125, 93.95055389404296875, 3.831170558929443359, 0, 0, -0.9411468505859375, 0.33799794316291809, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+13, 466213, 2552, 14717, 14772, '0', 0, 0, 958.39788818359375, -1980.7552490234375, 74.42254638671875, 0.977370083332061767, 0, 0, 0.469465255737304687, 0.882950961589813232, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+14, 446238, 2552, 14717, 14772, '0', 0, 0, 903.55999755859375, -1933.63427734375, 78.5023193359375, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+15, 446158, 2552, 14717, 14772, '0', 0, 0, 949.21514892578125, -1847.9974365234375, 70.016815185546875, 3.752456188201904296, 0, 0, -0.95371723175048828, 0.3007049560546875, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+16, 466214, 2552, 14717, 14772, '0', 0, 0, 961.19903564453125, -1979.414794921875, 74.42255401611328125, 4.136416435241699218, 0, 0, -0.87882041931152343, 0.47715267539024353, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+17, 446239, 2552, 14717, 14772, '0', 0, 0, 902.412841796875, -1913.0196533203125, 76.16986846923828125, 3.170431375503540039, 0, 0, -0.99989604949951171, 0.014418772421777248, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+18, 446159, 2552, 14717, 14772, '0', 0, 0, 948.81756591796875, -1850.186279296875, 70.016815185546875, 2.207836151123046875, 0, 0, 0.892977714538574218, 0.450100898742675781, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+19, 466215, 2552, 14717, 14772, '0', 0, 0, 958.68511962890625, -1977.702392578125, 74.4194793701171875, 4.136416435241699218, 0, 0, -0.87882041931152343, 0.47715267539024353, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+20, 446244, 2552, 14717, 14772, '0', 0, 0, 910.5673828125, -1913.854736328125, 75.4457244873046875, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+21, 446233, 2552, 14717, 14772, '0', 0, 0, 914.82843017578125, -1913.7783203125, 75.448333740234375, 3.160928010940551757, 0, 0, -0.99995326995849609, 0.009667475707828998, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+22, 446245, 2552, 14717, 14772, '0', 0, 0, 929.529541015625, -1926.7406005859375, 78.4716033935546875, 3.946853876113891601, 0, 0, -0.92003345489501953, 0.391839832067489624, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+23, 446187, 2552, 14717, 14772, '0', 0, 0, 919.78961181640625, -1825.0037841796875, 89.098236083984375, 5.92556619644165039, 0, 0, -0.17785835266113281, 0.98405611515045166, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+24, 429687, 2552, 14717, 14772, '0', 0, 0, 1066.8367919921875, -1940.329833984375, 84.92975616455078125, 4.764751911163330078, 0, 0, -0.68835353851318359, 0.725375354290008544, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+25, 466209, 2552, 14717, 14772, '0', 0, 0, 950.10015869140625, -1975.853271484375, 74.412200927734375, 0.977370083332061767, 0, 0, 0.469465255737304687, 0.882950961589813232, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+26, 446246, 2552, 14717, 14772, '0', 0, 0, 914.7037353515625, -1907.642822265625, 75.44942474365234375, 3.155403614044189453, 0, 0, -0.99997615814208984, 0.006905339658260345, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+27, 446154, 2552, 14717, 14772, '0', 0, 0, 944.903076171875, -1848.795166015625, 70.016815185546875, 5.349431037902832031, 0, 0, -0.45009994506835937, 0.892978191375732421, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+28, 466676, 2552, 14717, 14772, '0', 0, 0, 912.47021484375, -1918.9241943359375, 75.4457244873046875, 4.733694076538085937, 0, 0, -0.69953441619873046, 0.714598894119262695, 120, 255, 1, 57689), -- Stool (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+29, 466210, 2552, 14717, 14772, '0', 0, 0, 960.6409912109375, -1982.29296875, 74.4225311279296875, 1.003550648689270019, 0, 0, 0.480982780456542968, 0.876730024814605712, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+30, 446235, 2552, 14717, 14772, '0', 0, 0, 910.49755859375, -1910.75, 75.4457244873046875, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+31, 446247, 2552, 14717, 14772, '0', 0, 0, 925.67633056640625, -1927.6868896484375, 78.4818572998046875, 5.523966789245605468, 0, 0, -0.37055778503417968, 0.928809404373168945, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+32, 446155, 2552, 14717, 14772, '0', 0, 0, 946.71038818359375, -1847.4417724609375, 70.016815185546875, 5.427972793579101562, 0, 0, -0.41469383239746093, 0.90996098518371582, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+33, 466677, 2552, 14717, 14772, '0', 0, 0, 913.70416259765625, -1918.921142578125, 75.4457244873046875, 4.724883079528808593, 0, 0, -0.70267581939697265, 0.711510121822357177, 120, 255, 1, 57689), -- Stool (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+34, 466211, 2552, 14717, 14772, '0', 0, 0, 952.96771240234375, -1977.4854736328125, 74.422637939453125, 0.977370083332061767, 0, 0, 0.469465255737304687, 0.882950961589813232, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+35, 446240, 2552, 14717, 14772, '0', 0, 0, 906.89141845703125, -1931.6676025390625, 78.502471923828125, 4.721115589141845703, 0, 0, -0.70401477813720703, 0.71018528938293457, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+36, 466678, 2552, 14717, 14772, '0', 0, 0, 916.482177734375, -1918.88037109375, 75.4457244873046875, 4.74849700927734375, 0, 0, -0.69422626495361328, 0.719756841659545898, 120, 255, 1, 57689), -- Stool (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+37, 446241, 2552, 14717, 14772, '0', 0, 0, 909.3677978515625, -1895.712646484375, 76.160400390625, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+38, 446242, 2552, 14717, 14772, '0', 0, 0, 898.43768310546875, -1912.9061279296875, 76.16042327880859375, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+39, 446192, 2552, 14717, 14772, '0', 0, 0, 922.50189208984375, -1824.2705078125, 89.098236083984375, 4.232596874237060546, 0, 0, -0.85486698150634765, 0.518847227096557617, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+40, 429692, 2552, 14717, 14772, '0', 0, 0, 1104.170166015625, -1900.3507080078125, 92.7378082275390625, 6.021387100219726562, 0, 0, -0.13052558898925781, 0.991444945335388183, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+41, 446243, 2552, 14717, 14772, '0', 0, 0, 914.93603515625, -1933.4844970703125, 78.50250244140625, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+42, 446193, 2552, 14717, 14772, '0', 0, 0, 943.27093505859375, -1831.769775390625, 93.95055389404296875, 5.340882301330566406, 0, 0, -0.45391273498535156, 0.891046106815338134, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+43, 446252, 2552, 14717, 14772, '0', 0, 0, 912.529541015625, -1897.694580078125, 76.16912078857421875, 1.584510564804077148, 0, 0, 0.711938858032226562, 0.702241480350494384, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+44, 446194, 2552, 14717, 14772, '0', 0, 0, 943.072509765625, -1833.7652587890625, 93.95055389404296875, 0.567404925823211669, 0, 0, 0.279911994934082031, 0.960025668144226074, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+45, 466216, 2552, 14717, 14772, '0', 0, 0, 951.171142578125, -1972.96875, 74.4132232666015625, 4.11023712158203125, 0, 0, -0.88499069213867187, 0.465608686208724975, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+46, 446253, 2552, 14717, 14772, '0', 0, 0, 923.282470703125, -1923.38232421875, 78.500885009765625, 5.515239715576171875, 0, 0, -0.37460708618164062, 0.927183687686920166, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+47, 465705, 2552, 14717, 14772, '0', 0, 0, 922.28369140625, -1914.01025390625, 75.74831390380859375, 5.692810535430908203, 0, 0, -0.29091930389404296, 0.956747591495513916, 120, 255, 1, 57689), -- Cooking Fire (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+48, 429688, 2552, 14717, 14772, '0', 0, 0, 1104.923583984375, -1906.060791015625, 92.78137969970703125, 0.837757468223571777, 0, 0, 0.406736373901367187, 0.913545548915863037, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+49, 446255, 2552, 14717, 14772, '0', 0, 0, 909.3353271484375, -1927.5364990234375, 78.5025177001953125, 4.729841232299804687, 0, 0, -0.70090961456298828, 0.71325010061264038, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+50, 429689, 2552, 14717, 14772, '0', 0, 0, 1102.4444580078125, -1891.9583740234375, 92.78778839111328125, 5.628688335418701171, 0, 0, -0.32143878936767578, 0.946930348873138427, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+51, 446248, 2552, 14717, 14772, '0', 0, 0, 921.4599609375, -1933.3414306640625, 78.502655029296875, 3.169897317886352539, 0, 0, -0.99989986419677734, 0.014151735231280326, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+52, 446195, 2552, 14717, 14772, '0', 0, 0, 976.30804443359375, -1951.1927490234375, 80.2471466064453125, 4.825821876525878906, 0, 0, -0.66588687896728515, 0.746052742004394531, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+53, 433036, 2552, 14717, 14772, '0', 0, 0, 1026.8038330078125, -1919.0989990234375, 78.46379852294921875, 3.141592741012573242, 0, 0, -1, 0, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+54, 429690, 2552, 14717, 14772, '0', 0, 0, 1108.513916015625, -1902.420166015625, 92.78137969970703125, 3.94444584846496582, 0, 0, -0.92050457000732421, 0.3907318115234375, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+55, 446249, 2552, 14717, 14772, '0', 0, 0, 900.31884765625, -1909.9139404296875, 76.19964599609375, 4.766410350799560546, 0, 0, -0.68775177001953125, 0.725945949554443359, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+56, 446204, 2552, 14717, 14772, '0', 0, 0, 1034.8037109375, -1895.65234375, 78.04912567138671875, 5.427974700927734375, 0, 0, -0.41469287872314453, 0.909961462020874023, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+57, 433037, 2552, 14717, 14772, '0', 0, 0, 921.19097900390625, -1875.0572509765625, 89.81894683837890625, 2.103119850158691406, 0, 0, 0.868198394775390625, 0.496217250823974609, 120, 255, 1, 57689), -- Forge (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+58, 429691, 2552, 14717, 14772, '0', 0, 0, 1106.564208984375, -1895.032958984375, 92.73703765869140625, 2.495818138122558593, 0, 0, 0.948323249816894531, 0.317305892705917358, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+59, 465869, 2552, 14717, 14772, '0', 0, 0, 917.69573974609375, -1918.8514404296875, 75.4457244873046875, 4.677939414978027343, 0, 0, -0.71918106079101562, 0.694822728633880615, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+60, 446250, 2552, 14717, 14772, '0', 0, 0, 925.069091796875, -1931.506591796875, 78.48171234130859375, 0.820303261280059814, 0, 0, 0.398748397827148437, 0.917060375213623046, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+61, 446205, 2552, 14717, 14772, '0', 0, 0, 1033.0576171875, -1897.2578125, 78.04912567138671875, 5.471609115600585937, 0, 0, -0.39474296569824218, 0.918791592121124267, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+62, 433038, 2552, 14717, 14772, '0', 0, 0, 963.34027099609375, -1919.5972900390625, 81.56813812255859375, 2.207840442657470703, 0, 0, 0.892978668212890625, 0.450098991394042968, 120, 255, 1, 57689), -- Mailbox (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+63, 433039, 2552, 14717, 14772, '0', 0, 0, 976.22393798828125, -1929.52783203125, 79.83160400390625, 5.715955257415771484, 0, 0, -0.27982807159423828, 0.960050106048583984, 120, 255, 1, 57689), -- Chair (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+64, 446260, 2552, 14717, 14772, '0', 0, 0, 915.63348388671875, -1895.548583984375, 76.16037750244140625, 3.145498991012573242, 0, 0, -0.99999809265136718, 0.001953125, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+65, 446261, 2552, 14717, 14772, '0', 0, 0, 914.7724609375, -1910.68310546875, 75.45215606689453125, 3.132858037948608398, 0, 0, 0.999990463256835937, 0.004367320332676172, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+66, 414379, 2552, 14717, 14772, '0', 0, 0, 927.54864501953125, -1630.439208984375, 83.53414154052734375, 5.619617462158203125, 0, 0, -0.3257303237915039, 0.945462703704833984, 120, 255, 1, 57689), -- Door (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+67, 422668, 2552, 14717, 14772, '0', 0, 0, 988.05731201171875, -1903.779541015625, 78.23577880859375, 0, 0, 0, 0, 1, 120, 255, 1, 57689), -- Bucket of Clay (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+68, 464019, 2552, 14717, 14772, '0', 0, 0, 937.8975830078125, -1866.3629150390625, 94.08280181884765625, 5.398197650909423828, 0.897220134735107421, -0.42794704437255859, 0.085825920104980468, 0.06701737642288208, 120, 255, 1, 57689), -- Stones of the Wolds Part 1 (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+69, 422668, 2552, 14717, 14772, '0', 0, 0, 1008.7396240234375, -1913.7725830078125, 78.19242095947265625, 0, 0, 0, 0, 1, 120, 255, 1, 57689), -- Bucket of Clay (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+70, 414335, 2552, 14717, 14772, '0', 0, 0, 1153.7552490234375, -1779.74658203125, 77.69769287109375, 4.139378547668457031, 0, 0, -0.87811279296875, 0.478453665971755981, 120, 255, 1, 57689), -- Irradiated Mycobloom (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+71, 459427, 2552, 14717, 14772, '0', 0, 0, 1000.62847900390625, -1913.9896240234375, 77.6757049560546875, 0, 0, 0, 0, 1, 120, 255, 1, 57689), -- Healing Bubbles (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+72, 466229, 2552, 14717, 14772, '0', 0, 0, 933.25177001953125, -1803.1927490234375, 89.40048980712890625, 4.574147224426269531, 0, 0, -0.75425529479980468, 0.656581223011016845, 120, 255, 1, 57689), -- Adelgonn's Journal (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+73, 446234, 2552, 14717, 14772, '0', 0, 0, 862.34625244140625, -1946.48046875, 63.75259017944335937, 4.729841232299804687, 0, 0, -0.70090961456298828, 0.71325010061264038, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+74, 463992, 2552, 14717, 14772, '0', 0, 0, 862.420166015625, -1947.642333984375, 64.84537506103515625, 1.553039193153381347, 0, 0, 0.700800895690917968, 0.71335691213607788, 120, 255, 1, 57689), -- Observational Notes: Stormrooks (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+75, 446258, 2552, 14717, 14772, '0', 0, 0, 861.169677734375, -1884.7869873046875, 66.69161224365234375, 1.582070350646972656, 0, 0, 0.711081504821777343, 0.703109562397003173, 120, 255, 1, 57689), -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +(@OGUID+76, 446254, 2552, 14717, 14772, '0', 0, 0, 861.12359619140625, -1880.7418212890625, 66.689361572265625, 4.729841232299804687, 0, 0, -0.70090961456298828, 0.71325010061264038, 120, 255, 1, 57689); -- Bench (Area: Freywold Village - Difficulty: 0) CreateObject1 +DELETE FROM `gameobject_addon` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+76; +INSERT INTO `gameobject_addon` (`guid`, `parent_rotation0`, `parent_rotation1`, `parent_rotation2`, `parent_rotation3`, `WorldEffectID`, `AIAnimKitID`) VALUES +(@OGUID+1, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Bench +(@OGUID+2, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Bench +(@OGUID+3, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Bench +(@OGUID+4, 0, 0, 0.893017828464508056, 0.450021326541900634, 0, 0), -- Chair +(@OGUID+5, 0, 0, 0.893017828464508056, 0.450021326541900634, 0, 0), -- Chair +(@OGUID+6, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Bench +(@OGUID+7, 0, 0, 0.894933879375457763, 0.446198910474777221, 0, 0), -- Chair +(@OGUID+8, 0, 0, 0.893017828464508056, 0.450021326541900634, 0, 0), -- Chair +(@OGUID+9, 0, 0, 0.878820538520812988, -0.47715246677398681, 0, 0), -- Chair +(@OGUID+10, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Bench +(@OGUID+11, 0, 0, 0.894933879375457763, 0.446198910474777221, 0, 0), -- Chair +(@OGUID+12, 0, 0, 0.893017828464508056, 0.450021326541900634, 0, 0), -- Chair +(@OGUID+13, 0, 0, 0.878820538520812988, -0.47715246677398681, 0, 0), -- Chair +(@OGUID+14, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Bench +(@OGUID+15, 0, 0, 0.894933879375457763, 0.446198910474777221, 0, 0), -- Chair +(@OGUID+16, 0, 0, 0.878820538520812988, -0.47715246677398681, 0, 0), -- Chair +(@OGUID+17, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Bench +(@OGUID+18, 0, 0, 0.894933879375457763, 0.446198910474777221, 0, 0), -- Chair +(@OGUID+19, 0, 0, 0.878820538520812988, -0.47715246677398681, 0, 0), -- Chair +(@OGUID+20, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Bench +(@OGUID+21, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Bench +(@OGUID+22, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Bench +(@OGUID+23, 0, 0, 0.893017828464508056, 0.450021326541900634, 0, 0), -- Chair +(@OGUID+25, 0, 0, 0.878820538520812988, -0.47715246677398681, 0, 0), -- Chair +(@OGUID+26, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Bench +(@OGUID+27, 0, 0, 0.894933879375457763, 0.446198910474777221, 0, 0), -- Chair +(@OGUID+28, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Stool +(@OGUID+29, 0, 0, 0.878820538520812988, -0.47715246677398681, 0, 0), -- Chair +(@OGUID+30, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Bench +(@OGUID+31, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Bench +(@OGUID+32, 0, 0, 0.894933879375457763, 0.446198910474777221, 0, 0), -- Chair +(@OGUID+33, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Stool +(@OGUID+34, 0, 0, 0.878820538520812988, -0.47715246677398681, 0, 0), -- Chair +(@OGUID+35, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Bench +(@OGUID+36, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Stool +(@OGUID+37, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Bench +(@OGUID+39, 0, 0, 0.893017828464508056, 0.450021326541900634, 0, 0), -- Chair +(@OGUID+41, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Bench +(@OGUID+42, 0, 0, 0.893017828464508056, 0.450021326541900634, 0, 0), -- Chair +(@OGUID+43, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Bench +(@OGUID+44, 0, 0, 0.893017828464508056, 0.450021326541900634, 0, 0), -- Chair +(@OGUID+45, 0, 0, 0.878820538520812988, -0.47715246677398681, 0, 0), -- Chair +(@OGUID+46, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Bench +(@OGUID+47, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Cooking Fire +(@OGUID+49, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Bench +(@OGUID+51, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Bench +(@OGUID+52, 0, 0, 0.878820538520812988, -0.47715246677398681, 0, 0), -- Bench +(@OGUID+55, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Bench +(@OGUID+56, 0, 0, 0.000000087422776573, 1, 0, 0), -- Chair +(@OGUID+59, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Chair +(@OGUID+60, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Bench +(@OGUID+61, 0, 0, 0.000000087422776573, 1, 0, 0), -- Chair +(@OGUID+64, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Bench +(@OGUID+65, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Bench +(@OGUID+68, 0, 0, 0, 1, 2100, 0), -- Stones of the Wolds Part 1 +(@OGUID+72, 0, 0, 0, 1, 2100, 0), -- Adelgonn's Journal +(@OGUID+93, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Bench +(@OGUID+73, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Bench +(@OGUID+74, 0, 0, 0, 1, 2100, 0), -- Observational Notes: Stormrooks +(@OGUID+75, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0), -- Bench +(@OGUID+76, 0, 0, 0.999961912631988525, -0.00872652977705001, 0, 0); -- Bench + +-- Template Addon +DELETE FROM `creature_template_addon` WHERE `entry` IN (230543 /*230543 (Archivist Rohlnar) - Cosmetic - Reading Book - All Races [DNT]*/, 227790 /*227790 (Kothilde) - [DNT] 11.0 Z1 - Earthen Shoveling (RPS)*/, 217450 /*217450 (Unbound Protector)*/); +INSERT INTO `creature_template_addon` (`entry`, `PathId`, `mount`, `StandState`, `AnimTier`, `VisFlags`, `SheathState`, `PvpFlags`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `visibilityDistanceType`, `auras`) VALUES +(230543, 0, 0, 0, 0, 0, 0, 0, 0, 27930, 0, 0, 0, '452224'), -- 230543 (Archivist Rohlnar) - Cosmetic - Reading Book - All Races [DNT] +(227790, 0, 0, 0, 0, 0, 1, 0, 0, 30555, 0, 0, 0, '458803'), -- 227790 (Kothilde) - [DNT] 11.0 Z1 - Earthen Shoveling (RPS) +(217450, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, ''); -- 217450 (Unbound Protector) + +DELETE FROM `gameobject_template_addon` WHERE `entry` IN (463992 /*Observational Notes: Stormrooks*/, 466229 /*Adelgonn's Journal*/, 464019 /*Stones of the Wolds Part 1*/, 429692 /*Chair*/, 429687 /*Chair*/); +INSERT INTO `gameobject_template_addon` (`entry`, `faction`, `flags`, `WorldEffectID`, `AIAnimKitID`) VALUES +(463992, 0, 0x40000, 2100, 0), -- Observational Notes: Stormrooks +(466229, 0, 0x40000, 2100, 0), -- Adelgonn's Journal +(464019, 0, 0x40000, 2100, 0), -- Stones of the Wolds Part 1 +(429692, 114, 0x0, 0, 0), -- Chair +(429687, 114, 0x0, 0, 0); -- Chair + +-- Template +UPDATE `creature_template` SET `faction`=3407, `npcflag`=65536, `BaseAttackTime`=2000, `unit_flags2`=0x800 WHERE `entry`=217440; -- Albetha +UPDATE `creature_template` SET `faction`=3407, `npcflag`=128, `BaseAttackTime`=2000, `unit_flags2`=0x800 WHERE `entry`=225406; -- Marisda +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags2`=0x800 WHERE `entry`=230543; -- Archivist Rohlnar +UPDATE `creature_template` SET `faction`=3407, `npcflag`=3, `BaseAttackTime`=2000, `unit_flags`=0x100, `unit_flags2`=0x800 WHERE `entry`=216094; -- Kodun +UPDATE `creature_template` SET `faction`=35, `npcflag`=2, `BaseAttackTime`=2000, `unit_flags`=0x300, `unit_flags2`=0x800 WHERE `entry`=223637; -- Natalia Pearce +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=0x2000300, `unit_flags2`=0x800, `unit_flags3`=0x1000000 WHERE `entry`=217193; -- Invis bunny for spell targeting [DNT] +UPDATE `creature_template` SET `faction`=3407, `npcflag`=128, `BaseAttackTime`=2000, `unit_flags2`=0x800 WHERE `entry`=225405; -- Bisdina +UPDATE `creature_template` SET `faction`=35, `BaseAttackTime`=2000, `unit_flags`=0x2000000, `unit_flags2`=0x4000800, `unit_flags3`=0x40000000 WHERE `entry`=228709; -- Invis Bunny - POI blob [DNT] + +DELETE FROM `gameobject_template` WHERE `entry` IN (444085 /*Crimson Charmer*/, 444083 /*Amber Bloom*/); +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`, `Data34`, `ContentTuningId`, `VerifiedBuild`) VALUES +(444085, 10, 90015, 'Crimson Charmer', 'questinteract', '', '', 1, 3598, 0, 0, 3000, 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, 57689), -- Crimson Charmer +(444083, 10, 90866, 'Amber Bloom', 'questinteract', '', '', 1, 3598, 0, 0, 3000, 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, 57689); -- Amber Bloom + +-- Gossip +DELETE FROM `creature_template_gossip` WHERE (`CreatureID`=216094 AND `MenuID`=34008) OR (`CreatureID`=223649 AND `MenuID`=34964) OR (`CreatureID`=217439 AND `MenuID`=6944) OR (`CreatureID`=223652 AND `MenuID`=34971) OR (`CreatureID`=223648 AND `MenuID`=34969); +INSERT INTO `creature_template_gossip` (`CreatureID`, `MenuID`, `VerifiedBuild`) VALUES +(216094, 34008, 57689), -- Kodun +(223649, 34964, 57689), -- Maluc +(217439, 6944, 57689), -- Iridi +(223652, 34971, 57689), -- Kurron +(223648, 34969, 57689); -- Betta + +DELETE FROM `npc_text` WHERE `ID` BETWEEN @NPCTEXTID+0 AND @NPCTEXTID+3; +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, 264315, 0, 0, 0, 0, 0, 0, 0, 57689), -- 223648 (Betta) +(@NPCTEXTID+1, 1, 0, 0, 0, 0, 0, 0, 0, 257442, 0, 0, 0, 0, 0, 0, 0, 57689), -- 216094 (Kodun) +(@NPCTEXTID+2, 1, 0, 0, 0, 0, 0, 0, 0, 264320, 0, 0, 0, 0, 0, 0, 0, 57689), -- 223652 (Kurron) +(@NPCTEXTID+3, 1, 0, 0, 0, 0, 0, 0, 0, 264299, 0, 0, 0, 0, 0, 0, 0, 57689); -- 223649 (Maluc) + +DELETE FROM `gossip_menu` WHERE (`MenuID`=34969 AND `TextID`=@NPCTEXTID+0) OR (`MenuID`=34008 AND `TextID`=@NPCTEXTID+1) OR (`MenuID`=34971 AND `TextID`=@NPCTEXTID+2) OR (`MenuID`=34964 AND `TextID`=@NPCTEXTID+3); +INSERT INTO `gossip_menu` (`MenuID`, `TextID`, `VerifiedBuild`) VALUES +(34969, @NPCTEXTID+0, 57689), -- 223648 (Betta) +(34008, @NPCTEXTID+1, 57689), -- 216094 (Kodun) +(34971, @NPCTEXTID+2, 57689), -- 223652 (Kurron) +(34964, @NPCTEXTID+3, 57689); -- 223649 (Maluc) + + +UPDATE `gossip_menu` SET `VerifiedBuild`=57689 WHERE (`MenuID`=6944 AND `TextID`=7778); + +UPDATE `gossip_menu_option` SET `VerifiedBuild`=57689 WHERE (`MenuID`=6944 AND `OptionID`=0); + +-- Quest +DELETE FROM `ui_map_quest_line` WHERE (`UIMapId`=2248 AND `QuestLineId` IN (5716,5652,5596)); +INSERT INTO `ui_map_quest_line` (`UIMapId`, `QuestLineId`, `VerifiedBuild`) VALUES +(2248, 5716, 57689), +(2248, 5652, 57689), +(2248, 5596, 57689); + +UPDATE `ui_map_quest_line` SET `VerifiedBuild`=57689 WHERE (`UIMapId`=2248 AND `QuestLineId` IN (5711,5672,5671,5670,5637,5627,5609,5602,5598,5593,5572,5561,5558,5551,5550,5544,5540,5539,5535,5534,5533,5531,5530,5529,5526,5525,5523,5521,5520,5513,5506,1416,5710,5709,5655,5654,5653,5651,5647,5644,5634,5628,5626,5625,5624,5623,5622,5621,5620,5619,5611,5610,5608,5607,5606,5605,5603,5601,5597,5590,5574,5565,5563,5562,5559,5552,5532,5527,5524,5522,5509,5591)); + +DELETE FROM `ui_map_quest` WHERE (`UIMapId`=2248 AND `QuestId` IN (83538,81767,81656,83930,82288)); +INSERT INTO `ui_map_quest` (`UIMapId`, `QuestId`, `VerifiedBuild`) VALUES +(2248, 83538, 57689), -- Excavation Liberation +(2248, 81767, 57689), -- Scrounge that Scrap! +(2248, 81656, 57689), -- Nothing to Waste +(2248, 83930, 57689), -- Deworming Solution +(2248, 82288, 57689); -- Work Hard, Play Hard + +DELETE FROM `creature_queststarter` WHERE (`id`=218535 AND `quest`=82792) OR (`id`=212708 AND `quest`=78570); +INSERT INTO `creature_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(218535, 82792, 57689), -- All Ore Nothing offered by Germira +(212708, 78570, 57689); -- Frayed Legacy offered by Freysworn Cruton + +-- Difficulty +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2462, `StaticFlags1`=0x10000000, `VerifiedBuild`=57689 WHERE (`Entry`=217440 AND `DifficultyID`=0); -- 217440 (Albetha) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2462, `StaticFlags1`=0x10000000, `VerifiedBuild`=57689 WHERE (`Entry`=225406 AND `DifficultyID`=0); -- 225406 (Marisda) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2797, `StaticFlags1`=0x10000000, `VerifiedBuild`=57689 WHERE (`Entry`=230543 AND `DifficultyID`=0); -- 230543 (Archivist Rohlnar) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2462, `StaticFlags1`=0x10000000, `VerifiedBuild`=57689 WHERE (`Entry`=216094 AND `DifficultyID`=0); -- 216094 (Kodun) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2797, `StaticFlags1`=0x10000000, `VerifiedBuild`=57689 WHERE (`Entry`=223637 AND `DifficultyID`=0); -- 223637 (Natalia Pearce) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2797, `StaticFlags1`=0x20000000, `VerifiedBuild`=57689 WHERE (`Entry`=217193 AND `DifficultyID`=0); -- 217193 (Invis bunny for spell targeting [DNT]) - Floating +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2797, `StaticFlags1`=0x10000000, `VerifiedBuild`=57689 WHERE (`Entry`=225405 AND `DifficultyID`=0); -- 225405 (Bisdina) - CanSwim +UPDATE `creature_template_difficulty` SET `ContentTuningID`=2797, `StaticFlags1`=0x20000100, `VerifiedBuild`=57689 WHERE (`Entry`=228709 AND `DifficultyID`=0); -- 228709 (Invis Bunny - POI blob [DNT]) - Sessile, Floating + +-- Path for Redwing Falcon +SET @MOVERGUID := 10000565; +SET @ENTRY := 215036; +SET @PATHOFFSET := 0; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 8.1667, 'Redwing Falcon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1085.9054, -1865.3073, 111.40017, NULL, 0), +(@PATH, 1, 1083.9955, -1855.5425, 111.40017, NULL, 0), +(@PATH, 2, 1089.5496, -1847.2872, 111.40017, NULL, 0), +(@PATH, 3, 1099.3143, -1845.3773, 111.40017, NULL, 0), +(@PATH, 4, 1107.5696, -1850.9314, 111.40017, NULL, 0), +(@PATH, 5, 1109.4796, -1860.6962, 111.40017, NULL, 0), +(@PATH, 6, 1103.9254, -1868.9514, 111.40017, NULL, 0), +(@PATH, 7, 1094.1606, -1870.8615, 111.40017, NULL, 0); + +UPDATE `creature` SET `position_x`=1085.9054, `position_y`=-1865.3073, `position_z`=111.40017, `orientation`=0, `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Redwing Falcon +SET @MOVERGUID := 10000596; +SET @ENTRY := 215036; +SET @PATHOFFSET := 1; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 8.2250, 'Redwing Falcon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 997.17883, -1919.0712, 102.7588, NULL, 0), +(@PATH, 1, 993.8993, -1901.7604, 100.33352, NULL, 0), +(@PATH, 2, 982.7153, -1891.1962, 100.33352, NULL, 0), +(@PATH, 3, 963.6493, -1891.2084, 105.89417, NULL, 0), +(@PATH, 4, 951.5764, -1905.0278, 112.88206, NULL, 0), +(@PATH, 5, 959.80206, -1941.9462, 112.88206, NULL, 0), +(@PATH, 6, 975.9028, -1946.132, 112.88206, NULL, 0), +(@PATH, 7, 981.02606, -1941.5747, 112.83701, NULL, 0); + +UPDATE `creature` SET `position_x`=997.17883, `position_y`=-1919.0712, `position_z`=102.7588, `orientation`=0, `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Redwing Falcon +SET @MOVERGUID := 10000593; +SET @ENTRY := 215036; +SET @PATHOFFSET := 2; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 8.1667, 'Redwing Falcon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 1002.78625, -1838.4913, 113.78512, NULL, 0), +(@PATH, 1, 1012.4332, -1836.0554, 113.78512, NULL, 0), +(@PATH, 2, 1020.9772, -1841.1543, 113.78512, NULL, 0), +(@PATH, 3, 1023.41315, -1850.8013, 113.78512, NULL, 0), +(@PATH, 4, 1018.3142, -1859.3452, 113.78512, NULL, 0), +(@PATH, 5, 1008.66724, -1861.7812, 113.78512, NULL, 0), +(@PATH, 6, 1000.1233, -1856.6823, 113.78512, NULL, 0), +(@PATH, 7, 997.6873, -1847.0353, 113.78512, NULL, 0); + +UPDATE `creature` SET `position_x`=1002.78625, `position_y`=-1838.4913, `position_z`=113.78512, `orientation`=0, `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Redwing Falcon +SET @MOVERGUID := 10000651; +SET @ENTRY := 215036; +SET @PATHOFFSET := 3; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 8.1667, 'Redwing Falcon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 891.30554, -1933.8611, 146.89929, NULL, 0), +(@PATH, 1, 900.4979, -1937.6687, 146.89929, NULL, 0), +(@PATH, 2, 904.30554, -1946.8611, 146.89929, NULL, 0), +(@PATH, 3, 900.4979, -1956.0535, 146.89929, NULL, 0), +(@PATH, 4, 891.30554, -1959.8611, 146.89929, NULL, 0), +(@PATH, 5, 882.11316, -1956.0535, 146.89929, NULL, 0), +(@PATH, 6, 878.30554, -1946.8611, 146.89929, NULL, 0), +(@PATH, 7, 882.11316, -1937.6687, 146.89929, NULL, 0); + +UPDATE `creature` SET `position_x`=891.30554, `position_y`=-1933.8611, `position_z`=146.89929, `orientation`=0, `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); + +-- Path for Redwing Falcon +SET @MOVERGUID := 10000592; +SET @ENTRY := 215036; +SET @PATHOFFSET := 4; +SET @PATH := @ENTRY * 100 + @PATHOFFSET; +DELETE FROM `waypoint_path` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path` (`PathId`, `MoveType`, `Flags`, `Velocity`, `Comment`) VALUES +(@PATH, 0, 0x2, 8.1669, 'Redwing Falcon - Cyclic Path'); + +DELETE FROM `waypoint_path_node` WHERE `PathId`= @PATH; +INSERT INTO `waypoint_path_node` (`PathId`, `NodeId`, `PositionX`, `PositionY`, `PositionZ`, `Orientation`, `Delay`) VALUES +(@PATH, 0, 981.3976, -1791.4036, 115.99746, NULL, 0), +(@PATH, 1, 973.4488, -1797.3881, 115.99746, NULL, 0), +(@PATH, 2, 963.59644, -1795.9991, 115.99746, NULL, 0), +(@PATH, 3, 957.61194, -1788.0503, 115.99746, NULL, 0), +(@PATH, 4, 959.0009, -1778.198, 115.99746, NULL, 0), +(@PATH, 5, 966.9497, -1772.2134, 115.99746, NULL, 0), +(@PATH, 6, 976.80206, -1773.6024, 115.99746, NULL, 0), +(@PATH, 7, 982.78656, -1781.5513, 115.99746, NULL, 0); + +UPDATE `creature` SET `position_x`=981.3976, `position_y`=-1791.4036, `position_z`=115.99746, `orientation`=0, `wander_distance`=0, `MovementType`=2 WHERE `guid`=@MOVERGUID; +DELETE FROM `creature_addon` WHERE `guid`=@MOVERGUID; +INSERT INTO `creature_addon` (`guid`, `PathId`, `SheathState`) VALUES +(@MOVERGUID, @PATH, 1); |