[MajorSecurity Advisory #33]ShopSystems - SQL Injection Issue

[admin () majorsecurity de]

[MajorSecurity Advisory #33]ShopSystems - SQL Injection Issue

Details
=======
Product: ShopSystems
Affected Version: <= 4.0
Immune Version: none
Security-Risk: moderated
Remote-Exploit: yes
Vendor-URL: http://www.shopsystems.biz
Vendor-Status: informed
Advisory-Status: published

Credits
============
Discovered by: David Vieira-Kurz
http://www.majorsecurity.de

Original Advisory:
============
http://www.majorsecurity.de/index_2.php?major_rls=major_rls33

Introduction
============
ShopSystems is a web shop system.

More Details
============
SQL injection:
Input passed directly to the "sessid" parameter in "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.

Fix
===
none known

Solution
=============
Edit the source code to ensure that input is properly sanitised.
You should work with the "intval()" and "mysql_real_escape_string()" or "addslashes()" php-function to ensure that sql 
statements
can't be delivered over the "get" variables. 

Example:
$pass = htmlentities($_POST['pass']);
$test = htmlspecialchars($_GET('test'));
$id = intval($_POST['id']);
?>

History/Timeline
================
03.11.2006 discovery of the vulnerability
04.11.2006 additional tests with other versions
04.11.2006 contacted the vendor
11.11.2006 advisory is written
11.11.2006 advisory released

MajorSecurity
=======
MajorSecurity is a German penetration testing and security research project
which consists of only one person at the present time.
I am looking for a sponsor.
You can find more Information on the MajorSecurity Project at
http://www.majorsecurity.de/