itsourcecode Apartment Management System SQL Injection Vulnerability in Admin Settings Handler

A SQL injection vulnerability has been identified in the itsourcecode Apartment Management System version 1.0. The issue resides in the Setting Handler component, specifically within the '/setting/admin.php' file. The vulnerability is triggered by manipulating the 'MULTIPART ddlBranch' parameter, allowing attackers to inject malicious SQL queries. This exploitation can be performed remotely, without any authentication requirements.

Impact

Exploitation of this vulnerability allows unauthorized database access, manipulation of database contents, and potential disruption of service.

Reproduction

To reproduce this vulnerability, send a POST request to '/setting/admin.php' with the 'ddlBranch' parameter crafted to include a SQL injection payload. The injection can be time-based, using a payload that exploits SQL query execution timing to confirm the injection's success.

Remediation

It is recommended to use prepared statements and parameter binding to prevent SQL injection, validate and filter user input, minimize database user permissions, and conduct regular security audits.