diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2024_05_26_03_world.sql | 39 |
1 files changed, 39 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_05_26_03_world.sql b/sql/updates/world/3.3.5/2024_05_26_03_world.sql new file mode 100644 index 00000000000..74152c39756 --- /dev/null +++ b/sql/updates/world/3.3.5/2024_05_26_03_world.sql @@ -0,0 +1,39 @@ +-- UPDATE Stratholme Signposts with sniffed values from build: V4_4_0_54737 +DELETE FROM `gameobject` WHERE `guid` IN (25329,27141,18209,20638,20733,20746,42972,20747,20748,45054,12152,12153,12155,22034,25119,12045,12145,12158,15560,15561,27561,27562,27587,20777,20850,20871,20873); +INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `ScriptName`, `VerifiedBuild`) VALUES +(25329, 175459, 329, 0, 0, 1, 1, 3446.5439453125, -3370.093017578125, 140.9564361572265625, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 7200, 255, 1, '', 54737), -- To Stranglethorn Vale +(27141, 175460, 329, 0, 0, 1, 1, 3447.166015625, -3369.943603515625, 140.9246978759765625, 4.7944183349609375, -0.11731481552124023, 0.128026962280273437, -0.66532611846923828, 0.726076781749725341, 7200, 255, 1, '', 54737), -- Market Row +(18209, 175441, 329, 0, 0, 1, 1, 3524.133544921875, -3377.8134765625, 133.0133819580078125, 2.967044830322265625, -0.00380182266235351, -0.04345226287841796, 0.995245933532714843, 0.087080210447311401, 7200, 255, 1, '', 54737), -- Elders' Square + +(20638, 175442, 329, 0, 0, 1, 1, 3524.405029296875, -3376.470458984375, 132.17120361328125, 2.967034816741943359, -0.01886367797851562, -0.21561527252197265, 0.9725799560546875, 0.085102535784244537, 7200, 255, 1, '', 54737), -- Festival Lane +(20733, 175443, 329, 0, 0, 1, 1, 3524.434326171875, -3376.182373046875, 133.0558013916015625, 6.108653545379638671, 0, 0, -0.08715534210205078, 0.996194720268249511, 7200, 255, 1, '', 54737), -- Market Row +(20746, 175444, 329, 0, 0, 1, 1, 3523.578369140625, -3377.0380859375, 132.508636474609375, 1.396262884140014648, -0.03341388702392578, -0.02803707122802734, 0.642175674438476562, 0.765315532684326171, 7200, 255, 1, '', 54737), -- Main Gate +(42972, 175824, 329, 0, 0, 1, 1, 3524.500244140625, -3375.92529296875, 132.2577972412109375, 6.109068870544433593, 0.034766674041748046, 0.003041267395019531, -0.08710289001464843, 0.995587825775146484, 7200, 255, 1, '', 54737), -- Crusaders' Square + +(20747, 175445, 329, 0, 0, 1, 1, 3558.121337890625, -3320.4375, 130.2953338623046875, 4.450591087341308593, 0.07945871353149414, -0.10355281829833984, -0.78656578063964843, 0.603554010391235351, 7200, 255, 1, '', 54737), -- Market Row +(20748, 175447, 329, 0, 0, 1, 1, 3555.99267578125, -3321.162109375, 129.5000762939453125, 2.879780769348144531, 0.005692958831787109, 0.043245315551757812, 0.990500450134277343, 0.130408123135566711, 7200, 255, 1, '', 54737), -- Main Gate +(45054, 175825, 329, 0, 0, 1, 1, 3557.52685546875, -3320.4375, 129.2545013427734375, 4.455188751220703125, 0.003703594207763671, -0.04522895812988281, -0.79056072235107421, 0.610699892044067382, 7200, 255, 1, '', 54737), -- Crusaders' Square + +(12152, 175435, 329, 0, 0, 1, 1, 3652.9052734375, -3325.3388671875, 123.9886703491210937, 2.094393253326416015, 0, 0, 0.866024971008300781, 0.50000077486038208, 7200, 255, 1, '', 54737), -- King's Square +(12153, 175436, 329, 0, 0, 1, 1, 3654.427490234375, -3325.948486328125, 123.5406341552734375, 3.665196418762207031, 0.011289596557617187, -0.04213237762451171, -0.96500587463378906, 0.258575111627578735, 7200, 255, 1, '', 54737), -- Festival Lane +(12155, 175437, 329, 0, 0, 1, 1, 3655.42041015625, -3323.930908203125, 124.335906982421875, 5.235989570617675781, 0.113039016723632812, -0.0652627944946289, -0.49572181701660156, 0.858616769313812255, 7200, 255, 1, '', 54737), -- Crusaders' Square + +(22034, 175457, 329, 0, 0, 1, 1, 3704.015625, -3246.3232421875, 127.4420394897460937, 0.69812941551208496, 0, 0, 0.342019081115722656, 0.939693033695220947, 7200, 255, 1, '', 54737), -- Crusaders' Square +(25119, 175458, 329, 0, 0, 1, 1, 3704.120849609375, -3247.52880859375, 126.8948822021484375, 2.268927812576293945, -0.0184335708618164, -0.03953266143798828, 0.905445098876953125, 0.422216206789016723, 7200, 255, 1, '', 54737), -- Market Row + +(12045, 175433, 329, 0, 0, 1, 1, 3707.61474609375, -3402.7021484375, 132.40533447265625, 3.310894250869750976, 0, 0.173647880554199218, -0.98106002807617187, 0.085835136473178863, 7200, 255, 1, '', 54737), -- Festival Lane +(12145, 175434, 329, 0, 0, 1, 1, 3707.411376953125, -3402.095458984375, 132.43707275390625, 0.174532130360603332, 0, 0, 0.087155342102050781, 0.996194720268249511, 7200, 255, 1, '', 54737), -- Crusaders' Square + +(12158, 175438, 329, 0, 0, 1, 1, 3649.884765625, -3496.593994140625, 137.0592193603515625, 4.799658775329589843, 0.096233844757080078, -0.0881814956665039, -0.66980934143066406, 0.730970919132232666, 7200, 255, 1, '', 54737), -- Market Row +(15560, 175439, 329, 0, 0, 1, 1, 3647.01025390625, -3496.806884765625, 136.71197509765625, 1.658061861991882324, 0, 0, 0.737277030944824218, 0.67559051513671875, 7200, 255, 1, '', 54737), -- King's Square +(15561, 175440, 329, 0, 0, 1, 1, 3648.13232421875, -3498.0029296875, 136.263946533203125, 3.228901147842407226, 0.001902580261230468, -0.04357719421386718, -0.99809646606445312, 0.043598759919404983, 7200, 255, 1, '', 54737), -- Elders' Square + +(27561, 175461, 329, 0, 0, 1, 1, 3683.655029296875, -3612.593994140625, 138.91009521484375, 1.83259439468383789, 0.07945871353149414, 0.103552818298339843, 0.786565780639648437, 0.603554010391235351, 7200, 255, 1, '', 54737), -- Service Entrance +(27562, 175462, 329, 0, 0, 1, 1, 3686.44873046875, -3611.885009765625, 138.5628662109375, 4.97418975830078125, 0, 0, -0.60876083374023437, 0.793353796005249023, 7200, 255, 1, '', 54737), -- The Gauntlet +(27587, 175463, 329, 0, 0, 1, 1, 3685.13623046875, -3610.902099609375, 138.1148223876953125, 0.261798620223999023, 0.043245792388916015, 0.005692481994628906, 0.130401611328125, 0.990501284599304199, 7200, 255, 1, '', 54737), -- Festival Lane + +(20777, 175449, 329, 0, 0, 1, 1, 3812.270751953125, -3615.736083984375, 145.2386627197265625, 5.445430278778076171, 0.039847850799560546, -0.01774120330810546, -0.40634822845458984, 0.912676572799682617, 7200, 255, 1, '', 54737), -- Slaughter Square +(20850, 175450, 329, 0, 0, 1, 1, 3810.090576171875, -3615.1845703125, 146.033935546875, 0.733037710189819335, 0.121856689453125, 0.04677581787109375, 0.355301856994628906, 0.92559361457824707, 7200, 255, 1, '', 54737), -- Elders' Square + +(20871, 175454, 329, 0, 0, 1, 1, 3993.23095703125, -3547.21435546875, 124.4813613891601562, 1.946041464805603027, 0, 0, 0.826589584350585937, 0.56280517578125, 7200, 255, 1, '', 54737), -- Elders' Square +(20873, 175455, 329, 0, 0, 1, 1, 3994.77880859375, -3546.61865234375, 124.4389419555664062, 5.08763742446899414, -0.03605461120605468, 0.024548530578613281, -0.56226825714111328, 0.825803756713867187, 7200, 255, 1, '', 54737); -- Slaughter Square |