SQL Injection in CLANSPHERE

Vulnerability ID: HTB22694
Reference: http://www.htbridge.ch/advisory/sql_injection_in_clansphere.html
Product: CLANSPHERE
Vendor: csphere.eu ( http://www.csphere.eu/ )
Vulnerable Version: 2010.0 Final
Vendor Notification: 02 November 2010
Vulnerability Type: SQL Injection
Status: Fixed by Vendor
Risk level: High
Credit: High-Tech Bridge SA - Ethical Hacking & Penetration Testing (http://www.htbridge.ch/)

Vulnerability Details:
The vulnerability exists due to failure in the "replays" module to properly sanitize user-supplied input in "where" variable.
Attacker can alter queries to the application SQL database, execute arbitrary queries to the database, compromise the application, access or modify sensitive data, or exploit various vulnerabilities in the underlying SQL database.

Attacker can use browser to exploit this vulnerability. The following PoC is available:

http://[host]/index.php?mod=replays&action=list&where=123%27%20union%20select%201,2,@@version,4,5%20–%20#

Solution: Upgrade to the most recent version