Files
AscEmu/sql/world/updates/20220116-02_creature_properties.sql
aaron02 1e7e13766d Vehicle Handling (#987)
* vehicle handling

* Spells: Handle custom base points correctly

* fix Vehicle and Movement
fix Vehicle Position Updates, Fix Vehicles make no Damage

* Units: Add functions to handle unit spell immunity

* fix a crash on respawn
vehicles shouldnt chase

* fix cata vehicles
Fix Not able to switch seats from Acessory to Base
crashfixes and codestyle

* Auras: Aura effects should be properly updated on aura refresh

* review from appled

* review from appled

Co-authored-by: Appled <346848+Appled@users.noreply.github.com>
2022-01-27 07:45:28 +01:00

8 lines
523 B
SQL

-- Merge two similiar mod immunities in modImmunities column
-- Add missing 1024 to creatures that had 8192 but not 1024 (only 2 rows affected)
UPDATE creature_properties SET modImmunities=(modImmunities | 1024) WHERE modImmunities & 8192 AND NOT modImmunities & 1024;
-- Remove 8192 from creatures that had it set
UPDATE creature_properties SET modImmunities=(modImmunities & ~8192) WHERE modImmunities & 8192;
INSERT INTO `world_db_version` (`id`, `LastUpdate`) VALUES ('101', '20220116-02_creature_properties');