=== Mega Database Cleanup ===
Contributors: megawixtech
Donate link: https://www.megawix.com
Tags: database cleanup, optimization, postmeta cleaner, acf cleanup, cron cleanup, performance
Requires at least: 5.0
Tested up to: 6.9
Requires PHP: 7.4
Stable tag: 1.0.0
License: GPLv2 or later
License URI: https://www.gnu.org/licenses/gpl-2.0.html

A powerful and safe WordPress database cleanup tool with ACF orphan removal, empty meta scanning, scheduled cleanup automation, backups, and real-time preview mode.

== Description ==

**Mega Database Cleanup** is a modern, high-performance cleanup utility built to remove unused, empty, bloated, or orphaned metadata from your WordPress database — safely and automatically.

It includes a smart scanner, preview mode, ACF pattern cleanup, scheduled tasks, and full backup support. Ideal for site owners, developers, agencies, and power users who want a faster & cleaner database without risking important data.

= Highlights =

* **Empty / Unused Meta Scanner**  
  Detects empty, null, serialized-empty, or JSON-empty postmeta values.

* **ACF Cleanup Engine**  
  Automatically identifies patterns used by Advanced Custom Fields to detect orphan entries.

* **Real-Time Safe Preview**  
  See exactly what will be deleted before confirming cleanup.

* **Backup Before Delete**  
  All removed metadata can be stored in a dedicated backup table.

* **Scheduled Cleanup (WP-Cron)**  
  Cleanup can run automatically (hourly, daily, weekly).

* **Retention Rules**  
  Keep the latest N meta rows per meta_key (default: 5).

* **Safe & Secure**  
  Full validation, sanitization, and capability checks included.

* **One-Click Full Cleanup**  
  Delete unused metadata across the entire database.

* **Custom Cleanup Patterns**  
  Add or remove ACF-like patterns (SQL LIKE rules).

= Who Is This For? =

**Website Owners**  
– Improve site performance and reduce database size safely.

**Agencies & Developers**  
– Maintain clean data structures, especially on large sites.

**ACF Users**  
– Automatically remove leftover fields that accumulate over time.

**Performance Optimizers**  
– Speed up queries by removing thousands of useless meta rows.

= Why Mega Database Cleanup Is Different =

* Designed for **large databases**  
* Uses safe preview mode  
* Runs scheduled cleanups automatically  
* Creates a backup of every deleted row  
* Preserves the **first meta entry + last 5 entries** for safety  
* Uses optimized SQL queries for predictable performance  

== Installation ==

= Automatic Installation =

1. Log in to **WordPress Admin → Plugins → Add New**  
2. Search for **Mega Database Cleanup**  
3. Click **Install Now** → **Activate**  
4. Navigate to **Tools → Mega DB Cleanup**

= Manual Installation =

1. Download the plugin ZIP  
2. Go to **Plugins → Add New → Upload Plugin**  
3. Select the ZIP and install  
4. Click **Activate Plugin**

= Initial Setup =

1. Open **Tools → Mega DB Cleanup**  
2. Enable ACF Cleanup (optional)  
3. Enable Preview Mode (recommended)  
4. Add patterns if needed  
5. Enable scheduled cleanup (optional)  
6. Save changes

You're ready to analyze or clean your database!

== Frequently Asked Questions ==

= Does this delete important data? =

No — the plugin only targets metadata that is clearly empty, unused, or orphaned.  
If backup is enabled, you can restore deleted rows at any time.

= Is there a preview mode? =

Yes. Preview mode allows you to see exactly which meta rows are considered empty before removing anything.

= Does this support ACF fields? =

Yes! It includes a dedicated ACF cleanup engine that uses pattern rules to identify real orphan fields.

= Can I add my own patterns? =

Absolutely. You can add or remove SQL LIKE patterns directly from the admin panel.

= Does it work on multisite? =

Yes, it works on standard and multisite installations. Cleanup runs per site.

= Will this improve my website speed? =

Yes — removing thousands of empty meta rows reduces database size and speeds up queries.

= What if I delete something by mistake? =

If backups are enabled, deleted metadata is stored in a dedicated table so you can manually restore it via phpMyAdmin.

= How safe is the scheduled cleanup? =

Very safe — it follows the same rules as manual cleanup, including retention rules and backups.

== Screenshots ==

1. Dashboard – Main cleanup panel  
2. Empty Meta Preview table  
3. ACF pattern manager  
4. Cleanup settings and scheduler  
5. Log viewer  
6. Backup information panel  

== Changelog ==

= 1.0.0 – Initial Release =  
* Empty meta scanner and preview mode  
* ACF orphan cleanup with pattern-based detection  
* Scheduled automatic cleanup (hourly/daily/weekly)  
* Backup table to store deleted meta rows  
* Retention rule: keep latest N entries per meta_key  
* One-click delete all empty metadata  
* Add/remove ACF patterns  
* Inline logs and real-time reports  
* Fully optimized SQL cleanup  
* Admin UI with jQuery enhancements  

== Upgrade Notice ==

= 1.0.0 =  
Initial release of Mega Database Cleanup.  
Adds full database cleanup toolkit with backup, preview, and automated cleanup scheduler.

== Privacy Policy ==

Mega Database Cleanup does **not** track, collect, or transmit any user data.  
No information leaves your site.  
All backups remain stored locally on your database server.

== Developer Hooks ==

= Filters =

* `mega_db_cleanup_patterns` – Modify cleanup patterns  
* `mega_db_cleanup_retention_limit` – Change default "keep latest N" count  

= Actions =

* `mega_db_cleanup_before_delete` – Fires before deletion  
* `mega_db_cleanup_after_delete` – Fires after deletion  

== Credits ==

Developed with ❤️ by [MegaWix Technologies](https://www.megawix.com)

* Plugin Development: MegaWix Technologies
* Testing & QA: MegaWix Technologies

== Support ==

Need help? Have a question or feature request?

* Website: https://www.megawix.com
* Email: info@megawix.com

We are committed to providing reliable support and regular updates to ensure this plugin remains compatible with the latest WordPress versions.