itsourcecode Apartment Management System SQL Injection Vulnerability in Member Type Setup File

A SQL injection vulnerability has been identified in the itsourcecode Apartment Management System version 1.0. The issue resides in the file '/setting/member_type_setup.php', where the 'MULTIPART txtMemberType' parameter is manipulated, allowing attackers to inject malicious SQL queries. This vulnerability can be exploited remotely, without any authentication, potentially leading to unauthorized database access, data modification or deletion, and exposure of sensitive information.

Impact

Exploitation of this vulnerability allows for SQL injection, which could be used to access, modify, or delete database information. Additionally, it could lead to unauthorized access to sensitive data and disrupt normal service operations.

Reproduction

The vulnerability can be reproduced by sending a POST request to '/setting/member_type_setup.php' with the 'txtMemberType' parameter. The injection point can be exploited using a payload that takes advantage of time-based blind SQL injection, such as one that uses the SQL 'SLEEP' function to create a delay, indicating successful exploitation.

Remediation

To address this vulnerability, it is recommended to implement prepared statements and parameter binding to prevent SQL injection. Additionally, user input should be validated and filtered to ensure it meets expected formats. Minimizing database user permissions and conducting regular security audits can also help enhance overall security.