Midsummer fixes & gameplay improvements

Fixes and improvements applied:

• [Scripts/Midsummer] prevent Bonfire's Blessing from harming the caster (#26322)
• [Core/Player] correct socket checks for prismatic belt socket (#26122)
• [Core/Item] Implement ITEM_FLAG2_EVERYONE_CAN_ROLL_NEED (#26240)
• [DB] import pending files
• [DB/Script] Rework "Where in the World is Hemet Nesingwary" quest event. (#26305)
• [Core/Unit] Re-sync movement speed to target's client after possess/charm ends (#26304)
• [Scripts/SlavePens] spawn Ahune loot chest when killed during submerge (#26298)

Update applied: 2026-06-24 09:32