diff options
author | Meji <alvaro.megias@outlook.com> | 2023-11-06 22:33:10 +0100 |
---|---|---|
committer | Meji <alvaro.megias@outlook.com> | 2023-11-06 22:33:10 +0100 |
commit | 0f72c39b0844e63c06c5f72e23523b7ec3cf59d8 (patch) | |
tree | 62cd44d1a19c2229c46f07bac022f8db27883dd9 /sql | |
parent | cdeb295d5b02ded3c7436192f34c73b668542f26 (diff) |
DB/SilverpineForest: Added Hallows End spawns
Diffstat (limited to 'sql')
-rw-r--r-- | sql/updates/world/master/2023_11_06_12_world_silverpine_forest_forsaken_rear_guard.sql | 227 | ||||
-rw-r--r-- | sql/updates/world/master/2023_11_06_13_world_silverpine_forest_the_sepulcher.sql | 197 |
2 files changed, 424 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_11_06_12_world_silverpine_forest_forsaken_rear_guard.sql b/sql/updates/world/master/2023_11_06_12_world_silverpine_forest_forsaken_rear_guard.sql new file mode 100644 index 00000000000..59a315356ed --- /dev/null +++ b/sql/updates/world/master/2023_11_06_12_world_silverpine_forest_forsaken_rear_guard.sql @@ -0,0 +1,227 @@ +SET @CGUID := 3000245; +SET @OGUID := 3003364; + +-- Gameobject templates +UPDATE `gameobject_template` SET `Data6`=0, `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=208146; -- Candy Bucket + +UPDATE `gameobject_template_addon` SET `faction`=1735 WHERE `entry`=208146; -- Candy Bucket + +-- Quests +UPDATE `quest_offer_reward` SET `VerifiedBuild`=51886 WHERE `ID`=28966; + +DELETE FROM `gameobject_queststarter` WHERE `id`=208146; +INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(208146, 28966, 51886); + +UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=208146 AND `quest`=28966); + +DELETE FROM `game_event_gameobject_quest` WHERE `id`=208146; + +-- Creature spawns +DELETE FROM `creature` WHERE `guid`=@CGUID+0; +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `unit_flags3`, `VerifiedBuild`) VALUES +(@CGUID+0, 22816, 0, 130, 5386, '0', 0, 0, 0, 0, 1059.342529296875, 1513.6044921875, 30.86394059753417968, 4.220808982849121093, 120, 10, 0, 1129, 0, 1, NULL, NULL, NULL, NULL, 51886); -- Black Cat (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 230189 AND 230278; +DELETE FROM `gameobject` WHERE `guid`=231993; +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 230189 AND 230278; +DELETE FROM `game_event_gameobject` WHERE `guid`=231993; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+92; +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, 180405, 0, 130, 5386, '0', 0, 0, 1081.3663330078125, 1522.6197509765625, 36.515411376953125, 0.191985160112380981, 0, 0, 0.095845222473144531, 0.995396256446838378, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+1, 180405, 0, 130, 5386, '0', 0, 0, 1057.0347900390625, 1529.77783203125, 36.401214599609375, 0.418878614902496337, 0, 0, 0.207911491394042968, 0.978147625923156738, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+2, 180405, 0, 130, 5386, '0', 0, 0, 1046.1024169921875, 1610.482666015625, 34.77732467651367187, 3.508116960525512695, 0, 0, -0.98325443267822265, 0.182238012552261352, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+3, 180405, 0, 130, 5386, '0', 0, 0, 1084.2274169921875, 1575.623291015625, 28.02008247375488281, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+4, 180405, 0, 130, 5386, '0', 0, 0, 1086.1180419921875, 1609.9600830078125, 35.7227783203125, 3.508116960525512695, 0, 0, -0.98325443267822265, 0.182238012552261352, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+5, 180406, 0, 130, 5386, '0', 0, 0, 1101.3819580078125, 1540.109375, 28.55016136169433593, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+6, 180406, 0, 130, 5386, '0', 0, 0, 1041.876708984375, 1561.8160400390625, 29.391265869140625, 2.775068521499633789, 0, 0, 0.983254432678222656, 0.182238012552261352, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+7, 180407, 0, 130, 5386, '0', 0, 0, 1083.73095703125, 1531.6978759765625, 28.45396232604980468, 3.403396368026733398, 0, 0, -0.99144458770751953, 0.130528271198272705, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+8, 180407, 0, 130, 5386, '0', 0, 0, 1047.5347900390625, 1549.59033203125, 29.70871353149414062, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+9, 180408, 0, 130, 5386, '0', 0, 0, 1081.3663330078125, 1522.59033203125, 38.12468719482421875, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- G_WitchHat_01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+10, 180408, 0, 130, 5386, '0', 0, 0, 1057.142333984375, 1529.5260009765625, 38.05330657958984375, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- G_WitchHat_01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+11, 180408, 0, 130, 5386, '0', 0, 0, 1086.107666015625, 1610.0191650390625, 37.36086654663085937, 3.071766138076782226, 0, 0, 0.999390602111816406, 0.034906134009361267, 120, 255, 1, 51886), -- G_WitchHat_01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+12, 180408, 0, 130, 5386, '0', 0, 0, 1046.0972900390625, 1610.43408203125, 36.40387344360351562, 3.22885894775390625, 0, 0, -0.99904823303222656, 0.043619260191917419, 120, 255, 1, 51886), -- G_WitchHat_01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+13, 180410, 0, 130, 5386, '0', 0, 0, 1092.545166015625, 1590.2083740234375, 29.87060928344726562, 5.096362113952636718, 0, 0, -0.55919265747070312, 0.829037725925445556, 120, 255, 1, 51886), -- G_HangingSkeleton_01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+14, 180410, 0, 130, 5386, '0', 0, 0, 1099.9913330078125, 1579.079833984375, 28.95720100402832031, 1.815141916275024414, 0, 0, 0.788010597229003906, 0.615661680698394775, 120, 255, 1, 51886), -- G_HangingSkeleton_01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+15, 180410, 0, 130, 5386, '0', 0, 0, 1092.782958984375, 1590.9722900390625, 37.08994674682617187, 4.9218292236328125, 0, 0, -0.62932014465332031, 0.77714616060256958, 120, 255, 1, 51886), -- G_HangingSkeleton_01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+16, 180410, 0, 130, 5386, '0', 0, 0, 1096.7274169921875, 1591.451416015625, 29.41508674621582031, 4.852017402648925781, 0, 0, -0.65605831146240234, 0.754710197448730468, 120, 255, 1, 51886), -- G_HangingSkeleton_01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+17, 180410, 0, 130, 5386, '0', 0, 0, 1095.8958740234375, 1591.623291015625, 36.62438201904296875, 4.9218292236328125, 0, 0, -0.62932014465332031, 0.77714616060256958, 120, 255, 1, 51886), -- G_HangingSkeleton_01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+18, 180411, 0, 130, 5386, '0', 0, 0, 1090.26220703125, 1568.62158203125, 38.09135818481445312, 1.396261811256408691, 0, 0, 0.642786979675292968, 0.766044974327087402, 120, 255, 1, 51886), -- G_Ghost_01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+19, 180415, 0, 130, 5386, '0', 0, 0, 1052.19970703125, 1519.71533203125, 31.24444961547851562, 6.021387100219726562, 0, 0, -0.13052558898925781, 0.991444945335388183, 120, 255, 1, 51886), -- CandleBlack01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+20, 180415, 0, 130, 5386, '0', 0, 0, 1044.9010009765625, 1549.4947509765625, 29.99745368957519531, 2.286378860473632812, 0, 0, 0.909960746765136718, 0.414694398641586303, 120, 255, 1, 51886), -- CandleBlack01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+21, 180415, 0, 130, 5386, '0', 0, 0, 1052.4114990234375, 1519.857666015625, 31.22130393981933593, 3.90954136848449707, 0, 0, -0.92718315124511718, 0.37460830807685852, 120, 255, 1, 51886), -- CandleBlack01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+22, 180415, 0, 130, 5386, '0', 0, 0, 1044.6754150390625, 1545.7447509765625, 31.65523719787597656, 3.874631166458129882, 0, 0, -0.93358039855957031, 0.358368009328842163, 120, 255, 1, 51886), -- CandleBlack01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+23, 180415, 0, 130, 5386, '0', 0, 0, 1044.4566650390625, 1546.0242919921875, 31.48002052307128906, 4.48549652099609375, 0, 0, -0.7826080322265625, 0.622514784336090087, 120, 255, 1, 51886), -- CandleBlack01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+24, 180415, 0, 130, 5386, '0', 0, 0, 1052.6163330078125, 1520.6197509765625, 30.800567626953125, 1.588248729705810546, 0, 0, 0.713250160217285156, 0.700909554958343505, 120, 255, 1, 51886), -- CandleBlack01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+25, 180415, 0, 130, 5386, '0', 0, 0, 1044.529541015625, 1549.65283203125, 30.07482528686523437, 4.9218292236328125, 0, 0, -0.62932014465332031, 0.77714616060256958, 120, 255, 1, 51886), -- CandleBlack01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+26, 180415, 0, 130, 5386, '0', 0, 0, 1044.529541015625, 1549.65283203125, 30.07482528686523437, 4.9218292236328125, 0, 0, -0.62932014465332031, 0.77714616060256958, 120, 255, 1, 51886), -- CandleBlack01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+27, 180415, 0, 130, 5386, '0', 0, 0, 1083.1492919921875, 1571.4896240234375, 28.94450187683105468, 4.555310726165771484, 0, 0, -0.76040554046630859, 0.649448513984680175, 120, 255, 1, 51886), -- CandleBlack01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+28, 180415, 0, 130, 5386, '0', 0, 0, 1080.6163330078125, 1564.28125, 28.73950958251953125, 2.181660413742065429, 0, 0, 0.887010574340820312, 0.461749136447906494, 120, 255, 1, 51886), -- CandleBlack01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+29, 180415, 0, 130, 5386, '0', 0, 0, 1083.4566650390625, 1570.9375, 30.08813095092773437, 4.9218292236328125, 0, 0, -0.62932014465332031, 0.77714616060256958, 120, 255, 1, 51886), -- CandleBlack01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+30, 180415, 0, 130, 5386, '0', 0, 0, 1080.34033203125, 1564.298583984375, 28.46576690673828125, 0.959929943084716796, 0, 0, 0.461748123168945312, 0.887011110782623291, 120, 255, 1, 51886), -- CandleBlack01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+31, 180415, 0, 130, 5386, '0', 0, 0, 1083.4879150390625, 1571.6441650390625, 29.17962074279785156, 2.844882726669311523, 0, 0, 0.989015579223632812, 0.147811368107795715, 120, 255, 1, 51886), -- CandleBlack01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+32, 180415, 0, 130, 5386, '0', 0, 0, 1080.48095703125, 1564.09375, 28.59250640869140625, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 51886), -- CandleBlack01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+33, 180425, 0, 130, 5386, '0', 0, 0, 1044.87158203125, 1549.904541015625, 30.21427154541015625, 0.645771682262420654, 0, 0, 0.317304611206054687, 0.948323667049407958, 120, 255, 1, 51886), -- SkullCandle01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+34, 180425, 0, 130, 5386, '0', 0, 0, 1052.109375, 1521.46875, 30.87921905517578125, 5.93412017822265625, 0, 0, -0.17364788055419921, 0.984807789325714111, 120, 255, 1, 51886), -- SkullCandle01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+35, 180425, 0, 130, 5386, '0', 0, 0, 1032.3038330078125, 1579.361083984375, 28.3823699951171875, 4.677483558654785156, 0, 0, -0.71933937072753906, 0.694658815860748291, 120, 255, 1, 51886), -- SkullCandle01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+36, 180425, 0, 130, 5386, '0', 0, 0, 1033.234375, 1580.1180419921875, 28.43958854675292968, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 120, 255, 1, 51886), -- SkullCandle01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+37, 180425, 0, 130, 5386, '0', 0, 0, 1031.532958984375, 1580.38720703125, 28.3018035888671875, 2.984498262405395507, 0, 0, 0.996916770935058593, 0.078466430306434631, 120, 255, 1, 51886), -- SkullCandle01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+38, 180425, 0, 130, 5386, '0', 0, 0, 1103.4322509765625, 1531.41845703125, 31.14222145080566406, 2.129300594329833984, 0, 0, 0.874619483947753906, 0.484810054302215576, 120, 255, 1, 51886), -- SkullCandle01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+39, 180425, 0, 130, 5386, '0', 0, 0, 1032.4288330078125, 1581.0867919921875, 28.3572235107421875, 1.396261811256408691, 0, 0, 0.642786979675292968, 0.766044974327087402, 120, 255, 1, 51886), -- SkullCandle01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+40, 180425, 0, 130, 5386, '0', 0, 0, 1084.1822509765625, 1572.451416015625, 29.04422378540039062, 3.036838293075561523, 0, 0, 0.998628616333007812, 0.052353221923112869, 120, 255, 1, 51886), -- SkullCandle01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+41, 180425, 0, 130, 5386, '0', 0, 0, 1079.3385009765625, 1563.953125, 29.25124549865722656, 2.094393253326416015, 0, 0, 0.866024971008300781, 0.50000077486038208, 120, 255, 1, 51886), -- SkullCandle01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+42, 180426, 0, 130, 5386, '0', 0, 0, 1071.298583984375, 1546.5364990234375, 48.12280654907226562, 5.986480236053466796, 0, 0, -0.14780902862548828, 0.989015936851501464, 120, 255, 1, 51886), -- Bat01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+43, 180426, 0, 130, 5386, '0', 0, 0, 1062.9288330078125, 1546.75, 46.777008056640625, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, 51886), -- Bat01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+44, 180426, 0, 130, 5386, '0', 0, 0, 1053.5086669921875, 1561.1978759765625, 52.51799392700195312, 4.014260292053222656, 0, 0, -0.90630722045898437, 0.422619491815567016, 120, 255, 1, 51886), -- Bat01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+45, 180426, 0, 130, 5386, '0', 0, 0, 1061.19970703125, 1569.8697509765625, 47.78021621704101562, 3.176533222198486328, 0, 0, -0.999847412109375, 0.017469281330704689, 120, 255, 1, 51886), -- Bat01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+46, 180427, 0, 130, 5386, '0', 0, 0, 1067.484375, 1547.4149169921875, 42.95427322387695312, 0.069811686873435974, 0, 0, 0.034898757934570312, 0.999390840530395507, 120, 255, 1, 51886), -- Bat02 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+47, 180427, 0, 130, 5386, '0', 0, 0, 1064.75, 1558.1007080078125, 48.09532546997070312, 2.530723094940185546, 0, 0, 0.953716278076171875, 0.300707906484603881, 120, 255, 1, 51886), -- Bat02 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+48, 180427, 0, 130, 5386, '0', 0, 0, 1054.7291259765625, 1550.15625, 49.77910232543945312, 3.822272777557373046, 0, 0, -0.94264125823974609, 0.333807557821273803, 120, 255, 1, 51886), -- Bat02 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+49, 180427, 0, 130, 5386, '0', 0, 0, 1061.6197509765625, 1553.71875, 52.05438613891601562, 5.480334281921386718, 0, 0, -0.39073085784912109, 0.920504987239837646, 120, 255, 1, 51886), -- Bat02 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+50, 180427, 0, 130, 5386, '0', 0, 0, 1061.3021240234375, 1561.625, 44.32678604125976562, 4.660029888153076171, 0, 0, -0.72537422180175781, 0.688354730606079101, 120, 255, 1, 51886), -- Bat02 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+51, 180427, 0, 130, 5386, '0', 0, 0, 1055.37158203125, 1570.13720703125, 47.97618484497070312, 2.373644113540649414, 0, 0, 0.927183151245117187, 0.37460830807685852, 120, 255, 1, 51886), -- Bat02 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+52, 180471, 0, 130, 5386, '0', 0, 0, 1086.5728759765625, 1528.6441650390625, 32.70581436157226562, 4.345870018005371093, 0, 0, -0.82412624359130859, 0.566406130790710449, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+53, 180471, 0, 130, 5386, '0', 0, 0, 1090.220458984375, 1533.6458740234375, 32.88034439086914062, 3.281238555908203125, 0, 0, -0.99756336212158203, 0.069766148924827575, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+54, 180471, 0, 130, 5386, '0', 0, 0, 1095.170166015625, 1529.857666015625, 32.74386215209960937, 1.692969322204589843, 0, 0, 0.748955726623535156, 0.662620067596435546, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+55, 180471, 0, 130, 5386, '0', 0, 0, 1100.2083740234375, 1536.29345703125, 31.93049049377441406, 3.769911527633666992, 0, 0, -0.95105648040771484, 0.309017121791839599, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+56, 180471, 0, 130, 5386, '0', 0, 0, 1099.9583740234375, 1530.4896240234375, 32.65742874145507812, 5.166176319122314453, 0, 0, -0.52991867065429687, 0.84804844856262207, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+57, 180471, 0, 130, 5386, '0', 0, 0, 1083.6441650390625, 1589.873291015625, 49.18288040161132812, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+58, 180471, 0, 130, 5386, '0', 0, 0, 1032.126708984375, 1577.8350830078125, 30.58640289306640625, 3.281238555908203125, 0, 0, -0.99756336212158203, 0.069766148924827575, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+59, 180471, 0, 130, 5386, '0', 0, 0, 1087.763916015625, 1573.515625, 43.65787124633789062, 5.323255538940429687, 0, 0, -0.46174812316894531, 0.887011110782623291, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+60, 180471, 0, 130, 5386, '0', 0, 0, 1083.920166015625, 1587.84375, 51.765350341796875, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+61, 180471, 0, 130, 5386, '0', 0, 0, 1084.2447509765625, 1586.2760009765625, 53.75676345825195312, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+62, 180471, 0, 130, 5386, '0', 0, 0, 1083.0382080078125, 1594.470458984375, 43.49265289306640625, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+63, 180471, 0, 130, 5386, '0', 0, 0, 1083.0382080078125, 1594.470458984375, 43.49265289306640625, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+64, 180471, 0, 130, 5386, '0', 0, 0, 1084.888916015625, 1580.920166015625, 35.24680709838867187, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+65, 180471, 0, 130, 5386, '0', 0, 0, 1082.7535400390625, 1581.8853759765625, 35.22666549682617187, 5.288348197937011718, 0, 0, -0.4771585464477539, 0.878817260265350341, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+66, 180471, 0, 130, 5386, '0', 0, 0, 1086.060791015625, 1579.6978759765625, 51.43650054931640625, 5.323255538940429687, 0, 0, -0.46174812316894531, 0.887011110782623291, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+67, 180471, 0, 130, 5386, '0', 0, 0, 1037.4271240234375, 1580.2552490234375, 30.91660499572753906, 3.281238555908203125, 0, 0, -0.99756336212158203, 0.069766148924827575, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+68, 180471, 0, 130, 5386, '0', 0, 0, 1083.5242919921875, 1586.704833984375, 35.24517822265625, 3.333590030670166015, 0, 0, -0.99539566040039062, 0.095851235091686248, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+69, 180471, 0, 130, 5386, '0', 0, 0, 1085.4478759765625, 1581.4600830078125, 53.83241653442382812, 5.323255538940429687, 0, 0, -0.46174812316894531, 0.887011110782623291, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+70, 180471, 0, 130, 5386, '0', 0, 0, 1087.6614990234375, 1575.236083984375, 45.483856201171875, 5.323255538940429687, 0, 0, -0.46174812316894531, 0.887011110782623291, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+71, 180471, 0, 130, 5386, '0', 0, 0, 1034.96533203125, 1585.5625, 31.19580841064453125, 3.281238555908203125, 0, 0, -0.99756336212158203, 0.069766148924827575, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+72, 180471, 0, 130, 5386, '0', 0, 0, 1081.923583984375, 1585.1441650390625, 35.21071243286132812, 4.782202720642089843, 0, 0, -0.68199825286865234, 0.731353819370269775, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+73, 180471, 0, 130, 5386, '0', 0, 0, 1106.03125, 1536.1492919921875, 31.97185707092285156, 2.146752834320068359, 0, 0, 0.878816604614257812, 0.477159708738327026, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+74, 180471, 0, 130, 5386, '0', 0, 0, 1083.41845703125, 1591.904541015625, 46.59970855712890625, 5.026549339294433593, 0, 0, -0.5877847671508789, 0.809017360210418701, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+75, 180471, 0, 130, 5386, '0', 0, 0, 1086.9271240234375, 1577.5660400390625, 48.46808624267578125, 5.323255538940429687, 0, 0, -0.46174812316894531, 0.887011110782623291, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+76, 180472, 0, 130, 5386, '0', 0, 0, 1082.3177490234375, 1583.498291015625, 36.82819747924804687, 3.351046562194824218, 0, 0, -0.99452114105224609, 0.104535527527332305, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+77, 180472, 0, 130, 5386, '0', 0, 0, 1098.8021240234375, 1582.7239990234375, 42.045928955078125, 5.235987663269042968, 0, 0, -0.5, 0.866025388240814208, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+78, 180472, 0, 130, 5386, '0', 0, 0, 1094.5399169921875, 1581.9461669921875, 35.0087890625, 1.762782454490661621, 0, 0, 0.771624565124511718, 0.636078238487243652, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+79, 180472, 0, 130, 5386, '0', 0, 0, 1085.5816650390625, 1584.07470703125, 47.83374786376953125, 3.351046562194824218, 0, 0, -0.99452114105224609, 0.104535527527332305, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+80, 180523, 0, 130, 5386, '0', 0, 0, 1098.923583984375, 1582.9635009765625, 28.69253158569335937, 2.600535154342651367, 0, 0, 0.963629722595214843, 0.26724100112915039, 120, 255, 1, 51886), -- Apple Bob (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+81, 208069, 0, 130, 5386, '0', 0, 0, 1039.4635009765625, 1558.435791015625, 34.50909805297851562, 1.675513744354248046, 0, 0, 0.743144035339355468, 0.669131457805633544, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 0.5 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+82, 208069, 0, 130, 5386, '0', 0, 0, 1083.532958984375, 1563.6597900390625, 30.68759918212890625, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 0.5 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+83, 208069, 0, 130, 5386, '0', 0, 0, 1025.439208984375, 1562.5972900390625, 30.48994255065917968, 2.094393253326416015, 0, 0, 0.866024971008300781, 0.50000077486038208, 120, 255, 1, 51886), -- G_Pumpkin_02 Scale 0.5 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+84, 208072, 0, 130, 5386, '0', 0, 0, 1081.5972900390625, 1561.1771240234375, 28.5865478515625, 0, 0, 0, 0, 1, 120, 255, 1, 51886), -- G_Pumpkin_03 Scale 0.5 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+85, 208072, 0, 130, 5386, '0', 0, 0, 1040.4149169921875, 1560.4791259765625, 32.48027801513671875, 2.373644113540649414, 0, 0, 0.927183151245117187, 0.37460830807685852, 120, 255, 1, 51886), -- G_Pumpkin_03 Scale 0.5 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+86, 208072, 0, 130, 5386, '0', 0, 0, 1028.1614990234375, 1573.8316650390625, 30.20028305053710937, 1.623155713081359863, 0, 0, 0.725374221801757812, 0.688354730606079101, 120, 255, 1, 51886), -- G_Pumpkin_03 Scale 0.5 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+87, 208078, 0, 130, 5386, '0', 0, 0, 1042.4791259765625, 1559.5728759765625, 30.91448593139648437, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, 51886), -- G_Pumpkin_01 scale 0.5 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+88, 208078, 0, 130, 5386, '0', 0, 0, 1026.3004150390625, 1597.2274169921875, 28.653900146484375, 1.082102894783020019, 0, 0, 0.51503753662109375, 0.857167601585388183, 120, 255, 1, 51886), -- G_Pumpkin_01 scale 0.5 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+89, 208078, 0, 130, 5386, '0', 0, 0, 1097.0694580078125, 1587.3941650390625, 36.47559356689453125, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 51886), -- G_Pumpkin_01 scale 0.5 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+90, 208078, 0, 130, 5386, '0', 0, 0, 1039.1475830078125, 1597.3958740234375, 30.49359512329101562, 0.226892471313476562, 0, 0, 0.113203048706054687, 0.993571877479553222, 120, 255, 1, 51886), -- G_Pumpkin_01 scale 0.5 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+91, 208078, 0, 130, 5386, '0', 0, 0, 1082.2535400390625, 1562.701416015625, 29.92713356018066406, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 51886), -- G_Pumpkin_01 scale 0.5 (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 +(@OGUID+92, 208146, 0, 130, 5386, '0', 0, 0, 1098.6353759765625, 1589.51220703125, 28.53030776977539062, 5.061456203460693359, 0, 0, -0.57357597351074218, 0.819152355194091796, 120, 255, 1, 51886); -- Candy Bucket (Area: Forsaken Rear Guard - Difficulty: 0) CreateObject1 + +-- Event spawns +DELETE FROM `game_event_creature` WHERE `eventEntry`=12 AND `guid`=@CGUID+0; +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(12, @CGUID+0); + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+92; +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +(12, @OGUID+0), +(12, @OGUID+1), +(12, @OGUID+2), +(12, @OGUID+3), +(12, @OGUID+4), +(12, @OGUID+5), +(12, @OGUID+6), +(12, @OGUID+7), +(12, @OGUID+8), +(12, @OGUID+9), +(12, @OGUID+10), +(12, @OGUID+11), +(12, @OGUID+12), +(12, @OGUID+13), +(12, @OGUID+14), +(12, @OGUID+15), +(12, @OGUID+16), +(12, @OGUID+17), +(12, @OGUID+18), +(12, @OGUID+19), +(12, @OGUID+20), +(12, @OGUID+21), +(12, @OGUID+22), +(12, @OGUID+23), +(12, @OGUID+24), +(12, @OGUID+25), +(12, @OGUID+26), +(12, @OGUID+27), +(12, @OGUID+28), +(12, @OGUID+29), +(12, @OGUID+30), +(12, @OGUID+31), +(12, @OGUID+32), +(12, @OGUID+33), +(12, @OGUID+34), +(12, @OGUID+35), +(12, @OGUID+36), +(12, @OGUID+37), +(12, @OGUID+38), +(12, @OGUID+39), +(12, @OGUID+40), +(12, @OGUID+41), +(12, @OGUID+42), +(12, @OGUID+43), +(12, @OGUID+44), +(12, @OGUID+45), +(12, @OGUID+46), +(12, @OGUID+47), +(12, @OGUID+48), +(12, @OGUID+49), +(12, @OGUID+50), +(12, @OGUID+51), +(12, @OGUID+52), +(12, @OGUID+53), +(12, @OGUID+54), +(12, @OGUID+55), +(12, @OGUID+56), +(12, @OGUID+57), +(12, @OGUID+58), +(12, @OGUID+59), +(12, @OGUID+60), +(12, @OGUID+61), +(12, @OGUID+62), +(12, @OGUID+63), +(12, @OGUID+64), +(12, @OGUID+65), +(12, @OGUID+66), +(12, @OGUID+67), +(12, @OGUID+68), +(12, @OGUID+69), +(12, @OGUID+70), +(12, @OGUID+71), +(12, @OGUID+72), +(12, @OGUID+73), +(12, @OGUID+74), +(12, @OGUID+75), +(12, @OGUID+76), +(12, @OGUID+77), +(12, @OGUID+78), +(12, @OGUID+79), +(12, @OGUID+80), +(12, @OGUID+81), +(12, @OGUID+82), +(12, @OGUID+83), +(12, @OGUID+84), +(12, @OGUID+85), +(12, @OGUID+86), +(12, @OGUID+87), +(12, @OGUID+88), +(12, @OGUID+89), +(12, @OGUID+90), +(12, @OGUID+91), +(12, @OGUID+92); diff --git a/sql/updates/world/master/2023_11_06_13_world_silverpine_forest_the_sepulcher.sql b/sql/updates/world/master/2023_11_06_13_world_silverpine_forest_the_sepulcher.sql new file mode 100644 index 00000000000..4b941afbe6d --- /dev/null +++ b/sql/updates/world/master/2023_11_06_13_world_silverpine_forest_the_sepulcher.sql @@ -0,0 +1,197 @@ +SET @OGUID := 3003457; + +-- Gameobject templates +UPDATE `gameobject_template` SET `ContentTuningId`=425, `VerifiedBuild`=51886 WHERE `entry`=190074; -- Candy Bucket + +UPDATE `gameobject_template_addon` SET `faction`=1735 WHERE `entry`=190074; -- Candy Bucket + +-- Quests +UPDATE `quest_offer_reward` SET `VerifiedBuild`=51886 WHERE `ID`=12371; + +DELETE FROM `gameobject_queststarter` WHERE `id`=190074; +INSERT INTO `gameobject_queststarter` (`id`, `quest`, `VerifiedBuild`) VALUES +(190074, 12371, 51886); + +UPDATE `gameobject_questender` SET `VerifiedBuild`=51886 WHERE (`id`=190074 AND `quest`=12371); + +DELETE FROM `game_event_gameobject_quest` WHERE `id`=190074; + +-- Old gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN 230055 AND 230188; +DELETE FROM `gameobject` WHERE `guid` IN (230279, 230280); +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN 230055 AND 230188; +DELETE FROM `game_event_gameobject` WHERE `guid` IN (230279, 230280); + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+82; +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, 180405, 0, 130, 228, '0', 0, 0, 473.852447509765625, 1515.7899169921875, 150.611114501953125, 3.717553615570068359, 0, 0, -0.95881938934326171, 0.284016460180282592, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+1, 180405, 0, 130, 228, '0', 0, 0, 449.743072509765625, 1496.970458984375, 145.9694366455078125, 2.967041015625, 0, 0, 0.996193885803222656, 0.087165042757987976, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+2, 180405, 0, 130, 228, '0', 0, 0, 472.454864501953125, 1516.095458984375, 135.7756500244140625, 2.687806606292724609, 0, 0, 0.974370002746582031, 0.224951311945915222, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+3, 180405, 0, 130, 228, '0', 0, 0, 493.220489501953125, 1492.064208984375, 163.120880126953125, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+4, 180405, 0, 130, 228, '0', 0, 0, 506.6290283203125, 1657.9888916015625, 116.5703964233398437, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+5, 180405, 0, 130, 228, '0', 0, 0, 571.79339599609375, 1577.295166015625, 132.293243408203125, 5.270895957946777343, 0, 0, -0.48480892181396484, 0.87462007999420166, 120, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+6, 180406, 0, 130, 228, '0', 0, 0, 452.536468505859375, 1514.232666015625, 163.1257476806640625, 3.368495941162109375, 0, 0, -0.99357128143310546, 0.113208353519439697, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+7, 180406, 0, 130, 228, '0', 0, 0, 436.322906494140625, 1484.357666015625, 163.1231231689453125, 5.89921426773071289, 0, 0, -0.19080829620361328, 0.981627285480499267, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+8, 180406, 0, 130, 228, '0', 0, 0, 482.46527099609375, 1511.1805419921875, 150.6131134033203125, 2.460912704467773437, 0, 0, 0.942641258239746093, 0.333807557821273803, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+9, 180406, 0, 130, 228, '0', 0, 0, 476.899322509765625, 1462.342041015625, 163.1182403564453125, 0.349065244197845458, 0, 0, 0.173647880554199218, 0.984807789325714111, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+10, 180406, 0, 130, 228, '0', 0, 0, 499.229156494140625, 1631.9722900390625, 141.4564971923828125, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+11, 180406, 0, 130, 228, '0', 0, 0, 553.4461669921875, 1569.579833984375, 141.88287353515625, 5.654868602752685546, 0, 0, -0.30901622772216796, 0.95105677843093872, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+12, 180406, 0, 130, 228, '0', 0, 0, 524.50738525390625, 1657.9383544921875, 111.0247268676757812, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, 51886), -- G_Pumpkin_02 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+13, 180407, 0, 130, 228, '0', 0, 0, 467.170135498046875, 1519.142333984375, 163.153961181640625, 3.630291461944580078, 0, 0, -0.97029495239257812, 0.241925001144409179, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+14, 180407, 0, 130, 228, '0', 0, 0, 488.609375, 1506.8367919921875, 163.1319122314453125, 2.460912704467773437, 0, 0, 0.942641258239746093, 0.333807557821273803, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+15, 180407, 0, 130, 228, '0', 0, 0, 447.001739501953125, 1497.5885009765625, 180.601409912109375, 3.45575571060180664, 0, 0, -0.98768806457519531, 0.156436234712600708, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+16, 180407, 0, 130, 228, '0', 0, 0, 551.94964599609375, 1577.1754150390625, 141.8812255859375, 4.834563255310058593, 0, 0, -0.66261959075927734, 0.748956084251403808, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+17, 180407, 0, 130, 228, '0', 0, 0, 501.625, 1628.8677978515625, 127.3178176879882812, 0.558503925800323486, 0, 0, 0.275636672973632812, 0.961261868476867675, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+18, 180407, 0, 130, 228, '0', 0, 0, 516.87237548828125, 1631.07421875, 126.796783447265625, 0.104719325900077819, 0, 0, 0.052335739135742187, 0.998629570007324218, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+19, 180407, 0, 130, 228, '0', 0, 0, 560.9461669921875, 1564.392333984375, 132.1631927490234375, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+20, 180407, 0, 130, 228, '0', 0, 0, 522.96112060546875, 1621.8658447265625, 105.7632827758789062, 3.508116960525512695, 0, 0, -0.98325443267822265, 0.182238012552261352, 120, 255, 1, 51886), -- G_Pumpkin_03 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+21, 180410, 0, 130, 228, '0', 0, 0, 464.904510498046875, 1496.44970703125, 137.9579620361328125, 1.064649581909179687, 0, 0, 0.507537841796875, 0.861629426479339599, 120, 255, 1, 51886), -- G_HangingSkeleton_01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+22, 180410, 0, 130, 228, '0', 0, 0, 518.060791015625, 1625.6239013671875, 105.8533706665039062, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 51886), -- G_HangingSkeleton_01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+23, 180411, 0, 130, 228, '0', 0, 0, 476.885406494140625, 1511.0069580078125, 141.8424835205078125, 4.049167633056640625, 0, 0, -0.89879322052001953, 0.438372820615768432, 120, 255, 1, 51886), -- G_Ghost_01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+24, 180411, 0, 130, 228, '0', 0, 0, 554.90106201171875, 1584.4791259765625, 141.5403900146484375, 5.95157480239868164, 0, 0, -0.16504669189453125, 0.986285746097564697, 120, 255, 1, 51886), -- G_Ghost_01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+25, 180411, 0, 130, 228, '0', 0, 0, 507.98089599609375, 1646.782958984375, 128.107269287109375, 1.204277276992797851, 0, 0, 0.56640625, 0.824126183986663818, 120, 255, 1, 51886), -- G_Ghost_01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+26, 180415, 0, 130, 228, '0', 0, 0, 476.21527099609375, 1516.4617919921875, 135.5836944580078125, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+27, 180415, 0, 130, 228, '0', 0, 0, 469.40277099609375, 1497.298583984375, 135.5185546875, 3.054326534271240234, 0, 0, 0.999048233032226562, 0.043619260191917419, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+28, 180415, 0, 130, 228, '0', 0, 0, 478.020843505859375, 1519.111083984375, 134.6112823486328125, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+29, 180415, 0, 130, 228, '0', 0, 0, 476.1875, 1505.7083740234375, 136.6704864501953125, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+30, 180415, 0, 130, 228, '0', 0, 0, 472.796875, 1503.4879150390625, 135.5185394287109375, 3.700104713439941406, 0, 0, -0.96126079559326171, 0.275640487670898437, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+31, 180415, 0, 130, 228, '0', 0, 0, 480.302093505859375, 1521.6978759765625, 133.4040069580078125, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+32, 180415, 0, 130, 228, '0', 0, 0, 472.998260498046875, 1507.7760009765625, 136.6956329345703125, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+33, 180415, 0, 130, 228, '0', 0, 0, 468.0069580078125, 1502.017333984375, 135.5186309814453125, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+34, 180415, 0, 130, 228, '0', 0, 0, 474.078125, 1498.7847900390625, 135.518646240234375, 0.680676698684692382, 0, 0, 0.333806037902832031, 0.942641794681549072, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+35, 180415, 0, 130, 228, '0', 0, 0, 483.861114501953125, 1514.9461669921875, 134.4277496337890625, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+36, 180415, 0, 130, 228, '0', 0, 0, 481.557281494140625, 1512.5833740234375, 135.4255523681640625, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+37, 180415, 0, 130, 228, '0', 0, 0, 481.09375, 1526.1285400390625, 132.52227783203125, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+38, 180415, 0, 130, 228, '0', 0, 0, 488.036468505859375, 1522.1805419921875, 132.0790863037109375, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+39, 180415, 0, 130, 228, '0', 0, 0, 486.22222900390625, 1518.4132080078125, 133.0768585205078125, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+40, 180415, 0, 130, 228, '0', 0, 0, 564.61981201171875, 1568.001708984375, 134.8176727294921875, 2.513273954391479492, 0, 0, 0.951056480407714843, 0.309017121791839599, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+41, 180415, 0, 130, 228, '0', 0, 0, 564.420166015625, 1569.0208740234375, 134.0753936767578125, 4.014260292053222656, 0, 0, -0.90630722045898437, 0.422619491815567016, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+42, 180415, 0, 130, 228, '0', 0, 0, 564.18231201171875, 1570.0833740234375, 133.3030853271484375, 2.565631866455078125, 0, 0, 0.958819389343261718, 0.284016460180282592, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+43, 180415, 0, 130, 228, '0', 0, 0, 564.0538330078125, 1570.8489990234375, 132.753143310546875, 3.054326534271240234, 0, 0, 0.999048233032226562, 0.043619260191917419, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+44, 180415, 0, 130, 228, '0', 0, 0, 564.904541015625, 1566.8125, 135.6863861083984375, 2.635444164276123046, 0, 0, 0.96814727783203125, 0.250381410121917724, 120, 255, 1, 51886), -- CandleBlack01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+45, 180425, 0, 130, 228, '0', 0, 0, 511.112518310546875, 1640.37158203125, 126.49786376953125, 4.747295856475830078, 0, 0, -0.69465827941894531, 0.719339847564697265, 120, 255, 1, 51886), -- SkullCandle01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+46, 180425, 0, 130, 228, '0', 0, 0, 505.021636962890625, 1640.3695068359375, 126.497589111328125, 4.694936752319335937, 0, 0, -0.71325016021728515, 0.700909554958343505, 120, 255, 1, 51886), -- SkullCandle01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+47, 180426, 0, 130, 228, '0', 0, 0, 515.44793701171875, 1550.6458740234375, 131.3998870849609375, 2.338739633560180664, 0, 0, 0.920504570007324218, 0.3907318115234375, 120, 255, 1, 51886), -- Bat01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+48, 180426, 0, 130, 228, '0', 0, 0, 471.401031494140625, 1562.154541015625, 127.9365234375, 4.066620349884033203, 0, 0, -0.89493370056152343, 0.44619917869567871, 120, 255, 1, 51886), -- Bat01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+49, 180426, 0, 130, 228, '0', 0, 0, 505.3507080078125, 1565.248291015625, 128.7751312255859375, 0.471238493919372558, 0, 0, 0.233445167541503906, 0.972369968891143798, 120, 255, 1, 51886), -- Bat01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+50, 180426, 0, 130, 228, '0', 0, 0, 498.06597900390625, 1539.923583984375, 129.3557891845703125, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 51886), -- Bat01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+51, 180426, 0, 130, 228, '0', 0, 0, 477.333343505859375, 1565.8941650390625, 127.5967636108398437, 0.802850961685180664, 0, 0, 0.390730857849121093, 0.920504987239837646, 120, 255, 1, 51886), -- Bat01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+52, 180426, 0, 130, 228, '0', 0, 0, 481.76214599609375, 1583.423583984375, 126.7216415405273437, 4.712389945983886718, 0, 0, -0.70710659027099609, 0.707106947898864746, 120, 255, 1, 51886), -- Bat01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+53, 180426, 0, 130, 228, '0', 0, 0, 458.748260498046875, 1554.4947509765625, 129.8225250244140625, 4.48549652099609375, 0, 0, -0.7826080322265625, 0.622514784336090087, 120, 255, 1, 51886), -- Bat01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+54, 180426, 0, 130, 228, '0', 0, 0, 502.626739501953125, 1530.1632080078125, 152.52423095703125, 1.396261811256408691, 0, 0, 0.642786979675292968, 0.766044974327087402, 120, 255, 1, 51886), -- Bat01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+55, 180426, 0, 130, 228, '0', 0, 0, 483.041656494140625, 1559.3785400390625, 128.1763458251953125, 1.675513744354248046, 0, 0, 0.743144035339355468, 0.669131457805633544, 120, 255, 1, 51886), -- Bat01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+56, 180426, 0, 130, 228, '0', 0, 0, 483.602447509765625, 1538.0833740234375, 130.4841156005859375, 3.926995515823364257, 0, 0, -0.92387866973876953, 0.38268551230430603, 120, 255, 1, 51886), -- Bat01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+57, 180427, 0, 130, 228, '0', 0, 0, 509.7100830078125, 1569.092041015625, 128.9152069091796875, 4.328419685363769531, 0, 0, -0.82903671264648437, 0.559194147586822509, 120, 255, 1, 51886), -- Bat02 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+58, 180427, 0, 130, 228, '0', 0, 0, 516.6805419921875, 1516.2691650390625, 136.02294921875, 3.996806621551513671, 0, 0, -0.90996074676513671, 0.414694398641586303, 120, 255, 1, 51886), -- Bat02 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+59, 180427, 0, 130, 228, '0', 0, 0, 482.279510498046875, 1561.298583984375, 127.9913864135742187, 5.84685373306274414, 0, 0, -0.21643924713134765, 0.976296067237854003, 120, 255, 1, 51886), -- Bat02 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+60, 180427, 0, 130, 228, '0', 0, 0, 471.32464599609375, 1565.60595703125, 127.6447906494140625, 2.879789113998413085, 0, 0, 0.991444587707519531, 0.130528271198272705, 120, 255, 1, 51886), -- Bat02 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+61, 180427, 0, 130, 228, '0', 0, 0, 504.84027099609375, 1553.2135009765625, 153.2401885986328125, 4.572763919830322265, 0, 0, -0.75470924377441406, 0.656059443950653076, 120, 255, 1, 51886), -- Bat02 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+62, 180427, 0, 130, 228, '0', 0, 0, 485.451385498046875, 1559.9166259765625, 159.0025177001953125, 1.535889506340026855, 0, 0, 0.694658279418945312, 0.719339847564697265, 120, 255, 1, 51886), -- Bat02 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+63, 180427, 0, 130, 228, '0', 0, 0, 517.576416015625, 1593.111083984375, 127.2895889282226562, 6.09120035171508789, 0, 0, -0.09584522247314453, 0.995396256446838378, 120, 255, 1, 51886), -- Bat02 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+64, 180427, 0, 130, 228, '0', 0, 0, 480.368072509765625, 1574.77783203125, 143.7326202392578125, 0.959929943084716796, 0, 0, 0.461748123168945312, 0.887011110782623291, 120, 255, 1, 51886), -- Bat02 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+65, 180427, 0, 130, 228, '0', 0, 0, 476.557281494140625, 1546.470458984375, 137.707244873046875, 4.014260292053222656, 0, 0, -0.90630722045898437, 0.422619491815567016, 120, 255, 1, 51886), -- Bat02 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+66, 180427, 0, 130, 228, '0', 0, 0, 518.89239501953125, 1570.0694580078125, 160.3891143798828125, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 51886), -- Bat02 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+67, 180471, 0, 130, 228, '0', 0, 0, 506.674102783203125, 1631.7259521484375, 135.9428253173828125, 5.794494152069091796, 0, 0, -0.24192142486572265, 0.970295846462249755, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+68, 180471, 0, 130, 228, '0', 0, 0, 500.46527099609375, 1632.078125, 132.8692474365234375, 0.261798173189163208, 0, 0, 0.130525588989257812, 0.991444945335388183, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+69, 180471, 0, 130, 228, '0', 0, 0, 559.1788330078125, 1567.5103759765625, 136.0166778564453125, 5.166176319122314453, 0, 0, -0.52991867065429687, 0.84804844856262207, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+70, 180471, 0, 130, 228, '0', 0, 0, 511.6632080078125, 1635.326416015625, 130.1550140380859375, 5.864306926727294921, 0, 0, -0.20791149139404296, 0.978147625923156738, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+71, 180471, 0, 130, 228, '0', 0, 0, 558.90972900390625, 1575.6771240234375, 137.0835723876953125, 4.956737518310546875, 0, 0, -0.61566066741943359, 0.788011372089385986, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+72, 180471, 0, 130, 228, '0', 0, 0, 556.37847900390625, 1581.1875, 136.0561370849609375, 4.293513298034667968, 0, 0, -0.8386697769165039, 0.544640243053436279, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+73, 180471, 0, 130, 228, '0', 0, 0, 559.39239501953125, 1573.345458984375, 137.0200958251953125, 5.166176319122314453, 0, 0, -0.52991867065429687, 0.84804844856262207, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+74, 180471, 0, 130, 228, '0', 0, 0, 500.7413330078125, 1642.921875, 132.737518310546875, 4.642575740814208984, 0, 0, -0.731353759765625, 0.681998312473297119, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+75, 180471, 0, 130, 228, '0', 0, 0, 564.2742919921875, 1560.3038330078125, 135.9887542724609375, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+76, 180471, 0, 130, 228, '0', 0, 0, 515.64239501953125, 1642.935791015625, 132.709747314453125, 1.570795774459838867, 0, 0, 0.707106590270996093, 0.707106947898864746, 120, 255, 1, 51886), -- HangingSkullLight01 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+77, 180472, 0, 130, 228, '0', 0, 0, 523.1632080078125, 1624.204833984375, 112.469146728515625, 1.553341388702392578, 0, 0, 0.700908660888671875, 0.713251054286956787, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+78, 180472, 0, 130, 228, '0', 0, 0, 508.736114501953125, 1634.734375, 132.0886688232421875, 4.782202720642089843, 0, 0, -0.68199825286865234, 0.731353819370269775, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+79, 180472, 0, 130, 228, '0', 0, 0, 559.29168701171875, 1574.5572509765625, 138.7160186767578125, 3.351046562194824218, 0, 0, -0.99452114105224609, 0.104535527527332305, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+80, 180472, 0, 130, 228, '0', 0, 0, 515.9774169921875, 1638.4879150390625, 134.1284942626953125, 5.427974700927734375, 0, 0, -0.41469287872314453, 0.909961462020874023, 120, 255, 1, 51886), -- HangingSkullLight02 (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+81, 180523, 0, 130, 228, '0', 0, 0, 473.4132080078125, 1494.90625, 136.0416107177734375, 0.15707901120185852, 0, 0, 0.078458786010742187, 0.996917366981506347, 120, 255, 1, 51886), -- Apple Bob (Area: The Sepulcher - Difficulty: 0) CreateObject1 +(@OGUID+82, 190074, 0, 130, 228, '0', 0, 0, 465.37847900390625, 1499.092041015625, 135.5258026123046875, 2.234017848968505859, 0, 0, 0.898793220520019531, 0.438372820615768432, 120, 255, 1, 51886); -- Candy Bucket (Area: The Sepulcher - Difficulty: 0) CreateObject1 + +-- Event spawns +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+82; +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +(12, @OGUID+0), +(12, @OGUID+1), +(12, @OGUID+2), +(12, @OGUID+3), +(12, @OGUID+4), +(12, @OGUID+5), +(12, @OGUID+6), +(12, @OGUID+7), +(12, @OGUID+8), +(12, @OGUID+9), +(12, @OGUID+10), +(12, @OGUID+11), +(12, @OGUID+12), +(12, @OGUID+13), +(12, @OGUID+14), +(12, @OGUID+15), +(12, @OGUID+16), +(12, @OGUID+17), +(12, @OGUID+18), +(12, @OGUID+19), +(12, @OGUID+20), +(12, @OGUID+21), +(12, @OGUID+22), +(12, @OGUID+23), +(12, @OGUID+24), +(12, @OGUID+25), +(12, @OGUID+26), +(12, @OGUID+27), +(12, @OGUID+28), +(12, @OGUID+29), +(12, @OGUID+30), +(12, @OGUID+31), +(12, @OGUID+32), +(12, @OGUID+33), +(12, @OGUID+34), +(12, @OGUID+35), +(12, @OGUID+36), +(12, @OGUID+37), +(12, @OGUID+38), +(12, @OGUID+39), +(12, @OGUID+40), +(12, @OGUID+41), +(12, @OGUID+42), +(12, @OGUID+43), +(12, @OGUID+44), +(12, @OGUID+45), +(12, @OGUID+46), +(12, @OGUID+47), +(12, @OGUID+48), +(12, @OGUID+49), +(12, @OGUID+50), +(12, @OGUID+51), +(12, @OGUID+52), +(12, @OGUID+53), +(12, @OGUID+54), +(12, @OGUID+55), +(12, @OGUID+56), +(12, @OGUID+57), +(12, @OGUID+58), +(12, @OGUID+59), +(12, @OGUID+60), +(12, @OGUID+61), +(12, @OGUID+62), +(12, @OGUID+63), +(12, @OGUID+64), +(12, @OGUID+65), +(12, @OGUID+66), +(12, @OGUID+67), +(12, @OGUID+68), +(12, @OGUID+69), +(12, @OGUID+70), +(12, @OGUID+71), +(12, @OGUID+72), +(12, @OGUID+73), +(12, @OGUID+74), +(12, @OGUID+75), +(12, @OGUID+76), +(12, @OGUID+77), +(12, @OGUID+78), +(12, @OGUID+79), +(12, @OGUID+80), +(12, @OGUID+81), +(12, @OGUID+82); |