From 81730cf4b87f0fbac8088c6aa047af23aefe21a7 Mon Sep 17 00:00:00 2001 From: offl Date: Tue, 22 Jun 2021 20:57:51 +0300 Subject: 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) --- sql/updates/world/master/2022_03_11_06_world_2021_06_22_05_world.sql | 2 ++ 1 file changed, 2 insertions(+) create mode 100644 sql/updates/world/master/2022_03_11_06_world_2021_06_22_05_world.sql (limited to 'sql') 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; -- cgit v1.2.3