CMSB v3.73 Beta (Admin: Login As User)

Hi everyone,

We've released a beta of version 3.73! This update is mainly a maintenance release but includes a useful new 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 logs 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 25, 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)

MINOR CHANGES
- Updated DB::isConnected() to verify connection status using mysqli->ping()
- 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 effected 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

BUG FIXES
- 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
- Upload Lists: Fixed issue that preventing drag sorting on touch devices
- Misc Code and other minor improvements

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

Please post (or email) any feedback, questions, concerns, or bugs you find.   Your help beta testing allows us to release new features even faster.

Thanks, we look forward to your feedback! :)