CMSB v3.73 Released (Sep 30) - Admin: Login As User

Hi everyone,

We've just released version 3.73! This update is mainly a maintenance release but includes a useful new admin feature: Login As User.

The Login As User feature allows administrators to log in as any user account. This functionality is particularly helpful for troubleshooting, providing support, and testing during site development.

To try it out, edit any user record in the CMS and click "Advanced Commands..." in the bottom right corner.  You'll find some new commands: 

• Admin: Login As User - This logs you into the CMS as the selected user.
• Admin: Login As User (Website) - If you're using Website Membership, this will appear and log you into the frontend website as the selected user.

For those of you using a separate table for website users (such as "members"), you'll find the website login option under that section instead.

The full changelog for this release is as follows:

*** September 30, 2024 - Version 3.73 (Admin: Login As User)

SERVER REQUIREMENTS: PHP 8.0+ and MySQL 5.7+ (or MariaDB 10.2+)

NEW FEATURES
- Added "Login As User" under Accounts > Advanced Commands for admin troubleshooting and support
- Added "Login As User (Website)" for frontend website access (when using Website Membership plugin)
- Developer Log: Added "Latest Error" view for quickly reloading the most recent error when debugging

MINOR CHANGES
- All Menus: "Advanced Commands..." dropdown is now hidden if it has no options
- Database Editor: "Add Field" buttons are now hidden for link and menu group menu types that don't support fields
- Admin > Security > Audit Log: Usernames are now displayed on list page for all login attempts
- Admin > Security > Audit Log: Added detail column to list page with error details and links to affected records
- Programmers: mysql_where() - Added support for NULL value comparisons in criteria array
- Programmers: isValidEmail() - Allow leading and trailing spaces in email addresses
- Programmers: getRecords() - Added useIndex option to specify MySQL index hints
- Programmers: getRecords() - Added selectExpr option for overriding SELECT expressions
- Programmers: DB::isConnected() now supports optional parameter to verify active connection via mysqli ping

BUG FIXES
- Upload Lists: Fixed issue that prevents drag sorting on touch devices such as iPads
- loadINI: Fixed issue where loadINI() would return an error when loading legacy .ini format schema files
- Category Menus: Fixed issue where older category menus didn't allow NULL values and returned error
- Database Editor: Fixed "Undefined array key" warning when saving a menu group section
- Updated DBException() to verify connection before loading admin status for error details
- Fixed issue that prevented plugin list from loading when Cloudflare Rocket Loader was being used
- Misc code and other minor improvements

You can download the latest version here:https://www.interactivetools.com/download/

Please feel free to ask any questions or post any feedback, questions, or bugs you find! 

Thank you!