[XTR] Dynamic Welcome Panel 1.0.5

• Resolved a fatal entity hydration cache flaw that caused the "Undefined array key" Server Error in the Admin Panel.
• Refactored the "Latest Registered Members" structure, abandoning the manual array caching method in favor of the 100% native XenForo architecture.
• Purged all hard-coded/legacy raw SQL aggregate queries (SELECT COUNT) and migrated them to the optimized XenForo Finder/ORM method (\XF::finder()->total()).
• Integrated the XenForo Core standard indexHint('USE', 'register_date') logic for maximum query performance when retrieving new users.

This update represents a massive architectural overhaul aimed exclusively at achieving absolute XenForo 2.3.x Core Architecture Compliance and flawless stability.

We completely eliminated a persistent, flawed caching architecture regarding "Latest Registered Members," which was directly responsible for triggering the "Undefined array key" Server Errors deep within the XF Entity Manager mapping logic. The addon now natively utilizes the official XF "NewestMembers" widget index-hinting algorithms.

Furthermore, we conducted a rigorous backend refactoring targeting 3rd party module statistics (DBTech, XFRM, XFMG, XENTR Tickets). All obsolete, hard-coded raw SQL queries (SELECT COUNT(*)) have been completely rewritten into xenForo's official, high-performance Finder/ORM infrastructure, vastly improving processing speed and guaranteeing maximum codebase reliability.

• Fixed: Resolved an error (Undefined array key) in the "Latest Registered Members" list caused by conflicts with other third-party add-ons.
• Fixed: Completely resolved a severe performance issue (Lock wait timeout exceeded) where background statistics updates would overwhelm the system, causing delayed page loads or temporary site freezes.

This update focuses on improving system stability and performance based on feedback from our users. We have completely resolved the issues causing occasional slowdowns or delayed page loads, especially noticeable on high-traffic and busy forums.

Furthermore, compatibility issues with other third-party add-ons installed on your forum have been addressed, ensuring that the "New Members" block operates flawlessly and is 100% compliant with XenForo standards.

We highly recommend installing this update for a much faster and smoother Welcome Panel experience! Please do not forget to rebuild your caches from the tools section after installing the update to clear out old data.

• Performance Optimization: Heavy database queries (COUNT/FETCH) for statistics have been optimized. Server load is now minimized using SimpleCache and the XenForo Registry system.
• Bug Fix: Fixed an issue where specific user statistics (e.g., post count percentage) were cached and incorrectly displayed to other users.
• Compatibility: Resolved issues where template modifications failed on custom themes. Modifications now utilize a flexible Regex structure.
• Integration: Added is_addon_active checks to prevent errors or empty blocks when 3rd party add-ons (XFRM, XFMG, Support Tickets, eCommerce) are disabled or uninstalled.
• Code Cleanup: Improvements made for PHP 8.3 compatibility (Type hints and strict types).

This update is a critical maintenance release focusing on performance and stability.

Database queries that caused server load in the previous version, especially on high-traffic forums, have been completely optimized. The statistics collection engine has been rewritten to utilize XenForo's native caching system.
Additionally, the "Cache Pollution" issue, where user-specific data (e.g., message count) was accidentally cached and displayed to other users, has been resolved. Template modifications have been converted to Regex to improve compatibility with custom themes.

• Added optional control for support ticket statistics
• Prevented errors when [XTR] Support Tickets System addon is not installed
• Made it toggleable from admin panel like other addon statistics

Support ticket counter now respects the xentrShowTotalSupportTickets option

• Fixed Entity serialization error when using Redis Cache
• Resolved "Entities cannot be serialized or unserialized" LogicException
• Optimized user list caching mechanism

This update fixes a critical error that occurs when using Redis Cache.

Who Is Affected:
• Sites using Redis Cache
• Forums with SV/RedisCache addon active
• High-traffic websites

Support:

If you need assistance, feel free to contact us or create a support ticket.

---

We are always here to assist our customers and are happy to help resolve any issues you may encounter.