67% advanced-cf7-db

Code Review | Advanced Contact form 7 DB

WordPress plugin Advanced Contact form 7 DB scored 67% from 54 tests.

About plugin

  • Plugin page: advanced-cf7-db
  • Plugin version: 1.8.7
  • PHP version: 7.4.16
  • WordPress compatibility: 4.0-5.9
  • WordPress version: 5.8.1
  • First release: Jul 13, 2017
  • Latest release: Feb 22, 2022
  • Number of updates: 57
  • Update frequency: every 29.6 days
  • Top authors: vsourz1td (100%)

Code review

54 tests

User reviews

35 reviews

Install metrics

90,000+ active / 518,631 total downloads

Benchmarks

Plugin footprint 65% from 16 tests

Installer Passed 1 test

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

Server metrics [RAM: ▲0.40MB] [CPU: ▼147.40ms] Passed 4 tests

This is a short check of server-side resources used by Advanced Contact form 7 DB
Server-side resource usage in normal parameters
PageMemory (MB)CPU Time (ms)
Home /3.22 ▲0.3829.62 ▲2.94
Dashboard /wp-admin3.51 ▲0.4536.66 ▼10.82
Posts /wp-admin/edit.php3.56 ▲0.4539.52 ▲3.08
Add New Post /wp-admin/post-new.php5.81 ▲0.3775.63 ▼584.78
Media Library /wp-admin/upload.php3.39 ▲0.3931.32 ▲6.32

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

How much does this plugin use your filesystem and database?
The plugin installed successfully
Filesystem: 305 new files
Database: 2 new tables, 1 new option
New tables
wp_cf7_vdata
wp_cf7_vdata_entry
New WordPress options
vsz_cf7_db_version

Browser metrics Passed 4 tests

Checking browser requirements for Advanced Contact form 7 DB
There were no issues detected in relation to browser resource usage
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /3,666 ▲6515.53 ▼0.427.64 ▼1.8471.47 ▼1.17
Dashboard /wp-admin2,930 ▲316.15 ▲0.00114.44 ▼16.84165.45 ▼8.03
Posts /wp-admin/edit.php2,706 ▼343.37 ▲0.0165.15 ▲1.60136.04 ▲0.33
Add New Post /wp-admin/post-new.php3,736 ▼7118.08 ▼0.98427.02 ▼44.34158.52 ▼5.67
Media Library /wp-admin/upload.php1,749 ▼05.53 ▲0.01147.15 ▲11.01195.64 ▲9.82

Uninstaller [IO: ▲0.00MB] [DB: ▲0.00MB] 50% 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 failed, leaving 2 tables in the database
    • wp_cf7_vdata_entry
    • wp_cf7_vdata
  • This plugin did not uninstall successfully, leaving 1 option in the database
    • vsz_cf7_db_version

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 | It is important to ensure that your PHP files perform no action when accessed directly, respecting the single-responsibility principle
Please take a closer look at the following
  • 7× PHP files perform the action of outputting non-empty strings when accessed directly:
    • > /wp-content/plugins/advanced-cf7-db/admin/partials/import_cf7_entry.class.php
    • > /wp-content/plugins/advanced-cf7-db/admin/partials/import_cf7_csv.php
    • > /wp-content/plugins/advanced-cf7-db/admin/partials/contact_form_listing.php
    • > /wp-content/plugins/advanced-cf7-db/includes/vsz-cf7-db-function.php
    • > /wp-content/plugins/advanced-cf7-db/public/partials/advanced-cf7-db-public-display.php
    • > /wp-content/plugins/advanced-cf7-db/admin/partials/advanced-cf7-db-admin-display.php
    • > /wp-content/plugins/advanced-cf7-db/admin/class/PHPExcel/CachedObjectStorage/SQLite.php
  • 96× PHP files trigger server-side errors or warnings when accessed directly (only 10 are shown):
    • > PHP Fatal error
      Uncaught Error: Class 'PHPExcel_Style_Supervisor' not found in wp-content/plugins/advanced-cf7-db/admin/class/PHPExcel/Style.php:36
    • > PHP Fatal error
      Uncaught Error: Interface 'PHPExcel_Writer_IWriter' not found in wp-content/plugins/advanced-cf7-db/admin/class/PHPExcel/Writer/Abstract.php:36
    • > PHP Fatal error
      Uncaught Error: Class 'PHPExcel_Writer_OpenDocument_WriterPart' not found in wp-content/plugins/advanced-cf7-db/admin/class/PHPExcel/Writer/OpenDocument/Settings.php:37
    • > PHP Fatal error
      Uncaught Error: Interface 'PHPExcel_IComparable' not found in wp-content/plugins/advanced-cf7-db/admin/class/PHPExcel/Worksheet/BaseDrawing.php:36
    • > PHP Fatal error
      Uncaught Error: Interface 'PHPExcel_Reader_IReader' not found in wp-content/plugins/advanced-cf7-db/admin/class/PHPExcel/Reader/Abstract.php:36
    • > PHP Fatal error
      Uncaught Error: Class 'PHPExcel_Writer_Excel2007_WriterPart' not found in wp-content/plugins/advanced-cf7-db/admin/class/PHPExcel/Writer/Excel2007/Chart.php:35
    • > PHP Fatal error
      Uncaught Error: Interface 'PHPExcel_RichText_ITextElement' not found in wp-content/plugins/advanced-cf7-db/admin/class/PHPExcel/RichText/TextElement.php:34
    • > PHP Warning
      Use of undefined constant PHPEXCEL_ROOT - assumed 'PHPEXCEL_ROOT' (this will throw an Error in a future version of PHP) in wp-content/plugins/advanced-cf7-db/admin/class/PHPExcel/Autoloader.php on line 77
    • > PHP Fatal error
      Uncaught Error: Class 'PHPExcel_Writer_OpenDocument_WriterPart' not found in wp-content/plugins/advanced-cf7-db/admin/class/PHPExcel/Writer/OpenDocument/Mimetype.php:37
    • > PHP Fatal error
      Uncaught Error: Class 'PHPExcel_Worksheet_BaseDrawing' not found in wp-content/plugins/advanced-cf7-db/admin/class/PHPExcel/Worksheet/MemoryDrawing.php:36

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 93% from 29 tests

readme.txt 88% from 16 tests

The readme.txt file is important because it is parsed by WordPress.org for the public listing of your plugin
Attributes that require attention:
  • Screenshots: Screenshot #6 (Developer Support) image missing
  • Tags: Please delete some tags, you are using 15 tag instead of maximum 10
Please take inspiration from this readme.txt

advanced-cf7-db/advanced-cf7-db.php Passed 13 tests

The main PHP file in "Advanced Contact form 7 DB" ver. 1.8.7 adds more information about the plugin and also serves as the entry point for this plugin
135 characters long description:
Save all contact form 7 submitted data to the database, View, Export, ordering, Change field labels, Import data using CSV very easily.

Code Analysis 95% from 3 tests

File types Passed 1 test

🔸 Test weight: 35 | An overview of files in this plugin; executable files are not allowed
No dangerous file extensions were detected63,820 lines of code in 241 files:
LanguageFilesBlank linesComment linesLines of code
PHP22812,65238,20557,693
CSS555523,318
JavaScript32561562,150
SVG500659

PHP code 0% from 2 tests

Analyzing logical lines of code, cyclomatic complexity, and other code metrics
The following items need your attention
  • Class cyclomatic complexity has to be reduced to less than 1000 (currently 1,177)
  • Method cyclomatic complexity should be reduced to less than 100 (currently 387)
Cyclomatic complexity
Average complexity per logical line of code0.39
Average class complexity51.45
▷ Minimum class complexity1.00
▷ Maximum class complexity1,177.00
Average method complexity4.71
▷ Minimum method complexity1.00
▷ Maximum method complexity387.00
Code structure
Namespaces0
Interfaces7
Traits0
Classes205
▷ Abstract classes94.39%
▷ Concrete classes19695.61%
▷ Final classes00.00%
Methods2,904
▷ Static methods62621.56%
▷ Public methods2,33980.54%
▷ Protected methods742.55%
▷ Private methods49116.91%
Functions43
▷ Named functions43100.00%
▷ Anonymous functions00.00%
Constants819
▷ Global constants12615.38%
▷ Class constants69384.62%
▷ Public constants693100.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 images were found in this plugin