diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2020_07_30_00_world.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_07_30_00_world.sql b/sql/updates/world/3.3.5/2020_07_30_00_world.sql new file mode 100644 index 00000000000..6a1fba7f401 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_07_30_00_world.sql @@ -0,0 +1,10 @@ +-- Creature Rhahk'Zor 644 SAI +DELETE FROM `smart_scripts` WHERE `entryorguid` = 644 AND `source_type` = 0 AND `id` = 2; + +-- Change door entries to correct ones +UPDATE `gameobject` SET `id` = 16400 WHERE `guid` = 26185 AND `id` = 17153; +UPDATE `gameobject` SET `id` = 16399 WHERE `guid` = 26182 AND `id` = 17153; + +-- Update Door Lever's interaction SAI to the new doors +UPDATE `smart_scripts` SET `target_type` = 20, `target_param1` = 16400, `target_param2` = 30 WHERE `entryorguid` = 101832 AND `source_type` = 1 AND `id` = 0; +UPDATE `smart_scripts` SET `target_type` = 20, `target_param1` = 16399, `target_param2` = 30 WHERE `entryorguid` = 101834 AND `source_type` = 1 AND `id` = 0; |