aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoroffl <offl@users.noreply.github.com>2021-06-22 20:57:51 +0300
committerShauren <shauren.trinity@gmail.com>2022-03-11 12:37:06 +0100
commit81730cf4b87f0fbac8088c6aa047af23aefe21a7 (patch)
tree55816a03d3ee2b37d4d01352a84c3bf6c1e1db02
parent7de51d5ebc4a7732196e9677114b7103bc5112ae (diff)
DB/SAI: Remove wrongly used SmartActionSummonCreatureFlags
Closes #26595 After ee839fe action_param5 is used as SmartActionSummonCreatureFlags and 1 is PersonalSpawn. And somehow currently action_param5 = 1 is used in 40 actions even if that param wasn't used by core before ee839fe. Because of that those summoned creatures became personal spawns of creatures or objects and were not visible to player as they're supposed to be (cherry picked from commit 338abd531556822d17924025f6d460a3fd9899a2)
-rw-r--r--sql/updates/world/master/2022_03_11_06_world_2021_06_22_05_world.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_03_11_06_world_2021_06_22_05_world.sql b/sql/updates/world/master/2022_03_11_06_world_2021_06_22_05_world.sql
new file mode 100644
index 00000000000..8b87bc38f81
--- /dev/null
+++ b/sql/updates/world/master/2022_03_11_06_world_2021_06_22_05_world.sql
@@ -0,0 +1,2 @@
+--
+UPDATE `smart_scripts` SET `action_param5` = 0 WHERE `entryorguid` IN (27843,51708,179499,293300,2464000,3113500,3113501,3113502,3113503,3113504,3113505,17592500,17592600,17634600,17634900,17635000,17635100,17635200,17635300,18551200) AND `action_type` = 12;