Description
claudiopizzillo PIAF-HMS (PBX-In-A-Flash Hotel Management System; no released versions, latest commit 389d2633441b65ced1c104212cd62be2bfca21e5) contains multiple unauthenticated SQL injection vulnerabilities. The application has no authentication mechanism and passes user-supplied HTTP parameters directly into deprecated mysql_query calls via string concatenation, without sanitization, escaping, or parameterization.
Published: 2026-06-18
Score: 9.3 Critical
EPSS: < 1% Very Low
KEV: No
Impact: n/a
Action: n/a
AI Analysis

Impact

The flaw is a classic SQL injection that allows an attacker to inject arbitrary SQL through user‑supplied HTTP parameters. The application passes these parameters straight into deprecated mysql_query calls without any sanitization or escaping. Successful exploitation can let the attacker execute any SQL statement—reading, modifying, or deleting database contents—and could ultimately lead to full compromise of the application’s data integrity and confidentiality.

Affected Systems

The vulnerable software is the PBX‑In‑A‑Flash Hotel Management System (PIAF‑HMS), developed by claudiopizzillo. No official releases are available; the latest publicly available code resides at commit 389d2633441b65ced1c104212cd62be2bfca21e5. The entries at ec.php line 57 and rooms.php line 16 contain the vulnerable mysql_query calls, and the system provides no authentication, exposing these endpoints to any HTTP client.

Risk and Exploitability

The CVSS score of 9.3 reflects a high‑severity vulnerability, while the EPSS score of < 1 % suggests that, at the time of this analysis, the exploitation probability is low but not negligible. The vulnerability is not listed in CISA’s KEV catalog. Based on the description, it is inferred that attackers can trigger the flaw simply by sending crafted HTTP GET or POST requests to the exposed endpoints; no credentials are required. Because the application accepts unauthenticated requests and concatenates input directly into SQL statements, the attack path is straightforward and could be leveraged if the system is exposed to the internet.

Generated by OpenCVE AI on August 10, 2026 at 23:43 UTC.

Remediation

No vendor fix or workaround currently provided.

OpenCVE Recommended Actions

  • Replace all deprecated mysql_* calls with mysqli or PDO prepared statements, ensuring input is properly parameterized or escaped.
  • Implement an authentication layer that requires valid credentials before any endpoint can be accessed, thereby blocking unauthenticated requests from reaching the vulnerable code.
  • Disable the mysql_* extension in the PHP runtime—remove the functions from php.ini or add them to php_disable_functions—to prevent any accidental use of legacy query functions.

Generated by OpenCVE AI on August 10, 2026 at 23:43 UTC.

Tracking

Sign in to view the affected projects.

Advisories

No advisories yet.

History

Mon, 10 Aug 2026 12:00:00 +0000

Type Values Removed Values Added
Description claudiopizzillo PIAF-HMS (PBX-In-A-Flash Hotel Management System; no released versions, latest commit 389d2633441b65ced1c104212cd62be2bfca21e5) contains multiple unauthenticated SQL injection vulnerabilities. The application has no authentication mechanism and passes user-supplied HTTP parameters directly into deprecated mysql_query() calls via string concatenation, without sanitization, escaping, or parameterization. Affected sinks include rooms.php (DELETE FROM Rooms WHERE ID = $_GET['ID'], unquoted numeric context), checkuser.php (WHERE Ext = '$_GET["Ext"]'), ec.php (date/extension parameters in a WHERE), checkin.php and wakeup.php ($_POST values into INSERT statements), bills.php ($_POST fields built into a WHERE clause), and rates.php and checkout.php. A remote, unauthenticated attacker can inject arbitrary SQL to read, modify, or delete arbitrary records in the backing database (e.g. rooms.php?ID=1 OR 1=1 deletes all room records). Note: queries run via the legacy mysql_* extension, which does not permit stacked statements. claudiopizzillo PIAF-HMS (PBX-In-A-Flash Hotel Management System; no released versions, latest commit 389d2633441b65ced1c104212cd62be2bfca21e5) contains multiple unauthenticated SQL injection vulnerabilities. The application has no authentication mechanism and passes user-supplied HTTP parameters directly into deprecated mysql_query calls via string concatenation, without sanitization, escaping, or parameterization.
Title PIAF-HMS - Multiple Unauthenticated SQL Injection Vulnerabilities via mysql_query PIAF-HMS multiple unauthenticated SQL injection vulnerabilities via mysql_query

Mon, 10 Aug 2026 11:45:00 +0000

Type Values Removed Values Added
Title PIAF-HMS multiple unauthenticated SQL injection vulnerabilities via mysql_query PIAF-HMS - Multiple Unauthenticated SQL Injection Vulnerabilities via mysql_query

Sun, 21 Jun 2026 09:45:00 +0000

Type Values Removed Values Added
First Time appeared Claudiopizzillo
Claudiopizzillo piaf-hms
Vendors & Products Claudiopizzillo
Claudiopizzillo piaf-hms

Thu, 18 Jun 2026 16:45:00 +0000

Type Values Removed Values Added
Description claudiopizzillo PIAF-HMS (PBX-In-A-Flash Hotel Management System; no released versions, latest commit 389d2633441b65ced1c104212cd62be2bfca21e5) contains multiple unauthenticated SQL injection vulnerabilities. The application has no authentication mechanism and passes user-supplied HTTP parameters directly into deprecated mysql_query() calls via string concatenation, without sanitization, escaping, or parameterization. Affected sinks include rooms.php (DELETE FROM Rooms WHERE ID = $_GET['ID'], unquoted numeric context), checkuser.php (WHERE Ext = '$_GET["Ext"]'), ec.php (date/extension parameters in a WHERE), checkin.php and wakeup.php ($_POST values into INSERT statements), bills.php ($_POST fields built into a WHERE clause), and rates.php and checkout.php. A remote, unauthenticated attacker can inject arbitrary SQL to read, modify, or delete arbitrary records in the backing database (e.g. rooms.php?ID=1 OR 1=1 deletes all room records). Note: queries run via the legacy mysql_* extension, which does not permit stacked statements.
Title PIAF-HMS multiple unauthenticated SQL injection vulnerabilities via mysql_query
Weaknesses CWE-89
References
Metrics cvssV3_1

{'score': 9.8, 'vector': 'CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H'}

cvssV4_0

{'score': 9.3, 'vector': 'CVSS:4.0/AV:N/AC:L/AT:N/PR:N/UI:N/VC:H/VI:H/VA:H/SC:N/SI:N/SA:N'}

ssvc

{'options': {'Automatable': 'yes', 'Exploitation': 'none', 'Technical Impact': 'total'}, 'version': '2.0.3'}


Subscriptions

Claudiopizzillo Piaf-hms
cve-icon MITRE

Status: PUBLISHED

Assigner: TuranSec

Published:

Updated: 2026-08-10T11:44:12.801Z

Reserved: 2026-06-13T16:39:46.122Z

Link: CVE-2026-54419

cve-icon Vulnrichment

Updated: 2026-06-18T12:04:57.185Z

cve-icon NVD

Status : Deferred

Published: 2026-06-18T14:17:31.887

Modified: 2026-08-10T12:17:18.223

Link: CVE-2026-54419

cve-icon Redhat

No data.

cve-icon OpenCVE Enrichment

Updated: 2026-08-10T23:45:04Z

Weaknesses
  • CWE-89

    Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')