4.71v Various improvements

1. Department Management and User Administration
   - Enhanced department group statistics modal for better oversight of group performance
   - Implemented read-only status toggle for department assignments with visual feedback
   - Added confirmation modal for assigned department edits to prevent accidental changes
   - Improved user department management with transaction handling for data integrity
   - Added utility to cleanup orphan departments and maintain database consistency
   - Enhanced department assignment UI with better UX and simultaneous request prevention
   - Added filtering for users by assigned departments for improved navigation
   - Implemented department limitation handling and cache version updates on changes
   - Added red/green color indicators for operator online status visibility

2. Bot System and Webhook Improvements
   - Enhanced bot conditions handling with condition identifiers for better query filtering
   - Updated trigger link display to show bot name alongside trigger name for clarity
   - Disabled cache for bot actions and conditions to ensure real-time updates
   - Added 'single_event' support to webhook functionality for better event handling
   - Implemented webhook search panel with filtering capabilities for easier management
   - Added event field to webhook search panel and configuration options
   - Enhanced bot trigger validation with improved button assignment verification
   - Added support for conditional text generation in bot responses
   - Implemented 'sub_source' parameter to sendBotResponse for better tracking
   - Added option to check chat status after REST API calls

3. File Management and Image Processing
   - Added HEIC image conversion support in verifyaccess.php for modern image formats
   - Implemented file download restrictions and settings to mail conversation module
   - Enhanced image verification process with re-verification features
   - Added modal display for attached image files with better user experience
   - Implemented resize support for form files to optimize storage and performance
   - Added option to download files inline with modal interface
   - Enhanced file extension detection and validation for security
   - Added fallback options when browser cannot render images
   - Implemented option to ignore specific image files during verification
   - Added resize functionality for large mail message screenshots

4. Chat System and Message Handling
   - Added system message indicating when chat was accepted by operator
   - Enhanced image handling and conditions in the chat system
   - Implemented separate events for messages added via incoming webhooks
   - Added loading spinner overlay to main widget for better user feedback
   - Enhanced form submission experience with spinner on submit button
   - Added option to inherit start chat form settings for consistency
   - Improved message handling with better error display and validation
   - Enhanced chat search capabilities with message ID search functionality
   - Added support for raw file embed syntax in chat messages
   - Implemented conditional text generation for dynamic responses

5. Security and Performance Improvements
   - Implemented strict locking mechanisms for critical operations
   - Added transaction handling for operator transfers and chat attribute updates
   - Enhanced permission checking in export functions for better security
   - Implemented proper transaction handling for icon operations
   - Added cache clearing mechanisms for improved performance
   - Enhanced error handling for failed file downloads and operations
   - Implemented audit log truncation option from back office
   - Added better logging for auto assignment operations and error tracking
   - Enhanced REST API with option to skip empty body requests

6. User Interface and Experience Enhancements
   - Enhanced department assignment functionality with improved UI feedback
   - Added 'user-select-none' class to labels for better user experience
   - Implemented lazy load option for widget theme optimization
   - Added argument titles to command execution for better clarity
   - Enhanced form styling with improved input field appearance
   - Added link to documentation for better user guidance
   - Updated React app version with enhanced network failure handling
   - Improved checkbox re-enabling logic after request completion
   - Added nowrap styling for department group lists for better display

7. System Maintenance and Bug Fixes
   - Fixed issue #2298, #2304, #2305, #2306 addressing various system bugs
   - Updated dependencies and php-imap reference for security and compatibility
   - Enhanced error handling for non-existing users in reports
   - Fixed replacement process and edge case scenarios
   - Improved file type validation and extension setting for known formats
   - Fixed undefined display issues in pending wait time calculations
   - Enhanced aggregation queries by removing duplicates for better performance
   - Updated default translations for better internationalization support

execute doc/update_db/update_339.sql for update

**Full Changelog**: https://github.com/LiveHelperChat/livehelperchat/compare/4.70v...4.71v

4.70v Various improvements

1. REST API and Bot Enhancements
   - Added retry options for REST API calls with configurable retry attempts and delays
   - Enhanced bot trigger validation to ensure buttons are correctly assigned to triggers
   - Improved trigger argument importing to support all available trigger arguments
   - Enhanced bot condition support with new "Not in list" condition type for more flexible logic flows
   - Better error handling and continuation logic when customers don't set matching triggers

2. File Management and Search Improvements
   - Enhanced file search functionality with new chat ID and user ID filters
   - Added display of attached files in chat modification view for better file visibility
   - Improved file search panel UI with better styling and user experience
   - Enhanced JavaScript for dynamic form submission on input changes
   - Implemented indefinite file download capability for better file access management

3. Forms and Offline Chat Integration
   - Major offline form tight integration (#2286) with React Component migration
   - Enhanced offline form to use React Components instead of legacy offline form system
   - Added conditions for offline form prefilling fields from previous chat sessions
   - Improved form error rendering for number field types
   - Better handling of input_data passing to offline templates
   - Enhanced forms integration with edge case scenario updates

4. Chat and Message Handling Improvements
   - Added support for image requests with visitor messages
   - Improved file attachment flow to prevent message overlapping during file uploads
   - Enhanced scroll positioning for file preview functionality
   - Better handling of visitor message display and file attachment rendering
   - Improved message object passing for enhanced chat functionality

5. Security and Permissions
   - Fixed permission handling issues (#2288, #2291)
   - Enhanced file verification events for attachment flows
   - Better access control and security validations throughout the system

6. UI and User Experience Enhancements
   - Enhanced file list module to support new search parameters
   - Improved styling of input fields for better user experience
   - Better JavaScript handling for dynamic form interactions
   - Enhanced chat modification interface with file display capabilities

7. System and Internal Improvements
   - Increased length of internal type fields for better data handling
   - Updated database structure with new field length requirements
   - Enhanced schedule checks with new ActionConditions class
   - Better chat blocking tests and validation logic

8. Technical Infrastructure
   - Updated widget React components for better offline form handling
   - Enhanced translation system and updated translation files

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

## What's Changed

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

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