70% wpdtol-database-table-overview-logs

Code Review | Database Table Overview and Logs

WordPress plugin Database Table Overview and Logs scored70%from 54 tests.

About plugin

  • Plugin page: wpdtol-database-t...
  • Plugin version: 1.1.2
  • PHP compatiblity: 7.4.0+
  • PHP version: 7.4.16
  • WordPress compatibility: 6.1.0-6.3.1
  • WordPress version: 6.3.1
  • First release: Mar 7, 2023
  • Latest release: Sep 19, 2023
  • Number of updates: 5
  • Update frequency: every 39.2 days
  • Top authors: ninetyninew (100%)

Code review

54 tests

User reviews

1 review

Install metrics

20+ active /614 total downloads

Benchmarks

Plugin footprint 48% from 16 tests

Installer Passed 1 test

🔺 Critical test (weight: 50) | The install procedure must perform silently
This plugin's installer ran successfully

Server metrics [RAM: ▲0.54MB] [CPU: ▲3.49ms] Passed 4 tests

A check of server-side resources used by Database Table Overview and Logs
This plugin has minimal impact on server resources
PageMemory (MB)CPU Time (ms)
Home /4.06 ▲0.6044.39 ▲1.75
Dashboard /wp-admin3.90 ▲0.6052.85 ▲4.93
Posts /wp-admin/edit.php3.96 ▲0.6049.30 ▲4.77
Add New Post /wp-admin/post-new.php6.42 ▲0.5487.62 ▲2.52
Media Library /wp-admin/upload.php3.66 ▲0.4437.08 ▲5.13
Freemius Debug [v.2.5.12] /wp-admin/admin.php?page=freemius4.0140.17

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

Input-output and database impact of this plugin
The plugin installed successfully
Filesystem: 279 new files
Database: 1 new table, 10 new options
New tables
wp_wpdtol_database_table_overview_logs
New WordPress options
theysaidso_admin_options
fs_accounts
wpdtol_database_table_overview_logs_version
widget_theysaidso_widget
widget_recent-posts
db_upgraded
fs_debug_mode
can_compress_scripts
widget_recent-comments
fs_active_plugins

Browser metrics Passed 4 tests

An overview of browser requirements for Database Table Overview and Logs
This plugin has a minimal impact on browser resources
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /2,834 ▲7713.20 ▼1.171.78 ▼0.2731.82 ▼17.46
Dashboard /wp-admin2,240 ▲515.83 ▲0.91116.24 ▼1.1445.67 ▲1.30
Posts /wp-admin/edit.php2,123 ▲342.02 ▲0.0436.30 ▼4.3834.63 ▼2.77
Add New Post /wp-admin/post-new.php1,532 ▲1223.07 ▼0.04667.09 ▲22.0165.31 ▲6.77
Media Library /wp-admin/upload.php1,425 ▲374.21 ▼0.0396.83 ▼3.3243.62 ▼1.07
Freemius Debug [v.2.5.12] /wp-admin/admin.php?page=freemius1,0891.8535.8341.89

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

🔸 Tests weight: 35 | Verifying that this plugin uninstalls completely without leaving any traces
You still need to fix the following
  • This plugin cannot be uninstalled
    • > Notice in wp-content/plugins/wpdtol-database-table-overview-logs/freemius/includes/class-freemius.php+8515
    Undefined property: stdClass::$plugins
  • Zombie tables were found after uninstall: 1 table
    • wp_wpdtol_database_table_overview_logs
  • Zombie WordPress options detected upon uninstall: 10 options
    • widget_theysaidso_widget
    • fs_accounts
    • wpdtol_database_table_overview_logs_version
    • widget_recent-posts
    • widget_recent-comments
    • can_compress_scripts
    • fs_active_plugins
    • fs_debug_mode
    • db_upgraded
    • theysaidso_admin_options

Smoke tests Passed 4 tests

Server-side errors Passed 1 test

🔹 Test weight: 20 | A shallow check that no server-side errors were triggered
Good news, no errors were detected

SRP Passed 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
No output text or server-side errors detected on direct access of PHP files

User-side errors Passed 1 test

🔹 Test weight: 20 | This is just a short smoke test looking for browser issues
Everything seems fine on the user side

Optimizations

Plugin configuration Passed 29 tests

readme.txt Passed 16 tests

The readme.txt file is important because it is parsed by WordPress.org for the public listing of your plugin
5 plugin tags: database, database log, log, database table, table

wpdtol-database-table-overview-logs/wpdtol-database-table-overview-logs.php Passed 13 tests

The principal PHP file in "Database Table Overview and Logs" v. 1.1.2 is loaded by WordPress automatically on each request
24 characters long description:
WordPress Plugin by 99w.

Code Analysis 97% from 3 tests

File types Passed 1 test

🔸 Test weight: 35 | A short review of files and their extensions; it is not recommended to include executable files
Success! There were no dangerous files found in this plugin73,980 lines of code in 221 files:
LanguageFilesBlank linesComment linesLines of code
PHP1188,03017,23433,492
JavaScript498,08220,79632,168
CSS48257797,866
Sass36110388
XML29355
JSON10011

PHP code 50% from 2 tests

Analyzing cyclomatic complexity and code structure
It is recommended to fix the following
  • Cyclomatic complexity of classes should be reduced to less than 1000 (currently 3,088)
Cyclomatic complexity
Average complexity per logical line of code0.63
Average class complexity92.20
▷ Minimum class complexity1.00
▷ Maximum class complexity3,088.00
Average method complexity4.58
▷ Minimum method complexity1.00
▷ Maximum method complexity94.00
Code structure
Namespaces0
Interfaces0
Traits0
Classes49
▷ Abstract classes24.08%
▷ Concrete classes4795.92%
▷ Final classes00.00%
Methods1,275
▷ Static methods19815.53%
▷ Public methods88569.41%
▷ Protected methods171.33%
▷ Private methods37329.25%
Functions99
▷ Named functions99100.00%
▷ Anonymous functions00.00%
Constants146
▷ Global constants9967.81%
▷ Class constants4732.19%
▷ Public constants47100.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
8 compressed PNG files occupy 0.05MB
Potential savings
Compression of 5 random PNG files using pngquant
FileSize - originalSize - compressedSavings
libraries/DataTables/DataTables-1.13.2/images/sort_asc_disabled.png0.14KB0.25KB0.00%
libraries/DataTables/DataTables-1.13.2/images/sort_asc.png0.16KB0.25KB0.00%
libraries/DataTables/DataTables-1.13.2/images/sort_desc_disabled.png0.14KB0.25KB0.00%
freemius/assets/img/wpdtol-database-table-overview-logs.png34.18KB19.91KB▼ 41.75%
libraries/DataTables/DataTables-1.13.2/images/sort_desc.png0.15KB0.25KB0.00%