SQL Table Lookup
Slug: sql-table-lookup · harvest316 · 10+
Overall Score
Excellent quality and security
What this score means
Scores are calculated on a 100-point scale by analysing six weighted categories: Security, WP.org Readiness, Performance, Code Quality, Accessibility, and Vulnerabilities.
-
Excellent The plugin follows best practices across every measured category. It is well-maintained, low-risk, and recommended for production use.
-
Good Strong overall quality with minor areas for improvement. Generally safe to use on most sites.
-
Needs Review Some areas of concern detected. Review the full issues report and weigh the risks before installing on production.
-
High Risk Significant quality or security problems found. Exercise caution — check the details carefully before using this plugin.
- Wordfence: May 21, 2026 8:33 pm (51 minutes ago)
Score Breakdown
Why this score?
Top deductions are based on 1 affected rules, reducing this category by 12 total points.
| Rule | Hits | Impact | Share |
|---|---|---|---|
| Security issue: Warning | 3 | -12 | 100% |
Why this score?
Top deductions are based on 4 affected rules, reducing this category by 25 total points.
| Rule | Hits | Impact | Share |
|---|---|---|---|
| Repo issue: Warning | 4 | -12 | 48% |
| Repo issue: Notice | 5 | -5 | 20% |
| Last update is over one year old | 1 | -5 | 20% |
Plus 1 additional rules with smaller impact.
Show all rules (1 more)
| Rule | Hits | Impact | Share |
|---|---|---|---|
| Tested up to version is behind current WordPress | 1 | -3 | 12% |
Why this score?
Top deductions are based on 0 affected rules, reducing this category by 0 total points.
No deductions were applied for this category in the latest score run.
Why this score?
Top deductions are based on 1 affected rules, reducing this category by 3 total points.
| Rule | Hits | Impact | Share |
|---|---|---|---|
| Code Quality issue: Warning | 1 | -3 | 100% |
Why this score?
Top deductions are based on 0 affected rules, reducing this category by 0 total points.
No deductions were applied for this category in the latest score run.
Why this score?
Top deductions are based on 0 affected rules, reducing this category by 0 total points.
No deductions were applied for this category in the latest score run.
Plugin Details
- Version: 0.1
- Active Installs: 10+
- Last Updated: 2014-08-19 04:13:00
- Tested up to:
- Requires PHP:
- Rating: 5/5 (1 ratings)
- View on WordPress.org
- Download Plugin
Scan Summary
- Errors: 0
- Warnings: 8
- Notices: 5
- Last Scanned: 2026-05-21 18:34:42
What Changed Since Last Scan
New Issues
No items in this category.
Resolved Issues
No items in this category.
Worsened Issues
No items in this category.
Detected Issues
| Severity | Category | Message | File | Fix Guidance |
|---|---|---|---|---|
| WARNING | REPO | Plugin metadata is missing a declared minimum PHP version. |
Quick
Add a "Requires PHP" value in the plugin header and readme metadata.
Moderate
Validate minimum PHP compatibility across supported environments and release notes.
Advanced
Automate compatibility matrix tests in CI for all declared PHP versions.
|
|
| WARNING | REPO | Plugin metadata has no 'Tested up to' value. |
Quick
Set the "Tested up to" value in readme.txt to the latest stable WordPress release.
Moderate
Run smoke tests on current WordPress major/minor versions before publishing updates.
Advanced
Adopt automated WordPress-version CI pipelines and gate releases on pass/fail status.
|
|
| NOTICE | REPO | Plugin has no icon on WordPress.org. |
Quick
Upload standard plugin icon assets to the WordPress.org assets directory.
Moderate
Provide dark/light-safe icon variants and verify rendering in listing contexts.
Advanced
Automate asset packaging validation in release tooling to prevent missing media.
|
|
| NOTICE | REPO | Plugin has no header banner on WordPress.org. |
Quick
Upload the required WordPress.org banner image sizes in SVN assets.
Moderate
Create responsive-safe banner designs with legible copy and branding.
Advanced
Integrate listing asset checks in the release pipeline with design QA approvals.
|
|
| NOTICE | REPO | Plugin is still at pre-release version 0.1. |
Quick
Set a stable semantic version once production readiness is confirmed.
Moderate
Define release criteria and changelog quality gates before promoting stable tags.
Advanced
Adopt automated release orchestration with semantic version enforcement and rollback plans.
|
|
| WARNING | SECURITY | Declared minimum WordPress 3.0 is very outdated and lacks modern security APIs. |
Quick
Raise minimum WordPress version to a modern supported release.
Moderate
Replace deprecated APIs and confirm compatibility across current WordPress branches.
Advanced
Run multi-version WordPress integration tests in CI and block unsupported API usage.
|
|
| WARNING | REPO | Main plugin file does not declare a Text Domain header. | sql-table-lookup.php |
Quick
Add a Text Domain header so translation tooling and WordPress.org can identify the plugin textdomain.
Moderate
Apply the same remediation pattern across repo findings and re-scan to confirm warning issues drop.
Advanced
Add automated linting, CI checks, and team review guidance so this issue class is prevented in future releases.
|
| NOTICE | REPO | Main plugin file does not declare a Domain Path header. | sql-table-lookup.php |
Quick
Add a Domain Path header if language files are stored in a languages directory.
Moderate
Apply the same remediation pattern across repo findings and re-scan to confirm notice issues drop.
Advanced
Add automated linting, CI checks, and team review guidance so this issue class is prevented in future releases.
|
| WARNING | SECURITY | Main plugin file does not appear to guard direct access with an ABSPATH check. | sql-table-lookup.php |
Quick
Add an ABSPATH guard near the top of the main plugin file to prevent direct execution.
Moderate
Apply the same remediation pattern across security findings and re-scan to confirm warning issues drop.
Advanced
Add automated linting, CI checks, and team review guidance so this issue class is prevented in future releases.
|
| NOTICE | REPO | Plugin package does not include a license file. |
Quick
Add a LICENSE or COPYING file so distribution terms are explicit.
Moderate
Apply the same remediation pattern across repo findings and re-scan to confirm notice issues drop.
Advanced
Add automated linting, CI checks, and team review guidance so this issue class is prevented in future releases.
|
|
| WARNING | SECURITY | Direct database query detected without an immediately visible $wpdb->prepare() wrapper. | sql-table-lookup.php |
Quick
Wrap dynamic SQL arguments with $wpdb->prepare() in the flagged query.
Moderate
Refactor repeated SQL into repository/helper methods that enforce prepared statements by default.
Advanced
Add integration tests and static checks that fail builds when direct dynamic SQL is introduced.
|
| WARNING | CODE_QUALITY | No WordPress hooks were detected in the plugin source. |
Quick
Register actions, filters, and lifecycle hooks explicitly so plugin behavior integrates cleanly with WordPress.
Moderate
Apply the same remediation pattern across code quality findings and re-scan to confirm warning issues drop.
Advanced
Add automated linting, CI checks, and team review guidance so this issue class is prevented in future releases.
|
|
| WARNING | REPO | No translation functions were detected in the plugin source. |
Quick
Wrap user-facing strings with translation functions such as __(), esc_html__(), or _x().
Moderate
Apply the same remediation pattern across repo findings and re-scan to confirm warning issues drop.
Advanced
Add automated linting, CI checks, and team review guidance so this issue class is prevented in future releases.
|
Score History
Range Change: 0 pts · All-Time High: 92/100