72% ob-db-excel-converter

Code Review | OB DB Excel Converter

WordPress plugin OB DB Excel Converter scored72%from 54 tests.

About plugin

  • Plugin page: ob-db-excel-conve...
  • Plugin version: 2.1
  • PHP version: 7.4.16
  • WordPress compatibility: 2.9.0-5.5.1
  • WordPress version: 6.3.1
  • First release: Dec 9, 2017
  • Latest release: Oct 27, 2020
  • Number of updates: 10
  • Update frequency: every 105.5 days
  • Top authors: oudaryamayburai (100%)

Code review

54 tests

User reviews

1 review

Install metrics

80+ active /1,560 total downloads

Benchmarks

Plugin footprint 83% 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.06MB] [CPU: ▼3.16ms] Passed 4 tests

A check of server-side resources used by OB DB Excel Converter
This plugin does not affect your website's performance
PageMemory (MB)CPU Time (ms)
Home /3.51 ▲0.0536.58 ▼1.90
Dashboard /wp-admin3.36 ▲0.0645.38 ▼0.79
Posts /wp-admin/edit.php3.41 ▲0.0646.58 ▼2.68
Add New Post /wp-admin/post-new.php5.94 ▲0.0686.66 ▼7.27
Media Library /wp-admin/upload.php3.28 ▲0.0637.63 ▲3.00
Promotion /wp-admin/admin.php?page=odec-promotion3.2529.08
Run SQL /wp-admin/admin.php?page=SQLDbExcelConverter3.3027.95
OB DB Excel Converter /wp-admin/admin.php?page=DbExcelConverter3.2629.48

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

Filesystem and database footprint
There were no storage issued detected upon installing this plugin
Filesystem: 26 new files
Database: no new tables, 6 new options
New WordPress options
can_compress_scripts
theysaidso_admin_options
db_upgraded
widget_recent-comments
widget_theysaidso_widget
widget_recent-posts

Browser metrics Passed 4 tests

OB DB Excel Converter: an overview of browser usage
Minimal impact on browser resources
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /2,855 ▲10913.24 ▼1.164.88 ▲2.9940.46 ▼1.82
Dashboard /wp-admin2,239 ▲545.86 ▼0.07101.49 ▼1.4169.09 ▲26.31
Posts /wp-admin/edit.php2,122 ▲331.97 ▼0.2140.33 ▼0.4933.91 ▲1.27
Add New Post /wp-admin/post-new.php1,548 ▲3418.28 ▲0.85734.91 ▲47.3363.42 ▲13.01
Media Library /wp-admin/upload.php1,415 ▲274.10 ▼0.08111.55 ▲8.9180.62 ▲36.11
Promotion /wp-admin/admin.php?page=odec-promotion8392.0222.7234.29
Run SQL /wp-admin/admin.php?page=SQLDbExcelConverter7187.40373.2232.72
OB DB Excel Converter /wp-admin/admin.php?page=DbExcelConverter7587.35324.2526.01

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
The following items require your attention
  • The uninstall procedure has failed, leaving 6 options in the database
    • widget_theysaidso_widget
    • db_upgraded
    • can_compress_scripts
    • widget_recent-comments
    • widget_recent-posts
    • theysaidso_admin_options

Smoke tests 25% from 4 tests

Server-side errors 0% from 1 test

🔹 Test weight: 20 | A smoke test targeting server-side errors
These errors were triggered by the plugin
  • 12 occurences, only the last one shown
    • > GET request to /wp-admin/admin.php?page=DbExcelConverter
    • > Notice in wp-content/plugins/ob-db-excel-converter/ob-db_excel_converter.php+145
    Undefined index: table_name

SRP 0% from 2 tests

🔹 Tests weight: 20 | The single-responsibility principle: PHP files have to remain inert when accessed directly, throwing no errors and performing no actions
Please fix the following
  • 1× PHP files perform the task of outputting text when accessed with GET requests:
    • > /wp-content/plugins/ob-db-excel-converter/includes/promote/promote.php
  • 1× GET requests to PHP files have triggered server-side errors or warnings:
    • > PHP Fatal error
      Uncaught Error: Call to undefined function plugin_dir_path() in wp-content/plugins/ob-db-excel-converter/ob-db_excel_converter.php:18

User-side errors Passed 1 test

🔹 Test weight: 20 | This is just a short smoke test looking for browser issues
No browser errors were detected

Optimizations

Plugin configuration 90% from 29 tests

readme.txt 94% from 16 tests

You should put a lot of thought into formatting readme.txt as it is used by WordPress.org to prepare the public listing of your plugin
Attributes that need to be fixed:
  • Tags: Too many tags (11 tag instead of maximum 10); only the first 5 tags are used in your directory listing
You can take inspiration from this readme.txt

ob-db-excel-converter/ob-db_excel_converter.php 85% from 13 tests

This is the main PHP file of "OB DB Excel Converter" version 2.1, providing information about the plugin in the header fields and serving as the principal entry point to the plugin's functions
Please take the time to fix the following:
  • Description: Please don't use more than 140 characters for the plugin description (currently 220 characters long)
  • Main file name: Please rename the main PHP file in this plugin to the plugin slug ("ob-db-excel-converter.php" instead of "ob-db_excel_converter.php")

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
Everything looks great! No dangerous files found in this plugin8,579 lines of code in 21 files:
LanguageFilesBlank linesComment linesLines of code
JavaScript112,1071,9017,587
CSS64627634
PHP42534358

PHP code Passed 2 tests

A short review of cyclomatic complexity and code structure
All good! No complexity issues found
Cyclomatic complexity
Average complexity per logical line of code0.35
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%
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

Using a strong compression for your PNG files is a great way to speed-up your plugin
2 PNG files occupy 0.02MB with 0.01MB in potential savings
Potential savings
Compression of 2 random PNG files using pngquant
FileSize - originalSize - compressedSavings
assets/image/ob-home-icon.png19.25KB12.92KB▼ 32.87%
assets/image/ob-db_excel_converter_logo.png3.03KB0.40KB▼ 86.68%