SQL Executioner

Execute arbitrary SQL queries against your WordPress database from the Admin.

v1.4Justin WattUpdated Added 2k+ installs92% rating
70
Score
18
Errors
17
Warnings
+0
Change

Category Scores

Security60
Repo86
Performance100
Maintainability71

Issues to Review

Prioritized issue groups from the latest Plugin Check scan

35 findings

Maintainability

25

13 issue groups

Security

7

4 issue groups

Repo Compliance

3

3 issue groups

WARNINGMaintainabilityNon Prefixed Variable FoundGlobal variables defined by a theme/plugin should start with the theme/plugin prefix. Found: "$link_template".10
Category
Maintainability
Occurrences
10
Severity
warning

Sample message

Global variables defined by a theme/plugin should start with the theme/plugin prefix. Found: "$link_template".

ERRORSecurityOutput Not EscapedAll output should be run through an escaping function (see the Security sections in the WordPress Developer Handbooks), found '$links'.3
Category
Security
Occurrences
3
Severity
error

Sample message

All output should be run through an escaping function (see the Security sections in the WordPress Developer Handbooks), found '$links'.

ERRORMaintainabilitymissing direct file access protectionPHP file should prevent direct access. Add a check like: if ( ! defined( 'ABSPATH' ) ) exit;3
Category
Maintainability
Occurrences
3
Severity
error

Sample message

PHP file should prevent direct access. Add a check like: if ( ! defined( 'ABSPATH' ) ) exit;

ERRORMaintainabilitymysql mysqli queryAccessing the database directly should be avoided. Please use the $wpdb object and associated functions instead. Found: mysqli_query.2
Category
Maintainability
Occurrences
2
Severity
error

Sample message

Accessing the database directly should be avoided. Please use the $wpdb object and associated functions instead. Found: mysqli_query.

WARNINGSecurityMissingProcessing form data without nonce verification.2
Category
Security
Occurrences
2
Severity
warning

Sample message

Processing form data without nonce verification.

ERRORMaintainabilitymysql mysqli affected rowsAccessing the database directly should be avoided. Please use the $wpdb object and associated functions instead. Found: mysqli_affected_rows.1
Category
Maintainability
Occurrences
1
Severity
error

Sample message

Accessing the database directly should be avoided. Please use the $wpdb object and associated functions instead. Found: mysqli_affected_rows.

ERRORMaintainabilitymysql mysqli connectAccessing the database directly should be avoided. Please use the $wpdb object and associated functions instead. Found: mysqli_connect.1
Category
Maintainability
Occurrences
1
Severity
error

Sample message

Accessing the database directly should be avoided. Please use the $wpdb object and associated functions instead. Found: mysqli_connect.

ERRORMaintainabilitymysql mysqli errorAccessing the database directly should be avoided. Please use the $wpdb object and associated functions instead. Found: mysqli_error.1
Category
Maintainability
Occurrences
1
Severity
error

Sample message

Accessing the database directly should be avoided. Please use the $wpdb object and associated functions instead. Found: mysqli_error.

ERRORMaintainabilitymysql mysqli fetch arrayAccessing the database directly should be avoided. Please use the $wpdb object and associated functions instead. Found: mysqli_fetch_array.1
Category
Maintainability
Occurrences
1
Severity
error

Sample message

Accessing the database directly should be avoided. Please use the $wpdb object and associated functions instead. Found: mysqli_fetch_array.

ERRORMaintainabilitymysql mysqli fetch assocAccessing the database directly should be avoided. Please use the $wpdb object and associated functions instead. Found: mysqli_fetch_assoc.1
Category
Maintainability
Occurrences
1
Severity
error

Sample message

Accessing the database directly should be avoided. Please use the $wpdb object and associated functions instead. Found: mysqli_fetch_assoc.

Show 10 more
WARNINGSecurityInput Not Sanitized1
Category
Security
Occurrences
1
Severity
warning

Sample message

Detected usage of a non-sanitized input variable: $_POST['sql']

WARNINGSecurityMissing Unslash1
Category
Security
Occurrences
1
Severity
warning

Sample message

$_POST['sql'] not unslashed before sanitization. Use wp_unslash() or similar

ERRORMaintainabilityfile system operations fclose1
Category
Maintainability
Occurrences
1
Severity
error

Sample message

File operations should use WP_Filesystem methods instead of direct PHP filesystem calls. Found: fclose().

ERRORMaintainabilityfile system operations fopen1
Category
Maintainability
Occurrences
1
Severity
error

Sample message

File operations should use WP_Filesystem methods instead of direct PHP filesystem calls. Found: fopen().

WARNINGMaintainabilityscreen icon Found1
Category
Maintainability
Occurrences
1
Severity
warning

Sample message

screen_icon() has been deprecated since WordPress version 3.8.0.

WARNINGMaintainabilityNot In Footer1
Category
Maintainability
Occurrences
1
Severity
warning

Sample message

In footer ($in_footer) is not set explicitly wp_register_script; It is recommended to load scripts in the footer. Please set this value to `true` to load it in the footer, or explicitly `false` if it should be loaded in the header.

ERRORRepo Complianceoutdated tested upto header1
Category
Repo Compliance
Occurrences
1
Severity
error

Sample message

Tested up to: 4.6 < 7.0. The "Tested up to" value in your plugin is not set to the current version of WordPress. This means your plugin will not show up in searches, as we require plugins to be compatible and documented as tested up to the most recent version of WordPress.

ERRORRepo Complianceplugin header no license1
Category
Repo Compliance
Occurrences
1
Severity
error

Sample message

Missing "License" in Plugin Header. Please update your Plugin Header with a valid GPLv2 (or later) compatible license.

WARNINGRepo Compliancereadme parser warnings too many tags1
Category
Repo Compliance
Occurrences
1
Severity
warning

Sample message

One or more tags were ignored. Please limit your plugin to 5 tags.

ERRORMaintainabilitytrunk stable tag1
Category
Maintainability
Occurrences
1
Severity
error

Sample message

Incorrect Stable Tag. It's recommended not to use "Stable Tag: trunk". Your Stable Tag is meant to be the stable version of your plugin and it needs to be exactly the same with the Version in your main plugin file's header. Any mismatch can prevent users from downloading the correct plugin files from WordPress.org.

Score History

First score snapshot

v1.4

70

Latest

Findings
35
Errors
18
Warnings
17
Check
2.0.0

Related Plugins

Loops & Logic

2k+ active installs

81
Debug This

2k+ active installs

52
WP-ServerInfo

10k+ active installs

38
Database Backup for WordPress

70k+ active installs

35