diff options
| author | offl <offl@users.noreply.github.com> | 2021-02-10 18:16:17 +0200 |
|---|---|---|
| committer | offl <offl@users.noreply.github.com> | 2021-02-10 18:16:17 +0200 |
| commit | c00b0551345245c2a91db2e1b62a13fa969c218e (patch) | |
| tree | 60a8bc103ccc72dad6a4b40dd6674006591250f3 /sql | |
| parent | 33ca9feb19fcee792f590fc2cb4cd4b81c6a835b (diff) | |
DB/SAI: Remove SMART_EVENT_FLAG_WHILE_CHARMED
Guardians are not charmed. Vehicle requires that flag only if player controls vehicle. It has absolutely no impact to creatures which are mind-controlable \ enslave-able. Their default AI is blocked during mind-control \ enslave as intended and you definitely don't want to make them cast spells from their SAI or execute any other action if they are mind-controlled or enslaved.
Ref #26065
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2021_02_10_03_world_335.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_02_10_03_world_335.sql b/sql/updates/world/3.3.5/2021_02_10_03_world_335.sql new file mode 100644 index 00000000000..8e4ee2106c5 --- /dev/null +++ b/sql/updates/world/3.3.5/2021_02_10_03_world_335.sql @@ -0,0 +1,3 @@ +-- Skip all with SmartAI and CREATURE_DIFFICULTYFLAGS_2_UNK9 which is used by controlled creatures and vehicles +-- Skip all with SmartAI and VehicleId +UPDATE `smart_scripts` SET `event_flags` = `event_flags` &~ 512 WHERE `entryorguid` NOT IN (17606,21284,21804,22849,23468,24156,24752,24806,24821,24823,24825,24852,24922,25040,25460,25596,25743,25765,25801,25881,25968,26401,26472,26520,27131,27213,27270,27292,27409,27587,27605,27626,27761,27839,27886,27923,27924,27932,27939,27996,28009,28018,28115,28116,28120,28121,28122,28182,28192,28214,28215,28216,28308,28379,28399,28468,28605,28639,28665,28667,28668,28669,28710,28750,28802,28805,28817,28851,28864,28875,28931,29043,29144,29351,29358,29500,29579,29677,29679,29698,29732,29838,29863,29884,29903,29931,30066,30108,30124,30134,30159,30174,30204,30330,30331,30383,30393,30403,30420,30461,30468,30477,30487,30564,30698,30894,30895,31050,31110,31139,31157,31262,31268,31432,31641,31702,31881,31884,32189,32225,32227,32292,32682,32818,33519,33687,34146,34150,34151,34183,34320,35299,35373,35474,36812,36896,37120,37670,37827,37952,37966,37980) AND `source_type` = 0; |