# 📦 SMCStylus DB Utils v.1.0.0

A powerful WordPress plugin to manage, clean, and optimize your site's database with a modern, intuitive admin interface.

---

## ✨ Features

- Cleanup revisions, trashed posts, auto-drafts, spam comments
- Manage transients:
  - View expired/active
  - Load more with pagination
  - Selective or bulk deletion
- Optimize & repair database tables
- Remove orphaned postmeta and usermeta
- Manual SQL console for advanced users
- Scheduled automatic maintenance (configurable tasks & time)
- Multisite-aware (works in network admin)

---

## ⚙️ Installation

1. Upload the plugin folder to `/wp-content/plugins/`
2. Activate the plugin through the **Plugins** menu in WordPress.
3. Navigate to **DB Utils** in the admin sidebar.

---

## 📖 Usage

- **Dashboard:** Overview of database health
- **Cleanup:** One-click deletion of revisions, drafts, trash, spam
- **Transients:** List, filter, remove expired and active transients
- **Tables:** Optimize & repair individual tables via AJAX
- **Orphaned Data:** Find and remove unused postmeta/usermeta
- **SQL Console:** Run custom SQL queries (admin only)
- **Backup:** Manual SQL dumps before changes
- **Settings:** Schedule daily/weekly/monthly maintenance with task selection and custom hour

---

## 🔒 Security

- All actions secured with WordPress nonces
- Only `manage_options` users can access

---

## 🗓️ Roadmap

✅ AJAX-driven UI  
✅ Pagination / Load More for transients  
✅ Task-based scheduler with hour selection  
✅ WPML-ready strings  
✅ Optimized Bootstrap 5 interface  

---

## 🧑‍💻 Author

**Name:** Mihai Calin SIMION  
**Website:** [www.smcstylus.com](https://www.smcstylus.com)  
**Email:** [simion.mihai.calin@gmail.com](mailto:simion.mihai.calin@gmail.com)

---

## 📜 License

GPLv2 or later

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License.

---