10% myeasydb

Code Review | myEASYdb

WordPress plugin myEASYdb scored10%from 54 tests.

About plugin

  • Plugin page: myeasydb
  • Plugin version: 0.0.6
  • PHP version: 7.4.16
  • WordPress compatibility: 2.9.1-2.9.2
  • WordPress version: 6.3.1
  • First release: Feb 15, 2010
  • Latest release: Feb 23, 2010
  • Number of updates: 19
  • Update frequency: every 43.4 days
  • Top authors: camaleo (100%)

Code review

54 tests

User reviews

1 review

Install metrics

10+ active /3,669 total downloads

Benchmarks

Plugin footprint 58% from 16 tests

Installer 0% from 1 test

🔺 Critical test (weight: 50) | Checking the installer triggered no errors
Please fix the following installer errors
  • The plugin cannot be installed
    • > Warning in wp-content/plugins/myeasydb/med-config.php+25
    Use of undefined constant AJAX_CALLER - assumed 'AJAX_CALLER' (this will throw an Error in a future version of PHP)

Server metrics [RAM: ▲0.00MB] [CPU: ▼5.04ms] Passed 4 tests

Server-side resources used by myEASYdb
Server-side resource usage in normal parameters
PageMemory (MB)CPU Time (ms)
Home /3.47 ▲0.0038.37 ▼5.50
Dashboard /wp-admin3.31 ▲0.0047.94 ▼5.30
Posts /wp-admin/edit.php3.36 ▲0.0047.24 ▼3.32
Add New Post /wp-admin/post-new.php5.89 ▲0.0090.20 ▼6.02
Media Library /wp-admin/upload.php3.23 ▲0.0037.86 ▼0.70

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

A short overview of filesystem and database impact
The plugin installed successfully
Filesystem: 133 new files
Database: no new tables, 6 new options
New WordPress options
widget_recent-comments
theysaidso_admin_options
can_compress_scripts
db_upgraded
widget_theysaidso_widget
widget_recent-posts

Browser metrics Passed 4 tests

myEASYdb: an overview of browser usage
Minimal impact on browser resources
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /2,800 ▲4314.74 ▲0.451.87 ▼0.0242.72 ▼3.87
Dashboard /wp-admin2,203 ▲155.83 ▲0.94107.88 ▼11.6447.22 ▼2.48
Posts /wp-admin/edit.php2,089 ▼32.05 ▲0.0351.06 ▲13.4837.24 ▲5.20
Add New Post /wp-admin/post-new.php1,533 ▼123.25 ▼0.04619.97 ▼38.8868.27 ▲3.72
Media Library /wp-admin/upload.php1,382 ▼34.18 ▼0.09110.02 ▲5.4143.63 ▼4.52

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
It is recommended to fix the following
  • Zombie WordPress options were found after uninstall: 6 options
    • widget_recent-comments
    • db_upgraded
    • theysaidso_admin_options
    • can_compress_scripts
    • widget_theysaidso_widget
    • widget_recent-posts

Smoke tests 50% from 4 tests

Server-side errors Passed 1 test

🔹 Test weight: 20 | A smoke test targeting server-side errors
Even though no errors were found, this is by no means an exhaustive test

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
Almost there! Just fix the following items
  • 4× PHP files perform the action of outputting non-empty strings when accessed directly:
    • > /wp-content/plugins/myeasydb/ajax_ro.php
    • > /wp-content/plugins/myeasydb/js/myeasydb.js.php
    • > /wp-content/plugins/myeasydb/med_tools.php
    • > /wp-content/plugins/myeasydb/med_startHere.php
  • 24× GET requests to PHP files trigger server-side errors or Error 500 responses (only 10 are shown):
    • > PHP Fatal error
      Uncaught Error: Call to undefined function __() in wp-content/plugins/myeasydb/inc/table_editor.inc.php:34
    • > PHP Notice
      Undefined index: table in wp-content/plugins/myeasydb/table_editor.php on line 29
    • > PHP Fatal error
      require(): Failed opening required 'MED_PATHinc/table_editor.inc.php' (include_path='.:/usr/share/php') in wp-content/plugins/myeasydb/table_editor.php on line 54
    • > PHP Fatal error
      Uncaught Error: Call to undefined function mysql_connect() in wp-content/plugins/myeasydb/inc/MySQL.inc.php:30
    • > PHP Notice
      Undefined index: id in wp-content/plugins/myeasydb/table_editor.php on line 30
    • > PHP Notice
      Undefined index: id in wp-content/plugins/myeasydb/table_editor.php on line 35
    • > PHP Warning
      Use of undefined constant MED_PATH - assumed 'MED_PATH' (this will throw an Error in a future version of PHP) in wp-content/plugins/myeasydb/table_editor.php on line 54
    • > PHP Warning
      Use of undefined constant SITE_ROOT - assumed 'SITE_ROOT' (this will throw an Error in a future version of PHP) in wp-content/plugins/myeasydb/table_editor_ord.php on line 23
    • > PHP Fatal error
      Uncaught Error: Call to undefined function db_query() in wp-content/plugins/myeasydb/med_settings.php:23
    • > PHP Fatal error
      Uncaught Error: Call to undefined function mysql_connect() in wp-content/plugins/myeasydb/inc/MySQL.inc.php:30

User-side errors Passed 1 test

🔹 Test weight: 20 | This is a smoke test targeting browser errors/issues
Everything seems fine, but this is not an exhaustive test

Optimizations

Plugin configuration 97% from 29 tests

readme.txt 94% from 16 tests

The readme.txt file describes your plugin functionality and requirements and it is parsed to prepare the your plugin's listing
These attributes need your attention:
  • Screenshots: Add images for these screenshots: #1 (Browsing a table), #2 (Editing a record), #3 (Setting up a relation)
Please take inspiration from this readme.txt

myeasydb/myeasydb.php Passed 13 tests

The entry point to "myEASYdb" version 0.0.6 is a PHP file that has certain tags in its header comment area
66 characters long description:
Edit and handle your MySQL tables in the easiest and quickest way.

Code Analysis Passed 3 tests

File types Passed 1 test

🔸 Test weight: 35 | This is an overview of file extensions present in this plugin and a short test that no dangerous files are bundled with this plugin
Success! There were no dangerous files found in this plugin6,896 lines of code in 24 files:
LanguageFilesBlank linesComment linesLines of code
PHP151,2083,7464,058
JavaScript45133112,591
CSS12329214
SQL40133

PHP code Passed 2 tests

An overview of cyclomatic complexity and code structure
There are no cyclomatic complexity problems detected for this plugin
Cyclomatic complexity
Average complexity per logical line of code0.39
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%
Functions76
▷ Named functions76100.00%
▷ Anonymous functions00.00%
Constants76
▷ Global constants76100.00%
▷ Class constants00.00%
▷ Public constants00.00%

Plugin size 50% from 2 tests

Image compression 50% from 2 tests

All PNG images should be compressed to minimize bandwidth usage for end users
92 PNG files occupy 0.71MB with 0.12MB in potential savings
Potential savings
Compression of 5 random PNG files using pngquant
FileSize - originalSize - compressedSavings
img/myEASYdb-32.png1.80KB1.56KB▼ 13.08%
img/paginate/hmnu_prv-on.png0.78KB0.79KB0.00%
img/modules/back-on.png3.52KB1.01KB▼ 71.36%
img/modules/prev18-off.png0.96KB1.25KB0.00%
img/myEASYdb-16.png0.70KB0.69KB▼ 1.12%