Multiple vulnerabilities have been discovered in OrderSys, which can be exploited by malicious people to cross-site scripting and SQL injection attacks.

1) Input passed via the "where_clause" parameter to interface_creator/index.php, interface_creator/index_short.php, and interface_creator/index_long.php (when "table_name" is set to "vendor" and "function" is set to "search") is not properly sanitised before being used in a SQL query. This can be exploited to manipulate SQL queries by injecting arbitrary SQL code.

2) Input passed to multiple scripts is not properly sanitised before being returned to the user. This can be exploited to execute arbitrary HTML and script code in a user's browser session in context of an affected site.

List of affected scripts and parameters:
http://[host]/ordering/items.php?page
http://[host]/ordering/vendors.php
http://[host]/ordering/items.php
http://[host]/ordering/orders.php

3) Input passed via the "where_field" parameter to interface_creator/index.php is not properly sanitised before being used in a SQL query. This can be exploited to manipulate SQL queries by injecting arbitrary SQL code.

The vulnerabilities are confirmed in version 1.6.4. Other versions may also be affected.

Solution
Update to version 1.7.

Provided and/or discovered by
1) muuratsalo
2, 3) Canberk Bolat, Mavituna Security

Changelog
Further details available to Secunia VIM customers

Original Advisory
muuratsalo:
http://archives.neohapsis.com/archives/fulldisclosure/2011-11/att-0071/ordersys.txt

NS-12-007:
http://www.mavitunasecurity.com/xss-and-sql-injection-vulnerabilities-in-ordersys/

Deep Links
Links available to Secunia VIM customers