78% create-db-tables

Code Review | Create DB Tables

WordPress plugin Create DB Tables scored78%from 54 tests.

About plugin

  • Plugin page: create-db-tables
  • Plugin version: 1.2.1
  • PHP version: 7.4.16
  • WordPress compatibility: 3.0.1-4.5.3
  • WordPress version: 6.3.1
  • First release: Nov 18, 2015
  • Latest release: May 28, 2016
  • Number of updates: 43
  • Update frequency: every 4.5 days
  • Top authors: jppreus (100%)

Code review

54 tests

User reviews

1 review

Install metrics

40+ active /4,742 total downloads

Benchmarks

Plugin footprint 83% from 16 tests

Installer Passed 1 test

🔺 Critical test (weight: 50) | The install procedure must perform silently
The plugin installed gracefully, with no errors

Server metrics [RAM: ▲0.01MB] [CPU: ▼7.33ms] Passed 4 tests

Analyzing server-side resources used by Create DB Tables
No issues were detected with server-side resource usage
PageMemory (MB)CPU Time (ms)
Home /3.47 ▲0.0142.89 ▼4.11
Dashboard /wp-admin3.31 ▲0.0149.70 ▼1.05
Posts /wp-admin/edit.php3.36 ▲0.0143.42 ▼7.05
Add New Post /wp-admin/post-new.php5.89 ▲0.0182.10 ▼14.96
Media Library /wp-admin/upload.php3.24 ▲0.0135.20 ▼3.19
Create DB Tables /wp-admin/admin.php?page=create-db-tables3.1831.14
Add New Table /wp-admin/admin.php?page=add-new-table3.2029.69

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

A short overview of filesystem and database impact
No storage issues were detected
Filesystem: 7 new files
Database: no new tables, 6 new options
New WordPress options
widget_recent-comments
widget_recent-posts
db_upgraded
theysaidso_admin_options
widget_theysaidso_widget
can_compress_scripts

Browser metrics Passed 4 tests

Create DB Tables: an overview of browser usage
This plugin has a minimal impact on browser resources
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /2,823 ▲7713.28 ▼1.091.91 ▼0.4652.05 ▲3.98
Dashboard /wp-admin2,229 ▲414.81 ▼1.25126.12 ▲14.3043.65 ▼6.79
Posts /wp-admin/edit.php2,112 ▲232.05 ▲0.0537.83 ▼2.5834.94 ▼2.86
Add New Post /wp-admin/post-new.php1,555 ▲2223.29 ▲0.14644.39 ▼59.0752.00 ▼2.53
Media Library /wp-admin/upload.php1,414 ▲234.20 ▼0.1997.78 ▼12.3243.86 ▼6.96
Create DB Tables /wp-admin/admin.php?page=create-db-tables8332.0628.0028.57
Add New Table /wp-admin/admin.php?page=add-new-table8741.7125.3026.85

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

🔸 Tests weight: 35 | It is important to correctly uninstall your plugin, without leaving any traces
These items require your attention
  • Zombie WordPress options detected upon uninstall: 6 options
    • can_compress_scripts
    • widget_recent-comments
    • widget_recent-posts
    • db_upgraded
    • theysaidso_admin_options
    • widget_theysaidso_widget

Smoke tests 50% from 4 tests

Server-side errors 0% from 1 test

🔹 Test weight: 20 | A smoke test targeting server-side errors
These server-side errors were triggered
  • 3 occurences, only the last one shown
    • > GET request to /wp-admin/admin.php?page=create-db-tables
    • > Deprecated in wp-content/plugins/create-db-tables/create-db-tables.php+102
    parse_str(): Calling parse_str() without the result argument is deprecated
    • > GET request to /wp-admin/admin.php?page=create-db-tables
    • > Notice in wp-content/plugins/create-db-tables/create-db-tables.php+78
    Undefined variable: table_name
    • > GET request to /wp-admin/admin.php?page=create-db-tables
    • > Notice in wp-content/plugins/create-db-tables/create-db-tables.php+103
    Undefined variable: create_new_table_success

SRP 50% from 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
Please take a closer look at the following
  • 1× PHP files output non-empty strings when accessed directly via GET requests:
    • > /wp-content/plugins/create-db-tables/create-db-tables.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)
No browser errors were detected

Optimizations

Plugin configuration 96% from 29 tests

readme.txt Passed 16 tests

Don't ignore readme.txt as it is the file that instructs WordPress.org on how to present your plugin to the world
6 plugin tags: database, sql, wpdb, phpmyadmin, tables...

create-db-tables/create-db-tables.php 92% from 13 tests

The main PHP file in "Create DB Tables" ver. 1.2.1 adds more information about the plugin and also serves as the entry point for this plugin
Please take the time to fix the following:
  • Description: If Twitter did it, so should we! Keep the description under 140 characters (currently 527 characters long)

Code Analysis Passed 3 tests

File types Passed 1 test

🔸 Test weight: 35 | Executable files are not allowed as they can serve as attack vectors
Good job! No executable or dangerous file extensions detected469 lines of code in 6 files:
LanguageFilesBlank linesComment linesLines of code
PHP615697469

PHP code Passed 2 tests

Analyzing logical lines of code, cyclomatic complexity, and other code metrics
This plugin has no cyclomatic complexity problems
Cyclomatic complexity
Average complexity per logical line of code0.23
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%
Functions11
▷ Named functions11100.00%
▷ Anonymous functions00.00%
Constants1
▷ Global constants1100.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
There were not PNG files found in your plugin