SourceCodester Hotel Management System 1.0 contains a SQL injection vulnerability in the /index.php/reservation/check endpoint. Manipulating the room_type argument allows an attacker to inject SQL commands, potentially compromising the backend database. The vulnerability is remotely exploitable without requiring privileges or user interaction. The CVSS 4.0 base score is 6.9, indicating medium severity. No official fix or patch has been published, and the vendor has not provided remediation details. Exploit code has been disclosed publicly, increasing the risk of exploitation.

Successful exploitation of this vulnerability could allow an attacker to execute arbitrary SQL commands on the backend database, potentially leading to unauthorized data access or modification. The impact is rated medium based on the CVSS score and the lack of required privileges or user interaction. However, the exact scope of data exposure or system compromise is not detailed in the available information.

Patch status is not yet confirmed — check the vendor advisory for current remediation guidance. Until an official fix is released, users should consider implementing web application firewall (WAF) rules to detect and block SQL injection attempts targeting the room_type parameter. Additionally, reviewing and hardening input validation and parameter handling in the affected endpoint is recommended as a temporary mitigation.