{"dataType": "CVE_RECORD", "dataVersion": "5.2", "cveMetadata": {"cveId": "CVE-2026-54419", "assignerOrgId": "309f9ea4-e3e9-4c6c-b79d-e8eb01244f2c", "state": "PUBLISHED", "assignerShortName": "TuranSec", "dateReserved": "2026-06-13T16:39:46.122Z", "datePublished": "2026-06-18T10:21:47.135Z", "dateUpdated": "2026-06-18T12:05:05.175Z"}, "containers": {"cna": {"providerMetadata": {"orgId": "309f9ea4-e3e9-4c6c-b79d-e8eb01244f2c", "shortName": "TuranSec", "dateUpdated": "2026-06-18T10:21:47.135Z"}, "title": "PIAF-HMS multiple unauthenticated SQL injection vulnerabilities via mysql_query", "problemTypes": [{"descriptions": [{"lang": "en", "cweId": "CWE-89", "description": "CWE-89 Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')", "type": "CWE"}]}], "affected": [{"vendor": "claudiopizzillo", "product": "PIAF-HMS", "collectionURL": "https://github.com/claudiopizzillo/PIAF-HMS", "repo": "https://github.com/claudiopizzillo/PIAF-HMS", "programFiles": ["checkin.php", "checkout.php", "rates.php", "rooms.php", "bills.php", "wakeup.php", "checkuser.php", "ec.php"], "defaultStatus": "affected"}], "descriptions": [{"lang": "en", "value": "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.", "supportingMedia": [{"type": "text/html", "base64": false, "value": "<p>claudiopizzillo PIAF-HMS (PBX-In-A-Flash Hotel Management System; no released versions, latest commit <code>389d2633441b65ced1c104212cd62be2bfca21e5</code>) contains multiple unauthenticated SQL injection vulnerabilities. The application has no authentication mechanism and passes user-supplied HTTP parameters directly into deprecated <code>mysql_query()</code> calls via string concatenation, without sanitization, escaping, or parameterization. Affected sinks include <code>rooms.php</code> (<code>DELETE FROM Rooms WHERE ID = $_GET['ID']</code>, unquoted numeric context), <code>checkuser.php</code> (<code>WHERE Ext = '$_GET[\"Ext\"]'</code>), <code>ec.php</code> (date/extension parameters in a <code>WHERE</code>), <code>checkin.php</code> and <code>wakeup.php</code> (<code>$_POST</code> values into <code>INSERT</code> statements), <code>bills.php</code> (<code>$_POST</code> fields built into a <code>WHERE</code> clause), and <code>rates.php</code> and <code>checkout.php</code>. A remote, unauthenticated attacker can inject arbitrary SQL to read, modify, or delete arbitrary records in the backing database (e.g. <code>rooms.php?ID=1 OR 1=1</code> deletes all room records). Note: queries run via the legacy mysql_* extension, which does not permit stacked statements.</p>"}]}], "references": [{"url": "https://github.com/claudiopizzillo/PIAF-HMS/blob/389d2633441b65ced1c104212cd62be2bfca21e5/rooms.php#L16", "name": "Vulnerable sink: rooms.php DELETE WHERE ID = $_GET['ID']", "tags": ["technical-description"]}, {"url": "https://github.com/claudiopizzillo/PIAF-HMS/blob/389d2633441b65ced1c104212cd62be2bfca21e5/ec.php#L57", "name": "Vulnerable sink: ec.php WHERE with $_GET parameters", "tags": ["technical-description"]}, {"url": "https://github.com/claudiopizzillo/PIAF-HMS", "tags": ["product"]}], "metrics": [{"format": "CVSS", "scenarios": [{"lang": "en", "value": "GENERAL"}], "cvssV3_1": {"version": "3.1", "attackVector": "NETWORK", "attackComplexity": "LOW", "privilegesRequired": "NONE", "userInteraction": "NONE", "scope": "UNCHANGED", "confidentialityImpact": "HIGH", "integrityImpact": "HIGH", "availabilityImpact": "HIGH", "baseSeverity": "CRITICAL", "baseScore": 9.8, "vectorString": "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H"}}, {"format": "CVSS", "scenarios": [{"lang": "en", "value": "GENERAL"}], "cvssV4_0": {"attackVector": "NETWORK", "attackComplexity": "LOW", "attackRequirements": "NONE", "privilegesRequired": "NONE", "userInteraction": "NONE", "vulnConfidentialityImpact": "HIGH", "subConfidentialityImpact": "NONE", "vulnIntegrityImpact": "HIGH", "subIntegrityImpact": "NONE", "vulnAvailabilityImpact": "HIGH", "subAvailabilityImpact": "NONE", "exploitMaturity": "NOT_DEFINED", "Safety": "NOT_DEFINED", "Automatable": "NOT_DEFINED", "Recovery": "NOT_DEFINED", "valueDensity": "NOT_DEFINED", "vulnerabilityResponseEffort": "NOT_DEFINED", "providerUrgency": "NOT_DEFINED", "version": "4.0", "baseSeverity": "CRITICAL", "baseScore": 9.3, "vectorString": "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"}}], "credits": [{"lang": "en", "value": "Eshmirzayev Abbos", "type": "finder"}], "source": {"discovery": "EXTERNAL"}}, "adp": [{"metrics": [{"other": {"type": "ssvc", "content": {"timestamp": "2026-06-18T12:01:03.819166Z", "id": "CVE-2026-54419", "options": [{"Exploitation": "none"}, {"Automatable": "yes"}, {"Technical Impact": "total"}], "role": "CISA Coordinator", "version": "2.0.3"}}}], "title": "CISA ADP Vulnrichment", "providerMetadata": {"orgId": "134c704f-9b21-4f2e-91b3-4a467353bcc0", "shortName": "CISA-ADP", "dateUpdated": "2026-06-18T12:05:05.175Z"}}]}}

{"dataType": "CVE_RECORD", "containers": {"adp": [{"title": "CISA ADP Vulnrichment", "metrics": [{"other": {"type": "ssvc", "content": {"id": "CVE-2026-54419", "role": "CISA Coordinator", "options": [{"Exploitation": "none"}, {"Automatable": "yes"}, {"Technical Impact": "total"}], "version": "2.0.3", "timestamp": "2026-06-18T12:01:03.819166Z"}}}], "providerMetadata": {"orgId": "134c704f-9b21-4f2e-91b3-4a467353bcc0", "shortName": "CISA-ADP", "dateUpdated": "2026-06-18T12:04:57.185Z"}}], "cna": {"title": "PIAF-HMS multiple unauthenticated SQL injection vulnerabilities via mysql_query", "source": {"discovery": "EXTERNAL"}, "credits": [{"lang": "en", "type": "finder", "value": "Eshmirzayev Abbos"}], "metrics": [{"format": "CVSS", "cvssV3_1": {"scope": "UNCHANGED", "version": "3.1", "baseScore": 9.8, "attackVector": "NETWORK", "baseSeverity": "CRITICAL", "vectorString": "CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H", "integrityImpact": "HIGH", "userInteraction": "NONE", "attackComplexity": "LOW", "availabilityImpact": "HIGH", "privilegesRequired": "NONE", "confidentialityImpact": "HIGH"}, "scenarios": [{"lang": "en", "value": "GENERAL"}]}, {"format": "CVSS", "cvssV4_0": {"Safety": "NOT_DEFINED", "version": "4.0", "Recovery": "NOT_DEFINED", "baseScore": 9.3, "Automatable": "NOT_DEFINED", "attackVector": "NETWORK", "baseSeverity": "CRITICAL", "valueDensity": "NOT_DEFINED", "vectorString": "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", "exploitMaturity": "NOT_DEFINED", "providerUrgency": "NOT_DEFINED", "userInteraction": "NONE", "attackComplexity": "LOW", "attackRequirements": "NONE", "privilegesRequired": "NONE", "subIntegrityImpact": "NONE", "vulnIntegrityImpact": "HIGH", "subAvailabilityImpact": "NONE", "vulnAvailabilityImpact": "HIGH", "subConfidentialityImpact": "NONE", "vulnConfidentialityImpact": "HIGH", "vulnerabilityResponseEffort": "NOT_DEFINED"}, "scenarios": [{"lang": "en", "value": "GENERAL"}]}], "affected": [{"repo": "https://github.com/claudiopizzillo/PIAF-HMS", "vendor": "claudiopizzillo", "product": "PIAF-HMS", "programFiles": ["checkin.php", "checkout.php", "rates.php", "rooms.php", "bills.php", "wakeup.php", "checkuser.php", "ec.php"], "collectionURL": "https://github.com/claudiopizzillo/PIAF-HMS", "defaultStatus": "affected"}], "references": [{"url": "https://github.com/claudiopizzillo/PIAF-HMS/blob/389d2633441b65ced1c104212cd62be2bfca21e5/rooms.php#L16", "name": "Vulnerable sink: rooms.php DELETE WHERE ID = $_GET['ID']", "tags": ["technical-description"]}, {"url": "https://github.com/claudiopizzillo/PIAF-HMS/blob/389d2633441b65ced1c104212cd62be2bfca21e5/ec.php#L57", "name": "Vulnerable sink: ec.php WHERE with $_GET parameters", "tags": ["technical-description"]}, {"url": "https://github.com/claudiopizzillo/PIAF-HMS", "tags": ["product"]}], "descriptions": [{"lang": "en", "value": "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.", "supportingMedia": [{"type": "text/html", "value": "<p>claudiopizzillo PIAF-HMS (PBX-In-A-Flash Hotel Management System; no released versions, latest commit <code>389d2633441b65ced1c104212cd62be2bfca21e5</code>) contains multiple unauthenticated SQL injection vulnerabilities. The application has no authentication mechanism and passes user-supplied HTTP parameters directly into deprecated <code>mysql_query()</code> calls via string concatenation, without sanitization, escaping, or parameterization. Affected sinks include <code>rooms.php</code> (<code>DELETE FROM Rooms WHERE ID = $_GET['ID']</code>, unquoted numeric context), <code>checkuser.php</code> (<code>WHERE Ext = '$_GET[\"Ext\"]'</code>), <code>ec.php</code> (date/extension parameters in a <code>WHERE</code>), <code>checkin.php</code> and <code>wakeup.php</code> (<code>$_POST</code> values into <code>INSERT</code> statements), <code>bills.php</code> (<code>$_POST</code> fields built into a <code>WHERE</code> clause), and <code>rates.php</code> and <code>checkout.php</code>. A remote, unauthenticated attacker can inject arbitrary SQL to read, modify, or delete arbitrary records in the backing database (e.g. <code>rooms.php?ID=1 OR 1=1</code> deletes all room records). Note: queries run via the legacy mysql_* extension, which does not permit stacked statements.</p>", "base64": false}]}], "problemTypes": [{"descriptions": [{"lang": "en", "type": "CWE", "cweId": "CWE-89", "description": "CWE-89 Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')"}]}], "providerMetadata": {"orgId": "309f9ea4-e3e9-4c6c-b79d-e8eb01244f2c", "shortName": "TuranSec", "dateUpdated": "2026-06-18T10:21:47.135Z"}}}, "cveMetadata": {"cveId": "CVE-2026-54419", "state": "PUBLISHED", "dateUpdated": "2026-06-18T12:05:05.175Z", "dateReserved": "2026-06-13T16:39:46.122Z", "assignerOrgId": "309f9ea4-e3e9-4c6c-b79d-e8eb01244f2c", "datePublished": "2026-06-18T10:21:47.135Z", "assignerShortName": "TuranSec"}, "dataVersion": "5.2"}

{}

{}

{"affected": [{"configurations": [{"platform": null, "status": "affected", "versions": {"scheme": "code_commit", "value": "389d2633441b65ced1c104212cd62be2bfca21e5"}}], "enrichment": {"confidence": 100.0, "confidence_source": "cna", "scores": [{"score": 100.0, "source": "cna"}]}, "original": {"product": "PIAF-HMS", "source": "cna", "vendor": "claudiopizzillo"}, "product": "piaf-hms", "vendor": "claudiopizzillo"}], "created": "2026-06-18T20:30:05.277440+00:00", "updated": "2026-06-20T22:56:21.706742+00:00", "vendors": ["claudiopizzillo", "claudiopizzillo$PRODUCT$piaf-hms"]}