diff options
| author | Killyana <morphone1@gmail.com> | 2020-03-27 01:33:19 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-12-31 00:42:50 +0100 |
| commit | 0619f95876c7921fc0eadd980d8afc80843d5ea5 (patch) | |
| tree | 231d7207447efadf1cd7883d5927c07f514775c3 | |
| parent | 9bd785f6591af4c6cf407f0f5026719646ed3cd1 (diff) | |
DB/Misc: Fix some spawns
(cherry picked from commit 8c51d5cfedd119d4e215420645645d435af44650)
| -rw-r--r-- | sql/updates/world/master/2021_12_31_03_world_2020_03_26_03_world.sql | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/sql/updates/world/master/2021_12_31_03_world_2020_03_26_03_world.sql b/sql/updates/world/master/2021_12_31_03_world_2020_03_26_03_world.sql new file mode 100644 index 00000000000..d2230370cd3 --- /dev/null +++ b/sql/updates/world/master/2021_12_31_03_world_2020_03_26_03_world.sql @@ -0,0 +1,25 @@ +-- +UPDATE `creature_text` SET `Emote`=53 WHERE `CreatureID`=28873 AND `GroupID`=0; +UPDATE `creature_template_addon` SET `auras`="52243" WHERE `entry`=28750; + +UPDATE `creature` SET `unit_flags`=768 WHERE `guid` IN (112203,112204,112205); +DELETE FROM `creature_addon` WHERE `guid` IN (112203,112204,112205); +INSERT INTO `creature_addon` (`guid`,`bytes2`,`auras`) VALUES +(112203,1,"29266"), +(112204,1,"29266"), +(112205,1,"29266"); + +DELETE FROM `creature_template_addon` WHERE `entry` IN (28221); +INSERT INTO `creature_template_addon` (`entry`,`bytes2`,`auras`) VALUES +(28221,0,"11959"); +UPDATE `creature_template` SET `AIName` ='' WHERE `entry` = 28221; +DELETE FROM `smart_scripts` WHERE `source_type`IN (0) AND `entryorguid`IN (28221); + +UPDATE `creature` SET `position_x`=6290.406738, `position_y`=-2184.720947, `position_z`=240.059875 WHERE `guid`= 112188; +UPDATE `creature` SET `position_x`=6426.743164, `position_y`=-2258.166748, `position_z`=287.108734 WHERE `guid`= 112275; +UPDATE `creature` SET `position_x`=6418.568848, `position_y`=-2272.804199, `position_z`=287.967773 WHERE `guid`= 112290; +UPDATE `creature` SET `id`=28844, `equipment_id`=1, `modelid`=0, `position_x`=6362.347168, `position_y`=-2260.4226, `position_z`=281.79498, `MovementType`=1, `wander_distance`=5 WHERE `guid`= 112183; +UPDATE `creature` SET `id`=28844, `equipment_id`=1, `modelid`=0, `position_x`=6388.844727, `position_y`=-2219.6491, `position_z`=277.93396, `MovementType`=1, `wander_distance`=5 WHERE `guid`= 102596; +UPDATE `creature` SET `id`=28844, `equipment_id`=1, `modelid`=0, `position_x`=6408.862793, `position_y`=-2282.7724, `position_z`=288.39938, `MovementType`=1, `wander_distance`=5 WHERE `guid`= 102594; +UPDATE `creature` SET `id`=28844, `equipment_id`=1, `modelid`=0, `position_x`=6420.578125, `position_y`=-2289.0166, `position_z`=291.06971, `MovementType`=1, `wander_distance`=5 WHERE `guid`= 102599; +UPDATE `creature` SET `id`=28844, `equipment_id`=1, `modelid`=0, `position_x`=6459.795411, `position_y`=-2282.3593, `position_z`=292.86065, `MovementType`=1, `wander_distance`=5 WHERE `guid`= 102597; |