Scotty

ບັນທຶກການປ່ຽນແປງ

2.0.2

• Feature: add Trash Summary card to Overview with total cleanable items, breakdown badges, and “Clean now” link
• Feature: add Environment Info card to Overview showing PHP, WordPress, MySQL versions, memory limit, max upload size, and server
• Feature: add Documentation link button in Features dropdown menu
• Feature: redesign footer with Docs and Report Issue links, WP Bones and Mantine UI credits with icons
• Feature: add Database Size and Cron Jobs count to dashboard widget
• Enhancement: add loading skeleton and error state to dashboard widget
• Enhancement: translate all dashboard widget tooltip strings for i18n support
• Enhancement: reduce dashboard widget bundle size by removing unused providers and CSS imports
• Enhancement: add link to documentation website in readme.txt description and FAQ
• Enhancement: rewrite README.md with badges, links, features, tech stack, and project structure
• Fix: modal confirm title invisible in dark mode
• Fix: WPBonesLogo component using wrong Mantine v8 size props (width/height instead of w/h)
• Fix: dashboard widget “Open Scotty” link pointing to #trash instead of overview
• Chore: regenerate translation files (POT, PO, MO, JSON) with all new strings (223 total, Italian 100%)

2.0.1

• Security: restrict admin menu capability from ‘read’ to ‘manage_options’ to prevent subscriber access
• Security: add integer type casting to all AJAX delete endpoints for defense-in-depth
• Security: wrap remaining raw SQL queries with $wpdb->prepare() in duplicate meta deletion methods
• Fix: replace non-functional EMPTY_TRASH_DAYS constant with wp_scheduled_auto_delete_period filter
• Fix: replace impossible is_null() check with empty() after sanitize_text_field() in CronTrait
• Fix: correct resetAutoIncrement() to accumulate results across multiple tables
• Fix: resolve potential undefined array key when more than 13 data categories exceed color palette
• Fix: correct typo in OverviewAjaxServiceProvider ($commnets_count)
• Performance: add ORDER BY and LIMIT 1000 to comment listing queries to prevent unbounded result sets
• Enhancement: suppress deprecated WP_Debug_Data::get_sizes() notice in DiskTrait
• Chore: align PHP version requirement to >=8.1 across composer.json, readme.txt, and scotty.php
• Chore: update package.json version to match plugin version
• Chore: update blueprint.json to use wordpress.org/plugins slug resource and target PHP 8.2
• Chore: remove dead code (unused removeMenu method, empty PreferencesTrait, unreachable Ajax method)
• Chore: standardize returnColumnsJson() visibility to private across all Ajax service providers

2.0.0

Major release with security hardening, modernized stack, UI improvements, and new features.

New Features

• WordPress Settings: new Security options — disable file editor, author archives, Application Passwords
• WordPress Settings: new Admin Menu options — toggle Media, Pages, Comments, Tools visibility
• WordPress Settings: new Admin Notices options — disable update nags, admin email verification
• WordPress Settings: new Writing options — disable self-pings, auto-empty trash with configurable days
• WordPress Settings: new Reading options — disable emoji scripts, embed scripts, jQuery Migrate, RSS feeds
• WordPress Settings: new Performance tab — Heartbeat control, Dashicons removal on frontend
• WordPress Settings: new Media tab — disable big image scaling, custom JPEG quality
• WordPress Settings: unified OptionsProvider with single fetch and shared Reset button
• Cron: delete individual cron jobs with confirmation modal
• Cron: bulk delete selected cron jobs
• Cron: search/filter by hook name
• Cron: sortable columns (hook name, next run, schedule)
• Cron: row expansion showing signature, interval, and arguments
• Cron: right-click context menu with Run and Delete actions
• Cron: colored schedule badges (hourly, daily, weekly, one-time)
• Cron: time-relative status indicators (overdue, soon, upcoming)
• Overview: new Database Size quick card with link to Database section
• Overview: new Scheduled Cron Jobs quick card with link to Cron section
• Overview: clickable cards navigate to their corresponding section
• Overview: refresh button to reload all overview data
• Trash: bulk delete for unapproved, spam, and trashed comments
• Trash: orphan term relationships listing, single and bulk delete
• Duplicates: single and bulk delete for duplicate user meta and comment meta

Security

• Fixed SQL injection in database optimize and auto-increment reset (table name whitelist)
• Added schema validation and recursive sanitization for preferences update
• Added esc_html() to all meta/option/comment values in JSON responses
• Fixed hardcoded wp_posts table prefix in SQL subqueries
• Added $wpdb->prepare() to all orphan detection queries
• Sanitized cron hook_name and signature inputs
• Fixed transient query missing prepared statement
• Fixed XML-RPC error handler using PHP Error class instead of WP_Error
• Standardized LIKE clause syntax across all queries
• Fixed hardcoded commentmeta table prefix in orphan deletion

Bug Fixes

• Fixed Disk overview showing NaN for timed-out directory calculations
• Fixed Disk overview crash when WordPress size data contains error strings
• Fixed division by zero in Options overview when option count is zero
• Fixed OverviewCard pulsing indicator on arbitrary >50% values
• Fixed admin bar removal running too early (before scripts are registered)
• Fixed Reset to default not actually resetting options to defaults
• Fixed each WordPress Settings tab creating a separate OptionsProvider (4 redundant fetches)
• Fixed SWR mutate() not revalidating after bulk operations across all views
• Fixed broken Refresh button in empty Trash/Duplicates view
• Fixed Terms crash when excluded term IDs array is empty
• Fixed translated strings interpolated in SQL (comments)
• Fixed duplicate term meta deletion keeping wrong entry
• Fixed Features popover Overview link not working
• Fixed “Database Sneak Peak” typo (now “Sneak Peek”)
• Fixed getOptions crash on undefined path segments when new options are not yet in database

Improvements

• Migrated from npm to Yarn
• Updated @wordpress/scripts from 27.9.0 to 31.7.0
• Updated Mantine from 7.14.0 to 8.3.18
• Updated all dependencies to latest compatible versions
• Migrated to React 18 createRoot API (replaced deprecated wp.element.render)
• Modernized tsconfig.json (es2020, react-jsx, bundler resolution)
• Removed all unnecessary import * as React statements (30 files)
• Removed deprecated MantineProvider withStaticClasses prop
• Fixed Mantine 8 Image component rendering in header logo
• Performance: replaced N+1 user queries with single count_users() call
• Performance: removed repeated COUNT(*) subqueries in post/comment stats
• Performance: added LIMIT 1000 to orphan detection queries
• Removed esc_sql() mixing with prepare() in term relationships
• Cleaned up dead code and unused imports across Cron, Shortcode, and Options components
• Added error handling to Options/Preferences provider
• Improved AJAX error throwing with structured status/statusText

1.1.0

• Refactored code in TypeScript
• Added internationalization support
• Added total item count in Cron and Shortcode views
• Added links in the left sidebar
• Disabled admin notices for the Scotty view
• Fixed unused terms view to enable deletion of unused terms

1.0.0

• First public release