[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/