diff options
| -rw-r--r-- | sql/updates/world/cata_classic/2024_10_20_01_world.sql | 47 |
1 files changed, 47 insertions, 0 deletions
diff --git a/sql/updates/world/cata_classic/2024_10_20_01_world.sql b/sql/updates/world/cata_classic/2024_10_20_01_world.sql new file mode 100644 index 00000000000..b44e18e615d --- /dev/null +++ b/sql/updates/world/cata_classic/2024_10_20_01_world.sql @@ -0,0 +1,47 @@ +-- Delete duplicate spawns +DELETE FROM `creature` WHERE `guid` IN (295462, 294765, 295822, 294777, 294773, 296012, 295449); + +-- Update position with createobject2 +UPDATE `creature` SET `position_x` = -2929.3798828125, `position_y` = -177.89599609375, `position_z` = 67.76613616943359375, `orientation` = 0.122173048555850982, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 296014; +UPDATE `creature` SET `position_x` = -2860.719970703125, `position_y` = -164.356002807617187, `position_z` = 62.96093368530273437, `orientation` = 0.122173048555850982, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295985; +UPDATE `creature` SET `position_x` = -2825.35009765625, `position_y` = -217.188003540039062, `position_z` = 61.646331787109375, `orientation` = 0.122173048555850982, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 296016; +UPDATE `creature` SET `position_x` = -2897.550048828125, `position_y` = -117.882003784179687, `position_z` = 76.10103607177734375, `orientation` = 0.122173048555850982, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295983; +UPDATE `creature` SET `position_x` = -2820.14990234375, `position_y` = -336.011993408203125, `position_z` = 59.8488311767578125, `orientation` = 3.951739072799682617, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295463; +UPDATE `creature` SET `position_x` = -2807.18994140625, `position_y` = -289.37799072265625, `position_z` = 61.82653045654296875, `orientation` = 0.122173048555850982, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295993; +UPDATE `creature` SET `position_x` = -2841.52001953125, `position_y` = -399.89801025390625, `position_z` = 57.524932861328125, `orientation` = 0.122173048555850982, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295474; +UPDATE `creature` SET `position_x` = -2887.409912109375, `position_y` = -338.365997314453125, `position_z` = 59.25973129272460937, `orientation` = 5.506447315216064453, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295994; +UPDATE `creature` SET `position_x` = -2888.080078125, `position_y` = -387.433990478515625, `position_z` = 50.03603363037109375, `orientation` = 0.623360276222229003, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295469; +UPDATE `creature` SET `position_x` = -2917.56005859375, `position_y` = -480.266998291015625, `position_z` = 44.5764312744140625, `orientation` = 4.497570514678955078, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295475; +UPDATE `creature` SET `position_x` = -2963.260009765625, `position_y` = -448.480987548828125, `position_z` = 48.7816314697265625, `orientation` = 0.122173048555850982, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295467; +UPDATE `creature` SET `position_x` = -2909.989990234375, `position_y` = -424.3280029296875, `position_z` = 48.64873123168945312, `orientation` = 0.122173048555850982, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295476; +UPDATE `creature` SET `position_x` = -2861.3798828125, `position_y` = -473.884002685546875, `position_z` = 53.62633132934570312, `orientation` = 0.122173048555850982, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295479; +UPDATE `creature` SET `position_x` = -2838.85009765625, `position_y` = -564.92901611328125, `position_z` = 56.27953338623046875, `orientation` = 0.122173048555850982, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295502; +UPDATE `creature` SET `position_x` = -2829.110107421875, `position_y` = -629.38201904296875, `position_z` = 56.12083053588867187, `orientation` = 1.256839871406555175, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295501; +UPDATE `creature` SET `position_x` = -2775.590087890625, `position_y` = -584.54302978515625, `position_z` = 57.9449310302734375, `orientation` = 0.122173048555850982, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295486; +UPDATE `creature` SET `position_x` = -2806.800048828125, `position_y` = -521.7860107421875, `position_z` = 55.45063018798828125, `orientation` = 4.066850662231445312, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295484; +UPDATE `creature` SET `position_x` = -2887.239990234375, `position_y` = -533.45697021484375, `position_z` = 49.64423370361328125, `orientation` = 0.122173048555850982, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295488; +UPDATE `creature` SET `position_x` = -3113.699951171875, `position_y` = -381.17401123046875, `position_z` = 48.315032958984375, `orientation` = 0.122173048555850982, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295434; +UPDATE `creature` SET `position_x` = -3090.280029296875, `position_y` = -480.2860107421875, `position_z` = 42.49433135986328125, `orientation` = 0.122173048555850982, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295422; +UPDATE `creature` SET `position_x` = -3064.510009765625, `position_y` = -417.27398681640625, `position_z` = 42.85673141479492187, `orientation` = 0.122173048555850982, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295438; +UPDATE `creature` SET `position_x` = -3154.070068359375, `position_y` = -438.45098876953125, `position_z` = 41.30543136596679687, `orientation` = 0.122173048555850982, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295433; +UPDATE `creature` SET `position_x` = -3168.010009765625, `position_y` = -379.279998779296875, `position_z` = 38.4850311279296875, `orientation` = 0.122173048555850982, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295427; +UPDATE `creature` SET `position_x` = -3255.489990234375, `position_y` = -277.608001708984375, `position_z` = 44.09933090209960937, `orientation` = 0.908691942691802978, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 294963; +UPDATE `creature` SET `position_x` = -3208.68994140625, `position_y` = -325.936004638671875, `position_z` = 41.0681304931640625, `orientation` = 5.695508956909179687, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295333; +UPDATE `creature` SET `position_x` = -3313.35009765625, `position_y` = -277.12200927734375, `position_z` = 54.87383270263671875, `orientation` = 4.147119998931884765, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295877; +UPDATE `creature` SET `position_x` = -3255.2900390625, `position_y` = -362.660003662109375, `position_z` = 47.02283096313476562, `orientation` = 2.326224803924560546, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 294964; +UPDATE `creature` SET `position_x` = -3184.429931640625, `position_y` = -268.907989501953125, `position_z` = 45.64393234252929687, `orientation` = 0.122173048555850982, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 294967; +UPDATE `creature` SET `position_x` = -3349.2900390625, `position_y` = -131.300003051757812, `position_z` = 75.50263214111328125, `orientation` = 0.122173048555850982, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295938; +UPDATE `creature` SET `position_x` = -3271.35009765625, `position_y` = -123.806999206542968, `position_z` = 62.22213363647460937, `orientation` = 2.656152725219726562, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295935; +UPDATE `creature` SET `position_x` = -3314.469970703125, `position_y` = -69.6614990234375, `position_z` = 86.00693511962890625, `orientation` = 0.122173048555850982, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295936; +UPDATE `creature` SET `position_x` = -3313.780029296875, `position_y` = -189.5050048828125, `position_z` = 56.93413162231445312, `orientation` = 0.122173048555850982, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295934; +UPDATE `creature` SET `position_x` = -3239.6201171875, `position_y` = -162.425003051757812, `position_z` = 42.04073333740234375, `orientation` = 0.122173048555850982, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295941; +UPDATE `creature` SET `position_x` = -3493.949951171875, `position_y` = -249.339996337890625, `position_z` = 82.32433319091796875, `orientation` = 5.926441669464111328, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295912; +UPDATE `creature` SET `position_x` = -3450.340087890625, `position_y` = -205.259994506835937, `position_z` = 70.80313873291015625, `orientation` = 0.122173048555850982, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295927; +UPDATE `creature` SET `position_x` = -3221.6298828125, `position_y` = -217.2760009765625, `position_z` = 37.70713043212890625, `orientation` = 0.122173048555850982, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295937; +UPDATE `creature` SET `position_x` = -3185, `position_y` = -117.530998229980468, `position_z` = 46.16653060913085937, `orientation` = 0.122173048555850982, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295951; +UPDATE `creature` SET `position_x` = -3157.949951171875, `position_y` = -191.113006591796875, `position_z` = 48.48423385620117187, `orientation` = 3.932753801345825195, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295953; +UPDATE `creature` SET `position_x` = -3117.64990234375, `position_y` = -247.1719970703125, `position_z` = 47.07883071899414062, `orientation` = 0.122173048555850982, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295943; +UPDATE `creature` SET `position_x` = -3070.300048828125, `position_y` = -294.62200927734375, `position_z` = 45.72793197631835937, `orientation` = 0.122173048555850982, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295440; +UPDATE `creature` SET `position_x` = -3004.929931640625, `position_y` = -295.688995361328125, `position_z` = 51.23353195190429687, `orientation` = 2.20377349853515625, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 294764; +UPDATE `creature` SET `position_x` = -3042.639892578125, `position_y` = -356.6669921875, `position_z` = 46.77643203735351562, `orientation` = 0.122173048555850982, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295444; +UPDATE `creature` SET `position_x` = -3478, `position_y` = -147.136993408203125, `position_z` = 107.1193389892578125, `orientation` = 2.342191696166992187, `wander_distance` = 10, `MovementType` = 1 WHERE `guid` = 295922; |