84% sql-table-lookup

Code Review | SQL Table Lookup

WordPress plugin SQL Table Lookup scored84%from 54 tests.

About plugin

  • Plugin page: sql-table-lookup
  • Plugin version: 0.1
  • PHP version: 7.4.16
  • WordPress compatibility: 3.0+
  • WordPress version: 6.3.1
  • First release: Aug 19, 2014
  • Latest release: Aug 19, 2014
  • Number of updates: 3
  • Update frequency: N/A
  • Top authors: harvest316 (100%)

Code review

54 tests

User reviews

1 review

Install metrics

10+ active /1,243 total downloads

Benchmarks

Plugin footprint 82% from 16 tests

Installer Passed 1 test

🔺 Critical test (weight: 50) | Verifying that this plugin installs correctly without errors
Installer ran successfully

Server metrics [RAM: ▲0.01MB] [CPU: ▼6.53ms] Passed 4 tests

An overview of server-side resources used by SQL Table Lookup
Server-side resource usage in normal parameters
PageMemory (MB)CPU Time (ms)
Home /3.47 ▲0.0142.14 ▼0.56
Dashboard /wp-admin3.31 ▲0.0151.18 ▼0.79
Posts /wp-admin/edit.php3.36 ▲0.0146.21 ▼3.18
Add New Post /wp-admin/post-new.php5.89 ▲0.0185.31 ▼21.59
Media Library /wp-admin/upload.php3.24 ▲0.0136.55 ▲0.53

Server storage [IO: ▲0.00MB] [DB: ▲0.00MB] 67% from 3 tests

Input-output and database impact of this plugin
Just a few items left to fix
  • Illegal file modification detected: 1 file (4.00KB) outside of "wp-content/plugins/sql-table-lookup/" and "wp-content/uploads/"
    • (new file) wp-content/mgd_mirror/mgd_maximinodotpy-gitdown-test-repository
Filesystem: 2 new files
Database: no new tables, 6 new options
New WordPress options
widget_recent-comments
db_upgraded
theysaidso_admin_options
can_compress_scripts
widget_recent-posts
widget_theysaidso_widget

Browser metrics Passed 4 tests

An overview of browser requirements for SQL Table Lookup
This plugin renders optimally with no browser resource issues detected
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /2,815 ▲5413.30 ▼1.061.75 ▼0.0843.88 ▼1.07
Dashboard /wp-admin2,221 ▲185.85 ▲0.98112.11 ▼5.6242.46 ▼1.53
Posts /wp-admin/edit.php2,103 ▲32.00 ▲0.0035.50 ▼0.7433.73 ▼4.28
Add New Post /wp-admin/post-new.php1,545 ▲1123.59 ▲0.44680.71 ▲32.3856.46 ▲8.94
Media Library /wp-admin/upload.php1,394 ▼34.21 ▼0.0599.68 ▼6.9943.11 ▼2.92

Uninstaller [IO: ▲0.00MB] [DB: ▲0.00MB] 75% from 4 tests

🔸 Tests weight: 35 | The uninstall procedure must remove all plugin files and extra database tables
These items require your attention
  • Zombie WordPress options were found after uninstall: 6 options
    • widget_recent-posts
    • widget_recent-comments
    • theysaidso_admin_options
    • db_upgraded
    • widget_theysaidso_widget
    • can_compress_scripts

Smoke tests 75% from 4 tests

Server-side errors Passed 1 test

🔹 Test weight: 20 | A shallow check that no server-side errors were triggered
Even though everything seems fine, this is not an exhaustive test

SRP 50% from 2 tests

🔹 Tests weight: 20 | A shallow check of the single-responsibility principle; PHP files should perform no action - including output of placeholder text - and trigger no errors when accessed directly
The following issues need your attention
  • 1× GET requests to PHP files have triggered server-side errors or warnings:
    • > PHP Fatal error
      Uncaught Error: Call to undefined function add_shortcode() in wp-content/plugins/sql-table-lookup/sql-table-lookup.php:56

User-side errors Passed 1 test

🔹 Test weight: 20 | A shallow check that no browser errors were triggered
No browser issues were found

Optimizations

Plugin configuration Passed 29 tests

readme.txt Passed 16 tests

The readme.txt file is undoubtedly the most important file in your plugin, preparing it for public listing on WordPress.org
No tags were detected

sql-table-lookup/sql-table-lookup.php Passed 13 tests

The primary PHP file in "SQL Table Lookup" version 0.1 is used by WordPress to initiate all plugin functionality
98 characters long description:
You can use these SQL lookup shortcodes to extract data from any table in your WordPress database:

Code Analysis Passed 3 tests

File types Passed 1 test

🔸 Test weight: 35 | A short check of programming languages and file extensions; no executable files are allowed
Success! There were no dangerous files found in this plugin26 lines of code in 1 file:
LanguageFilesBlank linesComment linesLines of code
PHP1141726

PHP code Passed 2 tests

An overview of cyclomatic complexity and code structure
This plugin has no cyclomatic complexity issues
Cyclomatic complexity
Average complexity per logical line of code0.12
Average class complexity0.00
▷ Minimum class complexity0.00
▷ Maximum class complexity0.00
Average method complexity0.00
▷ Minimum method complexity0.00
▷ Maximum method complexity0.00
Code structure
Namespaces0
Interfaces0
Traits0
Classes0
▷ Abstract classes00.00%
▷ Concrete classes00.00%
▷ Final classes00.00%
Methods0
▷ Static methods00.00%
▷ Public methods00.00%
▷ Protected methods00.00%
▷ Private methods00.00%
Functions1
▷ Named functions1100.00%
▷ Anonymous functions00.00%
Constants2
▷ Global constants2100.00%
▷ Class constants00.00%
▷ Public constants00.00%

Plugin size Passed 2 tests

Image compression Passed 2 tests

It is recommended to compress PNG files in your plugin to minimize bandwidth usage
PNG images were not found in this plugin