4.69v File preview

1. File and Image Preview System Enhancement
   - Implemented comprehensive file and image preview functionality before sending to operator
   - Added temporary file handling with new `tmp` field in `lh_chat_file` table
   - Enhanced widget React components to support file preview with better user experience
   - File attachments are now rendered at the top of messages for better visibility
   - Improved file upload workflow with progress indicators and preview capabilities
   - This enhancement prepares the foundation for future OpenAI Responses API for images implementation

2. Widget and Chat Interface Improvements
   - Enhanced attachment rendering system with dedicated top-level templates
   - Improved AI-generated content checks and validation
   - Better file uploader component with enhanced preview functionality
   - Optimized widget React components for better performance and user experience
   - Enhanced chat file handling with improved meta message rendering

3. Department and Chat Management Enhancements
   - Added support for using department alias when provided in chat widget and status checks
   - Improved department handling logic for better chat routing
   - Enhanced chat widget functionality with streamlined department selection

4. Export and Data Handling Improvements
   - Fixed JSON export formatting with proper UTF-8 charset headers for Unicode support and pretty printing (#2283)
   - Enhanced bot export functionality with correct content-type headers
   - Improved REST API export with proper encoding
   - Better theme export handling with Unicode support

5. File Configuration and Management
   - Added new file configuration options for better file handling control
   - Enhanced file upload settings with improved validation and processing
   - Better integration between file upload API and widget components
   - Improved file metadata handling and storage

6. Technical Infrastructure Improvements
   - Updated database structure with new temporary file handling capabilities
   - Enhanced widget REST API endpoints for better file and chat management
   - Improved translation support and internationalization

7. User Experience Enhancements
   - Streamlined file attachment workflow with instant preview
   - Better visual feedback for file operations
   - Enhanced message rendering with improved attachment display
   - Optimized loading and rendering performance for file-heavy conversations

For update just follow standard update procedure. For manual update it's update_337.sql

## What's Changed

**Full Changelog**: https://github.com/LiveHelperChat/livehelperchat/compare/4.68v...4.69v

4.68v Improvements

1. Mail module enhancements
   - Added comprehensive mail file management system with listing, viewing, and searching functionalities
   - Enhanced mail image verification flow with protection mechanisms and sensitive content handling
   - New components: MailChatAttachment and MailChatImage for better mail attachment handling
   - Mail files archive tables now maintain consistent structure
   - Improved file details display in mail history
   - Better handling of mail file verification and download permissions

2. User management improvements
   - Added job title field to user department alias functionality
   - Enhanced user department attributes with additional customization options
   - Improved validation and structure for user department relationships

3. BBCode and URL handling enhancements
   - Added URL whitelist functionality for BBCode configuration to control link visibility
   - Enhanced URL obfuscation in BBCode parser with whitelist support
   - Improved BBCode URL handling and file extraction in messages
   - Added Message class for better file extraction functionality
   - Enhanced security and user control over link visibility

4. File and image handling improvements
   - New permission system for file verification with granular access control
   - Allow non-image files to download with proper verification
   - Enhanced file reveal functionality and logging capabilities
   - Improved image attributes display in file edit window
   - Better styling for reveal image actions

5. Mail search and performance optimizations
   - Enhanced mail search using message_id for improved performance
   - Better handling of mail file operations and verification flow
   - Optimized database queries for mail-related operations

6. System configuration enhancements
   - Added default system time zone variable for better timezone handling
   - Option to see SMTP debug information for troubleshooting
   - Enhanced SMTP settings form and tab navigation
   - Improved audit configuration and logging capabilities

7. Security and data handling
   - Fixed JSON export formatting with Unicode support and pretty printing (#2283)
   - Enhanced security for file downloads and verification
   - Better handling of sensitive information in mail attachments
   - Improved agent name escaping in various contexts

8. Performance and stability improvements
   - Combined department and department group results for better consistency
   - Merged department ID filters for improved data consistency in statistics retrieval
   - Enhanced message handling logic in fetch operations
   - React app version updates and script reference adjustments
   - Better content fetching and caching mechanisms

9. UI and UX improvements
   - Enhanced file body parsing and embed functionality for chat files
   - Improved styling and visual feedback for various components
   - Better handling of verification states and user interactions
   - Enhanced modal windows and form interactions

10. Developer and debugging improvements
    - Option to skip request body in logging for performance
    - Enhanced debugging capabilities with better logging options
    - Improved database structure documentation and references
    - Better error handling and validation throughout the system

For update just follow standard update procedure. For manual update it's update_336.sql

**Full Changelog**: https://github.com/LiveHelperChat/livehelperchat/compare/4.67v...4.68v

4.67v Image verification flow

Release is related to ​https://doc.livehelperchat.com/docs/bot/image-file-verification-flow

• Image download verification and protection features
•    - Introduced 'img_download_policy' configuration option to manage image download permissions
•    - Enhanced file download logic to include image verification and protection checks
•    - Added new verifyaccess.php module to handle image access verification requests
•    - Updated database schema to include 'meta_msg', 'width', and 'height' fields in lh_chat_file and lh_mailconv_file tables
•    - Implemented Svelte component for image handling with verification and protection features
•    - Added translations for image access verification messages
•    - Updated module.php to include new permissions for downloading verified and unverified files
•    - Added sensitive information image to the default theme
• Chat tabs and dashboard improvements
•    - Chat tabs React component now supports custom attributes for styling
•    - Enhanced tabs flow with better navigation and user experience
•    - Dashboard chat tabs improvements with better state management
• Bot and webhook enhancements
•    - Added support for overriding bot ID in webhook processing for better event handling
•    - Implemented chat file variable handling in generic bot action command for dynamic variable updates
•    - Enhanced REST API action to support chat file messages
•    - Option to sync attribute from database in bot conditions
•    - Modal window will show error message when trying to delete a bot that cannot be deleted
• Form and file handling improvements
•    - Fixed reCAPTCHA in offline form when file is submitted
•    - Enhanced offline forms with proper cookie handling and headers
•    - Better file upload handling with proper content headers
•    - Store partial encoded data for better file processing
• Chat experience enhancements
•    - Hide "Switch to Human" button when chat transitions to survey mode
•    - System message is now logged when "Switch to Human" button is clicked
•    - Custom template support for extensions below chat messages
•    - Improved image reveal logic in Svelte components for better scrolling behavior
• Security and compatibility
•    - Fixed deprecated PHP constant E_STRICT for better PHP 8+ compatibility
•    - Enhanced file download verification process with user data in event dispatch
•    - Improved security for image access and verification
• UI and UX improvements
•    - Better error handling and user feedback
•    - Enhanced modal dialogs and confirmation windows
•    - Improved responsive design elements
•    - Updated sponsors section

For update just follow standard update procedure. For manual update it's update_335.sql

4.66v Improvements

• IMAP and SMTP connection testing features in mailbox settings. You can now test your mail configuration directly from the interface.
• Enhanced mailbox management with delete folder functionality for better organization.
• Bot chart generation using Mermaid diagrams for visual workflow representation of bot flows.
• New configuration option for departments: "Do not transfer to destination department if it has no online operators" to improve chat transfer handling.
• Enhanced user settings management and dashboard tab management with improved visibility options.
• Conditions support for replaceable variables, allowing more dynamic content generation.
• Option to investigate use cases of various objects for better debugging and analysis.
• Priority rule testing - you can now test priority rules directly from the interface.
• Enhanced bot message handling and trigger management with better control options.
• Direct magic attribute support in bot text fields with new direct_ prefix option.
• Enhanced REST API trigger execution logging and handling for better debugging.
• Option to suspend/resume online visitors updating in main window for performance control.
• Canned messages now have max result configuration for display optimization.
• Enhanced email anonymization features and chat status improvements.
• n8n integration support for workflow automation.
• Improved quote handling in messages - quotes will be preserved as plain text.
• Enhanced access control for displaying user attributes in online user info.
• Better handling of chat continuation and message rendering.
• Updated dependencies including TinyMCE, Svelte, and other packages for security and performance.
• Switch to new modal confirm windows replacing browser native confirms.
• Enhanced character validation and node identifiers in bot chart generation.
• Improved debug output with better state attribute handling and clarity.
• Enhanced bot trigger builder functionality with better workflow management.
• Fixed chat closing in popup scenarios that sometimes triggered false alerts.
• Better handling of button payload text values as default triggers.
• Enhanced message processing with improved direct value handling.
• Various fixes for online operator department conditions and user management.
• Pronoun inclusivity improvements changing he/him/his references to they/them.
• Enhanced template compilation with preserved newline characters.
• Better background worker exception handling.
• Enhanced department query to include online hours check for better availability management.
• React app version updates and chat widget reducer state management improvements.

For update just follow standard update procedure. For manual update it's update_334.sql

Live Helper Chat integration with n8n for advanced workflow automation