diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2025_09_27_04_world.sql | 46 |
1 files changed, 46 insertions, 0 deletions
diff --git a/sql/updates/world/master/2025_09_27_04_world.sql b/sql/updates/world/master/2025_09_27_04_world.sql new file mode 100644 index 00000000000..74e3b39581d --- /dev/null +++ b/sql/updates/world/master/2025_09_27_04_world.sql @@ -0,0 +1,46 @@ +-- Update Harvest Watcher to createobject2 spawn positions +UPDATE `creature` SET `position_x` = -10184.28515625, `position_y` = 1115.9010009765625, `position_z` = 36.79700469970703125, `orientation` = 2.22785496711730957 WHERE `guid` = 275542; +UPDATE `creature` SET `position_x` = -10117.845703125, `position_y` = 1116.3125, `position_z` = 36.56398773193359375, `orientation` = 5.564764976501464843 WHERE `guid` = 275652; +UPDATE `creature` SET `position_x` = -10230.2470703125, `position_y` = 1157.6197509765625, `position_z` = 34.19196319580078125, `orientation` = 4.581770896911621093 WHERE `guid` = 275483; +UPDATE `creature` SET `position_x` = -10097.6982421875, `position_y` = 1212.513916015625, `position_z` = 35.22818756103515625, `orientation` = 3.60982680320739746 WHERE `guid` = 275666; +UPDATE `creature` SET `position_x` = -10217.0869140625, `position_y` = 1117.2535400390625, `position_z` = 36.389984130859375, `orientation` = 2.842301368713378906 WHERE `guid` = 275523; +UPDATE `creature` SET `position_x` = -10150.5107421875, `position_y` = 1116.4774169921875, `position_z` = 36.83774566650390625, `orientation` = 3.846194744110107421 WHERE `guid` = 275612; +UPDATE `creature` SET `position_x` = -10207.228515625, `position_y` = 1194.532958984375, `position_z` = 38.49316024780273437, `orientation` = 5.1524658203125 WHERE `guid` = 275520; +UPDATE `creature` SET `position_x` = -10152.4384765625, `position_y` = 1180.65625, `position_z` = 36.54000473022460937, `orientation` = 2.690482854843139648 WHERE `guid` = 275547; +UPDATE `creature` SET `position_x` = -10119.673828125, `position_y` = 1149.5850830078125, `position_z` = 36.9478607177734375, `orientation` = 1.209070682525634765 WHERE `guid` = 275661; +UPDATE `creature` SET `position_x` = -10183.9111328125, `position_y` = 1149.76220703125, `position_z` = 37.0020904541015625, `orientation` = 5.056718349456787109 WHERE `guid` = 275543; +UPDATE `creature` SET `position_x` = -10151.982421875, `position_y` = 1149.8992919921875, `position_z` = 37.6571807861328125, `orientation` = 37.6571807861328125 WHERE `guid` = 275548; +UPDATE `creature` SET `position_x` = -10173.5537109375, `position_y` = 1215.0521240234375, `position_z` = 36.05878448486328125, `orientation` = 5.96508646011352539 WHERE `guid` = 275546; +UPDATE `creature` SET `position_x` = -10239.2744140625, `position_y` = 1044.517333984375, `position_z` = 38.18732452392578125, `orientation` = 0.311268746852874755 WHERE `guid` = 275487; +UPDATE `creature` SET `position_x` = -10243.251953125, `position_y` = 1019.3350830078125, `position_z` = 35.29669952392578125, `orientation` = 1.283633947372436523 WHERE `guid` = 275490; +UPDATE `creature` SET `position_x` = -10238.7255859375, `position_y` = 1072.4427490234375, `position_z` = 39.16173171997070312, `orientation` = 4.230996608734130859 WHERE `guid` = 275486; +UPDATE `creature` SET `position_x` = -10261.6298828125, `position_y` = 1120.7916259765625, `position_z` = 39.38301467895507812, `orientation` = 2.619409799575805664 WHERE `guid` = 275484; +UPDATE `creature` SET `position_x` = -10217.201171875, `position_y` = 1041.170166015625, `position_z` = 36.28409576416015625, `orientation` = 3.263765573501586914 WHERE `guid` = 275526; +UPDATE `creature` SET `position_x` = -10192.701171875, `position_y` = 1015.96881103515625, `position_z` = 38.24028396606445312, `orientation` = 3.324448823928833007 WHERE `guid` = 275539; +UPDATE `creature` SET `position_x` = -10265.6630859375, `position_y` = 1084.4722900390625, `position_z` = 43.16688156127929687, `orientation` = 5.962688446044921875 WHERE `guid` = 275485; +UPDATE `creature` SET `position_x` = -10183.845703125, `position_y` = 1082.8941650390625, `position_z` = 36.62339401245117187, `orientation` = 1.816587090492248535 WHERE `guid` = 275541; + +-- Update Coyote to createobject2 spawn positions +UPDATE `creature` SET `position_x` = -10062.482421875, `position_y` = 1125.8975830078125, `position_z` = 38.69878387451171875, `orientation` = 2.868776798248291015 WHERE `guid` = 275651; +UPDATE `creature` SET `position_x` = -10084.2470703125, `position_y` = 1083.326416015625, `position_z` = 40.14482498168945312, `orientation` = 3.629468917846679687 WHERE `guid` = 275664; +UPDATE `creature` SET `position_x` = -10049.9755859375, `position_y` = 1050.99658203125, `position_z` = 36.3185272216796875, `orientation` = 0.920692801475524902 WHERE `guid` = 275657; + +-- Update Goretusk to createobject2 spawn positions +UPDATE `creature` SET `position_x` = -10018.2158203125, `position_y` = 1016.53131103515625, `position_z` = 36.69594192504882812, `orientation` = 4.067343711853027343 WHERE `guid` = 275703; +UPDATE `creature` SET `position_x` = -10092.1357421875, `position_y` = 1023.83331298828125, `position_z` = 38.40985488891601562, `orientation` = 5.558290481567382812 WHERE `guid` = 275649; +UPDATE `creature` SET `position_x` = -10037.5537109375, `position_y` = 1071.7396240234375, `position_z` = 38.358978271484375, `orientation` = 1.56054091453552246 WHERE `guid` = 275687; +UPDATE `creature` SET `position_x` = -10046.0244140625, `position_y` = 1095.5242919921875, `position_z` = 39.706146240234375, `orientation` = 5.580653667449951171 WHERE `guid` = 275663; +UPDATE `creature` SET `position_x` = -10056.31640625, `position_y` = 1035.7117919921875, `position_z` = 36.09445953369140625, `orientation` = 0 WHERE `guid` = 275659; +UPDATE `creature` SET `position_x` = -10057.6923828125, `position_y` = 1076.5035400390625, `position_z` = 38.19611740112304687, `orientation` = 0 WHERE `guid` = 275653; +UPDATE `creature` SET `position_x` = -10064.4462890625, `position_y` = 1095.654541015625, `position_z` = 39.39255142211914062, `orientation` = 0 WHERE `guid` = 275662; +UPDATE `creature` SET `position_x` = -10140.2255859375, `position_y` = 1031.6458740234375, `position_z` = 38.71607208251953125, `orientation` = 0 WHERE `guid` = 275616; +UPDATE `creature` SET `position_x` = -10125.6884765625, `position_y` = 1014.036376953125, `position_z` = 41.25223541259765625, `orientation` = 0 WHERE `guid` = 275631; + +-- Update random movement +UPDATE `creature` SET `wander_distance` = 8, `MovementType` = 1 WHERE `guid` IN (275542,275652,275483,275666,275523,275612,275520,275547,275661,275543,275548,275546,275487,275490,275486,275484,275526,275539,275485,275541); +UPDATE `creature` SET `wander_distance` = 6, `MovementType` = 1 WHERE `guid` IN (275651,275664,275657); +UPDATE `creature` SET `wander_distance` = 4, `MovementType` = 1 WHERE `guid` IN (275703,275649,275687,275663,275659,275653,275662,275616,275631); + +-- Delete duplicate spawns +DELETE FROM `creature` WHERE `guid` = 275525; +DELETE FROM `creature_addon` WHERE `guid` = 275525; |