83% elisqlreports

Code Review | EZ SQL Reports Shortcode Widget and DB Backup

WordPress plugin EZ SQL Reports Shortcode Widget and DB Backup scored83%from 54 tests.

About plugin

  • Plugin page: elisqlreports
  • Plugin version: 5.21.35
  • PHP version: 7.4.16
  • WordPress compatibility: 2.6-5.8.1
  • WordPress version: 6.3.1
  • First release: Dec 15, 2011
  • Latest release: Sep 5, 2021
  • Number of updates: 37
  • Update frequency: every 96.0 days
  • Top authors: scheeeli (100%)

Code review

54 tests

User reviews

13 reviews

Install metrics

600+ active /19,911 total downloads

Benchmarks

Plugin footprint 83% from 16 tests

Installer Passed 1 test

🔺 Critical test (weight: 50) | It is important to correctly install your plugin, without throwing errors or notices
This plugin's installer ran successfully

Server metrics [RAM: ▲0.31MB] [CPU: ▼3.42ms] Passed 4 tests

An overview of server-side resources used by EZ SQL Reports Shortcode Widget and DB Backup
Server-side resource usage in normal parameters
PageMemory (MB)CPU Time (ms)
Home /3.78 ▲0.3144.28 ▼3.11
Dashboard /wp-admin3.62 ▲0.3147.72 ▼0.44
Posts /wp-admin/edit.php3.73 ▲0.3748.86 ▼1.83
Add New Post /wp-admin/post-new.php6.20 ▲0.3193.88 ▼5.62
Media Library /wp-admin/upload.php3.54 ▲0.3136.94 ▼3.10
Plugin Settings /wp-admin/admin.php?page=ELISQLREPORTS-settings3.4938.85
Create Report /wp-admin/admin.php?page=ELISQLREPORTS-create-report3.5239.83

Server storage [IO: ▲0.07MB] [DB: ▲0.00MB] Passed 3 tests

A short overview of filesystem and database impact
This plugin installed successfully
Filesystem: 7 new files
Database: no new tables, 9 new options
New WordPress options
widget_recent-posts
ELISQLREPORTS_settings_array
widget_elisqlreports-widget
ELISQLREPORTS_BACKUP_DB
theysaidso_admin_options
widget_recent-comments
db_upgraded
widget_theysaidso_widget
can_compress_scripts

Browser metrics Passed 4 tests

A check of browser resources used by EZ SQL Reports Shortcode Widget and DB Backup
Minimal impact on browser resources
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /2,821 ▲6014.28 ▲0.061.90 ▼0.0741.19 ▼0.00
Dashboard /wp-admin2,230 ▲535.67 ▲0.0288.75 ▲1.3870.84 ▲31.14
Posts /wp-admin/edit.php2,135 ▲351.97 ▼0.0538.48 ▼3.0533.97 ▼7.64
Add New Post /wp-admin/post-new.php1,568 ▲4023.08 ▲0.01691.42 ▲22.1452.80 ▼2.02
Media Library /wp-admin/upload.php1,429 ▲324.18 ▼0.07105.85 ▼5.2275.46 ▲27.75
Plugin Settings /wp-admin/admin.php?page=ELISQLREPORTS-settings1,0262.0525.4125.65
Create Report /wp-admin/admin.php?page=ELISQLREPORTS-create-report1,0742.2132.6331.77

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

🔸 Tests weight: 35 | All plugins must uninstall correctly, removing their source code and extra database tables they might have created
Please fix the following items
  • Zombie WordPress options detected upon uninstall: 9 options
    • widget_recent-posts
    • can_compress_scripts
    • widget_theysaidso_widget
    • ELISQLREPORTS_settings_array
    • db_upgraded
    • widget_elisqlreports-widget
    • widget_recent-comments
    • ELISQLREPORTS_BACKUP_DB
    • theysaidso_admin_options

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
Even though everything seems fine, this is not an exhaustive test

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
Almost there! Just fix the following items
  • 2× PHP files output text when accessed directly:
    • > /wp-content/plugins/elisqlreports/images/index.php
    • > /wp-content/plugins/elisqlreports/index.php

User-side errors Passed 1 test

🔹 Test weight: 20 | Just a short smoke test targeting errors on the browser (console and network errors and warnings)
Everything seems fine, but this is not an exhaustive test

Optimizations

Plugin configuration 90% from 29 tests

readme.txt 94% from 16 tests

The readme.txt file is important because it is parsed by WordPress.org for the public listing of your plugin
These attributes need to be fixed:
  • Tags: You are using too many tags: 13 tag instead of maximum 10
The official readme.txt is a good inspiration

elisqlreports/index.php 85% from 13 tests

This is the main PHP file of "EZ SQL Reports Shortcode Widget and DB Backup" version 5.21.35, providing information about the plugin in the header fields and serving as the principal entry point to the plugin's functions
The following require your attention:
  • Main file name: Even though not officially enforced, the main plugin file should be the same as the plugin slug ("elisqlreports.php" instead of "index.php")
  • Description: The description should be shorter than 140 characters (currently 231 characters long)

Code Analysis Passed 3 tests

File types Passed 1 test

🔸 Test weight: 35 | There should be no dangerous file extensions present in any WordPress plugin
Success! There were no dangerous files found in this plugin966 lines of code in 3 files:
LanguageFilesBlank linesComment linesLines of code
PHP22135932
CSS19034

PHP code Passed 2 tests

An short overview of logical lines of code, cyclomatic complexity, and other code metrics
Great job! No cyclomatic complexity issues were detected in this plugin
Cyclomatic complexity
Average complexity per logical line of code0.77
Average class complexity10.00
▷ Minimum class complexity10.00
▷ Maximum class complexity10.00
Average method complexity2.80
▷ Minimum method complexity1.00
▷ Maximum method complexity7.00
Code structure
Namespaces0
Interfaces0
Traits0
Classes1
▷ Abstract classes00.00%
▷ Concrete classes1100.00%
▷ Final classes00.00%
Methods5
▷ Static methods00.00%
▷ Public methods5100.00%
▷ Protected methods00.00%
▷ Private methods00.00%
Functions28
▷ Named functions2796.43%
▷ Anonymous functions13.57%
Constants0
▷ Global constants00.00%
▷ Class constants00.00%
▷ Public constants00.00%

Plugin size Passed 2 tests

Image compression Passed 2 tests

PNG files should be compressed to save space and minimize bandwidth usage
There are no PNG files in this plugin