diff options
| -rw-r--r-- | sql/updates/world/master/2023_11_08_16_world_the_deadmines.sql | 112 |
1 files changed, 112 insertions, 0 deletions
diff --git a/sql/updates/world/master/2023_11_08_16_world_the_deadmines.sql b/sql/updates/world/master/2023_11_08_16_world_the_deadmines.sql new file mode 100644 index 00000000000..d08dbef68dd --- /dev/null +++ b/sql/updates/world/master/2023_11_08_16_world_the_deadmines.sql @@ -0,0 +1,112 @@ +SET @OGUID := 3005013; + +-- Gameobject spawns +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+51; +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, 36, 1581, 1581, '1,2', 0, 0, -46.2517356872558593, -780.95831298828125, 18.83513069152832031, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+1, 180405, 36, 1581, 1581, '1,2', 0, 0, -25.4583339691162109, -795.04864501953125, 24.81335639953613281, 2.408554315567016601, 0, 0, 0.933580398559570312, 0.358368009328842163, 7200, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+2, 180405, 36, 1581, 1581, '1,2', 0, 0, -27.5590286254882812, -831.66839599609375, 24.1566314697265625, 1.029743075370788574, 0, 0, 0.492423057556152343, 0.870355963706970214, 7200, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+3, 180405, 36, 1581, 1581, '1,2', 0, 0, -53.8333320617675781, -786.31597900390625, 38.92377090454101562, 3.45575571060180664, 0, 0, -0.98768806457519531, 0.156436234712600708, 7200, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+4, 180405, 36, 1581, 1581, '1,2', 0, 0, -16.9548606872558593, -835.4461669921875, 20.31581497192382812, 1.256635904312133789, 0, 0, 0.587784767150878906, 0.809017360210418701, 7200, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+5, 180405, 36, 1581, 1581, '1,2', 0, 0, -75.671875, -825.20831298828125, 40.14898300170898437, 1.832594871520996093, 0, 0, 0.793353080749511718, 0.608761727809906005, 7200, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+6, 180405, 36, 1581, 1581, '1,2', 0, 0, -48.4149322509765625, -860.07989501953125, 18.80362510681152343, 0.593410074710845947, 0, 0, 0.292370796203613281, 0.95630502700805664, 7200, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+7, 180405, 36, 1581, 1581, '1,2', 0, 0, -79.0607681274414062, -862.232666015625, 17.77784919738769531, 0.349065244197845458, 0, 0, 0.173647880554199218, 0.984807789325714111, 7200, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+8, 180405, 36, 1581, 1581, '1,2', 0, 0, -118.335067749023437, -844.42706298828125, 17.1402435302734375, 5.829400539398193359, 0, 0, -0.22495079040527343, 0.974370121955871582, 7200, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+9, 180405, 36, 1581, 1581, '1,2', 0, 0, -129.027786254882812, -816.0069580078125, 17.10091590881347656, 4.293513298034667968, 0, 0, -0.8386697769165039, 0.544640243053436279, 7200, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+10, 180405, 36, 1581, 1581, '1,2', 0, 0, -58.7326393127441406, -850.95660400390625, 22.46484565734863281, 0.506144583225250244, 0, 0, 0.250379562377929687, 0.968147754669189453, 7200, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+11, 180405, 36, 1581, 1581, '1,2', 0, 0, -109.065971374511718, -837.5694580078125, 21.00564193725585937, 5.89921426773071289, 0, 0, -0.19080829620361328, 0.981627285480499267, 7200, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+12, 180405, 36, 1581, 1581, '1,2', 0, 0, -74.84375, -812.3350830078125, 47.41023635864257812, 1.762782454490661621, 0, 0, 0.771624565124511718, 0.636078238487243652, 7200, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+13, 180405, 36, 1581, 1581, '1,2', 0, 0, -108.189239501953125, -800.91668701171875, 21.0112457275390625, 3.839725255966186523, 0, 0, -0.93969249725341796, 0.34202045202255249, 7200, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+14, 180405, 36, 1581, 1581, '1,2', 0, 0, -105.255210876464843, -786.6805419921875, 17.25224876403808593, 4.293513298034667968, 0, 0, -0.8386697769165039, 0.544640243053436279, 7200, 255, 1, 51886), -- G_Pumpkin_01 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+15, 180406, 36, 1581, 1581, '1,2', 0, 0, -20.7934036254882812, -800.046875, 24.93445205688476562, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 7200, 255, 1, 51886), -- G_Pumpkin_02 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+16, 180406, 36, 1581, 1581, '1,2', 0, 0, -11.6232643127441406, -820.70489501953125, 20.60879707336425781, 1.954769015312194824, 0, 0, 0.829037666320800781, 0.559192776679992675, 7200, 255, 1, 51886), -- G_Pumpkin_02 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+17, 180406, 36, 1581, 1581, '1,2', 0, 0, -64.2881927490234375, -789.107666015625, 22.18378067016601562, 3.141592741012573242, 0, 0, -1, 0, 7200, 255, 1, 51886), -- G_Pumpkin_02 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+18, 180406, 36, 1581, 1581, '1,2', 0, 0, -65.986114501953125, -784.67535400390625, 39.916259765625, 3.43830275535583496, 0, 0, -0.98901557922363281, 0.147811368107795715, 7200, 255, 1, 51886), -- G_Pumpkin_02 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+19, 180406, 36, 1581, 1581, '1,2', 0, 0, -56.2152786254882812, -778.5, 18.44533729553222656, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 7200, 255, 1, 51886), -- G_Pumpkin_02 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+20, 180406, 36, 1581, 1581, '1,2', 0, 0, -48.8125, -787.8524169921875, 38.68552017211914062, 3.001946926116943359, 0, 0, 0.997563362121582031, 0.069766148924827575, 7200, 255, 1, 51886), -- G_Pumpkin_02 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+21, 180406, 36, 1581, 1581, '1,2', 0, 0, -51.1215286254882812, -849.67364501953125, 22.83587455749511718, 0.628316879272460937, 0, 0, 0.309016227722167968, 0.95105677843093872, 7200, 255, 1, 51886), -- G_Pumpkin_02 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+22, 180406, 36, 1581, 1581, '1,2', 0, 0, -106.463539123535156, -852.22222900390625, 17.25153541564941406, 0.174532130360603332, 0, 0, 0.087155342102050781, 0.996194720268249511, 7200, 255, 1, 51886), -- G_Pumpkin_02 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+23, 180406, 36, 1581, 1581, '1,2', 0, 0, -36.3125, -855.060791015625, 19.3319244384765625, 0.767943859100341796, 0, 0, 0.374606132507324218, 0.927184045314788818, 7200, 255, 1, 51886), -- G_Pumpkin_02 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+24, 180406, 36, 1581, 1581, '1,2', 0, 0, -75.1631927490234375, -827.6805419921875, 47.40086746215820312, 2.251473426818847656, 0, 0, 0.902585029602050781, 0.430511653423309326, 7200, 255, 1, 51886), -- G_Pumpkin_02 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+25, 180406, 36, 1581, 1581, '1,2', 0, 0, -70.2899322509765625, -862.25347900390625, 21.71665000915527343, 0.174532130360603332, 0, 0, 0.087155342102050781, 0.996194720268249511, 7200, 255, 1, 51886), -- G_Pumpkin_02 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+26, 180406, 36, 1581, 1581, '1,2', 0, 0, -129.289932250976562, -821.138916015625, 17.100799560546875, 5.777040958404541015, 0, 0, -0.25037956237792968, 0.968147754669189453, 7200, 255, 1, 51886), -- G_Pumpkin_02 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+27, 180406, 36, 1581, 1581, '1,2', 0, 0, -99.6510391235351562, -843.310791015625, 21.15973472595214843, 6.248279094696044921, 0, 0, -0.01745223999023437, 0.999847710132598876, 7200, 255, 1, 51886), -- G_Pumpkin_02 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+28, 180406, 36, 1581, 1581, '1,2', 0, 0, -117.217018127441406, -793.8975830078125, 17.14227104187011718, 0.331610709428787231, 0, 0, 0.16504669189453125, 0.986285746097564697, 7200, 255, 1, 51886), -- G_Pumpkin_02 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+29, 180407, 36, 1581, 1581, '1,2', 0, 0, -15.7222223281860351, -808.2882080078125, 20.35940361022949218, 2.286378860473632812, 0, 0, 0.909960746765136718, 0.414694398641586303, 7200, 255, 1, 51886), -- G_Pumpkin_03 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+30, 180407, 36, 1581, 1581, '1,2', 0, 0, -35, -786.52606201171875, 19.33697128295898437, 2.757613182067871093, 0, 0, 0.981626510620117187, 0.190812408924102783, 7200, 255, 1, 51886), -- G_Pumpkin_03 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+31, 180407, 36, 1581, 1581, '1,2', 0, 0, -36.03125, -794.31427001953125, 39.38628005981445312, 2.879789113998413085, 0, 0, 0.991444587707519531, 0.130528271198272705, 7200, 255, 1, 51886), -- G_Pumpkin_03 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+32, 180407, 36, 1581, 1581, '1,2', 0, 0, -92.095489501953125, -781.01910400390625, 17.45472145080566406, 3.682650327682495117, 0, 0, -0.96362972259521484, 0.26724100112915039, 7200, 255, 1, 51886), -- G_Pumpkin_03 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+33, 180407, 36, 1581, 1581, '1,2', 0, 0, -93.6388931274414062, -857.951416015625, 17.45132827758789062, 0.017452461645007133, 0, 0, 0.008726119995117187, 0.999961912631988525, 7200, 255, 1, 51886), -- G_Pumpkin_03 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+34, 180407, 36, 1581, 1581, '1,2', 0, 0, -98.5138931274414062, -795.35418701171875, 21.17108345031738281, 3.9793548583984375, 0, 0, -0.9135446548461914, 0.406738430261611938, 7200, 255, 1, 51886), -- G_Pumpkin_03 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+35, 180407, 36, 1581, 1581, '1,2', 0, 0, -63.421875, -861.73089599609375, 21.79410362243652343, 0.314158439636230468, 0, 0, 0.156434059143066406, 0.987688362598419189, 7200, 255, 1, 51886), -- G_Pumpkin_03 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+36, 180407, 36, 1581, 1581, '1,2', 0, 0, -42.1649322509765625, -845.93231201171875, 23.29353523254394531, 0.663223206996917724, 0, 0, 0.325567245483398437, 0.945518851280212402, 7200, 255, 1, 51886), -- G_Pumpkin_03 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+37, 180407, 36, 1581, 1581, '1,2', 0, 0, -26.4652786254882812, -847.4288330078125, 19.81210136413574218, 0.942476630210876464, 0, 0, 0.453989982604980468, 0.891006767749786376, 7200, 255, 1, 51886), -- G_Pumpkin_03 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+38, 180407, 36, 1581, 1581, '1,2', 0, 0, -77.2899322509765625, -785.11285400390625, 39.03303909301757812, 3.543023586273193359, 0, 0, -0.97992420196533203, 0.199370384216308593, 7200, 255, 1, 51886), -- G_Pumpkin_03 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+39, 180407, 36, 1581, 1581, '1,2', 0, 0, -89.8072891235351562, -847.37677001953125, 21.38116455078125, 0.122172988951206207, 0, 0, 0.061048507690429687, 0.998134791851043701, 7200, 255, 1, 51886), -- G_Pumpkin_03 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+40, 180407, 36, 1581, 1581, '1,2', 0, 0, -128.0625, -803.076416015625, 17.10161781311035156, 4.398232460021972656, 0, 0, -0.80901622772216796, 0.587786316871643066, 7200, 255, 1, 51886), -- G_Pumpkin_03 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+41, 180407, 36, 1581, 1581, '1,2', 0, 0, -75.1857681274414062, -814.59893798828125, 40.1767578125, 2.059488296508789062, 0, 0, 0.857167243957519531, 0.515038192272186279, 7200, 255, 1, 51886), -- G_Pumpkin_03 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+42, 180407, 36, 1581, 1581, '1,2', 0, 0, -128.71875, -834.76739501953125, 17.10143852233886718, 5.532694816589355468, 0, 0, -0.3665008544921875, 0.93041771650314331, 7200, 255, 1, 51886), -- G_Pumpkin_03 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+43, 180431, 36, 1581, 1581, '1,2', 0, 0, -47.4513893127441406, -820.2257080078125, 51.79343795776367187, 5.044002056121826171, 0, 0, -0.58070278167724609, 0.814115643501281738, 7200, 255, 1, 51886), -- G_Pumpkin_01 scale 4.0 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+44, 180431, 36, 1581, 1581, '1,2', 0, 0, -126.661460876464843, -818.98956298828125, 21.83911323547363281, 5.044002056121826171, 0, 0, -0.58070278167724609, 0.814115643501281738, 7200, 255, 1, 51886), -- G_Pumpkin_01 scale 4.0 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+45, 180472, 36, 1581, 1581, '1,2', 0, 0, -108.519096374511718, -795.84893798828125, 27.05420112609863281, 3.700104713439941406, 0, 0, -0.96126079559326171, 0.275640487670898437, 7200, 255, 1, 51886), -- HangingSkullLight02 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+46, 180472, 36, 1581, 1581, '1,2', 0, 0, -100.090278625488281, -790.796875, 24.76599311828613281, 0.645771682262420654, 0, 0, 0.317304611206054687, 0.948323667049407958, 7200, 255, 1, 51886), -- HangingSkullLight02 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+47, 180472, 36, 1581, 1581, '1,2', 0, 0, -78.3159713745117187, -788.7569580078125, 35.73659133911132812, 2.495818138122558593, 0, 0, 0.948323249816894531, 0.317305892705917358, 7200, 255, 1, 51886), -- HangingSkullLight02 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+48, 180472, 36, 1581, 1581, '1,2', 0, 0, -83.2413177490234375, -786.6944580078125, 23.47067832946777343, 0.575957298278808593, 0, 0, 0.284014701843261718, 0.958819925785064697, 7200, 255, 1, 51886), -- HangingSkullLight02 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+49, 180472, 36, 1581, 1581, '1,2', 0, 0, -74.4288177490234375, -812.5694580078125, 45.81703567504882812, 5.89921426773071289, 0, 0, -0.19080829620361328, 0.981627285480499267, 7200, 255, 1, 51886), -- HangingSkullLight02 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+50, 180472, 36, 1581, 1581, '1,2', 0, 0, -74.4618072509765625, -779.94097900390625, 24.32401275634765625, 6.056293010711669921, 0, 0, -0.11320304870605468, 0.993571877479553222, 7200, 255, 1, 51886), -- HangingSkullLight02 (Area: The Deadmines - Difficulty: Normal) CreateObject1 +(@OGUID+51, 180472, 36, 1581, 1581, '1,2', 0, 0, -75.3836822509765625, -827.97393798828125, 45.74193954467773437, 0.191985160112380981, 0, 0, 0.095845222473144531, 0.995396256446838378, 7200, 255, 1, 51886); -- HangingSkullLight02 (Area: The Deadmines - Difficulty: Normal) CreateObject1 + +DELETE FROM `game_event_gameobject` WHERE `eventEntry`=12 AND `guid` BETWEEN @OGUID+0 AND @OGUID+51; +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); |