6.3.6

Added

• Support for time column as DATETIME and new time_only column as TIME.
• New error and success logs for log creation functionality.
• Enhanced sanitization for input data to improve security.
• Implemented a sortable table UI for the activity log using WordPress standards.
• Added support for sorting by columns such as ID, Action, Date & Time, and Source.
• Refactored log creation logic to support new schema changes (time and time_only).
• Improved sanitization and validation for user inputs.
• Enhanced error handling and logging for both UI and database operations.

Changed

• Updated create_log method to match the new database schema.
• Improved code readability and maintainability for the log creation process.

Fixed

• Addressed potential SQL injection risks by ensuring all inputs are sanitized.
• Improved compatibility with WordPress timezone and current_time('mysql').

Upgrade Notes

• Ensure you run the database migration script to modify the time column and add the time_only column.

• Use the following SQL commands if automatic schema updates fail:

  ALTER TABLE wp_lic_log_tbl MODIFY COLUMN time DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00';
  ALTER TABLE wp_lic_log_tbl ADD COLUMN time_only TIME NOT NULL DEFAULT '00:00:00';