EPIC: List of all missing features and relevant optimizations

[Grimdhex]

Describe your feature request or suggestion in detail

I'm proposing this topic so that we can keep track of notable improvements in AC outside the fix of current issues. In particular, I'd like to list a number of existing issues and evaluate the most relevant ones.

In particular, I propose two categories: missing features and major refactoring/optimization.

Missing features:

Gameplay

• Sparring system
• Period grace
• Feature: Dynamic Creature/Go spawning #4355
• Tug of War
• A proper system for GCD with MindControls (No implementation for dynamic charmed spell cooldowns. #19187 / Game breaking Mind Control/Charm bugs #11975)
• Feature: BreadcrumbQuest support in core #9386

Events

• (Events): Zombie Infestation unimplemented. #16256
• [EVENT] Operation Gnomeregan (Completely Missing) #1688

Framework/Core

• Creature static flags
• Several spells attributes
• Creature secondary stats (Not all creatures make use of base stats. #19238)
• Core: Unimplemented SummonProperties flags #12641
• Core/Creature: Several FactionTemplateFlags not implemented #7786
• Cyclic paths

Features:

• Feature: Dynamic script hotswapping #4302
• Feature: RBAC #5704
• Feature: CROSS REALMS #11073
• Feature: clustering #11072
• Feature: Server queue #8767
• Feature: Allow localized Autobroadcast #17912
• Feature: Implement missing arena progression throughout seasons #18761

Refactoring & Optimization:

Gameplay

• Move several current system into heartbeat
• Improve movement system (Feature: SmoothMovement, Waypoints, RandomMovement #10096 for example)
• Improve pathfinding (Creatures do not path around gameobjects. #18024)
• Feature: game_event_npc_vendor cannot be reloaded #20306
• Feature: move ArenaSpectator into a module and away from the core #17683
• Rewrite combat and threat system to be mutual from TC  #5985

SAI

• Feature: SMART_ACTION to disable onkill reputation gains and loot/gold drops for source creature #16359
• Feature Request: New SMART_TARGET type to work with creature_formations table #14939

Core

• Finish to remove all hardcoded gossip
• Throttling movements
• Map ressources usages to evaluate which part need to be improved for more performance
• Prepare to cpp-23 as default support
• Use more std::chrono

DB

• Clean up World Database #16942

Dependencies

• Feature: ZLIB Upgrade #20929
• Apparently unused imports causing linking issues when removed #9766

[Exitare]

IMO, the gamemgr has some places that could benefit from a refactoring as well e.g. the LoadDB function

[fangshun2004]

Azerothcore also lacks a creature-following and respawn system like Cmangos and Vmangos. When the follower dies. Followers will randomly wander around. There are also followers who are reborn and will only appear in the respawn position

[Grimdhex]

Azerothcore also lacks a creature-following and respawn system like Cmangos and Vmangos. When the follower dies. Followers will randomly wander around. There are also followers who are reborn and will only appear in the respawn position

Could you detail the feature of respawn system ? Maybe a like of few commit from mangos ?

[fangshun2004]

Here's the introduction
#8313
#14274