diff options
| -rw-r--r-- | sql/updates/world/master/2022_01_01_32_world_2020_04_20_00_world.sql | 215 |
1 files changed, 215 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_01_32_world_2020_04_20_00_world.sql b/sql/updates/world/master/2022_01_01_32_world_2020_04_20_00_world.sql new file mode 100644 index 00000000000..2f3a5936d19 --- /dev/null +++ b/sql/updates/world/master/2022_01_01_32_world_2020_04_20_00_world.sql @@ -0,0 +1,215 @@ +-- Zul Farrak Shallow Graves Pooling +SET @GUID := 10593; +SET @POOLENTRY := 660; +-- Deleting all the original Spawns and reuse the guids and coordinates to spawn the traps. Spawning non-trap shallow graves at the same position. +DELETE FROM `gameobject` WHERE `id` IN (128403,128308); +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `ScriptName`, `VerifiedBuild`) VALUES +(27139, 128403, 209, 1176, 1176, '1', 0, 1875.85, 1044.26, 9.07804, 0.855211, 0, 0, 0.414693, 0.909961, 7200, 100, 1, '', 0), +(@GUID+0, 128308, 209, 1176, 1176, '1', 0, 1875.85, 1044.26, 9.07804, 0.855211, 0, 0, 0.414693, 0.909961, 7200, 100, 1, '', 0), +(27138, 128403, 209, 1176, 1176, '1', 0, 1871.08, 1046.76, 9.03374, -2.16421, 0, 0, -0.882948, 0.469471, 7200, 100, 1, '', 0), +(@GUID+1, 128308, 209, 1176, 1176, '1', 0, 1871.08, 1046.76, 9.03374, -2.16421, 0, 0, -0.882948, 0.469471, 7200, 100, 1, '', 0), +(27137, 128403, 209, 1176, 1176, '1', 0, 1881.46, 1041.43, 8.87679, -2.19912, 0, 0, -0.891008, 0.453988, 7200, 100, 1, '', 0), +(@GUID+2, 128308, 209, 1176, 1176, '1', 0, 1881.46, 1041.43, 8.87679, -2.19912, 0, 0, -0.891008, 0.453988, 7200, 100, 1, '', 0), +(27135, 128403, 209, 1176, 1176, '1', 0, 1862.12, 1050.76, 9.05665, -2.3911, 0, 0, -0.930417, 0.366502, 7200, 100, 1, '', 0), +(@GUID+3, 128308, 209, 1176, 1176, '1', 0, 1862.12, 1050.76, 9.05665, -2.3911, 0, 0, -0.930417, 0.366502, 7200, 100, 1, '', 0), +(27134, 128403, 209, 1176, 1176, '1', 0, 1858.7, 1053.75, 8.87679, -2.74017, 0, 0, -0.979925, 0.199366, 7200, 100, 1, '', 0), +(@GUID+4, 128308, 209, 1176, 1176, '1', 0, 1858.7, 1053.75, 8.87679, -2.74017, 0, 0, -0.979925, 0.199366, 7200, 100, 1, '', 0), +(27133, 128403, 209, 1176, 1176, '1', 0, 1845.96, 1047.25, 8.87679, -0.453786, 0, 0, -0.224951, 0.97437, 7200, 100, 1, '', 0), +(@GUID+5, 128308, 209, 1176, 1176, '1', 0, 1845.96, 1047.25, 8.87679, -0.453786, 0, 0, -0.224951, 0.97437, 7200, 100, 1, '', 0), +(27132, 128403, 209, 1176, 1176, '1', 0, 1891.6, 1023.06, 9.37117, 2.79253, 0, 0, 0.984808, 0.173647, 7200, 100, 1, '', 0), +(@GUID+6, 128308, 209, 1176, 1176, '1', 0, 1891.6, 1023.06, 9.37117, 2.79253, 0, 0, 0.984808, 0.173647, 7200, 100, 1, '', 0), +(27131, 128403, 209, 1176, 1176, '1', 0, 1881.99, 1034.68, 8.87679, -0.453786, 0, 0, -0.224951, 0.97437, 7200, 100, 1, '', 0), +(@GUID+7, 128308, 209, 1176, 1176, '1', 0, 1881.99, 1034.68, 8.87679, -0.453786, 0, 0, -0.224951, 0.97437, 7200, 100, 1, '', 0), +(27130, 128403, 209, 1176, 1176, '1', 0, 1888.36, 1037, 8.92103, -1.98968, 0, 0, -0.838672, 0.544637, 7200, 100, 1, '', 0), +(@GUID+8, 128308, 209, 1176, 1176, '1', 0, 1888.36, 1037, 8.92103, -1.98968, 0, 0, -0.838672, 0.544637, 7200, 100, 1, '', 0), +(27129, 128403, 209, 1176, 1176, '1', 0, 1892.57, 1006.37, 9.06781, -2.1293, 0, 0, -0.874619, 0.48481, 7200, 100, 1, '', 0), +(@GUID+9, 128308, 209, 1176, 1176, '1', 0, 1892.57, 1006.37, 9.06781, -2.1293, 0, 0, -0.874619, 0.48481, 7200, 100, 1, '', 0), +(27128, 128403, 209, 1176, 1176, '1', 0, 1887.94, 1029.08, 9.14775, 0.855211, 0, 0, 0.414693, 0.909961, 7200, 100, 1, '', 0), +(@GUID+10, 128308, 209, 1176, 1176, '1', 0, 1887.94, 1029.08, 9.14775, 0.855211, 0, 0, 0.414693, 0.909961, 7200, 100, 1, '', 0), +(27126, 128403, 209, 1176, 1176, '1', 0, 1867.74, 1041.84, 8.8768, -0.436333, 0, 0, -0.21644, 0.976296, 7200, 100, 1, '', 0), +(@GUID+11, 128308, 209, 1176, 1176, '1', 0, 1867.74, 1041.84, 8.8768, -0.436333, 0, 0, -0.21644, 0.976296, 7200, 100, 1, '', 0), +(27121, 128403, 209, 1176, 1176, '1', 0, 1845.54, 1024.12, 9.07972, 0.977384, 0, 0, 0.469471, 0.882948, 7200, 100, 1, '', 0), +(@GUID+12, 128308, 209, 1176, 1176, '1', 0, 1845.54, 1024.12, 9.07972, 0.977384, 0, 0, 0.469471, 0.882948, 7200, 100, 1, '', 0), +(27120, 128403, 209, 1176, 1176, '1', 0, 1839.18, 1036.88, 9.35239, -1.67552, 0, 0, -0.743146, 0.669129, 7200, 100, 1, '', 0), +(@GUID+13, 128308, 209, 1176, 1176, '1', 0, 1839.18, 1036.88, 9.35239, -1.67552, 0, 0, -0.743146, 0.669129, 7200, 100, 1, '', 0), +(27119, 128403, 209, 1176, 1176, '1', 0, 1841.82, 1027.76, 9.15097, 0.959931, 0, 0, 0.461749, 0.887011, 7200, 100, 1, '', 0), +(@GUID+14, 128308, 209, 1176, 1176, '1', 0, 1841.82, 1027.76, 9.15097, 0.959931, 0, 0, 0.461749, 0.887011, 7200, 100, 1, '', 0), +(27118, 128403, 209, 1176, 1176, '1', 0, 1843.19, 1041.16, 8.87679, -0.401426, 0, 0, -0.199368, 0.979925, 7200, 100, 1, '', 0), +(@GUID+15, 128308, 209, 1176, 1176, '1', 0, 1843.19, 1041.16, 8.87679, -0.401426, 0, 0, -0.199368, 0.979925, 7200, 100, 1, '', 0), +(27117, 128403, 209, 1176, 1176, '1', 0, 1852.41, 1024.78, 8.87679, -2.49582, 0, 0, -0.948324, 0.317305, 7200, 100, 1, '', 0), +(@GUID+16, 128308, 209, 1176, 1176, '1', 0, 1852.41, 1024.78, 8.87679, -2.49582, 0, 0, -0.948324, 0.317305, 7200, 100, 1, '', 0), +(27115, 128403, 209, 1176, 1176, '1', 0, 1841.08, 1045.54, 9.21622, 3.05433, 0, 0, 0.999048, 0.0436174, 7200, 100, 1, '', 0), +(@GUID+17, 128308, 209, 1176, 1176, '1', 0, 1841.08, 1045.54, 9.21622, 3.05433, 0, 0, 0.999048, 0.0436174, 7200, 100, 1, '', 0), +(27114, 128403, 209, 1176, 1176, '1', 0, 1832.72, 1032.39, 9.45168, 0.575959, 0, 0, 0.284016, 0.95882, 7200, 100, 1, '', 0), +(@GUID+18, 128308, 209, 1176, 1176, '1', 0, 1832.72, 1032.39, 9.45168, 0.575959, 0, 0, 0.284016, 0.95882, 7200, 100, 1, '', 0), +(27113, 128403, 209, 1176, 1176, '1', 0, 1871.3, 1008.32, 8.87679, 1.0821, 0, 0, 0.515036, 0.857168, 7200, 100, 1, '', 0), +(@GUID+19, 128308, 209, 1176, 1176, '1', 0, 1871.3, 1008.32, 8.87679, 1.0821, 0, 0, 0.515036, 0.857168, 7200, 100, 1, '', 0), +(27111, 128403, 209, 1176, 1176, '1', 0, 1871.86, 994.256, 8.8819, 0.506145, 0, 0, 0.25038, 0.968148, 7200, 100, 1, '', 0), +(@GUID+20, 128308, 209, 1176, 1176, '1', 0, 1871.86, 994.256, 8.8819, 0.506145, 0, 0, 0.25038, 0.968148, 7200, 100, 1, '', 0), +(27108, 128403, 209, 1176, 1176, '1', 0, 1894.39, 977.006, 8.92631, -0.279253, 0, 0, -0.139173, 0.990268, 7200, 100, 1, '', 0), +(@GUID+21, 128308, 209, 1176, 1176, '1', 0, 1894.39, 977.006, 8.92631, -0.279253, 0, 0, -0.139173, 0.990268, 7200, 100, 1, '', 0), +(27106, 128403, 209, 1176, 1176, '1', 0, 1890.12, 989.759, 8.87679, 2.70526, 0, 0, 0.976296, 0.21644, 7200, 100, 1, '', 0), +(@GUID+22, 128308, 209, 1176, 1176, '1', 0, 1890.12, 989.759, 8.87679, 2.70526, 0, 0, 0.976296, 0.21644, 7200, 100, 1, '', 0), +(27105, 128403, 209, 1176, 1176, '1', 0, 1865.03, 1012.49, 8.8768, 1.0472, 0, 0, 0.500001, 0.866025, 7200, 100, 1, '', 0), +(@GUID+23, 128308, 209, 1176, 1176, '1', 0, 1865.03, 1012.49, 8.8768, 1.0472, 0, 0, 0.500001, 0.866025, 7200, 100, 1, '', 0), +(27104, 128403, 209, 1176, 1176, '1', 0, 1866.24, 1008.4, 8.87679, 0.663225, 0, 0, 0.325568, 0.945519, 7200, 100, 1, '', 0), +(@GUID+24, 128308, 209, 1176, 1176, '1', 0, 1866.24, 1008.4, 8.87679, 0.663225, 0, 0, 0.325568, 0.945519, 7200, 100, 1, '', 0), +(27103, 128403, 209, 1176, 1176, '1', 0, 1861.12, 1019.39, 8.87679, -1.18682, 0, 0, -0.559191, 0.829039, 7200, 100, 1, '', 0), +(@GUID+25, 128308, 209, 1176, 1176, '1', 0, 1861.12, 1019.39, 8.87679, -1.18682, 0, 0, -0.559191, 0.829039, 7200, 100, 1, '', 0), +(27102, 128403, 209, 1176, 1176, '1', 0, 1839.42, 1023.49, 9.56256, 2.98451, 0, 0, 0.996917, 0.0784606, 7200, 100, 1, '', 0), +(@GUID+26, 128308, 209, 1176, 1176, '1', 0, 1839.42, 1023.49, 9.56256, 2.98451, 0, 0, 0.996917, 0.0784606, 7200, 100, 1, '', 0), +(27100, 128403, 209, 1176, 1176, '1', 0, 1882.7, 971.825, 8.87679, 0.994838, 0, 0, 0.477159, 0.878817, 7200, 100, 1, '', 0), +(@GUID+27, 128308, 209, 1176, 1176, '1', 0, 1882.7, 971.825, 8.87679, 0.994838, 0, 0, 0.477159, 0.878817, 7200, 100, 1, '', 0), +(27099, 128403, 209, 1176, 1176, '1', 0, 1876.44, 972.207, 9.91169, 2.84489, 0, 0, 0.989016, 0.147808, 7200, 100, 1, '', 0), +(@GUID+28, 128308, 209, 1176, 1176, '1', 0, 1876.44, 972.207, 9.91169, 2.84489, 0, 0, 0.989016, 0.147808, 7200, 100, 1, '', 0), +(27098, 128403, 209, 1176, 1176, '1', 0, 1879.89, 974.651, 8.87679, 1.0472, 0, 0, 0.500001, 0.866025, 7200, 100, 1, '', 0), +(@GUID+29, 128308, 209, 1176, 1176, '1', 0, 1879.89, 974.651, 8.87679, 1.0472, 0, 0, 0.500001, 0.866025, 7200, 100, 1, '', 0), +(27097, 128403, 209, 1176, 1176, '1', 0, 1887.46, 967.143, 8.98506, -0.314159, 0, 0, -0.156434, 0.987688, 7200, 100, 1, '', 0), +(@GUID+30, 128308, 209, 1176, 1176, '1', 0, 1887.46, 967.143, 8.98506, -0.314159, 0, 0, -0.156434, 0.987688, 7200, 100, 1, '', 0), +(27136, 128403, 209, 1176, 1176, '1', 0, 1866.33, 1049.64, 9.01483, 1.11701, 0, 0, 0.529919, 0.848048, 7200, 100, 1, '', 0), +(@GUID+31, 128308, 209, 1176, 1176, '1', 0, 1866.33, 1049.64, 9.01483, 1.11701, 0, 0, 0.529919, 0.848048, 7200, 100, 1, '', 0), +(27127, 128403, 209, 1176, 1176, '1', 0, 1869.28, 1020.08, 8.87679, -0.488692, 0, 0, -0.241922, 0.970296, 7200, 100, 1, '', 0), +(@GUID+32, 128308, 209, 1176, 1176, '1', 0, 1869.28, 1020.08, 8.87679, -0.488692, 0, 0, -0.241922, 0.970296, 7200, 100, 1, '', 0), +(27122, 128403, 209, 1176, 1176, '1', 0, 1863.41, 1044.78, 8.87679, -1.71042, 0, 0, -0.754709, 0.65606, 7200, 100, 1, '', 0), +(@GUID+33, 128308, 209, 1176, 1176, '1', 0, 1863.41, 1044.78, 8.87679, -1.71042, 0, 0, -0.754709, 0.65606, 7200, 100, 1, '', 0), +(27116, 128403, 209, 1176, 1176, '1', 0, 1836.74, 1029.36, 9.62377, 0.942478, 0, 0, 0.453991, 0.891006, 7200, 100, 1, '', 0), +(@GUID+34, 128308, 209, 1176, 1176, '1', 0, 1836.74, 1029.36, 9.62377, 0.942478, 0, 0, 0.453991, 0.891006, 7200, 100, 1, '', 0), +(27112, 128403, 209, 1176, 1176, '1', 0, 1890.27, 970.862, 9.01388, 2.56563, 0, 0, 0.958819, 0.284017, 7200, 100, 1, '', 0), +(@GUID+35, 128308, 209, 1176, 1176, '1', 0, 1890.27, 970.862, 9.01388, 2.56563, 0, 0, 0.958819, 0.284017, 7200, 100, 1, '', 0), +(27110, 128403, 209, 1176, 1176, '1', 0, 1888.64, 977.75, 8.87679, -2.56563, 0, 0, -0.958819, 0.284017, 7200, 100, 1, '', 0), +(@GUID+36, 128308, 209, 1176, 1176, '1', 0, 1888.64, 977.75, 8.87679, -2.56563, 0, 0, -0.958819, 0.284017, 7200, 100, 1, '', 0), +(27109, 128403, 209, 1176, 1176, '1', 0, 1897.98, 985.276, 8.89835, 2.75762, 0, 0, 0.981627, 0.190809, 7200, 100, 1, '', 0), +(@GUID+37, 128308, 209, 1176, 1176, '1', 0, 1897.98, 985.276, 8.89835, 2.75762, 0, 0, 0.981627, 0.190809, 7200, 100, 1, '', 0), +(27107, 128403, 209, 1176, 1176, '1', 0, 1897.08, 980.836, 8.95884, -2.98451, 0, 0, -0.996917, 0.0784606, 7200, 100, 1, '', 0), +(@GUID+38, 128308, 209, 1176, 1176, '1', 0, 1897.08, 980.836, 8.95884, -2.98451, 0, 0, -0.996917, 0.0784606, 7200, 100, 1, '', 0), +(27101, 128403, 209, 1176, 1176, '1', 0, 1876.14, 976.482, 9.05195, 1.01229, 0, 0, 0.484809, 0.87462, 7200, 100, 1, '', 0), +(@GUID+39, 128308, 209, 1176, 1176, '1', 0, 1876.14, 976.482, 9.05195, 1.01229, 0, 0, 0.484809, 0.87462, 7200, 100, 1, '', 0); + +-- Creating the required pool templates +DELETE FROM `pool_template` WHERE `entry` BETWEEN @POOLENTRY+0 AND @POOLENTRY+39; +INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES +(@POOLENTRY+0, 1, 'Shallow Grave1'), +(@POOLENTRY+1, 1, 'Shallow Grave2'), +(@POOLENTRY+2, 1, 'Shallow Grave3'), +(@POOLENTRY+3, 1, 'Shallow Grave4'), +(@POOLENTRY+4, 1, 'Shallow Grave5'), +(@POOLENTRY+5, 1, 'Shallow Grave6'), +(@POOLENTRY+6, 1, 'Shallow Grave7'), +(@POOLENTRY+7, 1, 'Shallow Grave8'), +(@POOLENTRY+8, 1, 'Shallow Grave9'), +(@POOLENTRY+9, 1, 'Shallow Grave10'), +(@POOLENTRY+10, 1, 'Shallow Grave11'), +(@POOLENTRY+11, 1, 'Shallow Grave12'), +(@POOLENTRY+12, 1, 'Shallow Grave13'), +(@POOLENTRY+13, 1, 'Shallow Grave14'), +(@POOLENTRY+14, 1, 'Shallow Grave15'), +(@POOLENTRY+15, 1, 'Shallow Grave16'), +(@POOLENTRY+16, 1, 'Shallow Grave17'), +(@POOLENTRY+17, 1, 'Shallow Grave18'), +(@POOLENTRY+18, 1, 'Shallow Grave19'), +(@POOLENTRY+19, 1, 'Shallow Grave20'), +(@POOLENTRY+20, 1, 'Shallow Grave21'), +(@POOLENTRY+21, 1, 'Shallow Grave22'), +(@POOLENTRY+22, 1, 'Shallow Grave23'), +(@POOLENTRY+23, 1, 'Shallow Grave24'), +(@POOLENTRY+24, 1, 'Shallow Grave25'), +(@POOLENTRY+25, 1, 'Shallow Grave26'), +(@POOLENTRY+26, 1, 'Shallow Grave27'), +(@POOLENTRY+27, 1, 'Shallow Grave28'), +(@POOLENTRY+28, 1, 'Shallow Grave29'), +(@POOLENTRY+29, 1, 'Shallow Grave30'), +(@POOLENTRY+30, 1, 'Shallow Grave31'), +(@POOLENTRY+31, 1, 'Shallow Grave32'), +(@POOLENTRY+32, 1, 'Shallow Grave33'), +(@POOLENTRY+33, 1, 'Shallow Grave34'), +(@POOLENTRY+34, 1, 'Shallow Grave35'), +(@POOLENTRY+35, 1, 'Shallow Grave36'), +(@POOLENTRY+36, 1, 'Shallow Grave37'), +(@POOLENTRY+37, 1, 'Shallow Grave38'), +(@POOLENTRY+38, 1, 'Shallow Grave39'), +(@POOLENTRY+39, 1, 'Shallow Grave40'); + +-- Adding all spawns to pools with chance 78% for trap, 22 % for non trap +DELETE FROM `pool_members` WHERE `type`=1 AND `spawnId` IN (27139,27138,27137,27135,27134,27133,27132,27131,27130,27129,27128,27126,27120,27121,27122,27119,27118,27117,27115,27114,27113,27111,27108,27106,27105,27104,27103,27102,27100,27099,27098,27097,27136,27127,27122,27116,27112,27110,27109,27107,27101); +DELETE FROM `pool_members` WHERE `type`=1 AND `spawnId`BETWEEN @GUID+0 AND @GUID+39; +INSERT INTO `pool_members` (`type`, `spawnId`, `poolSpawnId`, `chance`, `description`) VALUES +(1, 27139, @POOLENTRY+0, 78, 'Shallow Grave Trap'), +(1, @GUID+0, @POOLENTRY+0, 22, 'Shallow Grave'), +(1, 27138, @POOLENTRY+1, 78, 'Shallow Grave Trap'), +(1, @GUID+1, @POOLENTRY+1, 22, 'Shallow Grave'), +(1, 27137, @POOLENTRY+2, 78, 'Shallow Grave Trap'), +(1, @GUID+2, @POOLENTRY+2, 22, 'Shallow Grave'), +(1, 27135, @POOLENTRY+3, 78, 'Shallow Grave Trap'), +(1, @GUID+3, @POOLENTRY+3, 22, 'Shallow Grave'), +(1, 27134, @POOLENTRY+4, 78, 'Shallow Grave Trap'), +(1, @GUID+4, @POOLENTRY+4, 22, 'Shallow Grave'), +(1, 27133, @POOLENTRY+5, 78, 'Shallow Grave Trap'), +(1, @GUID+5, @POOLENTRY+5, 22, 'Shallow Grave'), +(1, 27132, @POOLENTRY+6, 78, 'Shallow Grave Trap'), +(1, @GUID+6, @POOLENTRY+6, 22, 'Shallow Grave'), +(1, 27131, @POOLENTRY+7, 78, 'Shallow Grave Trap'), +(1, @GUID+7, @POOLENTRY+7, 22, 'Shallow Grave'), +(1, 27130, @POOLENTRY+8, 78, 'Shallow Grave Trap'), +(1, @GUID+8, @POOLENTRY+8, 22, 'Shallow Grave'), +(1, 27129, @POOLENTRY+9, 78, 'Shallow Grave Trap'), +(1, @GUID+9, @POOLENTRY+9, 22, 'Shallow Grave'), +(1, 27128, @POOLENTRY+10, 78, 'Shallow Grave Trap'), +(1, @GUID+10, @POOLENTRY+10, 22, 'Shallow Grave'), +(1, 27126, @POOLENTRY+11, 78, 'Shallow Grave Trap'), +(1, @GUID+11, @POOLENTRY+11, 22, 'Shallow Grave'), +(1, 27121, @POOLENTRY+12, 78, 'Shallow Grave Trap'), +(1, @GUID+12, @POOLENTRY+12, 22, 'Shallow Grave'), +(1, 27120, @POOLENTRY+13, 78, 'Shallow Grave Trap'), +(1, @GUID+13, @POOLENTRY+13, 22, 'Shallow Grave'), +(1, 27119, @POOLENTRY+14, 78, 'Shallow Grave Trap'), +(1, @GUID+14, @POOLENTRY+14, 22, 'Shallow Grave'), +(1, 27118, @POOLENTRY+15, 78, 'Shallow Grave Trap'), +(1, @GUID+15, @POOLENTRY+15, 22, 'Shallow Grave'), +(1, 27117, @POOLENTRY+16, 78, 'Shallow Grave Trap'), +(1, @GUID+16, @POOLENTRY+16, 22, 'Shallow Grave'), +(1, 27115, @POOLENTRY+17, 78, 'Shallow Grave Trap'), +(1, @GUID+17, @POOLENTRY+17, 22, 'Shallow Grave'), +(1, 27114, @POOLENTRY+18, 78, 'Shallow Grave Trap'), +(1, @GUID+18, @POOLENTRY+18, 22, 'Shallow Grave'), +(1, 27113, @POOLENTRY+19, 78, 'Shallow Grave Trap'), +(1, @GUID+19, @POOLENTRY+19, 22, 'Shallow Grave'), +(1, 27111, @POOLENTRY+20, 78, 'Shallow Grave Trap'), +(1, @GUID+20, @POOLENTRY+20, 22, 'Shallow Grave'), +(1, 27108, @POOLENTRY+21, 78, 'Shallow Grave Trap'), +(1, @GUID+21, @POOLENTRY+21, 22, 'Shallow Grave'), +(1, 27106, @POOLENTRY+22, 78, 'Shallow Grave Trap'), +(1, @GUID+22, @POOLENTRY+22, 22, 'Shallow Grave'), +(1, 27105, @POOLENTRY+23, 78, 'Shallow Grave Trap'), +(1, @GUID+23, @POOLENTRY+23, 22, 'Shallow Grave'), +(1, 27104, @POOLENTRY+24, 78, 'Shallow Grave Trap'), +(1, @GUID+24, @POOLENTRY+24, 22, 'Shallow Grave'), +(1, 27103, @POOLENTRY+25, 78, 'Shallow Grave Trap'), +(1, @GUID+25, @POOLENTRY+25, 22, 'Shallow Grave'), +(1, 27102, @POOLENTRY+26, 78, 'Shallow Grave Trap'), +(1, @GUID+26, @POOLENTRY+26, 22, 'Shallow Grave'), +(1, 27100, @POOLENTRY+27, 78, 'Shallow Grave Trap'), +(1, @GUID+27, @POOLENTRY+27, 22, 'Shallow Grave'), +(1, 27099, @POOLENTRY+28, 78, 'Shallow Grave Trap'), +(1, @GUID+28, @POOLENTRY+28, 22, 'Shallow Grave'), +(1, 27098, @POOLENTRY+29, 78, 'Shallow Grave Trap'), +(1, @GUID+29, @POOLENTRY+29, 22, 'Shallow Grave'), +(1, 27097, @POOLENTRY+30, 78, 'Shallow Grave Trap'), +(1, @GUID+30, @POOLENTRY+30, 22, 'Shallow Grave'), +(1, 27136, @POOLENTRY+31, 78, 'Shallow Grave Trap'), +(1, @GUID+31, @POOLENTRY+31, 22, 'Shallow Grave'), +(1, 27127, @POOLENTRY+32, 78, 'Shallow Grave Trap'), +(1, @GUID+32, @POOLENTRY+32, 22, 'Shallow Grave'), +(1, 27122, @POOLENTRY+33, 78, 'Shallow Grave Trap'), +(1, @GUID+33, @POOLENTRY+33, 22, 'Shallow Grave'), +(1, 27116, @POOLENTRY+34, 78, 'Shallow Grave Trap'), +(1, @GUID+34, @POOLENTRY+34, 22, 'Shallow Grave'), +(1, 27112, @POOLENTRY+35, 78, 'Shallow Grave Trap'), +(1, @GUID+35, @POOLENTRY+35, 22, 'Shallow Grave'), +(1, 27110, @POOLENTRY+36, 78, 'Shallow Grave Trap'), +(1, @GUID+36, @POOLENTRY+36, 22, 'Shallow Grave'), +(1, 27109, @POOLENTRY+37, 78, 'Shallow Grave Trap'), +(1, @GUID+37, @POOLENTRY+37, 22, 'Shallow Grave'), +(1, 27107, @POOLENTRY+38, 78, 'Shallow Grave Trap'), +(1, @GUID+38, @POOLENTRY+38, 22, 'Shallow Grave'), +(1, 27101, @POOLENTRY+39, 78, 'Shallow Grave Trap'), +(1, @GUID+39, @POOLENTRY+39, 22, 'Shallow Grave'); |