Search criteria

1 vulnerability by claudiopizzillo

CVE-2026-54419 (GCVE-0-2026-54419)

Vulnerability from cvelistv5 – Published: 2026-06-18 10:21 – Updated: 2026-06-18 12:05
VLAI?
Title
PIAF-HMS multiple unauthenticated SQL injection vulnerabilities via mysql_query
Summary
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.
CWE
  • CWE-89 - Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')
Assigner
Impacted products
Credits
Eshmirzayev Abbos
Show details on NVD website

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