From 11defa83c70519f3502d55963bc0067eb62b2ff5 Mon Sep 17 00:00:00 2001 From: "github-actions[bot]" Date: Tue, 16 Sep 2025 23:23:35 +0000 Subject: chore(DB): import pending files Referenced commit(s): f0acf6e3f02432c14acf9aa928f3d8c1c62c18b2 --- data/sql/updates/db_world/2025_09_16_06.sql | 48 ++++++++++++++++++++++ .../pending_db_world/rev_1758049497884332500.sql | 47 --------------------- 2 files changed, 48 insertions(+), 47 deletions(-) create mode 100644 data/sql/updates/db_world/2025_09_16_06.sql delete mode 100644 data/sql/updates/pending_db_world/rev_1758049497884332500.sql diff --git a/data/sql/updates/db_world/2025_09_16_06.sql b/data/sql/updates/db_world/2025_09_16_06.sql new file mode 100644 index 0000000000..9494da8f9f --- /dev/null +++ b/data/sql/updates/db_world/2025_09_16_06.sql @@ -0,0 +1,48 @@ +-- DB update 2025_09_16_05 -> 2025_09_16_06 +-- Update gameobject 'Sturdy Vine' with sniffed values +-- updated spawns +DELETE FROM `gameobject` WHERE (`id` IN (190622)) AND (`guid` IN (59679, 59680, 59681, 59682, 59683, 59684, 59685, 59686, 59687, 59688, 59689, 59690, 59691, 59692, 59693, 59694, 59695, 59696, 59697, 59698, 59699, 59700, 59701, 59702)); +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`, `Comment`) VALUES +(59679, 190622, 571, 0, 0, 1, 1, 5673.72216796875, 4650.47802734375, -125.527442932128906, 5.183629035949707031, 0, 0, -0.52249813079833984, 0.852640450000762939, 120, 255, 1, "", 45942, NULL), +(59680, 190622, 571, 0, 0, 1, 1, 5149.07763671875, 4673.03759765625, -126.673080444335937, 1.989672422409057617, 0, 0, 0.838669776916503906, 0.544640243053436279, 120, 255, 1, "", 45942, NULL), +(59681, 190622, 571, 0, 0, 1, 1, 5306.31640625, 4679.0927734375, -120.100379943847656, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 120, 255, 1, "", 45854, NULL), +(59682, 190622, 571, 0, 0, 1, 1, 5219.14794921875, 4687.21826171875, -126.521469116210937, 0.872663915157318115, 0, 0, 0.422617912292480468, 0.906307935714721679, 120, 255, 1, "", 45942, NULL), +(59683, 190622, 571, 0, 0, 1, 1, 5395.48291015625, 4610.205078125, -124.6485595703125, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, "", 45854, NULL), +(59684, 190622, 571, 0, 0, 1, 1, 5109.66650390625, 4834.08935546875, -124.72216796875, 4.380776405334472656, 0, 0, -0.81411552429199218, 0.580702960491180419, 120, 255, 1, "", 45942, NULL), +(59685, 190622, 571, 0, 0, 1, 1, 5521.69140625, 4615.71728515625, -130.610321044921875, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, "", 45854, NULL), +(59686, 190622, 571, 0, 0, 1, 1, 5136.04248046875, 4709.27587890625, -131.320388793945312, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 120, 255, 1, "", 45942, NULL), +(59687, 190622, 571, 0, 0, 1, 1, 5642.3212890625, 4714.00244140625, -127.601486206054687, 2.024578809738159179, 0, 0, 0.848047256469726562, 0.529920578002929687, 120, 255, 1, "", 45942, NULL), +(59688, 190622, 571, 0, 0, 1, 1, 5282.47412109375, 4975.71533203125, -126.121009826660156, 0.122172988951206207, 0, 0, 0.061048507690429687, 0.998134791851043701, 120, 255, 1, "", 45854, NULL), +(59689, 190622, 571, 0, 0, 1, 1, 5178.98193359375, 4899.48974609375, -122.379692077636718, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, "", 45942, NULL), +(59690, 190622, 571, 0, 0, 1, 1, 5211.4765625, 5013.88134765625, -128.495254516601562, 4.415683269500732421, 0, 0, -0.80385684967041015, 0.594822824001312255, 120, 255, 1, "", 45854, NULL), +(59691, 190622, 571, 0, 0, 1, 1, 5352.49560546875, 5064.845703125, -130.039840698242187, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 120, 255, 1, "", 47720, NULL), +(59692, 190622, 571, 0, 0, 1, 1, 5830.8671875, 4549.435546875, -120.839736938476562, 0.750490784645080566, 0, 0, 0.3665008544921875, 0.93041771650314331, 120, 255, 1, "", 45942, NULL), +(59693, 190622, 571, 0, 0, 1, 1, 5854.70458984375, 4788.34619140625, -127.529281616210937, 0.331610709428787231, 0, 0, 0.16504669189453125, 0.986285746097564697, 120, 255, 1, "", 45942, NULL), +(59694, 190622, 571, 0, 0, 1, 1, 5747.27587890625, 4497.44873046875, -124.290687561035156, 3.24634718894958496, 0, 0, -0.99862861633300781, 0.052353221923112869, 120, 255, 1, "", 45942, NULL), +(59695, 190622, 571, 0, 0, 1, 1, 5586.0556640625, 5215.5361328125, -126.595489501953125, 2.303830623626708984, 0, 0, 0.913544654846191406, 0.406738430261611938, 120, 255, 1, "", 45854, NULL), +(59696, 190622, 571, 0, 0, 1, 1, 5618.62158203125, 5052.03271484375, -120.335853576660156, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 120, 255, 1, "", 45942, NULL), +(59697, 190622, 571, 0, 0, 1, 1, 5147.85400390625, 5116.40185546875, -121.840362548828125, 6.108653545379638671, 0, 0, -0.08715534210205078, 0.996194720268249511, 120, 255, 1, "", 45854, NULL), +(59698, 190622, 571, 0, 0, 1, 1, 5654.27099609375, 5186.08935546875, -125.806991577148437, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 120, 255, 1, "", 45942, NULL), +(59699, 190622, 571, 0, 0, 1, 1, 5672.38720703125, 5211.49462890625, -122.175430297851562, 5.70722818374633789, 0, 0, -0.28401470184326171, 0.958819925785064697, 120, 255, 1, "", 45942, NULL), +(59700, 190622, 571, 0, 0, 1, 1, 5617.25732421875, 4907.94970703125, -125.945823669433593, 1.274088263511657714, 0, 0, 0.594821929931640625, 0.80385744571685791, 120, 255, 1, "", 45854, NULL), +(59701, 190622, 571, 0, 0, 1, 1, 5692.05126953125, 5114.4130859375, -128.620452880859375, 0.855210542678833007, 0, 0, 0.414692878723144531, 0.909961462020874023, 120, 255, 1, "", 45942, NULL), +(59702, 190622, 571, 0, 0, 1, 1, 5513.50537109375, 5523.17041015625, -95.3385086059570312, 5.829400539398193359, 0, 0, -0.22495079040527343, 0.974370121955871582, 120, 255, 1, "", 45942, NULL); + +-- new spawns +DELETE FROM `gameobject` WHERE (`id` IN (190622)) AND (`guid` IN (992, 993, 994, 995, 996, 997, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1006)); +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`, `Comment`) VALUES +(992, 190622, 571, 0, 0, 1, 1, 5367.56494140625, 5237.18017578125, -124.279983520507812, 0.959929943084716796, 0, 0, 0.461748123168945312, 0.887011110782623291, 120, 255, 1, "", 45854, NULL), +(993, 190622, 571, 0, 0, 1, 1, 5372.37451171875, 5362.42431640625, -130.01617431640625, 4.625123500823974609, 0, 0, -0.73727703094482421, 0.67559051513671875, 120, 255, 1, "", 45854, NULL), +(994, 190622, 571, 0, 0, 1, 1, 5389.837890625, 5120.15185546875, -127.117263793945312, 1.378809213638305664, 0, 0, 0.636077880859375, 0.771624863147735595, 120, 255, 1, "", 45942, NULL), +(995, 190622, 571, 0, 0, 1, 1, 5449.1953125, 5028.7431640625, -123.504936218261718, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, "", 45854, NULL), +(996, 190622, 571, 0, 0, 1, 1, 5472.548828125, 5298.6650390625, -124.564048767089843, 5.70722818374633789, 0, 0, -0.28401470184326171, 0.958819925785064697, 120, 255, 1, "", 45942, NULL), +(997, 190622, 571, 0, 0, 1, 1, 5505.2041015625, 5252.21337890625, -128.444000244140625, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 120, 255, 1, "", 45942, NULL), +(998, 190622, 571, 0, 0, 1, 1, 5510.4462890625, 5297.79052734375, -125.904327392578125, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, "", 45942, NULL), +(999, 190622, 571, 0, 0, 1, 1, 5632.1142578125, 4850.64794921875, -127.796516418457031, 3.368495941162109375, 0, 0, -0.99357128143310546, 0.113208353519439697, 120, 255, 1, "", 45854, NULL), +(1000, 190622, 571, 0, 0, 1, 1, 5696.837890625, 4919.0673828125, -129.01116943359375, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, "", 45942, NULL), +(1001, 190622, 571, 0, 0, 1, 1, 5748.6962890625, 4765.53271484375, -129.992263793945312, 4.537858963012695312, 0, 0, -0.76604366302490234, 0.642788589000701904, 120, 255, 1, "", 45942, NULL), +(1002, 190622, 571, 0, 0, 1, 1, 5771.84619140625, 4973.22509765625, -116.202163696289062, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 120, 255, 1, "", 45942, NULL), +(1003, 190622, 571, 0, 0, 1, 1, 5785.93701171875, 4705.3828125, -119.822021484375, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, "", 45942, NULL), +(1004, 190622, 571, 0, 0, 1, 1, 5786.0068359375, 4894.37255859375, -125.157676696777343, 5.323255538940429687, 0, 0, -0.46174812316894531, 0.887011110782623291, 120, 255, 1, "", 45942, NULL), +(1005, 190622, 571, 0, 0, 1, 1, 5786.03369140625, 5150.28125, -128.006103515625, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, "", 45942, NULL), +(1006, 190622, 571, 0, 0, 1, 1, 5795.01953125, 5085.044921875, -127.69378662109375, 5.427974700927734375, 0, 0, -0.41469287872314453, 0.909961462020874023, 120, 255, 1, "", 45942, NULL); diff --git a/data/sql/updates/pending_db_world/rev_1758049497884332500.sql b/data/sql/updates/pending_db_world/rev_1758049497884332500.sql deleted file mode 100644 index 3215025e60..0000000000 --- a/data/sql/updates/pending_db_world/rev_1758049497884332500.sql +++ /dev/null @@ -1,47 +0,0 @@ --- Update gameobject 'Sturdy Vine' with sniffed values --- updated spawns -DELETE FROM `gameobject` WHERE (`id` IN (190622)) AND (`guid` IN (59679, 59680, 59681, 59682, 59683, 59684, 59685, 59686, 59687, 59688, 59689, 59690, 59691, 59692, 59693, 59694, 59695, 59696, 59697, 59698, 59699, 59700, 59701, 59702)); -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`, `Comment`) VALUES -(59679, 190622, 571, 0, 0, 1, 1, 5673.72216796875, 4650.47802734375, -125.527442932128906, 5.183629035949707031, 0, 0, -0.52249813079833984, 0.852640450000762939, 120, 255, 1, "", 45942, NULL), -(59680, 190622, 571, 0, 0, 1, 1, 5149.07763671875, 4673.03759765625, -126.673080444335937, 1.989672422409057617, 0, 0, 0.838669776916503906, 0.544640243053436279, 120, 255, 1, "", 45942, NULL), -(59681, 190622, 571, 0, 0, 1, 1, 5306.31640625, 4679.0927734375, -120.100379943847656, 2.70525527000427246, 0, 0, 0.97629547119140625, 0.216442063450813293, 120, 255, 1, "", 45854, NULL), -(59682, 190622, 571, 0, 0, 1, 1, 5219.14794921875, 4687.21826171875, -126.521469116210937, 0.872663915157318115, 0, 0, 0.422617912292480468, 0.906307935714721679, 120, 255, 1, "", 45942, NULL), -(59683, 190622, 571, 0, 0, 1, 1, 5395.48291015625, 4610.205078125, -124.6485595703125, 6.265733242034912109, 0, 0, -0.00872611999511718, 0.999961912631988525, 120, 255, 1, "", 45854, NULL), -(59684, 190622, 571, 0, 0, 1, 1, 5109.66650390625, 4834.08935546875, -124.72216796875, 4.380776405334472656, 0, 0, -0.81411552429199218, 0.580702960491180419, 120, 255, 1, "", 45942, NULL), -(59685, 190622, 571, 0, 0, 1, 1, 5521.69140625, 4615.71728515625, -130.610321044921875, 5.35816192626953125, 0, 0, -0.446197509765625, 0.894934535026550292, 120, 255, 1, "", 45854, NULL), -(59686, 190622, 571, 0, 0, 1, 1, 5136.04248046875, 4709.27587890625, -131.320388793945312, 5.497788906097412109, 0, 0, -0.38268280029296875, 0.923879802227020263, 120, 255, 1, "", 45942, NULL), -(59687, 190622, 571, 0, 0, 1, 1, 5642.3212890625, 4714.00244140625, -127.601486206054687, 2.024578809738159179, 0, 0, 0.848047256469726562, 0.529920578002929687, 120, 255, 1, "", 45942, NULL), -(59688, 190622, 571, 0, 0, 1, 1, 5282.47412109375, 4975.71533203125, -126.121009826660156, 0.122172988951206207, 0, 0, 0.061048507690429687, 0.998134791851043701, 120, 255, 1, "", 45854, NULL), -(59689, 190622, 571, 0, 0, 1, 1, 5178.98193359375, 4899.48974609375, -122.379692077636718, 5.393068790435791015, 0, 0, -0.43051052093505859, 0.902585566043853759, 120, 255, 1, "", 45942, NULL), -(59690, 190622, 571, 0, 0, 1, 1, 5211.4765625, 5013.88134765625, -128.495254516601562, 4.415683269500732421, 0, 0, -0.80385684967041015, 0.594822824001312255, 120, 255, 1, "", 45854, NULL), -(59691, 190622, 571, 0, 0, 1, 1, 5352.49560546875, 5064.845703125, -130.039840698242187, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 120, 255, 1, "", 47720, NULL), -(59692, 190622, 571, 0, 0, 1, 1, 5830.8671875, 4549.435546875, -120.839736938476562, 0.750490784645080566, 0, 0, 0.3665008544921875, 0.93041771650314331, 120, 255, 1, "", 45942, NULL), -(59693, 190622, 571, 0, 0, 1, 1, 5854.70458984375, 4788.34619140625, -127.529281616210937, 0.331610709428787231, 0, 0, 0.16504669189453125, 0.986285746097564697, 120, 255, 1, "", 45942, NULL), -(59694, 190622, 571, 0, 0, 1, 1, 5747.27587890625, 4497.44873046875, -124.290687561035156, 3.24634718894958496, 0, 0, -0.99862861633300781, 0.052353221923112869, 120, 255, 1, "", 45942, NULL), -(59695, 190622, 571, 0, 0, 1, 1, 5586.0556640625, 5215.5361328125, -126.595489501953125, 2.303830623626708984, 0, 0, 0.913544654846191406, 0.406738430261611938, 120, 255, 1, "", 45854, NULL), -(59696, 190622, 571, 0, 0, 1, 1, 5618.62158203125, 5052.03271484375, -120.335853576660156, 1.169368624687194824, 0, 0, 0.551936149597167968, 0.833886384963989257, 120, 255, 1, "", 45942, NULL), -(59697, 190622, 571, 0, 0, 1, 1, 5147.85400390625, 5116.40185546875, -121.840362548828125, 6.108653545379638671, 0, 0, -0.08715534210205078, 0.996194720268249511, 120, 255, 1, "", 45854, NULL), -(59698, 190622, 571, 0, 0, 1, 1, 5654.27099609375, 5186.08935546875, -125.806991577148437, 4.939284324645996093, 0, 0, -0.6225137710571289, 0.78260880708694458, 120, 255, 1, "", 45942, NULL), -(59699, 190622, 571, 0, 0, 1, 1, 5672.38720703125, 5211.49462890625, -122.175430297851562, 5.70722818374633789, 0, 0, -0.28401470184326171, 0.958819925785064697, 120, 255, 1, "", 45942, NULL), -(59700, 190622, 571, 0, 0, 1, 1, 5617.25732421875, 4907.94970703125, -125.945823669433593, 1.274088263511657714, 0, 0, 0.594821929931640625, 0.80385744571685791, 120, 255, 1, "", 45854, NULL), -(59701, 190622, 571, 0, 0, 1, 1, 5692.05126953125, 5114.4130859375, -128.620452880859375, 0.855210542678833007, 0, 0, 0.414692878723144531, 0.909961462020874023, 120, 255, 1, "", 45942, NULL), -(59702, 190622, 571, 0, 0, 1, 1, 5513.50537109375, 5523.17041015625, -95.3385086059570312, 5.829400539398193359, 0, 0, -0.22495079040527343, 0.974370121955871582, 120, 255, 1, "", 45942, NULL); - --- new spawns -DELETE FROM `gameobject` WHERE (`id` IN (190622)) AND (`guid` IN (992, 993, 994, 995, 996, 997, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1006)); -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`, `Comment`) VALUES -(992, 190622, 571, 0, 0, 1, 1, 5367.56494140625, 5237.18017578125, -124.279983520507812, 0.959929943084716796, 0, 0, 0.461748123168945312, 0.887011110782623291, 120, 255, 1, "", 45854, NULL), -(993, 190622, 571, 0, 0, 1, 1, 5372.37451171875, 5362.42431640625, -130.01617431640625, 4.625123500823974609, 0, 0, -0.73727703094482421, 0.67559051513671875, 120, 255, 1, "", 45854, NULL), -(994, 190622, 571, 0, 0, 1, 1, 5389.837890625, 5120.15185546875, -127.117263793945312, 1.378809213638305664, 0, 0, 0.636077880859375, 0.771624863147735595, 120, 255, 1, "", 45942, NULL), -(995, 190622, 571, 0, 0, 1, 1, 5449.1953125, 5028.7431640625, -123.504936218261718, 1.780233979225158691, 0, 0, 0.7771453857421875, 0.629321098327636718, 120, 255, 1, "", 45854, NULL), -(996, 190622, 571, 0, 0, 1, 1, 5472.548828125, 5298.6650390625, -124.564048767089843, 5.70722818374633789, 0, 0, -0.28401470184326171, 0.958819925785064697, 120, 255, 1, "", 45942, NULL), -(997, 190622, 571, 0, 0, 1, 1, 5505.2041015625, 5252.21337890625, -128.444000244140625, 2.809975385665893554, 0, 0, 0.986285209655761718, 0.165049895644187927, 120, 255, 1, "", 45942, NULL), -(998, 190622, 571, 0, 0, 1, 1, 5510.4462890625, 5297.79052734375, -125.904327392578125, 4.799657344818115234, 0, 0, -0.67558956146240234, 0.737277925014495849, 120, 255, 1, "", 45942, NULL), -(999, 190622, 571, 0, 0, 1, 1, 5632.1142578125, 4850.64794921875, -127.796516418457031, 3.368495941162109375, 0, 0, -0.99357128143310546, 0.113208353519439697, 120, 255, 1, "", 45854, NULL), -(1000, 190622, 571, 0, 0, 1, 1, 5696.837890625, 4919.0673828125, -129.01116943359375, 4.886923789978027343, 0, 0, -0.64278697967529296, 0.766044974327087402, 120, 255, 1, "", 45942, NULL), -(1001, 190622, 571, 0, 0, 1, 1, 5748.6962890625, 4765.53271484375, -129.992263793945312, 4.537858963012695312, 0, 0, -0.76604366302490234, 0.642788589000701904, 120, 255, 1, "", 45942, NULL), -(1002, 190622, 571, 0, 0, 1, 1, 5771.84619140625, 4973.22509765625, -116.202163696289062, 5.131268978118896484, 0, 0, -0.54463863372802734, 0.838670849800109863, 120, 255, 1, "", 45942, NULL), -(1003, 190622, 571, 0, 0, 1, 1, 5785.93701171875, 4705.3828125, -119.822021484375, 1.518436193466186523, 0, 0, 0.6883544921875, 0.725374460220336914, 120, 255, 1, "", 45942, NULL), -(1004, 190622, 571, 0, 0, 1, 1, 5786.0068359375, 4894.37255859375, -125.157676696777343, 5.323255538940429687, 0, 0, -0.46174812316894531, 0.887011110782623291, 120, 255, 1, "", 45942, NULL), -(1005, 190622, 571, 0, 0, 1, 1, 5786.03369140625, 5150.28125, -128.006103515625, 3.089183330535888671, 0, 0, 0.99965667724609375, 0.026201646775007247, 120, 255, 1, "", 45942, NULL), -(1006, 190622, 571, 0, 0, 1, 1, 5795.01953125, 5085.044921875, -127.69378662109375, 5.427974700927734375, 0, 0, -0.41469287872314453, 0.909961462020874023, 120, 255, 1, "", 45942, NULL); -- cgit v1.2.3