SQL Chart Builder

Turn Your SQL Queries to Beautiful Dynamic Charts- Pie, Line, Area, Donut, Bar Charts with date/input filters.

v2.3.7.2Guaven LabsUpdated Added 600 installs78% rating
43
Score
12
Errors
39
Warnings
+0
Change

Category Scores

Security4
Repo94
Performance100
Maintainability85

Issues to Review

Prioritized issue groups from the latest Plugin Check scan

51 findings

Security

26

7 issue groups

Maintainability

19

8 issue groups

I18n

5

2 issue groups

Repo Compliance

1

1 issue group

WARNINGMaintainabilityNon-prefixed global variableGlobal variables defined by a theme/plugin should start with the theme/plugin prefix. Found: "$dbpass".7
Category
Maintainability
Occurrences
7
Severity
warning

Sample message

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

WARNINGSecurityNonce verification recommendedProcessing form data without nonce verification.7
Category
Security
Occurrences
7
Severity
warning

Sample message

Processing form data without nonce verification.

WARNINGSecurityInput is not sanitizedDetected usage of a non-sanitized input variable: $_GET[$vrow_arr[0]]6
Category
Security
Occurrences
6
Severity
warning

Sample message

Detected usage of a non-sanitized input variable: $_GET[$vrow_arr[0]]

WARNINGSecurityRequest data is not unslashed$_GET[$vrow_arr[0]] not unslashed before sanitization. Use wp_unslash() or similar6
Category
Security
Occurrences
6
Severity
warning

Sample message

$_GET[$vrow_arr[0]] not unslashed before sanitization. Use wp_unslash() or similar

WARNINGMaintainabilityNon-prefixed functionFunctions declared in the global namespace by a theme/plugin should start with the theme/plugin prefix. Found: "gvn_chart_check_sql_query".5
Category
Maintainability
Occurrences
5
Severity
warning

Sample message

Functions declared in the global namespace by a theme/plugin should start with the theme/plugin prefix. Found: "gvn_chart_check_sql_query".

ERRORI18nText Domain MismatchMismatched text domain. Expected 'sql-chart-builder' but got 'guaven_sqlcharts'.4
Category
I18n
Occurrences
4
Severity
error

Sample message

Mismatched text domain. Expected 'sql-chart-builder' but got 'guaven_sqlcharts'.

ERRORSecuritySQL query is not preparedUse placeholders and $wpdb->prepare(); found $i3
Category
Security
Occurrences
3
Severity
error

Sample message

Use placeholders and $wpdb->prepare(); found $i

WARNINGMaintainabilityerror log error logerror_log() found. Debug code should not normally be used in production.2
Category
Maintainability
Occurrences
2
Severity
warning

Sample message

error_log() found. Debug code should not normally be used in production.

WARNINGSecurityInput is not validatedDetected usage of a possibly undefined superglobal array index: $_POST['guaven_sqlcharts_code']. Check that the array index exists before using it.2
Category
Security
Occurrences
2
Severity
warning

Sample message

Detected usage of a possibly undefined superglobal array index: $_POST['guaven_sqlcharts_code']. Check that the array index exists before using it.

ERRORSecurityDatabase parameter is not escapedUnescaped parameter $sql_split[$i] used in $wpdb->get_results()\n$sql_split[$i] used without escaping.1
Category
Security
Occurrences
1
Severity
error

Sample message

Unescaped parameter $sql_split[$i] used in $wpdb->get_results()\n$sql_split[$i] used without escaping.

Show 8 more
WARNINGMaintainabilityDirect Query1
Category
Maintainability
Occurrences
1
Severity
warning

Sample message

Use of a direct database call is discouraged.

WARNINGMaintainabilityNo Caching1
Category
Maintainability
Occurrences
1
Severity
warning

Sample message

Direct database call without caching detected. Consider using wp_cache_get() / wp_cache_set() or wp_cache_delete().

WARNINGMaintainabilityNon-prefixed constant1
Category
Maintainability
Occurrences
1
Severity
warning

Sample message

Global constants defined by a theme/plugin should start with the theme/plugin prefix. Found: "GVNSQLCHARTS_VERSION".

WARNINGMaintainabilityerror log var dump1
Category
Maintainability
Occurrences
1
Severity
warning

Sample message

var_dump() found. Debug code should not normally be used in production.

ERRORSecurityOutput is not escaped1
Category
Security
Occurrences
1
Severity
error

Sample message

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

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

Sample message

Tested up to: 6.9 < 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.

ERRORMaintainabilitystable tag mismatch1
Category
Maintainability
Occurrences
1
Severity
error

Sample message

Mismatched Stable Tag: 2.3.8 != 2.3.7.2. 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.

ERRORI18ntextdomain invalid format1
Category
I18n
Occurrences
1
Severity
error

Sample message

The "Text Domain" header in the plugin file should only contain lowercase letters, numbers, and hyphens. Found "guaven_sqlcharts".

External Connections

Potential connections found in static code analysis.

9 domains

Outbound calls

24

External assets

0

Incoming endpoints

1

Notable Domains

momentjs.com6 · outbound
dropbox.com5 · outbound
guaven.com5 · outbound
api.billink.nl1 · outbound
chartjs.org1 · outbound

Platform / Reference Domains

w3.org2 · platform/reference
gnu.org1 · platform/reference

External Asset Domains

No external asset domains detected.

Incoming Endpoints

No public endpoints detected.

Admin AJAX endpoints1
wp_ajax_guaven_sqlcharts_onboarding_notice_dismissedauthenticated

wp_ajax

Score History

First score snapshot

v2.3.7.2

43

Latest

Findings
51
Errors
12
Warnings
39
Check
2.0.0

Relationship Map

Author, categories, issues, domains, and nearby plugins.

36 nodes

Related Plugins

Simple Table Manager

400 active installs

99
Run SQL Query

600 active installs

78
UsageDD

1k+ active installs

77
SQL Executioner

2k+ active installs

70