diff options
| author | Somebody <walliewhal4@gmail.com> | 2020-07-30 14:14:08 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-07-30 14:14:08 +0200 |
| commit | 81f3ed1d0c6ecba624b4a88a4c60c0dfa1cd9524 (patch) | |
| tree | 83d63d75e5cb285a56b1443742814c0b7be68144 /sql/updates/world | |
| parent | 420b21be9860367c82537634fb792a4af3d9be9b (diff) | |
Scripts/Deadmines: Doors after Rhahk'Zor, Sneed and Gilnid (#25107)
* Fix doors opening after killing Sneed and Gilnid in the Deadmines dungeon
* Add SQL file
* Update 2020_99_99_00_world.sql
SQL conventions
* Change SAI door opening into C++ door opening and make it use SetBossState.
* Delete 2020_99_99_00_world.sql
Replaced by different sql file
* Make CircleCI happy
* Change const to constexpr for EncounterCount variable
* Update src/server/scripts/EasternKingdoms/Deadmines/deadmines.h
Co-authored-by: Peter Keresztes Schmidt <carbenium@outlook.com>
* Update src/server/scripts/EasternKingdoms/Deadmines/deadmines.h
Co-authored-by: Peter Keresztes Schmidt <carbenium@outlook.com>
* Rename 9999_99_99_00_world.sql to 2020_07_30_00_world.sql
Co-authored-by: Peter Keresztes Schmidt <carbenium@outlook.com>
Co-authored-by: Giacomo Pozzoni <giacomopoz@gmail.com>
Diffstat (limited to 'sql/updates/world')
| -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; |