84% hlc-sql-window

Code Review | HLC_sql_window

WordPress plugin HLC_sql_window scored84%from 54 tests.

About plugin

  • Plugin page: hlc-sql-window
  • Plugin version: 1.0.1
  • PHP version: 7.4.16
  • WordPress compatibility: 3.0.1-4.5
  • WordPress version: 6.3.1
  • First release: Jul 10, 2015
  • Latest release: Apr 23, 2016
  • Number of updates: 8
  • Update frequency: every 36.1 days
  • Top authors: hlcsoftware (100%)

Code review

54 tests

User reviews

1 review

Install metrics

10+ active /995 total downloads

Benchmarks

Plugin footprint 82% from 16 tests

Installer Passed 1 test

🔺 Critical test (weight: 50) | All plugins must install correctly, without throwing any errors, warnings, or notices
The plugin installed successfully, without throwing any errors or notices

Server metrics [RAM: ▲0.02MB] [CPU: ▲3.18ms] Passed 4 tests

An overview of server-side resources used by HLC_sql_window
Normal server usage
PageMemory (MB)CPU Time (ms)
Home /3.48 ▲0.0246.24 ▲3.29
Dashboard /wp-admin3.32 ▲0.0255.71 ▲1.01
Posts /wp-admin/edit.php3.37 ▲0.0153.82 ▲4.43
Add New Post /wp-admin/post-new.php5.92 ▲0.0397.61 ▲3.97
Media Library /wp-admin/upload.php3.24 ▲0.0139.98 ▲5.55

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

How much does this plugin use your filesystem and database?
It is recommended to fix the following issues
  • Illegal file modification detected: 1 file (0.00KB) outside of "wp-content/plugins/hlc-sql-window/" and "wp-content/uploads/"
    • (new file) hlc_export/.empty
Filesystem: 22 new files
Database: 1 new table, 6 new options
New tables
hlc_Queries
New WordPress options
widget_recent-comments
can_compress_scripts
widget_recent-posts
db_upgraded
widget_theysaidso_widget
theysaidso_admin_options

Browser metrics Passed 4 tests

A check of browser resources used by HLC_sql_window
There were no issues detected in relation to browser resource usage
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /2,887 ▲14113.60 ▼0.6610.14 ▲8.0147.72 ▲4.95
Dashboard /wp-admin2,210 ▲224.86 ▼0.04123.69 ▲9.2044.95 ▲5.42
Posts /wp-admin/edit.php2,093 ▲12.00 ▼0.0339.46 ▼2.0136.19 ▲2.68
Add New Post /wp-admin/post-new.php1,518 ▼1522.95 ▼0.23649.22 ▲2.3048.18 ▼2.34
Media Library /wp-admin/upload.php1,386 ▼24.13 ▼0.10104.89 ▼1.7445.69 ▲2.16

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

🔸 Tests weight: 35 | Checking the uninstaller removed all traces of the plugin
It is recommended to fix the following
  • This plugin does not fully uninstall, leaving 6 options in the database
    • widget_recent-comments
    • can_compress_scripts
    • theysaidso_admin_options
    • widget_recent-posts
    • widget_theysaidso_widget
    • db_upgraded

Smoke tests 75% from 4 tests

Server-side errors Passed 1 test

🔹 Test weight: 20 | This is a short smoke test looking for server-side errors
Good news, no errors were detected

SRP 50% from 2 tests

🔹 Tests weight: 20 | The single-responsibility principle applies for WordPress plugins as well - please make sure your PHP files perform no actions when accessed directly
Please fix the following
  • 2× PHP files output text when accessed directly:
    • > /wp-content/plugins/hlc-sql-window/admin/partials/hlc-sql-window-admin-display.php
    • > /wp-content/plugins/hlc-sql-window/public/partials/hlc-sql-window-public-display.php

User-side errors Passed 1 test

🔹 Test weight: 20 | A shallow check that no browser errors were triggered
Everything seems fine on the user side

Optimizations

Plugin configuration 97% from 29 tests

readme.txt 94% from 16 tests

It's important to format your readme.txt file correctly as it is parsed for the public listing of your plugin
These attributes need to be fixed:
  • Plugin Name: "Plugin Name" should be replaced with the name of your plugin on the first line ( === hlc-sql-window === )
You can look at the official readme.txt

hlc-sql-window/hlc-sql-window.php Passed 13 tests

The entry point to "HLC_sql_window" version 1.0.1 is a PHP file that has certain tags in its header comment area
41 characters long description:
This plugin provides an SQL Command page.

Code Analysis Passed 3 tests

File types Passed 1 test

🔸 Test weight: 35 | This is an overview of programming languages used in this plugin; dangerous file extensions are not allowed
Success! There were no dangerous files found in this plugin429 lines of code in 16 files:
LanguageFilesBlank linesComment linesLines of code
PHP12126557423
JavaScript24546
CSS2080

PHP code Passed 2 tests

Analyzing cyclomatic complexity and code structure
No complexity issues detected
Cyclomatic complexity
Average complexity per logical line of code0.23
Average class complexity6.00
▷ Minimum class complexity1.00
▷ Maximum class complexity29.00
Average method complexity1.95
▷ Minimum method complexity1.00
▷ Maximum method complexity10.00
Code structure
Namespaces0
Interfaces0
Traits0
Classes7
▷ Abstract classes00.00%
▷ Concrete classes7100.00%
▷ Final classes00.00%
Methods37
▷ Static methods25.41%
▷ Public methods3286.49%
▷ Protected methods00.00%
▷ Private methods513.51%
Functions4
▷ Named functions4100.00%
▷ Anonymous functions00.00%
Constants0
▷ Global constants00.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
No PNG images were found in this plugin