83% elisqlreports

Code Review | EZ SQL Reports Shortcode Widget and DB Backup

WordPress plugin EZ SQL Reports Shortcode Widget and DB Backup scored 83% 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: 5.9.2
  • 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

800+ active / 18,652 total downloads

Benchmarks

Plugin footprint 83% from 16 tests

Installer Passed 1 test

🔺 Critical test (weight: 50) | Checking the installer triggered no errors
Installer ran successfully

Server metrics [RAM: ▲0.29MB] [CPU: ▼287.77ms] Passed 4 tests

Analyzing server-side resources used by EZ SQL Reports Shortcode Widget and DB Backup
This plugin does not affect your website's performance
PageMemory (MB)CPU Time (ms)
Home /3.90 ▲0.3855.51 ▼1.26
Dashboard /wp-admin3.73 ▲0.3279.15 ▲42.88
Posts /wp-admin/edit.php3.96 ▲0.3148.19 ▲3.30
Add New Post /wp-admin/post-new.php7.20 ▲0.23102.47 ▼1,153.03
Media Library /wp-admin/upload.php3.61 ▲0.3129.09 ▼0.07
Plugin Settings /wp-admin/admin.php?page=ELISQLREPORTS-settings3.5737.13
Create Report /wp-admin/admin.php?page=ELISQLREPORTS-create-report3.6038.06

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

Analyzing filesystem and database footprints of this plugin
No storage issues were detected
Filesystem: 7 new files
Database: no new tables, 3 new options
New WordPress options
ELISQLREPORTS_BACKUP_DB
widget_elisqlreports-widget
ELISQLREPORTS_settings_array

Browser metrics Passed 4 tests

EZ SQL Reports Shortcode Widget and DB Backup: an overview of browser usage
There were no issues detected in relation to browser resource usage
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /3,801 ▲5716.14 ▲0.395.81 ▼0.052.18 ▼0.17
Dashboard /wp-admin2,933 ▲756.16 ▼0.01116.73 ▼28.58176.22 ▼40.57
Posts /wp-admin/edit.php2,697 ▲33.14 ▼0.1064.34 ▲2.87220.62 ▲73.28
Add New Post /wp-admin/post-new.php1,716 ▲2620.63 ▲0.10443.44 ▲4.45157.42 ▼4.13
Media Library /wp-admin/upload.php1,734 ▲365.51 ▼0.02154.15 ▼6.11192.32 ▲12.30
Plugin Settings /wp-admin/admin.php?page=ELISQLREPORTS-settings1,2922.3852.81124.44
Create Report /wp-admin/admin.php?page=ELISQLREPORTS-create-report1,3502.8656.60130.34

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
You still need to fix the following
  • The uninstall procedure has failed, leaving 3 options in the database
    • widget_elisqlreports-widget
    • ELISQLREPORTS_BACKUP_DB
    • ELISQLREPORTS_settings_array

Smoke tests 75% from 4 tests

Server-side errors Passed 1 test

🔹 Test weight: 20 | A smoke test targeting server-side errors
Good news, no errors were detected

SRP 50% from 2 tests

🔹 Tests weight: 20 | SRP (Single-Responsibility Principle) - PHP files must act as libraries and never output text or perform any action when accessed directly in a browser
Please fix the following
  • 2× PHP files output non-empty strings when accessed directly via GET requests:
    • > /wp-content/plugins/elisqlreports/index.php
    • > /wp-content/plugins/elisqlreports/images/index.php

User-side errors Passed 1 test

🔹 Test weight: 20 | This is just a short smoke test looking for browser issues
There were no browser issues found

Optimizations

Plugin configuration 90% from 29 tests

readme.txt 94% from 16 tests

The readme.txt file is undoubtedly the most important file in your plugin, preparing it for public listing on WordPress.org
These attributes need to be fixed:
  • Tags: You are using too many tags: 13 tag instead of maximum 10
The official readme.txt might help

elisqlreports/index.php 85% from 13 tests

"EZ SQL Reports Shortcode Widget and DB Backup" version 5.21.35's primary PHP file adds more information about the plugin and serves as the entry point for WordPress
Please take the time to fix the following:
  • Main file name: Name the main plugin file 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 | This is a short overview of programming languages used in this plugin, detecting executable files
Good job! No executable or dangerous file extensions detected966 lines of code in 3 files:
LanguageFilesBlank linesComment linesLines of code
PHP22135932
CSS19034

PHP code Passed 2 tests

A short review of cyclomatic complexity and code structure
Everything seems fine, there were no complexity issues found
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
No PNG files were detected